Re: Another Disturbing MX Error

[Jesse Houwing]

Sean A Corfield wrote:

On Wednesday, Dec 18, 2002, at 12:11 US/Pacific, Mark Johnson wrote:
  

I like the theory, but there is one part that doesn't make sense.  This
error continued to happen until i restarted the service and more 
explicitily
killed jrun.  There are about twenty of the errors listed below.  
While it



Yes, I've seen that situation too. Typically, there will be several 
requests all getting out of memory errors at the same time (since 
nearly everything in Java makes requests to the allocator).

  

was happening i looked at Task Manager and zeroed in on the jrun 
process and
it was running well under the 512MB limit.  Which seems to point to 
the fact
that it was no longer taking up 512MB of memory.  If that is true then 
what



That is a little strange but I believe you (because you are not the 
only person to have monitored memory usage and observed that same 
behavior). I'm not entirely sure of a suitable explanation for what you 
are seeing but I'm having a conversation with some folks internally 
about this. My experience has been that if the system hits an out of 
memory error and then you stop accessing it for a while, it finishes 
garbage collecting and recovers fairly well (we've load tested CFMX to 
that point and had it recover properly several times). Mind you, 
watching the memory usage on Solaris we *have* seen it hit the high 
water mark at the point of error.
  

If you run Coldfusion on the new JRockit JVM (7.0sp1 1.4 edition) your 
CFMX installation will use a different type of garbage collection, which 
makes it a lot less likely that you'll be running out of memory. And 
it'll be faster too :)

Jesse

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

OT: browser stats, mozilla rising

[Zac Spitzer]

few interesting stories around the web today about mozilla's market 
share rising...

this is the stats from heise.de a big german news site, where mozilla 
based browsers now accounting for 19.4% of users

http://translate.google.com/translate?u=http://www.heise.de/newsticker/data/anw-18.12.02-000/

found from a story on mozilazine

http://www.mozillazine.org/talkback.html?article=2767

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

CFMX / JVM

[Robertson-Ravo, Neil (RX)]

What JVM do Macromedia recommend to use for performance etc...?  Is there
on?  What does everyone else use?

(that said, I still cannot get my ColdFusion MX server to start at boot
time!)
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: How to do this without the subselect?

[stas]

Break it into 2 queries.

CFQUERY Name=GetWaivers1 Datasource=#DSN#
Select RW.ClientID 
from RentalWaivers RW
where Month(RW.RentalWaiverDate) = #Form.Month#
and Year(RW.RentalWaiverDate) = #Form.Year#)
/CFQUERY

cfset filter = valuelist(getWaivers1,clientID)

