sql help needed

[RFH Reseller: HostCan]

Hi guys,

i am trying to write a script:

Error is

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ID='.
/Domains/MyDomain/WWWROOT/admin/dbmod/asp/db_ListSHW.asp, line 50

line 50 is:

<%
LookUp=Session("idLookUp")
Set FIELD = Server.CreateObject("ADODB.Connection")
field.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("..\..\..\..\db\DB938745_ContactForms.mdb"))
DEARSQL = "SELECT * FROM WebForms WHERE  ID= " & LookUp
set WebForms= field.Execute(DEARSQL)
do while not WebForms.eof 
%>

this code was working while ago... I didnt changed anything...

Whats wrong with it

[RFH Reseller: Wise Webs]

<%
LookUp=Session("idLookUp")
Set FIELD = Server.CreateObject("ADODB.Connection")
field.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("..\..\..\..\db\DB938745_ContactForms.mdb"))
DEARSQL = "SELECT * FROM WebForms WHERE  ID= " & LookUp
set WebForms= field.Execute(DEARSQL)
do while not WebForms.eof 
%>

Firstly, I would check that Session("idLookUp") really does have a value, by adding this code at the top of your script.

Response.write("[" & Session("idLookUp") & "]")
Response.End

Then try wrapping the LookUp in quotes for the SQL and see if this works.

DEARSQL = "SELECT * FROM WebForms WHERE  ID= '" & LookUp & "'"

Alastair

[RFH Reseller: HostCan]

Firstly, I would check that Session("idLookUp") really does have a value, by adding this code at the top of your script.

hi, today I worked on it again and the problem is mistake on session as you stated. Eventually I solved the problem thanks for your help