Re: 8.0.1 webservice compile errors
It appears that if I rename the cfc's, they then work. However, the files are not just used internally -- they are connected to by outside websites. Suggestions? --Ben Doom ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313554 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: 8.0.1 webservice compile errors
The refreshWSDL attribute didn't work. I cannot create the webservice in the Administrator, which is weird. I've also tried deleting the stubs and restarting the CF service. --Ben Doom You might try restarting CF or try using cfinvoke with refreshWSDL=true. It sounds like CF has cached the generated WSDL so you need to force it to regenerate that if you've changed anything. This is probably why changing the file names works. It appears that if I rename the cfc's, they then work. However, the files are not just used internally -- they are connected to by outside websites. Suggestions? --Ben Doom ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313561 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
8.0.1 webservice compile errors
We're running a pair of CF 8 Standard Servers. Since installing the 8.0.1 updater, webservices have been giving me a headache. Each server runs a different site, and they are integrated by web services. Some of these services return complex values, defined by CFCs with no methods, only data. Not all services in the CFC return complex data, but all throw errors when I try to run them. A test CFC containing a single method that simply returns true can be sucessfully consumed. Since installing the 8.0.1 updater (v 8,0,1,195765), none of the services are consumed correctly. When I call them by URL, they seem to return correct WDDX, but when I attempt to consume them using CFINVOKE, I get the error quoted at the end. We get the same problem on development servers. Is this a problem with JRE 1.6.0_04? Something wiggy about returning complex structures? Is there an obvious solution I'm not seeing? Heck, I'll settle for an obscure answer I'm not seeing. 10. public class IntegrationLocator extends org.apache.axis.client.Service implements services.Integration { ^---^ *** Semantic Error: The checked exception RemoteException is not assignable to any exception in the throws clause of the accessible method javax.xml.rpc.Call createCall() throws javax.xml.rpc.ServiceException; declared in type javax.xml.rpc.Service. 10. public class IntegrationLocator extends org.apache.axis.client.Service implements services.Integration { ^---^ *** Semantic Error: The method org.apache.axis.client.Call createCall() throws java.rmi.RemoteException; with protected access cannot replace the accessible method javax.xml.rpc.Call createCall() throws javax server-error: true Content-Type: text/html; charset=UTF-8 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:313489 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: problem with cfdocument and font size
Try styling the li instead of the containing div. --Ben Doom Rick Root wrote: Okay I'm having this very strange issue with cfdocument. My document has a couple of pages, and there is a header and footer. I can't seem to get the font size in my footer to do what I want. footer code: -- cfdocumentitem type=footer div style=font-size: 10px; ol CFLOOP LIST=#FOOTNOTE# DELIMITERS=#Chr(10)# INDEX=ThisFootnote CFOUTPUTCFIF Left(Trim(ThisFOOTNOTE),12) eq CONFIDENTIALPCFELSELI/CFIF#ThisFOOTNOTE#/CFOUTPUT /CFLOOP /ol img src=/include/black-spacer.gif width=100% height=2 border=0 cfoutput table width=100% tr td nowrap align=left width=25% style=font-size: 11px; font-weight: bold#dateFormat(Now(),', d, ')# #TimeFormat(Now(),h:mm tt)#/td td nowrap align=center width=50% style=font-size: 11px; font-weight: boldCONFIDENTIAL - OFFICIAL DUKE UNIVERSITY USE ONLY/td td nowrap align=right width=25% style=font-size: 11px; font-weight: boldPage #cfdocument.currentpagenumber# of #cfdocument.totalpagecount#/td /tr /table /div /cfoutput /cfdocumentitem -- So I'm trying to change the font size of my ordered list up there, so I change the style definition on the div to 14 px.. 18px.. 24px... each time, the visible font actually gets SMALLER. so I tried settign it to something small, and it also got smaller (5px) Tried putting in font tags and that didn't seem to help either. What the hell is going on? CF8/Windows ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300563 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SPAM: Macromedia 'Certified Professional' Pin
Sounds about right. I got one for being a MX6 Advanced Developer. I wore it the day we got it, as a gag, but then it went in a drawer. It's probably in a box somewhere in my apt. --Ben Doom Andy Allan wrote: I think I got a pin for the CF6 exam but I definately didn't get one for CF7. Would I wear it to the office? Hell no. Would I ever wear it? Hell no :) On 04/03/2008, Andy Matthews [EMAIL PROTECTED] wrote: I didn't get a pin...I just got a certificate. Maybe you scored higher than I did? :) -Original Message- From: Don [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 04, 2008 9:30 AM To: CF-Talk Subject: SPAM: Macromedia 'Certified Professional' Pin You know the one you get when you get CF certified. Does or has anyone wore them to the office? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300414 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Prevent users from voting twice.
What's to stop someone from stealing/hacking/gaining from friends physical devices? I think we're down to fingerprints, DNA scans, and retinal imaging. But your point is taken. :-) --Ben Doom Tom Chiverton wrote: On Thursday 28 Feb 2008, Ben Doom wrote: You can never completely eliminate the possibility of someone voting early and voting often Not without physical devices, no. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300169 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - URL Rewriting, an unknown number of items
I'm assuming here that you want to deal with them in CF, once you've gotten to your processing page. I'd probably use either a replace or a regex to remove the /with/ and whatever other known elements need to be removed from the URL string. Then, I'd just loop over it as a list with / as a delimiter. HTH. --Ben Doom Adrian Lynch wrote: Sorry again for the OT. I have a URL in the form: /with/item1/item2/item3/ Where there can be any number of items. Is there a RegEx to deal with this? I could cap the number of items to something acceptable, but either way would be find. Thanks. Adrian Lynch ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300202 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - URL Rewriting, an unknown number of items
Instead of trying to rewrite the list this way, wouldn't it make more sense to do something like: ^something/(.+) /somefile.cfm?items=$1 Then you could traverse the item list in CF using / as a delimiter, and not have to have multiple rules for the URLS. Of course, that all assumes that the item list is the last bit of the URL, which may or may not be true. --Ben Doom Russ wrote: The simplest way would be to write a rule for each item up to a max that you think you'd hit RewriteRule ^something/([^/])+/*$ /somefile.cfm?items=$1 RewriteRule ^something/([^/])+/([^/])+/*$ /somefile.cfm?items=$1,$2 RewriteRule ^something/([^/])+/([^/])+/([^/])+*$ /somefile.cfm?items=$1,$2,$3 And so on. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Friday, February 29, 2008 12:03 PM To: CF-Talk Subject: RE: OT - URL Rewriting, an unknown number of items Sorry, I didn't say what I wanted out the other end... something/item1/item2/item3 would become somefile.cfm?items=item1,item2,item3 The something/somefile parts aren't important, it's the items that I need. Cheers. -Original Message- From: Jordan Michaels Sent: 29 February 2008 16:59 To: CF-Talk Subject: Re: OT - URL Rewriting, an unknown number of items Just to clarify, are you wanting to deal with a list of variables, like so: fruits = orange, apple, pear, etc Or are you looking for item1, item2, item3 to contain values to different variables? Warm regards, Jordan Michaels Vivio Technologies http://www.viviotech.net/ BlueDragon Alliance Member [EMAIL PROTECTED] Adrian Lynch wrote: Sorry again for the OT. I have a URL in the form: /with/item1/item2/item3/ Where there can be any number of items. Is there a RegEx to deal with this? I could cap the number of items to something acceptable, but either way would be find. Thanks. Adrian Lynch ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300203 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Failing gracefully when using xmlParse()...
You could use cfhttp to load the xml data into a variable, then parse the contents on a successful retrieval. --Ben Doom Che Vilnonis wrote: How can I fail gracefully when using xmlParse and the feed is not available/online? cfset xmlFeed = xmlParse(http://www.somedomainwithrssfeed.com/keyword.xml;) When using cfhttp, you could always use cfif findNoCase(200, cfhttp.statusCode) to test for success. How is it done with xmlParse? I'd rather not use a cftry/cfcatch block. Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300216 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Prevent users from voting twice.
George Linderman wrote: Okay, got it. Thank you. Yeah, I was wondering if IPs were not going to work...but didn't know that they were *that* unreliable. Well, think about this: Everyone in my office is behind the same router. So there are 7 people in this office who would show up as a single IP. Add to that that if I go home or use a proxy (like a free internet proxy, or the TOR system) I could vote many times. You can never completely eliminate the possibility of someone voting early and voting often, but using a registration system or cookies can make it more reliable. --Ben Doom ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300081 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SOT - SQL Union Problem
I'm not an SQL guru, so take this with a grain of salt: You could do a join on table1.firstname=table2.firstname and table1.firstname = table2.lastname to get all the results that match. You could union this to two unioned selects where there's an entry in table1 but not table2 and vice versa. You'll have to select empty strings for the columns that are only present in one or the other table. This should give you a result set where you either have the addresses from one, or the other, or both. You can make display (or further processing) decisions based on that. --Ben Doom Mark Henderson wrote: OK, so that was working, and those are the only two fields I want to union on, which is fine. But now I also want to add the address fields to the query result, without doing a union on those additional fields. Some addresses aren't entered quite right, and this will then create duplicates even though the query doesn't see them as such - does that make sense? So, for instance, when I do: SELECT FirstName1 AS FirstName, Surname1 AS LastName FROM tblMain WHERE foundation = Yes UNION SELECT FirstName, LastName FROM tblCentennialMembers; I get the result set I want. But if I do SELECT FirstName1 AS FirstName, Surname1 AS LastName. Add1, Add2, City, Country FROM tblMain WHERE foundation = Yes UNION SELECT FirstName, LastName, Address1, Address2, City, Country FROM tblCentennialMembers; It returns almost everything including the duplicates since add1 doesn't always match address1, even though the first and last names match. So, how to get the extra fields into the original result set while only doing a union on first and last names? Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300083 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How accurate is IP address / Geocode lookup?
From what I understand, it's usually the ISP. However, it is often the last hop before the actual client, so it would only be inaccurate if, say, the person was in TN and the ISP was in KY. That said, at my last job, we were in KY, and we showed up as in (I think) PA, since that was where the router for static IPs was. Alltel was our ISP, IIRC. So it's a good approximation, but I would not rely on it for calculating sales tax. :-) --Doom Jeff Chastain wrote: I have a client that is looking to ascertain the state ( or country if not US based ) of the current visitor to their web site. One possibility has been to use their IP address and a geocode lookup, which I have never done before. So, how accurate is doing a geocode lookup based upon IP? Does it really give the user's location or more often the ISP's location? Any feedback would be appreciated. Thanks. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300128 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Interesting idea for next CF - thoughts...
I disagree that hints are cleaner than comments. Comments are set apart from the logic, display, whatever. They are semantically easy to parse as ignorable by the system, remove systematically, etc. They don't clutter the tags. They're available both in the tag-based language and script-based language. They're a standard feature, in some way or another, of *every* language. Replacing them is, in my opinion, silly, and your suggestion seems like an unnecessary augmentation that would add neither a fundamental improvement in performance, a new ability, or enhanced ease-of-use. Sorry to be so negative, but I just don't see it. --Ben Doom John Skrotzki wrote: As I was doing my stuff today I had an interesting idea and wondered what others thought. In a nutshell it would be cool to be able to have a HINT attribute for every CFML tag for VERY SHORT comments. I know this mixes comments within logic but it would be great for certain things. For example: CFPARAM NAME=myVar DEFAULT=233 HINT=myHint I have an extensive db value key table with all sorts of combinations and use its numeric key to represent its value. So, in the above, 233 would equal some value and the HINT would help the programmer to remember what the key was. Yes, you could just as easily do !--- myHint --- but the above idea is much cleaner. You could use HINT for all sorts of brief notes... Thoughts? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:300026 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion 8 and Win 2003 problems
It sounds like your permissions on the directories got hosed, possibly by changing permissions to allow the ASP extensions. That is, of course, mostly a guess. As a sidebar, why are you not running SP2 on your production machine? --Ben Doom Ali Awan wrote: I have an application running fine on ColdFusion 8 and Windows 2003 Server with SP2. Then I migrated the application to a production server also running ColdFusion 8 and Windows 2003, but this one does NOT have SP2. Both are on IIS 6. The CF application has been running fine up until now. Now when anyone tries to go to the website, before anything it throws a browser error that you are not authorized to view this page, and something about an ACL (access control list). It then throws up a windows prompt for a username/password. The only thing that changed was that the sys admin, loaded ASP extensions over the weekend. Anybody know of any solutions, or has run into this problem before? Thanks in advance, Ali ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299862 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I ma stuck here . In coldfusion query
You are trying to select where menuId = foundOn. I'm guessing foundOn is a text field. Check your subselect. --Ben Doom erik tom wrote: I have a column datatype text. And when i try to run the query I get the error [Macromedia][SQLServer JDBC Driver][SQLServer]Operand type clash: text is incompatible with int The query is select menuId,label,foundOn from dbo.menu where menuId IN (select foundOn from dbo.menu where menuId=#form.selTopLevel2#) order by menuId ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299502 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: I ma stuck here . In coldfusion query
If you are using foundOn as a list of menuId's, I would strongly suggest that you reconsider your db layout. I would, instead, use what is generally called a join table or link table that allows you to do basically the same thing, but in a cleaner, more normalized way that doesn't require special tricks. If you need more of a pointer than that, Google the terms first. It's a pretty basic db concept. --Ben Doom erik tom wrote: You are trying to select where menuId = foundOn. I'm guessing foundOn is a text field. Check your subselect. --Ben Doom erik tom wrote: I have a column datatype text. And when i try to run the query I get the error [Macromedia][SQLServer JDBC Driver][SQLServer]Operand type clash: text is incompatible with int The query is select menuId,label,foundOn from dbo.menu where menuId IN (select foundOn from dbo.menu where menuId=#form.selTopLevel2#) order by menuId You are correct foundOn is text datatype so how can I convert the subquery so it becomes int datatype ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299515 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT - Box has been attacked by cowboy
Yep. They basically let you do whatever. We used to host with them. --Ben Doom Josh Nathanson wrote: That is the moral equivolent of holding a car rental company liable for accidents caused by people that rent the cars. The responsibility for the security for *unmanaged* servers the the person that operates the server, not the company from which it is rented. Just like you are responsible for securing your own desktop at home. In that case I take back my jab at them. I didn't realize they were unmanaged. -- Josh ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299149 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 - Box has been attacked by cowboy
I know jack about cars. That's why I hire mechanics. If you don't feel competent regarding securing your server(s), hire someone who is. I completely understand not knowing that you are not secure enough the first time. However, complaining that you don't know enough and asking for a magic fix for security is not a reasonable solution. --Ben Doom Don L wrote: On the contrary, it's the only useful answer. If you have a known vulnerability, you have to fix it. The answer may not be as simple as put up a firewall, but if someone from Texas was able to get to your database server directly to change your schema, that indicates a clear problem. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Here's the thing, if I were a security professional, would I be in a better position to attack and/or defend my machine or any machines for that matter? Given the opportunity cost, could any of us be all and being experts in all? A clear and difficult challenge. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299130 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: all possible letter combinations
In pseudocode: function f(sofar, more) { array strings foreach letter in more { strings = f(foreach+letter, more-letter) } return strings } HTH. --Ben Doom Greg Morphis wrote: anyone else? I was hoping to do this in CF alone? Thanks On Wed, Feb 13, 2008 at 6:59 PM, Dawson, Michael [EMAIL PROTECTED] wrote: Thinking outside the box... You could use a database for this. Create a table that contains a single column. That column contains a record for each letter of the alphabet. Then, do a cartesian join to join that table to itself, three other times. Concatenate the fields and you should have each combination. That would get the first part without consideration of the second part. m!ke _ From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wed 2/13/2008 4:57 PM To: CF-Talk Subject: all possible letter combinations Given a string, e.g. ABCD I need to come up with all combinations of letters eg ABCD ABDC ACBD ACDB . And exlude strings like '', 'AAAB' unless you pass a string with duplicate characters If I pass the string AAAB then it'd return: AAAB AABA ABAA BAAA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298992 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: all possible letter combinations
I'd make some changes to make it easier to read. First, instead of wordarray[arraylen(wordarray)+1] = ... I'd use arrayappend(). Second, if you aren't going to use ccArr, sbArr, and rcArr, remove them from the function. They are just confusing. If the length of remainingchars is 1, you don't need the mid() function. You don't need mid() later, either. You can use left and right, which might be less confusing. You are returning an array, and trying to insert it into a single array element. I think you're getting nested arrays. Try dumping the entire argument scope (including wordarray) before returning on each recursion. HTH. --Ben Doom Greg Morphis wrote: I thought I had it with this.. which is similiar to what you suggested Ben cffunction name=createWordList returntype=array cfargument name=wordArray required=yes type=array / cfargument name=strbase default= required=yes type=string / cfargument name=remainingchars default= required=yes type=string / cfset var j = 1 / cfset var currchar = / cfset ccArr = arraynew(1) / cfset sbArr = arraynew(1) / cfset rcArr = arraynew(1) / cfscript if(len(remainingchars) eq 1) { wordArray[ArrayLen(wordArray)+1] = strbase mid(remainingchars,1,1); } else { for (j = 1; j lt len(remainingchars); j=j+1) { currchar = mid(remainingchars,j,1); if(find(currchar,remainingchars,j) eq j) { wordArray[ArrayLen(wordArray)+1] = createWordList(wordArray, mid(remainingchars,1,j) mid(remainingchars,j+1,len(remainingchars))); } } } /cfscript cfreturn wordArray / /cffunction But all I get is an empty Array.. : array 1 array [empty] 2 array 1 array [empty] 3 array 1 array [empty] 2 array 1 array [empty] On Thu, Feb 14, 2008 at 8:30 AM, Ben Doom [EMAIL PROTECTED] wrote: In pseudocode: function f(sofar, more) { array strings foreach letter in more { strings = f(foreach+letter, more-letter) } return strings } HTH. --Ben Doom Greg Morphis wrote: anyone else? I was hoping to do this in CF alone? Thanks On Wed, Feb 13, 2008 at 6:59 PM, Dawson, Michael [EMAIL PROTECTED] wrote: Thinking outside the box... You could use a database for this. Create a table that contains a single column. That column contains a record for each letter of the alphabet. Then, do a cartesian join to join that table to itself, three other times. Concatenate the fields and you should have each combination. That would get the first part without consideration of the second part. m!ke _ From: Greg Morphis [mailto:[EMAIL PROTECTED] Sent: Wed 2/13/2008 4:57 PM To: CF-Talk Subject: all possible letter combinations Given a string, e.g. ABCD I need to come up with all combinations of letters eg ABCD ABDC ACBD ACDB . And exlude strings like '', 'AAAB' unless you pass a string with duplicate characters If I pass the string AAAB then it'd return: AAAB AABA ABAA BAAA ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299005 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: What type of CF hosting do I need?
I'm not sure why that's not an option. It seems to me that you could create a db table which holds a list of accounts to be processed. Dequeue the first one, process it, and re-enqueue. Set up a single scheduled task for this, and fire it off every so-many (1, 2, 5?) minutes. Just a suggestion. --Ben Doom Che Vilnonis wrote: Thanks Jerry. That's not an option, really. My # of scheduled tasks would increase quite a bit if I took that approach and because of the inconsistencies of the feeds, extra steps are needed to be performed to make certain that all of the data is homogeneuous between the feeds. That said, the tasks are running very well considering what is being done. Basically it comes down to this. Are there any shared CF web hosts that allow to have an high number of scheduled tasks be run daily knowing that some of them may take a few minutes to complete? -Original Message- From: Jerry Johnson [mailto:[EMAIL PROTECTED] Sent: Thursday, February 14, 2008 1:53 PM To: CF-Talk Subject: Re: OT: What type of CF hosting do I need? Dont take so long on each task. break them down smaller, into more granular pieces. dont process them all at one whack, but build a queue of items to process, and then run through them individually or in much smaller groups. On Thu, Feb 14, 2008 at 1:37 PM, Che Vilnonis [EMAIL PROTECTED] wrote: Looking for opinions here. I'm looking to launch a CF based car/truck/cycle RSS feed aggregator. I don't expect to have a ton of traffic initially, so I thought shared hosting would work. But, when I built the app, I found that the scripts I needed to run (even using the cfthread tag) would take on average 1-3 minutes to run. A few would take 4-5 minutes. (I'm aggregating a lot of data from several sources at once through 4-5 dozen daily scheduled tasks on my dev server.) The problem with shared hosting is that there usually are restrictions to how long a page can run. Typically it is 30-60 seconds. There might even be issues with the number of scheduled tasks that my app requires. Is my only recourse to get VPS based hosting? Are there any other alternatives that I am missing that might save me a few $$$? Thanks for your thoughts, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299027 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Why does CFMail timeout?
OK, I seem to be missing something here. Why would CFMail ever timeout? I'm using spooling, so shouldn't it just write a file to the spool directory and let the scheduled delivery handle anything that might timeout? What am I missing? --Ben Doom ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297812 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: DNS Hosting
We run a primary DNS server on one of our production boxes, a secondary off a box in the office (this made more sense when our production servers were halfway across the country, but it still works), and we pay $50 a year for Nettica (http://www.nettica.com) to do secondary hosting for up to 100 domains. --Ben Doom Dave Hatz wrote: I am looking for recommendations on a company to host our DNS. We are currently using Internap's CoLocation services and their DNS went down again. 3rd time in less than 2 months. Our customers are pissed and I don't blame them. I need to find another solution and always value the recommendations from this list. Thanks, Dave Hatz ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297570 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Keep session alive for form
I would advise against storing user data in a literal way in a cookie. We ran into a situation where the user's ID was stored in a cookie. By changing the cookie, I could impersonate any user. Client variables (you're using a DB for them, right?) might be a good way to avoid that, though, since they don't store an easily recognizable or fudgable ID (like the auto-incremented ID key for users 0-:) --Ben Doom Dennis Powers wrote: therefore I have a max session timeout of 20 minutes. we store username in their session My problem lies with a user typing and typing and going over their timeout limit of 20 min. I ran into a similar problem with a website where people would start something get interrupted leave the page open come back finish and submit only to find the session had expired and the work seemd lost beasue they had to login again. Javascript keep alive was unreliable so I had to re-think the authentication plan and eventually changed it to store the login information in a cookie. That way once they logged in they they could take as long as they wanted because if the session expired the application would log them back from the cookie information and accept the post. Best Regards, Dennis Powers UXB Internet - A website design and Hosting Company 690 Wolcott Road P.O. Box 6029 Wolcott, CT� 06716 Tel: (203)879-2844 http://www.uxbinternet.com/ http://www.uxb.net/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297072 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: writing insert query sql in coldfusion
Well, the biggest reason is that it provides significant protection against SQL injection attacks. It basically does in-line data validation. There have been several discussions here on the list of the various benefits, so a quick search at the HoF site should give you a good idea about it. --Ben Doom Richard White wrote: Also, alot of people will advise you to use cfqueryparam (me included), so the code would look like: out of interest what is the difference in using the cfqueryparam and not? thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296977 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: White Space Eliminator
If you are going to use regular expressions to reduce whitespace, I'd probably use something like rereplace(text, \s+, , all); However, I would look carefully at whether this actually speeds up delivery. Full-fledged regex engines are slow, and there are several faster replacement engines designed specifically for reducing the size of web pages. Also, bandwidth is cheap. :-) --Ben Doom Nate Willard wrote: hello, I learned of of an issue with my whitespace reduction method that is almost funny. I do the following to remove whitespace cfsavecontent variable=pageholder_tboutputed PAGE CONTENTS... /cfsavecontent cfset pageholder_tboutputed =REReplace(pageholder_tboutputed, [[:space:]]{2,},,ALL) CFOUTPUT#pageholder_tboutputed#/CFOUTPUT What ended up happening today is that one of the sources I pull in information from had double spaced between words. so instead of the The bear went home they had The bear went home which caused my method to output Thebearwent home Is there any way around this? Or do I need to remove my whitespace method for the time being? Thxs ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297032 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: White Space Eliminator
\s* is probably not what you want. * means 0 or more so it would insert a space between every character. I would use \s+ or \s{2,} instead. --Ben Doom Sonny Savage wrote: How about this? cfset pageholder_tboutputed = REReplace(pageholder_tboutputed, \s*, , ALL) On Jan 21, 2008 3:13 PM, Nate Willard [EMAIL PROTECTED] wrote: hello, I learned of of an issue with my whitespace reduction method that is almost funny. I do the following to remove whitespace cfsavecontent variable=pageholder_tboutputed PAGE CONTENTS... /cfsavecontent cfset pageholder_tboutputed =REReplace(pageholder_tboutputed, [[:space:]]{2,},,ALL) CFOUTPUT#pageholder_tboutputed#/CFOUTPUT What ended up happening today is that one of the sources I pull in information from had double spaced between words. so instead of the The bear went home they had The bear went home which caused my method to output Thebearwent home Is there any way around this? Or do I need to remove my whitespace method for the time being? Thxs ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:297033 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 css/flash question.
Offhand, it looks like you aren't closing your object block. --Ben Doom Mark Fuqua wrote: I'm using a template from freetemplates.com. The css file seems quite well done. I want to replace an image with a small flash movie. I thought I would just eliminate the image, and embed the movie in the html page. However, when I just put the movie on the page, as is or in between two div tags, it will display, but nothing on the page below it will. Here is the code from the page with the swf: !DOCTYPE html PUBLIC -//W3C//DTD XHTML 1.1//EN http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd; html head meta http-equiv=content-type content=text/html; charset=iso-8859-1/ meta name=description content=description/ meta name=keywords content=keywords/ meta name=author content=author/ link rel=stylesheet type=text/css href=default.css/ titlePyramid Home Works/title /head body div class=main div class=gfxh1Pyramid Homeworks/h1/div object classid=clsid:d27cdb6e-ae6d-11cf-96b8-44455354 codebase=http://fpdownload.macromedia.com/pub/shockwave/cabs/flash/swflash. cab#version=8,0,0,0 width=766 height=250 id=pyramidHeader6 align=middle param name=allowScriptAccess value=sameDomain / param name=movie value=pyramidHeader6.swf /param name=quality value=high /param name=bgcolor value=#141a27 /embed src=pyramidHeader6.swf quality=high bgcolor=#141a27 width=766 height=250 name=pyramidHeader6 align=middle allowScriptAccess=sameDomain type=application/x-shockwave-flash pluginspage=http://www.macromedia.com/go/getflashplayer; / div class=menu a href=index.htmlspanHome/span/a a href=index.htmlspanAbout Us/span/a a href=index.htmlspanGallery/span/a a href=index.htmlspanContact Us/span/a a href=login/LoginForm.cfm id=lastspanCustomer Log In/span/a /div div class=content div class=item ..page content continues. It doesn't seem to matter whether the flash object is wrapped in div tags or not, everything below the movies goes away. If I could grow a brain real fast, what I'd really like to do is replace the image in the div class =gfx referenced on this page to the css template. The class on the css template looks like so: /* Header */ ..gfx { background: #222 url(img/dark_pixel.jpg) no-repeat; height: 240px; But, one way or the other, what I'd really like to do is get the swf to show along with the other content below it. Thanks, Mark ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296746 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Training a new programmer
I'd pick something non-time-critical and non-mission-critical and, as it were, throw him in the shallow end. Give him all the help he asks for. Do a code review. Pick something more important, wash, rinse, repeat. --Ben Doom Ian Rutherford wrote: I have an employee who has tinkered around with CF and Javascript and is familiar with HTML basics. He has expressed interest in learning more and getting more involved in the actual programming for the company. Any suggestions on how best to go about training him? I've got books galore but I'm not sure how best to introduce him to frameworks, OOP and CF as a cohesive whole. Thanks, Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296690 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help!!!
I think between Rey and Charlie, the correct answer (talk to your host) has already been provided. I will add this: more people on this list will read your post if you use a more descriptive subject. Honestly, I only read it by mistake. I usually skip any thread that doesn't tell me whether I'm likely to be able to help based on the topic. --Ben Doom greg coleman wrote: hi, I am trying to install and configure Adobe Coldfusion to add dynamic content to my website. The problem is, i don't know how to configure coldfusion to work with my webhost's mysql, it is only setup to work with the built in server. What i want it to be able to do is when i upload it through dreamweaver, to be able to work with my mysql setup that i have with my webhost. can anyone help me with that? apparently, lynda.com is only concerned with showing you how to work with coldfusion on with it's self contained server. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296532 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Email Validation Question, Possible RegEx required?
Once you've broken the list into individual elements, I'd use something like: email = rereplace(element, '.*(.*?)', '\1') This replaces everything before the open bracket, the open bracket, and the end bracket with just what is in between the brackets. --Ben Doom Nate Willard wrote: Morning, I'm currently working to add an address book importer (PLAXO) to a site. The address book importer returns the emails in the input box as follows: FNAME LNAME [EMAIL PROTECTED], FNAME LNAME [EMAIL PROTECTED], FNAME LNAME [EMAIL PROTECTED], I'd like to come up with a way to take that input and CFMAIL out to the user's inputted addresses. Problem is, isValid(email) will reject everything above. I think what needs to happen is I need to delete everything between the brackets including the brackets, and then take just what is between the quotes, leaving [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED] Which I can then cfloop through a cftry and mail out... Would that work? Can anyone suggest a better way to handle this situation. If that would work how would I go about doing that? Thanks, N ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Some help on defining passing a parameter in text HTML?
Without some kind of server-side processing (PHP, ColdFusion, etc.) or some fancy JavaScript, you aren't going to be able to display a URL variable. Raw HTML can't do that. --Ben Doom ismail cassiem wrote: Hi, I need help please i usually code in coldfusion but now i want to create 2 text html files where i pass a parameter on href? This normally works in coldfusion! Page1 a href=test.htm?test=100','','height=300,width=300 Page2 html head param name=test value=/ /head body cfoutput #test# /cfoutput /body /html Please Assist! Regards ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296251 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFFILE
If the file is on a shared drive, and the user CF runs as has access to that drive, then CFFile can access it. If that's not possible, you could set up FTP access and use cfftp (which would allow you to read/write it, instead of just read with cfhhtp). --Ben Doom Orlini, Robert wrote: Is there a way for CFFile to find a file not on the local server? For example to find a file on the c:\ drive on another server? Can the source be \\server\c$ cffile action=copy source=\\server\c$\accessLog.txt destination=C:\docs\accessLog_backup.txt If not, are there any CF tags or commands that can do this? CFHTTP? Thx. RO HWW ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296140 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: DNS question...
You want all the domains to redirect to a single domain? I'm not sure how to do it in IIS, but if you are on a private IIS install, you could set the default website to redirect to the correct domain, and then set the domain's web site separately. --Ben Doom Che Vilnonis wrote: I have about 75 domains that a client wants to point to one single domain. Is there an easy way (using M$ DNS Server) to configure all of these domains to point to one domain w/o a separate entry for each? TIA, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296002 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: DNS question...
So you want to point multiple domains to the same IP, but not necessarily redirect them? I don't know of a way in MS DNS. I know there is a way in BIND. I've seen an option for MS DNS on 2k3 to store the info in files only, so you may be able to cp the files, renaming them appropriately to create the new zones. --Ben Doom Che Vilnonis wrote: This isn't an IIS question, but a DNS server question. Basically, I don't want to create 75 new zones on the DNS Server. Dos this make more sense? -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, January 07, 2008 11:33 AM To: CF-Talk Subject: Re: OT: DNS question... You want all the domains to redirect to a single domain? I'm not sure how to do it in IIS, but if you are on a private IIS install, you could set the default website to redirect to the correct domain, and then set the domain's web site separately. --Ben Doom Che Vilnonis wrote: I have about 75 domains that a client wants to point to one single domain. Is there an easy way (using M$ DNS Server) to configure all of these domains to point to one domain w/o a separate entry for each? TIA, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296012 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: DNS question...
I think bad is probably a good summary. I know Google, for one, punishes multiple sites with the same or substantially similar (ie, different nav, or CSS) content. --Ben Doom Adrian Lynch wrote: Can anyone comment on the SEO ramifications of pointing mulitple domains at the same site rather than 301 redirecting them? Adrian -Original Message- From: Ben Doom Sent: 07 January 2008 17:05 To: CF-Talk Subject: Re: OT: DNS question... So you want to point multiple domains to the same IP, but not necessarily redirect them? I don't know of a way in MS DNS. I know there is a way in BIND. I've seen an option for MS DNS on 2k3 to store the info in files only, so you may be able to cp the files, renaming them appropriately to create the new zones. --Ben Doom Che Vilnonis wrote: This isn't an IIS question, but a DNS server question. Basically, I don't want to create 75 new zones on the DNS Server. Dos this make more sense? -Original Message- From: Ben Doom Sent: Monday, January 07, 2008 11:33 AM To: CF-Talk Subject: Re: OT: DNS question... You want all the domains to redirect to a single domain? I'm not sure how to do it in IIS, but if you are on a private IIS install, you could set the default website to redirect to the correct domain, and then set the domain's web site separately. --Ben Doom Che Vilnonis wrote: I have about 75 domains that a client wants to point to one single domain. Is there an easy way (using M$ DNS Server) to configure all of these domains to point to one domain w/o a separate entry for each? TIA, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:296023 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: sql clear data
This seems kind of odd. Why not just delete the row? --Ben Doom Chad Gray wrote: Is there anyway to clear the data in a row in a database without using UPDATE table SET foo = '', Moo = '', Goo = '' WHERE ID = 1 I don't want to clear the ID just the other fields. My table has 50 fields and I don't feel like typing out all of them and setting them to blank. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295835 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: sql clear data
He wants to clear all *columns*, not rows. --Ben Doom Greg Morphis wrote: UPDATE table SET foo = '', Moo = '', Goo = '' leave out the WHERE clause.. it'll empty all rows On Jan 4, 2008 9:47 AM, Chad Gray [EMAIL PROTECTED] wrote: Is there anyway to clear the data in a row in a database without using UPDATE table SET foo = '', Moo = '', Goo = '' WHERE ID = 1 I don't want to clear the ID just the other fields. My table has 50 fields and I don't feel like typing out all of them and setting them to blank. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295841 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: stuck with a loop count
Every time you loop through the query, you reset your total variable. You may need two -- one for this loop, and one for the complete total. --Ben Doom Dr. Who wrote: i am having a problem trying to get the results of a count in a loop. could use another set of eyes.. results VTodd :: 962 STetreault :: 342 RDoe :: 839 ASchmit :: 379 TotalLeads 379 758 1137 1516 1516 it loops through the last result 4 times should result in: 2522 not 1516 code... cfoutput query=get_Sales group=Market h3cfif get_Sales.Market IS 1 Industrial Sales Reps cfelse IT Sales Reps /cfif/h3 cfoutput group=Manager h4#get_Sales.Manager#/h4 h5Name - Total Leads - Rep Company/h5 cfoutput cfquery datasource=#request.dsn# name=get_leads Select Count(*) AS total From Leads WHERE r_agn = #get_Sales.usr_id# /cfquery #get_Sales.Fname# #get_Sales.usr_lname# :: #get_leads.total#br br /cfoutputTotalLeadsbr cfset sumTotal = 0 cfloop query=get_leads cfoutput CFSET sumTotal = #sumTotal# + #get_leads.total# #sumTotal#/cfoutput /cfloop br span class=style1#sumTotal#/span/cfoutput/cfoutput ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295874 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CF 5 and DAO
We always used includes, although cfmodule would probably be better. We just broke each inline query out into an include, then called it as necessary. --Ben Doom Chad Gray wrote: I am so use to using MX and CFCs that now I have to work on a CF5 server for a client and Is there a good way of setting up a DAO in CF5 so I can reuse SQL code and not have to retype the CFQueryies each time I need them? Should I use CFModule? CFInclude? A custom tag CF_ProductDAO? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295755 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In Theory - Returning to a Search Results Page Question
Here's a suggestion: store either the search query or the search conditions (depending on whether you want to be able to display them again, etc) in the user's session. Break step 2 into two separate parts -- store the data, then search based on it. Then, when you need to re-display the results page with the updated results, you don't try to re-store the session info, just re-run the stored search. --Ben Doom Les Mizzell wrote: I've got a search page on an admin system - maybe 20 different search parameters that can be used in combination. Once the results are returned, I need to be able to delete/archive/edit records from the returned set. So far, no problem. But, once I delete/archive/edit a specific record, I need to return to the search results page showing exactly what was returned before minus whatever was deleted/archived. Looking for a compact way of handling this. Really kludgy way of doing it (but works) - just keep passing the original search form parameters around in hidden fields. But, that's a lot of crap to keep up with. --- Basic flow: 1. Search page 2. action page (run search query) 3. Results page - make decisions (edit/delete/archive) If delete/archive 4. Action page (delete/archive record) 5. Return to #3 for more decisions (need to pass all form params from #1 back to page again to return original results) If edit 4. Record edit page 5. Action page - (update record) 6. Return to #3 for more decisions (need to pass all form params from #1 back to page again to return original results) -- Ideas? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295256 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Help on regex pattern in refindnocase
Inside a set of brackets, you have a character class. What a character class indicates is one of these or, with the ^ at the beginning, not one of these. Here, your parentheses have no meaning, other than they are not allowed. You also are only matching one, not many, characters. So ).gif will return a hit. You also are using a dot as a ... well, a dot. However, it's a special character that means any one character in a regular expression. You need to escape it: \. You're getting results here, because your one character happens to be a dot, but if your name was z#gif, it would also match. One possible solution might be to find all the .gif references, and then check each one to see if it's blank.gif. Not necessarily elegant, but it would work. --Ben Doom Kris Jones wrote: Not being a big regex wizard, I'm sure I'm missing something basic here. I'm trying to check some content for existence of gif images that are not named blank.gif. My if statement looks like: cfif refindnocase([^(blank)].gif,#somestring#) gt 0 However, this is not accounting for any gif where the filename prior to the extension ends in b, l, a, n, or k, such that join.gif or nob.gif or kak.gif would be eliminated from the find return. I thought the parenthesis indicated literal string, so I'm a little lost. Can anyone explain? Please... Cheers, Kris ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295264 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Another RegEx question...
The first thing I see is that you are only allowing for single-character names. You don't have a + or * (+ would be better) after [a-z0-9_]. There may be more, but that's what I see at first glance. --Ben Doom Che Vilnonis wrote: In a sea of data, I need to pull the first image tag. It looks like this... img src=http://images.craigslist.org/01010001150701030720071219cd6f3ea36b5b712d 2f00d0d9.jpg I am using... cfset imageLink = REReplaceNoCase(cfhttp.fileContent, img[^]+(\.(?:jpg|jpeg|gif|png))[^]*, , ONE) But it does not work. Can anyone help? Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: RegEx Tools
No. My brain is not online ... yet! Just so you know -- tools can be useful, but like everything (computer generated code, translations, whatever) people-skills will sometimes yeild a more efficient or easier-to-work-with solution. Also, I'm a snob about my regex. --Ben The Regex Ninja Doom Che Vilnonis wrote: Question, are there any online RegEx tools out there that will allow me to paste a url, for example, http://atlanta.craigslist.org/car/514214963.html, ask what data I need returned, and give me the RegEx necessary to get back just atlanta or any other city I need? Thanks, Che ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295139 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFDOCUMENT creating a PDF - ARGH!
I found I got better results with CSS by cfinluding the file into a style block, instead of doing what you did. HTH. --Ben Doom Les Mizzell wrote: I'm trying to use CFDOCUMENT (CF 7 with updates) to create PDF files for a client. If I remove the CFDOCUMENT tags surrounding my code, the page renders fine. Put the CFDOCUMENT back in and the page falls apart - CSS is ignored. So, I've got something wrong somewhere. Is the basic format for creating a PDF page below correct? Is the problem the way the CSS file is referenced? How else should I try to do that? --- START OF TEMPLATE - QUERIES HERE- cfdocument format=PDF mimetype=text/html html xmlns=http://www.w3.org/1999/xhtml; head link rel=stylesheet type=text/css href=css/makePDF.css / /head body - OUTPUT BLOCK - STANDARD CFOUTPUT AND STUFF - /body /html /cfdocument -- END OF TEMPLATE - ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295007 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Compare two tables
I don't think you can do a subselect in a QofQ (someone correct me if I'm wrong) so I think the easiest thing would be to pull both in and then walk the arrays. Brute force and inelegant, but is this something you need to do once, or is this something that must be done often? --Ben Doom Ian Skinner wrote: Anybody have a creative way to compare data in two tables and find all records in table A not in table B and vice-a-versa. The data share a common key, 'License Number'. The trick -- Table A is in an MS Access Database and Table B is in a MS SQL server database. They are not aware of each other and we can not import the Access data into the SQL database at this time at least. TIA Ian ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294801 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: or statement problems
Because the implication was that his mistake was a lack of knowledge about CF, not a logic mistake that would have affected him regardless of language. I'm pretty sure that the other two statements are the same thing in other languages -- PHP and ASP, if I had to guess. --Ben Todd wrote: Why? This only works within a cfscript block. cfset stuff = 1 cfset stuff2 = 1 cfif stuff != stuff2 cfset foo = boo! cfelse cfset foo = yay! /cfif cfdump var=#foo# On Dec 13, 2007 11:06 AM, Azadi Saryev [EMAIL PROTECTED] wrote: Thank you Ian. I was literally foaming @ some of the responses before you came in... --- Azadi Saryev Sabai-dee.com http://www.sabai-dee.com ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294719 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFEclipse Key mappings
Why not just copy over your Eclipse folder? Then, *all* your settings, plugins, etc. would be the same. --BenD Dave Hatz wrote: I am using CFEclipse v3.3.0 and I am trying to install CFEclipse on a new laptop. I want to keep all my settings. I have been able to copy over my snippets, but I can not find where the Key Mappings are located. Can someone point me in the right location for the mappings? Thanks, Dave Hatz ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294618 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Filemaker Pro
Years ago, I helped develop a solution with CF7 and FMP8. It's possible, but the performance was horrible. You have to connect via a system ODBC (at least, on Win2k3 server) and FMP just wasn't up to the task of serving any sort of query except a direct dump. I'd suggest to the client that they move to a more internet-ready DB. --Ben Doom Matt Williams wrote: A client has a pre-built system on Filemaker Pro 9. The db is hosted. The website is on a different host. Am I able to remotely query that db with CF? If so, what is involved? Does the Filemaker host need to do anything special other than provide me with the IP, db and login info? I'm guessing I would need the Filemaker JDBC driver installed on the CF server. Any pointers are appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294637 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: can't use the result of a regular expression as a variable?
CF evaluates the replace string *before* sending it to the regular expression engine. Therefore, it's trying to find the struct key named '\1' which is not legal. There are several ways to get around this, but they all basically boil down to doing it in two steps. --BenD Johnny Le wrote: I tried to do this: cfset thestring = user.listid={id}username={username}/ cfset reReplace(thestring,'\w*{(\w+)}','#qryUser[\1]#','all')/ but I got an error. Is it possible to use \1 as a variable? I even tried '#evaluate(qryUser[\1])# but it doesn't work. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294152 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: finding a substring in string, target attribute of an anchor tag
I think your regex thought was probably good. If you don't need to keep any style or class on them, the easiest thing would be to find the whole anchor, grab the url, and replace the whole shebang with the url inserted into a preformatted anchor tag. If you do need to preserve other attributes, I'd do a find for the whole tag, the search that substring for a target attribute, then either replace or add as necessary. Make sense? --Ben Doom Andy Matthews wrote: I have a variable containing a string in which might appear any number of links to to kbb.com: a href=http://www.kbb.com/kb/ki.dll/kw.kc.uy?dlr3 http://www.kbb.com/kb/ki.dll/kw.kc.uy?dlr3amp;;tamp;21amp;amp amp;;tamp;21amp;amp; target=mainsome text/a I need to programmatically find each anchor tag with said link, then force it's target attribute to be target=_blank. I originally thought I could do it with regex but I don't think that's going to work. I was thinking that I could get the kbb.com's starting position, then find the next instance of target, then work from there. Might you chaps have a better/more efficient means to do this? Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:294155 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cffile destination
You could use something like #expandpath('..')#/tempUploads to do that. expandpath() can be *very* useful sometimes. :-) --Ben Doom Richard White wrote: hi, i am creating an upload facility using the cffile tag. from all i have read it seems that the destination attribute needs to have the full address to where the file will be saved to. however i want to specify that it goes into a file on the wwwroot without specifying the full address e.g. (C:\ColdFusion8\wwwroot\appName\tempUploads) This would obviously be different if i were uploading it onto our web server. usually referencing files i would simply put (../tempUploads) so is there anyway i can get it to still do this, without knowing the full path of where it needs to be stored thanks ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293485 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: blocking spambots
Which is more or less what I meant by variant. --Ben Doom Larry Lyons wrote: Always use CAPTCHA or a variant when possible. Check the referrer. nofollow links and moderate, or nofollow unmoderated links. --Ben Doom Unfortunately most captchas are not accessible, no text reader can work with them. One idea is to ask for the nth last word in this sentance (eg, What is the Fifth last word in this sentance? answer last). While not foolproof, its far more likely that a person can answer the question correctly than a bot. regards, larry ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293500 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: url variables not picked up in url with # anchor
Off the top of my head, I think the #anchor has to come last. Everything after the pound sign is read as part of the anchor directive. So, page.cfm?foo=1#test should work. Not tested, YMMV. --Ben Doom Will Swain wrote: Can anyone help with this. This may be common knowledge but I've never come up against it before. http://www.site.com/page.cfm#test?foo=1 CF doesn't see the url variable on the end of the url. The CGI.ScriptName doesn't include it, in fact I can't see it included in any CGI variable. Is there a way of grabbing the url variable in these cases (where there is a # in the url), or will it simply not work? Oh, this is on IIS6 + CF 7.0.2 Thanks Will ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293373 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using reReplace Backreference as StructKey or Argument
Sorry, you can't do that. Here's why: Coldfusion hands strings off to the regex engine. CF allows you to used functions, variables, etc. in the string, but it executes them *before* the regex runs. So, in your first code sample, it's trying to find the literal key \1 in appSettings, and then passing the result as the replace value. --Ben Doom Jon Clausen wrote: I'm sure it's something simple that I'm missing, but I want to use a regex backreference as the struct key (i.e. - struct[key]) or as an argument (i.e. - function(argument) ) but I've failed in all my attempts so far. For now I've written the code out using a loop with reFind(), returning subexpressions, mid(), etc. but it seems to me there should be a way to do this using reReplace() and pass the backreference as an argument/key. Usage of evaluate() would probably be a deal-breaker since it would be less expensive to perform the loop. Here's examples of what i'm trying to do: !--- Trying to use backref passed as struct key --- cfset pageOut = reReplace(pageContent,%show:([a-zA-Z0-9_]+) %,appSettings[\1],ALL)/ !--- Trying to use backref passed as argument --- cfset pageOut = reReplace(pageContent,%getModule:([a-zA-Z0-9_]+) %,controller.getModule(\1),ALL)/ Thoughts? Jon ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293375 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Cfoutput query backwards
You could try something like: cfoutput cfloop from=#query.recordcount# to=1 index=i #query[column][i]# /cfloop /cfoutput I may have swapped column and i -- I can never remember if it's a struct of arrays or an array of structs. :-\ --Ben Doom Tom King wrote: Hi All, Is there a way of outputting a Query in cfoutput in reverse without creating another query, or adding rows to the query, and with no numerical index? I have a manual query object created, with galleryId, and galleryName, but GalleryID is not a sequential number sequence nor alphabetical, so ORDER BY galleryID doesn't have the correct effect; ie. values might be: IDName 2007_foo Foobar 2007_abc FooFoo Obviously, when I CFDUMP the query, you get CF's ID in the column, and outputting QueryName.currentrow will give you a sequential numerical list, but I want CF to output that Query in reverse! Any ideas? Thanks T ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293386 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: blocking spambots
The smarter ones may be. Some may (gasp) actually post a correct referrer. But some will be caught. I figure the idea is not to stop them all, but to stop enough that the remainder can be handled manually (or by some other process). --Ben Doom Tom Chiverton wrote: On Wednesday 14 Nov 2007, Ben Doom wrote: Check the referrer. Aren't spambots faking that these days ? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293374 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: In a bind
IIRC, in IE the onChange does not fire until the form element loses focus. I think if you change the event to onClick, it will work the way you want. --BenD Brian McCairn wrote: When you click on a radio button clicking anywhere else on the browser seems to trigger ther bind to work. What have I done wrong? ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293411 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex Gunslingers
Pretty slick. --Ben Doom Ben Nadel wrote: A while back I wrote a custom tag for iterating over regular expression patterns. I think this would be a great use for it. I wrote up an example based on the proposed question: http://www.bennadel.com/blog/1037-RELoop-ColdFusion-Custom-Tag-Case-Stud y.htm Or - http://bennadel.com/index.cfm?dax=blog:1037.view ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293286 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: What I need to Develop a standalone application on my LAPTOP usiong COLDFUSION?
You do not NEED CFEclipse to develop in CF. However, it is a great tool for it. I prefer it over Dreamweaver, as do many other people here. CF Developer Edition will allow you to run your application locally, after which you can deploy the source code to a production CF server. Developer Edition is simply a locked down version of the full server, limiting the number of IPs that can connect to it. --Ben Doom sandeep saini wrote: Hey thanks Scott, So i need Eclipse and CFEclipse in place of Dreamveawer (means for writhing CF files..) But i am not getting which component will serve as a COLD FUSION server. Is it Developer Edition ? which was told by Todd :-( Soory i am a little cfDUMP :-) Also i want to let you know that I am having dreamveawer 7 . So do i still need Eclipse and/or CFEclipse ? Also from Standalone i mean..that i want to create a CF application on my laptop. there after when its done i would like to deploy it on some servers (on the web). Please reply.. thanks all ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293318 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: blocking spambots
Always use CAPTCHA or a variant when possible. Check the referrer. nofollow links and moderate, or nofollow unmoderated links. --Ben Doom Mike Little wrote: hi guys, it appears my addcomments.cfm page has become indexed in google. usually this page is only accessed when a user goes clicks a link from the articles.cfm page. so... because of the endless spam we are currently getting, i am assuming the spambots are going directly to the addcomment page? now, i had an idea - what if on the addcomment page, i test that the user has come from the articles page using CGI.HTTP_referrer?? (i have also now added the addcomment.cfm page to my robots page and used the google remove url tool). any thoughts would be appreciated. mike ps. we use the cffromprotect tool and it works brilliantly. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293336 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Using includes to build pages
It is, technically, slower. However, this slowdown is likely not even measurable in milliseconds. Honestly, I wouldn't worry about the performance. The ease of building/altering/updating the site pays for the shaved milliseconds very quickly. --Ben Doom Tim Ashworth wrote: Hi, Just a quick newbie question - how does using includes affect the way that a site performs? If I've got a page that has 7 includes - header in one, content in another, etc. Is this worse than having a page that is compiled from only 2 or 3? Cheers Tim ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293319 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Replace Syntax
replace(form.description not replace('form.description'... form.description is the variable, 'form.description' is a string with the name of the variable. --Ben Doom Rick Sanders wrote: Hey list, I'm trying to replace double quotes for single quotes in a string using this syntax: #Replace('form.description','',',ALL)# However, it's giving back form.description in the output and not the actual text from the textfield named description. What am I doing wrong? Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293208 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regex Gunslingers
Actually, that's not all that easy. Regex is great for tokenizing, but not parsing. There are ways to determine whether or not you are inside quotes, but in my experience, looping usually gives you the best results -- especially when the text is not precicely what you expect. For example, quotes doubled to escape them, unclosed quotes, etc. --Ben Doom Josh Nathanson wrote: Hey all, Got a regex challenge...I was able to solve it using an REFind and then REReplace, but I'm wondering if anyone can come with a one-shot way to replace without looping. I need to remove any carriage returns within a quoted string, but not touch them if they are outside quotes. So: the quick brown fox \r\n jumps over the \r\n lazy dog -- remove the \r\n's My name is mud \r\n -- leave this one alone I'm sure this is probably easy for the regex gurus... -- Josh ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: ASCII String Value
You could use mid(mystring, i, 1) which returns a substring starting at i and 1 long. --Ben Doom Richard White wrote: Hi, I have a javascript function that checks for any unwanted string character values - such as \ or / etc... In Javascript i loop through the length of the string and use the code: myString.charCodeAt(i) // this gives me the asci value for the character so i can test if it is an unwanted character is there any similar function in coldfusion? Thanks very much Richard ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293253 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reuse regular sub-expression in larger expression
There may be a way, but I've not run across it yet. If you are really intent on it, you could simplify it using CF itself. cfset thing = -?[\w,.]+ and then use \(#thing#/#thing#\) For something this trivial, it seems a bit pointless, but for large and complicated subexpressions, it might be worthwhile. I know that I often do something like this for linebreaks so that I can easily change which linebreak I'm using, and not have to make sure I get every instance. :-) What can I say -- I'm lazy. --Ben Doom Andy Matthews wrote: Adam Howitt wrote a blog post asking for improvements to a regex that he wrote: http://tinyurl.com/yvzxjk This is what I came up with: \(-?[\w,.]+/-?[\w,.]+\) But I'm wondering if it's possible to reuse the first portion of the expression, rather than writing the same exact thing twice in one string. So rather than this: \(-?[\w,.]+/-?[\w,.]+\) I could have this: \((-?[\w,.]+)/\1\) or something like that. I could swear that I've seen someone do this before. Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293039 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Reuse regular sub-expression in larger expression
IIRC, this only works if you want the same string for both matches. I don't think that is what Andy wanted. --Ben Doom Barney Boisvert wrote: Yeah, you can do that. Here's a simple example of it in action (using the backreference to match quotes). It also uses a non-greedy modifier in there to avoid doing an incorrect match on the apostrophe within the double quotes. cheers, barneyb cfoutput cfset baseString = some 'text' with quotes an' some apostrophes in it / h2Quoted Strings within #baseString#/h2 ul cfset start = 1 / cfloop condition=true cfset result = REFind((['])(.*?)\1, baseString, start, true) / cfif result.pos[1] LT 1 cfbreak / /cfif cfset string = mid(baseString, result.pos[3], result.len[3]) / cfset quote = mid(baseString, result.pos[2], result.len[2]) / cfset start = result.pos[1] + result.len[1] / li#string# (quoted with #quote#)/li /cfloop /ul /cfoutput On Nov 8, 2007 2:16 PM, Andy Matthews [EMAIL PROTECTED] wrote: Adam Howitt wrote a blog post asking for improvements to a regex that he wrote: http://tinyurl.com/yvzxjk This is what I came up with: \(-?[\w,.]+/-?[\w,.]+\) But I'm wondering if it's possible to reuse the first portion of the expression, rather than writing the same exact thing twice in one string. So rather than this: \(-?[\w,.]+/-?[\w,.]+\) I could have this: \((-?[\w,.]+)/\1\) or something like that. I could swear that I've seen someone do this before. Andy Matthews ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:293037 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: changing a css file via coldfusion
Well, you could store which stylesheet they are using in a session variable, change it when the click the links, and include it dynamically. There are lots of other ways to do it, but in lieu of more info, that's what I would suggest. --Ben Doom John P wrote: Is it possible create a way using coldfusion which would allow the user to change the current page style by selecting a link on the page? Seems like it shouldn't be to difficult, I just can't think of how to do it. Thanks, John ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292963 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Wierd regex problem (isn't it always)
A handful of comments: Backreferencing a single, static character is silly. It just wastes memory and processor time. You're throwing it away, anyway. {1} is useless. It means one of. Which would just be the thing by itself. Second, {1,} is more commonly written +. Also, you are saying one or more backreferenced things instead of one or more backreferenced things. I'd write it like this: @([a-zA-Z0-9]+) Then use the first backreference instead of the second. --Ben Doom Andy Jarrett wrote: Hi I'm trying to do a look through as string to find usernames and add a tags around them ala Twitter. The regex I think is fine but when I use reReplace 's back reference I'm not getting the result I thought I would of. Heres the code. Can anyone see anything obvious? Cheers, Andy !--- String to be manipulated --- cfset str = First username is @andrew and second is @jarrett / cfoutputp#str#/p/cfoutput !--- The Regex (@){1} - First back reference is the @ sign. Look for one of these ([a-zA-Z0-9]){1,} - Second back reference is the username --- cfset reg = (@){1}([a-zA-Z0-9]){1,} / !--- Using reReplace we take the second back reference and wrap an a tag around it --- cfset usernamePos = reReplace(str, reg, @a href='test'\2/a, all) cfoutput#usernamePos#/cfoutput ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292878 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regex search problem
No, you're right about the all. I'm confusing the refind() and rereplace() syntax. But, yes. By using a regex in the condition, you are running it twice per loop. --Ben Doom Bobby Hartsfield wrote: The option is called 'returnsubexpressions' and valid values are true or false. You can only return one instance of a match with refind() (and possibly one instance of a sub expression match if you use parens in the expression). To get more, you have to run the function again with a different starting position (I chose to change the string rather than the starting position). At least that's what the docs say. Do you have a working example of what you are talking about with 'all' because if you can get them all at once... that would be very nice to say the least. I also don't see how I'm running it twice per loop unless you are counting the actual condition of the loop? ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292742 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFC Not acting like I expect
I'm not seeing where you are actually assigning the return from your SP to propID. foo is not a query. --Ben Doom Bruce Sorge wrote: I have a CFC that both inserts a series of field variables and returns the ID number that was just created. I am getting an error that states the value returned from the insertProposal function is not of type query. Here is the function: cffunction name=insertProposal access=public returntype=query cfargument name=BidType type=string required=yes cfargument name=Number type=string required=yes cfargument name=Description type=string required=yes cfargument name=Contact_Name type=string required=yes cfargument name=Contact_Phone type=string required=yes cfargument name=Contact_Email type=string required=yes cfargument name=Job_Walk_Date type=string required=yes cfargument name=Job_Walk_Time type=string required=yes cfargument name=Status type=numeric required=yes cfargument name=Create_Date type=date required=yes cfargument name=Create_Time type=string required=yes cfset propID=foo cfstoredproc procedure=pr_InsertRFP datasource=#Request.dsn# cfprocparam cfsqltype=cf_sql_varchar dbvarname=BidType type=in value=#Arguments.BidType# cfprocparam cfsqltype=cf_sql_varchar dbvarname=Number type=in value=#Arguments.Number# cfprocparam cfsqltype=cf_sql_longvarchar dbvarname=Description value=#Arguments.Description# cfprocparam cfsqltype=cf_sql_varchar dbvarname=Contact_Name type=in value=#Arguments.Contact_Name# cfprocparam cfsqltype=cf_sql_varchar dbvarname=Contact_Phone type=in value=#Arguments.Contact_Phone# cfprocparam cfsqltype=cf_sql_varchar dbvarname=Contact_Email type=in value=#Arguments.Contact_Email# cfprocparam cfsqltype=cf_sql_date dbvarname=Job_Walk_Date type=in value=#Arguments.Job_Walk_Date# cfprocparam cfsqltype=cf_sql_time dbvarname=Job_Walk_Time type=in value=#Arguments.Job_Walk_Time# cfprocparam cfsqltype=cf_sql_integer dbvarname=Status type=in value=#Arguments.Status# cfprocparam cfsqltype=cf_sql_date dbvarname=Create_Date type=in value=#Arguments.Create_Date# cfprocparam cfsqltype=cf_sql_time dbvarname=Create_Time type=in value=#Arguments.Create_Time# /cfstoredproc cfreturn propID /cffunction When I run the page, the insert query works. I captured the SP in SQL Profiler, copied it into a new query in SQL Server Manager, and it inserts the information and returns the newly created ID as it should, so I am baffeled. Perhaps I need another pair of eyes to see what might end up being a glaringly obvious error on my part. Thanks, Bruce ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292778 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex search problem
Here's what I usually do: cfscript loc = refind(text, thing, 1, 1); while (loc.pos[1]) { //do stuff loc = refind(text, thing, 1, loc.pos[1]+loc.len[1]); } /cfscript It's 1 extra line of code, but it means only doing n+1 searches, where n is the number of loops. --Ben Doom Bobby Hartsfield wrote: Ahh... I was REALLY hoping you were right about that. That would have been great. In any event, I learned something new about refind() so thanks! I'll always think of you and the time we shared in this thread when I use it. hehe As for running the regex twice... Since looping a space delimited list would make ME weep... this is the only other way I could think of ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292784 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Question about writeToBrowser image action...
Custom CAPTCA applications. On-the-fly resizing. --Ben Doom Rick Faircloth wrote: What would be the possible use(es) of the writeToBrowser image action? Rick ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292667 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex search problem
You can do an refind(text, \d+, 1, all) refind in text digits starting at position one find all This will return an array of structs with keys pos and len. Pos is the start position, and len is the length. You can then use mid() to grab them. --Ben Doom Web Exp wrote: Thanks Ray... Ok... I guess I should have clarified that I am using CF MX7, so I cannot use reMatch function. Also, what I am looking for is to find a list of numbers between the strings: testId and Text in this pattern: testId67Text more text more text testId49Text more text testId54Text more text. I need to extract 67,49,54. Note: I do not need all the umbers, I want them only if they are present in that pattern. Thanks, K On 11/5/07, Raymond Camden [EMAIL PROTECTED] wrote: Use the number character class. cfsavecontent variable=test testId67Text more text more text testId49Text more text testId54Text more text /cfsavecontent cfset numbers = reMatch([[:digit:]]+, test) cfdump var=#numbers# On Nov 5, 2007 9:30 AM, Web Exp [EMAIL PROTECTED] wrote: Hi. I have a bunch of text in a db table that has multiple occurances of this pattern: testId67Text more text more text testId49Text more text testId54Text more text How can I get all the numbers from it? i need 67,49,54. I know it need regex. But I need help. Thanks, K ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292665 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Regex search problem
Don't do the refind() in the loop. Running it once with all specified will return (you're right on this one) a struct of arrays. It will find all of the matches (hence scope all :-P). You then only need to loop over the results. Much more efficient. Plus, OMG, you're using a condition that runs the regex and throws away the answer. Don't do that. Ever. Please. It makes me weep. --Ben Doom Bobby Hartsfield wrote: Likea so... cfset txt = this is a test testId67Text more text more text testId49Text more text testId54Text more text testId56Text / cfset county = 0 / cfset arrString = arrayNew(1) / cfset nums = arrayNew(1) / cfloop condition=refind('testId(\d+)Text', txt) cfset county = county + 1 / cfset arrString = refind('testId(\d+)Text', txt, 1, true) / cfset nums[county] = mid(txt, arrString['pos'][2], arrString['len'][2]) / cfset txt = removechars(txt, arrString['pos'][1], arrString['len'][1]) / /cfloop cfdump var=#nums# / ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, November 05, 2007 11:37 AM To: CF-Talk Subject: Re: Regex search problem You can do an refind(text, \d+, 1, all) refind in text digits starting at position one find all This will return an array of structs with keys pos and len. Pos is the start position, and len is the length. You can then use mid() to grab them. --Ben Doom Web Exp wrote: Thanks Ray... Ok... I guess I should have clarified that I am using CF MX7, so I cannot use reMatch function. Also, what I am looking for is to find a list of numbers between the strings: testId and Text in this pattern: testId67Text more text more text testId49Text more text testId54Text more text. I need to extract 67,49,54. Note: I do not need all the umbers, I want them only if they are present in that pattern. Thanks, K On 11/5/07, Raymond Camden [EMAIL PROTECTED] wrote: Use the number character class. cfsavecontent variable=test testId67Text more text more text testId49Text more text testId54Text more text /cfsavecontent cfset numbers = reMatch([[:digit:]]+, test) cfdump var=#numbers# On Nov 5, 2007 9:30 AM, Web Exp [EMAIL PROTECTED] wrote: Hi. I have a bunch of text in a db table that has multiple occurances of this pattern: testId67Text more text more text testId49Text more text testId54Text more text How can I get all the numbers from it? i need 67,49,54. I know it need regex. But I need help. Thanks, K ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292691 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Regex search problem
Really? I thought that is what I was using in 6.1. I'm sure the docs can set you straight on what syntax is correct. Regardless, you are running the regex twice per loop, which is at least twice as often as you need to. Even if you have to run it once per loop, run it, store it, and check what you stored. --Ben Doom Bobby Hartsfield wrote: Hah crybaby! ;-) I tried 'all' but it just throws an error on 6.1 ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -Original Message- From: Ben Doom [mailto:[EMAIL PROTECTED] Sent: Monday, November 05, 2007 1:55 PM To: CF-Talk Subject: Re: Regex search problem Don't do the refind() in the loop. Running it once with all specified will return (you're right on this one) a struct of arrays. It will find all of the matches (hence scope all :-P). You then only need to loop over the results. Much more efficient. Plus, OMG, you're using a condition that runs the regex and throws away the answer. Don't do that. Ever. Please. It makes me weep. --Ben Doom Bobby Hartsfield wrote: Likea so... cfset txt = this is a test testId67Text more text more text testId49Text more text testId54Text more text testId56Text / cfset county = 0 / cfset arrString = arrayNew(1) / cfset nums = arrayNew(1) / cfloop condition=refind('testId(\d+)Text', txt) cfset county = county + 1 / cfset arrString = refind('testId(\d+)Text', txt, 1, true) / cfset nums[county] = mid(txt, arrString['pos'][2], arrString['len'][2]) / cfset txt = removechars(txt, arrString['pos'][1], arrString['len'][1]) / /cfloop cfdump var=#nums# / ..:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292707 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: PDF Support with CF8 - Can this be done?
If I understand what it is you want to do, look into cfpdfform. You'll have to build an XML data object to hold the form data, but that shouldn't be too difficult. --Ben Doom Frank Mamone wrote: Hi everyone, I've been out of the CF game for a very long time and now I have a little project to do and wondering if CF8 has the answer for me. I'll keep search the docs, but in case you have a quick answer I appreciate it. What I need to do is take information posted from a web form and merge it into an existing PDF with place holders and then save the file and email it as an attachement. Can CF 8 do the PDF portion natively? Thank you, Frank Mamone ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292534 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: number of times
A couple of options: Loop over the text using find() or findnocase(). More code, may be faster. Use refind() or refindnocase() to find all the matches (return an array of them) and then get the arraylen() of what it returns. Easier code, but it will likely run slower. --Ben Doom Web Exp wrote: Hi. I have a large chunk of text/html-text in the database and I need to find out the number of times the term fantabulous occurs in it. Any CF function/UDFs that I can use? Any ideas please? Thanks, k ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Merging Static PDFs and PDF Forms in CF8
This is off-the-cuff, but... Can you create the sig block in HTML, and append it to a page containing the PDF to sign (in an iframe or something). Then, write the signed HTML to a temporary PDF and merge it with the static document. Not sure if I explained that well, but hopefully you understood. --Ben Doom Jim Bates wrote: Hi All, The issue I am facing is this: 1200+ PDF forms that employees will need to sign. The docs are being created in MS Word, and all have a standard signature block. We have prototyped using LiveCycle Designer 8 to add fields to static PDF files (print Word files into Acrobat, import into LiveCycle and paste in fields) but this is pretty labor-intensive to use with a minimum of 1200 forms per quarter. The employee forms go into a CF8/Oracle library app (stored as BLOBs) and served up for 7,000 or so employees to sign. Posted data goes back into database. Here is the issue: Does anyone know any way to use some combination of cfpdf / cfpdfform / cfdocument that will allow us to create ONE generic signature block form, 1200 static PDF files, and merge them on the fly? cfdocument apparently does not allow PDF data to be included with a cfpdfform, as I have tried outputting PDF variables, toBinary(PDF variable), PDF served by cfcontent and various other combinations. (If the non-form data were HTML, we could easily output in a cfdocumentsection of the cfdocument, and add the cfpdfform source=#genericForm# action=populate and be done with it. But, we can't.) cfpdf action=merge with a combination of a static PDF file and a populated form results in a flattend PDF file with no form data. I am acutely aware that LiveCycle 8 uses the XFA schema, and regular PDF documents use a different schema. And, this may prohibit what we want to do. If anyone has experience with CF8 PDFs and PDF forms, or has any helpful thoughts, I would be appreciatively gross. Needless to say, this is a six month project that must be live in four weeks ;-) Thanks! Jim Bates Verizon Business ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292533 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CF 8 Perl on Win 2003 box
Like several others, I've run CF (5, 6) in parallel with Perl (Activeperl) on Win2k server. Like the others, I didn't see any direct conflicts. Like the others, I'd watch your CPU usage carefully if you are using Perl do do any heavy lifting. --Ben Doom Ian Skinner wrote: I'm 99% sure I know the answer, but I do not have the seniority or experience for my organization to take my word unsupported. Is there any potential problem with running the latest version of Perl and ColdFusion on a Windows 2003 server? Has anybody ever experiences a problem attributed to the two conflicting? TIA Ian ~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292462 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFMAIL quesitons..
I've never tried it, but Make sure your SMTP server is set to listen on all applicable IPs. Use the server argument to specify the SMTP server by IP instead of by name. HTH. --Ben Doom Al Musella, DPM wrote: Hi I am on CF7, with multiple websites on multiple IP addresses. When I send mail using cfmail, I want the IP address in the headers to say it came from the IP address of each website. For example. Website 1 is at ...100 Website 2 is at ...101 The headers from mail sent from both websites say they came from ...100. I want mail from Website 2 to say it is from ....101 Thanks Al ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292464 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replacing Strings
replace('dills', '', ', all) In other words, where you are explicitly writing double-quotes (like for the find string) wrap in single quotes, and where you are explicitly writing single quotes (like the replace string) wrap in double quotes. --Ben Doom Rick Sanders wrote: Hey list, I'm trying to replace a double quote in a text field to a single quote. I've tried using ReReplace, but it still crashes the Cold Fusion server. What I've done is this: cfoutput#REReplace(dills,,',ALL)#/cfoutput See, users tend to like using double quotes in a text field which breaks the SQL query. How can i check if there's a double quote in a #form.textfield# and remove it? Thanks in advance. Rick Sanders Webenergy Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292466 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Replacing Strings
Not to put too fine a point on it, but if this data is coming directly from an end user, it would probably be in your best interest to add the cfqueryparam anyway. It does quite a bit more than just quote escaping. Definitely a best practice recommendation. --Ben Doom Rick Sanders wrote: Didn't think of that, but it's less code to do a replace than the cfqueryparam. Rick Sanders Canada: 902-401-7689 USA: 919-799-9076 Canada: www.webenergy.ca USA: www.webenergyusa.com -Original Message- From: Dana Kowalski [mailto:[EMAIL PROTECTED] Sent: November-01-07 11:42 AM To: CF-Talk Subject: Re: Replacing Strings are you using cfqueryparam's on your query? It should escape them on its own I would think. ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292472 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: brain freeze: which is faster, contains or REFind
re* functions are inherently slower than their find* equivalents. There's a startup cost for the RegEx engine. --Ben Doom Barney Boisvert wrote: Those aren't equivalent. REFind does a case-sensitive RegEx search. find (which you didn't list) does a case-sensitive search. contains does a case-INsensitive search. I'd expect contains and findNoCase to be roughly equivalent, with REFindNoCase lagging slightly. Find and and REFind should be slightly faster than their NoCase equivalents. cheers, barneyb On 11/1/07, Larry Lyons [EMAIL PROTECTED] wrote: Hi all, Suffering from a post Halloween brain freeze here, but I cannot remember which would be faster: cfif foo Contains xyz or cfif refind(foo,xyz,1,false) thanks, larry -- Larry C. Lyons Web Analyst BEI Resources American Type Culture Collection http://www.beiresources.org email: llyons(at)atcc(dot)org tel: 703.365.2700.2678 -- ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292497 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: How to break down a number into percentages
Without seeing your code, I can say this with a fair degree of certainty: if you're really losing 3%, you are probably doing something wrong (like always truncating, using integers instead of floats, etc.). If you round to the nearest cent, you should be getting totals like $99.97 or $100.02 when you run your functions. Getting something exact is actually a bit difficult, unless the percentages happen to be even divisors of the beginning amount (which, for $100, they probably are, but we'll ignore that since we're using fake numbers). One way banks tackle this is by alternating fraction increases and decreases. For example, the first time they get a fraction of a cent, they go up to the next penny. The second time, they go down. The third time, up again, and so forth. It's not perfect, but it makes the math easy, and you should never be more than a penny off. --Ben Doom Rick Faircloth wrote: Hi, all. I know that sounds simple and, as it's stated, it is. However, what I'm trying to accomplish turns out to be more complicated that I thought. I want to take a dollar amount, break it down by various percentages (that should total 100%), then place the dollar amounts into various accounts and have the total placed into those accounts equal the original amount that was broken down by the percentages. I've been trying every function I could find including decimal, round, various math equations, to achieve the goal, but it's not working. The data type in myself is decimal, set to 2 places, but invariably, if I take $100 and run it through the breakdown and place the amounts into the accounts, then add the dollar figures places into the accounts, the total comes back $97.00. Not only that, but all dollar amounts ending up in the database are whole dollar amounts with not cents. Anybody have any clues how this should be approached? If the description above is not sufficient, I can give some concrete examples with actual numbers, but I figured someone had tackled something like this before. Thanks, Rick PS - I am on CF 8 now, so every solution is in play! :o) ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292501 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Generating a Cutlist with ColdFusion
Sounds like a variation on the knapsack problem in 2d. I don't have any code, but looking for knapsack algorithms might help. --Ben Doom Matthew Reinbold wrote: (my apologies if this appears twice - I posted to the web and then logged in and, because I didn't see the post on the list, assumed it was discarded) I've been working on this problem for some time and I'm about ready to throw in the towel. The client has a sheet of plywood and needs to have an application show the most efficient way to make a series of cuts (cutlist) so that waste is minimized. I know this problem has to have been solved several times over before now and I don't want to be reinventing the wheel. However, my Google searches are either turning up commercial products or binaries created from C or Delphi code. If anyone has an idea how to approach representing this problem or some great resources online I'd love to hear it. Matthew Reinbold Creative Principal - Vox Pop Design - http://voxpopdesign.com ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292405 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Copying a CFC Persisted in Session Scope
There should, since MX6 or so, be no reason to create read-only locks unless you have some sort of weird race condition going on. All session vars are thread-safe, and so cannot be simultaneously read and written to. So, you don't need to be absolved from locking even if you are referencing the session scope directly -- CF is forgiving. :-) --Ben Doom Ryan Heldt wrote: The objects I am copying from are persisted in the session scope. I would like to be able to read from these objects at runtime without having to lock them all over the place. Does creating a pointer in the request scope to an object in session absolve you from locking? I'm not sure, and to be honest, I haven't found a lot of information either way on the issue, so copying the object seems to be playing it safe, no? ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292281 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URLEncodedFormat question
Look into using cfstorecontent to grab the table into a variable. Then you only have to make one urlencodedformat() call on it. --Ben Doom john mcdonald wrote: Hi Everyone, I've been trying to solve this for a couple hours, and am getting nowhere fast. If anyone here as an idea that could point me in the right direction I would be very grateful. I have this HTML table which is being output to the users browser, and its got data from several queries in it. (see below for the table) and it works fine to output normally, but what I need to do is URL encode the entire table (After its been rendered with the data from the queries) and stuff the whole thing into a form variable that I can pass into Lotus Notes using a cfhttp method=Post The table (with query data) will then be unencoded by Lotus Notes and displayed as part of an email that will be sent to whoever. The whole passing into Lotus Notes part works fine. I have a rendered, hard coded, URL Encoded string as part of a cfhttp method=Post that I used for testing and works fine. I just don't know how to URL encode the table with the query values on the fly in my code so I can stuff it into the form field value. table width=664 border=1 cellpadding=5 cellspacing=0 bordercolor=#CC tbody tr td width=462 bgcolor=#CC h2 align=center class=style1Question/h2/td td width=196 bgcolor=#CC h2 align=center class=style1Answer/h2/td /tr tr tdProduct Market Segment/td tdstrongcfif isDefined(pnums.MARKETSEGMENTS)cfoutput#pnums.MARKETSEGMENTS#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted Revenue/td tdstrongcfif isDefined(totalEC)cfoutput#dollarformat(totalEC)#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted Quantity/td td width=196strongcfif isDefined(getParts.qtrlyFcstQty)cfoutput#getParts.qtrlyFcstQty#/cfoutput/cfif/strong/td /tr tr tdQuarterly Forecasted G Margin/td td strongcfif isDefined(metaFinance.SH_FIN_GROSSMARGIN)cfoutput#metaFinance.SH_FIN_GROSSMARGIN#/cfoutput/cfif/strong/td /tr tr tdMinimum Pull Quantity/td td width=196 strongcfif isDefined(metaHubMgt.SH_JHM_MINPULLQTY)cfoutput#metaHubMgt.SH_JHM_MINPULLQTY#/cfoutput/cfif/strong/td /tr tr tdCost Per Unit for __ pulls/td td width=196 pstrongMin Pull QTY:/strong cfif isDefined(metaHubMgt.SH_JHM_minPullQty)cfoutput#metaHubMgt.SH_JHM_minPullQty#/cfoutput/cfif /p pstrongCost Per Pallet:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitPallPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitPallPull#/cfoutput/cfif/p pstrongCost Per Carton:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitCartPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitCartPull#/cfoutput/cfif/p pstrongCost Per Layer:/strong cfif isDefined(metaHubMgt.SH_JHM_costPerUnitLayPull)cfoutput#metaHubMgt.SH_JHM_costPerUnitLayPull#/cfoutput/cfif/p /td /tr tr tdAdder/td td width=196 strongcfif isDefined(metapricing.SH_PRI_ADDER)cfoutput#metapricing.SH_PRI_ADDER#/cfoutput/cfif/strong/td /tr tr tdp class=style2Stakeholder - Does Not Qualify Comments/p /td td width=196 cfinclude template=Q-doesNotQualify.cfm/td /tr tr tdHub Justification/td td width=196strongcfif isDefined(metaRequest.REQ_HUBJUST)cfoutput#metaRequest.REQ_HUBJUST#/cfoutput/cfif/strong/td /tr /tbody /table Any ideas would be greatly appreciated. Thanks John ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292167 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: URLEncodedFormat question
Er, cfsavecontent rather. --Ben Doom Ben Doom wrote: Look into using cfstorecontent to grab the table into a variable. Then you only have to make one urlencodedformat() call on it. --Ben Doom ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292171 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: SeeFusion vs. FusionReactor
Regardless, I currently have one instance on one server. So licensing structure isn't a big deal. --Ben Doom DURETTE, STEVEN J (ATTASIAIT) wrote: Even with that change to the licensing, that still costs more than Fusion Reactor when you have 6 CF instances on one box. 1 Fusion Reactor License or 3 SeeFusion licenses. -Original Message- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 24, 2007 3:10 PM To: CF-Talk Subject: RE: SeeFusion vs. FusionReactor Actually, the SeeFusion pricing is a little different then that. http://www.seefusion.com/index.cfm?do=c.whatsnew The last item on this page details their 2 for 1 pricing model. == New 2-for-1 pricing model for individual servers For any single physical server, every 2 ColdFusion instances that you want to monitor now require just 1 SeeFusion license. So for a server with 4 ColdFusion instances that you want to monitor, you'd need 2 SeeFusion licenses. Or, for 2 physical servers each with 2 ColdFusion instances you want to monitor, you'd also still only need 2 SeeFusion licenses. == ~Brad A SeeFusion license had to be purchased for each instance of ColdFusion running on the server. Whereas, one FusionReactor license was used per server (not instance). ~| Get the answers you are looking for on the ColdFusion Labs Forum direct from active programmers and developers. http://www.adobe.com/cfusion/webforums/forum/categories.cfm?forumid-72catid=648 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292071 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Deleting Attachments Immediately After CFMAIL
Without having tried it, the first thing that springs to mind is to turn off mail spooling. In theory, attaching files should not be that much of a bother. I think you have to add a header specifying filename, MIME header, etc., and you have to add the file as a base-64 encoded block at the end of the email. Others (Jochem -- I'm looking at you!) could probably advise better about this. HTH --Ben Doom Nathan Wells wrote: Is there any way to safely delete files that were attached using a cfmailparam tag to an email that was generated with the cfmail tag? If you delete the attached file too soon, then the file doesn't get attached to the email, at best, and at worst, the email fails altogether. cfmail to=[EMAIL PROTECTED] to=[EMAIL PROTECTED] subject=See Attachment cfmailparam file=#theFullFilePath# See attached file, #GetFileFromPath(theFullFilePath)# /cfmail cffile action=delete file=#theFullFilePath# I know for a fact that this worked just fine in CF 5, because the contents of the attached file would be included as a base64 string in the .mail file that was written to the spool. In the MX versions of CF, only path of the attached file is put in the .mail file, meaning the attached file had to stick around until the .mail file in the spool could be processed. It seems like a significant feature digression, but I have found zero documentation on this from Adobe. It is quite a hindrance if you are attaching (gasp) dynamically generated files to emails to create an entire separate process to manually clean up the files from the file system. Does anybody know how attachments work in CF 8? I haven't tried it yet, and I would be curious if it works the same as CF 7. Has anyone heard of future plans by Adobe to allow attached files to be automatically deleted after the spool file has been processed. Maybe something similar to the cfcontent tag? cfmailparam file=#theFullFilePath# delete=yes And finally, has anyone ever tried to somehow force the contents of the file into the body of the email so it is indeed written to the spool file? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292095 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Best regex for this, getting software version numbers
Without testingL ^.*?($|\d+\.\d+) Which is, basically, beginning of string, shortest possible string, (end of string or digits dot digits). --Ben Doom Andy Matthews wrote: I have these strings: Firefox 2.0.0.8 (Firefox 2.0) Internet Explorer 7.0 (Internet Explorer 7.0) Googlebot 2.1 (Googlebot 2.1) Yahoo! Slurp (Yahoo! Slurp) etc. I'd like to grab everything up to a second period (if it exists). What I want is in parens next to each string. Anyone have any ideas? Andy Matthews Senior ColdFusion Developer Office: 877.707.5467 x747 Direct: 615.627.9747 Fax: 615.467.6249 [EMAIL PROTECTED] www.dealerskins.com http://www.dealerskins.com/ ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292096 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SeeFusion vs. FusionReactor
I'm about to invest in one of these, and I'm looking for advice and/or practical experience. We have several applications running, and we're trying to hunt down the source of site slowdowns. Is there an overriding reason to pick one over the other? I'm currently leaning toward FusionReactor -- it seems cleaner and easier to use. It is, of course, a bit more expensive. Is it worth the extra money? For reference, I'm running CF8 Standard on Win2k3 R2. --Ben Doom ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291961 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SeeFusion vs. FusionReactor
As Andy and Morgan pointed out, CF8 standard does not come with a server monitor. Trust me -- I'd have already been using it if standard shipped with it! Thanks for the FR nod. --Ben Doom Peterson, Chris wrote: Ben - the integrated server monitor in CF8 was not enough to figure out the errors? (from the admin, check out server monitor on the left) I have FusionReactor on CF7 Ent, and I agree it is much cleaner than the demo I tried of SeeFusion. I have never had a problem with it. Chris Peterson Gainey IT Adobe Certified Advanced Coldfusion Developer ~| Check out the new features and enhancements in the latest product release - download the What's New PDF now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291979 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: SeeFusion vs. FusionReactor
Thanks for the advice. See questions and comments inline. Brad Wood wrote: I'm biased because SeeFusion is the only product I have used, but I wholeheartedly recommend it. (I have absolutely no affiliation with them) Unless you are simply interested in spending more money don't think SeeFusion is less of a product because it is cheaper. No, my preference for FusionReactor wasn't because SeeFusion was cheaper. The latest version of SeeFusion uses a very slick Flex interface that allows constant streaming of stats among other things which I have found to be very easy to use. Yes. However, the FusionReactor interface seems just as nice. The active monitoring rules E-mail me before anyone even notices the servers have a problem FusionReactor seems to have this as well. Where I take SeeFusion to the bank is in the database logging. I have a separate database for my webserver stats which I aggregate via jobs every night and I can produce pretty nice trending reports at the end of the month. (I will send you an example of a report I made from SeeFusion data if you are interested) I had difficulty understanding how I was supposed to get this running. Honestly, I didn't put much time into it. Even cooler is the API that is available to build your own monitoring interfaces using live SeeFusion data. I have a monitor I built that shows me every spid running on the database, the NAME of the user running it, and the page of the application they are on. I used the SeeFusion API to tie the web server info together with the database info via running spid and web server IP. Fair enough. I'm not sure I'd use that, though. But it is a damn nifty feature. Finally, I have never had a bad experience calling up for tech support. I bugged the crap out of them for a while, and they still kept answering the phones with a smile. lol This is IMHO a great recommendation. Service is very important to me. --Ben Doom ~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291978 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: How should SQL handle same named columns from different tables?
IIRC, it should actually error and force you either to pick one or give them unique names (a.userid as bob, b.userid as fred). Expecting Access to behave properly is like expecting teens not to drink. Sometimes it works, but most of the time, it's a mistake. --Ben Doom Jim McAtee wrote: SELECT a.*, b.* FROM user a INNER JOIN userprefs b ON b.userid = a.userid WHERE username = 'bsmith' In the query there's a common column named 'userid'. Should the query retun 1) one column named userid 2) two columns named userid 3) two columns with some type of unique name for each I find that the CF8 'Microsoft Access with Unicode' driver does #3, which I hadn't seen before in other ODBC drivers. It returns two columns named 'a.userid' and 'b.userid'. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292008 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: getting date from dynamic date ranges
datediff() is what you are looking for. --Ben Doom Andrew Whone wrote: I retrieve a bunch of dynamic DateFroms and DateTos that a user has input into a form. !--- Loop through the dateField IDs to get the Dates ranges--- cfloop list=#form.DatefieldID# index=id !--- Get the dates--- cfset DateFrom = form[dateFrom_ id] cfset DateTo = form[dateTo_ id] !--- Format the dates--- CFSET DateFrom1 = #DateFormat(DateFrom, -mm-dd)# CFSET DateTo1 = #DateFormat(DateTo, -mm-dd)# !--- Get the number of days in each period--- cfset DateDifference = DateDiff(d, #DateFrom1#, #DateTo1#)+1 /cfloop I want to know the DateFrom of the first period that is more than 4 days and I want to find out if each date range is separated by at least one day. I have ensured that the date ranges are in chronological order and the DateFrom is before the DateTo. !--- Get the DateFrom of the first period that is more than 4 days?--- cfif #DateDifference# GT 4 /cfif Any clues would be much appreciated! ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finderproductID=1522loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291840 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Which query would be better?
Okay. Except Oracle != MySQL 5. MySQL 5 was what was specified in the original, forgive the pun, query. --Ben Doom Tom Chiverton wrote: On Monday 22 Oct 2007, [EMAIL PROTECTED] wrote: Which, according to the docs, is only limited by max_allowed_packet. You must be on the wrong page. #oldCompany# had an Oracle install that crapped out at 100 items. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291842 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: get the value of the drop down and pass it to the cfquery
What do you have the submit button doing? Does it actually submit to the server, or just forward to the next tab? For CF to process information, you have to make a server trip of some kind. If you are making the server trip, but not seeing the information passed, what are you naming your dropdown, and how are you referencing it in the query? --Ben Doom erik tom wrote: I need to be able get the value from the drop down and pass ethis value to cfquery function which located on the second tab of the form. Once i selected the drop down item i clicked on the submit button and going to the second tab but nothing getting passed to the query. Help? ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291870 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: OT: Limit a MSSQL Server 2000 user.
Set up a SQL Express server for him with nightly (?) replication, when it won't affect performance so much. Let him beat the crap out of that to his heart's content. Bonus points if you put it on his workstation, so he's dragging down his own workstation. --Ben don't mess with my servers Doom DURETTE, STEVEN J (ATTASIAIT) wrote: Hi all, Here is an interesting OT for you. Is there any way to restrict how much bandwidth, how many rows, or how high a priority a user has when connecting to a MSSQL2K server? My issue is that we have a user, who for political reasons we can't just boot out of the db, who we were forced to grant access to our database. He is using Access XP to connect to our database, he then proceeds to download two of our largest tables into his access database. He does this multiple times a day, and each time it takes out Table locks and all of our pages back up and other users can't access the data. I've already limited what tables he has access to and what he can do to them (select only), but I still need a way to put his requests as a low priority on the database. Thanks, Steve Steve Durette 586-466-7654 [EMAIL PROTECTED] ~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:291877 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4