Skip to main content
A
alecken
Known Participant
November 6, 2008
Question

How can I use it in CFQueryparam?

  • November 6, 2008
  • 3 replies
  • 406 views
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!
This topic has been closed for replies.

3 replies

J
JR__Bob__Dobbs-qSBHQ2
Inspiring
November 6, 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.
J
JR__Bob__Dobbs-qSBHQ2
Inspiring
November 6, 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.
N
Newsgroup_User
Inspiring
November 6, 2008
cfsqltype attribute is optional - you do not have to specify it.


Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices