How can I make cfquery stop removing leading 0's??

I googled this and can't come up with a solution. I have an id field with a varchar datatype. I need to insert an id value into it. cfquery is removing my leading 0's. Is there a simple way to solve this without an ugly hack? Thanks, Will I removed the cfqueryparam to try and get ANYthing

Re: How can I make cfquery stop removing leading 0's??

what happens when you use a cf_sql_varchar in the queryparam? And what happens when you run the INSERT statement in a Database console window? same thing, or does it keep the leading 0's? Mark On 4/30/07, Will Tomlinson [EMAIL PROTECTED] wrote: I googled this and can't come up with a solution.

Re: How can I make cfquery stop removing leading 0's??

Mark, just dumped the data and figured out Ben Nadel's excel CFC is removing the 0's for me. Thanks, Will ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2

Re: How can I make cfquery stop removing leading 0's??

Just figured out I have bad data to start with. lol... Will ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: