Question: In the SQL table what are all the possible message status
eg"send, sent,
transmited, delivered"?
This page gives you all the possible values:
Message state updates
OZEKI MESSAGE SERVER 6 - SMS PROBLEM WITH QUOTES
When I receive an SMS,
sometimes my messages are not inserted into the database.
When a message is received, an SQL string is composed, then it is passed to the database server. The SQL string composition is based on an SQL template defined in the Database Settings form. If an incoming message contains an apostrophe (') or a quotation mark ("), the SQL statement becomes invalid when the message text is inserted into the template.
Our software provides a mechanism to replace the apostrophe (') and the quotation mark (") in the received message before it is inserted into the SQL template. On the Database settings form you can specify what caracter sequence should be used instead of these characters.
Note: On Sybase, MSSql and on MySql, you should substitue the apostrophe (') with backslash and apostrophe (\') and you should do the same for quotation marks.
More information
- Pregunta: ¿Cómo puedo cambiar el número de teléfono del remitente?
- Capturar el CLI
- Envío de SMS
- Interfaz web
- Conexión SMPP
- Estados del mensaje
- Pregunta: ¿Para qué se utiliza el campo "referencia"?
- ID del mensaje
- Colas de múltiples usuarios
- Períodos de validez
- Soporte para Unicode y SQL
- Palabras clave de la base de datos
- Archivos jar en SMS wappush
- Programación de mensajes
- Prefijo internacional