Re: IIS connector tuning question

2013-10-25 Thread Sergey Croitor
> simultaneous requests than CF itself would. > Thanks a lot for explanation! Larger pool of connections in connector makes sense then. But why I see Simultaneous Template Requests = 500 in CF admin after manual connector tuning while it was 24 before tuning? Is that normal? Sergey Croitor

IIS connector tuning question

2013-10-25 Thread Sergey Croitor
in your production sites? If you use 500 connection_pool_size/simultaneous_template_requests, how stable is your production site in case of peak load with a lot of requests coming simultaneously? Sergey Croitor, ECommercePartners.net ~| Order

Re: Help needed with CF10 developer edition on XP w/IIS

2012-12-11 Thread Sergey Croitor
WinXP doesn't enable multiple sites on IIS. Use iis_multiplex as a workaround On Tue, Dec 11, 2012 at 1:41 AM, Stephen Hait wrote: > > I've installed CF 10 Developer edition on XP that is running IIS 5.1. I can > get the CF Administrator to come up but cannot figure out how to set up a > virtu

Re: IIS & ColdFusion Developer, best practices for setting up multiple sites

2010-01-08 Thread Sergey Croitor
iis_multiplex is a correct name. I've typed it wrong in previous email. On Fri, Jan 8, 2010 at 3:04 PM, Jeff F wrote: > > I'd like to set up my development environment to match what I've got on the > server, namely multiple sites under IIS with each site acting as root. > > Can anyone offer any

Re: IIS & ColdFusion Developer, best practices for setting up multiple sites

2010-01-08 Thread Sergey Croitor
Use iis_multilex addon for IIS. It works fine on WinXP. --- Sergey Croitor On Fri, Jan 8, 2010 at 3:04 PM, Jeff F wrote: > > I'd like to set up my development environment to match what I've got on the > server, namely multiple sites under IIS with each site acting as r

Re: Fusebox Editor based on XmlHttpRequest.

2006-03-28 Thread Sergey Croitor
e list of orphaned files, then edit it by excluding NH> some entries, then rename. NH> I tested it working on large projects with more than 50 circuits NH> and 500 fuseactions. NH> Firefox draws circuit xml tree much faster than IE. NH> Strange but true :) NH> site: ht

Re: Fusebox Editor based on XmlHttpRequest.

2006-03-28 Thread Sergey Croitor
ownerDocument) nodeRoot=doc.ownerDocument; var result = nodeRoot.evaluate(xpath, doc, null, XPathResult.ORDERED_NODE_SNAPSHOT_TYPE, null); if(result.snapshotLength==2){ var xmlSerializer = new XMLSerializer

ANN: Fusebox Editor based on XmlHttpRequest.

2006-03-28 Thread Sergey Croitor
Strange but true :) site: http://www.docubee.com See HowTo help panel for more info. I'd appreciate any feedback. Thanks, Sergey Croitor ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236338 Archives: http://www.ho

Re: InterSystems Cache

2005-09-21 Thread Sergey Croitor
Here is the discussion about the subject http://forums.devshed.com/archive/t-53895 -- Serg MD> Just wondering if anyone is using this database and what they MD> thought of it. Any specific issues to worry about? 'gatchas'? MD> Thanks ~~

Re: InterSystems Cache

2005-09-21 Thread Sergey Croitor
MD> Just wondering if anyone is using this database and what they MD> thought of it. Any specific issues to worry about? 'gatchas'? I was using the predecessor of Cache, the MUMPS, but it was 15 years ago :) It's the b-tree database, very fast when you retrieve the data of the node. In fact the fe

Re: XML Tree Search

2005-09-03 Thread Sergey Croitor
A> Problem is that I don't know the Node Name tmpNodes=XmlSearch(your_XmlDoc, '//[EMAIL PROTECTED]"Y"]'); Look at http://www.zvon.org/xxl/XPathTutorial/General/examples.html -- Serg ~| Logware (www.logware.us): a new and co

Re: XML Tree Search

2005-09-03 Thread Sergey Croitor
Use XPath query: tmpNodes=XmlSearch(your_XmlDoc, '//[EMAIL PROTECTED]"Y"]'); Then loop through tmpNodes, it is an array. -- Serg A> I need to search for all of the Nodes that an attribute X that equals Y, A> then do something with each of those nodes. A> Andy A> -Original Message---

