Member Avatar for federod

Hey guys I having a problem with the null values and I need help when I have a Null value or Empty value I need to make the price = 0. Because I will get this error

The value "" cannot be converted to a number

Here is the the code

<cfquery name="totalsovr" datasource="data1">
SELECT 
COUNT (*) AS Ordersnum,
SUM(price) AS ordersum,
AVG(price)AS orderavg
FROM         overchargestudents,overcharges 
WHERE    (overcharges.orderdate >= '#startdate#') AND (overcharges.orderdate <= '#enddate#') 
AND (overcharges.cardType = #form.CCNumber#) AND (overchargestudents.stukey = overcharges.stukey)
</cfquery>

Thanks

  • 1 Contributor
  • 1 Reply
  • 65 Views
  • 9 Hours Discussion Span
  • Latest Post Latest Post by federod
Member Avatar for federod

I figured it out thanks anyways

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.