Concerning this topic: http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=16005 I beleive Craig is right. Not with the RecordSet being open in a previous file, but that the set rs = Server.CreateObject("ADODB.RecordSet") on line 43 is not needed in this case. And the Set word needs to be at line 49:
Actually, I'm not sure of the difference, if we need to use the recordset or not. I see many times over in the Snitz code where the set rs = my_Conn.Execute (strSql) is used and sometimes a Recordset is set and used to open the strSql.
Maybe someone can explain to me what the difference is between using the two.
It dosnt really matter to me, I was thinking along the lines that 'set rs = Server.CreateObject("ADODB.RecordSet")' is more compatible I guess with different database types, or does it not matter?
---------- -Eric (da_stimulator) Stims Snitz Test area - Running 3.3.03, 4 beta, and Huw's modified code Need a Mod? Check out the Mod Resource
Forum Locked
Topic Locked
Posted - 09 November 2001 : 01:53:03
