(RADIATOR) SQL Query with Backslash

[Harrison Ng]

Hi,

We have some special usernames such as *99#\ needed for login.

But the backslash "\" may cause problem to update query like this:

Fri Jun 14 10:15:13 2002: ERR: do failed for 'update RADPOOL set
STATE=1,TIME_STAMP=1024020913,EXPIRY=1024280113,USERNAME='*99#\',CALLINGSTAT
IONID='85294546592' where YIADDR='10.25.192.153' and TIME_STAMP=1023961400':
You have an error in your SQL syntax near '85294546592' where
YIADDR='10.25.192.153' and TIME_STAMP=1023961400' at line 1

The effect is unable to complete authentication for current request.

Can you help?

Regards,
Harrison Ng
SmarTone Mobile Communications Limited
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020618/df74397c/attachment.html>
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: InterScan_Disclaimer.txt
URL: <http://www.open.com.au/pipermail/radiator/attachments/20020618/df74397c/attachment.txt>