Error 80040e14

[Ragol1]

Can somebody please tell we what is wrong with this
Im getting error

Microsoft JET Database Engine error '80040e14'

Extra ) in query expression 'ID = )'.

/update/edit.asp, line 20

<---------------------------->
mySQL = &quot;SELECT Membersragol.* FROM Membersragol WHERE (ID = &quot; & ID & &quot&quot;
Set RS = Con.Execute( mySQL )

 

[BobLoblaws]

mySQL = &quot;SELECT * FROM Membersragol WHERE ID = &quot; & ID & &quot;;&quot;

Try that.

 

[Ragol1]

Now I get
Microsoft JET Database Engine error '80040e14'

Syntax error (missing operator) in query expression 'ID ='.

/update/edit.asp, line 20

 

[BobLoblaws]

It sounds like your SQL statement has a blank ID in it.
Before you execute the SQL, check for an ID.

If Len(Id) < 1 Then
'Did not get ID.
End If

You can also comment out the execute statement and out
response.write(mySQL)

That will show you if your sql statement is building properly.