CFQUERY Name=GetWaivers Datasource=#DSN#
Select UW.UtilityWaiverID
from utilitywaivers UW
where Month(UW.IssueDate) = #Form.Month#
and Year(UW.IssueDate) = #Form.Year#
 and UW.ClientID not in (#filter#)
  
/CFQUERY


 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, December 19, 2002 1:50 AM
 To: CF-Talk
 Subject: How to do this without the subselect?
 
 
 Hi, all.
 
 How can I get the same results as this query with using the subselect?
 
 CFQUERY Name=GetWaivers Datasource=#DSN#
 
  Select UW.UtilityWaiverID
 from utilitywaivers UW
   where Month(UW.IssueDate) = #Form.Month#
  and Year(UW.IssueDate) = #Form.Year#
  and UW.ClientID not in
(Select RW.ClientID from RentalWaivers RW
 where Month(RW.RentalWaiverDate) = #Form.Month#
and Year(RW.RentalWaiverDate) = #Form.Year#)
 
 /CFQUERY
 
 (I'll be s glad when they get subselects in mySQL 4.2!)
 
 Thanks,
 
 Rick
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

MX Support # 44972

[Robertson-Ravo, Neil (RX)]

This one is really getting me down.  Macromedia has identified issue #44972
: The ColdFusion MX Application Server service does not start automatically
following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when you
reboot?  even when there has been no configurations added/changed etc..?  

Neil
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: How to do this without the subselect?

[Zac Spitzer]

Rick Faircloth wrote:
 Hi, all.
 
 How can I get the same results as this query with using the subselect?
 
 CFQUERY Name=GetWaivers Datasource=#DSN#
 
  Select UW.UtilityWaiverID
 from utilitywaivers UW
   where Month(UW.IssueDate) = #Form.Month#
  and Year(UW.IssueDate) = #Form.Year#
  and UW.ClientID not in
(Select RW.ClientID from RentalWaivers RW
 where Month(RW.RentalWaiverDate) = #Form.Month#
and Year(RW.RentalWaiverDate) = #Form.Year#)
 
 /CFQUERY
 
 (I'll be s glad when they get subselects in mySQL 4.2!)

do a left outer join on RentalWaivers in the query and then do a check 
that where UW.ClientID is null (if, this is standard perfomance 
improvement anyway as it uses a index...)

not in is actually a real bad performance killer... this technique is 
found in most good oracle books... should work for mysql but i don't know

z

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Best Way To Integrate Separate Web Sites using CF

[Dick Applebaum]

OK, It appears that you want to just be able to access another sites  
database records and files rather than to make sure that the  
databases/files of these sites are synchronized (contain each other's  
data).

You can do this with a web service on each site that receives a request  
(from another site) and returns the data requested -- if the sites are  
CFMX.

If you are using prior versions of CF, it's a little more work.  You  
can write a CF stub that resides on each site.  As above, the stub  
receives requests for database records/files from other sites and  
returns the results.  You use WDDX to handle the passing of data, for  
example;

Site a - requestor   Site b - target
===  ===
-Compose db query
-serialize into WDDX
-cfhttp pass request -- -receive request
  -deserialize request
  -issue query to b's db
  -serialize results
-receive results -- -return results
-deserialize results
-display results

To site a, it appears as if you have local access to site b's database,  
etc.

I have used the stub/WDDX approach to move entire databases from one  
remote site to another where I didn't have admin privileges to either  
site.

The easiest way to return non-text images/files is to just pass the URL  
of the image/file to the requestor, which, in turn, passes it to the  
requesting browser.

HTH

Dick

On Wednesday, December 18, 2002, at 10:15 PM, CounterCW wrote:

 The databases will be on separate servers.
 So, unfortunately, I won't be able to do SQL statements.

 Is there another method I can use?

 --
 Mike







 At 04:24 PM 12/18/02 -0800, you wrote:
 Is the database on a separate server or servers?

 Does each site have a separate database, or do they sahre a common
 database with a column in each table that identifies the site.

 You can set up a shared database with each table having a layout such
 as:

 Create Table Customer
   (
CustomerID  Integer Identity Primary Key,
SiteID   Char.
*
*
*
   )

 Then your queries could include site identifiers (or not)

 SELECT * From Customer
WHERE SiteID = 'a'


 SELECT * From Customer
WHERE SiteID IN ('a','c','d')

 So, you could easily integrate the db.

 I did a web site with 12 different magazines sharing a common set of
 programs and 1 common database using the above design.  They also
 shared a common CF server.

 Based, on the URL accessed initially, a session variable was set which
 determined the look and feel of the site-- the common programs would
 work slightly differently depending on the site being accessed.

 As some others have mentioned, you could use CFMXJ2ee an something  
 like
 Websphere, JRun or Tomcat and deploy a different CF Server instance  
 for
 each site.

 HTH

 Dick


 On Wednesday, December 18, 2002, at 03:10 PM, CounterCW wrote:

 What is the best way to synchronize multiple web sites so that if one
 website wants to share information with others, they can?
 For example, if you had these web sites: (each on different servers)

 a.com
 b.com
 c.com
 d.com

 If each of these web sites had information in a database, how could
 Coldfusion retrieve this information so that the articles of data
 could
 be seen on their own web sites?  Keep in mind that these articles
 could
 contain images or other objects.

 Anyone have ideas?  Thanks,

 --
 Mike.


 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: Best Way To Integrate Separate Web Sites using CF

[Jon Hall]

Sounds like you are using Access...if a better db server is not in the
budget, you might want to investigate MySQL. That would allow you to
make remote db connections.

-- 
jon
mailto:[EMAIL PROTECTED]

Thursday, December 19, 2002, 1:15:56 AM, you wrote:

C The databases will be on separate servers.
C So, unfortunately, I won't be able to do SQL statements.

C Is there another method I can use?

C --
C Mike

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: cferror

[Tim Laureska]

Rick... sorry I didn't respond sooner about your initial blank screen
.. I think that was the same problemquestion

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 2:04 AM
To: CF-Talk
Subject: RE: cferror

Thanks for the in-depth analysis, Mosh!

Concerning this comment:

 This is still valid with one caveat; you
  must put CFOUTPUT tags around any variables used in the request
handler.

I found that out when I followed your suggestion to CFINCLUDE
the user display page from within the admin diagnostic page.

I ended up putting this on the application.cfm:

CFERROR Type=Exception Template=error_admin.cfm
Exception=Any mailto=[EMAIL PROTECTED]

Then, from within the error_admin.cfm page, I put:

CFINCLUDE Template=error_user.cfm

I could send my mail using a CF_Dump var=#Error# custom tag to
send the error info to my email, and have the CFIncluded
error_user.cfm
page display the error info to the user.  (After putting the
CFOUTPUT's
around message for error variables.)

It's going to be great having these error messages show up in my email
when a user has a problem.  Now, I'll be able to call them right away,
if needed, instead of waiting until they get frustrated and have to call
me!

Thanks again!

Rick



-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 12:55 AM
To: CF-Talk
Subject: RE: cferror


Mosh Teitelbaum wrote:
 ... there's no reason why you can't specify multiple CFERROR
 TYPE=Exception tags as in:

 CFERROR TYPE=Request TEMPLATE=request_error.cfm
 CFERROR TYPE=Exception EXCEPTION=Database
TEMPLATE=db_exception.cfm
 CFERROR TYPE=Exception EXCEPTION=Application
TEMPLATE=app_exception.cfm

 I don't know what would happen though if you did the above and
 also included an EXCEPTION=All.  Would it catch everything,
 ignoring the other tags, or would it catch everything not
 specified in the other tags.  Order might matter in this case (as
 it does when declaring CFCATCH blocks).  Dunno... if I have some
 time tonight, I'll try to remember to test it out.

So I did some testing and, for those that are interested, what follows
is a
summary of the findings and some items to note:

ColdFusion lets you define multiple instances of the CFERROR tag.  The
two
attributes we're concerned with here are TYPE and EXCEPTION.
TYPE=Request
is something of a catch all declaration that will catch all exceptions
not
handled by other CFERROR instances and exceptions caused by other error
handlers.  TYPE=Exception allows you to define handlers on a per
exception
basis using the EXCEPTION attribute which can specify the name of a
single
exception type or the word Any which, like TYPE=Request, catches all
exceptions not handled by other instances of CFERROR.

If you specify EXCEPTION=Any, than a TYPE=Request is used only when
an
exception is generated in an error handler.  That is, the
EXCEPTION=Any
essentially relieves TYPE=Request of it's role as a catch-all.

EXCEPTION=Any will only catch those exceptions not otherwise handled
by
other EXCEPTION= definitions.  So, with the following code:

   CFERROR TYPE=EXCEPTION EXCEPTION=Any TEMPLATE=any.cfm
   CFERROR TYPE=EXCEPTION EXCEPTION=Expression
TEMPLATE=expression.cfm
   CFERROR TYPE=EXCEPTION EXCEPTION=MissingInclude
TEMPLATE=missingInclude.cfm

An Expression exception will be handled by expression.cfm but any OTHER
type
of exception will be handled by any.cfm.  Order of declaration does not
matter.

As I mentioned above, when you declare EXCEPTION=Any, TYPE=Request
is
only used to catch exceptions caused by an exception handler.  Even if
the
type of exception thrown by the handler has a defined handler (for
example,
if the Expression handler in the above code causes a MissingInclude
exception to be thrown) it will be handled by the Request handler, not
the
Exception handler.

Finally, I had suggested earlier in the thread that, instead of
maintaining
multiple displays to inform the user that an error occurred, you can
simply
define it once -- in the Request handler -- and just include the request
handler from your other handlers.  This is still valid with one caveat;
you
must put CFOUTPUT tags around any variables used in the request handler.

All exception handlers (including Request) can access several variables
from
the ERROR scope.  However, the request handler is limited in that it
cannot
make use of CFML so, to output the variables from the ERROR scope, you
simply escape them with pound signs, no CFOUTPUT needed.  But, if the
request handler is executed by way of inclusion from another exception
handler, it will be executing in the role of a non-request handler,
i.e.,
it needs CFOUTPUT.  Because the request handler simply ignores CFML
syntax,
you can wrap the variables with CFOUTPUT tags and everyone is happy.

So that's it.  I hope this is helpful.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL 

RE: MX Support # 44972

[John Wilker]

I have MX with Updater 2 on my server at home and it starts up after
reboot.

J.

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer
Founder/President IE CFUG
www.red-omega.com
 
Whatever is wrong it is better than a poke in the eye with a sharp
stick. Unless of course you just got poked in the eye with a sharp
stick.


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 1:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you reboot?  even when there has been no configurations added/changed
etc..?  

Neil

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: MX Support # 44972

[Robertson-Ravo, Neil (RX)]

Yep, I dont think its 100% across the board, buts obviously been flagged as
an issue : I am experiencing the problem on XP Pro at the momemt.

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 12:10
To: CF-Talk
Subject: RE: MX Support # 44972


I have MX with Updater 2 on my server at home and it starts up after
reboot.

J.

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer
Founder/President IE CFUG
www.red-omega.com
 
Whatever is wrong it is better than a poke in the eye with a sharp
stick. Unless of course you just got poked in the eye with a sharp
stick.


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 1:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you reboot?  even when there has been no configurations added/changed
etc..?  

Neil


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Semi-OT: NASD Tech Regulations...

[Andrew Golden]

I have a possible job coming up to replace a clients god-forsaken Goldmine 
system. They are concerned about the NASD regulations and claim that 
Goldmine is a NASD approved software package. I have searched and come up 
empty handed and they didn't seem too sure of what regulations/compliance 
issues there would be. Aside from the e-mail monitoring regulations I have 
not been able to find any details about NASD tech. regulations. Has anyone 
else ever had to deal with this before and if so, any pointers to 
information? Please reply off list so as not to clutter this resource. TIA!

Andrew Golden

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: MX Support # 44972

[Tony Weeg]

no problems whatsoever, windowsXP Pro, IIS5, CFMX, reboots
restarts, no matter what, 2 servers and 3 dev machines, all work
fine and the same, updater 2.

..tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 4:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically
following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you
reboot?  even when there has been no configurations added/changed etc..?


Neil

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: OT: AOL?

[Kris Pilles]

How can I test to ensure that my RDNS is working???

Do I have to have an entry for every domain in reverse DNS???

-Original Message-
From: Justin Greene [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 12:18 AM
To: CF-Talk
Subject: RE: OT: AOL?


AOL has their own internal RBL and uses their own rules.  If you are
sending alot of email across their network you should speak with them
about being whitelisted.  They may be enforcing rDNS, some anti-spam
efforts do this. They probably have other criteria as well.  Most of the
AOL delivery problems that we have had in the past were just related to
a few really slow relays that held the mail for a few hours before
spitting it back out.

Oh, if they are rejecting based on a non-matching rDNS, they should be
doing it at the connection and not even accepting the mail.  I would be
very surprised to hear that it was really being sent to /dev/null.

Justin

 -Original Message-
 From: samcfug [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 18, 2002 3:37 PM
 To: CF-Talk
 Subject: Re: OT: AOL?
 
 Ah, excuse me, the validate sender is a separate selection
 on the mail server.
 Sorry
 
 =
 Douglas White
 group Manager
 mailto:[EMAIL PROTECTED]
 http://www.samcfug.org
 =
 - Original Message -
 From: Jason Burnett [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, December 18, 2002 2:24 PM
 Subject: Re: OT: AOL?
 
 
 | I am not trying to start a flame war here, I just want to make sure 
 | noone gets the wrong impression and confirm or disprove
 what I thought
 | SMTP-AUTH was. As far as I can tell from RFC 2554 SMTP-AUTH really 
 | has nothing to do with checking reverse DNS, it is just an 
 | authentication method.
 |
 | on Wed Dec 18 samcfug spoke forth with the blessed manuscript
 |  I see your point, however, in my own case as a email
 hosting provider, I
 have
 |  the settings set to enable SMTP AUTH, which is what you
 mean by doing the
 |  reverse lookup.  I also make it a point to create the
 in-addr-arpa record
 in
 |  DNS that takes care of it.   That is just another task in 
 hosting email
 domains.
 |  In fact I use a script that takes care of all this when
 adding a new domain.
 |  If you were an ISP or hosting provider, you would be
 aware of the constant
 |  attacks by others trying to spoof one of your hosted
 addresses, including
 virus
 |  attacks such as the Klez Virus, which are all turned away
 at the server.
 |  That is my story, and I am sticking to it! :-)
 |
 |  =
 |  Douglas White
 |  group Manager
 |  mailto:[EMAIL PROTECTED]
 |  http://www.samcfug.org =
 |  - Original Message -
 |  From: Lee Fuller [EMAIL PROTECTED]
 |  To: CF-Talk [EMAIL PROTECTED]
 |  Sent: Wednesday, December 18, 2002 1:12 PM
 |  Subject: RE: OT: AOL?
 |
 |
 |  | Ya know.. Don't let them hit you with that.
 |  |
 |  | The problem is, new sysadmins tend to think that making
 changes is part
 |  | of their job.  We had a MAJOR battle with HUD since one
 of our customers
 |  | submits information to them via email regularly.
 Suddenly, they could
 |  | not contact HUD, due to a policy change by a new admin
 who decided that
 |  | if the email server didn't reverse to the same domain
 name, it was
 |  | most-likely SPAM.  The problem is (as you are most
 likely aware) that
 |  | with 1000's of domain names on a single mail server,
 how could you
 |  | POSSIBLY reverse to them?  Even if you added all the
 reverse names to
 |  | your DNS server manually, it would never answer with
 the right one
 |  | first.. So it's not logical.
 |  |
 |  | We have to force them to understand that THEY are not
 the ONLY ISP on
 |  | the planet... and that making willy-nilly admin
 decisions effects
 |  | millions.  If we fight back, they will change the policy.
 |  |
 |  | Just my .02...
 |  |
 |  |
 |  |
 |  | | -Original Message-
 |  | | From: Kris Pilles [mailto:[EMAIL PROTECTED]]
 |  | | Sent: Wednesday, December 18, 2002 11:05 AM
 |  | | To: CF-Talk
 |  | | Subject: RE: OT: AOL?
 |  | |
 |  | |
 |  | | Aol says my reverse DNS is not up But everything on my 
 |  | | server appears to be working fine I guess its my fault 
 |  | | after all lol
 |  | |
 |  | | -Original Message-
 |  | | From: Bud [mailto:[EMAIL PROTECTED]]
 |  | | Sent: Wednesday, December 18, 2002 1:44 PM
 |  | | To: CF-Talk
 |  | | Subject: RE: OT: AOL?
 |  | |
 |  | |
 |  | | On 12/18/02, Kris Pilles penned:
 |  | | No good This sucks... MY clients are starting to
 notice this
 |  | | too.  Weird thing is the mail just disappears... No
 |  | | bounce back or
 |  | | anything like that...
 |  | |
 |  | | I occasionally have similar problems. I ALWAYS use them as an 
 |  | | opportunity to point out to my client that they are
 LIKELY losing
 |  | | other e-mails, some which may be 

Re: MX Support # 44972

[James Blaha]

Ola All:
There is a know bug with this and a work around configuration, search 
the Macromedia Online Forums it was posted about 4 months ago. If you 
cant find it email me personally I'll see if I can dig it up.

Regards,
James Blaha

Robertson-Ravo, Neil (RX) wrote:

Yep, I dont think its 100% across the board, buts obviously been flagged as
an issue : I am experiencing the problem on XP Pro at the momemt.

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 12:10
To: CF-Talk
Subject: RE: MX Support # 44972


I have MX with Updater 2 on my server at home and it starts up after
reboot.

J.

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer
Founder/President IE CFUG
www.red-omega.com
 
Whatever is wrong it is better than a poke in the eye with a sharp
stick. Unless of course you just got poked in the eye with a sharp
stick.


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 1:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you reboot?  even when there has been no configurations added/changed
etc..?  

Neil



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: MX Support # 44972

[Robertson-Ravo, Neil (RX)]

Yep, as I said its obvisously not 100% across the board, but it is severe
enough to be flagged to be fixed/researched.

One question : Are your MX installs all on C:\  ?

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 13:58
To: CF-Talk
Subject: RE: MX Support # 44972


no problems whatsoever, windowsXP Pro, IIS5, CFMX, reboots
restarts, no matter what, 2 servers and 3 dev machines, all work
fine and the same, updater 2.

.tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 4:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically
following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you
reboot?  even when there has been no configurations added/changed etc..?


Neil


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Page Breaks for Printing

[Chad]

Has anyone figured out how to make page breaks for printing?

I.E. have the user click one button to print all of the new orders.
Each order on a separate piece of 8.5x11 paper.

Javascript?  Generate a PDF?

Thanks!

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: MX Support # 44972

[Robertson-Ravo, Neil (RX)]

Post it here, this is where it would benefit.

-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:03
To: CF-Talk
Subject: Re: MX Support # 44972


Ola All:
There is a know bug with this and a work around configuration, search 
the Macromedia Online Forums it was posted about 4 months ago. If you 
cant find it email me personally I'll see if I can dig it up.

Regards,
James Blaha

Robertson-Ravo, Neil (RX) wrote:

Yep, I dont think its 100% across the board, buts obviously been flagged as
an issue : I am experiencing the problem on XP Pro at the momemt.

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 12:10
To: CF-Talk
Subject: RE: MX Support # 44972


I have MX with Updater 2 on my server at home and it starts up after
reboot.

J.

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer
Founder/President IE CFUG
www.red-omega.com
 
Whatever is wrong it is better than a poke in the eye with a sharp
stick. Unless of course you just got poked in the eye with a sharp
stick.


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 1:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you reboot?  even when there has been no configurations added/changed
etc..?  

Neil




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

RE: Page Breaks for Printing

[Timothy Heald]

CSS.  Think it may be IE only.  Look at these properties:

page-break-after
page-break-before
page-break-inside

You can then set up divs or p blocks that will throw a page break right where you 
want it.  We did this with some success for printing out course certificates and stuff 
before.
Tim

-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:03 AM
To: CF-Talk
Subject: Page Breaks for Printing


Has anyone figured out how to make page breaks for printing?

I.E. have the user click one button to print all of the new orders.
Each order on a separate piece of 8.5x11 paper.

Javascript?  Generate a PDF?

Thanks!


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Page Breaks for Printing

[Jason Lees (National Express)]

We use page breaks, and its a simple tag extention of the classic paragraph
Tag

p STYLE=page-break-before: always

The Complication is deciding on the location to place the Tag.

Jason Lees
Development Team Leader
National Express Coaches Ltd.



-Original Message-
From: Chad [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:03
To: CF-Talk
Subject: Page Breaks for Printing


Has anyone figured out how to make page breaks for printing?

I.E. have the user click one button to print all of the new orders.
Each order on a separate piece of 8.5x11 paper.

Javascript?  Generate a PDF?

Thanks!


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: Page Breaks for Printing

[Pete Ruckelshaus]

CSS holds the answer.

style type=text/css
BR.pageEnd{page-break-after: always;}
/style
.
.
.
This line should be above the break
br class=pageEnd
This line should be after the page break.

This only works in CSS2 compliant browsers.

Hope this helps,

Pete

- Original Message -
From: Chad [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 9:03 AM
Subject: Page Breaks for Printing


 Has anyone figured out how to make page breaks for printing?

 I.E. have the user click one button to print all of the new orders.
 Each order on a separate piece of 8.5x11 paper.

 Javascript?  Generate a PDF?

 Thanks!

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: Page Breaks for Printing

[Chad]

Oh cool.. thanks... I have control of what browser the user has so this
should work!



 -Original Message-
 From: Timothy Heald [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, December 19, 2002 9:08 AM
 To: CF-Talk
 Subject: RE: Page Breaks for Printing
 
 CSS.  Think it may be IE only.  Look at these properties:
 
 page-break-after
 page-break-before
 page-break-inside
 
 You can then set up divs or p blocks that will throw a page break
right
 where you want it.  We did this with some success for printing out
course
 certificates and stuff before.
 Tim
 
 -Original Message-
 From: Chad [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, December 19, 2002 9:03 AM
 To: CF-Talk
 Subject: Page Breaks for Printing
 
 
 Has anyone figured out how to make page breaks for printing?
 
 I.E. have the user click one button to print all of the new orders.
 Each order on a separate piece of 8.5x11 paper.
 
 Javascript?  Generate a PDF?
 
 Thanks!
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: MX Support # 44972

[Tony Weeg]

none of my mx installs are on c:\ they are all on
other drives, I like to keep c:\ for the OS and let
all apps/servers/programs run on d:\ e:\ etc...

..tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 9:00 AM
To: CF-Talk
Subject: RE: MX Support # 44972


Yep, as I said its obvisously not 100% across the board, but it is
severe
enough to be flagged to be fixed/researched.

One question : Are your MX installs all on C:\  ?

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 13:58
To: CF-Talk
Subject: RE: MX Support # 44972


no problems whatsoever, windowsXP Pro, IIS5, CFMX, reboots
restarts, no matter what, 2 servers and 3 dev machines, all work
fine and the same, updater 2.

tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 4:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically
following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you
reboot?  even when there has been no configurations added/changed etc..?


Neil



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: MX Support # 44972

[Christine Lawson]

Hi Neil,
It happens on my machine. I suspect it's been something that occurs with those of us 
who have done multiple installs - I could be wrong but I know you and I have! I posted 
a workaround that I'm using to the list a while ago:

Set the cfmx service to be dependent on another service, so it starts later in the 
process.

Add a string value named DependOnService with the value W3SVC under:
HKLM\SYSTEM\CurrentControlSet\Services\ColdFusion MX Application Server\

This will cause CFMX to start after IIS.

Hope that Helps!
Christine



-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:03 AM
To: CF-Talk
Subject: RE: MX Support # 44972


Post it here, this is where it would benefit.

-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:03
To: CF-Talk
Subject: Re: MX Support # 44972


Ola All:
There is a know bug with this and a work around configuration, search 
the Macromedia Online Forums it was posted about 4 months ago. If you 
cant find it email me personally I'll see if I can dig it up.

Regards,
James Blaha

Robertson-Ravo, Neil (RX) wrote:

Yep, I dont think its 100% across the board, buts obviously been flagged as
an issue : I am experiencing the problem on XP Pro at the momemt.

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 12:10
To: CF-Talk
Subject: RE: MX Support # 44972


I have MX with Updater 2 on my server at home and it starts up after
reboot.

J.

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer
Founder/President IE CFUG
www.red-omega.com
 
Whatever is wrong it is better than a poke in the eye with a sharp
stick. Unless of course you just got poked in the eye with a sharp
stick.


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 1:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you reboot?  even when there has been no configurations added/changed
etc..?  

Neil





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: Page Breaks for Printing

[Jeffry Houser]

  This might be 
useful. 
http://www.cfconf.org/cfun-02/talks/DynamicallyGeneratingPDF_files/sld003.cfm
  Generating PDFs is also a valid option.

  I've heard that giving the HTML file with a .doc extension instead of 
html will open it in word, which will render the HTML as a document with 
page breaks, but I have never tried this on my own.

At 09:03 AM 12/19/2002 -0500, you wrote:
Has anyone figured out how to make page breaks for printing?

I.E. have the user click one button to print all of the new orders.
Each order on a separate piece of 8.5x11 paper.

Javascript?  Generate a PDF?

Thanks!


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Requirements gathering for the full lifecycle development process

[Timothy Heald]

Hi,
Wondering if anyone has any good resources for following the full lifecycle 
development process? Documents, forms things of that nature.  I usually either fly by 
the seat of my pants, or follow FLiP procedures, but now that I am at State I am 
required to provide far more documentation for all applications.

I am looking for things like functional requirements, requirements, gnatt 
information.  Also opinions on processes and methodologies other than Fusebox (not 
allowed to do the FLiP thing, even though it's being written in FB3).  Any help would 
be appreciated, as would opinions :)

tia

Timothy Heald
Assistant Webmaster
Overseas Security Advisory Council
U.S. Department of State 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: How to do this without the subselect?

[Rick Faircloth]

Hi, Zac.

I played around a bit with the left outer join before mailing to the list,
but couldn't work out the syntax for this query.

In the original message I did leave out a line which complicates the
query.  The original query with the subselect looked like the one below.
The part about #MultipleWaivers[CurrentRow][1]# is there because I'm
looping the query through the names of Utility Companies.

I tried some left outer join solutions, but nothing was working.
Can you show me how you would set up the code with a left outer join?
Since the where statement is taken by the #MultipleWaivers... line,
it doesn't leave room for another where statement such as
where UW.ClientID is NULL...

Thanks for your help.

Rick


 CFQUERY Name=GetWaivers Datasource=#DSN#

  Select UW.UtilityWaiverID
 from utilitywaivers UW
   where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
  and Month(UW.IssueDate) = #Form.Month#
  and Year(UW.IssueDate) = #Form.Year#
  and UW.ClientID not in
(Select RW.ClientID from RentalWaivers RW
 where Month(RW.RentalWaiverDate) = #Form.Month#
and Year(RW.RentalWaiverDate) = #Form.Year#)

 /CFQUERY



-Original Message-
From: Zac Spitzer [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 4:46 AM
To: CF-Talk
Subject: Re: How to do this without the subselect?


Rick Faircloth wrote:
 Hi, all.

 How can I get the same results as this query with using the subselect?

 CFQUERY Name=GetWaivers Datasource=#DSN#

  Select UW.UtilityWaiverID
 from utilitywaivers UW
   where Month(UW.IssueDate) = #Form.Month#
  and Year(UW.IssueDate) = #Form.Year#
  and UW.ClientID not in
(Select RW.ClientID from RentalWaivers RW
 where Month(RW.RentalWaiverDate) = #Form.Month#
and Year(RW.RentalWaiverDate) = #Form.Year#)

 /CFQUERY

 (I'll be s glad when they get subselects in mySQL 4.2!)

do a left outer join on RentalWaivers in the query and then do a check
that where UW.ClientID is null (if, this is standard perfomance
improvement anyway as it uses a index...)

not in is actually a real bad performance killer... this technique is
found in most good oracle books... should work for mysql but i don't know

z


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: MX Support # 44972

[Robertson-Ravo, Neil (RX)]

:-)  wahoo, I will have a look



-Original Message-
From: Christine Lawson [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:16
To: CF-Talk
Subject: RE: MX Support # 44972


Hi Neil,
It happens on my machine. I suspect it's been something that occurs with
those of us who have done multiple installs - I could be wrong but I know
you and I have! I posted a workaround that I'm using to the list a while
ago:

Set the cfmx service to be dependent on another service, so it starts later
in the process.

Add a string value named DependOnService with the value W3SVC under:
HKLM\SYSTEM\CurrentControlSet\Services\ColdFusion MX Application Server\

This will cause CFMX to start after IIS.

Hope that Helps!
Christine



-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:03 AM
To: CF-Talk
Subject: RE: MX Support # 44972


Post it here, this is where it would benefit.

-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:03
To: CF-Talk
Subject: Re: MX Support # 44972


Ola All:
There is a know bug with this and a work around configuration, search 
the Macromedia Online Forums it was posted about 4 months ago. If you 
cant find it email me personally I'll see if I can dig it up.

Regards,
James Blaha

Robertson-Ravo, Neil (RX) wrote:

Yep, I dont think its 100% across the board, buts obviously been flagged as
an issue : I am experiencing the problem on XP Pro at the momemt.

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 12:10
To: CF-Talk
Subject: RE: MX Support # 44972


I have MX with Updater 2 on my server at home and it starts up after
reboot.

J.

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer
Founder/President IE CFUG
www.red-omega.com
 
Whatever is wrong it is better than a poke in the eye with a sharp
stick. Unless of course you just got poked in the eye with a sharp
stick.


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 1:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you reboot?  even when there has been no configurations added/changed
etc..?  

Neil






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Page Breaks for Printing

[Jochem van Dieten]

Quoting Chad [EMAIL PROTECTED]:
 
 Has anyone figured out how to make page breaks for printing?

http://www.w3.org/TR/REC-CSS2/page.html

Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: How to do this without the subselect?

[Jochem van Dieten]

Quoting Rick Faircloth [EMAIL PROTECTED]:
 
 Since the where statement is taken by the #MultipleWaivers... line,
 it doesn't leave room for another where statement such as
 where UW.ClientID is NULL...

Shouldn't it be RW.ClientID IS NULL.

Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Updaters...Culmulitive?

[Robertson-Ravo, Neil (RX)]

Are they?
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: OT: AOL?

[Len Conrad]

How can I test to ensure that my RDNS is working???

dig -x ip.ad.re.ss

dig for win32 can be had at ftp.isc.org.

or free registration to get to this page:

http://preview.samspade.org/t/

or:

http://www.dnsstuff.com/

Do I have to have an entry for every domain in reverse DNS???

The critical ones are any ip's that are SMTP clients sending mail to other 
mail servers.  Each sending ip should have matching PTR and A records.

Of course, the reverse zone delegation must be done and the delegated NS 
responding.

For all CF or web apps that send mail:

1. the envelope @sender.domain must have A and/or MX records.

2. The MX for @sender.domain must accept mail for [EMAIL PROTECTED]

That is, in your CF apps that send mail (and that you want to give the best 
chance of being delivered), just don't invent any old 
[EMAIL PROTECTED]  You will have no success with MX's that do sender 
address verification or DNS validations of @sender.domain.

Len

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: Updaters...Culmulitive?

[Jochem van Dieten]

Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]:

 Are they?

Release notes :-)

Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: Updaters...Culmulitive?

[Stephen Moretti]

- Original Message - 
From: Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 2:26 PM
Subject: Updaters...Culmulitive?


 Are they?


Yes.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Please help me achieve this with CF and Javascrip please

[Ian Vaughan]

Hi Neil

I e-mailed a question to you at the start of December.

What I was and still am trying to achieve was creating related selects
generated from one database table and you provided me with some code.

I am getting somewhere with this now and there is only one small part that
needs to be resolved (javascript problem) before my deadline tommorrow for
this to work correctly, and I am contacting you for your expert opinion with
the hope of a possible solution please.

Using the code below the first select box is being populated from the
database as it should, however when I select an option from this list the
second select does not list the related items and there is a javascript
error

'ChapterArray1' is undefined.

Can you see from my code where this may be going wrong??


Ian


!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN

html
head
 titleUntitled/title
/head

body

!--- Select the ATA_Chapter, ATA_Section and title_Codes. ---
CFQUERY name=query1 datasource=intranetv8
SELECT
catno, category, parent_level from category_menu
where parent_level = 0
ORDER BY category

/CFQUERY

CFQUERY name=query2 datasource=intranetv8
SELECT
catno, category, parent_level from category_menu
where catno = parent_level
ORDER BY category

/CFQUERY

!--- Select all the sub codes. ---

script language = JavaScript
!--
// For each chapter, create an array to hold the sections.
// Each chapter array will be identified by the ATA_Chapter
cfoutput query=query2 group=category
// Create the array
ChapterArray#category# = new Array();
ChapterArrayVal#catno# = new Array();
cfset i = 0
// Populate the array
cfoutput
cfset i = i + 1
ChapterArray#catno#[#i#] = #category#;
ChapterArrayVal#catno#[#i#] = #parent_level# #category#;
/cfoutput
/cfoutput


// Function to populate the ATA_Sub_Codes for the ATA_Code selected
function PopulateATASubCode() {
// Only process the function if the first item is not selected.
var indx = document.InsertForm.ATACode.selectedIndex;
if (indx != 0) {
// Find the Chapter
var ThisChapter = document.InsertForm.ATACode[indx].value;
// Set the length of the ATA_Sub_Codes drop down equal to the length of the
Chapter's array
var len;
len = eval(ChapterArray + ThisChapter + .length);
document.InsertForm.ATA_SubCode.length = len;
// Put 'Select' as the first option in the SubCode drop-down
document.InsertForm.ATA_SubCode[0].value = ;
document.InsertForm.ATA_SubCode[0].text = Select Sub Category;
document.InsertForm.ATA_SubCode[0].selected = true;
// Loop through the chapter's array and populate the SubCode drop down.
for (i=1; ilen; i++) {
document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter +
);
document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter
+ );
}
}
}
//--
/script

html
head
titleRequirements Database Add Requirement/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body
form action=# method=POST name=InsertForm id=InsertForm
table
tr
td select name=ATACode onChange=PopulateATASubCode();
option value=0Select ATA Code cfoutput query=query1 group=category
option value=#catno##Category# #Category# /cfoutput
/select
select name=ATA_SubCode size=1
option value=0Select ATA Sub Code
/select/td
/tr
/table

/body
/html

  - Original Message -
  From: Thomas Hoheneder
  To: Ian Vaughan
  Sent: Friday, November 01, 2002 6:27 PM
  Subject: Re: Advanced Javascript and Forms ???


  Hello Ian,

  oh... I have seen that the link to earthweb.com was your own discovery ;-)
  so you might know the example ;-)) [LOL]

  The fine aspect of this algorithm is that the function bCascadeDrop()
needs not to be updated any time (when just adding further selects and
entries within them).
  Only a new select tag and the appropriate Array elements need to be
added.

  Greetings from
  Thomas
- Original Message -
From: Ian Vaughan
To: [EMAIL PROTECTED]
Sent: Friday, November 01, 2002 3:58 PM
Subject: Advanced Javascript and Forms ???


Hi Thomas

I have been reading your postings on the javascript newsgroup and have
been impressed with your knowledge with the language, and would be grateful
if someone of your experience and caliber in javascript will be able to
assist me in this problem I am having please.

I just have a quick query for you please, I have been trying to get my
head around this week, but am still having problems, I would be grateful if
you could help me out please.

In the script below I am trying to add another select box based on the
value chosen from the second select box, so basically a third select box . I
know I am going to perhaps need a new onchange value on the second select ?
but where do the arrays need to be specified etc

I would appreciate a lead on this please

Thankyou
Ian


SCRIPT LANGUAGE=JavaScript


!-- Begin
var minutesArray =  new Array(('Select Sub Category','',true,true),
('Management Team'),
('Information Technology Steering Group'),

RE: Updaters...Culmulitive?

[Robertson-Ravo, Neil (RX)]

what?! and read something without just clicking OK I think not my man...

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:37
To: CF-Talk
Subject: Re: Updaters...Culmulitive?


Quoting Robertson-Ravo, Neil (RX) [EMAIL PROTECTED]:

 Are they?

Release notes :-)

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: Please help me achieve this with CF and Javascrip please

[Robertson-Ravo, Neil (RX)]

which Neil?!

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:42
To: CF-Talk
Subject: Re: Please help me achieve this with CF and Javascrip please


Hi Neil

I e-mailed a question to you at the start of December.

What I was and still am trying to achieve was creating related selects
generated from one database table and you provided me with some code.

I am getting somewhere with this now and there is only one small part that
needs to be resolved (javascript problem) before my deadline tommorrow for
this to work correctly, and I am contacting you for your expert opinion with
the hope of a possible solution please.

Using the code below the first select box is being populated from the
database as it should, however when I select an option from this list the
second select does not list the related items and there is a javascript
error

'ChapterArray1' is undefined.

Can you see from my code where this may be going wrong??


Ian


!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN

html
head
 titleUntitled/title
/head

body

!--- Select the ATA_Chapter, ATA_Section and title_Codes. ---
CFQUERY name=query1 datasource=intranetv8
SELECT
catno, category, parent_level from category_menu
where parent_level = 0
ORDER BY category

/CFQUERY

CFQUERY name=query2 datasource=intranetv8
SELECT
catno, category, parent_level from category_menu
where catno = parent_level
ORDER BY category

/CFQUERY

!--- Select all the sub codes. ---

script language = JavaScript
!--
// For each chapter, create an array to hold the sections.
// Each chapter array will be identified by the ATA_Chapter
cfoutput query=query2 group=category
// Create the array
ChapterArray#category# = new Array();
ChapterArrayVal#catno# = new Array();
cfset i = 0
// Populate the array
cfoutput
cfset i = i + 1
ChapterArray#catno#[#i#] = #category#;
ChapterArrayVal#catno#[#i#] = #parent_level# #category#;
/cfoutput
/cfoutput


// Function to populate the ATA_Sub_Codes for the ATA_Code selected
function PopulateATASubCode() {
// Only process the function if the first item is not selected.
var indx = document.InsertForm.ATACode.selectedIndex;
if (indx != 0) {
// Find the Chapter
var ThisChapter = document.InsertForm.ATACode[indx].value;
// Set the length of the ATA_Sub_Codes drop down equal to the length of the
Chapter's array
var len;
len = eval(ChapterArray + ThisChapter + .length);
document.InsertForm.ATA_SubCode.length = len;
// Put 'Select' as the first option in the SubCode drop-down
document.InsertForm.ATA_SubCode[0].value = ;
document.InsertForm.ATA_SubCode[0].text = Select Sub Category;
document.InsertForm.ATA_SubCode[0].selected = true;
// Loop through the chapter's array and populate the SubCode drop down.
for (i=1; ilen; i++) {
document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter +
);
document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal + ThisChapter
+ );
}
}
}
//--
/script

html
head
titleRequirements Database Add Requirement/title
meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
/head
body
form action=# method=POST name=InsertForm id=InsertForm
table
tr
td select name=ATACode onChange=PopulateATASubCode();
option value=0Select ATA Code cfoutput query=query1 group=category
option value=#catno##Category# #Category# /cfoutput
/select
select name=ATA_SubCode size=1
option value=0Select ATA Sub Code
/select/td
/tr
/table

/body
/html

  - Original Message -
  From: Thomas Hoheneder
  To: Ian Vaughan
  Sent: Friday, November 01, 2002 6:27 PM
  Subject: Re: Advanced Javascript and Forms ???


  Hello Ian,

  oh... I have seen that the link to earthweb.com was your own discovery ;-)
  so you might know the example ;-)) [LOL]

  The fine aspect of this algorithm is that the function bCascadeDrop()
needs not to be updated any time (when just adding further selects and
entries within them).
  Only a new select tag and the appropriate Array elements need to be
added.

  Greetings from
  Thomas
- Original Message -
From: Ian Vaughan
To: [EMAIL PROTECTED]
Sent: Friday, November 01, 2002 3:58 PM
Subject: Advanced Javascript and Forms ???


Hi Thomas

I have been reading your postings on the javascript newsgroup and have
been impressed with your knowledge with the language, and would be grateful
if someone of your experience and caliber in javascript will be able to
assist me in this problem I am having please.

I just have a quick query for you please, I have been trying to get my
head around this week, but am still having problems, I would be grateful if
you could help me out please.

In the script below I am trying to add another select box based on the
value chosen from the second select box, so basically a third select box . I
know I am going to perhaps need a new onchange value on the second select ?
but where do the arrays need to be specified etc

I would appreciate a lead on this please

Thankyou
  

Re: Please help me achieve this with CF and Javascrip please

[Ian Vaughan]

Sorry guys

Ignore that last post.. sent it to the wrong address

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: MX Support # 44972

[James Blaha]

All:

Permanent fix would be to setup CFMX as a dependency on your web server 
service. I think someone just posting on this in regards to IIS. MX was 
such a headache we decided to stick with 5 for our production 
environment there are way to many little bugs out there in MX. Plus 
there are internal issues within JRUN but that's a whole another ball of 
wax.

http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143threadid=451892highlight_key=ykeyword1=MXkeyword2=SunONE

Hope this help!

Regards,

James Blaha

AKA: A almost converted MX enthusiast NOT

The label on the box should say migrations may cause loss of hair. :-)


Robertson-Ravo, Neil (RX) wrote:

Post it here, this is where it would benefit.

-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:03
To: CF-Talk
Subject: Re: MX Support # 44972


Ola All:
There is a know bug with this and a work around configuration, search 
the Macromedia Online Forums it was posted about 4 months ago. If you 
cant find it email me personally I'll see if I can dig it up.

Regards,
James Blaha

Robertson-Ravo, Neil (RX) wrote:

  

Yep, I dont think its 100% across the board, buts obviously been flagged as
an issue : I am experiencing the problem on XP Pro at the momemt.

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 12:10
To: CF-Talk
Subject: RE: MX Support # 44972


I have MX with Updater 2 on my server at home and it starts up after
reboot.

J.

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer
Founder/President IE CFUG
www.red-omega.com

Whatever is wrong it is better than a poke in the eye with a sharp
stick. Unless of course you just got poked in the eye with a sharp
stick.


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 1:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you reboot?  even when there has been no configurations added/changed
etc..?  

Neil







~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: Please help me achieve this with CF and Javascrip please

[Ben Doom]

Without digging too deeply, I notice you refer to ChapterArray#category# and
later ChapterArray#catno# -- I'm betting that the category and catno aren't
the same for a given row of your query, else you wouldn't have both columns.
I bet that's giving you your error -- or at least would cause another later
on.


  --Ben Doom
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: Ian Vaughan [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 9:42 AM
: To: CF-Talk
: Subject: Re: Please help me achieve this with CF and Javascrip please
:
:
: Hi Neil
:
: I e-mailed a question to you at the start of December.
:
: What I was and still am trying to achieve was creating related selects
: generated from one database table and you provided me with some code.
:
: I am getting somewhere with this now and there is only one small part that
: needs to be resolved (javascript problem) before my deadline tommorrow for
: this to work correctly, and I am contacting you for your expert
: opinion with
: the hope of a possible solution please.
:
: Using the code below the first select box is being populated from the
: database as it should, however when I select an option from this list the
: second select does not list the related items and there is a javascript
: error
:
: 'ChapterArray1' is undefined.
:
: Can you see from my code where this may be going wrong??
:
:
: Ian
:
:
: !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN
:
: html
: head
:  titleUntitled/title
: /head
:
: body
:
: !--- Select the ATA_Chapter, ATA_Section and title_Codes. ---
: CFQUERY name=query1 datasource=intranetv8
: SELECT
: catno, category, parent_level from category_menu
: where parent_level = 0
: ORDER BY category
:
: /CFQUERY
:
: CFQUERY name=query2 datasource=intranetv8
: SELECT
: catno, category, parent_level from category_menu
: where catno = parent_level
: ORDER BY category
:
: /CFQUERY
:
: !--- Select all the sub codes. ---
:
: script language = JavaScript
: !--
: // For each chapter, create an array to hold the sections.
: // Each chapter array will be identified by the ATA_Chapter
: cfoutput query=query2 group=category
: // Create the array
: ChapterArray#category# = new Array();
: ChapterArrayVal#catno# = new Array();
: cfset i = 0
: // Populate the array
: cfoutput
: cfset i = i + 1
: ChapterArray#catno#[#i#] = #category#;
: ChapterArrayVal#catno#[#i#] = #parent_level# #category#;
: /cfoutput
: /cfoutput
:
:
: // Function to populate the ATA_Sub_Codes for the ATA_Code selected
: function PopulateATASubCode() {
: // Only process the function if the first item is not selected.
: var indx = document.InsertForm.ATACode.selectedIndex;
: if (indx != 0) {
: // Find the Chapter
: var ThisChapter = document.InsertForm.ATACode[indx].value;
: // Set the length of the ATA_Sub_Codes drop down equal to the
: length of the
: Chapter's array
: var len;
: len = eval(ChapterArray + ThisChapter + .length);
: document.InsertForm.ATA_SubCode.length = len;
: // Put 'Select' as the first option in the SubCode drop-down
: document.InsertForm.ATA_SubCode[0].value = ;
: document.InsertForm.ATA_SubCode[0].text = Select Sub Category;
: document.InsertForm.ATA_SubCode[0].selected = true;
: // Loop through the chapter's array and populate the SubCode drop down.
: for (i=1; ilen; i++) {
: document.InsertForm.ATA_SubCode.value = eval(ChapterArray +
: ThisChapter +
: );
: document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal +
: ThisChapter
: + );
: }
: }
: }
: //--
: /script
:
: html
: head
: titleRequirements Database Add Requirement/title
: meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
: /head
: body
: form action=# method=POST name=InsertForm id=InsertForm
: table
: tr
: td select name=ATACode onChange=PopulateATASubCode();
: option value=0Select ATA Code cfoutput query=query1
: group=category
: option value=#catno##Category# #Category# /cfoutput
: /select
: select name=ATA_SubCode size=1
: option value=0Select ATA Sub Code
: /select/td
: /tr
: /table
:
: /body
: /html
:
:   - Original Message -
:   From: Thomas Hoheneder
:   To: Ian Vaughan
:   Sent: Friday, November 01, 2002 6:27 PM
:   Subject: Re: Advanced Javascript and Forms ???
:
:
:   Hello Ian,
:
:   oh... I have seen that the link to earthweb.com was your own
: discovery ;-)
:   so you might know the example ;-)) [LOL]
:
:   The fine aspect of this algorithm is that the function bCascadeDrop()
: needs not to be updated any time (when just adding further selects and
: entries within them).
:   Only a new select tag and the appropriate Array elements need to be
: added.
:
:   Greetings from
:   Thomas
: - Original Message -
: From: Ian Vaughan
: To: [EMAIL PROTECTED]
: Sent: Friday, November 01, 2002 3:58 PM
: Subject: Advanced Javascript and Forms ???
:
:
: Hi Thomas
:
: I have been reading your postings on the javascript newsgroup and have
: been impressed with your knowledge with 

