[cfaussie] Re: [OT] full-text index vs. wildcards

From my limited knowledge, I understand that this select companyName, companyState from companyDetails where freetext(companyName, '"eagle*"') and companyState = 'WA' order by companyName is going to return exact matches, the reason being is that if double quotes surround the phrase then you ar

[cfaussie] Re: [OT] full-text index vs. wildcards

No, the first asterix is ignored. B) AJ Mercer wrote: > would you need a Astrix both sizes of 'eagle'? >freetext(companyName, '"*eagle*"') > > > On 7/6/07, *Brett Payne-Rhodes* < [EMAIL PROTECTED] > > wrote: > > > Sure... > > select companyName, c

[cfaussie] Re: Remotely restart CF service

Anything that is used to rest a CFServer cant be triggered by CF. I did try it once before but it wouldnt work because the process that spawned the restart process dies when the cf server is stopped and it would never restart. _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] O

[cfaussie] Re: [OT] full-text index vs. wildcards

would you need a Astrix both sizes of 'eagle'? freetext(companyName, '"*eagle*"') On 7/6/07, Brett Payne-Rhodes <[EMAIL PROTECTED]> wrote: > > > Sure... > > select companyName, companyState from companyDetails > where freetext(companyName, '"eagle*"') and companyState = 'WA' > order by com

[cfaussie] Re: [OT] full-text index vs. wildcards

Sure... select companyName, companyState from companyDetails where freetext(companyName, '"eagle*"') and companyState = 'WA' order by companyName Returns 121 rows in 2 seconds While... select companyName, companyState from companyDetails where companyNamelike '%eagle%' and companyState = 'WA'

[cfaussie] Re: Remotely restart CF service

Heya yep on a shared environment. thanks for the code snippet. I'll test it out and let you guys know what happens From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Andrew Scott Sent: Friday, 6 July 2007 3:21 PM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Remot

[cfaussie] Re: Remotely restart CF service

Ryan, ASP code for you, and you can maybe use the net stat as suggested by Dale. dim objShell Set objShell = Server.CreateObject("WScript.Shell") objShell.Run "START c:\winnt\system32\notepad.exe" I have no idea if this stuff can be sandboxed so be warned that if they can do this it may

[cfaussie] Re: Remotely restart CF service

Java does have the execute, I used that once to run a script to get around the cfexecute sandboxing kind of silly if you ask me to lock something that is provided by java :-) But again unless jsp is accessible, that will not work from coldfusion if it is not responding. Andrew Scott Senior C

[cfaussie] Re: Remotely restart CF service

Nice snippet, the only downside is that it only works on the Enterprise version. And would be no good running a Coldfusion script if it is not responding, applies to standard installs of course. I am assuming that Ryan this is on a shared host environment? Andrew Scott Senior Coldfusi

[cfaussie] Re: Remotely restart CF service

ah muggins here didn't properly read your message :) absolutely no idea how to do it from asp, unless you write something that will make a similar java call. Toby On 07/07/2007, at 1:07 , Toby Tremayne wrote: > This will restart a cf instance > > > oJRun = CreateObject("java", "jrunx

[cfaussie] Re: Remotely restart CF service

Not sure how, But just write a simple ASP page that executes the batch, might be tricky if you don't have server access. Regards Dale Fraser http://dalefraser.blogspot.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ry

[cfaussie] Re: Remotely restart CF service

This will restart a cf instance oJRun = CreateObject("java", "jrunx.kernel.JRun"); oJRun.restart(oJRun.getServerName()); On 06/07/2007, at 12:54 , Ryan Sabir wrote: > > Does anyone have a script that can restart the Cold Fusion service > remotely? > > Preferably written in A

[cfaussie] Re: [OT] full-text index vs. wildcards

Can you post your SQL? On 7/6/07, Brett Payne-Rhodes <[EMAIL PROTECTED]> wrote: > > > I'm trying to speed up a wildcard search on a text field along the lines > of SELECT companyName from companyDetails where companyName like '%eagle%' > > The database is mssql 2005 and the table has over two mill

[cfaussie] [OT] full-text index vs. wildcards

I'm trying to speed up a wildcard search on a text field along the lines of SELECT companyName from companyDetails where companyName like '%eagle%' The database is mssql 2005 and the table has over two million rows. What I have already done is to create a full-text index on companyName and whi

[cfaussie] [OT] READPAST lock - more info please

if you perform a profile of the database and username you are using, the resulting output in the trace will usually list it right up the top. (run some sql statments via CF). PS, use select db_id() against your database to get its ID, to put into the profile filters. PPS, I am referring to MS

[cfaussie] Re: [OT] READPAST lock - more info please

