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]

RE: Re: Digiguide & xQL


  • Subject: RE: Re: Digiguide & xQL
  • From: Frost Neil
  • Date: Mon, 22 Dec 2003 13:02:00 +0000

Thanks Tony, this is the script complete

Sub tonyt_dguide_guide_trigger(xplmsg)

If
ucase(xpl.getparam(xplmsg,"{SCHEMA}",true))="DGUIDE.PLAYING"
then
strmsg="command=add" & chr(10)
strmsg=strmsg & "sql=select * from epg"&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 & "descroption=" &
xpl.getparam(xplmsg,"DESCRIPTION",true) & chr(10)
strmsg=strmsg & "channelname=" &
xpl.getparam(xplmsg,"channelname",true) & chr(10)
strmsg=strmsg & "channelno=" &
xpl.getparam(xplmsg,"channelno",true) & chr(10)
call
xpl.sendmsg("","TONYT-XQL.MASTER","DB.XQL",strmsg)
end if
End Sub

The script reload but still nothing happens...

I've changed to DGUIDE.PLAYING as otherwise I'd have to wait for the next
program to start. Could be 30mins..

Is there a way to test this without using digiguide? Can you send a dummy
message in anyway?

Regards
Neil

-----Original Message-----
From: Tony Tofts [mailto:<a
href="/group/ukha_xpl/post?postID=NZ5DqYsa3PI9wMCDuC73Qz2UCgdPliQY4-AqoWOS3GPVlhQa7EnYOeWBpfVxjkvobUrrC82C">tony@x...</a>]
Sent: 22 December 2003 12:21
To: <a
href="/group/ukha_xpl/post?postID=NeMCANeF299M9JM9wqgKQyuzhCiSNLSl8plCY42s2Y_I0XrLsSl6W8gYr_SRxbZKNfLq4vwSP6W_JXzdg58">ukha_xpl@xxxxxxx</a>
Subject: RE: [ukha_xpl] Re: Digiguide &amp; xQL

> Sub tonyt_digiguide_guide_trigger(xplmsg)

Sorry, that should be

Sub tonyt_dguide_guide_trigger(xplmsg)

Regards
Tony


xPL Links: <a href="http://www.xplproject.org.uk";>http://www.xplproject.org.uk</a>
<a href="http://www.xplhal.com";>http://www.xplhal.com</a>
<a href="http://www.xpl.myby.co.uk";>http://www.xpl.myby.co.uk</a>
To Post a Message: <a
href="/group/ukha_xpl/post?postID=NeMCANeF299M9JM9wqgKQyuzhCiSNLSl8plCY42s2Y_I0XrLsSl6W8gYr_SRxbZKNfLq4vwSP6W_JXzdg58">ukha_xpl@xxxxxxx</a>
To
Subscribe: <a
href="/group/ukha_xpl/post?postID=L7tL9WxdXZNwfmDAiQfJvRSd6U39I0ABx8nq3ydlV8FpwxnVgWeBPId5U2zyzkOraxHoFTgC035HOL45LOVrhpUDT8w-Eg7NU0vC2cQ">ukha_xpl-subscribe@xxxxxxx</a>
To Unsubscribe: <a
href="/group/ukha_xpl/post?postID=DYWh4Fzpfaio0de6vpHIzgWocWiLPcWJCD2LsuFI3kMVOEu2kUApkUCne2mWeUtizS5nTSzUeUkzetjtWc_DaNHnHbwYyHCFRnQ">ukha_xpl-unsubscribe@xxxxxxx</a>


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.