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
wrote:
>
> I'm running into an odd be
.com
>
> Great advertising can't be either/or. It must be &.
>
> Plug in to our blog: A&W Unplugged
> http://www.austin-williams.com/unplugged
>
>
> -Original Message-
> From: Dave Sueltenfuss [mailto:dsueltenf...@gmail.com]
> Sent: Wednesday, March
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)
SELECT blah
FROM
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 wrote:
>
> I'm running into an odd behavior with CFQUERY (at least I think it is odd)
>
>
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)
SELECT blah
FROM blah
WHERE blah = 1
12345
if the query blahName returns no results, I thought i would
I'm running into an odd behavior with CFQUERY (at least I think it is odd)
I have the following code (example)
SELECT blah
FROM blah
WHERE blah = 1
12345
if the query blahName returns no results, I thought i would still be able to
access blahName.recordCount
Am I wrong o
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 :
INSERT INTO users(userName) VALUES()
is trivial.
--
Tom Chiverton
Help
Andrew Tegenkamp wrote:
> Why is this
Because CF automatically escapes all single quotes in variables used
inside of a 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, it is re
I have a SQL statement that is easier to build and save as a variable but it
throws an error when I do this:
#strSQL2#
The error says it is trying to insert the values with two '':
SQL: INSERT INTO users(userName) VALUES(''andrew'')
If I put the SQL code into the CFQUERY tag it is fi
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 kn
Does anyone know how to delete duplicate records from a table and leave only
one record in the table using .
~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tr
This was just what I was looking for ...
Thanks a bunch!
- Charles
>Here you go ...
>
>
>
>
> #col# = #evaluate(col)#
>
>
>
>- Joe
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
Here you go ...
#col# = #evaluate(col)#
- Joe
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
you could always use
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,
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 --
>
>
> SELECT *
> FROM DOCS
>
>
>
> #q_Info.
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 --
SELECT *
FROM DOCS
#q_Info.queryoutput# <--- This is what I need help with :-)
Thanks,
- Charles
[Todays Threads]
[This Message]
[Su
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 h
: 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 to
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
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 is
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
escapi
> 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. W
EMAIL PROTECTED]
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
&
ows NT 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???
Ar
) 933-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_descri
: [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
>
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 q
om: 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
ps
> 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
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
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.
SELECT city
FROM profiles
WHERE city is unique
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)
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: http://www.thenetprofits.
select
whateveryouwanttoselect
from
tablename
where
idnumber = #whatever#
-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 database that
ECTED]]
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
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 though
37 matches
Mail list logo