I have a client who is essentially entering a document of 50+ pages into a text
area field (tiny MCE). The data is being saved to a data base via CFquery
Update. The data base is MS SQL server and the field length is set to
VARCHAR(MAX). Data is being truncated on update to data base (same
: Date Truncation on CFquery Update
I have a client who is essentially entering a document of 50+ pages into a
text
area field (tiny MCE). The data is being saved to a data base via CFquery
Update. The data base is MS SQL server and the field length is set to
VARCHAR(MAX). Data is being
is essentially entering a document of 50+ pages into a
text area field (tiny MCE). The data is being saved to a data base via
CFquery Update. The data base is MS SQL server and the field length is set
to VARCHAR(MAX). Data is being truncated on update to data base (same
place every time).
I
huge you might want to see if increasing that setting
helps.
-Original Message-
From: Robert Harrison [mailto:rob...@austin-williams.com]
Sent: 13 June 2012 17:17
To: cf-talk
Subject: Date Truncation on CFquery Update
I have a client who is essentially entering a document
Thanks Rob Parkhill.
It was the Max data length in cf admin.It was set to 64,000 characters by
default. Adjusting that solved the problem.
Robert Harrison
Director of Interactive Services
Austin Williams
Advertising I Branding I Digital I Direct
125 Kennedy Drive, Suite 100 I
I checked and it's turned off. This is happening from multiple computers
with Firefox.
Any other thoughts?
-Original Message-
From: Matt Quackenbush
Sent: Tuesday, April 19, 2011 12:20 AM
To: cf-talk
Subject: Re: CFQUERY update Firefox wierdness
Wild guess: Firebug is turned
On 19/04/2011 8:46 PM, Dan Blickensderfer wrote:
I checked and it's turned off. This is happening from multiple computers
with Firefox.
Any other thoughts?
in that case turn it on and look at what the browser is sending...
--
Yours,
Kym Kovan
mbcomms.net.au
not referring to a url
it reloads the same page.
This was driving me crazy.
Dan
-Original Message-
From: Kym Kovan
Sent: Tuesday, April 19, 2011 7:23 AM
To: cf-talk
Subject: Re: CFQUERY update Firefox wierdness
On 19/04/2011 8:46 PM, Dan Blickensderfer wrote:
I checked and it's turned off
Hi Everyone,
I have a really strange issue that I can not figure out how to fix it. I
have a simple shopping cart and everything works exactly the way it should
in ie7 ie8 but firefox not so much.
This is the issue. When customer clicks on the item to add to cart it first
checks to see if
Hi
I never seen that.. but the first thing I would look at is to set
up a way to see how many times that action page is run. Perhaps insert a
GetTickCount counter into a log file when the action page is
run.. First look to see how it works in IE, then try firefox.
At 06:55 PM 4/18/2011,
cfquery tag has absolutely nothing to do with any browser - it is
executed by cf on the server side.
i would check your page's html and javascript instead - that's where
browser differences can come into play.
how do you submit your form to add item to cart - ajax or regular form
submit?
how
Wild guess: Firebug is turned on and is adding a second click to the flow.
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
After a bit (!) of research, I am still a little confused about using
CFQUERYPARAM.
It is not in my SAMs Teach Yourself Coldfusion Express in 24 Hrs.
Probably not. I'm not sure CFQUERYPARAM exists in CF Express.
CFQUERYPARAM was introduced around the same time that CF Express came
out, but CF
I just want to point out that you should be using cfqueryparam around
all of those form elements. The way you have it will last about 2
hours before someone hacks into your database.
see:
error - CFQUERY - UPDATE Options
I just want to point out that you should be using cfqueryparam around
all of those form elements. The way you have it will last about 2
hours before someone hacks into your database.
see:
http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks
error - CFQUERY - UPDATE Options
I just want to point out that you should be using cfqueryparam around
all of those form elements. The way you have it will last about 2
hours before someone hacks into your database.
see:
http://www.forta.com/blog/index.cfm/2005/12/21/SQL-Injection-Attacks
How can CFQUERYPARAM be applied to a boolean (Yes/No) field ?
I cannot find it in the CFSQLTYPE list
Use BIT.
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,
... Syntax error - CFQUERY - UPDATE Options
How can CFQUERYPARAM be applied to a boolean (Yes/No) field ?
I cannot find it in the CDSQLTYPE list
- Original Message -
From: Al Musella, DPM muse...@virtualtrials.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Monday, December 29, 2008 5:40
Can anyone tell me exactly what is causing this error ?
!---Update using a CFQUERY with SQL UPDATE ---
CFquery NAME=qUpdate DATASOURCE=learncfe!--- error ---
UPDATE GuestBook
SET (GuestName = '#Form.GuestName#',
Email = '#Form.Email#',
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
Sorry that should be Comments = '#trim(Form.Comments)#)'
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic
On Sun, Dec 28, 2008 at 11:33 AM, Jide Aliu jide_a...@hotmail.com wrote:
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
Remove the opening bracket as well
CFquery NAME=qUpdate DATASOURCE=learncfe!--- error ---
UPDATE GuestBook
Thanks, but that is supposed to be the right bracket of the SET
- Original Message -
From: Jide Aliu jide_a...@hotmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Sunday, December 28, 2008 4:33 PM
Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Comments
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
Remove the opening bracket as well
CFquery NAME=qUpdate DATASOURCE=learncfe!--- error ---
UPDATE GuestBook
SET
GuestName = '#Form.GuestName#',
Email =
Woo !Thanks for that. works ok now.
- Original Message -
From: Casey Dougall ca...@uberwebsitesolutions.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Sunday, December 28, 2008 4:37 PM
Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
On Sun, Dec 28, 2008
Woo ! Thanks for thatworks ok now.
- Original Message -
From: Jide Aliu jide_a...@hotmail.com
To: cf-talk cf-talk@houseoffusion.com
Sent: Sunday, December 28, 2008 4:35 PM
Subject: Re: CF Express ... Syntax error - CFQUERY - UPDATE Options
Comments = '#trim(Form.Comments
Thanks, but that is supposed to be the right bracket of the SET
Comments = '#trim(Form.Comments)#')
Should be Comments = Comments = '#trim(Form.Comments)#'
Yep, but syntactically (sqlwise) you can't have the construct (opening and
closing bracket) the way it's laid out unlike your
Hi,
Whats wrong with the syntax below? When I change a field and click the submit to run
the code below it adds the field to the existing field in the database.
I want to replace it.
For example the password is test. Using my template I enter in xxx click the
submit. When I check the database
where usrID=#FORM.UserID# (your missing the name of the field in the
where clause...
At 12:16 PM 4/3/2003 -0500, you wrote:
Hi,
Whats wrong with the syntax below? When I change a field and click the
submit to run the code below it adds the field to the existing field in
the database.
I want
03, 2003 12:17 PM
To: CF-Talk
Subject: re: cfquery UPDATE
Hi,
Whats wrong with the syntax below? When I change a field and click the submit to run
the code below it adds the field to the existing field in the database.
I want to replace it.
For example the password is test. Using my template I
PROTECTED]
Sent: Thursday, April 03, 2003 9:16 AM
Subject: re: cfquery UPDATE
Hi,
Whats wrong with the syntax below? When I change a field and click the
submit to run the code below it adds the field to the existing field in
the database.
I want to replace it.
For example the password is test
-vancouverisland.com
- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 9:16 AM
Subject: re: cfquery UPDATE
Hi,
Whats wrong with the syntax below? When I change a field and click the
submit to run the code below it adds
-
Vancouver Island ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 9:16 AM
Subject: re: cfquery UPDATE
Hi,
Whats wrong
PROTECTED]
Sent: Thursday, April 03, 2003 9:16 AM
Subject: re: cfquery UPDATE
Hi,
Whats wrong with the syntax below? When I change a field and click the
submit to run the code below it adds the field to the existing field in
the database.
I want to replace
-
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 9:56 AM
Subject: Re: cfquery UPDATE
WTF
Here is my code:
cfquery name=UpdateUser datasource=#Request.App.dsn#
UPDATE login
SET
Username=cfqueryparam value=#FORM.Username#
cfsqltype
with the
original username...
HTH,
Jeff Garza
- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 10:56 AM
Subject: Re: cfquery UPDATE
WTF
Here is my code:
cfquery name=UpdateUser datasource=#Request.App.dsn#
UPDATE login
SET
]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 9:56 AM
Subject: Re: cfquery UPDATE
WTF
Here is my code:
cfquery name=UpdateUser datasource=#Request.App.dsn#
UPDATE login
SET
Username=cfqueryparam value=#FORM.Username#
cfsqltype=CF_SQL_LONGVARCHAR
ColdFusion Users Group
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: FlashGuy [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 9:56 AM
Subject: Re: cfquery UPDATE
WTF
Here is my code:
cfquery name=UpdateUser datasource
Eh.. if you are talking about character masking, you can use input type=password ..
. Otherwise, i don't understand the question :)
-R
-Original Message-
From: FlashGuy [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 03, 2003 1:13 PM
To: CF-Talk
Subject: Re: cfquery UPDATE
I have
I was going absolutely bonkers not understanding why CFUPDATE wasn't
always updating a field consistently, so I switched to CFQUERY and
updating the fields with SQL commands and it's now working perfectly. I
wasn't using any session or client variables other then those passed from
the form, but
What database were you using? Oracle has known problems with CFUPDATE and
CFINSERT.
-Original Message-
From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 2:19 PM
To: CF-Talk
Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e
tc.
I
Director
www.cfug-vancouverisland.com
- Original Message -
From: Hawkes, Keith A CIV [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 11:18 AM
Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename e
tc.
I was going absolutely bonkers
anythign about your database, so
don't let it.
My $0.02,
barneyb
-Original Message-
From: Hawkes, Keith A CIV [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 11:19 AM
To: CF-Talk
Subject: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE tablename
e tc.
I was going absolutely
What would I gain by using CFUPDATE/CFINSERT over CFQUERY?
THanks,
Scott
-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 2:24 PM
To: CF-Talk
Subject: RE: NOT A CRITICAL ISSUE - CFUPDATE vs CFQUERY UPDATE
tablena me e tc
: NOT
A CRITICAL
ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.)
What would I gain by using CFUPDATE/CFINSERT over CFQUERY?
THanks,
Scott
-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 2:24 PM
To: CF-Talk
Subject: RE
Founder Director
www.cfug-vancouverisland.com
- Original Message -
From: Scott Wilhelm [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 12:25 PM
Subject: Benefits of Using CFUPDATE/CFINSERT (was RE: NOT A CRITICAL
ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc
: NOT A CRITICAL
ISSUE - CFUPDATE vs CFQUERY UPDATE tablena me e tc.)
What would I gain by using CFUPDATE/CFINSERT over CFQUERY?
THanks,
Scott
-Original Message-
From: Edwards Robert (air0rae) [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 18, 2003 2:24 PM
To: CF-Talk
Subject: RE
Hi all,
I am trying to update a table using CFQUERY. I do not see any error when the
query is excuted in CF and I can see the query is correct in the debug mode.
But somehow the data is not updated. When I run the same query in SQL Server,
the data is updated. Does anybody know why? I am
Does it return an error in CF?
Some thoughts:
Make sure that the ID field is a NUMBER field
and the ID # is unique.
-Original Message-
From: JL [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 25, 2001 9:46 AM
To: CF-Talk
Subject: CFQUERY Update..
Hi all,
I am trying to update
:46 AM
Subject: CFQUERY Update..
Hi all,
I am trying to update a table using CFQUERY. I do not see any error when
the
query is excuted in CF and I can see the query is correct in the debug
mode.
But somehow the data is not updated. When I run the same query in SQL
Server,
the data
ANY IDEAS ON SYNTAX OR WHAT I AM OVERLOOKING:
The problem is using CFQUERY update to post edited results extracted from a
memo field back to that memo field. TPLT_TXT is a memo field.
I can SELECT data and display in in a textarea fine. It bombs when I try to
put it back. There is data
ADDED INFO ON: ANY IDEAS ON SYNTAX OR WHAT I AM OVERLOOKING:
When I change the TPLT_TXT line so I'm just posting a text string "This is
some text" it works fine too. So the issue must have to with something I
need to do with the text string in the "textarea" field before running the
update.
Solved problem -- I think.
I added a hidden field on the data entry page per example code below and it worked.
!-
Apparently a TPLT_TXT hidden field required for textarea field to
pass results to a CFQUERY update action on called page.
---
INPUT TYPE="hidden" NAME
Thought I solved the problem, but not so...
Worked fine when I updated the memo field with the TPLT_DES field that came
from a text box.
Bombs when I update the memo field with the contents of the textarea field.
Hence ODBC works fine.
Thus, the format or datatype or ??? of the textarea
Sorry to talk to myself about this problem, but, it's maddening.
Apparently at least one solution is to trim the length of the string
FORM.TPLT_TXT produced by the textarea to the length of the string in the
textarea before doing the update (go figure) as follows:
CFSET mLEN =
'[EMAIL PROTECTED]'
Subject: CFQUERY UPDATE problem -- not solved -- now solved.
Sorry to talk to myself about this problem, but, it's maddening.
Apparently at least one solution is to trim the length of the string
FORM.TPLT_TXT produced by the textarea to the length of the string in the
I have a SQL update. When it tries to update data a row
that doesn't exist I don't get an error, I don't get 0
rows, I get the query variable itself doesn't exist!?
A query can exist and contain no rows.
RecordCount counts existing rows.
If query has no rows - RecordCount is
pd" datasource="dsn"
update Users set UserName = "xyzzy" where UserName = "nevernevernotever"
/cfquery
Update done on cfoutput#upd.RecordCount#/cfoutput records.br
!--
He
From: "Peter Theobald" [EMAIL PROTECTED]
I have a SQL update. When it tries to update data a row that doesn't exist I
don't get an error, I don't get 0 rows, I get the query variable itself doesn't
exist!?
A query can exist and contain no rows.
RecordCount counts existing rows.
If query has
Ok i am very confused. I am trying to update one field with the following
statement:
CFQUERY Datasource="#dsn#" name="update1"
Update Rates_And_Charges
SET passengers_enplaned_domestic = #form.passengers_enplaned_domestic#
Where Member_number = '#form.Member_Number#'
/CFQUERY
It returns back the
ject: Help with CFQUERY/Update
Ok i am very confused. I am trying to update one field with the =
following=20
statement:=20
CFQUERY Datasource=3D"#dsn#" name=3D"update1"=20
Update Rates_And_Charges=20
SET passengers_enplaned_domestic =3D =
#form.passengers_enplaned_dome
i may just be reaching, but is the Member_number field in your database a
number field or a text field?
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
62 matches
Mail list logo