[thelist] ASP using SQL but anoing me like $%&#

Alan Storm gliff at rochester.rr.com
Sun Jan 28 17:07:31 CST 2001


At 09:24 PM 1/28/01 -0000, Elfur Logadottir wrote:
>When I'm trying to display this page I always get the error:
>
>###### THE ERROR #####
>Microsoft VBScript compilation (0x800A0401)
>Expected end of statement
>post.asp, line 27, column 17
>objRS.Open strsql;
>######################

>###### THE ERROR #####
>Missing semicolon (;) at end of SQL statement.
>post.asp, line 26
>######################


I'm more PHP/mySQL than a ASP/SQL server, but it looks like the SQL engine
wants a semicolon at the end of the SQL stament itself. VBScript lines
never end with a semicolon. Try this

###### THE NEW CODE ######
strsql = strsql&";"
objRS.Open
##########################


--
Alan Storm
http://www.alanstorm.com
http://www.gliff.org




More information about the thelist mailing list