Re: Flat File as a Database?
Bob Wright wrote: 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. In that case the structure-in-memory is quite viable. I would not want to risk keeping the data in memory, with periodic writes to disc. Not with this project. Hah! what do you think a database server does? We use the struct WDDX database for our stats engines with complete success. If the hit rate is not too ridiculous you write to disk as soon as the structure is updated, for our stats engine we limit it to once a second to stop the situation getting too frantic but you only need to write when there is an update so how often is the database going to be written to? Remember a flat-file database via ODBC is doing exactly the same thing. And its a database where do you draw the line, when is it a database and when is it not. A database is a collection of data, nothing more -- Yours, Kym Kovan mbcomms.net.au ~| 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:318515 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image Gallery/Scroller from Recordset
Azadi, could you explain it a little more, i need to do something similar to the scroller you have on your site! do u have an email address i can reach you at possibly?? thanks Anthony ~| 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:318516 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Flat File as a Database?
Curious, you mentioned that a database can't be 'installed' here. Someone had mentioned earlier that you might be able to use an Access database. I have very limited exposure to them, but beyond creating the connection in the CF Administrator, I think all that is done is the database file is uploaded to a directory on the site. No additional server installs are required. Please correct me if I am wrong on this. Would this solve the criteria? William -Original Message- From: Bob Wright [mailto:thecfprogram...@gmail.com] Sent: Sunday, January 25, 2009 11:00 PM To: cf-talk Subject: 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:318517 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image Gallery/Scroller from Recordset
Anthony, sorry, had no Internet here for 1/2 a day... you can email me to azadi at sabai-dee dot com if you want to. i will need to see the styles you have defined for your #carshow div tag - please include those. i have also just seen your post on EE and requested the same there... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Anthony Doherty wrote: Azadi, could you explain it a little more, i need to do something similar to the scroller you have on your site! do u have an email address i can reach you at possibly?? thanks Anthony ~| 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:318518 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
You can use a delimited text file (flat file) by setting up an ODBC data source that uses the Microsoft text driver for .txt or .csv files. I find it easier to use tab delimited files instead of comma delimited because occasionally you'll encounter commas in the data. The Microsoft text driver is available in the ODBC manager under user, system and file data sources. Hope this helps. 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. ~| 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:318519 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 8 verity collections disappearing
We recently upgraded to CF8 in our production environment and have begun experiencing the exact same issue w/ Verity going missing for no apparent reason. Did you ever find a solution? ~| 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:318520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
The terminology you are using is inconsistent since you say no database but flat file is a type of database. Back before the Web existed, flat file databases were the most common types of databases. FileMaker Pro was a flat file database product, and it was the top selling database product for a long time. Some people use MS Excel for databases or delimited lists as databases. XML is a common data storage format these days. I have worked on systems that used the file system as the database. Maybe the client is unclear what the definition of database is. The requirement of no database would imply that you are not allowed to store any structured data. -Mike Chabot On Mon, Jan 26, 2009 at 2:39 AM, Bob Wright thecfprogram...@gmail.com wrote: 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:318521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Flat File as a Database?
Bob... You never did clarify if by flat file you mean text file? andy -Original Message- From: Bob Wright [mailto:thecfprogram...@gmail.com] Sent: Monday, January 26, 2009 1:00 AM To: cf-talk Subject: 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:318522 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 8 verity collections disappearing
Well, it turns out that we neglected to uninstall CF7 from one of the production servers... That'll do it!!! ~| 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:318523 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
MX 7 has some decent capabilities with XML, if that's a viable option, I've done basic CRUD with XML, however if you have data that's in any way relational it gets complicated really quickly; not to mention, the XML files can be cumbersome and get huge pretty quickly if you're capturing data to them. Make sure that your client knows that forgoing a database means that any data captured is only as secure as the web server that it's sitting on. No database usually means that your client wants to be able to pick up and move the site on a whim. Bob Wright wrote: 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:318524 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Image Gallery/Scroller from Recordset
Hi Azadi, No Problem i just replied to your comments on EE as well! ~| 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:318525 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: SQL query sorting problem
The proper solution would be a separate table that contains the state codes with their desired sort order. That table is joined to the main table. This is probably best if you have to list all 50+ states. If you only need to list three states, then I would use CASE as Azadi suggested. In MSSQL: SELECT state ,CASE WHEN state = 'NY' THEN 1 WHEN state = 'CA' THEN 2 WHEN state = 'FL' THEN 3 END AS stateSortOrder FROM cities ORDER BY stateSortOrder mike Jim McAtee wrote: DBMS is MySQL 5. I have a report that is generated for cities within several states. The states are designated by their two letter postal abbreviations and are in a certain order. For example: 1. NY 2. CA 3. FL I would like the records of the report sorted by the original state order, then by city name. I can pull the data for the report in single query, but can't figure out how to maintain the state order. Turning the state list above into a comma delimmited list (NY,CA,FL), my query looks something like: SELECT * FROM cities WHERE state IN (cfqueryparam value=#states# list=yes) ORDER BY state, city Except that I lose the original order of the state list. There are a number of workarounds, such as looping through the states and doing one query for each. Or run the single query shown above and then in a similar manner loop through the states and do a QoQ for each. Is there a way to do this in a single query? ~| 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:318526 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
redirect question SERVER_NAME script_name
hey guys.. trying to set up a ton of redirects in application.cfm they don't seem to be working. i want if url is www.morel/tasty/ to goto a addy... cfif #CGI.SERVER_NAME# CONTAINS www.morel.com/tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif not sure if i need to check script_name to check for folder. ~| 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:318527 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: redirect question SERVER_NAME script_name
Just out put it. Dump the CGI scope to see the parts you need. SCRIPT_NAME will include the file name. Also be careful of case. Why not FindNoCase()? Adrian -Original Message- From: Paul Ihrig [mailto:pih...@gmail.com] Sent: 26 January 2009 15:13 To: cf-talk Subject: redirect question SERVER_NAME script_name hey guys.. trying to set up a ton of redirects in application.cfm they don't seem to be working. i want if url is www.morel/tasty/ to goto a addy... cfif #CGI.SERVER_NAME# CONTAINS www.morel.com/tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif not sure if i need to check script_name to check for folder. ~| 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:318528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
the flat file will be effectively a database. May be the problem is your interpretation of the term flat file. A database is a structured set of data. A flat file is an unstructured file, then by definition cannot be a database. May be you (your non idiot client) means independent file or stand alone file, which is different. There are many database systems that use undependable files. The simplest may be Access: only one file per database. Or even FoxPro : one directory per database, one file per table or index. But a true flat file would only be a representation of a database, like XML. An XML file, or an SQL code source file, can be used to represent a database as an exchange format, for import/export purpose, but it is not workable. ~| 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:318529 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Removing spaces from a string?
Trim() removes all white space, front and back. So you'll need to do many replaces or use REReplace to get at the tabs, carriage returns and linefeeds too. Adrian -Original Message- From: Joel Polsky [mailto:jsp2...@hotmail.com] Sent: 25 January 2009 22:49 To: cf-talk Subject: Re: Removing spaces from a string? Trim will only remove leading and trailing spaces. If you want to remove all spaces, Replace(StringVar, , , all) Rob At 08:59 PM 6/28/2003 +0200, cf-t...@sdsolutions.de wrote: This is correct: (and a little old to reply, but wanted to have it correct for future people who read this.. Replace(StringVar, , , all) Need quotes around ALL ~| 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:318530 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect question SERVER_NAME script_name
On Mon, Jan 26, 2009 at 10:12 AM, Paul Ihrig pih...@gmail.com wrote: hey guys.. trying to set up a ton of redirects in application.cfm they don't seem to be working. i want if url is www.morel/tasty/ to goto a addy... cfif #CGI.SERVER_NAME# CONTAINS www.morel.com/tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif Get rid of www first. cfset Request.ChannelName= ReplaceNoCase(CGI.SERVER_NAME,www.,,ALL) switch based on server name and if you need tasty then you need to add cgi.scriptname. cfswitch expression=#Trim(REQUEST.ChannelName)##CGI.ScriptName# cfcase value=morel.com/tasty http://www.morel.com/tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfcase cfdefaultcase leave this blank /cfdefaultcase /cfswitch Casey ~| 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:318532 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect question SERVER_NAME script_name
nm... cfif #CGI.SERVER_NAME# CONTAINS www.morel.ca AND #SCRIPT_NAME# CONTAINS /tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif On Mon, Jan 26, 2009 at 10:12 AM, Paul Ihrig pih...@gmail.com wrote: hey guys.. trying to set up a ton of redirects in application.cfm they don't seem to be working. i want if url is www.morel/tasty/ to goto a addy... cfif #CGI.SERVER_NAME# CONTAINS www.morel.com/tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif not sure if i need to check script_name to check for folder. ~| 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:318531 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect question SERVER_NAME script_name
On Mon, Jan 26, 2009 at 10:23 AM, Paul Ihrig pih...@gmail.com wrote: nm... cfif #CGI.SERVER_NAME# CONTAINS www.morel.ca AND #SCRIPT_NAME# CONTAINS /tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif I'd still do that in a cfswitch instead, and get rid of www before you check because people may type morel.ca not the subdomain cname www ~| 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:318535 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?
flat file databases were the most common types of databases. I may be wrong, but I think that by definition, a flat file contains unstructured data and a database contains structured data. Even a GIF or a JPEG image is not a flat file. Filemaker, Access, dBase, Clipper, Foxpro use stand alone files, not flat files. ~| 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:318534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: redirect question SERVER_NAME script_name
cgi.server_name will only give you the www.morel.com part, so you'll need to look at parts of cgi.sript_name as well to get subdir's ~| 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:318533 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?
May be the problem is your interpretation of the term flat file. A database is a structured set of data. A flat file is an unstructured file, then by definition cannot be a database. Well, no, that's not correct. The structure of a database can be as simple as a file format. A flat file can certainly contain sufficient structure to be used as a database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318536 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?
Please correct me if I am wrong on this. You're perfectly correct. ~| 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:318537 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect question SERVER_NAME script_name
Yeah, SERVER_NAME is only going to have the server name, not the subdirectory. You'll have to look at CF_TEMPLATE_PATH or PATH_TRANSLATED I think to find tasty. Greg On Mon, Jan 26, 2009 at 10:12 AM, Paul Ihrig pih...@gmail.com wrote: hey guys.. trying to set up a ton of redirects in application.cfm they don't seem to be working. i want if url is www.morel/tasty/ to goto a addy... cfif #CGI.SERVER_NAME# CONTAINS www.morel.com/tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif not sure if i need to check script_name to check for folder. ~| 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:318538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
I may be wrong, but I think that by definition, a flat file contains unstructured data and a database contains structured data. A flat file can contain structured data, but it is not relational. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318539 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect question SERVER_NAME script_name
man.. this only works if there is a folder called /tasty/ i need it to work with out the folder being there., On Mon, Jan 26, 2009 at 10:23 AM, Paul Ihrig pih...@gmail.com wrote: nm... cfif #CGI.SERVER_NAME# CONTAINS www.morel.ca AND #SCRIPT_NAME# CONTAINS /tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif On Mon, Jan 26, 2009 at 10:12 AM, Paul Ihrig pih...@gmail.com wrote: hey guys.. trying to set up a ton of redirects in application.cfm they don't seem to be working. i want if url is www.morel/tasty/ to goto a addy... cfif #CGI.SERVER_NAME# CONTAINS www.morel.com/tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif not sure if i need to check script_name to check for folder. ~| 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:318540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect question SERVER_NAME script_name
You forgot the CGI scope on the second condition here: cfif #CGI.SERVER_NAME# CONTAINS www.morel.ca AND #SCRIPT_NAME# CONTAINS /tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif Should be CGI.SCRIPT_NAME Greg On Mon, Jan 26, 2009 at 10:31 AM, Greg Luce luce...@gmail.com wrote: Yeah, SERVER_NAME is only going to have the server name, not the subdirectory. You'll have to look at CF_TEMPLATE_PATH or PATH_TRANSLATED I think to find tasty. Greg On Mon, Jan 26, 2009 at 10:12 AM, Paul Ihrig pih...@gmail.com wrote: hey guys.. trying to set up a ton of redirects in application.cfm they don't seem to be working. i want if url is www.morel/tasty/ to goto a addy... cfif #CGI.SERVER_NAME# CONTAINS www.morel.com/tasty/ cflocation url=/products/index.cfm?n1Id=1n2Id=7 addtoken=no /cfif not sure if i need to check script_name to check for folder. ~| 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:318541 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?
Bob, I realize I am coming in late here, but what about a tab or comma delimited file? You can link it to an Access Data source and by doing that you can add/edit/delete records easily as long as your delimited list contains a unique key column. Terry Troxel -Original Message- From: Bob Wright [mailto:thecfprogram...@gmail.com] Sent: Sunday, January 25, 2009 9:51 AM To: cf-talk Subject: 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:318542 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL query sorting problem
DBMS is MySQL 5. I have a report that is generated for cities within several states. The states are designated by their two letter postal abbreviations and are in a certain order. For example: 1. NY 2. CA 3. FL I would like the records of the report sorted by the original state order, then by city name. I can pull the data for the report in single query, but can't figure out how to maintain the state order. Turning the state list above into a comma delimmited list (NY,CA,FL), my query looks something like: SELECT * FROM cities WHERE state IN (cfqueryparam value=#states# list=yes) ORDER BY state, city Except that I lose the original order of the state list. There are a number of workarounds, such as looping through the states and doing one query for each. Or run the single query shown above and then in a similar manner loop through the states and do a QoQ for each. Is there a way to do this in a single query? You can do this in a very easy and elegant manner with MySQL. No need for join or nasty case statements SELECT * FROM cities WHERE state IN (cfqueryparam value=#states# list=yes) ORDER BY FIND_IN_SET(state, cfqueryparam value=#states#), city NB. the second cfqueryparam is not a list, its just a comma seperated string like NY,CA,FL ~| 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:318543 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Printing out a List of all my servers data sources
How do I go about printing out a list of all my CFadmin data sources with the location of the source files as well? I would like it for back up purposes in order to recreate the dsn's if I want to move the server. Terry Troxel ~| 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:318544 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFENCODE Decoder
How can I decode a CFENCODE.exe file? One of my developers deleted a file w/o backing it up. *_* Do any of you out there have one of those handy litte tools to decode a CFENDODE.exe'ed file? You can email me of list if you want to remain anonymous :) Thanks! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email svanvl...@semprautilities.com mailto:svanvl...@sempra.com _ _ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority. com/signup.cfm ~| 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:318545 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
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
Re: Printing out a List of all my servers data sources
You can get the list of DSNs like so: /* Get factory */ variables.fObj = createObject(java, coldfusion.server.ServiceFactory); /* Get datasource service */ variables.dsService = variables.fObj.getDataSourceService(); /* Get data sources */ var dsFull = variables.dsService.getNames(); That will return dsFull as an array of DSN names on the server. Not sure where to get the file locations, but I'm guessing you can find in the DataSourceService. ~| 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:318547 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?
What about databases you dont have to install? Like sqlite? I don't think CF has the greatest compability with it (I think I ran into problems with using cfqueryparam and OOP) but it'd certainly be better than working with a freaking .txt file. Just my 2 pennies.. and yea, I'll take the change On Mon, Jan 26, 2009 at 10:12 AM, Bob Wright thecfprogram...@gmail.com wrote: 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:318548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
Just an idea: I think you can use MS ODBC to deal with delimited text file as a database or You can do this: 1. Convert the text file as a recordset. This can be done by converting your delimited text file (CSV) to CF Query (recordset) 2. Use QoQ for select operation against the recordset. 3. For insert operation, you can use queryaddrow - querysetcell 4. For update operation, you can use querysetcell 5. For delete operation, you can put a marker - an extra field to denote whether that record should be removed or not When you are finished, you can then rewrite the recordset back into CSV. (Don't forget to exclude records marked for deletion above) HTH, Rizal www.masrizal.com ColdFusion Custom Tags And More At 11:12 PM 1/26/2009, you wrote: 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:318549 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: redirect question SERVER_NAME script_name
ok. it dosnt work if there is no folder on the server called tasty CGI.SCRIPT_NAME it does work if there is a folder. ~| 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:318550 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
I'm not sure exactly how it's done, but I know fusebuilder stores all of its data in WDDX format in a text file. Might work for your purposes. http://livedocs.adobe.com/coldfusion/6.1/htmldocs/tags-c20.htm Mike Bob Wright wrote: 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:318551 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Printing out a List of all my servers data sources
Can't you get all that using the Admin API? http://livedocs.adobe.com/coldfusion/8/htmldocs/basiconfig_37.html Paul. On Mon, Jan 26, 2009 at 11:18 AM, Jason Fisher ja...@wanax.com wrote: You can get the list of DSNs like so: /* Get factory */ variables.fObj = createObject(java, coldfusion.server.ServiceFactory); /* Get datasource service */ variables.dsService = variables.fObj.getDataSourceService(); /* Get data sources */ var dsFull = variables.dsService.getNames(); That will return dsFull as an array of DSN names on the server. Not sure where to get the file locations, but I'm guessing you can find in the DataSourceService. ~| 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:318552 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
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. I would second Greg's suggestion, except that I'd recommend you look at Apache Derby, which is included with CF 8. You can just drop your Derby database files on the server, point to them, and go. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318553 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFENCODE Decoder
What version of CF was it encoded with? It makes a difference... On Mon, Jan 26, 2009 at 9:08 AM, Ennio Bozzetti enniobozze...@gmail.comwrote: How can I decode a CFENCODE.exe file? One of my developers deleted a file w/o backing it up. *_* Do any of you out there have one of those handy litte tools to decode a CFENDODE.exe'ed file? You can email me of list if you want to remain anonymous :) Thanks! -- Scott Van Vliet Sempra Energy 555 W. 5th St., 21st Floor Los Angeles, CA 90013 Tel 213.244.5205 Email svanvl...@semprautilities.com mailto:svanvl...@sempra.com _ _ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority. com/signup.cfm ~| 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:318554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
What about creating a CFC which handles your delimited text file (using CFFILE)? just mimic the sql commands if its easier to remember: insert delete update select Within your select you would wrap your matching line in a ListToArray() function and pass your result sets back as a query. Then it is basically transparent to coldfusion. speeves On Mon, Jan 26, 2009 at 11:00 AM, Dave Watts dwa...@figleaf.com wrote: 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. I would second Greg's suggestion, except that I'd recommend you look at Apache Derby, which is included with CF 8. You can just drop your Derby database files on the server, point to them, and go. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318555 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
Within your select you would wrap your matching line in a ListToArray() function and pass your result sets back as a query. Just to clarify, you would split the line into and array, and build a custom query: http://www.devx.com/webdev/Article/27963 ~| 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:318556 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
Not sure if this got mentioned already, but there are DBs that run off a single file, such as sqlite. I found sqlite incredibly fast and easy to use with Adobe Air. There is also a jdbc sqlite connection, so talking to it with CF is cake. Not sure if that will qualify in your case (as a flat? file) but thought I would mention it. -Brian ~| 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:318557 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Printing out a List of all my servers data sources
QD cfset conn = createObject(java,coldfusion.server.ServiceFactory) !--- Create a List to loop over --- cfset dbList = listSort(structKeyList(conn.DataSourceService.getDatasources()),textnocase) cfoutput cfloop list=#dbList# index=dsnName #dsnName# br / /cfloop /cfoutput On Mon, Jan 26, 2009 at 10:57 AM, Terry Troxel te...@it-werks.com wrote: How do I go about printing out a list of all my CFadmin data sources with the location of the source files as well? I would like it for back up purposes in order to recreate the dsn's if I want to move the server. Terry Troxel ~| 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:318558 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Cfwindow caching
Has anyone experienced the same issue I have had? I have to create a time stamp to keep the window from caching and then remove the window from cache every time. There is nothing in CFdocs that says you have to do this. However, if you do not then the window object caches the contents and opening and closing different windows become impossible. function CatWindow(val) { ColdFusion.Window.create('Category', val,'cats.cfm?id=' + val, {x:100,y:100,height:350,width:350,modal:false,closable:true, draggable:true,resizable:false,center:true,initshow:true}) } function close_window(val) { ColdFusion.Window.getWindowObject(val).destroy(true); ColdFusion.objectCache[val] = null; } ~| 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:318559 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Printing out a List of all my servers data sources
Gerald, This works great. Now where do I go to print the source file name and location as that's the reason for all this as I can print the page in CFAdmin that lists all my datasources. Terry -Original Message- From: Gerald Guido [mailto:gerald.gu...@gmail.com] Sent: Monday, January 26, 2009 10:21 AM To: cf-talk Subject: Re: Printing out a List of all my servers data sources QD cfset conn = createObject(java,coldfusion.server.ServiceFactory) !--- Create a List to loop over --- cfset dbList = listSort(structKeyList(conn.DataSourceService.getDatasources()),textnocase ) cfoutput cfloop list=#dbList# index=dsnName #dsnName# br / /cfloop /cfoutput On Mon, Jan 26, 2009 at 10:57 AM, Terry Troxel te...@it-werks.com wrote: How do I go about printing out a list of all my CFadmin data sources with the location of the source files as well? I would like it for back up purposes in order to recreate the dsn's if I want to move the server. Terry Troxel ~| 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:318560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Copying files to a network directory
This may be an obvious question. There is a file what I want to copy using coldfusion to a directory that I have write permission to -. However when I try this, I get an access denied error. Do I need to use ftp to copy files over, or the like? Thanks a great deal. NG ~| 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:318561 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?
On Sun, Jan 25, 2009 at 6:51 PM, Bob Wright wrote: 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. Do you normally build a data access layer that is abstracted away from the rest of the code? If so, just build the site as you normally would and then replace the data access layer. If not, now is a good time to start. Jochem -- Jochem van Dieten http://jochem.vandieten.net/ ~| 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:318562 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Flat File as a Database?
ie /etc/{group,passwd,resolv.conf} On Mon, Jan 26, 2009 at 9:27 AM, Dave Watts dwa...@figleaf.com wrote: May be the problem is your interpretation of the term flat file. A database is a structured set of data. A flat file is an unstructured file, then by definition cannot be a database. Well, no, that's not correct. The structure of a database can be as simple as a file format. A flat file can certainly contain sufficient structure to be used as a database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Printing out a List of all my servers data sources
How do I go about printing out a list of all my CFadmin data sources with the location of the source files as well? I would like it for back up purposes in order to recreate the dsn's if I want to move the server. If you have access to the server's filesystem, just grab neo-datasource.xml if you're using CF 8, or neo-query.xml if you're using CF 7 or 6. If you have access to the CF Administrator, and have CF Enterprise or are willing to temporarily remove your serial number so that your server will have CF Enterprise trial version, you can create a CAR file with all your datasources from the CF Administrator, and then just read from the CAR file on the new server. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318564 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Copying files to a network directory
Nope. As long as the user under which CF us running has permissions to the file server you're golden. Just remember that CF probably isn't running as you. -Original Message- From: Nupur Gupta [mailto:nupurgupta0...@gmail.com] Sent: Monday, January 26, 2009 1:23 PM To: cf-talk Subject: Copying files to a network directory This may be an obvious question. There is a file what I want to copy using coldfusion to a directory that I have write permission to -. However when I try this, I get an access denied error. Do I need to use ftp to copy files over, or the like? Thanks a great deal. NG ~| 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:318565 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How do I traverse XML using ColdFusion?
I'd like to hit the list up again on this subject if I could. Ezra helped me immensley, but I'm still having trouble. First, just so Ezra knows, this authHeader business you gave me worked just fine. I'm authenticating and am able to call methods. BUT, it's not working like I expected -- or even like the getIPAddress() example earlier in this thread. I take for my example another relatively simple method call: getYears(). This method takes exactly one argument: a string representing the CountryCode (U = United States, C = Canada, B = Both). Now the C# example shows something like: ws.getYears(U) Wouldn't it be lovely if that's all *I* had to do, too? But no. When I look up the Years element in the WSDL I find: s:element name=Years s:complexType s:sequence s:element minOccurs=0 maxOccurs=1 name=sCountryCode type=s:string/ /s:sequence /s:complexType /s:element It's a complex type. Well, thanks to Ezra I know that this means a CF structure. So I create a structure with a member called 'sCountryCode' and I set it to U. So my code becomes: cfscript wsurl = https://www.blackbookws.com/UsedCarWS.asmx?WSDL;; portname = UsedCarWS1; portname = UsedCarWS; ws = CreateObject(webservice, wsurl, portname); authHeader = xmlNew(); authHeader.UserCredentials = xmlElemNew(authHeader, http://localhost/webservices/UsedCarWS;, UserCredentials); // authHeader stuff here... ommitted for space... args = structNew(); args.sCountryCode = U; response = ws.getYears(args); /cfscript cfdump var=#response# So, response is now an object of type localhost.webservices.UsedCarWS.YearsResponse that contains several functions. Just like in the getIPAddress() example there was a method that required no arguments that allowed me to get the returned data. In this case it's called getYearsResult(). Here comes the problem. When I run getYearsResult(), instead of getting back some sort of data structure with all of the available years in it, I get another object with methods like: equals(java.lang.Object) getDeserializer(java.lang.String, java.lang.Class, javax.xml.namespace.QName) getSerializer(java.lang.String, java.lang.Class, javax.xml.namespace.QName) getTypeDesc() get_any() hashCode() set_any(org.apache.axis.message.MessageElement[]) This confuses me even more. I have verified with the web service provider that I am authenticting correctly and that the function is getting called. I can't tell what data is coming back, but it is running and wouldn't do so if I didn't authenticate correctly, so that's not the issue. Any ideas what I'm doing wrong (other than trying to consume a SOAP based web service)? This is obviously much, much easier in a .NET environment. Thanks, Chris On Sat, Jan 24, 2009 at 12:50 PM, Ezra Parker e...@cfgrok.com wrote: You're welcome, I'm glad that helped. As far as authentication goes, it looks like this needs to be submitted as a SOAP header. I'm not too familiar with that aspect of web services, but here is my stab at it: cfscript wsurl = https://www.blackbookws.com/UsedCarWS.asmx?WSDL;; portname = UsedCarWS; ws = CreateObject(webservice, wsurl, portname); authHeader = xmlNew(); authHeader.UserCredentials = xmlElemNew(authHeader, http://localhost/webservices/UsedCarWS;, UserCredentials); authHeader.UserCredentials.userid = xmlElemNew(authHeader, userid); authHeader.UserCredentials.userid.xmlText = userid; //plug in your userid value here authHeader.UserCredentials.password = xmlElemNew(authHeader, password); authHeader.UserCredentials.password.xmlText = password; //plug in your password value here authHeader.UserCredentials.company = xmlElemNew(authHeader, company); authHeader.UserCredentials.company.xmlText = company; //plug in your company value here authHeader.UserCredentials.producttype = xmlElemNew(authHeader, producttype); authHeader.UserCredentials.producttype.xmlText = producttype; //plug in your producttype value here authHeader.UserCredentials.returncode = xmlElemNew(authHeader, returncode); authHeader.UserCredentials.returncode.xmlText = 0; //this needs to be an integer authHeader.UserCredentials.returnmessage = xmlElemNew(authHeader, returnmessage); authHeader.UserCredentials.returnmessage.xmlText = returnmessage; //can this be an empty string? addSOAPRequestHeader(ws, ignored, ignored, authHeader); body = structNew(); response = ws.getAllStates(body); /cfscript cfdump var=#response# I'm creating the header as an XML document (there may be a less verbose way of dealing with this -- if so, I'd love to hear it), and using the namespace indicated in the examples listed here: https://www.blackbookws.com/UsedCarWS.asmx?op=AllStates You will need to plug in the correct values for userid, password, etc., of course. I cannot tell if this works, as I obviously do not have the authentication credentials, but it does not thrown an error, and returns what
RE: From and ReplyTo address, CFMAIL and Spam filters...
Les Mizzell wrote: They suggested switching all cfmail from parameters to a trusted address like fo...@mysite.com, and simply having the address of the sender in the body somewhere. Les: So long as CF is authenticating against their mail server with a username and password, it shouldn't matter what address is in the From header. Make sure that CF logs in to the SMTP server with a valid username/password combo (either set in the CF Administrator or as attributes of the CFMAIL tag) and, assuming they haven't poorly configured their mail servers, the email should go through fine. Oftentimes, SMTP servers are configured to only accept messages with a From header that includes the SMTP server's domain. However, if the server supports authentication (as they all should to better prevent Spam), the authentication tends to override the previous requirement. -- Mosh Teitelbaum evoch, LLC http://www.evoch.com/ ~| 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:318567 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Copying files to a network directory
Nupur Gupta wrote: This may be an obvious question. There is a file what I want to copy using coldfusion to a directory that I have write permission to -. However when I try this, I get an access denied error. Do I need to use ftp to copy files over, or the like? Nupur: When trying to access a network share, you have to either have the CF service run as a user with a mapped drive to the share or use the file's UNC path (\\server\share) in your CF code. By default, ColdFusion does not run as a standard user account (which can have mapped drives); instead, it runs as a local service (which cannot have mapped drives). So, either change how the service logs in (via the Services control panel applet or use the UNC. -- Mosh Teitelbaum evoch, LLC http://www.evoch.com/ ~| 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:318568 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Copying files to a network directory
When trying to access a network share, you have to either have the CF service run as a user with a mapped drive to the share or use the file's UNC path (\\server\share) in your CF code. By default, ColdFusion does not run as a standard user account (which can have mapped drives); instead, it runs as a local service (which cannot have mapped drives). So, either change how the service logs in (via the Services control panel applet or use the UNC. By default, CF can't access UNC paths either, because SYSTEM doesn't have network access. You will need to run CF with a user account that has permission to the share in question. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318569 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: From and ReplyTo address, CFMAIL and Spam filters...
Oftentimes, SMTP servers are configured to only accept messages with a From header that includes the SMTP server's domain. However, if the server supports authentication (as they all should to better prevent Spam), the authentication tends to override the previous requirement. If the domain to which the sender's address belongs has SPF records configured, the target mail server may well reject messages from your server that claim to be from that sender. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318570 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do I traverse XML using ColdFusion?
bump? :o/ On Mon, Jan 26, 2009 at 1:49 PM, Chris Jordan chris.s.jor...@gmail.comwrote: I'd like to hit the list up again on this subject if I could. Ezra helped me immensley, but I'm still having trouble. First, just so Ezra knows, this authHeader business you gave me worked just fine. I'm authenticating and am able to call methods. ... BUT, it's not working like I expected -- or even like the getIPAddress() example earlier in this thread. I take for my example another relatively simple method call: getYears(). This method takes exactly one argument: a string representing the CountryCode (U = United States, C = Canada, B = Both). Now the C# example shows something like: ws.getYears(U) Wouldn't it be lovely if that's all *I* had to do, too? But no. When I look up the Years element in the WSDL I find: s:element name=Years s:complexType s:sequence s:element minOccurs=0 maxOccurs=1 name=sCountryCode type=s:string/ /s:sequence /s:complexType /s:element It's a complex type. Well, thanks to Ezra I know that this means a CF structure. So I create a structure with a member called 'sCountryCode' and I set it to U. So my code becomes: cfscript wsurl = https://www.blackbookws.com/UsedCarWS.asmx?WSDL;; portname = UsedCarWS1; portname = UsedCarWS; ws = CreateObject(webservice, wsurl, portname); authHeader = xmlNew(); authHeader.UserCredentials = xmlElemNew(authHeader, http://localhost/webservices/UsedCarWS;, UserCredentials); // authHeader stuff here... ommitted for space... args = structNew(); args.sCountryCode = U; response = ws.getYears(args); /cfscript cfdump var=#response# So, response is now an object of type localhost.webservices.UsedCarWS.YearsResponse that contains several functions. Just like in the getIPAddress() example there was a method that required no arguments that allowed me to get the returned data. In this case it's called getYearsResult(). Here comes the problem. When I run getYearsResult(), instead of getting back some sort of data structure with all of the available years in it, I get another object with methods like: equals(java.lang.Object) getDeserializer(java.lang.String, java.lang.Class, javax.xml.namespace.QName) getSerializer(java.lang.String, java.lang.Class, javax.xml.namespace.QName) getTypeDesc() get_any() hashCode() set_any(org.apache.axis.message.MessageElement[]) This confuses me even more. I have verified with the web service provider that I am authenticting correctly and that the function is getting called. I can't tell what data is coming back, but it is running and wouldn't do so if I didn't authenticate correctly, so that's not the issue. Any ideas what I'm doing wrong (other than trying to consume a SOAP based web service)? This is obviously much, much easier in a .NET environment. Thanks, Chris On Sat, Jan 24, 2009 at 12:50 PM, Ezra Parker e...@cfgrok.com wrote: You're welcome, I'm glad that helped. As far as authentication goes, it looks like this needs to be submitted as a SOAP header. I'm not too familiar with that aspect of web services, but here is my stab at it: cfscript wsurl = https://www.blackbookws.com/UsedCarWS.asmx?WSDL;; portname = UsedCarWS; ws = CreateObject(webservice, wsurl, portname); authHeader = xmlNew(); authHeader.UserCredentials = xmlElemNew(authHeader, http://localhost/webservices/UsedCarWS;, UserCredentials); authHeader.UserCredentials.userid = xmlElemNew(authHeader, userid); authHeader.UserCredentials.userid.xmlText = userid; //plug in your userid value here authHeader.UserCredentials.password = xmlElemNew(authHeader, password); authHeader.UserCredentials.password.xmlText = password; //plug in your password value here authHeader.UserCredentials.company = xmlElemNew(authHeader, company); authHeader.UserCredentials.company.xmlText = company; //plug in your company value here authHeader.UserCredentials.producttype = xmlElemNew(authHeader, producttype); authHeader.UserCredentials.producttype.xmlText = producttype; //plug in your producttype value here authHeader.UserCredentials.returncode = xmlElemNew(authHeader, returncode); authHeader.UserCredentials.returncode.xmlText = 0; //this needs to be an integer authHeader.UserCredentials.returnmessage = xmlElemNew(authHeader, returnmessage); authHeader.UserCredentials.returnmessage.xmlText = returnmessage; //can this be an empty string? addSOAPRequestHeader(ws, ignored, ignored, authHeader); body = structNew(); response = ws.getAllStates(body); /cfscript cfdump var=#response# I'm creating the header as an XML document (there may be a less verbose way of dealing with this -- if so, I'd love to hear it), and using the namespace indicated in the examples listed here: https://www.blackbookws.com/UsedCarWS.asmx?op=AllStates You will need to plug in the correct values for userid, password,
Re: How do I traverse XML using ColdFusion?
This is a bit of a stab in the dark, as I believe that I am seeing an empty response due to the fact that I am not authenticated, but give this a try (continuing from the last line of your script block): response = ws.getYears(args); result = response.getYearsResult().get_any(); At this point, result will be an array containing two Java objects of the class org.apache.axis.message.MessageElement. Try dumping one or both, and investigating the methods they expose: cfdump var=#result[1]# cfdump var=#result[2]# In my case, I note that result[1].getName() returns schema (which sounds promising), result[1].getAttribute(javacast(string, id)) returns NewDataSet (sounds even more promising), and that result[1].getValue() returns NULL (therefore I think this is an empty result set). I hope that is helpful... -- Ezra Parker ~| 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:318572 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do I traverse XML using ColdFusion?
Ezra! Bless you for responding with even a stab in the dark. If this is it, I'll scream because I thought I tried that already, but I'm gonna give it a go right now. Stay tuned... :o) Chris On Mon, Jan 26, 2009 at 4:27 PM, Ezra Parker e...@cfgrok.com wrote: This is a bit of a stab in the dark, as I believe that I am seeing an empty response due to the fact that I am not authenticated, but give this a try (continuing from the last line of your script block): response = ws.getYears(args); result = response.getYearsResult().get_any(); At this point, result will be an array containing two Java objects of the class org.apache.axis.message.MessageElement. Try dumping one or both, and investigating the methods they expose: cfdump var=#result[1]# cfdump var=#result[2]# In my case, I note that result[1].getName() returns schema (which sounds promising), result[1].getAttribute(javacast(string, id)) returns NewDataSet (sounds even more promising), and that result[1].getValue() returns NULL (therefore I think this is an empty result set). I hope that is helpful... -- Ezra Parker ~| 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:318573 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: From and ReplyTo address, CFMAIL and Spam filters...
So long as CF is authenticating against their mail server with a username and password, it shouldn't matter what address is in the From header. Make sure that CF logs in to the SMTP server with a valid username/passw] According to HostMySite - sending from the server isn't the problem. All email reported missing was actually sent, according to their logs. However, heavy handed spam/spoof filters elsewhere on the way to the final destination are looking at email being sent by mail server A, but a from address of mail server B, and are filtering because of the domain mismatch. So, the from address should be a trusted address from the same domain as the mail server to avoid filtering. The replyto address can be anything, and that's where the form sender address needs to be. Makes sense to me anyway. ~| 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:318574 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: From and ReplyTo address, CFMAIL and Spam filters...
However, heavy handed spam/spoof filters elsewhere on the way to the final destination are looking at email being sent by mail server A, but a from address of mail server B, and are filtering because of the domain mismatch. That's not heavy handed, it's proper configuration. That's why we have things like SPF. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| 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:318575 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: From and ReplyTo address, CFMAIL and Spam filters...
That's not heavy handed, it's proper configuration. That's why we have things like SPF. Bad choice of words! My bad! We all know what I meant though... ~| 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:318576 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL query sorting problem
Mike, the way i read OP's question is that the order of states is not fixed, but user-defined: i.e. a user selects several states in several select lists and the data returned must be in the order of selected states. but in case of pre-defined order of states, your suggestion will be perfect. Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Dawson, Michael wrote: The proper solution would be a separate table that contains the state codes with their desired sort order. That table is joined to the main table. This is probably best if you have to list all 50+ states. If you only need to list three states, then I would use CASE as Azadi suggested. In MSSQL: SELECT state ,CASE WHEN state = 'NY' THEN 1 WHEN state = 'CA' THEN 2 WHEN state = 'FL' THEN 3 END AS stateSortOrder FROM cities ORDER BY stateSortOrder mike Jim McAtee wrote: DBMS is MySQL 5. I have a report that is generated for cities within several states. The states are designated by their two letter postal abbreviations and are in a certain order. For example: 1. NY 2. CA 3. FL I would like the records of the report sorted by the original state order, then by city name. I can pull the data for the report in single query, but can't figure out how to maintain the state order. Turning the state list above into a comma delimmited list (NY,CA,FL), my query looks something like: SELECT * FROM cities WHERE state IN (cfqueryparam value=#states# list=yes) ORDER BY state, city Except that I lose the original order of the state list. There are a number of workarounds, such as looping through the states and doing one query for each. Or run the single query shown above and then in a similar manner loop through the states and do a QoQ for each. Is there a way to do this in a single query? ~| 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:318577 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL query sorting problem
that's very neat, chris! i didn't think one could use FIND_IN_SET in ORDER BY clause - live and learn! Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Chris Blackwell wrote: You can do this in a very easy and elegant manner with MySQL. No need for join or nasty case statements SELECT * FROM cities WHERE state IN (cfqueryparam value=#states# list=yes) ORDER BY FIND_IN_SET(state, cfqueryparam value=#states#), city NB. the second cfqueryparam is not a list, its just a comma seperated string like NY,CA,FL ~| 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:318578 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Cfwindow caching
try adding refreshOnShow:true to your cfwindow's parameters ? Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Tony Bentley wrote: Has anyone experienced the same issue I have had? I have to create a time stamp to keep the window from caching and then remove the window from cache every time. There is nothing in CFdocs that says you have to do this. However, if you do not then the window object caches the contents and opening and closing different windows become impossible. function CatWindow(val) { ColdFusion.Window.create('Category', val,'cats.cfm?id=' + val, {x:100,y:100,height:350,width:350,modal:false,closable:true, draggable:true,resizable:false,center:true,initshow:true}) } function close_window(val) { ColdFusion.Window.getWindowObject(val).destroy(true); ColdFusion.objectCache[val] = null; } ~| 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:318579 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
I am having the same problem with DW I found this posting online http://kb.adobe.com/selfservice/viewContent.do?externalId=kb402776 followed the directions and it is still crashing. I have been so unproductive behind this that i decided to install eclipse. That became a nightmare as there is not good documentation on how to set it up. Does anyone know of a good free CF editor? ~| 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:318580 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
I am having the same problem with DW I found this posting online http://kb.adobe. com/selfservice/viewContent.do?externalId=kb402776 followed the directions and it is still crashing. I have been so unproductive behind this that i decided to install eclipse. That became a nightmare as there is not good documentation on how to set it up. Does anyone know of a good free CF editor? P.S. I have been sitting here for 3 hours restarting DW and trying to install CFECLIPSE. I have resorted to downloading a trial version of HOMESITE (I can't believe they are still selling HS) which is SAD. I am praying that IT works. A word to all current and aspiring software developers and tutorial writers, bloggers, whoever PLEASE PLEASE PLEASE PLEASE make sure your software works properly and if you write a tutorial PLEASE PLEASE PLEASE PLEASE make sure your instructions work INCLUDING PROPER SYNTAX and PLEASE PLEASE PLEASE PLEASE write a detailed description of how to install, setup and use your product. I have wasted so much production time on Dreamweaver crashing - it's pathetic. I know I am ranting but I've had it. Make it work or make it free so others can make it work. And if you do make it free like ECLIPSE, hire a darn tech writer so people can learn how to use your software ~| 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:318581 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
At what point is your CFEclipse install not working? Matthew Williams Geodesic GraFX ~| 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:318582 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
You can try this if you are still interested in Eclipse http://www.yoxos.com/ondemand/ it basically allows you to choose what plugins/whatever you want for Eclipse, and then puts it all into a single package that you download and install (1 step, pretty sure anyways) HTH Rob On Mon, Jan 26, 2009 at 10:20 PM, Torrent Girl torrentg...@gmail.comwrote: I am having the same problem with DW I found this posting online http://kb.adobe. com/selfservice/viewContent.do?externalId=kb402776 followed the directions and it is still crashing. I have been so unproductive behind this that i decided to install eclipse. That became a nightmare as there is not good documentation on how to set it up. Does anyone know of a good free CF editor? P.S. I have been sitting here for 3 hours restarting DW and trying to install CFECLIPSE. I have resorted to downloading a trial version of HOMESITE (I can't believe they are still selling HS) which is SAD. I am praying that IT works. A word to all current and aspiring software developers and tutorial writers, bloggers, whoever PLEASE PLEASE PLEASE PLEASE make sure your software works properly and if you write a tutorial PLEASE PLEASE PLEASE PLEASE make sure your instructions work INCLUDING PROPER SYNTAX and PLEASE PLEASE PLEASE PLEASE write a detailed description of how to install, setup and use your product. I have wasted so much production time on Dreamweaver crashing - it's pathetic. I know I am ranting but I've had it. Make it work or make it free so others can make it work. And if you do make it free like ECLIPSE, hire a darn tech writer so people can learn how to use your software ~| 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:318583 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
I have found Dreamweaver to be a very stable application. From version 8 to CS3 to CS4.If you were really interested in solving your problem, I'd get rid of it completely and start again from the beginning. I'd adivise: [1] Uninstalling it completely. [2] Delete any folders or files that might be left in the install directory [3] Delete any user preferences (in windows, they're in C:\Documents and Settings\username\Application Data\Adobe\Dreamweaver CS4\en_US\Configuration [4] remove any keys in the registry [5] reboot. Then you should have removed every reference to Dreamweaver. Then I'd advise starting again from the beginning. I suspect the reason your DW is crashing all the time is there is some remnant somewhere from a previous installation that's not being overwritten by a reinstall, or some corrupted file somewhere that's not removed by the previous uninstall. I dont suppose your handle is a clue to what's gone wrong is it? Torrent girl?? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jan 27, 2009 at 2:56 PM, Rob Parkhill robert.parkh...@gmail.com wrote: You can try this if you are still interested in Eclipse http://www.yoxos.com/ondemand/ it basically allows you to choose what plugins/whatever you want for Eclipse, and then puts it all into a single package that you download and install (1 step, pretty sure anyways) HTH Rob On Mon, Jan 26, 2009 at 10:20 PM, Torrent Girl torrentg...@gmail.comwrote: I am having the same problem with DW I found this posting online http://kb.adobe. com/selfservice/viewContent.do?externalId=kb402776 followed the directions and it is still crashing. I have been so unproductive behind this that i decided to install eclipse. That became a nightmare as there is not good documentation on how to set it up. Does anyone know of a good free CF editor? P.S. I have been sitting here for 3 hours restarting DW and trying to install CFECLIPSE. I have resorted to downloading a trial version of HOMESITE (I can't believe they are still selling HS) which is SAD. I am praying that IT works. A word to all current and aspiring software developers and tutorial writers, bloggers, whoever PLEASE PLEASE PLEASE PLEASE make sure your software works properly and if you write a tutorial PLEASE PLEASE PLEASE PLEASE make sure your instructions work INCLUDING PROPER SYNTAX and PLEASE PLEASE PLEASE PLEASE write a detailed description of how to install, setup and use your product. I have wasted so much production time on Dreamweaver crashing - it's pathetic. I know I am ranting but I've had it. Make it work or make it free so others can make it work. And if you do make it free like ECLIPSE, hire a darn tech writer so people can learn how to use your software ~| 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:318584 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Submitting larger data using cfajaxproxy
Hi all, I'm submitting my form using cfajaxproxy(using remote method invocation). it is working fine with small data. my page is having a text area. if we give larger text say like 500 chars, the sumbit action is throwing javascript error. the CFC is not able to handle it. is there any solution for this issue ? please help ~| 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:318585 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
But, does it actually explain how to set up a project and actually use the UI? ;) I'm already in the middle of getting a tutorial together for setting up a new CFEclipse project. I don't mind releasing it, but it won't be finished until at least tomorrow. Matthew Williams Geodesic GraFX ~| 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:318586 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreamweaver CRASHES!!!
I have been using DW from 8 to CS4 and the only times I had major problems with it was when I had a computer issue unrelated to the software. Although I will admit sometimes uninstalling it completely and putting DW back on would fix things for awhile. On Mon, Jan 26, 2009 at 10:04 PM, Mike Kear afpwebwo...@gmail.com wrote: I have found Dreamweaver to be a very stable application. From version 8 to CS3 to CS4.If you were really interested in solving your problem, I'd get rid of it completely and start again from the beginning. I'd adivise: [1] Uninstalling it completely. [2] Delete any folders or files that might be left in the install directory [3] Delete any user preferences (in windows, they're in C:\Documents and Settings\username\Application Data\Adobe\Dreamweaver CS4\en_US\Configuration [4] remove any keys in the registry [5] reboot. Then you should have removed every reference to Dreamweaver. Then I'd advise starting again from the beginning. I suspect the reason your DW is crashing all the time is there is some remnant somewhere from a previous installation that's not being overwritten by a reinstall, or some corrupted file somewhere that's not removed by the previous uninstall. I dont suppose your handle is a clue to what's gone wrong is it? Torrent girl?? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jan 27, 2009 at 2:56 PM, Rob Parkhill robert.parkh...@gmail.com wrote: You can try this if you are still interested in Eclipse http://www.yoxos.com/ondemand/ it basically allows you to choose what plugins/whatever you want for Eclipse, and then puts it all into a single package that you download and install (1 step, pretty sure anyways) HTH Rob On Mon, Jan 26, 2009 at 10:20 PM, Torrent Girl torrentg...@gmail.com wrote: I am having the same problem with DW I found this posting online http://kb.adobe. com/selfservice/viewContent.do?externalId=kb402776 followed the directions and it is still crashing. I have been so unproductive behind this that i decided to install eclipse. That became a nightmare as there is not good documentation on how to set it up. Does anyone know of a good free CF editor? P.S. I have been sitting here for 3 hours restarting DW and trying to install CFECLIPSE. I have resorted to downloading a trial version of HOMESITE (I can't believe they are still selling HS) which is SAD. I am praying that IT works. A word to all current and aspiring software developers and tutorial writers, bloggers, whoever PLEASE PLEASE PLEASE PLEASE make sure your software works properly and if you write a tutorial PLEASE PLEASE PLEASE PLEASE make sure your instructions work INCLUDING PROPER SYNTAX and PLEASE PLEASE PLEASE PLEASE write a detailed description of how to install, setup and use your product. I have wasted so much production time on Dreamweaver crashing - it's pathetic. I know I am ranting but I've had it. Make it work or make it free so others can make it work. And if you do make it free like ECLIPSE, hire a darn tech writer so people can learn how to use your software ~| 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:318587 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Submitting larger data using cfajaxproxy: throwing error
Hi all, I'm submitting my form using cfajaxproxy(using remote method invocation). it is working fine with small data. my page is having a text area. if we give larger text say like 500 chars, the sumbit action is throwing javascript error. the CFC is not able to handle it. is there any solution for this issue ? please help ~| 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:318588 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Submitting larger data using cfajaxproxy: throwing error
Is there a CF error being thrown? (the CFC is not able to handle it) ~Brad - Original Message - From: dev losh devl...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, January 26, 2009 10:14 PM Subject: Submitting larger data using cfajaxproxy: throwing error Hi all, I'm submitting my form using cfajaxproxy(using remote method invocation). it is working fine with small data. my page is having a text area. if we give larger text say like 500 chars, the sumbit action is throwing javascript error. the CFC is not able to handle it. is there any solution for this issue ? please help ~| 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:318589 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreamweaver CRASHES!!!
I ditched DW when I switched to an AMD Turion 64x2 processor. DW spikes 50% on one of the dual cores and stays that way until a drop down menu is selected. The issue showed up on the Adobe boards, but there was never a resolution that I saw. I'm pretty sure this was only with CS3... but I never tried CS4 to find out. That's what drove me to CFEclipse, but I've never really minded. Matthew Williams Geodesic GraFX ~| 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:318590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Submitting larger data using cfajaxproxy: throwing error
Does the Text Area have new lines in it. I remember reading about there being an issue with JS and Textarea with afajaxproxy when the text has newlines. -- Kumar Shah http://www.coldfusion-ria.com/Blog/ On Mon, Jan 26, 2009 at 11:22 PM, Brad Wood b...@bradwood.com wrote: Is there a CF error being thrown? (the CFC is not able to handle it) ~Brad - Original Message - From: dev losh devl...@gmail.com To: cf-talk cf-talk@houseoffusion.com Sent: Monday, January 26, 2009 10:14 PM Subject: Submitting larger data using cfajaxproxy: throwing error Hi all, I'm submitting my form using cfajaxproxy(using remote method invocation). it is working fine with small data. my page is having a text area. if we give larger text say like 500 chars, the sumbit action is throwing javascript error. the CFC is not able to handle it. is there any solution for this issue ? please help ~| 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:318591 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Submitting larger data using cfajaxproxy
I assume the code sends a GET to the proxy - convert this to a POST and you should be fine: http://www.cfquickdocs.com/cf8/?getDoc=cfajaxproxy setHTTPMethod(method) Sets the HTTP method to use for the call. The function parameter is a case-insensitive string, and must have one of the following values: GET (the default method) POST mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/27 dev losh devl...@gmail.com: Hi all, I'm submitting my form using cfajaxproxy(using remote method invocation). it is working fine with small data. my page is having a text area. if we give larger text say like 500 chars, the sumbit action is throwing javascript error. the CFC is not able to handle it. is there any solution for this issue ? please help ~| 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:318592 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SQL query sorting problem
Michael, Thanks. That worked perfectly. Jim - Original Message - From: Dawson, Michael m...@evansville.edu To: cf-talk cf-talk@houseoffusion.com Sent: Monday, January 26, 2009 8:07 AM Subject: RE: SQL query sorting problem The proper solution would be a separate table that contains the state codes with their desired sort order. That table is joined to the main table. This is probably best if you have to list all 50+ states. If you only need to list three states, then I would use CASE as Azadi suggested. In MSSQL: SELECT state ,CASE WHEN state = 'NY' THEN 1 WHEN state = 'CA' THEN 2 WHEN state = 'FL' THEN 3 END AS stateSortOrder FROM cities ORDER BY stateSortOrder mike Jim McAtee wrote: DBMS is MySQL 5. I have a report that is generated for cities within several states. The states are designated by their two letter postal abbreviations and are in a certain order. For example: 1. NY 2. CA 3. FL I would like the records of the report sorted by the original state order, then by city name. I can pull the data for the report in single query, but can't figure out how to maintain the state order. Turning the state list above into a comma delimmited list (NY,CA,FL), my query looks something like: SELECT * FROM cities WHERE state IN (cfqueryparam value=#states# list=yes) ORDER BY state, city Except that I lose the original order of the state list. There are a number of workarounds, such as looping through the states and doing one query for each. Or run the single query shown above and then in a similar manner loop through the states and do a QoQ for each. Is there a way to do this in a single query? ~| 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:318593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
I have experienced DW crashing...but i don't think that was since the first or second version (5 6 I believe)that came out after Macromedia bought Allaire. I don't recall having that issue with 8. As far as eclipse...I have had a problem with an install just not being right. All i had to do was re-download it and all was well. Eric Aaron Rouse wrote: I have been using DW from 8 to CS4 and the only times I had major problems with it was when I had a computer issue unrelated to the software. Although I will admit sometimes uninstalling it completely and putting DW back on would fix things for awhile. On Mon, Jan 26, 2009 at 10:04 PM, Mike Kear afpwebwo...@gmail.com wrote: I have found Dreamweaver to be a very stable application. From version 8 to CS3 to CS4.If you were really interested in solving your problem, I'd get rid of it completely and start again from the beginning. I'd adivise: [1] Uninstalling it completely. [2] Delete any folders or files that might be left in the install directory [3] Delete any user preferences (in windows, they're in C:\Documents and Settings\username\Application Data\Adobe\Dreamweaver CS4\en_US\Configuration [4] remove any keys in the registry [5] reboot. Then you should have removed every reference to Dreamweaver. Then I'd advise starting again from the beginning. I suspect the reason your DW is crashing all the time is there is some remnant somewhere from a previous installation that's not being overwritten by a reinstall, or some corrupted file somewhere that's not removed by the previous uninstall. I dont suppose your handle is a clue to what's gone wrong is it? Torrent girl?? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jan 27, 2009 at 2:56 PM, Rob Parkhill robert.parkh...@gmail.com wrote: You can try this if you are still interested in Eclipse http://www.yoxos.com/ondemand/ it basically allows you to choose what plugins/whatever you want for Eclipse, and then puts it all into a single package that you download and install (1 step, pretty sure anyways) HTH Rob On Mon, Jan 26, 2009 at 10:20 PM, Torrent Girl torrentg...@gmail.com wrote: I am having the same problem with DW I found this posting online http://kb.adobe. com/selfservice/viewContent.do?externalId=kb402776 followed the directions and it is still crashing. I have been so unproductive behind this that i decided to install eclipse. That became a nightmare as there is not good documentation on how to set it up. Does anyone know of a good free CF editor? P.S. I have been sitting here for 3 hours restarting DW and trying to install CFECLIPSE. I have resorted to downloading a trial version of HOMESITE (I can't believe they are still selling HS) which is SAD. I am praying that IT works. A word to all current and aspiring software developers and tutorial writers, bloggers, whoever PLEASE PLEASE PLEASE PLEASE make sure your software works properly and if you write a tutorial PLEASE PLEASE PLEASE PLEASE make sure your instructions work INCLUDING PROPER SYNTAX and PLEASE PLEASE PLEASE PLEASE write a detailed description of how to install, setup and use your product. I have wasted so much production time on Dreamweaver crashing - it's pathetic. I know I am ranting but I've had it. Make it work or make it free so others can make it work. And if you do make it free like ECLIPSE, hire a darn tech writer so people can learn how to use your software ~| 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:318594 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
surely it couldn't be vista! ;) cfeclipse isn't difficult and there are plenty of blogs that show you how. 1. dl install eclipse 2. install cfeclipse, follow instructions on http://www.cfeclipse.org/download.cfm 1. Select the Help-Software Updates-Find and install menu option. 2. On the screen that is displayed, select 'Search for new features to install' and click the 'Next' button. Now click the 'New Remote Site' button. 3. Enter a name for the update site, for example CFEclipse. In the URL box, enter http://www.cfeclipse.org/update; and click the OK button. 4. You should now have a 'CFEclipse' node in the 'Sites to include in search' box. 5. Tick the 'Stable CFEclipse' box and click 'Next'. 6. Eclipse will contact the CFEclipse site and retrieve the list of available plugins. Tick the plugin with the highest version number and click 'Next'. 7. The next instructions are self-explanatory, agree to the license, install the software and restart Eclipse 8. Once Eclipse has restarted CFEclipse should have been successfully installed. 3. open eclipse and right click in navigator panel and choose new project 4. that brings up a window called select wizard, open up the cfeclipse folder and choose cfml project 5. new window called cfeclipse project: type in your project (or sites name), next if it is a new empty site and you want to use the default location hit next, if you want to use your own location uncheck the use default location box and choose your location. For example since I am on a mac I keep my web site folders in a directory called sites, so I brouse to that folder and go in and select my projects folder and hit next and you should be done. 6. open up the project in navigator pane and go to work. ~| 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:318595 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
I have found Dreamweaver to be a very stable application. From version 8 to CS3 to CS4.If you were really interested in solving your problem, I'd get rid of it completely and start again from the beginning. I'd adivise: [1] Uninstalling it completely. [2] Delete any folders or files that might be left in the install directory [3] Delete any user preferences (in windows, they're in C:\Documents and Settings\username\Application Data\Adobe\Dreamweaver CS4\en_US\Configuration [4] remove any keys in the registry [5] reboot. Then you should have removed every reference to Dreamweaver. Then I'd advise starting again from the beginning. I suspect the reason your DW is crashing all the time is there is some remnant somewhere from a previous installation that's not being overwritten by a reinstall, or some corrupted file somewhere that's not removed by the previous uninstall. I dont suppose your handle is a clue to what's gone wrong is it? Torrent girl?? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month Not in the mood for jokes. My name has nothing to do with software. Why should I have to completely reinstall this software, the crap should work. I am not the only one having these issues, Mr Certified CF guy. we have reinstalled the software and I'm over it. i will never purchase or recommend the purchase of dreamweaver again. I have wasted MANY a nights work on DW. ~| 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:318596 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
surely it couldn't be vista! ;) Nope I am on XP. Ok let's start with your instructions. You said go download eclipse. I have one question - WHICH VERSION? I downloaded the classic which i assumed i needed since I am not working in java but apparently I got the wrong one. This is what i mean by instructions and tuts. On the page, they should list the recommended version for CF programmers. ~| 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:318597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreamweaver CRASHES!!!
surely it couldn't be vista! ;) cfeclipse isn't difficult and there are plenty of blogs that show you how. 1. dl install eclipse 2. install cfeclipse, follow instructions on http://www.cfeclipse. org/download.cfm Sorry I meant - WHCIH VERSION OF ECLIPSE DO I DOWNLOAD? ~| 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:318598 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreamweaver CRASHES!!!
At what point is your CFEclipse install not working? Matthew Williams Geodesic GraFX Ok let's start with the tut posted on this thread. here is the link: http://www.cfeclipse.org/download.cfm here is step 1 Select the Help-Software Updates-Find and install menu option. Ok here is the problem. When I open ECLIPSE, and follow this path Help-Software Updates- THERE IS NO FIND AND INSTALL OPTION. ~| 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:318599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
But, does it actually explain how to set up a project and actually use the UI? ;) I'm already in the middle of getting a tutorial together for setting up a new CFEclipse project. I don't mind releasing it, but it won't be finished until at least tomorrow. Matthew Williams Geodesic GraFX No I have searched and none show the details. I just want to find one, just one tutorial that will tell me which version of the software to download. JUST ONE. ~| 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:318600 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
I have experienced DW crashing...but i don't think that was since the first or second version (5 6 I believe)that came out after Macromedia bought Allaire. I don't recall having that issue with 8. As far as eclipse...I have had a problem with an install just not being right. All i had to do was re-download it and all was well. Eric Aar Eric do a search on the net for people experiencing dw crashing - its TONS. This is a $400 piece of software made by a leading company. The more people defend it and ignore the issues, they aren't going to fix it. I have used DW for a least 5 years and have had similar problems. ~| 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:318601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreamweaver CRASHES!!!
Torrent Girl wrote: Not in the mood for jokes. My name has nothing to do with software. Why should I have to I would have thought it did. My guess is that you installed hacked software and that's causing your problems. That, or you've downloaded hacked software and are trying to get a fix for it. People are going to form conclusions like this whether you like it or not. It might do you well to provide your real name or something more legitimate. completely reinstall this software, the crap should work. I am not the only one having these issues, Mr Certified CF guy. we have reinstalled the software and I'm over it. i will never purchase or recommend the purchase of dreamweaver again. I have wasted MANY a nights work on DW. Of course it should work, and of course you shouldn't have to go through the steps outlined previously.. but hey, it's a computer and as much as you complain about it, it's still going to be a computer. So, instead of pissing on the people that are trying to help you, try their advice and then you'll be wasting a lot less bandwidth and getting more work done.. end result: win win :) Mike ~| 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:318602 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
http://trac.cfeclipse.org/cfeclipse/ Currently CFEclipse does not work well with Ganymede (line numbers are broken). If you want stable - we recommend you continue using Eclipse 3.3 (Europa) for a stable user experience. http://trac.cfeclipse.org/cfeclipse/wiki/InstallingCfeclipse You must first have Eclipse installed. For basic needs the Classic install will be fine. This is pretty clear. Regardless, I got Eclipse 3.4 and the place to add an update site is rather obviously under Help - Software Updates. Click the Available Software tab and hot the Add Site button. Use the URL from the install instructions and CFEclipse shows up after a refresh. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/1/27 Torrent Girl torrentg...@gmail.com: But, does it actually explain how to set up a project and actually use the UI? ;) I'm already in the middle of getting a tutorial together for setting up a new CFEclipse project. I don't mind releasing it, but it won't be finished until at least tomorrow. Matthew Williams Geodesic GraFX No I have searched and none show the details. I just want to find one, just one tutorial that will tell me which version of the software to download. JUST ONE. ~| 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:318603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
Sorry I meant - WHCIH VERSION OF ECLIPSE DO I DOWNLOAD? ummm, any of them... classic is fine ~| 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:318604 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Dreamweaver CRASHES!!!
I would have thought it did. My guess is that you installed hacked software and that's causing your problems. That, or you've downloaded hacked software and are trying to get a fix for it. WTF? BitTorrent is just a distribution method. Where did this hacked software crap come from? Not all BT users use cracked software, and not all cracked software comes via BT. People are going to form conclusions like this whether you like it or not. It might do you well to provide your real name or something more legitimate. Pfft. Just because some people are ignorant, doesn't mean she should go changing her handle. Seeing the word torrent and jumping to omg illegal software should result in being smacked round the head with a good sized encyclopaedia. :P And if you are such a person, please refer yourself to such a source, and you'll encounter the many more meanings that the word torrent can have: http://en.wikipedia.org/wiki/Torrent :) ~| 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:318605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Dreamweaver CRASHES!!!
Sorry I meant - WHICH VERSION OF ECLIPSE DO I DOWNLOAD? Best to grab 3.3 Classic. It is possible to use 3.4, but there are more issues that way. ~| 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:318606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4