Re: Recursion

[Zac Spitzer]

S. Isaac Dealey wrote:
> Before you give up... There's a couple of things you can do for the
> recursion in the db... One is to create a cross-reference table which shows
> the parent-child relationship between all records in the table...
> Alternatively, you could try this:
> 
> 
> 
> 
> 
> 
> 
>   
>   SELECT * FROM mytable
>   WHERE parentid IN (#valuelist(rs.id)#)
>   
>   SELECT * FROM rs UNION SELECT * FROM rs2
>   
> 
> 
> This or something like it ought to give you a single query containing all of
> the children of the parent... It will be much slower than a cross-reference
> table in the db, however, it should be similar in performance to the current
> solution... Once you have this query, however, you can then use the
> recursive UDF in CF 5 and either pass the query to the UDF along with the
> current parent id for the tree, or you can place the query in the request
> scope and reference it from there...

never do to much work in cf when your database can do it faster

http://www.sqlteam.com/item.asp?ItemID=8866 is a really nice and simple 
method for doing trees it stores an id path for each node in your 
tree, automatically, that why you can do a query like (see example on 
page above) select node where lineage contains '/#target_node_id#' to 
return a specific part of the tree

z

> 
> 
> hth
> 
> Isaac
> Certified Advanced ColdFusion 5 Developer
> 
> www.turnkey.to
> 954-776-0046
> 
> 
>>All,
> 
> 
>>Thank you for your responses to my inquiry.
> 
> 
>>As it turns out, the CFSCRIPT option is not viable because
>>the point of the recursion was querying a database for
>>records that represented subordinate records which might
>>have subordinate records of their own.
> 
> 
>>The cfmodule seems to take forever and therefore is not
>>practical.
> 
> 
>>In the end, I will have to change the design of the
>>application.  However, that is not necessarily a bad
>>thing.  However, it does make me appreciate the changes in
>>CFMX.
> 
> 
>>Again, thank you all for your responses.
> 
> 
> 
> 
>>-- Original Message
>>--
>>From: Mosh Teitelbaum <[EMAIL PROTECTED]>
>>Reply-To: [EMAIL PROTECTED]
>>Date:  Thu, 12 Sep 2002 15:45:57 -0400
> 
> 
>>>Or, you could rewrite the function without recursion.
>>>Just thought I'd
>>>mention it as another alternative.
>>>
>>
> 
>>>--
>>>Mosh Teitelbaum
>>>evoch, LLC
>>>Tel: (301) 625-9191
>>>Fax: (301) 933-3651
>>>Email: [EMAIL PROTECTED]
>>>WWW: http://www.evoch.com/
>>>
>>>
>>>
-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 12, 2002 2:23 PM
To: CF-Talk
Subject: RE: Recursion



>I wrote this really neat recursive function using the
> tag on my development system which is
>running
>CFMX on WindowsXP Pro.  When I ported to the
>operational host
>(third party), I discovered that they were running a
>previous
>version of CF (I do not know which) which does not
>support
>the new tag.  Does anybody know how to do recursion
>without
>the  tag?

If your recursive function is relatively simple, you can
probably write it
as a CF 5-compliant user-defined function, using
CFSCRIPT.
CFSCRIPT is a tag
in which you can write CF commands using a
JavaScript-like language, which
uses the same syntax and control flow structures as
JavaScript, but uses
CFML operators and expressions. You can't use CFML tags
within a CFSCRIPT
tag, though, and CFSCRIPT doesn't support all the things
you can do with
CFML tags, such as querying a database. Keep in mind
that the host would
have to be using CF 5 or higher for this to work.

Alternatively, you could write a recursive custom tag.
However,
this is the
least desirable alternative, as custom tags don't
provide any built-in
ability to return values (you can write that ability
into your
code, though)
and they tend to negatively affect performance.
Nevertheless, if you need
recursion and you're using a version of CF prior to 5,
that's the only way
you can do it within CFML.

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


>>>
>>__
>>
>>Signup for the Fusion Authority news alert and keep up
>>with the latest news in ColdFusion and related topics.
>>http://www.fusionauthority.com/signup.cfm
>>FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
>>Archives:
>>http://www.mail-archive.com/cf-talk@houseoffusion.com/
>>Unsubscribe:
>>http://www.houseoffusion.com/index.cfm?sidebar=lists
> 
> 
> 
> 
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topi

RE: DW hell

[Thomas Chiverton]

> Does anyone know if there is update to cfstudio 5 that has cfmx tags

And ditto for HOmeSite+ 5.1 ?

Thomas Chiverton
LocaVista


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT: OpenSSL + Perl + CF

[cf-talk]

Hi list,
we have a perl script running (initialized from CF),
which proves credit card authorization against another
machine via OpenSSL (SSLeay) libraries.
We adopted this script from a Linux box.
It is not running on our Windows box because OpenSSL is not installed.
Someone told me, that we shouldn't really use
OpenSSL since it slowing down the machine under Win2000 significantly.
Is there any other credit card authorization process or data transfer
mechanism (XML ? + the actual authorization is done on another box) in secure 
environments you know of ?
Thanks
Uwe

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Recursion

[Adam Reynolds]

I think UDFs do not do recursion.

The moment you return a value from nested UDFs it finishes the whole stack.

I found that cfmodule can be very good.

If you are making a lot of recursive calls to get the same result set, then
it is very very important to store the result set inside a structure (say at
application level).

I found this particularly useful when generating personalised site
navigation generated from a database. It made a massive boost to
performance.


> -Original Message-
> From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
> Sent: 12 September 2002 20:11
> To: CF-Talk
> Subject: Re: Recursion
>
>
>   Rewrite the function using the CFScript UDF syntax.  Theoretically it
> should work fine, but it may depend on what you are doing inside the
> CFFunction tag.
>
> At 01:31 PM 9/13/2002 +0600, you wrote:
> >Hello all,
> >
> >I wrote this really neat recursive function using the
>  tag on
> >my development system which is running CFMX on WindowsXP Pro.  When I
> >ported to the operational host (third party), I discovered that
> they were
> >running a previous version of CF (I do not know which) which does not
> >support the new tag.  Does anybody know how to do recursion without the
> > tag?
> >
> >Thank you!
> >
> >--
> >Respectfully,
> >
> >Robert J. Polickoski, CNA
> >Lead Programmer
> >(540) 842-6339
> >[EMAIL PROTECTED]
> >AIM: RobertJFP
> >Windows Messenger: RPolickoski
> >--
> >
> 
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Recursion

[Rich Wild]

> I think UDFs do not do recursion.

not true.

nice example:

http://www.cflib.org/udf.cfm?ID=600

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Textarea value incorrect when used with Wddx

[JAIME HOI]

hi 
  i encountered this problem. I used cfwddx to convert my queries into javascript 
arrays. Purpose is to be able to update the specific row in the array upon change. 
Thus Upon onchange event of my form elements, it would go into a javascript function 
to set the value changed into the js wddx array. However when i was using textarea, 
very strangely the "enter" keystroke was not captured in the array. In fact it was 
removed from the string value once i set it into the js wddx array. 
 
An example will be like the one below
 

 

wddx_insert = 1;
wddx_update = 2;
 
function fn_Update ( wddxName, fieldName, intRowNum ) {
 
obj = eval(wddxName + '.' + fieldName + '[' + intRowNum + ']')
 obj = strValue ;

if ( eval(wddxName + '.action' + '[' + intRowNum + ']' ) != wddx_insert )eval( 
wddxName + '.action' + '[' + intRowNum + ']' + '='+ wddx_update ) 
}



this function is supposed to set the strValue passed in into the array, then update 
the action fieldname to wddx_insert. So that upon saving , i would like which rows was 
amended. 

Have anyone came across this bug ? Or did i do it wrongly?

 

 


**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Recursion

[Adam Reynolds]

hat



> -Original Message-
> From: Rich Wild [mailto:[EMAIL PROTECTED]]
> Sent: 13 September 2002 10:56
> To: CF-Talk
> Subject: RE: Recursion
> 
> 
> > I think UDFs do not do recursion.
> 
> not true.
> 
> nice example:
> 
> http://www.cflib.org/udf.cfm?ID=600
> 
> 
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE Structure ... I have a bad feeling about this...

[Everett, Al]

Can you CFDUMP it?

> -Original Message-
> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, September 12, 2002 11:21 PM
> To: CF-Talk
> Subject: CFFILE Structure ... I have a bad feeling about this... 
> 
> 
> Someone please tell me I'm wrong and that  does create it's
> variables in a structure called CFFILE and not as a collection of
> dissociated variables? ... CF 5 currently... I'm trying to 
> use this code:
> 
>  DESTINATION="#ulpath#" NAMECONFLICT="MAKEUNIQUE">
> 
> 
> but it chokes on "cffile" saying it can't find the variable...
> 
> Isaac Dealey
> Certified Advanced ColdFusion 5 Developer
> 
> new epoch
> www.turnkey.to
> 954-776-0046
> 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: DW hell

[Everett, Al]

Holy cow. This comes up every couple of days.

Search the archives. http://www.houseoffusion.com/cf_lists

You might also try Googling "ColdFusion MX Updater"

> -Original Message-
> From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 13, 2002 4:12 AM
> To: CF-Talk
> Subject: RE: DW hell
> 
> 
> > Does anyone know if there is update to cfstudio 5 that has cfmx tags
> 
> And ditto for HOmeSite+ 5.1 ?
> 
> Thomas Chiverton
> LocaVista
> 
> 
> 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFFILE Structure ... I have a bad feeling about this...

[Gyrus]

- Original Message -
From: "Joe Eugene" <[EMAIL PROTECTED]>
> >  > DESTINATION="#ulpath#" NAMECONFLICT="MAKEUNIQUE">
> > 
>
> I think FILEFIELD does not need "#" sign in CFMX, since u are specifying
> (cffile).. am assuming u are on CFMX. I think CFFILE.. is not yet created
> because of the filefield # sign. Havent tested this.


But I assume #attributes.filefield# refers to the file field, so the pound
signs are needed. If the form field is called 'filePath',
FILEFIELD="#filePath#" would be wrong, but if attributes.filefield EQ
"filePath", then the above is right, no?

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: question for MM: CFMX sandboxing security holes?

[Candace Cottrell]

But if you are hosted in a sandbox environment, you really cant use all
of Dreamweaver MX's functionality. Correct? Because of the  RDS issue?

I have this problem at home with my personal website
(www.ccewebdev.com). I wanted to check out the databindings, etc.
that DWMX offers, but HostMySite said they couldnt allow it. S, I
guess the option is to have my own local development server, use the RDS
for that and upload the whole shebang.

If anyone can think of a better way, I am open :)

Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org

 
[EMAIL PROTECTED]

