Re: Threaded cfhttp example
Here try this. I snipped it out of something I use to build static pages with CFHTTP. It builds thousands of them based on query output. I wanted it to run multiple threads at once but not so many it fried CF. So the code keeps track of how many threads are running and limits their number to a value you specify. variables.threadcount sets the number of threads to allow to run concurrently. For your routine you could have the urls you want to canvas in a db, query them as seen below and then reference the query output's current row in the loop via the loopCounter variable as shown. cfscript variables.threadArray=arrayNew(1); variables.threadCount=3; /cfscript cfquery name=getData datasource=#server.DSN# username=#server.userName# password=#server.password# SELECT fileName.primaryKey FROM fileName WHERE 0=0 ORDER BY fileName.primaryKey ASC /cfquery cfset variables.loopCounter=0 cfloop condition=variables.loopCounter LT getData.recordCount !--- count the threads that are currently live --- cfset variables.threadsLive=arrayLen(variables.threadArray) !--- Do we have an available thread? --- cfif variables.threadsLive lt variables.threadCount !--- A thread is available. Increment the loopCounter and give it a name --- cfset variables.loopCounter=variables.loopCounter+1 cfset variables.thisThreadID=createUUID() cfset temp=arrayAppend(variables.threadArray,variables.thisThreadID) !--- create the thread whose name we specified and have reserved --- cfthread name=#variables.thisThreadID# action=run !--- CF Code to be run inside the thread goes here. This next cfset is just a dummy --- cfset variables.foo=getdata.ID[variables.loopCounter] !--- remove the now-completed thread from the live list --- cfset temp=arrayDeleteAt(variables.threadArray,arrayFindNoCase(variables.threadArray,variables.thisThreadID)) /cfthread /cfif /cfloop -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:360142 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 404 handler non being invoked on IIS
sorry for my lack of attention on this. If you are in fact using IIS Rewrite then that clouds the picture a little. However if I can pull myself together and write something up you should be able to do all of your 404 handling in your ... 404 handler. I don't use IIS rewrites for much and instead rely on CF wherever possible. Will try and find some time this long weekend (holiday here in the USA). On Thu, Feb 12, 2015 at 5:31 AM, Mark Spence markpence...@gmail.com wrote: After playing with it a bit more I added this: httpErrors existingResponse=PassThrough/ Now I just get a blank page. Am I successfully passing it through to cf? Hard to tell. I was hoping to have made a bit of progress. On Mon, Feb 9, 2015 at 6:38 PM, Matt Robertson websitema...@gmail.com wrote: Mark, those two threads aren't exactly a linear set of to do steps. I'll try to put that together tomorrow when I am in front of a desktop. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:360119 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 404 handler non being invoked on IIS
Mark, those two threads aren't exactly a linear set of to do steps. I'll try to put that together tomorrow when I am in front of a desktop. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:360100 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 404 handler non being invoked on IIS
Url rewrite in IIS may not even be involved here, and need not be. Prior to win2k8 the standard way to handle Cf 404 and 'fakeURL' 404's was to tell IIS not to 'check to see if file exists' in the .cfm mapping. From there CF server's 404 handler did whatever you wanted it to. To retain the same capability with dynamic urls i had to jump thru the hoops described above in win2k8. Current method of individual site 404 handlers is a pain but more flexible. On Monday, February 9, 2015, Russ Michaels r...@michaels.me.uk wrote: I deal with many sites that have non existent pages which use URL REWRITE to redirect them. The usual reason is that the url rewrite rules are not working, or even that the url rewrite module is not installed. Have you tried a very simple rule to test of that is working ok ? On Mon, Feb 9, 2015 at 9:47 PM, Mark Spence markpence...@gmail.com javascript:; wrote: Matt, Thank you for the link. I am working through the first step below: *Step 1:* Configure a Missing Template Handler in CF Administrator. Mine is global to the server and kept in the ColdFusion webroot - which is separate from the IIS web root and whose default location is c:\ColdFusion9\wwwroot. This global template is 404handler.cfm and contains the following simple code, which you can expand upon: h1404/h1pPage Not Found/pcfheader statuscode=404 statustext=Not Found At this point, visit your web site and execute a bad ColdFusion url: *http://[domain]/bogus.cfm*. You will see both the IIS remote error screen/banner followed by your ColdFusion error screen. Check the header and it is a 404. This next step will solve the dual display problem. When I visit the bogus page, I still just get the standard detailed iis 404 page, without the cf page that I created. I have tried it both with and without the Enable HTTP status codes. I can't figure out what I am doing wrong. This is on a windows 8 machine. Any ideas? Thank you for the help. ~| 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:360098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 404 handler non being invoked on IIS
Formerly, in IIS you could check a box that told IIS to not check first if a page exists on the .cfm extension, which would defeat IIS handling .cfm 404 errors. From there your CF 404 error template would take over. This behavior changed as IIS was upgraded. So Item 1: If you are using an earlier version of IIS the solution is different. Your version? Look at this: http://stackoverflow.com/questions/18879758/coldfusion-10-update-11-404-handler-not-firing this was part of my discovery that CF 10/Win2k8 error handling was different from CF9/Win2k3. From this, thre observation that IIS was returning as the failed url http://[mydomain]:80/jakarta/isapi_redirect.dll became a CF bug that I am pretty sure got fixed. My eventual solution was posted up here http://stackoverflow.com/questions/18237478/iis7-displays-both-its-own-404-message-cf9-message-should-display-just-its-ow/18927484#18927484 and involved using a local site 404 template handler rather than one specified in the CF admin. If you follow the two discussions there were a lot of suggestions that wound up doing half the job, or an unacceptable version (IIS + CF errors shown, 200 codes returned) but the above fixed the lot. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:360092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: scoping
On Fri, May 20, 2011 at 4:54 AM, Aaron Rouse aaron.ro...@gmail.com wrote: I know people who have horrible code readability and been in the same teams for 5-10 years. Granted. I should have said 'my' team. If they're working for me they get educated quick or they're gone. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:344770 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: scoping
On Thu, May 19, 2011 at 6:55 AM, wrote: Actually, there is only ambiguity for those who do not know the language they are using and its rules by default. The penalty for being smug about your mastery of the universe is - sooner or later - extremely painful. Put simply, unscoped vars can yield uncertain results. There has been more than enough illustration of this with specific cases right here in this thread, so I won't repeat them. Unscoped = sloppy. Always scoped = always predictable behavior, and always traceable at a glance by other members of the team. The latter is at least as important as the former. And anyone blowing off code readability is going to be on the street looking for a job on a different team. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:344731 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Feedback on this approach to many sites, one codebase (MSOC)
Even though my own CMS can handle multiple sites running off of a single installation, I don't run it that way. The points brought up about clients wanting individual customizations and portability fit my situation. I understand if you are offering software-as-a-service things change, but for me this turned out to be enough of a headache that I reverted to separate installs and have never regretted it. If a customer wants an upgrade, they pay me an hour or two individually to make that happen. If they want a specific feature that I don't want to fold into the overall codebase, I can do it - and earn the money for doing it - without worrying about consequences on 40 other web sites on the server. But thats a business decision and not coding. Mentioned just as food for thought. For sites for my own company, where presently we have about 36 up and running and will be at around 60 when we are done, we *do* share a single codebase. There are no special mappings. Each site has an Application.cfm that looks like this: request.appName=AR_060110_1033; request.rootFolder=ARDotCom/; request.FQDN=www.mysiteAR.com; cfinclude template=../common/Application_common.cfm The common file has some server vars too: server.BaseRoot=C:/foo/bar/sites/; server.dsn= etc. etc. blah blah And thats enough - along with more code in the common Application.cfm - to set up absolute and relative paths to the files I have located in the common-use folder. Every site has its own independent application scope. I've opted to set the app name manually so I can reset session and app vars if need be... a rare occurrence but its nice to have the option available. The root of this web site is a root folder in a discrete IIS web site and, since CF has no trouble recursing back up beyond a web root insofar as physical paths go, the /common/ folder is not accessible from the web, but it is from CF. Very simple to set up. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
Here's the update: Jochem's StAX-based solution worked so well -- and it allowed me to re-use existing code since I was already processing xml -- that I didn't bother to consider testing the xml2csv utility. Original code processing a 45mb file yielded an insert time of 90 seconds per record with total file processing time being a projected 66 hours. Using code that incorporated xmlSplitter.cfc, the routine created 2682 discrete xml files in approximately 45 seconds. From there, the insert loop did its work pulling out xml and pouring it into roughly 100 db table fields at ... 20 records per second. Total time to read in the 45mb xml file, create the discrete files, read them, insert them into the db and delete them (one at a time as I went along in the loop) was 192250ms. A bit more than three minutes. Thats an acceptable level of improvement. I owe you one, Jochem. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
On Wed, Feb 16, 2011 at 8:08 PM, Rick Faircloth wrote: Perhaps this will be of some help. Thanks Rick, Interesting stuff. I don't work with xml so much so a lot of this is new, and I hate new :-). I haven't been a full-time programmer for a few years now so I haven't kept up with everything like I would have otherwise. I have a business trip today so I have to set this aside but I'm going to run Jochem's solution - which is presented darn near turnkey - as soon as I can tomorrow and see what happens. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342379 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
On Thu, Feb 17, 2011 at 8:56 AM, Rick Faircloth wrote: Good to know! Indeed. Thanks to Marco and Mark. I plan on trying out both this and Jochem's solution starting maybe as soon as tomorrow and certainly through the long U.S. holiday weekend. Maybe try both and see which is faster. I'll post back the results. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
Hey everybody, we're in a bind here and I pitched the idea to the client of bringing in a ringer. Is there someone out there who is interested in building a direct-to-SQL Server or direct-to-mySQL-based solution? Solution would have to, on a scheduled basis, grab a file in a location on the server on its own without CF and process it (we have stuff that retrieves/places the file). Current file size is about 50 mb but must be expected to go to around 100. At 42mb using just CF I am at about 70 seconds per record loop. We need a *significant* improvement in performance. Work would be on a dedicated Windows server. Present box is a fairly powerful Crystaltech Win2003 Server w/4GB RAM and a Xeon 2.8 processor w/4 cores. We'd consider a Win2008, 64-bit installation to improve speed. Looking at a 24-core server at Viviotech w/16gb as a hi-horsepower alternative. Our feed partner is probably going to be able to use a different method of delivery that will reduce file size, but for now we need to plan for the worst and move on it. Anyone interested? You can email me at my for-reals email at matt AT mysecretbase DOT com. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342336 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
DisplacementMeasure unitCode='pound'25000/DisplacementMeasure BoatCategoryCodeSail/BoatCategoryCode BoatClassGroup BoatClassCodeCruisers/BoatClassCode PrimaryBoatClassIndicatortrue/PrimaryBoatClassIndicator /BoatClassGroup GeneralBoatDescriptionOne Big Boat/GeneralBoatDescription BuilderNameStarratt and Jenks/BuilderName DesignerNameCharles Morgan/DesignerName BoatNameInventions/BoatName Hull BoatHullMaterialCodeFiberglass/BoatHullMaterialCode /Hull BallastWeightMeasure unitCode='pound'12500/BallastWeightMeasure /VehicleRemarketingBoat /dataRecord /dataArea On Wed, Feb 16, 2011 at 10:09 AM, Rick Faircloth r...@whitestonemedia.com wrote: Hi, Matt... I know you might have looked at this link at dev.mysql.com for a solution to processing your data feed, but I thought I'd bring it up, just in case you haven't seen it. Looks like it might be right up your alley. http://dev.mysql.com/tech-resources/articles/xml-in-mysql5.1-6.0.html#xml-5. 1-in-and-out While I didn't have to process xml files, I do have to process a daily data feed of real estate data in comma-delimited files and insert that info into a MySQL 5 database. At first, I tried processing the files with CF, but it was a *really* slow process using CF, taking almost a minute to process some files. Finally, someone on this list suggested I take a look at the MySQL commands for loading data from files, such as, in your case, Load_File(), which opens an entire XML document, makes it available as a string, and inserts this string into a table column. In my case, using MySQL's load data infile, the time was reduced to less than a second. Check out the page above for details on usage and syntax. hth, Rick -Original Message- From: Matt Robertson [mailto:websitema...@gmail.com] Sent: Wednesday, February 16, 2011 12:22 PM To: cf-talk Subject: Re: Big XML files processing Really s-l-o-w. Solution? Hey everybody, we're in a bind here and I pitched the idea to the client of bringing in a ringer. Is there someone out there who is interested in building a direct-to-SQL Server or direct-to-mySQL-based solution? Solution would have to, on a scheduled basis, grab a file in a location on the server on its own without CF and process it (we have stuff that retrieves/places the file). Current file size is about 50 mb but must be expected to go to around 100. At 42mb using just CF I am at about 70 seconds per record loop. We need a *significant* improvement in performance. Work would be on a dedicated Windows server. Present box is a fairly powerful Crystaltech Win2003 Server w/4GB RAM and a Xeon 2.8 processor w/4 cores. We'd consider a Win2008, 64-bit installation to improve speed. Looking at a 24-core server at Viviotech w/16gb as a hi-horsepower alternative. Our feed partner is probably going to be able to use a different method of delivery that will reduce file size, but for now we need to plan for the worst and move on it. Anyone interested? You can email me at my for-reals email at matt AT mysecretbase DOT com. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342342 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
On Wed, Feb 16, 2011 at 3:49 PM, Jochem van Dieten wrote: Would it help if you split the file into individual records before processing them? I think it would help immensely I think. I'd prefer to fight my way thru this in CF if at all possible and things are just complex enough that I may need to go the route of stax. Outside my comfort zone in terms of installing it on the server but I can likely figure it out. This morning I investigated the possibility of dropping into java and reading one line at a time, parsing out the text in that line... Its what I do in this file's CSV-format predecessor. But there are no CR's or LF's in the file so that is out. Thanks very much for that post and your thoughts. Incidentally if anyone is looking for an xml reader/editor that can almost instantly read these kinds of moster files, check out the free firstobject xml editor. http://www.firstobject.com/ -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342360 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Big XML files processing Really s-l-o-w. Solution?
My question is how do I reduce processing time... is there anything I
could be doing better?
I am tasked with doing an import on a file whose size can essentially
be unlimited. We've been able to handle in the 10-15mb range but it
recently ballooned to 100 mb, and its going to get larger. Processing
time seems to be about 66 hours for a 45 mb file and thats a disaster.
For a 14mb file its about 90 minutes.
Whats happening is this: CF is looping over a very large number of
records that are in themselves fairly complex. The more records there
are, the longer the loop over them takes. More records + more time
per record = a seemingly geometric increase in processing time.
The file is read in like so.
!---
read the imported file
---
cflock
name=mates_import
type=EXCLUSIVE
timeout=10
cffile
action=READ
file=#variables.mates.srcFile#
variable=x
/cflock
cfset x =
replaceNoCase(x,StateOrProvinceCountrySub-DivisionID,StateProvince,ALL)
!---
turn the file into a coldfusion xml object
---
cfset x=ltrim(trim(x))
cfset x=XMLParse(x)
The above takes only a few seconds. No problem there.
Next I have to read in some header info
cfscript:
header.logicalID=x.processvehicleremarketing.applicationarea.sender.logicalID.xmltext;
header.taskID=x.processvehicleremarketing.applicationarea.sender.taskID.xmltext;
header.BODID=x.processvehicleremarketing.applicationarea.BODID.xmltext;
header.created=x.processvehicleremarketing.applicationarea.CreationDateTime.xmltext;
// ...
// and here comes the node with all of the line items in it I'll have
to loop over. This is where all of the speed issues have been traced
to:
variables.mates.boatArrayLen=arrayLen(x.processvehicleremarketing.ProcessVehicleRemarketingDataArea.VehicleRemarketing);
/cfscript
knowing the array length I can use CFLOOP to look over it and pull
data in where it is then stored in a db.
cfloop
from=1
to=#variables.mates.boatArrayLen#
index=i
cfscript
listings_mates.inHouseListingNumber=M-
x.processVehicleRemarketing.processVehicleRemarketingDataArea.vehicleRemarketing[i].vehicleRemarketingHeader.documentIdentificationGroup.documentIdentification.documentID.xmltext;
listings_mates.price=x.processVehicleRemarketing.processVehicleRemarketingDataArea.vehicleRemarketing[i].vehicleRemarketingBoatLineItem.pricingABIE.price.chargeAmount.xmltext;
listings_mates.currency=x.processVehicleRemarketing.processVehicleRemarketingDataArea.vehicleRemarketing[i].vehicleRemarketingBoatLineItem.pricingABIE.price.chargeAmount.xmlAttributes.currencyID;
// there can be more than one of these items so run a loop inside
of the loop
variables.mates.engineArrayLen=arrayLen(x.processVehicleRemarketing.processVehicleRemarketingDataArea.vehicleRemarketing[i].vehicleRemarketingBoatLineItem.VehicleRemarketingEngineLineItem);
ii=0;
do {
ii=ii+1;
listings_mates.engineDesc=x.processVehicleRemarketing.processVehicleRemarketingDataArea.vehicleRemarketing[i].vehicleRemarketingBoatLineItem.VehicleRemarketingEngineLineItem[ii].VehicleRemarketingEngine.modelDescription.xmltext;
listings_mates.engHrs=x.processVehicleRemarketing.processVehicleRemarketingDataArea.vehicleRemarketing[i].vehicleRemarketingBoatLineItem.VehicleRemarketingEngineLineItem[ii].VehicleRemarketingEngine.totalEngineHoursNumeric.xmltext;
} while (ii LTE variables.mates.engineArrayLen);
...
/cfscript
...
/cfloop
And so on. A hundred or so fields and a dozen or so loops inside the
main loop, along with a loop or two inside of those. So the very long
variable names get even longer.
As you can see I am pouring the data into a struct, and when done, I
insert it as a db record.
Anyone see a mistake in my methods? Would things speed up if, before
I read it into an xml object, I ran a replace() or three to shorten up
some of those names?
--
--m@Robertson--
Janitor, The Robertson Team
mysecretbase.com
~|
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:342213
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
Client is running mySQL, But a SQL Server could probably be arranged if we have to. Kind of a painful investment for them, though. I was kind of hoping you guys would find a bonehead mistake that would magically clear this up. I'm out of CF-based ideas. Speaking of which, I tried shortening those var names with some replace() statements and it had zero effect. Didn't expect it would but wanted to throw it up against the wall. Damn shame I can't drop to java and do a line-by-line read like I do with CSV files :-( -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342220 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
On Mon, Feb 14, 2011 at 3:27 PM, Mark Mandel wrote: Either that, or start looking at something like StaX - http://stax.codehaus.org/Home thx for the tip on Stax but it frankly looks a bit out of my league for this project. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342221 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Big XML files processing Really s-l-o-w. Solution?
Very interesting stuff, guys. Very much appreciated. Should have come here before I did the project as opposed to afterward. You'd think I'd know better by now. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:342231 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Permanent Redirect (301)???
Here's what I do to force traffic onto the same domain so Google is happy: ...taken from where I set my application vars ... cfset application.FQDN = www.foo.com /... ...this is inside of /Application.cfm cfif compareNoCase(cgi.server_name,application.AMPro.FQDN) cfif Len(Trim(cgi.query_string)) gt 0 cfset variables.QueryDelim=? cfelse cfset variables.QueryDelim= /cfif cfif not CompareNoCase(cgi.https,ON) cfset variables.HTTPData=https://; cfelse cfset variables.HTTPData=http://; /cfif cfif not Compare(cgi.server_port,80) cfset variables.ServerPort= cfelse cfset variables.ServerPort=: cgi.server_port /cfif cfset variables.newURL=variables.HTTPData application.FQDN variables.ServerPort cgi.script_name variables.QueryDelim cgi.query_string cfif not compareNoCase(right(cgi.script_name,10),/index.cfm) cfset variables.newURL=replaceNoCase(variables.newURL,index.cfm,) /cfif cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=#variables.newURL# /cfif What it does is check to see if the domain is what its supposed to be. If it isn't, the url is dissected and reassembled, this time using the correct domain. Additionally, it also looks for any url with an 'index.cfm' in it. Google doesn't like to see links to both http://www.foo.com/index.cfm and http://www.foo.com/ so this eliminates that 'duplicate' url. All of this has to be done in conjunction with matching link coding throughout your site. It won't help (and I am sure it would hurt) to do this if your own links aren't written properly. As in you consistently use the proper fully qualified domain name, and your links to your home page never use 'index.cfm'. -- --m@Robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:340995 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: br instead of br /
It doesn't. CF can do it of course as the OP said he was already doing. The solution I have used is to change the doctype but this was already mentioned above. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:339593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: fckEditor and Coldfusion tags
Are you trying to retrieve coldFusion code from a database and then execute it? -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:338399 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: fckEditor and Coldfusion tags
The only way to do it would be to write the code into a file, then CFINCLUDE it, kind of cumbersome, Not quite the only way. 1. Write the code in the editor ... as if it were a code editor :-| 2. Store the form field data using the gymnastics described earlier. 3. Publish the data as a discrete .CFM template that you use somehow in your application. Since its a physical .CFM you can CFINCLUDE it, CFMODULE it, call it directly as a discrete template etc. If its a CMS you could use code to auto-handle naming, pathing etc. etc. My CMS does all that now but I don't allow CF code to be written into the pages it publishes. On the surface it doesn't sound like an ideal way to write code and build applications but its a big world I guess and someone needs to do it. Glad its not me. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:338418 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF9 Developer on Windows 7 Home Premium?
I'm looking at buying a couple of laptops that will get some light development use. The trouble I am seeing is every laptop whose feature set I am interested in is running Win7 Home Premium. If I am running CF9 developer on them and would only be using the development web server, will CF9 run on it or will the installer kick me out when it sees the Win version I'd be running? -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:335946 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF9 Developer on Windows 7 Home Premium?
Beautiful. Thank you, Dave. You mean upgrade Windows, right? I'm still running all my office stuff on XP downgrades. Stayed clean away from Vista except for my home system which is running Vista 64 On Tue, Aug 3, 2010 at 12:46 PM, Dave Watts dwa...@figleaf.com wrote: I'm looking at buying a couple of laptops that will get some light development use. The trouble I am seeing is every laptop whose feature set I am interested in is running Win7 Home Premium. If I am running CF9 developer on them and would only be using the development web server, will CF9 run on it or will the installer kick me out when it sees the Win version I'd be running? CF 9 will run just fine on that, but if you later decide you want to upgrade to Professional or Ultimate, you can actually do that very easily online. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite ~| 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:335948 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Shopping carts
Well, I guess it is a bag-on-Eric thread after all. Michael Grant said you'd be much better spending the 40 or so hours trying to drum up business or on a job search. Spend one day putting together a resume/portfolio and the other 32 hours contacting people and circulating your portfolio. Good advice right there. Like I said, you have a problem with your business model. Abandon it. Reboot. Cuz right now you are making a big mistake that a lot of us recognize ... since we made the same stupid move ourselves and know the consequences. And when someone tells you this they aren't elitists... They correct word is 'successful', and to be blunt, thats something you are not. Pay attention to someone who is successful if they take the time to give you advice. Chances are they have done well for reasons other than blind luck or random chance. Not saying any of this to be mean. This is just the way it is and, as many of us have said, we have been there, done that and really hate to see someone else jumping off that same cliff. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:334933 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Shopping carts
On Sun, Jun 27, 2010 at 3:10 PM, Eric Roberts wrote: I wouldn't say it's an objection to paying a few hundred dollars, it's an inability to come up with the funds to do so for the little guy. Not to derail this into a lets-beat-on-Eric thread, but as others mentioned, thats peanuts. Something is wrong with your business model if you are in this business and a fee like that knocks you out of the game. Not bagging on you... I'm just sayin'... and I'm saying it as someone who started coding in an office that was a spare bedroom in my apartment... sitting on a plastic lawn chair. I did mom-and-pop retail work and there are some jobs you *have* to say no to, unless you've got nothing else and your time isn't worth anything (i.e. the time you'd save not rolling your own solution... you could be on to and getting paid for your next job). I'm not sure CF lends itself to the mom-and-pop operation, where the expectation is that you can get an ecommerce site for $500, three bags of Doritos and a case of Jolt. There's plenty of college-student developers out there who work for those rates and if you play in those waters you'll never get past that. A fair question to ask: Is the small business ecommerce market such today that it pays NOT to be involved with it? i.e. all the free/cheap/just-add-water solutions out there... Can a developer who wants to earn a good rate for their time get there at all anymore with ecommerce? Does that perhaps explain the dearth of solutions? -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:334879 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Re: CF 9 Hosting
I too have been with Crystaltech for years. Something you should have done if you had a tech talking like that is report it in the satisfaction survey they send out after every ticket is resolved. One thing I have learned is that *all* hosts, sooner or later, decrease in tech support quality. The trick is to find the one who declines the least, where that decline doesn't affect you because you put yourself in charge of the job.. Its helpful when you can do your own work and don't have to rely on anyone. Which brings me to my next point: Stop trying to get decent CF service on shared hosting. It only takes one moron writing bad CF code (and lets face it, CF has more than its fair share of those per capita, thanks to its shallow learning curve) to crush the life out of the server. Stop wasting your time swimming upstream. Drop the coin to get yourself a dedicated box and a CF license. Then only your own code - which is of course rock solid - is affecting the box. You have a high nut to make for the month, sure. But its peanuts compared to the profit you can make off of a dedicated box where you charge customers $20-$50 per month for hosting / email *and you get to keep all of that*. Same with things like secure certificates. 10 minutes worth of effort and $30 in actual expense. Bill it out any way you please. I jumped ship off of shared hosting years ago. Never looked back. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| 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:333872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Custom 404 Page
ColdFusion has a place to designate a special 404 handler in the Administrator. In IIS you tell it not to check to ensure CFM pages exist and then CF will handle all 404's according to your instructions. If IIS is handing off a 404 to a .cfm page, isn't that page just a dumb page that doesn't execute any CF? I have to admit I haven't tried it that way in a *long* time so I don't remember.. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.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:331141 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Server Reboot
Alan Rother wrote: If you want to set an auto refresh on your application variables, to force them to refresh, then I would create a scheduled tasks that passes in a url var which could trigger the onApplicationStart from the onRequestStart I find it can be extremely helpful to do that with both application and server variables. Sort of a back door that keeps you from having to kludge the job by renaming the cfapplication statement, or restarting the CF service in the case of server vars. Me, I don't have to reboot servers any more often than I have to install Windows security patches, which is to say monthly. On rare occasion something gets gummed up and requires a restart of a service or the whole box, but by and large you shouldn't be seeing any need to restart your app. -...@robertson- Janitor, The Robertson Team http://mysecretbase.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:326120 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: New CF8 vulnerability
Supposedly on July 6 a new version will be released that is at least better, if not 'fixed'. Kind of glad I put mine behind logins from the get-go. I am guessing that this affects all FCKEditor installations and not just CF8's cftextarea. Way back when, an earlier cf connector was so full of holes I wound up rewriting it with another developer's help and posting it on their forum. Guess that since then its code got a lot more complex but not a lot better. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.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:324211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload suddenly stops working
A Windows security update would seem to be one of the usual suspects when it comes to mysterious behavioral changes. Just a shot in the dark. I had a blowup today myself on some longstanding code but it was a CFX based issue. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322188 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Detect a 301 redirect
CF matters aside, isn't anything but a silent, server-side redirect going to do very very bad things to your SEO and existing link placement? -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322201 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload suddenly stops working
Matt: Have you heard of any security updates that would affect CF5 in this way? No not at all. I was just throwing out a potential culprit, as in if I haven't changed anything, what could have changed automatically on me? Another potential for change then, is the browser itself. Thats something else that updates itself automatically and is in this mix. Any chance you can fall back to an older browser somewhere? Perhaps one sitting on one of your servers that you can get to via TS? Using a browser from a server is a sin, I know, but if ever there was a place you can find an old browser version, thats a likely way to find one in a snap. Have you checked to make sure your cgi.request_method is post like you think it is? Sounds like you have already checked the form scope exists. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322202 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Newbie ... CFSQLTYPE of CFQueryParam
Anyone remember this article? http://coldfusion.sys-con.com/node/45569 Lets you drop down into Java and pull out the field types that your db reports back to the JDBC driver. Its neat on the surface, but too expensive on resources to use on the fly. Plus you have to put the for-real username and password directly into the template... Using vars doesn't work. Still, I like to use it during development if I have a monster query that I need to write up. Saves me the need to look back and forth from screen to screen to determine what the next cfsqltype is in my query list. Or stick it in front of a custom tag that writes the sql and cfqueryparams for you !--- cfmodule template=create_record.cfm dbUserName=#attributes.DBUserName# dbPassword=#attributes.DBPassword# DSN=#attributes.DSN# tableName=woof fieldList=arf,bark,ruff,meow SQLTypeList=CF_SQL_VARCHAR,CF_SQL_VARCHAR,CF_SQL_VARCHAR,CF_SQL_VARCHAR valueList=how,now,brown,cow --- cfquery username=#attributes.DBUserName# password=#attributes.DBPassword# datasource=#attributes.DSN# INSERT INTO #attributes.tableName# ( #attributes.fieldList# ) VALUES ( cfloop list=#attributes.fieldList# index=FieldValue cfset variables.LoopCounter=ListFindNoCase(attributes.fieldList,FieldValue) cfqueryparam cfsqltype=#ListGetAt(attributes.SQLTypeList,variables.LoopCounter)# value=#ListGetAt(attributes.valueList,variables.LoopCounter)# null=#YesNoFormat(not Len(ListGetAt(attributes.valueList,variables.LoopCounter)))# cfif compareNoCase(ListLast(attributes.fieldList),FieldValue),/cfif /cfloop ) /cfquery -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best practice - registration activation by email
Ditto, except I use a 24-hour period, which is a bit aggressive. Also on the first login the user is prompted to enter a hint and an answer for future forgotten-password routine use. The hint is encrypted and the answer is stored as a salted hash. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:319658 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 performace/practice for storing temp data
What Dave said about client scope and db rows. For my own cart I wound up using client variables. I felt they were more survivable than session vars. Restart CF and lose your session vars... bad news on a shared server where the host might have an uneven record of uptime. A cvar-based solution will typically survive a cf restart (user visits page, cf gets restarted while user reads content, next page hit is after restart and cvar cart contents persist). I haven't kept up with CF8's features but I believe they are in a struct now and much easier to work with as a result. My thinking behind not using a db table was that I would need to clean it up somehow, and the fact that the client variable db was automatically cleaned out over time (imperfect assumption on my part) did that job for me. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How do you guys deploy databases to shared servers?
An unhelpful observation: I just migrated a guy off of SQL Server and onto mySQL so we could handle this sort of thing so much more smoothly. SQLYog has a command-line utility you can schedule that will do as many one-way or two-way synchs as desired and don't require the db to be taken offline. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317428 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 performace/practice for storing temp data
Whatever you do, don't take ease of programming your solution as a valid way to look at the problem. You are talking about a cart checkout process. The payoff to your client's entire business model. Paramount is making something that will not step on its own you-know-what ... ever. As in fault tolerant. I'd cross session vars clean off the consideration list since they can go byebye for a variety of common causes. In my mind, we are talking about database or client vars. Only. Pick the solution that survives the most number of common, imperfect circumstances. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: finding dynamic form fields after submission
That CFC is sweet! Ages ago I wrote up a complete tutorial on how to do the multi-record thing, start to finish. http://tutorial214.easycfm.com/ I used evaluate(), which is a sin, but otherwise its a pretty straightforward, basic way to get the job done. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317007 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: finding dynamic form fields after submission
*sigh* where is the UnSend button? That tutorial only covers updating existing rows. Never mind :-) form.fieldnames and a little conditional logic should fix you right up. Don't forget to also exclude the form field(s) your submit button generates. -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Locking Shared Variables
You surround code that needs to be locked with cflock and /cflock statements. Also you are using a session lock with an application var. Don't take it wrong but the manual is probably a good place to go to get a handle on this. Using Persistent Data and Locking: http://livedocs.adobe.com/coldfusion/6/Developing_ColdFusion_MX_Applications_with_CFML/sharedVars.htm#1159066 -- -...@robertson-- Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Alternatives
Can't slowly unspooling emails also be attributed to a mail server thats slow in accepting them? I know I have that problem with my SmarterMail-based mail server, although I can live with it because my CF-originating traffic is not all that time-critical. Surprised no one has recommended iMS from CoolFusion. It hasn't been updated in years but I'd be surprised if it needed an update when it comes down to it. The thing always hauled ass for me... but as people have said, ColdFusion improved its mail performance years ago. Don't dismiss what people are saying about CF's mail handling performance. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:314063 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMail Alternatives
Welp, iMS_SE is only $250. And they have a single-threaded free version you can try. Or at least they used to. Check their site. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On Fri, Oct 17, 2008 at 2:10 PM, [EMAIL PROTECTED] wrote: I also am using SmarterMail Enterprise. The main reason I don't think it is SmarterMail is because I have sent mail to that same mail server from an enterprise version of CF and it went out plenty fast. I have also sent mail to that same Mail Server from ListServ products and it also goes out plenty fast. ~| 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:314072 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFMail Alternatives
as maddening as it is, fast mail is a problem as opposed to a solution it seems. I've used a mail trickler to get around this for years. http://mysecretbase.com/Slowing_Down_CFMail_2004.cfm It is far from perfect, but it works. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On Fri, Oct 17, 2008 at 8:01 PM, Al Musella, DPM wrote: I have to do strange things to intentionally slow down the sending of mail. When I send mail out at full speed, I get blocked by a lot of isps. Does anyone else have that problem? ~| 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:314086 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 does Security affect search engine spiders?
is there a good bot/bad bot list? Not that I would trust it but it can't hurt to at least look at whether its feasible to use it as another weapon in the arsenal. I have an IP- and bot-identifying based system that works pretty well but I'm always up for newer and better info. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313827 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 does Security affect search engine spiders?
Oh yes... I found out early on that I would get all bent out of shape and cranky doing log analysis without filtering out that declare stuff before it hit the logs in the first place. I figured there was no point to relying on user agent info but wanted to see if anyone had anything that I might pick over. Good old FunWebProducts ... a.k.a. I Am a Moron ... -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313832 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SQL injection attack on House of Fusion
Well I guess I'm glad I am not the only one dealing with this. I implemented cfif cgi.query_string contains DECLARE%20 cfheader statuscode=500 statustext=Server Error /cfif at the top of /Application.cfm and that stopped it dead in its tracks, but not before spiking my custom logging app and turning my weekly sales response figures to oatmeal. A little spit and polish fixed that. One client had about a 3-day love affair with these bots before they went away. They made a mess of his error logs when the non-conforming data hit cfqueryparam but otherwise no noticeable effect. I think if I was still actively in the contract programming scene I would find the person propagating this and... pin a medal on them and shake their hand. This one attack has caused a whole slew of folks who thought I was a PITA crank over-obsessed with security to call me up, apologize and thank me. If I was still taking clients I'd have just doubled up my dance card. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| 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:310577 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
PDF delivery via CFContent in IE7 ... doesn't.
This is driving me nuts. It works great in Safari, FF and, up until recently, in IE. Server is CF 6.1 I have to serve up pre-existing pdf files stored off the web root and pushed to the authenticated visitor via cfcontent. User clicks on link located at foo.cfm: a href=bar.cfm?FileIs=woof.pdfclick me/a bar.cfm contains some gymnastics that determines which folder is pulled. I'll hardwire it here for simplicity: cfset variables.pushFile.filePath=c:\pdfs\ I do a fileExists() check of course. and now the part that seems to have suddenly broken: cfheader name=content-disposition value=inline; filename=#variables.pushFile.fileName# cfcontent type=application/pdf file=#url.fileIs# IE tries to treat bar.cfm?FileIs=woof.pdf as a pdf file. Then nothing in the blank window that follows. What am I doing wrong? Seems like something changed in IE. I am on IE7 and Acrobat 5 and 9. Tests in IE6 and 5 show it works fine. And it worked in IE 7 until very recently. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| 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:309831 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF delivery via CFContent in IE7 ... doesn't.
I had to go in and change IE7's settings before it would shoe the movie You mean Windows' settings, right? I don't know anywhere where IE7 does file type support, although that doesn't mean its not hiding somewhere inside. Since I have the full Acrobat (5) on my desktop unit, I'll try it on one that has just the plugin. Maybe thats the problem... but it worked on this desktop recently. Bah! This is supposed to be simple! I don't know what I'd do if I spent the day working on what I expected to. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On Mon, Jul 28, 2008 at 3:04 PM, Will Tomlinson [EMAIL PROTECTED] wrote: This is driving me nuts. It works great in Safari, FF and, up until recently, in IE. Server is CF 6.1 I could swear I ran into this same thing with WMV's. IE7 wasn't set as default for that file type. I had to go in and change IE7's settings before it would shoe the movie. Otherwise, I believe it was a blank screen. Could that be the culprit with PDF's as well? hth, Will ~| 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:309833 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Just a little cfcase tip...
been there and done that :-) -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| 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:308636 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Store Locator - Mass Import
I've built something like this myself and as Ian says its all about your validation routine. You run it, you test each field with everything you can throw at it (in my case regexes are my friend) and you tell the uploader of problems with the upload operation. If something gets past the regexes and a sql write fails the reason is logged separately. Also you may or may not want to skip over error records and continue with the good ones, or fail the whole upload depending on your business rules. I use the intermediate temp table concept as well to keep the upload the heck away from a live db until its been fully vetted. Its all possible with CF. You just have to code it. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:305122 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Update multiple Records
I wrote up a complete tutorial on how to do this over at easyCFM a few years ago. http://tutorial214.easycfm.com/ Don't hate me for using evaluate() :-) -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304683 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 unofficial ahphosting status thread
What a mess for many of you; Mary Jo your story in particular. 3 hosting moves? Jeez. Stick to that CT dedicated. Shared hosting is problematic at best imho. Dedicated hosting is the only way to go. No crackpot problems that you don't make yourself. No goofball code blowing up the server. No crazy loads bogging the server. I'm not actively in the programming business any more but I still keep the servers. I'll never suffer thru a shared host, having known the freedom of dedicated, and slept peacefully thru so many nights... Its been a log time since my cell phone beeped me out of bed at 4 am and I sure don't miss it. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| 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:299808 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: a sIMPLER url?
You can easily do this with your missing template handler. First of all, your web server needs to hand off 404 processing to CF. on IIS you do this by altering the .cfm document property so the box that says 'make sure the file actually exists' is unchecked. Obviously I'm paraphrasing and not trying to give you a step-by-step on how to do it). Next, set up a missing template handler in the CF server admin. Next, in that missing template handler ... you tell it what to do. This means you deal with the expected cases of 'false' 404's as well as properly handling real ones. So lets say you have a set of search results that you want a crawler to move thru. Creating urls like http://mydomain.com/next/list_61.cfm http://mydomain.com/prev/list_1.cfm You could make up something like what you see below. Set up a cfif for every possible case you can find. the thing works by chopping up the url looking for a string. When it finds the string it branches accordingly. You would think that using cfhttp like this is really resource intensive but it has proven not to be via experience. Since I am querying 'myself' with it essentially, the load has proven to be negligible. !--- make sure its not a for-real error (error handling code snipped out for clarity) --- cfif not isdefined (error.diagnostics) cfset is404=1 !--- not defined. must be a 404 and not an error --- !--- next/prev button --- cfif FindNoCase(next/,cgi.path_info,1) or FindNoCase(prev/,cgi.path_info,1) cfset is404=0 cfset url.StartRow=ListLast(ListFirst(ListLast(cgi.Script_Name,/),.),_) cfset thisURL=#server.rootURL#list.cfm?StartRow=#url.StartRow# /cfif !--- ... more cases go here ... --- !--- did we NOT hit one of the special cases? --- cfif is404 !--- the var is not set, so lets show our dummy resource-lite 404 page. --- cfheader statuscode=404 statustext=Not Found cfheader name=Location value=http://mydomain.com/404.html; cfabort cfelse !--- get the page, whose url has been determined by the handler above. --- cfhttp url=#thisURL# method=GET timeout=20 resolveurl=YES port=80 /cfhttp !--- display what we got --- cfoutput#cfhttp.FileContent#/cfoutput !--- kill the waaabbit --- cfabort /cfif /cfif On Feb 13, 2008 11:08 AM, Josh Nathanson [EMAIL PROTECTED] wrote: and I get 404 - not found... I think you need to remove that trailing slash in the rewrite rule, if it will not be present on the request url: RewriteRule (.*)/seminar/(.*) $1/seminar.cfm?VAR=$2 -- Josh ~| 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:298918 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF-based CMS?
At one time, ContentMonger was the most downloaded free CMS on the Adobe developers exchange, and I believe that still is the case. The download is now what was once the full commercial version. Its $99 to license for a commercial site. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| 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:295381 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF forums
What we really need is forum software that emulates VBulletin. That stuff is so far ahead of products available to the CF community it makes it worth it to add a PHP server to your mix. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| 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:294941 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: No Longer Need to Lock Session Variables?
Not really. You still need to lock around any potential race conditions. Perosnally I tend not to lock reads and always lock writes, unless there is a race condition possibility on the read, in which case I lock that too.. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMAIL quesitons..
My clients have been sending mail for years without this happening. The largest one is in the medical industry themselves, and they send by the thousands every week with no problems. Their list is an opt-in for their association members. Environment is a shared host where the web server is one IP and mail is another, common IP for all web sites. DNS is all green according to dnsreport.com (have you checked yourself against that or a similar checker?) The thing I give much credit to for keeping me under everyone's radar for many years running is the use of a mail trickler. My clients are running the one built inside of ContentMonger that has error trapping and restart capabilities. Easy to build your own. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFML engine compatibility - a possible solution?
If you wrap the various different implementations in something like a CFIF around a CFINCLUDE, does that allow one (set of) templates to run on all engines ? It very well might! I haven't tried, myself. It works fine. Something old I snipped and simplified for the sake of illustration from some old code I have: cfif not compareNoCase(server.coldFusion.productName,BlueDragon) ... do stuff ... cfelse ... do different stuff... /cfif You can of course use different server variables, different values, snip out substrings etc. to make your decisions. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292438 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfwebstore ups rates table
Dan, as I mentioned in my email to you earlier today you can use the importation tools that are in the tag distribution, but as Mary Jo said there is more to this than just importing the text files (assuming UPS still even makes them available, and they are still in a usable format). I dropped UPSR for a reason... UPS changed their rate structures enough from year to year that tag maintenance just ate too much time, especially given what they did in the 2005 rates. I made the decision after many hours of work getting myself up to that point... and I knew that I was likely in store for more of the same the following year when UPS played the same game all over again. Thats going to be you if you go this route. UPSR was a great tag for the four years or so that I kept it updated, but UPS wants very badly for you to use their own internal tools and your client will be a lot happier if you don't swim against that current... and so will you, frankly. If you are desperate to fudge this you can add a blanket surcharge to the rate calculation that will guesstimate the difference from the 2004 rates to today... but this is not recommended. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291900 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cfwebstore ups rates table
I just checked. UPS no longer even provides ASCII data. Its all pdf's now. They used to provide a form of ASCII that UPSR could clean up and use as a fixed-length file. No more. You would have to hand-input every rate item, and there are probably thousands of those. The days of such independent tools are past; especially if the source dries up. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291902 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Stop View Source
Richard, here is everything you need to know about protecting client-side code and images: http://www.digitalmidget.com/help/noclick/index.php :-) -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SYS-Con relies on quot;deadquot; technology
Considering the context perhaps we should adjust our expectations ;) Exactly. What else would you expect from an entity with their reputation? If their code was well put-together it would be the only thing so in their entire organization it seems. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Returns the value, 16,16?? Please help!
honestly, I haven't read the code posted, but I can say with certainty that you get a comma-delimited list in a single form field if you are submitting it twice. You'll get smarter answers if you say some words in your post. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290881 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: isEmail vs cfmail tag
Chasing the perfect regex in this circumstance is like trying to herd cats. Figure something screwy will always come up and meow at you from behind, but if you error-proof your app no matter what shows up you will chug along. I carved the example below from one of my mail trickler tutorials. I personally prefer to store the error record in a single database record (tied to a EZ-PZ GridMonger grid for administrative display) as what you see below can get pretty monstrous if there are more than a few errors. Doing it that way also lets me cfdump out more scopes for better diagnosis. Then I just send a 'hey dummy' email to the admin telling them to check the error log. cfset variables.errArray=ArrayNew(2) cfloop query=MailList cftry cfmail to=#MailList.EmailAddr# from=#MailList.EmailFrom# subject=#MailList.EmailSubject# server=#MailList.EmailServer# type=HTML #MailList.EmailMsg# /cfmail cfcatch type=ANY cfset arrayAppend(variables.errArray[1],MailList.ID) cfset arrayAppend(variables.errArray[2],MailList.EmailAddr) cfsavecontent variable=variables.diaginfo cfdump var=#cfcatch# label=Read This You Poor Sap /cfsavecontent cfset arrayAppend(variables.errArray[3],variables.diaginfo) /cfcatch /cftry /cfloop cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=OOPS! server=mail.mydomain.com type=HTML cfdump var=#variables.errArray# label=Error List /cfmail On 10/9/07, Rick Root [EMAIL PROTECTED] wrote: On 10/9/07, Russ [EMAIL PROTECTED] wrote: Actually, if the email is being sent to an address hosted at the email server through which the email is being sent, and the server replies saying something like 'This email doesn't exist', CF will fail the mail and put it in the undeliverable folder. I don't believe it will cause an exception (unless maybe the emails are not set to be spooled in the admin?). that is correct, if spooling is disabled, cfmail will throw an exception on delivery failure. This of course is REALLY REALLYL slow. -- Rick Root Check out CFMBB, BlogCFM, ImageCFC, ImapCFC, CFFM, and more at www.opensourcecf.com ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290685 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF Coding Standards
or don't do tabs and use spaces exclusively. Tell HomeSite/CF Studio to convert tabs to spaces so you don't have to actually use the spacebar. I went that route after I wound up having to edit non-CF code in HS and weird things started happening to the other code, whose (primitive) native editor used spaces only, and whose interpreter didn't figure on seeing tabs in the code like that. Not sure if CF cares much over the extra char count. Must be a slow day if we are all waxing eloquent on this utterly worthless topic :D Oh and another variation on the tag thing: cfmail to=#MailList.EmailAddr# from=#MailList.EmailFrom# subject=#MailList.EmailSubject# server=#MailList.EmailServer# type=HTML I put the closing bracket on the same line as the last attribute. woo hoo. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290687 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Coding Standards
Cutter (CFRelated) wrote: People still use HomeSite or CF Studio!?! (Cutter ducks from the flying objects) ;) Only when I have too much stuff in memory to load Notepad :D -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290710 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Breaking down mass email into chunks to beat page timeout.
Try this. Its been around for a long time and works very well. There are server-side-only variations described somewhere in there but I have never had one work anywhere near as well as this: http://mysecretbase.com/Slowing_Down_CFMAIL.cfm 2nd generation: http://mysecretbase.com/Slowing_Down_CFMail_2004.cfm Gen3: http://mysecretbase.com/slowing_down_cfmail_2006.cfm -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On 9/25/07, Andrew Peterson [EMAIL PROTECTED] wrote: Hello, I have a mass email which times out due to our shared server's timeout of 60,000 ms. (It takes longer than that to process the page.) I could loop through and send out 2000 emails at a time, but I am still stuck with having the client wait and click on Send the next 1000 emails button until they're all sent out. Looking for a more elegant solution - something behind the scenes. Any ideas? TIA. Sincerely, Andy ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289444 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: #$^% Forms!
I wrote a form generator and submitted data handler into my ContentMonger CMS years ago. Supports every form type, secure forms, handles data encryption where desired etc. etc. Let the editors build and manage their own forms, I say :-). A year or so ago I put in hooks that let developers tie in their own custom form processors; either to supplement or entirely replace ContentMonger's built in form processor. Its a killer tool, but I understand why so few do this. Its a royal screaming b*tch to visualize the thing, let alone code it. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:289378 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Quick Question About Dbase Architecture
A single lookup table should work fine for this. I don't see a need to create a different table for each lookup. Field structure ID (int, indexed) ItemType (varchar 25, indexed) ItemStored (char3) ItemDisplay(varchar 25) The field lengths above are not set in stone, and I am assuming your profile table does not have any one-to-many relationships with the drop-down data (there's only oging to be one marital status per individual profiled, for example). Data would be stored in the profile table in individual dedicated fields. I don't see a reason to have a foreign key in the lookup table. To edit all lookups you can develop a simple data grid that dumps them all out, sorted, or get fancy and make one data grid per field name. Drop-down display results from a simple select statement with one filter for itemtype. ItemType gets the form field name, perhaps. ItemStored is what is put into the db and ItemDisplay is what is visible to the user in the drop-down. I suppose if you were a fanatic about data normalization you would create a table for 'lookups' and have it contain only ID and ItemType. Then your lookup table has an indexed ParentID field (foreign key) replacing the ItemType field. Not something I would do unless I was trying to impress a professor in a class project. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288734 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: FCKEditor Revisited
Check out CFFM as an alternative file manager. Its easy to integrate into FCKEditor and doesn't suffer from some of the BS that the included system does. I see the FCK author has a Finder that is really slick... but no CF version yet. A couple versions back I helped write a better file manager for FCK with one or two other CF guys via the FCK forum. What I did was mostly plug loopholes and try to put in tests that checked to see if some clown had managed to get to a folder they shouldn't be in, and if they were to deal with them. IIRC the early v2 file managers could allow folder traversal to forbidden lands. I haven't gotten too deep into the current code base as I chucked it out in favor of CFFM. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:288507 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SECURITY: ENCRYPTION AND HASHING
Its not a failure of the industry experts to understand the problem. Its the failure to have a problem in the first place, honestly. I think that, while you are clearly working hard to wrap your arms around the subject... you aren't there yet. What you want to do is inherently insecure... use client-side code to enforce a component of security? How would you protect the client-side code from being hacked and manipulated to ill effect? What scenario will you be covering, since the transmission off the screen is fully covered by the https protocol and a certificate? The only threat left is someone looking over the hapless user's shoulder and writing down their input, and in your capacity as developer you cannot protect against this type of threat. And client-side code is inherently open and available to the ... client. Open for inspection and giving clues to the server side tools in use; providing insight to the thoughtful hacker as to how they go about their next step in their attack against you. So if the client desktop is its own problem outside your control, and the transmission has a globally-accepted, universal solution in place, that only leaves the server side, and there you do indeed have quite a lot of wiggle room with respect to doing it badly versus doing it well. Just for starters, if you are hashing something (like a password) I would say you have made a mistake right there if its a simple hash. Use a salted hash always. I know cfencrypt/cfdecrypt has made great strides in CF7, but I'm not sure if it is really industrial-strength? I'll leave that question to others. I rely on 3rd-party tools that give me RSA asymmetric-key encryption of selectable strength, personally. SSL is used for confidentiality, not Data Integrity That is incorrect. Read tha Wikipedia article that was linked a few posts back in this thread. While you need to exercise care and perform due diligence, some of this is a lot simpler than you are making it out to be. Worry about the server side. The rest is effectively out of your hands due to the nature of the medium. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286886 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: fckeditor not under root and image connector
one thing I remember from monkeying with FCKEditor in my own cms... that application.cfm in its folder structure can be safely removed and that solves at least that part of your problem. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:286745 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: hooking up IMS Lite
very easy. If you've ever config'd a mail server before you should be in for about 5 minutes' work. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: HostMySite: Linux Builder + CF No Longer Offered
Its the same old story for shared ColdFusion hosting... morons can code in crap that takes the server out and blows everyone else up with it. A service nightmare even if the host has CF knowledge. Takes me back to the days when I was on shared CF hosting at Interland. Anyone remember that nightmare world? And then moving to Virtualscape and how good they were by comparison? ah... CF nostalgia. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Easy-to-develop recurring billing?
Whats the easiest gateway to deal with (as in program a solution for... preferably something with a tag already developed) with respect to setting up recurring payments? Ideally it would support monthly and weekly open-ended. It would also have to support single transactions. Anyone have a favorite where code is available either at the Exchange or from the gateway's support group? -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282382 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Easy-to-develop recurring billing?
On 6/27/07, Irvin Gomez [EMAIL PROTECTED] wrote: Authorize.net. There are several tags for it. Actually thats not correct unless I have been unable to find something that is hiding. Single billings are typically managed thru Auth.net's AIM interface. And for that there are indeed several tags out there. I have one of running now and auth.net would be my preferred provider. But my primary need is recurring billing, which is gotten to (at auth.net, at least) via an entirely different API -- and they do not provide any sort of sample code for that method. Nor are there any custom tags for it. I wish it were as simple as just adding a parameter to their AIM protocol. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF Editor
On 6/25/07, Bobby Hartsfield wrote: opinionIf it were easy to just install CFE and simply double click a .cfm (that isn't part of an existing project) then edit and save... CFEclipse would be on every developers workstation./opinion A big amen to that. I have a very limited amount of time to be anything but productive. If something has a learning curve it has to be a shallow one or it costs me a small fortune to forego otherwise paid production time for unpaid learning time. I've always felt Eclipse missed the boat big time by ignoring what I have always felt was a fundamental unit concept... the file. Instead of wrestling with using the UI you instead get to wrestle with how it wants you to organize your work. Thanks but no thanks to that. All I want is an editor, not a nanny. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282127 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Updated Broadband Stats
On 6/16/07, Dinner wrote: random rhetorical aside (disregard) How come so much CF uses .cfm, when there's a ton that could be written to plain html, sparing CF cycles? Cache takes care of it? /random rhetorical aside (disregard) Hah. One of my pet rants. Answer is one or the other of 1. The developer/customer is not up to the task of complicating the admin/edit process by outputting static pages from their administration system 2. The developer/customer doesn't understand or dismisses the benefits of static delivery, or opines that gratuitous dynamic delivery is what [insert app server here] is for. One of the best things you can do for a busy CF server is ... cut CF out of the picture. Let IIS do the heavy lifting and keep CF as an admin-only tool wherever possible. /rant -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281564 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF 6.1 Std to CF8 upgrade path
Sorry if I missed it earlier but has Adobe announced whether or not folks with CF 6.1 will be eligible for upgrade pricing to CF8? -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281278 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Updated Broadband Stats
I'm researching broadband acceptance rates in the U.S. right now and I just saw this thread. I came across the stats ref'd in the first post already. Looking around some more I found another source that pegged the number at 60%. Still another gave a 2005 prediction that put us at about 65% in 2007 but that didn't take into account the slowdown in broadband adoption that has occurred since. While Mike's point about aiming for your target audience is well-taken, its also important to take what Rey is saying to heart. How many of us have experienced what life is like on your U.S.-typical 49k dialup lately? Tried it for a week? I was on it for two recently. Do that and it will give you a whole new appreciation of web site bloat. Broadband is far from ubiquitous. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: FMS2 - CF8 and MySQL on the same Server?
I wouldn't even think of running a db on the same box, despite its capacity. some of them getting 1 million hits per year could equate to 20k hits per day; which isn't the end o the world but its substantial. Then you throw in that there are going to be video downloads? And SATA drives and not SCSI? I'd separate out the db to another box with at least a single SCSI drive (I'd feel better if it was a RAID5) and use SCSI drives for the RAID5 on the web box. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281344 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Robust Permissions System
AccessMonger Pro has groups, tiers, permissions and the ability to bundle them all together into a profile you can apply to a given user, then customize individually. It doesn't use functions as you describe to test for permissions, though. It uses a variable assignment (to define the permission or permissions allowed to access a given block of code) followed by a cfinclude and a cfif to test the result. Functions would definitely be cleaner. Includes are survivors of a codebase set down in olden times, and still around thanks to my busy social calendar. Its more than just permission assignment, though. Full user management. Login, automated password reset and so on. I didn't implement anti-permissions the way you describe them. I looked at them and decided that the way this system is structured with respect to user customization that it could be handled differently if that need was present. Not 100% sure that decision covers all circumstances but I have yet to hear differently from a user so its held up pretty well on that score. http://mysecretbase.com/AMPro_Home.cfm -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:281014 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Short rant
And the fact that it is freaking impossible to import data in the Express version. Funny... this topic coming up right now. I have a client with a BIG web site who has decided to branch their main web presence onto SQL Express, and I spent some frustrating time a few days ago trying to figure out how to import data into the thing via the Express tool... Discovered the tools for that aren't in Express. At all. Anyone know if Management Studio keeps working after the 180-day trial period is up like it did with the old Enterprise Manager? Heck I'd be happy to buy EMgr like I have in the past (the US$50 msrp was reasonable) but it doesn't seem to be available as a standalone. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280846 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Short rant
On 6/12/07, Crow T. Robot wrote: I'm pretty sure Express Mgmt Studio is free - period. Is that what you're asking? No I'm using the Mgmt Studio Express myself already, like the original poster. I was lamenting about how there was no way to import or export data from it... since I am right in the middle of a major job with a client where I am needing to export a lot of data from SQL 2000 (table by table) and ... Access (also 1 table at a time). Russ and Dan seem to have a better grip on reality than I do. I had flat out been unable to find a copy of the Dev edition for sale when I was looking for it last week. Found another one at CDW just now, but its not as cheap as Amazon. I'll try Russ' solution first to see if I can live with it. Thx guys, -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280852 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 love CF but it's not fair
On 6/12/07, David Low wrote: I don't recall CF5 ever being free though, There was Cold Fusion Express. It was a chopped-up v4.x IIRC. Crippled and didn't last long. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| ColdFusion MX7 and Flex 2 Build sales marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Large CSV File
And you can always drop to java and read the little beast in one line at a time that way. You won't have any memory issues like you would if you try and read in an 80mb file into a single cosmic-scale array. I have a similar monster file situation and solved it this way; although mine is daily and only about 20mb I chopped this out of that working file. Hopefully I got all the important bits as the original is like 1000 lines. Basically imported.str is one line of the file. It is incremented as shown and you do whatever processing you need on the text. I have a bunch of reformatting and additional processing that I do before I toss the data into a db, publish a static file blahblahblah. What I like about this approach is I get to do everything in a single cfloop that has minimal memory consequences. cfset srcFile=c:/foo/bar/mongofile.txt cfset fr=createObject(java,java.io.FileReader) cfset fr.init(srcFile) cfset br=createObject(java,java.io.BufferedReader) cfset br.init(fr) cfset imported.str=br.readLine() cfloop condition='isDefined(imported.str)' !--- ...do stuff... --- cfset imported.str = br.readLine() /cfloop cfset br.close() On 6/12/07, Jake Pilgrim [EMAIL PROTECTED] wrote: A number of excellent database-based solutions have already been posted (and a database solution is probably preferred), but don't overlook CFHTTP. CFHTTP is actually quite good at parsing a CSV and spooling it into a CFQUERY. Depending on exactly what you want to do with your data, this may be a good solution. ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Open Source ColdFusion CMS
Sorry to resurrect a dead thread but I hate leaving loose ends. I missed Andrew and Rick's question as to how I created my ContentMonger tutorials. I used ViewletCam by Qarbon. Its a lot cheaper than RoboHelp, and a lot less functional, but it gets the job done for $149. If you just dabble in making these sorts of movies its an alternative to a $1000 product, but I'd sure rather have RoboHelp. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On 1/21/07, Andrew Grosset wrote: I like the demo/tutorial. Editing and publishing content: Quick and Dirty Tour: http://mysecretbase.com/cmpro/tutorials/tutorial05 How did you do that? Andrew. Hi, Matt... ContentMonger looks good... and I like your tutorials... quick-loading and clear. What did you use to create those? Rick ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280401 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Form Encryption
You can use asymmetric-key RSA encryption economically... http://developer.perthweb.com.au/textcrypt.html I've been using that tool for many years. its about as safe as you can get for encrypting stored data. Key part of that phrase is as you can get. The problems with symmetric key encryption were already well-stated. Don't even think of doing that. In theory a combination of SSL and a 128-bit RSA encryption provide a commercial-strength solution, but I would argue that its a horrible idea to store credit card info on a server you are responsible for. Its such a gross violation of best or even acceptable practices in the IT and financial industries that the liability you will bear if the chain of custody on the private key is compromised... the liability you will personally incur, as well as what your client will incur... its not worth the risk. I would suggest that, if you are storing data encrypt ALL of it to make the job more difficult. Do not name the fields with hacker-usable names (like credit_card_number) Use symmetric key encryption to encrypt first, then use asymmetric to encrypt that. Access your db server via a 2nd nic and make that 2nd nic go to the other server via internal IPs only. and say your prayers regularly. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| ColdFusion 8 beta â Build next generation applications today. Free beta download on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280270 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SOT - Passing Credit Card info w/o storing in DB
The robot has it right. You should only be transmitting cc info via a secure gateway to a cc processor, where keeping the data safe is their problem. Just clarifying in case your client wants something like cc nums emailed to them or somesuch. I've had a few of those requests. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:280302 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Shocked!
If CF had a demand scoping option it would break most of the CF code out there if what I've seen is any indicator. 'course, since I am a troubleshooter, the reason I am working on a given lump of code in the first place is because the original code was developed by chimps. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Deploy Web Applications Quickly across the enterprise with ColdFusion MX7 Flex 2 Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278806 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shocked!
I wonder if the simple hill folk who cannot learn to scope vars would put up with a cfprocessingdirective statement or any other developer-accessible feature that impacts so severely their free-love style of development. It would severely pu the screws to some kinds of application 'structure'. You know the kind I mean... Where you not only don't scope, but you can't because Cheeta and Tarzan decided to accept inputs to a given var from the url, variables and form scopes and didn't know how to ... ah... don't get me started. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278813 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Shocked!
On 5/21/07, Steve Brownlee wrote: It just took me off guard more than anything and made all the red flags that have been pounded into my brain start waving. As well they should. Off the top of my head I can't think of a more effective way to obfuscate code... and that includes cfencrypt... or fusebox oh my here we go... Where's that UNsend button?!? -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create robust enterprise, web RIAs. Upgrade integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278827 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 on CF server
It will run, but no matter how overbuilt your server is, you'll get better reliability from two separate servers. For years I ran a setup like you are describing... big dual-processor behemoth with uber-SCSI drives and gobs of memory. The theory was to overbuild the single box and use all that extra capacity to run multiple apps off the same box (in my case that was CF/IIS, mySQL and SmarterMail/ASSP). When I eventually outgrew that, I went to two behemoths and put CF/IIS alone to itself, moving db and mail/antispam to its own box. Reliability went WAY up. Later, I decided to go with a lower-cost approach: A mid-grade build for web/CF (dual Xeon, 2gb, 1 73gb SCSI drive), and a single cheapo server for mySQL, another for mail, another for DNS/antispam and so on. I wound up spending less for *five* 'little' servers that each did only one or two things ($480/month) than I did for Godzilla and Megalon ($850/month for both) ... and reliability went from 'pretty darn reliable' to 'rock solid forever and ever'. I personally would never go back to doubling and tripling up like that if I could help it. My server setup: LARRY primary DNS statistics (smarterstats) backup for all the other servers (synchback, mySQL via sqlYog scheduled jobs) CURLY CF-generated smtp (smartermail) antispam gateway for human-generated mail (ASSP) MOE mySQL SHEMP CF IIS JOE Secondary DNS human smtp/pop mail server, web mail (smartermail) If I need more capacity I'd replace one of the small boxes above with a bigger one. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com On 5/17/07, Jim McAtee [EMAIL PROTECTED] wrote: We're finally going to be migrating from CF 5 to CFMX 7.1 soon and will spec a new server with Win2k3 Server Standard as the OS. The dbms, currently running on a separate Windows server, is MySQL 5.0. If we move MySQL to the new server, how well could we expect it to coexist with CF/IIS on the same machine? The new server will likely be far more powerful than needed given our traffic level and the complexity of our web sites - either a single or dual dual-core Xeon, 4GB memory, 10k RPM SAS disks. I suspect MySQL will run faster on this machine, even with CF and IIS running along side, and it eliminates the 100 Mbps network connection between two machines. Any thoughts or recommendations? ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:278536 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Online WYSIWYG Editors
On 5/4/07, Will Tomlinson wrote: Is this the part where I make funny jokes about the name, FCKeditor?? You will be able to call it CFTextArea at some point in the future. I just read the following announcement: Adobe has chosen FCKeditor for one of the great new features of its next major release of ColdFusion, code named Scorpio. Some reviews of it can be found on the web. For ColdFusion programmers, it will be as easy as defining a cftextarea richtext=true tag to see FCKeditor playing all its power on their pages, out of the box. ... http://www.fckeditor.net/newsarchive And on the home page of the site. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Create Web Applications With ColdFusion MX7 Flex 2. Build powerful, scalable RIAs. Free Trial http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:277082 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Check for valid email before CFMAIL
verify your email addresses above the cfmail statement as described. if not valid email then branch your code to notify somebody that Record X has a sucky address that needs fixing (I compile a complete list of all failures and only send the list once its finished). After that, surround your cfmail statement in a try/catch block, where the catch block also adds notification to the list you are already compiling. By putting cfmail into a try/catch block you allow the other cfmail statements in your query loop to run despite the failure of one or more cfmail statements. You wind up with a much more robust chunk of code. I never use the query attribute of cfmail anymore. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276699 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HTTP Compression with CF7
I have used cfx_gzip for years with no adverse effects. Check the Exchange for it. Requires a separate custom tag also found at the Exchange. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Macromedia ColdFusion MX7 Upgrade to MX7 experience time-saving features, more productivity. http://www.adobe.com/products/coldfusion?sdid=RVJW Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276317 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Preferred clientstorage setting for client variables
On 4/25/07, james carberry wrote: What is the best way to store client variables? Better way to phrase that is what is the least bad way? :-) Cookies are a disaster. To make a long story short you can't count on them being present all the time, and you have to wait for a trip to the client and back before you can use one thats been set (unless that behavior has changed over the years). Plus they can be hacked ore easily, being client-side. All of the true nightmares I have experienced with cvars have been when I discovered the site owner was storing them in cookies. Writing to the registry... It works, but horrific consequences possible if a write goes bad. Other nasties possible. For example your site gets hit by an ill-behaved bot two zillion times and it creates two zillion entries... in your registry. Your now-uber-bloated registry. 'nuff said. Writing to the db. As robust as your db is. Nobody loves a thing that executes a db read and write at every page request, but at least there are no vultures circling your server when you do it this way. The problems you will cause will be manageable, one way or the other. Lest you think I hate cvars, I do not. I still use them at least to some degree, although mostly in legacy apps. I try to rely on session vars. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: cf_htmlemail
That tag is from back when dinosaurs ruled the Earth. My Multimail tag attempted something similar, but it went a step further and converted html into usable, legible plain text... achieving success up to a point. cf_htmlmail requires your input of two different message versions. I dropped attempts at doing this quite some time ago. There were just too many browser-based web mail clients and such that blew a gasket on seeing what was CF's version of multipart mail. Got tired of messing with it and just started relying on cfmail type=HTML and the problems my clients had simply stopped. Haven't had a need to revisit the issue in years. -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 MX7 integration create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJQ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:275102 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Scorpio Prerelease Program
first rule about beta club is you don't talk about beta club. :-) -- [EMAIL PROTECTED] Janitor, The Robertson Team mysecretbase.com ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
