Thanks John!
Eric
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm
DatePart will return an integer so CF_SQL_INTEGER
On Mon, Aug 9, 2010 at 10:46 AM, Eric Roberts <
ow...@threeravensconsulting.com> wrote:
>
> We are putting a cfqueryparam aound all of our sql vars...I am not sure how
> to handle this one:
>
> Here's the line:
>
> *
>
> AND* DatePart(m,inv_date)
We are putting a cfqueryparam aound all of our sql vars...I am not sure how
to handle this one:
Here's the line:
*
AND* DatePart(m,inv_date)=
Should that be date or varchar since it is looking at the part of the date
(which I am assuming returns a char or varchar value). The actual column i
> The list="yes" parameter of CFQUERYPARAM will properly wrap the single quotes
> around each list element.
That's not quite right. What it will do is create a parameter for
every element in the list and map it to the database type you supply.
Even with character data, no single quotes are used w
Try this:
Thanks,
Eric Cobb
Scott Stewart wrote:
> I have a variable passed though a URL that looks like this
>
> index.cfm?a=1,2,3
>
> The variable "a" is passed to a SQL statement WHERE clause as
> part of an "IN" operator
>
> IE: WHERE b in (#url.a#).
>
> How would I encapsulate "url.a
cfqp has a list attribute.
Adrian
Building a database of ColdFusion errors at http://cferror.org/
-Original Message-
From: Scott Stewart
Sent: 28 October 2008 17:13
To: cf-talk
Subject: CFQueryParam question
I have a variable passed though a URL that looks like this
index.cfm?a=1,2,3
WHERE b IN ( )
The list="yes" parameter of CFQUERYPARAM will properly wrap the single quotes
around each list element.
-Jason
>I have a variable passed though a URL that looks like this
>
>index.cfm?a=1,2,3
>
>The variable "a" is passed to a SQL statement WHERE clause as
>part of an "IN" opera
Obviously you would need to change the sqltype to what your sql type is.
On Tue, Oct 28, 2008 at 10:13 AM, Scott Stewart <[EMAIL PROTECTED]>wrote:
> I have a variable passed though a URL that looks like this
>
> index.cfm?a=1,2,3
>
> The variable "a" is passed to a SQL statement WHERE clause
I have a variable passed though a URL that looks like this
index.cfm?a=1,2,3
The variable "a" is passed to a SQL statement WHERE clause as
part of an "IN" operator
IE: WHERE b in (#url.a#).
How would I encapsulate "url.a" in a CFQueryParam properly, is this a
case where I wouldn't define the c
Sorry forgot to mention.
we are only storing text, HTML and wddx information in these fields.
Matt
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.
I have to modify my MSSQL database and change some of my fields from varchars
to text fields.
The question I have is that i have a bunch of querys that we are using the
function and we are binding with the cfsqltype="varchar".
Do I need to go through the entire site and change this to CF_SQL_L
I believe with Oracle in later than CF5 you could insert/update more
than 4000 characters into a clob when using CF_SQL_CLOB. Not sure for
CF5 though, for some reason I recall it failing beyond 4000 and
requiring work arounds.
On Tue, 22 Mar 2005 10:44:53 -0700, Scott Brady <[EMAIL PROTECTED]> w
On Sun, 13 Mar 2005 11:06:58 -0500, S. Isaac Dealey wrote:
> specifically I believe cfsqltype="cf_sql_longvarchar"
CF_SQL_CLOB is an undocumented type that is, I believe, more
specifically designed for the "text" field, though longvarchar also
works. I'm not sure if there's a significant differen
specifically I believe cfsqltype="cf_sql_longvarchar"
> Long varchar
> Ade
> -Original Message-
> From: Dave Francis [mailto:[EMAIL PROTECTED]
> Sent: 13 March 2005 12:50
> To: CF-Talk
> Subject: cfqueryparam question
> Brain-dead. What's
Long varchar
Ade
-Original Message-
From: Dave Francis [mailto:[EMAIL PROTECTED]
Sent: 13 March 2005 12:50
To: CF-Talk
Subject: cfqueryparam question
Brain-dead. What's the cfqueryparam cfsqltype for a text column? - SQL
Server 2k. CF5.0
--
No virus found in this outgoing me
Brain-dead. What's the cfqueryparam cfsqltype for a text column? - SQL
Server 2k. CF5.0
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a
>>Yes, that is correct.
Ok, I understand, the null must be specify by program, because
CFQUERYPARAM has no way to distinguish an empty string from a true null.
Thanks.
--
___
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagst
> Do you mean that if NULL="yes" null will be passed to the
> database, even if the VALUE attributes contains a valid value?
Yes, that is correct.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
Fig Leaf Software provides the highest caliber vendor-authorized
instruction at our trai
>>That'll pass the number in the database, unless the value isn't
>>numeric, in which case it will pass NULL.
Do you mean that if NULL="yes" null will be passed to the database, even if the
VALUE attributes contains a valid value ?
--
___
REUSE CODE! Use cu
> I'm not too sure I accurately understand the role of
> attribute null in the CFQUERYPARAM tag.
> Does it mean that if it is YES, when the VALUE attribute is
> empty, the query will use NULL instead of the empty string?
Yes. You can use inline conditional logic to determine whether to specify a
If the NULL atributes is set to true, then NULL will be passed to the
database. If the NULL attributes is set to false (or omitted), then
the value of the VALUE attribute will be passed to the database.
Here's a 'typical' usage:
That'll pass the number in the database, unless the value isn't
n
Hi,
I'm not too sure I accurately understand the role of attribute null in
the CFQUERYPARAM tag.
Does it mean that if it is YES, when the VALUE attribute is empty, the
query will use NULL instead of the empty string?
For instance, these two quries are about the same?
INSERT INTO Clients (Client
I'd swear I just answered this question. Invalid Parameter Binding
probably means the CFSQLTYPE is not right.
Try using a different CFSQLTYPE. Like INTEGER.
Better yet, store zip code as a string, because if you store it as a
number, you'll have to format it on the output if the zipcode is 00
SELECT *
FROM mytable
WHERE zip <
Jochem
~|
Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF
community.
http://www.houseoffusion.com/banners/view.cfm?bannerid=38
Message: http://www
why the parenthesis? That might be it
Ray
At 02:37 PM 10/27/2004, you wrote:
>Sadly, I'm just learning to use cfqueryparam in my querys. However, I get
>an error every time!
>
>"[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s). "
>
>For the life of me I can't understand why I get
Why do you have a single quote after the WHERE statement?
WHERE '(zip <
-Original Message-
From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 27, 2004 2:37 PM
To: CF-Talk
Subject: cfqueryparam question (errors)
Sadly, I'm just learning to use cfque
Sadly, I'm just learning to use cfqueryparam in my querys. However, I get an error
every time!
"[DataDirect][SequeLink JDBC Driver]Invalid parameter binding(s). "
For the life of me I can't understand why I get this. Query works great without.
ColdFusion MX.
SELECT *
FROM mytable
WH
No
-Original Message-
From: Chris Montgomery [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 10, 2003 12:55 PM
To: CF-Talk
Subject: Quick CFQueryParam Question
Howdy,
When using the CFQueryParam tag to insert string form values
(cfsqltype="CF_SQL_VARCHAR"), does this aut
Howdy,
When using the CFQueryParam tag to insert string form values
(cfsqltype="CF_SQL_VARCHAR"), does this automatically "Trim" the value?
Thanks.
--
Chris Montgomery
Airtight Web Services http://www.airtightweb.com
Web Development, Web Project Management, Software Sales
210-490-2415
AIM: Ai
David Collie (itndac) wrote:
>
>
> SELECT AS
>QUESTION
> FROM
> WHERE=
>
>
>
>
> Not actually looked at if there has been any major performance increase cause of
>this but can anybody explain why it doesn't accpet it in the FROM clause, but it does
>in t
It's a database limitation. You can't bind variables for table names, just column
values.
>
> SELECT
>AS QUESTION
> FROM
> WHERE=
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?foru
Ooops... doesn't work at all actually, the last statement doesn't return any errors
but doesn't return the required rows anyway...
-Original Message-
From: David Collie (itndac)
Sent: 21 February 2003 15:09
To: CF-Talk
Subject: cfqueryparam question
Was mucking
Was mucking about trying to optomise a reports template and noticed I had the
following code (obvious dynamic variables)...
SELECT #sColName# AS QUESTION
FROM#sTableName#
WHERE #sPKCol# =
Lead webdev suggested trying cfqueryparam's like so
SELECT
Has any one had any memory leak problems with cfx_image tag? I haven't been
able to pin our server issues on the tag yet with 100% certainty, but it
seems as though making about 3-4 consecutive calls to the tag is causing
the cfserver to become unresponsive (timeout).
Anybody have any similar
This AND title LIKE
Robert Everland III
Dixon Ticonderoga
Web Developer Extraordinaire
-Original Message-
From: Jen Perkins [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 25, 2002 1:08 PM
To: CF-Talk
Subject: cfqueryparam question
When you are doing a sql query with a LIKE statement
When you are doing a sql query with a LIKE statement:
..AND title LIKE '%#TRIM(FORM.criteria)#%'
Should you do this:
..AND title LIKE
OR this?
..AND title LIKE '%%'
Many thanks in advance.
Jen Perkins
Macromedia Certified ColdFusion Developer
Carol/Trevelyan Strategy Group
Phone: 925.432.4
I thought couldn't/shouldn't be used in INSERT
statements?
(I don't remember where I heard this. I think from a thread months
ago on
this list.) Where are people using them in their code? I use them
in
every SELECT statement I make, but not in INSERT, UPDATE, and DELETE.
Any
thoughts?
>
37 matches
Mail list logo
