ummm
can I have that in English please
----- Original Message -----
From: "Andrew Scott" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, August 27, 2000 4:31 AM
Subject: RE: weird problem
| Simple before doing the cfset check the value of quantity, if its null
then
| put a zero in the array intead of throwing the returned value from the
| query:-)
|
|
| -----Original Message-----
| From: S R [mailto:[EMAIL PROTECTED]]
| Sent: Friday, 25 August 2000 2:54 AM
| To: [EMAIL PROTECTED]
| Subject: weird problem
|
|
| Hi everyone,
|
| I have a simple table with 4 fields (Quantity, ID, State, FirstName) .
When
| I run this query:
|
| <cfquery datasource="Tester" name="GetNumbers">
| SELECT Quantity, ID FROM TestTable
| WHERE State = NULL
| </cfquery>
|
| and try to do this array and output:
|
| <cfset QuantityTotal = ArrayNew(1)>
| <cfoutput query="GetNumbers">
| <cfset QuantityTotal[GetNumbers.CurrentRow] = #Quantity#>
| </cfoutput>
|
|
| <cfoutput>
| #ArraySum(QuantityTotal)#
| </cfoutput>
|
| I get a value that looks something like this:
|
| 1.48562799385E-306
|
| If I change the query to this:
|
| <cfquery datasource="Tester" name="GetNumbers">
| SELECT Quantity, ID FROM TestTable
| WHERE Quantity <> NULL
| </cfquery>
|
| It works fine. I really need to do a query against 'Blank' 'State' fields.
| What the heck is going on??
| ________________________________________________________________________
| Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
|
| --------------------------------------------------------------------------
--
| --
| Archives: http://www.mail-archive.com/[email protected]/
| To Unsubscribe visit
| http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
| send a message to [EMAIL PROTECTED] with 'unsubscribe' in
| the body.
|
| --------------------------------------------------------------------------
----
| Archives: http://www.mail-archive.com/[email protected]/
| To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
|
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
