RE: Slightly OT: Altering access tables in CF...
OH, I'm sorry, Brian, I misread your statement. I was reading as altering *info* in Access tables, not altering the table itself in the way you're trying to...haven't done that, so I don't know what's possible...sorry. Rick -Original Message- From: Yager, Brian T Contractor/Sverdrup [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:15 PM To: CF-Talk Subject: RE: Slightly OT: Altering access tables in CF... Did you have to do anything special? Here is my SQL Alter table index_tbl add(pic_pos number) I've also tried with number(1) but still doesn't work. Brian -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:19 AM To: CF-Talk Subject: RE: Slightly OT: Altering access tables in CF... No problem here...CF 4.5.2, Access 2000 Rick -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:02 AM To: CF-Talk Subject: Re: Slightly OT: Altering access tables in CF... Yes >>> [EMAIL PROTECTED] 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF. Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ 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: Slightly OT: Altering access tables in CF...SOLVED
thank you all. Randell showed me the error of my ways. I was using () around the column and type. It works well without them! Brian -Original Message- From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:38 AM To: CF-Talk Subject: Re: Slightly OT: Altering access tables in CF... Back when I worked with Access regularly I used to do it a lot... You might want to forward the particular query and the error to the list. > I am getting an error when I try to alter an Access table in CF. Has > anyone had any success doing this? > Thanks, > Brian Yager > President - North AL Cold Fusion Users Group > http://www.nacfug.com > Sr. Systems Analyst > Sverdrup/CIC > [EMAIL PROTECTED] > (256) 842-8342 > __ 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: Slightly OT: Altering access tables in CF...
Back when I worked with Access regularly I used to do it a lot... You might want to forward the particular query and the error to the list. > I am getting an error when I try to alter an Access table in CF. Has > anyone had any success doing this? > Thanks, > Brian Yager > President - North AL Cold Fusion Users Group > http://www.nacfug.com > Sr. Systems Analyst > Sverdrup/CIC > [EMAIL PROTECTED] > (256) 842-8342 > __ 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: Slightly OT: Altering access tables in CF...
Did you have to do anything special? Here is my SQL Alter table index_tbl add(pic_pos number) I've also tried with number(1) but still doesn't work. Brian -Original Message- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:19 AM To: CF-Talk Subject: RE: Slightly OT: Altering access tables in CF... No problem here...CF 4.5.2, Access 2000 Rick -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:02 AM To: CF-Talk Subject: Re: Slightly OT: Altering access tables in CF... Yes >>> [EMAIL PROTECTED] 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF. Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ 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: Slightly OT: Altering access tables in CF...
No problem here...CF 4.5.2, Access 2000 Rick -Original Message- From: Randell B Adkins [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 11:02 AM To: CF-Talk Subject: Re: Slightly OT: Altering access tables in CF... Yes >>> [EMAIL PROTECTED] 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF. Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ 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: Slightly OT: Altering access tables in CF...
Yes >>> [EMAIL PROTECTED] 09/30/02 10:57AM >>> I am getting an error when I try to alter an Access table in CF. Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
Slightly OT: Altering access tables in CF...
I am getting an error when I try to alter an Access table in CF. Has anyone had any success doing this? Thanks, Brian Yager President - North AL Cold Fusion Users Group http://www.nacfug.com Sr. Systems Analyst Sverdrup/CIC [EMAIL PROTECTED] (256) 842-8342 __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
