Re: SQL Express and CF
the things cut out of the express version are the kinds of things we use coldfusion for anyway. I havent found any issues at all in connecting SQLexpress versions and Coldfusion. The only issues I've had are to do with things like the lack of SSIS which makes things like moving data to online more difficult that's all. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Nov 16, 2012 at 6:32 AM, Pete Ruckelshaus pruckelsh...@gmail.comwrote: Works just like the full version, and it's what I use on my VPS. On Thu, Nov 15, 2012 at 5:23 AM, Kevin Parker tras...@internode.on.net wrote: Are there any issues using Express versions of SQL Server for development? Thank you ++ Kevin Parker M: 0418 815 527 ++ ~| 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:353200 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Best practice question for Application.cfc
Which ever way you do it, somewhere or other you have to have a file that's unique to this site, or have a settings record in a database or some such. Does it REALLY make much difference if it's a site-specific Application.cfc or a site-specific Settings.xml file or a site-specific Settings table in a database? The way I do it is to have a config folder in the core code, which is where I put the site-specific things that are called by the generic core code. There's usually a config.xml with site name, application name, passwords to things. Then when I create a new site, I copy all the core code over, then go into the config folder and modify all the values in the config.xml.The config.xml file is called into a config.cfc that sets up all the application and other critical variables for the site at application start. But I dont think you necessarily need to do it the way I do.I would suggest though, that you keep all the site-specific variables in one place (in my case a config folder) so it's quick and easy to set up a new site. And also when you modify your code, you know that you can safely copy all your modified files into your other similar sites without breaking all the site-specific settings. This is not related to whether or not you use Application.cfm or Application.cfc. The same principles apply however you set up your code. But since you are changing your architecture, it's a good time to examine whether you have opportunities to make your code better organised. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, Oct 14, 2012 at 1:46 AM, Dave Watts dwa...@figleaf.com wrote: We're moving from application.cfm to application.cfc and I had a question regarding best practices. We re-use our base code and in the past, we have used a settings page that is external from the base code and unique per client to set the applicationname variable (and other variables). This is called at the beginning of application.cfm and provides cfapplication with the unique application name. That same structure seems to work with application.cfc but requires calling a file at the top of application.cfc, above setting the application variables in application.cfc, to provide the applicationname. Is that approach (calling a file at the top of application.cfc to provide a unique client setting) considered a best practice for this kind of thing. Or, is there a more appropriate way? The only other thing I could think of would be to hard code the unique client applicationname in Application.cfc, but that would then require that Application.cfc be a unique file per client and thus not part of our core base code in the sense that we wouldn't include it in upgrades (so that it wouldn't over-write a unique client file with default values). I think the most common approach for this sort of thing with Application.cfc is to use inheritance. You can have a base Application.cfc, then use the EXTENDS attribute to create a new Application.cfc with customized settings, overridden event handlers, etc. 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/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:352900 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with CF Barcode39
I've never tried to use a special font (i.e. not standard windows) with ColdFusion - do you have to register the font with CF in teh administrator or something like that? Does it print out the number in times roman or helvetica or something? Cheers Mike Kear On Sat, Sep 22, 2012 at 2:36 AM, Bruce Sorge sor...@gmail.com wrote: I downloaded the font but my macbook is not picking it up. It recognizes other fonts that I have installed but not this one. Weird. Bruce On Sep 20, 2012, at 4:03 PM, Mike Kear afpwebwo...@gmail.com wrote: You might need to download a 3of9 truetype font and print the number you want in that font. it's just like printing 44557841 in TimesRoman, except you're printing it in Barcode3of9. That's the way we've been printing barcodes for decades. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:352699 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) How compatible is SQLServer 2012 with SQL Server 2005 databases?
Thanks Larry, and that's what I'd have expected.Most software products offer a means of upgrading existing files when there's a new version. My issue is that my main client has SQL2005 databases in production. So any work I do for him has to be on SQL205 database. And any new database has to be a SQL2005 database. Any StoredProcs have to be SQL2005. So I was really asking if there are any features of SQL2012 I'm likely to use that aren't compatible with SQL2005. It's the downwards compatibility I'm really worried about. As it happens, Microsoft tell me it can't be done - it's taken them 14 days to muster up the courage to find someone to answer my question. In the mean time several people here have told me that it's possible and not all that difficult, by simply setting the compatibility index to 90 when I create my work on my dev machine. But thanks for your input Larry - its valuable knowledge. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Sep 21, 2012 at 12:07 AM, Larry Lyons larrycly...@gmail.com wrote: When i upgraded, I just ran a complete backup on the 2005 db's and then did a restore to the 2012 db. Worked like a charm, no issues at all. regards, larry Sorry for asking an OT question, but I've been asking around Microsoft (at least 10 different people in MS Support, and in Partner services) for more than a week and after all this time not a single MS person will even attempt to answer this question If i install a SQL Server 2012 product, (any level - Express or up to Enterprise ) how compatible is it with SQL Server 2005 databases? The reason I ask is I'm building new laptops for development, based on Windows 7 Pro OS, and want to install up to date software if i can. But my major client uses SQLServer 2005 as his production database. Therefore any machine I build has to be capable of developing SQL2005 databases. Does anyone here know the answer? Or else can anyone point me towards someone who could tell me? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:352677 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Issue with CF Barcode39
You might need to download a 3of9 truetype font and print the number you want in that font. it's just like printing 44557841 in TimesRoman, except you're printing it in Barcode3of9. That's the way we've been printing barcodes for decades. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Sep 21, 2012 at 4:25 AM, Chad Gray cg...@careyweb.com wrote: This is a guess, because I have no experience with the custom tag to make the barcode image, but you may want to save the content out at a variable first. Then put it in the cfdocument tag. This has always worked best for me. cfsavecontent variable=voucher table width=900 border=0 cellspacing=1 cellpadding=1 tr td width=420 align=left valign=bottomimg src=Images/logo.png //td td width=473 align=left valign=middle class=TEXTLEFT4840 PERL EAST CIRCLE, 210 W. span class=ORANGE| /spanBOULDER span class=ORANGE|/span CO span class=ORANGE|/span 80301/td etc /cfsavecontent cfdocument format=PDF filename=Voucher.pdf overwrite=Yes localUrl=Yes #variables. Voucher# /cfdocument -Original Message- From: Bruce Sorge [mailto:sor...@gmail.com] Sent: Thursday, September 20, 2012 1:03 PM To: cf-talk Subject: Issue with CF Barcode39 Has anyone here used CFBARCODE? I am having a small issue with it. Basically, I am creating a PDF using CFDOCUMENT and inside the PDF I am using CF_Barcdode39 to insert a barcode into the document that will be emailed to a customer. When I put the code into CFMAIL all works fine, images including barcode are there. But because someone can get that emal and put it into a word doc and change the barcode, they want to use a PDF instead. With the PDF, the logo and signature images are fine. But the barcode will not insert into the PDF and I really cannot figure out why. I have tried cfinclude as well as just putting cf_barcode in the code as I did below. Since the barcode is basically an image that is being created based on the actual barcode in the database, I put it in an IMG tag but still get the nice little red x on the document. Below is the code I am using. ~| 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:352691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) How compatible is SQLServer 2012 with SQL Server 2005 databases?
Thanks, Maureeen and Russ. I fully expected to be able to upgrade 2005 databases to 2008 or further.What I'm really worried about is whether I'll be able to develop databases on my laptops with the newer database, and deploy the resulting work onto the client's SQL2005 database somehow. Is there a converter utility or something or can i create a 2005 database using SQL Server 2008? Maybe I'd be better to install only the SQL2005 on my laptops. Cheers Mike Kear AFP Webworks Windsor, NSW, Australia. On Fri, Sep 14, 2012 at 6:38 PM, Maureen mamamaur...@gmail.com wrote: 2005 databases will likely run without problem once upgraded to 2012 - but you won't be able to take those databases back to a 2005 server and run them once you've upgraded them. The issues are here: http://msdn.microsoft.com/en-us/library/ms144256.aspx - especially the link at the bottom for backward compatibility issues. You can also run multiple instances of the database - different versions - on the same machine. That might be your best choice. On Thu, Sep 13, 2012 at 7:35 PM, Mike Kear afpwebwo...@gmail.com wrote: Sorry for asking an OT question, but I've been asking around Microsoft (at least 10 different people in MS Support, and in Partner services) for more than a week and after all this time not a single MS person will even attempt to answer this question If i install a SQL Server 2012 product, (any level - Express or up to Enterprise ) how compatible is it with SQL Server 2005 databases? The reason I ask is I'm building new laptops for development, based on Windows 7 Pro OS, and want to install up to date software if i can. But my major client uses SQLServer 2005 as his production database. Therefore any machine I build has to be capable of developing SQL2005 databases. Does anyone here know the answer? Or else can anyone point me towards someone who could tell me? ~| 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:352608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) How compatible is SQLServer 2012 with SQL Server 2005 databases?
OK, thanks everybody.I think I am fairly sure I'm going to be able to load up anything I might develop in the future onto that client's 2005 server. And thanks Maureen for your offer. If you dont mind, I'll keep your offer on my desk in case I really get stuck. Interesting, that I had multiple answers and suggestions inside 4 hours here, when Microsoft have been unable to even take a stab at the answer in over a week. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month -- ~| 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:352611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) How compatible is SQLServer 2012 with SQL Server 2005 databases?
Sorry for asking an OT question, but I've been asking around Microsoft (at least 10 different people in MS Support, and in Partner services) for more than a week and after all this time not a single MS person will even attempt to answer this question If i install a SQL Server 2012 product, (any level - Express or up to Enterprise ) how compatible is it with SQL Server 2005 databases? The reason I ask is I'm building new laptops for development, based on Windows 7 Pro OS, and want to install up to date software if i can. But my major client uses SQLServer 2005 as his production database. Therefore any machine I build has to be capable of developing SQL2005 databases. Does anyone here know the answer? Or else can anyone point me towards someone who could tell me? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:352605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Tomorrow: Join 55 ColdFusion Users at Automating CFML App Build, Test, Deploy, with Joseph Lamoree
Thank you, Brian. This meeting is of interest to me, but I don't know when it's on. I'm afraid in a world-wide forum, just saying '6pm' doesn't help. 6pm where? What time zone? And since I suspect it's 6pm in Georgia, that makes it 8am Thursday here in Sydney, I'll be in a meeting. Will this session be recorded for later viewing by those of us who can't make it, as so many other meetup sessions are? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Jul 26, 2012 at 4:40 AM, Brian Thornton br...@cfdeveloper.comwrote: -- Forwarded message -- From: The Online ColdFusion Meetup i...@meetup.com Date: Wed, Jul 25, 2012 at 12:24 PM Subject: Tomorrow: Join 55 ColdFusion Users at Automating CFML App Build, Test, Deploy, with Joseph Lamoree To: vegasthorn...@gmail.com [image: Meetup] http://www.meetup.com/t/md1_1 tomorrow Automating CFML App Build, Test, Deploy, with Joseph Lamoree http://www.meetup.com/__ms1204811/coldfusionmeetup/events/74575422/t/md1_grp/?rv=md1_af_eid=74575422_af=eventexpires=1343406273319sig=72da06b946d3da80b49d1cf7bbbac8221eb91621 The Online ColdFusion Meetup Thursday, July 26, 2012 6:00 PM Online meeting via Adobe Connect Meeting room: http://www.tinyurl.com/cfmeetup Alpharetta, GA Will you attend? **Yes** http://www.meetup.com/__ms1204811/coldfusionmeetup/events/74575422/t/md1_lnm/?response=3fromEmail=74575422action=rsvprv=md1_af_eid=74575422_af=eventrefund_policy=trueexpires=1343406273318sig=3d49ea6aa5a19eac5d5ae3265e528ab3c05f106a **No** http://www.meetup.com/__ms1204811/coldfusionmeetup/events/74575422/t/md1_lnm/?response=2action=rsvprv=md1_af_eid=74575422_af=eventrefund_policy=trueexpires=1343406273319sig=9ca39281a72a19e3abb2a718f558595cba5ac330 55 ColdFusion Users attending, including: ~| 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:351994 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Hosting A to Z
I inherited a couple of sites on Hosting AtoZ and still have them there. It's a low-cost hosting service, and you get what you pay for in the world, but service is still there and running. They have implemented a new trouble ticket system, which is why it might look like support has disappeared.I have never had any problem getting prompt support, in all the years I've been looking after these sites. The support trouble ticket system is at http://support.hostingatoz.com . Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sat, Jun 30, 2012 at 8:14 AM, Phillip Vector vec...@mostdeadlygame.comwrote: Had them awhile ago. The server I was on kept going down and support was non-existant. Get out now. On Fri, Jun 29, 2012 at 12:03 PM, Stephens, Larry V steph...@iu.edu wrote: Does anyone have any info about them? I moved all of my websites there several weeks ago. Seemed like a good price and someone I do some work for had been there for quite a while with good luck. Until recently they were reasonably responsive to trouble tickets although I'm pretty sure the helpdesk is somewhere English isn't the first language. I'm not passing judgment on that but there were a few communications problems that seemed language driven. But now the helpdesk seems to have disappeared. I submitted an issue a week ago and had one response and now no one will respond. Anyone else having issues? ~| 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:351769 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: [ANN SYD AU] Tomorrow (Monday) Coldfusion 10 Launch
Good luck with the session, Chris.Second time you've had a ColdFusion topic, and I'm unable to attend!!!.However, if you are able to retain any of the content for later viewing I'd be most grateful - recording or videoing or whatever. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, May 27, 2012 at 10:12 PM, Chris Velevitch chris.velevi...@gmail.com wrote: Tomorrow, Monday 28th April, 6pm for 6:30 start Richard Turner-Jones of Adobe will be showing us Coldfusion 10 along with Creative Suite 6 and Creative Cloud, from a developers perspective. Full synopsis to follow soon. Please RSVP to help with the catering numbers. You'll need to sign in and join the group to RVSP. The venue is courtesy of Rocketboots. Please RSVP to help with the catering numbers. You need to sign in and join the group to RSVP. Please RSVP at http://apugs.groups.adobe.com/index.cfm?event=post.displaypostid=42516 The venue is courtesy of Rocketboots. Chris -- Chris Velevitch Manager - Adobe Platform Users Group, Sydney m: 0415 469 095 www.apugs.org.au ~| 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:351329 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion developers in Australia
I for one am eager to see the re-emergence of a ColdFusion community here. Based on current activity, the Usergroups arent interested in it, Adobe in Australia doesnt seem very interested in it, the people organising conferences apparently arent much interested, and it basically seems to be petering out of existence. Us developers are just left to our own devices it seems. So someone taking an interest in ColdFusion again is a GOOD THING. Thank you Martin. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Mon, Apr 30, 2012 at 7:44 PM, Mark Mandel mark.man...@gmail.com wrote: Martin, You may want to send this to the CFAUSSIE making list, but to ask a stupid question: What does your site actually do? Mark Sent from my mobile doohickey. On Apr 30, 2012 4:35 PM, Martin Parry martin.pa...@beetrootstreet.com wrote: Hey guys - I'm trying to get a ColdFusion developer community going in Australia - Go to http://www.coldfusion.com.au and register your interest.. We will have project sharing and profiles available once I know the interest level is there. Martin ~| 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:350886 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: ColdFusion developers in Australia
Chris, in the last 12 months, the Sydney usergroup has had only one CF related topic (and as it happens, it was on a day I couldnt attend). The Usergroup is not interested in ColdFusion as far as I can see. And WebDU doesn't have the word ColdFusion anywhere on the agenda. No CF topics at all. CFAussie is almost no traffic. CFJobs has had only a couple of postings in the last few months. I fully understand how Martin Parry could come to the conclusion that there is no CF Community here in Australia. And I applaud any attempt to give it a bit of a kick-start. But of course I also note Mark's scepticism about this - you're right, Mark, it could be a simple case of details harvesting for any of a number of purposes, not all of them above-board. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:350908 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Somewhat OT....Making us look bad...For the adobe engineers on the list..
The only problem with using Access for a web application is that it isnt designed to handle simultaneous accesses. And that's what most web applications require.If you have multiple requests on Access, it will queue the requests and handle them one at a time. In some applications, that's not a problem. On a desktop app, for example, it's not a problem. On a low-traffic site, it's not a problem. On a web site where it's only occasionally used, it's not a problem. I've used Access several times on web sites.First I used it because I didnt know any better.Then switched to SQLServer and saw my web site performance improve markedly. Next I used it as a once-a-day method of getting client information into my web site sqlserver database. My client understood Office apps, but didnt want to install SQLServer locally and learn how to update his web site through that. He updates his Access database, uploads it, and the web site has a twice-daily task where it opens the latest Access database, reads in data, and updates the SQLServer database.It's worked flawlessly for about 18months now, and the client's happy cos he didnt have to learn anything new. Another application that worked fine for me was using Access as a link to the client's MYOB database. I set up Access as a DSN for ColdFusion and Access links to the MYOB database. Daily, the web application updates its customer database with the latest data in the MYOB database. These apps work reliably in a web environment, but with the proviso they dont have to handle multiple simultaneous requests.You can use it for web apps, but because it only handles one request at a time, your higher traffic times will be affected by the performance hit of the queueing. Also there's a strong risk of data being corrupted in that moment when there are many requests queued. As always, use the right tools for the job. Access is a terrific tool in the right situation. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, Apr 29, 2012 at 2:46 AM, Roger Austin raust...@nc.rr.com wrote: On 4/28/2012 9:18 AM, Raymond Camden wrote: I spoke to a guy yesterday who still has several (old) clients using Access. It works fine for them so they haven't seen a need to change. I used to run DeathClock.com on it (4M views per month), but I cached the hell out of -everything- I did. I still think Access had the easiest way to create tables. No visual editor I've used yet has come close - even Aqua Data Studio. I sort of cringe when people bad mouth Access. I made a lot of money using Access as a backend with CF 1.5 - 3.1 in the old days. I agree 100% on the interface, they did a great job. I don't use it for the backend DBs now, but we really shouldn't hammer on older tech since that is where the ideas of our current systems were fleshed out. One of the best uses of the newest Access is to link to SQL Server tables for now technical people. I help some people get started who know little about relational databases and end up doing some fairly sophisticated things eventually. The SQL view really helps people learn to query databases. -- LinkedIn: http://www.linkedin.com/pub/8/a4/60 Twitter: http://twitter.com/RogerTheGeek Google+: https://plus.google.com/117357905892731200369 ~| 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:350876 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Remove all CF comments
I dont understand what's the problem with comments anyway.So what if we have comments peppered through the code?Do they slow down processing in any significant way?Yes, they cause the files to be somewhat larger, but if all that means is a bit more disk space gets used, so what?If they reduce maintenance cost because its quicker for other developers to maintain the code later on, that must surely more than offset any overhead due to the existence of comments. I get that the tests in TDD are a good way to see what's happening (or supposed to happen) in code. But whats the problem if there are comments in there too? (Assuming they're accurately reflecting what's going on in the code - if they're misleading because they reflect old or trial versions of the logic, that's bad but none of us is talking about that are we?) I just dont understand why this is even a discussion in the first place. As someone who often has to work on code that others have built before me (and normally aren't around to ask questions of) I can testify that comments make any program file MUCH MUCH MUCH easier to work on. As I said earlier in this thread, I once had to work on a 1500 line convoluted file, with nested cfif clientiD = peppered through it, just to change some text being displayed. It took me hours to find the exact line I had to correct because it wasnt every instance of the text in the file, but only one that had to be changed. It certainly didn't justify spending ages and ages looking through the whole logic of the application just to make a little tweak. A few comments here or there would have meant it cost the client a fraction of what I billed him for my time for that little job, then i could have got on to another much more important job he wanted done. You dont want comments in your code? I get that. Dont know why you dont, but I get it. But I'm a contractor who does a lot of temp work on existing code bases not written by me.I know I go a lot faster when I have comments I can read. Yes, I can read code, and I can write code. But the comments make it a LOT faster for me to work out what I'm working on and how to make the change I'm asked to do. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Mar 2, 2012 at 2:04 AM, James Holmes james.hol...@gmail.com wrote: That's misrepresenting the thread. This is more accurate: Me: Don't use comments, use tests. Cutter: Noobs can't read tests Me: That's why we pair program. Michael: What do *you* do if all the developers who worked on the project are long gone? You: Read the tests. (implication; I'm not a noob). -- Shu Ha Ri: Agile and .NET blog http://www.bifrost.com.au/ ~| 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:350182 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: how deeply nested are your code comments?
If I had to change something temporarily by commenting it out, I'd be wanting to leave any comments in the code. That way, if i ended up UNcommenting it again, the restored routine would still have the comments in it.If that segment of code is permanently disabled, I'd probably remove it, along with the comments. So yes, it's quite possible that code I work on could have nested comments. But that would be deliberate. The worst job I've ever had to do was work on a 1500 line file, where the IT Director had ordered that all comments be removed 'because they only make the file bigger and take longer to load'. The structure of the code was peppered with 'cfif clientid = '423' style customisations and all carriage returns and comments had been removed.It took me hours to simply find the line i was supposed to correct. So yes, any commented out code I work on will have its embedded comments remain. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Feb 29, 2012 at 4:08 AM, Matt Quackenbush quackfu...@gmail.comwrote: Based upon what I have seen, I would say that legit comments inside of commented-out code is extremely common. On Tue, Feb 28, 2012 at 11:03 AM, Michael Dinowitz mdino...@houseoffusion.com wrote: I know that we all remove unused code and don't comment it out. I know we all use best practices in commenting code. Lets assume you were working on someone elses application that did not do these things and had comments in their code comments. How deeply nested have you seen comments on average? Have you seen comments on code which has in turn been commented out leaving the comments as the second level nested rather than the first? Worse? -- ~| 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:350141 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Controlling location of temporary file
In my shared hosting sites, I often come up against a problem with uploading files using image uploaders, because the sysadmin locks down access to the temporary directory. Is there any way to set the temporary directory in my code so I can have temp files in my own hosting space, which I have full access to? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:349389 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Controlling location of temporary file
Ray all the shared hosts have folders that are not web accessible. The question is though, how to make ColdFusion upload files into a temporary directory that i have access to when i use CFFILE He's got CF set up so that whenever I upload using ColdFusion, I get error cannot access the temp directory. I was hoping I would be able to control the location of the temp directory somehow, in a way that didnt require me putting in a system request every time I set up a site. Cheers Mike Kear On Wed, Jan 11, 2012 at 10:43 PM, Raymond Camden raymondcam...@gmail.comwrote: I'd ask your host to give you a folder that is NOT web accessible. On Wed, Jan 11, 2012 at 4:35 AM, Mike Kear afpwebwo...@gmail.com wrote: In my shared hosting sites, I often come up against a problem with uploading files using image uploaders, because the sysadmin locks down access to the temporary directory. Is there any way to set the temporary directory in my code so I can have temp files in my own hosting space, which I have full access to? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:349402 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Controlling location of temporary file
As I understand it, Coldfusion uploads a file to a temporary directory, default location is under the c:\Coldfusion directrory, then when the upload is complete, it copies the uploaded file to the location in the 'destination=' parameter of the CFFILE tag The destination directory is always under my control and i have access. It's the temporary directory that's the problem.. Cheers Mike Kear On Thu, Jan 12, 2012 at 4:04 AM, Raymond Camden raymondcam...@gmail.comwrote: I'm confused - can't you tell CFFILE/action=upload to send the file to a place you _do_ have access to? Or does even that fail? On Wed, Jan 11, 2012 at 11:02 AM, Mike Kear afpwebwo...@gmail.com wrote: Ray all the shared hosts have folders that are not web accessible. The question is though, how to make ColdFusion upload files into a temporary directory that i have access to when i use CFFILE He's got CF set up so that whenever I upload using ColdFusion, I get error cannot access the temp directory. I was hoping I would be able to control the location of the temp directory somehow, in a way that didnt require me putting in a system request every time I set up a site. Cheers Mike Kear On Wed, Jan 11, 2012 at 10:43 PM, Raymond Camden raymondcam...@gmail.comwrote: I'd ask your host to give you a folder that is NOT web accessible. On Wed, Jan 11, 2012 at 4:35 AM, Mike Kear afpwebwo...@gmail.com wrote: In my shared hosting sites, I often come up against a problem with uploading files using image uploaders, because the sysadmin locks down access to the temporary directory. Is there any way to set the temporary directory in my code so I can have temp files in my own hosting space, which I have full access to? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:349406 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Controlling location of temporary file
yes, Russ, it's affecting other things - like for example CFIMAGE requires this temp directory too. I guess i just have to live with putting in a support request every time i set up a new site for the sandbox to have access to it. Cheers Mike Kear On Wed, Jan 11, 2012 at 11:55 PM, Russ Michaels r...@michaels.me.uk wrote: Sadly no, but tell your host they need to include the temp folders in your sandbox or other things wont work either. Regards Russ Michaels From my mobile On 11 Jan 2012 10:36, Mike Kear afpwebwo...@gmail.com wrote: In my shared hosting sites, I often come up against a problem with uploading files using image uploaders, because the sysadmin locks down access to the temporary directory. Is there any way to set the temporary directory in my code so I can have temp files in my own hosting space, which I have full access to? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:349407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: anyone using ckeditor? I will PAY you for your help!
Are you trying to enter CF code into the editor and expect it to come through intact? There is quite a community of tech-savvy users on the CKEditor forum - have you checked there? It includes some CF people. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Jan 11, 2012 at 11:51 AM, Torrent Girl moniqueb...@gmail.comwrote: Hi All I have had a year long headache with ckeditor and it changing my CF code. I got around the issue for a while by using a straight text area to enter code in the DB. Now other users will be using the system and I need to get the text editor to work. I STILL have not been able to figure out how to stop this thing from editing my CF code and I am beyond frustrated with it. I tried installing tinyMCE (sp?) and it did the same thing. Has anyone installed and used ckeditor properly with Coldfusion to where it is keeping your CF code in tact? I will pay for your help (that is how desperate I am) Thank you! ~| 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:349384 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
How to compare images programmatically
I have a webcam in the studio of our radio station, and it hangs sometimes. I want to try to pin down when this happens, and send myself an email with the time etc so i can track down what's causing the camera to hang. The webcam software uploads an image to the site every 30 seconds, so I figure i can track down when this hanging is occurring by comparing the current image with one that was uploaded 30 seconds ago. When they are identical, that tells me when the camera stalled. Here's my question: how can I use CF9 (enterprise if it makes any difference) to determine if the current image is identical to the one uploaded 30 seconds ago? Is there a CF image function or tag that will compare one image with another? If not, is there a java function or something I can use? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:349354 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to compare images programmatically
Thanks for all your helpful responses ... @phillip:The symptom we get is that images are uploaded every 30 seconds ok, but at some point during the day instead of uploading new images, it uploads the same image again and again. The problem is with the computer that's providing the images, not coldfusion or the web server, but what we're trying to pin down is exactly when this occurs, so we can look at what's happening in our network at that time to cause the software to hang. We know the web server's working ok, and we know the ftp server's working ok. The images are identical, but with different creation times. So that means we're getting 'new' images every 30 seconds, but at some time in the day instead of the content being a new snapshot from the broadcast studio, it's the same snapshot being uploaded again and again.If we can learn that the software hangs at (say) 2.17am, we can look at what happened around the station at 2.17am and work out what's causing the problem - either human or IT based. That's why we want to pin down at what exact time (plus or minus a few minutes) do the images uploaded stop changing each time. I want to compare this current image, with the last one that was uploaded - about 30 seconds ago, and see if the image content is the same or not. So in short, we know the ColdFusion and web aspects of this functionality are working ok, but we want to use it to trace back in our system and see where/when the webcam software is going haywire. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jan 10, 2012 at 2:38 AM, Phillip Vector vec...@mostdeadlygame.comwrote: This may seem like a stupid question, but what do you mean exactly that the webcam hangs? You mean the software.. right? If it's the software that hangs (since hardware can't really hang), that means it doesn't upload a file or is it a different FTP program that does it? You could always set up something on cfschedule to check the most recent file and see if the time changed on it.. ~| 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:349361 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to compare images programmatically
The filename is always the same, and the ftp software sets the creation dates and mod dates correctly. Therefore we can't use any CFFILE-type functionality What we'll see is when you go into the station's webcam page, you can see the current show host as he/she does his/her show - with an image captured and uploaded to the site in the last minute.But on some mornings (no pattern we can pin down) we'll go into the site and see the overnight host, who finished his show hours ago.That image will have a create time of a minute ago, and a time stamped on the image of a minute ago. So our question is, when did the webcam software stop snapping new images? To see what I mean, see http://hawkesburyradio.com.au/index.cfm?pid=111538 - everything's working fine at the moment. But if it wasn't, we'd find about 10am tomorrow, this same image with 10am time stamped on it. But of course we know that this guy's home and in bed asleep because he finishes his show at 5.30am. So we need to be able to compare the actual content of the images somehow. If the content is identical (we know the mod dates and creation dates will be different) then the software has hanged. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:349363 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to compare images programmatically - GOT-IT!!!!
Ok i have it figured out ... i can convert images to base64 strings, which gives me a string I can manipulate using simple 'eq' operators. So using a scheduled task, every 5 minutes, I take the current cabcam.jpg (thats the name of the file that's displayed on the web page) and convert it to base64 using the function ImageWriteBase64() . That string, I compare to the one I did 5 minutes ago. If they're different, all's well and good, so do nothing, except save the base64 string to use in 5 minutes' time. If the base64 strings are the same, we have a winner!Send me an email with all the details and I know within 5 minutes when the thing went haywire. Now all i have to do is write the functionality so it doesnt keep sending me emails every 5 minutes after that. Thanks for your help everyone. I have a little bit of tweaking to get round a couple more hiccups, but i have the basis of the method I can use. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jan 10, 2012 at 3:20 AM, Cameron Childress camer...@gmail.comwrote: Depending on what EXIF data gets written to the file, you might inspect it using imageGetEXIFMetadata() and determine a change. Usually cameras will drop the date taken in there, maybe your webcam does too. cfimage source=/path/to/your/file.jpg name=myImage / cfset test = imageGetEXIFMetadata(myImage) / cfdump var=#test# / -Cameron ~| 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:349366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Music Podcast - anyone done one?
REPLY OFF LIST PLEASE I'm sorry for posting off - topic but I'm looking for someone who can give me some help getting a podcast going of a music show and I suspect there might be some people here who've done it. One of the hosts at my radio station wants to set her show up as a podcast, and she's getting conflicting stories about the amount she has to pay for licencing and royalties. Has anyone done it, and can point me at the right place for accurate and intelligent information? the Australian rights outfit, APRA is not being at all realistic or reliable. Ask one person you get one answer, ask another you get an answer that's double the price. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:349324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Save Form Data to XML file
IF you use cfdump var=#form# / you should see a struct called form with each of your form fields and their settings from the submitted form. If you use Daniel Gaspar http://www.danielgaspar.com/'s ANYTHINGXOXML.cfc you can automatically convert it to XML without any effort. http://anythingtoxml.riaforge.org/ Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Dec 15, 2011 at 3:43 PM, Tom Jones tjo...@acworld.com wrote: Hello, I have been searching all over cf-talk archives and on google and I don't see a good example on how to save form data to a xml file. So what I'm doing right now is, I have a xml file and read that and then display it in a form so the it can be edited. Here is an example on what I'm thinking. What I'm struggling with is the form data is not returned as an array of structs where I could easily create a xml file from, it's just coma separated lists. Thanks, tom !--- Example XML columns column alignleft/align dnameAgent Version/dname hiddenfalse/hidden idx2/idx nameagent_version/name order2/order width100/width /column column alignleft/align dnameAllow Client/dname hiddenfalse/hidden idx3/idx nameAllowClient/name order1/order width100/width /column /columns --- form name=colSettings method=post table width=600 cellpadding=2 cellspacing=1 tr thOrder/th thDisplay Name/th thAlign Text/th thHide/th thColumn Width/th /tr cfloop index=x array=#sortedColsArray# tr cfoutput tdinput type=text name=order size=3 value=#x.order#/td tdinput type=text name=dname size=50 value=#x.dname#/td tdinput type=text name=align size=10 value=#x.align#/td tdinput type=text name=hidden size=3 value=#x.hidden#/td tdinput type=text name=width size=10 value=#x.width#/td /cfoutput /tr /cfloop /table input name=submit type=submit value=Save / /form ~| 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:349159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: KCfinder with CKeditor and Coldfusion?
If you mean CKFinder and CKeditor, i find they cooperate beautifully and flawlessly with ColdFusion. I use them both together in my CMS systems. The trick is to note that when they install, they put application.cfm in a few places, which creates new applications and therefore all your application variables are unavailable. I found i had to disable the application.cfm that they installed and move the relevant code to my site's application.cfc . Then the only issue is setting the paths up properly. Do those two things and you'll be sailing! Happy to help more if you need it. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Dec 8, 2011 at 10:25 AM, Terry Troxel terry.tro...@gmail.com wrote: Anyone have any success with KCeditor integration into CKeditor? I do not need file uploading of any kind, just to be able to browse to a predefined image directory Under the website root to insert images stored there. Any help would be appreciated. Terry ~| 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:349026 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: KCfinder with CKeditor and Coldfusion?
In that case Terry, I'm not much help to you - I've not used KCFinder. Good luck with it though.I might check it out myself just to stay on top of things. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Dec 8, 2011 at 3:32 PM, Terry Troxel terry.tro...@gmail.com wrote: Mike, If you google CKfinder Alternative you will find KCfinder. It supposedly works with FCKeditor, CKeditor and Tinymce. http://kcfinder.sunhater.com/ I was asking if anyone has gotten it to hook up with Coldfusion safely. I do not want to allow uploading just want to browse a single image Directory on a single website. Terry -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: Wednesday, December 07, 2011 6:31 PM To: cf-talk Subject: Re: KCfinder with CKeditor and Coldfusion? I use them both together in my CMS systems. The trick is to note that when they install, they put application.cfm in a few places, which creates new applications and therefore all your application variables are unavailable. I found i had to disable the application.cfm that they installed and move the relevant code to my site's application.cfc . Then the only issue is setting the paths up properly. Do those two things and you'll be sailing! Happy to help more if you need it. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Dec 8, 2011 at 10:25 AM, Terry Troxel terry.tro...@gmail.com wrote: Anyone have any success with KCeditor integration into CKeditor? I do not need file uploading of any kind, just to be able to browse to a predefined image directory Under the website root to insert images stored there. Any help would be appreciated. ~| 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:349028 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SOT: curved corners
Most CSS3 features can be made to work in all modern browsers including IE 7+.If you can bear to have square corners in IE6 and below, there is a javascript library you can add that will give the right functionality to IE7+. (same with HTML5 functionality) Otherwise, border radius works on the other browsers as long as they are reasonably up to date. The border-radius property is supported in IE9+, Firefox 4+, Chrome, Safari 5+, and Opera. There is a 5 minute video presentation on setting border radius for webkit and mozilla browsers here: http://teamtreehouse.com/library/design-foundations/css3/borders/border-radius-part-1/play Some CSS3 features are really not viable yet because they arent very cross-browser, but my understanding is that border-radius is pretty widespread now, except for IE6. Unless you REALLY have to have rounded corners in IE6, I wouldn't use any technique other than CSS3 any more - as people move to more and more modern browsers they'll just work. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Nov 30, 2011 at 9:52 AM, wrote: I have designed a custom tag able to create all sub images from one gif image and manages all frame parts. See : CF_EasyFrame http://www.cftagstore.com/tags/cfxeasyframe.cfm -- ~| 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:348922 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Converting scientific notation to pure numeric
I'm having a brain fade at the moment, or perhaps it's a senior moment.Hopefully someone here can help.An external device is sending data to my website in XML format, which my site processes and makes available to logged-in users. It's worked fine for more than a year, but for the first time, we have a value that is calculated in the external device and has a recurring decimal value. So now instead of a simple value with 4 decimal places, I'm dealing with a value like '9.09090909090909E 106' My CFC is complaining and throwing an error that it's not a numeric value. How do I convert that 9.09090909090909E 106 to a numeric value that the CFC will be happy with? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:348870 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Wysiwyg editor
Yes, the paste from word button turns it in to plain ASCII text, at least as far as all my trials have gone. It's possible there are examples where there are fragments left, but I havent found any. It strips out all the formatting, style info, html from the word text. I have removed all the 'paste' buttons from some of my implementations, except for the 'paste from word' button, and i just call it the paste button. On those implementations, teh users only have the choice of either typing the content into the text area, or pasting it in, or using the paste button. I tell them that if they are copying text from a word or other document, to paste it in using that button and so far it's worked a treat. I suppose if i had a lot more users loading content, that might become an issue but so far it's been fine. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Oct 26, 2011 at 2:20 AM, Russ Michaels r...@michaels.me.uk wrote: I would say NOT, if you are pasting HTML with addiitonal markup, such as span tags, classes etc, it may get stripped using paste from word On Tue, Oct 25, 2011 at 3:56 PM, Rick Faircloth r...@whitestonemedia.com wrote: And the Paste from Word button works for all circumstances? ~| 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:348350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Wysiwyg editor
fckEditor (or its more modern cousin ckeditor) has a button to paste from word instead. You can have all kinds of style and markup in the clipboard and it'll strip it all out and give you just plain text entered into your field. The user copys the text from the word document, then instead of pasting it straight into the editor, click the paste from word button and paste the content into the little window that pops up. When you click the button, it puts plain text into the editor. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Oct 25, 2011 at 12:09 PM, Jenny Gavin-Wear jenn...@fasttrackonline.co.uk wrote: + 1 for Matt's reply. FCK doesn't do a great job of cleaning up word text .. do a view source .. Jenny Gavin-Wear Fast Track Online Tel: 01262 602013 http://www.fasttrackonline.co.uk/ ~| 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:348324 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfqueryparam sqltype for text field?
I am having an issue updating a record that has a text field (MSSQLServer2005). I'm using cfqueryparam and the docs are silent about what is the correct type for a MSSQL Text field. It's rejecting the update, saying The data types text and varchar are incompatible in the equal to operator I've tried setting the sqltype to varchar, and longvarchar but it still gives the error. I've never had this problem updating records with text fields before. What's the correct sqltype to use for a MSSQLServer Text field type? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/mon ~| 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:347266 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfqueryparam sqltype for text field?
OH wait.I've done it again slams forehead on the desk the problem was i was updating the record using the text field in the WHERE clause. Bad bad bad me. Sorry about that, everyone. We return you to normal programming. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Sep 7, 2011 at 5:46 PM, Mike Kear afpwebwo...@gmail.com wrote: I am having an issue updating a record that has a text field (MSSQLServer2005). I'm using cfqueryparam and the docs are silent about what is the correct type for a MSSQL Text field. It's rejecting the update, saying The data types text and varchar are incompatible in the equal to operator I've tried setting the sqltype to varchar, and longvarchar but it still gives the error. I've never had this problem updating records with text fields before. What's the correct sqltype to use for a MSSQLServer Text field type? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:347267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Problem with Apache 2.2 not starting on windows -- CF9.01
Gerald, are you sure you're running CF9 on Windows7 Home Premium?? The system requirements on the Adobe page say that CF9 has to have at least Windows7 Professional or higher. I couldnt get CF9 to install in Win7 Home Premium. It would stall mid-install and that's the end of it for me until I upgrade windows next week. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Jul 7, 2011 at 10:17 PM, Matthew Williams mai...@geodesicgrafx.com wrote: You would also think that moving the compiled .so file over from a known good install should work... but no dice there. Matthew Williams Geodesic GraFX www.geodesicgrafx.com/blog ~| 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:346152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF vs. Java Web Developer
I knew a guy years ago who started working from home, and in order to get himself in 'work' mode, he'd get dressed up in his suit and tie, have his breakfast as usual, pick up his briefcase, kiss his wife goodbye, walk out the back door, round the house to the front door, walk in, take his suit coat off and hang it on the hook inside the door, rant about the public transport system, and sit down at his desk. I never went to such lengths - I have always loved the 15-second commute to my office. But i have found i have developed the ability to completely shut out the whole outside world while I'm writing code. Many's the time my wife has said but I TOLD you about that only yesterday - how come you're claiming you didnt know My work usually begins about 10am and goes through till at least midnight most nights, often 3 or 4am. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Jun 24, 2011 at 7:06 PM, Russ Michaels r...@michaels.me.uk wrote: indeed working at the office makes no difference for some. I had one guy working for me once who was spending all his day chatting on ~| 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:345614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) Shameful
Interesting way to introduce your self in a forum where nearly everyone is making their living from what you call a comatose product. Still, since the demos all work for me and have done since they were put up on the web site, i guess that tells us volumes about your judgement. We can apply that assessment of your judgement to your claim that Coldfusion is 'comatose'. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, May 11, 2011 at 10:03 AM, Irvin Gomez ir...@pixel69.com wrote: The Adobe Coldfusion 9 demos do not work and have not worked for who knows how long. I guess that's the best way to show Adobe's commitment to its comatose product. http://www.adobe.com/products/coldfusion/demos/ ~| 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:344419 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Bless cfqueryparam - helped defend against a persistent hack attempt
Last night I watched as someone made a pretty determined attempt to attack one of my web sites. Thankfully I'd heeded good advice and used cfqueryparam on all the queries in that site and nothing they tried worked.They were submitting urls with parameters like : /index.cfm?pid=111825pgm=../../../../../../../../../../proc/self/environguestprogID=2 and many many variations.Like most of us, I get lots of hack attempts but this was more persistent than any I'd seen before. The site is still running happily now, after about 8 hours of this. I don't know why they persisted for that long with no result - I would have thought there were other targets they could go for if they're getting no result here. I'm pleased I bothered to do all those things at the time. When I was building the site (which is only a small hobby site), I remember saying to myself several times this is overkill there's no need for all this paranoia.But I'm glad now that I did all that. The techniques I've used that worked for me in this case were a combination of factors: [A] ALL queries - every single one of them - have cfqueryparam including the cf-sqltype parameter around any parameters sent to the database. [B] no feedback is given to the user about the nature of the error, only an error-handling page with the generic statement that 'there is an error - perhaps we're updating the database - check back soon' so they have no clue why their attempt failed. [C] an email is sent to me with the exception struct, cgi vars, etc so I can be aware of what they're doing - that way i can make sure I am covering all the vulnerabilities. I have a banning system on forms on this site, so that forms submitted with values that match certain parameters cause the ip address of that user to be banned from the site. I think perhaps I'll need to expand that to include URL variables now. I just wanted to pass on, that the warnings everyone hears about using cfqueryparam are valid, and we should never let a chink appear in our defences by listening to that voice in the back of your head, specially when you're under time pressure this is overkill there's no need for all this paranoia. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:344116 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bless cfqueryparam - helped defend against a persistent hack attempt
Just for the record, I use other techniques to protect my sites too but in this case, i was outlining what saved me in this case. Clearly there are a bazillion ways nasty people can do damage or exploit weaknesses in sites. In this case, I was grateful that I hadn't given in to the temptation to take the shortcut. The fields that the hacker was trying to inject into are integer fields. If I hadn't had the cfqueryparam set up for all variables to the query, AND the cf-sqltype=integer parameter as well, the injection might have got through the other defences I have set up. But the cfqueryparam stopped the text injection getting into the query, and the fact that i use error handling to trap errors, and give no feedback as to why the url failed, meant it was difficult for the hacker to figure out what he had to do to get around my defences. As it is, I got to watch over a period of 8 hours several hundred attempts to exploit my database and do damage, without having to lift a finger. I use a code writer to write most of my queries - at least the CRUD ones anyway, so it's no difficulty to ensure all the queries have cfqueryparam but at the time I wrote this site, I didnt have the code writer ready yet. I'm just glad i took the time back then to do the job properly and not cut corners. All I'm saying about this is:whenever you think it's not likely someone will try to hack your site, and anyway you're up against a deadline and cfqueryparam is a long-winded way to type out the simple parameter you want to use, THINK AGAIN!! it is DEFINITELY worth putting up all the defences you can, provided there isnt an undue price to pay in terms of performance. In fact, using cfqueryparam improves performance of queries- that site of mine is a database-driven site for a radio show, and it just lopes along during the show when load is higher. If anyone is curious about what site it is, I'll be happy to tell you and let you have a look for yourself, but I'm reluctant to post the url here since I've discussed so much about the security of the site. Just send me an email off line and i'll tell you. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Mon, May 2, 2011 at 11:49 PM, Dorioo dor...@gmail.com wrote: Ok. I'll respect your opinion. But for anyone new to CF that may read this, I don't believe there is a debate about using cfqueryparam. My impression is that the settled majority best practice is to use it blindly, use it everywhere rather than not use it, or use it sparingly, or not use it because of code aesthetic reasons. - Gabriel On Mon, May 2, 2011 at 9:04 AM, wrote: Are you implying that cfqueryparam _shouldn't_ be used for these reasons?? No, I'm just saying that there are better and more efficient ways of fighting attacks. I use cfqueryparam on some occasions, but not everywhere blindly. ~| 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:344126 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bless cfqueryparam - helped defend against a persistent hack attempt
As an interesting aside, the same ip address started trying to probe my mail server a few minutes ago, and my version of cfformprotect picked it up and added the ip address to the banned ips. Now that same ip address is banned from using any forms on any site I administer. Again, they get no feedback that they've been banned.Just seems like they've successfully submitted a form, but in fact their submission just gets dumped in the bitbucket and nothing gets done. it doesn't even get to the database. The reason for not letting them know they're banned is they can submit forms till the cows come home and nothing will happen. It means they will be less likely to try to find other holes in the defences to exploit. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:344127 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Bless cfqueryparam - helped defend against a persistent hack attempt
I dont know what the motivation is. All I've seen is repeated attempts to inject stuff into the database - never getting anywhere. So that means all the attempts so far are simply attempts to get at passwords or schema. I'm supposing once they get a look at the database they'll be able to figure out what's there that they want. If they're after credit card or user info I have bad news for them ... it's not a commercial site. There AREN'T any customer details because there are no customers LOL I get attempts on the email server every day. At least a hundred attempts a day over all the sites I manage. I dont see them now because I have automated the defences. Once an ip address is banned, they can submit hundreds of forms a minute and i wont see any of them because the first line of the form processing is to check if the user's ip address is banned, and only proceed further if it's not. I'm guessing the reason for these probes is to find mail servers that are open to exploitation, so they can send spams through them. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, May 3, 2011 at 1:09 AM, Gerald Guido gerald.gu...@gmail.com wrote: Mike, out of curiosity, what seems to be motivating these attacks? Malware injections? Hacker cred? Revenge or grudge? Or just to vandalize and do damage? It seems like a LOT of effort. I am also surprised that they are using the same IP for so long and not changing proxies. Thanx G! ~| 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:344130 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: I think I'm confused...
I use different domain names. I have www.mydomain.com for the live server site, and dev.mydomain for my local development sites Then in my hosts file, i have the line: 127.0.0.1 dev.mydomain for each client site i have. With apache, the local dev versions and remote server versions behave in an identical manner Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Feb 24, 2011 at 9:21 PM, Rick Faircloth r...@whitestonemedia.com wrote: Ok... thanks Mark and Eric We need a better solution available to developers to be able to switch between local and server DNS. Perhaps, a switch of some kind that could be inserted into a URL to tell a browser to use a local hosts file if that switch is present. http://local/www.xyz.com or http://l:www.xyz.com That would certainly be a *lot* easier than constantly editing that hosts file. But it's good to know that I can use a local DNS file that way! ~| 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:342551 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)
That wouldnt be a problem if you only did business in one country. But a LOT of web sites do business around the globe, when no matter what the time is, it's business hours in some part of the world. A VERY LARGE number of web sites of all sizes have no time down for maintenance, except on rare occasions. There are NO commercial sites in Australia that I know of that habitually shut down for anything more than a minute or two EVER. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Feb 24, 2011 at 1:45 AM, Michael Grant mgr...@modus.bz wrote: Really. Even banking sites come down for hours of maintenance. I suspect whatever your sites are, your 24/7 with no exceptions is a policy vs. a true necessity. Unless you are perhaps in the defence industry. Live code push? *shudders* On Wed, Feb 23, 2011 at 9:31 AM, Jane Williams janewilliam...@yahoo.co.ukwrote: Our sites run 24/7: we have no maintenance window that size. I bet I'm not the only one, either. ~| 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:342552 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)
I would agree with Robert.I was contracted to work on a site once that was doing just what you want - they were an application provider for their clients web sites. All the clients provided was a look and feel template, and they did the rest. At first it was easy. In fact they had one core file that did all the grunt work for the application, then a client wanted something a bit different. It was needed in a hurry, and wasnt much of a change, so they just put in a cfif clientid=345 and made the change in that core file.Then another change was needed. And another. And one more complex for another client. Before long the core file was strewn with all these cfif /cfelseif/cfelseif/cfelseif switches and the file had swollen to about 5 times its original size. It became almost impossible to maintain. Just finding the line to maintain became about 80% of the time required to do a simple little task. Eventually they had to re-write the whole application. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Feb 18, 2011 at 5:21 AM, Robert Harrison rob...@austin-williams.com wrote: From a technical standpoint you are on the right track... we do a similar thing in that we use a standard framework and deploy that to the sites we build, thus we use copies of the same codebase. It seems the approach you are taking is to really use JUST ONE codebase to run all the sites. Technically I can see the allure, and if this is for a company owned group of web sites and they are all similar this can work. However, if this is for sites you are deploying for clients, there are at least two places where that can really cause some problems. There are: 1. Your relationship with the client changes and the client wants to take the site and move. Now you are faced with either holding the client's site hostage or giving away your multi-site base code framework (possibly even to a competitor). Neither of those is an attractive option. 2. Also, assume one or more clients keeps coming back to you to make adjustments and additions. Now your code is getting more and more mucked up with custom-code exceptions. That's also not cool. Eventually that will make your framework really difficult to manage and upgrade. If this is an in-house thing and you know the sites won't be moved and you can control what's going in them somewhat, your approach is good. If you're going to do this for separate clients, you should probably think about building a framework you can copy, profile, and customize as needed. Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.c ~| 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:342403 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Change in ColdFusion management
I think there's a bit of the American NIH syndrome in evidence, which is well known in international US owned companies, specially in technology companies.This might come as a deep shock to some of you Americans, but there are some VERY smart people OUTSIDE the USA. I first saw this when I worked for Burroughs Corp in New Zealand in the early 1970s. We had some VERY clever programmers building some revolutionary software, that enabled us to sell mainframes worth millions against IBM, who were dominant in NZ as well as everywhere else at the time. We managed to corner the Government mainframe market back then. But even so, when it attracted the attention of the execs in the USA, they refused to believe that we could have developed software they were unable to do.The NIH syndrome struck. (Not Invented Here) The NZ subsidiary continued using the software to make sales, and it took the transfer of one of our senior guys to the USA for them to finally accept that we might have broken into a new market with something new. In the 1980s i was in another field, and we were routinely doing things my American counterparts had never thought of doing. When I would tell them what I was doing, they'd scoff, saying it if was possible, we'd be doing it. I think the NIH is in evidence here too. We've all had pretty dismal experiences with Indian, Phillipino and Indonesian call centres, but the software industry in India is VERY advanced. There's nothing inherently better about American programmers. Just because they're American doesn't make them better. There are a whole lot more factors that need to be taken into account than nationality. Americans build some rotten software too, you know, just like everyone else. CF7 and CF8 and CF9 were all splendid releases, each better than their predecessors. I see this change as a good thing. It makes good sense to have the Product manager in daily contact with the engineering and QA teams. A two way dialogue between Product management, and Engineering is essential to good development and innovation.I suspect Adam doesnt want to uproot his whole family and move to India. He doesnt say why he's not going to India so I'm guessing, but I dont think it makes any difference. They'll find a great PM to do the job in India, either an existing employee or someone hired for the job there. Either Indian or not, I dont think it makes any difference, provided the person doing the job has the qualities needed for a good Product Manager. This'll stun Sean, so I'll put it in caps in its own paragraph: I THINK THIS IS A GOOD MOVE BY ADOBE AND WILL BE GOOD FOR COLDFUSION. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Feb 15, 2011 at 12:39 PM, Sean Corfield seancorfi...@gmail.com wrote: On Mon, Feb 14, 2011 at 5:14 PM, Kelly webd...@gmail.com wrote: Right so Adobe isn't outsourcing. They have an office in India in which they probably hire Indian citizens. Yup, the Noida and Bangalore offices are staffed by a lot of locals and, indeed, some Americans who have decided they'd like to go live over there. Adobe has offices in quite a few countries, BTW... -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ ~| 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:342267 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Change in ColdFusion management
Actually Matt, I hope you read all of my post. I'm not taking the same stance as Michael Grant. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Feb 15, 2011 at 6:30 PM, Matt Quackenbush quackfu...@gmail.com wrote: Damn! Mike Kear and Michael Grant, both? In the same thread?!?!?! THE HEAVENS HAVE OPENED! :-) ~| 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:342269 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Change in ColdFusion management
Indeed, Matt.In fact my posting at all here is a minor miracle. I gave up on it quite some time ago when I was beaten about the head for expressing my opinion. I have this reputation as being a negative whiner. But I think it's uncalled for. I have been critical of Adobe's marketing here in Australia, and I'm not alone. In fact some of the people who slammed me on this list wrote me privately and said they agreed, but weren't prepared to say so publicly. And in frustration at a few tech issues related to installation of a version some years ago, I voiced (ok strongly voiced) an opinion about what I thought should have been in the installation instructions. I'll admit I should perhaps have been a bit more temperate in my language at the time. But apart from that, I have been positive to ColdFusion and their owners of the day.ColdFusion's been my living for around 15 years so I think that testifies to some commitment on my part, don't you think? Also, i think it qualifies me to have strong opinions about some aspects of the CFML product. Since I had a background in senior management, and running major and government accounts operations in several US based and Australian high tech companies before cutting out on my own, I think that qualifies me to express opinions about Adobe's organisation here. If I don't feel I know what I'm talking about, I keep my opinions to myself. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Feb 15, 2011 at 6:38 PM, Matt Quackenbush quackfu...@gmail.com wrote: I did read your entire post. And I did not say you were taking the same stance. But you both said positive things about Adobe. In the same thread. Miracles *do* happen! :-) ~| 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:342271 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SMS messages
I had to set up my first SMS application about 3 years ago, and I was busy looking for Australian SMS providers, when another colleague said to try an English company he'd been using. I too was skeptical about using an overseas company, but he assured me that it didnt matter. So we had a race.We sent SMS messages from my phone to his phone, using the normal 'two thumbs and press 'send' method, and using his web site to another phone. We pressed his enter key and my send button together, and time after time, the web site would win. He was sending a XML packet to the English SMS server, they were routing the message through any number of other providers around the world (depending on where the cheapest carriers were on this day) and eventually ending up beside us here on the next desk in Australia. It turns out that SMS providers treat SMS messages like a commodity. They buy in huge numbers, and make a margin by selling to you and me and our clients in smaller volumes. So the routing today will quite likely be different to how it was yesterday because of the pricing. Of course there are plenty of issues to check on when searching for a provider, but when it comes to SMS messaging, location doesnt matter for performance reasons. This is rather similar to knowing that it doesnt really matter much where you locate your web servers geographically, as long as they are provided with enough bandwidth and set up properly. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sat, Feb 12, 2011 at 12:23 PM, Chuka Anene anene.quor...@yahoo.com wrote: www.q-sms.org They have a very robust sms gateway. Thanks, I took a look at their pricing page and LOLed when I saw this... Q-sms offers the cheapest price in Nigeria and one of the most competitive globally... The Nigeria mention makes them immediately suspect in my mind, but I suppose there must be legitimate businesses there too, right? Hopefully they won't switch out my messages for offers to transfer millions into the recipients account... ha! Have you used them to send to mobile numbers on US carriers? A few places I've spoken to have said that we would need to apply for our own short code to send to US recipients, others have said we can send through theirs but only to certain carriers. It all seems to be more confusing than it should be. -Justin Well, believe it or not, i have used them to send messages to the U.S. Their delivery was instant. I thought the same way you do, but when i decided to use them, i got results and its cool to pay for results, these days. ~| 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:342161 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: favorite coldfusion host
As a small-scale hoster myself, I'm interested in what makes a hosting company good (or otherwise). I'm assuming that a few of the factors are: [A] site stays up more often than not - a LOT more often than not. Preferably 100% of the time [B] when there are problems, they're handled quickly and reliably, first time. [C] support people listen to what you say and act on that rather than a copperplate pre-defined answer/action. [D] Price is in the market, and there are several payment options. What else? (or am I wrong in thinking the above are important factors?) Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Jan 26, 2011 at 1:55 PM, Michael Firth mfsqlser...@gmail.com wrote: Ah I remember GoDaddy. What a horror story that was. I am disappointed to hear about CrystalTech because I actually had some good experiences with them.. I am surprised to hear about Hostmysite.com though. Thought they were always the gold standard per say even though I never tried them. ~| 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:341290 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: favorite coldfusion host
What sorts of questions do you expect a hosting company to be knowledgeable about and willing to help you with (aside from specific hosting questions of course)? DO you expect them to know how to use every tag and function? Syntax things? (I happen to be pretty experienced at that level, as a practicing developer of about 14 years experience) but I'm interested in what you expect of a hosting company. Or do you want the hosting company to be knowledgeable more about server issues - throughput, optimising code, finding bottlenecks? I know that where I'm not hosting a site I'm working on, few hosting support people will answer questions like my report is giving the wrong results - can you look at the query and tell me what I've done wrong. The answer to that one is thats probably in the manuals - look there or ask someone else.But if one of my clients calls me with a question like that, I'll help them.Sometimes even fix the code for them and send it to them, if I have the time available. I've had Perth's Fasthit do things like that for me too. And Kym Kovan is extremely knowledgeable and helpful with things like that too, if she has the time available. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:341317 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Detecting Mobile user agent - what methods work best?
I have to convert a client site to enable phone users to use the site and I was wondering what is the best method to detect the mobile user agent and switch the css sheet? As far as i have seen, there are a few ways to do this - which is best? (or maybe the way to put it is 'least bad') [A] a link at the top of the normal page, linking to a mobile version of the page. (yuk) [B] javascript detection (but there are thousands of mobile devices to detect. YUK ) [C] Use CSS @media handheld (but many cell phones don't support the handheld media type ) [D] server side detection using CGI.User_Agent (but there are so many user agents to detect) [E] screen resolution detection (but is that reliable?) Are there any other ways to do this? How do the rest of you handle serving pages to both computer screens and mobile device screens?? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:340547 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: How to make a CFSELECT Required
It only applies to CFFORMS. not quite the same thing.One choice with CFFORMS is flash forms, but there are also XML forms and HTML forms, all of which use the built-in cfforms tags, validation and jquery functionality. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Dec 1, 2010 at 2:35 AM, Leigh cfsearch...@yahoo.com wrote: to set the value of the default option (the pre-selected option which user has to change) to a signe space string I thought that only applied to flash forms? -Leigh ~| 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:339659 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Free ColdFusion Hosting
I'm not sure what your problem is with hosting in another country. Specially not if the other country is the USA. It's not going anywhere. I've been hosting sites in the USA since 1996 and never once had a problem related to the physical location. At first i expected to have performance problems because of the distance between the server and the users, but those fears proved to be groundless. There is plenty of bandwidth carrying data around the world, and quite frankly i dont think it matters where your server is located, unless you have pretty significant amounts of traffic. There ARE issues you need to think about with any hosting company, but geographic location isn't one of them, if the company is located in one of the G20 countries. Incidentally, as a sidebar, I received a UCE last month from a Russian web host, offering to host any project I might wish to host, including (and i was astonished to see this spelled out): credit card fraud, (yes, they used the word fraud!) personal details collection (meaning phishing I assume) music file sharing adult files porn movies child pornography (yes! They actually invited me to host child porn! ) I was flabbergasted that they were so open and blatant about it. Needless to say I wasnt interested in what they have to offer, and I referred their offer to the Australian Federal Police. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Nov 25, 2010 at 7:23 AM, Paul Alkema paulalkemadesi...@gmail.com wrote: Matthew, If it was me, I wouldn't poo-poo it just because it's hosted out of the country. If it's free, I wouldn't expect GREAT honest but it's free right!? I would think as long as your not looking to put anything that you want to keep secure on it IE; credit card data, SSN's, other people's passwords ect, that you'd be fine. If it was me I would just sign up, pay the £1.00 setup fee (don't know if you saw that or not) and if they charge you more than £1.00 than it's credit card fraud, file a dispute with your cc company which is really easy and you get your money back. If you do, do it, make sure you share your experience with everyone so we can see how it worked out for you. ;) Paul Alkema http://paulalkema.co ~| 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:339521 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Should a getMemento method return the results of getters if they exist?
About the only use for getMemento() method I have is as a kind of CFDUMP of the current data contained within an object. As a debugging device to check that the values of the various parameters actually are what i think they should be. In that case, the getMemento() method should always return the getters, otherwise all you ever see is the default values, not the current values. Otherwise, I only ever use a getter or two in a process, or pass an object around, as Sean said. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Nov 17, 2010 at 12:57 PM, Sean Corfield seancorfi...@gmail.com wrote: On Sun, Nov 14, 2010 at 11:03 AM, Dave Merrill enigm...@gmail.com wrote: In the cfproperty-oriented world, where properties get dumped into the variables scope along with your methods and anything else there, many folks including me have written getMemento methods to return a struct with the values of the object's declared properties, only. Why? If you wanted a struct, why use an object in the first place. If you wanted an object, why provide a method that un-encapsulates the data? -- ~| 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:339302 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
I get round this issue in my CMS by having a fileName field. For security reasons, this field only appears in forms offered to validated users who have permission to upload such files. (not many!).They can upload the file, using the uploader on the 'content' page, then instead of putting content in the CKEditor, they put the name of the CFM file in that 'filename' field. When I produce the page, the logic is like this: cfif len(content.fileName) GT '0' cfinclude template=/includes/clientfiles/#content.filename#/cfelse , yada yada yada This allows me to have some pages produced programmatically, while the majority are simple reads from the database and then rendered. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Oct 21, 2010 at 1:22 PM, Torrent Girl moniqueb...@gmail.com wrote: I spoke too soonit's not working hmmm...maybe I'll add the function before i enter the text into the DB ~| 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:338416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Fckeditor html vs xhtml
Yes. Upgrade to the latest version of FCKEditor, or even to the new CKEditor. IF you are using the built-in editor in CF8, you will find there's a FCKEditor folder in the forms files (in CF9 it's at \CFIDE\scripts\ajax\FCKeditor and from memory I think that's where it is in CF8 too). You can upgrade your version by unzipping the FCKEditor download into that folder, making sure you have the newer versions of the files in the same places. The latest versions of the product produce XHTML as default, and you can edit the configuration if you want to use the older HTML Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Oct 19, 2010 at 1:45 PM, Terry Troxel te...@it-werks.com wrote: Is there anyway to configure Fckditor so when it writes richtext in CF8 it switches between shorttag and longtag? Ie: br br / foe example. Terry ~| 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:338417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IIS 7 401.2 Error for cftree (long post with error info)
I had this same problem in my shared hosting. The Sysadmin didnt really understand the coldfusion set up that well, and wouldnt allow sites access to the CFIDE folder (actually a mapping on this server). So i copied the relevant parts of the CFIDE folder into the web site just under the root. And that fixed it. Took up extra disk space but that's the only implication that i've found yet.just dont do this with the CFADMINISTATOR folders!!! Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sat, Sep 25, 2010 at 2:29 AM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Do you mean I have to turn on both NTLM and Anonymous for these items? For testing purposes I've also granted EVERYONE read/execute to all of these folders. I set All of CFIDE to anony and locked down Administrator and adminapi. Still no love. :( ~| 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:337504 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
Lots of people have suggested similar things - cause an error when running a query on the access database, which will break the lock. Maureen also suggested deleting the ldb file. That's the file that creates the lock and it cant be deleted.It gets deleted when the system lets go of the This is old news, I'm afraid. It dates back to CF5. Since the MX era, that no longer works. However I have found that in CF9 the lock remains on the access database only as long as the datasource is being used. When the process using the database is completed, the lock is removed automatically.The reason I never noticed this before is that I have been trying to open a zip file, copy the file to the \db folder where it can be used as a datasource, update it, then put the access database file back into the zip file and delete the file i was working on. I was trying to do it all in the same page. Now it seems I have to put the process into two separate steps. I have to allow ColdFusion to disconnect from the datasource first, THEN attempt to delete the mdb file.I have been experimenting with CFThread as a way of accomplishing this but its a bit obscure to me yet. More study required.Or alternatively, two separate .cfm files completely, with the second one being triggered separately to the first. If anyone has any suggestions as to how i should do this, I'd be most grateful. Currently I'm thinking one of the following : [A] A single .cfm file calling separate threads. This has the advantage of the whole process in a single file, but will only work if the datasource is released after that thread completes processing. [B] A single .cfm file, calling the actions that require the database in a custom tag. But again, that will only work if the datasource is released after the tag completes processing. [C] two separate .cfm files, and one triggered after the first completes processing. Perhaps by a third .cfm file controlling both of the others. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, Sep 19, 2010 at 2:52 AM, Kris Jones kris.jon...@verizon.net wrote: It's not elegant, but I've found that throwing an error on the datasource works for releasing them. Try a query against the dsn for a table that doesn't exist. Cheers, Kris Try deleting the .ldb file. On Wed, Sep 15, 2010 at 8:58 AM, Mike Kear afpwebwo...@gmail.com wrote: I have to make an Access database containing updated data from my SQLServer database, which can be downloaded by my users by FTP. I can make the Access database a coldfusion datasource, and fill it up with the data I want, but I need to release it from the lock ColdFusion puts on it. Does anyone have a technique for releasing that lock nowdays? (I'm using CF9 Enter ~| 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:337219 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
The solution: (was: Re: Is there a way to force lock release on Access database? (CF9) )
That would work too, Dave. I think!The second page would contain the delete functionality? Seems to make sense. The problem is to force ColdFusion to let go of the datasource completely before attempting to delete the MDB file. I have found that using CFThread wont work, because ColdFusion still hangs on to the datasource even after the .cfthread accessing it has completed. Later: ... I tried Dave Watts' suggestion of a CFLOCATION to a second page, and it works on my development environment.PROGRESS! Thank you Dave. So the lesson to learn: [A] ColdFusion 9 retains a lock on an Access database for the entire time a page that requires it is active. Once the page finishes processing, the lock is automatically released on the access database. PROVISO: you have to have set up the datasouce in the CFAdministrator as -- Maintain connections across client requests. set to Off (unchecked). I have not been doing any work on this with that option On, so I can only assume it wont work with that option set. [B] causing an error, by running a query on a non-existent table wont release the lock on the database post-CF5. That was the advice way back in the old days, but now it wont work. In fact it'll be counter-productive because it will cause the connection to the dsn to persist even longer and therefore retain the lock longer. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Mon, Sep 20, 2010 at 1:40 PM, Dave Watts dwa...@figleaf.com wrote: Why not have one page that redirects to another using CFLOCATION? Dave Watts, CTO, Fig Leaf Software ~| 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:337222 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is there a way to force lock release on Access database? (CF9)
I have to make an Access database containing updated data from my SQLServer database, which can be downloaded by my users by FTP.I can make the Access database a coldfusion datasource, and fill it up with the data I want, but I need to release it from the lock ColdFusion puts on it. Does anyone have a technique for releasing that lock nowdays? (I'm using CF9 Enterprise). IN CF5, which is the last time i used Access with ColdFusion, it was a simple case of doing an invalid query but that doesnt work in MX days. There was a non-documented function once as well ... CFusion_DBConnections_Flush( ) ... but that's not valid in CF9. Has anyone found a way to break that connection programmatically in CF9? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:337075 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
This has to happen automatically because the process is initiated by an event when a manager logs on and maintains a record in the product file. When that happens, it causes the system to generate a new database for the users around the country to download when they next log on.So i need to connect and disconnect from the access database programmatically. Are you meaning when I set the DSN up in the first place, i uncheck the Maintain Database Connections checkbox and that should do the trick for future connects/disconnects?? Our control panel doesnt set access DSNs up that way but i can get my sysadmin to set the DSNs up manually through the administration interface instead though. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Sep 16, 2010 at 2:31 AM, Rick Root rick.r...@gmail.com wrote: On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337081 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
Yes, that's what i used to do too, Will. But that was in the CF5 days. With MX that stopped doing the trick. Cheers Mike Kear On Thu, Sep 16, 2010 at 2:39 AM, Will Swain w...@hothorse.com wrote: We used to have to create a 'bad' connection by querying a non-existent table or something. That would break the connection and release the .ldb. This was years ago though. Will -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: 15 September 2010 17:31 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337084 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is there a way to force lock release on Access database? (CF9)
It's ok. It's been a while for me too. I havent touched Access in any way for any reason since way back in the mid 90s. Now i have to use it because of a legacy of LOTS of point of sale terminals that all use it for importing updates into their systems. My hope is that we'll get rid of this application pretty soon. But in the mean time I'm stuck with it. Cheers Mike Kear On Thu, Sep 16, 2010 at 3:30 AM, Will Swain w...@hothorse.com wrote: Sorry - like I said, it's been a while. -Original Message- From: Mike Kear [mailto:afpwebwo...@gmail.com] Sent: 15 September 2010 18:21 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) Yes, that's what i used to do too, Will. But that was in the CF5 days. With MX that stopped doing the trick. Cheers Mike Kear On Thu, Sep 16, 2010 at 2:39 AM, Will Swain w...@hothorse.com wrote: We used to have to create a 'bad' connection by querying a non-existent table or something. That would break the connection and release the .ldb. This was years ago though. Will -Original Message- From: Rick Root [mailto:rick.r...@gmail.com] Sent: 15 September 2010 17:31 To: cf-talk Subject: Re: Is there a way to force lock release on Access database? (CF9) On Wed, Sep 15, 2010 at 12:27 PM, Russ Michaels r...@michaels.me.uk wrote: unchecking the maintain database connections in the DSN may work. WE used to do this back in the 90s when I was still using Access databases for web sites :) Rick ~| 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:337087 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) CKFinder - anyone know about how licensing works?
Dan, they've had a heavy workload recently, and not enough people to respond to things. Add to that, some other people taking annual leave and they're getting behind in their responses. I got a response from Wiktor Walc, who heads up the support function at CKFinder, and he's given me a temporary workaround for my problem, and he's working with me on developing a long term fix. I'll send you his email address off list. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Sep 15, 2010 at 10:41 AM, Dan O'Keefe dan.oke...@gmail.com wrote: I have a client having the same issue as far as contacting Fred regarding a new purchase, and no response. Dan On Wed, Aug 25, 2010 at 11:45 PM, Mike Kear afpwebwo...@gmail.com wrote: ~| 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:337038 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: (ot) CKFinder - anyone know about how licensing works?
G'day Gerald, I think you might be right. There was nothing that I saw telling me that BEFORE i made the sale, and now I cant get anyone at CKFinder to answer my emails. I have some issues connecting it up where the documentation is sparse to say the least, and after 4 days they wont answer my email asking them to confirm what you said. I need to see if they're willing to change the licence details to allow me to put the CKFinder where I need it, and I need to have another tech question answered. But they haven't responded in any way after 3 attempts to contact them. So perhaps my options are running out and I might well end up doing what I usually do - making my own. I could call it MKFinder. The only bit I'm not sure how to do right now is integrating with FCKEditor or CKEditor and passing the image details back to the editor. The rest I can do with ColdFusion. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, Aug 25, 2010 at 11:38 PM, Gerald Guido gerald.gu...@gmail.com wrote: install it into a subdomain * I think you are SOL** :( * *The *license states*: **Web Site*: you may integrate CKFinder in one web site (the Web Site). The Web Site URL must be specified at the moment of the purchase. The license will not be valid for sub-domains of the specified Web Site URL. *** *http://ckfinder.com/license G! ~| 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:336563 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) CKFinder - anyone know about how licensing works?
I'm sorry this is off-topic here, but I've written to Fred and haven't had an answer. I bought a copy of CKFinder the other day and I'm installing it into my CMS on the domain alacastinaswh.com.au only it's still showing as demo version even after i added the licence details to the config.cfm file as per the instructions. I have written to Fred, but after a couple of days I havent had an answer yet. Does anyone know if i buy it for the domain alacastinaswh.com.au, then install it into a subdomain (e.g. http://cms.alacastinaswh.com.au) will that invalidate the licence and show on the CKFinder as a demo version? I guess what I'm asking is whether i need to go back to Fred to get a variation in the licence, or whether i need to look for something else I might have wrong. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:336498 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
I think you might be right, David, except that there is no right click menu on that popup. That's the problem. I tried doing that about 8 weeks ago when I first encountered the problem. But based on Kym Kovan's advice that they messed around with this same thing for ages and ages until they decided it wasnt worth the effort,and based on the fact that half a dozen requests to Rick Root for help and getting no response at all, not even 'i'm not interested in supporting you', tells me i should find something else to use instead. Dump CFFM is my recommendation. My current plan is to forget about this whole CFFM thing since Rick isnt helping and use CFFinder or maybe have a go at writing my own. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Aug 19, 2010 at 10:00 PM, David McGraw david.mcg...@gmail.com wrote: You can right click the alert pop up, then click on select all, copy the text and paste it into dreamweaver or something else and then let that render it, it will show you what it is. My best guess is that you have some kind of authneitcation scheme going on that the upload script isn't part of, so your getting a redirected login page, or something like that. You have to ensure you do not have some kind of global application wide handlers interfering with your FCKEditor code. You may also want to review your fckconfig.js file and ensure your paths are correct... if you have some incorrect paths, then it would return the HTML of a page cannot be found page, or your custom site wide error page. I have a lot of experience with FCKEditor, if you can select all and get that HTML of the JS pop up and actually understand what it's returning, I bet you will have an Ah ha! moment, and realize what's happening. Thanks, David McGraw Oyova Software, LLC http://www.oyova.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:336391 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Licensing on CKEditor - included?
G'day Den, Actually I was thinking of updating to the newest CKEditor from my current favourite FCKEditor and using the matching CKFinder. You're right, all i actually NEED right now is a replacement for CFFM, so the CKFinder would do that, but I thought there would probably be some advantages to keeping up to date with developments on both parts of that solution. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Aug 20, 2010 at 5:08 AM, denstar valliants...@gmail.com wrote: CKEditor is open source (or dual-tri licensed or some such, for folks that need support). You're going after the file manager plugin that isn't open source, aren't you? =-) :Den - ~| 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:336430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
RICK!! Thank you for your response. I am most grateful. I thought
we'd lost you.
However unless the flash/cookie authentication thing is quick for me
to fix, I'm still going to have to move on to another product I'm
afraid. Your CFFM is a super application, except for the fact that
the uploader has this authentication issue.
By the sound of it, quite a few people have experienced this same
issue, so if you want to keep moving it along, you will probably need
to spend some time working out a solution for this sooner or later.
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
On Fri, Aug 20, 2010 at 1:56 AM, Tony Bentley
cascadefreehee...@gmail.com wrote:
you can add this code to the cffm.js:
function createErrorWin(msg){
var el = $(document.createElement(div));
$(el).html(msg);
$(el).css(zIndex,999);
$(body).append(el);
}
and then do a find and replace for all alerts; find:alert
replace:createErrorWin
If an error pops up, it should show up as a div (which is better IMHO). You
could probably add a link in there that deletes the div but this should get
you going. I didn't fix your problem but maybe you just need a better
debugging handler and use firebug/firefox or chrome and check out the console
as others have mentioned.
~|
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:336431
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
No problem. You dont NEED to do anything. I wasn't trying to tell you what to do. Just saying. If you read what i wrote fully, you'd have seen i put a big IF in the beginning of that sentence.I wrote: ...if you want to keep moving it along, you will probably need to spend some time working out a solution for this sooner or later. You can let it languish for all I care. It was your project, something that obviously meant something to you in the first place, because you were the one that started it all off. You do (or dont do) whatever you like. It's no skin off my nose. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Aug 20, 2010 at 9:22 AM, Rick Root rick.r...@gmail.com wrote: On Thu, Aug 19, 2010 at 6:43 PM, Mike Kear afpwebwo...@gmail.com wrote: By the sound of it, quite a few people have experienced this same issue, so if you want to keep moving it along, you will probably need to spend some time working out a solution for this sooner or later. Not to be rude, but I don't *NEED* To do anything. When I *NEED* to, I will. This is an open source project, so if someone wants to contribute a patch that either fixes the issue by modifying uploadify or replaces it with a different file upload mechanism, that's great. I'm not actually using CFFM 1.3x in any of my own apps. CFFM 1.22 works pretty nicely still, so you can always use that. No uploadify plugin. R ~| 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:336434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Alternatives to CFFM?
Are there any good alternatives to CFFM? I have had a client's anger at me for over a month now, because we can't get the upload to work. I've written to Rick Root five times, and had no response, so i have to assume he's walked away from CFFM now. That means i have to find some alternative to it.The problem we've got is we get an error message that can't be read whenever we try to upload. I asked Rick to help me figure out what might be causing the problem, but he doesnt answer my emails. So what i'm looking for is a way to upload image files from FCKEditor, and manage the image directories. If CFFM worked as advertised, it would be perfect, but since RIck's walked away from it I'm stuck now. Any suggestions where I should go now? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:336362 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
Thanks John, I dont think its a CF error, thats the problem.A narrow very tall popup appears (taller than the window) with a whole lot of code in it, generated by javascript I assume, but since it's in a popup, you cant cut and paste any of the content into a code editor, and its so large you cant see all of it, so it never renders properly. SO I don't know what the error is, or what's causing it, only what point in the process it appears. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Aug 19, 2010 at 9:04 AM, John M Bliss bliss.j...@gmail.com wrote: The problem we've got is we get an error message that can't be read whenever we try to upload. Have you checked the CF logs for the error? On Wed, Aug 18, 2010 at 5:46 PM, Mike Kear afpwebwo...@gmail.com wrote: ~| 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:336364 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
Yes it's not browser specific. i could post a screen shot of the error message somewhere but i dont think I can put it on this list can i? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Aug 19, 2010 at 9:27 AM, Michael Grant mgr...@modus.bz wrote: *Is this behaviour the same across all browsers?* * * ~| 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:336366 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
Here are two screen shots that illustrate what I'm facing every time i try to upload using CFFM: http://picpaste.com/alacastina01.jpg is a general image of the screen when the error occurs, and http://picpaste.com/alacastina02.jpg shows a closer image of the error popup. Since this doesnt allow cut and paste, i can never see the rest of the message, so i can never know what this error is caused by. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Aug 19, 2010 at 10:32 AM, Mike Kear afpwebwo...@gmail.com wrote: Yes it's not browser specific. i could post a screen shot of the error message somewhere but i dont think I can put it on this list can i? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Aug 19, 2010 at 9:27 AM, Michael Grant mgr...@modus.bz wrote: *Is this behaviour the same across all browsers?* * * -- ~| 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:336368 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
No, thats the problem. There is no right click menu at all. As you see on the screen shot at http://picpaste.com/alacastina02.jpg there's no way to see what the error is, because the code that's displayed on the popup is only the header part of the error page. The actual error is in the [ CDATA part that's off the side of the screen. The only option offered is to click OK. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Aug 19, 2010 at 10:42 AM, Maureen mamamaur...@gmail.com wrote: Can you right click on the popup and do a view source, or show it in firebug? On Wed, Aug 18, 2010 at 5:39 PM, Mike Kear afpwebwo...@gmail.com wrote: Here are two screen shots that illustrate what I'm facing every time i try to upload using CFFM: http://picpaste.com/alacastina01.jpg is a general image of the screen when the error occurs, and http://picpaste.com/alacastina02.jpg shows a closer image of the error popup. Since this doesnt allow cut and paste, i can never see the rest of the message, so i can never know what this error is caused by. ~| 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:336372 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
Yes it's in the same directory. The site is a content management system, and requires a login. Perhaps i need to add a login to the CFFM or change my logged in test to exclude CFFM somehow. Good idea James, thanks for the suggestion. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Aug 19, 2010 at 10:44 AM, James Holmes james.hol...@gmail.com wrote: The Please Log In in the title of the HTML that's coming back in that popup suggests your upload script isn't authenticating properly. Is it under the same Application.cfc/cfm as the rest of your app? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ ~| 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:336373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Alternatives to CFFM?
Thanks Kym.Your experience is worrying for me - I LIKE the new version with its neat ajax image calls to give a little thumbnail of each image etc. But if you guys gave up on it, I had better learn from your experience. That's been a policy that's never failed me before. If'n you guys cant get it going within a reasonable time, then I need to seriously think about whether I should put more time in on it too. I guess that's why Rick doesn't answer emails about it. Sigh. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Thu, Aug 19, 2010 at 12:47 PM, Kym Kovan dev-li...@mbcomms.net.au wrote: On 19/08/2010 08:46, Mike Kear wrote: Are there any good alternatives to CFFM? ... That means i have to find some alternative to it. The problem we've got is we get an error message that can't be read whenever we try to upload. I asked Rick to help me figure out what might be causing the problem, but he doesnt answer my emails. We had exactly the same issue when we upgraded CFFM in our CMS to the latest version of CFFM with the flash tools. After much messing around and wasted time we decided it was a path issue in the code that we could not find so we back-pedalled to the last, non-flash version which works fine with both CKeditor or TinyMCE. -- Yours, Kym Kovan mbcomms.net.au ~| 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:336383 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Licensing on CKEditor - included?
Is this true? - we can replace the existing FCKEditor in our ColdFusion with the updates to CKEditor because it's already licensed to Adobe as part of ColdFusion? (And therefore since we've paid for a licence for ColdFusion that in turn has paid Fred for a licence for CKEditor). True or not? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:336385 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFML broadcasting app
As I understand it, the blacklisting services look NOT for large volumes of mail, but substantial and/or sudden changes. I had a spammer get through my defences once and set up hosting with me. Immediately he started sending volumes of email. Within 24 hours our ip addresses were blacklisted, and the advice I got when i tried to get them unblacklisted again was that there was a sudden increase in mail and that's what triggered the blacklisting. I have other clients I host who send more emails than that person did in the short time before we shut him down again, and there has never been a suggestion of blacklisting them. I'm assuming that's because they have built up the volume over a period of time so their pattern hasn't changed dramatically. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Sun, Aug 8, 2010 at 4:37 AM, UXB Internet denn...@uxbinternet.comwrote: This is much bigger than a CFML issue... I could, and for the unfortunate bystanders, have talked for hours about the problem of email. We are a website design and Hosting company and yet my biggest expenditure in time and resources goes to email and email issues. - oops I started pontificating again. The real trick is to have granular control of your sending email server. We have a SMTP server specifically for the sending process. Our main POP/SMTP email server like most today can easily handle more than 512 simultaneous SMTP threads however the sending server, the one used to send out notifications and newsletters, is set to 32 outbound threads and 512 inbound threads. This allows CF and our listserver to send email to the sending relay as fast as it can but throttles the actual outbound delivery to a manageable level so as not to overwhelm other services like AOL, which grey-list automatically, yahoo or Gmail. It takes longer to deliver but it does get delivered and we stay off block lists. You just have to remember to be polite, which sometimes the fast technology forgets to do. Dennis Powers UXB Internet - A Website Design Hosting Company P.O. Box 6028 Wolcott, CT 06716 203-879-2844 http://www.uxbinternet.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:336098 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Suppressing whitespace from CFCs
I believe the following will work --- cffunction name=functionname output=true cfargument name=whatever cfset var whatever = arguments.whatever / Logic stuff in here. cfsavecontent variable=outputstuffhtmlhead/head etc . your ourput stuff goes here./cfsavecontent cfreturn outputstuff / /cffunction Then in your calling page you have : cfset outputgenerator = createobject(component, outputgenerator).init() / cfset myoutput = outputgenerator.functionname( whatever ) / cfoutput#myoutput#/cfoutput This way you're not outputting code directly from the CFC, only generating a string of output tags, which you're going to use in the calling page. it's a couple of years since i've done it, but if my memory is serving me right, that's how i solved the problem for a complex XML output cfc application, where white space was really causing problems. You only have to limit the white space in your CFC between the CFSAVECONTENT tags. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Aug 6, 2010 at 1:10 AM, Robert Harrison rob...@austin-williams.comwrote: Apparently you cannot use CFSILENT or CFSETTING inside a function at all. Using either of these tags in the function give me the following error: The start tag must have a matching end tag. An explicit end tag can be provided by adding /cffunction. If the body of the tag is empty, you can use the shortcut cffunction .../ Robert B. Harrison Director of Interactive Services Austin Williams 125 Kennedy Drive, Suite 100 Hauppauge NY 11788 P : 631.231.6600 Ext. 119 F : 631.434.7022 http://www.austin-williams.com Great advertising can't be either/or. It must be . Plug in to our blog: AW Unplugged http://www.austin-williams.com/unplugged __ Information from ESET Smart Security, version of virus signature database 5343 (20100805) __ The message was checked by ESET Smart Security. http://www.eset.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:336025 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Suppressing whitespace from CFCs
There are reasons to use CFCs to create output.For example i had an application that required an output of a quite large XML file made up of maybe 50 fragments of XML, out of a possible 300 or so specially formatted fragments.Each occasion the XML was created, the logic CFC would call the appropriate functions in the output cfc, which would produce the relevant fragment of that XML packet, then the logic CFC would stitch them all together into one XML packet and return it to the calling page. In XML, if you have white space in the wrong place, it can make the whole XML packet invalid, so this was a serious issue for the viability of the whole application. And as i posted in my previous email in this thread, it worked just fine, producing output from the CFC with no extra white space. But you can't just treat it as a normal cfml page inside a cfc. You have to create a variable, containing the bit of html you want to output, then pass that back to the calling page. Otherwise, as you've found, you'll get all kinds of extra white space. As it happened, my XML packets ended up having no spaces AT ALL in them, except for intentional spaces between words in the values of the fields. So i know you can do what you are seeking to do. Another application for CFCs producing output is my CF9 code generator. I have a CFC that examines a database table, then calls a whole series of cfc methods, each of which produces a fragment of code, and the logic CFC stitches them together and writes them out to a file (or files). Kind of like my own form of ORM, that i wrote before i had ever heard of the term ORM. You can do what you want, but as others have said I'd advise putting the logic in one CFC, and the actual output generation in another, just so you organise your code. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Aug 6, 2010 at 2:16 AM, Sean Corfield seancorfi...@gmail.comwrote: On Thu, Aug 5, 2010 at 7:13 AM, Robert Harrison rob...@austin-williams.com wrote: I've moved output function into CFC's; thus I'm using output=true. Only problem is the CFC is outputting whitespace where all the logic is now. How can I suppress the white space in an output CFC? Write the CFC entirely in cfscript (which generates no spurious whitespace) and use writeOutput() around the stuff you want to output. But, as others have noted, really the 'best practice' is CFCs for logic, CFM pages for output - mainly since you don't want to be mixing HTML (display) in with your logic. -- Sean A Corfield -- (904) 302-SEAN Railo Technologies, Inc. -- http://getrailo.com/ An Architect's View -- http://corfield.org/ If you're not annoying somebody, you're not really alive. -- Margaret Atwood ~| 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:336048 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need a west coast (US) based CF host
I would have thought most hosting companies would have their servers set to UTC ( or Greenwich Mean Time) . Is that not true? I have servers in California, but ours are on UTC so we can move them from place to place if we choose and it makes no difference to the code. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Jul 30, 2010 at 12:02 PM, Charlie Griefer charlie.grie...@gmail.com wrote: I -think- it's 2k8, but based on my discussion with the previous developer, I'm not sure database tweaks are going to do it. I've pitched Andy's trigger idea to the client. Still waiting to hear back... On Thu, Jul 29, 2010 at 6:55 PM, Maureen mamamaur...@gmail.com wrote: Which version of SQL Server, because timezone data is handled differently between 2005 and 2008, and if it is 2008 you could likely fix this issue with some database tweeks. On Thu, Jul 29, 2010 at 12:29 PM, Charlie Griefer charlie.grie...@gmail.com wrote: Hey Scott: Hmm... not sure that the current site will run under Railo. Also, their current database is SQL Server (I probably should have mentioned that). Looks like Alurium is exclusively Railo/mySQL ( ~| 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:335878 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Need a west coast (US) based CF host [spamtrap heur]
Well i do something similar in a way.I never use now() in any of my code. Instead in the application.cfc i create a variable called request.austime (for Australian Time) and throughout my code whenever i need a time stamp or a date or i might otherwise use now(), i use request.austime instead. Then, depending on the environment, in Application.cfc I create request.austime in different ways but it has no effect on the rest of the code.In my development machine, I use cfset request.austime = now() / because the system clock is set to my local time zone. On my production machine, which is set to UTC, i use the timezone.cfc to convert UTC to Sydney time (or for clients who want their sites to appear based in other timezones I'll use the same cfc to set the variable request.austime to that time zone.) In other words, that whole timezone/daylight savings thing is handled in one, maybe two lines of code in application.cfc and the rest of the application doesnt need to know or care what timezone the server is sitting in. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, Jul 30, 2010 at 12:57 PM, Paul Hastings p...@sustainablegis.comwrote: On 7/30/2010 2:09 AM, Charlie Griefer wrote: funds for VPS, unfortunately) on a server with the clock set to PST. ah just think how simpler our world would be w/a setTimezone() function ;-) ~| 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:335882 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Is Rick Root OK? Has anyone contacted him lately?
I sent a question to Rick Root a week ago about his excellent CFFM and i haven't heard back from him.That's most unlike Rick - usually he's responding almost before I've finished the question. I'm getting a bit concerned. Is he ok? Has anyone had contact from him recently? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:335453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Is Rick Root OK? Has anyone contacted him lately?
Ah yes of course! Thanks Mike. It's mid winter here, so i had forgotten about that aspect. Thanks. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Mon, Jul 19, 2010 at 5:50 AM, Mike Chabot mcha...@gmail.com wrote: At this time of year the assumption would be that he is on vacation. This is especially true for someone who works for a university and likely gets an above-average amount of paid vacation time. -Mike Chabot ~| 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:335458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Looking for a CF Recipe script!
Remember when this thread was actually a request for information?? I suspect that Ennio was looking for a modern-day equivalent of the old DOS-based MealMaster application. That dates back to the old before-internet BBS days.MealMaster would keep track of recipes, and ingredients, so you could keep all your recipes in it, but also you could enter some ingredients and it would give you a list of recipes you could make with those ingredients. Also, if you mapped out a menu, it would compile a shopping list for you. The short answer, Ennio is no, I would be very surprised if there is such a thing available, but it would make a really good learning opportunity for you. If you made such an application, you'd learn about parsing text files, storing and manipulating data, compiling menus (in manufacturing they're called Bill of Materials). Maybe you could even turn it into a money-making application for yourself if you went ahead and built it. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:335286 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can CF create/open SPD database files?
I have a client whose stores are uploading zipped .spd database files each night, and wants me to have coldfusion open these files, read in the data then process it all .Before i go asking him to change his systems in his stores, I want to find out if ColdFusion can open these files. Also, can ColdFusion create them for passing data back the other way? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:335287 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CFMAIL isn't working at all
I find CFMAIL issues amongst the most difficult to debug, because you get such vague or even non-existent indications of problems.Often the only indication you get that your CFMAIL is wrong, is you dont receive any email. [A] I would check that you have all the required settings for your mail server. For example, in our system, the username is the full complete email address, not just the part to the left of the @. [B] Check that you have the server= attribute and the username= and password= correct in the CFMAIL tag. Our system blocks any mail coming from anywhere that doesnt have the correct authentication to prevent spammers exploiting our mail server. Yours may well be the same. Your support people at eworks.in will be able to tell you this. [C] check that you have no syntax errors in the message. If your message is built using coldfusion, and you have an error in your code there, you'll not get an error message, you'll just get nothing at all. I would verify that you can indeed send emails using CFMAIL by sending one with a very simple content like TEST to eliminate this as a possible culprit. [D] check that your isp doesnt block some ports. My isp (iinet.net.au) for example, blocks port 25 by default to help reduce hacking, but can be enabled if you need it (we do in order to pass mail through to the remote mail server). In this case, I think you're not making a connection to the server, but once you get through that obstacle, the others may well show themselves too. I think the most likely is [D] above. Hope this helps. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Tue, Jul 6, 2010 at 2:19 PM, Sagar Gupta jupi...@eworks.in wrote: Hello everyone, I'm trying to send emails using the CFMAIL tag. I know how it is done and have tried every possible way to figure out why it isn't working. Coldfusion 9 64-bit is running on a CentOS 5.4 x64 box with Apache 64-bit installed. It is neither sending email through smtp.gmail.com (Google App account) nor with localhost (sendmail server.) I've tried following way so far: 1. Tried to verify my mail server connections (both to Gmail and sendmail) using the Coldfusion administrator, however, always get following error: Connection Verification Failed! 2. Enabled mail log and have set the log level to Debug. Still don't see any error in the mail.log file. It does keep updating with spool related information but no error or details about connection to the mail server. 3. I know correct port and SSL settings required to connect to the Gmail smtp server. 4. Coldfusion is running as user cfusion in developer mode. 5. This is a new installation on a fresh CentOS box at a client's site and I've tried reinstalling Coldfusion a couple of times already. 6. Coldfusion is connected properly with Apache version 2.2_15. 7. I tried sending email using sendmail using the command-line and it went through. 8. I also tried to send email using a PHP script and it works, however, I can't rely on it as it deliver email very slow and I need to fix my installation. 9. If I enter localhost in SMTP field, uncheck SSL and check Verify connection and hit the Submit button in the CF Administrator, it gives Connection Verification Failed! Error instantly. However, with Gmail, when the SSL and Verify connection is checked, and port is set to 465 it take a while (about 20-40 seconds) to give the message Connection Verification Failed! I'm passing correct login credentials each time. As I mentioned in the point above it does work from command-line and PHP work with same mail server settings and login credentials and same CentOS box/Apache installation. 10. IP, host name, trusted users, network config and Firewall all seems to be setup quite properly. Does anyone have any idea what could be wrong here? Where should I look in my server to get more details? Again, neither sendmail nor Gmail works. I've looked in server.log and mail.log. Not sure what's happening. Best, Sagar Gupta ~| 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:335091 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Options for securing our IP on the client's machine?
We have an application that will possibly require putting a version of our CF application on the client's machine. Therefore we're going to be needing to encrypt or compile or otherwise hide our code from the client's prying eyes. It's quite a while since i had to consider this - like since CF5! - so I need to update my knowledge of this whole area. What options are there these days for allowing applications to run on a client machine without them being able to see the source code behind it? -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:335058 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF Shopping carts
Thats why i like the idea of my own shopping cart. I find it takes longer to track down a bug in someone else's code and fix it (or get a support ticket attended to ) than in my own code. And at least i know they are my own bugs!(I always make such a better class of bug, you know? g ) When you make your own code you learn a lot more about how everything bolts together. It's not a principle that always works, but for basic things like a CMS or a catalogue or a shopping cart I think its better to invest in your own code and use that for client sites. (always assuming that your own code is good enough of course) Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Mon, Jun 28, 2010 at 6:59 PM, Kevan Stannard ke...@stannard.net.auwrote: I used CFShopKart a few years back before it was free and had a pretty poor experience. The list of cart features were good, but I found its implementation very poor with duplicate code, scores of bugs, messy markup and sparse responses from the developer when attempting to contact him regarding the bugs I found. I haven't looked at it recently so it may be better now. On 28 June 2010 15:28, Kym Kovan dev-li...@mbcomms.net.au wrote: Bringing this back on topic has anyone got any opinions about CFShopKart? -- Yours, Kym Kovan mbcomms.net.au ~| 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:334891 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: referencing #application.applicationname#
The appropriate use of locks can be really important. Here's a case in point that cost me a LOT: I did an application for a client where to save processing time, I put a couple of variables used many times into the application scope. In this case I wasnt allowed to deploy the application to the production server myself, their staff programmer was going to do it. I had to write the code, demonstrate, test it and prove it on a dev server, then give them the code to deploy on production. Nothing too unusual there. Except the person who did the deployment to production didnt listen to what I told him, didn't read my installation notes, and didnt know much about modern ColdFusion. His knowledge was based back in CF5. He looked at my code, scoffed at all my unlocked reads of application variables and corrected it by putting locks around every access of application vars. In this application that was about 50 places in 5 files. For good measure he put locks on every datasource access as well. When 400 users started using this application (it was something they all access many times a day) all these locks brought the entire system to its knees.Instead of doing what normal people would do and calling me to tell me to come and sort out the problem, they decided that my code had brought their system to its knees, they dumped my application and set their staff guy to re-writing what I'd done and told me i wasnt needed any more. If they'd have called me, I'd have been there in 30 minutes, looked at the changes their staff guy had made, fixed them, and it would have been up and rolling inside an hour. Sadly, I wasn't given the opportunity to have a say, or correct what they had already decided was my mistake. My point here is that locks, if used incorrectly, can wreck an application, or as in this case bring an entire server and database to a crawl. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month p.s. when I last heard, they were still putting locks around every application scope and database access, and had decided that ColdFusion ran too slow, so they were re-writing their whole system in dotnet instead. ~| 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:334216 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: CF 9 Hosting
Since all my competitors are being listed here, I feel its only fair that I should get a mention too. I have CF9Enterprise, with SQLServer2005, MySQL, PHP4 and PHP5, ASP, ASPX, unlimited email accounts, unlimited ftp accounts and lots more stuff too. The environment is shared hosting but nearly all the sites are coldfusion. Because nearly everyone using my system are coldfusion developers, we have optimised it for CF Developing. Few restrictions on tags, mappings etc. It's a bit of a risk but over more than 10 years now we have found it pays off. We have a lot of sites using us for development, staging or test environments while their production sites are on dedicated servers, because they can have their test sites set up identically to the way their production sites are set up. You can see the details at http://afpwebworks.com/hosting.When you look at that, bear in mind that the prices shown are Australian dollars. US dollar equivalent is about 25% lower, so hosting is from US$10 a month, depending on what you need. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month Anyone know any good, reasonable CF 9 hosting companies w/ mysql. Thanks! ~| 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:333881 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: Now() vs getDate() MsSQL CFMX
For all the time I've been hosting my own sites, I have been hosted on servers in different time zones to my own. So i have adopted a practice as follows: [A] I never use now() [B] i have a request variable called request.austime set in the application.cfc which is the current local time in Sydney. [C] request.austime is based on the server clock, adjusted for the timezone offset, returned by the excellent cfc timezone.cfc. [D] timezone.cfc accesses the java routines that provide the timezone info, including daylight savings etc. Using this technique, the same code works on my dev machine which is sitting in my own timezone, and on a site i have at fasthit in perth, western australia, and on my shared hosting on servers in california. And except in the one case where the java timezone routines didnt keep up with the political changes of timezones here in NSW, the time automatically changes to and from daylight savings correctly. The only hiccup i'd say I found is that because of the time differences between Australia and California, the Californian based sites dont recognise the switch to/from daylight savings time till about 2pm the following day, rather than at 2am on the day. The code I use in my application.cfc is as follows: cfset timezonecfc = createobject(component,cms.cfcs.utilities.timezone) / cfset hometimezone =Australia/Sydney / cfset request.austime = Timezonecfc.castFromServer(now(), hometimezone ) / As long as the server clock doesn't wander too far from actual time, everything else flows through the site where i need it. In audit records in teh tables, i use #createodbcdatetime(request.austime)# or i use cfqueryparam value=#request.austime# cfsqltype=CF_SQL_TIMESTAMP/ By preference I'd like the server to connect regularly to an internet time server to correct its clock so that could keep my site timely to the millisecond. But by using this method i dont have to touch anything to do with setting time or daylight savings from one year's end to the next, regardless of where the server sits in the world, or whether or not it's set to UTC or local time or whatever. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Fri, May 21, 2010 at 1:24 PM, Rick Root rick.r...@gmail.com wrote: An excellent point! On Thu, May 20, 2010 at 11:21 PM, Dave Watts dwa...@figleaf.com wrote: Now() is also database independent, which is generally a good thing IMO =) Avoid using database-specific code whenever possible unless said database specific code provides a not insignificant performance advantage. I suspect GetDate() vs. Now() is pretty insignificant. Well, actually, I'd recommend the exact opposite in many cases. It's a good thing to centralize time management wherever possible, and you're typically going to have a single database server servicing one or more application servers. Ideally, all of the servers should use the same NTP server, but even so having a single time source in your application is a good thing. 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 onsit -- ~| 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:333896 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Coldspring question - what causes this error?
I hope someone here can help me. I'm getting an error message as follows from some of my sites: [quote] An exception occurred while instantiating a Java object. The class must not be an interface or an abstract class. Error: ''. [/quote] What causes this error? It's generated when the coldspring instantiation happens. The error goes away when I comment out the lines: cfset application.BeanFactory = createObject(component,coldspring.beans.DefaultXmlBeanFactory).init()/ cfset application.BeanFactory.loadBeansFromXmlFile(expandPath(/admin/cfcs/config/Coldspring.xml),true)/ I have found when I put a fresh copy of Coldspring1.2 in the site, the problem sometimes goes away, but I'd like to know what causes it so I don't have to keep uploading the whole package to my sites. The version I'm using is Coldspring1.2-final. Cheers Mike Kear Windsor, NSW, Australia 0414 622 847 Adobe Certified Advanced ColdFusion Developer AFP Webworks Pty Ltd http://afpwebworks.com Full Scale ColdFusion 9 hosting from A$15/month ~| 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:333751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQLServer2005 and european dates
I'm having trouble figuring out why my database is storing dates in a way i dont want. I hope someone can help. If I run an insert statement, and the dateentered = cfqueryparam value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought that it would store the value '2010-03-31 00:00:00' but it doesnt. When i run a select query on the table the value has been stored as '2010-31-03 00:00:00' (month and day in American format) This means my reports dont find results for the last day of March and all other days are screwed up too.I can't change the reports for a whole lot of reasons, not the least of which is there are bazillions of them. I'd rather force the database to store the date in the format i want. Does anyone know now I can force SQLServer2005 to behave like a good Australian server not an American one and store the dates how we use them? I have also tried using dateentered=#createodbcdate(dateentered)# and that gives the same result. -- Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:333593 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQLServer2005 and European dates
Thanks Steve, but the problem is we're in Australia. We use European format
dates. All the reports and queries are already written as
select * from someTable where mydate between '01-05-2010' and '31-05-2010';
But they dont select any May records unless i re-write the query using cast(
) etc.
That is simply impractical - the client is not going to pay me to rewrite
hundreds of queries, and anyway I'm not going to be able to do that inside
the time available.
And anyway, we already have historical data stored the way we want, from the
previous server where this site came from. We brought it over to this
server and now we have the problem. Maybe what I have to do is figure out
how to change the collation. Do you think that would get at the issue?
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
On Wed, May 12, 2010 at 11:34 PM, DURETTE, STEVEN J (ATTASIAIT)
sd1...@att.com wrote:
Mike,
SQL Server doesn't actually save the date in either format. It saves it
as seconds (milliseconds maybe) from a certain date (I believe
1/1/1900).
The way it is displaying is based on the collation setting of the
Database. Mine are set to SQL_Latin1_General_CP1_CI_AS so I get dates
back like this: 2010-05-12 08:25:15.670 Notice its Year-Month-Day.
You noted that the format of Year-Day-Month was American format, that is
incorrect. It is European format. US Format is Year Month Day and most
people in the US write their dates as Month/Day/Year.
If you want a date in a specific format, you can return it as a string
in the format you want. Select cast(year(getDate()) as varchar) + '-' +
right('0' + cast(month(getDate()) as varchar), 2) + '-' + right('0' +
cast(day(getDate()) as varchar), 2) as properlyFormatedDate
Either way cfqueryparam should be handling the conversions correctly.
If you aren't picking up the 31st, then I would guess that there is
another issue.
If you did something like select * from someTable where mydate between
'05-01-2010' and '05-31-2010'; and it didn't return the record for the
31st that you were expecting then my guess is that there is time data
for that record.
In general when I'm doing something like that I do this:
Select *
From someTable
Where myDate = '05-01-2010'
And myDate dateAdd(d, -1, dateAdd(m, 1, '05-01-2010'));
That way you get everything from 05-01-2010 00:00:00.000 to 05-31-2010
23:59:59.999.
Steve
-Original Message-
From: Mike Kear [mailto:afpwebwo...@gmail.com]
Sent: Wednesday, May 12, 2010 9:20 AM
To: cf-talk
Subject: SQLServer2005 and european dates
I'm having trouble figuring out why my database is storing dates in a
way i
dont want. I hope someone can help.
If I run an insert statement, and the dateentered = cfqueryparam
value=#dateentered# cfsqltype=CF_SQL_DATE / i would have thought
that
it would store the value '2010-03-31 00:00:00' but it doesnt. When
i
run a select query on the table the value has been stored as '2010-31-03
00:00:00' (month and day in American format)
This means my reports dont find results for the last day of March and
all
other days are screwed up too.I can't change the reports for a whole
lot
of reasons, not the least of which is there are bazillions of them.
I'd
rather force the database to store the date in the format i want.
Does anyone know now I can force SQLServer2005 to behave like a good
Australian server not an American one and store the dates how we use
them?
I have also tried using dateentered=#createodbcdate(dateentered)# and
that
gives the same result.
--
Cheers
Mike Kear
Windsor, NSW, Australia
Adobe Certified Advanced ColdFusion Developer
AFP Webworks
http://afpwebworks.com
ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month
~|
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:333595
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQLServer2005 and European dates
It is SQLServer2005. The old server was SQLServer2000.Rewriting hundreds of queries is not an option. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, May 12, 2010 at 11:44 PM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Yes, check the old database and the new one and compare the collation. What versions of SQL server are you using? Steve ~| 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:333599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQLServer2005 and European dates
Thank you Steve, but I dont think you've seen the point. The query you wrote isnt the one I'm using. you wrote: Select * From someTable Where myDate = '05-01-2010' And myDate dateAdd(m, 1, '05-01-2010'); and that gets all the May results. We're sending: Select * From someTable Where myDate = '01-05-2010' And myDate '31-05-2010'; and it gets NO May results. As i said, re-writing hundreds of queries throughout the application is NOT an option. Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month On Wed, May 12, 2010 at 11:42 PM, DURETTE, STEVEN J (ATTASIAIT) sd1...@att.com wrote: Ok, so I made a mistake in my code... Here is the correction: Select * From someTable Where myDate = '05-01-2010' And myDate dateAdd(m, 1, '05-01-2010'); That code gets everything greater than or equal to 2010-05-01 00:00:00.000 and less than 2010-06-01 00:00:00.000 Steve ~| 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:333601 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: SQLServer2005 and European dates
Ok here's a puzzle. I changed my insert query, and now it's changed the way the date is stored. Does anyone know if this is a bug? For example if I have this in the insert query: cfqueryparam value=#PLUTotal.getdateentered()# cfsqltype=CF_SQL_TIMESTAMP /, then the date is stored in the American format of '2010-31-03 00:00:00' But if i get rid of the CFQUERYPARAM and have the same info inserted as follows; #createodbcdate(PLUTotal.getdateentered())#, then the date shows in a query as ''2010-03-31 00:00:00' So . the solution for my issue is to do away with CFQUERYPARAM at least for date fields in insert/update queries. But why would that make this difference? Cheers Mike Kear Windsor, NSW, Australia Adobe Certified Advanced ColdFusion Developer AFP Webworks http://afpwebworks.com ColdFusion 9 Enterprise, PHP, ASP, ASP.NET hosting from AUD$15/month ~| 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:333603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
