[Emerald] Problem with PTC w/AVS

Will LaSala ( will@greennet.net )
Mon, 16 Nov 1998 13:28:10 -0500

Hey all,
I'm using PTC w/AVS as the credit card batch out filter.
When I import it (after hours of figuring out which fields have to imported
and which have to be exported)
PTC gave me an error with the Operator ID apparently it needs to be a
numeric and not a character.
Ok np, right?!?....not even close!
The operator ID is the person that ran the batch,
So you say, if you logon as a number, say the user name is 01, it would work
fine...in theory.
Well to my surprise 01 is an invalid user name apparently you can have a
username that
is a number. What a pain! So my question is does anyone know how I can use
a number as a username in SQL? or translate the batch file name to a number
every time?

P.S. Please excuse the frustration I've been working on this for weeks just
to find out that there is a problem with the exporting features...;-)
Will ,,,=^. .^=,,,
GreenNet® ========================================
"Link Locally ~ Surf Globally©" http://www.greennet.net
Come Play On The Best Quake Server in the Northeast
Serving Eastern Massachusetts and Southern New Hampshire
TEL: 978-363-8898 FAX: 978-363-1225 email:will@greennet.net