Your cfif statement asks for the recordCount to be returned
on if the recordCount is greater than 0.
Try cfif blahName.recordcount GTE 0 and you should
get the recordCount either way.
Rick
-Original Message-
From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com]
Sent: Wednesday, March
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
You are correct that it should work, but they maybe something else in the
code which is preventing the query from being executed. On the top of your
page add:
cfparam name= blahName.recordcount default=0
And that will deal with the case where the query is not executed.
Robert B.
Ok, found the cause of the issue, by taking the query into SQL Server
In SQL, the following is being returned
*Warning: Null value is eliminated by an aggregate or other SET operation.
(0 row(s) affected)*
So it appears this is what is throwing off the query results in CF
I am working on
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)
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,
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
Are you sure request.departmentTable is a valid table?
===
Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc
(www.mindseye.com)
Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia)
Email:
Best bet is to activate debugging and see what the actual query being
executed is. That'll let you know for sure what each variable is equal to
at the time of query execution. Also, are you sure that the table name is
correct?
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301)
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
does #request.departmenttable# contain special chars? i'd recommend
escaping it with [brackets] either way, if you're on SQL Server or Access.
`backticks` will do it for MySQL, and I don't know about anything else.
---
Barney Boisvert, Senior Development Engineer
AudienceCentral
[EMAIL
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
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
What your looking for is:
CFQUERY Name=myTables Datasource=yourDataSource
SELECT *
FROM sysobjects
WHERE xtype = 'U'
/CFQUERY
Type U is user tables and S is system tables. There are others, but I'm not
sure what they are.
Steven Durette
MGR. - Engineering Construction System Support
Database
There is a SqL Server stored procedure that will describe a database for
you. Off the top of my head, I can't remember the name of it but you can
find it in books on line.
If I can remember the name, I'll pass it along.
Mark
-Original Message-
From: Edward Chanter [mailto:[EMAIL
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? or is it
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)
Try the CF functions ListContains or ListFind. We dealt with the very same
issue and used one of these two to solve it, but I don't remember which.
This works as long as your database field is exactly a CF list format.
Brian
-Original Message-
From: Joby Bednar [mailto:[EMAIL
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 in a
28 matches
Mail list logo