ASP Forum
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


Reply to Post new at asp - need help with string query



Back to Forum Page