Re: KickAssVps.com Experiences
Beyond this they seem to be a good company although I'm a little squeemish about there not being telephone tech support available. That's the impression I get from viewing their Web Site. Any feedback will be very much appreciated. Peter Donahue My experience with them sucked. My hosting setup was a bit rocky. The support was ok, but aremysitesup.com reported site down messages to me almost every day, multiple times a day. I don't know how Rick is doing well with them, he must've gotten the magical kickassvps account. I use viviotech now. No, it isn't a discount host, but they're rock solid from top to bottom. It's been a pleasure dealing with them for over a year now. Oh, and my aremysitesup has been extremely quiet the entire time. my .02 Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: refreshing application variables
How does one refresh application.cfc application variables without restarting coldfusion services? Thanks in advance. And I would recommend using a hard to guess url variable to fire off the app restart: ?hardToGuessVar=1 Otherwise, hoodlums like Ray Camden will run around restarting your app 100 times a day. :) Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:342057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT - site monitors
I unashamedly admit I don't want to pay for a service if I can. Can anyone recommend anything or alternatively I'm happy to run it off my own box if someone can recommend some code etc TIA! I use aremysitesup.com Works well. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341955 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Application.cfc cfinclude
Hi Folks - I am feeling dumb and either I am missing something simple or it's way above me. In my application.cfc, I was going to have a cfinclude that would pull in my DB Name, user name, and password. I would store those variables in application scope in onApplicationStart(). Then reference them from there. But I pass them into data access cfc objects in my init()'s in onApplicationStart(), and save to variables in the data access cfc. Then in your queries, it'll look like cfquery datasource=#variables.dsn# That's just how I do it. I don't know about others. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: why is cf_builder so slow? (was: expensive)
Gerald, Your comments about CFB being slow bother me, and warrant some exploration. Can you provide more detail? Do you have projects set up into a shared dev environment over the network? I can't imagine that would be fast for any IDE. I'm not a CFBuilder fan, I've always liked DW. But let's drag DW into it. I've had DW hang on me. Hog resources, run slow, JS errors, etc. I use Coda on my Mac now and really like it. But it's done some kooky things at times. FTP (transmit) has been strange, and some other issues. But I like it in general. Maybe nothing will be perfect. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341566 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: favorite coldfusion host
Curious to see what everybody's favorite coldfusion host is also? Hostek? CrystalTech? DailyRazor? + 1 Viviotech. I feel much better knowing those guys have my back. I have two VPS's with them. One for my Railo, one for my Database. No, it isn't discount-cheap-fast food hosting. You get what you pay for though. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341331 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: multiple Application.cfcs
so I've got a site with a few Application.cfc (basically I want to lock down some folders). If everyone has to log in to hit the admin/Application.cfc does that cfc need the onApplicationStart method or even onSessionStat methods? And it shouldn't need the application variables either correct? Am I on the right track of thought? Greg, I think you're correct in your thinking. onAppStart and onSessionStart don't need to be in admin/application.cfc But you might want to extend your root application.cfc if you want to use its variables, etc. I use Sean's technique...works nicely. http://corfield.org/entry/Extending_Your_Root_Applicationcfc Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341041 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: trying to pass ajax complex strings within another form
After that I wanted to click the top submit button that submits all the other form elements to the action page. This of course generates Looks like your CF doesn't have access to createObject() ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340671 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Coldfusion Code Review Tool
Can anyone recommend any good tool that can be used for Coldfusion Code Reviews? I tried Sonar but could'nt find coldfusion plugin for the same. I built one a couple of years back. You'd need to have some knowledge of Regexs to use it. It uses a MySQL DB. http://willtomlinson.wordpress.com/2008/07/03/announcing-code-scanner-10/ Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340630 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: trying to pass ajax complex strings within another form
After that I wanted to click the top submit button that submits all the other form elements to the action page. This of course generates an error that says element data undefine. It looks like you're binding to an id of #submit, but the submit button doesn't have an id=submit, so the ajax call doesn't work. Then you need to make sure to return false; inside that same jquery handler, so that it doesn't try posting the form without the ajax call. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SOT: FireFTP - Upload appends files instead of overwrites?
I ran into a bizarre issue last night where FireFTP wouldn't overwrite my Application.cfc. The site started erroring with invalid tokens. When I viewed the code on the live server, I noticed the Application.cfc had been appended to with as many cfcomponent tags as I had uploaded the files. I had like six cfcomponent tags in my Application.cfc. hehehe I was tipped off when I saw that the file sizes kept growing as I made my uploads. I checked my FireFTP settings and didn't see anything that jumped out. Has anyone seen this behavior before? Thanks, Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340103 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Moving from MSSQL to mySQL
Hello All. Is there a utility that will allow me to copy the tables and structure from an MS SQL database to a mySQL one? Thanks I use this product - works flawlessly. When moving large amounts of data, just be sure to go into settings and use NO skin. It bogs it down. Otherwise it works beauifully...maintaining PK's, FK's, indexes, etc etc. http://dbconvert.com/convert-mssql-to-mysql-sync.php Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339708 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hosted VPS recommendations
Can anyone recommend a decent VPS host with a basic windows server setup that would allow several developers to login and develop remotely? Dan - 1 kickassvps - aremysitesup.com overloaded my phone txts with server down notifications. I had other problems with support as well. Don't know how others here got the 'magical support' packages. + 1 viviotech - nothing but amazing - I recommend them to everyone. Mark Keymer and Jordan rock. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
transferring data from one app to another I'd just use Navicat to transfer the data. No CF needed. Quick and easy. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339115 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: slow cfquery cfqueryparam?
Hi, I am running the following cfquery which inserts a large amount of rows into a table (approx 2200) Just out of curiosity, where does your insert data originate from? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:339080 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Importing from CSV to a database
Thanks, but it is not that simple. I have plenty of things to check, convert, validate, etc. Don't forget an Excel file is created and filled by humans ;-) I would figure out a way to use my RDBMS to handle this. Navicat or SQL Server tools to do it. Then clean the data or whatever once it's in there. To reference those crappy fieldnames you'll need to use aliases SELECT some[space]crap[space] fieldname as somethingICanUse FROM someTable ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338486 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFFM 1.32 Released
Demo: http://www.opensourcecf.com/cffm/demo Rick, the demo doesn't come up: HTTP Status 404 - /cffm/demo/ Thanks, Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337140 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: social network application based on CF ?
Hi list, is there any social network application / social network framework based on CF you guys are aware of ? Thanks in advance for your feedback ! Uwe This one is PHP, but I know folks that seem to love it. http://www.socialengine.net/ Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Millions of Coldfusion sites need to apply patches
Richard Brain of ProCheckUp commented âThis is a trivial attack which can be performed easily by a competent engineer; ProCheckUp thanks Adobe for consciously working with us to produce a patch which fixes the traversal attack. By performing a simple Google search for inurl:index.cfm, it was found that over 80 million examples of sites using Coldfusion. Gee, I thought ColdFusion was dead. Guess not Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336214 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Suppressing whitespace from CFCs
The general consensus is that CFCs should be used primarily to encapsulate logic, and data retrieval. If you want to output something it really should be in a CFM page, or a custom tag. Man, consensus scares me. :) Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:336033 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: www.cbo.gov down. CF to blame?
I keep trying to post to this thread but HOF is down. hehehehe!! Why is no one mentioning the Java argument? Ask your friends if they think Java sucks and can't handle load. Then you got'em by the gonads. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335813 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Form cleaner utility
Why not just use CFQUERYPARAM bound parameters in your SQL? In my case, I'm scrubbing the data. cfqueryparam doesn't do that. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335702 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Form cleaner utility
I'm building a form cleaner utility method that might help thwart some XSS, clean my fields up, etc. Know I can't stop it all. Didnt see anything on riaforge exactly like what I'm lookin for here. Here's what I've got so far. Anyone have anything to add? cffunction name=cleanFormFields access=public output=false returntype=struct cfargument name=formStruct cfset var form = cfset var thisField = cfloop list=#arguments.formStruct.fieldnames# index=thisField cfset form[thisField] = trim(form[thisField]) cfset form[thisField] = htmlEditFormat(form[thisField]) /cfloop cfdump var=#form#cfabort cfreturn form /cffunction ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Hosting Inquiry
Hi, Jim... Check into www.KickAssVPS.com. I've been with them for two years and haven't had a single moment of downtime. Seriously... I was with them for a few months and I had to move to a better host. I have an account at aremysitesup.com, which sends me txts when one of my sites is down. It sent me so many txts from my kickass sites being down, that it overshot my txt plan. lol! I literally got 6+ emails a day, all throughout the day. I moved to viviotech.net and now I get maybe one site down txt every few weeks. Amazing difference there... Anyway, I figured I'd shoot Rick down, and give a thumbs up to Viviotech.net! :) Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL - Selecting a row based off linking table row matches
Could someone show me an example? I've tried all kinds of stuff with no luck. Thanks, Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQL - Selecting a row based off linking table row matches
Use an inner join on the id's that you wish to link across the tables. I don't get what you mean Andrew. Sorry. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334954 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL - Selecting a row based off linking table row matches
MySql 5, I have this product schema. There are other tables involved but this is the pertinent part. tblskus skuid pk sku_prodid more fields... tblskuoptions skuoptionid pk skuoptionname more fields... tblskuoptions_rel (linking many table) skuid fk skuoptionid fk The user is presented with two dropdowns for example. Select color: Select size: I create a list based off their choices. I have a productid they submitted. How can I select a single sku based off the option combination they chose. I tried a few different things with no luck. where tblskuoptions_rel in (24,37,59) didnt work. It pulls too many skus. I just need the one that matches the combination of options they chose. It could be just size. Or just color. Or both. Here's what I have right now. This selects way too much. select tblskuoptions_rel.optionID, tblskus.merchskuid from tblskuoptions_rel, tblskus where tblskuoptions_rel.optionskuid = tblskus.skuid and option_optionid in (cfqueryparam cfsqltype=cf_sql_smallint value=#optionSelList# list=yes) and tblskus.sku_prodid = cfqueryparam cfsqltype=cf_sql_smallint value=#form.productid# Any help would be appreciated. Thanks! Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is it time for Adobe to Rebrand Cold Fusion?
Ok, I'm now straying into OT area, but I must be the only who liked the idea of PRODUCT YEAR as a brand. Ie, Windows 95, Windows 98, Windows 2000. To me it was a very clear way to know the release of the version you are using. This sounds perfect for Rick. Where's dave when we need'em?? :) ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334814 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF regex question [SOT]
Seems to work beautifully! Thanks! As long as you don't have any variables/values with cf in them. hehehe.. cfqueryparam value=anythingcfanything / doesn't match. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Hosting
Anyone know any good, reasonable CF 9 hosting companies w/ mysql. Thanks! + 1000 for viviotech. They rock. Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333871 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is CFGRID in CF9 solid enough for heavy use for CRUD functionality?
Playing with some CFGRID examples on ColdFusion 9, I noticed some major slowdown without a lot of records being loaded. Being on a locally hosted server off my workstation that concerned me even more. I like jqGrid. cfgrid bit me in the butt when I moved to Railo. jqGrid fixes that problem. http://www.trirand.com/jqgridwiki/doku.php?id=start Will ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Anyone else have the latest CFBuilder crashing constantly?
I turned off Syntax Checking: Preferences ColdFusion Editor Profiles Editor Syntax Checking Turned off Build Server Settings Preferences ColdFusion Server Settings Build Server Settings I downloaded it, installed it, used it for about 20 minutes, and realized it was the most unintuitive pile of crap I've ever seen. It's like Adobe hired the Vista team to build it. Jesus. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332944 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: time difference
2 ?'s I need to show a difference between to dates basically how much time is left between the ending date and now. can cf do this or should I use a java script? also, how do I use a Now() but add 3 hours to the output? server is 3 hours behind but I need to be the current time. I don't think the java get current time will work because I need to retrieve it from a db lots o ?'s tonight why see below! haha dave !--- doesn't know jack about cfm --- My god. This still holds true today! Wanna chime in Rick??? LOL!! Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: time difference
actually I already have it:) just really sick of reading it at the moment. lots to absorb, short amount of time Dave, CF is a lot to absorb chief!! LOL!!! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331398 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How do people transfer data between databases nowdays?
Now that my dev machine is being rebuilt, one of the things i have to do is work out if the way I've been doing things is still the best way of doing them. +1 dbconvert.com. They have an amazing slick application there. I happen to use it to convert MSSQL MySQL. Works like a charm. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331306 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: jquery find/replace on an entire body DOM
Anything you could do to make jQuery have to do less work will be beneficial. Andy, This works great for form actions. I've played around with doing the exact same thing for any inputs with onclick attributes. But JQ doesn't seem to select up the value of the onclick. Do you have any ideas? Here's the form one that works. $(document).ready(function() { var regexp = /action=([a-zA-Z]+\.[a-zA-Z]+)/; var value = $(form).attr('action'); var replaced = value.replace(regexp,'action=$1cte=thompson'); $(form).attr('action',replaced); }); Thanks! Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330950 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jquery find/replace on an entire body DOM
It sounds like you're talking about jQuery manipulating jQuery code? Not in these cases. This is some legacy JS in our onclicks.They must remain, but they contain mappings that I need to do the exact same thing we did realier in the form action. The code to be manipulated looks somethin like this: input...onclick=switchActionSubmit('someController.someMapping') I need to grab that someController.someMapping part, just like the form action. I've tried different things, but JQ isn't grabbing it up so I can maniuplate it. Thanks for your help! Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330965 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jquery find/replace on an entire body DOM
It sounds like you're talking about jQuery manipulating jQuery code? Andy, this seems to do the trick with grabbing my input code string. var htmlStr = $(':input').append($(':input').clone()).remove().html(); Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330972 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jquery find/replace on an entire body DOM
Your problem is twofold. 1) change $(this) to this $('body') (assuming that the text will only appear within the body tag. Thanks Andy! I'm having a problem with the page choking on this line: $('body').html(replaced); It literally bogs thr browser down and it just churns away with a blank screen. Weird! Any ideas? Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jquery find/replace on an entire body DOM
Your problem is twofold. 1) change $(this) to this $('body') (assuming that the text will only appear within the body tag. Thanks Andy! I'm having a problem with the page choking on this line: $('body').html(replaced); It literally bogs thr browser down and it just churns away with a blank screen. Weird! Any ideas? Thanks, Wil ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
jquery find/replace on an entire body DOM
I didn't get any response on the jquery list, so I'm reposting this here. Hey, I need to traverse an entire DOM, find a match for a pattern like this: someController.somemapping And I need to replace that text with this: someController.somemappingsomeURLVar=someValue This pattern could be located ANYwhere inside the body of the document - a form action, an onclick, etc. Here's what I've built so far, but it doesn't work. Any ideas would be appreciated: $(document).ready(function() { var regexp = /([a-zA-Z]+\.[a-zA-Z]+)/; $(this).html().replace(regexp,$1 + someURLVar=someValue); }); Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Microsoft JDBC Driver: Multiple SQL statements
I recently switched to using the latest Microsoft JDBC Driver for MSSQL 2005 and immediately saw a performance increase (over using the standard driver w/ ColdFusion 8.01). However, all our queries that have multiple statements are failing so I've had to switch back. e.g. I know with MySQL, you can specify multiple queries right in your DSN setting. http://www.bennadel.com/blog/1542-MySQL-3-4-com-mysql-jdbc-Driver-And-allowMultiQueries-true.htm I don't know if there's an equivalent for the SQL Server driver. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330299 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Injection Testing/Monitoring
Does anyone have any good methods for testing or monitoring SQL Injection they are willing to share? Thanks! Here's a good resource we use to test attacks: http://ha.ckers.org/xss.html Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329790 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best Way to Handle Multiple Related Selects?
Iâm trying to get four related selects to work---basically, you can change any one of the selects and it will reload the other 3 based on your selection. I've used qForms with great success. I had up to 7 related selects - handled it, no problem. http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Best Way to Handle Multiple Related Selects?
Same here and in most cases found it to be faster than doing Ajax calls but guess it would greatly depend on the amount of select options and speed of the connections being used. I have done our organizational hierarchy using qForms and we have a ton of nodes and saw no performance issues. On Mon, Nov 23, 2009 at 10:10 AM, Will Tomlinson w...@wtomlinson.comwrote: Yeah, mine had hundreds of items. All the data is loaded into JS, so there are no ajax calls to make, which makes it superfast instantaneous. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328622 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT - MySQL List
Hi All, Anyone know of a good MySQL list? I have to take on a project that has a PHP/MySQL backend. Thankfully it's a short term thing as the entire site is getting migrated. In the mean time I need to find a tool similar to Enterprise Manager/SQL Studio for MySQL. I like Navicat for MySQL administration. www.navicat.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Trouble with query...
i'm not very familiar with sql server syntax, but would something like this work? SELECT IFNULL(cpn.numCoupons,0) as numCoupons, couponcode, THEORDERDATE Hmm. didn't work. SQL server didn't like it. :( I just simplified it and didn't break it down by the day. I got somethin that'll work for now. Thanks jessica! Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327651 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Trouble with query...
SQL Server I'm trying to report on the number of orders per day that has coupon code associated with them. The problem is, we can have multiple coupons running at the same time. My query just counts the number of coupons used per day. It doesn't filter by couponcode. But the minute I add a WHERE clause, it filters out all the days where coupons weren't used - not what I want. I want to even show the days where coupons were not used. Here's what doesn't work. If I remove the WHERE couponcode clause, it show all days of the couponcode. Which is almost correct, but I need to tell it to show the totals for a particular couponcode. SELECT DATEADD(d,DATEDIFF(d,0,orderdate),0) AS orderdate, count(couponCode) AS numCoupons, couponcode FROM tblOrders WHERE cfif len(form.startDate) and len(form.endDate) orderdate between #createODBCdate(getcouponData.couponstartdate)# and #createODBCdate(getcouponData.couponenddate)# /cfif WHERE couponcode = cfqueryparam value=#getcouponData.couponcode# AND orderpaid = 1 GROUP BY DATEADD(d,DATEDIFF(d,0,orderdate),0), couponcode ORDER BY DATEADD(d,DATEDIFF(d,0,orderdate),0) Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327621 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: url-write and global error handling
A couple of things that I'd like to do with local deployment of my web app using an open source cfml engine. FYI, I ran some quick search, unsatisfactory. If you're using railo, why not ask on the railo list? Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326008 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: issues with the list
The session logout time is fairly short and everytime you write a long post you got to copy and paste to save your work and relogin to post, arg I would just stop posting if I were you. I'm sure everyone would agree this is the best solution. :) Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325875 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Could use some inputs
I have help with problems to your motivated issue of capable proportions that might hint to the extinction of the not cf coding issue... Here's a situation I hope you could provide some thoughtful input. I've converted a cf8-based app into an open source one. Initially it seemed all's well but lately, right when I'm ready to deploy it (not Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325232 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Regex help - without a look-around
I'm trying to match if a pageID list doesn't end with: ,services.wpViewingHistory And has a siteList with W in it. Here's my regex: pageIDs=[0-9a-zA-Z.,]+,*(s[^e]{1}|se[^r]{1}|ser[^v]{1}|serv[^i]{1}|servi[^c]{1}|servic[^e]{1}|service[^s]{1}|services[^\.]{1}|services\.[^w]{1}|services\.w[^p]{1}|services\.wp[^V]{1}|services\.wpV[^i]{1}|services\.wpVi[^e]{1}|services\.wpVie[^w]{1}|services\.wpView[^i]{1}|services\.wpViewi[^n]{1}|services\.wpViewin[^g]{1}|services\.wpViewing[^H]{1}|services\.wpViewingH[^i]{1}|services\.wpViewingHi[^s]{1}|services\.wpViewingHis[^t]{1}|services\.wpViewingHist[^o]{1}|services\.wpViewingHisto[^r]{1}|services\.wpViewingHistor[^y]{1})\s{1}siteList=(W+[,A-Za-z]*|[,A-Za-z]*W+|[,A-Za-z]*W+[,A-Za-z]+) Here's my target string: pageIDs=services.wpLayout,profile.registerpc,services.wpProgramInfo,profile.pcLogin,errors.profile.apReferrer,services.wpViewingHistory siteList=W It's almost there but not quite. It doesn't match this and it should: pageIDs=services.wpLayout,profile.registerpc,services.wpProgramInfo,profile.pcLogin,errors.profile.apReferrer,main.testing siteList=W I can't use look-around with my regex engine Thanks for any help someone could offer... Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:325188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
cfgrid Why are empty rows clickable?
We're using a cfgrid. Pagesize is 25. If you specify href, and there are less than 25 results are returned... then remaining rows are empty but still clickable.This results in CFGRIDKEY=null Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324999 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL - allowMultiQueries=true not working on developer edition...
Hey, CF8 - mySql 5 on both boxes. I've added allowMultiQueries=true in CF Admin on my live server, and it works just fine with letting me use multiple selects within one cfquery So I added it to my development machine, but it doesn't work. My queries still error due to the semicolon and extra select statement. Any ideas? Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324959 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - allowMultiQueries=true not working on developer edition...
Oh, I fixed it! I just deleted the DSN and created a new one with the new connection setting. Seems to have worked. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324960 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SOT: CF based Message Queue - Thread safe stored procedure
Hi all, I have an issue with a stored proc that hopefully someone can help with... A little background... I built a CF based message queue system. It is pretty simple; I have a table of 'messages' in the database. I can fire up as many infinite threads as I want and they process those messages. My initial problem was that the same messages were being executed multiple times when I ran multiple threads at once. A simply CFLOCK solved that. The problem now, is that I need to allow the message queue threads to run from multiple servers at once. So now I'm back to messages getting executed multiple times when threads are running from different servers. I moved all of the SQL from the CFLOCK into a stored proc thinking that I could easily wrap the SQL in a transaction (SQL Transaction, not CF). I'm having quite a bit more trouble than I expected. I'm running into deadlocks. The whole flow of the Stored Procedure needs to be something like this... 1) Grab the next message record where the status is 'pending' 2) Update that record's status to 'running' 3) Return the record While that is running, no other process should be able to access the record that is being processed but It'd be nice if it didn't cause immediate deadlocks but waited (or even moved to the next record if possible) This is the procedure after my latest attempts. Ive actually changed the approach and updated the record first THEn grabbed it to return hoping that would help. It still the same issue. Deadlocks Not sure how this is going to come through in an email but here it is. -- IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[getNextMesssageQueueRecord]') AND type in (N'P', N'PC')) DROP PROCEDURE [dbo].[getNextMesssageQueueRecord] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE PROCEDURE getNextMesssageQueueRecord AS SET TRANSACTION ISOLATION LEVEL READ COMMITTED BEGIN SET NOCOUNT ON; begin transaction declare @uuid nvarchar(32) set @uuid = lower(replace(newID(), '-','')) update queue.messages set messagestatus='running' , dateStarted = getDate() , messageUUID = @uuid where messageStatus='pending' and messageID in ( select top 1 messageID from queue.messages with(updlock) where messageStatus = 'pending' order by messageID ) commit transaction select messageID, messageStatus, messageXML from queue.messages where messageUUID = @uuid END Go - Any ideas to resolve this would be greatly appreciated. Thanks! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323945 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: AW: railo getting started 3
Don, I guess it's time to invite you to the Railo Google group. THANK YOU GERT! I thought you'd never offer! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323907 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Guru guidance needed....
Man, I have no idea what I'm doin. hehe, i often feel that way, too :) Ahhh thank you! I will give it a shot tonight. And the JS you posted does indeed go in product_add.cfm, correct? Thanks much, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323112 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Guru guidance needed....
your form processing javascript will then look something like this: Ahh yes, this works! I just need to stick a .tabs() in there that selects the next tab after submission. Thanks! Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323145 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Guru guidance needed....
Man, I have no idea what I'm doin. hehe, i often feel that way, too :) Hot damn! I'm gettin' fancy now. Check this out. I decided to try and preselect the categories tab after the product is added. Like a wizard. I'm also passing my ID to each tab so you can use them for inserting into the many tables. I knew I could chain, so I tried it and it works! Add a product, then it switches to the next tab after the insert. Still unfinished: script type=text/javascript var options = { url: 'processProd.cfm', dataType: 'json', success: function(res) { var id = eval(res); $(#productAdmin).tabs('url', 0, 'product_add.cfm?id=' + id); $(#productAdmin).tabs('url', 1, 'productBuilder-Categories.cfm?id=' + id).tabs('option', 'selected', 1); $(#productAdmin).tabs('url', 2, 'productBuilder-Skus.cfm?id=' + id); $(#productAdmin).tabs('url', 3, 'productBuilder-SuggestedProducts.cfm?id=' + id); $(#productAdmin).tabs('url', 4, 'productBuilder-prodImage.cfm?id=' + id); } }; $('#addprod').submit(function() { $(this).ajaxSubmit(options); return false; }); /script ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323147 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: jQuery Guru guidance needed....
go here: http://jqueryui.com/demos/tabs/ click on Methods tab. read about the 'URL' method. presumably, your product_add.cfm page adds a product using ajax post? if so, the callback function should receive the id of newly added product and then call the url() method on the other tabs (and maybe load() method as well - can't remember now if just setting a new url reloads the tab or not...) Where do you put the callback funtion? In the product_add.cfm page? Or the parent tabs.cfm page? I'm a little mixed up. Thanks for the help, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323101 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jQuery Guru guidance needed....
a safe bet would be to define all your js in the main page (tabs.cfm). but particulars depend on your code... how are you submitting your add product form? are you using jquery (i.e. $.ajax or $.post) or are you using cf8 built-in ajax features (cfajaxproxy or ColdFusion.Ajax.submitForm())? Here's what I have so far. It still isn't quite working properly. tabs.cfm: script $(document).ready(function() { $(#productAdmin).tabs(); }); /script product_add.cfm: script type=text/javascript src=/admin/js/jquery.form.js/script cfoutput script type=text/javascript var id = #variables.lastprodID# $(document).ready(function() { //cfoutputalert(#variables.lastprodID# yo yo!);/cfoutput $('##addprod').ajaxForm(function() { $(##productAdmin).tabs('url', 1, 'productBuilder-Categories.cfm?id=' + id); //$(##productAdmin).tabs('load', 2); }); }); /script cfform name=addprod id=addprod action=processProd.cfm. inputs here... processProd.cfm has all the form processing code. How do I get the lastProdId back into the tab pages for use there? Man, I have no idea what I'm doin. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323105 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
jQuery Guru guidance needed....
I'm using jQuery Tabs to rebuild my ancient product admin. Trying to slicken it up a bit. As a product is added, I need the tab .cfm's, and the parent to pass around the prod ID variable to each other. The tabs I'm using: http://docs.jquery.com/UI/API/1.7/Tabs I have a parent page that contains the tabs (disabling 2nd-5th tab until a product is added: tabs.cfm script $(document).ready(function() { $(#productAdmin).tabs({ disabled: [1, 2, 3, 4] }); }); /script div id=productAdmin ul lia href=product_add.cfmspanProduct Info/span/a/li lia href=productBuilder-Categories.cfmspanCategories/span/a/li lia href=productBuilder-Skus.cfmspanSKUS/span/a/li lia href=productBuilder-SuggestedProducts.cfmspanSuggested Products/span/a/li lia href=productBuilder-prodImage.cfmspanImages/span/a/li /ul If someone is using the product info tab, and they add a product, how could I let the parent, tabs.cfm know, and enable the other tabs at that point. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: jQuery Guru guidance needed....
go here: http://jqueryui.com/demos/tabs/ click on Methods tab. read about the 'URL' method. presumably, your product_add.cfm page adds a product using ajax post? if so, the callback function should receive the id of newly added product and then call the url() method on the other tabs (and maybe load() method as well - can't remember now if just setting a new url reloads the tab or not...) Ahh... I wasn't posting via AJAX. I was just looking at this: http://malsup.com/jquery/form/#getting-started Thanks for the info. I think I'm on the right track now. Need to post via ajax. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323065 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What's the best way to handle returning two queries from a component for looping?
I started out that way, but couldn't make a join of any type work... I tried left join, inner join, join, union, etc, but the best I could do was get one title with one section. There should be one title with multiple sections. Rick, 1. I would remove the * and reference your fieldnames. 2. Remove that group by n the SQL. 3. Your query output should look something like this: cfoutput query=getStuff group=theTitleFieldHere h1#someTitleField#/h1 cfoutput p#theDetailField#/p /cfoutput /cfoutput See if that works. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322853 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Form submittion redirected with 302 Moved Permanently response, Form Post Failed !!!
anyone got any idea , what is going wrong It's virtually impossible to know what is going wrong unless we see some of your code!! ! Hope this helps, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL - How to create a category tree in a store
I think I'm going to use this tool: http://nstree.riaforge.org/ I've been playing around with it. Seems fairly straightforward and does everything I need. I'm just working on what the admin interface would look like to display the entire tree so you could select multiple categories for a given product. Thanks for everyone's input. Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322755 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
MySQL - How to create a category tree in a store
I built a store application that has a simple product category schema. Right now, the user can select one or more categories to associate to a given product. I have a linking table in between those two tables that resolves the many-to-many. Now, I need the ability to let the user create their own categories and nested categories/subcategories, then associate a product to one or more of them. Much like a category tree. i.e. A shoe needs to be associated to the footwear category, and the shoes category located within the footwear category. Make sense? :) I've looked at recursion, but I'm on MySQL 5.1, and I don't think it supports recursive queries. Does anyone have any suggestions on the best way to go about this? Also, what would you implement for the admin tool that creates the category tree? Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322704 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MySQL - How to create a category tree in a store
This might be useful: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html Cheers, Dave Yes, there's a lot of great info there. But it looks like a nightmare if I want to add a node under the parent. Products -baseball --gloves --bats --shin guards -golf --gloves --bags ---nike ---titleist ---ping --shoes If I want to add lacrosse between baseball and golf, that'd be a pain. Wish I could find something easier for this. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322709 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: MySQL - How to create a category tree in a store
@willr u ok with setting a maximum number of levels? -- Ryan Yep. I could max it out at 4 levels. I had thought about building related tables, 4 of them. Thanks, Will ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322711 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 server - Order totals by month, even without month data
Thanks to everyone for their help with this! Will ~| 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:320991 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL server - Order totals by month, even without month data
I have your typical tblorders. I'm trying to query it to get order totals by month, and I'm outputting them in cfchart All goes fine, except in 2009. We have no order data for April-December of course, so the query returns just three rows (Jan, Feb, March). I need it to return all 12 months, with 0 for the months with no orders (April-Dec) I've played with this query and can't get anything to work for me. Any ideas? Thanks! Will select year(orderdate) as orderYear, month(orderdate) as monthOrdered, sum(ordertotal) as totalOrders, dateName(month, orderdate) as monthName from tblorders where orderpaid = 1 and year(orderdate) = 2009 group by year(orderdate), month(orderdate), dateName(month, orderdate) order by year(orderdate) asc, month(orderdate) asc ~| 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:320906 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: (ot) about Vista
I need a quick favor from someone who has access to a Vista box. type echo %OS% from DOS prompt and let me know what you got. I'm a bad googler. It crashed on me. Thanks don L. ~| 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:320845 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Yet another SEO/URL rewrite question....
thanks for the tips guys! Will ~| 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:320751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Yet another SEO/URL rewrite question....
I'm planning on using onMissingMethod() to create some pretty URL's for products, using a new db field (productPrettyTitle) in my products table. I'd rather not use an ISAPI filter right now. Everything seems to work OK so far, but I wondered what would happen if I took it a step further. Is there a downside to adding more keyword-rich extensions in whatever CF config xml file? So for a baseball product site, I'd have: www.mycoolsite.com/some-cool-product.baseball Instead of: www.mycoolsite.com/some-cool-product.cfm Will googlebot care? Will I be penalized? Thanks, Will ~| 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:320632 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 can I make this Replace() work?
I have an uploaded file named: CIY '06 001.jpg (That's CIYspace'06space001.jpg) I want to change the name of that file to: CIY06001.jpg Dunno if this is an option rick, but I usually use bobby h's trick of creating my own filename for the images. Then you don't need to worry about crappily-named images from users. cfset somefilename = replace(createuuid(), -, , all) Then cffile save the image with your newly-created filename. Then again, I wouldn't doubt if YOU were the one naming the images. :) Will ~| 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:320520 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DropDown List
I am working on Dropdown List and was just wondering how to make the dropdown list selected data preserved. cfform prevervedata=yes works for other Formfields but not the drowpdown list? Does your select menu use cfquery data? ~| 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:320349 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 to convert GMT Time into something I can use
Problem is, the order date they are passing is in Greenwich Mean Time, and looks pretty funky to me: I used this. Seemed to work fine... http://www.cflib.org/udf/DateConvertZ Will ~| 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:320247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cffile in a CFC
I have a user submitting an image via a form. I would like to make a function in my cfc to upload the file. What do I put in the fileField attribute of CFFile? Arguments.TitleImage or Form.TitleImage? What type do I set for the cfargument? String? Binary? http://corfield.org/blog/index.cfm/do/blog.entry/entry/File_Upload_and_CFCs ~| 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:320211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I give...anything inherently wrong with this code that would cause this error?
Thanks, everyone, for pointing out the goofy errors in the attributes. I don't know how I got those in there...copy and paste gone wild, or something. Maybe just old-age confusion... :o) Rick, have you thought about just quitting CF altogether? And maybe taking up PHP or .NET?? :) Will ~| 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:320192 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Arrays
Interesting Will. So does your outer-most structure have some sort of incremental key? Personally an array of structs seems easier to me because the array implies a series of something. As far as updating and the code to deal with them it is pretty much 6 or 1/2 dozen I would think. I have a timeAdded key which I sort on using structSort(). cfset keyArray = structSort(cart, numeric, desc, timeAdded) Then use the resulting array to loop over the cart. cfloop from=1 to=#arrayLen(keyArray)# index=thisKey pSKU: #keyArray[thisKey]# | Time Added: #cart[keyArray[thisKey]].timeAdded# | Price: #cart[keyArray[thisKey]].price#/p /cfloop Will ~| 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:319952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MySQL - Querying tax total for each month
MySQL 5 My client wants to run a report on taxes collected for a given month in a given year. I have a typical orders table with an âordertaxâ field and âorderdateâ field. Iâm remote right now so I canât test this, but how could I spit out order totals for each month. Hereâs what Iâm thinking⦠select month(orderdate), sum(ordertax) as totalMonthTaxes from tblorders where year(orderdate) = 2008 group by month(orderdate) order by month(orderdate) Any better ideas? Thanks, Will ~| 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:319534 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Googlebot got me good last night...
cfif session.allowin neq true cfif ListLast(CGI.SCRIPT_NAME, /) EQ ../admin_login.cfm cfelseif ListLast(CGI.SCRIPT_NAME, /) EQ login_process.cfm cfelse !--- Not logged in, alert user and redirect --- script !---alert(You must login to access this area!);--- self.location=../admin_login.cfm; /script /cfif /cfif Why are you using JS? I usually cfinclude the login form. Never rely on JS for anything like this. Will ~| 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:319540 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Arrays
I find a structure of structures to be better-understood, and easily updated. I have some example code from my cart if you want it. Will ~| 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:319040 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need ISAPI rewrite help...
What version of ISAPI Rewrite are you using? The tutorial looks as though it's written for v2; whereas in v3 it is much more like the syntax of Apache's mod_rewrite. Which means that the querystring is not actually seen as part of the URL in RewriteRule, but can be accessed via a RewriteCond. I'm using V3 I believe. I just want to convert: calendarDetails.html/EID/935 - calendarDetails.cfm?EID=935 Thanks much! Will ~| 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:319051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need ISAPI rewrite help...
And this assumes that the files are at your site's root, and that it's always an EID value you're matching. (If the key value in the querystring varies, you could use a regex for that too). Thanks Seb! So I could say: RewriteRule ^calendarDetails\.html/[A-Za-z]+/([0-9]+)$ /calendarDetails.cfm? EID=$1 [NC] ~| 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:319057 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Need ISAPI rewrite help...
This should do the trick: RewriteRule ^calendarDetails\.html/EID/([0-9]+)$ /calendarDetails.cfm? EID=$1 [NC] Seb, this works just fine in the ISAPI test utility, but I cannot get the URL variable to show up in URL scope of the page, which of course, cause an error. http://staging.ac100.org/calendarDetails.html/EID/935 URL.EID should = 935, but it isn't. I restarted IIS, etc. Any ideas? Thanks for your help! Will ~| 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:319058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Need ISAPI rewrite help...
I'm attempting my first SES URL rewriting with the IIS ISAPI filter, and having a few problems. I wanted to process .html files as .cfm's. That part seems to work, but I have another rule that converts /EID/993 to ?EID=993 My URL var doesn't seem to be seen on the action page. http://staging.ac100.org/calendarDetails.html?/EID/935 I dump the value of URL.EID, and it's 0, which I had cfparam'd. Here are my rewrite rules in httpd.ini. Thanks for any help someone could offer. RewriteRule (.*)/(.*)\.html(.*) /$2.cfm [I] #Convert SES URLs to standard URLs before passing them to ColdFusion RewriteRule (.*?\.cfm)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)? $1(?2$2:\?)$3=$4?5$5: [N,I] RewriteRule (.*?\.cfc)(\?[^/]*)?/([^/]*)/([^/]*)(.+?)? $1(?2$2:\?)$3=$4?5$5: [N,I] I was using Brandon's tutorial here: http://www.bpurcell.org/blog/index.cfm?mode=entryentry=1070 ~| 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:319019 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Need ISAPI rewrite help...
You know you don't have to use a rewrite tool to do that - you can just map the .html extension to CF in IIS. Well I'm eventually wanting to create friendly URL's. /someVolleyballShirt.html. I think you might need to use the .html extension. I tried it with and without. No matter what I do, URL.eid is never available to me. Thanks, Will ~| 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:319024 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Limits on images being uploaded using CFFILE?
I'm getting errors when i attempt to upload images to a site using an image upload form I've done. But I'm not sure why. What does your file processing code look like? Will ~| 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:318168 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 to: Submitting a form to self
How do I get the above section to submit the selected voucher to populate the remainder of the form with the relevant details before I submit the form for processing? TIA Sounds like you could use an onchange event in that select to submit the form. Use that for your cfif to run that query for the card data, and display it inmore form items. Then use your form.submit variable to actually process the form. it'd be niftier if you used some AJAX to do it. Will ~| 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:318147 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
The right syntax for last insert - MySQL
I don't want to use the new result variable in CF8 here. What's the right syntax for getting the last inserted ID in mySQL. I'm getting a syntax error with this: insert into sometable (fields...) values (values) ; select last_insert_id() as lastinsert ~| 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:317949 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The right syntax for last insert - MySQL
Found a beautiful post by ben on this subject. Thanks ben! http://www.bennadel.com/blog/1209-Turning-On-Multiple-Statements-In-ColdFusion-8-MySQL-4-5-Datasource.htm Will ~| 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:317952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: The right syntax for last insert - MySQL
MySQL doesn't allow multiple statements in a single query unless you change a server config option. It's a form of SQL injection protection. So just run the two statements in two CFQUERY tags. You'll need to ensure they're on the same connection with no interleaved queries though, so make sure you use CFTRANSACTION if, for some reason, you're not already. Thanks barney! That got me headed down the right path. Will ~| 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:317953 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Load testing tools.
I played around with WebLoad and thought it was pretty easy to use. http://www.webload.org/ Will ~| 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:317821 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Ok, let me get this straight...
Should I be able to set up my local dev environment mappings, where I view all http requests through localhost/..., and my remote server environment mappings, where the server is a multi-homed webserver, in such a way that the same logical path will work in both places? When I used to use the built-in webserver, I couldn't do this. So I switched to apache, and now my paths work fine. The built-in server sees wwwroot as the root, which screwed me up. Will ~| 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:317711 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 you guys deploy databases to shared servers?
I'm heartily sick of the tedious way I have to spend half a day or more EACH WEEK uploading and downloading databases from my SQLServer2005 web sites. Not that it helps you any, but this is exactly the reason I've moved most of my websites to MySQL. Navicat makes this kinda thing completely brainless for me. Will ~| 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:317370 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ColdFusion Express?
cf express + :oP I think rick uses cf express beta. ~| 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:317333 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 to deal with multiple sites within one
i also have to warn you having multiple domains with the same content can class as duplicated content in Google. If Google decides the websites are the same it WILL only index one of them or only one domain will come up per search query i.e. sports. this rule will also apply to sub domains Google will only list 2 sub domains in the same results but NEVER on the same page. hope this helps :) That helps alot. Thanks for the tips! Will ~| 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:317289 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 to deal with multiple sites within one
I'm just wondering what will happen with SSL. Never done it like that before. Thanks, Will ~| 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:317285 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4