Do a <cfdump var="#form#"> <cfabort> before running query.
And see if the field you are expecting is there. Is by any chance the field a check box? Those are submitted only if they are checked. You can also try: <cfparam name="form.confsent" default=""> at the top of the page but this can hide a problem you may having. Marius Milosav www.scorpiosoft.com It's not about technology, it's about people. Virtual Company (VICO) Application Demo www.scorpiosoft.com/vicodemo/login.cfm ----- Original Message ----- From: "Jillian Carroll" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Sunday, October 27, 2002 2:29 PM Subject: RE: Query Problem > I'm going out of my mind with this one. I use the EXACT same code to do the > initial entry of the user information and it works. > > It keeps telling me that "Relation "form" does not exist"... That leads me > to believe one of two things... either it is looking in my database for a > table named "form"... or for some reason when I hit submit on my form on the > previous page, the values aren't being transferred. > > Any reason why the form fields wouldn't be sent along with the form? Hrm. > > I tried just removing the # symbols from the queries... and no difference. > > > -----Original Message----- > From: S. Isaac Dealey [mailto:info@;turnkey.to] > Sent: Sunday, October 27, 2002 1:26 PM > To: CF-Talk > Subject: Re: Query Problem > > > > The query below doesn't work... the first clause in the > > CFIF works fine, but it gives me the error: Error while > > executing the query (non-fatal); ERROR: Relation "form" > > does not exist for the CFELSE portion. > > Incedentally, this _sounds_ to me like a bug. The syntax of the query > certainly looks good -- I can't imagine it not working on CF 3.0-5.0 for > Windows. What OS / CF version are you using? > > You might try removing the # symbols in your <cfif> statement -- they're not > necessary within cf tags and I suppose theoretically could be causing a > problem. That's pure conjecture tho. > > Isaac > Certified Advanced ColdFusion 5 Developer > > www.turnkey.to > 954-776-0046 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com