CF ERROR MSG: The value "" cannot be converted to a number

General Suggestions:
Remove the lock around your query
Remove # from coldfusion statements
In your query you have the line:
WHERE id IN (#session.classes#)
This will throw an error if and when the value session.classes is null or not a number.

As far as your error goes - Do this:
<td>
<cfif session.validMember is "yes">
      <cfif isNumeric(member_earlybird)>
      #DollarFormat(member_earlybird)#
      <cfset totalFees = totalFees + member_earlybird>
      </cfif>
<cfelse>
      <cfif isNumeric(non_member_earlybird)>
      #DollarFormat(non_member_earlybird)#
                 <cfset totalFees = totalFees + non_member_earlybird>
      </cfif>
</cfif>
</td>

You could also try <cfset totalFees = #evaluate(#totalFees# + #non_member_earlybird#)#>

Hi All,

Thank you all for your suggestions. A few things.

1. I do know that the session variables have NOT expired because they are showing up in the error report.

2. I originally had <cfset totalFees = 0> but changed it to <cfset totalFees = "0"> after I received the same error as above with the <cfset totalFees = 0>.

3. I orignally had the following code below and it threw the same error as above so that is when i added the # signs around the totalFees and member_earlybird/non_member_earlybird.

4. the member_earlybird/non_member_earlybird is NOT a number is the dbase. it is a text field. basically what happens is in session.classes (this is a list of numbers). that list of numbers is compared to the ce listing table and if a match occurs then the appropriate workshop information is displayed. basically the text fields are 450.00 or 90.00 or 270.00. that is the format and that is why i addition will work for the most part on the cfset totalFees.

i can remove the cflock around the qry however the other suggestion except for  aseusainc are for things that I have already done and change to the programming I showed above.

Any other ideas????


Thanks


<cflock scope="session" type="readonly" timeout="5">

<cfif #session.validMember# EQ "YES">
<td>#DollarFormat(member_earlybird)#</td>
<cfset totalFees = totalFees + member_earlybird>

<cfelse>

<td>#DollarFormat(non_member_earlybird)#</td>
<cfset totalFees = totalFees + non_member_earlybird>

</cfif>
</cflock>
      

If you really want a catch all (without using a try/catch), you could use something like BEFORE your calculation:

<cfif #isnumeric(member_earlybird)# IS FALSE>
  <cfset #member_earlybird# = 0>
</cfif>

Mamea
I should have elaborated ...
The first part of my answer had nothing to do with your error, but were simply statements meant to improve your coding practices.
Locking this query and also in your most recent post you lock an cfif block. This is not needed. It is not a situation where you need a lock. You should remove you locks for code like this. You can read about how and why to use lock in your cf docs.
Also, using #'s inside ColdFusion statements is inefficient and screams "newbie". It is not how the language was designed. #'s are meant for when you need to give a vars value to the browser (to the user), Not to the ColdFusion server. Remove them from your code.
Also <cfset totalFees = 0> vs <cfset totalFees = "0"> There is no difference - but you should use <cfset totalFees = 0>

Now about your error ...
Did you try this?
<td>
<cfif session.validMember is "yes">
     <cfif isNumeric(member_earlybird)>
     #DollarFormat(member_earlybird)#
     <cfset totalFees = totalFees + member_earlybird>
     </cfif>
<cfelse>
     <cfif isNumeric(non_member_earlybird)>
     #DollarFormat(non_member_earlybird)#
                 <cfset totalFees = totalFees + non_member_earlybird>
     </cfif>
</cfif>
</td>
I don't see a reason why it wouldn't work.
You have an error that says basicly that "" cannot be converted to a number - which is logical.
So if you then say "only try to add this if it is a number" - then this is logical also.
You do it by saying cfif isNumeric(member_earlybird)

good luck ...