RE: [ACFUG Discuss] Issue with return from cfquery
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'm looking at and it is 'sysmod' which is the DB name. Any more detail you could provide me with here would help since this is my first time using Profiler. Thanks, once again. jeffCharlie Arehart <[EMAIL PROTECTED]> wrote: 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 about security. Now, since you said this is coming and going, I'm less inclined to think it's about security. The credentials used in the DSN or in your login to enterprise manager (and records authorized to that account) shouldn't be changing much, but it seems worth at least double-checking. Again, rather than wait until you have access to the Admin, this is something that SQL Profiler should be able to tell you (what account is being used to access records). Hope all that gets you further down the field. /charlie http://www.carehart.org/blog/ From: [EMAIL 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 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 Profiler but I'm pretty positive that I've figured this part out. As far as the CF debugging tool, we had a problem with the email server and my login was in an email that was deleted off the server and I can't get to the CF Admin right now. As soon as I get the login I can take that step. I was hoping that maybe somebody has had this issue and had a fix/advice on how to correct/remedy the problem. Once again, thanks. Jeff- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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 from cfquery Awww... no fight? I was going to suggest mud wrastling. Ya'll are no fun! ;-) mcg - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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 about security. Now, since you said this is coming and going, I'm less inclined to think it's about security. The credentials used in the DSN or in your login to enterprise manager (and records authorized to that account) shouldn't be changing much, but it seems worth at least double-checking. Again, rather than wait until you have access to the Admin, this is something that SQL Profiler should be able to tell you (what account is being used to access records). Hope all that gets you further down the field. /charlie http://www.carehart.org/blog/ From: [EMAIL 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 "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 problem with the email server and my login was in an email that was deleted off the server and I can't get to the CF Admin right now. As soon as I get the login I can take that step. I was hoping that maybe somebody has had this issue and had a fix/advice on how to correct/remedy the problem. Once again, thanks. Jeff - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] css - a little off topic
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 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 Google is your friend. Just Google for CSS Center Next, remember you can always View/Page Source for any web page. You see a site that uses CSS, view the page source, if the style sheet is “linked” just copy the path, it will be in the section, paste this back into your browser and you’ll be looking at their CSS for that page/site. Study it to see how they positioned and styled elements, etc. The biggest headache you’ll have is with IE. The problem here is IE often follows its own rules and not strict W3C guidelines. So you’ll do a page, developing with IE and think GREAT it works, only to see the site with Netscape or Firefox and it has blown up. This has been my personal nemesis. Until I SWITCHED TO FIREFOX. It really is a better browser. Now I develop my CSS using Firefox and then “tweak” it to work with IE’s quirks. Good luck, Dan Kaufman From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 1:12 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] css - a little off topic 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]> Sent by: [EMAIL PROTECTED] 10/03/2006 03:59 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] css - a little off topic 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 code */ #mydiv { What goes here to make the div box centered on the page. } Many thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
Re: [ACFUG Discuss] css - a little off topic
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.Of course, as my first professor said, there are 1,000 ways to utica. :)Also, technically to save a line of code - you could bring the margin-left and right into one line of code. And you could also do:margin: top right bottom leftso a typical default is:margin: 0 auto auto auto-- Allenhttp://www.htmlcenter.comhttp://www.centernetworks.com- Original Message From: Dan Kaufman <[EMAIL PROTECTED]>To: discussion@acfug.orgSent: Tuesday, October 3, 2006 4:51:48 PMSubject: RE: [ACFUG Discuss] css - a little off topic 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 Google is your friend. Just Google for CSS Center Next, remember you can always View/Page Source for any web page. You see a site that uses CSS, view the page source, if the style sheet is “linked” just copy the path, it will be in the section, paste this back into your browser and you’ll be looking at their CSS for that page/site. Study it to see how they positioned and styled elements, etc. The biggest headache you’ll have is with IE. The problem here is IE often follows its own rules and not strict W3C guidelines. So you’ll do a page, developing with IE and think GREAT it works, only to see the site with Netscape or Firefox and it has blown up. This has been my personal nemesis. Until I SWITCHED TO FIREFOX. It really is a better browser. Now I develop my CSS using Firefox and then “tweak” it to work with IE’s quirks. Good luck, Dan Kaufman From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 1:12 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] css - a little off topic 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]> Sent by: [EMAIL PROTECTED] 10/03/2006 03:59 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] css - a little off topic 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 code */ #mydiv { What goes here to make the div box centered on the page. } Many thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] css - a little off topic
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 Google is your friend. Just Google for CSS Center Next, remember you can always View/Page Source for any web page. You see a site that uses CSS, view the page source, if the style sheet is “linked” just copy the path, it will be in the section, paste this back into your browser and you’ll be looking at their CSS for that page/site. Study it to see how they positioned and styled elements, etc. The biggest headache you’ll have is with IE. The problem here is IE often follows its own rules and not strict W3C guidelines. So you’ll do a page, developing with IE and think GREAT it works, only to see the site with Netscape or Firefox and it has blown up. This has been my personal nemesis. Until I SWITCHED TO FIREFOX. It really is a better browser. Now I develop my CSS using Firefox and then “tweak” it to work with IE’s quirks. Good luck, Dan Kaufman From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 1:12 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] css - a little off topic 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]> Sent by: [EMAIL PROTECTED] 10/03/2006 03:59 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] css - a little off topic 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 code */ #mydiv { What goes here to make the div box centered on the page. } Many thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
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 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 problem with the email server and my login was in an email that was deleted off the server and I can't get to the CF Admin right now. As soon as I get the login I can take that step. I was hoping that maybe somebody has had this issue and had a fix/advice on how to correct/remedy the problem. Once again, thanks. Jeff Charlie Arehart <[EMAIL PROTECTED]> wrote: Jeff, you still haven't confirmed your use of two of the diagnostics Iproposed: what does the debugging output say for the CFQUERY? And moreimportant, to rule out all this debate about caching in CFML or thedatabase, what does the SQL Profiler tell you? You can watch live while thequeries come into SQL Server based on the CF page being hit. If it reallydoes a query, then you know that it "really is querying the database". If itwere to leverage a cached result "in the database", it would tell you it'sdoing that as well. This really is your best tool.If it's that you're not familiar with it and are reluctant to explore thispage, do just say so. I'm sure many can point out excellent resources to getyou started. You could have your answer--and much more compellingdiagnostics rather than all this guessing--in minutes./charliehttp://www.carehart.org/blog/ Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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 forces some sort of flush, and everything goes back to returning the expected result set. You can immediately recheck the maintain connections box after one run of the page and everything is fine again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf 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 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 resultsets". It does indeed preclude the *use* of the CachedWithin or CachedAfter attributes in CFQUERY (in CFMX, that is, not in BlueDragon), so in that sense it "prevents" you trying to use cached results. On the other hand, when Benjamin notes that use of CFQUERYPARAM could lead to seeming caching of results, I could see that *possibly* being related to an entirely different kind of caching: the caching within the database of the Query Execution Plan. CFQUERYPARAM does indeed cause the SQL engine to use "bind parameters" which lead the database to try to cache the execution plan for the query. That said, I don't think it should really cause the caching of the *resultset* ever returned from such a cached query execution plan, though someone with more experience may correct us on any of these matters. I just wanted to put in a defense for what Benjamin may have been 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/ -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 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? " --Gandhi On Oct 3, 2006, at 1:41 PM, Benjamin Bloodworth wrote: > 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. > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Issue with return from cfquery
/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 is to tell them they are being attacked, and denounce the pacifists for lack of patriotism and exposing the country to danger. It works the same in every country." --Hermann Goering, Hitler's Reich-Marshall at the Nuremberg Trials On Oct 3, 2006, at 4:03 PM, Charlie Arehart wrote: 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 resultsets". It does indeed preclude the *use* of the CachedWithin or CachedAfter attributes in CFQUERY (in CFMX, that is, not in BlueDragon), so in that sense it "prevents" you trying to use cached results. On the other hand, when Benjamin notes that use of CFQUERYPARAM could lead to seeming caching of results, I could see that *possibly* being related to an entirely different kind of caching: the caching within the database of the Query Execution Plan. CFQUERYPARAM does indeed cause the SQL engine to use "bind parameters" which lead the database to try to cache the execution plan for the query. That said, I don't think it should really cause the caching of the *resultset* ever returned from such a cached query execution plan, though someone with more experience may correct us on any of these matters. I just wanted to put in a defense for what Benjamin may have been 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/ -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 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? " --Gandhi On Oct 3, 2006, at 1:41 PM, Benjamin Bloodworth wrote: 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. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Issue with return from cfquery
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 return from cfquery /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 is to tell them they are being attacked, and denounce the pacifists for lack of patriotism and exposing the country to danger. It works the same in every country." --Hermann Goering, Hitler's Reich-Marshall at the Nuremberg Trials On Oct 3, 2006, at 4:03 PM, Charlie Arehart wrote: > 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 resultsets". It > does indeed > preclude the *use* of the CachedWithin or CachedAfter attributes in > CFQUERY > (in CFMX, that is, not in BlueDragon), so in that sense it > "prevents" you > trying to use cached results. > > On the other hand, when Benjamin notes that use of CFQUERYPARAM > could lead > to seeming caching of results, I could see that *possibly* being > related to > an entirely different kind of caching: the caching within the > database of > the Query Execution Plan. CFQUERYPARAM does indeed cause the SQL > engine to > use "bind parameters" which lead the database to try to cache the > execution > plan for the query. That said, I don't think it should really cause > the > caching of the *resultset* ever returned from such a cached query > execution > plan, though someone with more experience may correct us on any of > these > matters. > > I just wanted to put in a defense for what Benjamin may have been > 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/ > > -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 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? " > --Gandhi > > > On Oct 3, 2006, at 1:41 PM, Benjamin Bloodworth wrote: > >> 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. >> > > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by http://www.fusionlink.com > - > > > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] css - a little off topic
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-right: 10%; Dan K. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dusty Hale Sent: Tuesday, October 03, 2006 12:59 PM To: discussion@acfug.org Subject: [ACFUG Discuss] css - a little off topic 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 code */ #mydiv { What goes here to make the div box centered on the page. } Many thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
Re: [ACFUG Discuss] css - a little off topic
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]> Sent by: [EMAIL PROTECTED] 10/03/2006 03:59 PM Please respond to discussion@acfug.org To discussion@acfug.org cc Subject [ACFUG Discuss] css - a little off topic 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 code */ #mydiv { What goes here to make the div box centered on the page. } Many thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
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 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 resultsets". It does indeed preclude the *use* of the CachedWithin or CachedAfter attributes in CFQUERY (in CFMX, that is, not in BlueDragon), so in that sense it "prevents" you trying to use cached results. On the other hand, when Benjamin notes that use of CFQUERYPARAM could lead to seeming caching of results, I could see that *possibly* being related to an entirely different kind of caching: the caching within the database of the Query Execution Plan. CFQUERYPARAM does indeed cause the SQL engine to use "bind parameters" which lead the database to try to cache the execution plan for the query. That said, I don't think it should really cause the caching of the *resultset* ever returned from such a cached query execution plan, though someone with more experience may correct us on any of these matters. I just wanted to put in a defense for what Benjamin may have been 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/ -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 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? " --Gandhi On Oct 3, 2006, at 1:41 PM, Benjamin Bloodworth wrote: > 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. > - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
[ACFUG Discuss] css - a little off topic
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 code */ #mydiv { What goes here to make the div box centered on the page. } Many thanks, Dusty - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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 into SQL Server based on the CF page being hit. If it really does a query, then you know that it "really is querying the database". If it were to leverage a cached result "in the database", it would tell you it's doing that as well. This really is your best tool. If it's that you're not familiar with it and are reluctant to explore this page, do just say so. I'm sure many can point out excellent resources to get you started. You could have your answer--and much more compelling diagnostics rather than all this guessing--in minutes. /charlie 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 sudden started functioning properly as well when I hit refresh on the browser after lunch. So my issue now is, what are possible causes of this behavior? - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Issue with return from cfquery
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 not realize it. If you have other servers running a copy of this sql server database, turn them off and see what the results are. John [EMAIL PROTECTED] 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 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:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 2:09 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfqueryIt 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 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 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 new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart <[EMAIL PROTECTED]> 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. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jef
[ACFUG Discuss] Auto-receipt
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: Tuesday, October 03, 2006 2:40 PM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] Issue with return from cfquery Return Receipt Your Re: [ACFUG Discuss] Issue with return from cfquery document: wasCraig Nassal/ATL/FRS received by: at:10/03/2006 02:39:35 PM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Issue with return from cfquery
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 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:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 2:09 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfqueryIt 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 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 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 new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart <[EMAIL PROTECTED]> 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. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive
Re: [ACFUG Discuss] Issue with return from cfquery
Return Receipt Your Re: [ACFUG Discuss] Issue with return from cfquery document: wasCraig Nassal/ATL/FRS received by: at:10/03/2006 02:39:35 PM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Issue with return from cfquery
Return Receipt Your Re: [ACFUG Discuss] Issue with return from cfquery document: wasShawn Gorrell/ATL/FRS received by: at:10/03/2006 02:33:54 PM - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
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:[EMAIL PROTECTED]On Behalf Of Jeff HowardSent: Tuesday, October 03, 2006 2:09 PMTo: discussion@acfug.orgSubject: RE: [ACFUG Discuss] Issue with return from cfqueryIt 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 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 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 new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart <[EMAIL PROTECTED]> 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. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://w
Re: [ACFUG Discuss] Issue with return from cfquery
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 on the page and it started working. This is obviously not a good situation once the project I'm working on is live. Any new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart <[EMAIL PROTECTED]> 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. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /charlie http://www.carehart.org/blog/ 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: 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
Re: [ACFUG Discuss] Issue with return from cfquery
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. 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 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 querying has more than 1 value? Yes, by working I meant that it accessed the table and returned all the rows I requested. Thus, all connections were correct and functioning this morning. Then all of sudden it started returning just 1 record instead of the multiple records it was returning a half-hour earlier. No change to the .cfm file, just a change in the output. When this app quit working I created a new table called "Test" with one column called "ID" and 10 rows with a value of "1-10" for ID. SELECT IDFROM test #getIDs.recordcount# --# ID#< br> I had the same issue with this table that I created just to test if there was something I was missing in my other app. I broke it down to 1 extremely simple table with 1 extremely simple query and still only got the 1st record. This "test app" all of a sudden started functioning properly as well when I hit refresh on the browser after lunch. So my issue now is, what are possible causes of this behavior?The reason also that it sounds incredulous to most of us is that CF really makes it easy to query a database if you have the correct database connection set up in your CF Administrator. We are just looking for more information to assist you,Teddy On 10/3/06, Jeff Howard <[EMAIL PROTECTED]> wrote: 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 tothe same DB with enterprise manager? -dhsDean H. Saxe, CISSP, CEH[EMAIL PROTECTED]"Great spirits have often encountered violent opposition from weakminds." --EinsteinOn Oct 3, 2006, at 12:53 PM, Jeff Howard wrote:> 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 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>>> 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.>> When I run this in a browser it is only returning the first> record. When I copy and paste the query into Enterprise Manager > and Query Analyzer and it returns all 10 rows.>> The script I was running when this problem first surface ran fine> several times this morning and all of a sudden it quit working. It> was returning all records from the table and then I ran it again > and this problem popped up. I couldn't figure out what was> happening so I built a little test table and test script and I'm> getting the same problems. This makes me believe it is a CF> problem and not a SQL Server problem. >> Any ideas?>> From what I've gathered since joining a few months ago, someone> always knows the answer in this group.>> Thanks,> Jeff Howard> Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail.> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink> ->> - > To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink> - >> Stay in the know. Pulse on the new Yahoo.com . Check it out.> -> To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink>
RE: [ACFUG Discuss] Issue with return from cfquery
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 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 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 new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart <[EMAIL PROTECTED]> 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. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail.
Re: [ACFUG Discuss] Issue with return from cfquery
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? " --Gandhi On Oct 3, 2006, at 1:41 PM, Benjamin Bloodworth wrote: 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. -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. 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, 1964 On Oct 3, 2006, at 1:14 PM, Benjamin Bloodworth wrote: 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 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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Issue with return from cfquery
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 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 querying has more than 1 value? Yes, by working I meant that it accessed the table and returned all the rows I requested. Thus, all connections were correct and functioning this morning. Then all of sudden it started returning just 1 record instead of the multiple records it was returning a half-hour earlier. No change to the .cfm file, just a change in the output. When this app quit working I created a new table called "Test" with one column called "ID" and 10 rows with a value of "1-10" for ID. SELECT ID FROM test #getIDs.recordcount# --# ID#< br> I had the same issue with this table that I created just to test if there was something I was missing in my other app. I broke it down to 1 extremely simple table with 1 extremely simple query and still only got the 1st record. This "test app" all of a sudden started functioning properly as well when I hit refresh on the browser after lunch. So my issue now is, what are possible causes of this behavior? The reason also that it sounds incredulous to most of us is that CF really makes it easy to query a database if you have the correct database connection set up in your CF Administrator. We are just looking for more information to assist you, Teddy On 10/3/06, Jeff Howard <[EMAIL PROTECTED]> wrote: 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? -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: > 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] 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 > 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. > > When I run this in a browser it is only returning the first > record. When I copy and paste the query into Enterprise Manager > and Query Analyzer and it returns all 10 rows. > > The script I was running when this problem first surface ran fine > several times this morning and all of a sudden it quit working. It > was returning all records from the table and then I ran it again > and this problem popped up. I couldn't figure out what was > happening so I built a little test table and test script and I'm > getting the same problems. This makes me believe it is a CF > problem and not a SQL Server problem. > > Any ideas? > > From what I've gathered since joining a few months ago, someone > always knows the answer in this group. > > Thanks, > Jeff Howard > Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail. > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > - > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > - > > Stay in the know. Pulse on the new Yahoo.com . Check it out. > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > --
RE: [ACFUG Discuss] Issue with return from cfquery
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@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. This is obviously not a good situation once the project I'm working on is live. Any new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart <[EMAIL PROTECTED]> 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. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discus
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. This is obviously not a good situation once the project I'm working on is live. Any new ideas on why it would all of a sudden start only returning 1 record instead of multiple records and then fix itself to start returning all records? I am the only one here today working on this server or with these scripts. Ideas? Charlie Arehart <[EMAIL PROTECTED]> 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. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Get your own web address for just $1.99/1st yr. We'll help. Yahoo! Small Business. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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. -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. 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, 1964 On Oct 3, 2006, at 1:14 PM, Benjamin Bloodworth wrote: > 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 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 >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. > > > > When I run this in a browser it is only returning the first > record. When I copy and paste the query into Enterprise Manager > and Query Analyzer and it returns all 10 rows. > > > > The script I was running when this problem first surface ran fine > several times this morning and all of a sudden it quit working. It > was returning all records from the table and then I ran it again > and this problem popped up. I couldn't figure out what was > happening so I built a little test table and test script and I'm > getting the same problems. This makes me believe it is a CF > problem and not a SQL Server problem. > > > > Any ideas? > > > > From what I've gathered since joining a few months ago, someone > always knows the answer in this group. > > > > Thanks, > > Jeff Howard > > > > Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail. > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > - > > > - > To unsubscribe from this list, manage your profile @ > http://www.acfug.org?fa=login.edituserform > > For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/ > List hosted by FusionLink > - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Issue with return from cfquery
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 querying has more than 1 value? The reason also that it sounds incredulous to most of us is that CF really makes it easy to query a database if you have the correct database connection set up in your CF Administrator.We are just looking for more information to assist you, TeddyOn 10/3/06, Jeff Howard <[EMAIL PROTECTED]> wrote: 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] "Great spirits have often encountered violent opposition from weak minds."--EinsteinOn Oct 3, 2006, at 12:53 PM, Jeff Howard wrote:> 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 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 > >> 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.> > When I run this in a browser it is only returning the first > record. When I copy and paste the query into Enterprise Manager > and Query Analyzer and it returns all 10 rows.>> The script I was running when this problem first surface ran fine > several times this morning and all of a sudden it quit working. It > was returning all records from the table and then I ran it again > and this problem popped up. I couldn't figure out what was > happening so I built a little test table and test script and I'm > getting the same problems. This makes me believe it is a CF > problem and not a SQL Server problem. >> Any ideas?>> From what I've gathered since joining a few months ago, someone > always knows the answer in this group.>> Thanks,> Jeff Howard> Do you Yahoo!? > Everyone is raving about the all-new Yahoo! Mail.> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink > ->> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink > ->> Stay in the know. Pulse on the new Yahoo.com . Check it out.> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists > Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink > --To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - -- Blog: http://cfpayne.wordpress.com/Atlanta CFUG: http://www.acfug.org
Re: [ACFUG Discuss] 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." -- Robert F. Kennedy, 1964 On Oct 3, 2006, at 1:14 PM, Benjamin Bloodworth wrote: 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 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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Issue with return from cfquery
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 wrought under the name of totalitarianism or the holy name of liberty and democracy? " --Gandhi On Oct 3, 2006, at 12:57 PM, Jeff Howard wrote: 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 Howard Sent: Tuesday, October 03, 2006 9:32 AM 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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Issue with return from cfquery
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]"Great spirits have often encountered violent opposition from weak minds."--EinsteinOn Oct 3, 2006, at 12:53 PM, Jeff Howard wrote:> 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] 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> 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.>> When I run this in a browser it is only returning the first > record. When I copy and paste the query into Enterprise Manager > and Query Analyzer and it returns all 10 rows.>> The script I was running when this problem first surface ran fine > several times this morning and all of a sudden it quit working. It > was returning all records from the table and then I ran it again > and this problem popped up. I couldn't figure out what was > happening so I built a little test table and test script and I'm > getting the same problems. This makes me believe it is a CF > problem and not a SQL Server problem.>> Any ideas?>> From what I've gathered since joining a few months ago, someone > always knows the answer in this group.>> Thanks,> Jeff Howard> Do you Yahoo!?> Everyone is raving about the all-new Yahoo! Mail.> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink> ->> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink> ->> Stay in the know. Pulse on the new Yahoo.com. Check it out.> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink> --To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com- Talk is cheap. Use Yahoo! Messenger to make PC-to-Phone calls. Great rates starting at 1¢/min. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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 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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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. I'm pretty sure it's possible to restrict people to see only the records they're authorized to see. When you login to Enterprise Manager, do you log in with the same account as is being used in the setup of this datasource in the CF Admin console? If you have no control over the DSN setup, since you do have access to Enterprise Manager, turn on the SQL Profiler to see what authentication is being used when the request comes into SQL Server from CF. And do the same to watch the Query Analyzer request you make. It may tell you where and why things are different. /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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
Re: [ACFUG Discuss] Issue with return from cfquery
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" <[EMAIL PROTECTED]> 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.-dhsDean H. Saxe, CISSP, CEH[EMAIL PROTECTED]Here in America everything is bought and sold, you can get anything for little bits of gold.We'll rape the earth and ruin the air, cut down every tree from here to there.-- Donna The Buffalo "America"On Oct 3, 2006, at 12:53 PM, Jeff Howard wrote:> 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] 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> 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.>> When I run this in a browser it is only returning the first > record. When I copy and paste the query into Enterprise Manager > and Query Analyzer and it returns all 10 rows.>> The script I was running when this problem first surface ran fine > several times this morning and all of a sudden it quit working. It > was returning all records from the table and then I ran it again > and this problem popped up. I couldn't figure out what was > happening so I built a little test table and test script and I'm > getting the same problems. This makes me believe it is a CF > problem and not a SQL Server problem.>> Any ideas?>> From what I've gathered since joining a few months ago, someone > always knows the answer in this group.>> Thanks,> Jeff Howard> Do you Yahoo!?> Everyone is raving about the all-new Yahoo! Mail.> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink> ->> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink> ->> Stay in the know. Pulse on the new Yahoo.com. Check it out.> -> To unsubscribe from this list, manage your profile @> http://www.acfug.org?fa=login.edituserform>> For more info, see http://www.acfug.org/mailinglists> Archive @ http://www.mail-archive.com/discussion%40acfug.org/> List hosted by FusionLink> --To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserformFor more info, see http://www.acfug.org/mailinglistsArchive @ http://www.mail-archive.com/discussion%40acfug.org/List hosted by http://www.fusionlink.com- Yahoo! Messenger with Voice. Make PC-to-Phone Calls to the US (and 30+ countries) for 2¢/min or less. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
Re: [ACFUG Discuss] Issue with return from cfquery
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: 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] 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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Stay in the know. Pulse on the new Yahoo.com. Check it out. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
Re: [ACFUG Discuss] Issue with return from cfquery
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'll rape the earth and ruin the air, cut down every tree from here to there. -- Donna The Buffalo "America" On Oct 3, 2006, at 12:53 PM, Jeff Howard wrote: 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] 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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Stay in the know. Pulse on the new Yahoo.com. Check it out. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -
RE: [ACFUG Discuss] Issue with return from cfquery
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: 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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks,Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - All-new Yahoo! Mail - Fire up a more powerful email and get things done faster. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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@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 is happening to a more complex table that is having the same issue. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Stay in the know. Pulse on the new Yahoo.com. Check it out. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
Re: [ACFUG Discuss] Issue with return from cfquery
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. Precia On 10/3/06, Jeff Howard <[EMAIL PROTECTED]> wrote: 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - Do you Yahoo!? Get on board. You're invited to try the new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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 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 happening to a more complex table that is having the same issue. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
Re: [ACFUG Discuss] Issue with return from cfquery
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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
RE: [ACFUG Discuss] Issue with return from cfquery
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 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. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!?Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink - - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -
[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 is happening to a more complex table that is having the same issue. When I run this in a browser it is only returning the first record. When I copy and paste the query into Enterprise Manager and Query Analyzer and it returns all 10 rows. The script I was running when this problem first surface ran fine several times this morning and all of a sudden it quit working. It was returning all records from the table and then I ran it again and this problem popped up. I couldn't figure out what was happening so I built a little test table and test script and I'm getting the same problems. This makes me believe it is a CF problem and not a SQL Server problem. Any ideas? From what I've gathered since joining a few months ago, someone always knows the answer in this group. Thanks, Jeff Howard Do you Yahoo!? Everyone is raving about the all-new Yahoo! Mail. - To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink -