Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itoleck
Starting Member
2 Posts |
 Posted - 2003-01-14 : 20:33:43
|
| I am using ASP to query/join 3 tables but the ASP page always times out. The page just sits like it's loading forever. I can do the same query in the query analyzer and it works fine. Is there some kind of problem with ADO and SQL joins?here is the code.sql = "SELECT * FROM appjoin"set RS=conntemp.execute(sql)Regards,Chad |
|
|
itoleck
Starting Member
2 Posts |
Posted - 2003-01-14 : 21:58:38
|
| Sorry, nevermind.I found problem in my ASP code. It's so stupid but I will list it here just in case anyone ever has the same problem.Always remember to put your movenext method if you are looping though your recordset. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-14 : 22:04:07
|
A-HA!!!!!!I'll bet you any amount of money I've made that mistake a lot more times than you have!  If you're writing out the contents of the recordset using a loop, do yourself a favor and look into using GetRows or GetString. Search the SQL Team forums for "getrows" or "getstring", and also look for them here:http://www.learnasp.com/You will NEVER go back to MoveNext loops once you start using GetRows/GetString. |
|
|
|
|
|
|
Join/View problem