Nick,
> > I need to modify a table on one of my Databases - to add 2 Yes/No
fields.
> > The DB is Access, and the table name "Pending."
>
> alter table pending add column col1 yesno, col2 yesno;
Strange problem with that - probably Access being pathetic. It creates the
column perfectly happily, and appears to be a Yes/No data type, but it
isn't - just says the format is blank.
Damn annoying - any ideas why this is happening?
Thanks
Will
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists