Troubleshooting


One of the biggest aids is to do a reponse.write of your SQL Statement BEFORE you execute it (if you are having problems)

EXAMPLE: Do you get a SQL Error on the line
set rstemp=conntemp.execute(SQLstmt)?

Then replace that line with
response.write SQLstmt
set rstemp=conntemp.execute(SQLstmt)


The response.write will greatly aid in troubleshooting.



Come learn HTML or Classic ASP in Honolulu, Hawaii!

HOME | SQL Tutorials | XML Tutorials | OKIWEB | EMAIL ME | ASP Alliance