cfmail validation
HI everybody am using cfmail with the code below.. my problem is with the query that get's all email addresses. If an email address is valid it goes if at one point emailaddress is not valid it gives an error. is there a way with my code to test valid email addresses or better then if there is a way that i could check which emails just went thru or not? CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=NO CFMAIL QUERY=GetList SERVER=cbox.cbox.org SUBJECT=subject FROM=press service i...@info.org TO=#Trim(Name)# #Trim(Fname)# #Trim(emailaddr)# TYPE=HTML cfinclude template=pubSSMailDesign.cfm /CFMAIL /CFPROCESSINGDIRECTIVE thanks for any help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322407 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: cfmail validation
isValid(email, emailaddr) will tell you if it's a correctly formed email address, but not if it actually exists. This udf will check that a mailbox exists. Haven't tried it myself yet: http://cflib.org/udf/verifyEmail -Original Message- From: alex poyaoan [mailto:ap.cli...@tiscali.it] Sent: 12 May 2009 09:15 To: cf-talk Subject: cfmail validation HI everybody am using cfmail with the code below.. my problem is with the query that get's all email addresses. If an email address is valid it goes if at one point emailaddress is not valid it gives an error. is there a way with my code to test valid email addresses or better then if there is a way that i could check which emails just went thru or not? CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=NO CFMAIL QUERY=GetList SERVER=cbox.cbox.org SUBJECT=subject FROM=press service i...@info.org TO=#Trim(Name)# #Trim(Fname)# #Trim(emailaddr)# TYPE=HTML cfinclude template=pubSSMailDesign.cfm /CFMAIL /CFPROCESSINGDIRECTIVE thanks for any help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322408 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Why is my server in the US ?
On Tuesday 12 May 2009, Paul Hastings wrote: ah, two countries separated by a language...no i meant that *you* do the low level java call to set the default locale as a workaround until you can track down what's resetting the locale. *Ah ha* gotcha now :-) We've stuck the relevant options in the CF jvm.config file for the moment. -- Helping to augmentatively empower 24/7 virtual synergistic solutions as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322409 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
(ot) Who takes care of this site? ;-))
Site is hacked... And no, it's not me... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322410 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) Who takes care of this site? ;-))
Attachments don't go through... the site is www.cfcode.com On Tue, May 12, 2009 at 12:47, Beru beru.b...@gmail.com wrote: Site is hacked... And no, it's not me... ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322411 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: cfmail validation
thanks will try this out... isValid(email, emailaddr) will tell you if it's a correctly formed email address, but not if it actually exists. This udf will check that a mailbox exists. Haven't tried it myself yet: http://cflib.org/udf/verifyEmail HI everybody am using cfmail with the code below.. my problem is with the query that get's all email addresses. If an email address is valid it goes if at one point emailaddress is not valid it gives an error. is there a way with my code to test valid email addresses or better then if there is a way that i could check which emails just went thru or not? CFPROCESSINGDIRECTIVE SUPPRESSWHITESPACE=NO CFMAILQUERY=GetList SERVER=cbox.cbox.org SUBJECT=subject FROM=press service i...@info.org TO=#Trim(Name)# #Trim(Fname)# #Trim(emailaddr)# TYPE=HTML cfinclude template=pubSSMailDesign.cfm /CFMAIL /CFPROCESSINGDIRECTIVE thanks for any help ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322412 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
getting cfx_imsmail and cfset to play nice?
I am currently trying to use the cfx_imsmail tag (custom tag available using inFusion Mail Server) and I have a question which I hope can be easily answered. I want to use the cfx_imsmail tag to replace a cfmail tag that uses a query attribute. I am using the query and queryfield attributes to automatically loop the same query. My problem is that while inside an attribute of the cfx_imsmail tag, my cfset tags seem to be ignored. I want to put in place some link tracking logic and also a cfinclude tag that calls a dynamic template name. I have tried to set up this data in a token_emailbody attribute, directly in the body attribute, and also directly in the html attribute, but nothing seems to work for me. a dumbed-down code snippet is attached below: cfx_imsmail header_to=#myquery.to_email# header_from=#myquery.from_email# smtpfrom=#myquery.from_email# header_subject=#myquery.subject# failto=graph...@gammasports.com parsetokens=yes renderplaintext=no log=yes priority=0 query=myquery queryfield=to_email html= cfsilent !--- tracking logic here --- cfset ... /cfsilent !--- dynamic include here --- cfinclude template='...' cfsilent !--- extra cfinvoke where I am erroring --- cfset var.myvariable = 'blah blah' ) cfinvoke component='my_component' method='do_this' cfinvokeargument name='this_argument' value='#var. myvariable#' / /cfinvoke /cfsilent Please note that the data contained in the html attribute of the cfx_imsmail tag in the above code example was taken directly from between the opening and closing cfmail tags that I'm trying to replace. The cfmail tag works without any problems at all times. I keep getting an error on line 57 stating that a variable is undefined, even though I have the variable being defined on line 54. This leads me to believe that the cfset I am using is not being executed. Is there anything I can do to get my cfset to behave properly while inside of the cfx_imsmail tag? I have had success looping the cfx_imsmail tag for my query, replacing query and queryfield attributes with the smtpto attribute, and using a cfsavecontent tag before the cfx_imsmail tag to build the content for the html attribute. I do not want to do it this way, as this is far less efficient than using the query and queryfield attributes. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322413 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) Who takes care of this site? ;-))
I guess talking to Robert would be a good start... http://whois.domaintools.com/cfcode.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322414 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) Who takes care of this site? ;-))
Not to add insult to injury but this is too funny. From the domain tools listing page: Front Page Information Website Title: HaCKeD By EL_MuHaMMeDhttp://www.cfcode.com/ Title Relevancy 100% On Tue, May 12, 2009 at 10:25 AM, Peter Boughton bought...@gmail.comwrote: I guess talking to Robert would be a good start... http://whois.domaintools.com/cfcode.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322415 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) Who takes care of this site? ;-))
whois is our friend :) Robert has been contacted. On Tue, May 12, 2009 at 8:41 AM, Gerald Guido gerald.gu...@gmail.comwrote: Not to add insult to injury but this is too funny. From the domain tools listing page: Front Page Information Website Title: HaCKeD By EL_MuHaMMeDhttp://www.cfcode.com/ Title Relevancy 100% On Tue, May 12, 2009 at 10:25 AM, Peter Boughton bought...@gmail.com wrote: I guess talking to Robert would be a good start... http://whois.domaintools.com/cfcode.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322416 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: getting cfx_imsmail and cfset to play nice?
I should add that I'm using cfx_imsmail version 3.3.2. The coolfusion.com website is really messed up at the moment, and link to files on the download page link to the same smtp installer file. Does anyone know where I can get the newest version of cfx_imsmail? Or an answer to the OP would be great too. I am currently trying to use the cfx_imsmail tag (custom tag available using inFusion Mail Server) and I have a question which I hope can be easily answered. I want to use the cfx_imsmail tag to replace a cfmail tag that uses a query attribute. I am using the query and queryfield attributes to automatically loop the same query. My problem is that while inside an attribute of the cfx_imsmail tag, my cfset tags seem to be ignored. I want to put in place some link tracking logic and also a cfinclude tag that calls a dynamic template name. I have tried to set up this data in a token_emailbody attribute, directly in the body attribute, and also directly in the html attribute, but nothing seems to work for me. a dumbed-down code snippet is attached below: cfx_imsmail header_to=#myquery.to_email# header_from=#myquery.from_email# smtpfrom=#myquery.from_email# header_subject=#myquery.subject# failto=graph...@gammasports.com parsetokens=yes renderplaintext=no log=yes priority=0 query=myquery queryfield=to_email html= cfsilent !--- tracking logic here --- cfset ... /cfsilent !--- dynamic include here --- cfinclude template='...' cfsilent !--- extra cfinvoke where I am erroring --- cfset var.myvariable = 'blah blah' ) cfinvoke component='my_component' method='do_this' cfinvokeargument name='this_argument' value='#var. myvariable#' / /cfinvoke /cfsilent Please note that the data contained in the html attribute of the cfx_imsmail tag in the above code example was taken directly from between the opening and closing cfmail tags that I'm trying to replace. The cfmail tag works without any problems at all times. I keep getting an error on line 57 stating that a variable is undefined, even though I have the variable being defined on line 54. This leads me to believe that the cfset I am using is not being executed. Is there anything I can do to get my cfset to behave properly while inside of the cfx_imsmail tag? I have had success looping the cfx_imsmail tag for my query, replacing query and queryfield attributes with the smtpto attribute, and using a cfsavecontent tag before the cfx_imsmail tag to build the content for the html attribute. I do not want to do it this way, as this is far less efficient than using the query and queryfield attributes. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322417 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
I think he is going to the wrong school.
http://apnews.myway.com/article/20090511/D9848CA00.html I don't agree with this school's stance on dancing, rock music and hand-holding, but I agree they have a right to have these stances and that others can choose to agree with them to attend the school. There was another story yesterday that said the father also disagreed with the schools stance. I presume this is a private school that this boys family is paying for him to attend... With that assumption, I have these questions: Why pay to go to a school you and your family don't agree with? Why advertise you are going to go to a prom against the schools rules? I guess it could be a small enough town that doing so would somehow get back to the school, but I can't imagine that the school as undercover dance detectives going to these forbidden functions looking for rule breakers, would they? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322418 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) Who takes care of this site? ;-))
cf forum perhaps? http://web.archive.org/web/20071226130838rn_1/www.cfcode.com/cfforum/ With this? *cfforum-forummessages-sql-injection (47234)* http://xforce.iss.net/xforce/xfdb/47234 Here is a thread which is discussing the issues that customers were having with SQL injection attacks with that software: http://74.125.95.132/search?q=cache:rpWLYB_1Q1AJ:www.cfcode.com/cfforum/printthread.cfm%3FForum%3D9%26Topic%3D1568+cfforum+securitycd=4hl=enct=clnkgl=usclient=iceweasel-a A google search of site:cfcode.com shows that the software makes registered members usernames available to Google spiders through the whois.cfm, which would make a brute force attack fairly easy... Just a heads-up for anyone running this software. speeves On Tue, May 12, 2009 at 8:47 AM, Shannon Peevey spee...@stolaf.edu wrote: whois is our friend :) Robert has been contacted. On Tue, May 12, 2009 at 8:41 AM, Gerald Guido gerald.gu...@gmail.comwrote: Not to add insult to injury but this is too funny. From the domain tools listing page: Front Page Information Website Title: HaCKeD By EL_MuHaMMeDhttp://www.cfcode.com/ Title Relevancy 100% On Tue, May 12, 2009 at 10:25 AM, Peter Boughton bought...@gmail.com wrote: I guess talking to Robert would be a good start... http://whois.domaintools.com/cfcode.com ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322419 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 think he is going to the wrong school.
Ian Skinner wrote: Stuff I should have sent to the other list! It would be nice if there was some way to change this after I have hit the send button. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322420 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I think he is going to the wrong school.
So.. Does the school use ColdFusion? :) I'm not seeing how ColdFusion (this IS a ColdFusion list) is used here. I mean, if anything, they are using ASP (Look at the We are Hiring link). So why bring this up on a ColdFusion list to ColdFusion people? :) On Tue, May 12, 2009 at 7:06 AM, Ian Skinner h...@ilsweb.com wrote: *something NOT ColdFusion* ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322421 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: I think he is going to the wrong school.
On Tue, May 12, 2009 at 10:12 AM, Phillip Vector vec...@mostdeadlygame.comwrote: So.. Does the school use ColdFusion? :) I'm not seeing how ColdFusion (this IS a ColdFusion list) is used here. I mean, if anything, they are using ASP (Look at the We are Hiring link). So why bring this up on a ColdFusion list to ColdFusion people? :) On Tue, May 12, 2009 at 7:06 AM, Ian Skinner h...@ilsweb.com wrote: *something NOT ColdFusion* No, he just posts to cf-talk because it's picked up by google quicker and he's on some type of ego trip! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322422 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Storing SSN ... I know, I know
If the user is connecting with ONLY one bank, then see if that bank will let you send them the encrypted SSN and they can decrypt it on their end using whatever they have. Then all you have to do is one way hash it, and they can do the comparison on their end. -Original Message- From: ColdFusion Developer [mailto:cfdev...@gmail.com] Sent: Monday, May 11, 2009 7:19 PM To: cf-talk Subject: Storing SSN ... I know, I know What's a best practice for securely storing a social security number? I've talked myself blue trying to talk my client out of doing this, but the bank he's working with for this project absolutely, positively cannot process his transactions without the SSNs of our users (most of the businesses they work with are payroll companies with secure internal data storage, not a public-facing site like his will be). What would you all recommend as a process/method for storing this info in the most secure way possible? Most of what I've read just says encrypt/decrypt it in the database and you're fine -- but I'm not so sure that's the best course. Thanks in advance! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322423 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 think he is going to the wrong school.
Just FYI, you may want to consider a Gmail account. It can send from your domain name and it has an Undo button which has saved me a few times as well. :) and also to note, IMHO, private school, private rules. It sucks, but the kid is getting way to much attention to a non-issue. On Tue, May 12, 2009 at 7:11 AM, Ian Skinner h...@ilsweb.com wrote: Ian Skinner wrote: Stuff I should have sent to the other list! It would be nice if there was some way to change this after I have hit the send button. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322424 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: I think he is going to the wrong school.
I agree. If you're paying to go a private school, then you should be aware of their restrictions and choose to go to another school. -Original Message- From: Ian Skinner [mailto:h...@ilsweb.com] Sent: Tuesday, May 12, 2009 9:06 AM To: cf-talk Subject: I think he is going to the wrong school. http://apnews.myway.com/article/20090511/D9848CA00.html I don't agree with this school's stance on dancing, rock music and hand-holding, but I agree they have a right to have these stances and that others can choose to agree with them to attend the school. There was another story yesterday that said the father also disagreed with the schools stance. I presume this is a private school that this boys family is paying for him to attend... With that assumption, I have these questions: Why pay to go to a school you and your family don't agree with? Why advertise you are going to go to a prom against the schools rules? I guess it could be a small enough town that doing so would somehow get back to the school, but I can't imagine that the school as undercover dance detectives going to these forbidden functions looking for rule breakers, would they? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322425 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 think he is going to the wrong school.
Casey Dougall wrote: On Tue, May 12, 2009 at 10:12 AM, Phillip Vector vec...@mostdeadlygame.comwrote: *something NOT ColdFusion* No, he just posts to cf-talk because it's picked up by google quicker and he's on some type of ego trip! I blame Alien Hand Syndrome... Please don't give away the ending, I've only watch the first quarter of the episode this morning. P.S. I have resent another copy the original message to the correct list immediately after realizing I had sent another message to the wrong list yet again. This topic can be continued there. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322426 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Help With Regular Expressions
Hi All, I'm trying to find a way of using regular expressions to locate and replace text. My application reads in some text containing links from a DB: e.g. ../folderName/someCFMFile.cfm?code=AB. I want to change all occurrences of this to ../folderName/AB.html. Note that code can be any 2-uppercase-character combination. I've gotten to the point where I have ../folderName/code using: cfset aData = Replace(stringFromDB, someCFMFile.cfm, , ALL) cfset aData = REReplace(aData, ../folderName/[A-Z]{2}, aData, ALL) My problem is how to get it to replace what it matches with that same match (which would be ../folderName/code) with ../folderName/code.html? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322427 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Help With Regular Expressions
This is untested, but should be close. REReplace(string, [a-zA-Z0-9_-]+\.cfm\?code=([A-Z]{2}), \1.html, all) find zero or more a-zA-Z0-9_-, then .cfm?code=, then any two A-Z and replace the whole thing with thos upper case letters plus .html. If someCFMFile.cfm is static, you can replace that character class with the literal. cheers, barneyb On Tue, May 12, 2009 at 9:20 AM, Robert Nurse rnu...@gmail.com wrote: Hi All, I'm trying to find a way of using regular expressions to locate and replace text. My application reads in some text containing links from a DB: e.g. ../folderName/someCFMFile.cfm?code=AB. I want to change all occurrences of this to ../folderName/AB.html. Note that code can be any 2-uppercase-character combination. I've gotten to the point where I have ../folderName/code using: cfset aData = Replace(stringFromDB, someCFMFile.cfm, , ALL) cfset aData = REReplace(aData, ../folderName/[A-Z]{2}, aData, ALL) My problem is how to get it to replace what it matches with that same match (which would be ../folderName/code) with ../folderName/code.html? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322428 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 With Regular Expressions
Can you provide one more of the actual links? I'm going to assume that the folderName string is not actually 'folderName'. If that's the case then it would affect the regular expression and what it would need to look for. Will the two character string always be at the end of the link? If everything else is the same, and you just need the last two characters of a link: cfset string = '../folderName/someCFMFile.cfm?code=AB' cfset match = REMatchNoCase('[A-Z]{2}$',string) cfdump var=#match# cfabort -Original Message- From: Robert Nurse [mailto:rnu...@gmail.com] Sent: Tuesday, May 12, 2009 11:20 AM To: cf-talk Subject: Help With Regular Expressions Hi All, I'm trying to find a way of using regular expressions to locate and replace text. My application reads in some text containing links from a DB: e.g. ../folderName/someCFMFile.cfm?code=AB. I want to change all occurrences of this to ../folderName/AB.html. Note that code can be any 2-uppercase-character combination. I've gotten to the point where I have ../folderName/code using: cfset aData = Replace(stringFromDB, someCFMFile.cfm, , ALL) cfset aData = REReplace(aData, ../folderName/[A-Z]{2}, aData, ALL) My problem is how to get it to replace what it matches with that same match (which would be ../folderName/code) with ../folderName/code.html? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322429 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
ok here is a weird one. the numbers render fine on display in browser. but if i include the rendered output in a cfmail, i dont get the numbering? i have the js, and css linked correctly.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322430 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
You can't do JavaScript in emails. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322431 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
well, whatever you put in the body of cfmail tag would be processed and rendered BEFORE the page is displayed in the browser, thus BEFORE any jQuery magic kicks in... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: ok here is a weird one. the numbers render fine on display in browser. but if i include the rendered output in a cfmail, i dont get the numbering? i have the js, and css linked correctly.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322432 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
how are you rendering the table in cfmail? is it based on query output? use queryname.currentrow then, or a custom row counter if your query uses group output... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: ok here is a weird one. the numbers render fine on display in browser. but if i include the rendered output in a cfmail, i dont get the numbering? i have the js, and css linked correctly.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322433 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
cfmail to=#eTo# from=#eFrom# subject=whatever charset=utf-8 type=html cfinclude template=display1Day.cfm/cfmail display1Day.cfm http://63.144.103.199/FORMS/rittalXpress/ie/inc/detail/display1Day.cfm?placeholder=enclosuresxp1DayId=10027#step1 the jquery auto number is in the display1Day.cfm which renders fine. i dont need the sorting or any thing in the email, just the line number. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322434 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: table display: row number. without recordset
there are like 5 separate queries. with sub quires inside the first 3. so current row wouldn't work. unless i wrote a big nasty q0q that's why i really liked the jquery rendering of the row number. On Tue, May 12, 2009 at 12:23 PM, Azadi Saryev az...@sabai-dee.com wrote: how are you rendering the table in cfmail? is it based on query output? use queryname.currentrow then, or a custom row counter if your query uses group output... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: ok here is a weird one. the numbers render fine on display in browser. but if i include the rendered output in a cfmail, i dont get the numbering? i have the js, and css linked correctly.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322435 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
my cfqueryparam grievance
Hello folks, I had a pretty strange experience with CFQueryParam today. Basically, I have an innocent-looking query: cfquery datasource=#application.myDB# name=qGetUser *SELECT* username, password *FROM* someTable *WHERE* someID = cfqueryparam cfsqltype=CF_SQL_INTEGER value= #cookie.theID# maxlength=6 /cfquery This query had worked just fine for nearly a year (since I cfqueryparamed it last summer) until this morning, when it broke. The error messages read: *Message:* Error Executing Database Query. 12 May 2009 01:49:21 PM EDT Diagnostics: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '521636a' to a column of data type int. The error occurred on line 35. That error points to the WHERE statement, and it complains the cookie.theID is not an integerbut it is!!! *Even the error messages themselves which contains a CFDump on Cookie scope say it is an integer, of 6 digits!!!* Even more strangely, the error messages always say converting the varchar value 521636a , no matter what the actual cookie.theID value is. Since this query is called from a template that logs users in, I got dozens of error reports, all with this identical error message, even though the actual theID values were very different. When I switched the cfqueryparam cfsqltype to varchar, the error went away!! Of course, the actual data type of the id table column IS varchar, but I had purposefully made it integer in the cfqueryparam, for code readability and more control over the incoming value. L The moral of the story, of course, is that the cfsqltype should probably always match the receiving database table columns data type. But I am just curious why were my values being converted to 521636a ? 6-digit integer/varchar values are certainly not out of bounds for SQL int data type, so I simply cannot fathom why conversion was done and why it was necessary. A ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322436 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Date format question
Hi All, Thanks a lot for the answers. It works now... Thanks Using cfsqltype=cf_sql_timestamp will definitely solve that problem. I expect you're just trying to give an example, but if all you're trying to do is move values from one table to another, you can do this en-mass with SQL: cfquery name=putdate datasource=whatever insert into table2(date_field2) select date_field1 from table1 /cfquery Cheers, Kris I have an issue inserting date and time together into a database table from coldfusion. Right now, I am using cfquery to get records from a particular table, in which one of the field is date, and its value in the database is something like 2/14/2007 9:10:12 AM. I am performing insert operation into another table which has to insert this date field into the column of new table. I am doing currently as follow: cfquery name=getDate datasource= maxrows=1 select date_field from table /cfquery cfif getDate.recordcount is not 0 cfquery name=insertDate datasource= insert into table2 (date_field1) values (cfqueryparam cfsqltype=cf_sql_date value=#getDate.date_field#) /cfquery /cfif The problem with this is only the date is getting inserted but not the time. How to format ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322437 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Load Test Apps
Any recommendations on web site load testing apps? I'm considering JMeter and the Microsoft Web Application Stress Tool. Anything else I should be looking at? What's easiest to configure, run, and gives decent reporting? -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322438 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Include one form within another
Hi All, I am faced with a peculiar situation. I have a form, which has a save link at the end of finishing the form. In the form, I have used Javascript to show/display some other hyperlink, and it has its own href attibute and am passing variables with it as URL scope. But now, I need to include another form to post variables instead of using URL scopes. Is this possible to achieve in Coldfusion? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322439 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: my cfqueryparam grievance
Qing Xia wrote: I simply cannot fathom why conversion was done and why it was necessary. Presumably not necessary, definitely undesirable as you describe it. But seeing that value 521636a makes me wonder if something is trying to interpret the value as a hexadecimal for some reason? ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322440 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: my cfqueryparam grievance
It might have been a problem on the SQL server side if a corrupted prepared statement got cached. Changing the cfsqltype effectively cleared the old statement since a new one needed to be recompiled. Can't say I've ever seen what you described but I have seen structure changes a database break cached prepared statements before. ~Brad Original Message Subject: my cfqueryparam grievance From: Qing Xia txiasum...@gmail.com Date: Tue, May 12, 2009 2:16 pm To: cf-talk cf-talk@houseoffusion.com Hello folks, I had a pretty strange experience with CFQueryParam today. Basically, I have an innocent-looking query: cfquery datasource=#application.myDB# name=qGetUser *SELECT* username, password *FROM* someTable *WHERE* someID = cfqueryparam cfsqltype=CF_SQL_INTEGER value= #cookie.theID# maxlength=6 /cfquery This query had worked just fine for nearly a year (since I cfqueryparamed it last summer) until this morning, when it broke. The error messages read: *Message:* Error Executing Database Query. 12 May 2009 01:49:21 PM EDT Diagnostics: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '521636a' to a column of data type int. The error occurred on line 35. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322441 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Load Test Apps
Any recommendations on web site load testing apps? I'm considering JMeter and the Microsoft Web Application Stress Tool. Anything else I should be looking at? What's easiest to configure, run, and gives decent reporting? -Justin you may want to look at Selenium or BadBoy, http://www.badboysoftware.biz/ The nice thing about Badboy is that its a proxy recorder, so it can record everything you do in the browser. Once you're satisfied with it you can export the recording to a Jmeter test xml. then redo the tests in Jmeter. So it allows you to create some complex load tests that can imitate a real world load. It also has some limited reporting capabilities. hth, larry ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322442 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Load Test Apps
I found openSTA pretty easy to get up and running. http://www.opensta.org/ -- Josh -Original Message- From: Justin Scott [mailto:jscott-li...@gravityfree.com] Sent: Tuesday, May 12, 2009 12:26 PM To: cf-talk Subject: Load Test Apps Any recommendations on web site load testing apps? I'm considering JMeter and the Microsoft Web Application Stress Tool. Anything else I should be looking at? What's easiest to configure, run, and gives decent reporting? -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322443 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Include one form within another
I am faced with a peculiar situation. I have a form, which has a save link at the end of finishing the form. In the form, I have used Javascript to show/display some other hyperlink, and it has its own href attibute and am passing variables with it as URL scope. But now, I need to include another form to post variables instead of using URL scopes. Is this possible to achieve in Coldfusion? This has nothing to do with ColdFusion, and everything to do with HTML. In HTML, you can't place one form within another. However, I don't see why they'd need to be nested. I'm not entirely sure what you're trying to accomplish, either, so you may want to describe exactly what outcome you want, rather than talking about the underlying mechanisms of forms, JavaScript, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322444 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: my cfqueryparam grievance
Start logging the value of COOKIE.theID. Just save it somewhere and see if it's ever an unexpected value. Adrian -Original Message- From: Qing Xia [mailto:txiasum...@gmail.com] Sent: 12 May 2009 20:16 To: cf-talk Subject: my cfqueryparam grievance Hello folks, I had a pretty strange experience with CFQueryParam today. Basically, I have an innocent-looking query: cfquery datasource=#application.myDB# name=qGetUser *SELECT* username, password *FROM* someTable *WHERE* someID = cfqueryparam cfsqltype=CF_SQL_INTEGER value= #cookie.theID# maxlength=6 /cfquery This query had worked just fine for nearly a year (since I cfqueryparamed it last summer) until this morning, when it broke. The error messages read: *Message:* Error Executing Database Query. 12 May 2009 01:49:21 PM EDT Diagnostics: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver][SQLServer]Syntax error converting the varchar value '521636a' to a column of data type int. The error occurred on line 35. That error points to the WHERE statement, and it complains the cookie.theID is not an integer-but it is!!! *Even the error messages themselves which contains a CFDump on Cookie scope say it is an integer, of 6 digits!!!* Even more strangely, the error messages always say .converting the varchar value '521636a'. , no matter what the actual cookie.theID value is. Since this query is called from a template that logs users in, I got dozens of error reports, all with this identical error message, even though the actual theID values were very different. When I switched the cfqueryparam cfsqltype to varchar, the error went away!! Of course, the actual data type of the id table column IS varchar, but I had purposefully made it integer in the cfqueryparam, for code readability and more control over the incoming value. L The moral of the story, of course, is that the cfsqltype should probably always match the receiving database table column's data type. But I am just curious. why were my values being converted to 521636a.? 6-digit integer/varchar values are certainly not out of bounds for SQL int data type, so I simply cannot fathom why conversion was done and why it was necessary. A ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322445 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Load Test Apps
The nice thing about Badboy is that its a proxy recorder, so it can record everything you do in the browser. Once you're satisfied with it you can export the recording to a Jmeter test xml. Oh, shiny. I'll definitely check that out as it will make creating the tests a lot easier if it does what you describe. Thanks! -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322446 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Load Test Apps
We found OpenLoad to be reasonable, for a tool that could also read AMF requests, which we required since we have so many tools front ended by Flash and Flex. Steve Cutter Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer Co-Author of Learning Ext JS http://www.packtpub.com/learning-ext-js/book _ http://blog.cutterscrossing.com On 5/12/2009 2:26 PM, Justin Scott wrote: Any recommendations on web site load testing apps? I'm considering JMeter and the Microsoft Web Application Stress Tool. Anything else I should be looking at? What's easiest to configure, run, and gives decent reporting? -Justin ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322447 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Include one form within another
In the form I am creating, sometimes the user would be presented with a link to enroll themselves (This would happen before the actual form submission). So, when they click that which takes them to another form, those form fields should get prepoulated with the form fields that I need to pass from current form. As I said I was using URL, but due to security concerns, I have to use form variables to post data. Thanks I am faced with a peculiar situation. I have a form, which has a save link at the end of finishing the form. In the form, I have used Javascript to show/display some other hyperlink, and it has its own href attibute and am passing variables with it as URL scope. But now, I need to include another form to post variables instead of using URL scopes. Is this possible to achieve in Coldfusion? This has nothing to do with ColdFusion, and everything to do with HTML. In HTML, you can't place one form within another. However, I don't see why they'd need to be nested. I'm not entirely sure what you're trying to accomplish, either, so you may want to describe exactly what outcome you want, rather than talking about the underlying mechanisms of forms, JavaScript, etc. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322448 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: my cfqueryparam grievance
Ummm, not sure why your cookie.theID would shift, but I would say absolutely that the CF_SQL_TYPE is designed to match the database column data type, not the incoming variable parameter. The entire point of the CF_SQL_TYPE is to let the JDBC driver handle the data pass-through for you in a way that is safe and that the database server understands, regardless of what RDBMS you are using. So, I would agree that there are 2 separate issues: what's gone on with your data, independent of the CFQUERY and then ensuring that all CFQUERYPARAMs are designed to match your database rather than your application data, which in this case just happens to be integer. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322449 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Include one form within another
In the form I am creating, sometimes the user would be presented with a link to enroll themselves (This would happen before the actual form submission). So, when they click that which takes them to another form, those form fields should get prepoulated with the form fields that I need to pass from current form. As I said I was using URL, but due to security concerns, I have to use form variables to post data. If you can use JavaScript, you can have your link trigger a JavaScript function that changes the action of the form, then submits the form: a href=javascript:enroll()Enroll/a ... script language=JavaScript function enroll() { document.forms[0].action = enroll.cfm; document.forms[0].submit(); } /script Alternatively, you could have the link set a form field value, then use CF in your action page to check for the existence of the form field value, and show the user the appropriate results in either case. You could just have a checkbox for this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322450 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Include one form within another
fun and learning wrote: As I said I was using URL, but due to security concerns, I have to use form variables to post data. Thanks Dave have you pretty good advice an how to accomplish your goal. I would like to point out the red flag of any statement that indicates post (form as you named them) variables are inherently more secure then get (aka URL) variables. They both suffer from the exact same security concerns. Just because a user does not conveniently see the post form variables in the URL bar of a browser does not make them any more secure or trustworthy then the get form variables that can be. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322451 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Include one form within another
Ian Skinner wrote: Dave have you ... *gave* ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322452 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Coldbox - mxunit testing database interaction
I'm just starting to get into Coldbox and I'm encountering some confusion as to how to *really* test my models and database interaction. So I have the following handler function which is fired upon form submission: cffunction name=editAction cfargument name=event type=any cfscript var rc = arguments.event.getCollection(); var demoModelObj = getModel('demoModel'); demoModelObj.editUserObj(rc); runEvent('demoApp.list'); /cfscript /cffunction ... which calls the following model function: cffunction name=editUserObj cfargument name=rc type=struct required=true hint=request collection / cfscript if (structKeyExists(rc,'userID')) { instance.usersObj.load(rc.userID); instance.usersObj.setAll(rc); instance.usersObj.save(); } /cfscript /cffunction This all works fine and dandy (at least for a 'hello world' coldbox application - I know this code is lacking in a number of places). So now I'm trying to set up a mxunit test to test the behaviors of the handler, but I'm coming to a blank when I try to come up with an assertion for this... I could bundle the whole test up in a cftransaction, and rollback when I'm done - I get that, but the problem is I don't see how to test this w/o writing twice as much code within the test. Take the following beginning of a unit test: cffunction name=testEditAction cfargument name=event type=any cfscript var event = ; var rc = ''; // set up fake form submission rc.userID = 1; rc.userName='testUser'; rc.password = 'testPass'; rc.departmentID_fk = 1; event = execute(demoApp.edit); rc = event.getCollection(); debug(rc); // what to do here? /cfscript /cffunction ... what kind of assertions can I make at the 'what to do here?' line? Is there an easy way to get at instance.usersObj from the model's method, or do I have to have my model return it (seems wrong to have the model return just to allow for debugging)? Am I totally missing the short-bus here? Any insight would be greatly appreciated! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322453 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: table display: row number. without recordset
You could always use cfcontent to render the code and place it in a variable, then output into email. You could also call it via cfhttp and use the response. Be aware, however, JS and CSS do not always play nicely with email clients so make sure you test your target client(s). Judah On Tue, May 12, 2009 at 9:53 AM, Paul Ihrig pih...@gmail.com wrote: there are like 5 separate queries. with sub quires inside the first 3. so current row wouldn't work. unless i wrote a big nasty q0q that's why i really liked the jquery rendering of the row number. On Tue, May 12, 2009 at 12:23 PM, Azadi Saryev az...@sabai-dee.com wrote: how are you rendering the table in cfmail? is it based on query output? use queryname.currentrow then, or a custom row counter if your query uses group output... Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Paul Ihrig wrote: ok here is a weird one. the numbers render fine on display in browser. but if i include the rendered output in a cfmail, i dont get the numbering? i have the js, and css linked correctly.. ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322454 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldbox - mxunit testing database interaction
Jake, I would highly recommend posting this question to the ColdBox and/or MXUnit groups (links below). You are almost guaranteed to get a much greater response from those than you will from CF-Talk. /0.02 I would offer a suggestion, but I'm honestly not exactly sure what you're trying to do, or specifically, what you're struggling with. But that might be just because I a) don't use any of the built-in model stuff, and b) don't really write controller unit tests. I write extensive tests on my model itself, but typically just browser test the controllers. HTH ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322455 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Storing SSN ... I know, I know
Encryption and hashing aren't the same thing, but if there is only one end user for the data (the bank in question) then I'd say that PKI is the way to go. You have the bank set up a public/private key store. They give you the public key. You are able to encrypt the SSN's using the banks public key and store that in the db. Then when they get transmitted to the bank, the bank is able to decrypt them using their private key. The important part is that only the holder of the private key is able to decrypt the ssn's that were encrypted with the matching public key, so you couldn't give up the raw SSN info even if you wanted to because you don't have the private key. Judah On Tue, May 12, 2009 at 7:20 AM, Andy Matthews li...@commadelimited.com wrote: If the user is connecting with ONLY one bank, then see if that bank will let you send them the encrypted SSN and they can decrypt it on their end using whatever they have. Then all you have to do is one way hash it, and they can do the comparison on their end. -Original Message- From: ColdFusion Developer [mailto:cfdev...@gmail.com] Sent: Monday, May 11, 2009 7:19 PM To: cf-talk Subject: Storing SSN ... I know, I know What's a best practice for securely storing a social security number? I've talked myself blue trying to talk my client out of doing this, but the bank he's working with for this project absolutely, positively cannot process his transactions without the SSNs of our users (most of the businesses they work with are payroll companies with secure internal data storage, not a public-facing site like his will be). What would you all recommend as a process/method for storing this info in the most secure way possible? Most of what I've read just says encrypt/decrypt it in the database and you're fine -- but I'm not so sure that's the best course. Thanks in advance! ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322456 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldbox - mxunit testing database interaction
Thanks for the response Matt. I'll repost this there. In the meantime for anyone else viewing this thread, what I'm struggling with is finding out if the save occurred successfully. Maybe the answer is that I should be unit testing the model directly and ignoring this test within the handler's unit tests. Here's what I'm thinking this unit test should look like (partial pseudo-code): cffunction name=testEditAction cfargument name=event type=any cfscript var event = ; var rc = ''; var testObj = ''; // set up fake form submission rc.userID = 1; rc.userName='testUser'; rc.password = 'testPass'; rc.departmentID_fk = 1; event = execute(demoApp.edit); rc = event.getCollection(); debug(rc); testObj = createObject('component','path.to.users'); testObj.load(rc.userID); assertEquals(testObj.get('username'),rc.username,'usernames are not equal.'); assertEquals(testObj.get('password'),rc.password,'passwords are not equal.'); /cfscript /cffunction ... but you can see how this is a MUCH bigger function than what I'm actually trying to test. If I used this approach in a more complex scenario, I could see it taking twice as long to write the test than it did to write the functionality I'm trying to test... Seems like a losing battle - I'm hoping I'm missing something? Thanks! Jake, I would highly recommend posting this question to the ColdBox and/or MXUnit groups (links below). You are almost guaranteed to get a much greater response from those than you will from CF-Talk. /0.02 I would offer a suggestion, but I'm honestly not exactly sure what you're trying to do, or specifically, what you're struggling with. But that might be just because I a) don't use any of the built-in model stuff, and b) don't really write controller unit tests. I write extensive tests on my model itself, but typically just browser test the controllers. HTH ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322457 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
replace width/height values in youtube script
hey guys, developing an app that the user inputs the embed script from a youtube video. what i want however, is for all width= and height= attributes to be replaced with custom values that fit our site layout. just a little lost as how to do this with a regular expression. any help will be greatly appreciated. mike ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322458 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
cross side scripting hotfix for CFMX 6.1 not working
Hi, I am trying to install a hotfix for ColdFusion MX: Cross-site scripting vulnerability in forms found at: http://kb2.adobe.com/cps/966/dcf966be.html. We are running CFMX verion 6,1,0,83762 on Windows server 2003 with IIS 6.0. I have followed the steps exactly as specified on Adobe's site above and restarted the server. The issue is that in CF Administrator, the hotfix is not getting picked up. According to the Adobe's website above I should see 6,1,0 hf64586_611 in the version section which doesn't seem to be the case. I still see 6,1,0,83762. Any ideas? Thanks, Vineet ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322459 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 Hosting recommendations
gosh vivio is cheap!! can anyone else vouch for these guys? i would be keen to try them out. Yes, if that's the chosen path then Viviotech can provide a VPS for $19.95 per month. http://www.viviotech.net/vps.cfm mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:322460 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4