NotePage, Inc. Forum Index

Stuck in Pending

 
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> PageGate Support
View previous topic :: View next topic  
Author Message
tackland



Joined: 14 Dec 2013
Posts: 2
Location: Australia

PostPosted: Sat Dec 14, 2013 7:25 am    Post subject: Stuck in Pending Reply with quote

Msgs are stuck in pending when I use this script but they work fine with GuiClient

Am I missing something? Version 6.0.0.16
Set conn = CreateObject("ADODB.Connection")
conn.open "PageGate" '"Driver={SQL Server};Database=BlaBla;server=SuperBla;Connect Timeout=10;User Id=tx;Password=passwd;"
sql="INSERT INTO messages (user,pin,message,carrier,date_time_requested,frm,sent,error,ascii_file,mail_file,lock,scheduled,station,transaction) "
sql=sql + "VALUES ('MRHappy','','Woof! Test SMS sent from PRIME','OPTUS','" & Now & "', 'Administrator',0,0,'','',0,0,10,51)"
on error resume next


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4351

PostPosted: Sun Dec 15, 2013 12:33 pm    Post subject: Reply with quote

If you would, post an example of what the actual written line would look like so we can check the order, placement and values for each of the fields you're writing.



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
tackland



Joined: 14 Dec 2013
Posts: 2
Location: Australia

PostPosted: Sun Dec 15, 2013 9:41 pm    Post subject: Reply with quote

INSERT INTO messages (user,pin,message,carrier,date_time_requested,frm,sent,error,ascii_file,mail_file,lock,scheduled,station,transaction) VALUES ('MRHappy','','Woof! Test SMS sent from PRIME','OPTUS','" & Now & "', 'Administrator',0,0,'','',0,0,10,51)


Back to top
View user's profile
Tech Support



Joined: 25 Aug 2003
Posts: 4351

PostPosted: Mon Dec 16, 2013 8:56 am    Post subject: Reply with quote

Ah, it looks like some of your field values are a little off and you're also missing some values. Here is the explanation of the messages table and what fields need to be configured:

user: Enter the recipient name of the person to be contacted.
pin: ""
message: Enter the message to be sent to the recipient.
carrier: ""
date_time_req: Enter the current date/time in this format 5/22/2007 1:47:52 PM
date_time_sent: ""
frm: Enter the Sender's Name here
sent: False
error: False
ascii_file: ""
mail_file: ""
lock: False
scheduled: False
reliapage_index: False
repeat_interval: 0
repeat_stop: Set this to the same value as date_time_req.
station: Set this field to 0.
message_id: ""
retries: 0
last_try: Set this field to 30 seconds prior to the date_time_req field.
transaction: ""
dialer: ""

Note: "" means write a blank string to the field. If you leave the field completely blank, the Jet Engine Database will interpret it as a #NULL# value, which completely throws our program for a loop. I'm not sure what value you would use to write a blank string with the ODBC engine, just don't leave those fields completely blank.



_________________
Tech Support
support@notepage.com
http://www.notepage.net
Back to top
View user's profile
Display posts from previous:   
Post new topic   Reply to topic    NotePage, Inc. Forum Index -> PageGate Support All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group
Theme created by Vjacheslav Trushkin