I've spot the error after a break. thanks pal up there.



-----Original Message-----

From: Dillon [mailto:bacsr@c...]

Sent: Sunday, April 22, 2001 3:54 PM

To: ASP Databases

Subject: [asp_databases] help ! SQL syntax error





Hello,

I am trying to spot the code below, and I still unable to figure out for the

whole day.

Can someone please advise?  It would be greatly appreciated.



Here are the error message showed:

Syntax error (missing operator) in query expression 'where Postion = 'System

Analyst''.



and the SQL statement:

SQL = "Select JoborderID from Joborder where " &_

      "where Postion = '" & Session("Choice1") & "';"



Dillon.