.VBS that checks the time

Results 1 to 2 of 2

Thread: .VBS that checks the time

  1. #1
    Join Date
    Dec 1969

    Default .VBS that checks the time

    Hi,<BR>How can I make a .VBS that checks the time for SMS to send<BR><BR>Thanx a lot<BR>Nick<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: .VBS that checks the time

    You probably have a DB containing SMS text(?), phonenumber, time to send, a flag that says if it has been sent or not, etc...<BR><BR>SQL = "SELECT * FROM smsQue WHERE Sent=0 AND TimeToSend &#060; GetDate()"<BR>set rs = conn.execute(sql)<BR><BR>While not rs.eof<BR> TryToSendSMS<BR> If Sent_OK Then<BR> sql = "UPDATE smsQue Set Sent = 1 WHERE smsID = " & rs("smsID")<BR> End If<BR>rs.MoveNext<BR>Wend<BR><BR>Schedule this .VBS to run as often as you need to.<BR><BR><BR>- jørn

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts