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!
http://www.amazon.com/Adobe-Coldfusion-An
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 th
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 sta
> 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
~~~
-talk
Subject: RE: cfqueryparam issue
This gets stranger and stranger. It doesn't appear to have anything to do with
the 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 an
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 wrote:
> This gets stranger and stranger. It doesn't appear to have anything to do
> with the tags. I've
This gets stranger and stranger. It doesn't appear to have anything to do with
the 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? Be
1: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 cfsqltype="cf_sql_varchar" />. When you read the data back out of the db,
> convert it back to a string like so: #toString(t
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 . When you read the data
Try to encode the string to base64 before adding it to the db. So it
becomes . 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 11:18 AM, Stephens, Larry V wrote:
>
> One of my table fields (and
> 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 ( cfsqltype="CF_SQL_SMALLINT"
> list="Yes">)
>
> This fails:
> WHERE [id] IN (< cfsqltype="CF_S
ge-
> 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, Apr 30, 2008 at 10:41 AM, Leitch, Oblio
> <[EMAIL PROTECTED]> wrote:
>
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 in a
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 messag
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 [
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 bar
--- 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?
>
http://www.
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
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?
http://www.google.com/custom?q=cfqueryparam+execution+plan&sitesea
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 pas
Duncan,
1) Shouldn't the cfqueryparam value be "#URL.cotid#" and not Attributes ?
2) You're not calling the cot_ID in your SELECT statement.
Mark
-Original Message-
From: Duncan I Loxton [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 05, 2005 11:10 PM
To: CF-Talk
Subject: CFQUERYPAR
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, amon
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.
>
>
> order by
>
Only use bind variables (i.e. cfqueryparam) for variables, not
for ide
> 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.
>
>
> ""> order by
> value="#arguments.sortby#">
>
> is what I had at the bottom of my query in the CFC
>
24 matches
Mail list logo