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]

Reply via email to