OK, eventually found a fix..
SELECT *, STR("the-field") AS TheField
FROM theTextFile
Kind of works but still drops leading zeroes so I have to re add them
after the select...
--
Jay
On Wed, May 14, 2008 at 12:11 PM, James Smith <[EMAIL PROTECTED]> wrote:
> I am querying a text file and getting some annoying behaviour, when I
> have a field containing the value "692619037803123" for example it is
> reading it as a float value and then converting it into
> 6.92619037803E+013 for storage in my MSSQL database as a varchar. I
> need it to be a varchar because some values will be "00123456789" and
> I need to maintain the leading "0" characters.
>
> I have tried modifying the text file query to...
>
> SELECT *, cast(['the-field'] AS VarChar(20)) AS theField
> FROM theTextFile
>
> but that is throwing an error "Syntax error (missing operator) in
> query expression", I have also tried using convert() but that throws
> an undefined function error.
>
> Does any one know how I can get the text file odbc driver to read this
> field as a varchar?
>
> --
> James Smith
> IT Director
> Music Express Ltd
>
--
James Smith
IT Director
Music Express Ltd
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;192386516;25150098;k
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305593
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
