RE: [RE: [database update?]]
Peter, If these guys give you an update once a week they can wait 15 more minutes for the information to be available! Tell them the facts of life. Sometimes users have to be told NO! If they need faster updates let them ODBC into your database more frequently and directly update your tables. 15 minutes is nothing in the grand scheme of things. Wally Randall Date: Fri, 22 Dec 2000 14:05:29 -0500 From: Peter Benoit [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [RE: [database update?]] Message-ID: [EMAIL PROTECTED] Well it kinda can't be done that way. Essentially they throw a whole new DB at me once a week and ask that the new info be presented immediately. Currently it takes about 15 mins for the new info to appear. Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: [database update?]]
Peter, One way to do it would be to create an ODBC connection to a blank database. Then go into that db and link the tables to the database that's being uploaded. Go under FILE - GET EXTERNAL DATA - LINK TABLES. Then choose the uploaded database, and select all the relevant tables. Then when the database needs updating you don't have to worry about breaking the odbc connection etc, just replace the database. hth, larry -- Larry C. Lyons ColdFusion/Web Developer EBStor.com 8870 Rixlew Lane, Suite 201 Manassas, Virginia 20109-3795 tel: (703) 393-7930 x253 fax: (703) 393-2659 http://www.ebstor.com http://www.pacel.com email: [EMAIL PROTECTED] Chaos, panic, and disorder - my work here is done. -- Peter Benoit wrote: Well it kinda can't be done that way. Essentially they throw a whole new DB at me once a week and ask that the new info be presented immediately. Currently it takes about 15 mins for the new info to appear. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 2:00 PM To: CF-Talk Subject: Re: [RE: [database update?]] replace it over FTP at night. this has nothing to do with CF Peter Benoit [EMAIL PROTECTED] wrote: It's a whole new access DB -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit [EMAIL PROTECTED] wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: [database update?]]
replace it over FTP at night. this has nothing to do with CF Peter Benoit [EMAIL PROTECTED] wrote: It's a whole new access DB -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit [EMAIL PROTECTED] wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: [RE: [database update?]]
Well it kinda can't be done that way. Essentially they throw a whole new DB at me once a week and ask that the new info be presented immediately. Currently it takes about 15 mins for the new info to appear. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 2:00 PM To: CF-Talk Subject: Re: [RE: [database update?]] replace it over FTP at night. this has nothing to do with CF Peter Benoit [EMAIL PROTECTED] wrote: It's a whole new access DB -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit [EMAIL PROTECTED] wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: [RE: [RE: [database update?]]]
see if you can compress it somehow. Peter Benoit [EMAIL PROTECTED] wrote: Well it kinda can't be done that way. Essentially they throw a whole new DB at me once a week and ask that the new info be presented immediately. Currently it takes about 15 mins for the new info to appear. -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Friday, December 22, 2000 2:00 PM To: CF-Talk Subject: Re: [RE: [database update?]] replace it over FTP at night. this has nothing to do with CF Peter Benoit [EMAIL PROTECTED] wrote: It's a whole new access DB -Original Message- From: Alex [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 21, 2000 3:08 PM To: CF-Talk Subject: Re: [database update?] do you update the database (SQL statement) or replace the database with new access DB? Peter Benoit [EMAIL PROTECTED] wrote: I have an ODBC connection to my access database. Once a week I update that connection with a new database. It seems to take roughly 15 mins or so for that update to take place. Is there a reason for that, and can I shorten the length? ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists