Re: Log reporting error - No actual error (LONG)
Ok, here's the code from the two files. First, the form page (which someone is sent to after clicking "Checkout" on a non-secure page. This page is a secure page.): [and yes, I know there are some scoped variables which should be locked, but, again, this code isn't mine] __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Well... I think I've gone through all of my "ask these first" questions. The only other thing I can think of is a code review of the complete code. Dunno. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Scott Brady [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, September 18, 2002 8:50 PM > To: CF-Talk > Subject: Re: Log reporting error - No actual error > > > > If you try to CFOUTPUT FORM.FormFields, what does it give you? > And, if it > > gives you a list as you would expect, try iterating over that list, > > evaluating each one as in: > > I displayed the list and the values for each item in the list. The > list/values output as it should. And, it gave me an error saying "Element > FIELDNAMES is undefined in FORM. The error occurred on line 17." > > Line 17 is where I output Form.fieldnames (and it displayed ok). > > Mind boggling, isn't it? > > Scott > --- > Scott Brady > http://www.scottbrady.net > > > __ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Log reporting error - No actual error
I decided to look at the debugging info through CF (using MX's dockable debugging tree). For the tree item "Exceptions" it says "None Present". But, the error still gets reported. --- Scott Brady http://www.scottbrady.net __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Log reporting error - No actual error
> If you try to CFOUTPUT FORM.FormFields, what does it give you? And, if it > gives you a list as you would expect, try iterating over that list, > evaluating each one as in: I displayed the list and the values for each item in the list. The list/values output as it should. And, it gave me an error saying "Element FIELDNAMES is undefined in FORM. The error occurred on line 17." Line 17 is where I output Form.fieldnames (and it displayed ok). Mind boggling, isn't it? Scott --- Scott Brady http://www.scottbrady.net __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Jeez. Well, I can't see any problems in the code that you posted. If you try to CFOUTPUT FORM.FormFields, what does it give you? And, if it gives you a list as you would expect, try iterating over that list, evaluating each one as in: FORM.FormFields = #FORM.FormFields# FORM.#CurrEle# = #Evaluate("FORM.#CurrEle#")# FORM.FormFields is Not Defined -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Scott Brady [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 3:12 PM > To: CF-Talk > Subject: RE: Log reporting error - No actual error > > > I can give you the relevant parts, without posting all of the actual code: > > > >" >" > > > > INSERT INTO Orders > ( > FirstName > ) > VALUES > ( > '#form.FirstName#' > ) > > > > .. and then it displays the next page. > > (That page has a form on it, as well, which does the same thing > with submissions). > > It appears to happen with every field in the form (so, if you > were to cfparam FORM.firstname, then the error would report for > FORM.lastname [the next field]). > > > Scott Brady > http://www.scottbrady.net/ > > > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
I can give you the relevant parts, without posting all of the actual code: INSERT INTO Orders ( FirstName ) VALUES ( '#form.FirstName#' ) .. and then it displays the next page. (That page has a form on it, as well, which does the same thing with submissions). It appears to happen with every field in the form (so, if you were to cfparam FORM.firstname, then the error would report for FORM.lastname [the next field]). Scott Brady http://www.scottbrady.net/ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Not to sound like a broken record, but could you post the code for the action page? As Dan suggested, that's most likely where the problem would be. -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Scott Brady [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 1:23 PM > To: CF-Talk > Subject: RE: Log reporting error - No actual error > > > Here's the basic code (with layout and such trimmed out): > > The form: > > > > First Name* > align="LEFT" size="20" maxlength="25"> > > > > > > > > > > [I just noticed the missing closing table tag in that cell. I'm > closing it now, but I can't believe that's the problem] > > The action page is fairly simple. I can > #FORM.firstname# and it outputs fine and it > inserts into the database fine. But, cferror is triggered and > sends an e-mail saying that FORM.firstname doesn't exist. And, > again, cfparam-ing it just causes an empty string to go into the > database [without cfparam, the submitted form field goes into the > database]. > > > > Scott Brady > http://www.scottbrady.net/ > > -- Original Message -- > From: Mosh Teitelbaum <[EMAIL PROTECTED]> > Reply-To: [EMAIL PROTECTED] > Date: Tue, 17 Sep 2002 13:09:38 -0400 > > >Do you have any code we could look at? > > > >-- > >Mosh Teitelbaum > > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
>Turn off your error handling to see where the error is truly > occurring ... I knew I forgot to mention something. Even turning off the error handling doesn't throw an error in the browser when you submit the form. If I don't put in #FORM.firstname# (which I just used to debug), the line number in the error message is in the Insert Query. (although the Insert still works) Scott Brady http://www.scottbrady.net/ __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Turn off your error handling to see where the error is truly occurring ... or are you including that information in the error message? Your form is probably fine, I would concentrate on the page handling the request ... Dan -Original Message- From: Scott Brady [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 10:23 AM To: CF-Talk Subject: RE: Log reporting error - No actual error Here's the basic code (with layout and such trimmed out): The form: First Name* [I just noticed the missing closing table tag in that cell. I'm closing it now, but I can't believe that's the problem] The action page is fairly simple. I can #FORM.firstname# and it outputs fine and it inserts into the database fine. But, cferror is triggered and sends an e-mail saying that FORM.firstname doesn't exist. And, again, cfparam-ing it just causes an empty string to go into the database [without cfparam, the submitted form field goes into the database]. Scott Brady http://www.scottbrady.net/ -- Original Message -- From: Mosh Teitelbaum <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 17 Sep 2002 13:09:38 -0400 >Do you have any code we could look at? > >-- >Mosh Teitelbaum __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Here's the basic code (with layout and such trimmed out): The form: First Name* [I just noticed the missing closing table tag in that cell. I'm closing it now, but I can't believe that's the problem] The action page is fairly simple. I can #FORM.firstname# and it outputs fine and it inserts into the database fine. But, cferror is triggered and sends an e-mail saying that FORM.firstname doesn't exist. And, again, cfparam-ing it just causes an empty string to go into the database [without cfparam, the submitted form field goes into the database]. Scott Brady http://www.scottbrady.net/ -- Original Message -- From: Mosh Teitelbaum <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Tue, 17 Sep 2002 13:09:38 -0400 >Do you have any code we could look at? > >-- >Mosh Teitelbaum __ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Log reporting error - No actual error
Do you have any code we could look at? -- Mosh Teitelbaum evoch, LLC Tel: (301) 625-9191 Fax: (301) 933-3651 Email: [EMAIL PROTECTED] WWW: http://www.evoch.com/ > -Original Message- > From: Scott Brady [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, September 17, 2002 12:27 PM > To: CF-Talk > Subject: Log reporting error - No actual error > > > (I thought I sent this on Saturday, but never saw any replies nor > could I find it in the archives, so let me try it again) > > I'm helping a friend debug his site. Here's what happens: > > A user proceeds through the checkout process. In the first step, > they fill out a form. The next page goes through just fine and > they can finish the process ok. > > However, the log file reports an exception was generated and > cferror is called, sending an e-mail to the admin. The error > message is that "Form.FirstName" does not exist. However, on the > page generating the error, you can output "Form.FirstName" just > fine and it goes into the database just fine. > > I thought if I just put in cfparams (with defaults of empty > strings) for the form values, that would take care of it. But > then, the database actually inserts the empty strings (without > the cfparams, it inserts the submitted values). > > Has anyone else encountered this? It's very weird. > > The production environment is Windows 2000 CF5. > My development environment is Windows XP CFMX. > The error occurs in both environments. > > Thanks! > > > Scott Brady > http://www.scottbrady.net/ > > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists