RE: [ cf-dev ] number of items in a list

2004-09-23 Thread Adrian Lynch
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

2004-09-23 Thread Adrian Lynch
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

2004-09-23 Thread Adrian Lynch
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

2004-09-23 Thread Adrian Lynch
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 ???

2004-09-09 Thread Adrian Lynch
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 ???

2004-09-09 Thread Adrian Lynch
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 ???

2004-09-09 Thread Adrian Lynch
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 ???

2004-09-09 Thread Adrian Lynch
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 ???

2004-09-09 Thread Adrian Lynch
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 ???

2004-09-08 Thread Adrian Lynch
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 ???

2004-09-08 Thread Adrian Lynch
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 ....

2004-08-22 Thread Adrian Lynch
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 ....

2004-08-22 Thread Adrian Lynch
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 ....

2004-08-22 Thread Adrian Lynch
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 ....

2004-08-21 Thread Adrian Lynch
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 ....

2004-08-21 Thread Adrian Lynch
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!

2004-08-20 Thread Adrian Lynch
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

2004-08-17 Thread Adrian Lynch
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

2004-08-12 Thread Adrian Lynch
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

2004-08-09 Thread Adrian Lynch



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?

2004-08-09 Thread Adrian Lynch
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

2004-08-09 Thread Adrian Lynch

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

2004-07-05 Thread Adrian Lynch
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

2004-07-05 Thread Adrian Lynch
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

2004-06-26 Thread Adrian Lynch



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

2004-06-23 Thread Adrian Lynch
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

2004-06-18 Thread Adrian Lynch
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

2004-06-18 Thread Adrian Lynch
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() ?

2004-06-15 Thread Adrian Lynch
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

2004-06-10 Thread Adrian Lynch



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

2004-05-28 Thread Adrian Lynch
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!!

2004-05-27 Thread Adrian Lynch
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.

2004-05-27 Thread Adrian Lynch
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 ....

2004-05-23 Thread Adrian Lynch
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?

2004-04-20 Thread Adrian Lynch



"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!

2004-04-20 Thread Adrian Lynch



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

2004-04-06 Thread Adrian Lynch
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

2004-04-06 Thread Adrian Lynch
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

2004-04-01 Thread Adrian Lynch
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

2004-03-30 Thread Adrian Lynch



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

2004-03-16 Thread Adrian Lynch
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

2004-03-16 Thread Adrian Lynch
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....

2004-03-15 Thread Adrian Lynch
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

2004-03-15 Thread Adrian Lynch
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

2004-03-08 Thread Adrian Lynch
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

2004-03-07 Thread Adrian Lynch
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

2004-03-07 Thread Adrian Lynch
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

2004-03-06 Thread Adrian Lynch
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

2004-02-18 Thread Adrian Lynch
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

2004-02-09 Thread Adrian Lynch
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

2004-02-06 Thread Adrian Lynch
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

2004-02-06 Thread Adrian Lynch
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

2004-01-30 Thread Adrian Lynch
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.

2004-01-26 Thread Adrian Lynch
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

2004-01-21 Thread Adrian Lynch
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

2004-01-21 Thread Adrian Lynch
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

2004-01-20 Thread Adrian Lynch
 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 ...

2004-01-20 Thread Adrian Lynch
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

2004-01-15 Thread Adrian Lynch
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?

2004-01-15 Thread Adrian Lynch
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

2004-01-12 Thread Adrian Lynch
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

2004-01-12 Thread Adrian Lynch
 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

2004-01-09 Thread Adrian Lynch
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

2004-01-09 Thread Adrian Lynch
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

2004-01-09 Thread Adrian Lynch
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...

2004-01-08 Thread Adrian Lynch
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

2004-01-08 Thread Adrian Lynch
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

2004-01-08 Thread Adrian Lynch
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

2004-01-07 Thread Adrian Lynch
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)

2004-01-07 Thread Adrian Lynch
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)

2004-01-07 Thread Adrian Lynch
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)

2004-01-07 Thread Adrian Lynch
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

2004-01-07 Thread Adrian Lynch
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)

2004-01-07 Thread Adrian Lynch
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))

2004-01-07 Thread Adrian Lynch
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

2004-01-06 Thread Adrian Lynch
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

2004-01-06 Thread Adrian Lynch
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)

2004-01-06 Thread Adrian Lynch
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

2004-01-05 Thread Adrian Lynch
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

2004-01-05 Thread Adrian Lynch
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

2004-01-05 Thread Adrian Lynch
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

2004-01-05 Thread Adrian Lynch
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

2003-12-31 Thread Adrian Lynch
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

2003-12-12 Thread Adrian Lynch
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

2003-12-11 Thread Adrian Lynch
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?

2003-12-10 Thread Adrian Lynch
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?

2003-12-10 Thread Adrian Lynch
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?

2003-12-10 Thread Adrian Lynch
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)

2003-12-08 Thread Adrian Lynch
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

2003-12-05 Thread Adrian Lynch
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

2003-12-05 Thread Adrian Lynch
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

2003-12-05 Thread Adrian Lynch
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...

2003-11-26 Thread Adrian Lynch
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 don’t 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

2003-11-24 Thread Adrian Lynch
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()

2003-11-23 Thread Adrian Lynch
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()

2003-11-23 Thread Adrian Lynch
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

2003-11-21 Thread Adrian Lynch
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

2003-11-17 Thread Adrian Lynch
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

2003-11-17 Thread Adrian Lynch
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

2003-11-13 Thread Adrian Lynch
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]



  1   2   3   >