Re: Digiguide & xQL

[frostie2001uk]

Tony,

I must be doing something wrong....

Do I have to amend the tonyt_xql_master script?

I can see the messages in the monitor window, is the speed of the
update an issue? they do happen VERY fast.?

the table is in xql.mdb (i know thats working as meteor is still
updating it) all the fields are text with "allow zero length" set
to
yes...

now I'm a bit stumped...

I've put my complete script on the the bottom of this post...

Thanks again
Neil

my script is:

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 & "description=" & 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("xpl-cmnd","tonyt-
xql.master","db.xql",strmsg)
end if
End Sub