RE: MODIFY sql command
Will 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; Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
Re: MODIFY sql command
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
RE: MODIFY sql command
Will, Sorry, what do you mean by it isn't - just says the format is blank? Nick ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
Re: MODIFY sql command
Sorry, what do you mean by it isn't - just says the format is blank? Sorry, didn't explain it properly. In the Design View in Access, the new field's data type is Yes/No. But then looking at the properties, the *format* should be Yes/No (other options are On/Off or True False), but it's blank. As a result it appears to be acting like a number data type field, with Zeros in place of where the Yes/No checkbox should be. I think I'll just have to download/upload it :( Will ~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
Re: MODIFY sql command
Sorry - I meant ALTER not modify... Thanks in advance. Will - Original Message - From: W Luke [EMAIL PROTECTED] Newsgroups: cf-talk Sent: Sunday, September 23, 2001 11:48 PM Subject: MODIFY sql command Hi, 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. I really don't want to have to download, modify and upload the DB because it's over 8MB - having not really used the MODIFY statement before, can anyone advise what my query/queries should look like? Cheers 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