Thanks...I'm adding it all and will give it a shot. I did get a new error saying something about not getting a value...so it might work????
Dian D. Chapman, Technical Consultant Microsoft MVP, Certified MOS Expert Editor/TechTrax Ezine Free Tutorials: http://www.mousetrax.com/techtrax Free Word eBook: www.mousetrax.com/books.html Optimize your business docs: www.mousetrax.com/consulting Learn VBA the easy way: www.mousetrax.com/techcourses.html -----Original Message----- From: Paul Manzotti [mailto:[EMAIL PROTECTED] Sent: Friday, December 10, 2004 10:07 AM To: [EMAIL PROTECTED] Subject: Re: [ASP] SQL Query Syntax HELP! Dian D. Chapman wrote: >Thanks! I was wondering about both of the comments you made. As for the >*...there isn't much in either table and I DO need it all...so it seemed >silly to have to reiterate every field??? > Well, I always prefer to explicitly get the columns from the database. I've always considered it good practice - only get the information that you want, but it really stemmed from MS Access not returning any fields after a memo field (I think). manzo --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004 -- This email scanned and certified clean by AVG! Checked by AVG Anti-Virus. Version: 7.0.289 / Virus Database: 265.4.8 - Release Date: 12/8/2004 ------------------------ Yahoo! Groups Sponsor --------------------~--> $4.98 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/Q7_YsB/neXJAA/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/
