cf_sql_integer vs cf_sql_bigint vs cf_sql_int??
i have id (primary key) set bigint in sql server. have query following:
where whateverid = <cfqueryparam cfsqltype="cf_sql_integer" value="#url.id#">
i got invalid data type it. tried:
where whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#">
i still got invalid data type it. tried:
where whateverid = <cfqueryparam cfsqltype="cf_sql_int" value="#url.id#">
and worked.
the weird thing cf_sql_int not listed being accepted:
http://www.adobe.com/livedocs/coldfusion/5.0/cfml_reference/tags79.htm
can explain me.
where whateverid = <cfqueryparam cfsqltype="cf_sql_integer" value="#url.id#">
i got invalid data type it. tried:
where whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#">
i still got invalid data type it. tried:
where whateverid = <cfqueryparam cfsqltype="cf_sql_int" value="#url.id#">
and worked.
the weird thing cf_sql_int not listed being accepted:
http://www.adobe.com/livedocs/coldfusion/5.0/cfml_reference/tags79.htm
can explain me.
> whateverid = <cfqueryparam cfsqltype="cf_sql_bigint" value="#url.id#">
what value of #url.id#? had no problems either using cf8.
> weird thing cf_sql_int not listed being accepted:
iirc, when pass in invalid sql type cf uses default: cf_sql_char, accepts anything. ms sql implicit convert() right type , why works.
what value of #url.id#? had no problems either using cf8.
> weird thing cf_sql_int not listed being accepted:
iirc, when pass in invalid sql type cf uses default: cf_sql_char, accepts anything. ms sql implicit convert() right type , why works.
More discussions in Database Access
adobe
Comments
Post a Comment