Autoreply database
![]() |
Can I return a random row from a database table when an SMS comes in? | ||||||||||
Yes, you have to create a query in the
autoreply SMS script file that
returns a random row.
Select a random row with MySQL:
Select a random row with PostgreSQL:
Select a random row with Microsoft SQL Server:
Select a random row with IBM DB2
Select a random record with Oracle:
| |||||||||||
![]() |
Can I execute more then one SQL statements if an SMS comes in? | ||||||||||
Yes, you can put multiple SQL commands into the Autoreply script.
|
More information
- SMS basics
- Why is SMS so successful?
- Example applications of SMS messaging
- SMS number formats
- SMS and MMS message types
- Short Message Service Center (SMSC)
- SMS Gateway
- Two way SMS system - Ozeki NG
- Hardware and software requirements
- 2.2 Network requirements
- Ozeki SMS Gateway - General information about the software
- Routing
- Message types
- Delivery reports
- GSM modem
- SMPP
- CIMD2
- UCP/EMI
- HTTP
- SMTP
- API
- SQL to SMS
- HTTP to SMS gateway
- E-mail to SMS and SMS to E-mail forwarding
- Autoreply database
- Performance and scalability
- Logging
- Problem resolution
- Cost control and usage statistics
- Trial version of the SMS Gateway
- Commercial questions