I'm glad it worked. As (I hope) I indicated, I was using someone else's expertise, having found the technique on the net.
Dave S ----- Original Message ----- From: Christie Mason To: [email protected] Sent: Monday, September 05, 2005 12:41 AM Subject: RE: [ASP] Insert records Yippee yahooey. Thank you, you're name is very appropriate and it's a much better morning thanks to you. Had to go offline to deal with my septic system backing up so yesterday was not a good day in many ways. The INSERT INTO worked great. I attempted to use that approach earlier but all the examples I found seemed to indicate that I could only use field names in the select. Christie Mason -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of David Smart Sent: Saturday, September 03, 2005 7:17 PM To: [email protected] Subject: Re: [ASP] Insert records "insert into [C_ModelFeatures] ([idCategory], [Descrip]) select " & varMaxID & ", [Descrip] from [C_ModelFeatures] where [idCategory] = " & cloneCategory --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- ------------------------------------------------------------------------------ YAHOO! GROUPS LINKS a.. Visit your group "active-server-pages" on the web. b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. ------------------------------------------------------------------------------ [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/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/
