Main
Index 		Search
Posts 		Who's
Online 		Log
In

Home: Discontinued/Classic Products: Listings Manager Add-ons:
DB_Load : Record number contains non-numeric characters!

 
 


fabjr71
User

Aug 4, 2005, 6:17 PM

Post #1 of 2 (2474 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 (2458 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