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: Script help please


  • Subject: RE: Script help please
  • From: Frost Neil
  • Date: Tue, 06 Jan 2004 11:23:00 +0000

Is there anyway round this?


Regards
Neil

-----Original Message-----
From: SuperQuirky [mailto:<a
href="/group/ukha_xpl/post?postID=PnSZMs2mRVc6396UHQVeE2rUaafUSPRr1p2zbiS-GCRVc1yuw1SPhnSybLvMSzsnn-3yXnWPhJJ3WlgsiLM">ha@s...</a>]
Sent: 06 January 2004 11:20
To: <a
href="/group/ukha_xpl/post?postID=A5M8ymtXJBUKkxb4y3V6iQF6A6oOEpp9K4iw8IxH5OjcauTN0eqvbFBXfrYnshITodr76cn18msgAGMS8J0k8BefWA">ukha_xpl@xxxxxxx</a>
Subject: Re: [ukha_xpl] Script help please

The most common bad characters are probably ' (single quote) and &amp;.
Easily missed is such titles as Howard's Way.

---- Original Message ----
From: <a
href="/group/ukha_xpl/post?postID=NRdPdsmln7Qd1JdS0VkPtua2gV250AmCAUKO7-x56dAFiLySajbUSmKIwjfvw4XLPxnIxihtUWtBEONL3v2vk5IXtN8">steve.cooper@u...</a>
Sent: Tue, 6 Jan 2004 07:57:08 +0000
To: <a
href="/group/ukha_xpl/post?postID=A5M8ymtXJBUKkxb4y3V6iQF6A6oOEpp9K4iw8IxH5OjcauTN0eqvbFBXfrYnshITodr76cn18msgAGMS8J0k8BefWA">ukha_xpl@xxxxxxx</a>


I'm I right in thinking this just stores the latest program to MySQL or
Access for each channel. if so I can't see anything wrong with the script.

However if the description or category contains a character that SQL is not
expecting it my cause an error. Worth checking out the ones that cause an
error and seeing if there is something about the title of the program like
a
special character or perhaps just part of it in quotes.

S.


--------+--------------------------------->
"frostie2001uk"
<<a
href="/group/ukha_xpl/post?postID=NOysq0pDvUlWQUAFXzOUHhSafcSChj5FCQStJ1IkXEPyRqXG1Efb3geVMTFjfW22RNyJ4ja7VtU45ruq">Neil.Frost@s...</a>
jitsu.com>

05/01/2004 22:42
Please respond to
ukha_xpl

--------+--------------------------------->

>---------------------------------------------------------------------------
-------------------------------------------


To: <a
href="/group/ukha_xpl/post?postID=A5M8ymtXJBUKkxb4y3V6iQF6A6oOEpp9K4iw8IxH5OjcauTN0eqvbFBXfrYnshITodr76cn18msgAGMS8J0k8BefWA">ukha_xpl@xxxxxxx</a>

cc:

Subject: [ukha_xpl] Script help please


>---------------------------------------------------------------------------
-------------------------------------------



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" &amp; chr(10)
strmsg=strmsg &amp; "sql=select * from progguide where
[channelno]= '" &amp;
xpl.getparam(xplmsg,"CHANNELNO",true) &amp; "'"
+chr(10)
strmsg=strmsg &amp; "starttime=" &amp; xpl.getparam
(xplmsg,"TIME",true) +chr(10)
strmsg=strmsg &amp; "duration=" &amp; xpl.getparam
(xplmsg,"DURATION",true) +chr(10)
strmsg=strmsg &amp; "title=" &amp; xpl.getparam
(xplmsg,"TITLE",true) +chr(10)
strmsg=strmsg &amp; "category=" &amp; xpl.getparam
(xplmsg,"CATEGORY",true) +chr(10)
strmsg=strmsg &amp; "description=" &amp; xpl.getparam
(xplmsg,"DESCRIPTION",true) +chr(10)

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

Thanks
Neil


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=A5M8ymtXJBUKkxb4y3V6iQF6A6oOEpp9K4iw8IxH5OjcauTN0eqvbFBXfrYnshITodr76cn18msgAGMS8J0k8BefWA">ukha_xpl@xxxxxxx</a>
To
Subscribe: <a
href="/group/ukha_xpl/post?postID=AxhKgFxwsE8-FSFM88EHjSzQ9hbVb_uWBsfeth50j2m45FUH_nZjO__gnd-aVvpGxBQOyhMgrNj7qBTufO1yoiuVa8gCxL5A5C8">ukha_xpl-subscribe@xxxxxxx</a>
To Unsubscribe: <a
href="/group/ukha_xpl/post?postID=DK6HHy-ANHUMmecG-6xfnHTH4UKkS0EVKbQUFR4dJobkzH_L_dXUrR4a8YmMxi1brA5Qx77Fk-FexQqKpv3cHOEOBnbjE0Ex_3k">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.