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
-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
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
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
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,
, 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
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
here's the results:
struct
Submit Evaluation
CLASSIFICATION Freshman
COMMENTStest
DATEMODIFIED11/30/2006
FACULTY_ID 334
FIELDNAMES
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
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:
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
, 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
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
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
: 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
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
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
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
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. :)
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
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
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
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
--//-
-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
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
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
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
[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
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
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
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.
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.
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
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
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:
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
36 matches
Mail list logo