maybe a stupid question, how do I find out whether the datasource is using one of the isolation levels? On 7/6/07, Scott Thornton <[EMAIL PROTECTED]> wrote: > > > It will apply as long as the datasources' connection isolation level you > are using is one of the ones it likes (READ COMMITTED, REPEA

[cfaussie] [OT] READPAST lock - more info please

It will apply as long as the datasources' connection isolation level you are using is one of the ones it likes (READ COMMITTED, REPEATABLE READ). >>> "Taco Fleur" <[EMAIL PROTECTED]> 06/07/2007 12:36 pm >>> Hi Scott, > The readpast statement will apply to the query with the hint applied. The a

[cfaussie] Re: Remotely restart CF service

How would I call that from ASP? This is on a server that I don't have command line or CF administrator access to. It needs to be something like: http://mydeadcfserver.com/restartCF.asp From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Dale Fraser Sent: Friday, 6 J

[cfaussie] Re: Remotely restart CF service

Batch file net start "ColdFusion" net stop "Coldfusion" type net start and see all the service names Regards Dale Fraser http://dalefraser.blogspot.com From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Ryan Sabi

[cfaussie] Remotely restart CF service

Does anyone have a script that can restart the Cold Fusion service remotely? Preferably written in ASP or something like that, as we'd need to do this when Cold Fusion is not responding. thanks! Ryan Sabir Technical Director p: (02) 9274 8030 f: (02) 9274 8099 m: 0411 512 454 w: www.new

[cfaussie] Re: [OT] READPAST lock - more info please

Hi Scott, > The readpast statement will apply to the query with the hint applied. The above makes it sound like it will apply no matter what, as long as I have it within the SELECT statement > Every query executed will be within the same Isolation level on your database. Then the above makes it s

[cfaussie] Re: [OT] READPAST lock - more info please

Every query executed will be within the same Isolation level on your database. The readpast statement will apply to the query with the hint applied. So, the isolation level on your database will have to be one of the two mentioned for it to work I imagine. >>> "Taco Fleur" <[EMAIL PROTECTED]>

[cfaussie] [OT] READPAST lock - more info please

I'm using the READPAST hint in MS SQL 2005, to allow select statements to read data in a lock without waiting for it to be released. I think I understand it, but need a bit of clarification on the following in red; Specifies that the Database Engine not read rows and pages that are locked by oth

[cfaussie] Re: Coldfusion Server Using JRUN

sweet thanks Charlie ill check them out. Steve _ From: cfaussie@googlegroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Charlie Arehart (lists account) Sent: Friday, 6 July 2007 5:09 AM To: cfaussie@googlegroups.com Subject: [cfaussie] Re: Coldfusion Server Using JRUN Steve, since i

[cfaussie] Re: Coldfusion Server Using JRUN

Steve, since it's not new to 7 (was introduced in 6.1), I'll point you to a couple of articles from that time frame: "Introducing Multiple Server Instances in ColdFusion MX 6.1", Tim Buntel http://www.adobe.com/devnet/coldfusion/articles/multiple_61.html "Using Multiple Instances with ColdFusion

[cfaussie] Coldfusion Server Using JRUN

Where can i get more info about running CF Server on JRUN, dealing with instances and that sort of thing? Steve Onnis Director / Head Developer

[cfaussie] Re: CFLocation stopped working

then install Ray's coldfire - adds a ColdFusion tab in firebug to show all CF debugging http://coldfire.riaforge.org/ On 7/5/07, Andrew Scott <[EMAIL PROTECTED]> wrote: > > So does fireBug, with the added benefits of JS debugging, CSS editing all > live in the browser, console for dumping JS o

[cfaussie] Re: CFLocation stopped working

So does fireBug, with the added benefits of JS debugging, CSS editing all live in the browser, console for dumping JS objects for inspection, and a thousand more features to boot. fireBug should be the first plugin for FF that any developer installs. It is invaluable for development, want to write

[cfaussie] Re: CFLocation stopped working

There is also a really good Firefox Extension called LiveHTTPHeaders (http://livehttpheaders.mozdev.org/) which is invaluable for diagnosing all sorts of issues like this, it gives you a live view of all HTTP headers, both sent and received. Perhaps look for any differences in the headers between

[cfaussie] Re: Flash Media Server 2.0 Pricing and Editions

On 7/5/07, Guennadi M <[EMAIL PROTECTED]> wrote: > > ok.. so it's ok to use in production?? Going through the EULA with a fine tooth comb, only the NFR version can't be used in production. Chris -- Chris Velevitch Manager - Sydney Flash Platform Developers Group m: 0415 469 095 www.flashdev.or