[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
RE: xPLRioNet query generation
- Subject: RE: xPLRioNet query generation
- From: "UKHA" <ukha@xxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 06 Mar 2005 15:27:28 +0100
- References:
<MDAEMON-F200503041857.AA571524md50000214768@beagles-den.demon.co.uk>
On 04/03/2005 at 18:00 Tony Tofts wrote:
>
>Have added the ability to preview the query on the web page (rather
than
>having to look at the queue) and if an error returns it will display
the vb
>error on the web page
>
Ok, I confess to being confused...
<query title="New Albums" device="*"
sql="select trackid from AlbumTracks WHERE
format(AlbumScanned,'yyyyMMdd')>=format(dateadd('d',-5,now),'yyyyMMdd');"
/>
AlbumTracks isn't a table in the db, although 'albums' is but there's no
trackid, only albumid in that table...
I've also noticed that all my Album scanned dates are 01/01/1980 (same for
tracks table)
Anyone else confused or is it just me :)
Andy
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
|