User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 391,964 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,116 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting

SQL String question

Join Date: Jan 2008
Posts: 4
Reputation: harry78 is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
harry78 harry78 is offline Offline
Newbie Poster

Re: SQL String question

  #3  
Jan 18th, 2008
Hello.
You're right about the AND SOURCE IN syntax, although it's funny because it works if I stop the query there. I modified it and now it looks AND InfoDetails.SOURCE IN.

The problem still remains at the array. I put the coode in and it gives me an error

"Microsoft VBScript runtime error '800a01a8'

Object required: 'Sgrau'

processquery.asp, line 31 "
, line 31 being strculturaarr = strcultura.split(",")

If I select more than Sgrau in the form, for example Sgrau and Sfloare the error becomes :
Microsoft VBScript runtime error '800a01a8'

Object required: 'Sgrau, Sfloare'

processquery.asp, line 31

If I add Srapita to the selection the error becomes :

Microsoft VBScript runtime error '800a01a8'

Object required: 'Sgrau, Sfloare, Srap'

processquery.asp, line 31


I can't figure out why it says that. It is as if there is nothing in the array. I tried doing a response.write for each item in strculturaarr but it gives the same error.
Any clues?
Thanks.
Reply With Quote  
All times are GMT -4. The time now is 9:12 am.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC