RE: [ cf-dev ] number of items in a list
It's not often CF suprises me, but this is one of them! -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 15:55 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] number of items in a list list.split(,) am I missing something, where did this come from? That's a since MX thing -- because all basic types in CF are treated (at least initially) as Java strings, you can use functions from the java.lang.String class [1], which includes a function to tokenise a string into an array given a certain token (in this case a comma). In this case, the split() method [2] can actually perform the split on more than a single character -- it takes a regular expression as the delimiter. It also acts differently as the CF list functions in that is *doesn't* ignore empty items. You can use other methods the String class to good effect too: I've used functions like charAt(), compareTo(), startsWith(), endsWith() and matches(). Ah the joys of CF sitting on top of Java... ;) Tim. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] number of items in a list
You've gone and done it now, worm, can, open... ... does a CF query map to a built in Java dataype or is there a Query class? Got any more exmaples? Got any code to help explore this new gold mine? The service factory was fun but this looks like it might be even better! (If anyone's reading this, I didn't just say that :OP) Ade -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 16:27 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] number of items in a list Do you know to what extent this new functionality is supported? I'd hate to start using Java methods directly on CF variables (I assume that's what you're doing) only to find that in some future version the code fails to run because of some modification MM make. Well, of course this behaviour is under the hood and unsupported stuff which you probably won't find in any offical CF docs, much in the same wasy as using the service factory methods. While we're on the subject, another good one I've found is the handy isLast() function that you can call on queries. Take, for example, you want to print a comma-delimited list of items in a particular query column (and before anyone says it, yes you can use valueList() -- this is just an exmaple!). You need to output a value, followed by a comma each time apart from the last value. In regular CF, you'd can either do your query, set up a counter, then loop through all the results, incrementing the counter and comparing it to myQuery.recordcount to see if you've got to the end. The slightly better way is to remove the counter and use myQuery.currentrow instead. Alternatively, you can ignore any comparison of values as in the previous two example, and simply do a boolean check on myQuery.isLast() which will return TRUE if the current row is the last. Hidden methods are great. :) It's up to you whether you choose to use these functions or not, which I guess in most cases will come down to if (when) CF7 comes out, it may break things, but are you likely to upgrade the machines you're hosting your already-written apps on? Tim. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] number of items in a list
http://www.cfdev.com/mx/undocumentation/ Not read it yet, but the introduction says it all -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 16:54 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] number of items in a list You've gone and done it now, worm, can, open... ... does a CF query map to a built in Java dataype or is there a Query class? Got any more exmaples? Got any code to help explore this new gold mine? The service factory was fun but this looks like it might be even better! (If anyone's reading this, I didn't just say that :OP) Ade -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] MX, CFPop, and QofQ
TO might be reserved, alias it and see if that helps. Ade -Original Message- From: Jolly Green Giant [mailto:[EMAIL PROTECTED] Sent: 23 September 2004 18:09 To: [EMAIL PROTECTED] Subject: [ cf-dev ] MX, CFPop, and QofQ I'm on MX and have run a CFPop command and am successfully checking the mailbox because I can dump the query var and see the message stuff. But then I want to do a query on that cfpop query object to sort the results. This query worked fine in CF 5... cfquery dbtype=query name=sortedheaders SELECT to, subject, messagenumber, from, uid, date, body FROM getmessages ORDER BY to, subject, messagenumber /cfquery But now it crashes in MX with the following error... Query Of Queries syntax error. Encountered to at line 0, column 0. Incorrect Select List, Incorrect select column Any ideas? . -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Yukon WAS: A new problem ???
But come oon, dynamic TOP(n), how cool is that!?! :OD How are you finding it so far? I'm not too impressed with the management studio so far, seems awfully slow on my machine. Have you found many uses for the new windowing/ranking functions? Maybe I'm missing the point, but how can I make use of ROW_NUMBER() and filter on it? Anyone else started to play with SS 2005 yet? Ade -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 09:28 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] A new problem ??? Yep, it also has a shed load more ;-) which is even jucier... -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 17:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] A new problem ??? Or since it's inline SQL, CreateUUID might work for any other DB. cfquery... SELECT TOP 5 * FROM table ORDER BY 'CreatUUID()' /cfquery Give it a try, it might work. Ade BTW, I have installed SQL Server 2005 Beta 2, got a bunch of new features. Now call me an idiot, but my favourite is dynamic TOP(n)! -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Yukon WAS: A new problem ???
How can you use ROW_NUMBER()? My first thought was something like this... SELECT *, ROW_NUMBER() OVER(ORDER BY TestID) AS RowNumber FROM tblTest WHERE RowNumber BETWEEN 10 AND 20 ORDER BY RowNumber ... but you can't have the alias in the WHERE clause. Am I missing the point? Ade -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 10:59 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? I have loved it so far...come a long way from Alphato be honest is the T-SQL additions / modifications which are proving to be fantastic. ROW_NUMBER is one of those holy grail (and nemesis) of RDBMS...some people require it etc and some people think its stupid.jeez Oracle has had these abilities for while now. The biggest addition has to be Reporting Services (now available for 2K also) and the integration of the CLR...which is huge for us. N -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Yukon WAS: A new problem ???
I'm not sure what you've answered there. I was hoping that the windowing functions would be available as filters to allow paging like behaviour. So in the past, or rather right now, to get something similar you could create a temp table with an identity column which would act as your row numbering. I thought that ROW_NUMBER() would mean an end to that. Maybe I'm still missing the point. do you regard your rows in a table as logical or simply insertions with no logical order? Both, depends how I'm feeling ;O) Ade -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 11:33 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? Well, imagine this...ROW_NUMBER is used in dynamic evaluation of resultsets in T-SQL...think of it like CF MOD paging in SQLit allows you amongst other things to bring back a set (or single) row based on its rank in the current resultset. Your example needs to be something like : SELECT ROW_NUMBER() OVER(ORDER BY FIELD1) AS rownum, FIELD1, FIELD2, .[...] FROM YOURTBLE ORDER BY FIELD1 Basically its gonna be a function you will or will not use, it all depends on one thing...do you regard your rows in a table as logical or simply insertions with no logical order? One N -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 11:15 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? How can you use ROW_NUMBER()? My first thought was something like this... SELECT *, ROW_NUMBER() OVER(ORDER BY TestID) AS RowNumber FROM tblTest WHERE RowNumber BETWEEN 10 AND 20 ORDER BY RowNumber .. but you can't have the alias in the WHERE clause. Am I missing the point? Ade -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 10:59 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? I have loved it so far...come a long way from Alphato be honest is the T-SQL additions / modifications which are proving to be fantastic. ROW_NUMBER is one of those holy grail (and nemesis) of RDBMS...some people require it etc and some people think its stupid.jeez Oracle has had these abilities for while now. The biggest addition has to be Reporting Services (now available for 2K also) and the integration of the CLR...which is huge for us. N -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Yukon WAS: A new problem ???
Right, but I was hoping for more... SELECT ROW_NUMBER() OVER(ORDER BY TestID) AS RowNumber FROM tblTest WHERE RowNumber BETWEEN 10 AND 20 ORDER BY RowNumber ... but you can't use alias' in the WHERE clause. Ade -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 12:36 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? ROW_NUMBER does just that. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 12:12 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? I'm not sure what you've answered there. I was hoping that the windowing functions would be available as filters to allow paging like behaviour. So in the past, or rather right now, to get something similar you could create a temp table with an identity column which would act as your row numbering. I thought that ROW_NUMBER() would mean an end to that. Maybe I'm still missing the point. do you regard your rows in a table as logical or simply insertions with no logical order? Both, depends how I'm feeling ;O) Ade -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Yukon WAS: A new problem ???
Do you mean a GUI for 2005? I have the new SQL Server Management Studio installed which came on the disk. I had a problem connecting to a named instance of 2005 on one machine with EM/QA. The guy at the seminar I went to used QA for his examples so it might be something I'm doing wrong. Release for 2005 is supposed to be about a year from now so I wouldn't start developing with it in mind just yet. It's cool to get a look at the new features though. VARCHAR(MAX) should come in handy with a 2GB limit. We won't have to use TEXT as much. Ade -Original Message- From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 09 September 2004 12:10 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Yukon WAS: A new problem ??? Anyone else started to play with SS 2005 yet? I tried SQL Server 2005 Express Edition Beta 2., you need .net framework ver 2 installed, didn't like the fact they have not released a gui tool yet so you need to install and play with vb and visual studio and it comes without other management tools, even found making a connection locally to northwind a problem, maybe I'm missing something:)butI figure I'm better off sticking to developer edition of SS 2000... Colm -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] A new problem ???
Or try... cfquery... SELECT TOP 5 * FROM table ORDER BY NEWID() /cfquery I think that will work on SS2k. Ade -Original Message- From: Paul Swingewood [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 17:03 To: [EMAIL PROTECTED] Subject: [ cf-dev ] A new problem ??? Can anyone help me with the logic for this one please ... I have a table which has n number of pics in it I want to select 5 random pics (making sure that none are the same) and then display them on the screen. I have this muddled up code so far cfquery name=GetPics datasource=#application.DSN# select * from tblindexpics order by ID desc /cfquery cfset piclist= cfloop index = LoopCount from = 1 to = 5 cfoutput query=GetPics cfset piclist=listappend(piclist,#id#) /cfoutput cfset picnumber=randrange(1,listlen(piclist)) cfset pictoget=listappend(listgetat(piclist,picnumber),#LoopCount#) /cfloop cfquery name=views datasource=#application.DSN# select * from tblindexpics where id = #(whatgoes her??)# /cfquery I've lost the plot completely and am confused as to what loop goes where, when why. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] A new problem ???
Or since it's inline SQL, CreateUUID might work for any other DB. cfquery... SELECT TOP 5 * FROM table ORDER BY 'CreatUUID()' /cfquery Give it a try, it might work. Ade BTW, I have installed SQL Server 2005 Beta 2, got a bunch of new features. Now call me an idiot, but my favourite is dynamic TOP(n)! -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 08 September 2004 17:33 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] A new problem ??? Or try... cfquery... SELECT TOP 5 * FROM table ORDER BY NEWID() /cfquery I think that will work on SS2k. Ade -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] CFFILE ....
I think you may have to write the image to disk before displaying it if you store it in the DB. Go on, store it in the file system, you know you want to! :OD Seriously though, it'll make life easier. Why do you think storing in the DB will be better? Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 06:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE hi Ade, Yes, that's the bit I'm stuck on. How to display the image now I've stored it as text. And yep, it's a dating site. Shameless plug: http://www.chicksNchaps.co.uk Thanks for your help, Jenny - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 11:08 PM Subject: RE: [ cf-dev ] CFFILE I think you might be making problems for yourself further down the line. But first thing I noticed is you have... img src=#binarydata# ... if src isn't a path to a file it won't work. cfcontent might be what you want but I'd still suggest storing them in the file system and store data about the images in the DB. I'm sure that's the general consensus on the list too. BTW, is this a dating site you're doing, dating\profiles\photos, just call me Miss Marple :OD Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 21 August 2004 22:44 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE yep, replying to self has to be as bad as talking to self .. cracking up ... got this far .. seems like the data has to go into an ntext type .. binary said truncated, and varbinary said wrong data type .. so as it's a string ... ? At the end is my feeble attempt to get the data out again ... arhh cffile action = readBinary file = \apache\apache2\dating\profiles\photos\thumbs\#thumbname# variable = thumb1 cffile action = readBinary file = \apache\apache2\dating\profiles\photos\thumbs\small\#thumbname# variable = thumb2 !-- convert to base 64 -- cfoutput cfset thumb1_64=tobase64(thumb1) cfset thumb2_64=tobase64(thumb2) /cfoutput cfoutput cfquery datasource=dating UPDATE Registered SET PhotoThumbB = '#thumb1_64#', PhotoThumbSmallB = '#thumb2_64#' WHERE Registered.RegisterID = #session.registerID# /cfquery /cfoutput cfquery name=Register2 datasource=dating SELECT * FROM dbo.Registered WHERE dbo.Registered.RegisterID = #session.registerID# /cfquery cfoutput cfset binaryData = toBinary(#register2.photothumbsmallB#) img src=#binarydata# /cfoutput -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] CFFILE ....
But how would you use it in an HTML page? -Original Message- From: Christopher Dawes [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 15:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFFILE You don't have to write it to file first. Use toBase64 and toBinary to get it in and out for display. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Sunday, 22 August 2004 8:30 PM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFFILE I think you may have to write the image to disk before displaying it if you store it in the DB. Go on, store it in the file system, you know you want to! :OD Seriously though, it'll make life easier. Why do you think storing in the DB will be better? Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 06:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE hi Ade, Yes, that's the bit I'm stuck on. How to display the image now I've stored it as text. And yep, it's a dating site. Shameless plug: http://www.chicksNchaps.co.uk Thanks for your help, Jenny - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 11:08 PM Subject: RE: [ cf-dev ] CFFILE I think you might be making problems for yourself further down the line. But first thing I noticed is you have... img src=#binarydata# ... if src isn't a path to a file it won't work. cfcontent might be what you want but I'd still suggest storing them in the file system and store data about the images in the DB. I'm sure that's the general consensus on the list too. BTW, is this a dating site you're doing, dating\profiles\photos, just call me Miss Marple :OD Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 21 August 2004 22:44 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE yep, replying to self has to be as bad as talking to self .. cracking up ... got this far .. seems like the data has to go into an ntext type .. binary said truncated, and varbinary said wrong data type .. so as it's a string ... ? At the end is my feeble attempt to get the data out again ... arhh cffile action = readBinary file = \apache\apache2\dating\profiles\photos\thumbs\#thumbname# variable = thumb1 cffile action = readBinary file = \apache\apache2\dating\profiles\photos\thumbs\small\#thumbname# variable = thumb2 !-- convert to base 64 -- cfoutput cfset thumb1_64=tobase64(thumb1) cfset thumb2_64=tobase64(thumb2) /cfoutput cfoutput cfquery datasource=dating UPDATE Registered SET PhotoThumbB = '#thumb1_64#', PhotoThumbSmallB = '#thumb2_64#' WHERE Registered.RegisterID = #session.registerID# /cfquery /cfoutput cfquery name=Register2 datasource=dating SELECT * FROM dbo.Registered WHERE dbo.Registered.RegisterID = #session.registerID# /cfquery cfoutput cfset binaryData = toBinary(#register2.photothumbsmallB#) img src=#binarydata# /cfoutput -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] CFFILE ....
Don't answer that :OP img src=image.cfm / Ade -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 17:13 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFFILE But how would you use it in an HTML page? -Original Message- From: Christopher Dawes [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 15:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFFILE You don't have to write it to file first. Use toBase64 and toBinary to get it in and out for display. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Sunday, 22 August 2004 8:30 PM To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] CFFILE I think you may have to write the image to disk before displaying it if you store it in the DB. Go on, store it in the file system, you know you want to! :OD Seriously though, it'll make life easier. Why do you think storing in the DB will be better? Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 22 August 2004 06:56 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE hi Ade, Yes, that's the bit I'm stuck on. How to display the image now I've stored it as text. And yep, it's a dating site. Shameless plug: http://www.chicksNchaps.co.uk Thanks for your help, Jenny - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 11:08 PM Subject: RE: [ cf-dev ] CFFILE I think you might be making problems for yourself further down the line. But first thing I noticed is you have... img src=#binarydata# ... if src isn't a path to a file it won't work. cfcontent might be what you want but I'd still suggest storing them in the file system and store data about the images in the DB. I'm sure that's the general consensus on the list too. BTW, is this a dating site you're doing, dating\profiles\photos, just call me Miss Marple :OD Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 21 August 2004 22:44 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE yep, replying to self has to be as bad as talking to self .. cracking up ... got this far .. seems like the data has to go into an ntext type .. binary said truncated, and varbinary said wrong data type .. so as it's a string ... ? At the end is my feeble attempt to get the data out again ... arhh cffile action = readBinary file = \apache\apache2\dating\profiles\photos\thumbs\#thumbname# variable = thumb1 cffile action = readBinary file = \apache\apache2\dating\profiles\photos\thumbs\small\#thumbname# variable = thumb2 !-- convert to base 64 -- cfoutput cfset thumb1_64=tobase64(thumb1) cfset thumb2_64=tobase64(thumb2) /cfoutput cfoutput cfquery datasource=dating UPDATE Registered SET PhotoThumbB = '#thumb1_64#', PhotoThumbSmallB = '#thumb2_64#' WHERE Registered.RegisterID = #session.registerID# /cfquery /cfoutput cfquery name=Register2 datasource=dating SELECT * FROM dbo.Registered WHERE dbo.Registered.RegisterID = #session.registerID# /cfquery cfoutput cfset binaryData = toBinary(#register2.photothumbsmallB#) img src=#binarydata# /cfoutput -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided
RE: [ cf-dev ] CFFILE ....
Don't store them directly in the DB, instead use cfdirectory to get them all and put their names in a table. cfdirectory action=list directory=#pathToImages# name=qDir cfloop query=qDir cfquery INSERT INTO . /cfquery /loop About as quick and easy as it gets I think... Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 21 August 2004 16:57 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE Ok, this is getting messy storing pics as files .. is there an easy way to store them in an ms sql 7 database please? Thanks, Jenny - Original Message - From: Jenny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 4:33 PM Subject: Re: [ cf-dev ] CFFILE Thanks Terry, I'd missed the fileexists function. Jenny - Original Message - From: Terry Riley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 12:24 PM Subject: Re: [ cf-dev ] CFFILE Sure. Something like this: cfif FileExists(#variables.x_file_name#) cffile action=DELETE file=#variables.x_file_name# /cfif Of course, you'll have to substitute your own file name for the variable. Cheers Terry - Original Message - Hi all, Is there a way to check for the existence of a file before doing a cffile delete, please? Thanks, Jen (have to get in plug for new web site .. http://www.chicksNchaps.co.uk) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.742 / Virus Database: 495 - Release Date: 19/08/2004 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] CFFILE ....
I think you might be making problems for yourself further down the line. But first thing I noticed is you have... img src=#binarydata# ... if src isn't a path to a file it won't work. cfcontent might be what you want but I'd still suggest storing them in the file system and store data about the images in the DB. I'm sure that's the general consensus on the list too. BTW, is this a dating site you're doing, dating\profiles\photos, just call me Miss Marple :OD Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 21 August 2004 22:44 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE yep, replying to self has to be as bad as talking to self .. cracking up ... got this far .. seems like the data has to go into an ntext type .. binary said truncated, and varbinary said wrong data type .. so as it's a string ... ? At the end is my feeble attempt to get the data out again ... arhh cffile action = readBinary file = \apache\apache2\dating\profiles\photos\thumbs\#thumbname# variable = thumb1 cffile action = readBinary file = \apache\apache2\dating\profiles\photos\thumbs\small\#thumbname# variable = thumb2 !-- convert to base 64 -- cfoutput cfset thumb1_64=tobase64(thumb1) cfset thumb2_64=tobase64(thumb2) /cfoutput cfoutput cfquery datasource=dating UPDATE Registered SET PhotoThumbB = '#thumb1_64#', PhotoThumbSmallB = '#thumb2_64#' WHERE Registered.RegisterID = #session.registerID# /cfquery /cfoutput cfquery name=Register2 datasource=dating SELECT * FROM dbo.Registered WHERE dbo.Registered.RegisterID = #session.registerID# /cfquery cfoutput cfset binaryData = toBinary(#register2.photothumbsmallB#) img src=#binarydata# /cfoutput - Original Message - From: Jenny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 9:45 PM Subject: Re: [ cf-dev ] CFFILE Hi Adrian, Thanks, but just too many files to manage in this way. I've been playing around with base 64 and am struggling. I get a photo uploaed, create thumbs, then need to store the thumbs. Hope the below makes some sense and someone can tell me what silly thing I am doing. cfoutput cfexecute name = c:\Program Files\ImageMagick-6.0.1-Q16\convert.exe arguments = -sample 200x200 c:\apache\apache2\dating\profiles\photos\#search_word[1]# c:\apache\apache2\dating\profiles\photos\thumbs\#thumbname#/cfexecute cfexecute name = c:\Program Files\ImageMagick-6.0.1-Q16\convert.exe arguments = -sample 125x125 c:\apache\apache2\dating\profiles\photos\#search_word[1]# c:\apache\apache2\dating\profiles\photos\thumbs\small\#thumbname#/cfexecu te /cfoutput cffile action = readBinary file = c:\apache\apache2\dating\profiles\photos\thumbs\#thumbname# variable = thumb1 cffile action = readBinary file = c:\apache\apache2\dating\profiles\photos\thumbs\small\#thumbname# variable = thumb2cfabort !-- convert to base 64 -- cfoutput cfset thumb1_64=tobase64(thumb1) cfset thumb2_64=tobase64(thumb2) /cfoutput cfoutput cfquery datasource=dating UPDATE Registered SET PhotoThumb = '#thumb1#', PhotoThumbSmall = '#thumb2#' WHERE Registered.RegisterID = #session.registerID# /cfquery /cfoutput - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 6:28 PM Subject: RE: [ cf-dev ] CFFILE Don't store them directly in the DB, instead use cfdirectory to get them all and put their names in a table. cfdirectory action=list directory=#pathToImages# name=qDir cfloop query=qDir cfquery INSERT INTO . /cfquery /loop About as quick and easy as it gets I think... Ade -Original Message- From: Jenny [mailto:[EMAIL PROTECTED] Sent: 21 August 2004 16:57 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] CFFILE Ok, this is getting messy storing pics as files .. is there an easy way to store them in an ms sql 7 database please? Thanks, Jenny - Original Message - From: Jenny [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 4:33 PM Subject: Re: [ cf-dev ] CFFILE Thanks Terry, I'd missed the fileexists function. Jenny - Original Message - From: Terry Riley [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, August 21, 2004 12:24 PM Subject: Re: [ cf-dev ] CFFILE Sure. Something like this: cfif FileExists(#variables.x_file_name#) cffile action=DELETE file=#variables.x_file_name# /cfif Of course, you'll have to substitute your own file name for the variable. Cheers Terry - Original Message - Hi all, Is there a way to check for the existence of a file before doing a cffile delete, please? Thanks, Jen (have to get in plug for new web site .. http://www.chicksNchaps.co.uk
RE: [ cf-dev ] Session Timeout weirdness!
First thing would be to check the max timeout in administrator. Ade -Original Message- From: Mike [mailto:[EMAIL PROTECTED] Sent: 20 August 2004 18:12 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Session Timeout weirdness! Evening all, I am getting some strange things going on with an application, the Application uses session variables throughout the site, all locked Correctly and has been working fine for the past year, only in the last day Or two has a problem come up where the session is timing out every 20 secs Instead of the 1hr 30 as set in the application.cfm. The application is on a shared server and not windows 2003 which has been an issue in the past. Has anyone come across this before? Cheers Mikey -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 20 August 2004 15:31 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Dynamic query name and CF5 Sir, you're a genius ;) Tom Smith wrote: have you tried evaluate(request.queryName .recordCount) should work... let me know if it doesn't! - Original Message - *From:* Damian Watson mailto:[EMAIL PROTECTED] *To:* [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] *Sent:* Friday, August 20, 2004 3:19 PM *Subject:* [ cf-dev ] Dynamic query name and CF5 Hi, Got a wee problem, I've a query name generated dynamically: name=selectDistinctMonths#loop.year# Later on there's a CFIF statement that needs the recordcount of this query. In CFMX I can do this: cfset request.queryName=selectDistinctMonths#loop.year# cfif evaluate(request.queryName).recordCount GT 0 ...but CF5 don't get it. Anyone got an answer? Thanks d -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] cfmx hosting
Have either yourself of John had any problems with them? This is a cool thread as I'm looking for cheapish hosting :O) Ade -Original Message- From: Sam Clement [mailto:[EMAIL PROTECTED] Sent: 17 August 2004 18:39 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] cfmx hosting I'd have to agree here. Hostmysite.com is an excellent hosting company with excellent support. -Original Message- From: John Beynon [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 17, 2004 11:46 AM To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] cfmx hosting sorry but that's complete crap. Hostmysite.com service is excellent whatever time of day you contact them, the time difference is irrevelant, as i originally stated, whatever time of day i have contacted them i've got a response within 20 minutes!!! Usually i email about 9am UK time which is 4am their time and i get a response. As for cheap hosts not providing sandboxes, rubbish! They provide sandboxing. I needed cfobject/createobject for CFC invocation so i emailed them and they set the sandbox up allowing me to use those tags. They have recently denied me the use of cfx_zip as it it doesn't adhere to sandbox rules and thus was insecure - they even contacted Ben Forta on my behalf to see if there was anything that can be done about it. hmm, where has BenF just moved his personal site too? Any guesses :) On Tue, 17 Aug 2004 16:32:03 +0100, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: there's your endorsement Russ to use in your Sales Marketing: I think CFMX hosting is the best solution to mine the clients needs. - Paul Swingewood, CF guru. ;-) Paul Swingewood [EMAIL PROTECTED]To: [EMAIL PROTECTED] tmail.com cc: Subject: RE: [ cf-dev ] cfmx hosting 17/08/2004 16:27 Please respond to dev oops didn't mean to start a hosting war. I suggested CFMX hosting to my client for all the reasons that Russ has just said. #1 that I can pick up the phone and speak to someone right now who understands what I am trying to do and who will help me achieve it. Wicked! I should point out that I am not paying for the hosting the client is. For me I think CFMX hosting is the best solution to mine the clients needs. Regards - Paul -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] RegEx strip attribute
cfset str = 'font face=Times New Roman, Serif size=2 style=whatever color=##FF' cfdump var=#REReplace(str, 'face=.*?', '', 'all')# Although I'm sure it could be made to deal with more cases. Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 12 August 2004 11:54 To: [EMAIL PROTECTED] Subject: [ cf-dev ] RegEx strip attribute using regex, how could I turn this: font face=Times New Roman, Serif size=2 style=whatever color= #FF into this: font size=2 style=whatever color=#FF i.e. remove just the face= attribute, but leave everything else the same? -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] How to parse emails
Access them with cfpop if you can. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-b14.htm#wp1101854 Ade -Original Message-From: Jenny [mailto:[EMAIL PROTECTED]Sent: 09 August 2004 10:59To: [EMAIL PROTECTED]Subject: [ cf-dev ] How to parse emails Hi all, Hope someone can help me I recieve daily emails into outlook express from a maillist that I wish to use as site content. Is there anyway I can read these messages into the database using CF ? Regards, Jennifer Gavin-WearManaging Director Fast Track On Line -Web Design and Developmenthttp://www.fasttrackonline.co.uk ---Outgoing mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.732 / Virus Database: 486 - Release Date: 31/07/2004
RE: [ cf-dev ] RegEx madness, do I need glasses?
How about... \[UK NARIC:(.*?)\] ... just guessing mind, I love these RegEx questions :OD Ade -Original Message- From: Mark Woods [mailto:[EMAIL PROTECTED] Sent: 09 August 2004 12:38 To: [EMAIL PROTECTED] Subject: [ cf-dev ] RegEx madness, do I need glasses? string like [Yrs:4] [UK NARIC:British Bachelor degree std ] I want to get British Bachelor degree std I have... REFind(\[UK[[:space:]]+NARIC\:([^\]]+)[[:space:]]*],qExisting.notes,1,true ) which doesn't match correctly Now, I don't see anything wrong with that, so while testing, I changed the source string to... Yrs:4 UK NARIC:British Bachelor degree std and the RegEx to... \UK[[:space:]]+NARIC\:([^\]+)[[:space:]]* and it works dandy So, WTF is wrong with this sub-expression: ([^\]]+) when this one works just fine: ([^\]+) Am I seeing a CF regex bug or is my vision just blurred?? Help! Mark (BTW, yeah, I know I can workaround this, but that ain't the point) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Exceptions
but quite often, it's because the spec changes so often in development, its just not worth using SPs until the damn thing settles down a bit. Amen :OD -Original Message- From: Alistair Davidson [mailto:[EMAIL PROTECTED] Sent: 09 August 2004 15:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Exceptions I agree, stored procedures are usually the best way to go, but as a general rule I develop using cfqueries and migrate them to SPs as and when required. There are many reasons for this (crazy security policies / dev leads who don't like using sp's as they like to see everything in one page / internal politics / etc etc etc.. general corporate crap, usually) but quite often, it's because the spec changes so often in development, its just not worth using SPs until the damn thing settles down a bit. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: Regex
What makes a vestal virgin different from your bog standard virgin? Do you find you get a cleaner more robust ritual with a vestal? -Original Message- From: Alistair Davidson [mailto:[EMAIL PROTECTED] Sent: 05 July 2004 15:49 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: Regex My cats are well pleased - there's chicken blood and feathers everywhere from the rituals it took for me to come up with my version of the pattern. I just skipped the chicken blood and went straight onto the naked dancing with vestal virgins. Much more fun ;) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: Regex
H, I don't like the sound of this Pontifex Maximus! -Original Message- From: Alistair Davidson [mailto:[EMAIL PROTECTED] Sent: 05 July 2004 16:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: Regex There's only six of 'em : http://en.wikipedia.org/wiki/Vestal_Virgin -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 05 July 2004 16:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: Regex What makes a vestal virgin different from your bog standard virgin? Do you find you get a cleaner more robust ritual with a vestal? -Original Message- From: Alistair Davidson [mailto:[EMAIL PROTECTED] Sent: 05 July 2004 15:49 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: Regex My cats are well pleased - there's chicken blood and feathers everywhere from the rituals it took for me to come up with my version of the pattern. I just skipped the chicken blood and went straight onto the naked dancing with vestal virgins. Much more fun ;) -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: IIS file permissions on wmv files
Not an answer, but I can't view thewmv file, I get a page cannot be displayed message. I can see the jpg ok. Although I suspect this post was a chance for you to show off your mini big foot! :OD Ade -Original Message-From: Giles Roadnight [mailto:[EMAIL PROTECTED]Sent: 26 June 2004 09:31To: [EMAIL PROTECTED]Subject: [ cf-dev ] OT: IIS file permissions on wmv files The following URL can be opened fine: http://rc.giles.roadnight.name/images/uploaded/gallery/PICT0001.JPG this url however requires a password in both a browser and download software: http://rc.giles.roadnight.name/images/uploaded/gallery/wheelies_strath.wmv They are obviously both in the same directory, I have looked at them and they both have the same settings so why does one need a password and the other one doesnt? I thought it may be to do with the wmv streaming so I tried it in getRight and got the same result. Hope someone can help. Sorry for the OT post. Giles Roadnight http://giles.roadnight.name
RE: [ cf-dev ] OT: JS Regex
I'll have a pop... ^(F|K)[0-9]{4}(-[0-9]{1,2})?$ ... any good? Ade :OD -Original Message- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 23 June 2004 13:14 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] OT: JS Regex Mark Woods wrote: == For my sins - I have the following expressions that I need to compare a string against in javascript. [F|K]([0-9]{4}) = F1234 or K1234 try ^(F|K)[0-9]{4}$ Thanks for that Mark! Worked like a charm, however, I need to make an amendment to the above expression. I need to make this have an optional 3 characters on the end in the form -99. In other words I need to write an expression that will match F1234, F1234-, F1234-5 and F1234-56 At this point I'm all regex'd out. Any help would be appreciated. Regards Stephen -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] last nights CFUG
What was the attendence like anyone that went? There was some sort of football game on last night, haven't a clue who was playing :OD Ade -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED] Sent: 18 June 2004 08:40 To: UK DevList Subject: [ cf-dev ] last nights CFUG Hope the meeting went well? Sorry I couldn't make it - I'm flying out today for a conference and had to pack, etc. ~Simon -- Simon Horwith CTO, eTRILOGY ltd. Member of Team Macromedia Macromedia Certified Master Instructor http://www.cfstandards.org -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Looping through a list
To follow on from Tim, on the action page, check for FORM.test and delete them without a loop cfif IsDefined(FORM.test) DELETE FROM table WHERE ID IN (#FORM.test#) /cfif Howsat? Ade -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 17 June 2004 16:19 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Looping through a list Afternoon, This isn't going down the route you've already started on, but I find this approach cleaner... If you name all your checkboxs the same thing, CF automagically converts the selected IDs to a list. E.g. if you use the following, select the first 2 checkboxes and submit it, you'll end up with a url.test = 1,2: cfdump var=#url# form input type=checkbox name=test value=1 input type=checkbox name=test value=2 input type=checkbox name=test value=3 input type=submit /form HTH, Tim. -- --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- 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. --- -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] OT: JavaScript createUuid() ?
You could keep a number that gets incremented for every new form element you create. i = 0; newName = something_ + i; i++; Ade -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED] Sent: 15 June 2004 15:04 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: JavaScript createUuid() ? Why don't you dump a CreateUUID from coldfusion into a script? I'm generating form elements on the fly on a page in JS, and I figured the easiest way to find a unique name for each form field that's added is to use a native JavaScript createUuid() or createGuid() function. Thing is, I've searched high and low and can't find one and am finding it hard to believe that it's neither something in core JS or that no-ones every needed to do the same thing. And please excuse me if I refrain from justifying future requests. -- Aidan Whitehall [EMAIL PROTECTED] Macromedia ColdFusion Developer Fairbanks Environmental +44 (0)1695 51775 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 -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] SoEditor and XHTML validation
If you have the right licence and access to the code, could you not change the source so it outputs lowercase? I'm assuming there's no option availbale in the tag though. Ade -Original Message-From: Damian Watson [mailto:[EMAIL PROTECTED]Sent: 10 June 2004 12:21To: [EMAIL PROTECTED]Subject: [ cf-dev ] SoEditor and XHTML validation Hi all, anyone know if SoEditor can output its html in lowercase so that it validates for XHTML?? If not then has anyone got anything handy to convert html tags into lcase?
RE: [ cf-dev ] SQL question
Limit the join to only the first image ID, can't think how best to do this but MIN(I.ImageID) somewhere might help. Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 28 May 2004 14:39 To: [EMAIL PROTECTED] Subject: [ cf-dev ] SQL question Got two tables Properties and Images, in a one-to-many relationship: one property can have many images. I want to pick one property at random, and display the first image belonging to that property, but can't figure out how to do this. It's easy enough to just display any image at random: cfquery name=getImages datasource=dsn SELECT Imagename FROM Images I, Properties P WHERE I.PropertiesId = P.ID /cfquery cfset random = RandRange(1,getImages.RecordCount) cfoutputimg src=images/#getImags.Imagename[random]#/cfoutput However, how to limit it to just the first image for any random property, eg: Property A Image A1, Image A2, Image A3 Property B Image B1 Property C Image C1, Image C2, Image C3, Image C4 I want to display either A1, B1 or C1 at random any ideas? So far I'm trying combinations of grouping the output on the propertyID, and picking a random startrow, but not managing to get it doing what I want. -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Argghghhghghgg!!
Set the action of the form to the same page, then when you want to submit to a different page, change the action. As someone has said, formName.action is the attriubute you want to change. form name=theForm action=form.cfm method=post select name=theSelect onchange=document.theForm.submit(); option value=11/option option value=22/option option value=33/option option value=44/option /select input type=button value=Search onClick=document.theForm.action='anotherpage.cfm'; document.theForm.submit(); /form This seems to work unless I'm missing something. Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 27 May 2004 09:15 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Argghghhghghgg!! Hello again all. Duncan. I have just tried that Javascript thingy you posted but it still posts back to the original form ... :( Sorry to be a pain about this but I javascript really leaves me cold with its this.that.theother stuff and I really appreciate the help. The form should do this ... User selects a menu type (form post back to itself) User selects a relative Phase (form post back to itself) User selects a relative Group User clicks the Search button Form variables now passed to modrep_results.cfm This is what I have ... table border=0 width=100% cellspacing=4 cellpadding=6 form name=DropDown method=post cfquery name=get_Menu datasource=webuserDSN SELECT menu_id, menu_name FROM menus /cfquery !--- Select Menu Type--- tr td colspan=3 valign=top align=left font face=arial, Arial, Helvetica font size=2 font color=#80bPlease select which menu the report to modify is under./bbr /font font face=arial, Arial, Helvetica font size=2 This is the menu from the default screen on the performance website. p cfoutput select name=selected_menu required=yes onchange=this.form.submit() option value=Select Menu/option cfloop query=get_Menu option value=#menu_id# cfif isDefined('form.selected_menu')cfif form.selected_menu eq #menu_id#selected/cfif/cfif#menu_name#/option /cfloop /select /cfoutput /font /td /tr !--- Select Phase Type--- cfif isDefined('page.selected_menu') !--- query DB for second drop down list, based on the selected item from the first list --- cfquery name=get_phase datasource=webuserDSN SELECT DISTINCT phases.phase_id, phases.phase, details.menu_group FROM details INNER JOIN phases ON details.phase_id = phases.phase_id WHERE menu_group = #page.selected_Menu# /cfquery tr td colspan=3 valign=top align=left font face=arial, Arial, Helvetica font size=2 font color=#80bPlease select the Phase which the report relates to./b /font p cfoutput select name=selected_Phase required=yes onchange=this.form.submit() option value=Select Phase/option cfloop query=get_Phase option value=#phase_id# cfif isDefined('form.selected_phase')cfif form.selected_phase eq #phase_id#selected/cfif/cfif#phase#/option /cfloop /select /cfoutput /font /td /tr /cfif !--- Select Group Type--- cfif isDefined('page.selected_phase') cfquery name=get_group datasource=webuserDSN SELECT DISTINCT details.menu_group, report_groups.report_group, report_groups.group_id, details.phase_id FROM details INNER JOIN report_groups ON details.group_id = report_groups.group_id WHERE (details.menu_group = #page.selected_Menu# ) AND (details.phase_id = #page.selected_phase#) ORDER BY report_groups.report_group ASC /cfquery tr td
RE: [ cf-dev ] Regex to capitalise first letter of every word in a sentence.
http://www.cflib.org/udf.cfm?ID=889 I have one that's faster somewhere but cflib didn't put it up for some reason, see what you think of that one though, cfscript based. Ade -Original Message- From: Stephen Moretti [mailto:[EMAIL PROTECTED] Sent: 27 May 2004 12:13 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Regex to capitalise first letter of every word in a sentence. Has anyone got a wee bit of regex that'll allow me lower case a sentence and then upper case the first letter of each word in the sentence please? Regards Stephen -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Please Wait ....
Depending on the page layout, could you not use cfflush? Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 21 May 2004 14:32 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Please Wait Can anyone point me in the direction of a good please wait script? My cfcontent download pages sometimes fetch excel documents that are 3mb+ in size (I have no control over the docs before you say anything) These documents open in a new window and of course it appears blank until the document appears. It would be nice to have a Oi you! stop hitting that refresh button and wait a min whilst I download your huge excel file (Please Wait...) appear whilst this is happening. Regards - Paul * The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. * -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] why the hell doesn't this work?
"Just a guess! Someone cleverer set me straight." Well ok then, since you asked ;O) Damian's right, you can't use conditional logic in this way. As far as the parser is concerned, you have two opening cfoutputs and one closing. Someone clevererer might set me straight though! Ade, high on night nurse :OD -Original Message-From: Damian Watson [mailto:[EMAIL PROTECTED]Sent: 20 April 2004 17:42To: [EMAIL PROTECTED]Subject: RE: [ cf-dev ] why the hell doesn't this work? Because when it goes through the page it looks for correct syntax before it calculates the code to execute?? so youve got two query tags before a close query tag hence an error Just a guess! Someone cleverer set me straight. -Original Message-From: Ian Westbrook (FDM) [mailto:[EMAIL PROTECTED] Sent: 20 April 2004 14:12To: CFUG ListSubject: [ cf-dev ] why the hell doesn't this work? anyone any idea why this doesn't work? cfif IsDefined("form.search")cfoutput query="allbooks"cfelsecfoutput query="allbooks" STARTROW="#the_start#" MAXROWS="#records_to_display#"/cfif I keep getting the 'extraneous /cfoutput tag' error from the output's close. All I'm doing is choosing one of the output tags depending on whether a form variable exists or not. If I use either of the output tags straight off, it works fine. any ideas? Ian W
RE: [ cf-dev ] coldfusion.org.uk and GoogleBomb!
Would it be an idea to make it a book section in general, CF SQL, HTML etc? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: 20 April 2004 12:01To: [EMAIL PROTECTED]Subject: Re: [ cf-dev ] coldfusion.org.uk and GoogleBomb!suggestion: add a CF Books section, possibly with the ability to add a review. if you setup with an Amazon account you could make commission of any sales these would generate... also: "PJ Net Solutions Regular Expressions Tutorial Goes through from simple to complex Regular Expressions using ColdFusion (link submitted by: Paul Johnston) " - Shouldn't that say goes from simple to, er, simple?! ;-) been waiting since 2002 for the medium and complex bits to be completed on this tutorial... Paul Johnston [EMAIL PROTECTED] 20/04/2004 11:27 Please respond to dev To: [EMAIL PROTECTED] cc: Subject:[ cf-dev ] coldfusion.org.uk and GoogleBomb!The portal is coming along nicely now! I still need people to give me more info to put up there! Any links/help appreciated!Another thought... anyone want CMS to be another category? If so, please recomment the ones you think should go up there!Also, there is a googlebomb idea I've had... go to the site and see!Paul-- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/CFDeveloper Sponsors and contributors:-*Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com*To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] search problems
Hi Sanj, as well as the other replies you've had you might want to try going back to basics with things. If you find that you're not comfortable with the queries then just have a go at testing them on their own. Forget about the form and just hardcode values in. You'll be suprised at how fast you'll pick up the basics with ColdFusion :O) Ade -Original Message- From: sanjay sidar [mailto:[EMAIL PROTECTED] Sent: 06 April 2004 19:11 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] search problems Hey guys i have this code that is supposed to search for data in my access db. Now i have created a form in which the search is avaliable, (called form2.cfm) the way you search on this form is by a drop-down option ie choose a county, and you can select a country from the dropdown list. I have created an action page called search.cfm, (which is below), now there is info in my database, but when i try to search for it nothing comes up, and another thing im confused about is that if say the user tired to search for a person's name which does exisit in my db, how do i display that? as you may have guessed im very new to this language, so any help would be much appreciated:-) sanjay, p.s the code for the action page(search.cfm is below) body cfquery name=rsSearch datasource=sanjay_1 SELECT employee_name, company_name, country, region, position,department, section, random FROM tblAdmins WHERE 1 = 1 CFIF isDefined(form.employee_name) and form.employee_name neq AND employee_name = '#form.employee_name#' CFIF isDefined(form.company_name) and form.company_name neq AND company_name = '#form.company_name#' CFIF isDefined(form.country) and form.country neq AND country = '#form.country#' /CFIF CFIF isDefined(form.region ) and form.region neq AND region = '#form.region #' /CFIF CFIF isDefined(form.section ) and form.section neq AND section = '#form.section #' /CFIF CFIF isDefined(form.position) and form.position neq AND position = '#form.position#' /CFIF CFIF isDefined(form.department ) and form.department neq AND department = '#form.department #' /CFIF /cfquery /body _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] search problems
To help with what you're after, try the following as a starting point... search.cfm cfif IsDefined(FORM.submit) cfquery name=qSearch SELECT . WHERE Something LIKE '%#FORM.somethingElse#%' /cfquery cfif qSearch.RecordCount cfoutput query=qSearch #qSearch.someField# /cfoutput cfelse No results matey! /cfif /cfif form acteion=search.cfm method=post input / input typ=submit... / /form Rather simplified but it does what you're after. How long have you been using ColdFusion? How are you finding it so far? Ade -Original Message- From: sanjay sidar [mailto:[EMAIL PROTECTED] Sent: 06 April 2004 23:03 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] search problems thanks agin, but if i wanted to show the search results in another page how would i do that, and what if there is nothing in my database could i have some sort of a sign saying there are no items that match your search?? From: Damian Watson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] search problems Date: Tue, 6 Apr 2004 22:48:59 +0100 Sanjay, When you do a SELECT query (when you say search you mean SELECT) you are asking the database for records. This you have done. However, you haven't asked the coldfusion template to display those records. This is done using the cfoutput tag so you should read about that. For instance, after your query in your search.cfm if you were to put: cfoutput query=rsSearch #employee_name# /cfquery You would receive results supplying all the employee names. There is another way to check if you have results of your query, this is to use cfdump which I have showed you before. In this case you would use: cfdump var=#rsSearch# This will output on the page any data resulting from your query called rsSearch. Note that cfoutput is the tag you need to learn to use when you are wanting to display data to a user. HTH d -Original Message- From: sanjay sidar [mailto:[EMAIL PROTECTED] Sent: 06 April 2004 19:11 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] search problems Hey guys i have this code that is supposed to search for data in my access db. Now i have created a form in which the search is avaliable, (called form2.cfm) the way you search on this form is by a drop-down option ie choose a county, and you can select a country from the dropdown list. I have created an action page called search.cfm, (which is below), now there is info in my database, but when i try to search for it nothing comes up, and another thing im confused about is that if say the user tired to search for a person's name which does exisit in my db, how do i display that? as you may have guessed im very new to this language, so any help would be much appreciated:-) sanjay, p.s the code for the action page(search.cfm is below) body cfquery name=rsSearch datasource=sanjay_1 SELECT employee_name, company_name, country, region, position,department, section, random FROM tblAdmins WHERE 1 = 1 CFIF isDefined(form.employee_name) and form.employee_name neq AND employee_name = '#form.employee_name#' CFIF isDefined(form.company_name) and form.company_name neq AND company_name = '#form.company_name#' CFIF isDefined(form.country) and form.country neq AND country = '#form.country#' /CFIF CFIF isDefined(form.region ) and form.region neq AND region = '#form.region #' /CFIF CFIF isDefined(form.section ) and form.section neq AND section = '#form.section #' /CFIF CFIF isDefined(form.position) and form.position neq AND position = '#form.position#' /CFIF CFIF isDefined(form.department ) and form.department neq AND department = '#form.department #' /CFIF /cfquery /body _ Express yourself with cool emoticons - download MSN Messenger today! http://www.msn.co.uk/messenger -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and
RE: [ cf-dev ] Flex
Title: Message lol, that was a good one :OP of course I didn't fall for it ;O) BTW, been messing with Flex the last few days and I love it. Having more trouble with JRun than Flex, notsureif that says more about Flex, JRun or me! One thing I found I didn't want to do with Flash/ActionScript was the fidgety code to get all the nice touches to work. Flex seems to have a lot of these. Just need an excuse to use it now. I think the price will make it out of reach of most companies. If anyone hears of a hosting company with a Flex package could you post to the list. Might be too early at the moment but I'm not sure how quick hosting co's react to new software like this, especially with that price. Russ, are you planning to put it on cfdeveloper? Would you still need to buy the full license considering it's a developer platform of sorts! lol Ade -Original Message-From: Colm Brazel [mailto:[EMAIL PROTECTED]Sent: 01 April 2004 10:23To: [EMAIL PROTECTED]Subject: RE: [ cf-dev ] Flex Apparently;-)Flex will be included as part of Blackstone the relacement for MX, if you want to look at the code some disgruntled person has gone and released thecode for it;) http://www.mossyblog.com/index.cfm?entryID=240 -Original Message-From: Snake Hollywood [mailto:[EMAIL PROTECTED]Sent: 31 March 2004 18:30To: [EMAIL PROTECTED]Subject: RE: [ cf-dev ] Flex not even looked at it yet, but it looks like flash for coders? -Original Message-From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 30 March 2004 15:07To: [EMAIL PROTECTED]Subject: RE: [ cf-dev ] Flex Right. Back up and running but only on single IP developer version, which is fine for now. Flex has been completely removed and I had to re-install coldfusion MX 6.1 as a NEW INSTALL not an update. Bit weird now though as I am used to pointing my sites to localhost:8500 whereas now its just localhost. Plus inetmgr is now working also so I guess my original install must have had faults that Flex tried to fix but screwed up. A lesson learnt Ellis C Wood BSc Ellwood Web Solutions T: 01623 459973 E: [EMAIL PROTECTED] W: http://www.ellwoodwebsolutions.co.uk -Original Message-From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 30 March 2004 14:37To: [EMAIL PROTECTED]Subject: RE: [ cf-dev ] Flex Yep, I think the beta is now over. there was lots of info on it on the beta site though http://mmbeta.macromedia.com/l -Original Message-From: Adrian Lynch [mailto:[EMAIL PROTECTED]Sent: 30 March 2004 14:08To: '[EMAIL PROTECTED]'Subject: RE: [ cf-dev ] Flex Don't think. They're made it availableon thebeta site but they said it won't be there for long. Think it's just the CD for now. Ade -Original Message-From: Justin MacCarthy [mailto:[EMAIL PROTECTED]Sent: 30 March 2004 14:03To: [EMAIL PROTECTED]Subject: RE: [ cf-dev ] Flex FLEX available online at all??? just cd? -Original Message-From: Ellwood [mailto:[EMAIL PROTECTED]Sent: 30 March 2004 13:51To: [EMAIL PROTECTED]Subject: RE: [ cf-dev ] Flex Nah, I just did the bog standard all setting default install Ellis C Wood BSc Ellwood Web Solutions T: 01623 459973 E: [EMAIL PROTECTED] W: http://www.ellwoodwebsolutions.co.uk -Original Message-From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 30 March 2004 13:53To: '[EMAIL PROTECTED]'Subject: RE: [ cf-dev ] Flex Did you put Flex onto an existing JRun installation? Not sure about the current release but there was an option to install a bundled JRun/Flex in the beta. Could you have done that by mistake? Clutching at straws with this but thought I'd chime in. BTW, I've only had Flex on the go for a few days and I think it is great. Seems a bit pricey though. Anyone else out there planning on investing time in leaning it too? Might have to take a trip over to chattyfig and see if there's a list there :O) Ade
RE: [ cf-dev ] Flex
Did you put Flex onto an existing JRun installation? Not sure about the current release but there was an option to install a bundled JRun/Flex in the beta. Could you have done that by mistake? Clutching at straws with this but thought I'd chime in. BTW, I've only had Flex on the go for a few days and I think it is great. Seems a bit pricey though. Anyone else out there planning on investing time in leaning it too? Might have to take a trip over to chattyfig and see if there's a list there :O) Ade -Original Message-From: Ellwood [mailto:[EMAIL PROTECTED]Sent: 30 March 2004 13:43To: [EMAIL PROTECTED]Subject: [ cf-dev ] Flex Guys, Installed Flex this morning and seemed to work okay but now my CFMX installation wont work. I have removed the Flex programme but still wont work. Just gets a load of JRUN ERRORS. Anybody got any ideas. I have reinstalled CFMX once but still no joy. I am in the process of downloading the JRun updater to see if that will fix anything Ellis C Wood BSc Ellwood Web Solutions T: 01623 459973 E: [EMAIL PROTECTED] W: http://www.ellwoodwebsolutions.co.uk
RE: [ cf-dev ] File permission(?) error
Then won't the CF user need permission to delete the file? I've come across a problem with WinSCP messing with file permissions before, any chance you're using that? Ade -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 16 March 2004 09:48 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] File permission(?) error I've got OVERWRITE in there.. basically a file is being uploaded then rename... -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 16 March 2004 07:45 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] File permission(?) error I know it may be a silly question but often the most obvious is what is overlooked. Does the file already exists and have you told CFFILE to MAKEUNIQUE on the file name? Regards Ellis C Wood BSc Ellwood Web Solutions T: 01623 459973 E: [EMAIL PROTECTED] W: http://www.ellwoodwebsolutions.co.uk -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 16 March 2004 00:18 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] File permission(?) error What sort of behaviour have you got for when the file already exists? Ade -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 20:46 To: [EMAIL PROTECTED] Subject: [ cf-dev ] File permission(?) error Hi, Anyone know what would be causing this error, I can't replicate it with my own files? Permissions have been set properly for the destination directory as far as I'm aware: --- Error attempting to save uploaded file to path 'D:\data\0185rai\docs\assessmentFiles\riaFile_24.pdf.' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (61:2) to (61:134) in the template file D:\DATA\0185RAI\DOCS\HTMFILES\ACT_ASSESSMENTFILEGENERATOR.CFM. --- Not much to go on I know! d -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Regular Expression = CF Studio Search
Has CF Studio always allowed you to use regex in the Find/Replace function? Ade -Original Message- From: Tom Smith [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 13:17 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Regular Expression = CF Studio Search best I could do at short notice was this: cfstoredproc procedure=\[^\]*\ which isn't exactly what you want, but it will return all the names in the results window:) - Original Message - From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 15, 2004 1:05 PM Subject: [ cf-dev ] Regular Expression = CF Studio Search Anyone got a RegEx to use in CFStudio Extended Find system which will allow me to get the contents of every cfstoredproc tag? i.e. cfstoredproc procedure=I WANT THIS BIT Ta N This e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] The fat old Maltby birthday piss up extravaganza....
Or for those on dial up... http://www.adrianlynch.co.uk/rock/index2.cfm -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 16:08 To: [EMAIL PROTECTED] Subject: [ cf-dev ] The fat old Maltby birthday piss up extravaganza Thought I should share these. http://www.adrianlynch.co.uk/rock/index.cfm Teehee Snakey -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] File permission(?) error
What sort of behaviour have you got for when the file already exists? Ade -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 15 March 2004 20:46 To: [EMAIL PROTECTED] Subject: [ cf-dev ] File permission(?) error Hi, Anyone know what would be causing this error, I can't replicate it with my own files? Permissions have been set properly for the destination directory as far as I'm aware: --- Error attempting to save uploaded file to path 'D:\data\0185rai\docs\assessmentFiles\riaFile_24.pdf.' Access is denied. (error 5) The error occurred while processing an element with a general identifier of (CFFILE), occupying document position (61:2) to (61:134) in the template file D:\DATA\0185RAI\DOCS\HTMFILES\ACT_ASSESSMENTFILEGENERATOR.CFM. --- Not much to go on I know! d -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Upload Access to cfdeveloper site
First thing I'd check is what GetUser.RecordCount returns, you might be getting more than one record and hence the else code block will run. Ade -Original Message- From: (s) Fiona Tope [mailto:[EMAIL PROTECTED] Sent: 08 March 2004 20:08 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Upload Access to cfdeveloper site How come it works in my local machine with exactly the same codes and exactly the same database contents? When type in user name and password, the Re-prompt for a valid username and password codes are executed and show the Sorry, message. ** Form login form template *** CFFORM ACTION=#CGI.SCRIPT_NAME# NAME=LoginForm METHOD=POST !--- Make the UserLogin and UserPassword fields required --- INPUT TYPE=Hidden NAME=UserLogin_required INPUT TYPE=Hidden NAME=UserPassword_required !--- Use an HTML table for simple formatting --- TABLE BORDER=0 align=center TR class=fm TH height=37 COLSPAN=2Please Log In/TH /TR TR TH width=136 height=38 align=right class=fm UserID:/TH TD width=262 class=fm !--- Text field for Admin UserID --- cfinput class=text type=Text name=UserLogin size=5 value= maxlength=20 required=Yes validate=integer message=Please enter your User ID. /TD /TRTR TH height=51 align=right class=fmUser Password:/TH TD class=fm !--- Text field for Admin Password --- CFINPUT class=text TYPE=Password NAME=UserPassword SIZE=20 VALUE= MAXLENGTH=25 REQUIRED=Yes MESSAGE=Please enter your User Password to gain access. *** From loginCheck template CFIF GetUser.RecordCount EQ 1 CFSET SESSION.Auth = StructNew() CFSET SESSION.Auth.IsLoggedInApp = Yes CFSET SESSION.Auth.fname= GetUser.fname CFSET SESSION.Auth.lname = GetUser.lname CFSET SESSION.Auth.user_login = GetUser.user_login CFSET SESSION.Auth.user_password = GetUser.user_password CFLOCATION URL=index.cfm !--- Re-prompt for a valid username and password --- CFELSE TR TD ALIGN=right Sorry, that username and password are not recognized. Please try again. /TD /TR -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Sun 07/03/2004 21:47 To: [EMAIL PROTECTED] Cc: Subject: RE: [ cf-dev ] Upload Access to cfdeveloper site -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Re-direct a index.html page to index.cfm page
You might want to use the meta one as well incase JS is disabled. Or if you can change the htm page to a cfm one then you can use cflocation. Can you use a cfm page instead? Ade -Original Message- From: (s) Fiona Tope [mailto:[EMAIL PROTECTED] Sent: 07 March 2004 20:55 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Re-direct a index.html page to index.cfm page Thanks Adrian, the script works! -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Sat 06/03/2004 20:23 To: [EMAIL PROTECTED] Cc: Subject: RE: [ cf-dev ] Re-direct a index.html page to index.cfm page Meta redirect or javascript. meta http-equiv=refresh content=url=folderA/index.cfm or script window.location = folderA/index.cfm; /script You might want to check the syntax on those as I haven't used them in a while. Ade -Original Message- From: (s) Fiona Tope [mailto:[EMAIL PROTECTED] Sent: 06 March 2004 19:15 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Re-direct a index.html page to index.cfm page Hi there, Anyone know how to re-direct an index.html page to index.cfm page. My index.cfm is suitated under a subfolder i.e. folderA/index.cfm. I need to re-direct the initial page index.html which is the starting page of the cfdeveloper hosting. Thanks, Fiona -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Upload Access to cfdeveloper site
Not sure about cfdeveloper but you could try debugging the code. Step through it with cfabort and output details to help you find the problem. Start at the login form and move forward from there. If you post some code we might spot something :O) Ade -Original Message- From: (s) Fiona Tope [mailto:[EMAIL PROTECTED] Sent: 07 March 2004 20:33 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Upload Access to cfdeveloper site Hi there, I exported the SQL Server database into Access and then uploaded to the cfdeveloper site, but the login does not recognize my usual username and password - it would however returned the pre-set error message to prompt the user for valid login details. It works in my local machine connects to SQL Server database. The database contents are the same as in Access. Any idea!? Cheers, Fiona -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] Re-direct a index.html page to index.cfm page
Meta redirect or javascript. meta http-equiv=refresh content=url=folderA/index.cfm or script window.location = folderA/index.cfm; /script You might want to check the syntax on those as I haven't used them in a while. Ade -Original Message- From: (s) Fiona Tope [mailto:[EMAIL PROTECTED] Sent: 06 March 2004 19:15 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Re-direct a index.html page to index.cfm page Hi there, Anyone know how to re-direct an index.html page to index.cfm page. My index.cfm is suitated under a subfolder i.e. folderA/index.cfm. I need to re-direct the initial page index.html which is the starting page of the cfdeveloper hosting. Thanks, Fiona -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
RE: [ cf-dev ] SQL Server NOT EQUAL TO NULL
Try '' instead of 'null'. CF converts DB nulls to empty strings on output. Ade -Original Message- From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: 18 February 2004 15:52 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] SQL Server NOT EQUAL TO NULL Afternoon guys, Quick question: I'm trying to insert an image into a page using a references kept in an SQL Server DB. Here's the code: CFIF #getSuppliers.logo# neq 'NULL' td valign=top align=rightCFOUTPUT query=getSuppliersimg src=logos/#logo#.jpg/CFOUTPUT/td /CFIF This works fine when there is actually a value in a record but I'm getting a red cross when it doesn't (indicating it's ignoring my CFIF statement). Basically, how do you tell it to ignore the table row if the value is NULL? Cheers in advance, James -- ** 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 ] Getting the current page name
If you don't want to use CGI vars, try... cfoutput #GetFileFromPath(GetCurrentTemplatePath())# #GetFileFromPath(GetBaseTemplatePath())# /cfoutput One will get the base file the other the current would you believe :O) Ade -Original Message- From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: 09 February 2004 13:06 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Getting the current page name Hi guys, I swear I saw this on the Macromedia Forums a few weeks ago but it seems to have disappeared. I'm basically needing to know what the current page filename is. For example, index.cfm and nothing else. I saw a bit of code that worked through CGI which did this but everything I'm finding now is either giving me the full URL address or the folder + the file name. Any ideas? Cheers again, James -- ** 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 ] checking email addresses
There's a web service available somewhere that does this I think, it might have been mentioned on CF-Talk so the archives might throw something up. Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 10:51 To: [EMAIL PROTECTED] Subject: [ cf-dev ] checking email addresses Anyone got some code that can simply validate some email addresses. Not that they are the correct syntax, but that they actually exist and will accept mail? I'm sure this can be done... 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! -- -- -- ** 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 ] An easy one for you - list of all values from a qu ery
Query.ColumnList? -Original Message- From: Giles Roadnight [mailto:[EMAIL PROTECTED] Sent: 06 February 2004 17:36 To: [EMAIL PROTECTED] Subject: [ cf-dev ] An easy one for you - list of all values from a query Which function do I use to get a list of the values returned by queryname.attributename. Had a complete brain fade and can't remember what it is called. I've looked in the list functions but it's not listed there. THanks Giles Roadnight http://giles.roadnight.name -- ** 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 ] OT - Blockhead
http://www.mtbireland.com/dodge.html 47 seconds, then it gets too fast -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] Efficient implementation of Read/Unread messages/a rticles etc.
Chances are, the number of messages a user has read will be less than the number they haven't. Store only what they have read and display it accordingly. Ade -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 26 January 2004 17:43 To: Cfuk Subject: [ cf-dev ] Efficient implementation of Read/Unread messages/articles etc. Hi, I'm looking to do an efficient method of adding a read/unread icon to messages/articles etc. There are potentially 1s of users and 1s of messages, so the data can get pretty big fast. I'll probably end up with cheating e.g. only hold the data for messages in the last 2 weeks or something along those lines, but thought I'd ask in case someone has come up with a great solution I hadn't thought of. Cheers, Justin. -- ** 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 ] OT: preventing hotlinking
Well then you're in trouble then, cos my mate Dave, he hot links and he loves the stuff... -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:49 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking um. yes, yes it is. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:49 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking Goatse? What's that, goat cheese? -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:37 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking or do what I do when people hotlink FJ's images. call down a lil bit of goatse on their heads. -- ** 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 ] OT: preventing hotlinking
http://www.urbandictionary.com/define.php?term=goatse -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 21 January 2004 09:53 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] OT: preventing hotlinking well, he'll love the goatse that I can provide him with. -- ** 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 ] CFMX - Dreamweaver
Any ideas anyone? Move back again :OD -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 10:02 To: [EMAIL PROTECTED] Subject: [ cf-dev ] CFMX - Dreamweaver Help !! I have moved office and am having real difficulty getting Dreamweaver working agin for some reason I get an error when connecting saying that there is no default website on the server. Whats gone wrong? I use RDS to connect all worked fine before but now nothing ... Aghh Any ideas anyone? Regards - Paul * The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. * -- ** 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 ] How can I do this ...
Move back.. opps, done that one already :OP Try = instead of EQ and if that still throws an error, wrap some single quotes around it. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 20 January 2004 11:26 To: [EMAIL PROTECTED] Subject: [ cf-dev ] How can I do this ... I want to query a spread sheet and get the first letter of each school Display this as an a-z acroos the top Then display the school names that correspond with the first letter in the list Something like b,c,d,f,g,r,s,u, and then Bakers Lane, Bedford Boys, Bulging Girls etc.. I have this cfquery name=select_az datasource=schoolsBudget SELECT DISTINCT LEFT(schoolName,1) AS schoolFirstLetter FROM table$ ORDER BY LEFT(schoolName,1) /cfquery cfoutput query=Select_az a href=getdata.cfm?letter=#schoolFirstLetter##schoolFirstLetter#/a /cfoutput cfquery name=q_getSchools datasource=schoolsBudget SELECT schoolName FROM table$ WHERE DISTINCT LEFT(schoolName,1) eq #schoolFirstLetter# /cfquery cfoutput query = q_getSchools #schoolName# /cfoutput Error in second query schoolFirstLetter not defined .. ? Regards - Paul * The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. * -- ** 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 ] NEWBIE - Dividing a string by a particular charact er
You can use it as it is with any of the list functions by using the £ as the delimiter. Have a look here for what's available. http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/functi13.htm#wp109943 5 Ade -Original Message- From: James Buckingham [mailto:[EMAIL PROTECTED] Sent: 15 January 2004 12:35 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] NEWBIE - Dividing a string by a particular character Hi there, I'm currently working on my very first Cold Fusion project and I've hit a bit of a stumbling block; so I was wondering if any of you veterans out there could help me out :). I'm sure this is very simple!!! I have a field in my DB called fares which contains a single string in each of the records. The string looks something like this: £562.50£562.50£587.50£562.50£445.00 Each fare is to correspond with a date which is stored in exactly the same way. I've managed to split the date up ok as this is a set number of 8 characters but the prices could vary a lot so I'm needing to split it up by the £ character. I've been looking at the left,mid and right functions but I've not managed to find anything on how to implement it in this particular way. Can anyone point me in the right direction? Cheers in advance, JamesB -- ** 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 ] Fancy a ColdFusion Challenge?
THANKS ALOT, that's my evenings gone! Looks cool though, we need more of this I reckon :O) Ade -Original Message- From: Tim Blair [mailto:[EMAIL PROTECTED] Sent: 15 January 2004 15:55 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Fancy a ColdFusion Challenge? Right you 'orrible lot... For any of you that read my blog at http://tech.badpen.com/ (so that'll be, oh, no-one...) you will have seen yesterday that I've been putting together a ColdFusion Coding Contest, and the first challenge has been posted at http://tech.badpen.com/cfcontest/ Your task - given a text-based 2D maze, find the shortest path out of it! What's the point? I hear you ask? Well, there isn't one really. Mainly it's to give people a challenge and maybe to get people doing the sort of coding that they wouldn't normally get the chance to do during the usual mass-website-producing day in the office... Also, I'm trying to convince the boss-man here to provide a prize... All information you should need is on the site including submission details and sample mazes to test your solver on. The submission date has been set for Friday 13th Feb by 4pm GMT so make sure I have your entries by then! Just in case you missed it, the URL again: http://tech.badpen.com/cfcontest/ Happy coding! Tim. --- RAWNET LTD - Internet, New Media and ebusiness Gurus. WE'VE MOVED - for our new address, please visit our website at http://www.rawnet.com/ or call us any time on 0800 294 24 24. --- Tim Blair Web Application Engineer, Rawnet Limited Direct Phone : +44 (0) 1753 626 654 Switchboard : 0800 294 2424 --- 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]
RE: [ cf-dev ] Disaster recovery Plan for CF 5 and SQL 2000/IIS 5 .0
What have you got so far? -Original Message- From: Cruz, Lisa L Ms GPRMC [mailto:[EMAIL PROTECTED] Sent: 12 January 2004 16:02 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] Disaster recovery Plan for CF 5 and SQL 2000/IIS 5.0 Hi All, Does anyone have a good recovery plan I could look at? I started one, but my boss doesn't like it - and won't give me ideas---can any of you help? Thanks, Lisa Lisa Cruz Systems Administrator There's no place like 127.0.0.1 Office of Clinical Operations Great Plains Regional Medical Command 2410 Stanley Rd., Suite B-17 Ft Sam Houston, Texas 78234-6230 210-295-2705 DSN: 421-2705 Fax: 210-295-2345 DSN: 421-2345 -- ** 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 ] CF Salaries
And if you do apply put me as your tell a Friend refrence - I get cash if you get the job ;) If I tell someone about it, do we split it? :O) Ade -- ** 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 ] Displaying CFCATCH Details
I am trying to loop through CFCATCH and output all the values for each key like so: cfloop collection=#CFCATCH# item=i pstrong#i#: /strong #CFCATCH[i]#/p /cfloop But I'm getting Complex object types cannot be converted to simple values.. Can someone shed some light on this, cfcatch is a structure no? I can do the same with FORM, URL, CLIENT etc. This is just for some quick debugging so it's not important, but I thought I'd ask anyway. Have I missed something here? Thanks -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] Displaying CFCATCH Details
I wish I had now, would have answered my question. I was putting it into an html email. Ade -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:23 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Displaying CFCATCH Details Why not just cfdump var=#cfcatch#? Paul -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:10 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] Displaying CFCATCH Details I am trying to loop through CFCATCH and output all the values for each key like so: cfloop collection=#CFCATCH# item=i pstrong#i#: /strong #CFCATCH[i]#/p /cfloop But I'm getting Complex object types cannot be converted to simple values.. Can someone shed some light on this, cfcatch is a structure no? I can do the same with FORM, URL, CLIENT etc. This is just for some quick debugging so it's not important, but I thought I'd ask anyway. Have I missed something here? Thanks -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] Displaying CFCATCH Details
Nice one, I usually look there, sorry for being lazy. CFCATCH.tagContext is an array so I'd guess that was causing the error. If I had dumped it first I no doubt would have seen that. Thanks all :O) -Original Message- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:23 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Displaying CFCATCH Details Hi Have a gander at this http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a27.htm and more helpfully this http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/tags-a10.htm#wp33 95038 which has a code snippet at the bottom that might help ya -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 09 January 2004 12:10 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] Displaying CFCATCH Details I am trying to loop through CFCATCH and output all the values for each key like so: cfloop collection=#CFCATCH# item=i pstrong#i#: /strong #CFCATCH[i]#/p /cfloop But I'm getting Complex object types cannot be converted to simple values.. Can someone shed some light on this, cfcatch is a structure no? I can do the same with FORM, URL, CLIENT etc. This is just for some quick debugging so it's not important, but I thought I'd ask anyway. Have I missed something here? Thanks -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004 -- ** 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 ] fresh pair of eyes...
FROM clause? -Original Message- From: Ian Westbrook (FDM) [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 13:51 To: CFUG List Subject: [ cf-dev ] fresh pair of eyes... can anyone see what's wrong with this? I've been staring at it for half an hour now... I'm getting an error [Microsoft][ODBC Microsoft Access Driver] The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. CF4.5, Access db cfquery datasource=#dsn# name=events SELECT directory.id, directory.postcode, directory.fullname, directory.boxofficetelephone, directory.town, diary.directoryid AS directoryid, diary.startdate, diary.enddate, diary.publish, diary.description, diary.title, diary.artform, diary.ticketprice, diary.concessions, artforms.id, artforms.artform AS artform, towns.id, towns.town AS town WHERE (directory.postcode LIKE 'TN%' OR directory.postcode LIKE 'CT%' OR directory.postcode LIKE 'BR%' OR directory.postcode LIKE 'BN%') AND directory.id = diary.directoryid AND directory.town = towns.id AND diary.artform = artforms.id AND (( diary.startdate = #nowdate#) OR ( diary.enddate = #nowdate#)) AND diary.publish = 'yes' ORDER BY diary.startdate, diary.title /cfquery TIA Ian W -- ** 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 ] form variables
Try StructClear(FORM), (check the syntax on that though). I'm not sure if that will stop the refresh from causing trouble, but worth a try. Ade -Original Message- From: Damien Gallagher [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 14:26 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] form variables just a quick one... I have a form page that needs to submit to itself to process the action. Problem is, once the action's complete the form variables are still in the page and so clicking refresh reprocesses the lot. Any ideas how to purge the variables? Thanks, Damien -- ** 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 ] form variables
You could use CGI.SCRIPT_NAME if you wanted. -Original Message- From: Damien Gallagher [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 17:17 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] form variables it's because the form is a module that the administrator can insert into any one of the dynamic content pages. Wanted to keep the form / action on the same page so we didn't have to then find which page the form's been inserted into and then pass that into the cflocation... whoa!... you know what I mean! -Original Message- From: Mark Smyth [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 16:10 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] form variables if its that much of a problem though, why not just do a cflocation to another page at the bottom of the action page. anything you're presenting to the user could just as easy be presented on a separate page, and even if its dynamic content, send them as uel vars in the cflocation -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 15:18 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] form variables Try StructClear(FORM), (check the syntax on that though). I'm not sure if that will stop the refresh from causing trouble, but worth a try. Ade -Original Message- From: Damien Gallagher [mailto:[EMAIL PROTECTED] Sent: 08 January 2004 14:26 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] form variables just a quick one... I have a form page that needs to submit to itself to process the action. Problem is, once the action's complete the form variables are still in the page and so clicking refresh reprocesses the lot. Any ideas how to purge the variables? Thanks, Damien -- ** 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 ] So Editor
If you're sure the extra output isn't down to your code, maybe some one at the hosting company has slipped up, you could always get them to check. Chances are it's something as trivial as someone changing a tag. Ade -Original Message- From: Damien Gallagher [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 10:32 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] So Editor no, haven't touched the so editor files as they're provided as part of my hosting etc. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 10:25 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] So Editor Did you edit any of the source files? -Original Message- From: Damien Gallagher [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 09:58 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] So Editor Hi all, I'm using So Editor Pro on a couple of sites and it keeps putting the following at the top of my page when I edit and save: style=FONT-FAMILY: Any ideas why? Thanks, DAmien -- ** 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 ] Job Opening (London)
Why, are you a dab hand at Photoshop? :O) -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 08:43 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) hmmm. good timing. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 17:58 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] Job Opening (London) http://www.thoughtbubble.com/vacancies/ -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] Job Opening (London)
Yeah, but is he WAI compliant? -Original Message- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:04 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Job Opening (London) He's da McDonalds of Potatochop! - Peter -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:59 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) Why, are you a dab hand at Photoshop? :O) -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 08:43 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) hmmm. good timing. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 17:58 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] Job Opening (London) http://www.thoughtbubble.com/vacancies/ -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] Job Opening (London)
I da know, read the job description, I work here already :OP -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:09 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) er.. yes. (whats WAI mean?) -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:09 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) Yeah, but is he WAI compliant? -Original Message- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:04 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Job Opening (London) He's da McDonalds of Potatochop! - Peter -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:59 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) Why, are you a dab hand at Photoshop? :O) -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 08:43 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) hmmm. good timing. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 17:58 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] Job Opening (London) http://www.thoughtbubble.com/vacancies/ -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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] -- ** 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 ] Page Weight
Damn, that gets more sighs that the last 20 minutes of Lord Of The Rings III.. -Original Message- From: Snake Hollywood [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:19 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Page Weight Surely they are all going to weigh the same. It's whatever your monitor weighs ? -Original Message- From: Allan Cliff [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 11:22 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Page Weight Anyone know of a small program to check the weight of webpages? Thanks Allan -- ** 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 ] Job Opening (London)
lol -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:20 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) is it any coincidence that WAI sounds like why? -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:17 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) I da know, read the job description, I work here already :OP -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:09 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) er.. yes. (whats WAI mean?) -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:09 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) Yeah, but is he WAI compliant? -Original Message- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:04 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Job Opening (London) He's da McDonalds of Potatochop! - Peter -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:59 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) Why, are you a dab hand at Photoshop? :O) -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 08:43 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) hmmm. good timing. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 17:58 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] Job Opening (London) http://www.thoughtbubble.com/vacancies/ -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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] -- ** 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 ] WAI (WAS: Job Opening (London))
You forgot BBC, Channel 4 and Sky One... -Original Message- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:55 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] WAI (WAS: Job Opening (London)) bigWoodenSpoon It almost sounds like an HR agency dropping in related acronyms into a job advert to scare off chancers. Bet you it also says CFMX, Dreamweaver, DHTML, DOM, JavaScript, VBScript, ASP, .NET, SQL, Oracle, MySQL, Java, P3P, PHP, HTTP, SSL, PGP, COM+, XML, SOAP, FTP, WDDX, WAP, WML, WDSL, CORBA, Apache, Linux, Photoshop, COBOL... and notepad. :D But they really only need you to know how to use notepad, google and your brain. ;) /bigWoodenSpoon - Peter -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:36 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] WAI (WAS: Job Opening (London)) yup, sorry, I was larking around pretending not to know what it was for comedy purposes - but Peter has a good point - none of the customers of my current employer want to fork out for the extra time of development that WAI-compliance involves. They'll wait until it's a legal requirement, and then pay, but until then, there's no money made available for it. -Original Message- From: Simon Horwith [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:21 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Job Opening (London) WAI is the Web Accessibility Initiative. If you take a look at recent (and the current issue I believe) issues of CFDJ (http://www.sys-con.com/coldfusion/) there was a recent series of articles that will give you a very good idea what it is and how to meet it's requirements, etc. If the job description says anything about WAI, I'd be sure to know a bit about t before going to any interviews ;) ~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 http://www.how2cf.com/ -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:09 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) er.. yes. (whats WAI mean?) -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:09 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) Yeah, but is he WAI compliant? -Original Message- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 13:04 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Job Opening (London) He's da McDonalds of Potatochop! - Peter -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 12:59 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) Why, are you a dab hand at Photoshop? :O) -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 07 January 2004 08:43 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Job Opening (London) hmmm. good timing. -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 17:58 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] Job Opening (London) http://www.thoughtbubble.com/vacancies/ -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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
RE: [ cf-dev ] Another interesting question
JavaScript... status = 'message to be displayed'; should work. Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 06 January 2004 14:53 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Another interesting question Same form thingy as before. Now I want to tart it up and make it jazzy. I want to make it so that when elements of the form get the focus that a status line on the form will show information about that part of the form. For example Please enter your name Staus line shows Firstname Lastname I know I can force entry so that the user can only enter a certain way but I want this status line too Is this a Java thing? Again any Ideas welcomed Regards - Paul * The information contained within this e-mail (and any attachment) sent by Birmingham City Council is confidential and may be legally privileged. It is intended only for the named recipient or entity to whom it is addressed. If you are not the intended recipient please accept our apologies and notify the sender immediately, or telephone +(44) 121 303 . Unauthorised access, use, disclosure, storage or copying is not permitted and may be unlawful. Any e-mail including its content may be monitored and used by Birmingham City Council for reasons of security and for monitoring internal compliance with the office policy on staff use. E-mail blocking software may also be used. Any views or opinions presented are solely those of the originator and do not necessarily represent those of Birmingham City Council. We cannot guarantee that this message or any attachment is virus free or has not been intercepted and amended. * -- ** 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 ] OT: Quote
Taken from a job posting on ukcfug.org ...ASP experience is of no real value. Not my words :O) -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] Job Opening (London)
http://www.thoughtbubble.com/vacancies/ -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] OT MAME Roms
For those that care, I found http://www.rom-world.com/ You have to 'vote' for them a few times, but you get to the good stuff eventually. Ade -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 31 December 2003 13:16 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] OT MAME Roms Does anyone know where I can get some MAME Roms from? It's been a while since I downloaded some and it seems like all the sites have dried up. www.mame.dk doesn't appear to be up anymore either. Ade -- ** 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 ] stupid sql question
This seems to work on SQL Server CREATE TABLE #product ( pk int, product varchar(50) ) CREATE TABLE #shop ( pk int, shop varchar(50) ) CREATE TABLE #shopProduct ( fkProduct int, fkShop int ) INSERT INTO #product ( pk, product ) VALUES ( 1, 'pro_1' ) INSERT INTO #product ( pk, product ) VALUES ( 2, 'pro_2' ) INSERT INTO #product ( pk, product ) VALUES ( 3, 'pro_3' ) INSERT INTO #product ( pk, product ) VALUES ( 4, 'pro_4' ) INSERT INTO #shop ( pk, shop ) VALUES ( 1, 'shop_1' ) INSERT INTO #shop ( pk, shop ) VALUES ( 2, 'shop_2' ) INSERT INTO #shop ( pk, shop ) VALUES ( 3, 'shop_3' ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 1, 1 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 1, 2 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 2, 1 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 3, 2 ) SELECT Shop, Product, CASE WHEN sp.fkProduct IS NULL THEN 'no' ELSE 'yes' END AS 'Available' FROM #shop, #product LEFT OUTER JOIN #shopProduct AS sp ON ( #product.pk = sp.fkProduct ) ORDER BY Shop It looks right to me, but you'll know for sure if it's doing what you need. Ade -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 15:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] stupid sql question yes... if there is a entry for that product in that shop... feeling humiliated :-) Justin -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 14:52 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] stupid sql question Where is the availability flag? Is it simply if it exists in a shop? -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 14:54 To: Cfuk Subject: [ cf-dev ] stupid sql question My brain is still in xmas mode, and what should be simple sql is a challange! I want to do a query, that lists all the products , with a column with a yes/no (boolean/bit) column to say if the product is available in that shop or not so with [Product] pk product -- 1 product1 2 product2 3 product3 [Shop] pk shop -- 1 shop_1 2 shop_2 [ShopProduct] FKProduct FKShop --- 1 1 1 2 2 1 3 2 I should have Shopproduct available -- shop_1 product1yes shop_1 product2yes shop_1 product3no shop_2 product1yes shop_2 product2no shop_2 product3yes I know its a CROSS JOIN between shop and product with a outer? join on the ShopProduct table but just can't get it together... Thanks Justin -- ** 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 e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- ** 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 ] stupid sql question
Sorry, the temp tables were for me only, I don't have the originals see :O) Get rid of the hashs and change the names to your table names Justin and it should work. Ade -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 15:50 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] stupid sql question I havent had a chance to look at it, and this will work, but you shouldn't need to use a temporary table for this..will have a look post-work and see what I can come up with.! -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 15:55 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] stupid sql question This seems to work on SQL Server CREATE TABLE #product ( pk int, product varchar(50) ) CREATE TABLE #shop ( pk int, shop varchar(50) ) CREATE TABLE #shopProduct ( fkProduct int, fkShop int ) INSERT INTO #product ( pk, product ) VALUES ( 1, 'pro_1' ) INSERT INTO #product ( pk, product ) VALUES ( 2, 'pro_2' ) INSERT INTO #product ( pk, product ) VALUES ( 3, 'pro_3' ) INSERT INTO #product ( pk, product ) VALUES ( 4, 'pro_4' ) INSERT INTO #shop ( pk, shop ) VALUES ( 1, 'shop_1' ) INSERT INTO #shop ( pk, shop ) VALUES ( 2, 'shop_2' ) INSERT INTO #shop ( pk, shop ) VALUES ( 3, 'shop_3' ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 1, 1 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 1, 2 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 2, 1 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 3, 2 ) SELECT Shop, Product, CASE WHEN sp.fkProduct IS NULL THEN 'no' ELSE 'yes' END AS 'Available' FROM #shop, #product LEFT OUTER JOIN #shopProduct AS sp ON ( #product.pk = sp.fkProduct ) ORDER BY Shop It looks right to me, but you'll know for sure if it's doing what you need. Ade -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 15:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] stupid sql question yes... if there is a entry for that product in that shop... feeling humiliated :-) Justin -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 14:52 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] stupid sql question Where is the availability flag? Is it simply if it exists in a shop? -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 14:54 To: Cfuk Subject: [ cf-dev ] stupid sql question My brain is still in xmas mode, and what should be simple sql is a challange! I want to do a query, that lists all the products , with a column with a yes/no (boolean/bit) column to say if the product is available in that shop or not so with [Product] pk product -- 1 product1 2 product2 3 product3 [Shop] pk shop -- 1 shop_1 2 shop_2 [ShopProduct] FKProduct FKShop --- 1 1 1 2 2 1 3 2 I should have Shopproduct available -- shop_1 product1yes shop_1 product2yes shop_1 product3no shop_2 product1yes shop_2 product2no shop_2 product3yes I know its a CROSS JOIN between shop and product with a outer? join on the ShopProduct table but just can't get it together... Thanks Justin -- ** 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 e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- ** 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
RE: [ cf-dev ] stupid sql question
Or... SELECT Shop, Product, CASE WHEN sp.fkProduct IS NULL THEN 'no' ELSE 'yes' END AS 'Available' FROM Shop, Product LEFT OUTER JOIN ShopProduct AS sp ON ( Product.pk = sp.fkProduct ) ORDER BY Shop I've never seen a problem that was solved with a cartesian join before, interesting :O) Ade -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 15:59 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] stupid sql question Sorry, the temp tables were for me only, I don't have the originals see :O) Get rid of the hashs and change the names to your table names Justin and it should work. Ade -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 15:50 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] stupid sql question I havent had a chance to look at it, and this will work, but you shouldn't need to use a temporary table for this..will have a look post-work and see what I can come up with.! -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 15:55 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] stupid sql question This seems to work on SQL Server CREATE TABLE #product ( pk int, product varchar(50) ) CREATE TABLE #shop ( pk int, shop varchar(50) ) CREATE TABLE #shopProduct ( fkProduct int, fkShop int ) INSERT INTO #product ( pk, product ) VALUES ( 1, 'pro_1' ) INSERT INTO #product ( pk, product ) VALUES ( 2, 'pro_2' ) INSERT INTO #product ( pk, product ) VALUES ( 3, 'pro_3' ) INSERT INTO #product ( pk, product ) VALUES ( 4, 'pro_4' ) INSERT INTO #shop ( pk, shop ) VALUES ( 1, 'shop_1' ) INSERT INTO #shop ( pk, shop ) VALUES ( 2, 'shop_2' ) INSERT INTO #shop ( pk, shop ) VALUES ( 3, 'shop_3' ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 1, 1 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 1, 2 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 2, 1 ) INSERT INTO #shopProduct ( fkProduct, fkShop ) VALUES ( 3, 2 ) SELECT Shop, Product, CASE WHEN sp.fkProduct IS NULL THEN 'no' ELSE 'yes' END AS 'Available' FROM #shop, #product LEFT OUTER JOIN #shopProduct AS sp ON ( #product.pk = sp.fkProduct ) ORDER BY Shop It looks right to me, but you'll know for sure if it's doing what you need. Ade -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 15:16 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] stupid sql question yes... if there is a entry for that product in that shop... feeling humiliated :-) Justin -Original Message- From: Robertson-Ravo, Neil (RX) [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 14:52 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] stupid sql question Where is the availability flag? Is it simply if it exists in a shop? -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 05 January 2004 14:54 To: Cfuk Subject: [ cf-dev ] stupid sql question My brain is still in xmas mode, and what should be simple sql is a challange! I want to do a query, that lists all the products , with a column with a yes/no (boolean/bit) column to say if the product is available in that shop or not so with [Product] pk product -- 1 product1 2 product2 3 product3 [Shop] pk shop -- 1 shop_1 2 shop_2 [ShopProduct] FKProduct FKShop --- 1 1 1 2 2 1 3 2 I should have Shopproduct available -- shop_1 product1yes shop_1 product2yes shop_1 product3no shop_2 product1yes shop_2 product2no shop_2 product3yes I know its a CROSS JOIN between shop and product with a outer? join on the ShopProduct table but just can't get it together... Thanks Justin -- ** 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 e-mail is from Reed Exhibitions (Oriel House, 26 The Quadrant, Richmond, Surrey, TW9 1DL, United Kingdom), a division of Reed Business, Registered in England, Number 678540. It contains information which is confidential and may also be privileged. It is for the exclusive use of the intended recipient(s). If you are not the intended recipient(s) please note that any form of distribution, copying or use of this communication or the information in it is strictly prohibited and may be unlawful. If you have received this communication in error please return it to the sender or call our switchboard on +44 (0) 20 89107910. The opinions expressed within this communication are not necessarily those expressed by Reed Exhibitions. Visit our website at http://www.reedexpo.com -- ** Archive: http://www.mail-archive.com/dev
[ cf-dev ] OT MAME Roms
Does anyone know where I can get some MAME Roms from? It's been a while since I downloaded some and it seems like all the sites have dried up. www.mame.dk doesn't appear to be up anymore either. Ade -- ** 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 of queries issue
I'd guess it's because the mechanism that works out the db hits doesn't know whether CF is caching or not. A hidden implementation kind of thing maybe... Ade -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 12 December 2003 17:03 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Query of queries issue Ok... I have resolved the issue and found that only 9 queries were getting run in total. Moral of the story: Don't trust the statistics that the CF Server gives you with regards to db hits/sec!!! That's because, according to those stats, when I cache all the queries, and store everything I can in the application scope, I still have 28 db hits/sec for 1 request! That doesn't seem right to me, esp as when I check the SQL Server using Profiler, nothing has gone in or out. Ok... MM time to sort this one out or explain it! Paul -- ** 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 ] When two different strings are the same
I know you weren't looking for answers, but have a look at this: cfset one = 000 / cfset two = / cfif DE(one) EQ DE(two) yes cfelse no /cfif Change them to be the same and it result in yes being displayed. Ade -Original Message- From: Paolo Piponi [mailto:[EMAIL PROTECTED] Sent: 11 December 2003 11:37 To: '[EMAIL PROTECTED]' Subject: [ cf-dev ] When two different strings are the same An unfortunate result of not having numerics and strings in CF: cfset tenzeros=00 cfset elevenzeros=000 cfif tenzeros eq elevenzerosThese two strings are not the same, but this code thinks they are./cfif Don't ask why I did this, I can work round it, but just a little quirk I thought I'd share. Paolo -- ** 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 ] Europes Leading CF Expert?
Then let's toss a coin, heads it's me, tails it's you... flip heads / tails / heads / tails / heads / tails / heads / tails / heads / tails / heads / /flip Heads it is :OD -Original Message- From: Steve Martin [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 14:20 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Europes Leading CF Expert? There is none: Your search - Europe's leading ColdFusion expert - did not match any documents See, Google never lies! -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 14:15 To: Cfug Dev List (E-mail) Subject: [ cf-dev ] Europes Leading CF Expert? Just read this in a Monster post My client, a leading European Software House, require a strong ColdFusion developer with at least 6 months MX experience. You must have a commercial background using SQL databases. Candidates must be articulate, team players willing to learn new skills. This position offers training in all Macromedia products and provides the opportunity to work alongside one of Europe's leading ColdFusion experts. ... I wonder who the expert is? -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] Europes Leading CF Expert?
The last man to try that died from attribute poisoning... -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 16:03 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Europes Leading CF Expert? Ok Rich, high noon. 10 pints of Guinness, followed by race to see who can name all the CFGRID attributes. Justin -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 15:44 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Europes Leading CF Expert? Very, very good! I guess that means Rich is DA MAN currently yes. until challenged. -- ** 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 ] Europes Leading CF Expert?
It is, but they're busy training to take Wild Rich down... -Original Message- From: Peter Harrison [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 16:07 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Europes Leading CF Expert? I thought this list was moderated? :D - Peter -Original Message- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 16:03 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Europes Leading CF Expert? The last man to try that died from attribute poisoning... -Original Message- From: Justin [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 16:03 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Europes Leading CF Expert? Ok Rich, high noon. 10 pints of Guinness, followed by race to see who can name all the CFGRID attributes. Justin -Original Message- From: Rich Wild [mailto:[EMAIL PROTECTED] Sent: 10 December 2003 15:44 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Europes Leading CF Expert? Very, very good! I guess that means Rich is DA MAN currently yes. until challenged. -- ** 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]
[ cf-dev ] [OT] Fade in ActionScript (Paul)
Paul, I thought this might be of interest. I came across this behaviour a while ago... http://chattyfig.figleaf.com/ezmlm/ezmlm-cgi?1:sss:1701:eheaicjemhkibnpfhjgp #b It might explain away a few problems for some people. -- Adrian Lynch Web Application Developer Thoughtbubble Ltd Full Service Agency -- http://www.thoughtbubble.com Tel: +44 (0) 20 7387 8890 (ex. 23) Fax: +44 (0) 20 7383 2220 -- The information in this email and in any attachments is confidential and intended solely for the attention and use of the named addressee(s). Any views or opinions presented are solely those of the author and do not necessarily represent those of Thoughtbubble. This information may be subject to legal, professional or other privilege and further distribution of it is strictly prohibited without our authority. If you are not the intended recipient, you are not authorised to disclose, copy, distribute, or retain this message. Please notify us on +44 (0)207 387 8890. -- ** 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 ] OT: ActionScript
As others have said. Put the textfield in a movie clip, then inside the clip try something like this... text_tf.text = Hella Cool Fade; this.onEnterFrame = function() { if (this._alpha 0) { goDown = false; } else if (this._alpha 100) { goDown = true; } if (goDown) { trace(this._alpha); this._alpha -= 4; } else { trace(this._alpha); this._alpha += 4; } }; ... where text_tf is the instance name of the textfield. Remove the traces when you're happy with what it's doing. Try this first and you should notice that it doesn't seem to work. This is because you will need to embed the characters. This is done in the properties of the textfield, Character... Embed font outlines for:... Then it's a case of working the array into the equation. Ade -Original Message- From: Paul Johnston To: [EMAIL PROTECTED] Sent: 04/12/03 17:06 Subject: [ cf-dev ] OT: ActionScript I have a bunch of text in an array. I am cycling over that array and making the text come out and also move. The thing I now want is to be able to fade it in and out. The problem is that I cannot figure out how (in actionscript) to do this. The text will change regularly, so saying something like make a graphic of the text isn't going to help. Any ideas? I'm just banging my head against a brick wall! Paul --- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** 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 ] OT: ActionScript
Embed the font Luke... ... embed the font... -Original Message- From: Paul Johnston To: [EMAIL PROTECTED] Sent: 05/12/03 12:19 Subject: RE: [ cf-dev ] OT: ActionScript Basically, the way I managed it (worst luck) is to do this: 1) create a movie clip 2) insert a textfield into the movie clip 3) insert a box into the movie clip as a graphic (of the same colour as the background) 4) control the _alpha of the graphic The only issue is that you then cannot control the alpha of just the text, but the whole box. This can affect anything beneath it. I just CANNOT figure out how to control the alpha of JUST the text, or even just the movie clip! Any hints would be very much appreciated Paul -Original Message- From: Colm Brazel [mailto:[EMAIL PROTECTED] Sent: 05 December 2003 10:23 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] OT: ActionScript Paul, Reaaly cool if you manage to do a .swf with these effects, any chance of showing it plus code if you succeed? Closest I am aware of to help with this would be to look at the properties of the TextField Object which exposes lots of methods and properties including _alpha and turns text into a kind of movieclip. It can load dynamic data stored in a variable but don't think it can load complex data stored in an array, correct me if I`m wrong. MX Designer's Actionscript Reference I recommend might be helpful. Only other thing I can think of is some code I got from the above book fscommand (allowscale, true); moveMe = function () { this._x += this.dx; this._y += this.dy; this.dy += .5; this._alpha -= 2; if (this._y400) { this.dx = Math.random()*10-5; this.dy = Math.random()*-10-10; this._alpha = 100; this._x =315; this._y = 200; return true; } }; for (i=0; i120; i++) { nm = star add i; mainstar.duplicateMovieClip(nm, i); _root[nm].dx = Math.random()*10-5; _root[nm].dy = Math.random()*-10-10; _root[nm].onEnterFrame = moveMe; _root[nm]._x = 275; _root[nm]._y = 390; _quality = high; } mainstar.onEnterFrame = moveMe; stop(); I have the above on a page bubbles on www.cbweb.net the trick would be to change the small circle bubble, mainstar, which is a movie clip, into a movie clip loading text dynamically, the code would have to loop through the array, maybe turn the array into a list, choose first item on the list,that becomes mainstar above, then loop again and do same for next item, so you have a geeser of text:-)BTW I havn't worked out the switch to toggle the above on/off if anyone can point it out. Colm Colm Brazel MA CB Publications www.cbweb.net http://www.cbweb.net Macromedia-Dublin UserGroup Manager http://www.mmug-dublin.com [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Web Site Design Development, Cold Fusion, general publishing including E-Books. The information contained in this e-mail transmission is confidential and may be privileged. It is intended only for the addressee(s) stated above. If you are not an addressee, any use, dissemination, distribution, publication,or copying of the information contained in this e-mail is strictly prohibited. If you have received this e-mail in error, please immediately notify CB Publications by telephone at 353-1-4941625 or e-mail [EMAIL PROTECTED] and delete the e-mail from your system. -Original Message- From: Paul Johnston [mailto:[EMAIL PROTECTED] Sent: 04 December 2003 17:07 To: [EMAIL PROTECTED] Subject: [ cf-dev ] OT: ActionScript I have a bunch of text in an array. I am cycling over that array and making the text come out and also move. The thing I now want is to be able to fade it in and out. The problem is that I cannot figure out how (in actionscript) to do this. The text will change regularly, so saying something like make a graphic of the text isn't going to help. Any ideas? I'm just banging my head against a brick wall! Paul --- Paul Johnston PJ Net Solutions Ltd http://www.pjnetsolutions.com [EMAIL PROTECTED] +44 (0)7866 573013 -- ** 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- ** Archive:
RE: [ cf-dev ] SQL question
Sub select if you can use them: SELECT [User], Job FROM table1 WHERE [User] NOT IN (SELECT [User] FROM table2) Or Joining and excluding nulls in User in table2: SELECT table1.[User], table1.Job FROM table1 LEFT OUTER JOIN table2 ON ( table1.[User] = table2.[User] ) WHERE table2.[User] IS NULL Is that the sort of thing you meant? Ade -Original Message- From: Justin To: [EMAIL PROTECTED] Sent: 05/12/03 15:04 Subject: RE: [ cf-dev ] SQL question Trying to do in the DB only, without a cursor, but its Friday. Feel like it should be possible, maybe not! Thanks Justin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: 05 December 2003 14:48 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] SQL question actually that AND should be an OR instead. [EMAIL PROTECTED] sign.co.uk To: [EMAIL PROTECTED] cc: 05/12/2003 14:46 Subject: Re: [ cf-dev ] SQL question Please respond to dev how's this: !--- first query --- cfquery name=q1 select User, Job from sometable where somecriteria /cfquery cfif q1.recordcount !--- 2nd --- cfquery select ID, User, Job from table1 where cfloop query=q1 (User '#q1.User#' AND Job '#q1.Job#') OR /cfloop 1 = 0 /cfquery /cfif 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! -- -- Justin JustinMacCarthy@To: Cfuk [EMAIL PROTECTED] online.ie cc: Subject: [ cf-dev ] SQL question 05/12/2003 14:26 Please respond to dev If I have table 1 user job joe manager sam Staff harry manager and a query that returns user job joe manager harry manager dick staff is there a way to get this (i.e. anyone in table1 that don't have matching rows in the query) in SQL User job Sam staff Thanks Justin -- ** 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 ] A little advice...
With both CLIENT and SESSION you still need cookies enabled as CFID and CFTOKEN are needed on the client machine, although you could pass it through the URL I guess. Ade -Original Message- From: Paul Fennell [mailto:[EMAIL PROTECTED] Sent: 26 November 2003 11:21 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] A little advice... As long as you use the cookie at the payment gate way to look up the prices in the database - Rather than take prices from the cookie - Also you should look at encypting cookies However bear in mind a lot of people dont like cookies so you might have to stro the info in the client scope - -Original Message- From: Peter Dray [mailto:[EMAIL PROTECTED] Sent: 26 November 2003 11:06 To: [EMAIL PROTECTED] Subject: [ cf-dev ] A little advice... I'm doing a simple shopping cart 'thing'. I don't want to store the data in a db and I do want the data to persist across sessions. What I did was... Each item added to the basket is a structure, as is the basket itself. I then CFWDDX'd it and bunged it in a cookie. Good? Bad? Advice welcome Pete Dray -- ** 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] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 21/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.543 / Virus Database: 337 - Release Date: 21/11/2003 -- ** 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 ] Flash MX
Just get stuck in there, get hold of an ActionScript book to answer the basics go here http://chattyfig.figleaf.com and sign up to flashcoders and flashnewbie. Open the ActionScript Dictionary (Help AS Dictionary) from within Flash and become one with it. Be prepared to get very confused with some things and to then realise it's a bug in flash and not your code :OS I've had some very basic questions which where very well answered on flashnewbie, so don't be afraid to ask. Ade -Original Message- From: Ellwood [mailto:[EMAIL PROTECTED] Sent: 23 November 2003 20:03 To: [EMAIL PROTECTED] Subject: [ cf-dev ] Flash MX Being a seasoned Coldfusion developer who has been coding Coldfusion MX since its launch and also now the MX 6.1 outing little seems to phase me. But moving into the CFC arena and starting to develop 'Rich Internet Application' it has become almost a standard requirement for me to branch into the Flash MX environment. This scares the hell out of me as I have been told that CF'ers And FMX'ers work best away from each other only coming together when the applications they develop need to talk. So as you can tell, it is with much trepidation that I have ventured forth into the darkness with only my trusty gardener 'Sam' to protect me (sorry, wrong story). However, I feel almost as daunted as young Mr Frodo in my quest to bring better applications to my clients. The question I am finally getting to is this, how many of you guys have already gone blindly forth into the night and found your way through the dead marshes to achieve the goal of a Flash CF hybrid programmer? If so, how many of those of you that have got this far, have some good advice for those of us still putting our toe in the water so to speak? Are there any tried and trusted resources? Books, Online tutorials, presentations, etc. And also, of those that failed and followed the lights to join the dead within the marshes, what would you warn me against? Working as a freelancer it is important that I don't spend a great deal of time following a path that has been trodden before which bears no fruit. This List has always shown a mature and constructive response to my post in the past and I hope this is true again here. Ellis C Wood BSc Macromedia Certified Coldfusion MX Developer Ellwood Web Solutions -- ** 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 ] IsArray()
I'm running this on CFMX 6.1 cfoutput #IsArray(queryName[ColumnName])#br / #IsArray(queryName.ColumnName)# /cfoutput and it's returning yes for the first one and no for the second, am I missing something here? livedocs says the top one works this way, which is understandable, but why not the bottom one? Ade -- ** 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 ] IsArray()
I should have also mentioned, I understand the ability to access queries like structures of arrays, I'm just a little put off by the two examples not giving back the same result as it does in this example... cfscript queryName = StructNew(); queryName.ColumnName = ArrayNew(1); queryName.ColumnName[1] = First; queryName.ColumnName[2] = Second; queryName.ColumnName[3] = Third; /cfscript cfdump var=#queryName[ColumnName][1]# / cfdump var=#queryName.ColumnName[2]# / cfdump var=#queryName.ColumnName[3]# / cfdump var=#IsArray(queryName[ColumnName])# /!--- Yes --- cfdump var=#IsArray(queryName.ColumnName)# /!--- Yes --- Ade -Original Message- From: Adrian Lynch To: '[EMAIL PROTECTED]' Sent: 23/11/03 13:19 Subject: [ cf-dev ] IsArray() I'm running this on CFMX 6.1 cfoutput #IsArray(queryName[ColumnName])#br / #IsArray(queryName.ColumnName)# /cfoutput and it's returning yes for the first one and no for the second, am I missing something here? livedocs says the top one works this way, which is understandable, but why not the bottom one? Ade -- ** 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 ] Drop down dhtml from query
How about: ID ParentIDURL Title 1 0 index.cfm Vaporizers 2 1 index.cfm Ambient 3 2 index.cfm Natural 4 2 index.cfm Forced To get the data out you may need to do it recursively, or look into sql trees and something called tree traversal. I had these links saved for this but I remember reading a better article somewhere, if I find it I'll mail it. http://www.dbmsmag.com/9604d06.html http://www.dbmsmag.com/9603d06.html http://www.sitepoint.com/article/1105/3 Ade -Original Message- From: Dave Phipps [mailto:[EMAIL PROTECTED] Sent: 21 November 2003 09:37 To: CFUG Subject: [ cf-dev ] Drop down dhtml from query Hi, I have the following snippet from a dhtml dropdown system which I need to generate from a db query. How do I go about implementing the sub menus in the db table to make it easy to generate the correct parent-child relationships to get the nested dropdowns? The code needs to look like this: dqm__subdesc1_0 = Vaporizers; dqm__url1_0 = index.cfm; dqm__icon_index1_0 = 0; dqm__2nd_icon_index1_0 = 0 // sub menu of Vaporizers dqm__subdesc1_0_0 = Ambient; dqm__url1_0_0 = index.cfm; dqm__icon_index1_0_0 = 0; dqm__2nd_icon_index1_0_0 = 0 //sub menu of Ambient dqm__subdesc1_0_0_0 = Natural Draft; dqm__url1_0_0_0 = index.cfm; dqm__icon_index1_0_0_0 = 0 dqm__subdesc1_0_0_1 = Forced Draft; dqm__url1_0_0_1 = index.cfm; dqm__icon_index1_0_0_1 = 0 Any help would be great. 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]
RE: [ cf-dev ] Detecting JavaScript Enabled
Of the top of my head, what about loading the normal bog standard one, then attempt to override it with JS. If the browser isn't running scripts no harm is done, I think :OS Ade -Original Message- From: Lovelock, Richard J [mailto:[EMAIL PROTECTED] Sent: 17 November 2003 14:16 To: '[EMAIL PROTECTED]' Subject: RE: [ cf-dev ] Detecting JavaScript Enabled thats what I initiallly thought but i thought that the noscript was supposed to be used directly after a script /script section of which there isn't one!? the 'go' button displays regardless of whether scripting is enabled so using noscript will add a submit button and the 'go' button wouldn't it which is not what I want to achieve? ___ * 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: Matt Horn [mailto:[EMAIL PROTECTED] Sent: 17 November 2003 14:06 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Detecting JavaScript Enabled tough one maybe try noscript input type = submit value=submit /noscript or write 2 different pages .. and use the noscript tag to cause a meta refresh if there is no script html head noscript meta http-equiv=refresh content=0;URL=http://www.somewhere.com/js-no.html; /noscript /head HTH Matt - Original Message - From: Lovelock, Richard J [EMAIL PROTECTED] To: 'cflist' [EMAIL PROTECTED] Sent: Monday, November 17, 2003 3:58 PM Subject: [ cf-dev ] Detecting JavaScript Enabled Afternoon.. How can I test if a client's browser is JS enabled (i.e. Scripting not disabled)? the website is undergoing some e-gov monitoring and accessibility needs to be high. There is a form that uses a button labelled 'Go' to submit form with code: a href=javascript:frmChannelSelect.submit()img src=/templates/images/personal_arrow.gif alt=go border=0/a What I want to do, is be able to detect if user has scripting disabled and if this IS the case - put a bog standard submit button instead of this image button. Any ideas please? ___?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] === 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] -- ** 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 ] has too many arguments specified
Could it be that you haven't sized your varchars? VARCHAR(50), it may default to something though. Ade -Original Message- From: Damian Watson [mailto:[EMAIL PROTECTED] Sent: 17 November 2003 15:57 To: [EMAIL PROTECTED] Subject: [ cf-dev ] has too many arguments specified Hi all, I've got this error I can't figure from calling an SP: [MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC SQL Server Driver][SQL Server]Procedure or function selectText has too many arguments specified. The SP looks like this: CREATE PROCEDURE [updateText] @s_textTitle varchar, @s_textBody varchar, @i_textID int AS UPDATE contentText SET textTitle = '@s_textTitle', textBody = '@s_textBody' WHERE textID = @i_textID GO and the calling page: cfstoredproc datasource=#request.dsn# procedure=selectText returncode=no cfprocparam cfsqltype=CF_SQL_VARCHAR dbvarname=@s_textTitle type=in value=#form.s_textTitle# cfprocparam cfsqltype=CF_SQL_VARCHAR dbvarname=@s_textBody type=in value=#form.s_textBody# cfprocparam cfsqltype=CF_SQL_INTEGER dbvarname=@i_textID type=in value=#form.i_textID# /cfstoredproc Presumably it's something basic... Cheers d -- ** 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 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]