Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Bug Reports (Closed)
 v3.3(.03) BUG+FIX: pop_mail.asp coding error
 Forum Locked  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 09 November 2001 :  01:53:03  Show Profile
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:
set rs = my_Conn.Execute (strSql)


- David

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 09 November 2001 :  02:00:05  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
what about leaving the set rs = Server.CreateObject("ADODB.RecordSet") there and instead of rs = my_conn.execute(strsql), use rs.open strsql, my_conn?

Or did I miss something and the adodb.recordset object has to be removed?

----------
-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
Go to Top of Page

Davio
Development Team Member

Jamaica
12217 Posts

Posted - 09 November 2001 :  02:18:05  Show Profile
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.

- David
Go to Top of Page

Da_Stimulator
DEV Team Forum Moderator

USA
3373 Posts

Posted - 09 November 2001 :  23:58:36  Show Profile  Send Da_Stimulator an AOL message  Send Da_Stimulator a Yahoo! Message
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
Go to Top of Page

RichardKinser
Snitz Forums Admin

USA
16655 Posts

Posted - 29 December 2001 :  01:38:27  Show Profile
removed the:

set rs = Server.CreateObject("ADODB.RecordSet")


and added set in front of rs = my_Conn.Execute(strSql)

fixed in v3.4
Go to Top of Page
  Previous Topic Topic Next Topic  
 Forum Locked  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.24 seconds. Powered By: Snitz Forums 2000 Version 3.4.07