Re: OT: HTML Question

2003-01-07 Thread Jochem van Dieten
paul smith wrote:
 Page displays fine in IE
 
 Page does not display in Netscape unless I put TABLE border  0
 
 Tables are involved, but no missing TABLE/TR/TD tags.

Did you try http://validator.w3.org
What is the URL?

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
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Got an opinion on MM Contribute?

2003-01-07 Thread Robertson-Ravo, Neil (RX)
Contribute is far more stable that using ActiveEdit and indeed is better,
but ActiveEdit is far better at editing Dynamic data as it can pass it back
into the Datasource - this is where Contribute falls down.

-Original Message-
From: samcfug [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2003 22:37
To: CF-Talk
Subject: Re: Got an opinion on MM Contribute?


The sites I create use ActiveEdit which allows the client to log in and add
images, links, some formatting and the text content.  This does not affect
the
underlying code.

That considered, I find no use for Contribute in my operation.

=
Douglas White
group Manager
mailto:[EMAIL PROTECTED]
http://www.samcfug.org
=
- Original Message -
From: Matt Brown [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Monday, January 06, 2003 4:15 PM
Subject: Re: Got an opinion on MM Contribute?


| At 12:10 PM 1/6/2003 -0500, you wrote:
| a little pricey per seat.  How does it work?
| 
| Wouldn't something like CommonSpot be better/cheaper?
|
| Actually, $99 per seat is pretty good for a lot of organizations. Remember
| that CT is not a content management system in the vein that one here would
| construct one. It is a content editor in the static HTML of a file. If
your
| pages are all made up dynamically, there is still plenty it is good for,
| but it won't be your CMS for the site. I think the way to look at it is
| that it is for getting the enduser out of your hair if you don't have the
| contract for a full CMS.
|
| _
|
| Matt Brown   Dreamweaver and Contribute Community Manager
| Macromedia  (415) 706-6543   [EMAIL PROTECTED]
| The Dreamweaver Blog:   http://shorterlink.com/?KB8LAL
| Developer Resource Kit Volume 2: http://www.macromedia.com/software/drk/
|
|
|
| 

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFFILE Workarounds?

2003-01-07 Thread Robert Bailey
 
I can use CFExecute on my host. But the file I create I need to read it
into a variable, but CFFILE does not seem to work as it throws an error
saying it exceeded the allotted time limit, so I am guessing they shut
this off, but kept CFExecute. Well, here is my question: Can I read the
contents of this file into a variable without using CFFile? 
 
Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com


---
[This E-mail scanned for viruses]

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Got an opinion on MM Contribute?

2003-01-07 Thread Wayne Putterill
To be fair, I don't think he is the only one who's missing something, I have
been looking at Contribute with a puzzled expression since I heard about it.

From following this discussion it seems like its for:

Companies who regularly need to make changes to their site but won't go to a
CMS or cheap DB driven site, and have users who they trust to add unapproved
content to the site, but don't trust to leave non-content areas of a page
alone.

Does that sum it up?


- Original Message -
From: Dave Watts [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 5:13 AM
Subject: RE: Got an opinion on MM Contribute?


  Users can do that with a free application such as Netscape
  Composer and many other HTML editors, also free.
 
  I could not imagine making my clients purchase an editor
  which would require me to give them a permission key from
  DreamweaverMX, when I can do that simple via folder permissions..
 
  Maybe I am missing something here.

 I think you are missing something, if you don't mind me saying so.

 If you're working with a static site, and you want non-technical people to
 contribute content to that site, Contribute allows you to do that much
 easier than any other (free or not-free) HTML editor.

 Typically, you don't want non-technical content contributors dealing with
 HTML formatting any more than necessary, and you want them to place their
 content within a site format that you've already created. By creating
 templates in Dreamweaver, you can control the layout of specific pages
 created or edited in Contribute. This is quite a bit different than simply
 limiting what a user can do in a folder - instead, you're limiting users
to
 publishing using an existing approved format.

 For this use, I don't think there's anything comparable to Contribute out
 there, at any price point. This makes the $99 per seat cost look very
small
 to me. My biggest reservation about Contribute is that I'm not keen on the
 idea of a static HTML site - I'd much rather see content stored within a
 database. But, if an organization isn't ready to implement a real,
 database-driven CMS, and will be using a static HTML site, I'd strongly
 recommend looking at a Contribute/Dreamweaver solution - site designers
 would use Dreamweaver to create and edit templates, and content
contributers
 would use Contribute.

 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 phone: 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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFFILE Workarounds?

2003-01-07 Thread Jon Hall
Depending on the version of CF and OS, different ways would be
preferable. Assuming they haven't disabled cfobject though, using the
Scripting.FileSystemObject (GetFile() or OpenTextFile()), or
java.io.FileReader will both work.

http://java.sun.com/j2se/1.4/docs/api/java/io/FileReader.html
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbenlr98/html/vamthgetfile.asp

I have some code examples for both methods somewhere. If you would
want to see them let me know.

-- 
jon
mailto:[EMAIL PROTECTED]

Tuesday, January 7, 2003, 4:57:00 AM, you wrote:

 
RB I can use CFExecute on my host. But the file I create I need to read it
RB into a variable, but CFFILE does not seem to work as it throws an error
RB saying it exceeded the allotted time limit, so I am guessing they shut
RB this off, but kept CFExecute. Well, here is my question: Can I read the
RB contents of this file into a variable without using CFFile? 
 
RB Robert Bailey
RB [EMAIL PROTECTED]
RB Famous for nothing!
RB http://www.tinetics.com

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Got an opinion on MM Contribute?

2003-01-07 Thread Kennerly, Rick H CIV
Thanks for all the replies and insight.  

I imagine this intranet project I'm working on is like a lot of projects, a
mix of static pages and dynamic content.  

The community is medical (but not real tech savvy, particularly at the lower
levels) with lots of committees, minutes and reports (the main use I saw for
Contribute was secretaries publishing committee reports, minutes,  research
results from Word .docs in a standard format that is both a good display but
also printer ready).   

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
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



newbie: help with sql query

2003-01-07 Thread Azeem Huda
Hi,

I have the following query and was hoping that someone could help me out.
I am trying to retrieve a field named bug_type in another table (bug_type)
IF the bugs.bug_type_id != 0 (since i know that bug_type.bug_type_id does
not exist). Conversely if bugs.bug_type_id = 0 then simply add that
statement to the query. .

cfquery datasource=#variables.DSName# name=bug_details

SELECT  bugs.bug_id, bugs.bug_type_id, bugs.bug_site_id,
bugs.bug_section_id,
etc etc
FROMbugs, bug_site, etc etc
WHERE   bug_site.bug_site_id = bugs.bug_site_id
AND bug_status.bug_status_id = bugs.status_id
AND priority.priority_id = bugs.priority_id
AND (IF bug_type_id !=0
bug_type IN
(SELECT bug_type, bug_type_id
FROMbug_type
WHERE   bug_type.bug_type_id = bugs.bug_type_id)
ELSE bug_type_id =0)

/cfquery


Furthermore, i have noticed that if i do manage to get some hybrid of the
statement to work, i cannot reference the inner statement variable
#bug_type# when i try to output it to the table as shown below.

cfoutput query=bug_details


td#bug_details.currentrow#/td
cfif #bug_type_id# neq 0
td width=100#bug_type#nbsp;/td
cfelseif #bug_type_id# eq 0
td width=100Unknown/td
/cfif
td width=120#bug_site#nbsp;/td
etc etc



~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Net Send

2003-01-07 Thread Paul Wilson
I'm using it to notify people when an email system is not working. I might use it for 
evil purposes later

-Original Message-
From: Nick McClure [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2003 15:36
To: CF-Talk
Subject: RE: Net Send


No using what you have learned for evil. :)

 -Original Message-
 From: Paul Wilson [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 06, 2003 10:20 AM
 To: CF-Talk
 Subject: RE: Net Send
 
 cfexecute name=c:\winnt\system32\cmd.exe /c arguments=net send
user
 message/cfexecute
 
 you need '/c'
 
 -Original Message-
 From: Paul Wilson
 Sent: 06 January 2003 15:12
 To: CF-Talk
 Subject: Net Send
 
 
 Anyone know how to do a net send using cfexecute?
 
 Cheers
 
 

~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Replacing characters in a string

2003-01-07 Thread Ryan Mitchell
This should be a simple enough one...

I have a credit card number, 16 digits long, and I want to star (*) out the
middle 8. How do I do this?

TIA
Ryan


~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Replacing characters in a string

2003-01-07 Thread Robertson-Ravo, Neil (RX)
take the numberread the first 8 numbers and the output them with
hardcoded *'s.

 simple

Or do you mean by Javascript as they type?

N

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 12:56
To: CF-Talk
Subject: Replacing characters in a string


This should be a simple enough one...

I have a credit card number, 16 digits long, and I want to star (*) out the
middle 8. How do I do this?

TIA
Ryan



~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Replacing characters in a string

2003-01-07 Thread Ryan Mitchell
Nope, I mean by a cf method.
Ill give this a go thanks,
Ryan

On 7/1/03 12:55, Robertson-Ravo, Neil (RX)
[EMAIL PROTECTED] wrote:

 take the numberread the first 8 numbers and the output them with
 hardcoded *'s.
 
 simple
 
 Or do you mean by Javascript as they type?
 
 N
 
 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
 Sent: 07 January 2003 12:56
 To: CF-Talk
 Subject: Replacing characters in a string
 
 
 This should be a simple enough one...
 
 I have a credit card number, 16 digits long, and I want to star (*) out the
 middle 8. How do I do this?
 
 TIA
 Ryan
 
 
 
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Replacing characters in a string

2003-01-07 Thread Pascal Peters
Insert(,RemoveChars(ccnumber,5,8),4)

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] 
Sent: dinsdag 7 januari 2003 13:56
To: CF-Talk
Subject: Replacing characters in a string


This should be a simple enough one...

I have a credit card number, 16 digits long, and I want to star (*) out
the middle 8. How do I do this?

TIA
Ryan



~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: newbie: help with sql query

2003-01-07 Thread Jochem van Dieten
Azeem Huda wrote:
 
 I have the following query and was hoping that someone could help me out.
 I am trying to retrieve a field named bug_type in another table (bug_type)
 IF the bugs.bug_type_id != 0 (since i know that bug_type.bug_type_id does
 not exist). Conversely if bugs.bug_type_id = 0 then simply add that
 statement to the query.

if .. then .. else .. endif in SQL is:
CASE WHEN .. THEN .. [WHEN .. THEN ..] [ELSE ..] END


 cfquery datasource=#variables.DSName# name=bug_details
 
 SELECTbugs.bug_id, bugs.bug_type_id, bugs.bug_site_id,
 bugs.bug_section_id,
   etc etc
 FROM  bugs, bug_site, etc etc
 WHERE bug_site.bug_site_id = bugs.bug_site_id
 AND   bug_status.bug_status_id = bugs.status_id
 AND   priority.priority_id = bugs.priority_id
 AND   (IF bug_type_id !=0
   bug_type IN
   (SELECT bug_type, bug_type_id
   FROMbug_type
   WHERE   bug_type.bug_type_id = bugs.bug_type_id)
   ELSE bug_type_id =0)
 
 /cfquery

If I understand your intentions correctly it should be (presuming that 
bug_type is a varchar field):

SELECT  bugs.bug_id,
 bugs.bug_site_id, bugs.bug_section_id,
 etc etc,
 CASE WHEN bugs.bug_type_id = 0 THEN CAST(0 AS VARCHAR)
  ELSE bug_type.bug_type
 END
FROMbug_site, etc etc,
 bugs NATURAL JOIN bug_type
WHERE   bug_site.bug_site_id = bugs.bug_site_id
 ANDbug_status.bug_status_id = bugs.status_id
 ANDpriority.priority_id = bugs.priority_id


If there is no entry in the bug_type table for bug_type_id = 0 this becomes:
SELECT  bugs.bug_id,
 bugs.bug_site_id, bugs.bug_section_id,
 etc etc,
 CASE WHEN bugs.bug_type_id = 0 THEN CAST(0 AS VARCHAR)
 ELSE bug_type.bug_type
 END
FROMbug_site, etc etc,
 bugs LEFT JOIN bug_type
 ON bug_type.bug_type_id = bugs.bug_type_id
WHERE   bug_site.bug_site_id = bugs.bug_site_id
 AND bug_status.bug_status_id = bugs.status_id
 AND priority.priority_id = bugs.priority_id

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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Replacing characters in a string

2003-01-07 Thread Everett, Al
cfset maskedCCnumber=Left(CCnumber,4)  RepeatString(*,8) 
right(CCnumber,4)


Remember: Amex numbers are 15 digits long.

 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 7:56 AM
 To: CF-Talk
 Subject: Replacing characters in a string
 
 
 This should be a simple enough one...
 
 I have a credit card number, 16 digits long, and I want to 
 star (*) out the
 middle 8. How do I do this?
 
 TIA
 Ryan
 
 
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Got an opinion on MM Contribute?

2003-01-07 Thread Candace Cottrell
Rick, as I work in a hospital, we looked at this as an option as well,
but found that it didn't fit our needs for a lot of things. However, we
do plan to use it on the website, but we plan to use either M$ CMS or
Commonspot on our intranet.
 
I've been building a lot of active edit areas to tide us over, but I am
just way too overwhelmed to have to do this everytime somoene wants to
add something, as I am the only webber in an organization of 1500
users.
 
I have, however, suggested Contribute to some of my pals at home who I
have made templates for for book clubs, etc. I found that I needed to
buy a copy of CT myself because they were having so many problems that I
needed to be able to walk them through things. The DW updater did help a
little, but it crashes my machine when I try to use the CT stuff.
 
Ok, I am rambling..
 
 
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 1/7/2003 7:52:09 AM 
Thanks for all the replies and insight.  

I imagine this intranet project I'm working on is like a lot of
projects, a
mix of static pages and dynamic content.  

The community is medical (but not real tech savvy, particularly at the
lower
levels) with lots of committees, minutes and reports (the main use I
saw for
Contribute was secretaries publishing committee reports, minutes, 
research
results from Word .docs in a standard format that is both a good
display but
also printer ready).   

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
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: newbie: help with sql query

2003-01-07 Thread Azeem Huda
Jochem,

When i updated my query to your second version below i get:

Syntax error (missing operator) in query expression 'CASE WHEN
bugs.bug_type_id = 0 THEN CAST (0 AS VARCHAR) ELSE bug_type.bug_type'.

Can you explain CAST (0 AS VARCHAR). Btw, at this stage of development i
am using Access2000 but will be changing to SQL2000 soon, so the bug_type
field is simply text.
Thanks again.








-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 13:07
To: CF-Talk
Subject: Re: newbie: help with sql query


Azeem Huda wrote:

 I have the following query and was hoping that someone could help me out.
 I am trying to retrieve a field named bug_type in another table (bug_type)
 IF the bugs.bug_type_id != 0 (since i know that bug_type.bug_type_id does
 not exist). Conversely if bugs.bug_type_id = 0 then simply add that
 statement to the query.

if .. then .. else .. endif in SQL is:
CASE WHEN .. THEN .. [WHEN .. THEN ..] [ELSE ..] END


 cfquery datasource=#variables.DSName# name=bug_details

 SELECTbugs.bug_id, bugs.bug_type_id, bugs.bug_site_id,
 bugs.bug_section_id,
   etc etc
 FROM  bugs, bug_site, etc etc
 WHERE bug_site.bug_site_id = bugs.bug_site_id
 AND   bug_status.bug_status_id = bugs.status_id
 AND   priority.priority_id = bugs.priority_id
 AND   (IF bug_type_id !=0
   bug_type IN
   (SELECT bug_type, bug_type_id
   FROMbug_type
   WHERE   bug_type.bug_type_id = bugs.bug_type_id)
   ELSE bug_type_id =0)

 /cfquery

If I understand your intentions correctly it should be (presuming that
bug_type is a varchar field):

SELECT  bugs.bug_id,
 bugs.bug_site_id, bugs.bug_section_id,
 etc etc,
 CASE WHEN bugs.bug_type_id = 0 THEN CAST(0 AS VARCHAR)
  ELSE bug_type.bug_type
 END
FROMbug_site, etc etc,
 bugs NATURAL JOIN bug_type
WHERE   bug_site.bug_site_id = bugs.bug_site_id
 ANDbug_status.bug_status_id = bugs.status_id
 ANDpriority.priority_id = bugs.priority_id


If there is no entry in the bug_type table for bug_type_id = 0 this becomes:
SELECT  bugs.bug_id,
 bugs.bug_site_id, bugs.bug_section_id,
 etc etc,
 CASE WHEN bugs.bug_type_id = 0 THEN CAST(0 AS VARCHAR)
 ELSE bug_type.bug_type
 END
FROMbug_site, etc etc,
 bugs LEFT JOIN bug_type
 ON bug_type.bug_type_id = bugs.bug_type_id
WHERE   bug_site.bug_site_id = bugs.bug_site_id
 AND bug_status.bug_status_id = bugs.status_id
 AND priority.priority_id = bugs.priority_id

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Got an opinion on MM Contribute?

2003-01-07 Thread Robertson-Ravo, Neil (RX)
Jeezo, you must have ALOT of money if you are planning to use MSCMS or
CommonSpot.

Have you thought about NQContent? its actually pretty good, but the
documentation is v.poor.

N
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 13:34
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?


Rick, as I work in a hospital, we looked at this as an option as well,
but found that it didn't fit our needs for a lot of things. However, we
do plan to use it on the website, but we plan to use either M$ CMS or
Commonspot on our intranet.
 
I've been building a lot of active edit areas to tide us over, but I am
just way too overwhelmed to have to do this everytime somoene wants to
add something, as I am the only webber in an organization of 1500
users.
 
I have, however, suggested Contribute to some of my pals at home who I
have made templates for for book clubs, etc. I found that I needed to
buy a copy of CT myself because they were having so many problems that I
needed to be able to walk them through things. The DW updater did help a
little, but it crashes my machine when I try to use the CT stuff.
 
Ok, I am rambling..
 
 
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 1/7/2003 7:52:09 AM 
Thanks for all the replies and insight.  

I imagine this intranet project I'm working on is like a lot of
projects, a
mix of static pages and dynamic content.  

The community is medical (but not real tech savvy, particularly at the
lower
levels) with lots of committees, minutes and reports (the main use I
saw for
Contribute was secretaries publishing committee reports, minutes, 
research
results from Word .docs in a standard format that is both a good
display but
also printer ready).   

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
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Got an opinion on MM Contribute?

2003-01-07 Thread Candace Cottrell
Yeah, or hire me some help, huh!!!  rofl
 
M$ has offered to come in and do a proof of concept. They are also
adamantly saying that the fact we use CF will not matter. We aren't
bound to buying it, and I actually prefer Commonspot because of the fact
that I can extend it with CF. Although, I guess it wouldn't be a bad
thing to learn how to do things in ASP, just a lot more time consuming,
and time, I don't have.
 
I'll defintiely check our NQ content. Thanks for the heads up!
 
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 1/7/2003 8:38:25 AM 
Jeezo, you must have ALOT of money if you are planning to use MSCMS or
CommonSpot.

Have you thought about NQContent? its actually pretty good, but the
documentation is v.poor.

N
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]] 
Sent: 07 January 2003 13:34
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?


Rick, as I work in a hospital, we looked at this as an option as well,
but found that it didn't fit our needs for a lot of things. However,
we
do plan to use it on the website, but we plan to use either M$ CMS or
Commonspot on our intranet.

I've been building a lot of active edit areas to tide us over, but I
am
just way too overwhelmed to have to do this everytime somoene wants to
add something, as I am the only webber in an organization of 1500
users.

I have, however, suggested Contribute to some of my pals at home who I
have made templates for for book clubs, etc. I found that I needed to
buy a copy of CT myself because they were having so many problems that
I
needed to be able to walk them through things. The DW updater did help
a
little, but it crashes my machine when I try to use the CT stuff.

Ok, I am rambling..



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


[EMAIL PROTECTED] 

 [EMAIL PROTECTED] 1/7/2003 7:52:09 AM 
Thanks for all the replies and insight.  

I imagine this intranet project I'm working on is like a lot of
projects, a
mix of static pages and dynamic content.  

The community is medical (but not real tech savvy, particularly at the
lower
levels) with lots of committees, minutes and reports (the main use I
saw for
Contribute was secretaries publishing committee reports, minutes, 
research
results from Word .docs in a standard format that is both a good
display but
also printer ready).   

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
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Got an opinion on MM Contribute?

2003-01-07 Thread Robertson-Ravo, Neil (RX)
:-) MSCMS is very, very expensive.

