"Characters found after end of SQL statement"

[Marmalade]

Hey, folks,

I'm trying to run a SQL query against an Access database via an ASP page that uses information entered into a form, and keep getting the following error message:

"Characters found after end of SQL statement"

The code generating the error looks like this:

If  Request.Form(&quot;course&quot;) <> &quot;&quot; Then
SQL = &quot;Select * FROM Items &quot;
SQL = SQL & &quot;WHERE Course_Number LIKE '&quot; & Request.Form(&quot;course&quot;) & &quot;'&quot;
End If
Set objRS = objConn.Execute(SQL)

I've tried playing with the end quotes on the SQL statement a million ways, but can't get it to stop generating this error. Can anyone tell me what I'm doing wrong?

Thanks,

M

 

[Gatorajc]

Try this instead.

course = Request.Form("course&quot

If Request.Form(&quot;course&quot <> &quot;&quot; Then
SQL = &quot;Select * FROM Items &quot;
SQL = SQL & &quot;WHERE Course_Number LIKE '&quot; & course & &quot;'&quot;
End If
Set objRS = objConn.Execute(SQL)

the extra set of quotes may be throwing it off in the SQL string

 

[Marmalade]

Thanks - that cleared it up!

M

 

[codestorm]

Note also that Access typically prefers double quotes around strings. codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>