Autoreply SMS application

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Autoreply SMS application

Autoreply SMS application

Rate Topic

Display Mode

Topic Options

Author

Message

lesliejohnson1986

Posted Tuesday, January 15, 2013 1:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, January 15, 2013 1:18 AM
Points: 1, Visits: 0

Hello,

I am trying to create an application which will send a reply back once a customer (registered user) sends a a question to the system. The application will select the correct answers from a database and send it back in SMS to the customer’s mobile phone. For example I will use Microsoft SQL Express as the database server. I found a software, Ozeki NG SMS Gateway that can handle SMS receiving and sending. The database connection is the question. How should I organize the data in the database? Is this the best way as they recommend? (http://www.ozekisms.com/index.php?owpn=392&info=users-and-applications/autoreplydatabase-user)

For example:
> select * from autoreplymessage;
id keyword msg
---------- ------------------------------ -------------------------------------
1 default There is no data for this keyword.
2 red Red is a good color.
3 blue Blue is not the best option.

Please share with me your suggestions.

Bye,

Leslie

Post #1407070

« Prev Topic | Next Topic »

Permissions