RE: Testing for existance of a Structure within an Array
So, there is no real reason to check if one exists as it will always contain a struct ;-) -Original Message- From: Brant Winter [mailto:[EMAIL PROTECTED] Sent: 02 December 2004 12:55 To: CF-Talk Subject: Re: Testing for existance of a Structure within an Array The structure should initially be empty, or it may contain a value for anyone of 24 different errored fields. ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185915 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
well would you run into a problem with the array if you set each array index to the current row of your query loop. For example errorArray[1].etc errorArray[5].etc errorArray[22].etc I thought that when building and array you have to sequence your index values. If this is true you might need to create some other counter with in the loop for example *Increment the error Index *Now append the array* -- Original Message -- From: Brant Winter <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] Date: Thu, 02 Dec 2004 08:31:16 -0400 >I have spent hours trying to write a function for error checking a csv file. >In my function I want to check each field, and if there is an error put the >errored text in a structure in an array, the array index will be relevant to >the current row id of the query i am looping, and there will be a structure of >the errors in each array element ( if that makes sense ) > >In total I have 24 fields of each row to check, hence me wanting to put the >errors in an array so that I can provide an error report to the person >uploading the csv file. > >I have no idea how to test for the existance of the structure for each item i >want to test, i create the array first, then i will check each type of field, >but i dont want to issue a > if one is already created. > > > > > > > > > ~| Special thanks to the CF Community Suite Silver Sponsor - CFDynamics http://www.cfdynamics.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
>Rather than putting the error structure into an array, why not use a >structure? Then rather than having an array whuch is mostly empty >you'll have a structure which only contains errors. > >so rather than >errorsArray[rowNumber] = stError; >you could do >errorsStructure[rowNumber] = stError; > >does that makes sense? or did i misunderstand what you're doing? > >Cheers >Bert > >On Thu, 02 Dec 2004 08:31:16 -0400, Brant Winter <[EMAIL PROTECTED]> wrote: >><<< if there is an error put the errored text in a structure in >an array, the array index will be relevant to the current row id of >the query i am looping, and there will be a structure of the errors in >each array element ( if that makes sense ) >> Bert - I think that is I have 24 fields per row, if I have multiple errors per row they wont be able to be written as a group of errors if you know what i mean ? What I want is an array with the row number as the element number, and in that a structure that "may" have 24 elements in total. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185918 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
Then stAllMyErrors should contain a structure of any errors for each row which had an error, and nothing else. Yes? No? Bert On Thu, 02 Dec 2004 09:15:05 -0400, Brant Winter <[EMAIL PROTECTED]> wrote: <<<>>> > Bert - I think that is I have 24 fields per row, if I have multiple errors > per row they wont be able to be written as a group of errors if you know what > i mean ? What I want is an array with the row number as the element number, > and in that a structure that "may" have 24 elements in total. > > ~| Special thanks to the CF Community Suite Silver Sponsor - New Atlanta http://www.newatlanta.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185920 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
The following code is pretty much doing what I need, but I am not sure how to call it from my code. Basically I read in a CSV file using the following line of code: ~| Special thanks to the CF Community Suite Silver Sponsor - RUWebby http://www.ruwebby.com Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185922 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
The following code is pretty much doing what I need, but I am not sure how to call it from my code. Basically I read in a CSV file using the following line of code: ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185923 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for existance of a Structure within an Array
My example code is being truncated from this list somehow. ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185925 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Testing for existance of a Structure within an Array
> My example code is being truncated from this list somehow. Prolly the hyphens... If you have -- (or a some other amount) in the code it cuts it. Make sure there isn't and the message isn't too long -- dc ~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185928 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
CFUNITED-06 interview 20: John Paul Ashenfelter - Testing CF Applications
In this issue of ColdFusion conference and training news: * NEW Scheduler Program is here and ready! * SATURDAY REPEATS ANNOUNCED * Popular sessions Survey WINNER announced. * AJAX pre-conference class is now full. * CFUNITED 2006 will be available on video after the event * Order a DVD copy of CFUNITED 2005 recordings and materials/laptop bag * Fusetalk Forum on CFUNITED Talk to other Attendees. * CFLive - Thursday 12:30pm - John Paul Ashenfelter on Agile Programming * Interview with John Paul Ashenfelter on Testing CF Applications CFUNITED is the premier ColdFusion Conference near Washington DC 6/28-7/1/06 (Four whole days!) Check out speakers and topics at http://www.cfunited.com/ - Michael Smith TeraTech, Inc Q: How [CFUNITED] will help in my current job? CFUNITED Alumni Tony W. said: 1. Networking opp. with the HIGHEST Rated CF'ers in the business. 2. New techniques for legacy functionality 3. New applications for the new features 4. industry partners with lots to offer will be there 5. Q&A Sessions, BOF Sessions, Roundtable Chats with Industry experts It's a highly valuable event that will connect you with the ColdFusion community like no other event. - Tony Exciting Opportunity Available! TeraTech is seeking a creative and energetic PT or FT ColdFusion Developer to help maintain the CFUNITED website. For more details: http://cf.teratech.com/index.cfm?go=About.JobDetail&JobID=11 Conference and training news * Upcoming TeraTech classes Cost $59 - $349 see http://www.teratech.com/training/ for more details and registration FB101 - Intro to FuseboxMay 23 2006 FB201 - Intermediate FuseboxJun 6 2006 CF209 - Upgrade to CFMX 7 Jun 13 2006 * CF209 - Upgrading to CFMX 7 (new class) Are you new to CFMX 7? Do you want to learn all the new features fast? This class will get you upto speed on it all: Flash forms, XML forms, PDF generation, headers and footers, the report builder, sub reports, event gateways, CFC new features, Web Services, Verity enhancements, CF Application Framework, CF Administrator API and what is new in CF Administrator. * Pre-conference classes Cost $449 see http://www.cfunited.com/classes06.cfm for more details and registration Location: Bethesda North Marriott and Conference Center CU210 Leader of the Pack (strategies for building better software) - Simon Horwith - Monday 6/26 CU211 Fundamentals of Relational Database - Kurtis D. Leatham - Monday 6/26 CU212 ColdFusion Server Administration: JRun J2EE Deployment - Adam Wayne Lehman - Monday 6/26 CU213 Testing ColdFusion - John Paul Ashenfelter - Monday 6/26 CU214 Ajax intensive for ColdFusion Developers - Rob Gonda - Tuesday 6/27 (FULL!) CU215 XML, XPath, and XSLT for ColdFusion Developers - Jeff Peters - Tuesday 6/27 CU216 Domain Modeling - Hal Helms - Tuesday 6/27 CU217 Beyond Basic SQL for CF - Nate Nelson - Tuesday 6/27 CFUNITED NEWS! * We are excited to present our new AJAX based SCHEDULER PROGRAM!! Personalize your schedule and reserve the sessions you want to attend. http://www.cfunited.com/scheduler/ You must be registered for CFUNITED to use this program. This program was created by Joe Danziger. * SATURDAY REPEATS ANNOUNCED! We have finally decided on our repeat sessions for Saturday based on your survey responses. Thanks for your patience. The Saturday Schedule will also be added to the Scheduler soon. For now, view repeats at http://www.cfunited.com/schedule.cfm * SURVEY WINNER OF A FREE TICKET TO CFUNITED IS.Casey Dougall from New York! Congrats! Claim your prize at info @ teratech.com Thank you to everyone who filled out the survey we can't wait to see you in June! * CFUNITED/Video! http://www.cfunited.com/video_recordings.cfm Can't make it to the event? Attending but want to see sessions that you can't get to? Want to see a favorite session again to learn even more? Buy CFUNITED/Video and watch whenever you want from you own computer! $649 includes the show bag and goodies that attendees receive. Sample video and more information coming soon. This price is a license for one named individual to view the video - if you need a site license for multiple viewers contact Liz at liz (at) teratech.com CFUNITED 2006 Attendees get $400 off the price! Already registered for CFUNITED but want the videos too? Upgrade for just $200 to both attend and get videos of all sessions. * See list of prizes from our sponsors. http://www.cfunited.com/prizes.cfm * Order a DVD copy of CFUNITED 2005's recordings on MP3 http://www.cfunited.com/dvd_recordings.cfm All sessions were recorded at CFUNITED-05, but there were technical problems that left a portion of the session's MP3 recordings inaudible. This disc includes all the audible recordings. We apologize if any of your favorite sessions are not available for your listening. Also, you can order your own copy plus the 2005 bookbag and materi
SOT: Load testing software for website with AD integrated authentication
We're having some serious trouble with an internal website that uses IIS pass-through authentication that logs you in automatically based on the user you're logged into your computer as. The problem is, I can't find any load testing apps that will test a site with that type of login. My thinking is that it doesn't exist because it would have to spoof to AD authentication which shouldn't be able to be done or it defeats the purpose of that type of security. Can anyone confirm this or point us toward a product that does it? I know most work with form authentication and cookies and such but none seem to do pass-through. I'm not interested in other solutions for debugging the code and finding the slow parts as we are unable to do that for contractual reasons. Thanks for your help. John ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309541 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Broken Images / Testing for file existence - JS to the rescue
> I have an application where I list several items on a page and display an > image for that item based on a reference number (ie, productnum+.jpg). The > database table does not tell me whether there is an image for that item > and there are many that do have one. > > I'd like to display an alternate image (or nothing at all) when there is > no image present, but I can't see using an for every > item for 50 or so on a page. Plus, I can't even do that because I'm > grabbing the images from a different server via http only ( SRC="http://otherserver/path/number.jpg>)... Tony, Let the client-side box do the work, with JavaScript. Here's a demo page that tests for the presence of an image, and swaps the missing image with a default image... I'm sure you can modify it to your needs: Image Not Found Test A big thanks to Jeff Howden at evolt.org for pointing out the onError event handler for tags to me initially. Ron Allen Hornbaker President/CTO Humankind Systems, Inc. http://humankindsystems.com mailto:[EMAIL PROTECTED] ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Broken Images / Testing for file existence - JS to the rescue
[EMAIL PROTECTED] wrote: > Let the client-side box do the work, with JavaScript. Interesting possibility. Of course, that still clutters your server log with 404 errors, which may be a consideration. And it requires additional network traffic, which may slow down the page display. But there are always tradeoffs. Keith C. Ivey <[EMAIL PROTECTED]> Webmaster, EEI Communications 66 Canal Center Plaza, Suite 200 Alexandria, VA 22314 Telephone: 703-683-0683 Fax: 703-683-4915 Web Site: http://www.eeicommunications.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Broken Images / Testing for file existence - JS to the rescue
This sounds interesting and I seem to have missed the suggestion/code... What was it? > [EMAIL PROTECTED] wrote: > > > Let the client-side box do the work, with JavaScript. > > Interesting possibility. Of course, that still clutters your > server log with 404 errors, which may be a consideration. And > it requires additional network traffic, which may slow down the > page display. But there are always tradeoffs. > > Keith C. Ivey <[EMAIL PROTECTED]> > Webmaster, EEI Communications > 66 Canal Center Plaza, Suite 200 > Alexandria, VA 22314 > Telephone: 703-683-0683 > Fax: 703-683-4915 > Web Site: http://www.eeicommunications.com > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Broken Images / Testing for file existence - JS to the rescue
Tony,
Let the client-side box do the work, with JavaScript. Here's a demo page
that tests for the presence of an image, and swaps the missing image with a
default image... I'm sure you can modify it to your needs:
Image Not Found Test
<!--
// make DARN sure this replacementImage file IS
// present and accounted for, or you'll get a nasty
// loop with repeated calls to this function.
// Also, enter the exact pixel dimensions of the
// replacement image. IE will respect it and resize...
// NS4 will load the replacementImage in the same
// dimensions as the missing one
var replacementImage = new Image(128,124);
replacementImage.src = '/images/notFound.gif';
function imageLoadError(myImage){
myImage.src=replacementImage.src
return false;
}
// -->
Tested with IE and NS v4+ on PC; even if it doesn't work on other browsers,
it shouldn't break anything since they'll just ignore the event handler.
A big thanks to Jeff Howden at evolt.org for pointing out the onError event
handler for tags to me initially.
Ron Allen Hornbaker
President/CTO
Humankind Systems, Inc.
http://humankindsystems.com
mailto:[EMAIL PROTECTED]
> -Original Message-
> From: Tony Schreiber [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, March 14, 2001 6:38 AM
> To: CF-Talk
> Subject: RE: Broken Images / Testing for file existence - JS to the
> rescue
>
>
> This sounds interesting and I seem to have missed the suggestion/code...
> What was it?
>
> > [EMAIL PROTECTED] wrote:
> >
> > > Let the client-side box do the work, with JavaScript.
> >
> > Interesting possibility. Of course, that still clutters your
> > server log with 404 errors, which may be a consideration. And
> > it requires additional network traffic, which may slow down the
> > page display. But there are always tradeoffs.
> >
> > Keith C. Ivey <[EMAIL PROTECTED]>
> > Webmaster, EEI Communications
> > 66 Canal Center Plaza, Suite 200
> > Alexandria, VA 22314
> > Telephone: 703-683-0683
> > Fax: 703-683-4915
> > Web Site: http://www.eeicommunications.com
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
testing to see if cfid and cftoken already exist in database
I'm trying to get my head around client variables ... in a scenario where they're placed in a database for later testing for existence ... but I can't figure out how to test for there existence??? I know this is probably a no-brainer, but that would be me at this point Here's how I'm insert them into a database (I assume this is a reasonable way): INSERT INTO tracking (LastVisit, token, cfid) VALUES (#Client.LastVisit#, '#client.cftoken#', '#client.cfid#') Now once these are in the database, how do I test for there existence in subsequent visits?? Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
CFUNITED news: Testing for Accessibility, MiniMAX, Journey to CFUNITED video contest
Here is the ColdFusion and Fusebox news: * New CFUNITED attendee Interview Video and Journey to CFUNITED contest * MiniMAX June 26th, pre-CFUnited conference http://www.minimaxconference.com/ * CFLive Schedule * IPv6 Conference 5/10/07 http://www.IPv6.TheNewNewInternet.com/ * New sponsor Savvy Software * New CFUNITED podcasts released http://cfunited.com/blog/index.cfm/podcast - Tom Link - Flex 2.0 Event Model - Sean Corfield - Objects and Persistence * Fusebox new samples apps under development * Interview with Sandra Clark on "Testing for Accessibility" "It is the largest conference for CF targeted specifically for developers. It is run by developers for developers. I can learn from other developers real world experience and real user case studies so I can see what my collegues at other organizations are doing. And it is just a great time to be had by all." -Barbara ONeal (CFUNITED attendee) Other great quotes from attendees about "Why people should attend CFUnited" http://cfunited.com/blog/index.cfm/2007/4/30/Survey-Contest-Winner * New CFUNITED attendee Interview Video and Journey to CFUNITED contest Have you seen the interview video on our homepage yet? Yeah, the one with Rob Gonda's face on it. We put together a little something from interviews we conducted at CFUnited 2006. See peoples reactions to our event and hear what they like about CFUnited. Thank you CFDynamics for helping us publish the video online. Also Nafisa, a CFUnited staff member, will be putting together the next video soon. She is conducting a new contest for attendees. Contest rules and results: Tell us your journey to CFUnited and what you are looking forward to most. Post your short video on YouTube with CFUNITED Journey in the title, email to nafisa (at) teratech.com with CFUNITED Journey in the subject line and she will choose 3 entries to post on our home page. Those who get re-posted on our website will get fame, fortune and be given a $50 gift certificate to BestBuy! Submit entries by June 5th. Have fun! Here are some ideas: * the moment when you receive your pamphlet in the mail * telling your friends about CFUnited * choosing your sessions online * when you receive your cap or t-shirt in the mail * tell us what you look forward to the most * funny tales about your past experiences * footage/pictures from your journey last year - the journey can be put together with photo's, video, animation, etc Entries will be judged on originality, humor and how well they convey the spirit of CFUNITED. All entries grant permission to TeraTech to display them on the CFUNITED website, at the show and in other media. -final video should be no longer then 5 mins long. * MiniMAX June 26th, pre-CFUnited conference http://www.minimaxconference.com/ Join dataTV's Adam Bell for the prelude to the CFUnited Conference on Tuesday Evening, June 26th at 8PM ET at the Marriott Hotel in North Bethesda, MD for MiniMAX's seventh annual event. This event is free to anyone who wants to attend. You don't even need to be registered for CFUnited to join Adam Bell and friends at this fun evening event! You must signup to reserve a seat at http://www.minimaxconference.com/ * CFLive Schedule We will be holding a series of online talks with CFUNITED speakers starting next Thursday. Watch out for the URL next week. 5/10/07 Charlie Arehart New in CFMX 6&7: What Did You Miss? 5/17/07 Simon Horwith - Architecting and Optimizing CF Applications for Performance and Scalability 5/24/07 Rob Gonda Flex Intensive for ColdFusion Developers 5/31/07 O?uz Demirkap? Multi Language Applications in CF in Theory and Practice 6/7/07 Peter Bell "Practical Code Generation: By Example" 6/14/07 Patrick Quinn UI design concepts 6/21/07 Mark Drew "CFeclipse Plus!" 6/28/07 Live from show * IPv6 Conference 5/10/07 There are less than 8 days left register for The New New Internet: IPv6 Conference coming to Arlington VA on May 10th! The event covers the most important and timely IPv6 issues with some first time appearances including: * First-time panel with the entire CIO Council IPv6 Working Group * Carol Bales - Senior Policy Analyst, OMB * Fred Schobert - Networx Program Manager, GSA * Dr. Ray Johnson - CTO Lockheed Martin * Dr. John D. Howard - Deputy Director of National Intelligence for Intelligence Community Enterprise Services * Jim Bound - CTO IPv6 Forum * Brad Ryan - Chief Technical Architect, Juniper Networks For the most up-to-date information and registration visit: http://www.IPv6.TheNewNewInternet.com Please use the following link to get $25 off your registration by using my promotion code "JDK07": https://www.execbizevents.com/ExecutiveBiz/events/register.php?event_id=60&promo=JDK07 * New CFUNITED Sponsor, Savvy Software We have a new Bronze LevelSponsor! Savvy Software is the developer of Savvy C
Testing: Things that mess up CF and semi-related web languages...
Hey folks! A good web QA person has an intuitive feeling for things that blow up web-based apps; unfortunately, you can't package that intuition, but you can share some of the things to look for. I'd like to propose a little community learning project, where folks send in their list of things that blow up web apps (CF and JavaScript); I'll be more than happy to package the results (absolutely giving full credit!!!) and return them back to the community in some way (email, website, whatever). These things shouldn't be large testing things, like "this is how we test". I'm looking more for things like: 1) Test a form field and the resulting displays with a # sign in it. Can blow up some cfoutputs depending on how they're formatted. 2) Test a field with double quotes. Can blow up JavaScript, depending on how you've written the JS. Things like that. Thanks for helping out the community! I hope to be returning a huge list of test items with lots of names associated with them! - Randy Smith [EMAIL PROTECTED] Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SOT: Load testing software for website with AD integrated authentication
On Wed, Jul 23, 2008 at 2:18 PM, Burns, John D <[EMAIL PROTECTED]> wrote: > We're having some serious trouble with an internal website that uses IIS > pass-through authentication that logs you in automatically based on the > user you're logged into your computer as. The problem is, I can't find > any load testing apps that will test a site with that type of login. My > thinking is that it doesn't exist because it would have to spoof to AD > authentication which shouldn't be able to be done or it defeats the > purpose of that type of security. Can anyone confirm this or point us > toward a product that does it? I know most work with form authentication > and cookies and such but none seem to do pass-through. I'm not > interested in other solutions for debugging the code and finding the > slow parts as we are unable to do that for contractual reasons. Thanks > for your help. What makes you think that it is a load issue? thanks, speeves ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309542 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: Load testing software for website with AD integrated authentication
On Wed, Jul 23, 2008 at 3:18 PM, Burns, John D <[EMAIL PROTECTED]> wrote: > Can anyone confirm this or point us > toward a product that does it? > This may do what you need http://www.iis.net/downloads/default.aspx?tabid=34&g=6&i=1466 ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309544 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 testing software for website with AD integrated authenti cation
> We're having some serious trouble with an internal website > that uses IIS pass-through authentication that logs you in > automatically based on the user you're logged into your > computer as. The problem is, I can't find any load testing > apps that will test a site with that type of login. My > thinking is that it doesn't exist because it would have to > spoof to AD authentication which shouldn't be able to be done > or it defeats the purpose of that type of security. Can > anyone confirm this or point us toward a product that does > it? I know most work with form authentication and cookies and > such but none seem to do pass-through. I'm not interested in > other solutions for debugging the code and finding the slow > parts as we are unable to do that for contractual reasons. > Thanks for your help. Almost any load testing tool will do this. There's nothing specific to AD here, you simply have to record your browser session from an authenticated machine. The credentials are just another HTTP request header. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309546 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 testing software for website with AD integrated authenti cation
How exactly do you "record" this? Is it a cookie that's set or do you need a network traffic sniffer to pick up whatever header is being passed? How often do the tokens or whatever is passed get changed? I'm assuming each time you login there's something that gets set? -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 23, 2008 5:27 PM To: CF-Talk Subject: RE: Load testing software for website with AD integrated authenti cation > We're having some serious trouble with an internal website > that uses IIS pass-through authentication that logs you in > automatically based on the user you're logged into your > computer as. The problem is, I can't find any load testing > apps that will test a site with that type of login. My > thinking is that it doesn't exist because it would have to > spoof to AD authentication which shouldn't be able to be done > or it defeats the purpose of that type of security. Can > anyone confirm this or point us toward a product that does > it? I know most work with form authentication and cookies and > such but none seem to do pass-through. I'm not interested in > other solutions for debugging the code and finding the slow > parts as we are unable to do that for contractual reasons. > Thanks for your help. Almost any load testing tool will do this. There's nothing specific to AD here, you simply have to record your browser session from an authenticated machine. The credentials are just another HTTP request header. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309571 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 testing software for website with AD integrated authenti cation
Your load testing tool, if it's worth anything, should come with a browser proxy that records everything you do and provides a script you can then edit and to which you can add username/password pairs from a text file. On Thu, Jul 24, 2008 at 8:35 PM, Burns, John D <[EMAIL PROTECTED]> wrote: > How exactly do you "record" this? Is it a cookie that's set or do you > need a network traffic sniffer to pick up whatever header is being > passed? How often do the tokens or whatever is passed get changed? I'm > assuming each time you login there's something that gets set? > > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 23, 2008 5:27 PM > To: CF-Talk > Subject: RE: Load testing software for website with AD integrated > authenti cation -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309580 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 testing software for website with AD integrated authenti cation
Any suggestions on a tool like this? We haven't invested in anything yet so I'm willing to take suggestions. Just looking to find the right tool. -Original Message- From: James Holmes [mailto:[EMAIL PROTECTED] Sent: Thursday, July 24, 2008 9:25 AM To: CF-Talk Subject: Re: Load testing software for website with AD integrated authenti cation Your load testing tool, if it's worth anything, should come with a browser proxy that records everything you do and provides a script you can then edit and to which you can add username/password pairs from a text file. On Thu, Jul 24, 2008 at 8:35 PM, Burns, John D <[EMAIL PROTECTED]> wrote: > How exactly do you "record" this? Is it a cookie that's set or do you > need a network traffic sniffer to pick up whatever header is being > passed? How often do the tokens or whatever is passed get changed? I'm > assuming each time you login there's something that gets set? > > -Original Message- > From: Dave Watts [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 23, 2008 5:27 PM > To: CF-Talk > Subject: RE: Load testing software for website with AD integrated > authenti cation -- mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309583 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 testing software for website with AD integrated authenti cation
>> We're having some serious trouble with an internal website > >Almost any load testing tool will do this. There's nothing specific to AD >here, you simply have to record your browser session from an authenticated >machine. The credentials are just another HTTP request header. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ One combination I find that works very well is the Badboy (http://www.badboy.com.au/) tool for proxy recording and the Apache Jakarta Project's JMeter (jakarta.apache.org/jmeter/) load testing tool. You record your session using BadBoy, then export the scripts to Jmeter. Tweak them a bit and you have a very good load test setup in a very short time. hth, larry ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309584 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 testing software for website with AD integrated authenti cation
> How exactly do you "record" this? Is it a cookie that's set > or do you need a network traffic sniffer to pick up whatever > header is being passed? How often do the tokens or whatever > is passed get changed? I'm assuming each time you login > there's something that gets set? Yes, every time you login, your browser sends an HTTP request header for every subsequent request. If you use a load testing tool that lets you record a browser session to create a script, this will be recorded along with everything else. Then when you run the script, the load testing tool will send the same HTTP request header along with everything else. 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! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:309641 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Testing for the existence of an image file on another web server
I want to include an image file that is on a server at another location. If no image exists, I want to display a message stating "No Image Available". I had it working fine for local images..here's the code: http://server.com/images/" & #Trim(sku)# & ".gif"> No Image Available How do I do that seam test for a remote server that I'm accessing via HTTP (I have permission to use their image files)? Would I do something with CFHTTP and then test for a valid image response? Thanks! John www.cornells.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
followon: testing to see if cfid and cftoken already exist in database
I meant one particular set of these variables to see if a particular visitor has been there before -Original Message- From: Tim Laureska [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 13, 2003 4:55 PM To: [EMAIL PROTECTED] Subject: testing to see if cfid and cftoken already exist in database I'm trying to get my head around client variables ... in a scenario where they're placed in a database for later testing for existence ... but I can't figure out how to test for there existence??? I know this is probably a no-brainer, but that would be me at this point Here's how I'm insert them into a database (I assume this is a reasonable way): INSERT INTO tracking (LastVisit, token, cfid) VALUES (#Client.LastVisit#, '#client.cftoken#', '#client.cfid#') Now once these are in the database, how do I test for there existence in subsequent visits?? Tim ~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Anyplace to pick up outdated browser versions for testing <-online emulator
There is also an online browser emulator: http://www.dejavu.org/emulator.htm Pretty cool huh? At 09:54 PM 11/22/00 -0500, you wrote: >Or you could use VMware to create a virtual PC on your box. It's very cool. > >-Original Message- >From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] > > > > >I need to get some older versions of MSIE and Netscape in order to test out > >style sheets that will be dynamically assigned based on browser version as > >detected by CF. Does anyone know where these can be found? I've searched > >around on MS and Netscape site but can't find any archives of outdated > >browser versions. > >You will need to install IE 3.0 on a separate PC (or on another partition) >as you >can't run more than one version. > >~~ >Structure your ColdFusion code with Fusebox. Get the official book at >http://www.fusionauthority.com/bkinfo.cfm > >Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ >Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > >-=-=- >SBG-Priority: 4 (Low) http://www.internz.com/SpamBeGone/ -- Michael She I m a g i n e C o m m u n i c a t i o n s Company E-mail: [EMAIL PROTECTED] Personal E-mail: [EMAIL PROTECTED] ICQ UIN: #243466 Personal Homepage: http://www.michaelshe.com (Under Construction) Imagine Communications: http://www.imagineer.net PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1 ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Testing for the existence of an image file on another web server
Use cfhttp reguest the image as the URL: "http://www.someotherdomain.com/somedirectory/someimage.jpg" Then if http.FileContent contains a "404" error code, the image was not found. HTH Dick At 10:17 AM -0400 4/2/01, John Fix 3rd wrote: >I want to include an image file that is on a server at another location. >If no image exists, I want to display a message stating "No Image >Available". I had it working fine for local images..here's the code: > > > >http://server.com/images/" & #Trim(sku)# & >".gif"> > > >No Image Available > > >How do I do that seam test for a remote server that I'm accessing via >HTTP (I have permission to use their image files)? Would I do something >with CFHTTP and then test for a valid image response? > >Thanks! > >John >www.cornells.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Testing for the existence of an image file on another web server
John, here's the best thing I found. Courtesy of Ron on this list: > > > > > > Image Not Found Test > > > > > > > > > > > onError="imageLoadError(this);"> > > > > Works great. As long as you don't mind the 404's in your error log. ALthough you can make an ignore rule in your webserver for the server you're hitting... > >I want to include an image file that is on a server at another location. > >If no image exists, I want to display a message stating "No Image > >Available". I had it working fine for local images..here's the code: > > > > > > > >http://server.com/images/" & #Trim(sku)# & > >".gif"> > > > > > >No Image Available > > > > > >How do I do that seam test for a remote server that I'm accessing via > >HTTP (I have permission to use their image files)? Would I do something > >with CFHTTP and then test for a valid image response? > > > >Thanks! > > > >John > >www.cornells.com > > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
CFUNITED news: Continuous Testing for Flex and CF, iPod, 8 days to CFUNITED.
Michael Here is the ColdFusion and Fusebox news: * Only 8 days left until CFUNITED-07! Managers Guide to CFUNITED. * CFUNITED Europe Call for Speakers OPEN * Open Source Code Off Results! Winner announced on Friday * CFUNITED-07 Manager's Guide. "Why send your developers to CFUNITED?" * CFMeetup Thur 12:30pm - Patrick Quinn Application Server Analytics * New CFUNITED podcasts released http://cfunited.com/blog/index.cfm/podcast - Rob Gonda: Flex Intensive for ColdFusion Dev - Peter Bell: Practical Code Generation by Example * New Fusebox website due for release at CFUNITED. "Got Fusebox?" t-shirt. * Fusebox YouTube video competition ends 6/22/07 * Interview with Kurtis D Leatham on "Structures, Arrays, and database" * Interview with Thomas Burleson about on "Continuous Testing with Flex and ColdFusion Projects". "After attending CFUnited Express in NYC this Spring, I saw the potential of CFUnited 2007. Its a conference full of information that will get you up to date on all the latest and greatest in the ColdFusion Developers world today. I am not missing any Teratech conferences anymore. Frameworks Conference and CFUnited Express proved that you can get so much more knowledge and training from few days on the conference, versus paying much more attending a class and getting much less for the money. I spoke to CFUnited 2006 attendees who cant stop praising the event. There are sessions for everyone, from developer to the manager. Can't wait for June 27th. Thanks!" -Elena A. Federal Reserve Bank NY (CFUNITED/Express NYC attendee) Other great quotes from attendees about "Why people should attend CFUnited" http://cfunited.com/blog/index.cfm/2007/4/30/Survey-Contest-Winner * Only 8 days left until CFUNITED-07! Hotel info. Managers Guide to CFUINTED. Need help getting your manager to understand why it makes sense to go to CFUNITED? Download our Managers Guide to CFUINTED at http://cfunited.com/go/managers-guide . Takes less than 5 minutes to read. * CFUNITED Europe Call for Speakers OPEN We've announced the CFUnited Europe Call for Speakers! http://callforspeakers.cfconf.org/?event=suggest&eventId=165 Date: March 12-13th 2008 Location: Novotel London West, UK To celebrate the 10 year anniversary of CFUnited we're going to Europe to share the CFUnited Experience with all the ColdFusion developers overseas. http://europe.cfunited.com/ * CFUNITED-07 pre-conference classes Registration and more info at http://cfunited.com/go/classes Monday 6/25 CU221 Rob Gonda Flex Intensive for ColdFusion Developers CU222 Ajay Sathuluri CF Server Administration for Security and More CU223 Oguz Demirkapi Multi Language Applications in CF in Theory and Practice CU224 Nate Nelson Advanced Database Tuesday 6/26 CU225 Peter Bell Practical Code Generation: By Example CU226 Simon Horwith Architecting and Optimizing CF Applications for Performance and Scalability CU227 John Paul Ashenfelter Best Practice Bootcamp for Developers CU228 Charlie Arehart New in CFMX 6 and 7: What Did You Miss? * Open Source Code Off Results Go to the CFUnited Wiki and check out the Open Source Contest Entries. We had some great projects submitted and it definitely shows off our talented community! Winners will be announced on Friday June 15th by the Advisory Board. If you have your own open source project you'd like to share, please list it on the CFUnited wiki! http://wiki.cfunited.com/index.cfm/Open_Source_Contest_Entries * CFUNITED-07 Manager's Guide "Why send your developers to CFUnited?" This question and more are answered in this Manager's Guide to how CFUnited benefits your company and how being an attendee contributes largely to the CF Community. http://cfunited.com/go/managers-guide * ColdFusion is Alive - partial survey results Some of you may have read the Computer World article listing ColdFusion as one of 10 dead languages and Ben Forta's response, Ray's opinions and Adam's rant on this. Obviously ColdFusion is not dying but how do you convice your clients that CF is the right solution? I am giving a talk at CFUNITED-07 on "Selling ColdFusion to Clients" that will cover what strategies to use for selling ColdFusion to clients and how to deal with common objections that clients have. I also have partial results of the survey on your experience with what arguments have been working on the street. Read more and see the survey results at: http://teratech.com/blog/index.cfm/2007/5/30/ColdFusion-is-Alive-Partial-survey-results (If you haven't taken the survey yet then please do! There is a link from the above page to it) * How to get your boss to send you to CFUNITED Having trouble getting authorization to attend CFUNITED - check out these top reasons for coming! http://cfunited.com/blog/index.cfm/20
Did my own CF/SQL Server performance testing, my world is turned upside down.
Well, OK, not that dramatic, but every DBA I have ever known has told me that if you want performance, you use stored procedures. My quick test this evening has me rethinking that. Using essentially the same query (basically a login query against a single table, pass in username and password, return ID, first name, last name, username, and email address), looped through each query 1,000 times, did that 10 times, in 3 different variations. I used CFTIMER for timings, SQL Server 2000 on my development workstation running MX7: * Straight SQL in a cfquery * Straight SQL using CFQUERYPARAM in a CFQUERY * Stored procedure using CFSTOREDPROC The straight query using CFQUERYPARAM was consistently the fastest. I fully expected this to be the case when compared to using a straight query without cfqueryparam, but I was really surprised to find that the stored procedure was consistently the SLOWEST. Has anyone else found this to be the case? I'm really thinking about ripping out all of my SP's and just using queries, it would make my life easier on a number of levels. I have all of my queries as methods in a CFC, so code reuse is about the same that it would be when using a stored procedure. Pete ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241054 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Testing for the existence of a dynamic structure that may or may not exist.
Is there any way to do this w/o causing an error/exception if the structure does not exist? Che Vilnonis Application Developer Advertising Systems Incorporated 8470C Remington Avenue Pennsauken, NJ 08110 p: 856.488.2211 f: 856.488.1990 www.asitv.com ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282731 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Did my own CF/SQL Server performance testing, my world is turned upside down.
here's what i have found... i agree. when it comes to small queries like that with NOT MUCH LOGIC involved. When it comes to a larger Stored Proc with LOTS of gobbledeegoop, i think it changes then. but yeah, for the most part, i refactored most if not all of my smaller queries into straight sql code, with cfquery. tw On 5/20/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > Well, OK, not that dramatic, but every DBA I have ever known has told > me that if you want performance, you use stored procedures. My quick > test this evening has me rethinking that. > > Using essentially the same query (basically a login query against a > single table, pass in username and password, return ID, first name, > last name, username, and email address), looped through each query > 1,000 times, did that 10 times, in 3 different variations. I used > CFTIMER for timings, SQL Server 2000 on my development workstation > running MX7: > > * Straight SQL in a cfquery > * Straight SQL using CFQUERYPARAM in a CFQUERY > * Stored procedure using CFSTOREDPROC > > The straight query using CFQUERYPARAM was consistently the fastest. I > fully expected this to be the case when compared to using a straight > query without cfqueryparam, but I was really surprised to find that > the stored procedure was consistently the SLOWEST. > > Has anyone else found this to be the case? I'm really thinking about > ripping out all of my SP's and just using queries, it would make my > life easier on a number of levels. I have all of my queries as > methods in a CFC, so code reuse is about the same that it would be > when using a stored procedure. > > Pete > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241055 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Did my own CF/SQL Server performance testing, my world is turned upside down.
On 5/20/06, Pete Ruckelshaus <[EMAIL PROTECTED]> wrote: > Has anyone else found this to be the case? I'm really thinking about > ripping out all of my SP's and just using queries, it would make my > life easier on a number of levels. I have all of my queries as > methods in a CFC, so code reuse is about the same that it would be > when using a stored procedure. Try using the stored procedure not using cfstoredproc - maybe it's the culprit. -- Phillip Beazley Onvix -- Website Hosting, Development & E-commerce Visit http://www.onvix.com/ or call 727-578-9600. ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241056 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Testing for the existence of a dynamic structure that may or may not exist.
StructKeyExists is good for this. Steve >Is there any way to do this w/o causing an error/exception if the structure >does not exist? > > > > ~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282732 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Testing for the existence of a dynamic structure that may or may not exist.
> Is there any way to do this w/o causing an error/exception if the > structure > does not exist? Did you mean the top level struct not existing? You could do this: -- Josh ~| CF 8 â Scorpio beta now available, easily build great internet experiences â Try it now on Labs http://www.adobe.com/cfusion/entitlement/index.cfm?e=labs_adobecf8_beta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Testing for the existence of a dynamic structure that may or may not exist.
Josh, Steve... thanks so much! -Original Message- From: Josh Nathanson [mailto:[EMAIL PROTECTED] Sent: Monday, July 02, 2007 3:05 PM To: CF-Talk Subject: Re: Testing for the existence of a dynamic structure that may or may not exist. > Is there any way to do this w/o causing an error/exception if the > structure does not exist? Did you mean the top level struct not existing? You could do this: -- Josh ~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:282737 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Did my own CF/SQL Server performance testing, my world is tur ned upside down.
> Well, OK, not that dramatic, but every DBA I have ever known > has told me that if you want performance, you use stored > procedures. My quick test this evening has me rethinking that. Just a warning - quick tests are often worth about the time you put into them. > The straight query using CFQUERYPARAM was consistently the > fastest. I fully expected this to be the case when compared > to using a straight query without cfqueryparam, but I was > really surprised to find that the stored procedure was > consistently the SLOWEST. > > Has anyone else found this to be the case? I'm really > thinking about ripping out all of my SP's and just using > queries, it would make my life easier on a number of levels. > I have all of my queries as methods in a CFC, so code reuse > is about the same that it would be when using a stored procedure. First, this may simply be due to the database drivers you're using. You might try running your stored procedure through CFQUERY instead. Or, you might try newer database drivers, if they're available. You might, just for curiosity's sake, try running your queries and stored procedures through Query Analyzer, to see how they compare then. Second, prepared statements using bound parameters are typically as fast as stored procedures in most modern databases. There are still reasons why you still might want to use stored procedures over prepared statements, though, such as the ability to provide additional database security, and the ability to provide a database interface to multiple applications. Third, the reason that stored procedures and prepared statements are generally faster is because they allow the database to cache an execution plan, so that the next time the query is run, the database can reuse the plan rather than calculating a new plan. While this is generally going to provide better performance, this will not always be the case; if the inputs to the query are radically different from the ones used to generate the existing plan, that plan may not be optimal for the new query. 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! ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241105 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Re: Did my own CF/SQL Server performance testing, my world is tur ned upside down.
It's worth mentioning that there is some overhead for calling a stored proc that isn't involved with straight queries, though it should be minimal. Where stored procs REALLY shine is when you've got a query whose result is only used for some logic driving another query. Using a stored proc in that scenario will save you DB roundtrips, which is huge (at least if you're hitting the DB across a network, which will pretty much always be the case for larger apps thare care about performance). The other argument for stored procs is security: you can limit application access to invoking stored proce, and thereby prevent any ad hoc access to the DB. Outside those two very specific situations, prepared statements as inlined SQL is almost always a better choice. cheers, barneyb On 5/21/06, Dave Watts <[EMAIL PROTECTED]> wrote: > > The straight query using CFQUERYPARAM was consistently the > > fastest. I fully expected this to be the case when compared > > to using a straight query without cfqueryparam, but I was > > really surprised to find that the stored procedure was > > consistently the SLOWEST. > > > > Has anyone else found this to be the case? I'm really > > thinking about ripping out all of my SP's and just using > > queries, it would make my life easier on a number of levels. > > I have all of my queries as methods in a CFC, so code reuse > > is about the same that it would be when using a stored procedure. > > First, this may simply be due to the database drivers you're using. You > might try running your stored procedure through CFQUERY instead. Or, you > might try newer database drivers, if they're available. You might, just for > curiosity's sake, try running your queries and stored procedures through > Query Analyzer, to see how they compare then. > > Second, prepared statements using bound parameters are typically as fast as > stored procedures in most modern databases. There are still reasons why you > still might want to use stored procedures over prepared statements, though, > such as the ability to provide additional database security, and the ability > to provide a database interface to multiple applications. > > Third, the reason that stored procedures and prepared statements are > generally faster is because they allow the database to cache an execution > plan, so that the next time the query is run, the database can reuse the > plan rather than calculating a new plan. While this is generally going to > provide better performance, this will not always be the case; if the inputs > to the query are radically different from the ones used to generate the > existing plan, that plan may not be optimal for the new query. > > 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! > > > ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241106 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
Any Ideas on How to Start the Testing Of Content Management Syste m - written in ColdFusion & FuseBox 3.0.
Hi, We have a Content Management system which is completely coded and tested by the Coders during development. The system is written in ColdFusion and methodology is: FuseBox3.0 . Does any one have any idea how do I do this Testing so that it catches the maximum errors from the system. Does any one have any articles written on this. If so, Can you share the link with me. Thanks in advance. Sudheer Chakka. __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Any Ideas on How to Start the Testing Of Content Management Syste m - written in ColdFusion & FuseBox 3.0.
I have always found the best way is to get non-developers to go through the site, use the system and write down things as they happen. People who have never seen the site before. Don't give them any more direction than you would the client, and let them go. At 03:57 PM 4/15/2002 -0500, you wrote: >Hi, > > We have a Content Management system which is completely coded and >tested by the Coders during development. > >The system is written in ColdFusion and methodology is: FuseBox3.0 . > >Does any one have any idea how do I do this Testing so that it catches the >maximum errors from the system. > >Does any one have any articles written on this. If so, Can you share the >link with me. > > >Thanks in advance. >Sudheer Chakka. > > __ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Any Ideas on How to Start the Testing Of Content Management Syste m - written in ColdFusion & FuseBox 3.0.
get no more than 5 people non-technical or juniors and start using it. On Mon, 15 Apr 2002, Chakka, Sudheer wrote: > Hi, > > We have a Content Management system which is completely coded and > tested by the Coders during development. > > The system is written in ColdFusion and methodology is: FuseBox3.0 . > > Does any one have any idea how do I do this Testing so that it catches the > maximum errors from the system. > > Does any one have any articles written on this. If so, Can you share the > link with me. > > > Thanks in advance. > Sudheer Chakka. > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Any Ideas on How to Start the Testing Of Content Management S yste m - written in ColdFusion & FuseBox 3.0.
Sudheer, I used to do this sort of work as an Allaire/Macromedia consultant and can give you an insight on how we handled this at that time. Before I start I should mention we used a fairly high-end application stress tool called Segue Silk_Performer. This enabled us to create an increasing load on the ColdFusion/Web Server and also to build scripts for VirtualUsers calling outside lists into those scripts to simulate multiple different users and scenarios. The Segue tool is superb for these sorts of functions but was fairly expensive. Others may know of other tools out there we have our own. So here was our Modus-Operandi for testing a new application prior to launch:- First "LIVE IN THE LOGS!", by that I mean use the ColdFusion and to a lesser extent the Web Server logs religiously at all times during your testing. They are truly your fountain of information and will tell you many things, (Btw there is a FB3 web logging tool at www.secretagents.com for the cost it may be a good idea to get a copy beforehand although the web logs are secondary to the ColdFusion logs.) 1/ Go into the site as an actual user and create a "script" of a fairly intensive user session. Again depending on the stress testing tool you are using you may be able to create several of these scripts and use them simultaneously. 2/ After creating the script's) clear out the logs and begin testing using your stress tool. Keep watching the logs, also use any ColdFusion and OS performance measuring indicators at the same time as running the tests. Keep reading the logs. 3/ Build up the number of simultaneous users until the site breaks (if you are very lucky it won't but experience tells me it will). Again watch the logs and all indicators as you go through this. Look at the error messages in the logs to determine what caused the site to break. 4/ Fix the problems step down your number of users and start again with your stress tool test. Repeat this process until the site performs well to a level of at least 100 users. If you need physical help with this process please let me know. Webapper consists of 3 ex Allaire/Macromedia consultants and we may be able to help you. Otherwise I hope this will be of assistance to you and any others who may be interested. Mike Brunt Webapper Lab1 http://www.webapper.com "Webapper Making the NET_Work" -Original Message- From: Chakka, Sudheer [mailto:[EMAIL PROTECTED]] Sent: Monday, April 15, 2002 1:57 PM To: CF-Talk Subject: Any Ideas on How to Start the Testing Of Content Management Syste m - written in ColdFusion & FuseBox 3.0. Hi, We have a Content Management system which is completely coded and tested by the Coders during development. The system is written in ColdFusion and methodology is: FuseBox3.0 . Does any one have any idea how do I do this Testing so that it catches the maximum errors from the system. Does any one have any articles written on this. If so, Can you share the link with me. Thanks in advance. Sudheer Chakka. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
