How can I use it in CFQueryparam?

Report · Nov 06, 2008

I'm not experience in Sybase but one of my application has Sybase as the back end. I'm using CF 8 as the front end. I need to use cfqueryparam but one of the column call Author_number is set to id_dt data type in Sybase
I have never heard about this data type so how can I use this data type in CFQueryparam's cfsqltype attribute?

The cfsqltype I'm familiar with are:
CF_SQL_BIGINT
CF_SQL_BIT
CF_SQL_CHAR
CF_SQL_BLOB
CF_SQL_CLOB
CF_SQL_DATE
CF_SQL_DECIMAL
CF_SQL_DOUBLE
CF_SQL_FLOAT
CF_SQL_IDSTAMP
CF_SQL_INTEGER
CF_SQL_LONGVARCHAR
CF_SQL_MONEY
CF_SQL_MONEY4
CF_SQL_NUMERIC
CF_SQL_REAL
CF_SQL_REFCURSOR
CF_SQL_SMALLINT
CF_SQL_TIME
CF_SQL_TIMESTAMP
CF_SQL_TINYINT
CF_SQL_VARCHAR

Please help!

Report · Nov 06, 2008

cfsqltype attribute is optional - you do not have to specify it.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

Report · Nov 06, 2008

Is"id_dt" a user defined data type (I think Sybase call this a Domain)? If so use the cfsqltype value that corresponds to the built in data type it is based on.

Report · Nov 06, 2008

Is"id_dt" a user defined data type (I think Sybase calls this a Domain)? If so use the cfsqltype value that corresponds to the built in data type it is based on.