I'm not sure but I think this should be in the archives, If I rember someone asked for the same sort of Stats not so long ago.
I didn't keep track of the thread I must admit. Sorry not much help I know, J -----Original Message----- From: Nick Betts [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 10:27 AM To: CF-Talk Subject: Help required on CF Performance.... Hi, Is there a way to test system performance based on differenet number of concurrent users? Are there any guidelines from macroMedia on the maximum number of concurrent users CF server supports? I realise this is quite ballpacrk but basically need to presnet some figures to our client. Regards, Nick -----Original Message----- From: Brian Scandale [mailto:[EMAIL PROTECTED]] Sent: 07 February 2002 08:02 To: CF-Talk Subject: Re: looping inside cfquery - brain on vacation Maybe this? Loop around the <cfquery> <cfloop query="theQuery"> <cfquery name="blah" datasource="blah"> INSERT INTO Table (Field) VALUES ('#theQuery.FieldValue#') </cfquery> </cfloop> At 05:15 PM 2/6/02 -0800, you wrote: >dang tried the semi-colon already with no luck...thought that's what it was....grrrrrrrrr ;-) > >Thanks > >Bryan Stevenson >VP & Director of E-Commerce Development >Electric Edge Systems Group Inc. >p. 250.920.8830 >e. [EMAIL PROTECTED] >--------------------------------------------------------- >Macromedia Associate Partner >www.macromedia.com >--------------------------------------------------------- >Vancouver Island ColdFusion Users Group >Founder & Director >www.cfug-vancouverisland.com > >----- Original Message ----- >From: "Steve Oliver" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Wednesday, February 06, 2002 5:06 PM >Subject: RE: looping inside cfquery - brain on vacation > > >> Oh nevermind, your not looping over the columns of the query (long day >> as well) >> >> I think you need a semi-colon at the end of your query, since that will >> put multiple inserts in one cfquery. >> >> ______________________ >> steve oliver >> atnet solutions, inc. >> http://www.atnetsolutions.com >> >> >> -----Original Message----- >> From: Steve Oliver [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, February 06, 2002 8:02 PM >> To: CF-Talk >> Subject: RE: looping inside cfquery - brain on vacation >> >> >> Hmmm, well if one of your fields is numeric, then that wouldn't work, >> since numeric values don't need 's around them, you could use the >> isNumeric() function for that. >> >> ______________________ >> steve oliver >> atnet solutions, inc. >> http://www.atnetsolutions.com >> >> >> -----Original Message----- >> From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] >> Sent: Wednesday, February 06, 2002 8:01 PM >> To: CF-Talk >> Subject: looping inside cfquery - brain on vacation >> >> >> OK..long day..CF whining about syntax...help! >> >> The situation: >> >> CF doesn't like my syntax for this bit of looping over a query to insert >> muliple records. It's >> complaining about the final ")" closing bracket for the insert. Any >> ideas? I'm sure I've done it >> before....just saw it posted the other week too...geesh talk about >> timing ;-) >> >> <cfquery name="blah" datasource="blah"> >> <cfloop query="theQuery"> >> INSERT INTO Table >> ( >> Field >> ) >> VALUES >> ( >> '#FieldValue#' >> ) >> <cfloop> >> </cfquery> >> >> TIA >> >> Bryan Stevenson >> VP & Director of E-Commerce Development >> Electric Edge Systems Group Inc. >> p. 250.920.8830 >> e. [EMAIL PROTECTED] >> --------------------------------------------------------- >> Macromedia Associate Partner >> www.macromedia.com >> --------------------------------------------------------- >> Vancouver Island ColdFusion Users Group >> Founder & Director >> www.cfug-vancouverisland.com >> >> >> >> > ______________________________________________________________________ Why Share? Dedicated Win 2000 Server · PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionc 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
