I was curious as to whether the following code is the best way to handle
updating datetime fields (SQL 2000). I use the isdate() function to verify
that my variable is indeed a date, and then update the db field with the
CreateODBCDate() function......is there another way I should be doing this??
thanks in advance for any advice or confirmation.....
<cfquery name="myQuery" datasource="myDSN">
UPDATE myTable
SET myField = <cfqueryparam value="#left(someValue,250)#"
cfsqltype="CF_SQL_VARCHAR">
<cfif isdate(trim(attributes.publishdate))>
, publishdate = #CreateODBCDate(attributes.publishdate)#
</cfif>
<cfif isdate(trim(attributes.unpublishdate))>
, unpublishdate = #CreateODBCDate(attributes.unpublishdate)#
</cfif>
WHERE myPKid = <cfqueryparam value=#val(id)# cfsqltype="CF_SQL_INTEGER">
</cfquery>
charlie hanlon
food service enablers, inc.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:230617
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
