One of my table fields (and this occurs in many of my tables) is edited using
CKEditor. This means the data will look like ptext data /p
I am using Access at the moment, converting to MySQL. I have not tried this
with the MySQL database; it fails using the Access database. (But, I have a
Try to encode the string to base64 before adding it to the db. So it
becomes cfqueryparam value=#toBase64(conNote)#
cfsqltype=cf_sql_varchar /. When you read the data back out of the db,
convert it back to a string like so: #toString(toBinary(field_name))#
HTH
Steve
On Fri, Feb 8, 2013 at
Thanks - but same error.
-Original Message-
From: Steve Milburn [mailto:scmilb...@gmail.com]
Sent: Friday, February 08, 2013 11:56 AM
To: cf-talk
Subject: Re: cfqueryparam issue
Try to encode the string to base64 before adding it to the db. So it
becomes cfqueryparam value=#toBase64
Milburn [mailto:scmilb...@gmail.com]
Sent: Friday, February 08, 2013 11:56 AM
To: cf-talk
Subject: Re: cfqueryparam issue
Try to encode the string to base64 before adding it to the db. So it
becomes cfqueryparam value=#toBase64(conNote)#
cfsqltype=cf_sql_varchar /. When you read the data back
This gets stranger and stranger. It doesn't appear to have anything to do with
the p tags. I've found all I have to do is remove some of the end of the
message and it works. I played with several iterations and finally took off the
last sentence and then it works okay.
Why the last sentence?
What is the datatype and length of the column in the Access database? This
sounds like a pretty standard data truncation problem.
-Cameron
On Fri, Feb 8, 2013 at 2:41 PM, Stephens, Larry V steph...@iu.edu wrote:
This gets stranger and stranger. It doesn't appear to have anything to do
with
Subject: RE: cfqueryparam issue
This gets stranger and stranger. It doesn't appear to have anything to do with
the p tags. I've found all I have to do is remove some of the end of the
message and it works. I played with several iterations and finally took off the
last sentence and then it works
What is the datatype and length of the column in the Access database?
Also, which datasource type? I remember someone mentioning problems with Memo
fields when using the unicode driver a ways back. They suggested using *_clob
instead of *_longvarchar.
-Leigh
It's a memo field.
-Original Message-
From: Cameron Childress [mailto:camer...@gmail.com]
Sent: Friday, February 08, 2013 2:52 PM
To: cf-talk
Subject: Re: cfqueryparam issue
What is the datatype and length of the column in the Access database? This
sounds like a pretty standard
Thank you - that did it. Does this apply to MySQL, too? (I'm porting the thing
over...)
-Original Message-
From: Leigh [mailto:cfsearch...@yahoo.com]
Sent: Friday, February 08, 2013 3:07 PM
To: cf-talk
Subject: Re: cfqueryparam issue
What is the datatype and length of the column
Well MySQL has very different data types (and unlike Access, it uses a pure
jdbc driver). So this probably does not apply to MySQL.
-Leigh
~|
Order the Adobe Coldfusion Anthology now!
I have a list of small numbers in a variable that I'm passing as an IN
() statement to a query-of-a-query. When I cast it as a TINYINT, it
fails. Any idea why?
This works:
WHERE [id] IN (cfqueryparam value=7,0,5,6 cfsqltype=CF_SQL_SMALLINT
list=Yes)
This fails:
WHERE [id] IN (cfqueryparam
What's the error message?
On Wed, Apr 30, 2008 at 10:41 AM, Leitch, Oblio
[EMAIL PROTECTED] wrote:
I have a list of small numbers in a variable that I'm passing as an IN
() statement to a query-of-a-query. When I cast it as a TINYINT, it
fails. Any idea why?
This works:
WHERE [id] IN
Oh yeah, that would help, wouldn't it?
It states: java.lang.Short cannot be cast to java.lang.Byte
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 30, 2008 1:44 PM
To: CF-Talk
Subject: Re: cfqueryparam issue
What's the error message?
On Wed
I don't know if you copy-pasted right out of your code, but you have an
extra '' in the second example.
-Original Message-
From: Leitch, Oblio [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 30, 2008 12:42 PM
To: CF-Talk
Subject: cfqueryparam issue
I have a list of small numbers
:[EMAIL PROTECTED]
Sent: Wednesday, April 30, 2008 1:44 PM
To: CF-Talk
Subject: Re: cfqueryparam issue
What's the error message?
On Wed, Apr 30, 2008 at 10:41 AM, Leitch, Oblio
[EMAIL PROTECTED] wrote:
I have a list of small numbers in a variable that I'm passing as an IN
() statement
I have a list of small numbers in a variable that I'm passing
as an IN () statement to a query-of-a-query. When I cast it as a
TINYINT, it fails. Any idea why?
This works:
WHERE [id] IN (cfqueryparam value=7,0,5,6
cfsqltype=CF_SQL_SMALLINT
list=Yes)
This fails:
WHERE [id] IN
Hey folks,
Still having this issue, and would like some more eyes on it, if
possible. Below is my original post from earlier this week.
I'm getting an odd error when using cfqueryparam. I've got the type
set to cf_sql_integer - the value I'm passing is an integer (even
throwing Int() into
Message-
From: Scott Weikert [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 04, 2007 10:33 AM
To: CF-Talk
Subject: Re: Odd cfqueryparam issue
Hey folks,
Still having this issue, and would like some more eyes on it, if possible.
Below is my original post from earlier this week.
I'm getting
I'm getting an odd error when using cfqueryparam. I've got the type
set to cf_sql_integer - the value I'm passing is an integer (even
throwing Int() into the mix - and yet, I'm getting the error:
[Macromedia][SQLServer JDBC Driver]Value can not be converted to
requested type.
However, when I
PM
To: CF-Talk
Subject: Odd cfqueryparam issue
I'm getting an odd error when using cfqueryparam. I've got the type
set to cf_sql_integer - the value I'm passing is an integer (even
throwing Int() into the mix - and yet, I'm getting the error:
[Macromedia][SQLServer JDBC Driver]Value can
Gaulin, Mark wrote:
Are you positive that the datatype in the database for that field is
really int? Could it be different in the two environments (which I
assume have different db servers)?
Quite certain. It's the primary keyed identity field in the given table.
The dev database is a
Hi all. I have an RSS processor that works like a champ, at least it did until
it ran into a string value that's causing it to barf. The heart of the
challenge is an insert query, where I'm inserting a few fields into a headlines
table. All field values are using cfqueryparam tags, but I have
Tried wrapping it in a toString? Or perhaps xmlformat?
Dunno what would do that off hand...
On 4/25/06, rhymes with 'loud' Doug Boude [EMAIL PROTECTED] wrote:
Hi all. I have an RSS processor that works like a champ, at least it did
until it ran into a string value that's causing it to barf.
OK, I discovered that
a) I posted in the wrong bit of the debug - the query after it was the
one affected. The fact that it had the ? on it threw me a bit and
stopped me looking at other causes, so I am afraid I jumped the gun
rather.
b) There was a problem relating to data and what was being
Duncan I Loxton wrote:
While I am here - I have read that using cfqueryparam gives a
performance gain over not using it - is there any proof or technical
data out there? An explanation over why/how it makes a query faster?
On Thursday 06 Jan 2005 09:13 am, Duncan I Loxton wrote:
one affected. The fact that it had the ? on it threw me a bit and
This is standard denotation for a bind parameter, which is what cfqueryparam
does.
--
Tom Chiverton
Advanced ColdFusion Programmer
Tel: +44 (0)1749 834900
email: [EMAIL
--- Jochem van Dieten [EMAIL PROTECTED] wrote:
Duncan I Loxton wrote:
While I am here - I have read that using cfqueryparam gives a
performance gain over not using it - is there any proof or technical
data out there? An explanation over why/how it makes a query faster?
I have just started to adopt something that I have seen on this list
cfqueryparam, amongst a host of other best practices that I have been
picking up whilst reading here.
My query looks like this:
cfquery name=getChildren dataSource=#Application.DataSource#
userName=#Application.DBUserName#
The debug output says you got 14 rows back with the CFQUERYPARAM tag
in there, not zero, so something's screwy.
cheers,
barneyb
On Thu, 6 Jan 2005 15:09:47 +1100, Duncan I Loxton
[EMAIL PROTECTED] wrote:
I have just started to adopt something that I have seen on this list
cfqueryparam, amongst
: CFQUERYPARAM issue
I have just started to adopt something that I have seen on this list
cfqueryparam, amongst a host of other best practices that I have been
picking up whilst reading here.
My query looks like this:
cfquery name=getChildren dataSource=#Application.DataSource#
userName
Okay I just spent about an hour on this...
Something's messed up with cfquerparam when used within the order by
SQL statement.
It was like it was ignoring the order by entirely.
cfif isdefined(arguments.sortby) and arguments.sortby neq
order by cfqueryparam cfsqltype=cf_sql_varchar
Okay I just spent about an hour on this...
Something's messed up with cfquerparam when used within the
order by SQL statement.
It was like it was ignoring the order by entirely.
cfif isdefined(arguments.sortby) and arguments.sortby neq
order by cfqueryparam cfsqltype=cf_sql_varchar
Greg Morphis wrote:
Okay I just spent about an hour on this...
Something's messed up with cfquerparam when used within the order by
SQL statement.
It was like it was ignoring the order by entirely.
cfif isdefined(arguments.sortby) and arguments.sortby neq
order by cfqueryparam
34 matches
Mail list logo