syntax error in query expression

[aonefun]

I am receiving the following error message:

Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'customerid_cus='.

for the following code:

If IsEmpty(Request.Form("company_cus")) Then

rs_company.Source = "SELECT customerid_cus, company_cus FROM customers_cus WHERE customerid_cus= "& Request.QueryString("customerid") &" "

Else

rs_company.Source = "SELECT customerid_cus, company_cus FROM customers_cus WHERE company_cus = '"& Request.Form("company_cus") &"' "

End If

What could the problem be?

[Newsgroup_User · Accepted solution]

Are you sure that you are passing the querystring customerid when the form
company_cus is empty.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"aonefun" <webforumsuser@macromedia.com> wrote in message
news:epmf3n$f3u$1@forums.macromedia.com...
>I am receiving the following error message:
>
> Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator)
> in
> query expression 'customerid_cus='.
>
> for the following code:
>
> If IsEmpty(Request.Form("company_cus")) Then
>
> rs_company.Source = "SELECT customerid_cus, company_cus FROM
> customers_cus
> WHERE customerid_cus= "& Request.QueryString("customerid") &" "
>
> Else
>
> rs_company.Source = "SELECT customerid_cus, company_cus FROM
> customers_cus
> WHERE company_cus = '"& Request.Form("company_cus") &"' "
>
> End If
>
> What could the problem be?
>