RE: Please help me achieve this with CF and Javascrip please

[Kevin Gilchrist]

Do whichever Neil a favor and send the generated page source, makes it
easier to debug dynamically generated JavaScript.
;-)

-Original Message-
From: Ian Vaughan [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 9:47 AM
To: CF-Talk
Subject: Re: Please help me achieve this with CF and Javascrip please


Sorry guys

Ignore that last post.. sent it to the wrong address


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: Please help me achieve this with CF and Javascrip please

[Stephen Moretti]

Ian,

Did you have a look at the twoselectsrelated custom tag?

It might be a little out of date and may need tidying up a little, but that
will do exactly what you're attempting.

Hope this helps

Regards

Stephen
- Original Message -
From: Ian Vaughan [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, December 19, 2002 2:41 PM
Subject: Re: Please help me achieve this with CF and Javascrip please


 Hi Neil

 I e-mailed a question to you at the start of December.

 What I was and still am trying to achieve was creating related selects
 generated from one database table and you provided me with some code.

 I am getting somewhere with this now and there is only one small part that
 needs to be resolved (javascript problem) before my deadline tommorrow for
 this to work correctly, and I am contacting you for your expert opinion
with
 the hope of a possible solution please.

 Using the code below the first select box is being populated from the
 database as it should, however when I select an option from this list the
 second select does not list the related items and there is a javascript
 error

 'ChapterArray1' is undefined.

 Can you see from my code where this may be going wrong??


 Ian


 !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN

 html
 head
  titleUntitled/title
 /head

 body

 !--- Select the ATA_Chapter, ATA_Section and title_Codes. ---
 CFQUERY name=query1 datasource=intranetv8
 SELECT
 catno, category, parent_level from category_menu
 where parent_level = 0
 ORDER BY category

 /CFQUERY

 CFQUERY name=query2 datasource=intranetv8
 SELECT
 catno, category, parent_level from category_menu
 where catno = parent_level
 ORDER BY category

 /CFQUERY

 !--- Select all the sub codes. ---

 script language = JavaScript
 !--
 // For each chapter, create an array to hold the sections.
 // Each chapter array will be identified by the ATA_Chapter
 cfoutput query=query2 group=category
 // Create the array
 ChapterArray#category# = new Array();
 ChapterArrayVal#catno# = new Array();
 cfset i = 0
 // Populate the array
 cfoutput
 cfset i = i + 1
 ChapterArray#catno#[#i#] = #category#;
 ChapterArrayVal#catno#[#i#] = #parent_level# #category#;
 /cfoutput
 /cfoutput


 // Function to populate the ATA_Sub_Codes for the ATA_Code selected
 function PopulateATASubCode() {
 // Only process the function if the first item is not selected.
 var indx = document.InsertForm.ATACode.selectedIndex;
 if (indx != 0) {
 // Find the Chapter
 var ThisChapter = document.InsertForm.ATACode[indx].value;
 // Set the length of the ATA_Sub_Codes drop down equal to the length of
the
 Chapter's array
 var len;
 len = eval(ChapterArray + ThisChapter + .length);
 document.InsertForm.ATA_SubCode.length = len;
 // Put 'Select' as the first option in the SubCode drop-down
 document.InsertForm.ATA_SubCode[0].value = ;
 document.InsertForm.ATA_SubCode[0].text = Select Sub Category;
 document.InsertForm.ATA_SubCode[0].selected = true;
 // Loop through the chapter's array and populate the SubCode drop down.
 for (i=1; ilen; i++) {
 document.InsertForm.ATA_SubCode.value = eval(ChapterArray + ThisChapter
+
 );
 document.InsertForm.ATA_SubCode.text = eval(ChapterArrayVal +
ThisChapter
 + );
 }
 }
 }
 //--
 /script

 html
 head
 titleRequirements Database Add Requirement/title
 meta http-equiv=Content-Type content=text/html; charset=iso-8859-1
 /head
 body
 form action=# method=POST name=InsertForm id=InsertForm
 table
 tr
 td select name=ATACode onChange=PopulateATASubCode();
 option value=0Select ATA Code cfoutput query=query1
group=category
 option value=#catno##Category# #Category# /cfoutput
 /select
 select name=ATA_SubCode size=1
 option value=0Select ATA Sub Code
 /select/td
 /tr
 /table

 /body
 /html

   - Original Message -
   From: Thomas Hoheneder
   To: Ian Vaughan
   Sent: Friday, November 01, 2002 6:27 PM
   Subject: Re: Advanced Javascript and Forms ???


   Hello Ian,

   oh... I have seen that the link to earthweb.com was your own discovery
;-)
   so you might know the example ;-)) [LOL]

   The fine aspect of this algorithm is that the function bCascadeDrop()
 needs not to be updated any time (when just adding further selects and
 entries within them).
   Only a new select tag and the appropriate Array elements need to be
 added.

   Greetings from
   Thomas
 - Original Message -
 From: Ian Vaughan
 To: [EMAIL PROTECTED]
 Sent: Friday, November 01, 2002 3:58 PM
 Subject: Advanced Javascript and Forms ???


 Hi Thomas

 I have been reading your postings on the javascript newsgroup and have
 been impressed with your knowledge with the language, and would be
grateful
 if someone of your experience and caliber in javascript will be able to
 assist me in this problem I am having please.

 I just have a quick query for you please, I have been trying to get my
 head around this week, but am still having problems, I would be grateful
if
 you could help me 

Re: CFMX / JVM

[Samuel R. Neff]

I don't think there is an official recommendation.  I believe the IBM one 
is bundled with CFMX and many have reported problems with CFHTTP fixed only 
by installing a new JVM--the SUN one in particular.

I've read reports that the BEA JVM, JRockit, is a lot faster than IBM  SUN 
JVM.  Also, CFMX for J2EE is much faster than standalone CFMX (even CFMX 
for JRUN is faster than CFMX Enterprise which uses JRun).


At 09:19 AM 12/19/2002, you wrote:
What JVM do Macromedia recommend to use for performance etc...?  Is there
on?  What does everyone else use?

(that said, I still cannot get my ColdFusion MX server to start at boot
time!)

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: MX Support # 44972

[James Blaha]

Christine, 

I believe this is an internal JRUN issue with the service startup. Macromedia told be 
at one time months back to just not log into the server right away upon reboot that 
fixed the issue about 40% of the time. I personally removed all registry keys and even 
reformatted a server I know its not due to multiple installs. Your recommendation was 
right on the money though!

Regards,
James Blaha


Robertson-Ravo, Neil (RX) wrote:

:-)  wahoo, I will have a look



