Re: Fusebox 3 Layouts

2004-12-23 Thread Kay Smoljak
On Wed, 22 Dec 2004 11:01:54 -0800, Barney Boisvert [EMAIL PROTECTED] wrote:
 I suspect you'll find that not many people are developing with Fusebox
 3 any more.  

I reckon you'd be surprised at the number of people who are... I've
got a stack of circuits, someone wants a new site, it's too easy to
whack em together and Bob's your uncle :)

-- 
Kay Smoljak
http://kay.smoljak.com/

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188606
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported.

2004-12-23 Thread Andrew Dixon
Hi All.

I have a problem with a Query of a Query. The error I'm getting is:

Query Of Queries runtime error.  
Sorting on columns of type java.sql.Types.NULL is not supported.  

The code is:

cfquery name=qry_accommodationData dbtype=query
SELECT   *
FROM   qry_accommodationData
ORDER BY #orderBy#, AdultPrice
/cfquery

Most of the time this works fine, but every now and again it gets a
dataset that it has this problem with. I have compared the first row
of a good dataset with the first row of bad dataset and they appear to
be pretty much same, apart from slightly different values. As far as
I'm aware CF uses the first row of the dataset to set the data types
and in both the good and bad datasets none of the columns in the first
have null values.

Anyone got any ideas?

Andrew.

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188607
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CFStoredProc bug?

2004-12-23 Thread Robertson-Ravo, Neil (RX)
Hey Nathan,

This was with cfstoredproc and cfprocparam, with this I have seen no lapse
or delay in SP's.  My point was merely that it was wrong of a DBA to assume
and state that the use of SP's was wrong.

That's not the point at all. We all know stored procedures are faster 
than plain vanilla sql statements. That's not in question, it's common 
sense.

Not true in all cases, we have had cases where an SP coded in SQL with
complex concepts is way slower than a SELECT and then all the logic
performed in CF - it's annoying when you have to do that but since CF does
not adhere to the timeout concept in CF sometimes it has to be done!

I still don't see any performance lag and we run SQL Profiler constantly!
Sure it is creating and using internal SP's but they are literally mini
footprints - certainly smaller footprints (in time) that it would be for CF
to startup, parse, shutdown and perform SQL passing...

No big deal, just what we have noticed and what we measure - its been a good
thread so far ;-)






-Original Message-
From: Nathan Strutz [mailto:[EMAIL PROTECTED] 
Sent: 22 December 2004 16:59
To: CF-Talk
Subject: Re: CFStoredProc bug?

Robertson-Ravo, Neil (RX) wrote:
 Based on the comments - I ran a quick test with an SP which basically ran
 the following (where iLanguageID and iEventID were @ variables passed in
via
 dbvarname):


How did you call the procedure, with cfquery or with cfstoredproc? Did 
you use cfqueryparam's? That's actually what this part of the thread 
is about. I suggest you try ALL the possibilities.

 
 Now, this is by no means a solid call as it can fluctuate between them
both
 taking 0 duration but never the SP taking any more than that and shows its
 more efficient.
 

That's not the point at all. We all know stored procedures are faster 
than plain vanilla sql statements. That's not in question, it's common 
sense.


 Client vars do perform updates internally using SP's for EVERY CALL if you
 do not switch that method off via the Client Vars section - maybe this is
 what your DBA was seeing?  This does indeed cause 3 SP's to run for every
 .CFM thread; turn the updates off if you don't need last visit and hit
count
 updated constantly.

Yes, I know that, problem is the app was relying on these variables. 
After disabling these updates, there was still overhead and inefficency 
on the DB storage for client vars. Run SQL Profiler on your database and 
you'll see it compiling and removing procedures all the time, not very 
good practice.

-nathan strutz
http://www.dopefly.com/




~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188608
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported.

2004-12-23 Thread Martin Parry
Hi Andrew

QofQ can be a bit of an arse some times (but bloody useful!)

I would suggest in your instance that you begin by narrowing down the
fields until you actually find the one(s) which are causing the NULL
error. Once you have done that, in the original query you could try
CASTing or CONVERTing to a supported data type - that way QofQ would
have a better guess at what each column is.

Give it a try.

Martin Parry
Macromedia Certified Developer
http://www.BeetrootStreet.co.uk

-Original Message-
From: Andrew Dixon [mailto:[EMAIL PROTECTED] 
Sent: 23 December 2004 08:54
To: CF-Talk
Subject: QofQ Problem: Sorting on columns of type java.sql.Types.NULL
is not supported.

Hi All.

I have a problem with a Query of a Query. The error I'm getting is:

Query Of Queries runtime error.  
Sorting on columns of type java.sql.Types.NULL is not supported.  

The code is:

cfquery name=qry_accommodationData dbtype=query
SELECT   *
FROM   qry_accommodationData
ORDER BY #orderBy#, AdultPrice
/cfquery

Most of the time this works fine, but every now and again it gets a
dataset that it has this problem with. I have compared the first row
of a good dataset with the first row of bad dataset and they appear to
be pretty much same, apart from slightly different values. As far as
I'm aware CF uses the first row of the dataset to set the data types
and in both the good and bad datasets none of the columns in the first
have null values.

Anyone got any ideas?

Andrew.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188609
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Fusebox 3 Layouts

2004-12-23 Thread Mark Drew
What would be really useful at this point is if people that have FBX3
applications send me their layout files so that I can test the layout
viewer.  Currently I am  not sure how to implement this in a view in
cfeclipse.

My thoughts were of a tree something like
/Application
/circuit [root]
/XFA.fuseaction
/XFA.fuseaction2
/layouts
/layoutname : layout file
/layoutname1: layout file 1
/default layout: layout file
/Fuseaction : layout
/fuse
/fuse
/Fuseaction : layout
/fuse
/fuse
/circuit2

Clicking on the /layouts node would take to the layout file
Clicking on the /layoutname : layout file  would take you to that layout file
or
Clicking on the layout name you could also set the variable (if you
are in a fuseaction) to something like
cfset homelayout = layoutname

Let me know what you think

The project homepage is : http://cfopen.org/projects/fusebox3cfe/

Regards

Mark Drew

On Thu, 23 Dec 2004 16:03:34 +0800, Kay Smoljak [EMAIL PROTECTED] wrote:
 On Wed, 22 Dec 2004 11:01:54 -0800, Barney Boisvert [EMAIL PROTECTED] wrote:
  I suspect you'll find that not many people are developing with Fusebox
  3 any more.
 
 I reckon you'd be surprised at the number of people who are... I've
 got a stack of circuits, someone wants a new site, it's too easy to
 whack em together and Bob's your uncle :)
 
 --
 Kay Smoljak
 http://kay.smoljak.com/
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188610
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


In One?

2004-12-23 Thread Ian Buzer
Hi,

This has been bugging me for about 3 years now, and I've finally decided to see 
if I can beat it (er... well see if I can find someone else that can beat it :)

I've got a db table with a typical category heirachy structure:

categoryId, parentCategoryId, categoryName,  etc..

Given a particular categoryId, is it possible to get the path back to the root 
category in only one db query? (given that the depth of the category in the 
structure is unknown).

Ian

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188611
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Micha Schopman
No that is not possible. When you have a specific amount of depth you
can, using multiple JOINS and separating the result with the IsNull. 

An example SPOC in MSSQL which returns a ColdFusion list with id's
seperated with || and a list with labels separated with ||:

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

ALTER  PROCEDURE dbo.upu_Instance_SitePath
@PageID int,
@SitePath   varchar (1000)  OUTPUT,
@PageIDsvarchar (1000)  OUTPUT
AS
-- Variables
DECLARE @lParentID  int
DECLARE @lSitePath  varchar (1000)
DECLARE @lPageIDs   varchar (1000)
-- Find Parent and Label
SELECT  @lParentID = I.ParentID,
@lSitePath = I.Label,
@lPageIDs = I.InstanceID
FROMdbo.Instance I
WHERE   (I.InstanceID = @PageID)
-- Resolve sitepath recursive
-- Subpages
IF (@lParentID  0) BEGIN
EXECdbo.upu_Instance_SitePath
@PageID = @lParentID,
@SitePath = @SitePath   OUTPUT,
@PageIDs = @PageIDs OUTPUT
-- Add label of current page to the full sitepath

SELECT  @SitePath = @SitePath + '|| ' + @lSitePath,
@PageIDs = @PageIDs + '|| '  + @lPageIDs
END
-- Homepage
ELSE BEGIN
SELECT  @SitePath = @lSitePath,
@PageIDs = @lPageIDs
END
-- The End
RETURN (0)

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO


Micha Schopman
Software Engineer

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188612
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Aaron DC
I think Oracle OO or object relational was supposed to do this natively, but
as far as i know, it is not possible to do an arbitrary number of dynamic
self-joins in native SQL.

You could always cheat and have a dynamically-sized text field containing a
comma separated list of the parentCategoryID hierarchy :)

Aaron

- Original Message -
From: Ian Buzer [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 23, 2004 8:03 PM
Subject: In One?


 Hi,

 This has been bugging me for about 3 years now, and I've finally decided
to see if I can beat it (er... well see if I can find someone else that can
beat it :)

 I've got a db table with a typical category heirachy structure:

 categoryId, parentCategoryId, categoryName,  etc..

 Given a particular categoryId, is it possible to get the path back to the
root category in only one db query? (given that the depth of the category in
the structure is unknown).

 Ian



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188613
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Micha Schopman
You could always cheat and have a dynamically-sized text field
containing a comma separated list of the parentCategoryID hierarchy :)

*cough* I think I misunderstood this suggestion ;) Even then, varchar
would be a better choice :P

Micha Schopman
Software Engineer

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188614
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Katz, Dov B (IT)
You could set your table up in a modified preorder tree traversal, so
each node has a LFT and RGT numeric value. I've done this in several
instances and it works great. 

See examples in this article:
http://www.sitepoint.com/article/hierarchical-data-database or google
for modified preorder

The query for you would be simple in this instance, assuming you're at
node X with rgt value R and L

Select n1.* From nodes n1, nodes n2
Where n2.nodeID=YOUR_ID
And n1.rgt=n2.rgt and n1.lft=n2.lft
Order by n1.rgt

Those are your nodes from the root until your desired node.

HTH,
dov


-Original Message-
From: Micha Schopman [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 5:25 AM
To: CF-Talk
Subject: RE: In One?

You could always cheat and have a dynamically-sized text field
containing a comma separated list of the parentCategoryID hierarchy :)

*cough* I think I misunderstood this suggestion ;) Even then, varchar
would be a better choice :P

Micha Schopman
Software Engineer

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort Tel 033-4535377, Fax
033-4535388 KvK Amersfoort 39081679, Rabo 39.48.05.380





~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188615
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Jochem van Dieten
Ian Buzer wrote:
 
 This has been bugging me for about 3 years now, and I've finally decided to 
 see if I can beat it (er... well see if I can find someone else that can beat 
 it :)
 
 I've got a db table with a typical category heirachy structure:
 
 categoryId, parentCategoryId, categoryName,  etc..
 
 Given a particular categoryId, is it possible to get the path back to the 
 root category in only one db query?

In SQL this is possible using the WITH (RECURSIVE) construct. DB2 
implements this currently and the next version of MS SQL Server 
will implement this. In Oracle and custom PostgreSQL builds you 
can achieve the same using the CONNECT BY statement which has 
slightly different semantics.

Jochem

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188616
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: I DID IT!! Shameless Self-promotion

2004-12-23 Thread Michael Traher
Well done!  

I passed in November and I notice today that my name now appears on
the macromedia site!

Should see yours there at the end of Jan.

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188617
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: OT: Mac/Flash Video assistance requested

2004-12-23 Thread Anthony Cooper
Tested on Safari, I can confirm that it doesn't work :(

Here's a guess, try adding the ?url... bit onto the src attribute in 
the embed tag also.

How are you loading the variables in from within flash?

On 23 Dec 2004, at 0:06, Dennis Powers wrote:

 Hi,

 I first have to confess my ignorance when it comes to the issues of 
 Mac web
 browsers and throw myself on the stake of the OS gods as supplication 
 for my
 shame!

 Having said that, I am hoping that I could gain some assistance from a 
 MAC
 user who might spare some time to determine where we have gone wrong 
 with a
 particular Flash Video applet we created and why it won't run in a MAC
 browser.

 The flash video applet can be found at
 http://www.halomaps.org/index.cfm?pg=15sid=17 select any from the 
 list.  We
 pull the *.flv video file name from a database then append it to the 
 URL
 line to tell the flash applet to run it.  Mac users are reporting that 
 they
 can't see it.  I suspect it has to do with the Flash plug-in version
 mismatch but I no longer have a MAC to test it with.   It appears to 
 work
 fine in Windows browsers with the Flash 7.x plug-in but MAC users are
 complaining.

 Any insight you can give to this lowly Windows programmer would be 
 greatly
 appreciated.

 Best Regards,

 Dennis Powers
 UXB Internet- A Website Design and Hosting Company
 690 Wolcott Road - P.O. Box 6028
 Wolcott, CT 06716tel: (203)879-2844
 http://www.uxbinternet.com
 http://dennis.uxb.net



 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188618
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SOT: linux/unix+ samba+IIS

2004-12-23 Thread Katz, Dov B (IT)
2 Questions: 
 
1) Does anyone serve out CF via IIS but upload/maniupulate files on
Linux/Unix via Samba+mapped drive, etc? I'm wondering how reliable a
solution like this is, for very few writes to a given file, and lots of
reads (which would be done via apache on the linux box directly)
 
