Ok, I saw it return all records the first couple of times I looked at it when I was trying to figure it out. Then it started returning one record while I was toying with it trying to figure out what was what. As far as what account is being used, all I see is a "LoginName" on the screen that I
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 return
f
Great. Thanks for sharing. Just didn't know if the earlier
message was missed.
OK, so if it is really querying the database, how many
records do you see it returning? 1 or 10? Are you back to this circumstance
where the problem is happening again? And recall I had also asked a question
abo
Yes now it came to me … many thanks
Dan and Mary Catherine J
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dan
Kaufman
Sent: Tuesday, October 03, 2006
4:52 PM
To: discussion@acfug.org
Subject: RE: [ACFUG Discuss] css -
a little off topic
Dusty,
Mary C
Dan - I have to disagree with you :) As someone who has been doing html since it started, my advice is always to either:a. work in IE because if you get it right there, you can get it right anywhereb. check both at the same time.Checking Firefox only will cause more time/work on you in the long run
Dusty,
Mary Catherine is right about adding to
the CSS definition text-align: center; (I was a little too quick in my
reply)
#MyDiv
{
margin-left: auto;
margin-right: auto;
}
Body
{
text-align: center;
}
In general remember Go
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
That's exactly what I was trying to say.
I've seen it most often happen with the use of cfqueryparam. You could take
out the cfqueryparam statements and get the expected result set back, but as
soon as you put them back in, you got the cached result.
Unchecking the maintain connections box force
/me gets out the battering ram ;-)
No, you're right Charlie, I was referring to result sets and the
cachedwithin/cachedafter parameters of .
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"[T]he people can always be brought to the bidding of the leaders.
This is easy. All you have to do
Awww... no fight? I was going
to suggest mud wrastling. Ya'll are no fun! ;-)
mcg
"Dean H. Saxe"
<[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
10/03/2006 04:11 PM
Please respond to
discussion@acfug.org
To
discussion@acfug.org
cc
Subject
Re: [ACFUG Discuss] Issue with retur
margin-left: auto;
margin-right: auto;
width: 50em;
this will center a fixed width element (of 50em wide,
or it could be say 750px,….
If you want it “liquid” (the side margins
to be a set width and the middle to expand/contract with screen size)
margin-left: 10%;
margin-ri
I believe that you have to use margin:
auto (or at least right and left) for it to play nice in IE. You
may also have to put a container around your div with text-align:center.
Or you can add that to your BODY tag. (I'm a little rusty on this
myself)
mcg
Dusty Hale <[EMAIL PROTECTED]>
Se
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 caching of result sets",
and I think I know what you're getting at, but perhaps some may
misunderstand.
Use of CFQUERYPARAM doesn't "prevent caching of
Does anyone know how to center a div using css? I should
know this and maybe just forgot. Google search only produces reference to the
text-align property. I want to center the box on the page not the content
inside the box. For example
Hello World
---
/* css co
Jeff, you still haven't confirmed your use of two of the diagnostics I
proposed: what does the debugging output say for the CFQUERY? And more
important, to rule out all this debate about caching in CFML or the
database, what does the SQL Profiler tell you? You can watch live while the
queries come
I agree, this is a basic connectivity issue more than
likely. You may assume nothing has changed but take a careful look
at your datasource settings. Is it connecting to a server name? Ping that
name. Does it response with the expect IP address? You may be connecting to
something else and no
Just fyi for everyone, please turn off auto-receipt when posting to the
ACFUG lists. It causes a lot of unnecessary traffic and is a problem at
times.
John
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
[EMAIL PROTECTED]
Sent: Tuesd
Here is another long shot but I had this happen to me.
Try
SELECT
ID FROM DBO.test
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of [EMAIL PROTECTED]Sent: Tuesday, October 03,
2006 2:15 PMTo: discussion@acfug.orgSubject: RE: [ACFUG
Discuss] Issue with return from cfqu
Return Receipt
Your Re: [ACFUG Discuss] Issue with return from cfquery
document:
Return Receipt
Your Re: [ACFUG Discuss] Issue with return from cfquery
document:
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:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent:
Tuesday, October 03, 2006 2:09
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
Is this portion a typo wher there exists a space in the #ID#? Also, try #getIDs.ID#. #getIDs.recordcount# --# ID#< br>
TeddyOn 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 clarify the issue. Ted
It did this when I created a brand new table with a brand new .cfm with a brand new query in it so that leads me to believe that it's not a caching issue.[EMAIL PROTECTED] wrote: Possibly the caching of the class files via CFthat's a long shot though as that really shouldn't affect the que
Ben,
explicitly prevents caching of result sets.
-dhs
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 wrought under the name of
totalitarianism or the holy name of liberty and democracy?
No offense taken, I thought I explained it fairly clearly. In any case, maybe
this will help clarify the issue.
Teddy Payne <[EMAIL PROTECTED]> wrote:
Jeff,
Saying that "it worked this morning" is not really the information needed to
troubleshoot a problem remotely. Plase take no offe
Possibly the caching of the class files via CFthat's a long shot
though as that really shouldn'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@acf
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. A
Maybe I have the wording wrong, but I have seen the exact same result set
returned when was used in a query with different values.
Breaking the connection in the datasource cleared it up.
Sql Server will also cache result sets if it gets requests for what it
thinks is the exact same query.
-
Jeff,Saying that "it worked this morning" is not really the information needed to troubleshoot a problem remotely. Plase take no offense by that statement if it sounded harsh.From this thread, I have seen about three people ask if you have opened up the database and the values in the table you are
"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. Kenne
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 wrough
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 PROTECTED]"G
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
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.
No luck with this approach either. The thing is, the query actually was working this morning. I was getting all rows returned and then it all of a sudden started returning only 1 row. I have no idea what would make this happen. I re-booted. Tried a different browser."Dean H. Saxe" <[EMAI
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
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
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 gold.
We'l
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 How
Thanks, but still only 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]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 12:32 PMTo: discussion
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
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
Howard
Sent: Tuesday, October 03, 2006
9:32 AM
To: discussion@acfug.org
Subject: [ACFUG Discuss] Issue
with
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 wha
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
