Re: Anyone else had this problem before?
Thanks everyone. turns out that you all were right I simpy had to change datatypes in my database (duh). thanks again, nelson Original Message Follows From: "t nelson" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Subject: Anyone else had this problem before? Date: Tue, 23 Jan 2001 21:45:56 - Received: from [207.31.122.140] by hotmail.com (3.2) with ESMTP id MHotMailBC374795006CD820F3B8CF1F7A8CB43456; Tue Jan 23 14:00:36 2001 Received: from houseoffusion.com ([207.31.122.140]) by www.houseoffusion.com (Post.Office MTA v3.5.3 release 223 ID# 0-54969U100L100S0V35) with ESMTP id com for [EMAIL PROTECTED]; Tue, 23 Jan 2001 16:58:22 -0500 From [EMAIL PROTECTED] Tue Jan 23 14:01:24 2001 Message-id: [EMAIL PROTECTED] Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Anyone else had this problem before?
What type of variable do you have UsersTotalPrice set to in the db? (e.g. nvarchar, money, etc.) --=@ greg @=-- - Original Message - From: "t nelson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 4:45 PM Subject: Anyone else had this problem before? Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anyone else had this problem before?
cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery Change the query to: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID IN (#UsersID#) ORDER BY UsersTotalPrice /cfquery Another developer had the same problem. As long as the UsersID list is only 1 long, you have noerrors, if it gets longer, then you get errors. Russel Madere, Jr. Senior Web Developer ICQ: 5446158 http://www.TurboSquid.com Some days you eat the bear; some days the bear eats you. -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 15:46 To: CF-Talk Subject: Anyone else had this problem before? Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anyone else had this problem before?
$5 says your UsersTotalPrice column is a text datatype, and not an integer. Change it to a number (int) datatype in the database, and it will be ordered correctly. -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 4:46 PM To: CF-Talk Subject: Anyone else had this problem before? Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Anyone else had this problem before?
try this cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY cast(UsersTotalPrice as decimal) /cfquery - Original Message - From: "t nelson" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 3:45 PM Subject: Anyone else had this problem before? Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Anyone else had this problem before?
At 09:45 PM 1/23/01 +, you wrote: Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? It seems like your datatype on that field is set to text instead of numeric. Now announcing my newly updated website http://www.blivit.org/mr_urc/index.cfm Resume: http://www.blivit.org/mr_urc/resume.cfm ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anyone else had this problem before?
Is your datatype for the table field "UsersTotalPrice" small money or money? -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 3:46 PM To: CF-Talk Subject: Anyone else had this problem before? Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Anyone else had this problem before?
I'll bet you $10 your correct. :) Jay Patton Web Pro USA 406.549.3337 ext. 203 1.888.5WEBPRO www.webpro-usa.com - Original Message - From: "Cameron Childress" [EMAIL PROTECTED] To: "CF-Talk" [EMAIL PROTECTED] Sent: Tuesday, January 23, 2001 3:13 PM Subject: RE: Anyone else had this problem before? $5 says your UsersTotalPrice column is a text datatype, and not an integer. Change it to a number (int) datatype in the database, and it will be ordered correctly. -Cameron Cameron Childress elliptIQ Inc. p.770.460.7277.232 f.770.460.0963 -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 23, 2001 4:46 PM To: CF-Talk Subject: Anyone else had this problem before? Hi All, I was just wondering if anyone out there had this problem before and what they did to correct it? Here's what I am trying to do: cfquery name="qryName" datasource="MyDatasource" SELECT UsersID, UsersTotalPrice FROM TableName WHERE UsersID = (#UsersID#) ORDER BY UsersTotalPrice /cfquery cfoutput query="qryName" tr td#UsersID#/td td#DollarFormat(UsersTotalPrice)#/td /tr /cfoutput Here is the problem: when the data outputs it is sorting it by the first digit instead of giving me a true sort from highest to lowest cost. for example. $1,000.00 $20,000.00*** (this record should be at the bottom but its not) $8,000.00 $9,000.00 I have rerun the query in both my query analyzer and in access. both times the query returns the correct results in the proper format. 1,000.00 8,000.00 9,000.00 20,000.00 Has anyone out there had a similar experience with this or know of someway to correct this? Thanks in advance, Nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Anyone else had this problem before?
Don't store numeric data in a text field. That should fix your problem. R ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anyone else had this problem before?
Do you mean in the source or the displayed HTML? I'm not sure of the question. If you mean the source, look at your cfoutput statement as being a loop. Every time your code goes through the loop, it executes the code as if there were multiple lines. The line that contains the CFOUTPUT doesn't count. So, when you read 100 lines from the query, you get 100 carriage returns in your HTML source. There are ways to correct this, but they usually result in less readable CFML. Personally, I'm not all that worried about what the source code looks like. I'd rather have readable CFML than readable HTML. If you'll post some code, it should be apparent if this is the case. Brian -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 18, 2000 7:48 PM To: CF-Talk Subject: Anyone else had this problem before? hi all, i was just wondering if anyone had run into this problem before and what you did they do to solve it? I have a table which i populated using cfoutput basically the user can go through a given number of records, 25 at a time (in reality they can select more this is just an example). then they can cycle through each record until they have gone through all 500 records. here is the problem, every time the user brings up the next 25 records my td gets pushed down on the page. by the time you get to record 200 out of 500, the td is about half way down the page with a huge space in between my td border and the actual data. I checked my html to see if i was adding in an extra td tag or maybe an extra br but the html is clean. i have also debugged the hell out of my cfml and it's clean as well. we did utilize a css but i took that out but i am still getting the same results. i'm stumped are there any ideas out there? thanks in advance. nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Anyone else had this problem before?
Yes, we have had that problem. Look for content that is being output OUTSIDE of the tds, but inside the trs. All that content, like non-breaking spaces, will appear in front of the table, effectively pusshing it down. It won't show up in 'view source' as in front of the table, but that is how the browser (at least IE) will handle it. Dan -Original Message- From: t nelson [mailto:[EMAIL PROTECTED]] Sent: Monday, December 18, 2000 4:48 PM To: CF-Talk Subject: Anyone else had this problem before? hi all, i was just wondering if anyone had run into this problem before and what you did they do to solve it? I have a table which i populated using cfoutput basically the user can go through a given number of records, 25 at a time (in reality they can select more this is just an example). then they can cycle through each record until they have gone through all 500 records. here is the problem, every time the user brings up the next 25 records my td gets pushed down on the page. by the time you get to record 200 out of 500, the td is about half way down the page with a huge space in between my td border and the actual data. I checked my html to see if i was adding in an extra td tag or maybe an extra br but the html is clean. i have also debugged the hell out of my cfml and it's clean as well. we did utilize a css but i took that out but i am still getting the same results. i'm stumped are there any ideas out there? thanks in advance. nelson ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists