Re: OT Malware on a CF Site
wow. thats slick. On Wed, Apr 15, 2009 at 10:12 PM, Terry Troxel wrote: > > Has anyone seen anything like this written to any of your sites? > > > > The file this was written to is an index.cfm file that has been on the site > for over 8 years. The only line that was in this file was a cflocation to > redirect to another folder. > > The index.html file that this file redirects to is rewritten by CF every > time the site admin makes a change. THAT index.html file had the same script > written to the very bottom of that file as well, but when I made a change > and it was rewritten the script is gone. I can then assume something other > then my CF or any SQL injections are not the culprit. > > I have been unable to contact the hosting company to check their server and > I have also been unable to find anything in my Googling to give me any clues > as to a cause and a cure. > > Any help would be greatly appreciated. > > > > > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321642 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: OT Malware on a CF Site
Thank you guys. I guess I searched everywhere but House of Fusion. I shoulda known. Terry -Original Message- From: Terry Troxel [mailto:te...@it-werks.com] Sent: Wednesday, April 15, 2009 7:13 PM To: cf-talk Subject: [SPAM-HIGH] OT Malware on a CF Site Has anyone seen anything like this written to any of your sites? The file this was written to is an index.cfm file that has been on the site for over 8 years. The only line that was in this file was a cflocation to redirect to another folder. The index.html file that this file redirects to is rewritten by CF every time the site admin makes a change. THAT index.html file had the same script written to the very bottom of that file as well, but when I made a change and it was rewritten the script is gone. I can then assume something other then my CF or any SQL injections are not the culprit. I have been unable to contact the hosting company to check their server and I have also been unable to find anything in my Googling to give me any clues as to a cause and a cure. Any help would be greatly appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321641 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT Malware on a CF Site
> Has anyone seen anything like this written to any of your sites? > > > > The file this was written to is an index.cfm file that has been on the site > for over 8 years. The only line that was in this file was a cflocation to > redirect to another folder. > > The index.html file that this file redirects to is rewritten by CF every > time the site admin makes a change. THAT index.html file had the same script > written to the very bottom of that file as well, but when I made a change > and it was rewritten the script is gone. I can then assume something other > then my CF or any SQL injections are not the culprit. > > I have been unable to contact the hosting company to check their server and > I have also been unable to find anything in my Googling to give me any clues > as to a cause and a cure. Why yes, check the recent "Question about hack" thread. It's about this very item. 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 mo ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321640 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: OT Malware on a CF Site
Yeah..it's a hack. There is a lengthy thread about it here: http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:59164 On Wed, Apr 15, 2009 at 7:12 PM, Terry Troxel wrote: > > Has anyone seen anything like this written to any of your sites? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321639 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
OT Malware on a CF Site
Has anyone seen anything like this written to any of your sites? The file this was written to is an index.cfm file that has been on the site for over 8 years. The only line that was in this file was a cflocation to redirect to another folder. The index.html file that this file redirects to is rewritten by CF every time the site admin makes a change. THAT index.html file had the same script written to the very bottom of that file as well, but when I made a change and it was rewritten the script is gone. I can then assume something other then my CF or any SQL injections are not the culprit. I have been unable to contact the hosting company to check their server and I have also been unable to find anything in my Googling to give me any clues as to a cause and a cure. Any help would be greatly appreciated. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321638 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Mura CMS (was Sava CMS) on Connect preso now
If you are interested in Mura CMS, tune in to see the presentation by Sean Schroeder of Blue River... http://experts.na3.acrobat.com/r67797209/ ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321637 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: MS WORD DOCX Question
Thanks Jason, that indeed provided the solution. I used the following two articles to setup the new mime types. http://sensisbledefault.wordpress.com/2007/03/05/office-2007-iis-6-mime-types-docx-pptx-xlsx/ http://support.microsoft.com/kb/936496 (This third described added MIME TYPES in another location in IIS - which did not work). http://www.microsoft.com/technet/prodtechnol/WindowsServer2003/Library/IIS/cd72c0dc-c5b8-42e4-96c2-b3c656f99ead.mspx?mfr=true Cheers, Matts >Some notes on the right MIME type for the Office 2007 formats, which IIS6 >doesn't know how to handle. > >http://www.jameskovacs.com/blog/ConfiguringIIS6ToServeOffice2007FileFormats. >aspx ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321636 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
re: MS WORD DOCX Question
Some notes on the right MIME type for the Office 2007 formats, which IIS6 doesn't know how to handle. http://www.jameskovacs.com/blog/ConfiguringIIS6ToServeOffice2007FileFormats. aspx ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321635 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
MS WORD DOCX Question
Hi All, I have a working app that lets users upload docs to a clients 'admin' people. Recently a few users have been uploading MS OFFICE 2008, MS WORD .docx files. The 'admin' people dont have this latest version, but have downloaded the compatibility pack that lets them open them. Trouble is on the admin side of the application Im using a redirect to the file on the file system (redirects to say http://www.theirdomain.com/files/the_file.docx - and I get an "The request is not supported." error. Okay, try via then , and it opens in MSWORD, but even though MS WORD has the compatibility pack === no luck. I have tried changing the type="application/msword" to a variety of mime formats.. still no luck. So does anyone have any suggestions? I'd settle for them being able to click on hyperlink download/save file, then open it in MS WORD (where word could then convert). Thanks, Matts ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321634 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Newbie ... Date / Time formatting
Was actually trying to find a way of using DateTime fields in queries. Just found TIMESTAMP type for CFQueryParam. To: "cf-talk" Sent: Wednesday, April 15, 2009 2:22 PM Subject: Re: Newbie ... Date / Time formatting > > You can't output a time with dateformat() - you need to use > timeformat() for that bit. > > mxAjax / CFAjax docs and other useful articles: > http://www.bifrost.com.au/blog/ > > > > 2009/4/15 BobSharp : >> >> I am having a problem with erroneous MINUTES in my DateTime >> creation/formatting. >> The rest of the DateTime comes out correctly. >>> LINK <<< >> >> >> >> >> > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321633 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for a CF drag & drop tutorial
Wow, I can already see some errors. The ajaxproxy name is wrong, should be ASort. There are some others too so you will need to know a few things about jquery and cfajaxproxy to CFC first. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321632 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert RGB values
Thanks for your help Raymond. >http://cflib.org/udf/RGBtoHex > > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321631 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Looking for a CF drag & drop tutorial
> Hi,
>
> I am looking for a CF tutorial on how to create a drag and drop list
> to reorder entries.
>
> Thanks!
This is not tested but it should offer an idea of how to get a sort working
with jquery.
Send me an email offline if you need more help. t...@tonybentley.com
Javascript
$("#div").sortable({
update : function()
{updatePicSort($('#div').sortable('serialize'))}
});
function updatePicSort(v){
var id = //whatever identifier;
var list = //a comma seperated list
var z = new ASort();
z.setHTTPMethod("post");
var SortRet = z.Sort(id,list);
}
AND THE CFC. Return something that verifies that the update took
update sort set sort = '#x#'
where id = '#newlist[x]#' and IDENTIFIER = '#id#'
on the front end be sure to include both jquery UI and jquery
.handle {
float:left;
margin-right:3px;
cursor:move;
}
#forsort.Name#
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321630
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Convert RGB values
http://cflib.org/udf/RGBtoHex On Wed, Apr 15, 2009 at 1:03 PM, Pranathi Reddy wrote: > > Hi All.. > I have a quick qn.. > How do we convert RGB input text data to hex or color in coldfusion. > Do we have any inbuilt function or we need to use javascript for that. > > Thanks, > Pranathi > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321629 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Convert RGB values
Hi All.. I have a quick qn.. How do we convert RGB input text data to hex or color in coldfusion. Do we have any inbuilt function or we need to use javascript for that. Thanks, Pranathi ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321628 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQUERY Timeout for SQL2005 Fails
Check this out. This one, as I've said before, outputs a number around 3000. select top 2 * from table #cfquery.ExecutionTime# However, this one results in an error: Error Executing Database Query. [Macromedia][SQLServer JDBC Driver]Execution timeout expired. select top 1 * from table waitfor delay '00:00:05' #cfquery.ExecutionTime# Porbably because the query in the second test ran under a second (completed successfully), then it waited five seconds. I read that portion of the docs, too, but I thought it meant if you'd strung more than a single SQL statement -- i.e., SELECT/INSERT/SELECT. Regardless, I think it's terrible that there isn't more substantial control over this. Shouldn't CF know how long a 3rd-party request is taking? There's a timeout parameter in CFHTTP, and it works just fine: wait.cfm test.cfm Result, in about two seconds: Statuscode 408 Request Time-out Which leads me to believe that the connection was indeed broken and CF completed the thread. And that's a 3rd-party call, too, isn't it? >The docs say, no, it may not timeout at 1 second. Check out the >livedocs... "Because the timeout attribute only affects the maximum >time for each suboperation of a query, the cumulative time may exceed >its value." > >And, even then, the query stuff is considered to be 3rd party (or at >least, so I remember reading a ways back) and does not fall under the >same rules as CF templates when it comes to setting a timeout using >CFsetting or by way of the administrator. The best way to kill those >hung threads is going to be something like FusionReactor or SeeFusion. > > >Matthew Williams >Geodesic GraFX ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321627 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Unable to access CF Admin
I didn't read the thread or if it is related but I had an issue where I changed the root dir that CF admin was in and I had to change a mapping to the CFIDE dir in the neo.xml Like I said... just a shot in the dark. G On Wed, Apr 15, 2009 at 11:32 AM, Toby King wrote: > > Still unable to access CF Administrator > > Does anyone know if it can be done. > > Happy to pay consulting fees to get fixed > > > > > > > > >Here is the entire httpd-vhosts.conf > > > >So I do already have the Alias in the file. > > > > > > > ># > ># Virtual Hosts > ># > ># If you want to maintain multiple domains/hostnames on your > ># machine you can setup VirtualHost containers for them. Most > configurations > ># use only name-based virtual hosts so the server doesn't need to worry > about > ># IP addresses. This is indicated by the asterisks in the directives > below.. > ># > ># Please see the documentation at > ># http://httpd.apache.org/docs/2.2/vhosts/> > ># for further details before you try to setup virtual hosts. > ># > ># You may use the command line option '-S' to verify your virtual host > ># configuration. > > > > > > > ># > ># Use name-based virtual hosting. > ># > > > >NameVirtualHost *:80 > > > ># > ># VirtualHost example: > ># Almost any Apache directive may go into a VirtualHost container. > ># The first VirtualHost section is used for all requests that do not > ># match a ServerName or ServerAlias in any block. > ># > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs" > >ServerName default > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/sava/admin" > >ServerName default > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Inetpub/wwwroot/CFIDE/administrator" > >ServerName default > > > > > >Alias /CFIDE "C:/Inetpub/wwwroot/CFIDE/administrator" > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/cosmeticbeautydirectory" > >ServerName www.cosmeticbeautydirectory.com.au > >ServerAlias cosmeticbeautydirectory.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/swanseaflowers" > >ServerName www.swanseaflowers.com.au > >ServerAlias swanseaflowers.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/beecroftflowerplace" > >ServerName www.beecroftflowerplace.com.au > >ServerAlias beecroftflowerplace.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/vipsolutions" > >ServerName www.vipsolutions.com.au > >ServerAlias vipsolutions.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/amandaheavens" > >ServerName www.amandaheavens.com.au > >ServerAlias amandaheavens.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/yorkfamlaw" > >ServerName www.yorkfamlaw.com.au > >ServerAlias yorkfamlaw.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/ederma" > >ServerName www.ederma.com.au > >ServerAlias ederma.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/yardy" > >ServerName www.yardy.com.au > >ServerAlias yardy.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/abansw" > >ServerName www.abansw.com > >ServerAlias abansw.com > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/capitalcosmeticlaser" > >ServerName www.capitalcosmeticlaser.com.au > >ServerAlias capitalcosmeticlaser.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/beecroftflowerplace" > >ServerName www.beecroftflowerplace.com.au > >ServerAlias beecroftflowerplace.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/thesite" > >ServerName www.thesite.com.au > >ServerAlias thesite.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/sava/cleverminds" > >ServerName www.cleverminds.com.au > >ServerAlias cleverminds.com.au > > > > > > > >ServerAdmin peter.tansw...@cleverminds.com.au > >DocumentRoot "C:/Program Files/Apache/htdocs/lookyounger" > >ServerName www.lookyounger.com.au > >ServerAlias lookyounger.com.au > > > > > > > >DocumentRoot "C:/Program Files/Apache/h
Re: show x words not x characters
A sentence is effectively a space-delimited list of words. So just do ListLeft(myvar,5,' ') However, words can be an unpredictable length, so this might not be exactly what you want. Here's some code that will give the first 100 characters, keeping words whole, and adding a html ellipsis onto the end: Just change the 90 to 20 or 25, strip the … part, and it should do what you want. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321625 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: show x words not x characters
>There should be a UDF for that @ cflib.org I would search for "word count" >or some such. > >G! > >On Wed, Apr 15, 2009 at 12:01 PM, Glyn Jackson >wrote: > >> thanks ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321624 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
SQL Server Locks
Hi All, SQL Server locks seem to cause problems that result in processes remaining blocked until something intervenes in two cases: circular dependencies between processes and application or when a query is cancelled but the lock isn't released. My question pertains to the latter. Has anyone really looked at situations that ColdFusion, through the default JDBC driver to SQL Server 2000 will obtain a table or row level lock and then not release it? Or is this possiblya function of some fault SQL. Or is there some user behaviour that causes the latter to occur? Regards, Dan Baughman ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321623 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: show x words not x characters
There should be a UDF for that @ cflib.org I would search for "word count" or some such. G! On Wed, Apr 15, 2009 at 12:01 PM, Glyn Jackson wrote: > > Ho every one, bit of a simple question, > > my website shows a snippet of text using the 'left(myvar,30)' function in > ColdFusion. however this some times cuts off words mid flow, is there a > function in CF that shows x words and not x characters? > > thanks in advance > > > ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321622 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: show x words not x characters
Treat the string as a list with any chars you see fit to be word delimiters, so spaces, tabs, full stops etc, then extract N elements from the left of the list. Adrian > -Original Message- > From: Glyn Jackson [mailto:glyn.jack...@newebia.co.uk] > Sent: 15 April 2009 17:02 > To: cf-talk > Subject: show x words not x characters > > > Ho every one, bit of a simple question, > > my website shows a snippet of text using the 'left(myvar,30)' function > in ColdFusion. however this some times cuts off words mid flow, is > there a function in CF that shows x words and not x characters? > > thanks in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321621 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
show x words not x characters
Ho every one, bit of a simple question, my website shows a snippet of text using the 'left(myvar,30)' function in ColdFusion. however this some times cuts off words mid flow, is there a function in CF that shows x words and not x characters? thanks in advance ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321620 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQUERY Timeout for SQL2005 Fails
The docs say, no, it may not timeout at 1 second. Check out the livedocs... "Because the timeout attribute only affects the maximum time for each suboperation of a query, the cumulative time may exceed its value." And, even then, the query stuff is considered to be 3rd party (or at least, so I remember reading a ways back) and does not fall under the same rules as CF templates when it comes to setting a timeout using CFsetting or by way of the administrator. The best way to kill those hung threads is going to be something like FusionReactor or SeeFusion. Matthew Williams Geodesic GraFX ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321619 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQUERY Timeout for SQL2005 Fails
For an ALTER TABLE to have this affect it would need to be running on a table that you were trying to access. Dropping and adding columns (if that is what was happening) on production tables will cause lots of problems - and not just with CF. It should be done infrequently and very carefully. I would be at a loss to really help if there is no cooperation at the other end. The DB folks have to be involved here. You can't work around poor practice or bad communication. -Mk -Original Message- From: Sung Woo [mailto:s...@cornell.edu] Sent: Wednesday, April 15, 2009 10:38 AM To: cf-talk Subject: Re: CFQUERY Timeout for SQL2005 Fails Hi Mark, To answer your question -- there's a DDL transaction that's running on the server, and from what the folks have told me, an ALTER TABLE command was causing the lock to occur. And the downside is that giving hints (i.e., WITH (NOLOCK)) is not going to have an effect in this situation. Working for a large corporation, I often do not have control over the databases that are in the company. So as much as I'd love to fix the issue, I can't. I'm sure we've all been there. This is why it's imperative that CF has the ability to protect itself against underperforming datasources. - Sung >The query timeout is not designed to work when there is no connection >at all to the DB server. It is designed to time the statement - so if >the connection itself is lost the setting will not have any affect. In >affect you have an orphaned thread out there that is taking up space in >the running request queue. > >The big question is why do you lose connection? Networking? Overloaded >SQL server? That's where you need to focus I think. > >-Mark > > >Mark A. Kruger, CFG, MCSE >(402) 408-3733 ext 105 >www.cfwebtools.com >www.coldfusionmuse.com >www.necfug.com > >Anyone? Bueller? I really need an answer to this -- even though I'm >running Fusion Reactor and can keep a survival strategy, this is no way >to keep a server running. Is there anyone out there who's successfully >used the TIMEOUT parameter in CFQUERY with CFMX 7.0.2 and SQL 2005 Standard? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321618 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQUERY Timeout for SQL2005 Fails
Hi Mark, To answer your question -- there's a DDL transaction that's running on the server, and from what the folks have told me, an ALTER TABLE command was causing the lock to occur. And the downside is that giving hints (i.e., WITH (NOLOCK)) is not going to have an effect in this situation. Working for a large corporation, I often do not have control over the databases that are in the company. So as much as I'd love to fix the issue, I can't. I'm sure we've all been there. This is why it's imperative that CF has the ability to protect itself against underperforming datasources. - Sung >The query timeout is not designed to work when there is no connection at all >to the DB server. It is designed to time the statement - so if the >connection itself is lost the setting will not have any affect. In affect >you have an orphaned thread out there that is taking up space in the running >request queue. > >The big question is why do you lose connection? Networking? Overloaded SQL >server? That's where you need to focus I think. > >-Mark > > >Mark A. Kruger, CFG, MCSE >(402) 408-3733 ext 105 >www.cfwebtools.com >www.coldfusionmuse.com >www.necfug.com > >Anyone? Bueller? I really need an answer to this -- even though I'm >running Fusion Reactor and can keep a survival strategy, this is no way to >keep a server running. Is there anyone out there who's successfully used >the TIMEOUT parameter in CFQUERY with CFMX 7.0.2 and SQL 2005 Standard? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321617 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Unable to access CF Admin
Still unable to access CF Administrator Does anyone know if it can be done. Happy to pay consulting fees to get fixed >Here is the entire httpd-vhosts.conf > >So I do already have the Alias in the file. > > > ># ># Virtual Hosts ># ># If you want to maintain multiple domains/hostnames on your ># machine you can setup VirtualHost containers for them. Most configurations ># use only name-based virtual hosts so the server doesn't need to worry about ># IP addresses. This is indicated by the asterisks in the directives below.. ># ># Please see the documentation at ># http://httpd.apache.org/docs/2.2/vhosts/> ># for further details before you try to setup virtual hosts. ># ># You may use the command line option '-S' to verify your virtual host ># configuration. > > > ># ># Use name-based virtual hosting. ># > >NameVirtualHost *:80 > ># ># VirtualHost example: ># Almost any Apache directive may go into a VirtualHost container. ># The first VirtualHost section is used for all requests that do not ># match a ServerName or ServerAlias in any block. ># > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs" >ServerName default > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/sava/admin" >ServerName default > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Inetpub/wwwroot/CFIDE/administrator" >ServerName default > > >Alias /CFIDE "C:/Inetpub/wwwroot/CFIDE/administrator" > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/cosmeticbeautydirectory" >ServerName www.cosmeticbeautydirectory.com.au >ServerAlias cosmeticbeautydirectory.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/swanseaflowers" >ServerName www.swanseaflowers.com.au >ServerAlias swanseaflowers.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/beecroftflowerplace" >ServerName www.beecroftflowerplace.com.au >ServerAlias beecroftflowerplace.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/vipsolutions" >ServerName www.vipsolutions.com.au >ServerAlias vipsolutions.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/amandaheavens" >ServerName www.amandaheavens.com.au >ServerAlias amandaheavens.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/yorkfamlaw" >ServerName www.yorkfamlaw.com.au >ServerAlias yorkfamlaw.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/ederma" >ServerName www.ederma.com.au >ServerAlias ederma.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/yardy" >ServerName www.yardy.com.au >ServerAlias yardy.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/abansw" >ServerName www.abansw.com >ServerAlias abansw.com > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/capitalcosmeticlaser" >ServerName www.capitalcosmeticlaser.com.au >ServerAlias capitalcosmeticlaser.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/beecroftflowerplace" >ServerName www.beecroftflowerplace.com.au >ServerAlias beecroftflowerplace.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/thesite" >ServerName www.thesite.com.au >ServerAlias thesite.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/sava/cleverminds" >ServerName www.cleverminds.com.au >ServerAlias cleverminds.com.au > > > >ServerAdmin peter.tansw...@cleverminds.com.au >DocumentRoot "C:/Program Files/Apache/htdocs/lookyounger" >ServerName www.lookyounger.com.au >ServerAlias lookyounger.com.au > > > >DocumentRoot "C:/Program Files/Apache/htdocs" >ServerName sava.test.localhost > > > > > > >___> _ >> Start of error message >> >> The website declined to show this webpage > >> HTTP 403 > >> Most likely causes: >> ⢠This website requires you to log in. > >> What you can try: > >> >> Go back to the previous page. >> >> > >> >_ > >> ServerAdmin peter.tansw...@cleverminds.com.au > >> DocumentRoot "C:/Program Files/Apache/htdocs" > >> ServerName d
Re: Looking for a CF drag & drop tutorial
Maya MacDonald wrote: > Hi, > > I am looking for a CF tutorial on how to create a drag and drop list to > reorder entries. > > Thanks! > You may find this useful: http://www.stillnetstudios.com/2006/12/31/drag-and-drop-sort-order-with-scriptaculous/ It shows how to pass the resorted values back into ColdFusion. -Ryan ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321615 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Looking for a CF drag & drop tutorial
On Wednesday 15 Apr 2009, Maya MacDonald wrote: > I am looking for a CF tutorial on how to create a drag and drop list to > reorder entries. You want a client-side solution, like JavaScript, of course, not a server-side one like ColdFusion. I'm sure YUI, jQuery etc. all support this. -- Helping to evangelistically harness robust vertical eye-catching strategic design-patterns as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321614 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQUERY Timeout for SQL2005 Fails
Also -- this may just be me being dense, but I don't get why the TIMEOUT feature in CFQUERY has to work this way. It's CF that's making the initial request to the datasource, so it should start counting down from the moment it creates that request. And then after waiting for a predetermined point of time (in my case, 1 second), it should sever the connection if the connection still exists and return an error. Is there another way this can be handled? Like I said, CFSETTING is also useless in this example, since it, too, has to wait for the CFQUERY to end. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321613 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQUERY Timeout for SQL2005 Fails
Mark and Casey, Thanks for clarifying this for me. I don't own the SQL Server that I need to hit, so it looks like I'm between a rock and a hard place. I still don't think the TIMEOUT parameter is working, though. In my example, I'm hitting a database that is fully operational, and I have a query that runs for about 3.5 seconds. However, I have the TIMEOUT param set to 1, so shouldn't it time out in exactly 1 second and return an error? ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321612 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: CFQUERY Timeout for SQL2005 Fails
This is an interesting thread, I've seen what I believe to be very similar behaviour here on one of my webservices, seemed that one particular query sometimes just hangs indefinitly, however other threads and requests are all just fine. I tried playing around with application request timeouts, concurrent threads and cfquery timeout settings but seem to still have the same problem on occasion, I'm wondering if they're caused by the same issue, I too running SQL2k5 however I'm on CF8. Mark, I'd concur that its waiting to establish a connection, is there anything which can be done to cure that problem with a timeout on the connection? I'd imagine mine is down to load as its a busy statistical database which we're having problems with which really needs moving to a beefier box but in the mean time it'd be nice to try and find a quick-fix to tide me over. Rob >That's totally separate issue. if sqlserver is locking up, coldfusion is >waiting to make a connection, not getting the result back. the timeout on >cfquery only works on the actually sql statement itself. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321611 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Newbie ... Date / Time formatting
You can't output a time with dateformat() - you need to use timeformat() for that bit. mxAjax / CFAjax docs and other useful articles: http://www.bifrost.com.au/blog/ 2009/4/15 BobSharp : > > I am having a problem with erroneous MINUTES in my DateTime > creation/formatting. > The rest of the DateTime comes out correctly. >>> LINK <<< > > > > > http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321610 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Looking for a CF drag & drop tutorial
Hi, I am looking for a CF tutorial on how to create a drag and drop list to reorder entries. Thanks! ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321609 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: CFQUERY Timeout for SQL2005 Fails
The query timeout is not designed to work when there is no connection at all to the DB server. It is designed to time the statement - so if the connection itself is lost the setting will not have any affect. In affect you have an orphaned thread out there that is taking up space in the running request queue. The big question is why do you lose connection? Networking? Overloaded SQL server? That's where you need to focus I think. -Mark Mark A. Kruger, CFG, MCSE (402) 408-3733 ext 105 www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Sung Woo [mailto:s...@cornell.edu] Sent: Wednesday, April 15, 2009 7:58 AM To: cf-talk Subject: Re: CFQUERY Timeout for SQL2005 Fails Anyone? Bueller? I really need an answer to this -- even though I'm running Fusion Reactor and can keep a survival strategy, this is no way to keep a server running. Is there anyone out there who's successfully used the TIMEOUT parameter in CFQUERY with CFMX 7.0.2 and SQL 2005 Standard? > Hi Casey, > > What happened today is that the SQL server basically locked up. CF > kept waiting for the request to come back, but it never did because it > just hung infinititely. It seems as if CF waits forever in a case > like this, so it's vital that I can kill the connection from the > CFQUERY. > > The real query I run returns usually within milliseconds, about 75ms > at most. So this is something that is out of the ordinary, but I want > to prevent it from happening in the future. Is there a way? Thanks. > > > >how about adding WITH (NOLOCK) > > > >If your queries are just selecting data, i'd use WITH (NOLOCK) > > > >that way you don't need to wait for transactions to finish if that > table > >gets heavy inserts > > > > > > > >> select top 2 * WITH (NOLOCK) > >> from table > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321608 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Newbie ... Date / Time formatting
I am having a problem with erroneous MINUTES in my DateTime
creation/formatting.
The rest of the DateTime comes out correctly. >>> LINK <<<
OUTPUT ...
Date Formatting tests
vStartDate = 01/01/2000 vEndDate = 14/4/2009
CreateDateTime (vStartDate) = {ts '2000-01-01 00:00:00'}
DateFormat of the above = 2000-01-01 00:01:00
CreateDateTime (vEndDate) = {ts '2009-04-14 23:59:59'}
DateFormat of the above = 2009-04-14 23:04:59
AFFECTED CODE ...
--
I am using the free version of SPAMfighter.
We are a community of 6 million users fighting spam.
SPAMfighter has removed 12962 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len
The Professional version does not have this message
~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321607
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQUERY Timeout for SQL2005 Fails
On Tue, Apr 14, 2009 at 5:25 PM, Sung Woo wrote: > > Hi Casey, > > What happened today is that the SQL server basically locked up. CF kept > waiting for the request to come back, but it never did because it just hung > infinitely. It seems as if CF waits forever in a case like this, so it's > vital that I can kill the connection from the CFQUERY. > That's totally separate issue. if sqlserver is locking up, coldfusion is waiting to make a connection, not getting the result back. the timeout on cfquery only works on the actually sql statement itself. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321606 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: CFQUERY Timeout for SQL2005 Fails
Anyone? Bueller? I really need an answer to this -- even though I'm running Fusion Reactor and can keep a survival strategy, this is no way to keep a server running. Is there anyone out there who's successfully used the TIMEOUT parameter in CFQUERY with CFMX 7.0.2 and SQL 2005 Standard? > Hi Casey, > > What happened today is that the SQL server basically locked up. CF > kept waiting for the request to come back, but it never did because it > just hung infinititely. It seems as if CF waits forever in a case > like this, so it's vital that I can kill the connection from the > CFQUERY. > > The real query I run returns usually within milliseconds, about 75ms > at most. So this is something that is out of the ordinary, but I want > to prevent it from happening in the future. Is there a way? Thanks. > > > >how about adding WITH (NOLOCK) > > > >If your queries are just selecting data, i'd use WITH (NOLOCK) > > > >that way you don't need to wait for transactions to finish if that > table > >gets heavy inserts > > > > > > > >> select top 2 * WITH (NOLOCK) > >> from table > >> ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321605 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Server Monitoring
On Tuesday 14 Apr 2009, Rob Parkhill wrote: > although I am not sure if that is possible with CF. The other thing I > could test would be the connection to the database, but I can't seem to > find the references to accessing the admin tools in CF8, where I thought > that would be possible, so any resource direction would be much > appreciated. CFQUERY inside a CFTRY/CFCATCH ? -- Helping to continuously morph professional killer e-tailers as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321604 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Java now available on Google App engine - how long til CFML?
On Friday 10 Apr 2009, Rick Mason wrote: > I suspect it will happen and it will be one of the open source distros. The next Ubuntu should, for instance. -- Helping to simultaneously visualize functionalities as part of the IT team of the year, '09 and '08 Tom Chiverton Developer Tel: +44 0161 618 5032 Fax: +44 0161 618 5099 tom.chiver...@halliwells.com 3 Hardman Square, Manchester, M3 3EB www.Halliwells.com This email is sent for and on behalf of Halliwells LLP. Halliwells LLP is a limited liability partnership registered in England and Wales under registered number OC307980 whose registered office address is at Halliwells LLP, 3 Hardman Square, Spinningfields, Manchester, M3 3EB. A list of members is available for inspection at the registered office together with a list of those non members who are referred to as partners. We use the word partner to refer to a member of the LLP, or an employee or consultant with equivalent standing and qualifications. Regulated by the Solicitors Regulation Authority. CONFIDENTIALITY This email is intended only for the use of the addressee named above and may be confidential or legally privileged. If you are not the addressee you must not read it and must not use any information contained in nor copy it nor inform any person other than Halliwells LLP or the addressee of its existence or contents. If you have received this email in error please delete it and notify Halliwells LLP IT Department on 0870 365 2500. For more information about Halliwells LLP visit www.Halliwells.com. ~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321603 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
