P Mistry
|
Posted: 09/12/2002, 3:24 PM |
|
sql = "SELECT case_id, user_email FROM support_cases WHERE user_email = " &
ThisEmail & ""
cn.execute sql
I get a browser error...
Error Type:
Microsoft JET Database Engine (0x80040E14)
Syntax error (missing operator) in query expression 'user_email =
pm@raksoft.co.uk'.
/support/usrCasesGrid.asp, line 463
|
|
|
DonB
|
Posted: 09/12/2002, 4:31 PM |
|
Needs quotes around the string.
"P Mistry" <pm@raksoft.co.uk> wrote in message
news:alr46a$kj1$1@news.codecharge.com...
> sql = "SELECT case_id, user_email FROM support_cases WHERE user_email = "
&
> ThisEmail & ""
> cn.execute sql
>
> I get a browser error...
>
> Error Type:
> Microsoft JET Database Engine (0x80040E14)
> Syntax error (missing operator) in query expression 'user_email =
>pm@raksoft.co.uk'.
> /support/usrCasesGrid.asp, line 463
>
>
>
|
|
|
|