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: Tony Tofts
  • Date: Mon, 22 Dec 2003 12:19:00 +0000

Try,

Sub tonyt_digiguide_guide_trigger(xplmsg)

If
ucase(xpl.getparam(xplmsg,"{SCHEMA}",true))="DGUIDE.START"
then

Strmsg="command=add" & chr(10)

Strmsg=strmsg & "sql=select * from epg"+chr(10)

Strmsg=strmsg & "starttime=" &
xpl.getparam(xplmsg,"time",true) & chr(10)

Etc

Call
xpl.sendmsg("xpl-cmnd","tonyt-xql.master","db.xql",strmsg)

End if

End sub

Don't forget the values returned by getparam are _always_ strings, so when
handling time/date etc you have to be careful of the data type in the
access
field

The above is off the top of my head, so if doesn't work let me know and
I'll
have a go when I get home.

Regards
Tony






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.