Preserving leading zeroes in a query

[D. Miller]

Hello,

I'm trying to run a query of queries on an employee directory, and use the
employees id number to link to a "Details" page. Unfortunately, these id
numbers are of varying lengths and have leading zeroes which are stripped out
when my QofQ runs. The few suggestions I've seen for dealing with leading
zeroes all relate to using numberFormat() or the SQL ZEROFILL command. But,
since my numbers are of varying lengths, this isn't going to work for me. Can
anyone tell me how to preserve my leading zeroes?

If it makes a difference, I'm running on CFMX 6.1, and the original query is
being created with QueryNew(), from an XML source.

Thanks in advance.

[Dan Bracuk]

Basically, you have to force the field to be text. Make sure the first row is
strictly alpha. Since you are building your own, do something like this:

create the query variable
populate the first row with something that will force that fields to be text.
loop through your file and add the real data.

Then in your QofQ, add
and that_file <> 'what you put in that field'
to your where clause.

[D. Miller]

Thanks, Dan. I ended up adding an "x" in front of the zeroes, then removing it when displaying the link.

Thanks!