MSibai
Joined: 30 Mar 2008
Posts: 2
|
 Posted: Sun Mar 30, 2008 11:34 pm Post subject: Process Incoming Unicode SMS for DB Query |
|
|
Hi,
I am trying to query the database by selecting an ID that is sent as the Body of the SMS message...
When using the Text BodyFormat ... it is 100% direct for both MS Access and MySQL.
But the problem is when using the Unicoded Arabic message ...
| Quote: |
Set objConn = CreateObject("ADODB.Connection")
objConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & STR_DATABASEFILE & ";"
strQuery = "SELECT * FROM blocks WHERE block_name = '" & BlockName & "'"
Set RS = objConn.Execute ( strQuery ) |
The "BlockName" is a variable that am reading as a function's argument, and which is the uniceoded value.
Following are the errors I get ...
| Quote: |
| 03/31/2008 01:21:43 AM - [My Autoresponder Project.vbs] Error #29120 - Microsoft OLE DB Provider for ODBC Drivers: [MySQL][ODBC 5.1 Driver][mysqld-5.1.22-rc-community]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''þ123' at line 1; Line:165; Char:4; Code:0x80040E14 (duration: 00:00) |
| Quote: |
| 03/31/2008 02:31:37 AM - [My Autoresponder Project.vbs] Error #29120 - Microsoft JET Database Engine: Syntax error in string in query expression 'block_name = 'þ123'.; Line:166; Char:3; Code:0x80040E14 (duration: 00:00) |
Please advice as this became a critical issue for me now ... |
|
Download SMS Messaging Server | 
Visit the SMS Messaging Server website
Process Incoming Unicode SMS for DB Query
