I'm running into an odd behavior with CFQUERY (at least I think it is odd)
I have the following code (example)
cfquery name=blahName datasource=blah
SELECT blah
FROM blah
WHERE blah = 1
/cfquery
CFIF blahName.recordCount GT 0
12345
/CFIF
if the query blahName returns no results,
31, 2010 1:59 PM
To: cf-talk
Subject: CFQUERY Question
I'm running into an odd behavior with CFQUERY (at least I think it is odd)
I have the following code (example)
cfquery name=blahName datasource=blah
SELECT blah
FROM blah
WHERE blah = 1
/cfquery
CFIF blahName.recordCount GT 0
You are correct, the record count for an empty query object does exist (and
should be 0). What exactly is not working? Are you getting an error
message?
On Wed, Mar 31, 2010 at 1:59 PM, Dave Sueltenfuss dsueltenf...@gmail.comwrote:
I'm running into an odd behavior with CFQUERY (at least I
/unplugged
-Original Message-
From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com]
Sent: Wednesday, March 31, 2010 1:59 PM
To: cf-talk
Subject: CFQUERY Question
I'm running into an odd behavior with CFQUERY (at least I think it is odd)
I have the following code (example)
cfquery name
-williams.com
Great advertising can't be either/or. It must be .
Plug in to our blog: AW Unplugged
http://www.austin-williams.com/unplugged
-Original Message-
From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com]
Sent: Wednesday, March 31, 2010 1:59 PM
To: cf-talk
Subject: CFQUERY Question
If the query is executing correctly but bringing back no records, this
should work with blahname.recordcount equal zero . If the query is
not executing correctly, blahname.recordcount will not equal zero.
On Wed, Mar 31, 2010 at 10:59 AM, Dave Sueltenfuss
dsueltenf...@gmail.com wrote:
I'm
On Wednesday 07 Jan 2009, Andrew Tegenkamp wrote:
can I fix it?
You can, but shouldn't. Constructing raw SQL strings is dangerous, security
wise.
I expect your real use case is more complex, but rewriting it to :
cfquery name=insert datasource=#DSN#
INSERT INTO users(userName)
I have a SQL statement that is easier to build and save as a variable but it
throws an error when I do this:
cfset strSQL2 = INSERT INTO users(userName) VALUES('andrew')
cfquery name=insert datasource=#DSN#
#strSQL2#
/cfquery
The error says it is trying to insert the values with two '':
Andrew Tegenkamp wrote:
Why is this
Because CF automatically escapes all single quotes in variables used
inside of a CFQUERY... block.
and can I fix it?
Use the perserveSingleQuotes() function whose purpose is to over ride
this default behavior.
Just be aware that if you are not careful,
Does anyone know how to delete duplicate records from a table and leave only
one record in the table using CFQUERY.
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application.
Select Distinct *
INTO #temp
From mytable
truncate TABLE my table
Insert into myTable
Select *
From #temp
or thats the psuedo code for it...not sure the exact syntax is right
Adam H
On Fri, 28 Jan 2005 08:14:14 -0800 (PST), Discover Antartica
[EMAIL PROTECTED] wrote:
Does anyone know
Hello,
I was wondering if there was a easy way to run a quick query and have it display all of the results with out know in column names?
Example --
CFQUERY NAME=q_Info DATASOURCE=dbeta1
SELECT *
FROM DOCS
/CFQUERY
cfoutput query=q_Info startrow=1 maxrows=50
#q_Info.queryoutput#br --- This is
Loop thru query.ColumnNames
On Aug 28, 2004, at 12:06 PM, Charles Heizer wrote:
Hello,
I was wondering if there was a easy way to run a quick query and have
it display all of the results with out know in column names?
Example --
CFQUERY NAME=q_Info DATASOURCE=dbeta1
SELECT *
FROM DOCS
you could always use cfdump var=#q_info#
or you could loop through the q_info.columnlist variable.
-Original Message-
From: Charles Heizer [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 28, 2004 2:07 PM
To: CF-Talk
Subject: cfoutput and cfquery question ...
Hello,
I
Here you go ...
cfquery name='blah' ../
cfoutput query='blah'
cfloop list='#blah.columnlist#' index='col'
#col# = #evaluate(col)#
/cfloop
/cfoutput
- Joe
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
This was just what I was looking for ...
Thanks a bunch!
- Charles
Here you go ...
cfquery name='blah' ../
cfoutput query='blah'
cfloop list='#blah.columnlist#' index='col'
#col# = #evaluate(col)#
/cfloop
/cfoutput
- Joe
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
hi all,
I have a situation where I have to read the data from the table while the
other script is inserting data at the same time. Means I have a cgi script
which inserts data and cfm page is calling that inserted data till it finds
end word in one of the field. How I can do that using cfflush. I
SELECT
title,template,layout,meta_description,short_description,keywords,conten
t,image_a,image_b,image_c,
build_date,state
FROM #request.departmentTable#
WHERE id = #url.id#
how could this query above possibly bomb
when in cfquery tag, yet not in
: [EMAIL PROTECTED]
Blog : www.camdenfamily.com/morpheus/blog
Yahoo IM : morpheus
My ally is the Force, and a powerful ally it is. - Yoda
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 6:46 PM
To: CF-Talk
Subject: cfquery question
-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 8:46 PM
To: CF-Talk
Subject: cfquery question???
SELECT
title,template,layout,meta_description,short_description,keywords,conten
t
5.1; .NET CLR
1.0.3705)
Remote Address 127.0.0.1
Referrer
Date/Time 28-Jul-03 08:53 PM
Stack Trace (click to expand)
-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 8:52 PM
To: CF-Talk
Subject: RE: cfquery question
]
voice : 360.756.8080 x12
fax : 360.647.5351
www.audiencecentral.com
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 5:46 PM
To: CF-Talk
Subject: cfquery question???
SELECT
title,template,layout,meta_description,short_description
below is what i can output on the page, first you see
175, that is the value of url.id, 3 is the len of the string
url.id and you can view, the site at
http://www.revolutionwebdesign.com/clients/armynavy/site/department.cfm
In the error message, it seems to have a problem with the 175.
that parses out to armyNavy_departments all day long.
-Original Message-
From: Barney Boisvert [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 8:57 PM
To: CF-Talk
Subject: RE: cfquery question???
does #request.departmenttable# contain special chars? i'd recommend
escaping
see reply to ray. of course i checked all that, this is on my dev
box @ home... :) i can see all that !!!
see my reply!
tw
-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 8:54 PM
To: CF-Talk
Subject: RE: cfquery question???
Best bet
frustrating
thanks!
tony
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:03 PM
To: CF-Talk
Subject: Re: cfquery question???
below is what i can output on the page, first you see
175, that is the value of url.id, 3 is the len
: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:10 PM
To: CF-Talk
Subject: RE: cfquery question???
thats how the original code was...this is from site director3
and its not my code, i have to get in and hack it so that the
client can finally have their site up, i cant wait
CFQUERY Question to populate a drop down for search
I'm looking for a way to query a database table and display the results
with out any diplicates.
The WHERE city is unique does not work.
CFQUERY name=getcity DATASOURCE=datasource
SELECT city
FROM profiles
WHERE city is unique
/CFQUERY
You could use:
SELECT DISTINCT city FROM profiles
Alex
-Original Message-
From: Brian Simpson [mailto:[EMAIL PROTECTED]]
Sent: 29 May 2002 10:32
To: CF-Talk
Subject: CFQUERY Question to populate a drop down for search
CFQUERY Question to populate a drop down for search
You could use:
SELECT DISTINCT city FROM profiles
Not forgetting to ORDER BY the query, otherwise it can appear
pseudo-random
Philip Arnold
Technical Director
Certified ColdFusion Developer
ASP Multimedia Limited
Switchboard: +44 (0)20 8680 8099
Fax: +44 (0)20 8686 7911
www.aspmedia.co.uk
: Philip Arnold - ASP [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 29, 2002 5:57 AM
To: CF-Talk
Subject: RE: CFQUERY Question to populate a drop down for search
You could use:
SELECT DISTINCT city FROM profiles
Not forgetting to ORDER BY the query, otherwise it can appear
pseudo-random
Philip
select *
from sysobjects
where type = 'u'
order by name
Mark Stewart [EMAIL PROTECTED] on 09/06/2001 02:23:36 PM
Please respond to [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
cc:
Subject: RE: cfquery Question
There is a SqL Server stored procedure that will describe a database
Srocedures section.
Tim
- Original Message -
From: Mark Stewart [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 06, 2001 15:23
Subject: RE: cfquery Question
There is a SqL Server stored procedure that will describe a database for
you. Off the top of my head, I can't
Administrator/Web Developer
Ameritech/SBC
(810)466-7654 [Office]
[EMAIL PROTECTED] [work email]
[EMAIL PROTECTED] [work email]
- Original Message -
From: Edward Chanter [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, September 06, 2001 8:09 AM
Subject: cfquery Question
I'm probably being a dunce here but does anyone know a sql query that will
list out all the tables in a particular sql7 database...?
Thanks in advance...
-= Ed
~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ:
PROTECTED]]
Sent: Thursday, September 06, 2001 8:10 AM
To: CF-Talk
Subject: cfquery Question
I'm probably being a dunce here but does anyone know a sql query that
will
list out all the tables in a particular sql7 database...?
Thanks in advance...
-= Ed
Like what?
What exactly are you looking for? CREATE, ALTER, AND DROP work...
-Original Message-
From: Pooh Bear [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2001 2:26 PM
To: CF-Talk
Subject: CFQUERY question
hey can i do Full SQL programming inside cfquery tags
hey can i do Full SQL programming inside cfquery tags? or is it limited to
inserts updates, and such?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ:
hey can i do Full SQL programming inside cfquery tags? or is
it limited to inserts updates, and such?
No, on most platforms you should be able to write whatever SQL batch you
want within a CFQUERY.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202)
I've got a field in a database that is a list of id numbers. When creating
a query how do I say pull all records that have an id of "whatever" in that
list? I don't want to use CONTAINS since the id could be "1" and any number
with "1" in it could return the record like "142,3,8,76".
Any
]]
Sent: Wednesday, February 07, 2001 3:13 PM
To: CF-Talk
Subject: CFQUERY question
I've got a field in a database that is a list of id numbers. When creating
a query how do I say pull all records that have an id of "whatever" in that
list? I don't want to use CONTAINS since the id c
cfquery ...
select
whateveryouwanttoselect
from
tablename
where
idnumber = #whatever#
/cfqury
-Original Message-
From: Joby Bednar [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 3:13 PM
To: CF-Talk
Subject: CFQUERY question
I've got a field
This is a multi-part message in MIME format.
--=_NextPart_000_0177_01C017F7.6A6D41C0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
I have a list that contains the ID of several items in a database. I =
want to run one query that will
43 matches
Mail list logo