ASP Commandment #3: write that SQL

Command #3: use a string variable to build the SQL string so it can be displayed and debugged if there is a problem.

This is bad:
set rstemp=conntemp.execute("select * from publishers where state='NY')

This is good:
mySQL= ""select * "
mySQL= mySQL & "from publishers"
mySQL= mySQL &  "where state='NY'"
response.write mySQL
set rstemp=conntemp.execute(mySQL)
rstemp.close
set rstemp=nothing

Chaz Wish List Tall Tip $5 Grande Tip $20 Venti Tip $39 Tip Jar Thanks 2004 Thanks 2005 Thanks HUGE Tip -love site