The value ACCOUNTING cannot be converted to a number.

[Phillip M. Vector]

<cfquery datasource="#CloudDatasource#" name="Permissions">
        select *
        from Permissions
        order by UserID
</cfquery>

<cfoutput query="Permissions">
        <cfloop index="Index" list="#Permissions.columnlist#">
                <cfif Permissions[Index][currentrow] EQ 1>
                        True
                </cfif>
        </cfloop>
</cfoutput>


There is in my DB a Column called Accounting and it's an Integer set to 1.

Why do I get a "The value ACCOUNTING cannot be converted to a number." 
error?

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to 
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f

Archive: 
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317159
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4