Ask a Question related to Coldfusion Database Access, Design and Development.
-
doramon #1
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. correct sometimes, but at other times the return values were not correct.
Thanks
doramon 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... -
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... -
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... -
Boolean Searches
I am trying to implement a boolean type search . The current search that I have searches for exact matches, if the input has multiple words. I want... -
Boolean constructor...
Hello, When I instanciate a boolean with a string for an argument, and the display the variable for example var b:Boolean = new Boolean("ASDF");... -
doramon #2
Re: boolean cfsqltype
OK. I've tried boolean with cf_sql_integer and it works. Thanks anyway.
doramon Guest
-
The ScareCrow #3
Re: boolean cfsqltype
If it's a boolean, you should use bit and pass either a one (1) or zero (0).
Ken
The ScareCrow Guest
-



Reply With Quote

