RE: Evaluate an Array

2003-11-14 Thread Pascal Peters
cfloop list=#PNResponse# index=pair delimiters=
cfset #ListFirst(pair,'=')# = ListRest(pair,'=')
/cfloop

 
Make sure that the var names are suitable for CF. Maybe it's better to create a structure

 
cfset stResponse = StructNew()
cfloop list=#PNResponse# index=pair delimiters=
cfset stResponse[ListFirst(pair,'=')] = ListRest(pair,'=')
/cfloop

 
Pascal

	-Oorspronkelijk bericht- 
	Van: Robert Redpath [mailto:[EMAIL PROTECTED] 
	Verzonden: do 13/11/2003 21:25 
	Aan: CF-Talk 
	CC: 
	Onderwerp: Evaluate an Array
	
	
	In a credit card processing app I am working on I get a response back from
	the credit card processor in the following form:
	
	PNResponse = RESULT=23PNREF=V50035748010RESPMSG=Invalid account number 
	
	


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFINCLUDE within CFLOOP not working

2003-11-14 Thread Pascal Peters
This works perfectly on a few of my apps (in CF 5, but I don't know why it would break in CFMX). Make sure the file ReportName'.CFM' exists. Use FileExists or try/catch around your include. 
Also, don't use # when it's not neccesary:
cfif ReportName NEQ 
cfset theReport = ReportName'.CFM'

	-Oorspronkelijk bericht- 
	Van: Sam Komolafe [mailto:[EMAIL PROTECTED] 
	Verzonden: do 13/11/2003 20:44 
	Aan: CF-Talk 
	CC: 
	Onderwerp: CFINCLUDE within CFLOOP not working
	
	
	Hi,
	
	How do I dynamically include files using CFINCLUDE within a CFLOOP statement:
	
	This does NOT WORK:
	
	cfloop index=ReportName list =#variables.ALLReports# delimiters = ,
	 cfif #ReportName# NEQ 
	cfset theReport = #ReportName#'.CFM'
	cfinclude template=#theReport#br
	 /cfif
	/cfloop
	
	Help will be appreciated.
	
	Thanks
	
_

	
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFINCLUDE within CFLOOP not working

2003-11-14 Thread Pascal Peters
What is wrong with that line? He has unneaded # in there, but that isn't wrong.
 is the concatenation operator in CF, but not always in sql (can be , +, || and maybe others depending on the db).

 
Pascal

	-Oorspronkelijk bericht- 
	Van: Janine Jakim [mailto:[EMAIL PROTECTED] 
	Verzonden: do 13/11/2003 21:07 
	Aan: CF-Talk 
	CC: 
	Onderwerp: RE: CFINCLUDE within CFLOOP not working
	
	
	My guess there's something wrong with this line
	cfset theReport = #ReportName#'.CFM'
	This isn't a database command so you don't need a  to concatonate the 2
	together.
	


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Sleepy CF

2003-11-14 Thread A.Little
It might to do with the CF templates being compiled. After a template
has been amended (or after CF has been restarted on the server) CF needs
to recompile the template, hence why it can be much slower on the first
'hit' than the subsequent hits.

 
This was a bit of a problem for doing development with the first version
of CFMX, but I thought that 6.1 had speeded up the compiling process.

 
HTH

Alex

	-Original Message-
	From: stas [mailto:[EMAIL PROTECTED] 
	Sent: 13 November 2003 21:27
	To: CF-Talk
	Subject: Sleepy CF
	
	
	I've got a 6.1 box on the LAN and it takes long time to get the
first page
	after I haven't hit the site in a while, the following pages
spool much
	faster. I haven't nailed down the threshold for this behavior,
but is there
	anything I should look at?
	
	
_

	
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Project / Task Manager Collaboration

2003-11-14 Thread Rafael Bleiweiss
Sorry for the insane delay - if you'd caught my frantic emails this past 
week you hopefully understand much of the delay- had to basically rebuild 
my main web server (with 50 domains, 30 databases)... At least now I'm 
running CF MX 6.1 finally!

Anyhow, over the next couple days I'll work to get my task management tool 
onto a site where everyone can mess with it and I'll also start up a 
mailing list for us.So far there's five of us wanting to give it a go!

Just to let you know, I have used this component on projects valued at up 
to $500,000 (www.lawroom.com) and it's done really well by me so far.I'd 
love to see it out in the open source community as a truly robust solution!

Alan

At 03:29 AM 10/31/03, you wrote:
Hi,

I'd be interested in looking at that!

/Hugo


-
Hugo AhleniusE-Mail: [EMAIL PROTECTED]
Project Officer Phone:+46 8 230460
UNEP GRID-ArendalFax:+46 8 230441
Stockholm OfficeMobile:+46 733 467111
WWW: 
 http://www.grida.nohttp://www.grida.no
-



| -Original Message-
| From: Rafael Bleiweiss [mailto:[EMAIL PROTECTED]
| Sent: Friday, October 31, 2003 05:25
| To: CF-Talk
| Subject: Project / Task Manager Collaboration
|
|
| Don't recall who on the list was interested.I've got a
| Project / Task
| manager
| that I'm ready to make available in a collaborative
| open-source initiative.
|
| If you're interested let me know.We'll coordinate.
|
|

--
[
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFINCLUDE within CFLOOP not working

2003-11-14 Thread Pascal Peters
Not true, dynamic includes worked in CF4.5/5 (and probably in CF4, but we can't verify) and they still work in CFMX. We just tested.

 
Pascal

	-Oorspronkelijk bericht- 
	Van: Schuster, Steven [mailto:[EMAIL PROTECTED] 
	Verzonden: do 13/11/2003 21:08 
	Aan: CF-Talk 
	CC: 
	Onderwerp: RE: CFINCLUDE within CFLOOP not working
	
	
	Page processing will not do dynamic includes because the code has to
	compile. It's complicated to explain but it has to do with the order in
	which the page is rendered from both the web server and the cold fusion
	server.
	
	


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Users want to format text

2003-11-14 Thread Hugo Ahlenius
Haven't checked around for a while, but if I remember correctly -- there
are no XHTML compliant ones out there.

If I had a project that required something like this I would go with a
simple textarea and allow the user to use UBB syntax (or similar) I think.

/Hugo


-
Hugo AhleniusE-Mail: [EMAIL PROTECTED]
Project Officer Phone:+46 8 230460
UNEP GRID-ArendalFax:+46 8 230441
Stockholm OfficeMobile:+46 733 467111
 WWW: http://www.grida.no
- 



| -Original Message-
| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
| Sent: Friday, November 14, 2003 00:39
| To: CF-Talk
| Subject: RE: Users want to format text
|
|
| why dont u do it in flash?
| or use a flash editor and i hope he could copy and paste it
| into the right
| place
| this one is fantastic
| http://www.joshdura.com/archives/000163.php
###

This message has been scanned by F-Secure Anti-Virus for Microsoft
Exchange.
For more information, connect to http://www.F-Secure.com/

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Users want to format text

2003-11-14 Thread d.a.collie
Did massimo not do a pretty near XHTML version of a formatted text area?
Can't google it but sure he did

	-Original Message-
	From: Hugo Ahlenius [mailto:[EMAIL PROTECTED] 
	Sent: 14 November 2003 11:07
	To: CF-Talk
	Subject: RE: Users want to format text
	
	
	Haven't checked around for a while, but if I remember correctly
-- there
	are no XHTML compliant ones out there.
	
	If I had a project that required something like this I would go
with a
	simple textarea and allow the user to use UBB syntax (or
similar) I think.
	
	/Hugo
	
	
	-
	Hugo AhleniusE-Mail: [EMAIL PROTECTED]
	Project Officer Phone:+46 8 230460
	UNEP GRID-ArendalFax:+46 8 230441
	Stockholm OfficeMobile:+46 733 467111
	 WWW: http://www.grida.no
	- 
	
	
	
	| -Original Message-
	| From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
	| Sent: Friday, November 14, 2003 00:39
	| To: CF-Talk
	| Subject: RE: Users want to format text
	|
	|
	| why dont u do it in flash?
	| or use a flash editor and i hope he could copy and paste it
	| into the right
	| place
	| this one is fantastic
	| http://www.joshdura.com/archives/000163.php
	###
	
	This message has been scanned by F-Secure Anti-Virus for
Microsoft
	Exchange.
	For more information, connect to http://www.F-Secure.com/
	
_

	
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Bushy
What do you mean store it in a scope and then cache it? How?

--Original Message Text---
From: Raymond Camden
Date: Thu, 13 Nov 2003 11:42:56 -0600

The result of cfdirectory is a query. You can store it in scope you want
and cache it. If you want to store it into a db, you need to convert it
to a string first, which you can do with WDDX, or just save one column.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Users want to format text

2003-11-14 Thread Massimo, Tiziana e Federica
[EMAIL PROTECTED]
 wrote in message
 Did massimo not do a pretty near XHTML version of a formatted text area?

Yes, I did, I focused on outputting clean code removing instead of adding
features (no tables for example).
Usually it's available from the italian CFUG website, right now the server
is moving and the whole stuff is offline, feel free to send me an email if
you need a copy quickly


Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/





 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Jochem van Dieten
There shouldn't be any need to store anything.

Schedule a template to run every day at 1 minute past midnight. Have
that template do a cfdirectory to list the content of the directory.
Then do a QofQ of the dirlist to get all the files with a
datelastmodified that was in the previous day. Email that QofQ to the
person that needs to be informed.

Jochem


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: SQL Generators

2003-11-14 Thread Hugo Ahlenius
Why don't you create the query in the GUI tools in Access, and then
cutnpaste them to your CF code (with minor modifications). I often do
that, to test that they work find.


-
Hugo AhleniusE-Mail: [EMAIL PROTECTED]
Project Officer Phone:+46 8 230460
UNEP GRID-ArendalFax:+46 8 230441
Stockholm OfficeMobile:+46 733 467111
 WWW: http://www.grida.no
- 



| -Original Message-
| From: Brad Roberts [mailto:[EMAIL PROTECTED]
| Sent: Thursday, November 13, 2003 18:34
| To: CF-Talk
| Subject: SQL Generators
|
|
| Anyone know of software (desktop or CF based), that will generate SQL
| (select, insert, update, etc.), by simply pointing to an
| Access database?
| Generating cfqueryparam's would be a bonus.
|
| -Brad
|
|
| 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Com/asp/ldap maybe?

2003-11-14 Thread Ryan Mitchell
Hello

I have the following line in an asp script:
GetObject(IIS://  Application(Server)  /W3SVC)

To connect to iis to get some details from it.
Is there any way of doing the same in coldfusion? Would prefer to do it
natively as opposed to cfhttping an asp script.

Ryan

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Pascal Peters
I think ray means something like

 
cfdirectory ... name=qDir
cfset application.qDir = qDir

 
It is then stored in the application scope and available as long as the application doesn't time-out or you alter the var. Don't forget to lock if you are not on CFMX.

	-Oorspronkelijk bericht- 
	Van: Bushy [mailto:[EMAIL PROTECTED] 
	Verzonden: vr 14/11/2003 12:55 
	Aan: CF-Talk 
	CC: 
	Onderwerp: RE: Changes in a Directory CFDIRECTORY
	
	
	What do you mean store it in a scope and then cache it? How?
	
	--Original Message Text---
	From: Raymond Camden
	Date: Thu, 13 Nov 2003 11:42:56 -0600
	
	The result of cfdirectory is a query. You can store it in scope you want
	and cache it. If you want to store it into a db, you need to convert it
	to a string first, which you can do with WDDX, or just save one column.
	
	
_

	
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Better method for counting records?

2003-11-14 Thread rob.stokes
Hi all,

I've got a main cfloop looping through a set of records - say 15 at a time - and within that loop I've got 3 SQL queries performing a count on how many associated records there are for that particular record in the main loop. Kind of like a forum index page to give how many threads, posts etc there are for each forum.

i.e. (rough code to give you an idea of what I mean):

cfquery name=mainquery
select * from tablemain
/cfquery

cfloop query=mainquery startrow=1 endrow=15

td#SectionName#/td

cfquery name=countquery1
select count(case_id) As ThisCount1 from table1 where x = '#mainquery.SectionName#'
/cfquery
td#countquery1.ThisCount1#/td

cfquery name=countquery2
select count(case_id) As ThisCount2 from table2 where x = '#mainquery.SectionName#'
/cfquery
td#countquery2.ThisCount2#/td

cfquery name=countquery3
select count(case_id) As ThisCount3 from table3 where x = '#mainquery.SectionName#'
/cfquery
td#countquery3.ThisCount3#/td

/cfloop

My question is, is there a more efficient method for doing this kind of thing? As the tables I am accessing have 1,000s of rows - possibly millions - the page takes a significant amount of time finish processing. I could remove the record counts altogether, but it's preferable for it to remain.

Cheers,
Rob
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX 6.0 on Red Hat ES 3.0 install errors

2003-11-14 Thread Debbie Dickerson
We've seen the first error, and a TechNote for the issue is currently going through the review process. It shouldn't affect the installation process though.

 
The second error isn't expected however. Is it possible you don't have enough disk space in /tmp for the install? If it wasn't able to extract all the files, you could see an error like this. 450MB is the amount of free space needed for the installation.
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro5.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro5.htm 
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro6.htm http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/intro6.htm 

-Original Message-
From: Eric Parker [mailto:[EMAIL PROTECTED] 
Sent: Thursday, November 13, 2003 8:43 PM
To: CF-Talk
Subject: CFMX 6.0 on Red Hat ES 3.0 install errors

Hello,

I am trying to install CFMX on Red Hat ES 3.0

I get the following error message:

[EMAIL PROTECTED] data]# ./coldfusion-60-linux-en.bin 
Preparing to install...
tail: `-1' option is obsolete; use `-n 1'
Try `tail --help' for more information.
./coldfusion-60-linux-en.bin: line 328: [: `)' expected, found -z WARNING! The amount of /tmp disk space required and/or available could not be determined.The installation will be attempted anyway. Extracting the JRE from the installer archive... Unpacking the JRE... Extracting the installation resources from the installer archive... Configuring the installer for this system's environment...

Launching installer...

head: `-1' option is obsolete; use `-n 1'
Try `head --help' for more information.
/tmp/install.dir.3579/Linux/resource/jre/bin/i386/native_threads/java: error while loading shared libraries: libjvm.so: cannot open shared object file: No such file or directory 
[EMAIL PROTECTED] data]# 

any help would be greatly appreciated.

Eric 
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Com/asp/ldap maybe?

2003-11-14 Thread Jochem van Dieten
Ryan Mitchell said:

 I have the following line in an asp script:
 GetObject(IIS://  Application(Server)  /W3SVC)

 To connect to iis to get some details from it.
 Is there any way of doing the same in coldfusion? Would prefer to do
 it natively as opposed to cfhttping an asp script.

I don't think you can do it without going through COM or some executable.

I use mdutil.exe (Option pack or Support Tools) called with cfexecute
myself. Using a command line tool from CF can be a bit hackish, but it
allows for a uniform codebase when I am logged in through OpenSSH and
I only have a command line.
Syntax will be something like: mdutil enum W3CSVC/1/ and you can drill
down from there.

Jochem


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Bushy
Is it better to put store it in a application scope or session variable? Is either one fast than the other? Whats the pros and cons?

--Original Message Text---
From: Pascal Peters
Date: Fri, 14 Nov 2003 13:36:40 +0100

I think ray means something like

cfdirectory ... name=qDir
cfset application.qDir = qDir

It is then stored in the application scope and available as long as the application doesn't time-out or you alter the var. Don't forget to lock if you are not on CFMX.

-Oorspronkelijk bericht- 
Van: Bushy [mailto:[EMAIL PROTECTED] 
Verzonden: vr 14/11/2003 12:55 
Aan: CF-Talk 
CC: 
Onderwerp: RE: Changes in a Directory CFDIRECTORY

What do you mean store it in a scope and then cache it? How?

--Original Message Text---
From: Raymond Camden
Date: Thu, 13 Nov 2003 11:42:56 -0600

The result of cfdirectory is a query. You can store it in scope you want
and cache it. If you want to store it into a db, you need to convert it
to a string first, which you can do with WDDX, or just save one column.

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




When sending a message through CFMail

2003-11-14 Thread Mark Leder
Is the cfmailpart tag required if I know I'm only going to send the
message as plain text?

Thanks, Mark 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CF4.5, CFHTTP, SSL.... anybody been able to get it to work?

2003-11-14 Thread d.a.collie
Yeah sorry, diff timezone...

 
matt  I'm sure you've thought of this, but you remembered to specify
the port
matt  value, right?

 
It's been tried with proxyPort and proxyServer in the cfhttp tag and
doesn't seem to make any diff
We can browse to the script

matt As I recall, cfhttp was pretty screwed up in early 4.5 releases,
and got
matt  a lot of attention in the service packs.You're up to .1sp2 on
that 4.5
matt  box, right?

 
It's not really a machine under my control, more helping out another
dept... 

 
Thing is we can get it to work on the CF4.5 Dev box without issue, it's
just the CF4.5 Prod box that is keeling over systems say there are
no rules in the DMZ (both servers in same DMZ) that would stop it, the
other dept say they have no other config settings that I can't think
about that would stop this from working on the Prod box grrr and
it's friday

 
Cheers for the reply

 
-dc

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Better method for counting records?

2003-11-14 Thread Jochem van Dieten

 cfquery name=mainquery
 select * from tablemain
 /cfquery

 cfloop query=mainquery startrow=1 endrow=15

cfquery name=countquery1
select count(case_id) As ThisCount1 from table1 where x =
 '#mainquery.SectionName#' /cfquery

cfquery name=countquery2
select count(case_id) As ThisCount2 from table2 where x =
 '#mainquery.SectionName#' /cfquery

cfquery name=countquery3
select count(case_id) As ThisCount3 from table3 where x =
 '#mainquery.SectionName#' /cfquery

 /cfloop

SELECT
 tm.SectionName,
 count(t1.case_id) AS count1,
 count(t2.case_id) AS count2,
 count(t3.case_id) AS count3
FROM
 tablemain tm
 INNER JOIN table1 t1 ON tm.SectionName = t1.x
 INNER JOIN table2 t2 ON tm.SectionName = t2.x
 INNER JOIN table3 t3 ON tm.SectionName = t3.x
GROUP BY
 tm.SectionName

Whether this is actually faster depends on indexes and how smart your
DBMS is. It might be more efficient to split it in 3 queries, one for
each of the table you are joining against.

Jochem


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Better method for counting records?

2003-11-14 Thread I-Lin Kuo
try this:

cfquery name=countquery1
select count(case_id) As ThisCount1 from table1
left outer join tablemain on tablemain.sectionname =
table1.x
group by sectionname
order by sectionname
/cfquery
cfquery name=countquery2
select count(case_id) As ThisCount2 from table2
left outer join tablemain on tablemain.sectionname =
table1.x
group by sectionname
order by sectionname
/cfquery
cfquery name=countquery3
select count(case_id) As ThisCount3 from table2
left outer join tablemain on tablemain.sectionname =
table1.x
group by sectionname
order by sectionname
/cfquery

cfoutput query=countquery1
#countquery1.thiscount1[currentrow]#
#countquery2.thiscount2[currentrow]#
#countquery3.thiscount3[currentrow]#
/cfoutput
--- [EMAIL PROTECTED] wrote:
 Hi all,
 
 I've got a main cfloop looping through a set of
 records - say 15 at a time - and within that loop
 I've got 3 SQL queries performing a count on how
 many associated records there are for that
 particular record in the main loop. Kind of like a
 forum index page to give how many threads, posts etc
 there are for each forum.
 
 i.e. (rough code to give you an idea of what I
 mean):
 
 cfquery name=mainquery
 select * from tablemain
 /cfquery
 
 cfloop query=mainquery startrow=1 endrow=15
 
td#SectionName#/td
 
cfquery name=countquery1
select count(case_id) As ThisCount1 from table1
 where x = '#mainquery.SectionName#'
/cfquery
td#countquery1.ThisCount1#/td
 
cfquery name=countquery2
select count(case_id) As ThisCount2 from table2
 where x = '#mainquery.SectionName#'
/cfquery
td#countquery2.ThisCount2#/td
 
cfquery name=countquery3
select count(case_id) As ThisCount3 from table3
 where x = '#mainquery.SectionName#'
/cfquery
td#countquery3.ThisCount3#/td
 
 /cfloop
 
 My question is, is there a more efficient method for
 doing this kind of thing? As the tables I am
 accessing have 1,000s of rows - possibly millions -
 the page takes a significant amount of time finish
 processing. I could remove the record counts
 altogether, but it's preferable for it to remain.
 
 Cheers,
 Rob


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Better method for counting records?

2003-11-14 Thread Pascal Peters
Try avoiding queries in loops. You can do the query before the loop using group by and in

 
cfquery name=countquery1
select count(case_id) As ThisCount1, x 
from table1 
where x IN (cfqueryparam cfsqltype=CF_SQL_VARCHAR value=#SectionNameList# list=yes)
GROUP BY x
/cfquery

 
You have to build your SectionNameList first from your main query. You can store the results in a structure to easily display later
cfset stCounter1 = StructNew()
cfloop query=countquery1
cfset stCounter1[countquery1.x] = countquery1.ThisCount1
/cfloop

 
If the counts don't change according to the user, you may consider storing them in the main table to savea query. When you add or delete an item, update the count in the main table. This could save a lot of time on display.

	-Oorspronkelijk bericht- 
	Van: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
	Verzonden: vr 14/11/2003 13:41 
	Aan: CF-Talk 
	CC: 
	Onderwerp: Better method for counting records?
	
	
	Hi all,
	
	I've got a main cfloop looping through a set of records - say 15 at a time - and within that loop I've got 3 SQL queries performing a count on how many associated records there are for that particular record in the main loop. Kind of like a forum index page to give how many threads, posts etc there are for each forum.
	
	i.e. (rough code to give you an idea of what I mean):
	
	cfquery name=mainquery
	select * from tablemain
	/cfquery
	
	cfloop query=mainquery startrow=1 endrow=15
	
	td#SectionName#/td
	
	cfquery name=countquery1
	select count(case_id) As ThisCount1 from table1 where x = '#mainquery.SectionName#'
	/cfquery
	td#countquery1.ThisCount1#/td
	
	cfquery name=countquery2
	select count(case_id) As ThisCount2 from table2 where x = '#mainquery.SectionName#'
	/cfquery
	td#countquery2.ThisCount2#/td
	
	cfquery name=countquery3
	select count(case_id) As ThisCount3 from table3 where x = '#mainquery.SectionName#'
	/cfquery
	td#countquery3.ThisCount3#/td
	
	/cfloop
	
	My question is, is there a more efficient method for doing this kind of thing? As the tables I am accessing have 1,000s of rows - possibly millions - the page takes a significant amount of time finish processing. I could remove the record counts altogether, but it's preferable for it to remain.
	
	Cheers,
	Rob 
_

	
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Pascal Peters
Depends on what you need:
SESSION: 1 user, 1 application, short timeout
APPLICATION: All users, 1 application, longer timeout
SERVER: All users, all applications, no timeout (not recommended to write in this scope)

 
All these shared scopes are destroyed if the CFServer is restarted.
All need locking before CFMX. In CFMX, only lock to avoid race conditions.

	-Oorspronkelijk bericht- 
	Van: Bushy [mailto:[EMAIL PROTECTED] 
	Verzonden: vr 14/11/2003 13:52 
	Aan: CF-Talk 
	CC: 
	Onderwerp: RE: Changes in a Directory CFDIRECTORY
	
	
	Is it better to put store it in a application scope or session variable? Is either one fast than the other? Whats the pros and cons?
	
	


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Bushy
I see. So I have a web interface that will be accessed by 50+ users. A treeview listing of directories allowing editing/deleteing files etc.

So I should be using an APPLICATION scope then? Currently I have all SESSION scopes.

--Original Message Text---
From: Pascal Peters
Date: Fri, 14 Nov 2003 14:06:24 +0100

Depends on what you need:
SESSION: 1 user, 1 application, short timeout
APPLICATION: All users, 1 application, longer timeout
SERVER: All users, all applications, no timeout (not recommended to write in this scope)

All these shared scopes are destroyed if the CFServer is restarted.
All need locking before CFMX. In CFMX, only lock to avoid race conditions.

-Oorspronkelijk bericht- 
Van: Bushy [mailto:[EMAIL PROTECTED] 
Verzonden: vr 14/11/2003 13:52 
Aan: CF-Talk 
CC: 
Onderwerp: RE: Changes in a Directory CFDIRECTORY

Is it better to put store it in a application scope or session variable? Is either one fast than the other? Whats the pros and cons?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Bushy
Forgot to ask...why not use a SERVER scope. Why is it not recommended to write to this scope? Why have it then?

--Original Message Text---
From: Pascal Peters
Date: Fri, 14 Nov 2003 14:06:24 +0100

Depends on what you need:
SESSION: 1 user, 1 application, short timeout
APPLICATION: All users, 1 application, longer timeout
SERVER: All users, all applications, no timeout (not recommended to write in this scope)

All these shared scopes are destroyed if the CFServer is restarted.
All need locking before CFMX. In CFMX, only lock to avoid race conditions.

-Oorspronkelijk bericht- 
Van: Bushy [mailto:[EMAIL PROTECTED] 
Verzonden: vr 14/11/2003 13:52 
Aan: CF-Talk 
CC: 
Onderwerp: RE: Changes in a Directory CFDIRECTORY

Is it better to put store it in a application scope or session variable? Is either one fast than the other? Whats the pros and cons?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Com/asp/ldap maybe?

2003-11-14 Thread Dave Watts
 I have the following line in an asp script:
 GetObject(IIS://  Application(Server)  /W3SVC)
 
 To connect to iis to get some details from it.
 Is there any way of doing the same in coldfusion? Would 
 prefer to do it natively as opposed to cfhttping an asp 
 script.

You can't easily use ADSI (which is what this is) directly from CF - even
with CF 5. What I've done before is to write COM wrappers for ADSI
functionality in Windows Script Components, and called those. If you're
using CFMX, you might find better solutions by searching for ADSI and Java.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Pascal Peters
There is some default info in the server scope. I'm not sure about CFMX, but in CF5 you couldn't delete server variables. So they would exist untill you restarted the server. How often do you need a var in ALL your apps, for ALL your users, ALL the time?

	-Oorspronkelijk bericht- 
	Van: Bushy [mailto:[EMAIL PROTECTED] 
	Verzonden: vr 14/11/2003 14:13 
	Aan: CF-Talk 
	CC: 
	Onderwerp: RE: Changes in a Directory CFDIRECTORY
	
	
	Forgot to ask...why not use a SERVER scope. Why is it not recommended to write to this scope? Why have it then?
	
	


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




OT - Win 2000 boot

2003-11-14 Thread Robert Orlini
In NT 4.0 I was able to edit the boot.ini file and change the bootup menu. How does one do this in Windows 2000? I don't see a boot.ini file and can't find any reference to changing it in the Control Panel.

Thx.

Robert O.
HWW
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Pascal Peters
If the directory listing is the same for all users, you can store it in the application scope. Don't forget to refresh the variable if you add/delete/rename a file.
You can only store it in the session scope if users can only see their own files. Otherwise you would get in trouble if two users are logged in and one of them deletes a file. How would the other user be aware of that? The file would still exist in his session var.
If you are pre-CFMX, you have to be carefull not to single-thread your application using the application scope in the Application.cfm

	-Oorspronkelijk bericht- 
	Van: Bushy [mailto:[EMAIL PROTECTED] 
	Verzonden: vr 14/11/2003 14:11 
	Aan: CF-Talk 
	CC: 
	Onderwerp: RE: Changes in a Directory CFDIRECTORY
	
	
	I see. So I have a web interface that will be accessed by 50+ users. A treeview listing of directories allowing editing/deleteing files etc.
	
	So I should be using an APPLICATION scope then? Currently I have all SESSION scopes.
	


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Cookies...

2003-11-14 Thread Hassan Arteaga Rodríguez
Hi Dave:

 
ASP application write in cookies variables without any trouble. 
And yes in ASP and CF u can write/read cookies as

 
ASP:
Response.Cookies.(User).nick=hassan

 
CF MX
CFCookie name=user.nick value=hassan

 
Regards

 
--
M.Sc. Hassan Arteaga Rodrguez.
Microsoft Certified System Engineer.
Grupo de Desarrollo. DIGI
COPEXTEL, S.A
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Bushy
--Original Message Text---
From: Pascal Peters
Date: Fri, 14 Nov 2003 14:51:45 +0100

If the directory listing is the same for all users, you can store it in the application scope. 

Directory listings would change. Not all users would be accessing the same data in the same directories. Can I still use an APPLICATION scope?

Don't forget to refresh the variable if you add/delete/rename a file.
You can only store it in the session scope if users can only see their own files. Otherwise you would get in trouble if two users are logged in and one of them deletes a file. How would the other user 
be aware of that? The file would still exist in his session var.

If you are pre-CFMX, 

Yes...CF5

you have to be carefull not to single-thread your application using the application scope in the Application.cfm

I'm not sure what you mean by that. Could you give an example?

-Oorspronkelijk bericht- 
Van: Bushy [mailto:[EMAIL PROTECTED] 
Verzonden: vr 14/11/2003 14:11 
Aan: CF-Talk 
CC: 
Onderwerp: RE: Changes in a Directory CFDIRECTORY

I see. So I have a web interface that will be accessed by 50+ users. A treeview listing of directories allowing editing/deleteing files etc.

So I should be using an APPLICATION scope then? Currently I have all SESSION scopes.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Manually clearing CF cache

2003-11-14 Thread Austin Govella
Can I manually delete the files i the cache folder without screwing 
anything up?

CF won't recompile a template I've changed, so the website keeps seeing 
the previous, now incorrect file.

--
Austin

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Com/asp/ldap maybe?

2003-11-14 Thread Ryan Mitchell
Aaah java, should have thought of that!
Thanks for pointing me in the right direction :)

On 14/11/03 1:45 pm, Dave Watts [EMAIL PROTECTED] wrote:

  I have the following line in an asp script:
  GetObject(IIS://  Application(Server)  /W3SVC)
  
  To connect to iis to get some details from it.
  Is there any way of doing the same in coldfusion? Would
  prefer to do it natively as opposed to cfhttping an asp
  script.
 
 You can't easily use ADSI (which is what this is) directly from CF - even
 with CF 5. What I've done before is to write COM wrappers for ADSI
 functionality in Windows Script Components, and called those. If you're
 using CFMX, you might find better solutions by searching for ADSI and Java.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 voice: (202) 797-5496
 fax: (202) 797-5444
 
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:SOT: Internal/Intranet Search Engines - What to ask the sales critters

2003-11-14 Thread Jeremy Brodie
Larry,

Some of the critical questions to help you in your search.

1) Do you need to search locally from a CD/DVD or from a server?
2) In what file format is the manual (PDF, word docs, etc)
3) What will you use as your user interface for searching the manual (flash, HTML, etc)?
4) What is your budget?
5) Are there any components of the manual located on the server (diagrams, videos, and so on)?
6) If using a CD, what platforms will the target audiance use?

If you're searching directly from a CD/DVD then you'll need to bundle DT search (the others require a server) and create an interface that interacts with the search program either using Flash or Java Swing (assuming not everyone has Windows). 

Jeremy Brodie
Intelix
an Edgewater Technology Solutions Company

web: http://www.edgewater.com
phone:(703) 815-2500
nasdaq symbol: EDGE


Thanks Jeremy. I don't think that this is really for a CMS system rather 
for an on-line manual (IETM's Interactive Electronic Technical Manuals). 
But I agree with your point regarding the database searches.

As for the location of the data, from what I understand its going to be 
on the corporate servers and local hard drives.

regards,
larry

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT - Win 2000 boot

2003-11-14 Thread John Beynon
START  RUN msconfig.exe and run it,

Jb.

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED] 
Sent: 14 November 2003 13:45
To: CF-Talk
Subject: OT - Win 2000 boot

In NT 4.0 I was able to edit the boot.ini file and change the bootup menu.
How does one do this in Windows 2000? I don't see a boot.ini file and can't
find any reference to changing it in the Control Panel.

Thx.

Robert O.
HWW

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT - Win 2000 boot

2003-11-14 Thread Josh Remus
Also, just FYI: boot.ini exists on 2k/xp, it's just a hidden file.Also,
you can typically get to these settings through the System control panel.
Usually under Advanced / Startup-Recovery.
-Original Message-
From: John Beynon [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 9:30 AM
To: CF-Talk
Subject: RE: OT - Win 2000 boot

START  RUN msconfig.exe and run it,

Jb.

-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]
Sent: 14 November 2003 13:45
To: CF-Talk
Subject: OT - Win 2000 boot

In NT 4.0 I was able to edit the boot.ini file and change the bootup menu.
How does one do this in Windows 2000? I don't see a boot.ini file and
can't
find any reference to changing it in the Control Panel.

Thx.

Robert O.
HWW


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Manually clearing CF cache

2003-11-14 Thread Dave Watts
 Can I manually delete the files i the cache folder without 
 screwing anything up?

Yes. I think Matt Liotta posted a script on his blog (http://devilm.com/ ?)
you can use to determine exactly which file you want to delete, if you'd
rather not delete them all.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT - Win 2000 boot

2003-11-14 Thread Dave Watts
 In NT 4.0 I was able to edit the boot.ini file and change the 
 bootup menu. How does one do this in Windows 2000? I don't 
 see a boot.ini file and can't find any reference to changing 
 it in the Control Panel.

It's on the root of your boot partition, although it's often hidden and
read-only by default. You can just remove those attributes with attrib,
edit, then reset the attributes.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




UNC names and Mapped Drives for CFDIRECTORY

2003-11-14 Thread Mickael
Hello All,

Does CFDIRECTORY work with Mapped drive letters?I am trying to view Network Share and having now luck.I went into the coldfusion service and checked off log on as and gave it a name with rights on the machine.Also I tried setting up a mapped drive and tried doing a list on my mapped letter no luck either?

Any ideas?

Thanks


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: UNC names and Mapped Drives for CFDIRECTORY

2003-11-14 Thread Dave Watts
 Does CFDIRECTORY work with Mapped drive letters?I am trying 
 to view Network Share and having now luck.I went into the 
 coldfusion service and checked off log on as and gave it a 
 name with rights on the machine.Also I tried setting up a 
 mapped drive and tried doing a list on my mapped letter no 
 luck either?

The mapped drive would have to be created using that user account, and it
would also have to be persistent. I'd recommend just using the UNC path, if
that works for you.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Changes in a Directory CFDIRECTORY

2003-11-14 Thread Pascal Peters
I have no idea what your app does, but you could cache the dir structure in the application scope and filter it according to the user that is logged. If two users can't manipulate the same file, I would use session scope.

 
Single treaded app in cf5:
Application.cfm:
= = = = = = =
cflock scope=application timeout=20
cfset application.var = 
/cflock

 
By locking the application scope, every tread has to wait for the previous tread to release the lock. As all users share the application scope and all requests execute application.cfm, the result is a single-treaded app. This may work fine in dev (only one or two users), but have a huge performance impact in production.

	-Oorspronkelijk bericht- 
	Van: Bushy [mailto:[EMAIL PROTECTED] 
	Verzonden: vr 14/11/2003 15:03 
	Aan: CF-Talk 
	CC: 
	Onderwerp: RE: Changes in a Directory CFDIRECTORY
	
	
	--Original Message Text---
	From: Pascal Peters
	Date: Fri, 14 Nov 2003 14:51:45 +0100
	
	If the directory listing is the same for all users, you can store it in the application scope. 
	
	Directory listings would change. Not all users would be accessing the same data in the same directories. Can I still use an APPLICATION scope?
	
	you have to be carefull not to single-thread your application using the application scope in the Application.cfm
	
	I'm not sure what you mean by that. Could you give an example?
	
	


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: UNC names and Mapped Drives for CFDIRECTORY

2003-11-14 Thread Pascal Peters
I think it's possible, but you have to run the CF service as a user with rights to access the network and create the mapped drive using that account.

	-Oorspronkelijk bericht- 
	Van: Mickael [mailto:[EMAIL PROTECTED] 
	Verzonden: vr 14/11/2003 15:37 
	Aan: CF-Talk 
	CC: 
	Onderwerp: UNC names and Mapped Drives for CFDIRECTORY
	
	
	Hello All,
	
	Does CFDIRECTORY work with Mapped drive letters?I am trying to view Network Share and having now luck


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: When sending a message through CFMail

2003-11-14 Thread Ubqtous
Mark,

On 11/14/2003 at 07:53, you wrote:

ML Is the cfmailpart tag required if I know I'm only going to send
ML the message as plain text?

Not normally. You should only need that for multi-part messages or if
you need to use specific character encoding (utf-8, iso-8859-1, etc).

~ Ubqtous ~

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: When sending a message through CFMail

2003-11-14 Thread Jillian Carroll
As long as your message isn't multipart, you can leave it out.

 
--
Jillian

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED] 
Sent: November 14, 2003 6:54 AM
To: CF-Talk
Subject: When sending a message through CFMail

Is the cfmailpart tag required if I know I'm only going to send the
message as plain text?

Thanks, Mark 

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: UNC names and Mapped Drives for CFDIRECTORY

2003-11-14 Thread Mickael
I have no problem using the UNC path, I am not able to view any of the files that are there.I just get an empty directory, and there is something in the directory.Is there a way to output debugging info for cfdirectory, like if there was a permission issue?
- Original Message - 
From: Dave Watts 
To: CF-Talk 
Sent: Friday, November 14, 2003 9:46 AM
Subject: RE: UNC names and Mapped Drives for CFDIRECTORY

 Does CFDIRECTORY work with Mapped drive letters?I am trying 
 to view Network Share and having now luck.I went into the 
 coldfusion service and checked off log on as and gave it a 
 name with rights on the machine.Also I tried setting up a 
 mapped drive and tried doing a list on my mapped letter no 
 luck either?

The mapped drive would have to be created using that user account, and it
would also have to be persistent. I'd recommend just using the UNC path, if
that works for you.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Is cflog thread-safe? [cf5]

2003-11-14 Thread M C
Is cflog in ColdFusion 5 thread-safe, or does it need to be locked like cffile?

Thank you,
Mike Chabot
[EMAIL PROTECTED]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Manually clearing CF cache

2003-11-14 Thread Nathan Strutz
Actually, I made a udf for this...
http://www.cflib.org/udf.cfm?ID=895
although I haven't had a need for it since the 6.1 upgrade came out.

-nathan strutz

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 7:43 AM
To: CF-Talk
Subject: RE: Manually clearing CF cache

 Can I manually delete the files i the cache folder without
 screwing anything up?

Yes. I think Matt Liotta posted a script on his blog (http://devilm.com/
?)
you can use to determine exactly which file you want to delete, if you'd
rather not delete them all.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: OT - Win 2000 boot

2003-11-14 Thread Robert Orlini
Thanks all for the help.

 
Robert O.

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 9:44 AM
To: CF-Talk
Subject: RE: OT - Win 2000 boot

 In NT 4.0 I was able to edit the boot.ini file and change the 
 bootup menu. How does one do this in Windows 2000? I don't 
 see a boot.ini file and can't find any reference to changing 
 it in the Control Panel.

It's on the root of your boot partition, although it's often hidden and
read-only by default. You can just remove those attributes with attrib,
edit, then reset the attributes.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Evaluate an Array

2003-11-14 Thread Robert Redpath
Thanks Pascal - worked like a charm! 

-Original Message-
From: Pascal Peters [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 3:23 AM
To: CF-Talk
Subject: RE: Evaluate an Array

cfloop list=#PNResponse# index=pair delimiters=
cfset #ListFirst(pair,'=')# = ListRest(pair,'=')
/cfloop

Make sure that the var names are suitable for CF. Maybe it's better to
create a structure

cfset stResponse = StructNew()
cfloop list=#PNResponse# index=pair delimiters=
cfset stResponse[ListFirst(pair,'=')] = ListRest(pair,'=')
/cfloop

Pascal

-Oorspronkelijk bericht- 
Van: Robert Redpath [mailto:[EMAIL PROTECTED] 
Verzonden: do 13/11/2003 21:25 
Aan: CF-Talk 
CC: 
Onderwerp: Evaluate an Array

In a credit card processing app I am working on I get a response back from
the credit card processor in the following form:

PNResponse = RESULT=23PNREF=V50035748010RESPMSG=Invalid account number 


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOT Hosting Options? Repost

2003-11-14 Thread [EMAIL PROTECTED]
I posted this on a slow Sunday  got no response -- so I'll try again:

have been away from CFMX for a couple of months, so I'd like to get
the latest input from the experts.

I want to set up several web sites to memorialize family members who
have passed on  -- wife, sister, mother, father.

Also to provide web sites for my grandchildren.

I want this to run on CFMX/JRun Linux, Unix or Mac OS X

Almost any db is acceptable (dynamic text, photo, music storage).

I could host this myself or go to a reasonably-priced, reliable shared
service.

I will need to have 20-30 domain names -- so registration cost is a
consideration too,

One shared host (WebCom) offers CFMX, UNIX... and $6.95 domain
registration.

WebCom brings bittersweet memories -- hosted my first Perl (subset)
shopping cart there.

My ideal would be a Mac OS X hosted site CFMX For J2EE / JRun / Sybase,
Oracle. or SQL-Server.

I know there is no Official CFMX product for Mac OS X. but I could
purchase the Developer License and run it myself.

Does MM still offer a Multiuser CFMX/JRun developer license?  I went to
the MM site but could not find this.

Any input will be greatly appreciated.

TIA

Dick


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Question from a beginner

2003-11-14 Thread John Munyan
I have a website describing hikes I have taken.I have recently added a
charting page to chart much of the data I collect such as Region,
Recommendation, Difficulty which works fine (since these values are
essentially categorical ones with few values 5-6).However I also am
trying to chart Time, Elevation gain, and Distance hiked.Elevation
Gain in particular charts poorly as hardly any of the 60 hikes had the
same gain.

What I would like to do is when I am charting Time, Elevation gain, and
Distance I would like to categorized the output into just a few.For
Elevation it would probably be best to use 500ft increments.0-500,
500-1000, 1000-1500 and so on. 

The current query I am using for the cfchart call is:

SELECT #ChartMe#, count(*) as

Chart_count

FROM hike

Where #ChartMe# is not null

group by #ChartMe#

order by #ChartMe#; 

Does anyone have an idea of how this query might be amended or otherwise
rewritten to allow the above categorization to happen rather than just
counting discreet instances?I have tried searching the web for quite a
while to no avail, and was thinking this group might have some clues.
Even good sql sites, groups, or book recommendations would be very
welcomed.

Thanks sincerely,

John






 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Oracle CLOBS SQL

2003-11-14 Thread d.a.collie
Hi All,

Got a table where the text is held in clob's

I need to extract all CLOBS where there is a URL contained within them.

Can I do this in SQL (Oracle specific SQL ok by me) or would I have to
do it in Co,d Fusion, looping and doing a REFind on each individual
clob?

Cheers,

-dc

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Question from a beginner

2003-11-14 Thread Jerry Johnson
John,

Are your elevation value stored in feet units?

If so, you can set a new variable:

cfset chart_me_calc=integer(elevation/500)
(the actual syntax may be different for your db.)

Then:
cfset chart_me=elevation
cfparam name=chart_me_code default=#chart_me#

select #chart_me_calc# as #chart_me#, count(*) as Chart_count

Post the url when you are done so we can check it out.

Jerry Johnson

 [EMAIL PROTECTED] 11/14/03 11:04AM 
I have a website describing hikes I have taken.I have recently added a
charting page to chart much of the data I collect such as Region,
Recommendation, Difficulty which works fine (since these values are
essentially categorical ones with few values 5-6).However I also am
trying to chart Time, Elevation gain, and Distance hiked.Elevation
Gain in particular charts poorly as hardly any of the 60 hikes had the
same gain.

What I would like to do is when I am charting Time, Elevation gain, and
Distance I would like to categorized the output into just a few.For
Elevation it would probably be best to use 500ft increments.0-500,
500-1000, 1000-1500 and so on. 

The current query I am using for the cfchart call is:

SELECT #ChartMe#, count(*) as

Chart_count

FROM hike

Where #ChartMe# is not null

group by #ChartMe#

order by #ChartMe#; 

Does anyone have an idea of how this query might be amended or otherwise
rewritten to allow the above categorization to happen rather than just
counting discreet instances?I have tried searching the web for quite a
while to no avail, and was thinking this group might have some clues.
Even good sql sites, groups, or book recommendations would be very
welcomed.

Thanks sincerely,

John






 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




What is wrong w/ this cfscript block of code?

2003-11-14 Thread Che Vilnonis
Any help would be appreciated here...

In the end, I would like 4 dynamically named variables with
random values. What am I missing?

cfscript
	// Convert the product ids to a comma delimited list.
	PIDList = ValueList(getAllInCat.Product_ID);

	// Loop through 4 times and create 4 dynamically name vars with random
values.
	for(i=1; i LTE 4; i = i + 1)
		{
		// Grab a random number based on the number of products available.
		RandValue#i# = RandRange(1, ListLen(PIDList));
		// Get the Product_ID based on the random number.
		RandRecord#i# = ListGetAt(PIDList, RandValue#i#);
		// Remove the first Random value from the list, so it is not selected
twice.
		PIDList = ListDeleteAt(PIDList, RandValue#i#);
		}
/cfscript

Thanks, Ch

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Oracle CLOBS SQL

2003-11-14 Thread Matt Robertson
A cfquery/cfloop would be pretty simple to write.Sounds like a tall
order for a single regex, though.Seems like you'd need another loop
over the output text in case of multiple urls.I'm not much with
regexes though, so I could be wrong.


 Matt Robertson [EMAIL PROTECTED] 
 MSB Designs, Inc.http://mysecretbase.com


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: What is wrong w/ this cfscript block of code?

2003-11-14 Thread Stephen Moretti
Che,

I think you probably need a SetVariable for this...

 RandValue#i# = RandRange(1, ListLen(PIDList));
 
SetVariable(RandValuei,RandRange(1, ListLen(PIDList));

 RandRecord#i# = ListGetAt(PIDList, RandValue#i#);
 
SetVariable(RandRecordi,RandRange(1, ListLen(PIDList));

And perhaps use a struct reference for this

 PIDList = ListDeleteAt(PIDList, RandValue#i#);
 
PIDList = ListDeleteAt(PIDList,variables[RandValuei]);

Hope this helps

Regards

Stephen

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Oracle CLOBS SQL

2003-11-14 Thread d.a.collie
Hmmm thought it would be difficult to do in SQL

 
I don't need to actually find the URL's in the text, just need to
identify that there is one or more so a simple regexp would do for
me it's just a flag to say... hey this block of text needs to be
checked

 
Don't want the users putting in undesirable links and want a quick way
to check them;-)

 
-dc

	-Original Message-
	From: Matt Robertson [mailto:[EMAIL PROTECTED] 
	Sent: 14 November 2003 16:43
	To: CF-Talk
	Subject: RE: Oracle CLOBS SQL
	
	
	A cfquery/cfloop would be pretty simple to write.Sounds like a
tall
	order for a single regex, though.Seems like you'd need another
loop
	over the output text in case of multiple urls.I'm not much
with
	regexes though, so I could be wrong.
	
	
	Matt Robertson [EMAIL PROTECTED] 
	MSB Designs, Inc.http://mysecretbase.com
	
	
_

	
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Oracle CLOBS SQL

2003-11-14 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote:
 
 I need to extract all CLOBS where there is a URL contained within them.
 
 Can I do this in SQL (Oracle specific SQL ok by me) or would I have to
 do it in Co,d Fusion, looping and doing a REFind on each individual
 clob?

SELECT *
FROM table
WHERE whatever LIKE '%http://%'

Jochem

-- 
Who needs virtual reality
if you can just dream?
- Loesje


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: What is wrong w/ this cfscript block of code?

2003-11-14 Thread Ubqtous
Che,

On 11/14/2003 at 11:33, you wrote:

CV In the end, I would like 4 dynamically named variables with random
CV values. What am I missing?

CV RandValue#i# = RandRange(1, ListLen(PIDList));

Quote the dynamically named variable:

RandValue#i# = RandRange(1, ListLen(PIDList));

~ Ubqtous ~

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Question from a beginner

2003-11-14 Thread John Munyan
The link is http://www.attrition.ws/hike.cfm (click piechart).

Basically the hikechart.cfm page takes in a url variable from 1-6 to set
some values and based on the input populates the #chartme# variable to
build the query. I am using mssql for this.I am trying to take into
consideration the discreet values for Elevation, Time, and distance so
the count value from the sql query would be categorized.Currently each
discreet value is charted. See how many values there are for elevation?
http://www.attrition.ws/hikechart.cfm?Chart=6Totpics=12Columns=3Condi
tion=UrlValue=

When drilling into the chart I pass back a couple url variables to
refine the query to the hike.cfm page, which is why I am trying to
handle this logic in sql rather than the application per se so that I
can pass this back to the refining page.I was hoping that based in
the incoming url.chart value I could build some conditional logic within
the sql query to group Elevation etc into categories of 500. Any
ideas?Below is the relevant hikechart.cfm code:

cfif IsDefined(URL.Chart) AND url.Chart EQ 1

cfset ChartMe=Region

cfset Title=Regional Distribution of Hikes

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 2

cfset ChartMe=HikeDifficulty

cfset Title=Difficulty PieChart

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 3

cfset ChartMe=Reccomend

cfset Title=Reccomendation Piechart

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 4

cfset ChartMe=HikeTime

cfset Title=Round Trip Time In Hours PieChart

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 5

cfset ChartMe=RoundTripDistance

cfset Title=Round Trip Distance In Miles PieChart

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 6

cfset ChartMe=ElevationGain

cfset Title=Elevation Gained In Feet PieChart

/cfif

!--- End Catch block for URL variables ---

cfquery name=Recordset1 datasource=hike

SELECT #ChartMe#, count(*) as

Chart_count

FROM hike

Where #ChartMe# is not null

group by #ChartMe#

order by #ChartMe#; 

/cfquery

cfchart showborder=yes show3d=yes chartwidth=600
chartheight=400pieslicestyle=sliced
url="">
umns#urlvalue=$ITEMLABEL$

cfchartseries type=pie query=Recordset1 itemcolumn=#ChartMe#
valuecolumn=Chart_count

/cfchartseries

/cfchart

Thanks,

John

-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 8:27 AM
To: CF-Talk
Subject: Re: Question from a beginner

John,

Are your elevation value stored in feet units?

If so, you can set a new variable:

cfset chart_me_calc=integer(elevation/500)
(the actual syntax may be different for your db.)

Then:
cfset chart_me=elevation
cfparam name=chart_me_code default=#chart_me#

select #chart_me_calc# as #chart_me#, count(*) as Chart_count

Post the url when you are done so we can check it out.

Jerry Johnson

 [EMAIL PROTECTED] 11/14/03 11:04AM 
I have a website describing hikes I have taken.I have recently added a
charting page to chart much of the data I collect such as Region,
Recommendation, Difficulty which works fine (since these values are
essentially categorical ones with few values 5-6).However I also am
trying to chart Time, Elevation gain, and Distance hiked.Elevation
Gain in particular charts poorly as hardly any of the 60 hikes had the
same gain.

What I would like to do is when I am charting Time, Elevation gain, and
Distance I would like to categorized the output into just a few.For
Elevation it would probably be best to use 500ft increments.0-500,
500-1000, 1000-1500 and so on. 

The current query I am using for the cfchart call is:

SELECT #ChartMe#, count(*) as

Chart_count

FROM hike

Where #ChartMe# is not null

group by #ChartMe#

order by #ChartMe#; 

Does anyone have an idea of how this query might be amended or otherwise
rewritten to allow the above categorization to happen rather than just
counting discreet instances?I have tried searching the web for quite a
while to no avail, and was thinking this group might have some clues.
Even good sql sites, groups, or book recommendations would be very
welcomed.

Thanks sincerely,

John







 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: What is wrong w/ this cfscript block of code?

2003-11-14 Thread Che Vilnonis
Stephen, the last line bombs out. Variables is undefined. Any ideas?
-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 11:42 AM
To: CF-Talk
Subject: Re: What is wrong w/ this cfscript block of code?

Che,

I think you probably need a SetVariable for this...

 RandValue#i# = RandRange(1, ListLen(PIDList));

SetVariable(RandValuei,RandRange(1, ListLen(PIDList));

 RandRecord#i# = ListGetAt(PIDList, RandValue#i#);

SetVariable(RandRecordi,RandRange(1, ListLen(PIDList));

And perhaps use a struct reference for this

 PIDList = ListDeleteAt(PIDList, RandValue#i#);

PIDList = ListDeleteAt(PIDList,variables[RandValuei]);

Hope this helps

Regards

Stephen


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Oracle CLOBS SQL

2003-11-14 Thread d.a.collie
Cheers Jochem, but I thought of that and should have made it a bit
clearer in the question...

 
The clobs contain be free text with no HTML allowed.The links that may
be in the clob will just be plain text and may not actually contain
http://.

 
It might just be www.domain.com or even domain.com, that's why I was
thinking that I would need regexp, but was wondering aloud whether SQL
could do something like that

 
-dc

	-Original Message-
	From: Jochem van Dieten [mailto:[EMAIL PROTECTED] 
	Sent: 14 November 2003 16:48
	To: CF-Talk
	Subject: Re: Oracle CLOBS SQL
	
	
	[EMAIL PROTECTED] wrote:
	 
	 I need to extract all CLOBS where there is a URL contained
within them.
	 
	 Can I do this in SQL (Oracle specific SQL ok by me) or would I
have to
	 do it in Co,d Fusion, looping and doing a REFind on each
individual
	 clob?
	
	SELECT *
	FROM table
	WHERE whatever LIKE '%http://%'
	
	Jochem
	
	-- 
	Who needs virtual reality
	if you can just dream?
	- Loesje
	
	
_

	
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




persistent CFC and data update problem.

2003-11-14 Thread Ian Skinner
I'm going to try to describe this problem in abstract first.I'm sure we'll
get into code examples before the end, but I did not want to dump nine
related CFCs on the list all at once.Please bear with me, this is a bit
convoluted.

I have a fairly complex CFC/data structure.My first attempt at OO/CFC
application design.Lets start with the main CFC's
(Donor/Chairperson/Volunteer) each of which extend a CFC of basic
functionality (Profile).Profile is a composite of 6 CFC's that group
different sets of functionality (Basic Data/General
Comments/Education/Family  Friend Relationships/Lifestyle/Special
Dates/Complaints).All of these extend a small CFC containing common init
and display functions.

The main CFC is initiated and stored in the session scope: cfparam
name=session.cps.profile
default=#createObject('component','Profile_Donor').init(session.cps.id)#
for example.The main CFC then initiate each composite CFC which query the
database and stores the returned query in their this scope through a
getter function in each composite CFC.

The problem occurs when I try to update any of this data. In my update code,
I can not seem to refresh the data.I have forms that collects the new
data, the form is submitted to a controller CFC, that calls the update
functions of the Main CFC (in the session scope) inherited from the Profile
CFC.These functions in the Profile CFC, call the associated functions from
the appropriate composite CFC.Then the update function in the composite
CFC updates the database and calls the getter function that queries the
database and stores the data in the this scope.

For some reason this works, if I do it from a CFM file.But, if I do it
from a controller type CFC, I seem to get some kind of separate
scope/instance somewhere?That's the only theory I have anyway.All the
update code works, but when I return, the data in the CFC/object in the
session scope has not been updated.

I doubt I explained that very clearly yet.As I said this is rather
convoluted, and I'm not really sure where my problem is.Any help in
understanding / explaining / resolving this issue would be most appreciated.

--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA

Confidentiality Notice:This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




re: cfftp

2003-11-14 Thread Bushy
Hi,

I'm using cfftp to connect to a server to list /directory/files. I want to be able to check if whats being displayed is a directory or file. 

Like cfif ... dir display this image and cfif ... file display this image?

This is what I have...

cfftp action="" 
connection=ftpconnect
...

cfftp action="">
stoponerror=yes
name=listfiles
directory=/
connection=ftpconnect

cfoutput query=listfiles
#name#
/cfoutput

cfftp action="">
connection=ftpconnect
...



 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: What is wrong w/ this cfscript block of code?

2003-11-14 Thread Ubqtous
Che,

On 11/14/2003 at 12:03, you wrote:

CV Stephen, the last line bombs out. Variables is undefined. Any
CV ideas?

CVPIDList = ListDeleteAt(PIDList,variables[RandValuei]);

How about this:

cfscript
PIDList=ValueList(getAllInCat.Product_ID);
for(i=1; i lte 4; i=i+1){
 thisRandValue=RandRange(1,ListLen(PIDList));
 RandValue#i#=thisRandValue;
 RandRecord#i#=ListGetAt(PIDList,thisRandValue);
 PIDList=ListDeleteAt(PIDList,thisRandValue);
}
/cfscript

~ Ubqtous ~

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfftp

2003-11-14 Thread John Burns
Instead of cfoutput query=listfiles./cfoutput

Do a cfdump var=#listfiles# and that will show you everything that is
returned in that object.You'll see all of the variables and information
that you have access to and then you can set up your cfif .dir etc.

John Burns

-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 12:21 PM
To: CF-Talk
Subject: re: cfftp

Hi,

I'm using cfftp to connect to a server to list /directory/files. I want to
be able to check if whats being displayed is a directory or file. 

Like cfif ... dir display this image and cfif ... file display this
image?

This is what I have...

cfftp action="" 
connection=ftpconnect
...

cfftp action="">
stoponerror=yes
name=listfiles
directory=/
connection=ftpconnect

cfoutput query=listfiles
#name#
/cfoutput

cfftp action="">
connection=ftpconnect
...



_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: What is wrong w/ this cfscript block of code?

2003-11-14 Thread Che Vilnonis
that did the trick. thank you very much.
clever, using a set variable name made it work.
-Original Message-
From: Ubqtous [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 12:22 PM
To: CF-Talk
Subject: Re: What is wrong w/ this cfscript block of code?

Che,

On 11/14/2003 at 12:03, you wrote:

CV Stephen, the last line bombs out. Variables is undefined. Any
CV ideas?

CVPIDList = ListDeleteAt(PIDList,variables[RandValuei]);

How about this:

cfscript
 PIDList=ValueList(getAllInCat.Product_ID);
 for(i=1; i lte 4; i=i+1){
thisRandValue=RandRange(1,ListLen(PIDList));
RandValue#i#=thisRandValue;
RandRecord#i#=ListGetAt(PIDList,thisRandValue);
PIDList=ListDeleteAt(PIDList,thisRandValue);
 }
/cfscript

~ Ubqtous ~


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Cool Fusion - infusion Mail server - any opinions?

2003-11-14 Thread Rafael Bleiweiss
Saw a banner on this list for the Cool-Fusion built mail server and wanted 
to find out if anyone here has any experience with either their inFusion 
Mail server or their FusionMail server?

I tried joining their mailing list and sending email to their tech support 
- their automated just reply to confirm email came back user unknown as 
did the email I sent to their support staff!

They around? Legit? A good solid Cold Fusion based product?

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Oracle CLOBS SQL

2003-11-14 Thread Matt Robertson
Jochem wrote:
WHERE whatever LIKE '%http://%'

DOH! :-)


 Matt Robertson [EMAIL PROTECTED] 
 MSB Designs, Inc.http://mysecretbase.com


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cool Fusion - infusion Mail server - any opinions?

2003-11-14 Thread Michael Dinowitz
Very legit. Howie Hamlin is a long time list member and I've been using it to
power the lists for a while. I've emailed him that he may have some problems
with their mail support. If I get a bounce, I'll give him a call.

As a side thing, he's a list supporter which is the reason for the ads. iMS
makes the lists as powerful as they are and potentially more powerful once I get
a free second to make some mods to the software. I've got some built in
anti-spam templates for the product which will remove most spam before its even
on the server.

 Saw a banner on this list for the Cool-Fusion built mail server and wanted
 to find out if anyone here has any experience with either their inFusion
 Mail server or their FusionMail server?

 I tried joining their mailing list and sending email to their tech support
 - their automated just reply to confirm email came back user unknown as
 did the email I sent to their support staff!

 They around? Legit? A good solid Cold Fusion based product?

 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: What is wrong w/ this cfscript block of code?

2003-11-14 Thread Ubqtous
Che,

On 11/14/2003 at 12:28, you wrote:

CV clever, using a set variable name made it work.

I thought the variables[RandValuei] trick would have worked, but
maybe your version of CF doesn't support it.

I've successfully used that approach with the request scope on CF5:

request.name_#f#=trim(form['name_'f]);
...
#request['name_'f]#

~ Ubqtous ~

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Oracle CLOBS SQL

2003-11-14 Thread Jochem van Dieten
[EMAIL PROTECTED] wrote:

 The clobs contain be free text with no HTML allowed.The links that may
 be in the clob will just be plain text and may not actually contain
 http://.

 It might just be www.domain.com or even domain.com, that's why I was
 thinking that I would need regexp, but was wondering aloud whether SQL
 could do something like that

SQL doesn't do normal regex. But there is a functionality in SQL 
that combines parts from LIKE and regex, named SIMILAR TO. You 
might want to check the Oracle docs to see if it is supported. 
The pattern would look something like:

SELECT *
FROM table
WHERE whatever SIMILAR TO 
'%[abcdefghijklmnopqrstuvwxyz]+.(com|org|net)%'

Jochem

-- 
Who needs virtual reality
if you can just dream?
- Loesje


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




re: cfftp

2003-11-14 Thread Bushy
How can I sort the directories/files of my output with the directories being listed first and then files using cfftp?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Users want to format text

2003-11-14 Thread Jeff Beer
Is this a replacement for a textarea?Will it post along with a form
submission?I don't see any docs of that nature...

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, November 13, 2003 6:39 PM
 To: CF-Talk
 Subject: RE: Users want to format text
 
 
 why dont u do it in flash?
 or use a flash editor and i hope he could copy and paste it 
 into the right place this one is fantastic 
 http://www.joshdura.com/archives/000163.php
 
 
 
 
 
 
 
 
  I'm having the same problem.One mac user (the site 
 owner). I think 
  everyone else uses Windows.
 
  My biggest problem is that the editors are using a number 
 of different 
  versions of MS Word to write up their content. Some 
 versions convert 
  just fine (using FCKEditor - windows only) while others leave bad 
  markup and unprintable characters.
 
  Of course, we can't expect the end users to be careful :-)
 
  I'm looking at soEditor Pro 2.5 - has anyone used this with 
 multiple 
  versions of MS Word?I know it won't work for the Mac user 
 - he's ok 
  with that, but the MS Word support has to be top notch.
 
 
 
  Why can't they just learn a little HTML! Hehe
 
 
 
  -Original Message-
  From: Janine Jakim [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 12:58 PM
  To: CF-Talk
  Subject: RE: Users want to format text
 
 
  Would be perfect if 90% of my users were not Mac users!
  Any good cross platform ones?
 
  -Original Message-
  From: Mickael [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 12:42 PM
  To: CF-Talk
  Subject: Re: Users want to format text
 
 
  Use HTMLEdit from http://www.interactivetools.com 
  http://www.interactivetools.com
 
  Easy use
 - Original
  Message -
 From: Janine Jakim
 To: CF-Talk
 Sent: Thursday, November 13, 2003 12:30 PM
 Subject: Users want to format text
 
 Have an application with a bunch of input boxes.The 
 users want to 
  be able
 to do snazzy things as if it's a word document- underline, bold, 
  change font
 size and/or type for certain parts.
 Is this possible?
 They then want to output it to a word doc. (I do know that's 
  doable) Thanks,
 J
 
 
 _
 
 
 
  
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Cool Fusion - infusion Mail server - any opinions?

2003-11-14 Thread Angel Stewart
No..but if you're buying it buy it by clicking the link in the ad on
these pages so HOF gets the referral cash 
^_^

 
These lists run on iMS I believe.

 
-Gel

-Original Message-
From: Rafael Bleiweiss [mailto:[EMAIL PROTECTED] 

Saw a banner on this list for the Cool-Fusion built mail server and
wanted 
to find out if anyone here has any experience with either their inFusion

Mail server or their FusionMail server?

I tried joining their mailing list and sending email to their tech
support 
- their automated just reply to confirm email came back user unknown
as 
did the email I sent to their support staff!

They around? Legit? A good solid Cold Fusion based product?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Question from a beginner

2003-11-14 Thread John Burns
You use a cfloop and use statements to set a variable that you can
increment if a hike falls within that group..



cfparam name=group1 default=0

cfparam name=group2 default=0

cfparam name=group3 default=0

cfparam name=hikeGrouping default=500

cfoutput query=queryOfHikes

cfif hikeHeight LT hikeGrouping

cfset group1 = group1 + 1

cfelseif hikeHeight LT evaluate(hikeGrouping * 2)

cfset group2 = group2 + 1

/cfif

/cfoutput

This should give you values for your groups at the end for how many hikes
fell into that group.Since CFIF evaluates in order, just see if the hike
is less than that amount and if so, it falls into that group.Use
hikeGrouping to set the size of the groups.Then, later, when you climb
Everest, you can change it to 1000 so you don't have too many pie pieces.

John Burns

-Original Message-
From: John Munyan [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 11:51 AM
To: CF-Talk
Subject: RE: Question from a beginner

The link is http://www.attrition.ws/hike.cfm (click piechart).

Basically the hikechart.cfm page takes in a url variable from 1-6 to set
some values and based on the input populates the #chartme# variable to
build the query. I am using mssql for this.I am trying to take into
consideration the discreet values for Elevation, Time, and distance so
the count value from the sql query would be categorized.Currently each
discreet value is charted. See how many values there are for elevation?
http://www.attrition.ws/hikechart.cfm?Chart=6
http://www.attrition.ws/hikechart.cfm?Chart=6Totpics=12Columns=3Condi
Totpics=12Columns=3Condi
tion=UrlValue=

When drilling into the chart I pass back a couple url variables to
refine the query to the hike.cfm page, which is why I am trying to
handle this logic in sql rather than the application per se so that I
can pass this back to the refining page.I was hoping that based in
the incoming url.chart value I could build some conditional logic within
the sql query to group Elevation etc into categories of 500. Any
ideas?Below is the relevant hikechart.cfm code:

cfif IsDefined(URL.Chart) AND url.Chart EQ 1

cfset ChartMe=Region

cfset Title=Regional Distribution of Hikes

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 2

cfset ChartMe=HikeDifficulty

cfset Title=Difficulty PieChart

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 3

cfset ChartMe=Reccomend

cfset Title=Reccomendation Piechart

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 4

cfset ChartMe=HikeTime

cfset Title=Round Trip Time In Hours PieChart

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 5

cfset ChartMe=RoundTripDistance

cfset Title=Round Trip Distance In Miles PieChart

/cfif

cfif IsDefined(URL.Chart) AND url.Chart EQ 6

cfset ChartMe=ElevationGain

cfset Title=Elevation Gained In Feet PieChart

/cfif

!--- End Catch block for URL variables ---

cfquery name=Recordset1 datasource=hike

SELECT #ChartMe#, count(*) as

Chart_count

FROM hike

Where #ChartMe# is not null

group by #ChartMe#

order by #ChartMe#; 

/cfquery

cfchart showborder=yes show3d=yes chartwidth=600
chartheight=400pieslicestyle=sliced
url="">
umns#urlvalue=$ITEMLABEL$

cfchartseries type=pie query=Recordset1 itemcolumn=#ChartMe#
valuecolumn=Chart_count

/cfchartseries

/cfchart

Thanks,

John

-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 8:27 AM
To: CF-Talk
Subject: Re: Question from a beginner

John,

Are your elevation value stored in feet units?

If so, you can set a new variable:

cfset chart_me_calc=integer(elevation/500)
(the actual syntax may be different for your db.)

Then:
cfset chart_me=elevation
cfparam name=chart_me_code default=#chart_me#

select #chart_me_calc# as #chart_me#, count(*) as Chart_count

Post the url when you are done so we can check it out.

Jerry Johnson

 [EMAIL PROTECTED] 11/14/03 11:04AM 
I have a website describing hikes I have taken.I have recently added a
charting page to chart much of the data I collect such as Region,
Recommendation, Difficulty which works fine (since these values are
essentially categorical ones with few values 5-6).However I also am
trying to chart Time, Elevation gain, and Distance hiked.Elevation
Gain in particular charts poorly as hardly any of the 60 hikes had the
same gain.

What I would like to do is when I am charting Time, Elevation gain, and
Distance I would like to categorized the output into just a few.For
Elevation it would probably be best to use 500ft increments.0-500,
500-1000, 1000-1500 and so on. 

The current query I am using for the cfchart call is:

SELECT #ChartMe#, count(*) as

Chart_count

FROM hike

Where #ChartMe# is not null

group by #ChartMe#

order by #ChartMe#; 

Does anyone have an idea of how this query might be amended or otherwise
rewritten to allow the above categorization to happen rather than just
counting discreet instances?I have tried searching the web for quite a
while to no avail, and was thinking this group might have 

Re: Cool Fusion - infusion Mail server - any opinions?

2003-11-14 Thread Michael Dinowitz
Actually, because the list ads for iMS are in response to Howie's support, we
don't get any referrals for it. The only paid ads we have at the moment are the
Macromedia ads, but the same idea applies there. If you buy a MM product from
one of the HoF links, we get a referral fee. I've gotten 1 already (after over
500,000 ad impressions).
As for the lists, yes we're using iMS. It allows much finer control over the
mail out in addition to all the other features.

 No..but if you're buying it buy it by clicking the link in the ad on
 these pages so HOF gets the referral cash
 ^_^

 These lists run on iMS I believe.

 -Gel

 -Original Message-
 From: Rafael Bleiweiss [mailto:[EMAIL PROTECTED]


 Saw a banner on this list for the Cool-Fusion built mail server and
 wanted
 to find out if anyone here has any experience with either their inFusion

 Mail server or their FusionMail server?

 I tried joining their mailing list and sending email to their tech
 support
 - their automated just reply to confirm email came back user unknown
 as
 did the email I sent to their support staff!

 They around? Legit? A good solid Cold Fusion based product?



 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: cfftp

2003-11-14 Thread John Burns
I would imagine you could do a query of a query on the object that is
returned by cfftp and order it by whatever you wanted.

John Burns

-Original Message-
From: Bushy [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 12:47 PM
To: CF-Talk
Subject: re: cfftp

How can I sort the directories/files of my output with the directories being
listed first and then files using cfftp?


_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Users want to format text

2003-11-14 Thread cf
im sure u could
if not what u could do is have it as a pop up, fill it in hit the show
html button and copy  paste it in

or if you know enough flash just use it as the text field
pretty easy too do. just make the form in flash and call the cfm insert
page to do the insert



 Is this a replacement for a textarea?Will it post along with a form
 submission?I don't see any docs of that nature...


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: Thursday, November 13, 2003 6:39 PM
 To: CF-Talk
 Subject: RE: Users want to format text


 why dont u do it in flash?
 or use a flash editor and i hope he could copy and paste it
 into the right place this one is fantastic
 http://www.joshdura.com/archives/000163.php








  I'm having the same problem.One mac user (the site
 owner). I think
  everyone else uses Windows.
 
  My biggest problem is that the editors are using a number
 of different
  versions of MS Word to write up their content. Some
 versions convert
  just fine (using FCKEditor - windows only) while others leave bad
 markup and unprintable characters.
 
  Of course, we can't expect the end users to be careful :-)
 
  I'm looking at soEditor Pro 2.5 - has anyone used this with
 multiple
  versions of MS Word?I know it won't work for the Mac user
 - he's ok
  with that, but the MS Word support has to be top notch.
 


  Why can't they just learn a little HTML! Hehe
 
 
 
  -Original Message-
  From: Janine Jakim [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 12:58 PM
  To: CF-Talk
  Subject: RE: Users want to format text
 
 
  Would be perfect if 90% of my users were not Mac users!
  Any good cross platform ones?
 
  -Original Message-
  From: Mickael [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 12:42 PM
  To: CF-Talk
  Subject: Re: Users want to format text
 
 
  Use HTMLEdit from http://www.interactivetools.com
  http://www.interactivetools.com
 
  Easy use
 - Original
  Message -
 From: Janine Jakim
 To: CF-Talk
 Sent: Thursday, November 13, 2003 12:30 PM
 Subject: Users want to format text
 
 Have an application with a bunch of input boxes.The
 users want to
  be able
 to do snazzy things as if it's a word document- underline, bold,
  change font
 size and/or type for certain parts.
 Is this possible?
 They then want to output it to a word doc. (I do know that's
  doable) Thanks,
 J
 
 
 _
 
 
 
 

 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Users want to format text

2003-11-14 Thread Jeff Beer
Way too involved.. There are about 40 total textareas I need to replace
- and I'm not at all sure it will handle MS Word conversions.

Thanks for the info, though - I'll probably use it for other projects.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Friday, November 14, 2003 12:54 PM
 To: CF-Talk
 Subject: RE: Users want to format text
 
 
 im sure u could
 if not what u could do is have it as a pop up, fill it in hit 
 the show html button and copy  paste it in
 
 or if you know enough flash just use it as the text field 
 pretty easy too do. just make the form in flash and call the 
 cfm insert page to do the insert
 
 
 
 
 
  Is this a replacement for a textarea?Will it post along 
 with a form 
  submission?I don't see any docs of that nature...
 
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 6:39 PM
  To: CF-Talk
  Subject: RE: Users want to format text
 
 
  why dont u do it in flash?
  or use a flash editor and i hope he could copy and paste 
 it into the 
  right place this one is fantastic 
  http://www.joshdura.com/archives/000163.php
 
 
 
 
 
 
 
 
   I'm having the same problem.One mac user (the site
  owner). I think
   everyone else uses Windows.
  
   My biggest problem is that the editors are using a number
  of different
   versions of MS Word to write up their content. Some
  versions convert
   just fine (using FCKEditor - windows only) while others leave bad
  markup and unprintable characters.
  
   Of course, we can't expect the end users to be careful :-)
  
   I'm looking at soEditor Pro 2.5 - has anyone used this with
  multiple
   versions of MS Word?I know it won't work for the Mac user
  - he's ok
   with that, but the MS Word support has to be top notch.
  
 
 
   Why can't they just learn a little HTML! Hehe
  
  
  
   -Original Message-
   From: Janine Jakim [mailto:[EMAIL PROTECTED]
   Sent: Thursday, November 13, 2003 12:58 PM
   To: CF-Talk
   Subject: RE: Users want to format text
  
  
   Would be perfect if 90% of my users were not Mac users! 
 Any good 
   cross platform ones?
  
   -Original Message-
   From: Mickael [mailto:[EMAIL PROTECTED]
   Sent: Thursday, November 13, 2003 12:42 PM
   To: CF-Talk
   Subject: Re: Users want to format text
  
  
   Use HTMLEdit from http://www.interactivetools.com 
   http://www.interactivetools.com
  
   Easy use
  - Original
   Message -
  From: Janine Jakim
  To: CF-Talk
  Sent: Thursday, November 13, 2003 12:30 PM
  Subject: Users want to format text
  
  Have an application with a bunch of input boxes.The
  users want to
   be able
  to do snazzy things as if it's a word document- 
 underline, bold, 
   change font
  size and/or type for certain parts.
  Is this possible?
  They then want to output it to a word doc. (I do know that's
   doable) Thanks,
  J
  
  
  _
  
  
  
  
 
  
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFCOOKIE and Netscape 7.1

2003-11-14 Thread Bryan Stevenson
Hey All,

I'm setting non-persistent cookies like so:

cfcookie name=MyCookie value=MyValue

So with no expires attribute the cookie should be destroyed when the
browser closes.Well in Netscape 7.1 the cookie is persisting (i.e. close
ALL browsers...re-open...cookie is still there)!!

Any ideas?

Thanks

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Users want to format text

2003-11-14 Thread John Burns
While on this question. has anyone seen anything that allows you to format
text with style sheets?For instance, a user highlights some text and
instead of changing the font and size, you give them a list of the styles
that they can use so that the text matches the styles on the rest of your
pages?

John Burns

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 12:54 PM
To: CF-Talk
Subject: RE: Users want to format text

im sure u could
if not what u could do is have it as a pop up, fill it in hit the show
html button and copy  paste it in

or if you know enough flash just use it as the text field
pretty easy too do. just make the form in flash and call the cfm insert
page to do the insert

 Is this a replacement for a textarea?Will it post along with a form
 submission?I don't see any docs of that nature...


 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
 Sent: Thursday, November 13, 2003 6:39 PM
 To: CF-Talk
 Subject: RE: Users want to format text


 why dont u do it in flash?
 or use a flash editor and i hope he could copy and paste it
 into the right place this one is fantastic
 http://www.joshdura.com/archives/000163.php








  I'm having the same problem.One mac user (the site
 owner). I think
  everyone else uses Windows.
 
  My biggest problem is that the editors are using a number
 of different
  versions of MS Word to write up their content. Some
 versions convert
  just fine (using FCKEditor - windows only) while others leave bad
 markup and unprintable characters.
 
  Of course, we can't expect the end users to be careful :-)
 
  I'm looking at soEditor Pro 2.5 - has anyone used this with
 multiple
  versions of MS Word?I know it won't work for the Mac user
 - he's ok
  with that, but the MS Word support has to be top notch.
 


  Why can't they just learn a little HTML! Hehe
 
 
 
  -Original Message-
  From: Janine Jakim [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 12:58 PM
  To: CF-Talk
  Subject: RE: Users want to format text
 
 
  Would be perfect if 90% of my users were not Mac users!
  Any good cross platform ones?
 
  -Original Message-
  From: Mickael [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 12:42 PM
  To: CF-Talk
  Subject: Re: Users want to format text
 
 
  Use HTMLEdit from http://www.interactivetools.com
  http://www.interactivetools.com
 
  Easy use
 - Original
  Message -
 From: Janine Jakim
 To: CF-Talk
 Sent: Thursday, November 13, 2003 12:30 PM
 Subject: Users want to format text
 
 Have an application with a bunch of input boxes.The
 users want to
  be able
 to do snazzy things as if it's a word document- underline, bold,
  change font
 size and/or type for certain parts.
 Is this possible?
 They then want to output it to a word doc. (I do know that's
  doable) Thanks,
 J
 
 
 _
 
 
 
 

 

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SOLVED: CFCOOKIE and Netscape 7.1

2003-11-14 Thread Bryan Stevenson
Nevermind...solved

I had just installed NS 7.1 and the registration window was open the whole time but hiddenso it was keeping the cookie aliveTGIF ;-)

Cheers

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




SESConverter

2003-11-14 Thread CF Lists
I've been reading about the sesConverter at Fusium.com and wondered what 
other's experience was using it, preferrably with fusebox. I have a FB2 site 
a client wants better reporting/search engine ability on.

After looking into the sesConverter I didn't understand the reason/value of 
having the dummy filename on the url. What is this dummy file? Do you 
actually create a file with searchable content or is it just so the stats 
app will have something to display?

TIA


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cool Fusion - infusion Mail server - any opinions?

2003-11-14 Thread Howie Hamlin
I apologize for that.Your server is listed as an open relay in njabl.org and our mail server is currently configured to reply unknown user when a server is banned (we'll be changing that in the future - once we relocated to our new facility).

FYI: http://njabl.org/cgi-bin/lookup.cgi?query=209.73.244.54

We received a voice mail from someone at your company named Allen - someone here will return his call shortly.

I manually unbanned your server from our mail server so you should be able to send mail to us now.Sorry for the inconvenience.

Regards,

--
Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc. - www.CoolFusion.com
inFusion Mail Server (iMS) - The Award-winning, Intelligent Mail Server
 Please vote for iMS here: http://www.sys-con.com/coldfusion/readerschoice2003/index.cfm 
 Find out how iMS Stacks up to the competition: http://www.coolfusion.com/imssecomparison.cfm

- Original Message - 
From: Rafael Bleiweiss 
To: CF-Talk 
Sent: Friday, November 14, 2003 1:35 PM
Subject: Cool Fusion - infusion Mail server - any opinions?

Saw a banner on this list for the Cool-Fusion built mail server and wanted 
to find out if anyone here has any experience with either their inFusion 
Mail server or their FusionMail server?

I tried joining their mailing list and sending email to their tech support 
- their automated just reply to confirm email came back user unknown as 
did the email I sent to their support staff!

They around? Legit? A good solid Cold Fusion based product?


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Users want to format text

2003-11-14 Thread Jeff Beer
http://www.fredck.com/FCKeditor/

This is an awesome editor - free of charge - seems pretty flawless in
use, as long as your clients are on Windoze with IE5+

 -Original Message-
 From: John Burns [mailto:[EMAIL PROTECTED] 
 Sent: Friday, November 14, 2003 1:07 PM
 To: CF-Talk
 Subject: RE: Users want to format text
 
 
 While on this question. has anyone seen anything that allows 
 you to format text with style sheets?For instance, a user 
 highlights some text and instead of changing the font and 
 size, you give them a list of the styles that they can use so 
 that the text matches the styles on the rest of your pages?
 

 
 John Burns
 

 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Friday, November 14, 2003 12:54 PM
 To: CF-Talk
 Subject: RE: Users want to format text
 

 
 im sure u could
 if not what u could do is have it as a pop up, fill it in hit 
 the show html button and copy  paste it in
 
 or if you know enough flash just use it as the text field 
 pretty easy too do. just make the form in flash and call the 
 cfm insert page to do the insert
 
 
 
  Is this a replacement for a textarea?Will it post along 
 with a form 
  submission?I don't see any docs of that nature...
 
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 6:39 PM
  To: CF-Talk
  Subject: RE: Users want to format text
 
 
  why dont u do it in flash?
  or use a flash editor and i hope he could copy and paste 
 it into the 
  right place this one is fantastic 
  http://www.joshdura.com/archives/000163.php
 
 
 
 
 
 
 
 
   I'm having the same problem.One mac user (the site
  owner). I think
   everyone else uses Windows.
  
   My biggest problem is that the editors are using a number
  of different
   versions of MS Word to write up their content. Some
  versions convert
   just fine (using FCKEditor - windows only) while others leave bad
  markup and unprintable characters.
  
   Of course, we can't expect the end users to be careful :-)
  
   I'm looking at soEditor Pro 2.5 - has anyone used this with
  multiple
   versions of MS Word?I know it won't work for the Mac user
  - he's ok
   with that, but the MS Word support has to be top notch.
  
 
 
   Why can't they just learn a little HTML! Hehe
  
  
  
   -Original Message-
   From: Janine Jakim [mailto:[EMAIL PROTECTED]
   Sent: Thursday, November 13, 2003 12:58 PM
   To: CF-Talk
   Subject: RE: Users want to format text
  
  
   Would be perfect if 90% of my users were not Mac users! 
 Any good 
   cross platform ones?
  
   -Original Message-
   From: Mickael [mailto:[EMAIL PROTECTED]
   Sent: Thursday, November 13, 2003 12:42 PM
   To: CF-Talk
   Subject: Re: Users want to format text
  
  
   Use HTMLEdit from http://www.interactivetools.com 
   http://www.interactivetools.com
  
   Easy use
  - Original
   Message -
  From: Janine Jakim
  To: CF-Talk
  Sent: Thursday, November 13, 2003 12:30 PM
  Subject: Users want to format text
  
  Have an application with a bunch of input boxes.The
  users want to
   be able
  to do snazzy things as if it's a word document- 
 underline, bold, 
   change font
  size and/or type for certain parts.
  Is this possible?
  They then want to output it to a word doc. (I do know that's
   doable) Thanks,
  J
  
  
  _
  
  
  
  
 
  
 
_
 
 
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Cool Fusion - infusion Mail server - any opinions?

2003-11-14 Thread Howie Hamlin
You could always be set up as a reseller and make $ that way.

Regards,

Howie
- Original Message - 
From: Michael Dinowitz 
To: CF-Talk 
Sent: Friday, November 14, 2003 1:00 PM
Subject: Re: Cool Fusion - infusion Mail server - any opinions?

Actually, because the list ads for iMS are in response to Howie's support, we
don't get any referrals for it. The only paid ads we have at the moment are the
Macromedia ads, but the same idea applies there. If you buy a MM product from
one of the HoF links, we get a referral fee. I've gotten 1 already (after over
500,000 ad impressions).
As for the lists, yes we're using iMS. It allows much finer control over the
mail out in addition to all the other features.

 No..but if you're buying it buy it by clicking the link in the ad on
 these pages so HOF gets the referral cash
 ^_^

 These lists run on iMS I believe.

 -Gel

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Users want to format text

2003-11-14 Thread Schuster, Steven
Yeah, that is an awesome one. I use it

 
Steve


-Original Message-
From: Jeff Beer [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 1:25 PM
To: CF-Talk
Subject: RE: Users want to format text

 
http://www.fredck.com/FCKeditor/

This is an awesome editor - free of charge - seems pretty flawless in
use, as long as your clients are on Windoze with IE5+

 -Original Message-
 From: John Burns [mailto:[EMAIL PROTECTED] 
 Sent: Friday, November 14, 2003 1:07 PM
 To: CF-Talk
 Subject: RE: Users want to format text
 
 
 While on this question. has anyone seen anything that allows 
 you to format text with style sheets?For instance, a user 
 highlights some text and instead of changing the font and 
 size, you give them a list of the styles that they can use so 
 that the text matches the styles on the rest of your pages?
 

 
 John Burns
 

 
 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Friday, November 14, 2003 12:54 PM
 To: CF-Talk
 Subject: RE: Users want to format text
 

 
 im sure u could
 if not what u could do is have it as a pop up, fill it in hit 
 the show html button and copy  paste it in
 
 or if you know enough flash just use it as the text field 
 pretty easy too do. just make the form in flash and call the 
 cfm insert page to do the insert
 
 
 
  Is this a replacement for a textarea?Will it post along 
 with a form 
  submission?I don't see any docs of that nature...
 
 
  -Original Message-
  From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
  Sent: Thursday, November 13, 2003 6:39 PM
  To: CF-Talk
  Subject: RE: Users want to format text
 
 
  why dont u do it in flash?
  or use a flash editor and i hope he could copy and paste 
 it into the 
  right place this one is fantastic 
  http://www.joshdura.com/archives/000163.php
http://www.joshdura.com/archives/000163.php 
 
 
 
 
 
 
 
 
   I'm having the same problem.One mac user (the site
  owner). I think
   everyone else uses Windows.
  
   My biggest problem is that the editors are using a number
  of different
   versions of MS Word to write up their content. Some
  versions convert
   just fine (using FCKEditor - windows only) while others leave bad
  markup and unprintable characters.
  
   Of course, we can't expect the end users to be careful :-)
  
   I'm looking at soEditor Pro 2.5 - has anyone used this with
  multiple
   versions of MS Word?I know it won't work for the Mac user
  - he's ok
   with that, but the MS Word support has to be top notch.
  
 
 
   Why can't they just learn a little HTML! Hehe
  
  
  
   -Original Message-
   From: Janine Jakim [mailto:[EMAIL PROTECTED]
   Sent: Thursday, November 13, 2003 12:58 PM
   To: CF-Talk
   Subject: RE: Users want to format text
  
  
   Would be perfect if 90% of my users were not Mac users! 
 Any good 
   cross platform ones?
  
   -Original Message-
   From: Mickael [mailto:[EMAIL PROTECTED]
   Sent: Thursday, November 13, 2003 12:42 PM
   To: CF-Talk
   Subject: Re: Users want to format text
  
  
   Use HTMLEdit from http://www.interactivetools.com
http://www.interactivetools.com
   http://www.interactivetools.com
  
   Easy use
  - Original
   Message -
  From: Janine Jakim
  To: CF-Talk
  Sent: Thursday, November 13, 2003 12:30 PM
  Subject: Users want to format text
  
  Have an application with a bunch of input boxes.The
  users want to
   be able
  to do snazzy things as if it's a word document- 
 underline, bold, 
   change font
  size and/or type for certain parts.
  Is this possible?
  They then want to output it to a word doc. (I do know that's
   doable) Thanks,
  J
  
  
  _
  
  
  
  
 
  
 
_
 
 
 
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




separating alpha groups in query results

2003-11-14 Thread DougF
Want to insert a blank line separator at the start of each new alpha letter
group
in a looped display query result. Any suggestions?
DougF
-
Example:

Ajo
Amado
Apache Junction
Arizona City
Ash Fork
blank line here
Benson
Bisbee
Black Canyon City
blank line here
Camp Creek
Cottonwood
--

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Oracle CLOBS SQL

2003-11-14 Thread Deanna Schneider
Here's a quick tutorial on regular expressions in Oracle, but I'm not sure
when they became supported (I don't think they're available in 8i):

http://otn.oracle.com/books/pdfs/gennick_ch01.pdf

- Original Message - 
From: Jochem van Dieten [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, November 14, 2003 11:44 AM
Subject: Re: Oracle CLOBS SQL

 [EMAIL PROTECTED] wrote:
 
  The clobs contain be free text with no HTML allowed.The links that may
  be in the clob will just be plain text and may not actually contain
  http://.
 
  It might just be www.domain.com or even domain.com, that's why I was
  thinking that I would need regexp, but was wondering aloud whether SQL
  could do something like that

 SQL doesn't do normal regex. But there is a functionality in SQL
 that combines parts from LIKE and regex, named SIMILAR TO. You
 might want to check the Oracle docs to see if it is supported.
 The pattern would look something like:

 SELECT *
 FROM table
 WHERE whatever SIMILAR TO
 '%[abcdefghijklmnopqrstuvwxyz]+.(com|org|net)%'

 Jochem


 -- 
 Who needs virtual reality
 if you can just dream?
- Loesje


 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: separating alpha groups in query results

2003-11-14 Thread Ben Forta
One simple way is to add a column to your query with the initial letter
(something like LEFT(column, 1) AS initial) and then CFOUTPUT GROUP
using that column.

 
--- Ben

-Original Message-
From: DougF [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 1:34 PM
To: CF-Talk
Subject: separating alpha groups in query results

Want to insert a blank line separator at the start of each new alpha
letter
group
in a looped display query result. Any suggestions?
DougF
-
Example:

Ajo
Amado
Apache Junction
Arizona City
Ash Fork
blank line here
Benson
Bisbee
Black Canyon City
blank line here
Camp Creek
Cottonwood
--

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: separating alpha groups in query results

2003-11-14 Thread John Burns
Check the first letter of the variable you're outputting and store it into a
temporary variable.On the next time through, check the first letter
against that temporary variable and if they don't match, put a blank line
before outputting the info from the query.

John Burns

-Original Message-
From: DougF [mailto:[EMAIL PROTECTED] 
Sent: Friday, November 14, 2003 1:34 PM
To: CF-Talk
Subject: separating alpha groups in query results

Want to insert a blank line separator at the start of each new alpha letter
group
in a looped display query result. Any suggestions?
DougF
-
Example:

Ajo
Amado
Apache Junction
Arizona City
Ash Fork
blank line here
Benson
Bisbee
Black Canyon City
blank line here
Camp Creek
Cottonwood
--

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: separating alpha groups in query results

2003-11-14 Thread Ian Skinner
cfset firstLetter = A
cflloop AlphaList index=String
 cfif Left(string,1) NEQ firstLetter
Output Blank Line
cfset firstLetter = left(string,1)
 /cfif
 cfoutput#String#/cfoutput
/cfloop

 
HTH
-- 
Ian Skinner 
Web Programmer 
BloodSource 
www.BloodSource.org 
Sacramento, CA 

-Original Message-
From: DougF [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 10:34 AM
To: CF-Talk
Subject: separating alpha groups in query results

Want to insert a blank line separator at the start of each new alpha letter
group
in a looped display query result. Any suggestions?
DougF
-
Example:

Ajo
Amado
Apache Junction
Arizona City
Ash Fork
blank line here
Benson
Bisbee
Black Canyon City
blank line here
Camp Creek
Cottonwood
--

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Question from a beginner

2003-11-14 Thread Jerry Johnson
Well, after looking at the site, I completely miss living in Portland, OR.

Boo Hoo!

Make the following changes and I think you can get there:

(The label will say 500, rather than the more proper 500-1000, but I leave that as a detail for you to finish)

=)

Jerry Johnson

cfif IsDefined(URL.Chart) AND url.Chart EQ 6

cfset ChartMe=ElevationGain
cfset ChartMeCalc=integer(ElevationGain/500)*500

cfset Title=Elevation Gained In Feet PieChart

/cfif

!--- End Catch block for URL variables ---

cfparam name=ChartMeCalc default=#ChartMe#

cfquery name=Recordset1 datasource=hike

SELECT #ChartMeCalc# as #ChartMe#, count(*) as Chart_count

FROM hike

Where #ChartMe# is not null

group by #ChartMeCalc#

order by #ChartMe#; 

/cfquery


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: SESConverter

2003-11-14 Thread Mickael
Hi 

I have used it on FB3 and found it very useful for some search engines. The only issue is that it is one more this to support with IIS if thre is a change, and it is sometime difficult to get working properly at shared hosting environment. The dummy file is not an actual file in your system it is just there to make your url look complete.

Here is a link from one of my websites

http://www.mydomain.com/index.cfm/fuseaction/hotels.main/hotels.cfm

This is the same as http://www.mydomain.com/index.cfm?fuseaction=hotels.main

The file hotels.cfm does not actually exist.

Mike
- Original Message - 
From: CF Lists 
To: CF-Talk 
Sent: Friday, November 14, 2003 1:12 PM
Subject: SESConverter

I've been reading about the sesConverter at Fusium.com and wondered what 
other's experience was using it, preferrably with fusebox. I have a FB2 site 
a client wants better reporting/search engine ability on.

After looking into the sesConverter I didn't understand the reason/value of 
having the dummy filename on the url. What is this dummy file? Do you 
actually create a file with searchable content or is it just so the stats 
app will have something to display?

TIA


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Question from a beginner

2003-11-14 Thread Jerry Johnson
I pasted the wrong text.

cfset ChartMeCalc=integer(ElevationGain/500)*500

should read
cfset ChartMeCalc=convert(int,ElevationGain/500)*500

Jerry Johnson


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Oracle CLOBS SQL

2003-11-14 Thread I-Lin Kuo
Thanks for alerting me to this. According to
documentation, it's a new feature in 10g. Two words of
warning on searching CLOBs:
- CLOBs aren't made to be searched or manipulated or
concatenated, but Oracle usually converts a CLOB to a
string to allow this.
- the CLOB-string conversion usually only takes the
first 4000 bytes.

--- Deanna Schneider [EMAIL PROTECTED]
wrote:
 Here's a quick tutorial on regular expressions in
 Oracle, but I'm not sure
 when they became supported (I don't think they're
 available in 8i):
 
 http://otn.oracle.com/books/pdfs/gennick_ch01.pdf
 
 
 - Original Message - 
 From: Jochem van Dieten [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Friday, November 14, 2003 11:44 AM
 Subject: Re: Oracle CLOBS SQL
 
 
  [EMAIL PROTECTED] wrote:
  
   The clobs contain be free text with no HTML
 allowed.The links that may
   be in the clob will just be plain text and may
 not actually contain
   http://.
  
   It might just be www.domain.com or even
 domain.com, that's why I was
   thinking that I would need regexp, but was
 wondering aloud whether SQL
   could do something like that
 
  SQL doesn't do normal regex. But there is a
 functionality in SQL
  that combines parts from LIKE and regex, named
 SIMILAR TO. You
  might want to check the Oracle docs to see if it
 is supported.
  The pattern would look something like:
 
  SELECT *
  FROM table
  WHERE whatever SIMILAR TO
  '%[abcdefghijklmnopqrstuvwxyz]+.(com|org|net)%'
 
  Jochem
 
 
  -- 
  Who needs virtual reality
  if you can just dream?
 - Loesje
 
 
  


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re[2]: limit processor load of cfserver.exe ?

2003-11-14 Thread cf-talk
Hello Jochem,

Thursday, November 13, 2003, 11:29:40 PM, you wrote:

JvD [EMAIL PROTECTED] wrote:

 Hi list, is it (theoretically) possible,
 to limit the processor
 load coldfusion (cfserver.exe) is causing
 to the server itself ?(OS: Win2000 Server; CF: Version 5)

JvD Just give it a lower priority.

JvD Jochem

The bad part is, that I cannot change the priority
even though I am the administrator.
Strange windows. The message is: Access denied
Weird.

Uwe

-- 
Best regards,
 cf-talk mailto:[EMAIL PROTECTED]

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Setting Server Variables

2003-11-14 Thread DeMarco, Alex
How do I set server variables in CFMX 6.1? I want them to load everytime
the instance starts..

- Alex
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




  1   2   >