Respool mail on CFMX

Anyone know how to respool mail in CFMX? Care to share? I tried removing the Undelievered_ prefix from the filename and place back in the spool directory with no luck. Thanks, Nelson __ Structure your ColdFusion code with

Writing efficient CFIF statements

** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Hi, I am trying to put more structure into my CF code. My idea is to

Re: Writing efficient CFIF statements

Stephen, I usually like to set things either true or false. (or 1 or 0). The true or false is a little more visual, I think -- so to use your example, I would do it like: cfif myQuery.RecordCount EQ 0 cfset QueryResults = false cfelse cfset QueryResults = true /cfif cfif

RE: Writing efficient CFIF statements

Any opionions on: CFSET QueryResults = IIF(myQuery.RecordCount EQ 0, DE(False), DE(True)) ? Cheers, Hugo - Hugo Ahlenius E-Mail: [EMAIL PROTECTED] Project Officer Phone: +46 8

ColdFusion and VIM

Hi, Does anyone on this list use VIM as their main CF editor (like me?). I am trying to find an updated syntax/highlightning file that supports CFSCRIPT (my only grip about using VIM at the moment), and the maintainer of that file is not responding to my mail... Read more about VIM here:

RE: Writing efficient CFIF statements

Looks cleaner, but isn't it slower? -Original Message- From: Hugo Ahlenius [mailto:[EMAIL PROTECTED]] Sent: 16 July 2002 11:31 To: CF-Talk Subject: RE: Writing efficient CFIF statements Any opionions on: CFSET QueryResults = IIF(myQuery.RecordCount EQ 0, DE(False), DE(True)) ?

RE: Writing efficient CFIF statements

** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Yep it does look a lot cleaner than what I have been doing, but I do have to

RE: Verity: getting file size and date last modified from CFSEARC H

I don;t think you can do it directly with cfsearch - I'm sure someone will correct me if I'm wrong :-) One way you might be able to achieve what you want is to make use of the custom1 and custom2 fields when indexing the collection. You may then have to add each file individually to the

Re: Writing efficient CFIF statements

IIF is slower. Couldn't you just do: cfset QueryResults = myQuery.Recordcount If recordcount is 0, it would be false anyway - Original Message - From: Adrian Lynch [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 6:36 AM Subject: RE: Writing efficient CFIF

RE: Writing efficient CFIF statements

Using IIF() is slower. http://www.corfield.org/coldfusion/codingStandards.htm At 11:43 AM 7/16/2002 +0100, you wrote: ** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message

RE: Writing efficient CFIF statements

** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Yeah, I like that idea. Thanks I think I'll try and use it. Cheers.

Re: Writing efficient CFIF statements

Looks cleaner, but isn't it slower? Any opionions on: CFSET QueryResults = IIF(myQuery.RecordCount EQ 0, DE(False), DE(True)) IIF is supposed to be a little inefficient, but its like all these things. Its probably take a couple of milliseconds longer, so it really makes no

Re: Writing efficient CFIF statements

I just tested it on MX and it works the same. Tim P. - Original Message - From: Stephen Moretti [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 7:05 AM Subject: Re: Writing efficient CFIF statements Looks cleaner, but isn't it slower? Any

RE: Writing efficient CFIF statements

Why set anything? If you're down to this simple of a decision (0 or 1), I would run the query, then use the variable RecordCount in my output since it already exists. Like so... cfif QueryName.RecordCount IS 0 do stuff cfelse don't do stuff cfif Tony Gruen sfnetworks

RE: Writing efficient CFIF statements

Clean and fast: cfset QueryResults = (myQuery.RecordCount gt 0) Patrick __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm

Re: Writing efficient CFIF statements

This thread is odd. As Tim pointed out earlier, any non-zero value evaluates as TRUE so you can just say cfif myQuery.RecordCount and be done with it. That's far cleaner for the eye. - Original Message - From: Patrick McElhaney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent:

CFCs and Attribute scope.

Is the attribute scope available to CFCs? I am getting an error that says my form fields are not available to CFCs via the attribute scope (im using FB3, thus the attribute scope and not form scope). Ideas? Should I explicitly pass them in using the cfargument tag? Michael Tangorre MillenniuM

Re: CFCs and Attribute scope.

I would recommend explicitly passing arguments into a CFC method (or even a custom tag or UDF ) for various reasons, mainly code reusability. To pass values into a CFC method, you can use either cfinvokeargument or list them individually in the cfinvoke tag (just like sending variables into

RE: CFCs and Attribute scope.

Thanks Jeff.. Works good. Mike -Original Message- From: Jeffry Houser [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:39 AM To: CF-Talk Subject: Re: CFCs and Attribute scope. I would recommend explicitly passing arguments into a CFC method (or even a custom tag or UDF )

RE: Writing efficient CFIF statements

If QueryResults is supposed to be a boolean, isn't it better to make it a boolean? Doesn't that make it easier to understand the intent of the code? cfset QueryResults = myQuery.RecordCount The above statement tells me that QueryResults holds the number of records in the query. If I output the

Cf vs AOL help needed....

I have something I've been struggling with for a little while now, and while after exhaustive research I think I'm on the right path I'm not sure I understand quite what the actual solution is. I have a members only website. I use session variables to allow users to move around within the

Re: Respool mail on CFMX

Nelson, This issue includes several known bugs with CFMAIL in CF MX. The first is the type in Undelievered_. The second is that if you move the file to the spool directiory, it won't be resent until you restart the CF MX server. The third issue is that if it can't be resent, it is again

RE: Verity: getting file size and date last modified from CFSEARC H

One way you might be able to achieve what you want is to make use of the custom1 and custom2 fields when indexing the collection. You may then have to add each file individually to the collection using cfindex action=update... and you'd need to write a recursive function to find all the

RE: Verity: getting file size and date last modified from CFSEARC H

Is is possible to get the file size and date last modified for results using CFSEARCH? I don't think there's any way to get that information directly from Verity, but there's nothing to stop you from finding the information on the filesystem after you've retrieved a set of matching files from

RE: Writing efficient CFIF statements

Has this always worked? I'm sure I tried it in an earlier version of cf (4.5) I think, and it didn't work. Can anyone confirm this? Thanks Kola -Original Message- From: Matthew Walker [mailto:[EMAIL PROTECTED]] Sent: 16 July 2002 13:25 To: CF-Talk Subject: Re: Writing efficient CFIF

Fusebox classes 7/20, 7/24, 7/31 Wash DC

Come to an intensive class on Fusebox in Rockville Maryland. Classes limited to 12 students each so that you can be sure to get your own questions answered! Sign up today to guarantee a place at http://www.teratech.com/training/ - Michael Smith, TeraTech, Inc Class list ** Sat 7/20/02

CFMX Error

Has anyone gotten this: err.io.short_read I get it while using the following code: request.loginerror = 1; getPageContext().forward(index.cfm); Michael Tangorre MillenniuM Information Systems 1101 Wilson Blvd, Suite 1200 Arlington, Virginia 22209 (703) 341-1438

RE: Verity: getting file size and date last modified from CFSEARC H

Dave, FYI You can add custom1 and Custom 2 when doing an indexing operation on a file. I do this with an intranet ap that tracks manufacturing runs. The users upload PDF drawings of revisions on a design and I add the primary key and product line to custom 1 and 2. Then, when I do a full

RE: Writing efficient CFIF statements

Has this always worked? I'm sure I tried it in an earlier version of cf (4.5) I think, and it didn't work. Can anyone confirm this? If by this, you mean the fact that CF evaluates non-zero values as true and zero as false, yes, that's worked in every version of CF back to at least 3.

WDDX parsing error on MX

The setup...CFMX, Oracle 8, Solaris. The problem...retrieving WDDX packets created in CF 4.5 Code is attached. It takes a CF structure, CFML2WDDX packets it, inserts it into a CLOB column, retrieves it and WDDX2CFMLs it. If I run this on CFMX its fine. But, if I create the WDDX on CF 4.5 and

RE: Verity: getting file size and date last modified from CFSEARC H

You can add custom1 and Custom2 when doing an indexing operation on a file. Thanks! I didn't know that. I don't think it worked in CF 4.x, but it's nice to know that it works now. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444

Protecting non CF files with CF

We have to protect an entire directory and it's subdirectories with CF. We'd like to use CF to process our logins.. but can't have people directly linking to JPGs and MPGs etc under neath.. since CF can't really protect these individual files unless called through a CFM page, we've run into a

CFHTTP alternatives for Unix?

Are there any reliable alternatives for using CFHTTP on Unix (in my case, Solaris, but migrating to Linux in the near future)? I need to pass large WDDX packets to a Python server extensively, and CFHTTP is just not an adequate, scalable solution. Time is also a big factor, so rolling my own

Re: CFMX Error

Tangorre, Michael wrote: Has anyone gotten this: err.io.short_read Google returns about 25 hits which should give you some idea of what is going on. I get it while using the following code: request.loginerror = 1; getPageContext().forward(index.cfm);

RE: CFMX Error

Yeah... I did that before I posted to the list :-) -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 9:58 AM To: CF-Talk Subject: Re: CFMX Error Tangorre, Michael wrote: Has anyone gotten this: err.io.short_read Google returns

Re: CFMX Error

Jochem, Welcome to the wonderful world of using java libraries within CFMX... http://www.macromedia.com/v1/tipsubmission/tip_detail.cfm?tipid=144 Tangorre, might want to see if you're passing any variables on that forward and you might want to check out the above link and read what Charles

How to override RequestTimeout's in CFMX?

CF5 allows for ?RequestTimeout=X to be tacked on to any URL to override the CFADMIN timeout. Does anyone know if there is any way to do this in CFMX? It seems to ignore this param as far as I can tell. I want 99.999% of my templates to have a timeout as a protection, but be able to run some

RE: CFMX Error

I looked at the code for the custom tag, lots of error checking in there and what not its basically just a tag to save on typing. If I figure out my error I will share on the list.. Mike -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16,

RE: How to override RequestTimeout's in CFMX?

You can set the value using a new attribute of cfsettting, requesttimeout. === Raymond Camden, ColdFusion Jedi Master for Macromedia Email: [EMAIL PROTECTED] Yahoo IM : morpheus My ally is the Force, and a powerful ally it

Re: How to override RequestTimeout's in CFMX?

CF5 allows for ?RequestTimeout=X to be tacked on to any URL to override the CFADMIN timeout. Does anyone know if there is any way to do this in CFMX? It seems to ignore this param as far as I can tell. I want 99.999% of my templates to have a timeout as a protection, but be able to run some

Re: Cf vs AOL help needed....

Well, one of the things that I notice, is that Gecko is simply alot slower than IE and since AOL now is a Gecko loving ISP your visitors may see some slow down. I have several sites that run fine on IE and crawl a bit on Gecko, and keep in mind that some of them do not even use session vars.

Re: CFMX Error

[EMAIL PROTECTED] wrote: Jochem, Welcome to the wonderful world of using java libraries within CFMX... http://www.macromedia.com/v1/tipsubmission/tip_detail.cfm?tipid=144 Thanx for the heads up. I had read that it was possible but got a bit jumpy when the .cfm case it wasn't in the docs

RE: How to override RequestTimeout's in CFMX?

CFMX no longer supports the RequestTimeOut attribute on URL. You can use the following: CFSETTING RequestTimeOut=#url.RequestTimeOut# Is stated on the Migrating ColdFusion 5 Apps doc that came in the CFMX box. []'s Alex -Original Message- From: Dave Carabetta [mailto:[EMAIL

RE: CFMX Error

Did I mention that I was using the FB3 architecutre for this application that is throwing the weird error? Thought maybe that might be important... Mike -Original Message- From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:26 AM To: CF-Talk Subject:

Re: CFHTTP alternatives for Unix?

On Tue, 16 Jul 2002 09:50:24 -0400, Dave Carabetta [EMAIL PROTECTED] wrote: Are there any reliable alternatives for using CFHTTP on Unix (in my case, Solaris, but migrating to Linux in the near future)? I need to pass large WDDX packets to a Python server extensively, and CFHTTP is just not an

RE: Writing efficient CFIF statements

but it IS a boolean. 1 and 0 are boolean yes and no (in most languages). chris olive -Original Message- From: Patrick McElhaney [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 8:59 AM To: CF-Talk Subject: RE: Writing efficient CFIF statements If QueryResults is supposed to be

RE: CFMX Error

Well, there you go... FB3 is your problem. ;) (Just kidding) ~Todd On Tue, 16 Jul 2002, Tangorre, Michael wrote: Did I mention that I was using the FB3 architecutre for this application that is throwing the weird error? Thought maybe that might be important... Mike -Original

RE: Protecting non CF files with CF

Are you using apache? You could probably use CF to write an .htaccess file... -- jon - jon roig senior manager, online production epilepsy foundation phone: 215.850.0710 site: http://www.epilepsyfoundation.org email: [EMAIL PROTECTED] -Original Message- From: JLH

RE: CFMX Error

LOL :-) You might just be right! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:32 AM To: CF-Talk Subject: RE: CFMX Error Well, there you go... FB3 is your problem. ;) (Just kidding) ~Todd On Tue, 16 Jul 2002, Tangorre,

Re: Protecting non CF files with CF

Actually we are using IIS. But. we may be able to use Apache.. nothing is set in stone yet... How would we go about doing the HTAccess.? J - Original Message - From: jon roig [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 10:36 AM Subject: RE:

RE: CFMX Error

I'll tell you what though, this is stumping me!!! I'm gonna go over and post it on the FB list as well.. hopefully someone will have an idea.. Mike -Original Message- From: Tangorre, Michael Sent: Tuesday, July 16, 2002 10:40 AM To: CF-Talk Subject: RE: CFMX Error LOL :-) You

Re: Writing efficient CFIF statements

couldn't you just say... cfif not(len(myQuery.recordcount)) Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Patrick McElhaney [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 5:20 AM Subject: RE: Writing efficient CFIF statements

RE: Protecting non CF files with CF

Check out this tutorial... This will give you an idea on how do set one up, then you should be able to go from there ans how to get CF to write it... http://faq.clever.net/htaccess.htm Mike -Original Message- From: JLH All Turbo [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002

RE: Writing efficient CFIF statements

A Boolean value is a logical TRUE or FALSE. In some languages, this is represented as 0 and 1 or 0 and non-zero, but that's an implementation detail. -Original Message- From: Christopher Olive [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 16, 2002 10:33 AM To: CF-Talk Subject: RE:

