RE: Firefox Compatibility
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:262203 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
The browser will not typically affect your CF code. The only time that I have seen browser dependencies is when you debu Flex applications with FireFox. That is a flash player issues though. How are you submitting your data to the database import? On example would be that IE allows a lot more loose code when it comes to forms versus FireFox, which is more strict. This can cuase issues with form controls not submitting. Teddy On 11/30/06, Chelsie Lawson [EMAIL PROTECTED] wrote: 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:262204 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
Chelsie Lawson wrote: 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 Are you using CFINSERT or something? We're going to have to see your code to really help, because normally the browser really doesn't affect CFML execution at all. My guess is that you're using CFINSERT or CFUPDATE or something like that, and Firefox is including a fieldname that is blank or something in the form scope (which would be difficult, to say the least) but who knows. Personally, I despise CFINSERT and CFUPDATE. Rick ~| 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:262206 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
It's fun. Try it. -Original Message- From: Chelsie Lawson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 9:19 AM To: CF-Talk Subject: 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:262210 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
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. -Original Message- From: Chelsie Lawson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 9:31 AM To: CF-Talk Subject: Re: Firefox Compatibility here's the results: struct Submit Evaluation CLASSIFICATIONFreshman COMMENTS test DATEMODIFIED 11/30/2006 FACULTY_ID334 FIELDNAMES STUDENTID,INDEXNO,FACULTY_ID,DATEMODIFIED,TIMEMODIFIED,GENDER, CLASSIFICATION,GPA,REASON4COURSE,NUMOFSTUDENTS,QUESTION1,QUESTION2, QUESTION3,QUESTION4,QUESTION5,QUESTION6,QUESTION7,QUESTION8,QUESTION 9,QUESTION10,QUESTION11,QUESTION12,QUESTION13,QUESTION14,QUESTION15, QUESTION16,QUESTION17,QUESTION18,QUESTION19,QUESTION20,QUESTION21,QU ESTION22,COMMENTS, GENDERM GPA A INDEXNO A60328301001 NUMOFSTUDENTS A QUESTION1 A QUESTION10A QUESTION11A QUESTION12A QUESTION13A QUESTION14A QUESTION15A QUESTION16A QUESTION17A QUESTION18A QUESTION19A QUESTION2 A QUESTION20A,B QUESTION21A QUESTION22A QUESTION3 A QUESTION4 A QUESTION5 A QUESTION6 A QUESTION7 A QUESTION8 A QUESTION9 A REASON4COURSE A STUDENTID ** TIMEMODIFIED 10: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:262212 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
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:262213 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
You should compare the dump results on IE and FF. See if there is any change in data or fields. If so that is where you look in your form code. Joshua Cyr Savvy Software 866.870.6358 www.besavvy.com -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 10:46 AM To: CF-Talk Subject: 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. -Original Message- From: Chelsie Lawson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 9:31 AM To: CF-Talk Subject: Re: Firefox Compatibility here's the results: struct Submit Evaluation CLASSIFICATIONFreshman COMMENTS test DATEMODIFIED 11/30/2006 FACULTY_ID334 FIELDNAMES STUDENTID,INDEXNO,FACULTY_ID,DATEMODIFIED,TIMEMODIFIED,GENDER, CLASSIFICATION,GPA,REASON4COURSE,NUMOFSTUDENTS,QUESTION1,QUESTION2, QUESTION3,QUESTION4,QUESTION5,QUESTION6,QUESTION7,QUESTION8,QUESTION 9,QUESTION10,QUESTION11,QUESTION12,QUESTION13,QUESTION14,QUESTION15, QUESTION16,QUESTION17,QUESTION18,QUESTION19,QUESTION20,QUESTION21,QU ESTION22,COMMENTS, GENDERM GPA A INDEXNO A60328301001 NUMOFSTUDENTS A QUESTION1 A QUESTION10A QUESTION11A QUESTION12A QUESTION13A QUESTION14A QUESTION15A QUESTION16A QUESTION17A QUESTION18A QUESTION19A QUESTION2 A QUESTION20A,B QUESTION21A QUESTION22A QUESTION3 A QUESTION4 A QUESTION5 A QUESTION6 A QUESTION7 A QUESTION8 A QUESTION9 A REASON4COURSE A STUDENTID ** TIMEMODIFIED 10: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:262217 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
Chelsie Lawson wrote: 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?? Yes. cfquery name=AddEval datasource=studentsurvey INSERT INTO Results ( field1, field2, field3, field4 ... ) VALUES ( cfqueryparam cfsqltype=fieldtype1 value=#form.fieldname1#, cfqueryparam cfsqltype=fieldtype2 value=#form.fieldname2#, cfqueryparam cfsqltype=fieldtype3 value=#form.fieldname3#, cfqueryparam cfsqltype=fieldtype4 value=#form.fieldname4#, ... ) /cfquery look at the documentation for cfqueryparam to find out what to use for the cfsqltype values. Rick ~| 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:26 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
http://tinyurl.com/oo49m It's basically a tag that makes sure that the value you are trying to insert/select/update into your database is of the correct type (ie, date, varchar, int, bit, etc). You wrap it around your field values. Helps make your app much more secure as it prevents sql injection attacks. It also helps debugging in that you don't have to worry about whether you included quotes around text fields vs. date/int/etc fields. Again, a little bit more typing, but worth it when you go to make a change to the application months down the road. -Original Message- From: Chelsie Lawson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 9:51 AM To: CF-Talk Subject: 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:262225 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
Check your form code. Those results mean that the browsers are picking up an empty form field or something else odd. Coding your own cfquery is good for all the reasons already mentioned, but you really should clean up the form too in case it presents other problems down the road. Joshua Cyr Savvy Software 866.870.6358 www.besavvy.com -Original Message- From: Chelsie Lawson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 10:05 AM To: CF-Talk Subject: 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:262227 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
As for the cause of this, it looks like Firefox will send a form value for anything with name=, but IE does not, so perhaps that is the problem. It seems like you should see that listed in your cfdump though, and I don't see anything without a name. It looks like both IE and FF will submit something named name= , which would also probably hose a cfinsert. But as was mentioned...+1 to ditching cfinsert. ~| 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:262228 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
http://tinyurl.com/oo49m Sorry for the OT self promotion, but rather than sending a LiveDocs URL to tinyurl, you could post a short URL from CFQuickDocs: http://cfquickdocs.com/?getDoc=cfqueryparam It's not quite as short as tinyurls, but it still won't wrap. :) -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| 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:262234 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
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
Cool. I didn't even know about that. Thanks! -Original Message- From: Munson, Jacob [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 11:44 AM To: CF-Talk Subject: RE: Firefox Compatibility http://tinyurl.com/oo49m Sorry for the OT self promotion, but rather than sending a LiveDocs URL to tinyurl, you could post a short URL from CFQuickDocs: http://cfquickdocs.com/?getDoc=cfqueryparam It's not quite as short as tinyurls, but it still won't wrap. :) -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| 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:262236 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
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 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,Cla 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#, 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:262239 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
Cool. I didn't even know about that. Thanks! It works for functions too: http://cfquickdocs.com/?getDoc=datediff :) -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == EMF idahopower.com made the previous annotations. ~| 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:262240 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
Yep. INSERT INTO table_name ( var_one, var_two) VALUES ( '#var_one#', '#var_two#') !//-- andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --//- -Original Message- From: Chelsie Lawson [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 8:46 AM To: CF-Talk Subject: 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:262241 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'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
RE: Firefox Compatibility
On the error page, sometimes the debug output provides you with the SQL statement that it attempted to execute. You could copy that and paste it directly into a query editor for your database (if you have one). On first blush, perhaps you need a different cfsqltype since you're inserting into a memo field. It's been a looong time since I've used Access. cfqueryparam cfsqltype=cf_sql_clob value=#form.Comments# -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 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 ~| 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:262244 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
You also seem to be missing a ')' right before VALUES in your SQL. Maybe another typo into the email? -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 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,Cla 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#, 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:262246 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 used to despise them to, but then I realised something pretty cool about these tags, they work out the datatype of the columns for you, so generating truly dynamic queries where you don't know what datatype each column will be is posisble. Russ -Original Message- From: Rick Root [mailto:[EMAIL PROTECTED] Sent: 30 November 2006 15:20 To: CF-Talk Subject: Re: Firefox Compatibility Chelsie Lawson wrote: 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 Are you using CFINSERT or something? We're going to have to see your code to really help, because normally the browser really doesn't affect CFML execution at all. My guess is that you're using CFINSERT or CFUPDATE or something like that, and Firefox is including a fieldname that is blank or something in the form scope (which would be difficult, to say the least) but who knows. Personally, I despise CFINSERT and CFUPDATE. Rick ~| 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:262282 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 used to despise them to, but then I realised something pretty cool about these tags, they work out the datatype of the columns for you, so generating truly dynamic queries where you don't know what datatype each column will be is posisble. One thing I've always wondered is do you have protection against sql-injection attacks when you use cfinsert/cfupdate? When you use cfquery with a regular insert/update statement, you need to use cfqueryparam to make sure people don't destroy your database. But does cfinsert/cfupdate do that stuff automatically? Sounds like a question for a tinkerer like Ben Nadel. :) EMF idahopower.com made the following annotations. -- This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. == ~| 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:262306 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
One thing I've always wondered is do you have protection against sql-injection attacks when you use cfinsert/cfupdate? According to Ben Forta, yes. This makes sense, I guess, since CF has to determine the datatypes of the fields in any case. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore and Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:262312 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
On 11/30/06, Dave Watts [EMAIL PROTECTED] wrote: One thing I've always wondered is do you have protection against sql-injection attacks when you use cfinsert/cfupdate? According to Ben Forta, yes. This makes sense, I guess, since CF has to determine the datatypes of the fields in any case. Dave: I saw you pose that question on Ben's blog in the comments (http://www.forta.com/blog/index.cfm/2006/10/3/Use-CFINSERT-And-CFUPDATE), but saw no response from Ben. If this is in fact the case, that's good to know (altho I still am not a big fan of either tag) :) -- Charlie Griefer ...All the world shall be your enemy, Prince with a Thousand Enemies, and whenever they catch you, they will kill you. But first they must catch you, digger, listener, runner, prince with a swift warning. Be cunning and full of tricks and your people shall never be destroyed. ~| 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:262315 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 have noticed a similar problem with Firefox and a certain WYSIWYG text editor. Try turning your cftextarea tag into an HTML form textarea and see what happens. Might not be it but worth a try... 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:262330 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
How can your original form have two answers submitted for the same question? looks like you have a form field with the same name QUESTION20 A,B Casey On 11/30/06, Chelsie Lawson [EMAIL PROTECTED] wrote: 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:262338 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
Casey Dougall wrote: How can your original form have two answers submitted for the same question? looks like you have a form field with the same name QUESTION20 A,B A group of checkboxes with the same field name, or a select field with 'multiple' turned on. :P ~| 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:262342 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
could be checkboxes On 11/30/06, Casey Dougall [EMAIL PROTECTED] wrote: How can your original form have two answers submitted for the same question? looks like you have a form field with the same name QUESTION20 A,B Casey On 11/30/06, Chelsie Lawson [EMAIL PROTECTED] wrote: 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:262343 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
Duh... Thanks for the wakeup call! OK time to step away from the computer! C. On 11/30/06, Charlie Griefer [EMAIL PROTECTED] wrote: could be checkboxes ~| 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:262349 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4