Multiple Query in Ultradev

[KMarshall]

I have a form that has three fields

txtAccount (Account Number)
mnuCriteria (either = < or >)
txtInvoiceNo (1 to whatever)

I want the user to be able to key in an account number in the textbox txtAccount, then select from the dropdown menu mnuCriteria either = < or > then key in an invoice number in the textbox txtInvoiceNo.

I cant get dreamweaver to accept my SQL statement as I have two variables next to eachother in the statment as follows

SELECT Account, InvoiceNo
FROM DBA_HLG01_HAJobFile
WHERE Account LIKE 'varAccount' AND InvoiceNo &quot;varCriteria&quot; &quot;varInvoiceNo&quot;

My Variables have been set up as follows

varAccount % Request(&quot;txtAccount&quot
varCriteria % Request(&quot;mnuCriteria&quot
varInvoiceNo % Request(&quot;txtInvoiceNo&quot

I get the message Syntax error (missing operator) in Query Expression Account LIKE '%' AND InvoiceNo [%][%]'

Im very new to this so if its obvious, forgive me. I'd really appreciate the help though!

Thanks for your time.
Kevin Marshall.

 

[Microbe]

Try this:

SELECT Account, InvoiceNo
FROM DBA_HLG01_HAJobFile
WHERE Account LIKE '&quot; & varAccount & &quot;' AND
InvoiceNo &quot; & varCriteria & varInvoiceNo & &quot;;&quot;

The way you were doing it was not getting ASP to interpret the variables, it would be seeing the words literally. Steve Davis
hey.you@hahaha.com.au

http://www.hahaha.com.au

 

[KMarshall]

Excellent, thanks!

 

[Jouster]

I'm new to this also and I as wondering what your &quot;&'s&quot; do in the above SQL statement.

Thanks,