Re: Where ClientName Like '[a-d]%' - How would you actually do this?

2005-09-02 Thread Sergey Croitor
oops, misprint :) WHERE (ClientName >='a' AND ClientName <'e') OR (ClientName >='A' AND ClientName <'E') -- Serg ~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusio

Re: Where ClientName Like '[a-d]%' - How would you actually do this?

2005-09-02 Thread Sergey Croitor
WHERE (ClientName >='a' AND ClientName <'c') OR (ClientName >='A' AND ClientName <'C') -- Serg ~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent

Re: Fusebox4 DHTML editor

2005-08-25 Thread Sergey Croitor
S> PNG files never seem to internet explorer for some reason. Thanks for pointing. Here go GIF dupes Firefox screenshot: http://www.docubee.com/images/fb4ff.gif IE screenshot: http://www.docubee.com/images/fb2.gif -- Serg ~~

OT: Fusebox4 DHTML editor

2005-08-25 Thread Sergey Croitor
Maybe somebody will find it useful... I just added a Fusebox4/4.1 management tool as a part of my free Docubee project. It's a refreshless DHTML editor for fusebox and circuit xml files. Xml file is shown as an editable tree. Works in IE6 and Firefox. Firefox screenshot: http://www.docubee.com/im

Re: cfexecute question

2005-06-13 Thread Sergey Croitor
DW> Within the list of services, configure the CF service to be able to interact DW> with the desktop. Thanks a lot Dave. I forgot about this service option. It works now though jrunsvc console window is sticked up at task bar as well and HomeSite had yelled it cannot find its Desktop (another the

Re[2]: cfexecute question

2005-06-13 Thread Sergey Croitor
SID> Try setting the ColdFusion server service to use the Administrator SID> account or another windows user account instead of the system account SID> -- that might get the result you want. I'm not certain of that, but SID> I'm guessing that if CF Server is assigned to the Administrator SID> accou

Re: Quick OT Javascript question.

2005-06-13 Thread Sergey Croitor
Hello Jeff, Monday, June 13, 2005, 11:44:18 PM, you wrote: JW> 4:50 Ponderings... JW> How do I grab the CURRENTLY selected option in a select list WITHOUT knowing JW> how many options. (the options are dynamically created) JW> Say we have in select colors JW> Red JW> Green JW> Blue JW> Docu

cfexecute question

2005-06-13 Thread Sergey Croitor
I'm trying to open cfm file in editor by HomeSite starts but under SYSTEM account so it is invisible on desktop. Is there any way to start editor by cfmx server in visible mode? It is supposed that application is smart enough to not try start editor when request is remote :) Thanks -Sergey

Re: OT: traffic monitoring software

2005-05-26 Thread Sergey Croitor
ctsd> does s.o. know a good ctsd> traffic monitoring software ctsd> other than CommTraffic (Tamos) and ctsd> MRTG ? http://lastbit.com/trafmeter Powerful and convenient. -- Sergey ~| Logware (www.logware.us): a new and conve

Re: OT: using js to include files

2005-05-20 Thread Sergey Croitor
Most probably the error occurs because no any forms are included in the document at a stage you are trying to use their values. Seems you are trying to use it in the very beginning in a HEAD section while document.forms will be ready to use on page load. TD> Hi All, TD> I'm trying to use js in

Re: Database error

2005-05-17 Thread Sergey Croitor
RC> Thanks, I'm trying to change the code using nested queries. try PreserveSingleQuotes at first as Jochem advised you: UPDATE #qry_getSpcListInfo.PrimEntity# SET #PreserveSingleQuotes(setliststr)# WHERE #whereclause# -- Sergey ~

Re: Database error

2005-05-17 Thread Sergey Croitor
hi, Localize the error. Copy this final query into SQL Query Analyzer or SQL Enterprise Manager and check if it works there. Does it work there? RC> Variable Query is displayling like this in browser: RC> UPDATE Person SET Person.DatExp = 1231 , Person.DependentSeq = 0 , RC> Person.LstDate =

Re: Date/Time Question

2005-05-13 Thread Sergey Croitor
JR> The value I pull is in this format: JR> "2005-04-07T13:29:00.000-04:00" Truncate the string to a dot(.) and replace "T" to a space " " "2005-04-07 13:29:00" is a correct date format for most SQL servers. JR> I need to be JR> able to store it to SQL server but when I try it as is I get an

Re: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Sergey Croitor
excerpt from Access help: If you want to know which records were updated, first examine the results of a select query that uses the same criteria, and then run the update query. Ugly but works. SELECT count(*) as rowsAffected FROM your_table WHERE your_previous_update_where_clause DM> No recor

Re: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Sergey Croitor
or check query_name.RecordCount :) There is a chance it holds you need for UPDATE query as well. DM> Is there any way to find the number of rows affected by the last query DM> when using SQL Server 2000 and a cfquery UPDATE statement? I'm stumped DM> on this one. Thanks. -- Best regards,

