Hi Dian, > ...it doesn't like and it appears it doesn't like the Boolean field. So > I might be doing it wrong? But I've tried without quotes and with > single quotes...but it keeps telling me that one item doesn't have > a value. Since the error happens when I add the Boolean statement, > that must be it.
It's not the True that's doing it, it's the Chr(34). Try replacing it with a single apostrophe (Chr(39)). And TRUE should not be in quotes or apostrophes in your SQL. Regards, Shawn K. Hall http://ReliableAnswers.com/ '// ======================================================== Hope for the Best. Expect the worst. Life is a play. We're unrehearsed. -- Mel Brooks ------------------------ 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 <*> 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/
