[ cf-dev ] ThreeselectsRelated

2003-10-22 Thread Matt Horn
anyone know where I can get a copy of this custom tag? thanks |\/| Matt Horn Web Applications Developer Ph:+2782 424 3751 W: http://www.matt-horn.org E:[EMAIL PROTECTED] |\/|

RE: [ cf-dev ] ThreeselectsRelated

2003-10-22 Thread Rich Wild
sent offlist -Original Message- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 09:00 To: [EMAIL PROTECTED] Subject: [ cf-dev ] ThreeselectsRelated anyone know where I can get a copy of this custom tag? thanks |\/| Matt Horn Web

[ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Ellwood
Has anyone took this exam yet? If so, any pointers? Other than the obvious use the code answer. -- ** 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

Re: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Matt Horn
source its use the soure :d - Original Message - From: Ellwood [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 11:00 AM Subject: [ cf-dev ] Certified CFMX Developer Exam Has anyone took this exam yet? If so, any pointers? Other than the obvious use the code

RE: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Stephen Pope
Dunno .. ill be taking it next month so any pointers would be doubly welcome :¬) There is a program called CFMX Buster which generate exams that you might wanna try out then there's the old CFMX study guide. Wonder if there will be any 6.1 questions :¬) Stephen -Original Message-

RE: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Alex Skinner
Practice and more practice, id guess. The exam does expect you to know most attributes of tags and knowledge of most functions. Also you will be presented with code for which you need to find the error or say what the output will be. If you want a good revision guide get ben fortas cfmx exam book

[ cf-dev ] Re: [cfmail] RE: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Allan Cliff
I find the CF(MX) Buster program and the Ben Forta guide also comprehensive for this exam. I used them for the CF5 exam and the questions were very similar to the example ones. Allan

RE: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Simon Horwith
if you look at the outline on Macromedia.com and look over the syllabus for the fast track to ColdFsion, Advanced Coldfusion for Developers, and Fast Track to SQL courses and make sure you're comfortable with all of those topics, you'll be fine ;) ~Simon Simon Horwith CTO, Etrilogy Ltd. Member

RE: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Ellwood
I have got Bens book. Very good indeed and also took a few example exams on Bens site, even better and quite encouragingly been scoring 75 - 85% each time. However, I downloaded the CFMX buster trial and failed miserably which means its back to the books for the next few days as my exam is on

[ cf-dev ] Performance

2003-10-22 Thread Allan Cliff
Anyone like to share their opinion on improving coldfusion speed either by using stored procedures or caching queries? Which one is better? Or does it depend on the query. At the moment I have a mixture of them both with dynamic queries as SP and basic queries q_GetCountries and q_GetStates as

Re: [ cf-dev ] Performance

2003-10-22 Thread Matt Horn
storedprocs are great as the are semi precompiled but if the datapath changes on each query you wont see much performance enhancement one way to increase performance is to cffile the most visited pages down to HTML pages and serve those up instead of the CFML if no updates have occured since the

RE: [ cf-dev ] Performance

2003-10-22 Thread Simon Horwith
general rule of thumb is that caching queries will be MUCH faster. If the queries are dynamic, this can be more difficult to efficiently do, though. ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer

RE: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Stephen Pope
Hehe .. I did the same thing a while ago :¬) Btw I did notice I think 2 errors in the answers to the questions in Bens book .. not sure if there is an errata on his website .. but just to give you a heads up (although I cant remember exactly what they are off hand)! Stephen -Original

[ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread Stephen Pope
Lo all, Having some probs with a regexp wondered if anyone can help :¬) Heres the test .. CENTErbYay! You found it !/b/CENTEr cENTERIgnore me I'm the middle ground !/cENTER CENTERYay! You found the last One !/CENTER From this little example I want to return the top center tag and

Re: [ cf-dev ] Performance

2003-10-22 Thread Damian Watson
I would say that is potentially the optimum way of doing it -- no queries at all... If you have built the frontend of your site using well organised CSS this makes life lovely... basically when content is updated in the CMS you write an .htm (or whatever) file to the frontend which is named with

Re: [ cf-dev ] Performance

2003-10-22 Thread Tomo Smith
I found using a mixture of SP and cached queries was the daddy, although Matt's idea certainly has promise, and is something I've had a look at myself:) I also found that there's absolutely no point in caching things that run very rarely as you wont get any gains from that. It's also not a good

