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
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
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
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
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
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
> 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
> 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 " 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
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
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 : , > 48 : , > 49 : value="#form.Comments#"> > 50 : ) > 51 : > > Here's my code from my form page: > > > > > and here's the *new*query statement > > 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 > ( > , > , > , > , > , > , > , > , >value="#form.Reason4Course#">, >value="#form.NumOfStudents#">, > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > > ) > > > ~| 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
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. -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 :, 48 :, 49 : 50 :) 51 : ~| 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
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 >> ( >> , >> value="#form.INDEXNO#">, >> , >> , >> , >> , >> 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
Yep. INSERT INTO table_name ( var_one, var_two) VALUES ( '#var_one#', '#var_two#') -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? INSERT INTO Results 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
> 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 " 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
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 : , > 48 : , > 49 : value="#form.Comments#"> > 50 : ) > 51 : > > Here's my code from my form page: > > > > > and here's the *new*query statement > > 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 > ( > , > , > , > , > , > , > , > , >value="#form.Reason4Course#">, >value="#form.NumOfStudents#">, > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > , > > ) > > > ~| 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! > -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 " 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
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 :, 48 :, 49 : 50 :) 51 : Here's my code from my form page: and here's the *new*query statement 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 ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) ~| 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
> 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 " 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
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
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
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
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
Chelsie Lawson wrote: > did I mention that I'm completely new to CFwhat would be the query code? > > > INSERT INTO Results > > do I have to list EVERY field with # # around them, separated by a comma?? Yes. INSERT INTO Results ( field1, field2, field3, field4 ... ) VALUES ( , , , , ... ) 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
>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
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
did I mention that I'm completely new to CFwhat would be the query code? INSERT INTO Results 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
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
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
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
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: > > > I need to add: > > > > 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 >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
So, if my code on my action page is: I need to add: 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 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 my code: 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
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
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
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 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
