Your ms sql server column "RequestsDate" is of type date/time - right? In my database it's of type timestamp - totally different data type.
> -----Original Message----- > From: Boardwine, David L. [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, November 20, 2001 10:08 PM > To: CF-Talk > Subject: RE: cfsqltype=cf_sql_timestamp > > > 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
