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 happening
:[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
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 havecfquery name=fooINSERT INTO table
(col1, col2)VALUES(val1, val2);SELECT SCOPE_IDENTITY() as ID;/cfqueryThen foo.id has your last inserted id. DK
On
...
-Original Message-From: [EMAIL PROTECTED]
[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
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. Thanks f
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
ARe you placing your output as such
cfoutput query=getIDs
#ID#
/cfoutput
or
cfoutput
#getIDs.ID#
/cfoutput
or some other way?
The firstexample 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
I've tried both ways and they both produce the same result.Precia [EMAIL PROTECTED] wrote:ARe you placing your output as suchcfoutput query="getIDs" #ID# /cfoutputor cfoutput #getIDs.ID# /cfoutputor some other way?The firstexample will return all rows. The second
I tried something like that. Didn't work. Thanks though.Dan Kaufman [EMAIL PROTECTED] wrote:How about adding a WHERE clause which is always true for all records, such as:WHERE 1 = 1 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff HowardSent:
Totally WAG, but try select id as my_id from The column name
may be the problem you're having. You'd then output #my_id# in the
cfoutput block.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
Here in America everything is bought and sold, you can get anything
for little bits of
And are you sure Sysmods is the correct DB? Are you connecting to
the same DB with enterprise manager?
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
Great spirits have often encountered violent opposition from weak
minds.
--Einstein
On Oct 3, 2006, at 12:53 PM, Jeff Howard wrote:
Besides the other helpful suggestions so far, do
you have debugging turned on, to see how many records are being returned
in the resultset?
More important, If the issue is really that it's just
returning 1 record, then the question could be one of security and
authorization, in SQL I mean.
In the datasource, do you have Maintain
connections across client requests? If so, uncheck it, save the changes to the
datasource and then run your query again. If you get different results, you
may be running into a query caching issue.
From: [EMAIL PROTECTED]
[mailto:[EMAIL
Yes, absolutely positive. I am getting a return, just 1 row instead of 10 and it was working this morning."Dean H. Saxe" [EMAIL PROTECTED] wrote: And are you sure Sysmods is the correct DB? Are you connecting to the same DB with enterprise manager?-dhsDean H. Saxe, CISSP, CEH[EMAIL
SELECT count(*) as counter from test... then output the value of
counter. If its 1, you have 1 row and you're looking at the wrong DB.
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
What difference does it make to the dead, the orphans, and the
homeless, whether the mad destruction is
maintain connections... has nothing to do with query caching. Its
caching connections, not data.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
What is objectionable, what is dangerous about extremists is not
that they are extreme, but that they are intolerant.
-- Robert F. Kennedy,
query.
-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 caching
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 working.This is obviously not a good situation once the project I'm working on is live.Any
@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 working
] Issue with return from cfquery
maintain connections... has nothing to do with query caching. Its
caching connections, not data.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
What is objectionable, what is dangerous about extremists is not
that they are extreme, but that they are intolerant
Is this portion a typo wher there exists a space in the #ID#? Also, try #getIDs.ID#.cfoutput query=getIDs #getIDs.recordcount# --# ID# br
/cfoutputTeddyOn 10/3/06, Jeff Howard [EMAIL PROTECTED] wrote:
No offense taken, I thought I explained it fairly clearly.In any case, maybe this will help
The inserts for 2 - 10 were not committed in the db?
Otherwise, someone's messing with you. :)
mf
Jeff Howard wrote:
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
:
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
Return Receipt
Your Re: [ACFUG Discuss] Issue with return from cfquery
document
Return Receipt
Your Re: [ACFUG Discuss] Issue with return from cfquery
document
-
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
snip
This test app all of a sudden started functioning properly as well when
I hit refresh
] 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,
cfqueryparam explicitly prevents caching of result sets.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
What difference does it make to the dead
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
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 "really is que
Yeah, and here I broke out themusket 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 return
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 database". Once again, I've never used SQL Pro
31 matches
Mail list logo