Re: OT: AFFECTED_ROWS from sql server update cfquery?

2005-05-10 Thread Sergey Croitor
UPDATE ... SELECT @@ROWCOUNT AS rowsAffected DM> Is there any way to find the number of rows affected by the last query DM> when using SQL Server 2000 and a cfquery UPDATE statement? I'm stumped DM> on this one. Thanks. -- Best regards, Sergeymailto:[EMAIL PR

Re: Stored Procedure Help

2005-05-10 Thread Sergey Croitor
If you want to pass comma separated IDs to a stored procedure then use it in WHERE clause: CREATE PROCEDURE dbo.getCountryNames @inputIDs varchar(255) AS SELECT countryname FROM Countries WHERE countryID in (@inputIDs) GO If you need to loop through a query inside a stored procedure, use cursors.

Re: OT: Parent-Child Relationships within Table

2005-05-09 Thread Sergey Croitor
Additional parent_path field will help you to retrieve all the branch starting at a given tree item by a single SELECT query: SELECT * FROM Categories WHERE parent_path LIKE '#start_item_path##path_delimiter#%' If you want to avoid having problems with keeping parent_path field in actual state th

Re: SQL IF/ELSE or CASE Statement Help

2005-05-06 Thread Sergey Croitor
SELECT re.*, rtl.*, CAST(RIGHT(IsNull(PubNumber,'77-0'), LEN(IsNull(PubNumber,'77-0'))-3) as int) as NumberWithinAYear FROM Research re, ResearchTypesLookup rtl WHERE re.ResearchTypeID=2 --AND re.ResearchYear=1998 AND re.ResearchTypeID=rtl.ResearchTypeID AND NOT CONTAINS(re.PubNumber,

Re[6]: Try Docubee Forms please

2005-04-29 Thread Sergey Croitor
uot;piddling", meaning it didnt d> factor into my decision but would be nice to see a good color d> sceme.. d> d> From: Sergey Croitor <[EMAIL PROTECTED]> d> Sent: Friday, April 29, 2005 8:45 PM d> To: CF-Talk d> Subject: Re[4]

Re[4]: Try Docubee Forms please

2005-04-29 Thread Sergey Croitor
e you tried the product enough to sort it as a piddle. Yes, Friday aftenoon is not a good time. My fault... Serg d> -------- d> From: Sergey Croitor <[EMAIL PROTECTED]> d> Sent: Friday, April 29, 2005 7:40 PM d> To: CF-Talk d> Subject: Re

Re[2]: Try Docubee Forms please

2005-04-29 Thread Sergey Croitor
d> d> From: Sergey Croitor <[EMAIL PROTECTED]> d> Sent: Friday, April 29, 2005 6:58 PM d> To: CF-Talk d> Subject: Try Docubee Forms please d> Hi, d> I'm just finished and published my old project, the Docubee Forms d> http://www.docubee.com d>

Try Docubee Forms please

2005-04-29 Thread Sergey Croitor
Hi, I'm just finished and published my old project, the Docubee Forms http://www.docubee.com and wondering to what extent this might be useful to others. I'll appreciate any comment about Docubee. It's something similar to Flash Forms but uses JavaScript/DHTML GUI, without refresh, does not requi