| 2 way SMS |  Search
|
|
NowSMS Support Forums ⬆ NowSMS Support - SMS Issues ⬆ Archive through July 14, 2004 ⬆ |
◄ ► |
| Author | Message | |||
| Anonymous |
hi there, need your help to solve my questions below: 1. when someone send me a sms with key word "sales", nowsms will pick up the last 3 months sales record from a simple txt. file (all the database stored in a plain txt file.) meanwhile, i want to tag sender phone no., so that those phone nos. in the databse will only can check their own data. 2. do you have any other source code example besides the echo example, i need to study more details about this. 3. can nowsms interact with microsoft excel database? if yes, how to go about it? thanks for your help. best rgds, James | |||
| Bryce Norwood - NowSMS Support Board Administrator Username: Bryce Post Number: 2625 Registered: 10-2002 |
Hi James, Unfortunately, the only good 2-way examples that I have for this are PHP-based. http://support.nowsms.com/discus/messages/1/3991.html But you'd have to add the application logic to open and read a file to extact data based upon the sender number. I like using "echo" examples because basically they can show some parsing of the request, and how to send a response back. I've been meaning to do an ASP version of some of the PHP examples. Here's a real simple one along the lines of the first echo example in the above thread. Let's say you have a 2-way command configured to call http://server/2way.asp?sender=@@SENDER@@&text=@@FULLSMS@@ Here's an example of what 2way.asp could look like: <% Response.ContentType = "text/plain" If Request.QueryString("sender") = "" Then Response.Write ("ERROR : 'sender' parameter missing!") Else If (Request.QueryString("text") = "") Then Response.Write ("ERROR : 'text' parameter missing!") Else Response.Write ("I received your message : ") Response.Write (Request.QueryString("text")) End If End If %> I realise that all this example does is send an echo response back, but basically it shows how the variables are sent to an ASP script, and how you return back text in the SMS message that is sent back in reply. So basically, if you can write an ASP script to return the information out of your text file or database, you can adapt the script pretty easily to return a response via SMS. -bn | |||