-Original Message-
From: Christine Lawson [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:16
To: CF-Talk
Subject: RE: MX Support # 44972


Hi Neil,
It happens on my machine. I suspect it's been something that occurs with
those of us who have done multiple installs - I could be wrong but I know
you and I have! I posted a workaround that I'm using to the list a while
ago:

Set the cfmx service to be dependent on another service, so it starts later
in the process.

Add a string value named DependOnService with the value W3SVC under:
HKLM\SYSTEM\CurrentControlSet\Services\ColdFusion MX Application Server\

This will cause CFMX to start after IIS.

Hope that Helps!
Christine



-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:03 AM
To: CF-Talk
Subject: RE: MX Support # 44972


Post it here, this is where it would benefit.

-Original Message-
From: James Blaha [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 14:03
To: CF-Talk
Subject: Re: MX Support # 44972


Ola All:
There is a know bug with this and a work around configuration, search 
the Macromedia Online Forums it was posted about 4 months ago. If you 
cant find it email me personally I'll see if I can dig it up.

Regards,
James Blaha

Robertson-Ravo, Neil (RX) wrote:

  

Yep, I dont think its 100% across the board, buts obviously been flagged as
an issue : I am experiencing the problem on XP Pro at the momemt.

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 19 December 2002 12:10
To: CF-Talk
Subject: RE: MX Support # 44972


I have MX with Updater 2 on my server at home and it starts up after
reboot.

J.

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer
Founder/President IE CFUG
www.red-omega.com

Whatever is wrong it is better than a poke in the eye with a sharp
stick. Unless of course you just got poked in the eye with a sharp
stick.


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 1:32 AM
To: CF-Talk
Subject: MX Support # 44972


This one is really getting me down.  Macromedia has identified issue
#44972
: The ColdFusion MX Application Server service does not start
automatically following a Windows startup or reboot.

There seems to be no fix with it in Updater 1 or 2, and at present is
preventing me installing it on a server due to it?

Has anyone else had this problem?  Has anyone got a workaround?  

It seems to work when you first install it, it just seems to fail when
you reboot?  even when there has been no configurations added/changed
etc..?  

Neil









~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

RE: cferror

[Rick Faircloth]

No problem, Tim.

Sometimes it's hard to keep up with these mailing list conversations!

Thanks for your help!

Rick


-Original Message-
From: Tim Laureska [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 6:27 AM
To: CF-Talk
Subject: RE: cferror


Rick... sorry I didn't respond sooner about your initial blank screen
. I think that was the same problemquestion

-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 2:04 AM
To: CF-Talk
Subject: RE: cferror

Thanks for the in-depth analysis, Mosh!

Concerning this comment:

 This is still valid with one caveat; you
  must put CFOUTPUT tags around any variables used in the request
handler.

I found that out when I followed your suggestion to CFINCLUDE
the user display page from within the admin diagnostic page.

I ended up putting this on the application.cfm:

CFERROR Type=Exception Template=error_admin.cfm
Exception=Any mailto=[EMAIL PROTECTED]

Then, from within the error_admin.cfm page, I put:

CFINCLUDE Template=error_user.cfm

I could send my mail using a CF_Dump var=#Error# custom tag to
send the error info to my email, and have the CFIncluded
error_user.cfm
page display the error info to the user.  (After putting the
CFOUTPUT's
around message for error variables.)

It's going to be great having these error messages show up in my email
when a user has a problem.  Now, I'll be able to call them right away,
if needed, instead of waiting until they get frustrated and have to call
me!

Thanks again!

Rick



-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 12:55 AM
To: CF-Talk
Subject: RE: cferror


Mosh Teitelbaum wrote:
 ... there's no reason why you can't specify multiple CFERROR
 TYPE=Exception tags as in:

 CFERROR TYPE=Request TEMPLATE=request_error.cfm
 CFERROR TYPE=Exception EXCEPTION=Database
TEMPLATE=db_exception.cfm
 CFERROR TYPE=Exception EXCEPTION=Application
TEMPLATE=app_exception.cfm

 I don't know what would happen though if you did the above and
 also included an EXCEPTION=All.  Would it catch everything,
 ignoring the other tags, or would it catch everything not
 specified in the other tags.  Order might matter in this case (as
 it does when declaring CFCATCH blocks).  Dunno... if I have some
 time tonight, I'll try to remember to test it out.

So I did some testing and, for those that are interested, what follows
is a
summary of the findings and some items to note:

ColdFusion lets you define multiple instances of the CFERROR tag.  The
two
attributes we're concerned with here are TYPE and EXCEPTION.
TYPE=Request
is something of a catch all declaration that will catch all exceptions
not
handled by other CFERROR instances and exceptions caused by other error
handlers.  TYPE=Exception allows you to define handlers on a per
exception
basis using the EXCEPTION attribute which can specify the name of a
single
exception type or the word Any which, like TYPE=Request, catches all
exceptions not handled by other instances of CFERROR.

If you specify EXCEPTION=Any, than a TYPE=Request is used only when
an
exception is generated in an error handler.  That is, the
EXCEPTION=Any
essentially relieves TYPE=Request of it's role as a catch-all.

EXCEPTION=Any will only catch those exceptions not otherwise handled
by
other EXCEPTION= definitions.  So, with the following code:

   CFERROR TYPE=EXCEPTION EXCEPTION=Any TEMPLATE=any.cfm
   CFERROR TYPE=EXCEPTION EXCEPTION=Expression
TEMPLATE=expression.cfm
   CFERROR TYPE=EXCEPTION EXCEPTION=MissingInclude
TEMPLATE=missingInclude.cfm

An Expression exception will be handled by expression.cfm but any OTHER
type
of exception will be handled by any.cfm.  Order of declaration does not
matter.

As I mentioned above, when you declare EXCEPTION=Any, TYPE=Request
is
only used to catch exceptions caused by an exception handler.  Even if
the
type of exception thrown by the handler has a defined handler (for
example,
if the Expression handler in the above code causes a MissingInclude
exception to be thrown) it will be handled by the Request handler, not
the
Exception handler.

Finally, I had suggested earlier in the thread that, instead of
maintaining
multiple displays to inform the user that an error occurred, you can
simply
define it once -- in the Request handler -- and just include the request
handler from your other handlers.  This is still valid with one caveat;
you
must put CFOUTPUT tags around any variables used in the request handler.

All exception handlers (including Request) can access several variables
from
the ERROR scope.  However, the request handler is limited in that it
cannot
make use of CFML so, to output the variables from the ERROR scope, you
simply escape them with pound signs, no CFOUTPUT needed.  But, if the
request handler is executed by way of inclusion from another exception
handler, it will be executing in the role of a non-request handler,
i.e.,
it 

RE: How to do this without the subselect?

[Rick Faircloth]

Hi, Jochem.

Shouldn't it be RW.ClientID IS NULL

Now, that's a good question.  I've always used subselects to get around
having to spend time with those unfriendly (at least to me!) joins.
I don't know enough about the fine points of joinery to answer that.

Suggestions on how to setup the code to accomplish what's below with a
subselect?

 CFQUERY Name=GetWaivers Datasource=#DSN#

  Select UW.UtilityWaiverID
 from utilitywaivers UW
   where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
  and Month(UW.IssueDate) = #Form.Month#
  and Year(UW.IssueDate) = #Form.Year#
  and UW.ClientID not in
(Select RW.ClientID from RentalWaivers RW
 where Month(RW.RentalWaiverDate) = #Form.Month#
and Year(RW.RentalWaiverDate) = #Form.Year#)

 /CFQUERY



Thanks,

Rick


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 9:29 AM
To: CF-Talk
Subject: RE: How to do this without the subselect?


Quoting Rick Faircloth [EMAIL PROTECTED]:

 Since the where statement is taken by the #MultipleWaivers... line,
 it doesn't leave room for another where statement such as
 where UW.ClientID is NULL...

Shouldn't it be RW.ClientID IS NULL.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

MX and Apache 2.0.43

[Haggerty, Mike]

I have installed updater 2 and am trying to get MX to work with Apache
2.0.43 on a Win2K box with no success. I don't have the error message in
front of me, something about requiring #some long number# and having #some
long number#, please contact the vendor for the appropriate version.

Anyone have MX running with Apache 2.0.43?

M

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: How to do this without the subselect?

[Jochem van Dieten]

Quoting Rick Faircloth [EMAIL PROTECTED]:
 
 Now, that's a good question.  I've always used subselects to get
 around having to spend time with those unfriendly (at least to me!)
 joins.

Then maybe MySQL isn't the database for you :)


   Select UW.UtilityWaiverID
  from utilitywaivers UW
where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
   and Month(UW.IssueDate) = #Form.Month#
   and Year(UW.IssueDate) = #Form.Year#
   and UW.ClientID not in
 (Select RW.ClientID from RentalWaivers RW
  where Month(RW.RentalWaiverDate) = #Form.Month#
 and Year(RW.RentalWaiverDate) = #Form.Year#)

I think it should be:

SELECT UW.UtilityWaiverID
FROM   utilitywaivers UW LEFT JOIN RentalWaivers RW
   ON (UW.ClientID = RW.ClientID
  AND Month(RW.RentalWaiverDate) = #Form.Month#
  AND Year(RW.RentalWaiverDate) = #Form.Year#
  )
WHERE  UW.UtilityCompanyID = #MultipleWaivers[CurrentRow][1]#
   AND Month(UW.IssueDate) = #Form.Month#
   AND Year(UW.IssueDate) = #Form.Year#
   AND RW.ClientID IS NULL

Don't forget to add the appropriate cfqueryparam tags.

Jochem
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: How to do this without the subselect?

[Stephen Moretti]

 Quoting Rick Faircloth [EMAIL PROTECTED]:
 
  Since the where statement is taken by the #MultipleWaivers... line,
  it doesn't leave room for another where statement such as
  where UW.ClientID is NULL...

 Shouldn't it be RW.ClientID IS NULL.

You're probably right

Two possibles...  (Neither tested, so expect typo's etc.)

One is :
SELECT UW.UtilityWaiverID
FROM utilitywaivers AS UW RIGHT JOIN RentalWaiver AS RW
 ON UW.ClientID = RW.ClientID
WHERE RW.ClientID IS NULL
AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
AND Month(UW.IssueDate) = #Form.Month#
AND Year(UW.IssueDate) = #Form.Year#
AND Month(RW.RentalWaiverDate) = #Form.Month#
AND Year(RW.RentalWaiverDate) = #Form.Year#)

The other is :
SELECT UW.UtilityWaiverID
FROM UtilityWaiver AS UW, RentalWaiver AS RW
WHERE UW.ClientID  RW.ClientID
AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
AND Month(UW.IssueDate) = #Form.Month#
AND Year(UW.IssueDate) = #Form.Year#
AND Month(RW.RentalWaiverDate) = #Form.Month#
AND Year(RW.RentalWaiverDate) = #Form.Year#)

I have a sneaky suspicious that the second query won't work, but give them a
go and let us know

Regards

Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

IIS or CFMX

[Steve]

Which is preferable to use with Coldfusion when running on Windoze box? I have 
ColdFusion MX installed as standalone, but judging from some comments I've seen 
over the last few days, others are using IIS to serve the pages.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: IIS or CFMX

[James Blaha]

Steve,

If your going to run MX, IIS would be your best bet with all the bugs it 
has Macromedia seems to be catering to IIS fixes first. Are you talking 
production or test? If your testing and its your local machine we run a 
CF5 shop but we test for MX so I run IIS locally for CF5 and use the MX 
standalone, I'm running dual web servers on my local machine.

Hope this helps,
James Blaha

Steve wrote:

Which is preferable to use with Coldfusion when running on Windoze box? I have 
ColdFusion MX installed as standalone, but judging from some comments I've seen 
over the last few days, others are using IIS to serve the pages.


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

RE: Updaters...Culmulitive?

[Aaron Johnson]

 what?! and read something without just clicking OK I think not my man...
 -- Yeah... actually just trying reading them online:
http://www.macromedia.com/support/coldfusion/releasenotes/mx/releasenotes_mx_updater.html

AJ

-- 
Aaron Johnson
http://cephas.net/blog/
[EMAIL PROTECTED]

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: How can I modify this query so mySQL will be happy?

[Matt Robertson]

Yes, I didn't figure DayName() would do much good without some
re-coding.  Good that you found DayofMonth().  Didn't know about that
one.  

--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com



-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, December 18, 2002 9:02 PM
To: CF-Talk
Subject: RE: How can I modify this query so mySQL will be happy?


Well that explains why the exact same query, minus the Day line,
works fine.  No Day() function...  Only problem with the DayName
function
(assuming it returns the Day of the Week name and not a number)
is that this function needs to return the day number in the month... 1
or
2...
not Monday, etc.

I found answer (after reading the docs!).  It was DayofMonth.  That
function returns a number of the month, which is what I needed.

Concerning your soapbox:

I agree.  The more versatile code is, the better.  I'm sure there are
cases when code that is completely optimized for a platform is required,
but I'd rather take a small hit in performance to avoid having to
rewrite
a bunch of code.  My current situation illustrates that.  I'm having to
tweak
code on all 197 pages of this business app to get everything to work.
:op

Thanks, Matt, and Ben for your help.

Rick



-Original Message-
From: Matt Robertson [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 11:36 PM
To: CF-Talk
Subject: RE: How can I modify this query so mySQL will be happy?


http://www.mysql.com/doc/en/Date_and_time_functions.html

They have a nice new web site, I see.  I like the new format.

mySQL has no DAY() function.  You can try using DayName() instead.  This
assumes AccountCreationDate is a valid mySQL date field.  And if you go
there it also makes your code platform-specific.  Again.

soapbox
This illustrates, IMHO, why you stay away from using anything that could
be platform-specific in your SQL (and most especially in your field
specs).  I've always treated the db as a file cabinet only.  Get files
from it.  Put files back; add new ones.  Nothing fancy.  Leave that to
whatever it is you use to massage the data.
/soapbox

You will hear vehement and learned arguments to the contrary that state
you should write code, SQL and db-level field constraints that are
optimal to the platform you are currently using, and rewrite it to a new
optimum if you change platforms.  I'll say no more than that in the
hopes of avoiding a jihad :).

--Matt Robertson--
MSB Designs, Inc.
http://mysecretbase.com



-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 18, 2002 7:41 PM
To: CF-Talk
Subject: How can I modify this query so mySQL will be happy?


This worked with MS Access, but I'm getting an error with this now...

CFQUERY Name=GetClients Datasource=#DSN#

Select ClientID from clients C

where Day(AccountCreationDate) = #Form.Day#
   and Month(AccountCreationDate) = #Form.Month#
   and Year(AccountCreationDate) = #Form.Year#

/CFQUERY

Here's the error:

[TCX][MyODBC]You have an error in your SQL syntax.
Check the manual that corresponds to your MySQL server version
for the right syntax to use near '(AccountCreationDate) = 18 and
Month(AccountCreationDa



The error occurred while processing an element with a general identifier
of
(CFQUERY),
occupying document position (34:218) to (34:263).

Thanks!

Rick





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: How can I modify this query so mySQL will be happy?

[S . Isaac Dealey]

There's also DateFormat(mydate,d) which returns the same value, but
DayOfMonth() makes a lot more sense when you're reading someone else's code.
;)

 Yes, I didn't figure DayName() would do much good without
 some
 re-coding.  Good that you found DayofMonth().  Didn't know
 about that
 one.

 --Matt Robertson--
 MSB Designs, Inc.
 http://mysecretbase.com



 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 18, 2002 9:02 PM
 To: CF-Talk
 Subject: RE: How can I modify this query so mySQL will be
 happy?


 Well that explains why the exact same query, minus the Day
 line,
 works fine.  No Day() function...  Only problem with the
 DayName
 function
 (assuming it returns the Day of the Week name and not a
 number)
 is that this function needs to return the day number in
 the month... 1
 or
 2...
 not Monday, etc.

 I found answer (after reading the docs!).  It was
 DayofMonth.  That
 function returns a number of the month, which is what I
 needed.

 Concerning your soapbox:

 I agree.  The more versatile code is, the better.  I'm
 sure there are
 cases when code that is completely optimized for a
 platform is required,
 but I'd rather take a small hit in performance to avoid
 having to
 rewrite
 a bunch of code.  My current situation illustrates that.
 I'm having to
 tweak
 code on all 197 pages of this business app to get
 everything to work.
 :op

 Thanks, Matt, and Ben for your help.

 Rick



 -Original Message-
 From: Matt Robertson [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 18, 2002 11:36 PM
 To: CF-Talk
 Subject: RE: How can I modify this query so mySQL will be
 happy?


 http://www.mysql.com/doc/en/Date_and_time_functions.html

 They have a nice new web site, I see.  I like the new
 format.

 mySQL has no DAY() function.  You can try using DayName()
 instead.  This
 assumes AccountCreationDate is a valid mySQL date field.
 And if you go
 there it also makes your code platform-specific.  Again.

 soapbox
 This illustrates, IMHO, why you stay away from using
 anything that could
 be platform-specific in your SQL (and most especially in
 your field
 specs).  I've always treated the db as a file cabinet
 only.  Get files
 from it.  Put files back; add new ones.  Nothing fancy.
 Leave that to
 whatever it is you use to massage the data.
 /soapbox

 You will hear vehement and learned arguments to the
 contrary that state
 you should write code, SQL and db-level field constraints
 that are
 optimal to the platform you are currently using, and
 rewrite it to a new
 optimum if you change platforms.  I'll say no more than
 that in the
 hopes of avoiding a jihad :).

 --Matt Robertson--
 MSB Designs, Inc.
 http://mysecretbase.com



 -Original Message-
 From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, December 18, 2002 7:41 PM
 To: CF-Talk
 Subject: How can I modify this query so mySQL will be
 happy?


 This worked with MS Access, but I'm getting an error with
 this now...

 CFQUERY Name=GetClients Datasource=#DSN#

 Select ClientID from clients C

 where Day(AccountCreationDate) = #Form.Day#
and Month(AccountCreationDate) = #Form.Month#
and Year(AccountCreationDate) = #Form.Year#

 /CFQUERY

 Here's the error:

 [TCX][MyODBC]You have an error in your SQL syntax.
 Check the manual that corresponds to your MySQL server
 version
 for the right syntax to use near '(AccountCreationDate) =
 18 and
 Month(AccountCreationDa



 The error occurred while processing an element with a
 general identifier
 of
 (CFQUERY),
 occupying document position (34:218) to (34:263).

 Thanks!

 Rick





 ~~
 ~~~|
 Archives:
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=4
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 This list and all House of Fusion resources hosted by
 CFHosting.com. The place for dependable ColdFusion
 Hosting.


s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: IIS or CFMX

[Stephen Moretti]

 Which is preferable to use with Coldfusion when running on Windoze box? I
have
 ColdFusion MX installed as standalone, but judging from some comments I've
seen
 over the last few days, others are using IIS to serve the pages.


I believe the notes say somewhere that the web server that comes as a part
of JRun and used for the standalone version of CFMX is not production
strength.

Nothing wrong with using the JRun server if all you're doing is developing
and its not a production server you're talking about.

Regards

Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Is there a Better Way to do this?

[Kelly Matthews]

Ok here is what i am doing and I am just trying to find out if 1. there is a 
better way and 2. if it can be done on the SQL side (as a stored proc) 
instaed of the CF side. Just not all that familiar with looping outside of 
CF.

ANyway I have one table that is a dictionary with about 1500 words. THen I 
have another table that has dreams people have entered. THe idea is to take 
the list of words and see if any of them show up in the dream and then 
display those words to the user. What I built works and it's actually pretty 
speedy, but the dictionary is very small right now and it may be closer to 
1 by the time we are done which is a MUCH larger list of words to loop 
through.

So right now I am doing a query to get the words
CFQUERY name=wordS
SELECT word
from dictionary
/CFQUERY

THen we grab a dream
CFQUERY name=dream
SELECT dream
from dreams
where dream_id = 3
/CFQUERY

Then I Loop through like so:
CFLOOP list=#valuelist(words.word)# delimiters=, index=theword
Then I check to see if the dream contains the word.
CFIF dream.dream contains  #theword#  OR dream.dream contains  
#theword#s
Then I grab the definition if it found that word.
CFQUERY name=getdef
SELECT definition from dictionary
where word = '#theword#'
/CFQUERY
Then I display it #theword#BR#getdef.definition#P
/CFIF
/CFLOOP

This words fine and with a dream thats a few thousand words it completes in 
a few seconds.  I just wonder if there is a faster or better way to do this 
so down the road we don't run into problems as the word list grows. 
THoughts?




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: Setting the focus to form select box item.

[Scott Brady]

SelectedIndex is a read-only property in all browsers except Navigator 
3 (O'Reilly's JavaScript: The Definitive Guide).

Yeah, well that's what I get for writing out the code without testing it . . . .

Just change that line to:
form.mySelect[0].selected = true; // Select the first index

Scott

Scott Brady
http://www.scottbrady.net/

 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: How can I modify this query so mySQL will be happy?

[Jochem van Dieten]

S. Isaac Dealey wrote:
 There's also DateFormat(mydate,d) which returns the same value, but
 DayOfMonth() makes a lot more sense when you're reading someone else's code.

There is also an SQL standard EXTRACT function, that will work in other 
SQL compliant databases. Unless of course you prefer to have these 
problems every time you change databases.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: IIS or CFMX

[Steve]

On 12/19/2002 11:35 AM, Stephen Moretti pounded the keyboard with stubby
fingers to type:

 I believe the notes say somewhere that the web server that comes as a part
 of JRun and used for the standalone version of CFMX is not production
 strength.

Ah ok then.

 Nothing wrong with using the JRun server if all you're doing is developing
 and its not a production server you're talking about.

Yes I'm simply using it for testing locally.

Thanks to you and James for responding.

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: How to do this without the subselect?

[Rick Faircloth]

These two didn't work out, Stephen.

Looks like Jochem's solution did it.

I think the two solutions you suggested didn't work
because they both required that the
RentalWaiverDate's had to match the Form dates.
Because the only hits in the query would be those
that did have matching RentalWaiver dates, that caused nothing
to be returned even though there were 3 records that should
have been returned for the test date.

It would return the correct hits only when there was
a RentalWaiver for the Form dates and the ClientID's didn't match.
If there was not RentalWaiver for the Form dates, nothing was returned.
I tried coding various scenarios within the query,
i.e., UW.ClientID=RW.Client, but RW.WaiverIssueDate  Form Dates
or UW.ClientIDRW.Client, but RW.WaiverIssueDate = Form Dates,
basically trying to cover all possibilities, but even then results weren't
correct.

*Unfortunately*, the totally *unintuitive* (for me), but *accurate* left
join from
Jochem worked.  (Thanks, Jochem.  :o)

I've just always found the joins, especially left, outer, inner, etc., to be
unintuitive when looking at the code.  I guess I just haven't worked with
them enough.
I've always worked around them with subselects, which mySQL won't do. (Until
4.2)
Or perhaps I'm too dense!  :o)

Thanks for your help.

Rick



-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 10:25 AM
To: CF-Talk
Subject: Re: How to do this without the subselect?


 Quoting Rick Faircloth [EMAIL PROTECTED]:
 
  Since the where statement is taken by the #MultipleWaivers... line,
  it doesn't leave room for another where statement such as
  where UW.ClientID is NULL...

 Shouldn't it be RW.ClientID IS NULL.

You're probably right

Two possibles...  (Neither tested, so expect typo's etc.)

One is :
SELECT UW.UtilityWaiverID
FROM utilitywaivers AS UW RIGHT JOIN RentalWaiver AS RW
 ON UW.ClientID = RW.ClientID
WHERE RW.ClientID IS NULL
AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
AND Month(UW.IssueDate) = #Form.Month#
AND Year(UW.IssueDate) = #Form.Year#
AND Month(RW.RentalWaiverDate) = #Form.Month#
AND Year(RW.RentalWaiverDate) = #Form.Year#)

The other is :
SELECT UW.UtilityWaiverID
FROM UtilityWaiver AS UW, RentalWaiver AS RW
WHERE UW.ClientID  RW.ClientID
AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
AND Month(UW.IssueDate) = #Form.Month#
AND Year(UW.IssueDate) = #Form.Year#
AND Month(RW.RentalWaiverDate) = #Form.Month#
AND Year(RW.RentalWaiverDate) = #Form.Year#)

I have a sneaky suspicious that the second query won't work, but give them a
go and let us know

Regards

Stephen



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: How to do this without the subselect?

[Rick Faircloth]

Quoting Jochem..

Then maybe MySQL isn't the database for you :)

You may be right...perhaps I should got back to Access...
at least it was *advanced* enough to handle sub-selects...  :o)

Thanks for your help!

You can pick up your tickets for your Hawaiian cruise
at the front desk!

Rick


-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 10:21 AM
To: CF-Talk
Subject: RE: How to do this without the subselect?


Quoting Rick Faircloth [EMAIL PROTECTED]:

 Now, that's a good question.  I've always used subselects to get
 around having to spend time with those unfriendly (at least to me!)
 joins.

Then maybe MySQL isn't the database for you :)


   Select UW.UtilityWaiverID
  from utilitywaivers UW
where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
   and Month(UW.IssueDate) = #Form.Month#
   and Year(UW.IssueDate) = #Form.Year#
   and UW.ClientID not in
 (Select RW.ClientID from RentalWaivers RW
  where Month(RW.RentalWaiverDate) = #Form.Month#
 and Year(RW.RentalWaiverDate) = #Form.Year#)

I think it should be:

SELECT UW.UtilityWaiverID
FROM   utilitywaivers UW LEFT JOIN RentalWaivers RW
   ON (UW.ClientID = RW.ClientID
  AND Month(RW.RentalWaiverDate) = #Form.Month#
  AND Year(RW.RentalWaiverDate) = #Form.Year#
  )
WHERE  UW.UtilityCompanyID = #MultipleWaivers[CurrentRow][1]#
   AND Month(UW.IssueDate) = #Form.Month#
   AND Year(UW.IssueDate) = #Form.Year#
   AND RW.ClientID IS NULL

Don't forget to add the appropriate cfqueryparam tags.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: How to do this without the subselect?

[Rick Faircloth]

Still don't know why Stas' idea didn't work with the two queries
and a valuelist.  Ideas?  Kept getting the error that CF couldn't
define ClientID in the cfset statement...

Rick

CFQUERY Name=GetWaivers1 Datasource=#DSN#
Select RW.ClientID
from RentalWaivers RW
where Month(RW.RentalWaiverDate) = #Form.Month#
and Year(RW.RentalWaiverDate) = #Form.Year#)
/CFQUERY

cfset filter = valuelist(getWaivers1,clientID)

CFQUERY Name=GetWaivers Datasource=#DSN#
Select UW.UtilityWaiverID
from utilitywaivers UW
where Month(UW.IssueDate) = #Form.Month#
and Year(UW.IssueDate) = #Form.Year#
 and UW.ClientID not in (#filter#)

/CFQUERY



-Original Message-
From: Rick Faircloth [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 11:54 AM
To: CF-Talk
Subject: RE: How to do this without the subselect?


These two didn't work out, Stephen.

Looks like Jochem's solution did it.

I think the two solutions you suggested didn't work
because they both required that the
RentalWaiverDate's had to match the Form dates.
Because the only hits in the query would be those
that did have matching RentalWaiver dates, that caused nothing
to be returned even though there were 3 records that should
have been returned for the test date.

It would return the correct hits only when there was
a RentalWaiver for the Form dates and the ClientID's didn't match.
If there was not RentalWaiver for the Form dates, nothing was returned.
I tried coding various scenarios within the query,
i.e., UW.ClientID=RW.Client, but RW.WaiverIssueDate  Form Dates
or UW.ClientIDRW.Client, but RW.WaiverIssueDate = Form Dates,
basically trying to cover all possibilities, but even then results weren't
correct.

*Unfortunately*, the totally *unintuitive* (for me), but *accurate* left
join from
Jochem worked.  (Thanks, Jochem.  :o)

I've just always found the joins, especially left, outer, inner, etc., to be
unintuitive when looking at the code.  I guess I just haven't worked with
them enough.
I've always worked around them with subselects, which mySQL won't do. (Until
4.2)
Or perhaps I'm too dense!  :o)

Thanks for your help.

Rick



-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 10:25 AM
To: CF-Talk
Subject: Re: How to do this without the subselect?


 Quoting Rick Faircloth [EMAIL PROTECTED]:
 
  Since the where statement is taken by the #MultipleWaivers... line,
  it doesn't leave room for another where statement such as
  where UW.ClientID is NULL...

 Shouldn't it be RW.ClientID IS NULL.

You're probably right

Two possibles...  (Neither tested, so expect typo's etc.)

One is :
SELECT UW.UtilityWaiverID
FROM utilitywaivers AS UW RIGHT JOIN RentalWaiver AS RW
 ON UW.ClientID = RW.ClientID
WHERE RW.ClientID IS NULL
AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
AND Month(UW.IssueDate) = #Form.Month#
AND Year(UW.IssueDate) = #Form.Year#
AND Month(RW.RentalWaiverDate) = #Form.Month#
AND Year(RW.RentalWaiverDate) = #Form.Year#)

The other is :
SELECT UW.UtilityWaiverID
FROM UtilityWaiver AS UW, RentalWaiver AS RW
WHERE UW.ClientID  RW.ClientID
AND UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
AND Month(UW.IssueDate) = #Form.Month#
AND Year(UW.IssueDate) = #Form.Year#
AND Month(RW.RentalWaiverDate) = #Form.Month#
AND Year(RW.RentalWaiverDate) = #Form.Year#)

I have a sneaky suspicious that the second query won't work, but give them a
go and let us know

Regards

Stephen




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: How can I modify this query so mySQL will be happy?

[S . Isaac Dealey]

 S. Isaac Dealey wrote:
 There's also DateFormat(mydate,d) which returns the
 same value, but
 DayOfMonth() makes a lot more sense when you're reading
 someone else's code.

 There is also an SQL standard EXTRACT function, that will
 work in other
 SQL compliant databases. Unless of course you prefer to
 have these
 problems every time you change databases.

 Jochem

Yep, that probably makes a lot more sense. :)

I sort of glazed over the thread actually... I should probably reserve
participation for when I have time to actually read the thread. ;)

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

CFEXECUTE aborting on Solaris

[Cathy Taylor]

We have a really odd problem I hope somebody else has come across (and solved!). One 
of our applications allows users to upload a zip file and then does a CFEXECUTE to run 
the /usr/bin/unzip function. After a while it just stops working with the following 
error:

The process /usr/bin/unzip caused the unix exec function to return abnormally, ... 
aborting this process.  

This seems to happen for no obvious reason and restarting ColdFusion (5.0) seems to 
clear up the problem temporarily. The unzip command continues to work just fine from 
the command line.

Any ideas?

Thanks!
Cathy
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: Is there a Better Way to do this?

[Ben Doom]

I'm not a SQL wizard and am doing this off the top of my head, but I'd try
something along the lines of

select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like ('%' + word + '%')

But, again, that's off the top of my head.



  --Ben Doom
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 11:38 AM
: To: CF-Talk
: Subject: Is there a Better Way to do this?
:
:
: Ok here is what i am doing and I am just trying to find out if 1.
: there is a
: better way and 2. if it can be done on the SQL side (as a stored proc)
: instaed of the CF side. Just not all that familiar with looping
: outside of
: CF.
:
: ANyway I have one table that is a dictionary with about 1500
: words. THen I
: have another table that has dreams people have entered. THe idea
: is to take
: the list of words and see if any of them show up in the dream and then
: display those words to the user. What I built works and it's
: actually pretty
: speedy, but the dictionary is very small right now and it may be
: closer to
: 1 by the time we are done which is a MUCH larger list of
: words to loop
: through.
:
: So right now I am doing a query to get the words
: CFQUERY name=wordS
: SELECT word
: from dictionary
: /CFQUERY
:
: THen we grab a dream
: CFQUERY name=dream
: SELECT dream
: from dreams
: where dream_id = 3
: /CFQUERY
:
: Then I Loop through like so:
: CFLOOP list=#valuelist(words.word)# delimiters=, index=theword
: Then I check to see if the dream contains the word.
: CFIF dream.dream contains  #theword#  OR dream.dream contains 
: #theword#s
: Then I grab the definition if it found that word.
: CFQUERY name=getdef
: SELECT definition from dictionary
: where word = '#theword#'
: /CFQUERY
: Then I display it #theword#BR#getdef.definition#P
: /CFIF
: /CFLOOP
:
: This words fine and with a dream thats a few thousand words it
: completes in
: a few seconds.  I just wonder if there is a faster or better way
: to do this
: so down the road we don't run into problems as the word list grows.
: THoughts?
:
:
:
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: How to do this without the subselect?

[Stephen Moretti]

 These two didn't work out, Stephen.

Never mind

 Looks like Jochem's solution did it.

My first one should have been the same as Jochem's just wasn't paying
attention and stuck the RW date checks in the wrong place... :o/

 I think the two solutions you suggested didn't work
 because they both required that the
 RentalWaiverDate's had to match the Form dates.
 Because the only hits in the query would be those
 that did have matching RentalWaiver dates, that caused nothing
 to be returned even though there were 3 records that should
 have been returned for the test date.

I had a feeling that nothing would be return from RentalWaiver table
Sorry about that...


 I've just always found the joins, especially left, outer, inner, etc., to
be
 unintuitive when looking at the code.  I guess I just haven't worked with
 them enough.

Makes more sense when you match them up with Venn diagrams.


 I've always worked around them with subselects, which mySQL won't do.
(Until
 4.2)

All subqueries can be replaced with an appropriate JOIN, it just depends on
how intuitive that query actually is

Of course, when all else fails You could, ~shudder~, use query of
queries

 Or perhaps I'm too dense!  :o)

~lol~ yeah that's it  Of course that makes the rest of us that didn't
quite get it right dense too... ;o)



 cfset filter = valuelist(getWaivers1,clientID)
^you've got a
comma here  It should be a stop.

Regards

Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: CFEXECUTE aborting on Solaris

[Ryan Farrell]

We called Macromedia on this one back when we had a support plan.  The
official fix is to restart the server when you notice the problem.  Gah!

Ryan

-Original Message-
From: Cathy Taylor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 11:02 AM
To: CF-Talk
Subject: CFEXECUTE aborting on Solaris


We have a really odd problem I hope somebody else has come across (and
solved!). One of our applications allows users to upload a zip file and then
does a CFEXECUTE to run the /usr/bin/unzip function. After a while it just
stops working with the following error:

The process /usr/bin/unzip caused the unix exec function to return
abnormally, ... aborting this process.  

This seems to happen for no obvious reason and restarting ColdFusion (5.0)
seems to clear up the problem temporarily. The unzip command continues to
work just fine from the command line.

Any ideas?

Thanks!
Cathy

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: MX and Apache 2.0.43

[Dave Watts]

 I have installed updater 2 and am trying to get MX 
 to work with Apache 2.0.43 on a Win2K box with no 
 success. I don't have the error message in front of 
 me, something about requiring #some long number# and 
 having #some long number#, please contact the vendor 
 for the appropriate version.
 
 Anyone have MX running with Apache 2.0.43?

Yes, it works fine with Apache 2.0.43 on Windows. You'll need to reinstall
the Apache connector, as described in the Updater release notes.

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

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

RE: Is there a Better Way to do this?

[Tony Weeg]

select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like '%#word#%')

can be done like this, without the () around the %#word#%
part

..tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 12:06 PM
To: CF-Talk
Subject: RE: Is there a Better Way to do this?


I'm not a SQL wizard and am doing this off the top of my head, but I'd
try
something along the lines of

select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like ('%' + word + '%')

But, again, that's off the top of my head.



  --Ben Doom
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 11:38 AM
: To: CF-Talk
: Subject: Is there a Better Way to do this?
:
:
: Ok here is what i am doing and I am just trying to find out if 1.
: there is a
: better way and 2. if it can be done on the SQL side (as a stored proc)
: instaed of the CF side. Just not all that familiar with looping
: outside of
: CF.
:
: ANyway I have one table that is a dictionary with about 1500
: words. THen I
: have another table that has dreams people have entered. THe idea
: is to take
: the list of words and see if any of them show up in the dream and then
: display those words to the user. What I built works and it's
: actually pretty
: speedy, but the dictionary is very small right now and it may be
: closer to
: 1 by the time we are done which is a MUCH larger list of
: words to loop
: through.
:
: So right now I am doing a query to get the words
: CFQUERY name=wordS
: SELECT word
: from dictionary
: /CFQUERY
:
: THen we grab a dream
: CFQUERY name=dream
: SELECT dream
: from dreams
: where dream_id = 3
: /CFQUERY
:
: Then I Loop through like so:
: CFLOOP list=#valuelist(words.word)# delimiters=, index=theword
: Then I check to see if the dream contains the word.
: CFIF dream.dream contains  #theword#  OR dream.dream contains 
: #theword#s
: Then I grab the definition if it found that word.
: CFQUERY name=getdef
: SELECT definition from dictionary
: where word = '#theword#'
: /CFQUERY
: Then I display it #theword#BR#getdef.definition#P
: /CFIF
: /CFLOOP
:
: This words fine and with a dream thats a few thousand words it
: completes in
: a few seconds.  I just wonder if there is a faster or better way
: to do this
: so down the road we don't run into problems as the word list grows.
: THoughts?
:
:
:
:
: 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: Is there a Better Way to do this?

[Tony Weeg]

typo, without the ) at the very end.

..tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 12:10 PM
To: CF-Talk
Subject: RE: Is there a Better Way to do this?


select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like '%#word#%')

can be done like this, without the () around the %#word#%
part

.tony

Tony Weeg
Senior Web Developer
UnCertified Advanced ColdFusion Developer
Information System Design
Navtrak, Inc.
Mobile workforce monitoring, mapping  reporting
www.navtrak.net
410.548.2337 

-Original Message-
From: Ben Doom [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, December 19, 2002 12:06 PM
To: CF-Talk
Subject: RE: Is there a Better Way to do this?


I'm not a SQL wizard and am doing this off the top of my head, but I'd
try
something along the lines of

select word from dictionary where
(select dream from dreams where dream_id = #dreamid#)
like ('%' + word + '%')

But, again, that's off the top of my head.



  --Ben Doom
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 11:38 AM
: To: CF-Talk
: Subject: Is there a Better Way to do this?
:
:
: Ok here is what i am doing and I am just trying to find out if 1.
: there is a
: better way and 2. if it can be done on the SQL side (as a stored proc)
: instaed of the CF side. Just not all that familiar with looping
: outside of
: CF.
:
: ANyway I have one table that is a dictionary with about 1500
: words. THen I
: have another table that has dreams people have entered. THe idea
: is to take
: the list of words and see if any of them show up in the dream and then
: display those words to the user. What I built works and it's
: actually pretty
: speedy, but the dictionary is very small right now and it may be
: closer to
: 1 by the time we are done which is a MUCH larger list of
: words to loop
: through.
:
: So right now I am doing a query to get the words
: CFQUERY name=wordS
: SELECT word
: from dictionary
: /CFQUERY
:
: THen we grab a dream
: CFQUERY name=dream
: SELECT dream
: from dreams
: where dream_id = 3
: /CFQUERY
:
: Then I Loop through like so:
: CFLOOP list=#valuelist(words.word)# delimiters=, index=theword
: Then I check to see if the dream contains the word.
: CFIF dream.dream contains  #theword#  OR dream.dream contains 
: #theword#s
: Then I grab the definition if it found that word.
: CFQUERY name=getdef
: SELECT definition from dictionary
: where word = '#theword#'
: /CFQUERY
: Then I display it #theword#BR#getdef.definition#P
: /CFIF
: /CFLOOP
:
: This words fine and with a dream thats a few thousand words it
: completes in
: a few seconds.  I just wonder if there is a faster or better way
: to do this
: so down the road we don't run into problems as the word list grows.
: THoughts?
:
:
:
:
: 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: Is there a Better Way to do this?

[S . Isaac Dealey]

I did this for an FAQ not long ago... something like this worked for me

select dictionary.word
from dictionary
inner join dreams on
dreams.dream like '%' + dictionary.word + '%'
order by dictionary.word

In the case of my faq the user was entering another question and the text of
the question was compared against the dictionary and then again compared to
other questions, so if you've got someone entering a new dream, you could
put this in a stored procedure like

CREATE PROCEDURE sp_DreamNewLookup
@txt_dream nvarchar(8000)
AS
select dictionary.word, dreams.dream from dictionary
inner join dreams on dreams.dream like '%' + dictionary.word + '%'
where @txt_dream like '%' + dictionary.word + '%'
order by dictionary.word
GO


hth


s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



 I'm not a SQL wizard and am doing this off the top of my
 head, but I'd try
 something along the lines of

 select word from dictionary where
 (select dream from dreams where dream_id = #dreamid#)
 like ('%' + word + '%')

 But, again, that's off the top of my head.



   --Ben Doom
 Programmer  General Lackey
 Moonbow Software

 : -Original Message-
 : From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
 : Sent: Thursday, December 19, 2002 11:38 AM
 : To: CF-Talk
 : Subject: Is there a Better Way to do this?
 :
 :
 : Ok here is what i am doing and I am just trying to find
 out if 1.
 : there is a
 : better way and 2. if it can be done on the SQL side (as
 a stored proc)
 : instaed of the CF side. Just not all that familiar with
 looping
 : outside of
 : CF.
 :
 : ANyway I have one table that is a dictionary with about
 1500
 : words. THen I
 : have another table that has dreams people have entered.
 THe idea
 : is to take
 : the list of words and see if any of them show up in the
 dream and then
 : display those words to the user. What I built works and
 it's
 : actually pretty
 : speedy, but the dictionary is very small right now and
 it may be
 : closer to
 : 1 by the time we are done which is a MUCH larger
 list of
 : words to loop
 : through.
 :
 : So right now I am doing a query to get the words
 : CFQUERY name=wordS
 : SELECT word
 : from dictionary
 : /CFQUERY
 :
 : THen we grab a dream
 : CFQUERY name=dream
 : SELECT dream
 : from dreams
 : where dream_id = 3
 : /CFQUERY
 :
 : Then I Loop through like so:
 : CFLOOP list=#valuelist(words.word)# delimiters=,
 index=theword
 : Then I check to see if the dream contains the word.
 : CFIF dream.dream contains  #theword#  OR dream.dream
 contains 
 : #theword#s
 : Then I grab the definition if it found that word.
 : CFQUERY name=getdef
 : SELECT definition from dictionary
 : where word = '#theword#'
 : /CFQUERY
 : Then I display it #theword#BR#getdef.definition#P
 : /CFIF
 : /CFLOOP
 :
 : This words fine and with a dream thats a few thousand
 words it
 : completes in
 : a few seconds.  I just wonder if there is a faster or
 better way
 : to do this
 : so down the road we don't run into problems as the word
 list grows.
 : THoughts?
 :
 :
 :
 :
 :
 ~~
 ~~~|
 Archives:
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=4
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 Structure your ColdFusion code with Fusebox. Get the
 official book at http://www.fusionauthority.com/bkinfo.cfm



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Is there a Better Way to do this?

[Ben Doom]

If you pound the word like that, won't you get whatever is stored in a cf
variable named 'word' instead of the contents of the word column from the
outer select?  Or am I missing something?



  --Ben Doom
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: Tony Weeg [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 12:10 PM
: To: CF-Talk
: Subject: RE: Is there a Better Way to do this?
:
:
: select word from dictionary where
: (select dream from dreams where dream_id = #dreamid#)
: like '%#word#%')
:
: can be done like this, without the () around the %#word#%
: part
:
: ..tony
:
: Tony Weeg
: Senior Web Developer
: UnCertified Advanced ColdFusion Developer
: Information System Design
: Navtrak, Inc.
: Mobile workforce monitoring, mapping  reporting
: www.navtrak.net
: 410.548.2337
:
: -Original Message-
: From: Ben Doom [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 12:06 PM
: To: CF-Talk
: Subject: RE: Is there a Better Way to do this?
:
:
: I'm not a SQL wizard and am doing this off the top of my head, but I'd
: try
: something along the lines of
:
: select word from dictionary where
: (select dream from dreams where dream_id = #dreamid#)
: like ('%' + word + '%')
:
: But, again, that's off the top of my head.
:
:
:
:   --Ben Doom
: Programmer  General Lackey
: Moonbow Software
:
: : -Original Message-
: : From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
: : Sent: Thursday, December 19, 2002 11:38 AM
: : To: CF-Talk
: : Subject: Is there a Better Way to do this?
: :
: :
: : Ok here is what i am doing and I am just trying to find out if 1.
: : there is a
: : better way and 2. if it can be done on the SQL side (as a stored proc)
: : instaed of the CF side. Just not all that familiar with looping
: : outside of
: : CF.
: :
: : ANyway I have one table that is a dictionary with about 1500
: : words. THen I
: : have another table that has dreams people have entered. THe idea
: : is to take
: : the list of words and see if any of them show up in the dream and then
: : display those words to the user. What I built works and it's
: : actually pretty
: : speedy, but the dictionary is very small right now and it may be
: : closer to
: : 1 by the time we are done which is a MUCH larger list of
: : words to loop
: : through.
: :
: : So right now I am doing a query to get the words
: : CFQUERY name=wordS
: : SELECT word
: : from dictionary
: : /CFQUERY
: :
: : THen we grab a dream
: : CFQUERY name=dream
: : SELECT dream
: : from dreams
: : where dream_id = 3
: : /CFQUERY
: :
: : Then I Loop through like so:
: : CFLOOP list=#valuelist(words.word)# delimiters=, index=theword
: : Then I check to see if the dream contains the word.
: : CFIF dream.dream contains  #theword#  OR dream.dream contains 
: : #theword#s
: : Then I grab the definition if it found that word.
: : CFQUERY name=getdef
: : SELECT definition from dictionary
: : where word = '#theword#'
: : /CFQUERY
: : Then I display it #theword#BR#getdef.definition#P
: : /CFIF
: : /CFLOOP
: :
: : This words fine and with a dream thats a few thousand words it
: : completes in
: : a few seconds.  I just wonder if there is a faster or better way
: : to do this
: : so down the road we don't run into problems as the word list grows.
: : THoughts?
: :
: :
: :
: :
: :
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

RE: How to do this without the subselect?

[Rick Faircloth]

 ~lol~ yeah that's it  Of course that makes the rest of us that didn't
quite get it right dense too... ;o)

No, the difference is, you hadn't already spent half a day and night trying
to figure out how to code the query!  I had!  :o)

Rick


-Original Message-
From: Stephen Moretti [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 12:06 PM
To: CF-Talk
Subject: Re: How to do this without the subselect?


 These two didn't work out, Stephen.

Never mind

 Looks like Jochem's solution did it.

My first one should have been the same as Jochem's just wasn't paying
attention and stuck the RW date checks in the wrong place... :o/

 I think the two solutions you suggested didn't work
 because they both required that the
 RentalWaiverDate's had to match the Form dates.
 Because the only hits in the query would be those
 that did have matching RentalWaiver dates, that caused nothing
 to be returned even though there were 3 records that should
 have been returned for the test date.

I had a feeling that nothing would be return from RentalWaiver table
Sorry about that...


 I've just always found the joins, especially left, outer, inner, etc., to
be
 unintuitive when looking at the code.  I guess I just haven't worked with
 them enough.

Makes more sense when you match them up with Venn diagrams.


 I've always worked around them with subselects, which mySQL won't do.
(Until
 4.2)

All subqueries can be replaced with an appropriate JOIN, it just depends on
how intuitive that query actually is

Of course, when all else fails You could, ~shudder~, use query of
queries

 Or perhaps I'm too dense!  :o)

~lol~ yeah that's it  Of course that makes the rest of us that didn't
quite get it right dense too... ;o)



 cfset filter = valuelist(getWaivers1,clientID)
^you've got a
comma here  It should be a stop.

Regards

Stephen



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

CFMX App Server Failing?

[Jeff D. Chastain]

I have a copy of CFMX Pro installed on my laptop (Win2K Pro).  It is
setup to utilize IIS if that matters.   Whenever I boot my laptop
however, the App Server fails.  The error in the event log is that the
CFMX App Server service terminated with service specific error 2.

Anybody got any idea what is happening?  I have installed CFMX Pro on a
development server and everything works great there.  I have updated
both with the latest updater as well.

Thanks
-- Jeff

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: Is there a Better Way to do this?

[Ben Doom]

Aye, that's what I was trying to think of.  Too much blood in my caffiene
stream this morning.



  --Ben Doom
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 12:28 PM
: To: CF-Talk
: Subject: RE: Is there a Better Way to do this?
:
:
: I did this for an FAQ not long ago... something like this worked for me
:
: select dictionary.word
: from dictionary
: inner join dreams on
: dreams.dream like '%' + dictionary.word + '%'
: order by dictionary.word
:
: In the case of my faq the user was entering another question and
: the text of
: the question was compared against the dictionary and then again
: compared to
: other questions, so if you've got someone entering a new dream, you could
: put this in a stored procedure like
:
: CREATE PROCEDURE sp_DreamNewLookup
:   @txt_dream nvarchar(8000)
: AS
:   select dictionary.word, dreams.dream from dictionary
:   inner join dreams on dreams.dream like '%' + dictionary.word + '%'
:   where @txt_dream like '%' + dictionary.word + '%'
:   order by dictionary.word
: GO
:
:
: hth
:
:
: s. isaac dealey954-776-0046
:
: new epoch  http://www.turnkey.to
:
: lead architect, tapestry cms   http://products.turnkey.to
:
: certified advanced coldfusion 5 developer
: http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
:
:
:
:  I'm not a SQL wizard and am doing this off the top of my
:  head, but I'd try
:  something along the lines of
:
:  select word from dictionary where
:  (select dream from dreams where dream_id = #dreamid#)
:  like ('%' + word + '%')
:
:  But, again, that's off the top of my head.
:
:
:
:--Ben Doom
:  Programmer  General Lackey
:  Moonbow Software
:
:  : -Original Message-
:  : From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
:  : Sent: Thursday, December 19, 2002 11:38 AM
:  : To: CF-Talk
:  : Subject: Is there a Better Way to do this?
:  :
:  :
:  : Ok here is what i am doing and I am just trying to find
:  out if 1.
:  : there is a
:  : better way and 2. if it can be done on the SQL side (as
:  a stored proc)
:  : instaed of the CF side. Just not all that familiar with
:  looping
:  : outside of
:  : CF.
:  :
:  : ANyway I have one table that is a dictionary with about
:  1500
:  : words. THen I
:  : have another table that has dreams people have entered.
:  THe idea
:  : is to take
:  : the list of words and see if any of them show up in the
:  dream and then
:  : display those words to the user. What I built works and
:  it's
:  : actually pretty
:  : speedy, but the dictionary is very small right now and
:  it may be
:  : closer to
:  : 1 by the time we are done which is a MUCH larger
:  list of
:  : words to loop
:  : through.
:  :
:  : So right now I am doing a query to get the words
:  : CFQUERY name=wordS
:  : SELECT word
:  : from dictionary
:  : /CFQUERY
:  :
:  : THen we grab a dream
:  : CFQUERY name=dream
:  : SELECT dream
:  : from dreams
:  : where dream_id = 3
:  : /CFQUERY
:  :
:  : Then I Loop through like so:
:  : CFLOOP list=#valuelist(words.word)# delimiters=,
:  index=theword
:  : Then I check to see if the dream contains the word.
:  : CFIF dream.dream contains  #theword#  OR dream.dream
:  contains 
:  : #theword#s
:  : Then I grab the definition if it found that word.
:  : CFQUERY name=getdef
:  : SELECT definition from dictionary
:  : where word = '#theword#'
:  : /CFQUERY
:  : Then I display it #theword#BR#getdef.definition#P
:  : /CFIF
:  : /CFLOOP
:  :
:  : This words fine and with a dream thats a few thousand
:  words it
:  : completes in
:  : a few seconds.  I just wonder if there is a faster or
:  better way
:  : to do this
:  : so down the road we don't run into problems as the word
:  list grows.
:  : THoughts?
:  :
:  :
:  :
:  :
:  :
:  ~~
:  ~~~|
:  Archives:
:  http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
:  Subscription: http://www.houseoffusion.com/cf_lists/index.
:  cfm?method=subscribeforumid=4
:  FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
:  Structure your ColdFusion code with Fusebox. Get the
:  official book at http://www.fusionauthority.com/bkinfo.cfm
:
:
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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: How to do this without the subselect?

[Rick Faircloth]

Hey, Jochem...

Since you've got a good grip on how the joins work, would my explanation
for my notes concerning why this query works be accurate?

Notes:

This query works to select UtilityWaivers that were issued within a given
month
and which were issued without an accompanying RentalWaiver.

The part of the query before the where clause selects all UtilityWaivers
which were issued within the specified month and which have
accompanying RentalWaivers with matching ClientID's for the same month.

The where clause then specifies that the joined group should be limited
to those UtilityWaivers whose ClientID does match any RentalWaiver ClientID.

 CFQUERY Name=GetUCSWCount Datasource=#DSN#
  Select UW.UtilityWaiverID
from utilitywaivers UW
   left join RentalWaivers RW
   on (UW.ClientID = RW.ClientID
 and Month(RW.RentalWaiverDate) = #Form.Month#
 and Year(RW.RentalWaiverDate) = #Form.Year#
  )
   where UW.UtilityCompanyID = #MultipleWaivers[CurrentRow][1]#
 and Month(UW.IssueDate) = #Form.Month#
 and Year(UW.IssueDate) = #Form.Year#
 and RW.ClientID IS NULL
 /CFQUERY

Thanks,

Rick



-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Thursday, December 19, 2002 10:21 AM
To: CF-Talk
Subject: RE: How to do this without the subselect?


Quoting Rick Faircloth [EMAIL PROTECTED]:

 Now, that's a good question.  I've always used subselects to get
 around having to spend time with those unfriendly (at least to me!)
 joins.

Then maybe MySQL isn't the database for you :)


   Select UW.UtilityWaiverID
  from utilitywaivers UW
where UW.UtilityCompanyID=#MultipleWaivers[CurrentRow][1]#
   and Month(UW.IssueDate) = #Form.Month#
   and Year(UW.IssueDate) = #Form.Year#
   and UW.ClientID not in
 (Select RW.ClientID from RentalWaivers RW
  where Month(RW.RentalWaiverDate) = #Form.Month#
 and Year(RW.RentalWaiverDate) = #Form.Year#)

I think it should be:

SELECT UW.UtilityWaiverID
FROM   utilitywaivers UW LEFT JOIN RentalWaivers RW
   ON (UW.ClientID = RW.ClientID
  AND Month(RW.RentalWaiverDate) = #Form.Month#
  AND Year(RW.RentalWaiverDate) = #Form.Year#
  )
WHERE  UW.UtilityCompanyID = #MultipleWaivers[CurrentRow][1]#
   AND Month(UW.IssueDate) = #Form.Month#
   AND Year(UW.IssueDate) = #Form.Year#
   AND RW.ClientID IS NULL

Don't forget to add the appropriate cfqueryparam tags.

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: Is there a Better Way to do this?

[Stephen Moretti]

 I'm not a SQL wizard and am doing this off the top of my head, but I'd try
 something along the lines of

 select word from dictionary where
 (select dream from dreams where dream_id = #dreamid#)
 like ('%' + word + '%')

 But, again, that's off the top of my head.


What you mean is :

SELECT dictionary.word, dictionary.definition
FROM dictionary LEFT JOIN dream
ON dreams.dream LIKE '%' + dictionary.word + '%'

Which is what Isaac's got in his stored proc... ;o)

Regards

Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: Is there a Better Way to do this?

[S . Isaac Dealey]

Nasty thing that blood... I say who needs it. ;)

 Aye, that's what I was trying to think of.  Too much blood
 in my caffiene stream this morning.



   --Ben Doom
 Programmer  General Lackey
 Moonbow Software

 : -Original Message-
 : From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]]
 : Sent: Thursday, December 19, 2002 12:28 PM
 : To: CF-Talk
 : Subject: RE: Is there a Better Way to do this?
 :
 :
 : I did this for an FAQ not long ago... something like
 this worked for me
 :
 : select dictionary.word
 : from dictionary
 : inner join dreams on
 : dreams.dream like '%' + dictionary.word + '%'
 : order by dictionary.word
 :
 : In the case of my faq the user was entering another
 question and
 : the text of
 : the question was compared against the dictionary and
 then again
 : compared to
 : other questions, so if you've got someone entering a new
 dream, you could
 : put this in a stored procedure like
 :
 : CREATE PROCEDURE sp_DreamNewLookup
 : @txt_dream nvarchar(8000)
 : AS
 : select dictionary.word, dreams.dream from dictionary
 : inner join dreams on dreams.dream like '%' +
 dictionary.word + '%'
 : where @txt_dream like '%' + dictionary.word + '%'
 : order by dictionary.word
 : GO
 :
 :
 : hth
 :
 :
 : s. isaac dealey954-776-0046
 :
 : new epoch  http://www.turnkey.to
 :
 : lead architect, tapestry cms
 http://products.turnkey.to
 :
 : certified advanced coldfusion 5 developer
 : http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
 :
 :
 :
 :  I'm not a SQL wizard and am doing this off the top of
 my
 :  head, but I'd try
 :  something along the lines of
 :
 :  select word from dictionary where
 :  (select dream from dreams where dream_id = #dreamid#)
 :  like ('%' + word + '%')
 :
 :  But, again, that's off the top of my head.
 :
 :
 :
 :--Ben Doom
 :  Programmer  General Lackey
 :  Moonbow Software
 :
 :  : -Original Message-
 :  : From: Kelly Matthews
 [mailto:[EMAIL PROTECTED]]
 :  : Sent: Thursday, December 19, 2002 11:38 AM
 :  : To: CF-Talk
 :  : Subject: Is there a Better Way to do this?
 :  :
 :  :
 :  : Ok here is what i am doing and I am just trying to
 find
 :  out if 1.
 :  : there is a
 :  : better way and 2. if it can be done on the SQL side
 (as
 :  a stored proc)
 :  : instaed of the CF side. Just not all that familiar
 with
 :  looping
 :  : outside of
 :  : CF.
 :  :
 :  : ANyway I have one table that is a dictionary with
 about
 :  1500
 :  : words. THen I
 :  : have another table that has dreams people have
 entered.
 :  THe idea
 :  : is to take
 :  : the list of words and see if any of them show up in
 the
 :  dream and then
 :  : display those words to the user. What I built works
 and
 :  it's
 :  : actually pretty
 :  : speedy, but the dictionary is very small right now
 and
 :  it may be
 :  : closer to
 :  : 1 by the time we are done which is a MUCH larger
 :  list of
 :  : words to loop
 :  : through.
 :  :
 :  : So right now I am doing a query to get the words
 :  : CFQUERY name=wordS
 :  : SELECT word
 :  : from dictionary
 :  : /CFQUERY
 :  :
 :  : THen we grab a dream
 :  : CFQUERY name=dream
 :  : SELECT dream
 :  : from dreams
 :  : where dream_id = 3
 :  : /CFQUERY
 :  :
 :  : Then I Loop through like so:
 :  : CFLOOP list=#valuelist(words.word)#
 delimiters=,
 :  index=theword
 :  : Then I check to see if the dream contains the word.
 :  : CFIF dream.dream contains  #theword#  OR
 dream.dream
 :  contains 
 :  : #theword#s
 :  : Then I grab the definition if it found that word.
 :  : CFQUERY name=getdef
 :  : SELECT definition from dictionary
 :  : where word = '#theword#'
 :  : /CFQUERY
 :  : Then I display it
 #theword#BR#getdef.definition#P
 :  : /CFIF
 :  : /CFLOOP
 :  :
 :  : This words fine and with a dream thats a few
 thousand
 :  words it
 :  : completes in
 :  : a few seconds.  I just wonder if there is a faster
 or
 :  better way
 :  : to do this
 :  : so down the road we don't run into problems as the
 word
 :  list grows.
 :  : THoughts?
 :  :
 :  :
 :  :
 :  :
 :  :
 : 
 ~~
 :  ~~~|
 :  Archives:
 : 
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 :  Subscription:
 http://www.houseoffusion.com/cf_lists/index.
 :  cfm?method=subscribeforumid=4
 :  FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 :  Structure your ColdFusion code with Fusebox. Get the
 :  official book at
 http://www.fusionauthority.com/bkinfo.cfm
 :
 :
 :
 :
 ~~
 ~~~|
 Archives:
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=4
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 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


s. isaac dealey   

Re: Is there a Better Way to do this?

[S . Isaac Dealey]

 I'm not a SQL wizard and am doing this off the top of my
 head, but I'd try
 something along the lines of

 select word from dictionary where
 (select dream from dreams where dream_id = #dreamid#)
 like ('%' + word + '%')

 But, again, that's off the top of my head.


 What you mean is :

 SELECT dictionary.word, dictionary.definition
 FROM dictionary LEFT JOIN dream
 ON dreams.dream LIKE '%' + dictionary.word + '%'

 Which is what Isaac's got in his stored proc... ;o)

Accept that if you left join dream, you'll get every word from the
dictionary -- I was under the impression ( possibly mistaken ) he was
looking for only words appearing in the dream text ...

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: CFMX App Server Failing?

[Stephen Moretti]

Jeff,

 I have a copy of CFMX Pro installed on my laptop (Win2K Pro).  It is
 setup to utilize IIS if that matters.   Whenever I boot my laptop
 however, the App Server fails.  The error in the event log is that the
 CFMX App Server service terminated with service specific error 2.

 Anybody got any idea what is happening?  I have installed CFMX Pro on a
 development server and everything works great there.  I have updated
 both with the latest updater as well.



According to net helpmsg 2 The system cannot find the file specified.

So possibly the service can't find the exe for the app server because its
moved/deleted or the permissions are preventing SYSTEM from accessing the
file.
Have a look around the event logs.  Theoretically, it should tell you what
that missing file is.

Hope that helps

Regards

Stephen


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Is there a Better Way to do this?

[Stephen Moretti]

 
 Accept that if you left join dream, you'll get every word from the
 dictionary -- I was under the impression ( possibly mistaken ) he was
 looking for only words appearing in the dream text ...
 

~sigh~ Right! that does it  You are of course correct 

Too much darkness outside now... Time for me to quit and go home

Stephen

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: CFMX App Server Failing?

[Jeff D. Chastain]

Stephen,

I checked the logs again and the message is exactly as I stated, no file
name included.  If I restart the service a couple of times and maybe do
a restart on the laptop, it will eventually work.  This seems to only
occur after a cold boot, not after I just do a restart.

Thanks
-- Jeff

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Simplest translation of simple XML file to CF5 structure?

[Jon Block]

Lets pretend that abc.xml contains...

?xml version=1.0?
book
authorjon/author
titlea question/title
/book

What is the most easy way to magically turn that into a coldfusion structure
where I can do #book.author# and #book.title#? There has GOT to be a CF5
xmlParse() UDF out there somewhere.

Please advise.
Thank you,
Jon

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Is there a Better Way to do this?

[Kelly Matthews]

No you were correct I only want to pull the dictionary words that were found 
in the dream. The code you gave me worked great the only issue i see now for 
example let's say the word is FEEL then it pulls EEL out of the dictionary.  
IS there a way to avoid that?

  I'm not a SQL wizard and am doing this off the top of my
  head, but I'd try
  something along the lines of
 
  select word from dictionary where
  (select dream from dreams where dream_id = #dreamid#)
  like ('%' + word + '%')
 
  But, again, that's off the top of my head.
 

  What you mean is :

  SELECT dictionary.word, dictionary.definition
  FROM dictionary LEFT JOIN dream
  ON dreams.dream LIKE '%' + dictionary.word + '%'

  Which is what Isaac's got in his stored proc... ;o)

Accept that if you left join dream, you'll get every word from the
dictionary -- I was under the impression ( possibly mistaken ) he was
looking for only words appearing in the dream text ...

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Self Join Question

[Les Mizzell]

Almost got a self join working the way I want, but not quite...

I've got a table of Office Branches. Some of them are MAIN BRANCHES (value
main under sub_branch in table).
Others are SUB BRANCHES and would have the branch_ID of the main branch
listed in the sub_branch cell.

So, I need a self join to get this to work, correct?  Can't get the syntax
just right

Table: BRANCHES
---
ID
branch_name
branch_ID
sub_branch


Return results like
--

Main Branch 1
SubBranch 1
SubBranch 2

Main Branch 2

Main Branch 3
SubBranch 3

Some assistance please?

Thanks

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: Is there a Better Way to do this?

[webguy]

Quick guess, change

like ('%' + word + '%')

to

like (word)
??/

WG

 -Original Message-
 From: Kelly Matthews [mailto:[EMAIL PROTECTED]]
 Sent: 19 December 2002 17:52
 To: CF-Talk
 Subject: Re: Is there a Better Way to do this?


 No you were correct I only want to pull the dictionary words that
 were found
 in the dream. The code you gave me worked great the only issue i
 see now for
 example let's say the word is FEEL then it pulls EEL out of the
 dictionary.
 IS there a way to avoid that?

   I'm not a SQL wizard and am doing this off the top of my
   head, but I'd try
   something along the lines of
  
   select word from dictionary where
   (select dream from dreams where dream_id = #dreamid#)
   like ('%' + word + '%')
  
   But, again, that's off the top of my head.
  
 
   What you mean is :
 
   SELECT dictionary.word, dictionary.definition
   FROM dictionary LEFT JOIN dream
   ON dreams.dream LIKE '%' + dictionary.word + '%'
 
   Which is what Isaac's got in his stored proc... ;o)
 
 Accept that if you left join dream, you'll get every word from the
 dictionary -- I was under the impression ( possibly mistaken ) he was
 looking for only words appearing in the dream text ...
 
 s. isaac dealey954-776-0046
 
 new epoch  http://www.turnkey.to
 
 lead architect, tapestry cms   http://products.turnkey.to
 
 certified advanced coldfusion 5 developer
 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: CFMX / JVM

[Sean A Corfield]

On Thursday, Dec 19, 2002, at 06:53 US/Pacific, Samuel R. Neff wrote:
 I don't think there is an official recommendation.

I think you're right because the question has been asked and gone 
unanswered here before.

 I believe the IBM one
 is bundled with CFMX and many have reported problems with CFHTTP fixed 
 only
 by installing a new JVM--the SUN one in particular.

Yes, CFMX Standalone ships with the IBM JVM, 1.3.1 I believe. Our own 
documentation mentions the 1.4.0 JVM in connection with certain tags 
(cfhttp may well be one of them). The 1.4.0 JVM is substantially faster 
than the 1.3.1 JVM so it's a 'safe' upgrade.

 I've read reports that the BEA JVM, JRockit, is a lot faster than IBM 
  SUN
 JVM.

Several people seem to have had a lot of success with JRockit although 
I recall some problems reported with it early on (perhaps an earlier 
version?). I don't believe CFMX w/ JRockit is a supported configuration 
however.

 Also, CFMX for J2EE is much faster than standalone CFMX (even CFMX
 for JRUN is faster than CFMX Enterprise which uses JRun).

By way of explanation, CFMX for J2EE has been optimized to take better 
advantage of the underlying J2EE system. Yes, it is faster than CFMX 
Standalone but it's also very dependent on the J2EE system in use and 
the difference is more noticeable as you move up the multi-processor 
scale. Check out the CFMX for WebSphere performance brief in the 
ColdFusion MX Whitepapers section of mm.com.

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/

Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: MX and Apache 2.0.43

[Sean A Corfield]

On Thursday, Dec 19, 2002, at 07:08 US/Pacific, Haggerty, Mike wrote:
 I have installed updater 2 and am trying to get MX to work with Apache
 2.0.43 on a Win2K box with no success. I don't have the error message 
 in
 front of me, something about requiring #some long number# and having 
 #some
 long number#, please contact the vendor for the appropriate version.

Sounds like the 'magic numbers' don't match which suggests that either 
wsconfig is finding a different Apache version or your Updater 2 
installer didn't properly update wsconfig.

 Anyone have MX running with Apache 2.0.43?

Yes, we have it running on Solaris (on several servers) but we're using 
CFMX for J2EE.

I'll forward this to some product team folks and see if they can 
suggest how to debug the problem you're seeing.

Sean A Corfield -- Director, Architecture
Web Technology Group -- Macromedia, Inc.
tel: (415) 252-2287 -- cell: (415) 717-8473
aim: seancorfield -- http://www.macromedia.com
An Architect's View -- http://www.corfield.org/blog/

Introducing Macromedia Contribute. Web publishing for everyone.
Learn more at http://www.macromedia.com/contribute

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: Is there a Better Way to do this?

[S . Isaac Dealey]

Yea, there's a couple things you can do ...

Make sure that every word in the dream is bounded by spaces

You can do this with a couple regular expressions like this:

cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^ [:alpha:]]),\1
\2,ALL)
cfset dreamtext = REReplace(dreamtext,([^ [:alpha:]])([[:alpha:]]),\1
\2,ALL)

To give you a quick run-down ( in case you're unfamiliar with regular
expressions ), this says find an alphabetic character [[:alpha:]] followed
by a character that is not a space and not alphabetical [^ [:alpha:]], and
replace them with the first character \1 a space and the second character \2
-- it then reverses the position of the alpha and the non alpha characters
and places spaces in front of words which are prepended with something other
than a space.

Then feed your massaged dream text into the stored procedure with an extra
space on either side of the text and add the spaces to the query like so:

WHERE dreams.dream LIKE '% ' + dictionary.word + ' %'

Alternatively, you could just change anything that's not a space into a
space before you feed it to the stored procedure like this:

cfquery ...
exec sp_DreamNewLookup
@txt_dream = ' #REReplace(dreamtext,[^ [:alpha:]], ,ALL)# ';
/cfquery

This is going to also replace numbers and punctuation, however, so you
probably won't want to store the text after this REReplace() function call.

If you need / want more help with regular expressions, check out the
cf-regex list also on www.houseoffusion.com

hth

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


 No you were correct I only want to pull the dictionary
 words that were found
 in the dream. The code you gave me worked great the only
 issue i see now for
 example let's say the word is FEEL then it pulls EEL out
 of the dictionary.
 IS there a way to avoid that?

  I'm not a SQL wizard and am doing this off the top of
  my
  head, but I'd try
  something along the lines of
 
  select word from dictionary where
  (select dream from dreams where dream_id = #dreamid#)
  like ('%' + word + '%')
 
  But, again, that's off the top of my head.
 

  What you mean is :

  SELECT dictionary.word, dictionary.definition
  FROM dictionary LEFT JOIN dream
  ON dreams.dream LIKE '%' + dictionary.word + '%'

  Which is what Isaac's got in his stored proc... ;o)

Accept that if you left join dream, you'll get every word
from the
dictionary -- I was under the impression ( possibly
mistaken ) he was
looking for only words appearing in the dream text ...

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



 ~~
 ~~~|
 Archives:
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=4
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 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


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

ODBC Data Source [Merant dBase/FoxPro Driver]

[Bruce, Rodney S HQISEC/Veridian IT Services]

hi all

Does anyone have any experience with ODBC Data Source [Merant dBase/FoxPro
Driver] in CF admin?

I haven't used it before and cant seem to find any examples.

I have tried the simple queries:

cfquery name=Qtransferrequests datasource=temp1610 dbtype=ODBC
SELECT STATION, ORG_ELMT
FROM t16101;
/cfquery
cfquery name=Qtransferrequests datasource=temp1610 dbtype=ODBC
DELETE t16101.*
FROM t16101;
/cfquery

for the select I get:
unknown exception condition

PCodeRuntimeContextImp::executeSQLTagCFQuery::endTag



for the delete I get the error:

ODBC Error Code = 37000 (Syntax error or access violation)


[MERANT][ODBC dBase driver]Missing FROM keyword in DELETE statement


SQL = Delete t16101.* FROM t16101;


I can verify the connection in CF Admin and it says its OK

any examples would be a great help
Thanks
Rodney

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Is there a Better Way to do this?

[Kelly Matthews]

awesome thanks :)))



From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Is there a Better Way to do this?
Date: Thu, 19 Dec 2002 13:26:40 -0500

Yea, there's a couple things you can do ...

Make sure that every word in the dream is bounded by spaces

You can do this with a couple regular expressions like this:

cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^ [:alpha:]]),\1
\2,ALL)
cfset dreamtext = REReplace(dreamtext,([^ [:alpha:]])([[:alpha:]]),\1
\2,ALL)

To give you a quick run-down ( in case you're unfamiliar with regular
expressions ), this says find an alphabetic character [[:alpha:]] followed
by a character that is not a space and not alphabetical [^ [:alpha:]], and
replace them with the first character \1 a space and the second character 
\2
-- it then reverses the position of the alpha and the non alpha characters
and places spaces in front of words which are prepended with something 
other
than a space.

Then feed your massaged dream text into the stored procedure with an extra
space on either side of the text and add the spaces to the query like so:

WHERE dreams.dream LIKE '% ' + dictionary.word + ' %'

Alternatively, you could just change anything that's not a space into a
space before you feed it to the stored procedure like this:

cfquery ...
   exec sp_DreamNewLookup
   @txt_dream = ' #REReplace(dreamtext,[^ [:alpha:]], ,ALL)# ';
/cfquery

This is going to also replace numbers and punctuation, however, so you
probably won't want to store the text after this REReplace() function call.

If you need / want more help with regular expressions, check out the
cf-regex list also on www.houseoffusion.com

hth

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


  No you were correct I only want to pull the dictionary
  words that were found
  in the dream. The code you gave me worked great the only
  issue i see now for
  example let's say the word is FEEL then it pulls EEL out
  of the dictionary.
  IS there a way to avoid that?

   I'm not a SQL wizard and am doing this off the top of
   my
   head, but I'd try
   something along the lines of
  
   select word from dictionary where
   (select dream from dreams where dream_id = #dreamid#)
   like ('%' + word + '%')
  
   But, again, that's off the top of my head.
  
 
   What you mean is :
 
   SELECT dictionary.word, dictionary.definition
   FROM dictionary LEFT JOIN dream
   ON dreams.dream LIKE '%' + dictionary.word + '%'
 
   Which is what Isaac's got in his stored proc... ;o)
 
 Accept that if you left join dream, you'll get every word
 from the
 dictionary -- I was under the impression ( possibly
 mistaken ) he was
 looking for only words appearing in the dream text ...
 
 s. isaac dealey954-776-0046
 
 new epoch  http://www.turnkey.to
 
 lead architect, tapestry cms   http://products.turnkey.to
 
 certified advanced coldfusion 5 developer
 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816
 
 
 
  ~~
  ~~~|
  Archives:
  http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
  Subscription: http://www.houseoffusion.com/cf_lists/index.
  cfm?method=subscribeforumid=4
  FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
  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



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: Is there a Better Way to do this?

[S . Isaac Dealey]

 Quick guess, change

 like ('%' + word + '%')

 to

 like (word)

At least in sql server afaik ( not sure about other db's, but I suspect it's
fairly standard ) using like word is the same as using = word because
the db is looking for a wildcard % or _ ( single character wildcard in sql
server iirc ) for the like comparison. If you leave them out afaik it
doesn't assume % on either side of the string.

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

Re: Is there a Better Way to do this?

[S . Isaac Dealey]

That's what we're here for. :)

 awesome thanks :)))



From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: Re: Is there a Better Way to do this?
Date: Thu, 19 Dec 2002 13:26:40 -0500

Yea, there's a couple things you can do ...

Make sure that every word in the dream is bounded by
spaces

You can do this with a couple regular expressions like
this:

cfset dreamtext = REReplace(dreamtext,([[:alpha:]])([^
[:alpha:]]),\1
\2,ALL)
cfset dreamtext = REReplace(dreamtext,([^
[:alpha:]])([[:alpha:]]),\1
\2,ALL)

To give you a quick run-down ( in case you're unfamiliar
with regular
expressions ), this says find an alphabetic character
[[:alpha:]] followed
by a character that is not a space and not alphabetical [^
[:alpha:]], and
replace them with the first character \1 a space and the
second character
\2
-- it then reverses the position of the alpha and the non
alpha characters
and places spaces in front of words which are prepended
with something
other
than a space.

Then feed your massaged dream text into the stored
procedure with an extra
space on either side of the text and add the spaces to the
query like so:

WHERE dreams.dream LIKE '% ' + dictionary.word + ' %'

Alternatively, you could just change anything that's not a
space into a
space before you feed it to the stored procedure like
this:

cfquery ...
  exec sp_DreamNewLookup
  @txt_dream = ' #REReplace(dreamtext,[^ [:alpha:]],
  ,ALL)# ';
