Donna French wrote: >I'm trying to plug in CFQUERYPARAM after the trouble earlier. I'm >getting errors and not real sure which data types to specify for each >- or if I should try to specify at all ? > >Here's my query and I'll post the actual db field types below that: > >SELECT COUNT(Clients.Client_ID) as ClientCount >FROM Clients >WHERE > Client_IntakeDate >= <cfqueryparam value="10/1/2004" cfsqltype="cf_sql_date"> > AND > Client_IntakeDate <= <cfqueryparam value="10/31/2004" cfsqltype="cf_sql_date"> > AND > Client_County = <cfqueryparam value="Cass" cfsqltype="cf_sql_varchar"> > AND > Client_CountyOfIncident = <cfqueryparam value="Bowie" >cfsqltype="cf_sql_varchar"> > AND > PhysicalImpact_Unknown = <cfqueryparam value="True" cfsqltype="cf_sql_varchar"> > AND > Client_Active = <cfqueryparam value="Yes" cfsqltype="cf_sql_varchar">; > >Client_County - text >Client_CountyOfIncident - text >PhysicalImpact_Unknown - true/false >Client_Active - yes/no (checkbox) > >Thanks again! > > > The error occurs with the last two datatypes correct? I've always used integer with a 1 for Yes/True and a 0 for No/False and haven't had a problem.
Hope this helps! -- Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| The annual ColdFusion User Conference is being held Sat 6/26 - Sun 6/27/04 8am-5pm in the Washington DC Area. http://www.houseoffusion.com/banners/view.cfm?bannerid=44 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:183205 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
