Firefox Compatibility
The web application I created will not insert the data into my Db. The app works fine with IE. The error says that a certain field is missing in the results table of my DB... : The given fieldname could not be found in the table Results Do I need to download something on my CF server to make my application work in firefox? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262199 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Firefox Compatibility
Here's my code: cfinsert datasource=studentsurvey tablename=Results pretty straighforward. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262207 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Firefox Compatibility
So, if my code on my action page is: cfinsert datasource=studentsurvey tablename=Results I need to add: cfdump var=#form# cfinsert datasource=studentsurvey tablename=Results what will this do? CF cares nothing about what browser you use. My first suggestion is to CFDUMP every scope you are using: URL, FORM, etc. Then, try each browser and look for the differences. I assume that, since you are inserting data, that you are using a form, so use cfdump var=#form# and test it with both browsers. Also, make sure you are following the EXACT SAME procedure/data for testing both browsers. Certain form elements won't appear in the form scope if they are not selected. These would be form elements such as checkboxes, radio buttons, un-clicked buttons and multi-select lists. M!ke -Original Message- From: Chelsie Lawson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 7:12 AM To: CF-Talk Subject: Firefox Compatibility The web application I created will not insert the data into my Db. The app works fine with IE. The error says that a certain field is missing in the results table of my DB... : The given fieldname could not be found in the table Results Do I need to download something on my CF server to make my application work in firefox? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Firefox Compatibility
here's the results: struct Submit Evaluation CLASSIFICATION Freshman COMMENTStest DATEMODIFIED11/30/2006 FACULTY_ID 334 FIELDNAMES STUDENTID,INDEXNO,FACULTY_ID,DATEMODIFIED,TIMEMODIFIED,GENDER,CLASSIFICATION,GPA,REASON4COURSE,NUMOFSTUDENTS,QUESTION1,QUESTION2,QUESTION3,QUESTION4,QUESTION5,QUESTION6,QUESTION7,QUESTION8,QUESTION9,QUESTION10,QUESTION11,QUESTION12,QUESTION13,QUESTION14,QUESTION15,QUESTION16,QUESTION17,QUESTION18,QUESTION19,QUESTION20,QUESTION21,QUESTION22,COMMENTS, GENDER M GPA A INDEXNO A60328301001 NUMOFSTUDENTS A QUESTION1 A QUESTION10 A QUESTION11 A QUESTION12 A QUESTION13 A QUESTION14 A QUESTION15 A QUESTION16 A QUESTION17 A QUESTION18 A QUESTION19 A QUESTION2 A QUESTION20 A,B QUESTION21 A QUESTION22 A QUESTION3 A QUESTION4 A QUESTION5 A QUESTION6 A QUESTION7 A QUESTION8 A QUESTION9 A REASON4COURSE A STUDENTID ** TIMEMODIFIED10:37:14 ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262211 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Firefox Compatibility
did I mention that I'm completely new to CFwhat would be the query code? cfquery name=AddEval datasource=studentsurvey INSERT INTO Results /cfquery do I have to list EVERY field with # # around them, separated by a comma?? It's interesting that FORM.FIELDNAMES has a trailing comma. I have no idea why it would, but that might be the cause of the problem. Ditch cfinsert and use cfquery instead =) It's safer and performs better, and is far easier to debug. Rick Chelsie Lawson wrote: here's the results: FIELDNAMES STUDENTID,INDEXNO,FACULTY_ID,DATEMODIFIED,TIMEMODIFIED, GENDER,CLASSIFICATION,GPA,REASON4COURSE,NUMOFSTUDENTS,QUESTION1, QUESTION2,QUESTION3,QUESTION4,QUESTION5,QUESTION6,QUESTION7,QUESTION8, QUESTION9,QUESTION10,QUESTION11,QUESTION12,QUESTION13,QUESTION14, QUESTION15,QUESTION16,QUESTION17,QUESTION18,QUESTION19,QUESTION20, QUESTION21,QUESTION22,COMMENTS, ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Firefox Compatibility
I'd take the advice of others on the list and ditch the cfinsert, and use cfquery with an insert statement. It's a little more code, but it makes it MUCH easier to maintain and debug. Don't forget to use cfqueryparam too. It's just good practice. what's the cfqueryparam code? where does it go? ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262219 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Firefox Compatibility
the IE dump results did not have a comma after commentsbut how do you get rid of that for Firefox? it makes sense that that comma would be the problem. It's interesting that FORM.FIELDNAMES has a trailing comma. I have no idea why it would, but that might be the cause of the problem. Ditch cfinsert and use cfquery instead =) It's safer and performs better, and is far easier to debug. Rick Chelsie Lawson wrote: here's the results: FIELDNAMES STUDENTID,INDEXNO,FACULTY_ID,DATEMODIFIED,TIMEMODIFIED, GENDER,CLASSIFICATION,GPA,REASON4COURSE,NUMOFSTUDENTS,QUESTION1, QUESTION2,QUESTION3,QUESTION4,QUESTION5,QUESTION6,QUESTION7,QUESTION8, QUESTION9,QUESTION10,QUESTION11,QUESTION12,QUESTION13,QUESTION14, QUESTION15,QUESTION16,QUESTION17,QUESTION18,QUESTION19,QUESTION20, QUESTION21,QUESTION22,COMMENTS, ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262226 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Firefox Compatibility
Ok...I've inserted the *all in favor of cfquery* code into my test app. haha But, I'm getting the error on line 49, which is my comments textbox. Here's the error: Error Executing Database Query. Syntax error in INSERT INTO statement. The error occurred in C:\CFusionMX7\wwwroot\CourseEvalsUserAuth\action.cfm: line 49 47 :cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question21#, 48 :cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question22#, 49 :cfqueryparam cfsqltype=cf_sql_longvarchar value=#form.Comments# 50 :) 51 :/cfquery Here's my code from my form page: cftextarea name=Comments width=500 cols=100/cftextarea and here's the *new*query statement cfquery name=AddEval datasource=studentsurvey INSERT INTO Results (StudentID,INDEXNO,FACULTY_ID,DateModified,TimeModified,Gender,Classification,GPA,Reason4Course,NumOfStudents,Question1,Question2,Question3,Question4,Question5,Question6,Question7,Question8,Question9,Question10,Question11,Question12,Question13,Question14,Question15,Question16,Question17,Question18,Question19,Question20,Question21,Question22,Comments VALUES ( cfqueryparam cfsqltype=cf_sql_varchar value=#form.StudentID#, cfqueryparam cfsqltype=cf_sql_longvarchar value=#form.INDEXNO#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.FACULTY_ID#, cfqueryparam cfsqltype=cf_sql_date value=#form.DateModified#, cfqueryparam cfsqltype=cf_sql_time value=#form.TimeModified#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Gender#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Classification#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.GPA#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Reason4Course#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.NumOfStudents#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question1#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question2#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question3#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question4#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question5#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question6#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question7#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question8#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question9#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question10#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question11#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question12#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question13#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question14#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question15#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question16#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question17#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question18#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question19#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question20#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question21#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Question22#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Comments# ) /cfquery ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262235 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Firefox Compatibility
I'm using an access one right now (i know, i know) my datatype is a memofield. that was just a typo. :) What datatype is your Comments field? What database are you using? Also, I noticed that your code has a little indiscrepancy. The error message you supply is saying that the cfsqltype is longvarchar and your code paste says it is type varchar. Not sure if that is a typo, or if it would technically matter in this case, but thought I'd point it out. -Original Message- From: Chelsie Lawson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 10:36 AM To: CF-Talk Subject: Re: Firefox Compatibility Ok...I've inserted the *all in favor of cfquery* code into my test app. haha C:\CFusionMX7\wwwroot\CourseEvalsUserAuth\action.cfm: ssification,GPA,Reason4Course,NumOfStudents,Question1,Question2,Question3,Q uestion4,Question5,Question6,Question7,Question8,Question9,Question10,Questi o n11,Question12,Question13,Question14,Question15,Question16,Question17,Questi on18,Question19,Question20,Question21,Question22,Comments VALUES ( cfqueryparam cfsqltype=cf_sql_varchar value=#form.StudentID#, cfqueryparam cfsqltype=cf_sql_longvarchar value=#form.INDEXNO#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.FACULTY_ID#, cfqueryparam cfsqltype=cf_sql_date value=#form.DateModified#, cfqueryparam cfsqltype=cf_sql_time value=#form.TimeModified#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Gender#, cfqueryparam cfsqltype=cf_sql_varchar value=#form.Classification#, ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:262242 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
