Re: Flat File as a Database?
You never did clarify if by flat file you mean text file? Yes, you are correct about that, sorry. I mean a delimited text file. Specifically, I am precluded from installing any database, including using access database files. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318546 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Flat File as a Database?
Hello everyone, I have a need to build a site which will not have access to a database. Instead, the client has specified that I must use a flat file. On this flat file, I need to be able insert, update, and select Honestly, I don't even know where to start. Anyone have any idea how to go about this? Is there a udf or cfc out there that would help me? Thank you for your time. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318484 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flat File as a Database?
Why can't you use a database? Is the client just being an idiot, or is there a legitimate reason for it? If you're on CF8 or Railo, you can serialize/deserialize your query objects, so you could store the data as a flat CFML/JSON file, but act on it using Query of Queries. But first I would explore why you apparently can't use a database. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flat File as a Database?
Thanks all for the replies. It sounds like some of you are in a position to fire clients. But since I get paid by the job, I can't just do that. Maybe someday, but not today. Besides, the client is not an idiot. I'm sorry, I can't go into detail about the reasons why we are limited to a flat file. But the reasons are legitimate, and cannot be circumvented. Absolutely no database can be installed. It is what it is. Yes, I get that if I can find a solution here, the flat file will be effectively a database. But hey, it's all about meeting the criteria. And a flat file absolutely will do just that. As far as what we need to accomplish, it is nothing more than basic CRUD via web forms with data download capabilities. Nothing fancy. No interface to other applications or products. Just simple CRUD on a stand-alone application. Gerald, I had not thought of ODBC text file thing. I have seen it over the years, but never messed with it. I'll look into that, thanks. Nitai, H2 looks interesting, but I can't use it here. Thanks anyway. Peter, I did reply to you earlier (from the house of fusion website). Not sure what happened. Basically, I said that all I had available to me was CF7. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318512 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Flat File as a Database?
Hi Kym, thanks for the reply. Very good question. The criteria is really No Database. There is more detailed and specific language than that, but it pretty much sums it up. As you pointed out, a filesystem is certainly a database, of sorts. I have been pondering it. It seems a bit messy though. Still, it is my fall-back plan, if I can't get find a flat file solution. But, it is not my preference. We expect not more than ten thousand entries. Likely not more than a few thousand. I would not want to risk keeping the data in memory, with periodic writes to disc. Not with this project. Thanks again. bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318514 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Install Hangs on Installing Web Connectors
First install CF with the builtin webserver and verify that everything works correctly, then install the connectors from the command line with the verbose option to see some debug output. Thank you for the reply, Jochem. I can't find anywhere how to install the web connectors from the command line. Might you be able to point me in the right direction? The stand-alone install appears to work correctly. Thank you very much for your help! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311406 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Install Hangs on Installing Web Connectors
Hello again. I am sorry to re-post this, but I am at my wits end, and I have to get this server up tomorrow. Can anyone here please help me? -Bob Hello everyone. I am stuck and am hoping someone here can help. I am trying to install CF8 x64 on a Windows Server 2008 x64 box. Unfortunately, The installer hangs when trying to install the web connectors. Before the install, I disabled Windows' firewall. I also made sure that ISAPI Filters and IIS 6 Management Compatibility roles were installed. Anyone here know how to get through this? The deadline looms... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311394 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldfusion Install Hangs on Installing Web Connectors
Hello everyone. I am stuck and am hoping someone here can help. I am trying to install CF8 x64 on a Windows Server 2008 x64 box. Unfortunately, The installer hangs when trying to install the web connectors. Before the install, I disabled Windows' firewall. I also made sure that ISAPI Filters and IIS 6 Management Compatibility roles were installed. Anyone here know how to get through this? The deadline looms... ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311353 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]
Thanks to all for the replies. It really shockes me that a simple mechanism to change the timezone of a particular app was never added to CF. I'm sure this has been a problem for many over the years. Dave pointed me to a simple UDF that did the trick. Thanks Dave! Regarding the question about remembering to change the offset when we go back to standard time, I don't think this that is an issue, is it? As long as timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can just use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right? Again, thanks all for your replies. Bob If you know of a bandage that doesn't need changing, please do share. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com SPAMTRAP] When applying a bandage over a 'wound' (beware, analogy here), you must be prepared to need change the bandage from time to time -- William Seiter ColdFusion Web Developer / Consultant http://william.seiter.com Have you ever read a book that changed your life? Go to: http://www.winninginthemargins.com Use PassKey: GoldenGrove You'll be glad you did. ::-Original Message- :: ::Sent: Monday, May 12, 2008 4:32 PM ::To: CF-Talk ::Subject: Re: Help! Can't I set a specific time zone for a CF App? [heur ::SPAMTRAP] :: ::Bobby Hartsfield wrote: :: You could store the time offset within an application variable then use ::that :: along with dateadd() within all of your dateformat and tiemformat calls :: throughout the application. :: ::what about DST changes? :: :: :: ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305183 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help! Can't I set a specific time zone for a CF App? [heur SPAMTRAP]
Right: east coast server's offset of 4+1 = 5, the offset for the mid-west client. Well, actually it's -5, but you get the point. :) If you are getting the offset from the gettimezoneinfo(), that is the servers offset, not the remote locations offset. .:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com http://cf4em.com SPAMTRAP] Thanks to all for the replies. It really shockes me that a simple mechanism to change the timezone of a particular app was never added to CF. I'm sure this has been a problem for many over the years. Dave pointed me to a simple UDF that did the trick. Thanks Dave! Regarding the question about remembering to change the offset when we go back to standard time, I don't think this that is an issue, is it? As long as timeZoneInfo.UTCtotalOffset increments to reflect the new offset, I can just use Application.TimeZone = -(timeZoneInfo.utcHourOffset+1) right? Again, thanks all for your replies. Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305201 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Help! Can't I set a specific time zone for a CF App?
Hi... I'm new here. I've been programming CF for a while but I have never come across this problem yet. I am really hoping someone here can help me. I built an application for a client in the mid-west, but serve it on a shared server on the east coast. The client wants all the times on the site to show in central time not eastern time. But I can't change the time on the server. And, I use time-math in so many places in this particular application. Isn't there some way to easily change the time zone of a particular application - like in the cfapplication or something? Surely I can't be the first person to deal with this problem! There must be an easy fix yes? Help? Bob ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305126 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4