>>> [EMAIL PROTECTED] 9/10/2002 11:09:22 AM >>>
For what it's worth, we are running CFMX and running sandboxing and
allow
use of CFFILE, CFDIRECTORY, and other "non-secure" tags. The server has
been
up for just over a month and I've not seen any issues as of yet.


Dan Phillips
CFXHosting.com

-Original Message-
From: Gyrus [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, September 10, 2002 10:45 AM
To: CF-Talk
Subject: question for MM: CFMX sandboxing security holes?


Could I get an official line from Macromedia on this?

We're being told by a potential host that they are only offering CF 5
with
CFFILE etc. enabled in a shared environment, secured through
sandboxing,
because they've been advised that the sandboxing security in CFMX is
not yet
stable. They are offering CFMX accounts, only with all non-secure tags
disabled.

I've not heard about this CFMX sandboxing security issue anywhere here
-
what's the company's official position on this?

many thanks,

- Gyrus


- [EMAIL PROTECTED] 
work: http://www.tengai.co.uk 
play: http://www.norlonto.net 
- PGP key available




__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFFILE Structure ... I have a bad feeling about this...

[S . Isaac Dealey]

No, that didn't work either... It seems either it is a structure and only
its elements are exposed, or it doesn't actually return a structure...

> Can you CFDUMP it?

>> -Original Message-
>> From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
>> Sent: Thursday, September 12, 2002 11:21 PM
>> To: CF-Talk
>> Subject: CFFILE Structure ... I have a bad feeling about
>> this...
>>
>>
>> Someone please tell me I'm wrong and that  does
>> create it's
>> variables in a structure called CFFILE and not as a
>> collection of
>> dissociated variables? ... CF 5 currently... I'm trying
>> to
>> use this code:
>>
>> > FILEFIELD="#attributes.filefield#"
>> DESTINATION="#ulpath#" NAMECONFLICT="MAKEUNIQUE">
>> 
>>
>> but it chokes on "cffile" saying it can't find the
>> variable...
>>
>> Isaac Dealey
>> Certified Advanced ColdFusion 5 Developer
>>
>> new epoch
>> www.turnkey.to
>> 954-776-0046
>>
>>
> __
> 
> Structure your ColdFusion code with Fusebox. Get the
> official book at http://www.fusionauthority.com/bkinfo.cfm
> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
> Archives:
> http://www.mail-archive.com/cf-talk@houseoffusion.com/
> Unsubscribe:
> http://www.houseoffusion.com/index.cfm?sidebar=lists


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFFILE Structure ... I have a bad feeling about this...

[S . Isaac Dealey]

> - Original Message -
> From: "Joe Eugene" <[EMAIL PROTECTED]>
>> > > > FILEFIELD="#attributes.filefield#"
>> > DESTINATION="#ulpath#" NAMECONFLICT="MAKEUNIQUE">
>> > 
>>
>> I think FILEFIELD does not need "#" sign in CFMX, since u
>> are specifying
>> (cffile).. am assuming u are on CFMX. I think CFFILE.. is
>> not yet created
>> because of the filefield # sign. Havent tested this.
> 

> But I assume #attributes.filefield# refers to the file
> field, so the pound
> signs are needed. If the form field is called 'filePath',
> FILEFIELD="#filePath#" would be wrong, but if
> attributes.filefield EQ
> "filePath", then the above is right, no?

Yes, this particular module is a custom tag which wraps around the 
tag in order to encapsulate some additional file-upload functionality in
this application, so filefield="#attributes.filefield#" is passing the name
of the form field containing the file from the calling document. That works
-- and the file _does_ upload, and it _does_ create the variable
#cffile.filewasuploaded# which evaluates to true ... but at that point, even
though  works, no attempt to manipulate a
structure named  has been successful -- they've all met with
"unknown variable 'cffile' ... "


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Recursion

[S . Isaac Dealey]

> S. Isaac Dealey wrote:
>> Before you give up... There's a couple of things you can
>> do for the
>> recursion in the db... One is to create a cross-reference
>> table which shows
>> the parent-child relationship between all records in the
>> table...
>> Alternatively, you could try this:
>>
>> 
>> 
>> 
>> 
>>
>> 
>>  
>>  SELECT * FROM mytable
>>  WHERE parentid IN (#valuelist(rs.id)#)
>>  
>>  SELECT * FROM rs UNION SELECT * FROM rs2
>>  
>> 
>>
>> This or something like it ought to give you a single
>> query containing all of
>> the children of the parent... It will be much slower than
>> a cross-reference
>> table in the db, however, it should be similar in
>> performance to the current
>> solution... Once you have this query, however, you can
>> then use the
>> recursive UDF in CF 5 and either pass the query to the
>> UDF along with the
>> current parent id for the tree, or you can place the
>> query in the request
>> scope and reference it from there...
>
> never do to much work in cf when your database can do it
> faster

Well, that's why I recommended that a cross-reference table would be
faster... :) All my recursion is done using the NTM model described by that
guy who wrote the book "SQL for Smarties" ... don't remember his name --
never actually read the book -- discovered the method was documented after I
had figured out how to do it on my own... But if the page in question
doesn't see huge amounts of traffic, or if the tree structure isn't
tremendously deep ( width isn't much of a problem ) then it's not wholly
unreasonable in terms of performance to do it in cf as above...


Isaac
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Comma seperaed help

[Kris Pilles]

Thanks for your thoughts Jerry.  I already have a my data model done.
We are using the related table to join the keywords to descriptions like
you mentioned.  I do think that giving them 2 selects (1 eith all the
keywords and 1 to move the keywords you want associated to that
descripotion is my best course of action).  

Now, my next issue is I am currently loggin all searches that are
entered into our search engine and I would like to find some way to
relate our keywords table to our searches table.

Thanks for your help!@!~

KP 

-Original Message-
From: Jerry Johnson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, September 12, 2002 4:14 PM
To: CF-Talk
Subject: RE: Comma seperaed help


Having just fixed a similar system, let me suggest you control the entry
a little more closely.

If you truly want free form data entry, use line feeds as the delimiter
instead of commas.

Just give them a tall text area and let them go to town.  The visible
break for each line leaves no wiggle room on the user's part about
whether they have or have not separate each item.

If you really want to store a comma delimited list, replace all line
feeds with commas before stashing in db, and replace all commas with
line feeds before displaying in the text area.

But...

If you really want to "help" the user, and if keywords are used over and
over again, you might instead go with a two select box with a move
button between each (unused, used keywords), as well as a text area in
the unused side to add new keywords.

This will help with data integrity, by not forcing them to reenter
previously used keywords (which will up your hit rate on searching for
keywords)

As for storing the data, if you are storing it in a db, remember that
"like" searches are usually considerably slower than a good relation
structure. Instead of a single comma separate field, might a related
table with a record for each keyword be a better db design?

Just a thought
Jerry Johnson

>>> [EMAIL PROTECTED] 09/12/02 03:12PM >>>
You could assume that every space in the text equals a comma, and just
do a replace

 -Original Message-
From:   Kris Pilles [mailto:[EMAIL PROTECTED]] 
Sent:   Thursday, September 12, 2002 12:37 PM
To: CF-Talk
Subject:Comma seperaed help

I have to give our users a screen where they can enter multiple
keywords.  Initially I was thinking of 1 gib memo field and the user
could speerate the words with a comma but im not so sure they actually
remember to put the comma in.  S I figured I would ask  you guys
what my other options are?  Also, I want to avoid giving them 20 text
boxes to put in keywords with...


Any suggestions would help

Thanks

KP

Kris Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED] 





__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CFFILE Structure ... I have a bad feeling about this...

[Gyrus]

- Original Message -
From: "S. Isaac Dealey" <[EMAIL PROTECTED]>
> -- and the file _does_ upload, and it _does_ create the variable
> #cffile.filewasuploaded# which evaluates to true ... but at that point,
even
> though  works, no attempt to manipulate a
> structure named  has been successful -- they've all met with
> "unknown variable 'cffile' ... "


I'm curious to see how this turns out, cos I've a vauge memory from a few
weeks back (!! :-|) of having problems CFDUMPing a "built-in" CF structure.
Can't recall the details, but it's possible there was a problem I didn't
credit CF with, and I worked around it and forget that possibility...

- Gyrus


- [EMAIL PROTECTED]
work: http://www.tengai.co.uk
play: http://www.norlonto.net
- PGP key available


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: DW hell

[Thomas Chiverton]

> Holy cow. This comes up every couple of days.

Is there a FAQ then ?
 
> Search the archives. http://www.houseoffusion.com/cf_lists

Nope, no help...
 
> You might also try Googling "ColdFusion MX Updater"

Mildly better, ta.

Thomas Chiverton
LocaVista


__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: DW hell

[Everett, Al]

> > Holy cow. This comes up every couple of days.
> 
> Is there a FAQ then ?

No, but the archives make it pretty unnecessary.

> > Search the archives. http://www.houseoffusion.com/cf_lists
> 
> Nope, no help...

I just searched for "tag updater" and had lots of hits.

http://www.houseoffusion.com/cf_lists/index.cfm?method=results&optionlist=0&;
forumid=4&Search=tag+updater&optionlist=2&Author=&After=&Before=&maxrows=20


> > You might also try Googling "ColdFusion MX Updater"
> 
> Mildly better, ta.

I almost always turn to Google first and almost always find what I'm looking
for.
__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Recursion

[Robert Polickoski]

All,

Thank you again for all of your suggestions.  As time allows, I will probably play 
with all of them just to learn how.

It is wonderful to have such support.

Take care,
Robert

-- Original Message --
From: S. Isaac Dealey <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Date:  Fri, 13 Sep 2002 08:56:59 -0400

>> S. Isaac Dealey wrote:
>>> Before you give up... There's a couple of things you can
>>> do for the
>>> recursion in the db... One is to create a cross-reference
>>> table which shows
>>> the parent-child relationship between all records in the
>>> table...
>>> Alternatively, you could try this:
>>>
>>> 
>>> 
>>> 
>>> 
>>>
>>> 
>>> 
>>> SELECT * FROM mytable
>>> WHERE parentid IN (#valuelist(rs.id)#)
>>> 
>>> SELECT * FROM rs UNION SELECT * FROM rs2
>>> 
>>> 
>>>
>>> This or something like it ought to give you a single
>>> query containing all of
>>> the children of the parent... It will be much slower than
>>> a cross-reference
>>> table in the db, however, it should be similar in
>>> performance to the current
>>> solution... Once you have this query, however, you can
>>> then use the
>>> recursive UDF in CF 5 and either pass the query to the
>>> UDF along with the
>>> current parent id for the tree, or you can place the
>>> query in the request
>>> scope and reference it from there...
>>
>> never do to much work in cf when your database can do it
>> faster
>
>Well, that's why I recommended that a cross-reference table would be
>faster... :) All my recursion is done using the NTM model described by that
>guy who wrote the book "SQL for Smarties" ... don't remember his name --
>never actually read the book -- discovered the method was documented after I
>had figured out how to do it on my own... But if the page in question
>doesn't see huge amounts of traffic, or if the tree structure isn't
>tremendously deep ( width isn't much of a problem ) then it's not wholly
>unreasonable in terms of performance to do it in cf as above...
>
>
>Isaac
>Certified Advanced ColdFusion 5 Developer
>
>www.turnkey.to
>954-776-0046
>
>
__
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Macromedia Developers Gallery

[Robert Everland]

Having issues with the developer gallery, since whenever I post to their bug
list nothing is ever done about it I hope to catch someone's eye here.
Whenever I log on it shows this at the top of the screen and doesn't really
log me on.

HTTP/1.1 200 OK
Server: Microsoft-IIS/4.0
Date: Fri, 13 Sep 2002 13:16:20 GMT
Connection: close
Content-type: text/html
Page-Completion-Status: Normal
Page-Completion-Status: Normal
Set-Cookie: MMUSERID=27755031; path=/; domain=.macromedia.com; 
Set-Cookie: ONYXIINDIVIDUALID=; path=/; domain=.macromedia.com; 
Set-Cookie: SESSION=%7Bts+%272002%2D09%2D13+09%3A16%3A18%27%7D; path=/; 
Set-Cookie: UID=2476F8C8%2D8496%2D11D6%2D84508B94F85A; expires=Sun,
27-Sep-2037 00:00:00 GMT; path=/; domain=.macromedia.com; 


Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 
__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: DW hell

[Thomas Chiverton]

> I just searched for "tag updater" and had lots of hits.
>
> http://www.houseoffusion.com/cf_lists/index.cfm?method=results&opt
> ionlist=0&
> forumid=4&Search=tag+updater&optionlist=2&Author=&After=&Before=&m
> axrows=20

Now put homesite as another keyword.


Zero results :-p

Thomas Chiverton
LocaVista


__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Macromedia Developers Gallery

[John Beynon]

Not just put IE6 sP1 on have you? Or XP SP1?

Jb.

-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: 13 September 2002 14:18
To: CF-Talk
Subject: Macromedia Developers Gallery


Having issues with the developer gallery, since whenever I post to their bug
list nothing is ever done about it I hope to catch someone's eye here.
Whenever I log on it shows this at the top of the screen and doesn't really
log me on.

HTTP/1.1 200 OK
Server: Microsoft-IIS/4.0
Date: Fri, 13 Sep 2002 13:16:20 GMT
Connection: close
Content-type: text/html
Page-Completion-Status: Normal
Page-Completion-Status: Normal
Set-Cookie: MMUSERID=27755031; path=/; domain=.macromedia.com; 
Set-Cookie: ONYXIINDIVIDUALID=; path=/; domain=.macromedia.com; 
Set-Cookie: SESSION=%7Bts+%272002%2D09%2D13+09%3A16%3A18%27%7D; path=/; 
Set-Cookie: UID=2476F8C8%2D8496%2D11D6%2D84508B94F85A; expires=Sun,
27-Sep-2037 00:00:00 GMT; path=/; domain=.macromedia.com; 


Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 

__
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Macromedia Developers Gallery

[Tony Weeg]

hey, whats the url for the developers gallery?
Im having issues with some stuff on my sites,
and I just did install sp1 for xp.

I want to try that developers gallery link you
are having issues with.

..tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 


-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 13, 2002 9:18 AM
To: CF-Talk
Subject: Macromedia Developers Gallery


Having issues with the developer gallery, since whenever I post to their
bug
list nothing is ever done about it I hope to catch someone's eye here.
Whenever I log on it shows this at the top of the screen and doesn't
really
log me on.

HTTP/1.1 200 OK
Server: Microsoft-IIS/4.0
Date: Fri, 13 Sep 2002 13:16:20 GMT
Connection: close
Content-type: text/html
Page-Completion-Status: Normal
Page-Completion-Status: Normal
Set-Cookie: MMUSERID=27755031; path=/; domain=.macromedia.com; 
Set-Cookie: ONYXIINDIVIDUALID=; path=/; domain=.macromedia.com; 
Set-Cookie: SESSION=%7Bts+%272002%2D09%2D13+09%3A16%3A18%27%7D; path=/; 
Set-Cookie: UID=2476F8C8%2D8496%2D11D6%2D84508B94F85A; expires=Sun,
27-Sep-2037 00:00:00 GMT; path=/; domain=.macromedia.com; 


Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 

__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Macromedia Developers Gallery

[John Beynon]

http://devex.macromedia.com/developer/gallery/index.cfm

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]] 
Sent: 13 September 2002 14:33
To: CF-Talk
Subject: RE: Macromedia Developers Gallery


