Re: error when trying to delete a record

On Mon, Jul 11, 2005 at 03:25:33PM +0100, Mark Rees wrote: > with no single quotes round it. Putting quotes round integer values is > counter-intuitive - is it necessary in some cases? If the field is a numeric type (e.g. INT) as opposed to numeric data being stored in a character field (e.g. a telephone number) then it is not only unnecessary to quote the value, it's also incorrect useage of SQL, although you'd probably get away with it in most database systems. Paul -- Rogue Tory http://www.roguetory.org.uk