[ cf-dev ] Query cacheing
Can anyone verify: Cached queries are application-specific rather than session-specific? Cheers Terry -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Query cacheing
Hi Terry It would make sense if they were session specific. Otherwise if it was application specific incorrect queries (ones produced by other users) would be served. This would cause problems with things like search Interfaces... Not 100% though and i'll be interested to find out also. Regards Mark -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 09:31 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Query cacheing Can anyone verify: Cached queries are application-specific rather than session-specific? Cheers Terry -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Query cacheing
they're server-specific aren't they? Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- [EMAIL PROTECTED] .uk (Terry To: [EMAIL PROTECTED] Riley) cc: Subject: [ cf-dev ] Query cacheing 13/11/2003 09:31 Please respond to dev Can anyone verify: Cached queries are application-specific rather than session-specific? Cheers Terry -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Query cacheing
Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Cache Folders Clearing
Morning... We are using a content management system with two servers in a cluster. Administration can be done on the master server via the content managament system which allows all of the cache folders (there is a 'cache' folder for each subsite - nearly 300 in total!) to be emptied, this is performed manually by clicking a button fairly regularly or after a template change. However, on the slave server, admin via the CMS can not be performed - so , I need a way of clearing the contents of any folder/subfolder called cache below the root directory. Can this be done using CF via a .cfm page which can be scheduled to run regularly in CF Admin, and if so, how? Or, should this be done with an NT Batch job? (and if so any ideas how) Much appreciate any help cheers ___?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. ===
Re: [ cf-dev ] Cache Folders Clearing
get some code that will recurse through a directory tree. amend it to find folders called cache. use cffile to loop through the contents of each of these folders, deleting all the files. set it all up with a scheduled job in the administrator or using cfschedule. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Lovelock, Richard J To: 'cflist' [EMAIL PROTECTED] richard.lovelockcc: @cgey.com Subject: [ cf-dev ] Cache Folders Clearing 13/11/2003 09:50 Please respond to dev Morning... We are using a content management system with two servers in a cluster. Administration can be done on the master server via the content managament system which allows all of the cache folders (there is a 'cache' folder for each subsite - nearly 300 in total!) to be emptied, this is performed manually by clicking a button fairly regularly or after a template change. However, on the slave server, admin via the CMS can not be performed - so , I need a way of clearing the contents of any folder/subfolder called cache below the root directory. Can this be done using CF via a .cfm page which can be scheduled to run regularly in CF Admin, and if so, how? Or, should this be done with an NT Batch job? (and if so any ideas how) Much appreciate any help cheers ___?xml:namespace prefix = o ns = urn:schemas-microsoft-com:office:office / * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. === -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Query cacheing
Thanks for that, Aidan. So on a server that only runs one application, they would effectively be application-wide. Otherwise, with several apps on one server, one would have to be careful on query naming, by the sound of it. (or put them to application or session scope) Cheers Terry --Original Message- Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Query cacheing
Yup, server-wide -- and only 100 per server is the setting so on a server with a lot of sites the gains are rather minimal... - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 9:50 AM Subject: RE: [ cf-dev ] Query cacheing Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OnMouseover from within function
Sorry...been out looking after my newborn... What are you trying to do? You can easily change style/text within a page (as long as JS can see it as object)! N - Original Message - From: Dave Phipps [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 8:50 PM Subject: Re: [ cf-dev ] OnMouseover from within function Matt, Sorry had no email this afternoon. I tried it but it didn't do anything. I have now given up on the idea of doing a mouseover. Thanks anyway. Dave At 11/12/2003 12:46, you wrote: Dave , did this work for you? - Original Message - From: Matt Horn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:20 AM Subject: Re: [ cf-dev ] OnMouseover from within function oA.mouseover = 'this.style.color:#ff'; that may work Matt - Original Message - From: Dave Phipps [EMAIL PROTECTED] To: ColdFusion User group [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:07 AM Subject: [ cf-dev ] OnMouseover from within function Hi, I have some javascript that generates a menu tree and each menu item can have an associated URL. What I want to do is apply a color change to the menu text when I mouseover. All of the code is within javascript so I can't do the usual onMouseover= etc. An example of some of the script is: oA.className = sNodeClass; This sets the class for the particular element. What I am trying to workout is how to do something like this: oA.mouseover = color:#44FF00; However this does not work. Anyone have any ideas? Thanks Dave -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] SOT: sms email gateway
thanks Alex, but that's an email sms service. I'm ideally looking for the opposite. Ta though. Currently looking at Peter's suggestion. -Original Message- From: Alex Skinner [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 18:34 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] SOT: sms email gateway kapow www.kapow.co.uk -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 17:21 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] SOT: sms email gateway Anyone know of any sms email gateways in the UK that work with all networks? I have an app that needs users in the streets to send in alerts, but their mobiles might not necessarily send emails, so we have to go for txt and then convert somehow to email so they can be picked up programmatically.. --- Rich Wild Senior Web Developer --- e-mango Tel: 01202 755 300 Gild House Fax: 01202 755 301 74 Norwich Avenue West Bournemouth Mailto:[EMAIL PROTECTED] BH2 6AW, UK http://www.e-mango.com --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of e-mango.com ltd, unless otherwise explicitly and independently indicated by an authorised representative of e-mango.com ltd. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Regex additional help
Hi, A long time ago I ask the list for some help with some regex of which the result was this: REReplacenocase(fusebox.layout,'(href=index[.]cfm[^]+)()','\1#request.urltoken#\2', 'all') The client now wishes to be able to use a full URL and therefore I need to change the above regex to be able to handle a url like this: http://www.mysite.com/index.cfm How do I change the above regex to include the full url without specifying exactly what that url is apart from the index.cfm which will stay the same. In other words, if the domain changes I don't want to have to go back through the code and change the above regex. Any help? Cheers Dave -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] OnMouseover from within function
Congrats on the new baby, ours is 1 next week - what a year!! I have a javascript tree menu system based loosely on the msdn TOC tree. It uses some javascript to generate the tree on the fly by grabbing each child node from another cfm template as it is selected. The javascript creates various sections for building the icons and text and I wanted to be able to place a mouseover color change to the text. I managed to get a cursor change on the icons but cannot get the text to pick up the stye onmouseover. Here is a snippet of js: oIMG = document.createElement(img); oIMG.border = 0; oIMG.className = handcursor; So I would want something like: oIMG.mouseover = style.color:44FF00;; This does not work though!! Cheers Dave At 11/13/2003 10:29, you wrote: Sorry...been out looking after my newborn... What are you trying to do? You can easily change style/text within a page (as long as JS can see it as object)! N - Original Message - From: Dave Phipps [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 8:50 PM Subject: Re: [ cf-dev ] OnMouseover from within function Matt, Sorry had no email this afternoon. I tried it but it didn't do anything. I have now given up on the idea of doing a mouseover. Thanks anyway. Dave At 11/12/2003 12:46, you wrote: Dave , did this work for you? - Original Message - From: Matt Horn [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:20 AM Subject: Re: [ cf-dev ] OnMouseover from within function oA.mouseover = 'this.style.color:#ff'; that may work Matt - Original Message - From: Dave Phipps [EMAIL PROTECTED] To: ColdFusion User group [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:07 AM Subject: [ cf-dev ] OnMouseover from within function Hi, I have some javascript that generates a menu tree and each menu item can have an associated URL. What I want to do is apply a color change to the menu text when I mouseover. All of the code is within javascript so I can't do the usual onMouseover= etc. An example of some of the script is: oA.className = sNodeClass; This sets the class for the particular element. What I am trying to workout is how to do something like this: oA.mouseover = color:#44FF00; However this does not work. Anyone have any ideas? Thanks Dave -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex additional help
application.cfm: cfset request.globalURL = http://www.mysite.com; regex: REReplacenocase(fusebox.layout,'(href=#request.globalURL#/index[.]cfm[^] +)()','\1#request.urltoken#\2', 'all') Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Dave Phipps [EMAIL PROTECTED]To: ColdFusion User group [EMAIL PROTECTED] cf.co.ukcc: Subject: [ cf-dev ] Regex additional help 13/11/2003 10:35 Please respond to dev Hi, A long time ago I ask the list for some help with some regex of which the result was this: REReplacenocase(fusebox.layout,'(href=index[.]cfm[^]+)()',' \1#request.urltoken#\2', 'all') The client now wishes to be able to use a full URL and therefore I need to change the above regex to be able to handle a url like this: http://www.mysite.com/index.cfm How do I change the above regex to include the full url without specifying exactly what that url is apart from the index.cfm which will stay the same. In other words, if the domain changes I don't want to have to go back through the code and change the above regex. Any help? Cheers Dave -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] a question
Hi, I'm an Italian boy who is trying to use CF using helm. .I've a problem with an SQL operation and I need help. I hope you can help me. The query is: cfquery datasource=fantabasket name=sel SELECT users.simbolo, Users.squadra, Classifica.punti, Classifica.pgioc, Classifica.pv, Classifica.pp, Classifica.ptot FROM Classifica INNER JOIN Users ON Classifica.id_users = Users.id_users ORDER BY Classifica.punti DESC , Classifica.ptot DESC /cfquery Helm give me this error (the attached file): do you know why? Tanks for all Samuele Spinelli - Original Message - From: Steve Martin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:07 AM Subject: RE: [ cf-dev ] Use of cfqueryparam CFQUERYPARAM parameterises the SQL in that irrespective of the variable values being used in the query, the actual SQL query is the same in every execution with the parameters being passed in seperately. This allows the RDBMS to precompile cache execution plans once for the general query template as opposed to each time a subtley different query is submitted. Oh, and it also prevents SQL injection hacking as a useful side effect. Steve -Original Message- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 13:30 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Use of cfqueryparam I've seen a lot of code lately where the query (either extracting, inserting or updating information) uses the cfqueryparam value=#xxx# in the WHERE clause, without qualifying the parameter with a cfsqltype. I can understand the use of the cfqueryparam with a cfsqltype and other attributes as one way of preventing cross-site scripting (adding additional text to the string to do something evil), but see no point in using 'WHERE ID = cfqueryparam value=#url.ID#' as opposed to 'WHERE ID = #url.ID#' Is there one? Is it faster? Manuals and googles don't seem to come up with an answer. Cheers Terry -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] a question
don't think you can send attachments to this list; copy and paste your SQL error message into the email. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Spinelli Samuele To: [EMAIL PROTECTED] [EMAIL PROTECTED]cc: li.it Subject: [ cf-dev ] a question 13/11/2003 11:00 Please respond to dev Hi, I'm an Italian boy who is trying to use CF using helm. .I've a problem with an SQL operation and I need help. I hope you can help me. The query is: cfquery datasource=fantabasket name=sel SELECT users.simbolo, Users.squadra, Classifica.punti, Classifica.pgioc, Classifica.pv, Classifica.pp, Classifica.ptot FROM Classifica INNER JOIN Users ON Classifica.id_users = Users.id_users ORDER BY Classifica.punti DESC , Classifica.ptot DESC /cfquery Helm give me this error (the attached file): do you know why? Tanks for all Samuele Spinelli - Original Message - From: Steve Martin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 12, 2003 10:07 AM Subject: RE: [ cf-dev ] Use of cfqueryparam CFQUERYPARAM parameterises the SQL in that irrespective of the variable values being used in the query, the actual SQL query is the same in every execution with the parameters being passed in seperately. This allows the RDBMS to precompile cache execution plans once for the general query template as opposed to each time a subtley different query is submitted. Oh, and it also prevents SQL injection hacking as a useful side effect. Steve -Original Message- From: Terry Riley [mailto:[EMAIL PROTECTED] Sent: 11 November 2003 13:30 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Use of cfqueryparam I've seen a lot of code lately where the query (either extracting, inserting or updating information) uses the cfqueryparam value=#xxx# in the WHERE clause, without qualifying the parameter with a cfsqltype. I can understand the use of the cfqueryparam with a cfsqltype and other attributes as one way of preventing cross-site scripting (adding additional text to the string to do something evil), but see no point in using 'WHERE ID = cfqueryparam value=#url.ID#' as opposed to 'WHERE ID = #url.ID#' Is there one? Is it faster? Manuals and googles don't seem to come up with an answer. Cheers Terry -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Query cacheing
So on a server that only runs one application, they would effectively be application-wide. Otherwise, with several apps on one server, one would have to be careful on query naming, by the sound of it. This was posted on cf-talk yesterday: -Original Message- From: A Tamuri [mailto:[EMAIL PROTECTED] Sent: 12 November 2003 16:51 Subject: Custom tag to see list of cached queries! ... I have written a CFX custom tag for CFMX, called cfx_queryCache, which allows you to get a list of all your cached queries and flush individual queries based on its key. I'd be interested in any ideas for improvements, both functionality and improving the Java code. It's open-source and available from http://tamuri.cfdeveloper.co.uk/ From the information on this page, the key that is used to store a cached query is based on datasource + sql + name + username + password. Also note that the sql part of this is specific to the *exact* query, right down to whitespace... From this, it means that the only time you're likely to be running the same query over multiple applications is if you're using a shared library or include and exactly the same datasource and parameters. In which case, you're after exactly the same data from both applications, so if wouldn't matter that you're retrieving the same info for both... Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Regex additional help
How do I change the above regex to include the full url without specifying exactly what that url is apart from the index.cfm which will stay the same. Here's a regex I've used for checking URLs: ^http[s]{0,}:\/\/[A-Za-z0-9-\.]+[A-Za-z0-9-_\.\/\?\]{0,} Maybe you can hack that apart a bit...? Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Query cacheing
- and only 100 per server is that even if you dump the cached queries into session or application scope? only 100 avail for Q-of-Q? cheers barry.b -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 November 2003 8:20 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Yup, server-wide -- and only 100 per server is the setting so on a server with a lot of sites the gains are rather minimal... - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 9:50 AM Subject: RE: [ cf-dev ] Query cacheing Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Query cacheing
Sorry, I should have been more clear. The server only stores 100 cached queries at any one time. If a new cached query is run, the oldest will be knocked off the list of 100 stored and so is no longer cached. It will only be cached once it is run again. This is why on a server with many applications you will not get a huge performance increase from cached queries. Dumping the query into a session or application scope is entirely seperate from the caching process. I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. HTH - Original Message - From: Beattie, Barry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 11:57 AM Subject: RE: [ cf-dev ] Query cacheing - and only 100 per server is that even if you dump the cached queries into session or application scope? only 100 avail for Q-of-Q? cheers barry.b -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 November 2003 8:20 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Yup, server-wide -- and only 100 per server is the setting so on a server with a lot of sites the gains are rather minimal... - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 9:50 AM Subject: RE: [ cf-dev ] Query cacheing Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Query cacheing
I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. i believe that is correct about the caching of QofQ the number of cached queries can be altered in CF Admin ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 12:08 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Sorry, I should have been more clear. The server only stores 100 cached queries at any one time. If a new cached query is run, the oldest will be knocked off the list of 100 stored and so is no longer cached. It will only be cached once it is run again. This is why on a server with many applications you will not get a huge performance increase from cached queries. Dumping the query into a session or application scope is entirely seperate from the caching process. I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. HTH - Original Message - From: Beattie, Barry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 11:57 AM Subject: RE: [ cf-dev ] Query cacheing - and only 100 per server is that even if you dump the cached queries into session or application scope? only 100 avail for Q-of-Q? cheers barry.b -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 November 2003 8:20 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Yup, server-wide -- and only 100 per server is the setting so on a server with a lot of sites the gains are rather minimal... - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 9:50 AM Subject: RE: [ cf-dev ] Query cacheing Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. === -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Query cacheing
I think I read somewhere, on this list maybe, that the limit on query caching in CFMX went up or was controllable. Is this right? -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 12:08 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Sorry, I should have been more clear. The server only stores 100 cached queries at any one time. If a new cached query is run, the oldest will be knocked off the list of 100 stored and so is no longer cached. It will only be cached once it is run again. This is why on a server with many applications you will not get a huge performance increase from cached queries. Dumping the query into a session or application scope is entirely seperate from the caching process. I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. HTH - Original Message - From: Beattie, Barry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 11:57 AM Subject: RE: [ cf-dev ] Query cacheing - and only 100 per server is that even if you dump the cached queries into session or application scope? only 100 avail for Q-of-Q? cheers barry.b -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 November 2003 8:20 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Yup, server-wide -- and only 100 per server is the setting so on a server with a lot of sites the gains are rather minimal... - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 9:50 AM Subject: RE: [ cf-dev ] Query cacheing Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Query cacheing
the number of cached queries can be altered in CF Admin Ah yeah... I was going to ask about that. Do you have any ideas of the performance issues of ramping it up? I seem to remember being advised against doing it... - Original Message - From: Lovelock, Richard J [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:10 PM Subject: RE: [ cf-dev ] Query cacheing I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. i believe that is correct about the caching of QofQ the number of cached queries can be altered in CF Admin ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 12:08 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Sorry, I should have been more clear. The server only stores 100 cached queries at any one time. If a new cached query is run, the oldest will be knocked off the list of 100 stored and so is no longer cached. It will only be cached once it is run again. This is why on a server with many applications you will not get a huge performance increase from cached queries. Dumping the query into a session or application scope is entirely seperate from the caching process. I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. HTH - Original Message - From: Beattie, Barry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 11:57 AM Subject: RE: [ cf-dev ] Query cacheing - and only 100 per server is that even if you dump the cached queries into session or application scope? only 100 avail for Q-of-Q? cheers barry.b -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 November 2003 8:20 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Yup, server-wide -- and only 100 per server is the setting so on a server with a lot of sites the gains are rather minimal... - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 9:50 AM Subject: RE: [ cf-dev ] Query cacheing Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. === -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional
RE: [ cf-dev ] Query cacheing
Alex (Skinner) may be able to advise but taken from CF Admin course notes: Do not limit the number of cached queries on the server, as caching queries can be a fundamental performance booster. I would set this to . When CF runs out of memory it will simpy drop the oldest query from the cache but Following article http://www.defusion.com/articles/index.cfm?articleid=130 says: In ColdFusion 4.5 the number of cached queries that you can have on the server is only really limited by the amount of physical memory you have in your machine. This setting is provided as a way for you to limit yourself, so that you don't get carried away and eat up all of your server resources storing cached query results. Also keep in mind the size of the result sets for the queries you are caching. This setting will allow you to limit the NUMBER of cached queries, but that has nothing to do with the total SIZE of all of the cached queries combined. Looks like there is an impact on server resources but can also dramatically help performance. I know that I where I have experimented with cached and uncached - the cached query pages are significantly quicker not sure if that helps :o/ ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 12:17 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing the number of cached queries can be altered in CF Admin Ah yeah... I was going to ask about that. Do you have any ideas of the performance issues of ramping it up? I seem to remember being advised against doing it... - Original Message - From: Lovelock, Richard J [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 12:10 PM Subject: RE: [ cf-dev ] Query cacheing I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. i believe that is correct about the caching of QofQ the number of cached queries can be altered in CF Admin ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 ___ -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 12:08 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Sorry, I should have been more clear. The server only stores 100 cached queries at any one time. If a new cached query is run, the oldest will be knocked off the list of 100 stored and so is no longer cached. It will only be cached once it is run again. This is why on a server with many applications you will not get a huge performance increase from cached queries. Dumping the query into a session or application scope is entirely seperate from the caching process. I assume that a QofQ is identical to a query as far as caching goes -- it's relationship to another query would not be cached, just the query itself. HTH - Original Message - From: Beattie, Barry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 11:57 AM Subject: RE: [ cf-dev ] Query cacheing - and only 100 per server is that even if you dump the cached queries into session or application scope? only 100 avail for Q-of-Q? cheers barry.b -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 November 2003 8:20 PM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Query cacheing Yup, server-wide -- and only 100 per server is the setting so on a server with a lot of sites the gains are rather minimal... - Original Message - From: Aidan Whitehall [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 9:50 AM Subject: RE: [ cf-dev ] Query cacheing Cached queries are application-specific rather than session-specific? Just done a test, and they aren't application specific but server wide. -- Aidan Whitehall mailto:[EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental Ltd +44 (0)1695 51775 Queen's Awards Winner 2003 http://www.fairbanks.co.uk/go/awards This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk
RE: [ cf-dev ] Regex additional help
Thanks Tim, I'll play around with it. I have now got it working. Always look for the easy answer: This does just what I need: REReplacenocase(fusebox.layout,'(index[.]cfm[^]+)','\1#request.urltoken#\2', 'all') It then does not matter if the the url looks like http://www.mysite.com/index.cfm or just index.cfm. They are both fixed. Cheers Dave At 11/13/2003 11:54, you wrote: How do I change the above regex to include the full url without specifying exactly what that url is apart from the index.cfm which will stay the same. Here's a regex I've used for checking URLs: ^http[s]{0,}:\/\/[A-Za-z0-9-\.]+[A-Za-z0-9-_\.\/\?\]{0,} Maybe you can hack that apart a bit...? Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. Visit our new website at http://www.rawnet.com for more information about our company, or call us free anytime on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1344 393 441 Switchboard : +44 (0) 1344 393 040 --- This message may contain information which is legally privileged and/or confidential. If you are not the intended recipient, you are hereby notified that any unauthorised disclosure, copying, distribution or use of this information is strictly prohibited. Such notification notwithstanding, any comments, opinions, information or conclusions expressed in this message are those of the originator, not of rawnet limited, unless otherwise explicitly and independently indicated by an authorised representative of rawnet limited. --- -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Searching for resolutions
When trying to find help online for CF related problems on searchable discussion forums - is the Macromedia CF Support forum the main/best place to go - or are there are searchable CF discussion forums that people here use regularly and can recommend? Regards Richard === This message contains information that may be privileged or confidential and is the property of the Cap Gemini Ernst Young Group. It is intended only for the person to whom it is addressed. If you are not the intended recipient, youare not authorized to read, print, retain, copy, disseminate, distribute, or use this message or any part thereof. If you receive this message in error, please notify the sender immediately and delete all copies of this message. ===
[ cf-dev ] Regex
I have an application where my client wants to prevent users putting in either an email or a phone number into a textform field. This is to ensure that contact is made through the site owner.. Does anyone have to hand a regex that can detect an email in a stringthat they could share. Does any have an suggestions about phone numbers I think any string with more that 5 numerals would be seen as suspicious ! Only UK numbers are the concern here TIA for any thoughts. Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Regex
@+|[0-9 ]{7,} Wouldn't that do it: either a @ sign or any combination of 7 numerals or spaces. Search for this and inform if found. Paolo -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 13:46 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex I have an application where my client wants to prevent users putting in either an email or a phone number into a textform field. This is to ensure that contact is made through the site owner.. Does anyone have to hand a regex that can detect an email in a stringthat they could share. Does any have an suggestions about phone numbers I think any string with more that 5 numerals would be seen as suspicious ! Only UK numbers are the concern here TIA for any thoughts. Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
Would it not be easier to check that the entered value _is_ something, as opposed to _is not_ something?? Or doesn't the client really have a set idea of what they want from the user, just that it shouldn't be email or phone number? Stephen Gordon Burns wrote: I have an application where my client wants to prevent users putting in either an email or a phone number into a textform field. This is to ensure that contact is made through the site owner.. Does anyone have to hand a regex that can detect an email in a stringthat they could share. Does any have an suggestions about phone numbers I think any string with more that 5 numerals would be seen as suspicious ! Only UK numbers are the concern here TIA for any thoughts. Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Regex
if someone really wants to put something in, there's not a lot you can do about it. If I really wanted to put a telephone number in, and noticed you regex'ing them out, I'd just do this: 0 two 0 four 3 six 7 four 7. that'll pass a telephone number regex. Same with e-mail, like friendsreunited discovered, there's no way other than manual moderation to catch all variances (eg rDOTwildATe-mangoDOTcom) -Original Message- From: Gordon Burns [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 13:46 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex I have an application where my client wants to prevent users putting in either an email or a phone number into a textform field. This is to ensure that contact is made through the site owner.. Does anyone have to hand a regex that can detect an email in a stringthat they could share. Does any have an suggestions about phone numbers I think any string with more that 5 numerals would be seen as suspicious ! Only UK numbers are the concern here TIA for any thoughts. Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
this would be too easy to get around, just like you can get around printing your email address on a page in a way that spambots can harvest it. I'd be really annoyed too if some form rejected my submission because it thought I'd put in an email address. Perhaps in these cases instead of informing the user, just inform the site administrator to deal with it manually (reject/edit/approve the user's message). otherwise, if you have a message like Sorry but we don't let you put email address or phone numbers in this form, I'd just put in something like: email @ my domain.com to get round it. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Gordon Burns [EMAIL PROTECTED]To: [EMAIL PROTECTED] quick.net cc: Subject: [ cf-dev ] Regex 13/11/2003 13:46 Please respond to dev I have an application where my client wants to prevent users putting in either an email or a phone number into a textform field. This is to ensure that contact is made through the site owner.. Does anyone have to hand a regex that can detect an email in a stringthat they could share. Does any have an suggestions about phone numbers I think any string with more that 5 numerals would be seen as suspicious ! Only UK numbers are the concern here TIA for any thoughts. Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Scottish CFUG Meeting - Thursday 20th November - CFCs Part 1
ah yes, Loch Lomond, that well known hot-bed of CF development ;-) Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Stephen Moretti To: [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ter.co.ukSubject: [ cf-dev ] Scottish CFUG Meeting - Thursday 20th November - CFCs Part 1 13/11/2003 14:11 Please respond to dev Just thought I'd pass on that the Scottish CFUG will be meeting next Thursday in Loch Lomond Leisure Club Bar. The meeting topic will be ColdFusion Components and how that can be used to leverage OO programming techniques to build powerful applications quickly. Duncan Jack, founder and manager, of the Scottish CFUG will be the speaker for this session. Duncan is also looking for other people interested in speaking at meetings up in Scotland. You can contact him at [EMAIL PROTECTED] if you're interested in speaking or have suggestions for someone that you would like to come and speak. You can find the Scottish CFUG website at http://www.scottishcfug.com/ Regards Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Verity vs full-text catalog
I am using full-text catalogs on a BIG database so I can do text searches using CONTAINS, but they take like 2 days to populate, so I am gonna give verity a try instead. Anyone got experience of creating verity collections for very large databases and how it compares to using full-text catalogs. Also I know there are restrictions on the version of verity that comes with CF, it will only return a certain number of results. Anyone every bought the full K2 verity server and know how much it is ? Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] some work going
Hi all, just putting another call out for anyone looking for a bit of work in London starting about mid-December and going on perhaps till mid-Jan. Will involve: 1. liaising between development agencies and webhosts 2. advising on technical issues and new site specifications 3. we use Cold Fusion and SQL2000 so a working knowledge of these 4. basic Photoshop skills 5. working in London office Please send me an email privately if you're interested or need more information. I had a few people who were going to send me CV's last time I advertised but never received any, so send them over now if you're still interested! Hope to hear form some of you! Thanks, Damien -- This mail sent through http://www.ukonline.net -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Verity vs full-text catalog
Have you looked into incremental population? Ade -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 14:33 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Verity vs full-text catalog I am using full-text catalogs on a BIG database so I can do text searches using CONTAINS, but they take like 2 days to populate, so I am gonna give verity a try instead. Anyone got experience of creating verity collections for very large databases and how it compares to using full-text catalogs. Also I know there are restrictions on the version of verity that comes with CF, it will only return a certain number of results. Anyone every bought the full K2 verity server and know how much it is ? Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
At 14:08 13/11/2003 Stephen Moretti said Would it not be easier to check that the entered value _is_ something, as opposed to _is not_ something?? Yes it would but the application does not work like that. The text area form is text entered by one user to be sent to another user and at this stage we do not want either user to have access to each other. It is not a dating application but to do with rare and difficult to to obtain machinery parts. Or doesn't the client really have a set idea of what they want from the user, just that it shouldn't be email or phone number? That is it really, no sneaking in an attempt at direct contact. However I have no found a function at CFLib.org still considering what to do about the numbers. Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
if you don't want users to have access to each other, don't let them enter text in a form that can be sent from one user to another. have everything moderated in between. logistical nightmare if you have a lot of users, or a lot of messages. but the only way to do it properly. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative solutions in a technical world -- Get your domain names online from: http://www.alienationdomains.co.uk Reseller options available! -- -- Gordon Burns [EMAIL PROTECTED]To: [EMAIL PROTECTED] quick.net cc: Subject: Re: [ cf-dev ] Regex 13/11/2003 15:17 Please respond to dev At 14:08 13/11/2003 Stephen Moretti said Would it not be easier to check that the entered value _is_ something, as opposed to _is not_ something?? Yes it would but the application does not work like that. The text area form is text entered by one user to be sent to another user and at this stage we do not want either user to have access to each other. It is not a dating application but to do with rare and difficult to to obtain machinery parts. Or doesn't the client really have a set idea of what they want from the user, just that it shouldn't be email or phone number? That is it really, no sneaking in an attempt at direct contact. However I have no found a function at CFLib.org still considering what to do about the numbers. Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Regex
At 14:16 13/11/2003 Rich Wild said if someone really wants to put something in, there's not a lot you can do about it. If I really wanted to put a telephone number in, and noticed you regex'ing them out, I'd just do this: 0 two 0 four 3 six 7 four 7. that'll pass a telephone number regex. Same with e-mail, like friendsreunited discovered, there's no way other than manual moderation to catch all variances (eg rDOTwildATe-mangoDOTcom) You are right of course but the message will be seen and reviwed after the event and if a user is playing sill y beggars they are an ex user. Frankly I do not think the client has a big problem here as it will be bad news for the user if he can not use the system. Thanks Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Regex
At 14:26 13/11/2003 [EMAIL PROTECTED] said this would be too easy to get around, just like you can get around printing your email address on a page in a way that spambots can harvest it. I'd be really annoyed too if some form rejected my submission because it thought I'd put in an email address. Perhaps in these cases instead of informing the user, just inform the site administrator to deal with it manually (reject/edit/approve the user's message). otherwise, if you have a message like Sorry but we don't let you put email address or phone numbers in this form, I'd just put in something like: email @ my domain.com to get round it. I am sure that once a user is warned that will be the end of the problem as it is simply not worth their while to risk being dumped from the system, The warning that we have sent the message butt removed the email etc will be sufficient to let them know that trying to get around the system will not work. Thanks to all for the coments. very useful when talking to client.. Gordon -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Verity vs full-text catalog
We have to do full population as the database is reloaded every week. - FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.giantcompany.com -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 15:24 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Verity vs full-text catalog Have you looked into incremental population? Ade -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 14:33 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Verity vs full-text catalog I am using full-text catalogs on a BIG database so I can do text searches using CONTAINS, but they take like 2 days to populate, so I am gonna give verity a try instead. Anyone got experience of creating verity collections for very large databases and how it compares to using full-text catalogs. Also I know there are restrictions on the version of verity that comes with CF, it will only return a certain number of results. Anyone every bought the full K2 verity server and know how much it is ? Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Problems with certain characters using XmlTransform
I'm getting a weird problem doing XSLT in CFMX 6.1. Every time CF encounters an 'è' as in crèche, it converts it into crà che in the output HTML. If I do the transform directly using Xalan 2.5, it works no problem. Has anyone else had this problem? What version of Xalan is CF using 'under the hood'? Adam Bailin Web Developer Ofsted Tel: 020 7421 5977 ** We cannot accept any liability for any loss or damage sustained as a result of software viruses. It is your responsibility to carry out such virus checking as is necessary before opening any attachment to this message. The information in this email and any files transmitted with it may be of a confidential nature and is intended solely for the addressees. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. www.ofsted.gov.uk ** -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Verity vs full-text catalog
MSSEARCH isn't crap Stephen, it's actually quite good. In my tests it is operating faster than verity. I have indexed over 20million records with the FULL-TEXT Search and am getitng results back in seconds. The only problem is the time to create the flippin catalog. - FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.giantcompany.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 16:13 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Verity vs full-text catalog Verity is a real text indexing and retrieval engine unlike that thing that MS attached to SQL Server. CFMX std can only index/search 125000 documents/records, CFMX Ent can cope with 25 documents/records. I believe that is total, not per collection. I don't believe there are restrictions on the number of records returned in a search (other than as I've just mentioned). In terms of a price for Verity K2 you're probably at some where between 20 to 50k. Regards Stephen Snake Hollywood wrote: I am using full-text catalogs on a BIG database so I can do text searches using CONTAINS, but they take like 2 days to populate, so I am gonna give verity a try instead. Anyone got experience of creating verity collections for very large databases and how it compares to using full-text catalogs. Also I know there are restrictions on the version of verity that comes with CF, it will only return a certain number of results. Anyone every bought the full K2 verity server and know how much it is ? Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Verity vs full-text catalog
MSSEARCH isn't crap Stephen, it's actually quite good. In my tests it is operating faster than verity. I have indexed over 20million records with the FULL-TEXT Search and am getitng results back in seconds. The only problem is the time to create the flippin catalog. - FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.giantcompany.com -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 16:13 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Verity vs full-text catalog Verity is a real text indexing and retrieval engine unlike that thing that MS attached to SQL Server. CFMX std can only index/search 125000 documents/records, CFMX Ent can cope with 25 documents/records. I believe that is total, not per collection. I don't believe there are restrictions on the number of records returned in a search (other than as I've just mentioned). In terms of a price for Verity K2 you're probably at some where between 20 to 50k. Regards Stephen Snake Hollywood wrote: I am using full-text catalogs on a BIG database so I can do text searches using CONTAINS, but they take like 2 days to populate, so I am gonna give verity a try instead. Anyone got experience of creating verity collections for very large databases and how it compares to using full-text catalogs. Also I know there are restrictions on the version of verity that comes with CF, it will only return a certain number of results. Anyone every bought the full K2 verity server and know how much it is ? Russ -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Problems with certain characters using XmlTransform
What character is displayed in the HTML source, you may need to change the encoding of the page. Russ - FIGHT BACK AGAINST SPAM! Download Spam Inspector, the Award Winning Anti-Spam Filter http://mail.giantcompany.com -Original Message- From: Adam Bailin [mailto:[EMAIL PROTECTED] Sent: 13 November 2003 16:39 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Problems with certain characters using XmlTransform I'm getting a weird problem doing XSLT in CFMX 6.1. Every time CF encounters an 'è' as in crèche, it converts it into crà che in the output HTML. If I do the transform directly using Xalan 2.5, it works no problem. Has anyone else had this problem? What version of Xalan is CF using 'under the hood'? Adam Bailin Web Developer Ofsted Tel: 020 7421 5977 ** We cannot accept any liability for any loss or damage sustained as a result of software viruses. It is your responsibility to carry out such virus checking as is necessary before opening any attachment to this message. The information in this email and any files transmitted with it may be of a confidential nature and is intended solely for the addressees. If you are not the intended addressee, any disclosure, copying or distribution by you is prohibited and may be unlawful. www.ofsted.gov.uk ** -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED] -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
Re: [ cf-dev ] Verity vs full-text catalog
MSSEARCH isn't crap Stephen, it's actually quite good. In my tests it is operating faster than verity. really?? Are you sure its not because you're using CONTAINS instead of STEM searches and other text indexing/retrieval type stuff etc? (he says struggling for a suitable Information Library Management type term) CONTAINS will be a damn site quicker than a full stem search, as it will look for exactly what you enter in the query. eg. searching for appearing with CONTAINS will get you just that. A STEM search will look for all versions and tenses of appear. I have indexed over 20million records with the FULL-TEXT Search and am getitng results back in seconds. The only problem is the time to create the flippin catalog. I suspect that you aren't going to be able to get past that. Is there a reason for full replacements of the database, rather than only those records that have changed? Can you get the client to update the database, rather than the originating flat files? Stephen -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
[ cf-dev ] Font in plain text emails
Hi, When sending out plain text emails, we have noticed that with cfmx plain text emails appear in Arial font in ms outlook. It used to be times new roman before. Our client has noticed this difference and requested whether verdana is possible instead of arial in plain text email... Would it be possible. Have a feeling its something to do with charset attribute.set to UTF-8 in our case..which makes the font appear in Arial by default? Know it wudnt be possible normally in plaintext emails but then why plain text emails would be appearing in Arial with mx instead of times new roman. Any advice much appreciated. Thanks in advance, Sandeep -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]