hey, whats the url for the developers gallery?
Im having issues with some stuff on my sites,
and I just did install sp1 for xp.

I want to try that developers gallery link you
are having issues with.

.tony

Tony Weeg
Senior Web Developer
Information System Design
Navtrak, Inc.
Fleet Management Solutions
www.navtrak.net
410.548.2337 


-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Friday, September 13, 2002 9:18 AM
To: CF-Talk
Subject: Macromedia Developers Gallery


Having issues with the developer gallery, since whenever I post to their bug
list nothing is ever done about it I hope to catch someone's eye here.
Whenever I log on it shows this at the top of the screen and doesn't really
log me on.

HTTP/1.1 200 OK
Server: Microsoft-IIS/4.0
Date: Fri, 13 Sep 2002 13:16:20 GMT
Connection: close
Content-type: text/html
Page-Completion-Status: Normal
Page-Completion-Status: Normal
Set-Cookie: MMUSERID=27755031; path=/; domain=.macromedia.com; 
Set-Cookie: ONYXIINDIVIDUALID=; path=/; domain=.macromedia.com; 
Set-Cookie: SESSION=%7Bts+%272002%2D09%2D13+09%3A16%3A18%27%7D; path=/; 
Set-Cookie: UID=2476F8C8%2D8496%2D11D6%2D84508B94F85A; expires=Sun,
27-Sep-2037 00:00:00 GMT; path=/; domain=.macromedia.com; 


Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 


__
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists