If you have multiple SQL Connectors in Diafaan SMS Server, routing an incoming message from one Gateway to a specific SQL Connector is only possible with an 'HTTP callback'. This means that you have to process the incoming message on an external HTTP server and set the 'connector_list' parameter of the HTTP response to the connector(s) you want the message routed to. However, if you already process the message on an external web server using PHP or ASP.NET, it is probably easier to to the database look up there, instead of using a trigger on a database.
A database trigger can probably be used to generate a response on an incoming SMS message but I do not have enough database experience to help you with this.
There is another way to generate a database look up for incoming messages but this also requires an external web server. The Web Connector can generate an HTTP call for each received message and send the response from the HTTP server back to the sender of the message. This option is called 'Reply HTTP response to sender', you can find it in the 'Receive SMS' options of the Web Connector.
I want to know how can I reply to SMS including the result of an query to a table on my MySQL DB based on Incoming number. I already know that this can be done in two ways: By Scripting Connector or By the Database itself on reading the MessageIn table.
So, can I do the reply SMS using Triggers (in case of MySQL)?
If yes, how can i route incoming SMSs to specific SQL Connector that contains the Database i want to query?
Thanks in Advance!
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 515
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 985