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 () >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 () ORDER BY FIND_IN_SET(state, ), 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
Re: cfthread running condition?
This should be pretty simple to achieve. One of the restrictions with threads is that a cfthread can not spawn another cfthread. So your going to need one scheduled task that runs at a suitable interval. It will need to see if theres a thread running and if not, kick off the first thread. The threads will need to report there current status somewhere the scheduled task can check - to a db or application scope. When the scheduled task next runs it checks if the previous task completed and then starts the next thread. Chris >Is there a way to make the start of one thread >conditional upon the ending of a previous thread? > >I want to keep only one thread at a time running >and would like to set up a series of threads to run, >but only one at a time. > >I've been doing this with scheduled tasks and emailing >completion to myself for verification of success each morning, >but running 54 schedule task templates currently, with having to add >another 30 or so soon has just become quite cumbersome. > >Didn't know if there were any options. > >Too bad we can't number the threads to run sequentially >and set them to run only individually. > >Rick ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311780 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Here's an interesting little problem...
i know i'm a little late to this party but... SELECT `class`, concat(left(`class`, 1),100-length(`class`)) AS `sort` FROM myTable ORDER BY `sort` ASC will give you AAA AA A B CC C D etc ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311629 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Centering text written on an image
> Hi, > > I want to add some text to an image but have it centered rather than > left justified. Does anyone know how to do that? > > Kevin Roche http://imageutils.riaforge.org/ - getCenteredTextPosition() ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311431 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Developing cross-RDBMS CF apps, second in an irregular series of Eureka! moments
There's also Reactor http://reactorframework.com/ Which would certainly clean up those functions. All those case statement will make for some really big unweildy functions. If you didn't want to use an ORM, you could break your queries out into seperate includes for each dbms. This makes maintanence and adding support for other dbms's simple, it also cleans up your function so you can see whats going on ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311239 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Details on CF9's "free for academic" licensing?
If you're after a free CF engine, why not use Open Blue Dragon. It has everything you need to teach your students web programming. They have a "Ready2Run" download which is preconfigured and only 20Mb. http://www.openbluedragon.org/download.cfm Advantage of this is your students can also use it at home or on their laptops with no licensing problems. Get them using the free CFeclipse IDE hopefully you'll get them hooked on CFML :) ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:311238 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Free BlueDragon?
>> Thank you, Gerald, allow me to be lazy for a minute, cf8 >> comes with its own web server albeit it is for development >> only, and it can be installed siliently ("without user >> interaction" would probably be more accurate), and this >> capability (of silent installation + a default web server) is >> important to me. > >This could be done fairly easy with almost any J2EE app server, and a bit of >shell scripting. fwiw, i just wanted to point out that unless the software hes writing is distributed under a license that is compatible with the GPL then he can't bundle OpenBD with his software. He would have to distribute the software seperately and then install it on OpenBD. The same is not true of Railo 3.1 which is LGPL and can be bundled with a commercial app as long as you don't modify the railo source code. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310982 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfexecute batch file not working
have you tried setting a timeout for the ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: expandPath() and mod_rewrite
Add NS (No Sub requests) to the last rewrite rule should solve it RewriteRule ^(.*)$ index.cfm?course=%{REQUEST_URI} [NS,QSA,L] >I've found an issue with mod_rewrite and expandPath() recently and >I'm wondering if anyone has a solution. It seems that Coldfusion >uses Apache to pull the directory information with expandPath(). >This is the case on Linux (CentOS and SUSE 10), at least, since I >can't duplicate the problem on my Mac. > >For example, I have the following rewrite rules: > >RewriteEngine on >#General Rewrites >RewriteRule ^$ index.cfm [QSA] >RewriteRule ^([^.]+)$ $1.htm [QSA] >#Escape if file or directory exists >RewriteCond %{REQUEST_FILENAME} !-f >RewriteCond %{REQUEST_FILENAME} !-d >#Redirect all other requests through index.cfm >RewriteRule ^(.*)$ index.cfm?course=%{REQUEST_URI} [QSA,L] > >The the two RewriteCond rules escape the redirect when a file or >directory exists however when using where an >expandPath is used to create the file path, Coldfusion returns the >path "redirect:index.cfm" as the expanded path instead - since the >file doesn't exist yet . > >The workaround is to modify every path variable to two separate >variables - one for the directory and one for the file name and then >combine the two in the tag: Not a big deal, except that one >of the apps is a decent sized app with a bunch of file operations >being done in legacy code (in different directories) where I keep >running into this issue. > >Any idea of a rewrite rule or workaround that will allow CF (and >expandPath()) to do it's thing in peace while allowing all other >rewrite rules to be processed?I've been digging into the >mod_rewrite book and trying to tweak the existing rules with no success. > >Thanks, >Jon ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297248 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
bug?
I've been messing around with cfimport today and i've come accross a strange behaviour. I created a custom tag /mytagdir/test.cfm - #getbasetaglist()# And then called it in two slightly different ways which results in two different strings CFOUTPUT,CF_TEST,CFINCLUDE CFOUTPUT,CFTEST,CFINCLUDE Any thoughts..? should they not both return CF_TEST? I'm running MX7.01 & RH7.3 Cheers ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260016 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4