The UK Home Automation Archive

Archive Home
Group Home
Search Archive


Advanced Search

The UKHA-ARCHIVE IS CEASING OPERATIONS 31 DEC 2024


[Message Prev][Message Next][Thread Prev][Thread Next][Message Index][Thread Index]

Script help please


  • Subject: Script help please
  • From: frostie2001uk
  • Date: Mon, 05 Jan 2004 22:42:00 +0000

Could someone look at this script and tell me why sometimes it works
and sometimes it fails...

Sub tonyt_dguide_guide_trigger(xplmsg)

If
ucase(xpl.getparam(xplmsg,"{SCHEMA}",true))="DGUIDE.START"
then
strmsg="command=edit" & chr(10)
strmsg=strmsg & "sql=select * from progguide where
[channelno]= '" &
xpl.getparam(xplmsg,"CHANNELNO",true) & "'"
+chr(10)
strmsg=strmsg & "starttime=" & xpl.getparam
(xplmsg,"TIME",true) +chr(10)
strmsg=strmsg & "duration=" & xpl.getparam
(xplmsg,"DURATION",true) +chr(10)
strmsg=strmsg & "title=" & xpl.getparam
(xplmsg,"TITLE",true) +chr(10)
strmsg=strmsg & "category=" & xpl.getparam
(xplmsg,"CATEGORY",true) +chr(10)
strmsg=strmsg & "description=" & xpl.getparam
(xplmsg,"DESCRIPTION",true) +chr(10)

Call xpl.sendmsg("","tonyt-
xql.master","db.xql",strmsg)
end if
End Sub

Thanks
Neil






xPL Main Index | xPL Thread Index | xPL Home | Archives Home

Comments to the Webmaster are always welcomed, please use this contact form . Note that as this site is a mailing list archive, the Webmaster has no control over the contents of the messages. Comments about message content should be directed to the relevant mailing list.