I agree with Adrian for an internal intranet site. The two recordset method requires two reads of the database whereas the inner join only requires one... as they say, six in one hand, half dozen in the other...
GL -----Original Message----- From: Adrian Forbes - ITD <[EMAIL PROTECTED]> Sent: Jul 22, 2004 12:25 PM To: [EMAIL PROTECTED] Subject: RE: [ASP] Well, THAT's not gonna work! The problem with that method is that you get repeated, redundant data. I think the idea of having two recordsets, one for the pictures and then one you repopulate each time for comments is better. Much easier to program to as well. -----Original Message----- From: Paul G. Sloboda [mailto:[EMAIL PROTECTED] Sent: 22 July 2004 5:24 To: [EMAIL PROTECTED] Subject: RE: [ASP] Well, THAT's not gonna work! Dian- u need to setup an inner join... a sql statement/construct which joins records of the two tables together GL- Paul Sloboda -----Original Message----- From: Dian Chapman <[EMAIL PROTECTED]> Sent: Jul 22, 2004 11:56 AM To: [EMAIL PROTECTED] Subject: RE: [ASP] Well, THAT's not gonna work! Thanks! I'll stop reading all the GET details in my dozen books and trying to match it up and make sense! ;-) Dian ~ -----Original Message----- From: Adrian Forbes - ITD [mailto:[EMAIL PROTECTED] Sent: Thursday, July 22, 2004 9:51 AM To: [EMAIL PROTECTED] Subject: RE: [ASP] Well, THAT's not gonna work! That was "pseudo code" he was writing. > Get PhotoRS("Select * from Photos") Really means construct a recordset that returns the results of that query as you would normally. I'd give an explicit example but my company's scanning software won't allow messages with code *rolls eyes* which is a PITA for this list. The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.722 / Virus Database: 478 - Release Date: 7/18/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.722 / Virus Database: 478 - Release Date: 7/18/2004 --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
