This code is working in my application. <CFPROCPARAM type="IN" cfsqltype="CF_SQL_TIMESTAMP" dbvarname="RequestsDate" value='#NOW()#'>
HTH -----Original Message----- From: Steve Vosloo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 20, 2001 3:00 PM To: CF-Talk Subject: RE: cfsqltype=cf_sql_timestamp unfortunately mssql timestamp has nothing to do with time/date - this is the problem. i need a cfsqltype that supports mssql timestamp. > -----Original Message----- > From: Costas Piliotis [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 20, 2001 9:03 PM > To: CF-Talk > Subject: RE: cfsqltype=cf_sql_timestamp > > > Try Using: #createodbcdate(attributes.contentTimeStamp)# CF function > > You may want to consider switching to datetime or smalldatetime... Check > the MDAC documentation on what that supports. Everything > supported in MDAC > *should* be supported in cf... > > -----Original Message----- > From: Steve Vosloo [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 20, 2001 7:42 AM > To: CF-Talk > Subject: cfsqltype=cf_sql_timestamp > > > hi > > I'm trying to pass a mssql server 7 timestamp variable into a sql > 7 database > using a stored proc (cf 4.51) using : > > <cfprocparam type="in" cfsqltype=cf_sql_timestamp > value="#attributes.contentTimestamp#"> > > It gives an error. I've subsequently learned that CF does not > support ms sql > 7 timestamp data types, which are actually of bin(8) data types. CF thinks > they're date/time, which in my case it certainly isn't. > > Has anyone successfully managed to pass this varibale type into SQL? > > Thanks > > > Steve Vosloo > > Vardus (Pty) Ltd > ASKA House > Fedsure on Main > Main Road > Newlands 7700 > Cape Town > > Tel: +27 (0)21 670 9880 > Fax: +27 (0)21 674 4549 > www.vardus.co.za > > The information contained in this communication is confidential, may be > privileged and is intended for the above named addressee(s). If > you are not > the intended recipient(s), and have received this communication in error, > please contact the sender by replying to this email or by telephoning +27 > (0)21 670 9880. Any views or opinions expressed are solely those of the > author and do not necessarily represent those of Vardus (Pty) Ltd. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
