RE: whitespace
I had a similar problem, so I used the CFSCRIPT tag and this reduced page size by as much as 25%, unfortunatly you can't use querys or custom tags in a CFScript block so there are limitations and Debuging can be a hand full. I would suggest writting the page normally in CF then converting as much as possible into a CFScript tag. HTH. Jason Lees National Express Systems Department. E-Mail : [EMAIL PROTECTED] -Original Message- From: nagesh [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 8:09 PM To: CF-Talk Subject: whitespace hi all, i really fed up with the white space which is generated in the text file by coldfusion(4.5). This happens when client(outlook) is reading the data which is in output tags and trying to write into the text(log) file. Do we have anything by which we can remove/trim the white space before it goes to text file. Because the problem here is with the white space the size of the file is getting increased like anything. I know about cfsetting enablecfoutputonly=yes tag. but i want something powerful than that. Any ideas would be greatly appreciated. Thanks nagesh ~~ 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: SQL Brain F@rt
Hi Tony, I'm using Access 2000 and I'll give this a try after I've had my morning coffee (Pepsi) Happy Holiday! Ann Harrell -Original Message- From: Tony Gruen [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 26, 2001 12:27 AM To: CF-Talk Subject: RE: SQL Brain F@rt Ann, I am hardly the sharpest mind on this forum but I got this working using my dev SQL Server 7 database. I created a table named 'data' and added a field named 'state'. I entered some records and the code below returned a results page that read like CA - 5, MA - 3, PA - 1. Here is the query cfquery name=qGetTotals datasource=test SELECT state, COUNT (state) AS StateCount FROM data GROUP BY state /cfquery and here is the output.. cfloop query=qGetTotals cfoutput#qGetTotals.state# - #qGetTotals.statecount#br/cfoutput /cfloop Hopefully this solves your question. :-) Tony Gruen sfnetworks -Original Message- From: Ann Harrell [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 9:24 PM To: CF-Talk Subject: SQL Brain F@rt I have a STATE column in a database. There are duplicate states. I want to count the states 7 MA, 3 FL, 3 IN, ect) and eventually output them to a CFGRAPH pie chart. SELECT State From databasename is as far as I've gotten. Nightie. Ann Harrell Mind like a steel trap.. Rusty and illegal in 37 states. ~~ 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
Saving document format
I was wondering if there was a way to past a word or other text document into a text field, and save it to the database so it will come out as an html document on the site. I have pages that will have profiles and articles that are in text. I'd like to beable to have the user to just copy and paste the document into a text field and retain its format. Can this be done? Thanks ahead, Gregg ~~ 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: Saving document format
Take a look at ezEdit from http://www.siteobjects.com/. It is a browser-based HTML editor, and will retain a lot of formatting if you paste text from Word into it. Matt -Original Message- From: Gregg Kachel [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 26, 2001 11:10 AM To: CF-Talk Subject: Saving document format I was wondering if there was a way to past a word or other text document into a text field, and save it to the database so it will come out as an html document on the site. I have pages that will have profiles and articles that are in text. I'd like to beable to have the user to just copy and paste the document into a text field and retain its format. Can this be done? Thanks ahead, Gregg ~~ 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
CreateUUID and Java
Is there a Java class that would create UUID's? Thanks, laszlo ~~ 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: CF with Advantage Database Server ? Anyone?
Coming from a Clipper and FoxPro background, I bought and installed Advantage Database Server but never got around to getting it setup with Cold Fusion (client decided to go with SQL Server). But, talking with the folks at Extended Systems (vendor for Advantage Database Server), they assured me that it will work via their ODBC driver. However, since the ODBC driver is not in the CF Admin ODBC picklist, you will probably have to configure it like I did with MySQL and its ODBC driver. I gave a paper at the Annapolis Cold Fusion User Group meeting May 24th on what I did to get MySQL Database Server configured with CF. Follow that analogy and I think you will be able to get Advantage Database Server configured. The Extended Systems Folks said they would help, but I never got around to asking them for assistance. Their 800 number is 800-235-7576. If you would like the paper, it will be up on the Annapolis User Group Site soon http://www.ancfug.com/meetings/ or just email me back and I will send it to you -- it's about 900mb so I didn't want to send it out via my 56k line until I am sure you are interested. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Pablo Varando [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:40 PM To: CF-Talk Subject:CF with Advantage Database Server ? Anyone? I am faced with a customer that is needing a coldfusion powered site, but his company uses a database I've never heard of called Advantage Database Server. It does have OLEDB and ODBC capabilities, but am unsure as if ColdFusion could handle this project. I thought I'd ask everyone here and see if anyone has had experience with this database and if it could be done. There is more information on this database at: http://www.advantagedatabase.com ODBC/OLE Support at: http://www.advantagedatabase.com/ADS/Product+Detail/_FAQs+and+Data+Sheet s..htm#ProductFAQs Please reply if you can help. Thanks! Pablo Varando CFM-Resources.Com http://www.cfm-resources.com ~~ 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: CreateUUID and Java
never mind, I think java.rmi.server.UID does the job laszlo Laszlo Nadai wrote: Is there a Java class that would create UUID's? Thanks, laszlo ~~ 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: forms query Question
It appears as though your game may still have issues. I'm guessing but it looks as though it is not divding the number of seconds someone is playing by 60 to create minutes when entering data into the record book. ~~ 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
Dedicated Cf Host
All- Need some recommendations on Dedicated CF hosts. Not so worried about price as I am about damm good services CB ~~ 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: CF with Advantage Database Server ? Anyone?
Yes I would be very interested in receiving that paper, I'm faced with the creation of this project, but amd having trouble with making the DB connection, any help (no matter how big it is :) I would appreciate. Thank you very much! Pablo - Original Message - From: Arden Weiss [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 26, 2001 3:21 PM Subject: RE: CF with Advantage Database Server ? Anyone? Coming from a Clipper and FoxPro background, I bought and installed Advantage Database Server but never got around to getting it setup with Cold Fusion (client decided to go with SQL Server). But, talking with the folks at Extended Systems (vendor for Advantage Database Server), they assured me that it will work via their ODBC driver. However, since the ODBC driver is not in the CF Admin ODBC picklist, you will probably have to configure it like I did with MySQL and its ODBC driver. I gave a paper at the Annapolis Cold Fusion User Group meeting May 24th on what I did to get MySQL Database Server configured with CF. Follow that analogy and I think you will be able to get Advantage Database Server configured. The Extended Systems Folks said they would help, but I never got around to asking them for assistance. Their 800 number is 800-235-7576. If you would like the paper, it will be up on the Annapolis User Group Site soon http://www.ancfug.com/meetings/ or just email me back and I will send it to you -- it's about 900mb so I didn't want to send it out via my 56k line until I am sure you are interested. ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Pablo Varando [SMTP:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 10:40 PM To: CF-Talk Subject: CF with Advantage Database Server ? Anyone? I am faced with a customer that is needing a coldfusion powered site, but his company uses a database I've never heard of called Advantage Database Server. It does have OLEDB and ODBC capabilities, but am unsure as if ColdFusion could handle this project. I thought I'd ask everyone here and see if anyone has had experience with this database and if it could be done. There is more information on this database at: http://www.advantagedatabase.com ODBC/OLE Support at: http://www.advantagedatabase.com/ADS/Product+Detail/_FAQs+and+Data+Sheet s..htm#ProductFAQs Please reply if you can help. Thanks! Pablo Varando CFM-Resources.Com http://www.cfm-resources.com ~~ 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
Unix Trouble
OK. now don't make fun of me, yet! :) However...My question is: I accidentally lost the etc folder (don't ask) while poking around inside the files of a Sun Solaris 8 box. I thought it had just dumped itself into another folder, and while in the process of looking for the etc folder, the system crashed. Of course it wouldn't come back up on reboot...what do I do next? I know it wasn't deleted...it's still there on the drive somewhere...can I boot the machine up from an external source such as a cdrom or a floppy? Thanks in advance, Erika (with a duncecap) One of the greatest pains to human nature is the pain of a new idea. - Walter Bagehot - ~~ 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: Dedicated Cf Host
Chris What sort of services are you looking for? Regards D -Original Message- From: Chris Badouin [mailto:[EMAIL PROTECTED]] Sent: 26 May 2001 21:06 To: CF-Talk Subject: Dedicated Cf Host All- Need some recommendations on Dedicated CF hosts. Not so worried about price as I am about damm good services CB ~~ 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: CF with Advantage Database Server ? Anyone?
ColdFusion can connect to ANY ODBC compliant database. Mark Warrick - Fusioneers.com Email: [EMAIL PROTECTED] Phone: 714-547-5386 http://www.fusioneers.com http://www.warrick.net -Original Message- From: Pablo Varando [mailto:[EMAIL PROTECTED]] Sent: Friday, May 25, 2001 7:40 PM To: CF-Talk Subject: CF with Advantage Database Server ? Anyone? I am faced with a customer that is needing a coldfusion powered site, but his company uses a database I've never heard of called Advantage Database Server. It does have OLEDB and ODBC capabilities, but am unsure as if ColdFusion could handle this project. I thought I'd ask everyone here and see if anyone has had experience with this database and if it could be done. There is more information on this database at: http://www.advantagedatabase.com ODBC/OLE Support at: http://www.advantagedatabase.com/ADS/Product+Detail/_FAQs+and+Data +Sheets..htm#ProductFAQs Please reply if you can help. Thanks! Pablo Varando CFM-Resources.Com http://www.cfm-resources.com ~~ 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: CF with Advantage Database Server ? Anyone?
it to you -- it's about 900mb so I didn't want to send it out via my 56k 900mb? What the heck is in that paper? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ 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: Dedicated Cf Host
If its the UK I suggest Virtual Internet - anywhere else can help. Peter Cooper ---Original Message--- From: Chris Badouin Date: 26 May 2001 22:07:33 To: CF-Talk Subject: Dedicated Cf Host All- Need some recommendations on Dedicated CF hosts. Not so worried about price as I am about damm good services CB ~~ 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: Unix Trouble
Haha. That's too funny. I was running OpenWindows one time and this stupid twitchy Sun mouse (really sensitive buttons ;p) MADE me mistakenly drag the /etc folder into the /bin folder... My mistake was to reboot - had to reinstall. On another computer I did a rm * when I meant to do a rm *~, lost that one too. ;) I know this isn't very helpful, but at least you know you're not the only one. OK. now don't make fun of me, yet! :) However...My question is: I accidentally lost the etc folder (don't ask) while poking around inside the files of a Sun Solaris 8 box. I thought it had just dumped itself into another folder, and while in the process of looking for the etc folder, the system crashed. Of course it wouldn't come back up on reboot...what do I do next? I know it wasn't deleted...it's still there on the drive somewhere...can I boot the machine up from an external source such as a cdrom or a floppy? Thanks in advance, Erika (with a duncecap) One of the greatest pains to human nature is the pain of a new idea. - Walter Bagehot - ~~ 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: Unix Trouble
Thanks Tony! I'm glad I'm not the only one! grin Makes me feel marginally better... Erika - -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 26, 2001 7:18 PM To: CF-Talk Subject: Re: Unix Trouble Haha. That's too funny. I was running OpenWindows one time and this stupid twitchy Sun mouse (really sensitive buttons ;p) MADE me mistakenly drag the /etc folder into the /bin folder... My mistake was to reboot - had to reinstall. On another computer I did a rm * when I meant to do a rm *~, lost that one too. ;) I know this isn't very helpful, but at least you know you're not the only one. OK. now don't make fun of me, yet! :) However...My question is: I accidentally lost the etc folder (don't ask) while poking around inside the files of a Sun Solaris 8 box. I thought it had just dumped itself into another folder, and while in the process of looking for the etc folder, the system crashed. Of course it wouldn't come back up on reboot...what do I do next? I know it wasn't deleted...it's still there on the drive somewhere...can I boot the machine up from an external source such as a cdrom or a floppy? Thanks in advance, Erika (with a duncecap) One of the greatest pains to human nature is the pain of a new idea. - Walter Bagehot - ~~ 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: CF with Advantage Database Server ? Anyone?
Whoops -- 900kb of course... ^ / \__ (@\___ / O /(_/ /_/ Whoof... 410-757-3487 -Original Message- From: Tony Schreiber [SMTP:[EMAIL PROTECTED]] Sent: Saturday, May 26, 2001 5:24 PM To: CF-Talk Subject:RE: CF with Advantage Database Server ? Anyone? it to you -- it's about 900mb so I didn't want to send it out via my 56k 900mb? What the heck is in that paper? Tony Schreiber, Senior Partner Man and Machine, Limited mailto:[EMAIL PROTECTED] http://www.technocraft.com http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion http://www.is300.net ___The Enthusiast's Home of the Lexus IS300 http://www.digitacamera.com __DigitA Camera Scripts and Tips http://www.linklabexchange.com _Miata Link ECU Data Exchange ~~ 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
bulk updating database from txt file
Hi I have a largish access database (30,000 records) which needs to be updated from a comma delimited text file. There will be some updated records and some new records. I am not sure how to begin with this My worries are how do I do an update loop when some records will have to be inserted and some updated. Also this would presumably take a long time to do - how do I handle this Any suggestions welcome (assume I am a bear with very little brain) or any tutorials on this sort of thing. many thanks Seamus ~~ 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: bulk updating database from txt file
I have a cf template (well a couple) that actively (via http) solicit prices from websites. I had one going that did 300,000 price updates over several days. The best way I found to run this template was via the command line, ie: e:\cfusion\bin\cfml.exe e:\webroot\scan\pricereport.cfm No request timeouts, no hung browser windows... I have a largish access database (30,000 records) which needs to be updated from a comma delimited text file. There will be some updated records and some new records. I am not sure how to begin with this My worries are how do I do an update loop when some records will have to be inserted and some updated. Also this would presumably take a long time to do - how do I handle this Any suggestions welcome (assume I am a bear with very little brain) or any tutorials on this sort of thing. many thanks Seamus ~~ 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: bulk updating database from txt file
Hmm Seamus, commonw problem I would suspect as most sites and people are finally getting to the data value :) Interested in hearing what recommendations you get... I have some stuff of my own that isn't so serious as far as reliability... I do bulk dumps and bulk imports... essentially, it is a big query... the a loop that transcends down the entry list running computations and checking on a per item basis, writing the file to the master database, ignoring it if it remains the same big queries tend to crash... so you might have to step through the process in 2-5k pieces... -paris [finding the future in the past, passing the future in the present] [connecting people, places and things] -Original Message- From: Seamus Campbell [EMAIL PROTECTED] Date: Sun, 27 May 2001 12:26:02 +1000 Subject: bulk updating database from txt file Hi I have a largish access database (30,000 records) which needs to be updated from a comma delimited text file. There will be some updated records and some new records. I am not sure how to begin with this My worries are how do I do an update loop when some records will have to be inserted and some updated. Also this would presumably take a long time to do - how do I handle this Any suggestions welcome (assume I am a bear with very little brain) or any tutorials on this sort of thing. many thanks Seamus ~~ 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: bulk updating database from txt file
That's one of the brightest ideas I've heard about ColdFusion programming. Good job, Tony. ---mark - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 26, 2001 7:48 PM Subject: Re: bulk updating database from txt file I have a cf template (well a couple) that actively (via http) solicit prices from websites. I had one going that did 300,000 price updates over several days. The best way I found to run this template was via the command line, ie: e:\cfusion\bin\cfml.exe e:\webroot\scan\pricereport.cfm No request timeouts, no hung browser windows... I have a largish access database (30,000 records) which needs to be updated from a comma delimited text file. There will be some updated records and some new records. I am not sure how to begin with this My worries are how do I do an update loop when some records will have to be inserted and some updated. Also this would presumably take a long time to do - how do I handle this Any suggestions welcome (assume I am a bear with very little brain) or any tutorials on this sort of thing. many thanks Seamus ~~ 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: Unix Trouble
This is *exactly* why you never run as root unless you absolutely have to (even then you can often get away w/ running only the current command as root using su). First suggestion is restoring from your daily backup. You *do* have a daily backup don't you? :) As far as recovery goes, assuming that the OpenBoot security level is not set to full you should be able to quickly recover with the help of the Solaris CD. Basically it will consist of booting off the CD, mounting the partition that normally contains /etc (and the partion where you think it went), and restoring it to it's proper location. For more exact details on how to do the boot and mount, you should be able to find some FAQ or info on one of the many Solaris sites ( http://directory.google.com/Top/Computers/Software/Operating_Systems/Unix/So laris/ ) or your favourite Solaris book. -Original Message- From: Erika L. Walker [mailto:[EMAIL PROTECTED]] Sent: May 26, 2001 17:02 To: CF-Talk Subject: RE: Unix Trouble Thanks Tony! I'm glad I'm not the only one! grin Makes me feel marginally better... Erika - -Original Message- From: Tony Schreiber [mailto:[EMAIL PROTECTED]] Sent: Saturday, May 26, 2001 7:18 PM To: CF-Talk Subject: Re: Unix Trouble Haha. That's too funny. I was running OpenWindows one time and this stupid twitchy Sun mouse (really sensitive buttons ;p) MADE me mistakenly drag the /etc folder into the /bin folder... My mistake was to reboot - had to reinstall. On another computer I did a rm * when I meant to do a rm *~, lost that one too. ;) I know this isn't very helpful, but at least you know you're not the only one. OK. now don't make fun of me, yet! :) However...My question is: I accidentally lost the etc folder (don't ask) while poking around inside the files of a Sun Solaris 8 box. I thought it had just dumped itself into another folder, and while in the process of looking for the etc folder, the system crashed. Of course it wouldn't come back up on reboot...what do I do next? I know it wasn't deleted...it's still there on the drive somewhere...can I boot the machine up from an external source such as a cdrom or a floppy? Thanks in advance, Erika (with a duncecap) One of the greatest pains to human nature is the pain of a new idea. - Walter Bagehot - ~~ 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: bulk updating database from txt file
I agree... good idea Tony... I am going to try my big batch of 20-30k items tonight and compare the run times :) -paris -Original Message- From: Warrick, Mark [EMAIL PROTECTED] Date: Sat, 26 May 2001 22:40:18 -0700 Subject: Re: bulk updating database from txt file That's one of the brightest ideas I've heard about ColdFusion programming. Good job, Tony. ---mark - Original Message - From: Tony Schreiber [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Saturday, May 26, 2001 7:48 PM Subject: Re: bulk updating database from txt file I have a cf template (well a couple) that actively (via http) solicit prices from websites. I had one going that did 300,000 price updates over several days. The best way I found to run this template was via the command line, ie: e:\cfusion\bin\cfml.exe e:\webroot\scan\pricereport.cfm No request timeouts, no hung browser windows... I have a largish access database (30,000 records) which needs to be updated from a comma delimited text file. There will be some updated records and some new records. I am not sure how to begin with this My worries are how do I do an update loop when some records will have to be inserted and some updated. Also this would presumably take a long time to do - how do I handle this Any suggestions welcome (assume I am a bear with very little brain) or any tutorials on this sort of thing. many thanks Seamus ~~ 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