 |
fabjr71
User
Aug 4, 2005, 6:17 PM
Post #1 of 2
(1579 views)
Shortcut
|
|
DB_Load : Record number contains non-numeric characters!
|
Can't Post
|
|
We are getting this error associated with the listing.dat.cgi file. We are producing the file from another cgi script which is importing the mls data and then publishing to the listing.dat.cgi file.
When I process the the listing.dat.cgi file and bring it into bbedit here is how the code gets converted. The ¡ is converted to this ¬°
Our developer is curious why we might be getting this and he has requested what is the proper hex code sequence. We are trying to narrow down where we might be picking up the extra character. The translations are getting screwed up somewhere from the translation of java to the perl listing.dat.cgi file.
Thanks,
Frank
|
|
| |
|
Theo
Project Manager
/ Moderator
Aug 5, 2005, 3:47 PM
Post #2 of 2
(1563 views)
Shortcut
|
|
Re: [fabjr71] DB_Load : Record number contains non-numeric characters!
[In reply to]
|
Can't Post
|
|
Frank,
Thanks for posting. Sounds like you've gotten most of the way, hopefully you can get past this last hitch.
The ¡ character used as the delimiter in the data files is a normal upside-down exclamation, as used in Spanish. The Hex value is A1, I believe.
You might find that you need to use a different custom delimiter when writing the datafile, and then have a separate function that replaces that delimiter with ¡ as a final step - maybe even with a different program if Java is having trouble with that character.
Let me know if you have any other questions for us, Frank.
Theo Wiersma
Project Manager
|
|
| |
|
