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

2003-10-27 Thread Jolly Green Giant
That was it! I just updated the MDAC and everything was fine! Thanks for the help! __/ Russ 'Snake' Michaels \__ Yes. You must install the latest MDAC. -Original Message- From: Jolly Green Giant [mailto:[EMAIL PROTECTED] Sent: 24 October 2003 16:53 To: [EMAIL PROTECT

RE: [ cf-dev ] Encoding strangeness in MX6.1

2003-10-27 Thread Lucas Sherwood
Hi Dave, I am guessing here, this sounds like on ei had a while back... For some strange reason ISO needs to be in uppercase... I hope this helps... L. -Original Message- From: Dave Phipps [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 14:43 To: ColdFusion User group Subject: [ cf

Re: [ cf-dev ] Macromedia CFMX Developer

2003-10-27 Thread Jolly Green Giant
Good for you!! Congrats! __/ Ellwood \__ Just to let you know, I passed. -- ** 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 PROTE

RE: [ cf-dev ] Macromedia CFMX Developer

2003-10-27 Thread Ellwood
Cf buster. -Original Message- From: Adams, Frank [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 17:10 To: '[EMAIL PROTECTED]' Congrats! What helped you most, ben forta book or cfbuster? if you dont mind... -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: Monday,

RE: [ cf-dev ] Macromedia CFMX Developer

2003-10-27 Thread Adrian Lynch
Well done :O) Ade -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 17:18 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Macromedia CFMX Developer Hi all, Just to let you know, I passed. Only 73%, not advanced I'm afraid but good enough for me. The main things

RE: [ cf-dev ] Macromedia CFMX Developer

2003-10-27 Thread Adams, Frank
Congrats! What helped you most, ben forta book or cfbuster? if you dont mind... -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:18 PM To: [EMAIL PROTECTED] Subject: [ cf-dev ] Macromedia CFMX Developer Hi all, Just to let you know, I passed. O

[ cf-dev ] Macromedia CFMX Developer

2003-10-27 Thread Ellwood
Hi all, Just to let you know, I passed. Only 73%, not advanced I'm afraid but good enough for me. The main things I remember are the application stuff being asked. Stupid things like argument.whatever Instead of arguments.whatever. My main problem was the client state management section and the fac

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Lovelock, Richard J
yes .. perfect sense and my understanding also ... thank you . i had debug on... the clearcache page showed the query was not being cached and had some time there (e.g. 160ms) - i.e. query not coming from cache then when I went back to run my 'proper page' (with timespan 5,0,0,0) the debug showed

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Aidan Whitehall
> yes I am using (1) - copied and pasted the queries in to a separate file and > changed the creatimespan from 5 to 0. > > so theoretically should be identical apart from the timespan - changing this > wouldn't prevent the query being cleared from cache would it - as this is > the whole point of t

RE: [ cf-dev ] Encoding strangeness in MX6.1

2003-10-27 Thread Dave Phipps
Hi, Thanks to all for the suggestions. I had to use a combo to fix it. We are on pre 4.1 I think due to it not being a fully stable release yet, or is it? Anyway the fix was this: Place the following in the index.cfm or Application.cfm: then in the advance properties of the ODBC datasource

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Kola Oyedeji
Richard >> -Original Message- >> From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] >> Sent: 27 October 2003 15:01 >> To: '[EMAIL PROTECTED]' >> Subject: RE: [ cf-dev ] Clearing cached queries >> >> I am presuming this flushes out the entires cache - given that it is a >> shared cache o

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Lovelock, Richard J
yes I am using (1) - copied and pasted the queries in to a separate file and changed the creatimespan from 5 to 0. so theoretically should be identical apart from the timespan - changing this wouldn't prevent the query being cleared from cache would it - as this is the whole point of the parameter

Re: [ cf-dev ] OT Javascript -Select boxes

2003-10-27 Thread Matt Horn
you are a saint : thanks - Original Message - From: "Robin Griffiths" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 5:04 PM Subject: Re: [ cf-dev ] OT Javascript -Select boxes document.myForm.selectBox.options[document.myForm.selectBox.options.length] = new

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Aidan Whitehall
> using a separate > page consisting of all the queries from my various pages Have you - copied and pasted the queries from the other templates into a single template and adjusted the cachedwithin attribute or - are you using a cfinclude or cfmodule file which includes or returns each query tha

RE: [ cf-dev ] OT Javascript -Select boxes

2003-10-27 Thread Paul Johnston
Just a text variable... function addListItem(listval) { ... listval ... } addListItem('listval1'); > -Original Message- > From: Matt Horn [mailto:[EMAIL PROTECTED] > Sent: 27 October 2003 15:02 > To: [EMAIL PROTECTED] > Subject: Re: [ cf-dev ] OT Javascript -Select boxes > > >

Re: [ cf-dev ] OT Javascript -Select boxes

2003-10-27 Thread Robin Griffiths
document.myForm.selectBox.options[document.myForm.selectBox.options.length] = new Option(optionText, optionValue, booleanDefaultSelected, booleanSelected); but don't ask me what defaultSelected means ;-) - Original Message - From: Matt Horn To: [EMAIL PROTECTED] Sent: Monday, O

Re: [ cf-dev ] OT Javascript -Select boxes

2003-10-27 Thread Matt Horn
erm can u show me what is in listval:? hanks - Original Message - From: "Paul Johnston" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 4:58 PM Subject: RE: [ cf-dev ] OT Javascript -Select boxes > Here's some code... > > ... Form name is "contentForm", sele

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Lovelock, Richard J
I am presuming this flushes out the entires cache - given that it is a shared cache on ISP may not be the best solution? (although ideal for what I want to do) ___ * Regards, Richard Lovelock Westminster City Council - Web Supp

Re: [ cf-dev ] OT Javascript -Select boxes

2003-10-27 Thread Matt Horn
Thanks - Original Message - From: "Paul Johnston" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 4:58 PM Subject: RE: [ cf-dev ] OT Javascript -Select boxes > Here's some code... > > ... Form name is "contentForm", select box name is "content". > > ---code-

RE: [ cf-dev ] OT Javascript -Select boxes

2003-10-27 Thread Paul Johnston
Here's some code... ... Form name is "contentForm", select box name is "content". ---code--- function addListItem(listval) { //document.contentForm.content.options a = document.contentForm.content.options.length; document.contentForm.content.options[a] = new Option(listva

RE: [ cf-dev ] Encoding strangeness in MX6.1

2003-10-27 Thread Paul Fennell
UTF-8 encoding is not supported by MySQL before version 4.1. Do you have cfmx admin access if so you can change the default charset encoding In the ColdFusion MX Administrator open the datasource properties for your MySql datasource, click on Advanced Properties, and put the following in the '

[ cf-dev ] OT Javascript -Select boxes

2003-10-27 Thread Matt Horn
Hi I need to repopulate selectboxes from a query in a hidden frame I can add to a selectbox but once I have removed the old entries I cant create new ones I cant seem to remember the new Options syntax anyone know it? thanks |\/| Matt Horn Web Applications Developer

RE: [ cf-dev ] Encoding strangeness in MX6.1

2003-10-27 Thread Tim Blair
> Where am I going wrong or what have I missed. The db is > MySQL 4 on Linux and the fields are varchar. Try adding useunicode=true in the "connection string" bit of the advanced settings for the datasource. Tim. --- RAWNET LTD - Internet,

RE: [ cf-dev ] Encoding strangeness in MX6.1

2003-10-27 Thread Kevin Faulkner
Try whacking "useUnicode=true&characterEncoding=ISO8859_1" without the quotes into the 'Append to all queries' on the advanced options of your ODBC in CF Admin, this worked a treat for me- I read as to what MX was doing differently, but can't dig up the URL -Original Message- From: Dav

RE: [ cf-dev ] Encoding strangeness in MX6.1

2003-10-27 Thread Stephen Pope
I had a similar problem .. and I spent ages and ages tearing my hair out trying to work out what it was .. all my £ signs were coming in as ? .. I set encoding, content type all that stuff .. it turned out that I needed a connection string in the CF administrator for the MySQL datasource that s

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Lovelock, Richard J
thanks Kola - will look in to that a bit more Aiden - I guess that is what I am doing in a way but just using a separate page consisting of all the queries from my various pages that I can run once to clear cache but it doesn't seem to be working the same way? :o/ ___

[ cf-dev ] Encoding strangeness in MX6.1

2003-10-27 Thread Dave Phipps
Hi, I know that MX is now Unicode and as such text is encoded as UTF-8 by default but can anyone explain this: I am using fusebox so all calls go via index.cfm. In my index.cfm I am using the following to change the encoding to iso8859-1 Then I have a query which grabs some text from the d

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Aidan Whitehall
Way I've done this is pretty simple: - create a template returns a query object and accepts a parameter for the timestamp - default the timestamp in that template to the length of time for which you want the query to be cached - in your customer-side code, call the page that returns the query a

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Lovelock, Richard J
i'm pretty certain it isn't the page ...although the way it is acting would suggest yes...but i don't think it is if i run the clearcache.cfm page with timespan(0,0,0,0) the results are fresh from db if i then run the proper page with identical SQL but timespan (5,0,0,0) it brings back cached res

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Kola Oyedeji
Ok Something to be aware of, your queries must be exactly the same, name, datasource, everything down to whitespace IIRC. If this is not the case cf will not recognize it as the same query. One alternative that we have found to work quite well is to use the undocumented (in CF5) tag You can se

Re: [ cf-dev ] OT : document.write an HTML comment

2003-10-27 Thread Matt Horn
well try it and see :P - Original Message - From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 4:03 PM Subject: RE: [ cf-dev ] OT : document.write an HTML comment > Erm, if its an HTML comment (client side)?, surely if can be cre

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread duncan . cumming
provided the query has the same name and all the same SQL, it should be the same regardless of which page you call it from. which is one of the uses of cached queries, for queries you repeat on lots of pages. you sure it's not the *page* that's cached? Duncan Cumming IT Manager http://www.ali

RE: [ cf-dev ] OT : document.write an HTML comment

2003-10-27 Thread Robertson-Ravo, Neil (RX)
Erm, if its an HTML comment (client side)?, surely if can be created? It may not be, I just need to check! -Original Message- From: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 14:03 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT : document.write an HTML comment I doubt

Re: [ cf-dev ] OT : document.write an HTML comment

2003-10-27 Thread duncan . cumming
some text '); //--> should work, provided the user has Javascript enabled in their browser. Duncan Cumming IT Manager http://www.alienationdesign.co.uk mailto:[EMAIL PROTECTED] Tel: 0141 575 9700 Fax: 0141 575 9600 Creative so

Re: [ cf-dev ] OT : document.write an HTML comment

2003-10-27 Thread Matt Horn
I doubt it as its clientside but the comment tag is parsed server side - Original Message - From: "Robertson-Ravo, Neil (RX)" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 3:57 PM Subject: [ cf-dev ] OT : document.write an HTML comment > Is it possible to

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Lovelock, Richard J
Ok i don't think i made myself clear enough... i'll break it down i have some pages with cached queries but when i update the DB my pages are not showing the new data because the results are cached. To get around this I have been editing all my createtimespan(5,0,0,0) to createtimespan(0,0,0

[ cf-dev ] OT : document.write an HTML comment

2003-10-27 Thread Robertson-Ravo, Neil (RX)
Is it possible to document.write an HTML comment around some HTML to stop it displaying front-end? -- ** 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: [EMAI

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Rich Wild
well, actually it won't - but it'll delete the cached version so that the next time the cacheable one (ie the one with a createtimespan(x,x,x,x) ) is run, it'll be re-cached. > -Original Message- > From: Rich Wild [mailto:[EMAIL PROTECTED] > Sent: 27 October 2003 13:50 > To: '[EMAIL PROTE

RE: [ cf-dev ] Clearing cached queries

2003-10-27 Thread Rich Wild
#createtimespan(0,0,0,0)# will refresh a query that is currently cached and has the same name and query statement. > -Original Message- > From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] > Sent: 27 October 2003 13:46 > To: 'cflist' > Subject: [ cf-dev ] Clearing cached queries > > >

[ cf-dev ] Clearing cached queries

2003-10-27 Thread Lovelock, Richard J
Does #CreateTimeSpan(0,0,0,0)# clear any identical cached versions of the query from the cache OR does it retreive the results fresh for this instance of the query but still leave the cached version in the cache - i.e. so if another page used the same query but with #CreateTimeSpan(5,0,0,0)# it wou

RE: [ cf-dev ] FW: Macromedia Certification

2003-10-27 Thread Stephen Pope
Good luck .. lemme know any tricky areas :¬) Stephen -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 11:44 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] FW: Macromedia Certification A mistake I have made very often. Thanks for the tip -Original Mess

RE: [ cf-dev ] FW: Macromedia Certification

2003-10-27 Thread Ellwood
A mistake I have made very often. Thanks for the tip -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 11:38 To: '[EMAIL PROTECTED]' Just remember one thing, read the question. Which is not as stupid as it sounds. -Original Message- From: Ellw

RE: [ cf-dev ] FW: Macromedia Certification

2003-10-27 Thread Adrian Lynch
Just remember one thing, read the question. Which is not as stupid as it sounds. -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 11:30 To: [EMAIL PROTECTED] Subject: [ cf-dev ] FW: Macromedia Certification _ From: Ellwood [mailto:[EMAIL PROTE

RE: [ cf-dev ] Dynamic javascript select box from function call

2003-10-27 Thread Dave Phipps
Thanks Russ, I finally manage to piece together something similar:
function addemail(journoid, jemail) {
oNewOption = new Option();
oNewOption.text = jemail;
oNewOption.value = journoid;
document.release2

[ cf-dev ] FW: Macromedia Certification

2003-10-27 Thread Ellwood
_ From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 11:29 To: '[EMAIL PROTECTED]' O!!! Exam in 3 hours. Need lots of toilet paper. Bens book feels almost part of me. As for CFMX buster, well, not at all sure about that one. Hopefully Bens book will see me right

RE: [ cf-dev ] cfinclude versus cf_

2003-10-27 Thread Peter Harrison
cf_tags also support detecting if they are the start or end tag. - Peter -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 09:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cfinclude versus cf_ Terry, There is a fairly fundamental difference

RE: [ cf-dev ] cfinclude versus cf_

2003-10-27 Thread Adrian Lynch
A the old "It's not for me it's for a mate" routine! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 11:12 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cfinclude versus cf_ Thanks to those we answered - it wasn't actually mine, but code tha

Re: [ cf-dev ] cfinclude versus cf_

2003-10-27 Thread Terry Riley
Thanks to those we answered - it wasn't actually mine, but code that I'm looking after for someone else :-) I hadn't thought of the searching (for genuine cf_ tags) but it makes sense. Perhaps the original coder had intended to go back and change these cf_ tags for the cfinclude? Cheers Terry

RE: [ cf-dev ] Select Menu > Back Button

2003-10-27 Thread Robertson-Ravo, Neil (RX)
Ignore that...just checked and they do ;-) -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 11:03 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Select Menu > Back Button Thanks guys...one thing...I am sure I cant use onLoad or inline J

RE: [ cf-dev ] Select Menu > Back Button

2003-10-27 Thread Robertson-Ravo, Neil (RX)
Thanks guys...one thing...I am sure I cant use onLoad or inline JS as when the browser back button is used they are not parsed...are they? I am having to trigger these via an Event (onClick)..the downside is that the menu appears and dissapears for a split second. -Original Message- Fr

Re: [ cf-dev ] Select Menu > Back Button

2003-10-27 Thread Stephen Moretti
Put a function at the very bottom of your HTML page (still inside though) that always runs. Use this function to check the form setting and disable the appropriate drop down. I use something similar to prepopulate a second drop down based on a value in the first select when you go into edit a

RE: [ cf-dev ] Select Menu > Back Button

2003-10-27 Thread Aidan Whitehall
> OK...I need clarifcation on this as I am not sure if its possible. Well, you've said the answer yourself -- you're using onChange to disable the menu. When the page is redisplayed, for that display, nothing has changed, so nothing's disabled. Run an onLoad event that checks to see if the se

RE: [ cf-dev ] Encrypting passwords

2003-10-27 Thread Stephen Pope
Is there an echo in here ? :¬P hehe [Sorry its sarcastic-Monday :¬)] -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 10:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Encrypting passwords CF function createUUID() Russ Michaels Macromedia/Allai

RE: [ cf-dev ] cfinclude versus cf_

2003-10-27 Thread Snake Hollywood
A CF_tag has more paths to search as it has to check I fthe tag is in current folder and then the custom tags folder, plus it has to check for any passed params. So a cfinclude should be faster overall. Russ Michaels Macromedia/Allaire Certified ColdFusion Developer CFDeveloper The free resource

RE: [ cf-dev ] Encrypting passwords

2003-10-27 Thread Snake Hollywood
CF function createUUID() Russ Michaels Macromedia/Allaire Certified ColdFusion Developer CFDeveloper The free resource and community for ColdFusion developer. http://www.cfdeveloper.co.uk Join the CFDeveloper discussion lists. To subscribe send an e-mail to [EMAIL PROTECTED] > -Original M

RE: [ cf-dev ] Dynamic javascript select box from function call

2003-10-27 Thread Snake Hollywood
OK here is what I would do. Don't have the ID list in the hidden form field, put it in an array. When the same ID is removed from the select list, remove it from the array (null it). Then add the list of ID's to the hidden field at the end when the form is submitted. //create array Var IDLIST =

[ cf-dev ] Select Menu > Back Button

2003-10-27 Thread Robertson-Ravo, Neil (RX)
OK...I need clarifcation on this as I am not sure if its possible. I have two Select menus, Continent & CountryWhen I select Coutinent : the country menu gets disabled as I do not want the user to select anything from their The same is true for the Countryif they select Country, th

Re: [ cf-dev ] cfinclude versus cf_

2003-10-27 Thread Stephen Moretti
Terry, There is a fairly fundamental difference between and / drags a page into the page that is currently being processed and processes it in-line with the rest of the code. Everything in the current page is available to your included page. / will load your page into separate memory space

RE: [ cf-dev ] cfinclude versus cf_

2003-10-27 Thread Kola Oyedeji
Terry If your pages are not custom tags then there really is no need to call them using the CF_ prefix. In fact this will actually incur a slight overhead as CF searches for the file for the custom tag. If all you are doing is including display pages then cfinclude is the way to go. HTH Kola >

[ cf-dev ] cfinclude versus cf_

2003-10-27 Thread Terry Riley
What's the consensus? Is it better (or faster) to use '' or '' in the middle of a display page? I've tried both ways, and don't seem to see any difference (on CF5) except when trying to validate using Studio's built-in validator. Sure, the second form is easier to type, but does it have an

RE: [ cf-dev ] Encrypting passwords

2003-10-27 Thread Stephen Pope
Yup .. CreateUUID() should do it :¬) Stephen -Original Message- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 27 October 2003 09:26 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Encrypting passwords UUID = Unique User ID ??

RE: [ cf-dev ] Encrypting passwords

2003-10-27 Thread Lovelock, Richard J
UUID = Unique User ID ?? ___ * Regards, Richard Lovelock Westminster City Council - Web Support Cap Gemini Ernst & Young Southbank 95 Wandsworth Road London SW8 2HG ( 0870 906 7482 __

[ cf-dev ] Dynamic javascript select box from function call

2003-10-27 Thread Dave Phipps
Hi, I have the following functions which when called via an href add the item to the list. The email appears in the text area and the id appears in a hidden field. The problem with this is that if the user deletes an email address from the text area the list of ids in the hidden field is inco