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
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
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
~~
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 F
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.
>
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 an
> 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.figl
> 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 yo
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 resul
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 Com
nto 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 fa
t;> 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
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 Compatibi
> 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
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
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
>
> S
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\CourseEvalsUse
> 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. :)
--
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
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
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
e-
> 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 stateme
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 ... )
>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? whe
, 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 c
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 m
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:
>
>
> F
ge-
> 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
>
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,QUES
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 t
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 insert
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.f
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 CF
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 l
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, mak
35 matches
Mail list logo
