I had this online somewhere, but its gone !!! You can find this list in ben forta's advanced CF4 book under the stored procs chapter Probably the only useful thing in it.
I'll dig it out tomorrow and post it. Justin -----Original Message----- From: Duncan Fenton [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 15:34 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Strange T-SQL issues Anything to do with the "date" being the integer part of the underlying number? Perhaps CF_SQL_DATE is mapped to Integer or Smallint. Do MM anywhere specify the mappings of CF_SQL_XXX to the actual DB types - which I suppose could also vary per DB engine? Duncan -----Original Message----- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 13 January 2004 11:58 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Strange T-SQL issues I have no idea, it appears to be one of those weird decisions the CF engineers made. I'm assuming the date var type just takes the date and not the time - you could test this if you have some time. > -----Original Message----- > From: Damian Watson [mailto:[EMAIL PROTECTED] > Sent: 13 January 2004 11:40 > To: [EMAIL PROTECTED] > Subject: RE: [ cf-dev ] Strange T-SQL issues > > > Yup, that would do it. Can you tell us why though Rich, tis > most perplexing! It had me screwed for quite some time. > > d > > -----Original Message----- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 13 January 2004 10:47 > To: '[EMAIL PROTECTED]' > Subject: RE: [ cf-dev ] Strange T-SQL issues > > use need the TIMESTAMP var type in cf. > > > -----Original Message----- > > From: Paul Johnston [mailto:[EMAIL PROTECTED] > > Sent: 13 January 2004 10:44 > > To: [EMAIL PROTECTED] > > Subject: [ cf-dev ] Strange T-SQL issues > > > > > > I am having issues putting a date/time from CF into SQL > > Server. I am sure it's simple, but I can't seem to get the > > time into the server (date is no problem). > > > > Running this code in Query Analyzer produces the correct > > output (ie a date with the right time): > > > > DECLARE @sd varchar(30) > > SELECT @sd = '2003-10-19 12:23:03' > > > > DECLARE @dt datetime > > SELECT @dt = CONVERT(datetime, @sd, 120) > > > > SELECT @dt as dt > > > > However, if I insert in a date via a Stored Procedure (either > > as a cf_sql_date or cf_sql_varchar and convert to date) > > either way it removes the time and just inserts the date. > > > > Anyone? > > > > Paul > > -------------------------- > > Paul Johnston > > PJ Net Solutions Ltd > > E: [EMAIL PROTECTED] > > M: +44 7866 573013 > > > > > > > > -- > > ** Archive: > http://www.mail-archive.com/dev%> 40lists.cfdeveloper.co.uk/ > > > > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > > [EMAIL PROTECTED] For human help, e-mail: > > [EMAIL PROTECTED] > > > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > > > -- > ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ > > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > For human help, e-mail: [EMAIL PROTECTED] > -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
