xQL

[frostie2001uk]

Could someone look at this sql statement for xql and tell me if it is
allright? in the monitor it fails...

strmsg=strmsg & "sql=select * from progguide where
[channelno]='" &
xpl.getparam(xplmsg,"CHANNELNO",true) &"'"
+chr(10)

the whole script is...


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

It is displayed in the monitor but i don't get the end part from
xQL.. like...

xpl-stat
{
hop=1
source=tonyt-xql.master
target=xpl-xplhal.main
}
DB.XQL
{
STATUS=OK
COMMAND=EDIT
SQLID=51
}

<--from montitor-->
xpl-cmnd
{
hop=1
source=xpl-xplhal.main
target=tonyt-xql.master
}
db.xql
{
command=edit
sql=select * from [progguide] where [channelno]='621'
starttime=01:10
duration=25
title=Dragonball Z
category=Animation
description=Pathos of Frieza. Goku's power and strength appears to
increase with every blow against Frieza but he does not have much time
}