Re: How to override RequestTimeout's in CFMX?

Thanks ray :) It's Terry Ford here btw. Sort of lurking. Taking some time to build up my website since I left MM. You wouldnt happen to know much about CFMX on linux would you? I'm encountering a weird problem.. Terry - Original Message - From: Raymond Camden [EMAIL PROTECTED] To:

Re: CFHTTP alternatives for Unix?

Dave Carabetta wrote: Are there any reliable alternatives for using CFHTTP on Unix (in my case, Solaris, but migrating to Linux in the near future)? I need to pass large WDDX packets to a Python server extensively, and CFHTTP is just not an adequate, scalable solution. Time is also a big

SOT: Flash: load sounds

I need a Flash mp3 player similar to the sample that comes with MX. My app is for a talent agency. I've already built the admin where they can upload a sound clip for each actor. Here's what I want to do: User clicks on an actor's name. The actors detail page is displayed, along with the

Re: Protecting non CF files with CF

Got it. Any ideas on how else to do it in IIS and CF? I wish IIS had an authent scheme to look for my cookie and it's content and see that's it there, so let them have access. That'd be nice. J - Original Message - From: Tangorre, Michael [EMAIL PROTECTED] To: CF-Talk [EMAIL

Re: Writing efficient CFIF statements

couldn't you just say... cfif not(len(myQuery.recordcount)) You would only ever get one result from the evaluation... because the length of recordcount will never be less than 1 ... i.e. cfif not len('0') is the same as cfif not 1 ... cfif not myQuery.recordcount works tho... Isaac Dealey

