I googled this and can't come up with a solution. I have an id field with a varchar datatype. I need to insert an id value into it. <cfquery> is removing my leading 0's.
Is there a simple way to solve this without an ugly hack? Thanks, Will I removed the <cfqueryparam> to try and get ANYthing to work. <cfquery name="addinstructors" datasource="#SESSION.dsn#"> INSERT INTO tblinstructors ( instructorid, instructorfirstname, instructorlastname , semesterid ) VALUES ( #instructorid#, <cfqueryparam value="#instructorfname#">, <cfqueryparam value="#instructorlname#" />, <cfqueryparam cfsqltype="cf_sql_integer" value="1" /> ); </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276527 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