-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 13:48
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?


Yeah, or hire me some help, huh!!!  rofl
 
M$ has offered to come in and do a proof of concept. They are also
adamantly saying that the fact we use CF will not matter. We aren't
bound to buying it, and I actually prefer Commonspot because of the fact
that I can extend it with CF. Although, I guess it wouldn't be a bad
thing to learn how to do things in ASP, just a lot more time consuming,
and time, I don't have.
 
I'll defintiely check our NQ content. Thanks for the heads up!
 
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 1/7/2003 8:38:25 AM 
Jeezo, you must have ALOT of money if you are planning to use MSCMS or
CommonSpot.

Have you thought about NQContent? its actually pretty good, but the
documentation is v.poor.

N
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]] 
Sent: 07 January 2003 13:34
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?


Rick, as I work in a hospital, we looked at this as an option as well,
but found that it didn't fit our needs for a lot of things. However,
we
do plan to use it on the website, but we plan to use either M$ CMS or
Commonspot on our intranet.

I've been building a lot of active edit areas to tide us over, but I
am
just way too overwhelmed to have to do this everytime somoene wants to
add something, as I am the only webber in an organization of 1500
users.

I have, however, suggested Contribute to some of my pals at home who I
have made templates for for book clubs, etc. I found that I needed to
buy a copy of CT myself because they were having so many problems that
I
needed to be able to walk them through things. The DW updater did help
a
little, but it crashes my machine when I try to use the CT stuff.

Ok, I am rambling..



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


[EMAIL PROTECTED] 

 [EMAIL PROTECTED] 1/7/2003 7:52:09 AM 
Thanks for all the replies and insight.  

I imagine this intranet project I'm working on is like a lot of
projects, a
mix of static pages and dynamic content.  

The community is medical (but not real tech savvy, particularly at the
lower
levels) with lots of committees, minutes and reports (the main use I
saw for
Contribute was secretaries publishing committee reports, minutes, 
research
results from Word .docs in a standard format that is both a good
display but
also printer ready).   

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: newbie: help with sql query

2003-01-07 Thread Jochem van Dieten
Azeem Huda wrote:
 
 Syntax error (missing operator) in query expression 'CASE WHEN
 bugs.bug_type_id = 0 THEN CAST (0 AS VARCHAR) ELSE bug_type.bug_type'.

Sounds like your database does not have support for CASE statements. You 
need to check the manual for some other type of IF support.


 Can you explain CAST (0 AS VARCHAR). Btw, at this stage of development i
 am using Access2000 but will be changing to SQL2000 soon, so the bug_type
 field is simply text.

The normal datatype of 0 is some numberic type. But bug_type is some 
text type. Since they will be in the same column, their datatype *has* 
to be the same. CAST() will override the default datatype and cast it to 
some other datatype so they are the same.
But again, I am not sure if your database supports the cast statement.

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: newbie: help with sql query

2003-01-07 Thread Robertson-Ravo, Neil (RX)
CAST also, cannot convert or change the datatype of certain datatypes to
others, there are some limitations to it.

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 13:51
To: CF-Talk
Subject: Re: newbie: help with sql query


Azeem Huda wrote:
 
 Syntax error (missing operator) in query expression 'CASE WHEN
 bugs.bug_type_id = 0 THEN CAST (0 AS VARCHAR) ELSE bug_type.bug_type'.

Sounds like your database does not have support for CASE statements. You 
need to check the manual for some other type of IF support.


 Can you explain CAST (0 AS VARCHAR). Btw, at this stage of development i
 am using Access2000 but will be changing to SQL2000 soon, so the bug_type
 field is simply text.

The normal datatype of 0 is some numberic type. But bug_type is some 
text type. Since they will be in the same column, their datatype *has* 
to be the same. CAST() will override the default datatype and cast it to 
some other datatype so they are the same.
But again, I am not sure if your database supports the cast statement.

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFGRID (from CF 4.5) with Latest Java Plug In?

2003-01-07 Thread Cutter (CF_Talk)
We ran into the same problem with the CFTREE component. It only appears 
to affect systems utilizing the latest Java Plug-in. All works fine with 
the MS VM.

Cutter

Jim Davis wrote:

As I'm sure some of you know the Grid applet used in CF 4.5 doesn't work
with the latest Java Plug-in.  I've been unable to find a MM patch for
the problem.

I'd be interested in ideas for addressing the problem.  I've found what
looks like a servicable replacement, but runs $400.  This isn't that
bad, but is still going to be seen as ColdFusion incurred expense -
It'd be nice to be able to top-spin this into a CF upgrade, but no
money, no way, no how.

Any other grid controls?  Anybody find a MM solution?  Any ideas?

