What was causing the issue was setting the rowcount 1 and maintaining connections across client requests. Apparently this set the rowcount to all queries called after this to have a rowcount of 1. So access to the CF Admin was pretty critical to the resolution using the code as I originally wr
MAIL PROTECTED]
On Behalf Of Jeff HowardSent: Wednesday, October 04, 2006 9:50
AMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss]
Issue with return from cfquery
So I got access to the CF Admin this morning and between that and Profiler
I can see what is causing my issue and can resolve. Than
ubject: RE: [ACFUG Discuss] Issue with return
from cfquery
You
should probably look into using scope_identity() rather than the method you
use below...that may help you out a bit...
INSERT into blah() values()
SELECT ID = SCOPE_IDENTITY()
Rowcount can cause some
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Jeff
Howard
Sent: Wednesday, October 04, 2006
9:50 AM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Issue
with return from cfquery
So I got access to the CF Admin this morning and between that and
Profiler I
I'm no SQL Server master, but I'd think you just use the SELECT SCOPE_IDENTITY() as ID; to fetch the last used id.so, in one cfquery tag you'd haveINSERT INTO table
(col1, col2)VALUES(val1, val2);SELECT SCOPE_IDENTITY() as ID;Then foo.id has your last inserted id. DK
On 10/4/06, Jeff Howard <[EMAI
]
[mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent:
Wednesday, October 04, 2006 9:50 AMTo:
discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return
from cfquery
So I got access to the CF Admin this morning and between that and
Profiler I can see what is causing my issue and can
So I got access to the CF Admin this morning and between that and Profiler I can see what is causing my issue and can resolve. Thanks for everyone's help once again. It was a comination of advice that got me to this point. Now I was wondering if anyone could tell me why this issue is happenin
] On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 4:40 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfqueryCharlie,
I appreciate the help. I have not used SQL Profiler before. I have been looking at it and can see it "really is querying the d
Yeah, and here I broke out the musket for nothin'.
:-)
/charlie
http://www.carehart.org/blog/
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]Sent:
Tuesday, October 03, 2006 4:18 PMTo:
discussion@acfug.orgSubject: Re: [ACFUG Discuss] Issue with r
L PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 4:40
PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss]
Issue with return from cfquery
Charlie,
I appreciate the help.
I have not used SQL Profiler before. I have been looking at it and can see
it
Charlie, I appreciate the help. I have not used SQL Profiler before. I have been looking at it and can see it "really is querying the database". Once again, I've never used SQL Profiler but I'm pretty positive that I've figured this part out. As far as the CF debugging tool, we had a
Of Charlie Arehart
Sent: Tuesday, October 03, 2006 4:03 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] Issue with return from cfquery
At the risk of taking on Dean in a head-first ram-on-ram head butt :-), I
want to offer a clarification.
Dean, you said " explicitly prevents ca
w.carehart.org/blog/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H.
Saxe
Sent: Tuesday, October 03, 2006 2:10 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Issue with return from cfquery
Ben,
explicitly prevents caching of result
n
> getting
> it, and clarify as well what Dean may have been meaning to say. OK,
> that's
> my volley, Dean (to switch analogies from rams to the revolution).
> Fire away
> while I reload my muzzle. :-)
>
> /charlie
> http://www.carehart.org/blog/
>
> -
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe
Sent: Tuesday, October 03, 2006 2:10 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Issue with return from cfquery
Ben,
explicitly prevents caching of result sets.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTEC
http://www.carehart.org/blog/
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard
Sent: Tuesday, October 03, 2006 1:58 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Issue with return from cfquery
This "test app" all of a
@acfug.orgSubject: RE: [ACFUG
Discuss] Issue with return from cfquery
Given
all this - I'd strongly urge you to check your DSN's like Dean was pointing out
earlier - this just doesn't make a whole lot of sense.
Allen
-Original Message-From: [EMAIL PROTECTED]
[mailto:[
ay, October 03, 2006 1:47 PMTo:
discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with
return from cfquery
Ok, the new issue is it all of a sudden started working again.
I didn't change any settings anywhere or even change my script. All
I did was eat a sandwich
Return Receipt
Your Re: [ACFUG Discuss] Issue with return from cfquery
document
Return Receipt
Your Re: [ACFUG Discuss] Issue with return from cfquery
document
ay, October 03, 2006 1:47 PMTo:
discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with
return from cfquery
Ok, the new issue is it all of a sudden started working again.
I didn't change any settings anywhere or even change my script. All
I did was eat a sandwich
Jeff
Howard
Sent: Tuesday, October 03, 2006 12:32 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Issue with return from cfquery
Does anyone know what could be causing the following issue:
I have a very simple query:
SELECT ID
FROM test
: [EMAIL PROTECTED]
]On Behalf Of Jeff Howard> Sent: Tuesday, October 03, 2006 12:32 PM> To: discussion@acfug.org> Subject: [ACFUG Discuss] Issue with return from cfquery
>> Does anyone know what could be causing the following issue:>>> I have a very simple query:>>&
27;t affect the query results.-Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 1:47 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfquery Ok, the new issue
is it all of a sudden
e running into a query caching issue.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff
Howard
Sent: Tuesday, October 03, 2006 12:32 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Issue with return from cfquery
Does anyone know what could be causing the following is
ly getting one record returned and a
> recordcount of 1.
>
> [EMAIL PROTECTED] wrote:
> Maybe try this:
> SELECT [id] from test
> -Original Message-
> From: [EMAIL PROTECTED] [mailto: [EMAIL PROTECTED] Behalf Of Jeff Howard
> Sent: Tuesday, October 03, 2006 12
discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return
from cfquery
Ok, the new issue is it all of a sudden started working again. I
didn't change any settings anywhere or even change my script. All I did
was eat a sandwich and hit refresh on the page and it started work
/charlie http://www.carehart.org/blog/ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff HowardSent:
Tuesday, October 03, 2006 12:32 PMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Issue with return from cfqueryDoes anyone know what could be causing the followin
.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. Saxe
Sent: Tuesday, October 03, 2006 1:30 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] Issue with return from cfquery
"maintain connections..." has nothing to do with query cac
[EMAIL PROTECTED] wrote:> Maybe try this:> SELECT [id] from test
> -Original Message-> From: [EMAIL PROTECTED] [mailto:
[EMAIL PROTECTED]]On Behalf Of Jeff Howard> Sent: Tuesday, October 03, 2006 12:32
PM> To: discussion@acfug.org> Subject: [ACFUG Discuss] Issue with
running into a query caching issue.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff
Howard
Sent: Tuesday, October 03, 2006 12:32 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Issue with return from cfquery
Does anyone know what could be causing the following issue
ERE clause which is always true for all
records, such as:
WHERE 1 = 1
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff
Howard
Sent: Tuesday, October 03, 2006 9:32 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Issue with return from cfquery
Does anyone know
SELECT [id] from test> -Original Message-> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Howard> Sent: Tuesday, October 03, 2006 12:32
PM> To: discussion@acfug.org> Subject: [ACFUG Discuss] Issue with return from cfquery>> Does anyone know what co
PROTECTED] On Behalf Of Jeff
Howard
Sent: Tuesday, October 03, 2006
12:32 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Issue
with return from cfquery
Does anyone know what could be causing the following issue:
I have a very simple query:
SELECT ID
ent.
/charlie
http://www.carehart.org/blog/
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 12:32
PMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Issue
with return from cfquery
Does anyone know what could be causing the following issu
gt; [EMAIL PROTECTED] wrote:> Maybe try this:> SELECT [id] from test> -Original Message-> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Howard> Sent: Tuesday, October 03, 2006 12:32 PM> To: discussion@acfug.org> Subject: [ACFUG Discuss] Issue with return
discussion@acfug.org
Subject: [ACFUG Discuss] Issue with return from cfquery
Does anyone know what could be causing the following issue:
I have a very simple query:
SELECT ID
FROM test
The DB has 1 column named ID and 10 rows numbered 1-10. I built
this table to try and figure o
] wrote:
Maybe try this:
SELECT [id] from test
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jeff Howard
Sent: Tuesday, October 03, 2006 12:32 PM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Issue with return from cfquery
Does anyone know what could be caus
alf Of Jeff HowardSent: Tuesday, October 03, 2006 9:32 AMTo: discussion@acfug.orgSubject: [ACFUG Discuss] Issue with return from cfquery Does anyone know what could be causing the following issue: I have a very simple query: SELECT ID FROM test The DB has 1 colu
: discussion@acfug.orgSubject: [ACFUG Discuss] Issue with return from cfquery Does anyone know what could be causing the following issue:
I have a very simple query: SELECT ID FROM test The DB has 1 column named ID and 10 rows numbered 1-10. I built this table to try and figure out what
I've tried both ways and they both produce the same result.Precia <[EMAIL PROTECTED]> wrote:ARe you placing your output as such #ID# or #getIDs.ID# or some other way? The first example will return all rows. The second example will return one row. Preci
with return from cfquery
Does anyone know what could be causing the following issue:
I have a very simple query:
SELECT ID
FROM test
The DB has 1 column named ID and 10 rows numbered 1-10. I built
this table to try and figure out what is
ARe you placing your output as such
#ID#
or
#getIDs.ID#
or some other way?
The first example will return all rows. The second example will return one row.
Precia
On 10/3/06, Jeff Howard <[EMAIL PROTECTED]> wrote:
Does anyone know what could be causing the following issu
Maybe
try this:
SELECT
[id] from test
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent:
Tuesday, October 03, 2006 12:32 PMTo:
discussion@acfug.orgSubject: [ACFUG Discuss] Issue with return from
cfquery
Does anyone know
Does anyone know what could be causing the following issue: I have a very simple query: SELECT ID FROM test The DB has 1 column named ID and 10 rows numbered 1-10. I built this table to try and figure out what is happening to a more complex table that is having the same issue.
45 matches
Mail list logo
