Are you using select * ?
If so, consider the error a slap on the wrist! ;)
Cheers,
Alistair
Alistair Davidson
Senior Technical Developer
Headshift.com
------------------------------------------
HEADSHIFT >> www.headshift.com
T: 020 7357 7358
------------------------------------------
smarter > simpler > social >
Personal techie blog: instantbadger.blogspot.com
George Abraham wrote:
>
> CFMX 6.1 on Win 2000. I am running the dev app off a SQL Server 2000.
> Everytime I make a change in database design on a particular table
> (say add a column), I keep getting an error on the front-end of the
> app. The error seems to occur when it encounters a query of that table
> in combination with two other tables. The error says "Variable cannot
> be converted to requested type" and throws out the line where it
> encountered the error. This line refers to the identity column of this
> offending table.
>
> <cfif FormID>AND ep.FormID = <cfqueryparam cfsqltype="cf_sql_smallint"
> value="#FormID#"></cfif>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
