Dunno, don't have 4.5 anymore -----Original Message----- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 02 April 2003 12:46 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Excel as a datasource Quirk
its CF45, I am not sure that is a 4.5 function (wasnt it 5 and upward?) -----Original Message----- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 02 April 2003 12:50 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Excel as a datasource Quirk Use the ToString() function. > -----Original Message----- > From: Robertson-Ravo, Neil (RX) > [mailto:[EMAIL PROTECTED] > Sent: 02 April 2003 11:18 > To: '[EMAIL PROTECTED]' > Subject: [ cf-dev ] Excel as a datasource Quirk > > > One of my colleagues has a quirk with CF45 and using Excel as > a datasource..... he has a set of values which are coming in > via the ODBC driver for Excel (they are zipcodes) and the > problem is this .... > > If a Zipcode has the following format - 12345-19874, > ColdFusion will treat it as a text value, BUT if the zipcode > is something like - 902010, ColdFusion will treat it as a > number and change it to : 90210.00 > > Apart from the usual LS functions etc, is there setting in > ColdFusion or Excel which can prevent this, bearing in mind > that its 4.5. > > Thanks > > Neil > > -- > ** 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]