Re: How to override RequestTimeout's in CFMX?

I bet the guys on [EMAIL PROTECTED] would know about CFMX on linux. I'm running it on RH7.2 myself ~Todd On Tue, 16 Jul 2002, Terry Ford wrote: Thanks ray :) It's Terry Ford here btw. Sort of lurking. Taking some time to build up my website since I left MM. You wouldnt happen to know

Re: Writing efficient CFIF statements

true...my bad Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: S. Isaac Dealey [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July 16, 2002 7:55 AM Subject: Re: Writing efficient CFIF statements couldn't you just say... cfif

RE: Writing efficient CFIF statements

The LEAST no of CFIF is the route to best code/speed etc.. This is my theory though Using CFSCRIPT blocks, short-cut evaluation, Switch statements wherever possible than CFIF, arranging likely executable CFIF's/Switch first etc Would be cleaner code to seperate Application Logic from

SOT: Writing good manuals and help systems

Hi there, Hoping to get a few opinions on this topic. Most of my company's CF work thus far has been custom solutions, but recently we've developed some apps that we can distribute as a product. (ie download and install on top of CF server) One of the challenges we've uncovered is coming up

OT: Javascript move up/down in select box

Hi folks. I know this is off-topic, but I'm getting annoyed, and I know someone here will be able to give the answer. I'm trying to do one of those javascript boxes where you can click a button and the items move up or down in the list. I found one that works if I don't care what the values are

RE: Writing efficient CFIF statements

If QueryResults is supposed to be a boolean, isn't it better to make it a boolean? Doesn't that make it easier to understand the intent of the code? You can certainly make this argument, but it's hard to confuse the intent of code which uses integers to determine boolean values. For example,

RE: Writing efficient CFIF statements

** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** Thanks Joe, That was what I was kind of looking for. I am also thinking

RE: Protecting non CF files with CF

AuthentiX... used it before.. How do you go about tracking who downloaded what and how many times etc? AuthentiX is built with an ISAPI filter that overrides Windows NT security model..(Challenge/Response) and creates an Authenticated user, (CGI.Auth_User) gets populated. The other

Re: Writing efficient CFIF statements

If you are going to do that, you might think of using fusebox, which does a very good job of seperating the application logic away from the the display. You can also use just one layout file and have it inherited by all the child directories etc... http://www.fusebox.org Douglas Brown

RE: Writing efficient CFIF statements

If you looking at application architecture design.. Fusebox does a good job www.fusebox.org. this has helped me a lot. all sorts of changes can be done much faster... and gets code organized. Joe Certified Advanced ColdFusion Developer [EMAIL PROTECTED] -Original Message- From: Adams,

RE: Writing efficient CFIF statements

** WESTMINSTER CITY COUNCIL Please refer to the disclaimer beneath this message ** True, I have looked at Fusebox, but at the moment I am not building a Fusebox

CFOBJECT and CFMX - ActivePDF

While I'm waiting for some help desk people to get back in touch with me, I wanted to send this question to the list: We upgraded our test server to CFMX (finally) and run ActivePDF on just about every site on the server (PDF is a standard over here). When we upgraded CFMX totally botched the

RE: CFMX Error

Ok, having gone through the custom tag (cfforward), and having played around with the encode types of forms... the issue lies in here somewhere... it is beyond me however.. According to the author of the custom tag, using a forward on the action page of a form will throw an error and does not

Recursive queries

Still trying to decide how I like to perform some type of recursive query wth the following Table structure; ID NAME PARENT_ID If the current record IS the parent then the Parent ID is 0 Otherwise the child has the ID of the parent as it's Parent ID. Anyone have any good references on

Re: Writing efficient CFIF statements

True, I have looked at Fusebox, but at the moment I am not building a Fusebox app, but I see your point and I should use what I know about Fusebox and apply it to my none Fusebox code. Start out with the techniques in FB2 and you'll get your coding standards to something like you're trying

Re: CFOBJECT and CFMX - ActivePDF

MX is having some COM problems right now, and they are working on a fix to the problem. Hopefully a patch will come out soon. Douglas Brown Email: [EMAIL PROTECTED] - Original Message - From: Smith, Don , , WHS/PSD [EMAIL PROTECTED] To: CF-Talk [EMAIL PROTECTED] Sent: Tuesday, July

CF MX with Deerfield Website Pro Issues

HI, I am looking into upgrading to CF MX from 4.5.1 and I am using Deerfield's Website Pro 2.54. I am seeing that there are issues involved with the combination of CFMX and Website Pro 3. I am looking for any and all solutions to the issue. Thanks Dave Miller

RE: Recursive queries

I had to write a stored proc to recursively scan a tree structure. The only way I could find to do this was through the use of a temp table, and a second query. Basically - Query 1(which is the entry point into the routine) would create the temp table, then call the recursive stored proc (which

RE: Recursive queries

I looped this: SELECT * WHERE PARENT_ID IN (#keyList#) appending the keys returned to a list, and kept going till recordcount = 0 That goes from parent to all children, grandchildcren, all the way down. Going up is the opposite. I can chunk you the code if you want. Matthew P.

RE: CF MX with Deerfield Website Pro Issues

I don't have any experience with Website Pro, but I recommend you Upgrade to 5.0. It is faster then 4.5.1 and just as stable. MX so far has been a big headache. Hopefully there will be patches that magically take care of things. -Original Message- From: [EMAIL PROTECTED]

RE: Recursive queries

This is a very complex query that I used to use to generate a report from: ID Parent Name 1 0 Dad 2 1 Daughter 3 2 Grandson To this: Master_Parent Parent Topic count Dad Dad Daughter

RE: Recursive queries

Does that only allow a set level of depth? Ideally, it should allow nth level relationships, eh? Matthew P. Smith Web Developer, Object Oriented Naval Education Training Professional Development Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] -Original

RE: Writing good manuals and help systems

Matthew, I know that where I am located (Columbus, OH) there is a chapter of a professional organzation called Society of Technical Writers(?) or Association of Technical Writers(?). Typically, in an association such as that, there are a number of freelancers, some specialized in Software

Re: Writing good manuals and help systems

Just about every company has someone who is excellent at writing, and nobody knows your applications like the people that you work with. I would see who in the office might be good at it. Receptionist, salesperson etc...etc... and then sit them down with the developer and more than likely they

Re: CF MX with Deerfield Website Pro Issues

Bob Denny is working on a connector that'll allow you to use WSP 3 and CFMX. I've been testing it on and off for weeks now. It's rather nice and should be out soon. Till then, I'm running on CF 5 and WSP 3. (I've been on WS since the beginning) HI, I am looking into upgrading to CF MX from

RE: Writing efficient CFIF statements

Sorry I meant: cfif somequery.recordcount ... Kola -Original Message- From: Dave Watts [mailto:[EMAIL PROTECTED]] Sent: 16 July 2002 14:49 To: CF-Talk Subject: RE: Writing efficient CFIF statements Has this always worked? I'm sure I tried it in an earlier version of cf (4.5) I

RE: Recursive queries

cfquery name=dbtree select ID, NAME, PARENT_ID, Max(ID) as MAXID from wherever /cfquery cfset tree = ArrayNew(1) cfset ArraySet(tree, 1, dbtree.MAXID, ) cfloop query=dbtree tree[dbtree.ID] = StructNew(); tree[dbtree.ID].ID = dbtree.ID; tree[dbtree.ID].NAME

RE: Writing good manuals and help systems

Matthew, my answer maybe SOT also but here goes. We use the Fusebox framework for development, the relevance of this is that the use of Fuseactions in fusebox makes it really easy to implement not only the application itself but ancillary things like Help Docs, Developer-Client interaction etc.

Re: Recursive queries

Still trying to decide how I like to perform some type of recursive query wth the following Table structure; ID NAME PARENT_ID If the current record IS the parent then the Parent ID is 0 Otherwise the child has the ID of the parent as it's Parent ID. Anyone have any good references

WDDX - deserializing error - invalid character code - bug ???

Hi, I'm getting the following error : --- begin error --- invalid character code The error occurred while processing an element with a general identifier of (CFWDDX), occupying document position (21:5) to (21:108) in the template file ... --- end error --- in the page that

Re: Writing efficient CFIF statements

True, I have looked at Fusebox, but at the moment I am not building a Fusebox app, but I see your point and I should use what I know about Fusebox and apply it to my none Fusebox code. Start out with the techniques in FB2 and you'll get your coding standards to something like you're

Re: Writing efficient CFIF statements

I really wish that people using my documents (originally posted in issues of FA) put down where they got the information from. I see chunks of information on that page taken directly from me. Now as for IIS() under MX. I've tested it heavily and there is literally no difference speed wise

RE: Recursive queries

If you don't choose to add those fields(I recommend you follow S. Isaac's method which is actually something from a guy named joe celko for which you can search google for) then you can do a udf in cfMX which calls a query which calls itself for each child. Or in cf5, you have to write a custom

Re: Writing efficient CFIF statements

I wouldn't declare it dead for the sake of readability. That above anything is a good reason not to use it. ~Todd On Tue, 16 Jul 2002, Michael Dinowitz wrote: I really wish that people using my documents (originally posted in issues of FA) put down where they got the information from. I

Re: WDDX - deserializing error - invalid character code - bug ???

This patch may help: http://www.macromedia.com/v1/Handlers/index.cfm?ID=22955Method=Full 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:

Re: Writing efficient CFIF statements

I'm declaring it dead for the sake of it not being an issue anymore. My original post and times for it showed IIF() being half as fast as CFIF. This is no longer true. Readability is a totally different issue. http://www.fusionauthority.com/alert/index.cfm?alertid=9#Tech1

Re: Writing efficient CFIF statements

Actually, the main problem with using IIF() now is that few people know how to use it right. The double evaluation issue, using DE vs. double quoting, etc. I'm going to have to revise my paper on it and get it out there again. :) http://www.fusionauthority.com/iif.cfm I wouldn't declare it

RE: Recursive queries

If you don't choose to add those fields(I recommend you follow S. Isaac's method which is actually something from a guy named joe celko for which you can search google for) This is news to me. :) I'll have to look him up. Isaac Dealey www.turnkey.to 954-776-0046

RE: Recursive queries

If you don't choose to add those fields(I recommend you follow S. Isaac's method which is actually something from a guy named joe celko for which you can search google for) then you can do a udf in cfMX which calls a query which calls itself for each child. Or in cf5, you have to write a

Re: Recursive queries

chris.alvarado wrote: Still trying to decide how I like to perform some type of recursive query wth the following Table structure; ID NAME PARENT_ID If the current record IS the parent then the Parent ID is 0 Otherwise the child has the ID of the parent as it's Parent ID.

CFMX SQL - simple query with weird error message

We just installed CFMX on a brand new server, W2k with SQL 2000. Most CF5 codes worked and no problems with stored procedures so far, except a few errors on simple queries. One of them was quite weird. Name : VARCHAR(128) Cost: real tableA joins tableB on (tableA.ID = tableB.aID) Case 1:

  1   2   3   >