Direct DB Access

[nadragon]

Hello,

I have successfully received the text messages from Admin tool. And now I am trying to see how the web interface and ASP or ASP.NET would work with PageGate.

First, I tried modifying the Access database, pagegate.mdb, manually and checked if the Admin tool recognized it. It did recognize the changes, but I got an error, "Invalid Null value". I believe that once I know what fields to modify in the database, I can create the customized web application.

I need the functions, "Add/Delete/Modify recipients, groups and sending messages." Well, so thanksfully there is a template for sending messages, using webgate.exe. And it perfectly worked.


And my last question is whether I can set up a schedule of the paging. For example, I would like to send a text message a couple of hours later or every week.

Thank you!

[Tech Support]

To avoid the NULL problems, you should be sure to populate all text fields with at least a zero length string (i.e. ""), instead of leaving it as a NULL value. This is done differently in different development environments, so I can't give any more details than that.

If you are writing directly to the database, message can be scheduled by making the 'date_time_requested' field a future date/time. The repeat_interval and repeat_stop fields can also be used to schedule repeating messages.

If you would, please email support@notepage.com so I can have your email address and send you the documentation on integrating PageGate with other applications as you'll find it most useful.

[nadragon]

Thank you so much! I sent an email to support@notepage.com.


[quote="Tech Support"]To avoid the NULL problems, you should be sure to populate all text fields with at least a zero length string (i.e. ""), instead of leaving it as a NULL value. This is done differently in different development environments, so I can't give any more details than that.

If you are writing directly to the database, message can be scheduled by making the 'date_time_requested' field a future date/time. The repeat_interval and repeat_stop fields can also be used to schedule repeating messages.

If you would, please email support@notepage.com so I can have your email address and send you the documentation on integrating PageGate with other applications as you'll find it most useful.[/quote]