Re: The value ACCOUNTING cannot be converted to a number.

Strange.. When I I get a 0. When I I get 45 (The correct recordcount). But when I changed the Permissions query to Settings, it worked... Weird. Thanks for the tip. :) Will Tomlinson wrote: >> The value is 1. It's not Null. >> >> I tried putting a val around it and it still bombs out. > > D

Re: The value ACCOUNTING cannot be converted to a number.

>The value is 1. It's not Null. > >I tried putting a val around it and it still bombs out. Did you try dumping the values? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial

Re: The value ACCOUNTING cannot be converted to a number.

The value is 1. It's not Null. I tried putting a val around it and it still bombs out. I can't see where my logic is wrong. Dominic Watson wrote: > If Accounting should be a number but can be null in the database, you > may want to use . > Otherwise I suspect your logic may be wrong. Personally,

Re: The value ACCOUNTING cannot be converted to a number.

order by UserID > > > > > >True > > > > > > There is in my DB a Column called Accounting and it's an Integer set to 1. > > Why do I

The value ACCOUNTING cannot be converted to a number.

select * from Permissions order by UserID True 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 t