May be I am over-simplifying your problem but adding empty string ("")
might solve?? Just curious what data type is SSN being returned from the
query (number ,integer , string)?
Pine
-----Original Message-----
From: Robert Everland III [mailto:[EMAIL PROTECTED]
Sent: Friday, March 10, 2006 10:01 AM
To: CF-Talk
Subject: Createquery and numbers that are strings
I am creating a huge structure so that I can get data from many
different tables that I can't join (don't ask long story). The key of my
structure is a SSN, now I need to order the records to be in
alphabetical on the name, i can't use the name as the key since some
people could potentially have the same name. So I came up with a way to
loop through the key and get the name and put them into a query I create
(you still with me). Now I do a dump of that query and it loses any 0's
in front and treats it as a number. Even when I use javacast. The only
way I have found to get by this is to put a letter in front of the SSN.
Anyone have another solution to this?
Bob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235076
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
