March 10, 2004 at 12:38 am
Hi,
I've developed an ASP (vbscript) site on my home machine using locally installed copys of IIS and SQL Server 2000 Developers version. The site has search criteria that the user can input, and it basically works fine.
A friend of mine offers hosting of sites and I sent the pages and they all work fine.
I then detached my local copy of the DB, gave hime the copy, and he attached it on his server machine.
I changed my connection string and all seemed fine, but I keep getting this error message:
"Incorrect syntax near the keyword 'AND'."
In the asp page, the line it says the error occurs on is:
"set rs=rs.NextRecordSet"
This line is used becasue mysql query calls a stored procedure that returns 2 record sets inside it. I've used what i need from the first record set before this line and am using this line to get to the record set with the actual search criteria results.
Apparently, accourding to collegues this sort of error message happens often and isn't always code related, but perhaps is some sort of server configuration problem.
Any help would be much appreciated,
Thanks,
Richard.
March 12, 2004 at 7:06 am
The problem really might be incorrect syntax near the AND if the connections on your hosted site wind up using different ANSI connection options than when you ran all this on your box. For instance if your code says AND mycol="value" it might not like the double quotes (I think this would give a different error though). Just a thought.
I've seen code that could not handle multiple result sets, but this first syntax error implies that is not problem in this case.
Might help a lot to post code of your proc here.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply