Title: SQL Query with Backslash

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#\',CALLINGSTATIONID='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

** This Email is virus-scanned and identified clean.


Reply via email to