new at asp - need help with string query
zaxdada | Posted 6:19pm 9. August 2009 Server Time |
I've found answers to most of my problems, but I can't find any example of how to get proper syntax on a sql string when using more than one variable or command (WHERE and ORDER BY)
Here's an example:
strSQL = "SELECT * FROM products Where products.cat=" & (Request.QueryString)
How do I add ORDER BY or a second variable (Request.Form(field)? May be simple, but it's driving me nuts! All those stupid "'""';""!!
Thanks in advance for the help.
Zaxdada |
