Re: invalid number?
Look into the IN clause ID IN () Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com - Original Message - From: "daniel kessler" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 29, 2004 11:02 AM Subject: Re: invalid number? >I figured out the problem. I had allowed the numbers to be entered with >commas, making them strings. I changed all of them to items without commas >and they worked. ie 2,373 became 2373. So I didn't see a "convertToNumber" >call. Am I missing something in my headless rush through the day? > >>I had this working fine one morning and checked it on all computers. >>I come in another morning and it's not working - I swear. It's >>giving me the error, "invalid number" and lists the WHERE in the >>query as the line culprit. I have the same query where I added the >>line to there WHERE: >>marathon_id = #cookie.vancouver_walk# AND >>and this seems to work fine, but I don't want to specify an ID, >>instead querying for everyone, so this query doesn't have it. >> >> >> >> >> >> >> >> >> >>SELECT Sum(entry) AS num_steps,Count(entry) AS num_days >>FROM marathon_entries >>WHERE entry_type = 'vancouver_walk' AND >> entry_data_date >= #first_day# AND entry_data_date <= #last_day# >> >> >> >> >> >> #header# >> >align="right">#NumberFormat(get_gweek_totals.num_steps,',')# >> >> >> >Int((get_gweek_totals.num_steps/get_gweek_totals.num_days))> >> >> #NumberFormat(g_av_steps,',')# >> >get_gweek_totals.num_steps = 0> >> >align="right">#NumberFormat((get_gweek_totals.num_steps * >>2.25)/5280,'___._')# >> >> >> >get_gweek_totals.num_steps = 0> >> >> >>-- >>Daniel Kessler >> >>Department of Public and Community Health >>University of Maryland >>Suite 2387 Valley Drive >>College Park, MD 20742-2611 >>301-405-2545 Phone >>www.phi.umd.edu > > ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185579 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: invalid number?
I figured out the problem. I had allowed the numbers to be entered with commas, making them strings. I changed all of them to items without commas and they worked. ie 2,373 became 2373. So I didn't see a "convertToNumber" call. Am I missing something in my headless rush through the day? >I had this working fine one morning and checked it on all computers. >I come in another morning and it's not working - I swear. It's >giving me the error, "invalid number" and lists the WHERE in the >query as the line culprit. I have the same query where I added the >line to there WHERE: >marathon_id = #cookie.vancouver_walk# AND >and this seems to work fine, but I don't want to specify an ID, >instead querying for everyone, so this query doesn't have it. > > > > > > > > > >SELECT Sum(entry) AS num_steps,Count(entry) AS num_days >FROM marathon_entries >WHERE entry_type = 'vancouver_walk' AND > entry_data_date >= #first_day# AND entry_data_date <= #last_day# > > > > > > #header# > align="right">#NumberFormat(get_gweek_totals.num_steps,',')# > > > Int((get_gweek_totals.num_steps/get_gweek_totals.num_days))> > > #NumberFormat(g_av_steps,',')# > get_gweek_totals.num_steps = 0> > align="right">#NumberFormat((get_gweek_totals.num_steps * >2.25)/5280,'___._')# > > > get_gweek_totals.num_steps = 0> > > >-- >Daniel Kessler > >Department of Public and Community Health >University of Maryland >Suite 2387 Valley Drive >College Park, MD 20742-2611 >301-405-2545 Phone >www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185577 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
invalid number?
I had this working fine one morning and checked it on all computers. I come in another morning and it's not working - I swear. It's giving me the error, "invalid number" and lists the WHERE in the query as the line culprit. I have the same query where I added the line to there WHERE: marathon_id = #cookie.vancouver_walk# AND and this seems to work fine, but I don't want to specify an ID, instead querying for everyone, so this query doesn't have it. SELECT Sum(entry) AS num_steps,Count(entry) AS num_days FROM marathon_entries WHERE entry_type = 'vancouver_walk' AND entry_data_date >= #first_day# AND entry_data_date <= #last_day# #header# #NumberFormat(get_gweek_totals.num_steps,',')# #NumberFormat(g_av_steps,',')# #NumberFormat((get_gweek_totals.num_steps * 2.25)/5280,'___._')# -- Daniel Kessler Department of Public and Community Health University of Maryland Suite 2387 Valley Drive College Park, MD 20742-2611 301-405-2545 Phone www.phi.umd.edu ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185572 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54