Thanks to all for the brilliant input. Finally, a solution has been found:
<cfprocparam type="in" cfsqltype="cf_sql_integer" value="#InputBaseN(attributes.contentTimestamp, 16)#"> Ciao > -----Original Message----- > From: Paul Hastings [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 21, 2001 1:17 PM > To: CF-Talk > Subject: Re: cfsqltype=cf_sql_timestamp > > > > Your ms sql server column "RequestsDate" is of type date/time - > right? In > my > > database it's of type timestamp - totally different data type. > > just to really rub it in: timestamp in sql server (as opposed to cf > dealing with sql server's datetimes) is a binary(8) or varbinary(8) > equivalent. > > Steve, after looking at this last night, your request is kinda tougher > than it 1st looks. if you've returned a TS value as part of some > previous resultset, i guess the best bet is that you'll have to go back > and CAST it as an integer on the way out--i just tried various > varchar combos *after* pulling it from the db & none returned the > timestamp correctly. the global var @@dbTS returns the db's > current timestamp value. its value in my db is 0x0000000000011307 > (int equivalent to 70407). this is the t-sql code i used to test: > > declare @x varchar(50) > set @x='0000000000011307' > select @@dbts, cast(@x as binary(8)), cast(@@dbts as int), > cast(70407 as timestamp) > > which returns: > real dbTS:=0x0000000000011307, > cast from varchar:=0x3030303030303030, (wrong) > cast as int:=70407, > cast int back to TS:=0x0000000000011307 (right) > > this db system is relatively quite lately, so i have no > idea if you'll overflow an int datatype if you really > pound tables with TS columns... > > is this what you're after? > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
