Re: "zip code" range from xls to sql
so do a query to get my list of zip codes. then try to do a listtoarray or should i first do a cfloop query to try to step through the values.. man.. feeling so stoopid.. i swear i saw an example of this in a wack4-7 book some where.. but cant find it.. ~| 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:297553 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: "zip code" range from xls to sql
> bump.. > any ideas how to do this? Hrm... it sounds to me like the logic is such that you're going to be better off making use of an array or structure to parse out the values. SQL doesn't have access to complex variable types. I would suggest creating an array of structures... each structure would contain a start value and stop value. ~| 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:297552 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is there a safe way to offer a "Send to a Friend(email)" feature without the concern of a Spam Bot?
>Has anyone solved this and made such a tag/module >available? > I use cfformprotect with success. Will ~| 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:297551 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Is there a safe way to offer a "Send to a Friend(email)" feature without the concern of a Spam Bot?
Couple of good suggestions from JJ and Will... I will briefly make the note that the captcha produces a number of other potential issues related to say visually impaired users, which is why for example PayPal now has an audio captcha (or at least they used to), although I think you'd be hard pressed to find any existing art for audio-captcha that can be dropped into CF. Not having that has the *potential* to be a usability issue, and usaiblity issues have the *potential* to be legal liabilities (even for privately held companies). Though at least in the present tense you're not likely to get sued over that particular usability issue, and given that all it really does is send an email with a url that's already available to them, they have other alternatives, so it's probably not going to become a legal concern in the future. But these thoughts are really more on the subject of captcha in general ... Captcha is also a nasty case for "user experience" -- often considered to be a "necessary evil" but it's sort of the exact opposite of "pleasant" for the users (in spite of the fact that they put up with it). For that reason, and because captcha isn't as bullet-proof as most people think, my own first choice would be to let them use it only if they're logged in. One other option, which may be no better than the captcha solution, but is at least different, so it's something to consider, is to let them use the form without being logged in and require an email confirmation before you send to their friend. So the user plugs in their message to the friend, hits send and gets their own email with a url with a random code that identifies their request to send to the friend and then it only sends the email to the friend if they hit the url in their email. Of course if they're logged in, you omit the confirmation email and just send it since you already know who they are, but this would be an alternative to captcha if your clients are really insisting that anonymous users have access to the friend form. hth, ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~| 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:297550 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Has anyone here built a solid RSS Ingest system?
Paragator. It lets you both do basic reading, as well as searching. It also takes fields that are a bit different in Atom versus RSS and 'mashes' them up into a common set of fields. http://paragator.riaforge.org On Jan 25, 2008 7:04 PM, Nate Willard <[EMAIL PROTECTED]> wrote: > A system that would ingest stories from 1+ rss feeds? > > > ~| 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:297549 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Is there a safe way to offer a "Send to a Friend(email)" feature without the concern of a Spam Bot?
I would think a captcha on the form would help stop most bots. Just a thought. J.J. On 1/27/08, Nate Willard <[EMAIL PROTECTED]> wrote: > Has anyone solved this and made such a tag/module > available? > > My site's users are demanding such a feature. I've > never use the Send to Friend but to my surprise a lot > of people do. > > I'm concerned that adding this feature will welcome > spam bots as most send to friend features offer a > Message Input box. > > Is there any safe way to go about adding such a > feature? Are there any platforms out there that I can > integrate with to avoid trouble (feedburner etc)? > > 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:297548 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: "zip code" range from xls to sql
bump.. any ideas how to do this? ~| 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:297547 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: "#" issue & SQL Query
> I have a sql query (SQL Server 2000) for CFMX: > > SELECT @Col_with_No_Pound = @Col_with_No_Pound + CASE > @Col_with_No_Pound WHEN '' THEN '' ELSE ',' END + COLUMN_NAME, >@Col_with_Pound= @Col_with_Pound + CASE @Col_with_Pound > WHEN '' THEN '#' ELSE '#,#' END + COLUMN_NAME > . > > Obviously, # is causing the error whereas I need to # sign there. Right, because # is used to indicate variables in CF... And of course because CF automatically evaluates variables in quoted values like when you're setting a string variable with a cfset tag, that's why you got the other error when you switched to trying to use replace() to swap out the % for #. But CF also automatically evaluates variables inside of cfquery tags because it's assumed that you'll want to use variables in your queries (very rarely is this not the case). So what you need is to escape the # signs so that CF treats it as a literal string instead of trying to evaluate a variable. In ColdFusion those characters are escaped by doubling them (same with single and double-quotes), so in your case this should give you the result you want: WHEN '' THEN '##' ELSE '##,##' END + COLUMN_NAME And this also applies to your cfset tag in the other message. hth, ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 http://onTap.riaforge.org/blog ~| 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:297546 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Is there a safe way to offer a "Send to a Friend(email)" feature without the concern of a Spam Bot?
Some of this will depend on whether or not you have a logged in area. I have added these systems in the past, but only with certain backend protections. For instance, You can limit it to 1 email address per send Offer an 'opt out' link for the recipients to add their email address to. Add a time-delay, after they send 1 message, another can't be sent for 60 seconds. Load the form into a frame, if the page isn't called from your site, or have specific criteria that you select, don't allow it to be viewed or sent. There is quite a few things you can do, but just remember that the best solution is to make it a logged in area and track who is doing 'what' so that you can shut them down if need be. William Ps. You can't stop spammers, only slow them down or make it so difficult that they have to go somewhere else for their tricks. -- William E. Seiter Have you ever read a book that changed your life? Go to: www.winninginthemargins.com Enter passkey: goldengrove Web Developer http://William.Seiter.com -Original Message- From: Nate Willard [mailto:[EMAIL PROTECTED] Sent: Sunday, January 27, 2008 10:29 AM To: CF-Talk Subject: Is there a safe way to offer a "Send to a Friend(email)" feature without the concern of a Spam Bot? Has anyone solved this and made such a tag/module available? My site's users are demanding such a feature. I've never use the Send to Friend but to my surprise a lot of people do. I'm concerned that adding this feature will welcome spam bots as most send to friend features offer a Message Input box. Is there any safe way to go about adding such a feature? Are there any platforms out there that I can integrate with to avoid trouble (feedburner etc)? 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:297545 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Is there a safe way to offer a "Send to a Friend(email)" feature without the concern of a Spam Bot?
Has anyone solved this and made such a tag/module available? My site's users are demanding such a feature. I've never use the Send to Friend but to my surprise a lot of people do. I'm concerned that adding this feature will welcome spam bots as most send to friend features offer a Message Input box. Is there any safe way to go about adding such a feature? Are there any platforms out there that I can integrate with to avoid trouble (feedburner etc)? 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:297544 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Has anyone here built a solid RSS Ingest system?
Thanks Don --- Don L <[EMAIL PROTECTED]> wrote: > >A system that would ingest stories from 1+ rss > feeds? > > I think so. And in my view, there are at least two > techniques to handle exception gracefully using > CFTHREAD tag. > a) the "timeout" attribute, this is an easier way to > implement; > b) using a predetermined timeout, to kill a thread > if it does not complete within a specified time, > check out livedocs for detail. > > And since we're at it, I wish the CFFEED tag has a > "cache" attribute like CFQUERY, hence, it can > improve performance greatly (saving round trips to > feed source), scenario, daily news. Yes, the > "xmlVar", or "varXML" would function kind of > similarly, but you would to go through the whole > damn process, creating such such a file, checking > date/time stamp... > > ~| 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:297543 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: date problem
>>so we first check with input mask US and if it says invalid date then we pass in input mask EU and if it works Good point. But this is not really 100% proof, since some dates may be valid in US format, although they were meant in EU format. Take 10/11/2008 for instance. So the date may be "valid" and still not be the good one. To be 100% sure, you could consider a date pick up system. -- ___ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) 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:297542 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: date problem
:) thanks again this is very straight forward and at the moment is solving our problems. sometimes we dont know what format the user is going to pass the date in so we first check with input mask US and if it says invalid date then we pass in input mask EU and if it works then fine and if not then there is an error in their date :) so this is working well for us! thanks again claude ~| 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:297541 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Pskill and cfexecute
> > I am trying to kill the process htmldoc.exe, using pskill.exe, > however > > i keep getting the following error > > It might be waiting for acceptance of the EULA. If you are using a > newer version, try adding the flag -accepteula it did appear, and i replied, which doesn't look like it loaded either, you fix worked a treat - thank you, have been pulling me hair out ~| 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:297540 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4