ASP error displays varchar field as date 30-Dec-99

[Guest_imported]

Hello!!

An ASP page retrieves a 3 character piece of data from an oracle database, that is a combination of letters and numbers. Currently it is having problem displaying 2 pieces of data: specifically 19A and 08A. When displaying these it converts them both to the date 30-Dec-99.

The data is held in an Oracle database in a varchar2 field 3 characters long. Any ideas out there??

 

[codestorm]

A snippet with what you're currently doing would be helpful.. codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>

 

[Guest_imported]

Sorry - i probably didn't give enough info.

What this is: an ASP that uses a select SQL statement to draw information about an employee and display it on an intranet. There are about 12 pieces of data on each employee (such as name, hourly pay rate, manager, etc.). Everything displays fine except 1 field - that being a 3 character code that is their Job Code. The problematic job codes are 19A and 08A. When i look in the database they are stored properly. The field itself is a varchar. But for some reason these two Job Codes are displayed as 30-Dec-99.

When i use an alert to see what the variable is - i get the proper job code (19A of 08A), but when it displays in the ASP page it is that specific date. I am assuming that those specific combinations of letters and numbers is confusing the program, which spits out it's default date?

Hopefully this makes sense to someone .....

 

[codestorm]

Sorry perhaps I wasn't clear ..
A snippet with the CODE which performs the above task would be good. codestorm
Fire bad. Tree pretty. - Buffy
Hey, I'm operating on a limited mental budget here.
<insert witticism here>