2) is it easy to set up a pair of linux servers which synchronize a
certain portion of their filesystem (so changes are always mirrored to
the other one, regardless of which server it originated on).
 
Thanks, and Happy Holidays,
 -Dov 

 
NOTICE: If received in error, please destroy and notify sender.  Sender does 
not waive confidentiality or privilege, and use is prohibited. 
 


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188619
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


DateAdd problems.

2004-12-23 Thread Stuart Kidd
Hi,

I'm having an annoying problem with DateAdd.

I'm hosted in the States and I'm in the UK so to fix that in my Applicatin.cfm 
I've put:

cfset UKtodayDate = #DateAdd(h, 5, Now())#

That is fine and i've used it forever.

To find the current edition (month) of my magazine I use:

cfset thisEdition = lcase(MonthAsString(month(UKtodayDate)))

I want to have an image on my page which displays the next month's advert and 
I'm trying to get the next month's name.

I've tried:

cfset nextEdition = #DateAdd(m, 1, 
lcase(MonthAsString(month(UKtodayDate()#

This doesn't seem to work so I have broken it down into two lines which is:

cfset nextEditionA = #DateAdd(m, 1, Now())#
cfset nextEdition = lcase(MonthAsString(month(nextEditiona)))

This works BUT only when i use 'Now', but i'd really like to use 'UKtodayDate' 
(otherwise it's five hours behind) but for some bizarre reason it doesn't work.

Is it because when i do my initial DateAdd (cfset UKtodayDate = #DateAdd(h, 
5, Now())#) i'm doing it incorrectly?

Is there a way I can get all of this on 1 line instead of two?

Thanks for your help,

Saturday 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188620
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: DateAdd problems.

2004-12-23 Thread Pascal Peters
UKTodayDate is not a function, but a variable:

nextEdition = lcase(DateFormat(DateAdd(m, 1, UKTodayDate),))

 -Original Message-
 From: Stuart Kidd [mailto:[EMAIL PROTECTED]
 Sent: 23 December 2004 13:39
 To: CF-Talk
 Subject: DateAdd problems.
 
 Hi,
 
 I'm having an annoying problem with DateAdd.
 
 I'm hosted in the States and I'm in the UK so to fix that in my
 Applicatin.cfm I've put:
 
 cfset UKtodayDate = #DateAdd(h, 5, Now())#
 
 That is fine and i've used it forever.
 
 To find the current edition (month) of my magazine I use:
 
 cfset thisEdition = lcase(MonthAsString(month(UKtodayDate)))
 
 I want to have an image on my page which displays the next month's
advert
 and I'm trying to get the next month's name.
 
 I've tried:
 
 cfset nextEdition = #DateAdd(m, 1,
 lcase(MonthAsString(month(UKtodayDate()#
 
 This doesn't seem to work so I have broken it down into two lines
which
 is:
 
 cfset nextEditionA = #DateAdd(m, 1, Now())#
 cfset nextEdition = lcase(MonthAsString(month(nextEditiona)))
 
 This works BUT only when i use 'Now', but i'd really like to use
 'UKtodayDate' (otherwise it's five hours behind) but for some bizarre
 reason it doesn't work.
 
 Is it because when i do my initial DateAdd (cfset UKtodayDate =
 #DateAdd(h, 5, Now())#) i'm doing it incorrectly?
 
 Is there a way I can get all of this on 1 line instead of two?
 
 Thanks for your help,
 
 Saturday
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188621
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: DateAdd problems.

2004-12-23 Thread Anthony Cooper
 cfset nextEdition = #DateAdd(m, 1, 
 lcase(MonthAsString(month(UKtodayDate()#

Hi Saturday,
Noticed you've got an extra set of arguments after UKtodayDate which 
could be your problem, try:

cfset nextEdition = DateAdd(m, 1, 
lcase(MonthAsString(month(UKtodayDate

Also in the UK and always on the look out for a good host, have you 
found a US Host that's easy to deal with from here? Reply off list if 
you like.

Thanks,
Ant


~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188622
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: DateAdd problems.

2004-12-23 Thread Stuart Kidd
That is perfect, thanks Pascal!

Saturday.


-- Original Message --
From: Pascal Peters [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
Date:  Thu, 23 Dec 2004 13:48:45 +0100

UKTodayDate is not a function, but a variable:

nextEdition = lcase(DateFormat(DateAdd(m, 1, UKTodayDate),))

 -Original Message-
 From: Stuart Kidd [mailto:[EMAIL PROTECTED]
 Sent: 23 December 2004 13:39
 To: CF-Talk
 Subject: DateAdd problems.
 
 Hi,
 
 I'm having an annoying problem with DateAdd.
 
 I'm hosted in the States and I'm in the UK so to fix that in my
 Applicatin.cfm I've put:
 
 cfset UKtodayDate = #DateAdd(h, 5, Now())#
 
 That is fine and i've used it forever.
 
 To find the current edition (month) of my magazine I use:
 
 cfset thisEdition = lcase(MonthAsString(month(UKtodayDate)))
 
 I want to have an image on my page which displays the next month's
advert
 and I'm trying to get the next month's name.
 
 I've tried:
 
 cfset nextEdition = #DateAdd(m, 1,
 lcase(MonthAsString(month(UKtodayDate()#
 
 This doesn't seem to work so I have broken it down into two lines
which
 is:
 
 cfset nextEditionA = #DateAdd(m, 1, Now())#
 cfset nextEdition = lcase(MonthAsString(month(nextEditiona)))
 
 This works BUT only when i use 'Now', but i'd really like to use
 'UKtodayDate' (otherwise it's five hours behind) but for some bizarre
 reason it doesn't work.
 
 Is it because when i do my initial DateAdd (cfset UKtodayDate =
 #DateAdd(h, 5, Now())#) i'm doing it incorrectly?
 
 Is there a way I can get all of this on 1 line instead of two?
 
 Thanks for your help,
 
 Saturday
 
 



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188623
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Seeing double?

2004-12-23 Thread Katz, Dov B (IT)
You're all going to love this one... 

I was batch downloading a replica of the site using the SmartFTP client
and it's global queue

Apparently theres a known issue whereby on file-exists-on-client it
appends  instead of overwrites.

How frustrating! I didn't actually expect cf to be at fault (I couldn't
figure out how it would behave differently on that pc), but was out of
things to look for.

Thanks to all for your time.

-Original Message-
From: Katz, Dov B (IT) 
Sent: Wednesday, December 22, 2004 8:54 AM
To: CF-Talk
Subject: RE: Seeing double?

Right. This much I know... The code switches on executionmode which is
why it makes a good single cfmodule call for start-end use.  It works
perfectly on one server (dual 1ghz, 1gb ram, 6,1,0,hf53633_61), but when
the code was copied to the other (quad 2.4ghz, 2gb ram, 6,1,0,83762) it
looks strange.

I'm wondering if it has to do with race conditions, and compiling on 4
processors, etc...  The code has worked for 2 years flawlessly on the
previous server.

Thanks in advance for any further insight.

-dov

-Original Message-
From: Anthony Cooper [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 22, 2004 8:48 AM
To: CF-Talk
Subject: Re: Seeing double?

If you've closed the tag or used a / at the end, it will get called
twice. You need to checkout the value of thisTag.executionMode, read
more here:

http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/reusec18.htm

On 22 Dec 2004, at 13:39, Katz, Dov B (IT) wrote:

 I have a dev machine (www.4simchas.com) which has quad 2.4 ghz 
 processors, running the latest 6.1 release

 I have an app (replica of my prod env) which is running there, and 
 most of my layout elements consist of custom tags (CF_page
 argscontent/cf_page)

 What I'm finding is that the headers and footers respectively are 
 appearing twice... this seems to happen only with content being 
 brought into pages via CFMODULE.

 Any advice (check it out, it's very wierd).

 -Dov
 

 NOTICE: If received in error, please destroy and notify sender.  
 Sender does not waive confidentiality or privilege, and use is 
 prohibited.



 





~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188624
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Aaron DC
Is varchar fixed in size? If so the field would not satisfy an arbitrary
depth of hierarchy. By dynamically-sized text field I mean any field type
that allows an unlimited dynamic length of text, like the memo field in MS
Access or DBISAM and is a generic description of what I meant. Apply as you
see fit to your db of choice!

Varchar in MySQL (255 chars max) is very different to Varchar in MS SQL
Server (4000 chars max).

I guess more than anything I'm struggling with someone saying that they dont
understand what I'm suggesting then telling me here's how to make it
better. Ah well. Hope your cough clears up, and Merry Christmas :-)

Aaron

- Original Message -
From: Micha Schopman [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 23, 2004 9:24 PM
Subject: RE: In One?


 You could always cheat and have a dynamically-sized text field
 containing a comma separated list of the parentCategoryID hierarchy :)

 *cough* I think I misunderstood this suggestion ;) Even then, varchar
 would be a better choice :P

 Micha Schopman
 Software Engineer



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188625
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: DateAdd problems.

2004-12-23 Thread Stuart Kidd
Hi Ant,

I just got the solution from Pascal, thanks anyhow.

I use www.hostmysite.com, i find them really good actually - i've been with 
them about 3 or 4 years.  I've tried other US firms in the past like Interland 
but their customer support was really bad.  I often get replies to my emails 
within 10 minutes which are well thought out responses which are very helpful.  
I've never had them try to fob me off with short replies.

I've never had to bother to call them though(i hate waiting on the end of a 
phone).

I have a CF MX 6.1, 500MB, MS-SQL 50mb/25mg log (i think).

Hope that helps.

Saturday




-- Original Message --
From: Anthony Cooper [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
Date:  Thu, 23 Dec 2004 12:51:41 +

 cfset nextEdition = #DateAdd(m, 1, 
 lcase(MonthAsString(month(UKtodayDate()#

Hi Saturday,
Noticed you've got an extra set of arguments after UKtodayDate which 
could be your problem, try:

cfset nextEdition = DateAdd(m, 1, 
lcase(MonthAsString(month(UKtodayDate

Also in the UK and always on the look out for a good host, have you 
found a US Host that's easy to deal with from here? Reply off list if 
you like.

Thanks,
Ant




~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188626
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Katz, Dov B (IT)
I urge you to avoid doing that.

Lets say you have a 3000 node tree, evenly distributed looking something
like this:

  A 
 B C
DE FG
...
Thousands/hundreds of nodes under here

If you , say want to insert B2, between A and B, you have to update the
varchar/text path column for several thousand nodes, (all of B's
ancestry) which by its datatype (varchar/text), and number of updates
can be very costly.  (text, linear, at worst)



Alternatively if you do it using modified preorder tree traversal, you
would be making numeric updates in order to do the same.   (numeric,
linear, at worst)



Granted, both of these are the costs of precomputing helper data to
avoid recursing every time you need to find out the structure and paths
of arbitrary nodes, but if you are going to do either, I suggest the
latter.

-Dov




-Original Message-
From: Aaron DC [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 7:59 AM
To: CF-Talk
Subject: Re: In One?

Is varchar fixed in size? If so the field would not satisfy an arbitrary
depth of hierarchy. By dynamically-sized text field I mean any field
type that allows an unlimited dynamic length of text, like the memo
field in MS Access or DBISAM and is a generic description of what I
meant. Apply as you see fit to your db of choice!

Varchar in MySQL (255 chars max) is very different to Varchar in MS SQL
Server (4000 chars max).

I guess more than anything I'm struggling with someone saying that they
dont understand what I'm suggesting then telling me here's how to make
it better. Ah well. Hope your cough clears up, and Merry Christmas :-)

Aaron

- Original Message -
From: Micha Schopman [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 23, 2004 9:24 PM
Subject: RE: In One?


 You could always cheat and have a dynamically-sized text field 
 containing a comma separated list of the parentCategoryID hierarchy
:)

 *cough* I think I misunderstood this suggestion ;) Even then, varchar 
 would be a better choice :P

 Micha Schopman
 Software Engineer





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188627
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: DateAdd problems.

2004-12-23 Thread Pascal Peters
DateAdd takes a date as 3rd argument, not the name of the month

Pascal

 
 cfset nextEdition = DateAdd(m, 1,
 lcase(MonthAsString(month(UKtodayDate
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188628
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Micha Schopman
I thought you were making a joke.. :) One of the principles of a good
database design is not to use lists of id's. You could better if you
really want to do such thing, create a seperate table to store the path.
The disadvantage of using lists is, you cannot use constraints to force
existing relationships and you cannot index the data in a optimal form.

You'd be better off with two tables like:

Table 1: Path
ID = Identity
ObjectID = Int (object for which the path is stored, so this could also
be ArticleID for example)

Table 2: PathData
ID = Identity
PathID = Int (Contains ID from the Path table)
Priority = TinyInt (Contains an order)
Target = Int (contains the result of a path, can be ID, anything you
want to)

So with this data

Path table:
ID = 1
ObjectID = 138475384047

PathData
ID = 1
PathID = 1
Priority = 1
Target = 3567242

ID = 1
PathID = 1
Priority = 2
Target = 3453456

ID = 1
PathID = 1
Priority = 3
Target = 75637


So you'll get the path for ObjectID = 138475384047 
Path = 3567242,3453456,75637

And this data can easily be extended with constraints, indexes etc.


Micha Schopman
Software Engineer

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188629
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Aaron DC
H I was not too serious - hence my use of the word cheat. You did
understand my suggestion, but wanted to make it better, by using VarChar.
I still fail to see how using varchar would make it better.
Having developed a number of databases in my time I am well aware of the
improperness of storing lists of id's.

The customer wanted to:
[store an arbitrary length hierarchy in one table] and
[retrieve the path to the root parent]
[in one query].

I believe my solution works based on these requirements/deliverables.
Heck, I'm going to suggest storing both the ID and the Category name for
display purposes :p

Didn't say it was elegant, valid, correct or the right shade of blue. No
mention was made by the customer of modifying the hierarchy nodes or
anything. I can come up with solutions for that too, but it'll cost them
extra :)

The customer wanted a solution and that's all I was offering. And it's
definitely cheating. :-) I've seen many properly designed database
projects fail to complete and many home grown syntactically incorrect
nightmare RDBMS (MS Access!) designs survive for years in both large and
small organisations.

Aaron

- Original Message -
From: Micha Schopman [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, December 24, 2004 12:18 AM
Subject: RE: In One?


 I thought you were making a joke.. :) One of the principles of a good
 database design is not to use lists of id's. You could better if you
 really want to do such thing, create a seperate table to store the path.
 The disadvantage of using lists is, you cannot use constraints to force
 existing relationships and you cannot index the data in a optimal form.

 You'd be better off with two tables like:

 Table 1: Path
 ID = Identity
 ObjectID = Int (object for which the path is stored, so this could also
 be ArticleID for example)

 Table 2: PathData
 ID = Identity
 PathID = Int (Contains ID from the Path table)
 Priority = TinyInt (Contains an order)
 Target = Int (contains the result of a path, can be ID, anything you
 want to)

 So with this data

 Path table:
 ID = 1
 ObjectID = 138475384047

 PathData
 ID = 1
 PathID = 1
 Priority = 1
 Target = 3567242

 ID = 1
 PathID = 1
 Priority = 2
 Target = 3453456



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188630
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Micha Schopman
Columns of the type text are stored in a different way than varchar
columns. Varchar columns have a much lesser effect on performance, and
the amount of characters is more than enough to store paths from new
york to tokio.

Text columns are stored with pointers in another place, because it is a
variable length column. They aren't stored along with the row, but the
row only contains a pointer to the place where the text column is
stored, and this slows a table down.

SQL Server features functionality to combine the performance power of
varchar with the flexibility power of text by using text in row. This
allows you to say to SQL Server store the first XXX characters with the
row, and the rest in another spot and create pointer to it. The will
dramatically increase performance, and I could recommend everyone using
text columns to use this feature. It is truly awesome. I did some
extensive testing and noticed improvements over 1000% speed on large
tables. The feature is called text in row. You first must enable the
feature and then update each row to follow the new rules of storage.


EXEC sp_tableoption 'Content', 'text in row', 'ON'
GO

UPDATE Content
SET Data = C.Data,
FROM Content C


Micha Schopman
Software Engineer

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188631
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


404 headaches - Windows O/S

2004-12-23 Thread John Inferrera
I have been working to get custom 404 error handlers with auto email and it 
appears I am incapable (or plain irritated) of getting it done. We migrated all 
htm to cfm  and want to verify all is well.

I set the CF Admin (CF MX 6.1, W2K3 Server) to handle 404 errors for CF pages 
and it is fine. The problem I am having is when I set IIS 6 to go to the same 
page (404.cfm) I get mixed results?

Such as I received over 500 + emails in minutes (No way I have that many 
404’s ( (I setup auto email to notify of course)) and I think the page has 
issues. My concerns are these two:

1. I am unable to capture the requested page, I tried #CGI.SCRIPT_NAME#, 
#CGI.PATH_INFO# and I get the 404.cfm page as the requested page every time? 
(The CF admin page gets the right one when I tested it)

2. I was bombarded with emails to the point I had to comment out the cfmail 
tag, when I checked the referral page (#CGI.HTTP_ REFERER#) and there were no 
broken links? It would help to know what page was requested!

If anyone has any insight I would appreciate it, I am at my wits end and I have 
searched for weeks and cannot locate any threads anywhere that can shed some 
light on this,only other confused individuals.

This is the following sendmail code:

cfmail to=[EMAIL PROTECTED] from=[EMAIL PROTECTED] subject=404 Error/File 
Missing type=html
A 404 Error Occuredbrbr
Time Stamp: #DateFormat(NOW(),'MM/DD/')# at #TimeFormat(NOW(),'hh:mm:ss 
tt')#brbr
Details:br
Request Method:nbsp;#CGI.HTTP_REQUEST_METHOD#br
IP Address:nbsp;#CGI.REMOTE_ADDR#br
Browser/Details:nbsp;#CGI.HTTP_USER_AGENT#br
Refferal Page:nbsp;a href=#CGI.HTTP_REFERER##CGI.HTTP_REFERER#/abr
br
Please review links of the following page:br
Request Info:nbsp; #CGI.PATH_INFO#br
/cfmail

All apologies for the length, just want to be clear as possible,

Thanks!
John

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188632
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Aaron DC
We don't know (and I won't assume) that the customer is using SQL Server.

Aaron

- Original Message - 
From: Micha Schopman [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, December 24, 2004 1:07 AM
Subject: RE: In One?


 Columns of the type text are stored in a different way than varchar
 columns. Varchar columns have a much lesser effect on performance, and
 the amount of characters is more than enough to store paths from new
 york to tokio.



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188633
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Ben Rogers
Performance often comes at the sake of good design. Good design should
always come first though. :)

Ben Rogers
http://www.c4.net
v.508.240.0051
f.508.240.0057

 -Original Message-
 From: Micha Schopman [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 23, 2004 8:19 AM
 To: CF-Talk
 Subject: RE: In One?
 
 I thought you were making a joke.. :) One of the principles of a good
 database design is not to use lists of id's. You could better if you
 really want to do such thing, create a seperate table to store the path.
 The disadvantage of using lists is, you cannot use constraints to force
 existing relationships and you cannot index the data in a optimal form.
 
 You'd be better off with two tables like:
 
 Table 1: Path
 ID = Identity
 ObjectID = Int (object for which the path is stored, so this could also
 be ArticleID for example)
 
 Table 2: PathData
 ID = Identity
 PathID = Int (Contains ID from the Path table)
 Priority = TinyInt (Contains an order)
 Target = Int (contains the result of a path, can be ID, anything you
 want to)
 
 So with this data
 
 Path table:
 ID = 1
 ObjectID = 138475384047
 
 PathData
 ID = 1
 PathID = 1
 Priority = 1
 Target = 3567242
 
 ID = 1
 PathID = 1
 Priority = 2
 Target = 3453456
 
 ID = 1
 PathID = 1
 Priority = 3
 Target = 75637
 
 
 So you'll get the path for ObjectID = 138475384047
 Path = 3567242,3453456,75637
 
 And this data can easily be extended with constraints, indexes etc.
 
 
 Micha Schopman
 Software Engineer
 
 Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
 Tel 033-4535377, Fax 033-4535388
 KvK Amersfoort 39081679, Rabo 39.48.05.380
 
 
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188634
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


SOT: Flash list

2004-12-23 Thread Murat Demirci
Hi folks,

I'm searching an active Flash developers list like CF-Talk. Does anyone know an 
active flash list?

Murat.



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188635
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Micha Schopman
And that is why I suggested the table approach instead of a list
approach. Constraints are a important part of good design, and cannot be
achieved with lists.

Micha Schopman
Project Manager

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188636
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: QofQ Problem: Sorting on columns of type java.sql.Types.NULL is not supported.

2004-12-23 Thread Andy Ousterhout
Question is how do you want to treat Null.  Since NULL has no value, you
will have to use IsNULLL() or your db equivalent to set a value that is
either the highest or lowest, depending on how you wish to sort.  If you
need to keep the value as NULL, then create a sort field that contains the
converted value(s).

Andy

-Original Message-
From: Andrew Dixon [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 2:54 AM
To: CF-Talk
Subject: QofQ Problem: Sorting on columns of type java.sql.Types.NULL
is not supported.


Hi All.

I have a problem with a Query of a Query. The error I'm getting is:

Query Of Queries runtime error.
Sorting on columns of type java.sql.Types.NULL is not supported.

The code is:

cfquery name=qry_accommodationData dbtype=query
SELECT   *
FROM   qry_accommodationData
ORDER BY #orderBy#, AdultPrice
/cfquery

Most of the time this works fine, but every now and again it gets a
dataset that it has this problem with. I have compared the first row
of a good dataset with the first row of bad dataset and they appear to
be pretty much same, apart from slightly different values. As far as
I'm aware CF uses the first row of the dataset to set the data types
and in both the good and bad datasets none of the columns in the first
have null values.

Anyone got any ideas?

Andrew.



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188637
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Micha Schopman
I meant relations

Micha Schopman
Software Engineer

Modern Media, Databankweg 12 M, 3821 AL  Amersfoort
Tel 033-4535377, Fax 033-4535388
KvK Amersfoort 39081679, Rabo 39.48.05.380



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188638
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: SOT: Flash list

2004-12-23 Thread Jaye Morris
Flashcoders

http://chattyfig.figleaf.com/


On Thu, 23 Dec 2004 16:33:25 +0200, Murat Demirci [EMAIL PROTECTED] wrote:
 Hi folks,
 
 I'm searching an active Flash developers list like CF-Talk. Does anyone know 
 an active flash list?
 
 Murat.
 
 
-- 
// Jaye Morris | Multimedia - Web Applications Developer
// www.jayezero.com
// [EMAIL PROTECTED]
// [EMAIL PROTECTED]

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188639
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Ian Buzer
You could set your table up in a modified preorder tree traversal, so
each node has a LFT and RGT numeric value. I've done this in several
instances and it works great. 

Hey, thanks Dov, that's lovely.

As far as I understand it so far, it does have the snag that if you make a 
change near the top of the hierachy, a whole lot of data below has to be 
updated.

Also, in this particular instance, I'm importing the category heirachy from 
another app on a daily basis which uses the other schema, so I'm probably 
looking at a long process to convert it from one schema to another during the 
import.

Ian

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188640
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


How to make mx run all .php extensions

2004-12-23 Thread gabriel l smallman
Hey all,

Trying to make mx handle all .php extensions. On iis 6 we remapped to the
extension but no get at message: 

Server Error
Either the Macromedia application server is unreachable or it does not have
a mapping to process this request.

Im guessing in some xml file jrun is told what extensions to handle? Anyone
done this before and have any insight?


gabe


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188641
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Aaron DC
With none of the previous message in your post I have no idea what you are
replying to here. Please include some of the previous post to which you are
replying, to maintain context.

Thanks
Aaron

- Original Message -
From: Micha Schopman [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Friday, December 24, 2004 1:40 AM
Subject: RE: In One?


 And that is why I suggested the table approach instead of a list
 approach. Constraints are a important part of good design, and cannot be
 achieved with lists.

 Micha Schopman
 Project Manager



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188642
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to make mx run all .php extensions

2004-12-23 Thread Andy Allan
cfmxroot/wwwroot/WEB-INF/web.xml

Though I'm sure you're aware you can't actually process PHP code via CFMX

Andy


On Thu, 23 Dec 2004 10:04:28 -0500, gabriel l smallman
[EMAIL PROTECTED] wrote:
 Hey all,
 
 Trying to make mx handle all .php extensions. On iis 6 we remapped to the
 extension but no get at message:
 
 Server Error
 Either the Macromedia application server is unreachable or it does not have
 a mapping to process this request.
 
 Im guessing in some xml file jrun is told what extensions to handle? Anyone
 done this before and have any insight?
 
 gabe
 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188643
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CFLock , CF_Accelerate(like) help

2004-12-23 Thread Katz, Dov B (IT)
So, a while back, I wrote a CF_Accelerate-like tag (before I knew of
that one) and this one cached to file, memory, or cached query objects.
I think my locking is too aggressive, and is hurting performance. I
stripped down the tag below for readability...

Can you please advise me whether I can change this around in any way to
help performance?  (Downgrade any cflocks from exclusive to readonly?
Maybe eliminate some locking?)

Also, which of  CFFILE+Read vs. getPageContext.include()  is more costly
for outputting the cached file content?

For file-basedc caching, I write to [filename]_tmp, and then move it to
[filename] on the first read.  I was worried about clashes...

Any tips would be helpful... 

Thanks!


---

Cfparam name=attributes.mode default=File|Memory|Query
Cfparam name=attributes.key
Cfparam name=attributes.expires
Cfparam name=attributes.clearcache default=false
cfparam name=application.contentcache default=#Structnew()#
cfparam name=application.memorycachetagoutput
default=#Structnew()#
cfparam name=application.mainquerycache default=#Structnew()#
cfif thistag.executionmode is Start
cfif NOT attributes.clearcache 
AND
structkeyexists(application.contentcache,attributes.key) 
AND
abs(datediff('n',structfind(Application.contentcache,attributes.key),now
())) LT attributes.expires
!--- CACHE HIT! ---
cflock timeout=15  type=exclusive
name=CacheTagOutput_#attributes.key#
Cfif attributes.mode is File
cfif fileexists(filename _tmp)
Cfif fileexists(filename)cffile
action=delete file=#filename# /cfif
cffile action=rename source=#filename#_tmp
destination=#filename#
/cfif
!--- used to be CFFILE reading ---
Cfset
getPageContext().include(#attributes.pagepath#partial_tag_cache/#attrib
utes.key#.cache)
cfelseif attributes.mode is memory

Cfoutput#structfind(Application.memorycachetagoutput,attributes.key)#
/cfoutput
cfelseif attributes.mode is query
CfoutputCfset
caller.#attributes.queryname#=#structfind(Application.mainquerycache,a
ttributes.key)#/cfoutput
/cfif
cfexit
/cflock

/cfif
cfelseif thistag.executionmode is End
!--- CACHE MISS (wouldn't have made it this far if a
hit) ---
!--- Insert Content ---
cflock  timeout=10 type=exclusive
name=CacheTagOutput_#attributes.key#
Cfif attributes.mode is file
cffile action=WRITE file=#filename#_tmp
output=#thistag.generatedcontent# addnewline=No
cfelseif attributes.mode is memory
cfset
structinsert(Application.memorycachetagoutput,attributes.key,#thistag.g
eneratedcontent#,true)
cfelseif attributes.mode is query
Cfquery dbtype=query
name=cachedQueryselect * From caller.#attributes.queryname#
/cfquery
cfset
structinsert(Application.mainquerycache,attributes.key,cachedQuery,true)

/cfif
!--- UPDATE TIMESTAMP OF KEY ---
cfset
structinsert(Application.cachetagoutput,attributes.key,now(),true)
/cflock
/cfif


/cfif 

 
NOTICE: If received in error, please destroy and notify sender.  Sender does 
not waive confidentiality or privilege, and use is prohibited. 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188644
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


CF tags work inside of CSS

2004-12-23 Thread Stuart Kidd
Hi,

I have a colour theme which changes each month.  Instead of having 12 different 
stylesheets to cover for the year i wanted to have some CF code at top of my 
CSS page, something like:

cfswitch expression=#thisMonth#
cfcase value=january
cfset myColour = #08BF83
/cfcase
cfcase value=february
cfset myColour = #085F83
/cfcase
cfcase value=march
cfset myColour = #08B383
/cfcase
/cfswitch

So when I get down to the part in the stylesheet which says:

a.preferences:hover {
color: #FF;
background-color: #8DC63F;
padding-top: 0px;
padding-right: 6px;
padding-bottom: 0px;
padding-left: 6px;
border: 1px solid cfoutput#myColour#/cfoutput;
margin: 5px 4px;
text-decoration: none;
font-size: 10px;
}

I've never tried this, do CF tags work in CSS?

Thanks for you time,

Saturday

ps: for those North Americans... cfset myColour = myColor ;)
(it's actually looks weird seeing it written as 'colour' nowadays). 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188645
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Katz, Dov B (IT)
True, but no matter what your choice of optimization, you will have a
snag.  You will be doing more reads than writes, and you will be doing
an in-table mathematic transformation (set LFT=LFT+1 or RGT=RGT+2 for
all rows whose left exceeds the newly inserted one...) That's linear,
but IMHO well worth it...

Check http://www.intelligententerprise.com/001020/celko1_1.jhtml,
someone already wrote an import query from adjacency list (which is what
everyone's used to -- row points to parent row) into this app.

Disclaimer message=this might not make senseI've never done this,
but I'm sure you can avoid re-balancing your tree if you assign LFT,RGT
values in increments of 100 (remember good old' prodos BASIC from my
early apple childhood). This way a single insert won't force a
rebalance. (you'd insert parent.LFT+1, and have for your children, all
numbers between parent.LFT+2 until your sibling's LFT, or your parent's
RGT (if you are an only child)... It would complicate things, but slow
down your update rate.../Disclaimer

-Dov

-Original Message-
From: Ian Buzer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 8:51 AM
To: CF-Talk
Subject: Re: In One?

You could set your table up in a modified preorder tree traversal, so

each node has a LFT and RGT numeric value. I've done this in 
several instances and it works great.

Hey, thanks Dov, that's lovely.

As far as I understand it so far, it does have the snag that if you make
a change near the top of the hierachy, a whole lot of data below has to
be updated.

Also, in this particular instance, I'm importing the category heirachy
from another app on a daily basis which uses the other schema, so I'm
probably looking at a long process to convert it from one schema to
another during the import.

Ian



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188646
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: In One?

2004-12-23 Thread Damien McKenna
My suggestion...

Cache the data (application-scope variable) then use local UDFs or a CFC
to manage processing.

-- 
Damien McKenna - Web Developer - [EMAIL PROTECTED]
The Limu Company - http://www.thelimucompany.com/ - 407-804-1014
#include stdjoke.h
 

 -Original Message-
 From: Ian Buzer [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, December 23, 2004 4:04 AM
 To: CF-Talk
 Subject: In One?
 
 Hi,
 
 This has been bugging me for about 3 years now, and I've 
 finally decided to see if I can beat it (er... well see if I 
 can find someone else that can beat it :)
 
 I've got a db table with a typical category heirachy structure:
 
 categoryId, parentCategoryId, categoryName,  etc..
 
 Given a particular categoryId, is it possible to get the path 
 back to the root category in only one db query? (given that 
 the depth of the category in the structure is unknown).
 
 Ian
 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188647
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF tags work inside of CSS

2004-12-23 Thread Charlie Griefer
CF won't fire unless the page is a .cfm or .cfml extension.  A .css
extension won't trigger CF to render the page.



On Thu, 23 Dec 2004 10:15:50 -0500, Stuart Kidd [EMAIL PROTECTED] wrote:
 Hi,
 
 I have a colour theme which changes each month.  Instead of having 12 
 different stylesheets to cover for the year i wanted to have some CF code at 
 top of my CSS page, something like:
 
 cfswitch expression=#thisMonth#
 cfcase value=january
 cfset myColour = #08BF83
 /cfcase
 cfcase value=february
 cfset myColour = #085F83
 /cfcase
 cfcase value=march
 cfset myColour = #08B383
 /cfcase
 /cfswitch
 
 So when I get down to the part in the stylesheet which says:
 
 a.preferences:hover {
 color: #FF;
 background-color: #8DC63F;
 padding-top: 0px;
 padding-right: 6px;
 padding-bottom: 0px;
 padding-left: 6px;
 border: 1px solid cfoutput#myColour#/cfoutput;
 margin: 5px 4px;
 text-decoration: none;
 font-size: 10px;
 }
 
 I've never tried this, do CF tags work in CSS?
 
 Thanks for you time,
 
 Saturday
 
 ps: for those North Americans... cfset myColour = myColor ;)
 (it's actually looks weird seeing it written as 'colour' nowadays).
 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188648
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF tags work inside of CSS

2004-12-23 Thread Massimo Foti
 I've never tried this, do CF tags work in CSS?

I am not sure if I understood your question, but I will give it a try.
In case you would like to embed CFML code inside an external CSS file a
solution could be to give the CSS file a .cfm extension, then add this at
the top of it:

cfcontent type=text/css; charset=ISO-8859-1 (use the charset you see
fit)

This way the file will be processed by CF server but served with a text/css
mime-type so browsers will recognize it as CSS

Hope it will help


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/




~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188649
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF tags work inside of CSS

2004-12-23 Thread Stuart Kidd
Ok, damn! Oh well, looks like a few files instead then.


-- Original Message --
From: Charlie Griefer [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
Date:  Thu, 23 Dec 2004 08:27:01 -0700

CF won't fire unless the page is a .cfm or .cfml extension.  A .css
extension won't trigger CF to render the page.



On Thu, 23 Dec 2004 10:15:50 -0500, Stuart Kidd [EMAIL PROTECTED] wrote:
 Hi,
 
 I have a colour theme which changes each month.  Instead of having 12 
 different stylesheets to cover for the year i wanted to have some CF code at 
 top of my CSS page, something like:
 
 cfswitch expression=#thisMonth#
 cfcase value=january
 cfset myColour = #08BF83
 /cfcase
 cfcase value=february
 cfset myColour = #085F83
 /cfcase
 cfcase value=march
 cfset myColour = #08B383
 /cfcase
 /cfswitch
 
 So when I get down to the part in the stylesheet which says:
 
 a.preferences:hover {
 color: #FF;
 background-color: #8DC63F;
 padding-top: 0px;
 padding-right: 6px;
 padding-bottom: 0px;
 padding-left: 6px;
 border: 1px solid cfoutput#myColour#/cfoutput;
 margin: 5px 4px;
 text-decoration: none;
 font-size: 10px;
 }
 
 I've never tried this, do CF tags work in CSS?
 
 Thanks for you time,
 
 Saturday
 
 ps: for those North Americans... cfset myColour = myColor ;)
 (it's actually looks weird seeing it written as 'colour' nowadays).
 
 



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188650
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF tags work inside of CSS

2004-12-23 Thread Pascal Peters
Yes, just give your css file a cfm extension and use cfcontent to have
the correct mime-type (although it will work without)

Pascal

 -Original Message-
 From: Stuart Kidd [mailto:[EMAIL PROTECTED]
 Sent: 23 December 2004 16:16
 To: CF-Talk
 Subject: CF tags work inside of CSS
 
 Hi,
 
 I have a colour theme which changes each month.  Instead of having 12
 different stylesheets to cover for the year i wanted to have some CF
code
 at top of my CSS page, something like:
 
 cfswitch expression=#thisMonth#
 cfcase value=january
 cfset myColour = #08BF83
 /cfcase
 cfcase value=february
 cfset myColour = #085F83
 /cfcase
 cfcase value=march
 cfset myColour = #08B383
 /cfcase
 /cfswitch
 
 So when I get down to the part in the stylesheet which says:
 
 a.preferences:hover {
   color: #FF;
   background-color: #8DC63F;
   padding-top: 0px;
   padding-right: 6px;
   padding-bottom: 0px;
   padding-left: 6px;
   border: 1px solid cfoutput#myColour#/cfoutput;
   margin: 5px 4px;
   text-decoration: none;
   font-size: 10px;
 }
 
 I've never tried this, do CF tags work in CSS?
 
 Thanks for you time,
 
 Saturday
 
 ps: for those North Americans... cfset myColour = myColor ;)
 (it's actually looks weird seeing it written as 'colour' nowadays).
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188651
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF tags work inside of CSS

2004-12-23 Thread Dawson, Michael
This topic came up a several days ago.  Read the archives for more
details than what I can remember right now.

1. Create multiple CSS files.  One file will contain only layout and
formatting.  Then, create individual CSS files that contain only color
information.  You would have an individual CSS file for each color
theme, however, you only need a single CSS file for layout.  In your CF
template, just use a CF construct to determine which CSS color file to
use.  This is nice because the browser can cache the CSS files.

2. Use CF to generate the CSS dynamically and use CFCONTENT to pass the
correct CSS document type.  (More information in these archives.)  This
is not as good because CF must process the CSS page, then then send it
to the browser.  The browser won't cache the CSS.

M!ke

-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 9:16 AM
To: CF-Talk
Subject: CF tags work inside of CSS

Hi,

I have a colour theme which changes each month.  Instead of having 12
different stylesheets to cover for the year i wanted to have some CF
code at top of my CSS page, something like:

cfswitch expression=#thisMonth#
cfcase value=january
cfset myColour = #08BF83
/cfcase
cfcase value=february
cfset myColour = #085F83
/cfcase
cfcase value=march
cfset myColour = #08B383
/cfcase
/cfswitch

So when I get down to the part in the stylesheet which says:

a.preferences:hover {
color: #FF;
background-color: #8DC63F;
padding-top: 0px;
padding-right: 6px;
padding-bottom: 0px;
padding-left: 6px;
border: 1px solid cfoutput#myColour#/cfoutput;
margin: 5px 4px;
text-decoration: none;
font-size: 10px;
}

I've never tried this, do CF tags work in CSS?

Thanks for you time,

Saturday

ps: for those North Americans... cfset myColour = myColor ;) (it's
actually looks weird seeing it written as 'colour' nowadays). 



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188652
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF tags work inside of CSS

2004-12-23 Thread C. Hatton Humphrey
 I've never tried this, do CF tags work in CSS?

Might try it using the style block on a CFM page... as Charlie
mentioned the CF engine is not going to parse the CSS page.

Hatton

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188653
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: How to make mx run all .php extensions

2004-12-23 Thread gabriel l smallman
What a cheap server! j/k 

servlet-mapping
  servlet-nameCfmServlet/servlet-name 
  url-pattern*.php/url-pattern 
/servlet-mapping

Worth mentioning, had to alter iis as well to allow scripts and executables
then it started working like a charm.

gabe

-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 10:10 AM
To: CF-Talk
Subject: Re: How to make mx run all .php extensions

cfmxroot/wwwroot/WEB-INF/web.xml

Though I'm sure you're aware you can't actually process PHP code via CFMX

Andy


On Thu, 23 Dec 2004 10:04:28 -0500, gabriel l smallman [EMAIL PROTECTED]
wrote:
 Hey all,
 
 Trying to make mx handle all .php extensions. On iis 6 we remapped to 
 the extension but no get at message:
 
 Server Error
 Either the Macromedia application server is unreachable or it does not 
 have a mapping to process this request.
 
 Im guessing in some xml file jrun is told what extensions to handle? 
 Anyone done this before and have any insight?
 
 gabe
 
 



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188655
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF tags work inside of CSS

2004-12-23 Thread Rick Root
Charlie Griefer wrote:
 CF won't fire unless the page is a .cfm or .cfml extension.  A .css
 extension won't trigger CF to render the page.

However, nothing says your stylesheets have to have a .css extension.

link href=/styles.cfm rel=stylesheet type=text/css

That works fine and dandy.

  - Rick

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188656
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Jochem van Dieten
Ian Buzer wrote:
 You could set your table up in a modified preorder tree traversal, so
 each node has a LFT and RGT numeric value. I've done this in several
 instances and it works great. 
 
 Hey, thanks Dov, that's lovely.
 
 As far as I understand it so far, it does have the snag that if you make a 
 change near the top of the hierachy, a whole lot of data below has to be 
 updated.

Depends on what type of change. If you don't use sequential 
nubers for left and right but increment by a thousand initially 
you can easily insert items without changing the rest. I don't 
know which term to Google for, but last year Joe Celko indicated 
this would be covered by his new book Trees and Hierarchies in 
SQL for Smarties.

Jochem

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188654
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF tags work inside of CSS

2004-12-23 Thread Matthew Small
But Stuart could set .css to be rendered by CF in IIS and make his code
executable, right? Or he could just append .cfm to his stylesheet and have
it processed by CF, then include that as his stylesheet.
 
Matthew Small
Web Developer
American City Business Journals
704-973-1045
[EMAIL PROTECTED]
 

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 10:27 AM
To: CF-Talk
Subject: Re: CF tags work inside of CSS

CF won't fire unless the page is a .cfm or .cfml extension.  A .css
extension won't trigger CF to render the page.



On Thu, 23 Dec 2004 10:15:50 -0500, Stuart Kidd [EMAIL PROTECTED] wrote:
 Hi,
 
 I have a colour theme which changes each month.  Instead of having 12
different stylesheets to cover for the year i wanted to have some CF code at
top of my CSS page, something like:
 
 cfswitch expression=#thisMonth#
 cfcase value=january
 cfset myColour = #08BF83
 /cfcase
 cfcase value=february
 cfset myColour = #085F83
 /cfcase
 cfcase value=march
 cfset myColour = #08B383
 /cfcase
 /cfswitch
 
 So when I get down to the part in the stylesheet which says:
 
 a.preferences:hover {
 color: #FF;
 background-color: #8DC63F;
 padding-top: 0px;
 padding-right: 6px;
 padding-bottom: 0px;
 padding-left: 6px;
 border: 1px solid cfoutput#myColour#/cfoutput;
 margin: 5px 4px;
 text-decoration: none;
 font-size: 10px;
 }
 
 I've never tried this, do CF tags work in CSS?
 
 Thanks for you time,
 
 Saturday
 
 ps: for those North Americans... cfset myColour = myColor ;)
 (it's actually looks weird seeing it written as 'colour' nowadays).
 
 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188659
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF tags work inside of CSS

2004-12-23 Thread Massimo Foti
 Yes, just give your css file a cfm extension and use cfcontent to have
 the correct mime-type (although it will work without)

As far as I know works without the mime-type in IE, not in Mozilla/fireFox.


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/





~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188660
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: CF tags work inside of CSS

2004-12-23 Thread Stuart Kidd
That'll do nicely thanks Massimo.

Grazie e buon natale (mangi un panatone)!

Saturday
-- Original Message --
From: Massimo Foti [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
Date:  Thu, 23 Dec 2004 16:22:50 +0100

 I've never tried this, do CF tags work in CSS?

I am not sure if I understood your question, but I will give it a try.
In case you would like to embed CFML code inside an external CSS file a
solution could be to give the CSS file a .cfm extension, then add this at
the top of it:

cfcontent type=text/css; charset=ISO-8859-1 (use the charset you see
fit)

This way the file will be processed by CF server but served with a text/css
mime-type so browsers will recognize it as CSS

Hope it will help


Massimo Foti
DW tools: http://www.massimocorner.com
CF tools:  http://www.olimpo.ch/tmt/


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188661
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF tags work inside of CSS

2004-12-23 Thread Stuart Kidd
Thanks Mike and everyone else. :)

Saturday


-- Original Message --
From: Dawson, Michael [EMAIL PROTECTED]
Reply-To: cf-talk@houseoffusion.com
Date:  Thu, 23 Dec 2004 09:29:17 -0600

This topic came up a several days ago.  Read the archives for more
details than what I can remember right now.

1. Create multiple CSS files.  One file will contain only layout and
formatting.  Then, create individual CSS files that contain only color
information.  You would have an individual CSS file for each color
theme, however, you only need a single CSS file for layout.  In your CF
template, just use a CF construct to determine which CSS color file to
use.  This is nice because the browser can cache the CSS files.

2. Use CF to generate the CSS dynamically and use CFCONTENT to pass the
correct CSS document type.  (More information in these archives.)  This
is not as good because CF must process the CSS page, then then send it
to the browser.  The browser won't cache the CSS.

M!ke

-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 9:16 AM
To: CF-Talk
Subject: CF tags work inside of CSS

Hi,

I have a colour theme which changes each month.  Instead of having 12
different stylesheets to cover for the year i wanted to have some CF
code at top of my CSS page, something like:

cfswitch expression=#thisMonth#
cfcase value=january
cfset myColour = #08BF83
/cfcase
cfcase value=february
cfset myColour = #085F83
/cfcase
cfcase value=march
cfset myColour = #08B383
/cfcase
/cfswitch

So when I get down to the part in the stylesheet which says:

a.preferences:hover {
   color: #FF;
   background-color: #8DC63F;
   padding-top: 0px;
   padding-right: 6px;
   padding-bottom: 0px;
   padding-left: 6px;
   border: 1px solid cfoutput#myColour#/cfoutput;
   margin: 5px 4px;
   text-decoration: none;
   font-size: 10px;
}

I've never tried this, do CF tags work in CSS?

Thanks for you time,

Saturday

ps: for those North Americans... cfset myColour = myColor ;) (it's
actually looks weird seeing it written as 'colour' nowadays). 





~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188662
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF tags work inside of CSS

2004-12-23 Thread James Smith
If you are only changing a small quantity of of the style sheet you could
move that one or two style definitions from your style sheet into your cfm
pages either in the header of the html or inline if there is very little of
it.

--
Jay 

-Original Message-
From: Charlie Griefer [mailto:[EMAIL PROTECTED] 
Sent: 23 December 2004 15:27
To: CF-Talk
Subject: Re: CF tags work inside of CSS

CF won't fire unless the page is a .cfm or .cfml extension.  A .css
extension won't trigger CF to render the page.



On Thu, 23 Dec 2004 10:15:50 -0500, Stuart Kidd [EMAIL PROTECTED] wrote:
 Hi,
 
 I have a colour theme which changes each month.  Instead of having 12
different stylesheets to cover for the year i wanted to have some CF code at
top of my CSS page, something like:
 
 cfswitch expression=#thisMonth#
 cfcase value=january
 cfset myColour = #08BF83
 /cfcase
 cfcase value=february
 cfset myColour = #085F83
 /cfcase
 cfcase value=march
 cfset myColour = #08B383
 /cfcase
 /cfswitch
 
 So when I get down to the part in the stylesheet which says:
 
 a.preferences:hover {
 color: #FF;
 background-color: #8DC63F;
 padding-top: 0px;
 padding-right: 6px;
 padding-bottom: 0px;
 padding-left: 6px;
 border: 1px solid cfoutput#myColour#/cfoutput;
 margin: 5px 4px;
 text-decoration: none;
 font-size: 10px;
 }
 
 I've never tried this, do CF tags work in CSS?
 
 Thanks for you time,
 
 Saturday
 
 ps: for those North Americans... cfset myColour = myColor ;) (it's 
 actually looks weird seeing it written as 'colour' nowadays).
 
 



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188657
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: SOT: Flash list

2004-12-23 Thread Murat Demirci
Thank you!

Murat. 

 -Original Message-
 From: Jaye Morris [mailto:[EMAIL PROTECTED] 
 Sent: Thursday, December 23, 2004 4:44 PM
 To: CF-Talk
 Subject: Re: SOT: Flash list
 
 Flashcoders
 
 http://chattyfig.figleaf.com/
 
 
 On Thu, 23 Dec 2004 16:33:25 +0200, Murat Demirci 
 [EMAIL PROTECTED] wrote:
  Hi folks,
  
  I'm searching an active Flash developers list like CF-Talk. 
 Does anyone know an active flash list?
  
  Murat.
  
  
 -- 
 // Jaye Morris | Multimedia - Web Applications Developer
 // www.jayezero.com
 // [EMAIL PROTECTED]
 // [EMAIL PROTECTED]
 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188658
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: 1st, 2nd, 3rd, 4th

2004-12-23 Thread Ewok
This should do it... I wrote it for a list of Top 10 Scores in a game but
changed it a little to work with larger numbers. Hope it helps

cfscript
function nth(num)
{
if (right(num, 1) is 1 and right(num, 2) NEQ 11) 
{
num = num  st;
}
else if (right(num, 1) is 2 and right(num, 2) NEQ 12) 
{
num = num  nd;
}
else if (right(num, 1) is 3 and right(num, 2) NEQ 13) 
{
num = num  rd;
}
else 
{
num = num  th;
}
return num;
}
/cfscript


-Original Message-
From: Rick Root [mailto:[EMAIL PROTECTED] 
Sent: Wednesday, December 22, 2004 12:36 PM
To: CF-Talk
Subject: 1st, 2nd, 3rd, 4th

Does anyone have a function that takes numbers and converts them to 1st, 
2nd, 3rd, ... 15th, .. 21st, etc?

  - Rick



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188664
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: CF tags work inside of CSS

2004-12-23 Thread Patrick McGeehan
You could also use some logic in application.cfm and use cfhtmlhead to
inject a style /style set into the head of the htm doc, rather than
using a linked style sheet.

Patrick McGeehan 
Applications Developer
DIT
CF_DIT#mcg#/CF_DIT

 



-Original Message-
From: Stuart Kidd [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 10:29 AM
To: CF-Talk
Subject: Re: CF tags work inside of CSS


Ok, damn! Oh well, looks like a few files instead then.



~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188663
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


where to put the java class?

2004-12-23 Thread Johnny Le
Hi,

Is there a specific location where I should put my java class?  I have a java 
class, and currently I put it in the same directory with my calling page.  When 
I call it, it says it could not find the class.  I registered it in the 
Adminstrator under Java and JVM, but it still doesn't work.
Please help!

Johnny

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188665
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: search for a string across columns

2004-12-23 Thread Sean Corfield
On Wed, 22 Dec 2004 20:30:23 +, Michael Traher
[EMAIL PROTECTED] wrote:
 I might be wrong but I would have thought that the DBMS will simply
 expand the cancat syntax to the full version with the ORs in that you
 started with.

No, it will do the concatenate first, then the comparison. Otherwise
you don't get the same results.
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 4 invites to give away!

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188666
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: where to put the java class?

2004-12-23 Thread Dave Carabetta
On Thu, 23 Dec 2004 10:42:01 -0400, Johnny Le [EMAIL PROTECTED] wrote:
 Hi,
 
 Is there a specific location where I should put my java class?  I have a java 
 class, and currently I put it in the same directory with my calling page.  
 When I call it, it says it could not find the class.  I registered it in the 
 Adminstrator under Java and JVM, but it still doesn't work.
 Please help!
 

You can put it in your WEB-INF/classes directory, restart the
instance, and CF will pick the class up.

Regards,
Dave.

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188667
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Two Selects

2004-12-23 Thread Rick
Does the two selects related tag not work in CFMX?

Dropdown one has the correct info but when I select an item nothing happens
in select two.

form action=index.cfm?t=results method=post name=FormX

cfquery datasource=#App_DataSource# name=QryGetCityStates
username=#App_DataBaseUser# password=#App_DataBasePass#
SELECT DISTINCT STATE, City
FROM TblMain
WHERE State  ''
ORDER BY State
/cfquery


CF_TwoSelectsRelated 
QUERY=QryGetCityStates 
NAME1=form.STATE 
NAME2=form.City 
DISPLAY1=STATE 
DISPLAY2=City 
VALUE1=STATE 
VALUE2=City 
FORCEWIDTH1=70 
FORCEWIDTH2=70
AUTOSELECTFIRST=No
HTMLBETWEEN=BR FORMNAME=FormX


..

/form


Nothing has been changed in the TwoSelectsRelated.cfm file.


Rick Eidson
Partner  CTO
ArcRiver Technology, LLC
http://www.arcriver.com/

Local Kansas City Music
http://www.kcjukebox.com/





-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188668
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Rick
Correction to code below...

CF_TwoSelectsRelated 
QUERY=QryGetCityStates 
NAME1=SearchSTATE 
NAME2=SearchCity 
DISPLAY1=STATE 
DISPLAY2=City 
VALUE1=STATE 
VALUE2=City 
FORCEWIDTH1=70 
FORCEWIDTH2=70
AUTOSELECTFIRST=No
HTMLBETWEEN=BR FORMNAME=FormX

Thanks!

Rick Eidson
Partner  CTO
ArcRiver Technology, LLC
http://www.arcriver.com/

Local Kansas City Music
http://www.kcjukebox.com/


-Original Message-
From: Rick [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 9:57 AM
To: CF-Talk
Subject: Two Selects

Does the two selects related tag not work in CFMX?

Dropdown one has the correct info but when I select an item nothing happens
in select two.

form action=index.cfm?t=results method=post name=FormX

cfquery datasource=#App_DataSource# name=QryGetCityStates
username=#App_DataBaseUser# password=#App_DataBasePass#
SELECT DISTINCT STATE, City
FROM TblMain
WHERE State  ''
ORDER BY State
/cfquery


CF_TwoSelectsRelated 
QUERY=QryGetCityStates 
NAME1=form.STATE 
NAME2=form.City 
DISPLAY1=STATE 
DISPLAY2=City 
VALUE1=STATE 
VALUE2=City 
FORCEWIDTH1=70 
FORCEWIDTH2=70
AUTOSELECTFIRST=No
HTMLBETWEEN=BR FORMNAME=FormX


..

/form


Nothing has been changed in the TwoSelectsRelated.cfm file.


Rick Eidson
Partner  CTO
ArcRiver Technology, LLC
http://www.arcriver.com/

Local Kansas City Music
http://www.kcjukebox.com/





-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188669
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Two Selects

2004-12-23 Thread Ray Champagne
Rick where did you get this tag?

I am interested in using for a couple of projects...never knew it existed.

Ray

At 10:57 AM 12/23/2004, you wrote:
Does the two selects related tag not work in CFMX?

Dropdown one has the correct info but when I select an item nothing happens
in select two.

form action=index.cfm?t=results method=post name=FormX

cfquery datasource=#App_DataSource# name=QryGetCityStates
username=#App_DataBaseUser# password=#App_DataBasePass#
SELECT DISTINCT STATE, City
FROM TblMain
WHERE State  ''
ORDER BY State
/cfquery


CF_TwoSelectsRelated
QUERY=QryGetCityStates
NAME1=form.STATE
NAME2=form.City
DISPLAY1=STATE
DISPLAY2=City
VALUE1=STATE
VALUE2=City
FORCEWIDTH1=70
FORCEWIDTH2=70
AUTOSELECTFIRST=No
HTMLBETWEEN=BR FORMNAME=FormX


..

/form


Nothing has been changed in the TwoSelectsRelated.cfm file.


Rick Eidson
Partner  CTO
ArcRiver Technology, LLC
http://www.arcriver.com/

Local Kansas City Music
http://www.kcjukebox.com/





--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004





~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188670
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Rick
It's in the Cold Fusion Exchange at Macromedia, there is also a 3 selects
related tag.

Rick

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 10:05 AM
To: CF-Talk
Subject: Re: Two Selects

Rick where did you get this tag?

I am interested in using for a couple of projects...never knew it existed.

Ray

At 10:57 AM 12/23/2004, you wrote:
Does the two selects related tag not work in CFMX?

Dropdown one has the correct info but when I select an item nothing happens
in select two.

form action=index.cfm?t=results method=post name=FormX

cfquery datasource=#App_DataSource# name=QryGetCityStates
username=#App_DataBaseUser# password=#App_DataBasePass#
SELECT DISTINCT STATE, City
FROM TblMain
WHERE State  ''
ORDER BY State
/cfquery


CF_TwoSelectsRelated
QUERY=QryGetCityStates
NAME1=form.STATE
NAME2=form.City
DISPLAY1=STATE
DISPLAY2=City
VALUE1=STATE
VALUE2=City
FORCEWIDTH1=70
FORCEWIDTH2=70
AUTOSELECTFIRST=No
HTMLBETWEEN=BR FORMNAME=FormX


..

/form


Nothing has been changed in the TwoSelectsRelated.cfm file.


Rick Eidson
Partner  CTO
ArcRiver Technology, LLC
http://www.arcriver.com/

Local Kansas City Music
http://www.kcjukebox.com/





--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004







~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188671
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Two Selects

2004-12-23 Thread Marius Milosav
CF_TwoSelectsRelated  tag should work on CFMX no problem.

You should enable JavaScript debugging and see if you get any js errors on
the page.

Marius Milosav
www.scorpiosoft.com
It's not about Technology, it's about people
Virtual Company (VICO) Application demo
www.scorpiosoft.com/vicodemo/login.cfm

- Original Message - 
From: Rick [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 23, 2004 11:00 AM
Subject: RE: Two Selects


 Correction to code below...

 CF_TwoSelectsRelated
 QUERY=QryGetCityStates
 NAME1=SearchSTATE
 NAME2=SearchCity
 DISPLAY1=STATE
 DISPLAY2=City
 VALUE1=STATE
 VALUE2=City
 FORCEWIDTH1=70
 FORCEWIDTH2=70
 AUTOSELECTFIRST=No
 HTMLBETWEEN=BR FORMNAME=FormX

 Thanks!

 Rick Eidson
 Partner  CTO
 ArcRiver Technology, LLC
 http://www.arcriver.com/

 Local Kansas City Music
 http://www.kcjukebox.com/


 -Original Message-
 From: Rick [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 23, 2004 9:57 AM
 To: CF-Talk
 Subject: Two Selects

 Does the two selects related tag not work in CFMX?

 Dropdown one has the correct info but when I select an item nothing
happens
 in select two.

 form action=index.cfm?t=results method=post name=FormX

 cfquery datasource=#App_DataSource# name=QryGetCityStates
 username=#App_DataBaseUser# password=#App_DataBasePass#
 SELECT DISTINCT STATE, City
 FROM TblMain
 WHERE State  ''
 ORDER BY State
 /cfquery


 CF_TwoSelectsRelated
 QUERY=QryGetCityStates
 NAME1=form.STATE
 NAME2=form.City
 DISPLAY1=STATE
 DISPLAY2=City
 VALUE1=STATE
 VALUE2=City
 FORCEWIDTH1=70
 FORCEWIDTH2=70
 AUTOSELECTFIRST=No
 HTMLBETWEEN=BR FORMNAME=FormX


 ..

 /form


 Nothing has been changed in the TwoSelectsRelated.cfm file.


 Rick Eidson
 Partner  CTO
 ArcRiver Technology, LLC
 http://www.arcriver.com/

 Local Kansas City Music
 http://www.kcjukebox.com/





 -- 
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004





 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188672
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Ray Champagne
Sweet.  thx!

Ray

At 11:07 AM 12/23/2004, you wrote:
It's in the Cold Fusion Exchange at Macromedia, there is also a 3 selects
related tag.

Rick

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 10:05 AM
To: CF-Talk
Subject: Re: Two Selects

Rick where did you get this tag?

I am interested in using for a couple of projects...never knew it existed.

Ray

At 10:57 AM 12/23/2004, you wrote:
 Does the two selects related tag not work in CFMX?
 
 Dropdown one has the correct info but when I select an item nothing happens
 in select two.
 
 form action=index.cfm?t=results method=post name=FormX
 
 cfquery datasource=#App_DataSource# name=QryGetCityStates
 username=#App_DataBaseUser# password=#App_DataBasePass#
 SELECT DISTINCT STATE, City
 FROM TblMain
 WHERE State  ''
 ORDER BY State
 /cfquery
 
 
 CF_TwoSelectsRelated
 QUERY=QryGetCityStates
 NAME1=form.STATE
 NAME2=form.City
 DISPLAY1=STATE
 DISPLAY2=City
 VALUE1=STATE
 VALUE2=City
 FORCEWIDTH1=70
 FORCEWIDTH2=70
 AUTOSELECTFIRST=No
 HTMLBETWEEN=BR FORMNAME=FormX
 
 
 ..
 
 /form
 
 
 Nothing has been changed in the TwoSelectsRelated.cfm file.
 
 
 Rick Eidson
 Partner  CTO
 ArcRiver Technology, LLC
 http://www.arcriver.com/
 
 Local Kansas City Music
 http://www.kcjukebox.com/
 
 
 
 
 
 --
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004
 
 
 
 





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188673
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Rick
Error: missing ; before statement
Source File: http://burrows.arcriver.com/i/index.cfm
Line: 179, Column: 211
Source Code:

NewOpt[86] = new Option(Oak Park);NewOpt[86].value = 'Oak Park';
NewOpt[87] = new Option(Oakbrook Terrace);NewOpt[87].value = 'Oakbrook
Terrace'; NewOpt[88] = new Option(O'Fallon);  NewOpt[88].value =
'O'Fallon'; NewOpt[89] = new Option(Orland Par


Well this looks like that maybe the ' in the city o'Fallon could be the
issue. 

Rick



-Original Message-
From: Marius Milosav [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 10:10 AM
To: CF-Talk
Subject: Re: Two Selects

CF_TwoSelectsRelated  tag should work on CFMX no problem.

You should enable JavaScript debugging and see if you get any js errors on
the page.

Marius Milosav
www.scorpiosoft.com
It's not about Technology, it's about people
Virtual Company (VICO) Application demo
www.scorpiosoft.com/vicodemo/login.cfm

- Original Message - 
From: Rick [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 23, 2004 11:00 AM
Subject: RE: Two Selects


 Correction to code below...

 CF_TwoSelectsRelated
 QUERY=QryGetCityStates
 NAME1=SearchSTATE
 NAME2=SearchCity
 DISPLAY1=STATE
 DISPLAY2=City
 VALUE1=STATE
 VALUE2=City
 FORCEWIDTH1=70
 FORCEWIDTH2=70
 AUTOSELECTFIRST=No
 HTMLBETWEEN=BR FORMNAME=FormX

 Thanks!

 Rick Eidson
 Partner  CTO
 ArcRiver Technology, LLC
 http://www.arcriver.com/

 Local Kansas City Music
 http://www.kcjukebox.com/


 -Original Message-
 From: Rick [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 23, 2004 9:57 AM
 To: CF-Talk
 Subject: Two Selects

 Does the two selects related tag not work in CFMX?

 Dropdown one has the correct info but when I select an item nothing
happens
 in select two.

 form action=index.cfm?t=results method=post name=FormX

 cfquery datasource=#App_DataSource# name=QryGetCityStates
 username=#App_DataBaseUser# password=#App_DataBasePass#
 SELECT DISTINCT STATE, City
 FROM TblMain
 WHERE State  ''
 ORDER BY State
 /cfquery


 CF_TwoSelectsRelated
 QUERY=QryGetCityStates
 NAME1=form.STATE
 NAME2=form.City
 DISPLAY1=STATE
 DISPLAY2=City
 VALUE1=STATE
 VALUE2=City
 FORCEWIDTH1=70
 FORCEWIDTH2=70
 AUTOSELECTFIRST=No
 HTMLBETWEEN=BR FORMNAME=FormX


 ..

 /form


 Nothing has been changed in the TwoSelectsRelated.cfm file.


 Rick Eidson
 Partner  CTO
 ArcRiver Technology, LLC
 http://www.arcriver.com/

 Local Kansas City Music
 http://www.kcjukebox.com/





 -- 
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004





 



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188674
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Rick
In the TwoSelectsRelated.cfm file on about line 100 I changed the ' to 

NewOpt[#Counter2#].value = '#Evaluate(Attributes.Value2)#';

To

NewOpt[#Counter2#].value = #Evaluate(Attributes.Value2)#;

Does anyone see any reason why I shouldn't?

Rick

-Original Message-
From: Rick [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 10:18 AM
To: CF-Talk
Subject: RE: Two Selects

Error: missing ; before statement
Source File: http://burrows.arcriver.com/i/index.cfm
Line: 179, Column: 211
Source Code:

NewOpt[86] = new Option(Oak Park);NewOpt[86].value = 'Oak Park';
NewOpt[87] = new Option(Oakbrook Terrace);NewOpt[87].value = 'Oakbrook
Terrace'; NewOpt[88] = new Option(O'Fallon);  NewOpt[88].value =
'O'Fallon'; NewOpt[89] = new Option(Orland Par


Well this looks like that maybe the ' in the city o'Fallon could be the
issue. 

Rick




-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188675
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Two Selects

2004-12-23 Thread Marius Milosav
use JSStringFormat and not evaluate

Marius Milosav
www.scorpiosoft.com
It's not about Technology, it's about people
Virtual Company (VICO) Application demo
www.scorpiosoft.com/vicodemo/login.cfm

- Original Message - 
From: Rick [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 23, 2004 11:23 AM
Subject: RE: Two Selects


 In the TwoSelectsRelated.cfm file on about line 100 I changed the ' to 

 NewOpt[#Counter2#].value = '#Evaluate(Attributes.Value2)#';

 To

 NewOpt[#Counter2#].value = #Evaluate(Attributes.Value2)#;

 Does anyone see any reason why I shouldn't?

 Rick

 -Original Message-
 From: Rick [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 23, 2004 10:18 AM
 To: CF-Talk
 Subject: RE: Two Selects

 Error: missing ; before statement
 Source File: http://burrows.arcriver.com/i/index.cfm
 Line: 179, Column: 211
 Source Code:

 NewOpt[86] = new Option(Oak Park); NewOpt[86].value = 'Oak Park';
 NewOpt[87] = new Option(Oakbrook Terrace); NewOpt[87].value = 'Oakbrook
 Terrace'; NewOpt[88] = new Option(O'Fallon); NewOpt[88].value =
 'O'Fallon'; NewOpt[89] = new Option(Orland Par


 Well this looks like that maybe the ' in the city o'Fallon could be the
 issue.

 Rick




 -- 
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004



 

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188676
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: In One?

2004-12-23 Thread Ian Buzer
Cache the data (application-scope variable) then use local UDFs or a CFC
to manage processing.

Yes, I'm beginning to think this may be the best compromise. Particularly as, 
although there's about 18k categories, probably 10% of those are queried 90% of 
the time.

So, following on from this ... does anyone know if there is a way of 
programmatically 'sizing' a variable (or CFC) to see how much memory it's 
consuming? 

Ian


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188677
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: where to put the java class?

2004-12-23 Thread Qasim Rasheed
In addition to the suggestion that Dave made earlier, you can also
load Java classes remotely. Here is a link to a blog post by Christian
Cantrell on this technique.

http://www.markme.com/cantrell/archives/005295.cfm



On Thu, 23 Dec 2004 10:48:44 -0500, Dave Carabetta [EMAIL PROTECTED] wrote:
 On Thu, 23 Dec 2004 10:42:01 -0400, Johnny Le [EMAIL PROTECTED] wrote:
  Hi,
 
  Is there a specific location where I should put my java class?  I have a 
  java class, and currently I put it in the same directory with my calling 
  page.  When I call it, it says it could not find the class.  I registered 
  it in the Adminstrator under Java and JVM, but it still doesn't work.
  Please help!
 
 
 You can put it in your WEB-INF/classes directory, restart the
 instance, and CF will pick the class up.
 
 Regards,
 Dave.
 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188678
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


mailing label custom tag?

2004-12-23 Thread Ray Champagne
Does anyone know of a custom tag that has the ability to create mailing labels?

If it had the ability to create them in various Avery formats, that would 
be even cooler!

Google didn't seem to help too much

Thanks, and have a merry merry!

Ray

=
Ray Champagne - Senior Application Developer
CrystalVision Web Site Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it
from your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at 603.433.9559.
Thank you.



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188679
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Andy Mcshane
Slightly OT but I managed to alter the 3 selects and create a 4 selects
related tag if that is of any help to anyone? It was a nightmare to do
and I can't actually remember how I did it but it works great, I had to
alter it to enable a user to select a region, country, division  club,
I am sure it could be useful for other things with a few more changes?

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188680
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Rick
I don't have a need for it now but I did a while back. Can't you upload it
to the Exchange?

Rick

-Original Message-
From: Andy Mcshane [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 11:24 AM
To: CF-Talk
Subject: RE: Two Selects

Slightly OT but I managed to alter the 3 selects and create a 4 selects
related tag if that is of any help to anyone? It was a nightmare to do
and I can't actually remember how I did it but it works great, I had to
alter it to enable a user to select a region, country, division  club,
I am sure it could be useful for other things with a few more changes?



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188681
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Tim Laureska
Andy... I'd sure be interested
Tim

-Original Message-
From: Andy Mcshane [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 12:24 PM
To: CF-Talk
Subject: RE: Two Selects

Slightly OT but I managed to alter the 3 selects and create a 4 selects
related tag if that is of any help to anyone? It was a nightmare to do
and I can't actually remember how I did it but it works great, I had to
alter it to enable a user to select a region, country, division  club,
I am sure it could be useful for other things with a few more changes?



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188682
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Two Selects

2004-12-23 Thread Chris Stoner
You also might want to look at the qForms implementation of this 
concept.  Its pretty easilly implemented.

http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm


Tim Laureska wrote:

Andy... I'd sure be interested
Tim

-Original Message-
From: Andy Mcshane [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 12:24 PM
To: CF-Talk
Subject: RE: Two Selects

Slightly OT but I managed to alter the 3 selects and create a 4 selects
related tag if that is of any help to anyone? It was a nightmare to do
and I can't actually remember how I did it but it works great, I had to
alter it to enable a user to select a region, country, division  club,
I am sure it could be useful for other things with a few more changes?


  




~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188683
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Two Selects

2004-12-23 Thread Rick Mason
Ray,

I have had better luck FWIW with the QForms JSAPI and their n-related
select boxes.  They work with any browser and are rock solid.

http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm

No problems with 2 and 3 selects related though I tried once to get a
5 selects related going and couldn't make it work :)!

Rick Mason



On Thu, 23 Dec 2004 11:05:15 -0500, Ray Champagne [EMAIL PROTECTED] wrote:
 Rick where did you get this tag?
 
 I am interested in using for a couple of projects...never knew it existed.
 
 Ray
 
 At 10:57 AM 12/23/2004, you wrote:
 Does the two selects related tag not work in CFMX?
 
 Dropdown one has the correct info but when I select an item nothing happens
 in select two.
 
 form action=index.cfm?t=results method=post name=FormX
 
 cfquery datasource=#App_DataSource# name=QryGetCityStates
 username=#App_DataBaseUser# password=#App_DataBasePass#
 SELECT DISTINCT STATE, City
 FROM TblMain
 WHERE State  ''
 ORDER BY State
 /cfquery
 
 
 CF_TwoSelectsRelated
 QUERY=QryGetCityStates
 NAME1=form.STATE
 NAME2=form.City
 DISPLAY1=STATE
 DISPLAY2=City
 VALUE1=STATE
 VALUE2=City
 FORCEWIDTH1=70
 FORCEWIDTH2=70
 AUTOSELECTFIRST=No
 HTMLBETWEEN=BR FORMNAME=FormX
 
 
 ..
 
 /form
 
 
 Nothing has been changed in the TwoSelectsRelated.cfm file.
 
 
 Rick Eidson
 Partner  CTO
 ArcRiver Technology, LLC
 http://www.arcriver.com/
 
 Local Kansas City Music
 http://www.kcjukebox.com/
 
 
 
 
 
 --
 No virus found in this outgoing message.
 Checked by AVG Anti-Virus.
 Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004
 
 
 
 
 
 

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188684
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Two Selects

2004-12-23 Thread Ray Champagne
I will do just that, thank for the advice!

Ray

At 01:07 PM 12/23/2004, you wrote:
Ray,

I have had better luck FWIW with the QForms JSAPI and their n-related
select boxes.  They work with any browser and are rock solid.

http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm

No problems with 2 and 3 selects related though I tried once to get a
5 selects related going and couldn't make it work :)!

Rick Mason



On Thu, 23 Dec 2004 11:05:15 -0500, Ray Champagne [EMAIL PROTECTED] wrote:
  Rick where did you get this tag?
 
  I am interested in using for a couple of projects...never knew it existed.
 
  Ray
 
  At 10:57 AM 12/23/2004, you wrote:
  Does the two selects related tag not work in CFMX?
  
  Dropdown one has the correct info but when I select an item nothing 
 happens
  in select two.
  
  form action=index.cfm?t=results method=post name=FormX
  
  cfquery datasource=#App_DataSource# name=QryGetCityStates
  username=#App_DataBaseUser# password=#App_DataBasePass#
  SELECT DISTINCT STATE, City
  FROM TblMain
  WHERE State  ''
  ORDER BY State
  /cfquery
  
  
  CF_TwoSelectsRelated
  QUERY=QryGetCityStates
  NAME1=form.STATE
  NAME2=form.City
  DISPLAY1=STATE
  DISPLAY2=City
  VALUE1=STATE
  VALUE2=City
  FORCEWIDTH1=70
  FORCEWIDTH2=70
  AUTOSELECTFIRST=No
  HTMLBETWEEN=BR FORMNAME=FormX
  
  
  ..
  
  /form
  
  
  Nothing has been changed in the TwoSelectsRelated.cfm file.
  
  
  Rick Eidson
  Partner  CTO
  ArcRiver Technology, LLC
  http://www.arcriver.com/
  
  Local Kansas City Music
  http://www.kcjukebox.com/
  
  
  
  
  
  --
  No virus found in this outgoing message.
  Checked by AVG Anti-Virus.
  Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004
  
  
  
  
 
 



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188685
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Development Tools

2004-12-23 Thread Blaine Korte
Hello everyone,

I'm looking for some good CVS software (free preferably) that works
under Cold Fusion.  I've seen a few good ones in PHP, but I'd much
rather have it in CF.

I'd rather not have a client application, nor do I want to install any
applications on the server.

Also, what coding standards do you use?  Have any links to share?

Thanks a lot.  Let me know if I'm not being clear enough.
-Blaine



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188686
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Paul
I've always used this one; it has an example going 6 deep, and I don't think
there is a limit...

http://www.mattkruse.com/javascript/dynamicoptionlist/


-Original Message-
From: Andy Mcshane [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 10:24 AM
To: CF-Talk
Subject: RE: Two Selects

Slightly OT but I managed to alter the 3 selects and create a 4 selects
related tag if that is of any help to anyone? It was a nightmare to do
and I can't actually remember how I did it but it works great, I had to
alter it to enable a user to select a region, country, division  club,
I am sure it could be useful for other things with a few more changes?


~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188687
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Scheduling/Appointment application

2004-12-23 Thread Chris Terrebonne
Happy Holidays everyone!

A few months ago there was a pretty in depth discussion regarding the database 
model and programming techniques of a scheduling/appointment application, but I 
can't seem to find it in the archives anywhere.  If anyone could point me to 
this discussion or to any articles related to this, I would appreciate it.  
Right now, I am looking at mimicking the SQL sysjobschedules methodology.  The 
only drawback is their use of bitmasks for frequency intervals could make for 
an unnecessarily complex calendar query.  I'm sure someone has come across a 
better method.  If anyone has any advise or resources to share, I'm all ears.

Thanks in advance,
Chris



This email and its attachments may contain confidential information 
which is intended only for the use of the person(s) named above.  
If you are not the intended recipient, you are hereby advised that
any disclosure, copying, distribution or the taking of any action
based on the contents of this information is prohibited.  If you 
have received this transmission in error, please notify the sender
and delete this email from your computer.  Thank you.



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188688
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: mailing label custom tag?

2004-12-23 Thread Eric Hoffman
I had one somewhere around here...I can dig up after xmas to see if I
didn't lose it.  Its at the office. 

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 11:16 AM
To: CF-Talk
Subject: mailing label custom tag?

Does anyone know of a custom tag that has the ability to create mailing
labels?

If it had the ability to create them in various Avery formats, that
would be even cooler!

Google didn't seem to help too much

Thanks, and have a merry merry!

Ray

=
Ray Champagne - Senior Application Developer CrystalVision Web Site
Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it from
your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at
603.433.9559.
Thank you.





~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188689
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: mailing label custom tag?

2004-12-23 Thread Ray Champagne
Thanks!

I actually found one on the dev exchange a few minutes ago.  it was written 
for CF5, but I am playing with it now, and don't see why it is going to 
make a difference which version I am running it under.

cf-averyrtf it is called...and it is pretty damn cool!

Ray



At 02:21 PM 12/23/2004, you wrote:
I had one somewhere around here...I can dig up after xmas to see if I
didn't lose it.  Its at the office.

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 11:16 AM
To: CF-Talk
Subject: mailing label custom tag?

Does anyone know of a custom tag that has the ability to create mailing
labels?

If it had the ability to create them in various Avery formats, that
would be even cooler!

Google didn't seem to help too much

Thanks, and have a merry merry!

Ray

=
Ray Champagne - Senior Application Developer CrystalVision Web Site
Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it from
your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at
603.433.9559.
Thank you.







~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188690
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: mailing label custom tag?

2004-12-23 Thread Eric Hoffman
That's the one I had.  Enjoy. 

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 1:25 PM
To: CF-Talk
Subject: RE: mailing label custom tag?

Thanks!

I actually found one on the dev exchange a few minutes ago.  it was
written for CF5, but I am playing with it now, and don't see why it is
going to make a difference which version I am running it under.

cf-averyrtf it is called...and it is pretty damn cool!

Ray



At 02:21 PM 12/23/2004, you wrote:
I had one somewhere around here...I can dig up after xmas to see if I 
didn't lose it.  Its at the office.

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 11:16 AM
To: CF-Talk
Subject: mailing label custom tag?

Does anyone know of a custom tag that has the ability to create mailing

labels?

If it had the ability to create them in various Avery formats, that 
would be even cooler!

Google didn't seem to help too much

Thanks, and have a merry merry!

Ray

=
Ray Champagne - Senior Application Developer CrystalVision Web Site 
Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named 
above. If you received this transmission in error, please delete it 
from your system and notify us immediately. If you are not an intended 
recipient, please note that any use or dissemination of the information

contained in this transmission (including any attached files) and the 
copying, printing, or retransmission of that information is strictly 
prohibited. You can notify us by return email or by phone at 
603.433.9559.
Thank you.









~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188691
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: mailing label custom tag?

2004-12-23 Thread Russell Patterson
Where did you find it at?

Thanks!
Russell

- Original Message - 
From: Ray Champagne [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 23, 2004 1:25 PM
Subject: RE: mailing label custom tag?


 Thanks!

 I actually found one on the dev exchange a few minutes ago.  it was 
 written
 for CF5, but I am playing with it now, and don't see why it is going to
 make a difference which version I am running it under.

 cf-averyrtf it is called...and it is pretty damn cool!

 Ray



 At 02:21 PM 12/23/2004, you wrote:
I had one somewhere around here...I can dig up after xmas to see if I
didn't lose it.  Its at the office.

-Original Message-
From: Ray Champagne [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 11:16 AM
To: CF-Talk
Subject: mailing label custom tag?

Does anyone know of a custom tag that has the ability to create mailing
labels?

If it had the ability to create them in various Avery formats, that
would be even cooler!

Google didn't seem to help too much

Thanks, and have a merry merry!

Ray

=
Ray Champagne - Senior Application Developer CrystalVision Web Site
Design and Internet Services
603.433.9559
www.crystalvision.org
=

The information contained in this transmission (including any attached
files) is CONFIDENTIAL and is intended only for the person(s) named
above. If you received this transmission in error, please delete it from
your system and notify us immediately. If you are not an intended
recipient, please note that any use or dissemination of the information
contained in this transmission (including any attached files) and the
copying, printing, or retransmission of that information is strictly
prohibited. You can notify us by return email or by phone at
603.433.9559.
Thank you.







 

~|
Special thanks to the CF Community Suite Silver Sponsor - CFDynamics
http://www.cfdynamics.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188692
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: mailing label custom tag?

2004-12-23 Thread Ray Champagne
Ask and ye shall receive!  (For those that might read this in the future, I 
found it on the MM exchange, search for 'Avery' under coldfusion exchange)

http://makeashorterlink.com/?T2972481Ahttp://makeashorterlink.com/?T2972481A

Ray


At 02:42 PM 12/23/2004, you wrote:
Where did you find it at?

Thanks!
Russell

- Original Message -
From: Ray Champagne [EMAIL PROTECTED]
To: CF-Talk cf-talk@houseoffusion.com
Sent: Thursday, December 23, 2004 1:25 PM
Subject: RE: mailing label custom tag?


  Thanks!
 
  I actually found one on the dev exchange a few minutes ago.  it was
  written
  for CF5, but I am playing with it now, and don't see why it is going to
  make a difference which version I am running it under.
 
  cf-averyrtf it is called...and it is pretty damn cool!
 
  Ray
 
 
 
  At 02:21 PM 12/23/2004, you wrote:
 I had one somewhere around here...I can dig up after xmas to see if I
 didn't lose it.  Its at the office.
 
 -Original Message-
 From: Ray Champagne [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 23, 2004 11:16 AM
 To: CF-Talk
 Subject: mailing label custom tag?
 
 Does anyone know of a custom tag that has the ability to create mailing
 labels?
 
 If it had the ability to create them in various Avery formats, that
 would be even cooler!
 
 Google didn't seem to help too much
 
 Thanks, and have a merry merry!
 
 Ray
 
 =
 Ray Champagne - Senior Application Developer CrystalVision Web Site
 Design and Internet Services
 603.433.9559
 www.crystalvision.org
 =
 
 The information contained in this transmission (including any attached
 files) is CONFIDENTIAL and is intended only for the person(s) named
 above. If you received this transmission in error, please delete it from
 your system and notify us immediately. If you are not an intended
 recipient, please note that any use or dissemination of the information
 contained in this transmission (including any attached files) and the
 copying, printing, or retransmission of that information is strictly
 prohibited. You can notify us by return email or by phone at
 603.433.9559.
 Thank you.
 
 
 
 
 
 
 
 



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188693
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Prefixing local variables

2004-12-23 Thread Michael Dinowitz
I've started to use a dollar sign as a prefix for variables which are local
to a function or CFC. i.e. those variables created when using the var
keyword. 
CFSET var $Localvar=
I could have also used an underscore like so:
CFSET var _Localvar=
I plan to give out the new CFCs and functions I'm writing (the logger is in
use and is being tweaked as we speak) and was wondering which you, the
ColdFusion using world, would prefer. I like the dollar sign, but I'm
willing to listen to what people have to say.

As an aside, can someone using Blue Dragon please test to see if the dollar
sign and underscore are legal for variables on that platform? Thanks



~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188694
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Two Selects

2004-12-23 Thread Dennis Powers
Rick,

Be sure you escape or remove any single or double quotes or any JavaScript
unfriendly characters from the data before feeding the tag.


Best Regards,

Dennis Powers
UXB Internet- A Website Design and Hosting Company
690 Wolcott Road - P.O. Box 6028
Wolcott, CT 06716tel: (203)879-2844
http://www.uxbinternet.com
http://dennis.uxb.net

-Original Message-
From: Rick [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 23, 2004 10:57 AM
To: CF-Talk
Subject: Two Selects

Does the two selects related tag not work in CFMX?

Dropdown one has the correct info but when I select an item nothing happens
in select two.

form action=index.cfm?t=results method=post name=FormX

cfquery datasource=#App_DataSource# name=QryGetCityStates
username=#App_DataBaseUser# password=#App_DataBasePass#
SELECT DISTINCT STATE, City
FROM TblMain
WHERE State  ''
ORDER BY State
/cfquery


CF_TwoSelectsRelated
QUERY=QryGetCityStates
NAME1=form.STATE
NAME2=form.City
DISPLAY1=STATE
DISPLAY2=City
VALUE1=STATE
VALUE2=City
FORCEWIDTH1=70
FORCEWIDTH2=70
AUTOSELECTFIRST=No
HTMLBETWEEN=BR FORMNAME=FormX


..

/form


Nothing has been changed in the TwoSelectsRelated.cfm file.


Rick Eidson
Partner  CTO
ArcRiver Technology, LLC
http://www.arcriver.com/

Local Kansas City Music
http://www.kcjukebox.com/





--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.298 / Virus Database: 265.6.4 - Release Date: 12/22/2004





~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188695
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


AW: In One?

2004-12-23 Thread Gert Franz
Hi Ian and everybody else,

Check out the book trees and hierarchies in SQL for smarties by Joe
Celko. ISBN: 1-55860-920-2
It gives a very good overview about how to treat trees in a SQL
database. It's really good, and it refers to the nested set tree model
very deeply.
I use SQL-Server and i wrote a couple of triggers that keep my lft, rgt
and lvl values up to date. If you need them, just email me at
[EMAIL PROTECTED]

Btw. The trick about not having to update so many records in a nested
set tree model if you insert a node near to the top is that you do not
use gaps with the size of 1 between the bottom leafs. You can use steps
of eg. 10. So if you have to insert a node to the left of the topmost
treenode with the left value of 1 and the left value of the first
subordinate of 11 you can just insert the new record with the lft and
rgt values of 2 and 3 without any further update. (check out Chapter 5
in the mentioned book called frequent insertion trees)

cfgreetings from=[EMAIL PROTECTED] to=reader location=bern
country=switzerland function=railo core developer message=merry
xmas

-Ursprüngliche Nachricht-
Von: Ian Buzer [mailto:[EMAIL PROTECTED] 
Gesendet: Donnerstag, 23. Dezember 2004 14:51
An: CF-Talk
Betreff: Re: In One?


You could set your table up in a modified preorder tree traversal, so

each node has a LFT and RGT numeric value. I've done this in 
several instances and it works great.

Hey, thanks Dov, that's lovely.

As far as I understand it so far, it does have the snag that if you make
a change near the top of the hierachy, a whole lot of data below has to
be updated.

Also, in this particular instance, I'm importing the category heirachy
from another app on a daily basis which uses the other schema, so I'm
probably looking at a long process to convert it from one schema to
another during the import.

Ian



~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188696
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Prefixing local variables

2004-12-23 Thread Sean Corfield
On Thu, 23 Dec 2004 14:54:34 -0500, Michael Dinowitz
[EMAIL PROTECTED] wrote:
 I've started to use a dollar sign as a prefix for variables which are local
 to a function or CFC. i.e. those variables created when using the var
 keyword.
 CFSET var $Localvar=
 I could have also used an underscore like so:
 CFSET var _Localvar=

I don't like either and I'm puzzled as to why you do it. After all,
everthing that is not a local variable will be prefixed by
variables. or arguments. right?
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 4 invites to give away!

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188697
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Prefixing local variables

2004-12-23 Thread Michael Dinowitz
I just wanted something to force recognition that a variable is local to the
function without having to prefix every argument that is passed in. As the
arguments prefix is optional, this helps in recognition and self
documentation of the code. 

 On Thu, 23 Dec 2004 14:54:34 -0500, Michael Dinowitz
 [EMAIL PROTECTED] wrote:
  I've started to use a dollar sign as a prefix for variables which are
 local
  to a function or CFC. i.e. those variables created when using the var
  keyword.
  CFSET var $Localvar=
  I could have also used an underscore like so:
  CFSET var _Localvar=
 
 I don't like either and I'm puzzled as to why you do it. After all,
 everthing that is not a local variable will be prefixed by
 variables. or arguments. right?



~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188698
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Two Selects

2004-12-23 Thread Aaron Rouse
qForms is what I have used for this as well.  I like being able to
control the layout of my form more so than what could be done with the
two or three selects tags.  I put up some examples a long time ago
doing n-selects with qForms, actually before pengoworks had any up. 
Maybe I should go through mine and make sure they are done correctly
 :)

On Thu, 23 Dec 2004 12:59:16 -0500, Chris Stoner [EMAIL PROTECTED] wrote:
 You also might want to look at the qForms implementation of this
 concept.  Its pretty easilly implemented.
 
 http://www.pengoworks.com/qforms/docs/examples/n-related_selectboxes.htm
 
 
 Tim Laureska wrote:
 
 Andy... I'd sure be interested
 Tim
 
 -Original Message-
 From: Andy Mcshane [mailto:[EMAIL PROTECTED]
 Sent: Thursday, December 23, 2004 12:24 PM
 To: CF-Talk
 Subject: RE: Two Selects
 
 Slightly OT but I managed to alter the 3 selects and create a 4 selects
 related tag if that is of any help to anyone? It was a nightmare to do
 and I can't actually remember how I did it but it works great, I had to
 alter it to enable a user to select a region, country, division  club,
 I am sure it could be useful for other things with a few more changes?
 
 
 
 
 
 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188699
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: How to make mx run all .php extensions

2004-12-23 Thread Asim Manzur
It didn't work for me, I tried to use another extension than php. but it shows 
the same error.



What a cheap server! j/k 

servlet-mapping
  servlet-nameCfmServlet/servlet-name 
  url-pattern*.php/url-pattern 
/servlet-mapping

Worth mentioning, had to alter iis as well to allow scripts and executables
then it started working like a charm.

gabe

-Original Message-
From: Andy Allan [mailto:[EMAIL PROTECTED] 
Sent: Thursday, December 23, 2004 10:10 AM
To: CF-Talk
Subject: Re: How to make mx run all .php extensions

cfmxroot/wwwroot/WEB-INF/web.xml

Though I'm sure you're aware you can't actually process PHP code via CFMX

Andy


On Thu, 23 Dec 2004 10:04:28 -0500, gabriel l smallman [EMAIL PROTECTED]
wrote:

~|
Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net
http://www.cfhosting.net

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188700
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Prefixing local variables

2004-12-23 Thread Sean Corfield
On Thu, 23 Dec 2004 15:43:18 -0500, Michael Dinowitz
[EMAIL PROTECTED] wrote:
 I just wanted something to force recognition that a variable is local to the
 function without having to prefix every argument that is passed in. As the
 arguments prefix is optional, this helps in recognition and self
 documentation of the code.

I prefer to see code explicitly using arguments scope (and variables
scope) so it is crystal clear where data is coming from. If you omit
arguments. then you can't tell whether it's an argument or a
variables scope item (assuming that someone who might omit
arguments. might also omit variables.).
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 6 invites to give away!

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188701
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Prefixing local variables

2004-12-23 Thread Sean Corfield
On Thu, 23 Dec 2004 13:00:08 -0800, Sean Corfield
[EMAIL PROTECTED] wrote:
 I prefer to see code explicitly using arguments scope (and variables
 scope) so it is crystal clear where data is coming from.

And it also makes the code faster since CF doesn't have to search
multiple scopes for an unqualified variable that is really not a local
variable!
-- 
Sean A Corfield -- http://www.corfield.org/
Team Fusebox -- http://www.fusebox.org/
Breeze Me! -- http://www.corfield.org/breezeme
Got Gmail? -- I have 6 invites to give away!

If you're not annoying somebody, you're not really alive.
-- Margaret Atwood

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188702
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Beating a .net horse! Job interview confirms suspicions...

2004-12-23 Thread Will Tomlinson
Kick me off the list if you want. I doubt I could piss anyone off any worse 
than I already have, so I'm going to post this anyway. And I'm not posting in 
CF-Community! 1. I don't want to sign up for it 2. I think five people probably 
frequent the place!

I just had a job interview with a local, high profile web design company here 
in the Triad (NC). They're probably the biggest outfit around this area. So the 
lady asked me the usual questions. Dreamweaver? Handcode? Flash? .NET? CF 
wasn't a big concern of hers when I told her I was a CF developer. She asked me 
if *I* had any questions. So I thought this is the PERFECT opportunity to find 
out the truth about what REAL WORLD design firms are using to build their apps. 
I asked her, Are most of your apps CF or .NET?. It took her 1/2 second to 
answer, .NET. DOT friggin NET! She went on about how they don't do much CF. 

It's a trend fellas! And I'll guarantdamnteeya it's indicitave of the market! 

I rest my case, Thank you! 

Will 

~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188703
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


Re: Beating a .net horse! Job interview confirms suspicions...

2004-12-23 Thread Bryan Stevenson
cf_sarcasm
  Well Will...I guess you had better learn .NET as apparently CF is 
dead...LMAO!!
/cf_sarcasm

Merry Ho Homabye Santa will bring you some new tools to play with

Bryan Stevenson B.Comm.
VP  Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com 


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188704
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


RE: Beating a .net horse! Job interview confirms suspicions...

2004-12-23 Thread Dave Watts
 I just had a job interview with a local, high profile web 
 design company here in the Triad (NC). They're probably the 
 biggest outfit around this area. So the lady asked me the 
 usual questions. Dreamweaver? Handcode? Flash? .NET? CF 
 wasn't a big concern of hers when I told her I was a CF 
 developer. She asked me if *I* had any questions. So I 
 thought this is the PERFECT opportunity to find out the truth 
 about what REAL WORLD design firms are using to build their 
 apps. I asked her, Are most of your apps CF or .NET?. It 
 took her 1/2 second to answer, .NET. DOT friggin NET! She 
 went on about how they don't do much CF. 
 
 It's a trend fellas! And I'll guarantdamnteeya it's 
 indicitave of the market! 
 
 I rest my case, Thank you! 

If that's your case, it's a good thing you're not a lawyer. I've been doing
consulting at a large company in the DC area that uses CF 5 and Notes (an
IBM product), and I asked them what they plan to use for future
applications, and they said CFMX on WebSphere (another IBM product).
What's more, I asked them whether they were planning to switch to Exchange,
and they said no! Based on this one incident, I strongly recommend you sell
your Microsoft stock and buy IBM's, because MS is obviously doomed.

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


~|
Special thanks to the CF Community Suite Silver Sponsor - RUWebby
http://www.ruwebby.com

Message: http://www.houseoffusion.com/lists.cfm/link=i:4:188705
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations  Support: http://www.houseoffusion.com/tiny.cfm/54


  1   2   >