RE: CF9 Half Failure
We've just been through a rash of apparently inexplicable issues similar to yours that were all eventually traced to a wonky power supply. At least, replacing the power supply eliminated the problems. HTH -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Thursday, July 21, 2011 10:06 AM To: cf-talk Subject: RE: CF9 Half Failure Agreed... FTP should not be affected at all, and if it was CF it should affect all the site. I don't see how restarting CF could repair FTP at all, nonetheless, it does. Right now I've got my server guy looking for IIS issues and for IP conflicts. To me, this looks more IIS/IP related... but it's strange that restarting CF fixes it. I don't get the connection either. 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: A&W Unplugged http://www.austin-williams.com/unplugged ~| 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:346295 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfquery select question
Greg and John, Many thanks to you both. John's SQL produced exactly the same results as my tortuous attempt, and went a long way toward showing how to write better SQL. Greg, to broaden my SQL experience even further, I will have to take a little time to understand yours and get it to produce the same results, which I will do. Thanks again, Mark -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Thursday, May 26, 2011 11:48 AM To: cf-talk Subject: Re: cfquery select question If they all return 1 row use this.. select * from table3 t3 where t3.ID = ( select t2.ID from table2 t2 where t2.productcode = ( select t1.productcode from table1 t1 where t1.ordernumber = [whatever] ) ) If they return multiple rows you can change the = to IN () And if they return many rows, may want to use WHERE EXISTS.. Let us know On Thu, May 26, 2011 at 11:41 AM, Mark Atkinson wrote: > > Hallo all, > > Forgive my SQL "injection" into this list - perhaps an answer to my question > might also prove useful to others. > > I'm using three tables. There is no relationship between table1 and table3. > > I first query table1 for ordernumber and productcode, based on the > productcode containing a certain string. > > Outputting the results, I query table2 for ordernumber and t2_ID based on > table2.ordernumber matching table1.ordernumber. > > Looping those results, I query table3 for ID and Company based on > table2.t2_ID. > > This, rather painfully I do admit, finds the table3.Company(ies) that > has(have) purchased table1.productcode. > > Have Googled and read about how a single select with JOIN and/or UNION would > achieve these results, but they also mention how I should essentially "start > at the end" and work my way backwards, so to speak. Can't quite get my head > around this. > > TIA for any advice. > Mark > > ~| 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:344931 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfquery select question
Hallo all, Forgive my SQL "injection" into this list - perhaps an answer to my question might also prove useful to others. I'm using three tables. There is no relationship between table1 and table3. I first query table1 for ordernumber and productcode, based on the productcode containing a certain string. Outputting the results, I query table2 for ordernumber and t2_ID based on table2.ordernumber matching table1.ordernumber. Looping those results, I query table3 for ID and Company based on table2.t2_ID. This, rather painfully I do admit, finds the table3.Company(ies) that has(have) purchased table1.productcode. Have Googled and read about how a single select with JOIN and/or UNION would achieve these results, but they also mention how I should essentially "start at the end" and work my way backwards, so to speak. Can't quite get my head around this. TIA for any advice. Mark ~| 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:344915 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: cfform validate onsubmit issue
Dang! Of course! It's Monday. Created a virtual directory under the secure subdomain pointing to the local path to that directory. Many thanks. -- Mark Atkinson AOCS Web | www.aocs.org 217-693-4839 Dave Watts wrote: >> Googled extensively and searched the docs - forgive me if I'm missing >> something. >> >> Have a cfform on a secure subdomain with its own certificate using >> validateat="onSubmit" for several text fields, which is being skipped. >> It also doesn't work on the secure subdomain if the request is not >> secure (http). validate="onServer" does work in these instances. >> >> validateat="onSubmit" for this form works on a local development box >> (non https) and on a non-secure development subdomain (same top-level >> domain as the secure). It works (both secure and non-secure) on the www >> of the same domain. >> >> Javascript is not disabled in any browser I'm using, and other >> javascript being called works fine. >> > > Does the URL http://your_server/CFIDE/scripts/cfform.js resolve > properly in production? > > 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. > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331769 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
cfform validate onsubmit issue
Howdy folks, Googled extensively and searched the docs - forgive me if I'm missing something. Have a cfform on a secure subdomain with its own certificate using validateat="onSubmit" for several text fields, which is being skipped. It also doesn't work on the secure subdomain if the request is not secure (http). validate="onServer" does work in these instances. validateat="onSubmit" for this form works on a local development box (non https) and on a non-secure development subdomain (same top-level domain as the secure). It works (both secure and non-secure) on the www of the same domain. Javascript is not disabled in any browser I'm using, and other javascript being called works fine. CF8 Standard Windows IIS5 Rather flummoxed. Has anyone come across this? Thanks, Mark ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:331766 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: IE8 is killing my website
Did in fact observe two or three users. In all cases, the cookie simply wasn't being set (through observation of the Temporary Internet Files folder). In each case, eventually it just started "working" -- after trying several different things -- with no consistency as to which thing worked in any of the cases. I don't believe this is a CFLOCATION or URL rewrite issue... users are all at the correct domain from the start. I've had issues with cookies and inconsistency, which were in many cases due to settings in security software such as Norton's, on the user's machine. HTH -- Mark Atkinson AOCS Web | www.aocs.org 217-693-4839 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Education
Guess I'm a little outnumbered - I have no degree. But then I'm an old fa*t who's been around and worked in everything over the years from law to construction before being wowed by the amazing combination of art and science that is the internet. Our Web Manager has a degree in nutritional science. Go figure. But we complement each other in the experience/qualification equation. But what you're seeing is more a sign of the current times rather than related to any given discipline. With so many people unfortunately out of work these days, employers (who are hiring) can afford to be more exacting and particular with their requirements of job applicants. I've seen these requirements undulate over the years. -- Mark Atkinson AOCS Web | www.aocs.org 217-693-4839 Phillip Vector wrote: > Just curious.. > > I've seen allot of jobs require lately BA/BS and not accept experience > in it's place. What in your estimation is the percent of coldfusion > people who have these and do you have one yourself? > > For me, I don't have any college experience and I would guess that > about 5% of the coldfusion community actually have a BA/BS. > > Has your experience been different? > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327590 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 => button => javascript/cfwindow => occasional => Error retrieving markup for element
Thanks for sharing. It's these little idiosyncratic tidbits that make this job so interesting and frustrating all at once. -- Mark Atkinson AOCS Web | www.aocs.org 217-693-4839 Robert Bell wrote: > Problem SOLVED. Seems by using the full path to the url, some browsers were > having problems, so I just used the cfimage.cfm relative path, and everything > works on all browser permutations just dandy. Guess this was viewed as a > cross-domain scripting attack somewhere down the ajax/ui/cf/javascript path ? > Hrm, anyway thanks for listening to me at all. :) > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327211 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF8 => button => javascript/cfwindow => occasional => Error retrieving markup for element
One thing that jumps out is this:
#oi_window + 108# (2 instances)
Is this what you're trying to do:
#evaluate(oi_window + 108)#
assuming oi_window is numeric? I think that might affect retrieving the
markup.
--
Mark Atkinson
AOCS Web | www.aocs.org
217-693-4839
Robert Bell wrote:
> Hi,
>
> I am having some problems with windows/xp boxes running IE7 with one of
> the cfm pages I created. I am kinda at a loss to why it is happening, because
> on my test machines it works flawlessly. Any ideas on why we could the
> error below would be appreciated. The page uses a cfform with a button
> that creates a cfwindow via javascript:
>
> The page works fine on ie8, ie6, ff2, ff3 etc.. and ie7 and seems to be
> intermittent on some browsers or connections to the cf8 server. I have had
> a couple of JVM mem warnings on the box, and upped the jvm heap size from
> 256/512 => 768/768, but I am not sure they have anything to do with this
> issue. Note, I never do a .destroy on the cfwindow, just a .hide, and plan
> to put in a .destroy, and I just assumed that garbage collection would clean
> up my windows (I know bad..:)
>
> Here is the error:
>
> Error retrieving markup for element iimg_J032_body, unable to open connectoin
> to URL
> http://www.domain.com/dir/subdir/cfimage.cfm?id=J073 : [Enable debugging by
> adding 'cfdebg' to your URL parameters to
> see more information]
>
> Here is the javascript code assigned to the button:
>
> http://www.domain.com/dir/subdir/cfimage.cfm?cfdebug&id=#DOCUMENT_NUMBER#'
> ,{height:#oi_window + 108# , width:940,shadow:true,modal:true, closable:true,
> draggable:true, resizable:true,center:true,
> initshow:true,minheight:#oi_window+108#, minwidth:940, refreshOnShow:true});}
> }" value="Larger">
>
>
> Here is the jvm arguments settings:
> -server -Dsun.io.useCanonCaches=false -XX:MaxPermSize=192m -XX:+UseParallelGC
> -Dcoldfusion.rootDir={application.home}/../
> -Dcoldfusion.libPath={application.home}/../lib
>
> Cfdebug from page that build the button, and when clicked:
>
> info:widget: Window hidden, id: iimg_J032
> info:http: Replaced markup for element: iimg_J032_body
> info:http: HTTP GET
> http://www.domain.com/dir/subdir/cfimage.cfm?cfdebug&id=J032&_cf_containerId=iimg_J032_body&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=9CE97279562E33039280EC69021AC64A&_cf_rc=0
> info:http: Replacing markup for element: iimg_J032_body from URL
> http://www.domain.com/dir/subdir/cfimage.cfm?cfdebug&id=J032
> with params _cf_containerId=iimg_J032_body
> info:widget: Creating window: iimg_J032
> info:LogReader: LogReader initialized
> info:global: Logger initialized
>
>
> Coldfusion Version:
>
> Server Product ColdFusion
> Version 8,0,0,176276
> Edition Enterprise
> Operating System UNIX
> OS Version 2.6.18-128.el5PAE
>
> Java VM Specification Version 1.0
> Java VM Specification Vendor Sun Microsystems Inc.
> Java VM Specification Name Java Virtual Machine Specification
> Java VM Version 1.6.0_01-b06
> Java VM Vendor Sun Microsystems Inc.
> Java VM Name Java HotSpot(TM) Server VM
> Java Specification Version 1.6
> Java Specification Vendor Sun Microsystems Inc.
> Java Specification Name Java Platform API Specification
>
>
> Thanks in advance,
> Bob
>
>
>
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327180
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF CMS
Howdy all, This is not a purely technical question so forgive me, but has anyone had experience with a ColdFusion implementation of Results Direct's CMSPlus? Either hosted or on your servers? Would be interested in feedback, offlist if you prefer. And would be happy to be pointed to a more appropriate place to post this question. Many thanks, Mark -- Mark Atkinson AOCS Web | www.aocs.org 217-693-4839 ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324597 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: File upload with cffile errors with Mac OSX
IIRC some browsers on Macs add an empty space to some or all form fields. Use the trim function on the action page. HTH Mark ColdFusion Developer wrote: > Code I'm using for the file upload: > > destination="#application.absolutePath#assets/images/userPhotos/" > nameconflict="makeunique" accept="image/*" /> > > I guess you could consider it "newbyish" since it's not in a CFC or custom > tag, just a form processing page. > > >> The flash player on a mac sometimes needs an output to work right >> especially on file uploads. >> >> How you do this depends on how you are doing the upload... basically >> if you are doing it newbyish or in a cfc or custom tag.. Either show >> some code or just output something like one of these: >> >> writeOutput(1) >> > > > > ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:323776 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF upgrade question
Many thanks to both of you. Mark >> You could probably install CF8 from the full developer edition >> installer available at Adobe, then enter your license keys? Not sure >> if it will require/accept the multiple license keys you'd have though >> -- your CF7 key, and the CF8 upgrade key. Probably someone here has >> direct experience with this. >> > > I just did this yesterday. Yes you can do a clean install with an > upgrade license number. When you enter the CF8 license number during > install, it will recognize it as an upgrade license and immediately ask > you for your previous version's license number. Just enter the older > license and you are off and installing a fully licensed, latest version > of ColdFusion server. > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317892 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CF upgrade question
Hi folks, Having trouble getting to houseoffusion.com to look at specific archives, so have quick and specific question if I could trouble y'all: Purchased upgrade from ColdFusion 7 to 8, Standard Edition - XP Pro & IIS web server. Is it possible/advisable to uninstall 7 and then do clean, full install of 8 from upgrade disk? Understand that datasource connections, etc., will need to be re-done. Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:317872 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: HELP! SQL Injection Attack!
We drew a great deal of breathing room to implement the solutions discussed here with our installation of Sonicwall firewall (about 600 bucks). Its intrusion prevention settings are highly configurable, both globally and individually, and with an annual subscription of 200 dollars we get I believe daily upgrades to help configure against new and known issues. In our small shop its been worth every single penny. HTH Mark Kris Jones wrote: > I'd like to know how I can stop the requests from ever hitting the web-server. > > Can anyone point me at a resource for a firewall solution? I've seen > some isapi filter solutions, but they all seem to just clean the > querystring and then forward the request on -- so it's still hitting > CF. I'd really like to stop it before we get to the web-server at all > (let alone the CF application server). > > Cheers, > Kris > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:310385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: (ot) URL Hack Attempt Leaves Me Scractching My Head...
We've been dealing with these too - to address Che's question they were crawling here for pages with query strings but not much else - as well as our implementing solutions offered here (much appreciation to all), our net. admin. simply shut down these attacks at the firewall - Sonicwall is the name of our firewall and it apparently updates every ten minutes to include defenses against things like this. Our logs are very clean now - although DB's a mess. :-) N.A. left for the day before I got back to email but I will attempt to discover what he did and post here. HTH Mark Che Vilnonis wrote: > For me, all attempts are focusing on rss.cfm. Another post said they saw > sitemap.cfm being hit. Can anyone confirm any other templates that are being > hit? Perhaps only 'commonly named' templates are being hit? > > Che > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309387 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfoutput in a cfouput
Good morning Chad, Try it without the group attribute in the foo query output. Cheers, Mark Chad Gray wrote: > Since when have we been able to nest cfoutputs? > > I have always thought that you could not do this. Maybe it was a CF4.5/5.0 > thing and in never learned it was possible in MX? > > I just tried this and it works in my CF8 installation: > > > #foo.id# > #foo.b# > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:306146 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
