Ask a Question related to Coldfusion Database Access, Design and Development.
-
steve458412 #1
Problem with cfsqltype attribute of cfprocparam
I am using Microsoft SQL server 2000. The cfsqltype attribute of cfprocparam
supports the following as shown below (extract from in its documentation). How
about SQL server data type text,ntext,nvarchar, which of the following should
we used?
CF_SQL_BIGINT
CF_SQL_BIT
CF_SQL_BLOB
CF_SQL_CHAR
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
steve458412 Guest
-
CFQUERYPARAM CFSQLTYPE Datatype Sizes?
Hi, This is probably come up before, but I'm not having any luck tracking down info on it. Does anyone have a list of datatype sizes for each type... -
CFProcParam - MX7
Well, you don't have to abandon using them if you don't mind providing the unused parameters with null="no". I've been doing this for years (since... -
Invalid data error for CFSQLTYPE CF_SQL_VARBINARY
I'm testing out our news release posting application with our new CF MX 7 server and I'm getting an error posting a news release: Invalid data... -
GUID and CFProcParam
I have a new client who is using GUID's as the primary key of their Customer table rather than the integer that most of my other clients use. When... -
boolean cfsqltype
Can someone please advise what cfsqltype should I used for boolean (true/false)? I've tried cf_sql_bit, but my results were inconsistent. i.e. ... -
CF_Oracle #2 Re: Problem with cfsqltype attribute of cfprocparam
Use CF_SQL_LONGVARCHAR that would take big text or just CF_SQL_VARCHAR. At least you will be protected from SQL injection and maybe decrease some performance time.
CF_Oracle Guest
-
vkunirs #3 Re: Problem with cfsqltype attribute of cfprocparam
Hi
check the below link, this will gives you full details.
[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/[/url]
wwhelp.htm?context=ColdFusion_Documentation&file=0 0000317.htm
vkunirs Guest
Reply With QuoteSimilar Questions and Discussions
Posting Permissions
- You may not post new threads
- You may post replies
- You may not post attachments
- You may not edit your posts