Thanks in advance,

Jim Davis



~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFFILE Workarounds?

2003-01-07 Thread Christian Cantrell
If the file is in your web root, you could use cfhttp.

Christian

On Tuesday, January 7, 2003, at 04:57 AM, Robert Bailey wrote:


 I can use CFExecute on my host. But the file I create I need to read it
 into a variable, but CFFILE does not seem to work as it throws an error
 saying it exceeded the allotted time limit, so I am guessing they shut
 this off, but kept CFExecute. Well, here is my question: Can I read the
 contents of this file into a variable without using CFFile?

 Robert Bailey
 [EMAIL PROTECTED]
 Famous for nothing!
 http://www.tinetics.com


 ---
 [This E-mail scanned for viruses]

 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: newbie: help with sql query

2003-01-07 Thread Pascal Peters
If you are on access, the outer join won't work and you have to do a
union:

SELECT bugs.bug_id, bugs.bug_site_id, 
   bugs.bug_section_id, bug_type.bug_type, 
   etc etc
FROM   bugs, bug_site, bug_type, etc etc
WHERE  bug_site.bug_site_id = bugs.bug_site_id
  AND  bug_status.bug_status_id = bugs.status_id
  AND  priority.priority_id = bugs.priority_id
  AND  bug_type.bug_type_id = bugs.bug_type_id
  AND  bugs.bug_type_id  0
UNION
SELECT bugs.bug_id, bugs.bug_site_id, 
   bugs.bug_section_id, '' AS bug_type, 
   etc etc
FROM   bugs, bug_site, etc etc
WHERE  bug_site.bug_site_id = bugs.bug_site_id
  AND  bug_status.bug_status_id = bugs.status_id
  AND  priority.priority_id = bugs.priority_id
  AND  bugs.bug_type_id = 0

If ther is no bug_type.bug_type_id equal to 0, you can leave out the
line:
  AND  bugs.bug_type_id  0

-Original Message-
From: Azeem Huda [mailto:[EMAIL PROTECTED]] 
Sent: dinsdag 7 januari 2003 14:35
To: CF-Talk
Subject: RE: newbie: help with sql query


Jochem,

When i updated my query to your second version below i get:

Syntax error (missing operator) in query expression 'CASE WHEN
bugs.bug_type_id = 0 THEN CAST (0 AS VARCHAR) ELSE bug_type.bug_type'.

Can you explain CAST (0 AS VARCHAR). Btw, at this stage of development
i am using Access2000 but will be changing to SQL2000 soon, so the
bug_type field is simply text. Thanks again.



~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFFILE Workarounds?

2003-01-07 Thread Pascal Peters
If you can include it AND there is no cfm in the page, you could do:

cfsavecontent variable=myvarcfinclude template=path to
file/cfsavecontent

-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: dinsdag 7 januari 2003 10:57
To: CF-Talk
Subject: CFFILE Workarounds?


 
I can use CFExecute on my host. But the file I create I need to read it
into a variable, but CFFILE does not seem to work as it throws an error
saying it exceeded the allotted time limit, so I am guessing they shut
this off, but kept CFExecute. Well, here is my question: Can I read the
contents of this file into a variable without using CFFile? 
 
Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com


---
[This E-mail scanned for viruses]


~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Got an opinion on MM Contribute?

2003-01-07 Thread Steve Drucker
Well, I think you need to quantify A LOT

I've actually reviewed both products extensively (The CFDJ CommonSpot review
is located here: http://www.sys-con.com/coldfusion/articlea.cfm?id=520).
Dave Watts and I are collaborating on a MSCMS review.

In the case of CommonSpot, the entry point starts around $20K for ten
dedicated content contributors.  Microsoft Content Management Server starts
at $40K, licensed by CPU.  So, there is a significant difference in
licensing models -- and upfront cost.

