> could be the name of your field...I think key may be a reserved word. Try
> puting square brackets around the word 'key' like so: WHERE [key] = 1
> "Key" is a reserved word in Transact-SQL.
> Apart from that the syntax is fine.
Thanks for the info... will try again.
--
Aidan Whitehall <[EMAIL PROTECTED]>
Netshopper UK Ltd
Advanced Web Solutions & Services
http://www.netshopperuk.com/
Telephone +44 (01744) 648650
Fax +44 (01744) 648651
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.