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: xQL Metoer SQL





The one thing I would check is the date and time inputs.  SQL can be very
particular about it's datetime formats.  For the time being try

strmsg=strmsg+"call="+ cstr(NOW()) + chr(10)

That will elimate this from the problem.

S.



"Tony Tofts"
<tony@xplhal.        To:     <ukha_xpl@xxxxxxx>
com>                 cc:
Subject:     RE: [ukha_xpl] xQL Metoer SQL
28/02/2005
11:30
Please
respond to
ukha_xpl






> Trouble is I'm having trouble with the script... Could
> someone have a look at the Complete Case below and tell me if
> it makes sense... It opens the record on the monitor but thats it....

Generally looks ok

Do all 3 messages get sent by the script ok?

I tend to use " & " rather than "+" in the string
building

Also the use of [] causes problems in mysql, maybe in sql too?

Regards
Tony



xPL Links: http://www.xplproject.org.uk http://www.xplhal.com
http://www.xpl.myby.co.uk
To Post a Message: ukha_xpl@xxxxxxx
To Subscribe:  ukha_xpl-subscribe@xxxxxxx
To Unsubscribe:  ukha_xpl-unsubscribe@xxxxxxx

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.