Mickael wrote: > My question is since this is a timestamp (binary) field is there anther > way to return the value in CF then what I have display above? Also how > can a date be Binary?
in this case sql server's timestamp datatype isn't a "real" datetime. it's used to determine if that row was updated (by comparing before & after timestamp values). i guess change the datatype to datetime w/a default of getDate() or update the datetime w/a trigger or do it "manually" from cf. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:213378 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
