[Message Prev][Message
Next][Thread Prev][Thread Next][Message
Index][Thread Index]
RE: xPLRioNet query generation
On 06/03/2005 at 15:27 UKHA wrote:
>
>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
>
Bugger it, damn embedded queries... found it
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
|