/cfquery

This is going to also replace numbers and punctuation,
however, so you
probably won't want to store the text after this
REReplace() function call.

If you need / want more help with regular expressions,
check out the
cf-regex list also on www.houseoffusion.com

hth

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


  No you were correct I only want to pull the dictionary
  words that were found
  in the dream. The code you gave me worked great the
  only
  issue i see now for
  example let's say the word is FEEL then it pulls EEL
  out
  of the dictionary.
  IS there a way to avoid that?

   I'm not a SQL wizard and am doing this off the top
   of
   my
   head, but I'd try
   something along the lines of
  
   select word from dictionary where
   (select dream from dreams where dream_id =
   #dreamid#)
   like ('%' + word + '%')
  
   But, again, that's off the top of my head.
  
 
   What you mean is :
 
   SELECT dictionary.word, dictionary.definition
   FROM dictionary LEFT JOIN dream
   ON dreams.dream LIKE '%' + dictionary.word + '%'
 
   Which is what Isaac's got in his stored proc... ;o)
 
 Accept that if you left join dream, you'll get every
 word
 from the
 dictionary -- I was under the impression ( possibly
 mistaken ) he was
 looking for only words appearing in the dream text ...
 
 s. isaac dealey954-776-0046
 
 new epoch  http://www.turnkey.to
 
 lead architect, tapestry cms
 http://products.turnkey.to
 
 certified advanced coldfusion 5 developer
 http://www.macromedia.com/v1/handlers/index.cfm?ID=2181
 6
 
 
 
  ~~~
  ~~~
  ~~~|
  Archives:
  http://www.houseoffusion.com/cf_lists/index.cfm?forumid
  =4
  Subscription:
  http://www.houseoffusion.com/cf_lists/index.
  cfm?method=subscribeforumid=4
  FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
  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



 ~~
 ~~~|
 Archives:
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=4
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 Structure your ColdFusion code with Fusebox. Get the
 official book at http://www.fusionauthority.com/bkinfo.cfm


s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

CFMail - Multiple Attachments

[Casey C Cook]

Hello,

I would think this is an easy question, but I have not easily found the
answer yet. Is it possible to send multiple attachments out with cfmail,
and can the number of attachments and attachment names be dynamically
determined based on user selections within the application. Basically Im
wondering can 2 or 3 forms be sent out via cfmail for certain benefit
selections an employee has made within our benefit selection system for our
annual enrollment process. I found 1 site referencing cfmailparam.  Can I
assume that the cfmailparam could be dynamically populated to pull the
forms we needed.

Thanks!
Casey Cook


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: CFMail - Multiple Attachments

[S . Isaac Dealey]

 Hello,

 I would think this is an easy question, but I have not
 easily found the
 answer yet. Is it possible to send multiple attachments
 out with cfmail,
 and can the number of attachments and attachment names be
 dynamically
 determined based on user selections within the
 application. Basically Im
 wondering can 2 or 3 forms be sent out via cfmail for
 certain benefit
 selections an employee has made within our benefit
 selection system for our
 annual enrollment process. I found 1 site referencing
 cfmailparam.  Can I
 assume that the cfmailparam could be dynamically populated
 to pull the
 forms we needed.

 Thanks!
 Casey Cook

Absolutely ... here's some pseudocode

cfquery name=rsSelected
SELECT benefits.FileName FROM benefits
INNER JOIN employee_benefits ON
( employee_benefits.employeeid = #employeeid# )
/cfquery

cfset variables.sourcefolder = c:\benefitsfiles

cfmail ...
cfloop query=rsSelected
cfmailparam file=#variables.sourcefolder#/#rsSelected.FileName#
/cfloop
/cfmail

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: CFMail - Multiple Attachments

[Casey C Cook]

Perfect. Thanks a bunch Isaac. Just needed a confirmation before providing
an estimate on amount of time needed to build the functionality.

CC


   

  S. Isaac

  Dealey infoTo:  CF-Talk 
[EMAIL PROTECTED]
  @turnkey.to cc: 

   Subject: Re: CFMail - Multiple 
Attachments  
  12/19/02 12:53   

  PM   

  Please respond   

  to cf-talk   

   

   





 Hello,

 I would think this is an easy question, but I have not
 easily found the
 answer yet. Is it possible to send multiple attachments
 out with cfmail,
 and can the number of attachments and attachment names be
 dynamically
 determined based on user selections within the
 application. Basically Im
 wondering can 2 or 3 forms be sent out via cfmail for
 certain benefit
 selections an employee has made within our benefit
 selection system for our
 annual enrollment process. I found 1 site referencing
 cfmailparam.  Can I
 assume that the cfmailparam could be dynamically populated
 to pull the
 forms we needed.

 Thanks!
 Casey Cook

Absolutely ... here's some pseudocode

cfquery name=rsSelected
 SELECT benefits.FileName FROM benefits
 INNER JOIN employee_benefits ON
 ( employee_benefits.employeeid = #employeeid# )
/cfquery

cfset variables.sourcefolder = c:\benefitsfiles

cfmail ...
 cfloop query=rsSelected
 cfmailparam file=
#variables.sourcefolder#/#rsSelected.FileName#
 /cfloop
/cfmail

s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: CFMail - Multiple Attachments

[Pablo Varando]

Here's a tutorial on this also:

http://tutorial27.easycfm.com/


Pablo

  I would think this is an easy question, but I have not
  easily found the
  answer yet. Is it possible to send multiple attachments
  out with cfmail,
  and can the number of attachments and attachment names be
  dynamically
  determined based on user selections within the
  application. Basically Im
  wondering can 2 or 3 forms be sent out via cfmail for
  certain benefit
  selections an employee has made within our benefit
  selection system for our
  annual enrollment process. I found 1 site referencing
  cfmailparam.  Can I
  assume that the cfmailparam could be dynamically populated
  to pull the
  forms we needed.
 
  Thanks!
  Casey Cook
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

ColdFusion and DDE

[Jacob]

Is it possible to use DDE links in ColdFusion?

Jacob

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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

Re: CFMail - Multiple Attachments

[S . Isaac Dealey]

Welcome. :)

 Perfect. Thanks a bunch Isaac. Just needed a confirmation
 before providing
 an estimate on amount of time needed to build the
 functionality.

 CC



   S. Isaac
   Dealey infoTo:
   CF-Talk [EMAIL PROTECTED]
   @turnkey.to cc:
Subject:
Re: CFMail
- Multiple
Attachments
   12/19/02 12:53
   PM
   Please respond
   to cf-talk






 Hello,

 I would think this is an easy question, but I have not
 easily found the
 answer yet. Is it possible to send multiple attachments
 out with cfmail,
 and can the number of attachments and attachment names be
 dynamically
 determined based on user selections within the
 application. Basically Im
 wondering can 2 or 3 forms be sent out via cfmail for
 certain benefit
 selections an employee has made within our benefit
 selection system for our
 annual enrollment process. I found 1 site referencing
 cfmailparam.  Can I
 assume that the cfmailparam could be dynamically
 populated
 to pull the
 forms we needed.

 Thanks!
 Casey Cook

 Absolutely ... here's some pseudocode

 cfquery name=rsSelected
  SELECT benefits.FileName FROM benefits
  INNER JOIN employee_benefits ON
  ( employee_benefits.employeeid = #employeeid#
  )
 /cfquery

 cfset variables.sourcefolder = c:\benefitsfiles

 cfmail ...
  cfloop query=rsSelected
  cfmailparam file=
 #variables.sourcefolder#/#rsSelected.FileName#
  /cfloop
 /cfmail

 s. isaac dealey954-776-0046

 new epoch  http://www.turnkey.to

 lead architect, tapestry cms   http://products.turnkey.to

 certified advanced coldfusion 5 developer
 http://www.macromedia.com/v1/handlers/index.cfm?ID=21816



 ~~
 ~~~|
 Archives:
 http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
 Subscription: http://www.houseoffusion.com/cf_lists/index.
 cfm?method=subscribeforumid=4
 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
 Structure your ColdFusion code with Fusebox. Get the
 official book at http://www.fusionauthority.com/bkinfo.cfm


s. isaac dealey954-776-0046

new epoch  http://www.turnkey.to

lead architect, tapestry cms   http://products.turnkey.to

certified advanced coldfusion 5 developer
http://www.macromedia.com/v1/handlers/index.cfm?ID=21816


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: ColdFusion and DDE

[Ben Doom]

Um...
Are you referring to Windows Drag'n'drop?  If so, that's going to be
browser-dependent unless you are talking about CFStudio.  And, to be honest,
I can't really think of anything you could dnd to a CF page except file
uploads.

If that's not what you're talking about then I'm lost anyway.  :-)



  --Ben Doom
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: Jacob [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, December 19, 2002 2:03 PM
: To: CF-Talk
: Subject: ColdFusion and DDE
:
:
: Is it possible to use DDE links in ColdFusion?
:
: Jacob
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribeforumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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