| View previous topic :: View next topic |
| Author |
Message |
tackland
Joined: 14 Dec 2013
Posts: 2
Location: Australia
|
 Posted: Sat Dec 14, 2013 7:25 am Post subject: Stuck in Pending |
 |
|
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 |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4382
|
| Posted: Sun Dec 15, 2013 12:33 pm Post subject: |
|
|
| 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. |
|
| Back to top |
|
tackland
Joined: 14 Dec 2013
Posts: 2
Location: Australia
|
| Posted: Sun Dec 15, 2013 9:41 pm Post subject: |
|
|
| 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 |
|
Tech Support
Joined: 25 Aug 2003
Posts: 4382
|
| Posted: Mon Dec 16, 2013 8:56 am Post subject: |
|
|
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. |
|
| Back to top |
|
|