The fact is, though, that CommonSpot is as close to an out of the box
solution as I have seen in a CMS package -- meaning that not much additional
programming is required (generally) to deploy a feature-rich site.  We've
been quite successful with deploying CommonSpot with low and mid-range
customers (check out http://www.heritage.org, http://www.ndm.edu/,
http://www.ceworld.org , http://www.usbg.gov ) and even use it internally
for our own sites (http://training.figleaf.com)

Microsoft CMS more closely resembles a framework (a la Spectra).  So
there's a huge developer API that you can take advantage of, but be prepared
to write A LOT of .NET code to get very far (thus adding more to the total
cost of ownership).  The principal advantages of MSCMS arise when you adopt
the entire MS platform including Win2K, SQL Server, SharePoint and MS
Commerce Server.  Microsoft is continuing to build on these integration
points which may ultimately lead to a compelling total integrated
enterprise CMS solution.  They've still got quite a bit of work to
do...but it's clear that this is where they're headed.

So, the real question is -- what are your present and projected future CMS
requirements?  Will CommonSpot fit the bill?  If so, it should definitely be
less expensive over the short-term.  If your organization is planning on
completely standardizing on the MS server suite, then MSCMS is probably a
better choice -- but make sure you add .NET developer training into your
budget -- and get ready to drink the .NET Kool-aid!

 
Regards,
Steve Drucker
CEO
Fig Leaf Software
www.figleaf.com
1-877-FIG-LEAF


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 8:38 AM
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?

Jeezo, you must have ALOT of money if you are planning to use MSCMS or
CommonSpot.

Have you thought about NQContent? its actually pretty good, but the
documentation is v.poor.

N
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 13:34
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?


Rick, as I work in a hospital, we looked at this as an option as well,
but found that it didn't fit our needs for a lot of things. However, we
do plan to use it on the website, but we plan to use either M$ CMS or
Commonspot on our intranet.
 
I've been building a lot of active edit areas to tide us over, but I am
just way too overwhelmed to have to do this everytime somoene wants to
add something, as I am the only webber in an organization of 1500
users.
 
I have, however, suggested Contribute to some of my pals at home who I
have made templates for for book clubs, etc. I found that I needed to
buy a copy of CT myself because they were having so many problems that I
needed to be able to walk them through things. The DW updater did help a
little, but it crashes my machine when I try to use the CT stuff.
 
Ok, I am rambling..
 
 
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 1/7/2003 7:52:09 AM 
Thanks for all the replies and insight.  

I imagine this intranet project I'm working on is like a lot of
projects, a
mix of static pages and dynamic content.  

The community is medical (but not real tech savvy, particularly at the
lower
levels) with lots of committees, minutes and reports (the main use I
saw for
Contribute was secretaries publishing committee reports, minutes, 
research
results from Word .docs in a standard format that is both a good
display but
also printer ready).   

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
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFPOP and attachments

2003-01-07 Thread Thane Sherrington
I'm using CFPOP to grab mail, but I can't get the queryname.attachments 
columnname.  It keeps telling me that the column attachments is not 
available in the query.  Does the column name not exist if there isn't an 
attachment?

T

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



OT: Flash Comm Server Demo now online

2003-01-07 Thread Steve Drucker
WysiDraw CommServer edition now available online - now with a live demo!
http://products.figleaf.com

What is WysiDraw?
WysiDraw is the first of series of Flash MX components being developed by
Fig Leaf Software.

Using WysiDraw, you can add image annotation capabilities to your web-based
applications. End-users may add lines, text, scribbles,  and other geometric
forms that sit in layers on top of a background JPEG image.

Because the component was developed using Flash MX from Macromedia, It is
x-browser compatible with any device running the Flash 6 player and can
interface with any application server, including ColdFusion 5/MX. 

Two editions of WysiDraw are currently available -- the HTML edition, 
which allows you embed a draw area within an HTML form and a Flash Component
edition that supports real-time whiteboard functionality when paired with
the Macromedia Flash Communications Server.

Have fun!

Regards,
Steve Drucker
CEO
Fig Leaf Software
www.figleaf.com
1-877-FIG-LEAF

~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Got an opinion on MM Contribute?

2003-01-07 Thread Robertson-Ravo, Neil (RX)
Yep, I was kinda gearing the answer to the MSCMS side of things as, like you
mentioned...MSCMS starts at 

$42,999 per processor and if you couple that with the required software of
$1,199 for Window Server, or $3,999 for advanced server (this is only for 25
access licenses), you have then got $4,999 for SQL server you are looking at
$50K just to get off the ground AND THATS NOT RUNNING,

You will have to do a lot of .NET and special MS specific stuff to get off
the ground

N

-Original Message-
From: Steve Drucker [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 14:22
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?


Well, I think you need to quantify A LOT

I've actually reviewed both products extensively (The CFDJ CommonSpot review
is located here: http://www.sys-con.com/coldfusion/articlea.cfm?id=520).
Dave Watts and I are collaborating on a MSCMS review.

In the case of CommonSpot, the entry point starts around $20K for ten
dedicated content contributors.  Microsoft Content Management Server starts
at $40K, licensed by CPU.  So, there is a significant difference in
licensing models -- and upfront cost.

The fact is, though, that CommonSpot is as close to an out of the box
solution as I have seen in a CMS package -- meaning that not much additional
programming is required (generally) to deploy a feature-rich site.  We've
been quite successful with deploying CommonSpot with low and mid-range
customers (check out http://www.heritage.org, http://www.ndm.edu/,
http://www.ceworld.org , http://www.usbg.gov ) and even use it internally
for our own sites (http://training.figleaf.com)

Microsoft CMS more closely resembles a framework (a la Spectra).  So
there's a huge developer API that you can take advantage of, but be prepared
to write A LOT of .NET code to get very far (thus adding more to the total
cost of ownership).  The principal advantages of MSCMS arise when you adopt
the entire MS platform including Win2K, SQL Server, SharePoint and MS
Commerce Server.  Microsoft is continuing to build on these integration
points which may ultimately lead to a compelling total integrated
enterprise CMS solution.  They've still got quite a bit of work to
do...but it's clear that this is where they're headed.

So, the real question is -- what are your present and projected future CMS
requirements?  Will CommonSpot fit the bill?  If so, it should definitely be
less expensive over the short-term.  If your organization is planning on
completely standardizing on the MS server suite, then MSCMS is probably a
better choice -- but make sure you add .NET developer training into your
budget -- and get ready to drink the .NET Kool-aid!

 
Regards,
Steve Drucker
CEO
Fig Leaf Software
www.figleaf.com
1-877-FIG-LEAF


-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 8:38 AM
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?

Jeezo, you must have ALOT of money if you are planning to use MSCMS or
CommonSpot.

Have you thought about NQContent? its actually pretty good, but the
documentation is v.poor.

N
-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 13:34
To: CF-Talk
Subject: RE: Got an opinion on MM Contribute?


Rick, as I work in a hospital, we looked at this as an option as well,
but found that it didn't fit our needs for a lot of things. However, we
do plan to use it on the website, but we plan to use either M$ CMS or
Commonspot on our intranet.
 
I've been building a lot of active edit areas to tide us over, but I am
just way too overwhelmed to have to do this everytime somoene wants to
add something, as I am the only webber in an organization of 1500
users.
 
I have, however, suggested Contribute to some of my pals at home who I
have made templates for for book clubs, etc. I found that I needed to
buy a copy of CT myself because they were having so many problems that I
needed to be able to walk them through things. The DW updater did help a
little, but it crashes my machine when I try to use the CT stuff.
 
Ok, I am rambling..
 
 
 
Candace K. Cottrell, Web Developer 
The Children's Medical Center 
One Children's Plaza 
Dayton, OH 45404 
937-641-4293 
http://www.childrensdayton.org
 
 
[EMAIL PROTECTED]

 [EMAIL PROTECTED] 1/7/2003 7:52:09 AM 
Thanks for all the replies and insight.  

I imagine this intranet project I'm working on is like a lot of
projects, a
mix of static pages and dynamic content.  

The community is medical (but not real tech savvy, particularly at the
lower
levels) with lots of committees, minutes and reports (the main use I
saw for
Contribute was secretaries publishing committee reports, minutes, 
research
results from Word .docs in a standard format that is both a good
display but
also printer ready).   

Rick




~|
Archives: 

RE: CFPOP and attachments

2003-01-07 Thread Pascal Peters
Are you doing action=getAll and specifying a valid attachmentPath? Did
you try to dump the query?

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]] 
Sent: dinsdag 7 januari 2003 15:17
To: CF-Talk
Subject: CFPOP and attachments


I'm using CFPOP to grab mail, but I can't get the queryname.attachments 
columnname.  It keeps telling me that the column attachments is not 
available in the query.  Does the column name not exist if there isn't
an 
attachment?

T


~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: more on grrrrr ... cfschedule

2003-01-07 Thread Jerry Johnson
Have you scheduled a really, really simple task that you will know ran?
(like a single web page load you can search through your logs for)

Get rid of all the complex variables and see if it runs at all.

If it works, slowly add complexity
  write a txt file saying Hello world
  add a couple of lines of your real program in at a time, and see if it still works.


Just some thoughts.

Jerry Johnson

 [EMAIL PROTECTED] 01/06/03 05:55PM 
To recap ... I haven't been able to get cfschedule to actually execute any
code.  It runs, according the logs, but nothing happens.


~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFPOP and attachments

2003-01-07 Thread Thane Sherrington
At 03:27 PM 01/07/03 +0100, Pascal Peters wrote:
Are you doing action=getAll and specifying a valid attachmentPath? Did
you try to dump the query?

I didn't have a valid path.  Thanks.

T

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFPOP and From Field

2003-01-07 Thread Thane Sherrington
When I use CFPOP, I sometimes get data in the FROM and REPLYTO fields, and 
sometimes I don't.  And it isn't always an e-mail address.  For instance, 
when I send e-mail to myself, I don't get anything in the reply to, and the 
from is Thane Sherrington with no e-mail address.  Is this a bug in 
CFPOP, or am I doing something wrong?

T

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFPOP and From Field

2003-01-07 Thread Mike Townend
You are getting the information... Click view source...

You will find that the address is often in the format 

Name email address

As its enclosed in  the browser assumes its code and as it cannot
understand it, it just hides it

Have a look at using HTMLEditFormat()

HTH

-Original Message-
From: Thane Sherrington [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 7, 2003 14:42
To: CF-Talk
Subject: CFPOP and From Field


When I use CFPOP, I sometimes get data in the FROM and REPLYTO fields, and 
sometimes I don't.  And it isn't always an e-mail address.  For instance, 
when I send e-mail to myself, I don't get anything in the reply to, and the 
from is Thane Sherrington with no e-mail address.  Is this a bug in 
CFPOP, or am I doing something wrong?

T


~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: certification experiences/plans?

2003-01-07 Thread Matt Liotta
I don't know, but our partner level includes certification vouchers.

Matt Liotta
President  CEO
Montara Software, Inc.
http://www.montarasoftware.com/
888-408-0900 x901

 -Original Message-
 From: Samuel Neff [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 06, 2003 10:54 PM
 To: CF-Talk
 Subject: RE: certification experiences/plans?
 
  For example, as a Macromedia partner my developers are
  required to be certified. However, as a partner our
  certifications are free, so there you go.
 
  -Matt
 
 Do all partners get free certifications or does it depend on your
 partner level?
 
 
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFPOP and From Field

2003-01-07 Thread Thane Sherrington
At 02:49 PM 01/07/03 +, Mike Townend wrote:

 Name email address

As its enclosed in  the browser assumes its code and as it cannot
understand it, it just hides it

Have a look at using HTMLEditFormat()

That's it.  Thanks for the help.

T

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SOT Does MS have a J2ee-certified or J2ee-compatible offering

2003-01-07 Thread Matt Liotta
 I'm not sure why IBM would buy Sun, either. As it is, IBM gets to
benefit
 from Java, so what's their incentive?
 
There are a lot of things IBM would like to see happen with Java that
Sun either blocks or slows down. For example, one major fight happening
in the Java scene right now is AWT vs. CWT. Both provide GUI widget
toolkits that work with Java, but they accomplish it very different
ways. AWT is meant to look and feel the same on every platform, while
CWT is meant to look and feel like the specific OS it is deployed on.

-Matt

~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: login prob

2003-01-07 Thread Mike Miessen
I put CFOUTPUT just after the CFSET stmt and indeed the variable
session.allowin was set to true.  I also put a CFOUTPUT at the top of my
application.cfm and found session.allowin was false.  So why is this
variable becoming false before it gets to my application.cfm?  Do I need
to do something to pass the values to it?

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 1:06 AM
To: CF-Talk
Subject: RE: login prob

Try and drop some CFOUTPUT into the code. Or run the app in debug so
you can watch SESSION.allowin my guess is a place you think is changing
it, isn't. If I am not doing it in debug I put some script alert() to
pop up the variables I want to watch.

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: Mike Miessen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 06, 2003 9:46 PM
To: CF-Talk
Subject: RE: login prob


I have the login page and the login process page in my root dir.  They
are now working as designed.  Login.cfm calls login_action.cfm which
checks the database and allows if the username and password works. It
sets session.allowin = true.  Then it calls out to the members dir where
the member page and the application.cfm is located.

Well application.cfm sets session.allowin default to false but it should
skip that because it is already set to true supposedly.  So then the
application.cfm blocks me and I don't know why


-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 12:37 AM
To: CF-Talk
Subject: RE: login prob

What happens? Nothing or you get put to the login page?

This chunk
cfif CGI.SCRIPT_NAME EQ /login.cfm
---You don't have anything happen here.---
  cfelseif CGI.SCRIPT_NAME EQ /login_process.cfm
---You don't have anything happen here.---
  cfelse
...

Do you set the session.allowin anywhere else prior to this page? Another
application.cfm somwhere up the directory tree?

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: Mike Miessen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 06, 2003 9:16 PM
To: CF-Talk
Subject: RE: login prob


Well I got some of my problems solved.  Mostly it was a directory
structure problem.  My current problem is that I get logged in and then
when it goes to the membersonly directory it runs a cfm page there where
I have an application.cfm file with the following code.  The problem is
that the variable session.allowin does not seem to be set because it
blocks me when it checks that in the cfif statement.  The process page
says I successfully logged in and then when I call the members page the
application.cfm blocks me.  Any ideas?


!--- Create the user login application ---
cfapplication name=MyApp clientmanagement=Yes
sessionmanagement=Yes
sessiontimeout=#CreateTimeSpan(0,0,15,0)#
applicationtimeout=#CreateTimeSpan(0,2,0,0)#

!--- Now define that this user is logged out by default --- CFPARAM
NAME=session.allowin DEFAULT=false

!--- Now if the variable session.allowin does not equal true, send
user to the login page ---
!---
the other thing you must check for is if the page calling this
application.cfm is the login.cfm page 
and the Login_process.cfm page since the Application.cfm is
always called, if this is not checked 
the application will simply Loop over and over. To check that,
you do the following call 

---
cfif session.allowin neq true
  cfif CGI.SCRIPT_NAME EQ /login.cfm
  cfelseif CGI.SCRIPT_NAME EQ /login_process.cfm
  cfelse
  !--- this user is not logged in, alert user and redirect to the
login.cfm page ---
  script
  alert(You must login to access this area!);
  self.location=/login.cfm;
  /script
  /cfif
/cfif

-Original Message-
From: Mike Miessen [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 06, 2003 11:12 PM
To: CF-Talk
Subject: RE: login prob

Well that didn't change anything.  I got this from the easycfm.com
tutorial.

Hey I thought this was easy LOL

-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 06, 2003 10:44 PM
To: CF-Talk
Subject: RE: login prob

If you have a DSN already set up (I asusme you do and it's called users)
try using just 

CFQUERY Datasource=users name=qVerify

John Wilker
Web Applications Consultant, Writer
Macromedia Certified ColdFusion Developer

Re: OT: HTML Question

2003-01-07 Thread paul smith
At 10:46 AM 1/7/03 +0100, you wrote:
paul smith wrote:
  Page displays fine in IE
 
  Page does not display in Netscape unless I put TABLE border  0
 
  Tables are involved, but no missing TABLE/TR/TD tags.

Did you try http://validator.w3.org

No.

What is the URL?

Page is password-protected.

best,  paul

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: mailto

2003-01-07 Thread Mosh Teitelbaum
Yeah, most of the current email clients support mailto attributes such as
body, but there is no standards-compliant way of specifying body text.
Also, even though most of the clients support the attribute, they don't (or
rarely do) support carriage returns.

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


 -Original Message-
 From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 12:51 AM
 To: CF-Talk
 Subject: RE: mailto


 Thanks Mosh - and thanks for the pointer to the article. I'll
 have a look a
 little later today. FYI I was researching this on MM's Forums as well and
 there was a claim that most mail systems support body?? Oh how I long for
 some consistency :-)


 **

 Kevin Parker
 Web Services Manager
 WorkCover Corporation

 [EMAIL PROTECTED]
 www.workcover.com

 p: 08 82332548
 f: 08 82332000
 m: 0418 806 166

 **


 -Original Message-
 From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, 7 January 2003 4:15 PM
 To: CF-Talk
 Subject: RE: mailto


 There is no way to (consistently) insert a carriage return into the body
 text.  You might try using \n or a URL Encoded carriage-return.
  Either of
 these methods might work in some clients and will fail in most others.

 BTW, technically speaking, ?body= is not allowed in a mailto: URL (see
 http://www.sightspecific.com/~mosh/WWW_FAQ/mailsubj.html for related
 discussion).

 --
 Mosh Teitelbaum
 evoch, LLC
 Tel: (301) 625-9191
 Fax: (301) 933-3651
 Email: [EMAIL PROTECTED]
 WWW: http://www.evoch.com/


  -Original Message-
  From: Parker, Kevin [mailto:[EMAIL PROTECTED]]
  Sent: Monday, January 06, 2003 10:56 PM
  To: CF-Talk
  Subject: SOT: mailto
 
 
  Does anyone know if you can code a carriage return into the body part of
  mailto attributes, viz:
 
  A HREF=mailto:[EMAIL PROTECTED]?subject=Hellobody=How Are You?/A
 
  TIA!!
 
  **
 
  Kevin Parker
  Web Services Manager
  WorkCover Corporation
 
  [EMAIL PROTECTED]
  www.workcover.com
 
  p: 08 82332548
  f: 08 82332000
  m: 0418 806 166
 
  **
 
 
 
  
  This e-mail is intended for the use of the addressee only. It may
  contain information that is protected by legislated confidentiality
  and/or is legally privileged. If you are not the intended recipient you
  are prohibited from disseminating, distributing or copying this e-mail.
 
  Any opinion expressed in this e-mail may not necessarily be that of the
  WorkCover Corporation of South Australia. Although precautions have
  been taken, the sender cannot warrant that this e-mail or any files
  transmitted with it are free of viruses or any other defect.
 
  If you have received this e-mail in error, please notify the sender
  immediately by return e-mail and destroy the original e-mail and any
  copies.
  
 
 

 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SQL Union Statement

2003-01-07 Thread Mark A. Kruger - CFG
What happens when you run this query by itself:

SELECT co_name, sponsor
FROM pl_companies
WHERE sponsor = 1

Does it return data? Is your data unique enough that you know the
difference?  You might try adding a column for type:

SELECT co_name, sponsor, 'Cultivar Companies' AS co_type
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor, 'PL Companies' AS co_type
FROM pl_companies
WHERE sponsor = 1
ORDER BY co_name


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 9:18 AM
To: CF-Talk
Subject: SQL Union Statement


Hi All,

Am I using the UNION statement correctly to join two different queries based
on two different tables in the same database?  I can't seem to get the data
from the pl_companies table to return a record.

Thanks.
==
cfquery name=qSponsor1 datasource=#REQUEST.dsn1#
SELECT co_name, sponsor
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor
FROM pl_companies
WHERE sponsor = 1
ORDER BY co_name
/cfquery



~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SQL Union Statement

2003-01-07 Thread Matthew Small
It looks right to me.  Are you sure that the pl_companies query is
supposed to return a record?  If it does, and it is the same as a record
in the first query, it will not show because union eliminates duplicate
records.  Try isolating the second query to ensure that it does return a
rowset.

Matthew Small
IT Supervisor
Showstopper National Dance Competitions
3660 Old Kings Hwy 
Murrells Inlet, SC 29576
843-357-1847
http://www.showstopperonline.com

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 10:18 AM
To: CF-Talk
Subject: SQL Union Statement

Hi All,

Am I using the UNION statement correctly to join two different queries
based
on two different tables in the same database?  I can't seem to get the
data
from the pl_companies table to return a record.

Thanks.
==
cfquery name=qSponsor1 datasource=#REQUEST.dsn1#
SELECT co_name, sponsor
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor
FROM pl_companies 
WHERE sponsor = 1   
ORDER BY co_name
/cfquery



~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SQL Union Statement

2003-01-07 Thread Robertson-Ravo, Neil (RX)
yep, doesn't seem there is a need for the union?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 15:25
To: CF-Talk
Subject: RE: SQL Union Statement


What happens when you run this query by itself:

SELECT co_name, sponsor
FROM pl_companies
WHERE sponsor = 1

Does it return data? Is your data unique enough that you know the
difference?  You might try adding a column for type:

SELECT co_name, sponsor, 'Cultivar Companies' AS co_type
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor, 'PL Companies' AS co_type
FROM pl_companies
WHERE sponsor = 1
ORDER BY co_name


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 9:18 AM
To: CF-Talk
Subject: SQL Union Statement


Hi All,

Am I using the UNION statement correctly to join two different queries based
on two different tables in the same database?  I can't seem to get the data
from the pl_companies table to return a record.

Thanks.
==
cfquery name=qSponsor1 datasource=#REQUEST.dsn1#
SELECT co_name, sponsor
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor
FROM pl_companies
WHERE sponsor = 1
ORDER BY co_name
/cfquery




~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



SpamArrest

2003-01-07 Thread Robertson-Ravo, Neil (RX)
uuurgh, can this be removed? coz at the moment all I am doing is filtering
and deleting these stupid little emails...

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SQL Union Statement

2003-01-07 Thread Mark Leder
I got it fixed.  This unique column advice did the trick.  Thanks.
Mark

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 10:27 AM
To: CF-Talk
Subject: RE: SQL Union Statement


yep, doesn't seem there is a need for the union?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 15:25
To: CF-Talk
Subject: RE: SQL Union Statement


What happens when you run this query by itself:

SELECT co_name, sponsor
FROM pl_companies
WHERE sponsor = 1

Does it return data? Is your data unique enough that you know the
difference?  You might try adding a column for type:

SELECT co_name, sponsor, 'Cultivar Companies' AS co_type
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor, 'PL Companies' AS co_type
FROM pl_companies
WHERE sponsor = 1
ORDER BY co_name


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 9:18 AM
To: CF-Talk
Subject: SQL Union Statement


Hi All,

Am I using the UNION statement correctly to join two different queries based
on two different tables in the same database?  I can't seem to get the data
from the pl_companies table to return a record.

Thanks.
==
cfquery name=qSponsor1 datasource=#REQUEST.dsn1#
SELECT co_name, sponsor
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor
FROM pl_companies
WHERE sponsor = 1
ORDER BY co_name
/cfquery





~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



How to unsubscribe

2003-01-07 Thread Mitko Gerensky-Greene
Hello,

going to the link gives me only:

Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?
user=1828.1748.4

The auto-unsubscribe functionality is being tested to be sure that non 
accidental access is allowed. 

Is this temporary or is it the way it is going to be?

Thanks,

Mitko

-
This mail sent through IMP: http://horde.org/imp/
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Replacing characters in a string

2003-01-07 Thread Ryan Emerle
Yet another way.. With regular expressions:

cfset maskDigits=8
cfset masked=REReplace(CCnum,^[0-9]{#maskDigits#},repeatString(*,maskDigits))

-Ryan

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 7:56 AM
To: CF-Talk
Subject: Replacing characters in a string


This should be a simple enough one...

I have a credit card number, 16 digits long, and I want to star (*) out the
middle 8. How do I do this?

TIA
Ryan



~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



CFMail Best Practice

2003-01-07 Thread Mark Leder
Hi All,
I'm looking for some kind of best practice when using the CFMAIL tag in
terms of selectively controlling whitespace.  If you look at the example
below, my problem is the that the CFIF statements create an empty row even
if they are not called - so if only one CFIF statement EQ Yes, I will still
have several rows of white space.  I've also found that the CFMAILPARAM
tag used after the beginning CFMAIL statement also creates a blank line at
the top of the mail message.  In addition, I would like my Phone, Email, and
Web rows (at the bottom) to line up nicely.

CFPROCESSINGDIRECTIVE as shown below has no effect on the output.  What's
the best solution others have used?  CFSILENT ? CFSETTING
ENABLECFOUTPUTONLY ?

Thanks,
Mark

+
cfset CRLF = chr(13) chr(10)
!--- Mail which goes to the user who filled out the form ---
CFMAIL TO=#FORM.emailadr#
 FROM=#fromemail#
 SUBJECT=Correspondance Confirmation
 BCC=#bcc#
Thank you for visiting #companyname# on the web.
cfprocessingdirective suppresswhitespace=yes
CFIF FORM.Message IS NOT For your reference, since you provided inquiry
comments, they are listed here:#CRLF#
CFIF FORM.lymph IS YesI'm interested in learning more about your
Lymph Drainage Therapy./CFIF
CFIF FORM.aroma IS YesI'm interested in learning more about
Aroma Therapy./CFIF
CFIF FORM.craniosacral IS YesI'm interested in learning more
about your CranioSacral Therapy./CFIF
CFIF FORM.farinfrared IS YesI'm interested in learning more
about your Far Infrared Sauna Therapy./CFIF
CFIF FORM.intensive IS YesI'm interested in learning more about
your Intensive Treatment Therapy./CFIF
CFIF FORM.bodytalk IS YesI'm interested in learning more about
your Body Talk System./CFIF
CFIF FORM.privacy IS YesI have a question about the privacy on
this site./CFIF
CFIF FORM.course IS YesI'm interested in signing up for the
following course when it is announced:
#Trim(FORM.activity)#/CFIF
CFIF FORM.signup IS YesI'm signing up for the following free
course:#CRLF#
Course Title: #Trim(qCalendarTBA.activityTitle)##CRLF#
Course Date: #DateFormat(qCalendarTBA.cal_date_start, , 
DD, )##CRLF#
Course Time: #Trim(qCalendarTBA.activity_Time)##CRLF#
Course Instructor: #Trim(qCalendarTBA.instructorName)##CRLF#
Course Location: #Trim(qCalendarTBA.locationname)##CRLF#
Course Address: #Trim(qCalendarTBA.address)##CRLF#
Course City, State, Zip: #Trim(qCalendarTBA.city)#,
#Trim(qCalendarTBA.state)# #Trim(qCalendarTBA.zip)#/CFIF

#Trim(FORM.Message)#/CFIF
/cfprocessingdirective

We will follow up shortly regarding your e-mail message.

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Replacing characters in a string

2003-01-07 Thread Ryan Emerle
Sorry.. MIDDLE eight.. Now it gets ugly with regEx..

cfset 
masked=REReplace(ccnum,([0-9]{4})[0-9]+([0-9]{4}),\1#repeatString('*',8)#\2)

-Ryan
-Original Message-
From: Ryan Emerle 
Sent: Tuesday, January 07, 2003 10:47 AM
To: CF-Talk
Subject: RE: Replacing characters in a string


Yet another way.. With regular expressions:

cfset maskDigits=8
cfset masked=REReplace(CCnum,^[0-9]{#maskDigits#},repeatString(*,maskDigits))

-Ryan

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 7:56 AM
To: CF-Talk
Subject: Replacing characters in a string


This should be a simple enough one...

I have a credit card number, 16 digits long, and I want to star (*) out the
middle 8. How do I do this?

TIA
Ryan




~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: CFMail Best Practice

2003-01-07 Thread Todd Rafferty
Take a look at CFSAVECONTENT you can do all the building of the body 
outside of the CFMAIL tag and trim whitespace from there.

~Todd

At 10:47 AM 1/7/2003 -0500, you wrote:
Hi All,
I'm looking for some kind of best practice when using the CFMAIL tag in
terms of selectively controlling whitespace.  If you look at the example
below, my problem is the that the CFIF statements create an empty row even
if they are not called - so if only one CFIF statement EQ Yes, I will still
have several rows of white space.  I've also found that the CFMAILPARAM
tag used after the beginning CFMAIL statement also creates a blank line at
the top of the mail message.  In addition, I would like my Phone, Email, and
Web rows (at the bottom) to line up nicely.

CFPROCESSINGDIRECTIVE as shown below has no effect on the output.  What's
the best solution others have used?  CFSILENT ? CFSETTING
ENABLECFOUTPUTONLY ?

Thanks,
Mark



--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: newbie: help with sql query

2003-01-07 Thread Dina Hess
If you are on access, the outer join won't work and you have to do a union:

Sorry...that's not true. Access supports outer joins, but the syntax is either RIGHT 
JOIN or LEFT JOIN rather than OUTER JOIN.

Conversely if bugs.bug_type_id = 0 then simply add that statement to the query. .

Azeem, if you're still listening, the above comment and the code at the end of your 
original post to output the data indicates that you are retrieving *all* bug_type_ids, 
whether they are 0 or not. If that is true, you don't need the last six lines of your 
SQL statement since you can control your output based on a CFIF condition, which 
you've done. If you *do* want to filter out all bug_type_ids that are 0, simply add 
AND bugs.bug_type_id  '0' to your subquery (but don't forget to correct the join 
syntax in the subquery).

Since you appear to be joining multiple tables: bugs, bug_type, bug_status, and 
priority using an inner join, please be aware that Access does not support the WHERE 
PK=FK inner join syntax (that's fine in SQL Server though). 

Instead you will need to join the tables in the FROM clause. The easiest way to build 
an Access query is to use the Access Query Designer, switching to SQL view to run it 
and see the syntax. When you get the results you expect, just copy/paste into CF.

***

Regarding your question about why you cannot output the bug_type, it may be that CF is 
seeing the datatype as numeric. Therefore, try eliminating the quotes around 0. 

As an aside, it is unnecessary to wrap your variables with pound signs in the CFIF 
tag. And, logically, you should change cfelseif #bug_type_id# eq 0 to CFELSE.

~Dina






~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: OT: HTML Question

2003-01-07 Thread paul smith
At 10:46 AM 1/7/03 +0100, you wrote:
Did you try http://validator.w3.org

Yes. It refused to check an html-only version of the following (something 
about character set).

With border=1 replaced by border=0 in the following, Netscape 4.79 does 
not display the following - IE 5.50 does.

best,  paul

==
cfoutput
table border=1 cellpadding=0 cellspacing=4 align=right width=18%
trtd align=centerfont face=arial color=6f6f6f size=-1Sponsored 
Ads/font/td/tr
trtd
table bgcolor=b4d0dc border=0 cellspacing=0 width=100%
trtd
table border=0 cellpadding=3 cellspacing=0 width=100%
trtd bgcolor=ecf8ff nowrap font face=arial size=-1a 
href=ads/index.cfm/in.#variables.init#/cd.#cfi#/cn.#cft# 
onMouseOver=window.status='Go to support.net/Ads';return 
true#GetOrderedAdIDs.AdHead#/a
br
font face=arial color=6f6f6f 
size=-2#GetOrderedAdIDs.AdLine1#br#GetOrderedAdIDs.AdLine2#
br
#GetOrderedAdIDs.AdLine3#/fontbrfont face=arial color=green 
size=-1#GetOrderedAdIDs.AdURL#
/td/tr
/table
/td/tr
/table
/td/tr
trtd align=centerfont face=arial color=6f6f6f size=-1a 
href=ads/index.cfm/in.#variables.init#/cd.#cfi#/cn.#cft#.htmPlace your Ad 
here.../a/font/td/tr/table/cfoutput

==


~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMail Best Practice

2003-01-07 Thread Everett, Al
We generally create the text of the message before we call the CFMAIL tag
precisely to prevent all the whitespace. Then all we need is:

cfmail ...#Variables.mailMessageText#/cfmail

If you're using CF5  up, CFSAVECONTENT will be very helpful here.

 -Original Message-
 From: Mark Leder [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 10:48 AM
 To: CF-Talk
 Subject: CFMail Best Practice
 
 
 Hi All,
 I'm looking for some kind of best practice when using the 
 CFMAIL tag in
 terms of selectively controlling whitespace.  If you look at 
 the example
 below, my problem is the that the CFIF statements create an 
 empty row even
 if they are not called - so if only one CFIF statement EQ 
 Yes, I will still
 have several rows of white space.  I've also found that the 
 CFMAILPARAM
 tag used after the beginning CFMAIL statement also creates 
 a blank line at
 the top of the mail message.  In addition, I would like my 
 Phone, Email, and
 Web rows (at the bottom) to line up nicely.
 
 CFPROCESSINGDIRECTIVE as shown below has no effect on the 
 output.  What's
 the best solution others have used?  CFSILENT ? CFSETTING
 ENABLECFOUTPUTONLY ?
 
 Thanks,
 Mark
 
 +
 cfset CRLF = chr(13) chr(10)
 !--- Mail which goes to the user who filled out the form ---
 CFMAIL TO=#FORM.emailadr#
  FROM=#fromemail#
  SUBJECT=Correspondance Confirmation
  BCC=#bcc#
 Thank you for visiting #companyname# on the web.
 cfprocessingdirective suppresswhitespace=yes
 CFIF FORM.Message IS NOT For your reference, since you 
 provided inquiry
 comments, they are listed here:#CRLF#
   CFIF FORM.lymph IS YesI'm interested in learning 
 more about your
 Lymph Drainage Therapy./CFIF
   CFIF FORM.aroma IS YesI'm interested in learning more about
 Aroma Therapy./CFIF
   CFIF FORM.craniosacral IS YesI'm interested in learning more
 about your CranioSacral Therapy./CFIF
   CFIF FORM.farinfrared IS YesI'm interested in learning more
 about your Far Infrared Sauna Therapy./CFIF
   CFIF FORM.intensive IS YesI'm interested in 
 learning more about
 your Intensive Treatment Therapy./CFIF
   CFIF FORM.bodytalk IS YesI'm interested in learning 
 more about
 your Body Talk System./CFIF
   CFIF FORM.privacy IS YesI have a question about the 
 privacy on
 this site./CFIF
   CFIF FORM.course IS YesI'm interested in signing up for the
 following course when it is announced:
   #Trim(FORM.activity)#/CFIF
   CFIF FORM.signup IS YesI'm signing up for the following free
 course:#CRLF#
   Course Title: #Trim(qCalendarTBA.activityTitle)##CRLF#
   Course Date: #DateFormat(qCalendarTBA.cal_date_start, 
 , 
 DD, )##CRLF#
   Course Time: #Trim(qCalendarTBA.activity_Time)##CRLF#
   Course Instructor: #Trim(qCalendarTBA.instructorName)##CRLF#
   Course Location: #Trim(qCalendarTBA.locationname)##CRLF#
   Course Address: #Trim(qCalendarTBA.address)##CRLF#
   Course City, State, Zip: #Trim(qCalendarTBA.city)#,
 #Trim(qCalendarTBA.state)# #Trim(qCalendarTBA.zip)#/CFIF
 
 #Trim(FORM.Message)#/CFIF
 /cfprocessingdirective
 
 We will follow up shortly regarding your e-mail message.
 
 
~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



For the mac users out there

2003-01-07 Thread Ryan Mitchell
Tell me this is true!?

http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

Ryan

~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



looping through a list using cfscript

2003-01-07 Thread Pete Ruckelshaus
I need to loop through a comma delimited list (the output of a multiple select box) 
using cfscript, yet list isn't a loop type in cfscript.  Is there any workaround?

Thanks

Pete
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: certification experiences/plans?

2003-01-07 Thread Bryan Stevenson
Whoa...I came in way late on this thread

So is it being said that MM Partners get free certs?  If so what partner
level? how many certs?

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

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message -
From: Matt Liotta [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Tuesday, January 07, 2003 6:53 AM
Subject: RE: certification experiences/plans?


 I don't know, but our partner level includes certification vouchers.

 Matt Liotta
 President  CEO
 Montara Software, Inc.
 http://www.montarasoftware.com/
 888-408-0900 x901

  -Original Message-
  From: Samuel Neff [mailto:[EMAIL PROTECTED]]
  Sent: Monday, January 06, 2003 10:54 PM
  To: CF-Talk
  Subject: RE: certification experiences/plans?
 
   For example, as a Macromedia partner my developers are
   required to be certified. However, as a partner our
   certifications are free, so there you go.
  
   -Matt
 
  Do all partners get free certifications or does it depend on your
  partner level?
 
 
 
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Todd Rafferty
It's true.

~Todd

At 03:57 PM 1/7/2003 +, you wrote:
Tell me this is true!?

http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

Ryan



--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Verity Indexing Help...Can't I just shoot my computer?

2003-01-07 Thread Jeff Small
Okay, lemme see if I can put this correctly into words...

Lemme preface this by saying, I've got the collection done, and the
collection is working great, and I've also tried the macromedia forums with
no luck...so you really are my only hope, Obi Wans

Let's say I've indexed Foo.

Foo contains subdirectories bar1, bar2, and bar3

I've set Foo's index to index recursive directories

So let's say, this is what's contained in those directories.

Foo/index.cfm
Foo/page2.cfm
Foo/Bar1/index.cfm
Foo/Bar2/index.cfm
Foo/Bar2/page2.cfm
Foo/Bar3/index.cfm
Foo/Bar3/page2.cfm
Foo/Bar3/page3.cfm

Now, after searching my collection, the following pages match:

Foo/page2.cfm
Foo/Bar2/page2.cfm
Foo/Bar3/index.cfm
Foo/Bar3/page3.cfm

all my links, using:

CFSET FileName=GetFileFromPath(Key)
A HREF=#Filename#View/A

return the following:
A HREF=page2.cfmView/A
A HREF=page2.cfmView/A
A HREF=index.cfmView/A
A HREF=page3.cfmView/A

How do I determine the directory? In my collection, I've got the collection
url set to http://www.thedomain.com which I assumed would return the root
for the site which Foo is the root directory...

How do I accomplish this? I know it's something I'm overlooking. Whenever I
use JUST key I get the correct path all the way down (into Bar3 for
example) but I just can't grab that directory (Bar3) for some reason.

Was this clear? Any help is super appreciated.

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Jochem van Dieten
Ryan Mitchell wrote:
 Tell me this is true!?

No, the Macromedia website is not down :-)

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Matt Liotta
Indeed

Matt Liotta
President  CEO
Montara Software, Inc.
http://www.montarasoftware.com/
888-408-0900 x901

 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 10:57 AM
 To: CF-Talk
 Subject: For the mac users out there
 
 Tell me this is true!?
 
 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766
 
 Ryan
 
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Roberson, Jeff, Mr (Contractor) ACI
Unfortunately it's only the developers edition.

When the standard (non-j2ee) version of CFMX runs there will be dancing in
the streets :)

-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 10:57 AM
To: CF-Talk
Subject: For the mac users out there


Tell me this is true!?

http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

Ryan


~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: looping through a list using cfscript

2003-01-07 Thread Everett, Al
Do a simple counting loop, from 1 to ListLen(list) and use the ListGetAt()
function.

 -Original Message-
 From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 11:03 AM
 To: CF-Talk
 Subject: looping through a list using cfscript
 
 
 I need to loop through a comma delimited list (the output of 
 a multiple select box) using cfscript, yet list isn't a 
 loop type in cfscript.  Is there any workaround?
 
 Thanks
 
 Pete
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: looping through a list using cfscript

2003-01-07 Thread Ryan Emerle
Here ya go..

cfscript
myList=item1,item2,item3;
for(i=1;i lte listLen(myList);i=i+1) {
listItem=listGetAt(myList,i);

/* Loop Contents */
}
/cfscript

HTH
-Ryan

-Original Message-
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 11:03 AM
To: CF-Talk
Subject: looping through a list using cfscript


I need to loop through a comma delimited list (the output of a multiple select box) 
using cfscript, yet list isn't a loop type in cfscript.  Is there any workaround?

Thanks

Pete

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: looping through a list using cfscript

2003-01-07 Thread Jerry Johnson
for {i=1;i=listLen(list);i=i+1}
 val=listGetAt(list,i);

syntax most likely wrong, but idea is correct.

Jerry Johnson

 [EMAIL PROTECTED] 01/07/03 11:03AM 
I need to loop through a comma delimited list (the output of a multiple select box) 
using cfscript, yet list isn't a loop type in cfscript.  Is there any workaround?

Thanks

Pete

~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Ryan Mitchell
Thank you macromedia
When can I get it?


On 7/1/03 15:59, Todd Rafferty [EMAIL PROTECTED] wrote:

 It's true.
 
 ~Todd
 
 At 03:57 PM 1/7/2003 +, you wrote:
 Tell me this is true!?
 
 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766
 
 Ryan
 
 
 
 --
 Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
 Team Macromedia Volunteer for ColdFusion
 http://www.macromedia.com/support/forums/team_macromedia/
 http://www.devmx.com/
 
 --
 
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: OT: HTML Question

2003-01-07 Thread Jochem van Dieten
paul smith wrote:
 At 10:46 AM 1/7/03 +0100, you wrote:
 
Did you try http://validator.w3.org
 
 
 Yes. It refused to check an html-only version of the following (something 
 about character set).

Add a charset meta tag (but I don't think NN 4.x does unicode):
meta http-equiv=Content-Type content=text/html; charset=charset


 With border=1 replaced by border=0 in the following, Netscape 4.79 does 
 not display the following - IE 5.50 does.
 
 best,  paul
 
 ==

snip bad html

You need a lot of quotes around tag attributes there.

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
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Adam Reynolds
It was this morning for about 3 hours

 -Original Message-
 From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
 Sent: 07 January 2003 16:03
 To: CF-Talk
 Subject: Re: For the mac users out there


 Ryan Mitchell wrote:
  Tell me this is true!?

 No, the Macromedia website is not down :-)

 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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Automated RDS file copy over SSL i.e. secure backup

2003-01-07 Thread Mark W. Breneman
I know that RDS was never made for this but, I am looking for a way to
securely copy down a database backup from a CF server.  I can browse to the
file via RDS on a SSL connection and copy/paste the file but, I am hoping
for some way to automate it, something like a command prompt or CFRDS tags.

Anyone see anything like this?

Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
  Vivid Media
  [EMAIL PROTECTED]
  www.vividmedia.com
  608.270.9770

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Ryan Mitchell
Yeah, that will be the day that xserve takes over...


On 7/1/03 16:05, Roberson, Jeff, Mr (Contractor) ACI
[EMAIL PROTECTED] wrote:

 Unfortunately it's only the developers edition.
 
 When the standard (non-j2ee) version of CFMX runs there will be dancing in
 the streets :)
 
 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 10:57 AM
 To: CF-Talk
 Subject: For the mac users out there
 
 
 Tell me this is true!?
 
 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766
 
 Ryan
 
 
 
~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: SQL Union Statement

2003-01-07 Thread Mark A. Kruger - CFG
cool.

-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 9:39 AM
To: CF-Talk
Subject: RE: SQL Union Statement


I got it fixed.  This unique column advice did the trick.  Thanks.
Mark

-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 10:27 AM
To: CF-Talk
Subject: RE: SQL Union Statement


yep, doesn't seem there is a need for the union?

-Original Message-
From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 15:25
To: CF-Talk
Subject: RE: SQL Union Statement


What happens when you run this query by itself:

SELECT co_name, sponsor
FROM pl_companies
WHERE sponsor = 1

Does it return data? Is your data unique enough that you know the
difference?  You might try adding a column for type:

SELECT co_name, sponsor, 'Cultivar Companies' AS co_type
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor, 'PL Companies' AS co_type
FROM pl_companies
WHERE sponsor = 1
ORDER BY co_name


-Original Message-
From: Mark Leder [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 9:18 AM
To: CF-Talk
Subject: SQL Union Statement


Hi All,

Am I using the UNION statement correctly to join two different queries based
on two different tables in the same database?  I can't seem to get the data
from the pl_companies table to return a record.

Thanks.
==
cfquery name=qSponsor1 datasource=#REQUEST.dsn1#
SELECT co_name, sponsor
FROM tCultivarCompanies
WHERE sponsor = 1
UNION
SELECT co_name, sponsor
FROM pl_companies
WHERE sponsor = 1
ORDER BY co_name
/cfquery






~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: certification experiences/plans?

2003-01-07 Thread Matt Liotta
You can find the details about all the benefits of becoming a partner at
http://spectra15.macromedia.com/overview/na_benefits.cfm.

Matt Liotta
President  CEO
Montara Software, Inc.
http://www.montarasoftware.com/
888-408-0900 x901

 -Original Message-
 From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 11:09 AM
 To: CF-Talk
 Subject: Re: certification experiences/plans?
 
 Whoa...I came in way late on this thread
 
 So is it being said that MM Partners get free certs?  If so what
partner
 level? how many certs?
 
 Bryan Stevenson B.Comm.
 VP  Director of E-Commerce Development
 Electric Edge Systems Group Inc.
 t. 250.920.8830
 e. [EMAIL PROTECTED]
 
 -
 Macromedia Associate Partner
 www.macromedia.com
 -
 Vancouver Island ColdFusion Users Group
 Founder  Director
 www.cfug-vancouverisland.com
 - Original Message -
 From: Matt Liotta [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Tuesday, January 07, 2003 6:53 AM
 Subject: RE: certification experiences/plans?
 
 
  I don't know, but our partner level includes certification vouchers.
 
  Matt Liotta
  President  CEO
  Montara Software, Inc.
  http://www.montarasoftware.com/
  888-408-0900 x901
 
   -Original Message-
   From: Samuel Neff [mailto:[EMAIL PROTECTED]]
   Sent: Monday, January 06, 2003 10:54 PM
   To: CF-Talk
   Subject: RE: certification experiences/plans?
  
For example, as a Macromedia partner my developers are
required to be certified. However, as a partner our
certifications are free, so there you go.
   
-Matt
  
   Do all partners get free certifications or does it depend on your
   partner level?
  
  
  
 
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Verity Indexing Help...Can't I just shoot my computer?

2003-01-07 Thread Mosh Teitelbaum
Don't use GetFileFromPath().

--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 625-9191
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/


 -Original Message-
 From: Jeff Small [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 11:03 AM
 To: CF-Talk
 Subject: Verity Indexing Help...Can't I just shoot my computer?


 Okay, lemme see if I can put this correctly into words...

 Lemme preface this by saying, I've got the collection done, and the
 collection is working great, and I've also tried the macromedia
 forums with
 no luck...so you really are my only hope, Obi Wans

 Let's say I've indexed Foo.

 Foo contains subdirectories bar1, bar2, and bar3

 I've set Foo's index to index recursive directories

 So let's say, this is what's contained in those directories.

 Foo/index.cfm
 Foo/page2.cfm
 Foo/Bar1/index.cfm
 Foo/Bar2/index.cfm
 Foo/Bar2/page2.cfm
 Foo/Bar3/index.cfm
 Foo/Bar3/page2.cfm
 Foo/Bar3/page3.cfm

 Now, after searching my collection, the following pages match:

 Foo/page2.cfm
 Foo/Bar2/page2.cfm
 Foo/Bar3/index.cfm
 Foo/Bar3/page3.cfm

 all my links, using:

 CFSET FileName=GetFileFromPath(Key)
 A HREF=#Filename#View/A

 return the following:
 A HREF=page2.cfmView/A
 A HREF=page2.cfmView/A
 A HREF=index.cfmView/A
 A HREF=page3.cfmView/A

 How do I determine the directory? In my collection, I've got the
 collection
 url set to http://www.thedomain.com which I assumed would
 return the root
 for the site which Foo is the root directory...

 How do I accomplish this? I know it's something I'm overlooking.
 Whenever I
 use JUST key I get the correct path all the way down (into Bar3 for
 example) but I just can't grab that directory (Bar3) for some reason.

 Was this clear? Any help is super appreciated.

 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Query-of-Query All but [empty string]

2003-01-07 Thread Jesse Houwing
Dwayne Cole wrote:

try != (not equal):



I tried this to no avail.  'dwayne' works and so does != 'dwayne' but != '' does 
not.  I wonder if this is a Q-of-Q bug.
  

not email is null

?

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
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFFILE Workarounds?

2003-01-07 Thread Robert Bailey
I did not even think of that, yes, it is web accessible.

 
Robert Bailey
[EMAIL PROTECTED]
Famous for nothing!
http://www.tinetics.com
 
 

-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 6:05 AM
To: CF-Talk
Subject: Re: CFFILE Workarounds?

If the file is in your web root, you could use cfhttp.

Christian

On Tuesday, January 7, 2003, at 04:57 AM, Robert Bailey wrote:


 I can use CFExecute on my host. But the file I create I need to read
it
 into a variable, but CFFILE does not seem to work as it throws an
error
 saying it exceeded the allotted time limit, so I am guessing they shut
 this off, but kept CFExecute. Well, here is my question: Can I read
the
 contents of this file into a variable without using CFFile?

 Robert Bailey
 [EMAIL PROTECTED]
 Famous for nothing!
 http://www.tinetics.com


 ---
 [This E-mail scanned for viruses]

 

~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: Query-of-Query All but [empty string]

2003-01-07 Thread Todd Rafferty
something  ''

...?

~Todd

At 05:19 PM 1/7/2003 +0100, you wrote:
Dwayne Cole wrote:

 try != (not equal):
 
 
 
 I tried this to no avail.  'dwayne' works and so does != 'dwayne' but 
 != '' does not.  I wonder if this is a Q-of-Q bug.
 
 
not email is null

?

Jesse


--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



certification experiences/plans?

2003-01-07 Thread Cathy Taylor
Crud, my email server is down, so hopefully this will post through the website! 
Anyway, here's what I tried sending this morning.

Ok, in my experience (cynical as well)...

I've never been turned down due to a lack of degree or lack or certifications - I've 
always been hired/promoted based on my skills and experience. I did, however, get a CF 
5 cert because when I raised my rates this fiscal year (I'm an independent 
contractor), I was told I didn't qualify for the rate unless I was certified in 
something (anything) or had a degree. So I ran out and got certified in the one thing 
I thought I could pass pretty easily (and I did). 

I think there is a small percentage of the population that technical stuff comes 
easily to - you know, people with that certain knack who just get it when stuff 
comes their way and can chunk through anything whether they've seen it before or not 
(much of this list probably falls into that category). There is no way to screen that 
when hiring based on a resume, degree, or list of certifications someone has. I know, 
I've hired several complete duds who looked great on paper. If you've got that knack, 
employers will recognize that (after you're hired, of course) and keep/promote you.

(That said, I am working on my MIS degree right now mostly for fun rather than any 
career goals - I'm perfectly happy with my career.) 

My husband also does not have a degree and was one test shy of a CNE years ago - he 
has no other certifications. He has never lacked for good contracts either, owns our 
consulting firm, and is highly respected in the technical field.

A newbie - no weight - they can be groomed, particularly if they have aforesaid knack 
(I once had a great 21 year old tech under me - only downside was he was a bit flaky 
due to age and partying)

The other two I would hire based on experience and references.

JMHO!

Cathy

Subject: certification experiences/plans?
From: Rob Rohan [EMAIL PROTECTED]
Date: Mon, 6 Jan 2003 17:17:04 -0800
Thread: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=messagesthreadid=20255forumid=4#102369
~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



whats a black line around my cfdumped query mean?

2003-01-07 Thread Jon Block
I serialized my query object (recordset) to wddx. Later, I read it in and
need to CFOUTPUT over it again. For some reason, CF doesn't see it as a
native query and when I cfdump it, its got a black line going around the
outside of the table. How do I get my deserialized query to work like a
native query again?

Thanks,
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
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: whats a black line around my cfdumped query mean?

2003-01-07 Thread Todd Rafferty
You have to de-serialize it first.

CFWDDX action=wddx2cfml

~Todd

At 11:30 AM 1/7/2003 -0500, you wrote:
I serialized my query object (recordset) to wddx. Later, I read it in and
need to CFOUTPUT over it again. For some reason, CF doesn't see it as a
native query and when I cfdump it, its got a black line going around the
outside of the table. How do I get my deserialized query to work like a
native query again?

Thanks,
Jon



--
Todd Rafferty ([EMAIL PROTECTED]) - http://www.web-rat.com/
Team Macromedia Volunteer for ColdFusion
http://www.macromedia.com/support/forums/team_macromedia/
http://www.devmx.com/

--

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: CFMail Best Practice

2003-01-07 Thread Mark Leder
GREAT suggestions - I wasn't aware of the CFSAVECONTENT tag at all, and I'm
using CF5 - this should be a real problem solver.

Thanks,
Mark

-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 10:56 AM
To: CF-Talk
Subject: RE: CFMail Best Practice


We generally create the text of the message before we call the CFMAIL tag
precisely to prevent all the whitespace. Then all we need is:

cfmail ...#Variables.mailMessageText#/cfmail

If you're using CF5  up, CFSAVECONTENT will be very helpful here.

 -Original Message-
 From: Mark Leder [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 10:48 AM
 To: CF-Talk
 Subject: CFMail Best Practice
 
 
 Hi All,
 I'm looking for some kind of best practice when using the
 CFMAIL tag in
 terms of selectively controlling whitespace.  If you look at 
 the example
 below, my problem is the that the CFIF statements create an 
 empty row even
 if they are not called - so if only one CFIF statement EQ 
 Yes, I will still
 have several rows of white space.  I've also found that the 
 CFMAILPARAM
 tag used after the beginning CFMAIL statement also creates 
 a blank line at
 the top of the mail message.  In addition, I would like my 
 Phone, Email, and
 Web rows (at the bottom) to line up nicely.
 
 CFPROCESSINGDIRECTIVE as shown below has no effect on the
 output.  What's
 the best solution others have used?  CFSILENT ? CFSETTING
 ENABLECFOUTPUTONLY ?
 
 Thanks,
 Mark
 
 +
 cfset CRLF = chr(13) chr(10)
 !--- Mail which goes to the user who filled out the form --- CFMAIL 
 TO=#FORM.emailadr#  FROM=#fromemail#
  SUBJECT=Correspondance Confirmation
  BCC=#bcc#
 Thank you for visiting #companyname# on the web.
 cfprocessingdirective suppresswhitespace=yes
 CFIF FORM.Message IS NOT For your reference, since you 
 provided inquiry
 comments, they are listed here:#CRLF#
   CFIF FORM.lymph IS YesI'm interested in learning 
 more about your
 Lymph Drainage Therapy./CFIF
   CFIF FORM.aroma IS YesI'm interested in learning more about
 Aroma Therapy./CFIF
   CFIF FORM.craniosacral IS YesI'm interested in learning more
 about your CranioSacral Therapy./CFIF
   CFIF FORM.farinfrared IS YesI'm interested in learning more
 about your Far Infrared Sauna Therapy./CFIF
   CFIF FORM.intensive IS YesI'm interested in 
 learning more about
 your Intensive Treatment Therapy./CFIF
   CFIF FORM.bodytalk IS YesI'm interested in learning 
 more about
 your Body Talk System./CFIF
   CFIF FORM.privacy IS YesI have a question about the 
 privacy on
 this site./CFIF
   CFIF FORM.course IS YesI'm interested in signing up for the
 following course when it is announced:
   #Trim(FORM.activity)#/CFIF
   CFIF FORM.signup IS YesI'm signing up for the following free
 course:#CRLF#
   Course Title: #Trim(qCalendarTBA.activityTitle)##CRLF#
   Course Date: #DateFormat(qCalendarTBA.cal_date_start, 
 , 
 DD, )##CRLF#
   Course Time: #Trim(qCalendarTBA.activity_Time)##CRLF#
   Course Instructor: #Trim(qCalendarTBA.instructorName)##CRLF#
   Course Location: #Trim(qCalendarTBA.locationname)##CRLF#
   Course Address: #Trim(qCalendarTBA.address)##CRLF#
   Course City, State, Zip: #Trim(qCalendarTBA.city)#,
 #Trim(qCalendarTBA.state)# #Trim(qCalendarTBA.zip)#/CFIF
 
 #Trim(FORM.Message)#/CFIF
 /cfprocessingdirective
 
 We will follow up shortly regarding your e-mail message.
 
 

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: RE: certification experiences/plans?

2003-01-07 Thread Joe Eugene
Very interesting on what everybody has to say on Certification...

A certifcation lets you prove to YOURSELF how good you are with the specific area of 
development... and much more.
A very good example..
There are alot of questions asked on this list over and over again and alot of BAD 
CODE posted here... Well if those ppl really knew their stuff...took some time to 
study and understand all aspects of development We wouldnt be seeing those 
questions!.

Typically..most developers only know certain AREAS of development..cause thats what 
they mostly use... 

A Certification Requires you to KNOW all Areas/Aspects of the development language.

Before taking my Certification Exam, i had no clue of how CF Verity Engine worked or 
extensive details of implementation...Since i never had to implement it...

Certifcation Requires you to be able to Understand and be able to implement all 
aspects of the language. This also helps Employers evaluate your skills. Sometimes 5 
years of experience means nothing.. if you were only exposed to basic development.

Joe











---Original Message---
From: John Wilker [EMAIL PROTECTED]
Sent: 01/06/03 11:29 PM
To: CF-Talk [EMAIL PROTECTED]
Subject: RE: certification experiences/plans?

 
 I've never been asked or told my score. I think if someone asked they'd
be in the same group as the testers LOL

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: Jeffry Houser [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 06, 2003 8:28 PM
To: CF-Talk
Subject: RE: certification experiences/plans?


At 09:59 PM 1/6/2003 -0500, you wrote:

I think the CF exam is a much better indicator.  Be warned though that 
certification can actually hurt you.  If you're not certified, then the

employer just doesn't have that quantifier.  However, if you're 
certified and list that you're certified, they'll likely ask your 
score. If you barely passed, then it can look worse than not being 
certified.

  Wouldn't that fall under NDA ?
  I don't remember.
  I don't know if I would want to work under any employer who placed 
importance on my score.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
DotComIt, Putting you on the web
AIM: Reboog711  | Phone: 1-203-379-0773
--
My CFMX Book: 
http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20
My Books: http://www.instantcoldfusion.com
--
Ask me how to get a free recording of your band
--
Original Energetic Acoustic Rock: http://www.farcryfly.com 80's, 90's,
and Now: http://www.mtmexperience.com




~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: whats a black line around my cfdumped query mean?

2003-01-07 Thread Jon Block
Doh!... I just realized my deserialization tag wasn't set up right.

Thanks anyway,
Jon

-Original Message-
From: Jon Block [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 07, 2003 11:31 AM
To: CF-Talk
Subject: whats a black line around my cfdumped query mean?


I serialized my query object (recordset) to wddx. Later, I read it in and
need to CFOUTPUT over it again. For some reason, CF doesn't see it as a
native query and when I cfdump it, its got a black line going around the
outside of the table. How do I get my deserialized query to work like a
native query again?

Thanks,
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Christian Cantrell
The official word, as I'm sure you have all gathered by now, is that it  
is indeed true.  Most of the official announcements will happen later  
today, but the news is true and the software will be available today.

Christian

On Tuesday, January 7, 2003, at 10:57 AM, Ryan Mitchell wrote:

 Tell me this is true!?

 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

 Ryan

 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Dick Applebaum
Ryan

Actually, If you ever used the two side-by-side, I think you would  
prefer the CFMXJ2EE / JRun combo over CFMX Standalone server.  Lots of  
advantages.

This also brings the first J2EE-Certified app server to the Mac OS X  
platform

And --- best of all --- the UGLY port is dead!

Dick

If you have any trouble sounding condescending, find a Unix user to  
show you how it's done. -- Scott Adams


On Tuesday, January 7, 2003, at 08:10 AM, Ryan Mitchell wrote:

 Yeah, that will be the day that xserve takes over...


 On 7/1/03 16:05, Roberson, Jeff, Mr (Contractor) ACI
 [EMAIL PROTECTED] wrote:

 Unfortunately it's only the developers edition.

 When the standard (non-j2ee) version of CFMX runs there will be  
 dancing in
 the streets :)

 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 10:57 AM
 To: CF-Talk
 Subject: For the mac users out there


 Tell me this is true!?

 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

 Ryan



 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Robertson-Ravo, Neil (RX)
Yeah,  but its only the development version.

-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 16:39
To: CF-Talk
Subject: Re: For the mac users out there


The official word, as I'm sure you have all gathered by now, is that it  
is indeed true.  Most of the official announcements will happen later  
today, but the news is true and the software will be available today.

Christian

On Tuesday, January 7, 2003, at 10:57 AM, Ryan Mitchell wrote:

 Tell me this is true!?

 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

 Ryan

 

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: OT: HTML Question

2003-01-07 Thread paul smith
Nope.  Tried that.  Besides, check out the bible, HTML The Definitive 
Guide by Musciano  Kennedy.  They don't feel quotes are needed (where 
they are not needed ;-).

best,  paul

At 05:07 PM 1/7/03 +0100, you wrote:
snip bad html

You need a lot of quotes around tag attributes there.

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Christian Cantrell
On Tuesday, January 7, 2003, at 11:05 AM, Roberson, Jeff, Mr  
(Contractor) ACI wrote:

 Unfortunately it's only the developers edition.

 When the standard (non-j2ee) version of CFMX runs there will be  
 dancing in
 the streets :)

We will certainly keep our eye on the demand for other versions.  This  
was sort of the fastest  thing we could get tested and released to meet  
the immediate demand we knew was there.  Now we will see where things  
go from here.

Christian

 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 10:57 AM
 To: CF-Talk
 Subject: For the mac users out there


 Tell me this is true!?

 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

 Ryan


 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Mike Chambers
are you currently deploying production systems on OS X servers?

any input you have would be useful...

mike chambers

[EMAIL PROTECTED]

 -Original Message-
 From: Robertson-Ravo, Neil (RX) 
 [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, January 07, 2003 11:37 AM
 To: CF-Talk
 Subject: RE: For the mac users out there
 
 
 Yeah,  but its only the development version.
 
 -Original Message-
 From: Christian Cantrell [mailto:[EMAIL PROTECTED]]
 Sent: 07 January 2003 16:39
 To: CF-Talk
 Subject: Re: For the mac users out there
 
 
 The official word, as I'm sure you have all gathered by now, 
 is that it  
 is indeed true.  Most of the official announcements will 
 happen later  
 today, but the news is true and the software will be available today.
 
 Christian
 
 On Tuesday, January 7, 2003, at 10:57 AM, Ryan Mitchell wrote:
 
  Tell me this is true!?
 
  http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766
 
  Ryan
 
  
 
 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: Automated RDS file copy over SSL i.e. secure backup

2003-01-07 Thread Justin MacCarthy
how about this

Use rsync, tcpwrappers, and ssh.
Easy to automatic (command line)

This will give you, a very fast (rsnyc will only transfer the bits u need)
secure (ssh) , portable (linux/windows everything)  and free

All opensource...



 -Original Message-
 From: Mark W. Breneman [mailto:[EMAIL PROTECTED]]
 Sent: 07 January 2003 16:09
 To: CF-Talk
 Subject: Automated RDS file copy over SSL i.e. secure backup


 I know that RDS was never made for this but, I am looking for a way to
 securely copy down a database backup from a CF server.  I can
 browse to the
 file via RDS on a SSL connection and copy/paste the file but, I am hoping
 for some way to automate it, something like a command prompt or
 CFRDS tags.

 Anyone see anything like this?

 Mark W. Breneman
 -Macromedia Certified ColdFusion Developer
 -Network / Web Server Administrator
   Vivid Media
   [EMAIL PROTECTED]
   www.vividmedia.com
   608.270.9770

 
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Matt Liotta
 We will certainly keep our eye on the demand for other versions.  This
 was sort of the fastest  thing we could get tested and released to
meet
 the immediate demand we knew was there.  Now we will see where things
 go from here.
 
In other words, get it out the door in time for MacWorld.

-Matt

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Ryan Mitchell
You did well, thanks :)


On 7/1/03 16:44, Christian Cantrell [EMAIL PROTECTED] wrote:

 On Tuesday, January 7, 2003, at 11:05 AM, Roberson, Jeff, Mr
 (Contractor) ACI wrote:
 
 Unfortunately it's only the developers edition.
 
 When the standard (non-j2ee) version of CFMX runs there will be
 dancing in
 the streets :)
 
 We will certainly keep our eye on the demand for other versions.  This
 was sort of the fastest  thing we could get tested and released to meet
 the immediate demand we knew was there.  Now we will see where things
 go from here.
 
 Christian
 
 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 10:57 AM
 To: CF-Talk
 Subject: For the mac users out there
 
 
 Tell me this is true!?
 
 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766
 
 Ryan
 
 
 
 
~|
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.

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Robertson-Ravo, Neil (RX)
dont be daft?!

-Original Message-
From: Mike Chambers [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 16:47
To: CF-Talk
Subject: RE: For the mac users out there


are you currently deploying production systems on OS X servers?

any input you have would be useful...

mike chambers

[EMAIL PROTECTED]

 -Original Message-
 From: Robertson-Ravo, Neil (RX) 
 [mailto:[EMAIL PROTECTED]] 
 Sent: Tuesday, January 07, 2003 11:37 AM
 To: CF-Talk
 Subject: RE: For the mac users out there
 
 
 Yeah,  but its only the development version.
 
 -Original Message-
 From: Christian Cantrell [mailto:[EMAIL PROTECTED]]
 Sent: 07 January 2003 16:39
 To: CF-Talk
 Subject: Re: For the mac users out there
 
 
 The official word, as I'm sure you have all gathered by now, 
 is that it  
 is indeed true.  Most of the official announcements will 
 happen later  
 today, but the news is true and the software will be available today.
 
 Christian
 
 On Tuesday, January 7, 2003, at 10:57 AM, Ryan Mitchell wrote:
 
  Tell me this is true!?
 
  http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766
 
  Ryan
 
  
 
 

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Everett, Al
  We will certainly keep our eye on the demand for other versions.  This
  was sort of the fastest  thing we could get tested and released to meet
  the immediate demand we knew was there.  Now we will see where things
  go from here.
  
 In other words, get it out the door in time for MacWorld.

Tsk. So cynical.

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: OT: HTML Question

2003-01-07 Thread Jochem van Dieten
paul smith wrote:
 Nope.  Tried that.  Besides, check out the bible, HTML The Definitive 
 Guide by Musciano  Kennedy.  They don't feel quotes are needed (where 
 they are not needed ;-).

http://www.w3.org/TR/html401/intro/sgmltut.html#idx-attribute-6

% signs require quotes. And the way you currently define colors as hex 
values requires them to be prefixed with hash marks, which need to be 
quoted as well. http://www.w3.org/TR/html401/types.html#type-color

And don't get me started about XHTML.

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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Ryan Kime
God Bless Macromedia. CFMX development on my new PB!!! Woohoo


-Original Message-
From: Ryan Mitchell [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 9:57 AM
To: CF-Talk
Subject: For the mac users out there


Tell me this is true!?

http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

Ryan


~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Dick Applebaum
On Tuesday, January 7, 2003, at 08:37 AM, Robertson-Ravo, Neil (RX) 
wrote:

 Yeah,  but its only the development version.



There are a lot of suits in the Jobs Keynote audience!


Dick

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: For the mac users out there

2003-01-07 Thread Bud
On 1/7/03, Christian Cantrell penned:
We will certainly keep our eye on the demand for other versions.  This 
was sort of the fastest  thing we could get tested and released to meet 
the immediate demand we knew was there.  Now we will see where things
go from here.

I for one will be purchasing an XServe and CFMX the day a stable 
version is released for OSX. Until then, I'll likely keep chugging 
along with 4.5.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452
~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Robertson-Ravo, Neil (RX)
4.5?!  jeezo

-Original Message-
From: Bud [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2003 17:16
To: CF-Talk
Subject: Re: For the mac users out there


On 1/7/03, Christian Cantrell penned:
We will certainly keep our eye on the demand for other versions.  This 
was sort of the fastest  thing we could get tested and released to meet 
the immediate demand we knew was there.  Now we will see where things
go from here.

I for one will be purchasing an XServe and CFMX the day a stable 
version is released for OSX. Until then, I'll likely keep chugging 
along with 4.5.
-- 

Bud Schneehagen - Tropical Web Creations

_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
954.721.3452

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



Re: OT: HTML Question

2003-01-07 Thread paul smith
As I mentioned before, I had already tried quoting.  I just now added hash 
marks.  No change.  So whether or not they are needed, the absence of 
quotes or hash marks is not why Netscape 4.79 is being stubborn

best,  paul

At 05:56 PM 1/7/03 +0100, you wrote:
paul smith wrote:
  Nope.  Tried that.  Besides, check out the bible, HTML The Definitive
  Guide by Musciano  Kennedy.  They don't feel quotes are needed (where
  they are not needed ;-).

http://www.w3.org/TR/html401/intro/sgmltut.html#idx-attribute-6

% signs require quotes. And the way you currently define colors as hex
values requires them to be prefixed with hash marks, which need to be
quoted as well. http://www.w3.org/TR/html401/types.html#type-color

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



cgi CFMX

2003-01-07 Thread Robert Shaw
Hi All,
After upgrading from ColdFusion 5 to CFMX we can't read cgi variables -does 
anyone know if this changed? I couldn't find anything in the docs.

TIA,
Rob





~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



RE: For the mac users out there

2003-01-07 Thread Joshua Miller
Hey, no complaining! This is AWESOME! I'm glad to see that Macromedia is
listening!!! THANK YOU SO SO SO MUCH!!!

Joshua Miller
Head Programmer / IT Manager
Garrison Enterprises Inc.
www.garrisonenterprises.net
[EMAIL PROTECTED]
(704) 569-9044 ext. 254
 

*
Any views expressed in this message are those of the individual sender,
except where the sender states them to be the views of 
Garrison Enterprises Inc.
 
This e-mail is intended only for the individual or entity to which it is
addressed and contains information that is private and confidential. If
you are not the intended recipient you are hereby notified that any
dissemination, distribution or copying is strictly prohibited. If you 
have received this e-mail in error please delete it immediately and
advise us by return e-mail to [EMAIL PROTECTED]

*


-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED]] 
Sent: Tuesday, January 07, 2003 11:45 AM
To: CF-Talk
Subject: Re: For the mac users out there


On Tuesday, January 7, 2003, at 11:05 AM, Roberson, Jeff, Mr  
(Contractor) ACI wrote:

 Unfortunately it's only the developers edition.

 When the standard (non-j2ee) version of CFMX runs there will be
 dancing in
 the streets :)

We will certainly keep our eye on the demand for other versions.  This  
was sort of the fastest  thing we could get tested and released to meet

the immediate demand we knew was there.  Now we will see where things  
go from here.

Christian

 -Original Message-
 From: Ryan Mitchell [mailto:[EMAIL PROTECTED]]
 Sent: Tuesday, January 07, 2003 10:57 AM
 To: CF-Talk
 Subject: For the mac users out there


 Tell me this is true!?

 http://www.macworld.co.uk/news/main_news.cfm?NewsID=5766

 Ryan


 

~|
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

Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4



  1   2   3   4   >