Scott,
What cfsqltype attribute are you using in your cfqueryparam? You might
try "cf_sql_bit". Also, I had to write a custom function to generate
bit values for all boolean values. Here's my function:
<!--- BooltoBit can be used to convert logical boolean values
("on/off","true/false","yes/no", "1/0") to bit values for
insertion into SQL databases
Example:
foo = <cfqueryparam value="#BooltoBit(foo)#" cfsqltype="cf_sql_bit">
--->
<cffunction name="BooltoBit" returntype="numeric">
<cfargument name="b" type="string" required="yes">
<cfset var result = "">
<cfif LCase(b) eq "on">
<cfset b = True>
<cfelseif LCase(b) eq "off">
<cfset b = False>
</cfif>
<cfif IsBoolean(b)>
<cfif b>
<cfset result = 1>
<cfelse>
<cfset result = 0>
</cfif>
<cfelse>
<cfset result = -1>
</cfif>
<cfreturn result>
</cffunction>
HTH,
Carl
Scott Stewart wrote:
> The cfqueryparam tags work fine with the character fields, but they're
> returning true or false as opposed to 1 or 0, even though 1 or 0 is
> passed to it from the form.
>
> Any ideas?
>
> Scott Stewart wrote:
>
>> That's cool, I appreciate the input.
>>
>> thanks
>>
>> sas
>>
>> Craig Dudley wrote:
>>
>>
>>> Had a good look but can't find the examples, it's fairly easy to set up
>>> anyway.
>>>
>>> The MS SQL Server JDBC driver is three/jar fiels I think? Just drop them
>>> into \ColdFusion8\runtime\jre\lib\ext and restart CF, the .jar should then
>>> appear in the big CF Server Java Class Path box in settings summary in CF
>>> Admin.
>>>
>>> When you add a datasource, elect other from the driver dropdown it will ask
>>> you for a JDBC URL, Driver Class and Driver Name. All of which is standard
>>> JDBC stuff but there are docs in the MS download package I think, it's not
>>> complex either way but sorry I couldn't find my examples as it might have
>>> saved some time.
>>>
>>> Craig.
>>>
>>> -----Original Message-----
>>> From: Scott Stewart [mailto:[EMAIL PROTECTED]
>>> Sent: 11 August 2008 17:14
>>> To: CF-Talk
>>> Subject: Re: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3
>>> Driver
>>>
>>> Thanks Craig....
>>>
>>> The higher ups have deemed this a "last resort"... so if it comes to
>>> this I'll put up some results.
>>> I'm pursuing what could be an issue with cfqueryparam
>>>
>>> Craig Dudley wrote:
>>>
>>>
>>>
>>>> Not for a while, from memory you just drop the three MS .jar's somewhere
>>>>
>>>>
>>>>
>>> in
>>>
>>>
>>>
>>>> CF's classpath and restart CF to install and creating datasources becomes
>>>>
>>>>
>>>>
>>> a
>>>
>>>
>>>
>>>> bit more dificult, I'll see if I can dig up an example for you.
>>>>
>>>> I seem to remember that performance wasn't all that great, in fact, CF7's
>>>> built in drivers were faster in most of my test cases. Sorry I haven't
>>>>
>>>>
>>>>
>>> tried
>>>
>>>
>>>
>>>> them on CF8.
>>>>
>>>> The MS drivers don't cause any issues with CF's built in drivers though so
>>>> why not give it a try on your dev box?
>>>>
>>>> Craig.
>>>>
>>>> -----Original Message-----
>>>> From: Scott Stewart [mailto:[EMAIL PROTECTED]
>>>> Sent: 11 August 2008 15:10
>>>> To: CF-Talk
>>>> Subject: CF 8 Built in SQL Server drivers vs. MS SQL Server 2000 SP3
>>>>
>>>>
>>>>
>>> Driver
>>>
>>>
>>>
>>>> Hey all,
>>>>
>>>> I've run into an issue that I need opinions on. We've run into some SQL
>>>> server issues, where MS is saying "patch the driver".
>>>> Has anyone used the MS SQL Server 2000 SP3 JDBC driver in place of the
>>>> one shipped with CF8?
>>>> Has it cleared up 8180 errors?
>>>> Any performance gains/losses?
>>>> Any "gotchas"?
>>>>
>>>> thanks
>>>>
>>>> sas
>>>>
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;203748912;27390454;j
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310753
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