Re: [ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread duncan . cumming
what is this supposed to be finding: (.*?) 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

RE: [ cf-dev ] Performance

2003-10-22 Thread Paolo Piponi
We've got an enormous amount of dynamic content and because I was fed up with the time it takes to process I wrote a seperate process that, by the click of the button, updates all or a selected part of the dynamic content. What I actually did was dump loads of pages and each page had a series of

RE: [ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread Stephen Pope
.* = Anything between the first center tag ? = the fist occurance Got it from a perl book .. works for me hehe ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 10:49 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] RegEx Fun Fun Fun what is

RE: [ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread Stephen Pope
Oops typo fist = first -Original Message- From: Stephen Pope Sent: 22 October 2003 10:51 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] RegEx Fun Fun Fun .* = Anything between the first center tag ? = the fist occurance Got it from a perl book .. works for me hehe ! -Original

RE: [ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread Paolo Piponi
There might be a more elegant way, but I have this function: == function ReFindList(Document,SearchString) { var ComponentList=''; var thisPosition=1; var exitloop='false'; while (exitloop eq

Re: [ cf-dev ] Performance

2003-10-22 Thread Damian Watson
Yup about the caching... only 100 default. I seem to rememebr a useful thing in caching is to cache a query for a long period of time and when content is updated in your cfm to run that query on the frontend so that the query basically only ever operates when you make changes... is useful in some

RE: [ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread Stephen Pope
Ooh thanks for that .. *adds to code store* :¬) Think I just worked it out though .. .*center(.*?)/center .. that seems to be the puppy ! Apologies for my poor and very greedy regexp writing :¬) Stephen -Original Message- From: Paolo Piponi [mailto:[EMAIL PROTECTED] Sent: 22 October

RE: [ cf-dev ] Performance

2003-10-22 Thread Rich Wild
another alternative (and I'm only putting it forward as an alternative, cos I'm usually a publish to flat html kinda guy) is to add the queries into a shared scope (eg application) and then just read the application query as and when you need it, rather than doing another db hit. Course, this is

RE: [ cf-dev ] OT : Please wait button

2003-10-22 Thread Adam Reynolds
Here: script language=JavaScript !-- function submitForm() { document.haselect.xxx.value = Please Wait...; document.haselect.xxx.disabled = disabled; return true; } //-- /script FORM name=haselect action=index.cfm method=post onsubmit=submitForm(); INPUT name=xxx type=submit

Re: [ cf-dev ] Performance

2003-10-22 Thread Tomo Smith
one of the things we implemented, was when the admin was updated we changed one of the 'admin variables' so that the next hit on the front end of that page, would change the cache time out to 0, and therefore the page would update without the need for wait for a cache time out - this really needed

RE: [ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread Paolo Piponi
I think you'll be better with center[^]*/center unless you have tags within the center tag. Paolo -Original Message- From: Stephen Pope [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 10:58 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] RegEx Fun Fun Fun Ooh thanks for that ..

RE: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Adrian Lynch
Two errors? The book seems to be full of errors. It's also very much the same as the 4.5 version, not sure about 5 as I haven't read it, most of the sample questions are the same. Having said all that I'd still get the book as it has some good nuggets of info. I also have CFBuster, which I think

RE: [ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread Stephen Pope
Yeah .. it might have no tags or it might have a whole freak load of em .. hence the greedy regExp. Im scraping thousands of old HTML files of an old site for very quick rebranding .. horrid job :¬/ Thanks anyway :¬) -Original Message- From: Paolo Piponi [mailto:[EMAIL PROTECTED]

RE: [ cf-dev ] Performance

2003-10-22 Thread Robertson-Ravo, Neil (RX)
Well, as others have noted Caching a query is the daddy but if you want to ensure that code and pages are as up to date as humanly possible and also gain a speed advantage then go for SP's... We have been getting somewhere like 200% speed increase on some queries using SP's over the mutlitude

RE: [ cf-dev ] Performance

2003-10-22 Thread Rich Wild
though and I know from experience that CFSTOREDPROC has some issues with multiple resultsets coming back from CF so, as someone mentioned using exec may be a better path. I've never experienced problems with multiple recordsets and CFSTOREDPROC. You can't use exec and cfquery to run SPs that

Re: [ cf-dev ] Performance

2003-10-22 Thread Tomo Smith
yeah we only use cfstoredproc calls when it's imperative to get 2 or more result sets back, which poses a problem for caching, if you go down the exec route, you can still cache, and gain benefits from both systems... :) - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL

RE: [ cf-dev ] Performance

2003-10-22 Thread Robertson-Ravo, Neil (RX)
Truevery true The error with CFSTOREDPROC seems to be where your first resultset is bringing back a row with multiple TEXT Datatypes. -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 11:25 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ]

Re: [ cf-dev ] OT : Please wait button

2003-10-22 Thread Paul_Swingewood
Ok so this intrigued me . I have little experience with JS so I thought i'd have a play . Please forgive my ignorance but I need to be taught to suck eggs . ;-) SCRIPT Language=JavaScript function validate() { document.myForm.myButton.value='please wait';

RE: [ cf-dev ] Performance

2003-10-22 Thread Rich Wild
Truevery true The error with CFSTOREDPROC seems to be where your first resultset is bringing back a row with multiple TEXT Datatypes. Curious. I have several SPs that do this without problem. -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To

RE: [ cf-dev ] OT : Please wait button

2003-10-22 Thread Rich Wild
Paul, Javascript is case sensitive. You're calling your function as onsubmit=Validate(); but your function is actually called 'validate()' -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 11:32 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ]

RE: [ cf-dev ] Certified CFMX Developer Exam

2003-10-22 Thread Kola Oyedeji
According to others there are a few bugs in both EXAM buster and the book, http://www.talkingtree.com/blog/index.cfm?data=20031020#5A2BF2C5-45A6-28 44-75773C16B8EA60BC Check Ben's site for the Errata for his book Kola -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED]

RE: [ cf-dev ] Performance

2003-10-22 Thread Robertson-Ravo, Neil (RX)
Yepits a real bitch to confirm. (we have one which returns back around 10 resultsets). The actual SP is doing the usual...inner/outer joins...couple of other things... It fails on the large resultset...we strip that query out and put it in its own SP and it will work AOK!? Wierd...I

RE: [ cf-dev ] OT : Please wait button

2003-10-22 Thread Rich Wild
besides, your form is called 'search', whilst your submit button disabling function is calling 'myForm' and that script isn't validating anythign at all, its just disabling a button - I'd rename it to something like 'disableSearchButton()' to remove confusion. -Original Message- From:

Re: [ cf-dev ] Performance

2003-10-22 Thread Tomo Smith
Actually our problem is the same, but it's only when it hits about 2 records that this happens:) seriously so we swapped the output order within the SP, and the output within the cfstoredproc tag, and all was well... I'm sure the last time Neil brought this up, this was my response, and

RE: [ cf-dev ] Performance

2003-10-22 Thread Robertson-Ravo, Neil (RX)
It doesnt happen often and in fact its very sparse..but it still happens! -Original Message- From: Tomo Smith [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 11:35 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Performance Actually our problem is the same, but it's only when it hits

Re: [ cf-dev ] OT : Please wait button

2003-10-22 Thread Matt Horn
and the button needs a name too myButton - Original Message - From: Rich Wild [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 12:36 PM Subject: RE: [ cf-dev ] OT : Please wait button besides, your form is called 'search', whilst your submit button disabling

RE: [ cf-dev ] RegEx Fun Fun Fun

2003-10-22 Thread Paolo Piponi
Okay, you *might* have a problem. If not, then ignore this, but consider this email if the ReFindList brings back odd results: This updated function has a third optional parameter. This third parameter allows you to change all occurance of a single string with a single character. This helps

Re: [ cf-dev ] OT : Please wait button

2003-10-22 Thread Paul_Swingewood
Hmm ok thanks. Just thought i'd further my experience of egg sucking... Got it working now and it will be VERY useful for a few forms that I have where schools just like to click the button 387 million times Regards - Paul

[ cf-dev ] Auctions

2003-10-22 Thread Allan Cliff
Anyone know of any good auction software or something to fit into coldfusion? Have seen this one so far. http://www.silanta.com/products_enterprise.html

RE: [ cf-dev ] Auctions

2003-10-22 Thread Simon Horwith
a company called AllSoldOut has one I've used which is pretty good. (www.allsoldout.com) ~Simon Simon Horwith CTO, Etrilogy Ltd. Member of Team Macromedia Macromedia Certified Instructor Certified Advanced ColdFusion MX Developer Certified Flash MX Developer CFDJList - List Administrator

[ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Douglas Humphris
Hi folks, I'm having a nightmare today trying to get a verity search collection to return results. I haven't used them for quite a while. I've got a search collection (Reg_enq) which is built from a recordset. After running cfindex I get a collection of about 8Mb in size. When I try cfsearch on

Re: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Tomo Smith
you could try deleting the collection then recreating it, either programmatically or through cfadmin. Also it might be a good idea to purge this one first and see if that helps any... Another thing you could think of doing (only if you're using module recursion to get all the records from the

Re: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread duncan . cumming
what type of thing are you searching for? try searching for e*, which should give you some results. it sounds like the indexing is working if you've got a 8Mb collection, but Verity can be a bit funny about all this sometimes. you sure the value of #SearchCollection# and #Form.Collections#

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Douglas Humphris
Hi Tomo, Yeah I've tried re-creating the collections. I've also thought about the fake query thing but haven't tried it yet - don't really want to... Thanks, Douglas -Original Message- From: Tomo Smith [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 15:38 To: [EMAIL PROTECTED] Subject:

Re: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Tomo Smith
The fake query thing rocks... it'll reduce the time it take to index by loads and loads... the performance benefits are well worth it. - Original Message - From: Douglas Humphris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 22, 2003 3:57 PM Subject: RE: [ cf-dev ]

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Douglas Humphris
Duncan, I searched for e* and got a large resultset, but anything else I try yields nothing. Is e* shorthand for return everything? Yep, the values of SearchCollection and Form.Collections point to the same collection and I've hard coded the collection name in to make sure. I'm only indexing

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread duncan . cumming
e* means get everything that starts with e and has anything after it. e being the most common letter, it's usually a good way to get at least some results. so you can get results, just not the ones you want. try broadening your search, to perhaps the*, which should again give you some results

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Douglas Humphris
I've searched for the*, the, *the*, etc and get no results. I know that the appears in the recordset. I tried a windows search on the and got plenty of results. Scanning through the files in the collection, I can see that Verity seems to have successfully indexed the text. :( Doug -Original

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Douglas Humphris
Hey it's started yielding results! Most search criteria works now, but some words still won't return results (but I KNOW that they should!). At the moment I've established that the and bt don't return results but they both should. Everything else I'm trying is returning results now. I didn't

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread duncan . cumming
actually 'the' was maybe a bad example, as I suspect Verity might be stripping out common words like this, in the same way Google does. not sure why 'bt' wouldn't return results though - too short? if some results that should be coming up aren't, it's usually due to an error in the indexing.

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Duncan Fenton
Is there an option to suppress indexing 'common' words (like 'the'). And 'bt' almost never gives results :) (Sorry). Duncan Fenton -Original Message- From: Douglas Humphris [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 17:10 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] VERITY

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Adrian Lynch
I don't think it strips out words. Try searching on AND and OR, those are the buggers to watch out for. Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 17:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] VERITY PROBLEMS actually 'the' was

Re: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Tomo Smith
are you doing the mad recursion thing? if so the verity engine will have probably not finished indexing.. that's another reason why you should chuck as much info at it at once in one go rather than many ;) - Original Message - From: Douglas Humphris [EMAIL PROTECTED] To: [EMAIL

Re: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread duncan . cumming
oh yeah, always cflock any indexing and searching operations, forgot to mention that! 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

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Douglas Humphris
I'm not aware of any option to suppress common words. Believe me, in this case bt should return lots of results! Douglas -Original Message- From: Duncan Fenton [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 17:21 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] VERITY PROBLEMS Is there

RE: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Douglas Humphris
Hmm, true enough when I re-indexed it yesterday I left it running for over an hour it still hadn't finished. Today, however, it's been re-indexing fine. Tomorrow I'll purge the whole lot, put in some cflocks (hadn't thought of that) and start again. I'm not quite sure what the recursive indexing

Re: [ cf-dev ] VERITY PROBLEMS

2003-10-22 Thread Tomo Smith
recursive is only useful if you have a nasty child parent relationship sometime, you don't have the option of just running a select * on a table and hoping for the best:) - Original Message - From: Douglas Humphris [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 22,

RE: [ cf-dev ] Performance

2003-10-22 Thread Ellwood
Allan, Stored procedures don't improve speed that much unless you are doing multiple queries in one page. This is then a better example for using stored procs because of the lack of client server handshaking needed after each query. Cached queries however are much faster but beware that you

[ cf-dev ] CFAdmin: ODBC Service Not Running

2003-10-22 Thread Jolly Green Giant
I'm trying to create a datasource in my CF Admin that I just installed a few days ago. But I keep getting this error: The ColdFusion MX ODBC Server service is not running or has not been installed. But when I look in the Services console, that service is Started. Anybody got any ideas?

RE: [ cf-dev ] CFAdmin: ODBC Service Not Running

2003-10-22 Thread Ellwood
This is a very common misconception it seems. You will need to notify the administrator what your odbc is so he/she can then set it up. Perhaps the administrator should consider making the notice a bit clearer in future. Perhaps a note on the screen where you create the odbc that you still have to

RE: [ cf-dev ] CFAdmin: ODBC Service Not Running

2003-10-22 Thread Snake Hollywood
Actually I don't think he is referring to cfdeveloper, as he is specifying using the CFADMIN not HELM. Russ -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 22 October 2003 22:06 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFAdmin: ODBC Service Not Running

RE: [ cf-dev ] CFAdmin: ODBC Service Not Running

2003-10-22 Thread Jolly Green Giant
U. I am the administrator. :-) I'm the one in CF Admin trying to set up the ODBC. do you mean that I have to go into my computer's ODBC setup to make a connection first? If so, should I create a DSN under User or under System? I tried that and I still get the same error. __/

[ cf-dev ] cfchart problem - bar chart does not show

2003-10-22 Thread Stuart Welsh
Okay after checking this with the localhost server my bar chart displays perfectly well, but when I try the same page within my cfdeveloper.co.uk site the bar chart fails to appear. I tried the old depreciated cfgraph tag and the same problem occurs. What am I doing wrong here? cfchart