Re: SOT Converting MS-Access databases on non-windows machines

2002-10-10 Thread Dick Applebaum

Just to follow through on this -- I am posting similar messages to the  
CF-Linux list.

If you run CFMX on a non-windows box, you *can* directly interface  
MS-Access databases!

So everyone is clear, I don't propose to use MS-Access as a production  
online db -- just as a means of converting data to/from offline  
MS-Access databases to more robust online RDBMSes.

OpenLink Software has a package that allows you to establish a TCP/IP  
connection between CFMX and mdb filles on real or emulated windows.   
MS-Access can be running, or not -- against the same mdbs, or not.

The OpenLink solution is $500, which seems a little pricey, at first,   
But, when you consider the cost of Win OS, MS Office, an emulator, it's  
not too bad.

If you ever have the need to move data between MS-Access and more  
robust online RDBMSes, you can easily recover the cost of OpenLink --  
You can write CF programs to move the data directly -- no messing  
around with incompetent wizards,  CSV files, temp dbs, incompatible  
datatypes, etc.

An added benefit is that the conversion logic is captured in CF  
programs-- and is repeatable.

The $500 cost is for a retail product -- OpenLink does not currently  
have a developer offering for this package -- but they are looking into  
it.

OpenLink Software is at:

http://www.openlinksw.com

As a longtime Mac user, I was used to not being able to use MS-Access  
databases except under emulation.

With the advent of Mac OS X (Unix) and the port of CFMX  (Linux), I  
assumed that finally I would be able to interface MS-Access databases  
from CFMX.

I was surprised that I couldn't interface MS-Access databases directly  
from CFMX Linux -- no way, no how.  (according to answers to this  
thread on CF-Talk, CF-Linux and other sources)

To get that capability, you must run CFMX on windows (in my case this  
means emulated windows -- not really an option).

Some digging revealed the OpenLink solution.

I have benn fooling around for the kast day, or so, converting a 33 meg  
client mdb to a Sybase ASE database -- creating tables, validating  
data, normalizing and populating -- with CFMX programs.  I am using the  
same programs that I used several years ago to convert from MS-Access  
to SQL-Server with everything running on windows platform.

Now, CFMX  Sybase run native on Mac OS X -- the mdbs are on a  
VirtualPC emulated windows (Ive tested both NT  XP).   I am told that  
this could all run on Linux, with VMWare or wine in plave of VirtualPC.

  it just works!

To say it again:

If you run CFMX on a non-windows box, you *can* directly interface  
MS-Access databases!

I am pretty excited about this!

Thanks for all the help  responses

Dick


On Wednesday, October 9, 2002, at 04:23 PM, Jochem van Dieten wrote:

 Dick Applebaum wrote:
 On Wednesday, October 9, 2002, at 10:39 AM, Jochem van Dieten wrote:

 - use a utility to move the data (available for most open source
 databases such as PostgreSQL and MySQL).

 Can you point me to a reference?

 http://pgadmin.postgresql.org/pgadmin2.php?ContentID=1
 http://www.google.com/search?q=mysql+access+converterspell=1


 Is it true that you these utilities create a mirror (MySQL or
 PostgreSQL) db as an intermediate to the ultimate target RDBMS?

 They usually just take the data and move it. Normalization etc. still
 has to be handled by the programmer later, but it does not require a
 separate database, just some separate tables to store the data  
 temporarily.


 - make an ODBC datasource for the RDBMS you are going to use, create
 the
 tables in it and use Access linked tables to move the data over.


 As I understand this, you are essentially mirroring the Access tables
 on equivalent target RDBMS, and copying over the data.  Any  
 validation,
 normalization then uses the target RDBMS  linked tables as a source.

 So the target RDBMS Access linked tables are an intermediate step/copy
 of the data.

 Yes.


 - export the data as .csv and read it into the new database

 The last to can also move data in the other direction.



 These both involve intermediate files or databases, correct?

 Intermediate files and tables, not necessarily databases.


 What I am looking for is a solution where I can write a CF program  
 that:

1)  runs on a non-win platform
2) can read/write MS-Access dbs directly (no intermediate files or
 dbs)

 Hadn't I read your OpenLink comment, I woud have said that these 2
 already are conflicting (unless you count virtual PC simulators). But
 OpenLink like software is what you need.

 Jochem

 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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.



Problem with a dynamic menu and loops.

2002-10-10 Thread Adams, Stephen

**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**

Hi,

I am building an Intranet that has a menu for the company departments.  This
menu is populated by a query that returns the department name, title,
description, filename and the page URL. When a Department is selected the
page goes to that particular departments homepage and the menu expands to
display all the pages underneath that department, e.g. 

Human Resources
 - Holiday Form
 - Sick Pay
 - Contact HR

My problem is that I want to have the selected department appear at the top
of my series of departments, and still keep the other departments in
alphabetical order.  So I'd have:

Human Resources
 - Holiday Form
 - Sick Pay
 - Contact HR
Customer Service
Finance
Planning

Has anyone tried something like this before, or has any idea how I can do
this?

Thanks

Stephen


**
Westminster City Council switchboard: 
+44 20 7641 6000
**
This E-Mail may contain information which is 
privileged, confidential and protected from 
disclosure.  If you are not the intended recipient 
of this E-mail or any part of it, please telephone 
Westminster City Council immediately on receipt.
You should not disclose the contents to any other 
person or take copies.
**

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



RE: Browser Usage

2002-10-10 Thread Steve Green

A site i visit regular for forums and stuff (non developer) published their
monthly stats recently.

Something like 94% IE .. 6% Other.

I was amazed IE was that high.

SteG.

-Original Message-
From: Srimanta [mailto:[EMAIL PROTECTED]]
Sent: 10 October 2002 00:50
To: CF-Talk
Subject: OT: Browser Usage


Hi All,

Does any one know what percentage of users use/ prefer 
Netscape 4.5 or 6  over IE.

Thanks

S






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



Re: html inserted via SQL directly from template?

2002-10-10 Thread Jochem van Dieten

cfsavefcontent ..
P
SPAN class=Smaller style=COLOR: #80
STRONGWhat's the deal?/STRONG
/SPAN
/P
/cfsavecontent

cfqueryy .
INSERT INTO table (field)
VALUES (cfquerypatam cfsqltype=cf_sql_varchar value=#variable#
/cfquery

Jochem

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Browser Usage

2002-10-10 Thread Mark Stephenson - Evolution Internet

So far this month we are about 95% IE 5% AOL... NO Netscape or anything
else...  But we are usually at about 5% other as well...

Mark Stephenson
New Media Director
Evolution Internet
T: 0870 757 1631
F: 0870 757 1632
W: www.evolutioninternet.co.uk
E: [EMAIL PROTECTED]


WARNING:
---
The information contained in this document and attachments is confidential
and intended only for the person(s) named above.  If you are not the
intended recipient you are hereby notified that any disclosure, copying,
distribution, or any other use of the information is strictly prohibited.
If you have received this document by mistake, please notify the sender
immediately and destroy this document and attachments without making any
copy of any kind.

AVIS IMPORTANT:
---
Les informations contenues dans le present document et ses pieces jointes
sont strictement confidentielles et reservees a l'usage de la (des)
personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez
avise que toute divulgation, distribution, copie, ou autre utilisation de
ces informations est strictement prohibee.  Si vous avez recu ce document
par erreur, veuillez s'il vous plait communiquer immediatement avec
l'expediteur et detruire ce document sans en faire de copie sous quelque
forme.




-Original Message-
From: Steve Green [mailto:[EMAIL PROTECTED]]
Sent: 10 October 2002 09:55
To: CF-Talk
Subject: RE: Browser Usage


A site i visit regular for forums and stuff (non developer) published their
monthly stats recently.

Something like 94% IE .. 6% Other.

I was amazed IE was that high.

SteG.

-Original Message-
From: Srimanta [mailto:[EMAIL PROTECTED]]
Sent: 10 October 2002 00:50
To: CF-Talk
Subject: OT: Browser Usage


Hi All,

Does any one know what percentage of users use/ prefer
Netscape 4.5 or 6  over IE.

Thanks

S







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



RE: Browser Usage

2002-10-10 Thread Thomas Chiverton

 A site ... (non developer)
 Something like 94% IE .. 6% Other.
 I was amazed IE was that high.

Why ?
Amongst Joe Public, Mozilla/Netscape are not even on the radar, let alone
Opera and the rest.

Tom Chiverton
You don't have to be a mad scientist to believe in ColdFusion




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



RE: Problem with a dynamic menu and loops.

2002-10-10 Thread Thomas Chiverton

   Human Resources
- Holiday Form
- Sick Pay
- Contact HR
   Customer Service
   Finance
   Planning

Pseudo code below:

print selctedDepartment
loop over departments, order by title
if thisDepartment is not selectedDepartment
print thisDepartment
fi
pool

Easy :-)

Tom Chiverton
You don't have to be a mad scientist to believe in ColdFusion

 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



Wondering about good languages for financial math processing

2002-10-10 Thread Dave Wilson

Hi all,

In the past I've been piggy backing on Excel via COM in order to do some
calculations as ColdFusion isn't the best of tools for performing
mathematical routines. Now, this is not ideal either as it requires Excel to
be installed on the server and takes up valuable processing time.

Does anyone have any suggestions as to any good languages suited for
mathematical processing? Preferably with the ability to connect or extract
results easily. I've heard that Java isn't really suited for mathematical
work either [1]. Perhaps C++ would do the job? I want to avoid COM at this
stage considering:

a) CFMX doesnt work too well with COM now;
b) COM is becoming an obsolete technology with MS pushing .Net and web
services instead.

TIA,
Dave

[1] I was told by a friend studying for his MSc Comp Sci. so I could be
completely wrong in my presumptions about Java being unsuited for
mathematical work.

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



RE: Single Sign On

2002-10-10 Thread Weaver, Anthony

This also assumes you are not using a fully-qualified domain name.  IE is
set by default not to pass your NT credentials to FQDN URLs.  You can change
this by adding the destination as a trusted site.

-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 1:08 AM
To: CF-Talk
Subject: RE: Single Sign On


I may be misunderstanding your question, but if you need the NT
domain/user info, it's available in the variable CGI.AUTH_USER.  This is
assuming your Web Server is a member of the same domain as the client
computer.

-Cameron

-
Cameron Childress
Sumo Consulting Inc.
---
cell:  678-637-5072
aim:   cameroncf
email: [EMAIL PROTECTED]


 -Original Message-
 From: Sean McCarthy [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, October 09, 2002 11:36 PM
 To: CF-Talk
 Subject: Single Sign On


 I need to get the win nt network user name to do authorization for an
 intranet.  The only options I found in my search are:

 -the persistent cookie (which will still require one login)

 -custom configuration of a browser to auto login (not if sure if this will
 make the user name available?)

 -A certificate server to issue client certificates (user name available?)

 -A .dll or class(es) to do this?  If this is the case, can you please
 recommend some good choices.


 Info: NT 4 domain / iis 5 / cf 5



 Thanks for your help

 sean
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: not another mx boo boo

2002-10-10 Thread Weaver, Anthony

Ain't America great

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 2:08 PM
To: CF-Talk
Subject: RE: not another mx boo boo


Yes,I know where his emails come from.  However he makes many comments to
his employer and references to it, does not try all that hard to seperate
the two.  Heck when he made insultive remarks about the EfNet CF community
on this list, he had experienced his stay(breifly as it might have been) via
work, he got on from a IP at macromedia.com.  But I see now, as long as you
use a outside media you can then pick and choice when you represent your
company and when you just want to be a jerk.  Good think I represent no one,
means I can be a childish person all the time.

-- Original Message --
From: Fitch, Tyler [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Wed, 9 Oct 2002 10:46:54 -0600

Just because Sean works at MM doesn't mean he can't speak _his_ mind.

All his emails come from his personal address, not a MM address.  He's
able to say his own thoughts.  He just happens to have access to lots of
inside CF information at his work.

t

**
Tyler M. Fitch
Certified Advanced ColdFusion 5 Developer
http://isitedesign.com
**

-Original Message-
From: Aaron Rouse [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 09, 2002 8:09 AM
To: CF-Talk
Subject: re: not another mx boo boo


From best I can tell it is in fact part of his job.  It is good to see
that MM has employees out in these circles to best represent company
with such attitudes and at times insulting behavior.  Anyone know who we
could contact at MM via smail to compliment such things?

Oh, wait, nevermind I am just part of that childish group(Sean The MM
hat wearer words).

 Sean, You're not impressing me with your defensive
 attitude. Is all this arguing really part of your  job?

--
Snipe - CF_BotMaster Network=EFNet Channel=ColdFusion
--



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



Visual Source Safe and CF Studio

2002-10-10 Thread Jeffry Houser

  I'm sure this (or similar issues) have come up before, but... I can't log 
into the archives (I have no idea what my username and password is), I 
can't register because it says I'm already registered, and when I click the 
go here if you forgot link nothing happens.  There is nothing in the CF 
FAQ (I looked) and I tried searching on Macromedia KB (all links are broken 
from the search) and on Google.

  With all that said, here is my query.

  How does CF Studio integrate with Visual Source Safe?

  I came onto a project and they want to use VSS.  That's is all fine and 
dandy.  They provided me with a copy.  They already have the VSS database 
set up, which I am accessing via a mapped drive.
  The CF Studio documentation talks about setting up a project in CF Studio 
and then integrating it with VSS.  But, how do I take the VSS database and 
turn it into a CF Studio project?

  It seems to me that VSS is intended to copy the file locally.  That 
doesn't do much good if I am accessing the file remotely via RDS.  Checking 
it back in will copy the unchanged version back up to the site.  That 
doesn't seem like the ideal situation.

  I think I'm probably missing something important with regards to Source 
Control.



--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
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
My Band: http://www.farcryfly.com 

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



RE: Visual Source Safe and CF Studio

2002-10-10 Thread Thomas Chiverton

   How does CF Studio integrate with Visual Source Safe?

Very well, I've used it in the past.

   It seems to me that VSS is intended to copy the file locally.  That
   I think I'm probably missing something important with regards to Source
 Control.

Well, if it didn't copy it to local storage, how would you be able to edit
it ?

I think the way round it is to check things out to a local project, and then
use Studio's deploy functions to send them up to the RDS server when ya
done.

Tom Chiverton
You don't have to be a mad scientist to believe in ColdFusion




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: CF Currency Conversion

2002-10-10 Thread Everett, Al

Sounds like a Web Service to me.

Here's four I found at xmethods.com:

http://www.xmethods.com/ve2/ViewListing.po?serviceid=102592
http://www.xmethods.com/ve2/ViewListing.po?serviceid=94320
http://www.xmethods.com/ve2/ViewListing.po?serviceid=96
http://www.xmethods.com/ve2/ViewListing.po?serviceid=5

 -Original Message-
 From: Srimanta [mailto:[EMAIL PROTECTED]]
 Sent: Wednesday, October 09, 2002 8:39 PM
 To: CF-Talk
 Subject: CF  Currency Conversion
 
 
 Hi All,
 Is there a CF tag availabe that can convert currency values 
 depending on
 user selection (country)?
 I have a CF application which requires displaying currency 
 values depending
 on the exchange rates.
 The default currency is Australian Dollars. However users  
 need to see other
 values eg NZ Dollars,
 UK Pounds, HKDollars, US dollars etc. Changes have to be real time.
 I have seen similar in some ASP run websites.
 Any ideas as to how to implement it in CF  ?
 
 Thanks
 
 Srimanta
 
 
 - Original Message -
 From: Jochem van Dieten [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Thursday, October 10, 2002 12:25 PM
 Subject: Re: OT: SQL Question
 
 
  Tony Carcieri wrote:
   Hi all,
  
   Here's what I want to do:
   UPDATE tablename
   SET column = 0
   WHERE ID = ???
  
   I want to specify a range of numbers (like 100-200) and 
 increment it by
 2.
   So, 100, 102,104etc would only be updated and the rest wouldn't.
 
  WHERE
  ID BETWEEN 100 AND 200
  AND MOD(ID, 2) = 0
 
  Jochem
 
 
  
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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.



BigIP

2002-10-10 Thread Everett, Al

Anybody using the BigIP load balancer from F5? Have you had any problems
with sticky sessions?


-- 
Al Everett
Allied Office Products
www.askallied.com
mailto:[EMAIL PROTECTED]
v: 973-594-3209
f: 973-594-3626
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Visual Source Safe and CF Studio

2002-10-10 Thread Jeffry Houser

At 01:08 PM 10/10/2002 +0100, you wrote:
How does CF Studio integrate with Visual Source Safe?

Very well, I've used it in the past.

It seems to me that VSS is intended to copy the file locally.  That
I think I'm probably missing something important with regards to Source
  Control.

Well, if it didn't copy it to local storage, how would you be able to edit
it ?

I think the way round it is to check things out to a local project, and then
use Studio's deploy functions to send them up to the RDS server when ya
done.

  It is all becoming clear (sort of)
  However, if all the other developers are editing on Server A, wouldn't I 
have to be editing on the same server for the VSS to have any effect?


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
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
My Band: http://www.farcryfly.com 

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



Re: Visual Source Safe and CF Studio

2002-10-10 Thread Patric Stumpe

Hi Jeffry,

when you log any file out via CFStudio it becomes marked ni VSS on the
server. At least it should be.

Patric


JH At 01:08 PM 10/10/2002 +0100, you wrote:
How does CF Studio integrate with Visual Source Safe?

Very well, I've used it in the past.

It seems to me that VSS is intended to copy the file locally.  That
I think I'm probably missing something important with regards to Source
  Control.

Well, if it didn't copy it to local storage, how would you be able to edit
it ?

I think the way round it is to check things out to a local project, and then
use Studio's deploy functions to send them up to the RDS server when ya
done.

JH   It is all becoming clear (sort of)
JH   However, if all the other developers are editing on Server A, wouldn't I 
JH have to be editing on the same server for the VSS to have any effect?


JH --
JH Jeffry Houser | mailto:[EMAIL PROTECTED]
JH Need a Web Developer?  Contact me!
JH AIM: Reboog711  | Phone: 1-203-379-0773
JH --
JH My CFMX Book: 
JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20
JH My Books: http://www.instantcoldfusion.com
JH My Band: http://www.farcryfly.com 

JH 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: cfinclude inside a cffile tag?

2002-10-10 Thread Les Mizzell

Morning,

Thanks for all your help on this so far. I've still got one more problem
that I'm scratching my head over. The cfinclude template app_OUTPUT.cfm
contains HTML formatting. However, when the file #MyFile# is generated, the
HTML doesn't render - I'm actually seeing the raw HTML code in the file as
below:

br0001nbsp;nbsp;3.00 W
br00ANN
br01A01nbsp;nbsp


Code below (thanks for your help) works perfectally except for the HTML
rendering...


cfsavecontent variable=sqlOutput
  cfinclude template=app_OUTPUT.cfm
/cfsavecontent

cffile action=WRITE
file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
output=#sqlOutput#
addnewline=Yes

cfheader
name=content-disposition
value=attachment; filename=#MyFile#

cfcontent type=text/html
file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
deletefile=No reset=Yes


Ideas??

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



CF Changed ip access

2002-10-10 Thread Robert Everland

I have been using CF 5 developer edition for some time on my machine. All of
a suddent yesterday it changed it's ip address access from 127.0.0.1 to
10.100.100.195 which is my local ip. For one shouldn't this not be allowed
cause technically I just got a free copy of CF that anyone in the company
can access now, so how do I change it back?

Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



Custon Tag for opening/editing graphic files or PDF?

2002-10-10 Thread FlashGuy

Is there such a beast?



---
Colonel Nathan R. Jessop
Commanding Officer
Marine Ground Forces
Guatanamo Bay, Cuba
---



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



RE: CF Changed ip access

2002-10-10 Thread Ken Wilson

How many other folks at your company have 10.100.100.195 as their IP#?
:)



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:18 AM
To: CF-Talk
Subject: CF Changed ip access


I have been using CF 5 developer edition for some time on my machine.
All of a suddent yesterday it changed it's ip address access from
127.0.0.1 to 10.100.100.195 which is my local ip. For one shouldn't this
not be allowed cause technically I just got a free copy of CF that
anyone in the company can access now, so how do I change it back?

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

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



RE: CF Changed ip access

2002-10-10 Thread Lee Fuller

Was just going to ask that question.  ;)



| -Original Message-
| From: Ken Wilson [mailto:[EMAIL PROTECTED]] 
| Sent: Thursday, October 10, 2002 6:30 AM
| To: CF-Talk
| Subject: RE: CF Changed ip access
| 
| 
| How many other folks at your company have 10.100.100.195 as their IP#?
| :)
| 
| 
| 
| -Original Message-
| From: Robert Everland [mailto:[EMAIL PROTECTED]] 
| Sent: Thursday, October 10, 2002 9:18 AM
| To: CF-Talk
| Subject: CF Changed ip access
| 
| 
| I have been using CF 5 developer edition for some time on my 
| machine. All of a suddent yesterday it changed it's ip 
| address access from 127.0.0.1 to 10.100.100.195 which is my 
| local ip. For one shouldn't this not be allowed cause 
| technically I just got a free copy of CF that anyone in the 
| company can access now, so how do I change it back?
| 
| Robert Everland III
| Web Developer Extraordinaire
| Dixon Ticonderoga Company
| http://www.dixonusa.com 
| 
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: CF-Talk-list V1 #377

2002-10-10 Thread Govind Bhat

We do but no problems with sessions. What problem did you encounter?

Regards
Govind Bhat
www.50plus.com

-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 9:37 AM
To: [EMAIL PROTECTED]
Subject: CF-Talk-list V1 #377


CF-Talk-list   Thu, 10 Oct 2002  Volume 1 : Number
377

In this issue:

BigIP
RE: Visual Source Safe and CF Studio
Re: Visual Source Safe and CF Studio
RE: cfinclude inside a cffile tag?
CF Changed ip access
Custon Tag for opening/editing graphic files or PDF?
RE: CF Changed ip access
RE: CF Changed ip access


--

Date: Thu, 10 Oct 2002 08:58:20 -0400
From: Everett, Al [EMAIL PROTECTED]
Subject: BigIP
Message-ID: 319208EE9192D511AC590060979B532901F98B6B@EXCHSV01

Anybody using the BigIP load balancer from F5? Have you had any problems
with sticky sessions?


-- 
Al Everett
Allied Office Products
www.askallied.com
mailto:[EMAIL PROTECTED]
v: 973-594-3209
f: 973-594-3626
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com




Re: Visual Source Safe and CF Studio

2002-10-10 Thread Jeffry Houser

  Okay, that makes sense.  I can't figure out how to fill a CF Studio 
project with files over RDS, though.
  It hasn't helped that the server was inaccessible by me this morning, 
though.


At 03:07 PM 10/10/2002 +0200, you wrote:
Hi Jeffry,

when you log any file out via CFStudio it becomes marked ni VSS on the
server. At least it should be.

Patric


JH At 01:08 PM 10/10/2002 +0100, you wrote:
 How does CF Studio integrate with Visual Source Safe?
 
 Very well, I've used it in the past.
 
 It seems to me that VSS is intended to copy the file locally.  That
 I think I'm probably missing something important with regards to 
 Source
   Control.
 
 Well, if it didn't copy it to local storage, how would you be able to edit
 it ?
 
 I think the way round it is to check things out to a local project, and 
 then
 use Studio's deploy functions to send them up to the RDS server when ya
 done.

JH   It is all becoming clear (sort of)
JH   However, if all the other developers are editing on Server A, 
wouldn't I
JH have to be editing on the same server for the VSS to have any effect?


JH --
JH Jeffry Houser | mailto:[EMAIL PROTECTED]
JH Need a Web Developer?  Contact me!
JH AIM: Reboog711  | Phone: 1-203-379-0773
JH --
JH My CFMX Book:
JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20
JH My Books: http://www.instantcoldfusion.com
JH My Band: http://www.farcryfly.com

JH

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Another MX boo boo

2002-10-10 Thread Michael Corbridge

Rob,

I get:

dateFormat(now(), dd/mm/yy (ddd)) = 10/10/02 (Thu)

on my CFMX server.

Are you still experiencing difficulties, and let me know if you are.

Thanks,

michael d corbridge
macromedia
617.219.2307
[EMAIL PROTECTED]


-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 5:07 PM
To: CF-Talk
Subject: Another MX boo boo


dateFormat(now(), dd/mm/yy (ddd))

No longer works in MX. looks like only certain characters work in date
format.

Rob


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: CF Changed ip access

2002-10-10 Thread Robert Everland

Ehhh it's the morning, still, how do I change it back.

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

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:30 AM
To: CF-Talk
Subject: RE: CF Changed ip access


How many other folks at your company have 10.100.100.195 as their IP#?
:)



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:18 AM
To: CF-Talk
Subject: CF Changed ip access


I have been using CF 5 developer edition for some time on my machine. All of
a suddent yesterday it changed it's ip address access from 127.0.0.1 to
10.100.100.195 which is my local ip. For one shouldn't this not be allowed
cause technically I just got a free copy of CF that anyone in the company
can access now, so how do I change it back?

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


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



OT: Query Analyzer on Win95

2002-10-10 Thread Mitko Gerensky-Greene

Hello,

I want to be able to run Query Analyzer for SQL Server 7 or 2000 on a Windows 95 
machine. Is this possible? I tried installing from a SQL Server 2000 Standard Edition 
but the only thing it offered to install were the Client Connectivity Tools and 
English Query. Is there any place where I could get the Query Analizer as a 
stand-alone tool? Perhaps from Visual Studio?

Thanks in advance,

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



RE: Visual Source Safe and CF Studio

2002-10-10 Thread Lee Fuller

On a slightly different note..  Anyone have experience with Dreamweaver
MX and VSS?  Work as well as Studio/VSS?

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



RE: CF Changed ip access

2002-10-10 Thread Lee Fuller

If you want to simply change your IP address, visit the Network
Connections option in your Control Panel.  Assuming you're using Win 2K
or XP, you can right-click on the connection (typically Local Area
Connection) in the listing and select Properties.   Then select
TCP/IP ... and click Properties.  In that dialog, you'll see the IP
address of the machine.

HTH



| -Original Message-
| From: Robert Everland [mailto:[EMAIL PROTECTED]] 
| Sent: Thursday, October 10, 2002 6:38 AM
| To: CF-Talk
| Subject: RE: CF Changed ip access
| 
| 
| Ehhh it's the morning, still, how do I change it back.
| 
| Robert Everland III
| Web Developer Extraordinaire
| Dixon Ticonderoga Company
| http://www.dixonusa.com 
| 
| -Original Message-
| From: Ken Wilson [mailto:[EMAIL PROTECTED]] 
| Sent: Thursday, October 10, 2002 9:30 AM
| To: CF-Talk
| Subject: RE: CF Changed ip access
| 
| 
| How many other folks at your company have 10.100.100.195 as their IP#?
| :)
| 
| 
| 
| -Original Message-
| From: Robert Everland [mailto:[EMAIL PROTECTED]] 
| Sent: Thursday, October 10, 2002 9:18 AM
| To: CF-Talk
| Subject: CF Changed ip access
| 
| 
| I have been using CF 5 developer edition for some time on my 
| machine. All of a suddent yesterday it changed it's ip 
| address access from 127.0.0.1 to 10.100.100.195 which is my 
| local ip. For one shouldn't this not be allowed cause 
| technically I just got a free copy of CF that anyone in the 
| company can access now, so how do I change it back?
| 
| Robert Everland III
| Web Developer Extraordinaire
| Dixon Ticonderoga Company
| http://www.dixonusa.com 
| 
| 
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: CF Changed ip access

2002-10-10 Thread Ken Wilson

Restart the CF service.




-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:38 AM
To: CF-Talk
Subject: RE: CF Changed ip access


Ehhh it's the morning, still, how do I change it back.

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

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:30 AM
To: CF-Talk
Subject: RE: CF Changed ip access


How many other folks at your company have 10.100.100.195 as their IP#?
:)



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:18 AM
To: CF-Talk
Subject: CF Changed ip access


I have been using CF 5 developer edition for some time on my machine.
All of a suddent yesterday it changed it's ip address access from
127.0.0.1 to 10.100.100.195 which is my local ip. For one shouldn't this
not be allowed cause technically I just got a free copy of CF that
anyone in the company can access now, so how do I change it back?

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



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Visual Source Safe and CF Studio

2002-10-10 Thread Ken Wilson

I don't believe Projects work with RDS. Project are based on local or
mapped drives.

Ken



-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:39 AM
To: CF-Talk
Subject: Re: Visual Source Safe and CF Studio


  Okay, that makes sense.  I can't figure out how to fill a CF Studio 
project with files over RDS, though.
  It hasn't helped that the server was inaccessible by me this morning, 
though.


At 03:07 PM 10/10/2002 +0200, you wrote:
Hi Jeffry,

when you log any file out via CFStudio it becomes marked ni VSS on the 
server. At least it should be.

Patric


JH At 01:08 PM 10/10/2002 +0100, you wrote:
 How does CF Studio integrate with Visual Source Safe?
 
 Very well, I've used it in the past.
 
 It seems to me that VSS is intended to copy the file locally.
That
 I think I'm probably missing something important with regards 
   to
 Source
   Control.
 
 Well, if it didn't copy it to local storage, how would you be able 
 to edit it ?
 
 I think the way round it is to check things out to a local project, 
 and
 then
 use Studio's deploy functions to send them up to the RDS server when

 ya done.

JH   It is all becoming clear (sort of)
JH   However, if all the other developers are editing on Server A,
wouldn't I
JH have to be editing on the same server for the VSS to have any 
JH effect?


JH --
JH Jeffry Houser | mailto:[EMAIL PROTECTED]
JH Need a Web Developer?  Contact me!
JH AIM: Reboog711  | Phone: 1-203-379-0773
JH --
JH My CFMX Book: 
JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20
JH 
JH My Books: http://www.instantcoldfusion.com
JH My Band: http://www.farcryfly.com

JH


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: CF Changed ip access

2002-10-10 Thread Everett, Al

Well, if 10.100.100.195 is a gateway or proxy server...

 -Original Message-
 From: Ken Wilson [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 9:30 AM
 To: CF-Talk
 Subject: RE: CF Changed ip access
 
 
 How many other folks at your company have 10.100.100.195 as their IP#?
 :)
 
 
 
 -Original Message-
 From: Robert Everland [mailto:[EMAIL PROTECTED]] 
 Sent: Thursday, October 10, 2002 9:18 AM
 To: CF-Talk
 Subject: CF Changed ip access
 
 
 I have been using CF 5 developer edition for some time on my machine.
 All of a suddent yesterday it changed it's ip address access from
 127.0.0.1 to 10.100.100.195 which is my local ip. For one 
 shouldn't this
 not be allowed cause technically I just got a free copy of CF that
 anyone in the company can access now, so how do I change it back?
 
 Robert Everland III
 Web Developer Extraordinaire
 Dixon Ticonderoga Company
 http://www.dixonusa.com 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: CF Changed ip access

2002-10-10 Thread Robert Everland

That fixed it.

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

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:52 AM
To: CF-Talk
Subject: RE: CF Changed ip access


Restart the CF service.




-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:38 AM
To: CF-Talk
Subject: RE: CF Changed ip access


Ehhh it's the morning, still, how do I change it back.

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

-Original Message-
From: Ken Wilson [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:30 AM
To: CF-Talk
Subject: RE: CF Changed ip access


How many other folks at your company have 10.100.100.195 as their IP#?
:)



-Original Message-
From: Robert Everland [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 9:18 AM
To: CF-Talk
Subject: CF Changed ip access


I have been using CF 5 developer edition for some time on my machine. All of
a suddent yesterday it changed it's ip address access from 127.0.0.1 to
10.100.100.195 which is my local ip. For one shouldn't this not be allowed
cause technically I just got a free copy of CF that anyone in the company
can access now, so how do I change it back?

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




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: CF-Talk-list V1 #377

2002-10-10 Thread Everett, Al

BigIP is not honoring sticky sessions. We want a user that his server1 for
instance, to stay on server1 for the duration of his/her visit. Users are
being logged out at random because apparently they are getting bounced from
the server they started on (and where their session variables are) to
another server.

It USED to be fine. What I'm wondering is if there are any settings I can
suggest to the network guys to look at. (I'm only a lowly Web Developer
after all. My job is to be the first to have the finger pointed at him when
ANYTHING on the website goes wrong.) F5 has been unhelpful.


p.s. Yes, Client Variables and Database values instead of Session and
Application variables would probably help here, but that's not the direction
from on high.


 -Original Message-
 From: Govind Bhat [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 9:40 AM
 To: CF-Talk
 Subject: RE: CF-Talk-list V1 #377
 
 
 We do but no problems with sessions. What problem did you encounter?
 
 Regards
 Govind Bhat
 www.50plus.com
 
 -Original Message-
 From: [EMAIL PROTECTED]
 [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 9:37 AM
 To: [EMAIL PROTECTED]
 Subject: CF-Talk-list V1 #377
 
 
 CF-Talk-list   Thu, 10 Oct 2002  
 Volume 1 : Number
 377
 
 In this issue:
 
 BigIP
 RE: Visual Source Safe and CF Studio
 Re: Visual Source Safe and CF Studio
 RE: cfinclude inside a cffile tag?
 CF Changed ip access
 Custon Tag for opening/editing graphic files or PDF?
 RE: CF Changed ip access
 RE: CF Changed ip access
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Visual Source Safe and CF Studio

2002-10-10 Thread Jeffry Houser

  That would be on par with what I'm seeing.

  So, I'm suppose to work on a remote server via RDS in conjunction with 
visual source safe, and it just ain't seeming possible.  Ain't life 
grand.  : chuckle:  I guess it is time for a local copy of some sort.

  Thanks all!

At 09:53 AM 10/10/2002 -0400, you wrote:
I don't believe Projects work with RDS. Project are based on local or
mapped drives.

Ken



-Original Message-
From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 9:39 AM
To: CF-Talk
Subject: Re: Visual Source Safe and CF Studio


   Okay, that makes sense.  I can't figure out how to fill a CF Studio
project with files over RDS, though.
   It hasn't helped that the server was inaccessible by me this morning,
though.


At 03:07 PM 10/10/2002 +0200, you wrote:
 Hi Jeffry,
 
 when you log any file out via CFStudio it becomes marked ni VSS on the
 server. At least it should be.
 
 Patric
 
 
 JH At 01:08 PM 10/10/2002 +0100, you wrote:
  How does CF Studio integrate with Visual Source Safe?
  
  Very well, I've used it in the past.
  
  It seems to me that VSS is intended to copy the file locally.
That
  I think I'm probably missing something important with regards
to
  Source
Control.
  
  Well, if it didn't copy it to local storage, how would you be able
  to edit it ?
  
  I think the way round it is to check things out to a local project,
  and
  then
  use Studio's deploy functions to send them up to the RDS server when

  ya done.
 
 JH   It is all becoming clear (sort of)
 JH   However, if all the other developers are editing on Server A,
 wouldn't I
 JH have to be editing on the same server for the VSS to have any
 JH effect?
 
 
 JH --
 JH Jeffry Houser | mailto:[EMAIL PROTECTED]
 JH Need a Web Developer?  Contact me!
 JH AIM: Reboog711  | Phone: 1-203-379-0773
 JH --
 JH My CFMX Book:
 JH 
 http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20JH 
 JH My Books: http://www.instantcoldfusion.com
 JH My Band: http://www.farcryfly.com
 
 JH
 


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



Re: Visual Source Safe and CF Studio

2002-10-10 Thread Patric Stumpe

Weel that's what I mean to recall too. Jeff said he had a mapped
drive, so it shouldn't be a problem. And VSS-Server allows to publish
a project (if needed) to an online server. I think it's a very good
solution for a concurrent users working with CFStudio. The only sad
thing is to connect to the VSS-Server via Internet. I tested
SourceOffSite, but that screwed (kind of) my checked in/out files with
where users with LAN-connection to the server worked also on the
project. Hrmm... Perhaps I'll try to get my VPN working sometime...

Patric



KW I don't believe Projects work with RDS. Project are based on local or
KW mapped drives.

KW Ken



KW -Original Message-
KW From: Jeffry Houser [mailto:[EMAIL PROTECTED]] 
KW Sent: Thursday, October 10, 2002 9:39 AM
KW To: CF-Talk
KW Subject: Re: Visual Source Safe and CF Studio


KW   Okay, that makes sense.  I can't figure out how to fill a CF Studio 
KW project with files over RDS, though.
KW   It hasn't helped that the server was inaccessible by me this morning, 
KW though.


KW At 03:07 PM 10/10/2002 +0200, you wrote:
Hi Jeffry,

when you log any file out via CFStudio it becomes marked ni VSS on the 
server. At least it should be.

Patric


JH At 01:08 PM 10/10/2002 +0100, you wrote:
 How does CF Studio integrate with Visual Source Safe?
 
 Very well, I've used it in the past.
 
 It seems to me that VSS is intended to copy the file locally.
KW That
 I think I'm probably missing something important with regards 
   to
 Source
   Control.
 
 Well, if it didn't copy it to local storage, how would you be able 
 to edit it ?
 
 I think the way round it is to check things out to a local project, 
 and
 then
 use Studio's deploy functions to send them up to the RDS server when

 ya done.

JH   It is all becoming clear (sort of)
JH   However, if all the other developers are editing on Server A,
wouldn't I
JH have to be editing on the same server for the VSS to have any 
JH effect?


JH --
JH Jeffry Houser | mailto:[EMAIL PROTECTED]
JH Need a Web Developer?  Contact me!
JH AIM: Reboog711  | Phone: 1-203-379-0773
JH --
JH My CFMX Book: 
JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20
JH 
JH My Books: http://www.instantcoldfusion.com
JH My Band: http://www.farcryfly.com

JH


KW 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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.



Verity Summary - can you change it?

2002-10-10 Thread Robert Everland

I just finished up reindexing my website. The search feature works
pretty well except for certain instances where it will display html instead
of the content on the page. I would also like to skip the footer that it
insists on including, Is there anyway to help verity pick out what it should
display for the summary, or at least telling it what parts not to index.
Here is an example of some html it indexed instead of  text. This came up
when I did a query on the word chalk.


Summary: /localhost/shop/images/layout/pencil_bar/pencil_bar_05.gif
width=73 height=19 border=0 Prang Hyga-Color Board Chalk   Site Map |
Products | Company | Parents | Teachers | Kids | Promotional Distributors |
Contact | Terms of Use | Trademark | Privacy Policy (c)2002 The Dixon
Ticonderoga Companies, All Rights Reserved.



Robert Everland III
Web Developer Extraordinaire
Dixon Ticonderoga Company
http://www.dixonusa.com 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: cfinclude inside a cffile tag? Formatting Problem - whoops, your tags are showing...

2002-10-10 Thread Les Mizzell

Forgot to mention - if I run the template app_OUTPUT.cfm by itself, it
displays with the proper formatting...

: -Original Message-
: From: Les Mizzell [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, October 10, 2002 9:07 AM
: To: CF-Talk
: Subject: RE: cfinclude inside a cffile tag?
:
:
: Morning,
:
: Thanks for all your help on this so far. I've still got one more problem
: that I'm scratching my head over. The cfinclude template app_OUTPUT.cfm
: contains HTML formatting. However, when the file #MyFile# is
: generated, the
: HTML doesn't render - I'm actually seeing the raw HTML code in
: the file as
: below:
:
: br0001nbsp;nbsp;3.00 W
: br00ANN
: br01A01nbsp;nbsp
:
:
: Code below (thanks for your help) works perfectally except for the HTML
: rendering...
:
:
: cfsavecontent variable=sqlOutput
:   cfinclude template=app_OUTPUT.cfm
: /cfsavecontent
:
: cffile action=WRITE
:  file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
:  output=#sqlOutput#
:  addnewline=Yes
:
: cfheader
:  name=content-disposition
:  value=attachment; filename=#MyFile#
:
: cfcontent type=text/html
:  file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
:  deletefile=No reset=Yes
:
:
: Ideas??
:
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: cfinclude inside a cffile tag?

2002-10-10 Thread Mosh Teitelbaum

Are you trying to generate a file that gets saved (HTML tags and all) to a
file or do you want to generate a file that gets displayed in the browser
(and the HTML gets rendered by the browser)?

If you want to save it, than the code that you posted should be fine.  And,
as an HTML file, you'd expect to see HTML tags when you open the file in a
text editor.  If you want to display it, than replace the word attachment
in the CFHEADER tag with inline.

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


 -Original Message-
 From: Les Mizzell [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 9:07 AM
 To: CF-Talk
 Subject: RE: cfinclude inside a cffile tag?


 Morning,

 Thanks for all your help on this so far. I've still got one more problem
 that I'm scratching my head over. The cfinclude template app_OUTPUT.cfm
 contains HTML formatting. However, when the file #MyFile# is
 generated, the
 HTML doesn't render - I'm actually seeing the raw HTML code in the file as
 below:

 br0001nbsp;nbsp;3.00 W
 br00ANN
 br01A01nbsp;nbsp


 Code below (thanks for your help) works perfectally except for the HTML
 rendering...


 cfsavecontent variable=sqlOutput
   cfinclude template=app_OUTPUT.cfm
 /cfsavecontent

 cffile action=WRITE
   file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
   output=#sqlOutput#
   addnewline=Yes

 cfheader
   name=content-disposition
   value=attachment; filename=#MyFile#

 cfcontent type=text/html
   file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
   deletefile=No reset=Yes


 Ideas??

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



Re: Visual Source Safe and CF Studio

2002-10-10 Thread Jeffry Houser

At 04:05 PM 10/10/2002 +0200, you wrote:
Weel that's what I mean to recall too. Jeff said he had a mapped
drive, so it shouldn't be a problem.

   I have a mapped drive to the VSS database.  But, only RDS or FTP access 
to the actual files I'm working on.
  : groans:
  Luckily, I think they are the same server.. so my username / password 
combo might work.
  Unluckily, the server seems down, so I can't test the theory.


And VSS-Server allows to publish
a project (if needed) to an online server. I think it's a very good
solution for a concurrent users working with CFStudio. The only sad
thing is to connect to the VSS-Server via Internet. I tested
SourceOffSite, but that screwed (kind of) my checked in/out files with
where users with LAN-connection to the server worked also on the
project. Hrmm... Perhaps I'll try to get my VPN working sometime...

Patric



KW I don't believe Projects work with RDS. Project are based on local or
KW mapped drives.

KW Ken



KW -Original Message-
KW From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
KW Sent: Thursday, October 10, 2002 9:39 AM
KW To: CF-Talk
KW Subject: Re: Visual Source Safe and CF Studio


KW   Okay, that makes sense.  I can't figure out how to fill a CF Studio
KW project with files over RDS, though.
KW   It hasn't helped that the server was inaccessible by me this morning,
KW though.


KW At 03:07 PM 10/10/2002 +0200, you wrote:
 Hi Jeffry,
 
 when you log any file out via CFStudio it becomes marked ni VSS on the
 server. At least it should be.
 
 Patric
 
 
 JH At 01:08 PM 10/10/2002 +0100, you wrote:
  How does CF Studio integrate with Visual Source Safe?
  
  Very well, I've used it in the past.
  
  It seems to me that VSS is intended to copy the file locally.
KW That
  I think I'm probably missing something important with regards
to
  Source
Control.
  
  Well, if it didn't copy it to local storage, how would you be able
  to edit it ?
  
  I think the way round it is to check things out to a local project,
  and
  then
  use Studio's deploy functions to send them up to the RDS server when

  ya done.
 
 JH   It is all becoming clear (sort of)
 JH   However, if all the other developers are editing on Server A,
 wouldn't I
 JH have to be editing on the same server for the VSS to have any
 JH effect?
 
 
 JH --
 JH Jeffry Houser | mailto:[EMAIL PROTECTED]
 JH Need a Web Developer?  Contact me!
 JH AIM: Reboog711  | Phone: 1-203-379-0773
 JH --
 JH My CFMX Book:
 JH 
 http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20JH 
 JH My Books: http://www.instantcoldfusion.com
 JH My Band: http://www.farcryfly.com
 
 JH
 

KW

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



RE: BigIP and sticky sessions

2002-10-10 Thread Dave Watts

 BigIP is not honoring sticky sessions. We want a user that 
 his server1 for instance, to stay on server1 for the 
 duration of his/her visit. Users are being logged out at 
 random because apparently they are getting bounced from
 the server they started on (and where their session 
 variables are) to another server.
 
 It USED to be fine. What I'm wondering is if there are any 
 settings I can suggest to the network guys to look at. 
 (I'm only a lowly Web Developer after all. My job is to 
 be the first to have the finger pointed at him when
 ANYTHING on the website goes wrong.) F5 has been unhelpful.

You should be able to simply say to the appropriate people that BigIP is
not honoring sticky sessions. If you can actually demonstrate that, I don't
see what else you'll be able to do without significantly restructuring your
application code. You can easily build a demonstration case by using some
demo pages that return the current server info (name, IP address, whatever),
and putting them on each server.

I think that the way load-balancers normally enable sticky sessions is by
setting a cookie that corresponds with a single server in the cluster, so
you should be able to look at the raw HTTP traffic and see whether the
cookie is being set.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Re: Visual Source Safe and CF Studio

2002-10-10 Thread Patric Stumpe

Ahh, should have read your initial post more carefully. Sorry.

But wouldn't it be too easy if everthing would work instantly..? :)

Patric


JH At 04:05 PM 10/10/2002 +0200, you wrote:
Weel that's what I mean to recall too. Jeff said he had a mapped
drive, so it shouldn't be a problem.

JHI have a mapped drive to the VSS database.  But, only RDS or FTP access 
JH to the actual files I'm working on.
JH   : groans:
JH   Luckily, I think they are the same server.. so my username / password 
JH combo might work.
JH   Unluckily, the server seems down, so I can't test the theory.


And VSS-Server allows to publish
a project (if needed) to an online server. I think it's a very good
solution for a concurrent users working with CFStudio. The only sad
thing is to connect to the VSS-Server via Internet. I tested
SourceOffSite, but that screwed (kind of) my checked in/out files with
where users with LAN-connection to the server worked also on the
project. Hrmm... Perhaps I'll try to get my VPN working sometime...

Patric



KW I don't believe Projects work with RDS. Project are based on local or
KW mapped drives.

KW Ken



KW -Original Message-
KW From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
KW Sent: Thursday, October 10, 2002 9:39 AM
KW To: CF-Talk
KW Subject: Re: Visual Source Safe and CF Studio


KW   Okay, that makes sense.  I can't figure out how to fill a CF Studio
KW project with files over RDS, though.
KW   It hasn't helped that the server was inaccessible by me this morning,
KW though.


KW At 03:07 PM 10/10/2002 +0200, you wrote:
 Hi Jeffry,
 
 when you log any file out via CFStudio it becomes marked ni VSS on the
 server. At least it should be.
 
 Patric
 
 
 JH At 01:08 PM 10/10/2002 +0100, you wrote:
  How does CF Studio integrate with Visual Source Safe?
  
  Very well, I've used it in the past.
  
  It seems to me that VSS is intended to copy the file locally.
KW That
  I think I'm probably missing something important with regards
to
  Source
Control.
  
  Well, if it didn't copy it to local storage, how would you be able
  to edit it ?
  
  I think the way round it is to check things out to a local project,
  and
  then
  use Studio's deploy functions to send them up to the RDS server when

  ya done.
 
 JH   It is all becoming clear (sort of)
 JH   However, if all the other developers are editing on Server A,
 wouldn't I
 JH have to be editing on the same server for the VSS to have any
 JH effect?
 
 
 JH --
 JH Jeffry Houser | mailto:[EMAIL PROTECTED]
 JH Need a Web Developer?  Contact me!
 JH AIM: Reboog711  | Phone: 1-203-379-0773
 JH --
 JH My CFMX Book:
 JH 
 http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20JH 
 JH My Books: http://www.instantcoldfusion.com
 JH My Band: http://www.farcryfly.com
 
 JH
 

KW

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



RE: cfinclude inside a cffile tag?

2002-10-10 Thread Mark A. Kruger - CFG

If you are trying to display it you don't have to do that even - just do
this:

 cfsavecontent variable=sqlOutput
   cfinclude template=app_OUTPUT.cfm
 /cfsavecontent

 cffile action=WRITE
file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
output=#sqlOutput#
addnewline=Yes

Cfcontent type=text/html
cfoutput#sqloutput#/cfoutput

In this case, cfcontent is superflous as well.

-Original Message-
From: Mosh Teitelbaum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 9:28 AM
To: CF-Talk
Subject: RE: cfinclude inside a cffile tag?


Are you trying to generate a file that gets saved (HTML tags and all) to a
file or do you want to generate a file that gets displayed in the browser
(and the HTML gets rendered by the browser)?

If you want to save it, than the code that you posted should be fine.  And,
as an HTML file, you'd expect to see HTML tags when you open the file in a
text editor.  If you want to display it, than replace the word attachment
in the CFHEADER tag with inline.

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


 -Original Message-
 From: Les Mizzell [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 9:07 AM
 To: CF-Talk
 Subject: RE: cfinclude inside a cffile tag?


 Morning,

 Thanks for all your help on this so far. I've still got one more problem
 that I'm scratching my head over. The cfinclude template app_OUTPUT.cfm
 contains HTML formatting. However, when the file #MyFile# is
 generated, the
 HTML doesn't render - I'm actually seeing the raw HTML code in the file as
 below:

 br0001nbsp;nbsp;3.00 W
 br00ANN
 br01A01nbsp;nbsp


 Code below (thanks for your help) works perfectally except for the HTML
 rendering...


 cfsavecontent variable=sqlOutput
   cfinclude template=app_OUTPUT.cfm
 /cfsavecontent

 cffile action=WRITE
   file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
   output=#sqlOutput#
   addnewline=Yes

 cfheader
   name=content-disposition
   value=attachment; filename=#MyFile#

 cfcontent type=text/html
   file=c:\inetpub\hostroot\www.mySITE.com\files\#MyFile#
   deletefile=No reset=Yes


 Ideas??



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Re: OT: Query Analyzer on Win95

2002-10-10 Thread S . Isaac Dealey

I believe Query Analyzer is a part of the Client Connectivity Tools
bundle... along with Enterprise Manager... I could be wrong, but that's
always been my impression.

S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

 Hello,

 I want to be able to run Query Analyzer for SQL Server 7 or 2000 on a
 Windows 95 machine. Is this possible? I tried installing from a SQL Server
 2000 Standard Edition but the only thing it offered to install were the
 Client Connectivity Tools and English Query. Is there any place where I
 could get the Query Analizer as a stand-alone tool? Perhaps from Visual
 Studio?

 Thanks in advance,
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: OT: Query Analyzer on Win95

2002-10-10 Thread Mitko Gerensky-Greene

I was hoping that the Enterprise Manager would be included but it is not. And the 
Client Connectivity Tools is 
just a tool about what protocal you can use for connecting to a SQL Server, i.e. Named 
Pipes or TCP/IP.

Mitko
-- Original Message --
From: S. Isaac Dealey [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
Date:  Thu, 10 Oct 2002 10:33:04 -0400

I believe Query Analyzer is a part of the Client Connectivity Tools
bundle... along with Enterprise Manager... I could be wrong, but that's
always been my impression.

S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

 Hello,

 I want to be able to run Query Analyzer for SQL Server 7 or 2000 on a
 Windows 95 machine. Is this possible? I tried installing from a SQL Server
 2000 Standard Edition but the only thing it offered to install were the
 Client Connectivity Tools and English Query. Is there any place where I
 could get the Query Analizer as a stand-alone tool? Perhaps from Visual
 Studio?

 Thanks in advance,

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



Re: OT: Browser Usage

2002-10-10 Thread David Groth

Granted this is an academic environment, but here are our Netscape stats
for last month.
Netscape Browsers  
 
  Browser - Hits - % of Total Hits - Visits  
 1 Netscape 4.76 - 19,452 - 13.46% - 2,720 
 2 Netscape 4.75 - 10,471 - 7.24% - 2,469 
 3 Netscape 4.77 - 8,255 - 5.71% - 1,799 
 4 Netscape 4.7 - 12,585 - 8.70% - 1,738 
 5 Netscape 6.1 - 8,282 - 5.73% - 1,386 
 6 Netscape 4.79 - 9,397 - 6.50% - 1,358 
 7 Netscape 6.2 - 7,894 - 5.46% - 1,315 
 8 Netscape 4.5 - 6,005 - 4.15% - 1,188 
 9 Netscape 7.0 - 6,304 - 4.36% - 1,104 
 10 Netscape 4.73 - 5,284 - 3.65% - 1,032 
 11 Netscape 6.2.3 - 5,234 - 3.62% - 1,030 
 12 Netscape 5.0 - 3,600 - 2.49% - 1,028 
 13 Netscape 6.2.2 - 4,468 - 3.09% - 967 
 14 Netscape 4.78 - 4,827 - 3.34% - 759 
 15 Netscape 4.72 - 3,192 - 2.20% - 746 
 16 Netscape 6.2.1 - 2,594 - 1.79% - 578 
 17 Netscape 4.61 - 4,003 - 2.77% - 568 
 18 Netscape 4.08 - 2,482 - 1.71% - 481 
 19 Netscape CIRT - 4,957 - 3.43% - 418 
 20 Netscape 4.51 - 1,391 - 0.96% - 243 
Total For Browsers Above  130,677 - 90.42% - 22,927  
  
  
 


David Groth, Analyst/Programmer III
HSC Library  Informatics Center, University of New Mexico
505.272.8406  e-mail: [EMAIL PROTECTED]

 [EMAIL PROTECTED] 10/09/02 05:50PM 
Hi All,

Does any one know what percentage of users use/ prefer 
Netscape 4.5 or 6  over IE.

Thanks

S






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



OT DB field contains but is not first list element

2002-10-10 Thread JS

I have a situation where I have a list of elements in
a db field and I need to pull the records where an
item appears somewhere in the list but is not the
first item.  Something like 
WHERE (this_field NOT LIKE '#this_item#%') AND
(this_field LIKE '%#this_item#')

It is a SQL 7 db.

TIA,
JS

__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos  More
http://faith.yahoo.com
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: 2nd question - Run MX as nobody?

2002-10-10 Thread Troy Simpson

Jesse,

Thanks for the response.
I run this idea by our Sun Administrator.
Should we make the cfmx user a common user with a home directory, etc.?
Is there a recommended (possible published) method of how to configure the system for 
ColdFusion MX Enterprise Server?
Or is this considered common knowledge for a Sun Administrator?

Any other tips would be greatly appreciated.

Thanks,
Troy

Jesse Noller wrote:

 Change it from the nobody user to a cfmx user you add to the system. Don't use 
nobody if nobody does not have a shell predefined.

 Jesse Noller
 [EMAIL PROTECTED]
 Macromedia Server Development

 No concept man forms is valid unless he
 integrates it without contradiction into the
 sum of his knowledge.
 - Ayn Rand

  -Original Message-
  From: Troy Simpson [mailto:[EMAIL PROTECTED]]
  Sent: Wednesday, October 09, 2002 4:16 PM
  To: CF-Talk
  Subject: Re: 2nd question - Run MX as nobody?
 
  All,
 
  I was able to configure ColdFusion MX to run as the nobody user on Sun
  Solaris 8.
  But in order to run it I had to provide the nobody user with a shell.
  In my case, I used the Korn Shell.
 
  When I set the shell for the nobody user back to: /usr/sbin/noshell
 
  I get the following:
 
  # ./coldfusion start
  Starting ColdFusion MX...
  Oct  9 15:59:09 huey noshell[5813]: Titan warning: user 60001 login from a
  disabled shell
 
  Message from syslogd@huey at Wed Oct  9 15:59:09 2002 ...
  huey noshell[5813]: Titan warning: user 60001 login from a disabled shell
 
  Message from syslogd@huey at Wed Oct  9 15:59:09 2002 ...
  huey noshell[5813]: Titan warning: user 60001 login from a disabled shell
 
  Message from syslogd@huey at Wed Oct  9 15:59:09 2002 ...
  huey noshell[5813]: Titan warning: user 60001 login from a disabled shell
  There may be a few moments before you can access the Coldfusion MX
  administrator.  This
  is normal.
  There has been an error starting Coldfusion MX, please check the logs.
 
  I check the logs in the /opt/coldfusionmx/logs directory.  The logs are
  empty.  Nada!
  Nothin' there.
 
  Apache 2.0.40 has no problem with this.
  It is my understanding that the nobody user should not have a shell
  assigned to for
  security reasons.
  This appears to be bug.
  Am I missing something?
 
  Thanks,
  Troy
 
  Sean A Corfield wrote:
 
   Cathy Taylor wrote:
I'm trying to evaluate our CF MX upgrade on Solaris before I turn our
masses loose on it. I can't run it as root and our security
regulations forbid me from creating a new user to run it as (that
wouldn't work anyway since our web server runs as nobody). I've read
the docs and modified the user to nobody, but it won't start. The
error log just says 'su no shell'. Of course nobody has no shell, but
I'm sure it must be able to run that way. Am I missing something?
  
   I just checked one of our QA servers and we are indeed running it as
   nobody:
  
  nobody 24650 24648  0   Sep 30 ?   306:11
   /data/www/appserver/cfusionmx/bin/cfusion -start default
  nobody 24648 1  0   Sep 30 ?0:00
   /data/www/appserver/cfusionmx/bin/cfusion -autorestart -start default
   scorfiel 28370 28362  0 13:38:39 pts/10:00 fgrep cf
  
   Then I checked another one:
  
   scorfiel 23763 23758  0 13:40:03 pts/20:00 fgrep cf
  nobody 27009 27007  0   Sep 04 ?   1435:01
   /data/www/appserver/neo/bin/cfusion -start default
  nobody 27007 1  0   Sep 04 ?0:00
   /data/www/appserver/neo/bin/cfusion -autorestart -start default
  
   Also running as nobody (that one's a production server, BTW).
  
   As far as I know, our guys just followed the installation instructions
   but I'll ask them if there were any issues around the 'nobody' user.
  
   An Architect's View -- http://www.corfield.org/blog/
  
   Macromedia DevCon 2002, October 27-30, Orlando, Florida
   Architecting a New Internet Experience
   Register today at http://www.macromedia.com/go/devcon2002
  
  
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



OT: JEdit Source Control -- was Re: Visual Source Safe and CF Studio

2002-10-10 Thread S . Isaac Dealey

This is OT but I'm wondering if anyone in the JEdit community has heard
anything about a source/version control plugin? I'm less concerned about
versioning and the like, but it'd be nice to have access to a simple
checkout/checkin service to prevent simultaneous overwrites, and/or a
document comparison tool.


 Weel that's what I mean to recall too. Jeff said he had a mapped
 drive, so it shouldn't be a problem. And VSS-Server allows to publish
 a project (if needed) to an online server. I think it's a very good
 solution for a concurrent users working with CFStudio. The only sad
 thing is to connect to the VSS-Server via Internet. I tested
 SourceOffSite, but that screwed (kind of) my checked in/out files with
 where users with LAN-connection to the server worked also on the
 project. Hrmm... Perhaps I'll try to get my VPN working sometime...

 Patric



 KW I don't believe Projects work with RDS. Project are based on local or
 KW mapped drives.

 KW Ken



 KW -Original Message-
 KW From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
 KW Sent: Thursday, October 10, 2002 9:39 AM
 KW To: CF-Talk
 KW Subject: Re: Visual Source Safe and CF Studio


 KW   Okay, that makes sense.  I can't figure out how to fill a CF Studio
 KW project with files over RDS, though.
 KW   It hasn't helped that the server was inaccessible by me this
 morning,
 KW though.


 KW At 03:07 PM 10/10/2002 +0200, you wrote:
Hi Jeffry,

when you log any file out via CFStudio it becomes marked ni VSS on the
server. At least it should be.

Patric


JH At 01:08 PM 10/10/2002 +0100, you wrote:
 How does CF Studio integrate with Visual Source Safe?
 
 Very well, I've used it in the past.
 
 It seems to me that VSS is intended to copy the file locally.
 KW That
 I think I'm probably missing something important with regards
   to
 Source
   Control.
 
 Well, if it didn't copy it to local storage, how would you be able
 to edit it ?
 
 I think the way round it is to check things out to a local project,
 and
 then
 use Studio's deploy functions to send them up to the RDS server when

 ya done.

JH   It is all becoming clear (sort of)
JH   However, if all the other developers are editing on Server A,
wouldn't I
JH have to be editing on the same server for the VSS to have any
JH effect?


JH --
JH Jeffry Houser | mailto:[EMAIL PROTECTED]
JH Need a Web Developer?  Contact me!
JH AIM: Reboog711  | Phone: 1-203-379-0773
JH --
JH My CFMX Book:
JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-20
JH 
JH My Books: http://www.instantcoldfusion.com
JH My Band: http://www.farcryfly.com

JH


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



Re: FileMaker Pro Backend DB?

2002-10-10 Thread Sharon DiOrio

The only real reason to use FMP as a back-end database is if people are
still access it through the regular FMP interface.

Sharon
- Original Message -
From: Bob Haroche [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Wednesday, October 09, 2002 7:05 PM
Subject: Re: FileMaker Pro Backend DB?


  It will take me a while to dig up the info on how to do this -- I
 will
  post later.

 I'd appreciate that. Since the site isn't expecting heavy traffic, I
 was thinking a migration over to MS Access or MySQL if necessary. I
 don't think the project warrants moving up to SQL server or similar.


 -
 Regards,
 Bob Haroche
 O n P o i n t  S o l u t i o n s
 www.OnPointSolutions.com

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



RE: OT: Browser Usage

2002-10-10 Thread Mark A. Kruger - CFG

Dave,

Are you saying that 90% of the browsers that hit your site are netscape?  I
guess I didn't realize that netscape had so many versions and builds. Holy
cow.

-mk

-Original Message-
From: David Groth [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 9:47 AM
To: CF-Talk
Subject: Re: OT: Browser Usage


Granted this is an academic environment, but here are our Netscape stats
for last month.
Netscape Browsers

  Browser - Hits - % of Total Hits - Visits
 1 Netscape 4.76 - 19,452 - 13.46% - 2,720
 2 Netscape 4.75 - 10,471 - 7.24% - 2,469
 3 Netscape 4.77 - 8,255 - 5.71% - 1,799
 4 Netscape 4.7 - 12,585 - 8.70% - 1,738
 5 Netscape 6.1 - 8,282 - 5.73% - 1,386
 6 Netscape 4.79 - 9,397 - 6.50% - 1,358
 7 Netscape 6.2 - 7,894 - 5.46% - 1,315
 8 Netscape 4.5 - 6,005 - 4.15% - 1,188
 9 Netscape 7.0 - 6,304 - 4.36% - 1,104
 10 Netscape 4.73 - 5,284 - 3.65% - 1,032
 11 Netscape 6.2.3 - 5,234 - 3.62% - 1,030
 12 Netscape 5.0 - 3,600 - 2.49% - 1,028
 13 Netscape 6.2.2 - 4,468 - 3.09% - 967
 14 Netscape 4.78 - 4,827 - 3.34% - 759
 15 Netscape 4.72 - 3,192 - 2.20% - 746
 16 Netscape 6.2.1 - 2,594 - 1.79% - 578
 17 Netscape 4.61 - 4,003 - 2.77% - 568
 18 Netscape 4.08 - 2,482 - 1.71% - 481
 19 Netscape CIRT - 4,957 - 3.43% - 418
 20 Netscape 4.51 - 1,391 - 0.96% - 243
Total For Browsers Above  130,677 - 90.42% - 22,927





David Groth, Analyst/Programmer III
HSC Library  Informatics Center, University of New Mexico
505.272.8406  e-mail: [EMAIL PROTECTED]

 [EMAIL PROTECTED] 10/09/02 05:50PM 
Hi All,

Does any one know what percentage of users use/ prefer
Netscape 4.5 or 6  over IE.

Thanks

S







~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: Visual Source Safe and CF Studio

2002-10-10 Thread Jeffry Houser

At 04:34 PM 10/10/2002 +0200, you wrote:
Ahh, should have read your initial post more carefully. Sorry.

  Not a problem.


But wouldn't it be too easy if everthing would work instantly..? :)

  Yep.. way too easy.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
Need a Web Developer?  Contact me!
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
My Band: http://www.farcryfly.com 

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



RE: 2nd question - Run MX as nobody?

2002-10-10 Thread Jesse Noller

Make the cfmx user with privs to access the webserver document directory, otherwise, 
it is a normal user account. 

At this time there is not a recommended config document. I should write one.

Jesse Noller
[EMAIL PROTECTED]
Macromedia Server Development

No concept man forms is valid unless he
integrates it without contradiction into the
sum of his knowledge. 
- Ayn Rand

 -Original Message-
 From: Troy Simpson [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 10:58 AM
 To: CF-Talk
 Subject: Re: 2nd question - Run MX as nobody?
 
 Jesse,
 
 Thanks for the response.
 I run this idea by our Sun Administrator.
 Should we make the cfmx user a common user with a home directory, etc.?
 Is there a recommended (possible published) method of how to configure the
 system for ColdFusion MX Enterprise Server?
 Or is this considered common knowledge for a Sun Administrator?
 
 Any other tips would be greatly appreciated.
 
 Thanks,
 Troy
 
 Jesse Noller wrote:
 
  Change it from the nobody user to a cfmx user you add to the system.
 Don't use nobody if nobody does not have a shell predefined.
 
  Jesse Noller
  [EMAIL PROTECTED]
  Macromedia Server Development
 
  No concept man forms is valid unless he
  integrates it without contradiction into the
  sum of his knowledge.
  - Ayn Rand
 
   -Original Message-
   From: Troy Simpson [mailto:[EMAIL PROTECTED]]
   Sent: Wednesday, October 09, 2002 4:16 PM
   To: CF-Talk
   Subject: Re: 2nd question - Run MX as nobody?
  
   All,
  
   I was able to configure ColdFusion MX to run as the nobody user on Sun
   Solaris 8.
   But in order to run it I had to provide the nobody user with a shell.
   In my case, I used the Korn Shell.
  
   When I set the shell for the nobody user back to: /usr/sbin/noshell
  
   I get the following:
  
   # ./coldfusion start
   Starting ColdFusion MX...
   Oct  9 15:59:09 huey noshell[5813]: Titan warning: user 60001 login
 from a
   disabled shell
  
   Message from syslogd@huey at Wed Oct  9 15:59:09 2002 ...
   huey noshell[5813]: Titan warning: user 60001 login from a disabled
 shell
  
   Message from syslogd@huey at Wed Oct  9 15:59:09 2002 ...
   huey noshell[5813]: Titan warning: user 60001 login from a disabled
 shell
  
   Message from syslogd@huey at Wed Oct  9 15:59:09 2002 ...
   huey noshell[5813]: Titan warning: user 60001 login from a disabled
 shell
   There may be a few moments before you can access the Coldfusion MX
   administrator.  This
   is normal.
   There has been an error starting Coldfusion MX, please check the logs.
  
   I check the logs in the /opt/coldfusionmx/logs directory.  The logs
 are
   empty.  Nada!
   Nothin' there.
  
   Apache 2.0.40 has no problem with this.
   It is my understanding that the nobody user should not have a shell
   assigned to for
   security reasons.
   This appears to be bug.
   Am I missing something?
  
   Thanks,
   Troy
  
   Sean A Corfield wrote:
  
Cathy Taylor wrote:
 I'm trying to evaluate our CF MX upgrade on Solaris before I turn
 our
 masses loose on it. I can't run it as root and our security
 regulations forbid me from creating a new user to run it as (that
 wouldn't work anyway since our web server runs as nobody). I've
 read
 the docs and modified the user to nobody, but it won't start.
 The
 error log just says 'su no shell'. Of course nobody has no shell,
 but
 I'm sure it must be able to run that way. Am I missing something?
   
I just checked one of our QA servers and we are indeed running it as
nobody:
   
   nobody 24650 24648  0   Sep 30 ?   306:11
/data/www/appserver/cfusionmx/bin/cfusion -start default
   nobody 24648 1  0   Sep 30 ?0:00
/data/www/appserver/cfusionmx/bin/cfusion -autorestart -start
 default
scorfiel 28370 28362  0 13:38:39 pts/10:00 fgrep cf
   
Then I checked another one:
   
scorfiel 23763 23758  0 13:40:03 pts/20:00 fgrep cf
   nobody 27009 27007  0   Sep 04 ?   1435:01
/data/www/appserver/neo/bin/cfusion -start default
   nobody 27007 1  0   Sep 04 ?0:00
/data/www/appserver/neo/bin/cfusion -autorestart -start default
   
Also running as nobody (that one's a production server, BTW).
   
As far as I know, our guys just followed the installation
 instructions
but I'll ask them if there were any issues around the 'nobody' user.
   
An Architect's View -- http://www.corfield.org/blog/
   
Macromedia DevCon 2002, October 27-30, Orlando, Florida
Architecting a New Internet Experience
Register today at http://www.macromedia.com/go/devcon2002
   
   
  
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert 

RE: cfinclude inside a cffile tag?

2002-10-10 Thread Les Mizzell

: Are you trying to generate a file that gets saved (HTML tags and
: all) to a
: file or do you want to generate a file that gets displayed in the browser
: (and the HTML gets rendered by the browser)?


Neither...

The file is being pushed to the client to be saved as a properly formatted
text file with the .fnm extension for opening and processing in another
program. Don't want it to open in the browser.  The HTML that's in there is
to get the formatting correct and can't appear in the output...some of which
is pretty weird, like a certain value HAS to start at position 237 on a
specific line (no wrapping)

The cfinclude template app_OUTPUT.cfm will generate the proper output for
me I then need to get that output into WhateverFileName.fnm, which
then gets pushed to the user to save.


Thanks,

Les

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



RE: OT DB field contains but is not first list element

2002-10-10 Thread Ben Doom

I think what you want is:

where (this_field not like '#this_item#%') and (this_field like
'%#this_item#%')

Note that there's a % at each end of this_item in the second clause.

  --Ben Doom
Programmer  General Lackey
Moonbow Software

: -Original Message-
: From: JS [mailto:[EMAIL PROTECTED]]
: Sent: Thursday, October 10, 2002 10:49 AM
: To: CF-Talk
: Subject: OT DB field contains but is not first list element
:
:
: I have a situation where I have a list of elements in
: a db field and I need to pull the records where an
: item appears somewhere in the list but is not the
: first item.  Something like
: WHERE (this_field NOT LIKE '#this_item#%') AND
: (this_field LIKE '%#this_item#')
:
: It is a SQL 7 db.
:
: TIA,
: JS
:
: __
: Do you Yahoo!?
: Faith Hill - Exclusive Performances, Videos  More
: http://faith.yahoo.com
: 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: OT: SQL Question

2002-10-10 Thread Tony Carcieri

Thanks Everyone! I appreciate the help!

Thanks,
Tony

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 09, 2002 7:26 PM
To: CF-Talk
Subject: Re: OT: SQL Question


Tony Carcieri wrote:
 Hi all,

 Here's what I want to do:
 UPDATE tablename
 SET column = 0
 WHERE ID = ???

 I want to specify a range of numbers (like 100-200) and increment it by 2.
 So, 100, 102,104etc would only be updated and the rest wouldn't.

WHERE
ID BETWEEN 100 AND 200
AND MOD(ID, 2) = 0

Jochem



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: OT DB field contains but is not first list element

2002-10-10 Thread Mosh Teitelbaum

It looks like you've already pretty much got it down:

WHERE
(this_field NOT LIKE '#this_item#%')
AND (this_field LIKE '%#this_item#%')
  ^   ^
Just put the % both before and after this_item in the second conditional
clause.

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


 -Original Message-
 From: JS [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 10:49 AM
 To: CF-Talk
 Subject: OT DB field contains but is not first list element


 I have a situation where I have a list of elements in
 a db field and I need to pull the records where an
 item appears somewhere in the list but is not the
 first item.  Something like
 WHERE (this_field NOT LIKE '#this_item#%') AND
 (this_field LIKE '%#this_item#')

 It is a SQL 7 db.

 TIA,
 JS

 __
 Do you Yahoo!?
 Faith Hill - Exclusive Performances, Videos  More
 http://faith.yahoo.com
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



CFMAIL and UTF-8

2002-10-10 Thread Pascal Peters

Does anybody know how to send a plain text email in UTF-8 using cfmail on CF 4.5.1 
sp2. Right now, all special characters are rendered incorrectly (see below)
Example: support des caractères spéciaux dans les champs du sommaire,

Should be: support des caractères spéciaux dans les champs du sommaire

Pascal Peters
Certified ColdFusion Advanced Developer
Macromedia Certified Instructor
LR Technologies
Av. E. De Mot, 19
1000 BRUSSELS, BELGIUM
Tel: +32 2 639 68 70
Fax: +32 2 639 68 99
Email: [EMAIL PROTECTED]
Web: www.lrt.be
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: 2nd question - Run MX as nobody?

2002-10-10 Thread Thomas Chiverton

 I run this idea by our Sun Administrator.
 Should we make the cfmx user a common user with a home directory, etc.?
 Or is this considered common knowledge for a Sun Administrator?

I would think that the admin should know how to set up a limited permissions
user for running a deamon with.
That should mean no home dir, no shell etc. etc.

How much this breaks things I don't know, you may have to be more relaxed if
you want to use cfexecute for example. shrug

Tom Chiverton
You don't have to be a mad scientist to believe in ColdFusion




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



RE: 2nd question - Run MX as nobody?

2002-10-10 Thread Thomas Chiverton

 Make the cfmx user with privs to access the webserver document
 directory, otherwise, it is a normal user account.

!

Why would you ever need to login as the user CF runs as ?
Why does it need to be a member of the groups most users are part of
(usually 'users' by default) ?

Tom Chiverton
You don't have to be a mad scientist to believe in ColdFusion




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: OT DB field contains but is not first list element

2002-10-10 Thread JS

That did it!

Thanks, Ben,Mosh and others.

JS




It looks like you've already pretty much got it down:

WHERE
(this_field NOT LIKE '#this_item#%')
AND (this_field LIKE '%#this_item#%')
  ^   ^
Just put the % both before and after this_item in
the second conditional
clause.

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


 -Original Message-
 From: JS [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 10:49 AM
 To: CF-Talk
 Subject: OT DB field contains but is not first list
element


 I have a situation where I have a list of elements
in
 a db field and I need to pull the records where an
 item appears somewhere in the list but is not the
 first item.  Something like
 WHERE (this_field NOT LIKE '#this_item#%') AND
 (this_field LIKE '%#this_item#')

 It is a SQL 7 db.

 TIA,
 JS

 __
 Do you Yahoo!?
 Faith Hill - Exclusive Performances, Videos  More
 http://faith.yahoo.com
 

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



RE: 2nd question - Run MX as nobody?

2002-10-10 Thread Jesse Noller

You don't need to login as the cfuser, however, the CFuser needs a valid shell as well 
as typical privs associated with it.



Jesse Noller
[EMAIL PROTECTED]
Macromedia Server Development

No concept man forms is valid unless he
integrates it without contradiction into the
sum of his knowledge. 
- Ayn Rand

 -Original Message-
 From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 11:24 AM
 To: CF-Talk
 Subject: RE: 2nd question - Run MX as nobody?
 
  Make the cfmx user with privs to access the webserver document
  directory, otherwise, it is a normal user account.
 
 !
 
 Why would you ever need to login as the user CF runs as ?
 Why does it need to be a member of the groups most users are part of
 (usually 'users' by default) ?
 
 Tom Chiverton
 You don't have to be a mad scientist to believe in ColdFusion
 
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.



RE: Visual Source Safe and CF Studio

2002-10-10 Thread Costas Piliotis

Just to add my pennies here, you have a setting in VSS - your working
folder where the file is extracted to for changes.  You can leave it as the
same location the actual file is, and then you can edit (and test) in its
proper location.  There's no harm, because you can always roll back your
changes.

VSS integrates with studio really nicely, but I find it takes FOREVER to
load a project, so I actually check out my files through the VSS gui and
then edit them in CFStudio.  That way I don't have to wait 10 minutes for
the damn project to load my list of files...

Good luck.  I like the way VSS works with cfStudio.  PVCS works really
nicely with it too...

-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 5:09 AM
To: CF-Talk
Subject: RE: Visual Source Safe and CF Studio


   How does CF Studio integrate with Visual Source Safe?

Very well, I've used it in the past.

   It seems to me that VSS is intended to copy the file locally.  That
   I think I'm probably missing something important with regards to 
 Source Control.

Well, if it didn't copy it to local storage, how would you be able to edit
it ?

I think the way round it is to check things out to a local project, and then
use Studio's deploy functions to send them up to the RDS server when ya
done.

Tom Chiverton
You don't have to be a mad scientist to believe in ColdFusion





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



RE: 2nd question - Run MX as nobody?

2002-10-10 Thread Thomas Chiverton

 You don't need to login as the cfuser, however, the CFuser needs
 a valid shell

It does ? What for ?

 as well as typical privs associated with it.

I guess it depends what you mean by typical :-)
I wouldn't want my CFMX user to have read access to everything below /home
(some UNIXs set permissions by default that allow this) for instance.

Tom Chiverton
You don't have to be a mad scientist to believe in ColdFusion




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: 2nd question - Run MX as nobody? - Solution

2002-10-10 Thread Cathy Taylor

No, that's not a viable solution. I cannot give 'nobody' a shell. That defeats the 
purpose of nobody. 

I posted in the forum (hey Troy, that was probably me!) and am not receiving a 
response and have also submitted a bug report. I have narrowed it down to this:

CFMX will run as nobody if no shell is specified (nothing at the end of the line in 
/etc/passwd). It will not run if /dev/null or /bin/false is specified as the shell. 
The gov't agency I work for has strict requirements that one of the above be 
specified. This worked for for CF 4.5 and 5.0. It suddenly does not work with CFMX. 
(It also works for all web servers we have run and currently run, so should not be a 
major issue).

Glad to hear I'm not the only one. I'm kind of bummed I haven't received any reply 
from Macromedia though to at least confirm my suspicion and say, Hey, we'll get right 
on that!. We're at a standstill until it's resolved.

Thanks for the feedback! I seem to miss some using the digest and will try to pay more 
attention!

Cathy

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



Re: CFMAIL and UTF-8

2002-10-10 Thread Alex

Hi, we are not using CFMAIL because we found that it doesn't handle mass
mailing, e.g. it hangs when we're sending newsletters to our more than 2000
customers - we tested it only in CF 4.5 though). So we switched to a custom
tag called ASPMail - it works flawlessly with MS2000 SMTP server.
Regards,
Alex

BTW  We have some French customers, too. What are you using for getting
messages, CFPOP or something else? (We have some problems with French
letters in attachment names etc...)



 Does anybody know how to send a plain text email in UTF-8 using cfmail
on CF 4.5.1 sp2. Right now, all special characters are rendered incorrectly
(see below)
 Example: support des caractères spéciaux dans les champs du sommaire,


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



cfx_pwtextcrypt

2002-10-10 Thread Ben Densmore

Anyone currently using the cfx_pwtextcrypt custom tag that can answer a
few questions off list?
 
Thanks,
Ben
 
Ben Densmore
Web Developer
eSupport.com,Inc.
1538 Turnpike St.
North Andover, MA 01845
 
Phone: (978) 686-6468 x333
Email: [EMAIL PROTECTED]
 


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



SOT: RegEx

2002-10-10 Thread Willy Ray

Ok, I have a string that looks like this:

/web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 95kb 0.3u 0:01

It's an imagemagic identification of a file that my user is uploading.  myfile.jpg is 
CFFILE.clientfile.

I need to go through this thing and get the 1280x1024 out.  I could come up with a way 
to do this w/o regular expressions, but it wouldn't be as flexible as I'd like it to 
be.

I've tried this:


cfset location = REFind(/d+x/d+, mystring)

And this:

cfset start = REFind([/d+]x[/d+], mystring)

Doesn't seem to work.  Any ideas?





-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College

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



RE: Single Sign On

2002-10-10 Thread Costas Piliotis

You can do this two ways:

1)  Use IIS to manage the security.  Just make sure your site goes over ssl
so usernames and password aren't going in plain text, or

2) If you want a proper sign on page for username and password, install
advanced security into your cf server installation.  Then in cf admin,
enable advanced security.  You can then use an NT4 domain as a directory as
well afaik.  I did this in 4.5 successfully, but cf5 now uses siteminder.
From there, you can use the cfauthenticate tag to validate usernames and
passwords.

In solution 2, you would ask for a username and password in a logon form in
your cf site, whether they are inside the network or outside the network.


-Original Message-
From: Sean McCarthy [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 09, 2002 8:36 PM
To: CF-Talk
Subject: Single Sign On


I need to get the win nt network user name to do authorization for an
intranet.  The only options I found in my search are:

-the persistent cookie (which will still require one login)

-custom configuration of a browser to auto login (not if sure if this will
make the user name available?)

-A certificate server to issue client certificates (user name available?)

-A .dll or class(es) to do this?  If this is the case, can you please
recommend some good choices.


Info: NT 4 domain / iis 5 / cf 5 



Thanks for your help

sean 

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



RE: 2nd question - Run MX as nobody? - Solution

2002-10-10 Thread Jesse Noller

Cathy-

Do *not* run coldfusion as the nobody user then. CFMX requires the user it 
runs as have a valid shell on solaris as solaris SU does not allow for on the fly 
shell definition to run a given command. 

CF5 bypassed this by having an internal SUID system. CFMX does not.

Jesse Noller
[EMAIL PROTECTED]
Macromedia Server Development

 -Original Message-
 From: Cathy Taylor [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 11:48 AM
 To: CF-Talk
 Subject: RE: 2nd question - Run MX as nobody? - Solution
 
 No, that's not a viable solution. I cannot give 'nobody' a shell. That
 defeats the purpose of nobody.
 
 I posted in the forum (hey Troy, that was probably me!) and am not
 receiving a response and have also submitted a bug report. I have narrowed
 it down to this:
 
 CFMX will run as nobody if no shell is specified (nothing at the end of
 the line in /etc/passwd). It will not run if /dev/null or /bin/false is
 specified as the shell. The gov't agency I work for has strict
 requirements that one of the above be specified. This worked for for CF
 4.5 and 5.0. It suddenly does not work with CFMX. (It also works for all
 web servers we have run and currently run, so should not be a major issue).
 
 Glad to hear I'm not the only one. I'm kind of bummed I haven't received
 any reply from Macromedia though to at least confirm my suspicion and say,
 Hey, we'll get right on that!. We're at a standstill until it's resolved.
 
 Thanks for the feedback! I seem to miss some using the digest and will try
 to pay more attention!
 
 Cathy
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: 2nd question - Run MX as nobody?

2002-10-10 Thread Jesse Noller

Look in the coldfusion start script.

The start script run su -$user -c command 

On linux, su gives you the option of defining a run-time shell. Solaris does not, 
therefore, the solaris user you run CFMX as needs a valid shell.

Jesse Noller
[EMAIL PROTECTED]
Macromedia Server Development

No concept man forms is valid unless he
integrates it without contradiction into the
sum of his knowledge. 
- Ayn Rand

 -Original Message-
 From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 11:50 AM
 To: CF-Talk
 Subject: RE: 2nd question - Run MX as nobody?
 
  You don't need to login as the cfuser, however, the CFuser needs
  a valid shell
 
 It does ? What for ?
 
  as well as typical privs associated with it.
 
 I guess it depends what you mean by typical :-)
 I wouldn't want my CFMX user to have read access to everything below /home
 (some UNIXs set permissions by default that allow this) for instance.
 
 Tom Chiverton
 You don't have to be a mad scientist to believe in ColdFusion
 
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: Cf 5 on linux

2002-10-10 Thread Eric Hoffman

Yeah, I scoured pretty well, but came up with the same answer.  :-)

Regards,

Eric J Hoffman
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions 

-Original Message-
From: Tilbrook, Peter [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, October 09, 2002 7:16 PM
To: CF-Talk
Subject: RE: Cf 5 on linux


http://www.macromedia.com/software/trial_download/

Looks like only CFMX is available.

-Original Message-
From: Eric Hoffman [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 10 October 2002 8:40 AM
To: CF-Talk
Subject: Cf 5 on linux


Going to attempt to install CF 5 dev edition..is there a linux version
or a quick link someone has to the location to get the documentation,
etc...I am in moron mode today and can't find it on the site.

Regards,

Eric J Hoffman
DataStream Connexion
www.datastreamconnexion.com
Delivering Creative Data Solutions 





~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: SOT: RegEx

2002-10-10 Thread Patric Stumpe

Hi Willy,

if it's always the same structure you could get use
ListGet(myString, 3, ' ') With space as delimiter.

Just a thought...

Patric


WR Ok, I have a string that looks like this:

WR /web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 95kb 0.3u 0:01

WR It's an imagemagic identification of a file that my user is uploading.  myfile.jpg 
is CFFILE.clientfile.

WR I need to go through this thing and get the 1280x1024 out.  I could come up with a 
way to do this w/o regular expressions, but it wouldn't be as flexible as I'd like it 
to be.

WR I've tried this:


WR cfset location = REFind(/d+x/d+, mystring)

WR And this:

WR cfset start = REFind([/d+]x[/d+], mystring)

WR Doesn't seem to work.  Any ideas?





WR -
WR Willy Ray
WR Web Applications Developer
WR Certified Advanced ColdFusion Developer
WR Westminster College

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



RE: cfinclude inside a cffile tag?

2002-10-10 Thread Mosh Teitelbaum

OK, I'm not sure I understand this one correctly, so let me see...

app_OUTPUT.cfm is generating some content which includes HTML tags for
formatting.  You want to save this content to something.fnm, and then push
the file to the user where they can save it to their HD.  But, when the user
gets the file there should not be any HTML tags left in it... instead the
text should be formatted as per the HTML.  Is that right?

If so, you're going to have to handle the HTML rendering yourself, via CF
code.  CF doesn't know how to render HTML;  that's the responsibility of the
browser.  But you're trying to bypass the browser's rendering engine and
save the file straight to disk.  If the HTML code is simply some BR tags
and some nbsp; entities, you can render the contents with a couple of
ReplaceNoCase() calls as in:

cfsavecontent variable=sqlOutput
cfinclude template=app_OUTPUT.cfm
/cfsavecontent

CFSET sqlOutput = ReplaceNoCase(sqlOutput, BR, #Chr(13)##Chr(10)#,
ALL)
CFSET sqlOutput = ReplaceNoCase(sqlOutput, nbsp;,  , ALL)

cffile action=WRITE
...

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


 -Original Message-
 From: Les Mizzell [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 10:52 AM
 To: CF-Talk
 Subject: RE: cfinclude inside a cffile tag?


 : Are you trying to generate a file that gets saved (HTML tags and
 : all) to a
 : file or do you want to generate a file that gets displayed in
 the browser
 : (and the HTML gets rendered by the browser)?


 Neither...

 The file is being pushed to the client to be saved as a properly formatted
 text file with the .fnm extension for opening and processing in another
 program. Don't want it to open in the browser.  The HTML that's
 in there is
 to get the formatting correct and can't appear in the
 output...some of which
 is pretty weird, like a certain value HAS to start at position 237 on a
 specific line (no wrapping)

 The cfinclude template app_OUTPUT.cfm will generate the proper
 output for
 me I then need to get that output into WhateverFileName.fnm, which
 then gets pushed to the user to save.


 Thanks,

 Les

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



multiple case values in switch statement in cfscript

2002-10-10 Thread Kola Oyedeji

Hi

Could anyone tell me if its possible to define multiple case statements
In a switch block in cfscript..

So a cfscript version of :

cfcase = a,b,c,d,e 


Thanks

Kola


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



RE: SOT: RegEx

2002-10-10 Thread Everett, Al

I thought of that too, but what if there's a space in the file path?

 -Original Message-
 From: Patric Stumpe [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 12:04 PM
 To: CF-Talk
 Subject: Re: SOT: RegEx
 
 
 Hi Willy,
 
 if it's always the same structure you could get use
 ListGet(myString, 3, ' ') With space as delimiter.
 
 Just a thought...
 
 Patric
 
 
 WR Ok, I have a string that looks like this:
 
 WR /web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 
 95kb 0.3u 0:01
 
 WR It's an imagemagic identification of a file that my user 
 is uploading.  myfile.jpg is CFFILE.clientfile.
 
 WR I need to go through this thing and get the 1280x1024 
 out.  I could come up with a way to do this w/o regular 
 expressions, but it wouldn't be as flexible as I'd like it to be.
 
 WR I've tried this:
 
 
 WR cfset location = REFind(/d+x/d+, mystring)
 
 WR And this:
 
 WR cfset start = REFind([/d+]x[/d+], mystring)
 
 WR Doesn't seem to work.  Any ideas?
 
 
 
 
 
 WR -
 WR Willy Ray
 WR Web Applications Developer
 WR Certified Advanced ColdFusion Developer
 WR Westminster College
 
 WR 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



Re: 2nd question - Run MX as nobody?

2002-10-10 Thread Cathy Taylor

No, this is not a good enough answer. Nobody is *not supposed* to have a
shell and it worked just fine before CFMX. This is a security issue and I
feel should be investigated more fully before being written off in a pat
manner. I'm quite familiar with the script and how it works. I think this
has more to do with how it is doing the suid function.

Cathy Taylor

- Original Message -
From: Jesse Noller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 11:58 AM
Subject: RE: 2nd question - Run MX as nobody?


 Look in the coldfusion start script.

 The start script run su -$user -c command

 On linux, su gives you the option of defining a run-time shell. Solaris
does not, therefore, the solaris user you run CFMX as needs a valid shell.

 Jesse Noller
 [EMAIL PROTECTED]
 Macromedia Server Development

 No concept man forms is valid unless he
 integrates it without contradiction into the
 sum of his knowledge.
 - Ayn Rand

  -Original Message-
  From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 10, 2002 11:50 AM
  To: CF-Talk
  Subject: RE: 2nd question - Run MX as nobody?
 
   You don't need to login as the cfuser, however, the CFuser needs
   a valid shell
 
  It does ? What for ?
 
   as well as typical privs associated with it.
 
  I guess it depends what you mean by typical :-)
  I wouldn't want my CFMX user to have read access to everything below
/home
  (some UNIXs set permissions by default that allow this) for instance.
 
  Tom Chiverton
  You don't have to be a mad scientist to believe in ColdFusion
 
 
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com



RE: cfinclude inside a cffile tag?

2002-10-10 Thread Les Mizzell

cfsavecontent variable=sqlOutput
cfinclude template=app_OUTPUT.cfm
/cfsavecontent

CFSET sqlOutput = ReplaceNoCase(sqlOutput, BR, #Chr(13)##Chr(10)#,
ALL)
CFSET sqlOutput = ReplaceNoCase(sqlOutput, nbsp;,  , ALL)

cffile action=WRITE




That did the exact trick!

How much do I owe you for the consult?

Les

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Re: FileMaker Pro Backend DB?

2002-10-10 Thread Dick Applebaum

Here is how to do this -- assuming you have FIleMaker and the JDBC  
driver (fmpjdbc12.jar).

1) Start FileMaker and create/open a db called

Data Source :  FileMakerTest
  CF Data Source Name   FileMakerTest   
  JDBC URL       jdbc:fmpro:http://www..yourwebsite.com:591/
  Driver Class   com.fmi.jdbc.JdbcDriver
  Driver Name    FileMakerJDBC  
  Username
    
Put the fmpjdbc12.jar file path in your classpath, or put the jar in
/Library/Java extensions

I just tried it and it worked fine

HTH

Dick

On Thursday, October 10, 2002, at 07:50 AM, Sharon DiOrio wrote:

 The only real reason to use FMP as a back-end database is if people are
 still access it through the regular FMP interface.

 Sharon
 - Original Message -
 From: Bob Haroche [EMAIL PROTECTED]
 To: CF-Talk [EMAIL PROTECTED]
 Sent: Wednesday, October 09, 2002 7:05 PM
 Subject: Re: FileMaker Pro Backend DB?


 It will take me a while to dig up the info on how to do this -- I
 will
 post later.

 I'd appreciate that. Since the site isn't expecting heavy traffic, I
 was thinking a migration over to MS Access or MySQL if necessary. I
 don't think the project warrants moving up to SQL server or similar.


 -
 Regards,
 Bob Haroche
 O n P o i n t  S o l u t i o n s
 www.OnPointSolutions.com


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



Re: 2nd question - Run MX as nobody? - Solution

2002-10-10 Thread Cathy Taylor

This is not an option. I don't know how many times I have to say that. We have been 
using ColdFusion for years and have systems in place on it. We're forward thinking and 
trying to get rid of our legacy applications, not create new ones. It will not be an 
option for us to move forward unless CFMX can be run as nobody. 

Part of our security hardening procedure on production servers is to allow *no* user 
accounts other than administrators. None of our production software runs as a user 
other than nobody. We have *never* had a problem with that. I cannot just change the 
rules - they are dictated by a federal governing body (and I would lose my job and 
worse if I did). 

We took this problem to SUN to cover our bases as well and here was their response, 
backing up my security issue here:

Following up on this case regarding locking down a solaris system via the login 
shell. My understanding is one of your 3rd party plugins (coldfusion) must implement a 
valid shell for the user nobody, who normally does not have any shell assigned for 
obvious reasons. I dont know if I agree with the fact that coldfusion actually 
requires a shell since it is a security hole but thats another ballgame. Does 
coldfusion actually require a user to login? If not, I would highly recommend using the
noshell program which is much more secure than say /bin/false. This shell wont let the 
user actually login but it is a valid shell. You can get this right off of:

http://www.cert.org/security-improvement/implementations/i049.02.html

This site gives step by step instructions for using the noshell program, which is 
very straight forward and takes no more than 10 minutes. If coldfusion actually 
requires a login than their will be no choice but to assign a valid shell (ie. 
/bin/csh) to the user nobody and lock the system down appropriately (ie. specify NP in 
the /etc/shadow file or what not). A valid shell always leave a system open to hacker 
attacks so I would suggest reviewing the following security faq which tells you pretty 
much everything you need to know on how to secure the system:

http://muse.linuxmafia.org/lost+found/solaris-security-faq.html#Q3.10

I hope this helps.

Best Regards,

I will look into the noshell option to see if it works and is feasible, but I am 
highly disappointed that this was written off as a seemingly non-issue when it in fact 
is a huge issue.

Cathy Taylor

- Original Message - 
From: Jesse Noller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 12:00 PM
Subject: RE: 2nd question - Run MX as nobody? - Solution


 Cathy-
 
 Do *not* run coldfusion as the nobody user then. CFMX requires the user it runs as 
have a valid shell on solaris as solaris SU does not allow for on the fly shell 
definition to run a given command. 
 
 CF5 bypassed this by having an internal SUID system. CFMX does not.
 
 Jesse Noller
 [EMAIL PROTECTED]
 Macromedia Server Development
 
  -Original Message-
  From: Cathy Taylor [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 10, 2002 11:48 AM
  To: CF-Talk
  Subject: RE: 2nd question - Run MX as nobody? - Solution
  
  No, that's not a viable solution. I cannot give 'nobody' a shell. That
  defeats the purpose of nobody.
  
  I posted in the forum (hey Troy, that was probably me!) and am not
  receiving a response and have also submitted a bug report. I have narrowed
  it down to this:
  
  CFMX will run as nobody if no shell is specified (nothing at the end of
  the line in /etc/passwd). It will not run if /dev/null or /bin/false is
  specified as the shell. The gov't agency I work for has strict
  requirements that one of the above be specified. This worked for for CF
  4.5 and 5.0. It suddenly does not work with CFMX. (It also works for all
  web servers we have run and currently run, so should not be a major issue).
  
  Glad to hear I'm not the only one. I'm kind of bummed I haven't received
  any reply from Macromedia though to at least confirm my suspicion and say,
  Hey, we'll get right on that!. We're at a standstill until it's resolved.
  
  Thanks for the feedback! I seem to miss some using the digest and will try
  to pay more attention!
  
  Cathy
  
  
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm



RE: JEdit Source Control -- was Re: Visual Source Safe and CF Studio

2002-10-10 Thread Joshua Miller

Jedit supports MS Visual Source Safe using the SourceControl plugin and
CVS using the JEditCVS plugin. Both can be had using the built-in plugin
installed (Plugins  Plugin Manager  Install Plugins) or from
http://plugins.jedit.org

Thanks,

Joshua Miller
[EMAIL PROTECTED]


-Original Message-
From: S. Isaac Dealey [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 10:46 AM
To: CF-Talk
Subject: OT: JEdit Source Control -- was Re: Visual Source Safe and CF
Studio


This is OT but I'm wondering if anyone in the JEdit community has heard
anything about a source/version control plugin? I'm less concerned about
versioning and the like, but it'd be nice to have access to a simple
checkout/checkin service to prevent simultaneous overwrites, and/or a
document comparison tool.


 Weel that's what I mean to recall too. Jeff said he had a mapped 
 drive, so it shouldn't be a problem. And VSS-Server allows to publish 
 a project (if needed) to an online server. I think it's a very good 
 solution for a concurrent users working with CFStudio. The only sad 
 thing is to connect to the VSS-Server via Internet. I tested 
 SourceOffSite, but that screwed (kind of) my checked in/out files with

 where users with LAN-connection to the server worked also on the 
 project. Hrmm... Perhaps I'll try to get my VPN working sometime...

 Patric



 KW I don't believe Projects work with RDS. Project are based on local

 KW or mapped drives.

 KW Ken



 KW -Original Message-
 KW From: Jeffry Houser [mailto:[EMAIL PROTECTED]]
 KW Sent: Thursday, October 10, 2002 9:39 AM
 KW To: CF-Talk
 KW Subject: Re: Visual Source Safe and CF Studio


 KW   Okay, that makes sense.  I can't figure out how to fill a CF 
 KW Studio project with files over RDS, though.
 KW   It hasn't helped that the server was inaccessible by me this
 morning,
 KW though.


 KW At 03:07 PM 10/10/2002 +0200, you wrote:
Hi Jeffry,

when you log any file out via CFStudio it becomes marked ni VSS on 
the server. At least it should be.

Patric


JH At 01:08 PM 10/10/2002 +0100, you wrote:
 How does CF Studio integrate with Visual Source Safe?
 
 Very well, I've used it in the past.
 
 It seems to me that VSS is intended to copy the file locally.
 KW That
 I think I'm probably missing something important with regards

   to
 Source
   Control.
 
 Well, if it didn't copy it to local storage, how would you be able

 to edit it ?
 
 I think the way round it is to check things out to a local 
 project, and
 then
 use Studio's deploy functions to send them up to the RDS server 
 when

 ya done.

JH   It is all becoming clear (sort of)
JH   However, if all the other developers are editing on Server A,
wouldn't I
JH have to be editing on the same server for the VSS to have any 
JH effect?


JH --
JH Jeffry Houser | mailto:[EMAIL PROTECTED]
JH Need a Web Developer?  Contact me!
JH AIM: Reboog711  | Phone: 1-203-379-0773
JH --
JH My CFMX Book: 
JH http://www.amazon.com/exec/obidos/ASIN/0072225564/instantcoldfu-
JH 20
JH 
JH My Books: http://www.instantcoldfusion.com
JH My Band: http://www.farcryfly.com

JH


 KW
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



Re: 2nd question - Run MX as nobody?

2002-10-10 Thread Troy Simpson

Jesse,

Why does the CFMX deamon require a user account with a shell?

Thanks,
Troy

Jesse Noller wrote:

 You don't need to login as the cfuser, however, the CFuser needs a valid shell as 
well as typical privs associated with it.

 Jesse Noller
 [EMAIL PROTECTED]
 Macromedia Server Development

 No concept man forms is valid unless he
 integrates it without contradiction into the
 sum of his knowledge.
 - Ayn Rand

  -Original Message-
  From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 10, 2002 11:24 AM
  To: CF-Talk
  Subject: RE: 2nd question - Run MX as nobody?
 
   Make the cfmx user with privs to access the webserver document
   directory, otherwise, it is a normal user account.
 
  !
 
  Why would you ever need to login as the user CF runs as ?
  Why does it need to be a member of the groups most users are part of
  (usually 'users' by default) ?
 
  Tom Chiverton
  You don't have to be a mad scientist to believe in ColdFusion
 
 
 
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: OT: Query Analyzer on Win95

2002-10-10 Thread S . Isaac Dealey

Oh duh... ummm... hmmm... that's odd -- I thought it would allow you to
install the Client Access Tools (client connectivity, query analyzer,
enterprise manager) -- on Win98 you may need to use the SQL 7 client access
tools... I know the server portion will only install on Win2K or later... I
didn't realize but I think the same may be true for the client tools.

 I was hoping that the Enterprise Manager would be included but it is not.
 And the Client Connectivity Tools is
 just a tool about what protocal you can use for connecting to a SQL
 Server, i.e. Named Pipes or TCP/IP.

 Mitko
 -- Original Message --
 From: S. Isaac Dealey [EMAIL PROTECTED]
 Reply-To: [EMAIL PROTECTED]
 Date:  Thu, 10 Oct 2002 10:33:04 -0400

I believe Query Analyzer is a part of the Client Connectivity Tools
bundle... along with Enterprise Manager... I could be wrong, but that's
always been my impression.

S. Isaac Dealey
Certified Advanced ColdFusion 5 Developer

www.turnkey.to
954-776-0046

 Hello,

 I want to be able to run Query Analyzer for SQL Server 7 or 2000 on a
 Windows 95 machine. Is this possible? I tried installing from a SQL
 Server
 2000 Standard Edition but the only thing it offered to install were the
 Client Connectivity Tools and English Query. Is there any place where I
 could get the Query Analizer as a stand-alone tool? Perhaps from Visual
 Studio?

 Thanks in advance,

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



Re: OT: Browser Usage

2002-10-10 Thread BEN MORRIS

On my site about 25% or less use Netscape, leaving 75-80% for IE.  This seems to be 
pretty consistent across the board.

http://www.w3schools.com/browsers/browsers_stats.asp

 [EMAIL PROTECTED] 10/09/02 07:50PM 
Hi All,

Does any one know what percentage of users use/ prefer 
Netscape 4.5 or 6  over IE.

Thanks

S






~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



Please clarify behaviour of listContainsNoCase

2002-10-10 Thread Kola Oyedeji

Can someone confirm to me that this is the correct behaviour for
listcontainsNoCase:

cfscript
   if( listContainsNoCase(MRS,MS,MISS, mr  , , )) {
gender = F;
   } else {
gender = m;
   }
/cfscript

cfoutput#gender#/cfoutput

returns F, if I change the first entry in the list to MZ, M gets
outputted.
I'm assuming this is because MRS contains 'MR' however I thought the
whole point of having a listcontainsNocase function (as opposed to using
contains() ) was that the function would look at each entry as a whole?

Thanks

Kola


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



Wiki

2002-10-10 Thread project_boo

Are there any Wiki's written in cold fusion? Every one that I found was 
written in Asp
I thought I saw a reference to one in a passing e-mail. recently.
One of the abusers of the societies project suggested that it would work 
well to encourage people to share data.
Any comments

michael



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



Re: multiple case values in switch statement in cfscript

2002-10-10 Thread Gyrus

- Original Message -
 Could anyone tell me if its possible to define multiple case statements
 In a switch block in cfscript..
---

I don't think this is possible. If you get an error when you try it, that
would confirm things :-)  I think it might be to do with CFScript being kept
as close as possible to JavaScript. Use cfswitch if necessary...

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

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



RE: Visual Source Safe and CF Studio

2002-10-10 Thread Fitch, Tyler

Hi Lee,

I've found VSS with DWMX to be way, way, way better than any usage of
projects in studio ever was.

The VSS integration is one of the main reasons I switched early on.

Cheers,

t

**
Tyler M. Fitch
Certified Advanced ColdFusion 5 Developer
http://isitedesign.com
**

-Original Message-
From: Lee Fuller [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, October 10, 2002 6:45 AM
To: CF-Talk
Subject: RE: Visual Source Safe and CF Studio


On a slightly different note..  Anyone have experience with Dreamweaver
MX and VSS?  Work as well as Studio/VSS?


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



RE: Another MX boo boo

2002-10-10 Thread Rob Rohan

Yeah we still are. If you'd like I'll send you a link to our dev server (off
list) with a page that shows whats going on. Mail me off list if you want to
see. Sean has the link too.

-Original Message-
From: Michael Corbridge [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 6:40 AM
To: CF-Talk
Subject: RE: Another MX boo boo


Rob,

I get:

dateFormat(now(), dd/mm/yy (ddd)) = 10/10/02 (Thu)

on my CFMX server.

Are you still experiencing difficulties, and let me know if you are.

Thanks,

michael d corbridge
macromedia
617.219.2307
[EMAIL PROTECTED]


-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 08, 2002 5:07 PM
To: CF-Talk
Subject: Another MX boo boo


dateFormat(now(), dd/mm/yy (ddd))

No longer works in MX. looks like only certain characters work in date
format.

Rob



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



RE: 2nd question - Run MX as nobody?

2002-10-10 Thread Jesse Noller

Cathy-

   I wrote the CFMX start script. I also wrote the install. I wrote all of the scripts 
located in /bin/coldfusion.

   If you do not want to define a shell for the nobody user, and as solaris does *NOT* 
allow on the fly shell definition, you must run CFMX as something other than nobody 
with a validly defined shell.

   CFMX is written on top of JRun, therefore, we inherit it's methodology to an 
extent. JRun requires you install, and run (therefore it must be a valid user account) 
JRun as the user you wish to run it as.

   As you have pointed out, this differs from CF5. This is because CFMX is not written 
on the CF6 codebase, and has negligable C components. 

   CF5 and previous revisions has a C binary, the launcher, which would read out the 
run time user you defined. It would then perform a start function as the root user, 
fork the process and perform an SUID switching to that defined user. 

   This was made possible because Tom J (the primary engineer) wrote the C binaries 
for launching implementing his own SUID system. 

   CFMX did not have that luxury, our goal was to utilize as little C code as humanly 
possible. We were also built on top of JRun. As we could not expect CF users to 
install and run as a given user like JRun requires, we did what you see now.

   Inside the script, for Unixes, we perform an su -u $user -c 'command' and on Linux, 
we define an on the fly shell which is only utilized for the running of that single 
command.

   Solaris does not *allow* the definition of a shell when you su to a given user. 
This was a servere problem with us, and the only way around it is to ensure the 
defined user has a predefined shell.

   While some will accuse this as a security risk, the coldfusion documentation states 
(or should) that you should run CFMX as a user OTHER than nobody, instead, you should 
create a user account specifically for CFMX. It has never been recommended that you 
run CF as the same user as the webserver, we choose nobody during the install as that 
provides the easiest method of installation.

   If solaris changed SU to allow for on the fly shell definition, then we can change 
the script, otherwise on solaris the runtime user must have a valid shell.

-Jesse Noller
Macromedia

-Original Message-
From: Cathy Taylor
To: CF-Talk
Sent: 10/10/2002 9:15 AM
Subject: Re: 2nd question - Run MX as nobody?

No, this is not a good enough answer. Nobody is *not supposed* to have a
shell and it worked just fine before CFMX. This is a security issue and
I
feel should be investigated more fully before being written off in a pat
manner. I'm quite familiar with the script and how it works. I think
this
has more to do with how it is doing the suid function.

Cathy Taylor

- Original Message -
From: Jesse Noller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 11:58 AM
Subject: RE: 2nd question - Run MX as nobody?


 Look in the coldfusion start script.

 The start script run su -$user -c command

 On linux, su gives you the option of defining a run-time shell.
Solaris
does not, therefore, the solaris user you run CFMX as needs a valid
shell.

 Jesse Noller
 [EMAIL PROTECTED]
 Macromedia Server Development

 No concept man forms is valid unless he
 integrates it without contradiction into the
 sum of his knowledge.
 - Ayn Rand

  -Original Message-
  From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 10, 2002 11:50 AM
  To: CF-Talk
  Subject: RE: 2nd question - Run MX as nobody?
 
   You don't need to login as the cfuser, however, the CFuser needs
   a valid shell
 
  It does ? What for ?
 
   as well as typical privs associated with it.
 
  I guess it depends what you mean by typical :-)
  I wouldn't want my CFMX user to have read access to everything below
/home
  (some UNIXs set permissions by default that allow this) for
instance.
 
  Tom Chiverton
  You don't have to be a mad scientist to believe in ColdFusion
 
 
 
 
 
 

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



RE: cfx_pwtextcrypt

2002-10-10 Thread Rob Rohan

Hi Ben,
We used to use that tag and abandoned it. I wrote an in house
implementation with stronger encryption - plus the tag would crash our
server almost ever other day, think it has a memory leak.

Anyway I'll try to help if I can.



-Original Message-
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 8:55 AM
To: CF-Talk
Subject: cfx_pwtextcrypt


Anyone currently using the cfx_pwtextcrypt custom tag that can answer a
few questions off list?

Thanks,
Ben

Ben Densmore
Web Developer
eSupport.com,Inc.
1538 Turnpike St.
North Andover, MA 01845

Phone: (978) 686-6468 x333
Email: [EMAIL PROTECTED]




~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: multiple case values in switch statement in cfscript

2002-10-10 Thread Mark A. Kruger - CFG

No it is not.  Each case must be listed individually.  If you really must
use a single case for multiple values you will have to move to tag syntax
(cfswitch).

-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 11:11 AM
To: CF-Talk
Subject: multiple case values in switch statement in cfscript


Hi

Could anyone tell me if its possible to define multiple case statements
In a switch block in cfscript..

So a cfscript version of :

cfcase = a,b,c,d,e 


Thanks

Kola



~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm



RE: Problem with a dynamic menu and loops.

2002-10-10 Thread Cornillon, Matthieu

You could treat it as two separate queries, each of which feed a segment of
the select list.  So, in half-pseudo-sortof-code:

CFQUERY name=GetTargetDept...
SELECT NEEDEDCOLUMNS
FROM TABLE
/CFQUERY

CFQUERY name=GetOtherDepts...
SELECT NEEDEDCOLUMNS
FROM TABLE
/CFQUERY

SELECT name=...
CFOUTPUT query=GetTargetDept
OPTION...
/CFOUTPUT
CFOUTPUT query=GetOtherDepts
OPTION...
/CFOUTPUT
/SELECT

So you are just stacking the results from one query on top of the other.
I'm sure that your means of generating the department information are
probably different, but I imagine that this should work nonetheless.

Matthieu


-Original Message-
From: Adams, Stephen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 5:11 AM
To: CF-Talk
Subject: Problem with a dynamic menu and loops.


**
WESTMINSTER CITY COUNCIL
Please refer to the disclaimer beneath this message
**

Hi,

I am building an Intranet that has a menu for the company departments.  This
menu is populated by a query that returns the department name, title,
description, filename and the page URL. When a Department is selected the
page goes to that particular departments homepage and the menu expands to
display all the pages underneath that department, e.g. 

Human Resources
 - Holiday Form
 - Sick Pay
 - Contact HR

My problem is that I want to have the selected department appear at the top
of my series of departments, and still keep the other departments in
alphabetical order.  So I'd have:

Human Resources
 - Holiday Form
 - Sick Pay
 - Contact HR
Customer Service
Finance
Planning

Has anyone tried something like this before, or has any idea how I can do
this?

Thanks

Stephen


**
Westminster City Council switchboard: 
+44 20 7641 6000
**
This E-Mail may contain information which is 
privileged, confidential and protected from 
disclosure.  If you are not the intended recipient 
of this E-mail or any part of it, please telephone 
Westminster City Council immediately on receipt.
You should not disclose the contents to any other 
person or take copies.
**


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: multiple case values in switch statement in cfscript

2002-10-10 Thread Rob Rohan

cfcase = a,b,c,d,e delimiters=,

-Original Message-
From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 9:11 AM
To: CF-Talk
Subject: multiple case values in switch statement in cfscript


Hi

Could anyone tell me if its possible to define multiple case statements
In a switch block in cfscript..

So a cfscript version of :

cfcase = a,b,c,d,e 


Thanks

Kola



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



RE: 2nd question - Run MX as nobody? - Solution

2002-10-10 Thread Jesse Noller

 Cathy-

   I do recommend trying the noshell option. This was not written off as a non-issue, 
it was not feasible for us to write more C code binaries, and we were not left 
pleasant options.

  I will discuss this matter internally once I am over this flu-bug, and I will see 
what we can do. Our only real option is to either write a new C-launcher binary (not 
good, very bad, severe change in CFMX) or enforce the JRun method of installation (Not 
a good user experience) it is a loose-loose situation on our part.

   I will see what I can do, and will explore the options internally.

-Jesse Noller
Macromedia

-Original Message-
From: Cathy Taylor
To: CF-Talk
Sent: 10/10/2002 9:26 AM
Subject: Re: 2nd question - Run MX as nobody? - Solution

This is not an option. I don't know how many times I have to say that.
We have been using ColdFusion for years and have systems in place on it.
We're forward thinking and trying to get rid of our legacy applications,
not create new ones. It will not be an option for us to move forward
unless CFMX can be run as nobody. 

Part of our security hardening procedure on production servers is to
allow *no* user accounts other than administrators. None of our
production software runs as a user other than nobody. We have *never*
had a problem with that. I cannot just change the rules - they are
dictated by a federal governing body (and I would lose my job and worse
if I did). 

We took this problem to SUN to cover our bases as well and here was
their response, backing up my security issue here:

Following up on this case regarding locking down a solaris system via
the login shell. My understanding is one of your 3rd party plugins
(coldfusion) must implement a valid shell for the user nobody, who
normally does not have any shell assigned for obvious reasons. I dont
know if I agree with the fact that coldfusion actually requires a shell
since it is a security hole but thats another ballgame. Does coldfusion
actually require a user to login? If not, I would highly recommend using
the
noshell program which is much more secure than say /bin/false. This
shell wont let the user actually login but it is a valid shell. You can
get this right off of:

http://www.cert.org/security-improvement/implementations/i049.02.html

This site gives step by step instructions for using the noshell
program, which is very straight forward and takes no more than 10
minutes. If coldfusion actually requires a login than their will be no
choice but to assign a valid shell (ie. /bin/csh) to the user nobody and
lock the system down appropriately (ie. specify NP in the /etc/shadow
file or what not). A valid shell always leave a system open to hacker
attacks so I would suggest reviewing the following security faq which
tells you pretty much everything you need to know on how to secure the
system:

http://muse.linuxmafia.org/lost+found/solaris-security-faq.html#Q3.10

I hope this helps.

Best Regards,

I will look into the noshell option to see if it works and is feasible,
but I am highly disappointed that this was written off as a seemingly
non-issue when it in fact is a huge issue.

Cathy Taylor

- Original Message - 
From: Jesse Noller [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Thursday, October 10, 2002 12:00 PM
Subject: RE: 2nd question - Run MX as nobody? - Solution


 Cathy-
 
 Do *not* run coldfusion as the nobody user then. CFMX requires the
user it runs as have a valid shell on solaris as solaris SU does not
allow for on the fly shell definition to run a given command. 
 
 CF5 bypassed this by having an internal SUID system. CFMX does not.
 
 Jesse Noller
 [EMAIL PROTECTED]
 Macromedia Server Development
 
  -Original Message-
  From: Cathy Taylor [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 10, 2002 11:48 AM
  To: CF-Talk
  Subject: RE: 2nd question - Run MX as nobody? - Solution
  
  No, that's not a viable solution. I cannot give 'nobody' a shell.
That
  defeats the purpose of nobody.
  
  I posted in the forum (hey Troy, that was probably me!) and am not
  receiving a response and have also submitted a bug report. I have
narrowed
  it down to this:
  
  CFMX will run as nobody if no shell is specified (nothing at the end
of
  the line in /etc/passwd). It will not run if /dev/null or /bin/false
is
  specified as the shell. The gov't agency I work for has strict
  requirements that one of the above be specified. This worked for for
CF
  4.5 and 5.0. It suddenly does not work with CFMX. (It also works for
all
  web servers we have run and currently run, so should not be a major
issue).
  
  Glad to hear I'm not the only one. I'm kind of bummed I haven't
received
  any reply from Macromedia though to at least confirm my suspicion
and say,
  Hey, we'll get right on that!. We're at a standstill until it's
resolved.
  
  Thanks for the feedback! I seem to miss some using the digest and
will try
  to pay more attention!
  
  Cathy
  
  
 


RE: SOT: RegEx

2002-10-10 Thread Greg McDaniel

If it always bounded by JPEG and DirectClass, you could use the getContainer
tag.

Greg

-Original Message-
From: Everett, Al [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 11:15 AM
To: CF-Talk
Subject: RE: SOT: RegEx


I thought of that too, but what if there's a space in the file path?

 -Original Message-
 From: Patric Stumpe [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 12:04 PM
 To: CF-Talk
 Subject: Re: SOT: RegEx


 Hi Willy,

 if it's always the same structure you could get use
 ListGet(myString, 3, ' ') With space as delimiter.

 Just a thought...

 Patric


 WR Ok, I have a string that looks like this:

 WR /web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit
 95kb 0.3u 0:01

 WR It's an imagemagic identification of a file that my user
 is uploading.  myfile.jpg is CFFILE.clientfile.

 WR I need to go through this thing and get the 1280x1024
 out.  I could come up with a way to do this w/o regular
 expressions, but it wouldn't be as flexible as I'd like it to be.

 WR I've tried this:


 WR cfset location = REFind(/d+x/d+, mystring)

 WR And this:

 WR cfset start = REFind([/d+]x[/d+], mystring)

 WR Doesn't seem to work.  Any ideas?





 WR -
 WR Willy Ray
 WR Web Applications Developer
 WR Certified Advanced ColdFusion Developer
 WR Westminster College

 WR


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: Please clarify behaviour of listContainsNoCase

2002-10-10 Thread Everett, Al

You want ListFindNoCase()

 -Original Message-
 From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
 Sent: Thursday, October 10, 2002 12:41 PM
 To: CF-Talk
 Subject: Please clarify behaviour of listContainsNoCase
 
 
 Can someone confirm to me that this is the correct behaviour for
 listcontainsNoCase:
 
 cfscript
if( listContainsNoCase(MRS,MS,MISS, mr  , , )) {
 gender = F;
} else {
   gender = m;
}
 /cfscript
 
 cfoutput#gender#/cfoutput
 
 returns F, if I change the first entry in the list to MZ, M gets
 outputted.
 I'm assuming this is because MRS contains 'MR' however I thought the
 whole point of having a listcontainsNocase function (as 
 opposed to using
 contains() ) was that the function would look at each entry 
 as a whole?
 
 Thanks
 
 Kola
 
 
 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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



copying db info with cf

2002-10-10 Thread Cornillon, Matthieu

Hi.  I work on a site that has development, preview/testing, and production
environments.  These are fully independent right down to the database
environments.  It's all Oracle on the back end.  I've taken care that the
data structure is identical from environment to environment.  However, the
data itself is a little trickier.  Some of it is basic data that I set up
when the tables are established.  But some stuff gets entered later, and I
am trying to figure out a clever way to move data from one of the db
environments to another.
 
I could, of course, pull the data, try to have cf spit out sql statements
that I then paste into another page, but I am wondering whether there is
some smarter way?  I am imagining some simple export format that I import on
the other boxes.
 
Note: this is probably obvious, but just in case: the CF servers are all
independent, so no CF code can access another server's DBs.
 
Thanks,
Matthieu
 

Pfizer Information Center

 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: RegEx

2002-10-10 Thread Greg McDaniel

Sorry, getContainer is not a tag, it is a UDF that you can find on
cflib.org.

Greg
-Original Message-
From: Willy Ray [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 10:55 AM
To: CF-Talk
Subject: SOT: RegEx


Ok, I have a string that looks like this:

/web/path/to/myfile.jpg JPEG 1280x1024 DirectClass 8-bit 95kb 0.3u 0:01

It's an imagemagic identification of a file that my user is uploading.
myfile.jpg is CFFILE.clientfile.

I need to go through this thing and get the 1280x1024 out.  I could come up
with a way to do this w/o regular expressions, but it wouldn't be as
flexible as I'd like it to be.

I've tried this:


cfset location = REFind(/d+x/d+, mystring)

And this:

cfset start = REFind([/d+]x[/d+], mystring)

Doesn't seem to work.  Any ideas?





-
Willy Ray
Web Applications Developer
Certified Advanced ColdFusion Developer
Westminster College


~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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.



VSS and Dreamweaver MX?

2002-10-10 Thread Lee Fuller

Do they also work as well together?

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm



RE: 2nd question - Run MX as nobody?

2002-10-10 Thread Jesse Noller

See other assorted emails. It's because solaris su does not allow on the fly shell 
definition for command execution 

-Original Message-
From: Troy Simpson
To: CF-Talk
Sent: 10/10/2002 9:42 AM
Subject: Re: 2nd question - Run MX as nobody?

Jesse,

Why does the CFMX deamon require a user account with a shell?

Thanks,
Troy

Jesse Noller wrote:

 You don't need to login as the cfuser, however, the CFuser needs a
valid shell as well as typical privs associated with it.

 Jesse Noller
 [EMAIL PROTECTED]
 Macromedia Server Development

 No concept man forms is valid unless he
 integrates it without contradiction into the
 sum of his knowledge.
 - Ayn Rand

  -Original Message-
  From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
  Sent: Thursday, October 10, 2002 11:24 AM
  To: CF-Talk
  Subject: RE: 2nd question - Run MX as nobody?
 
   Make the cfmx user with privs to access the webserver document
   directory, otherwise, it is a normal user account.
 
  !
 
  Why would you ever need to login as the user CF runs as ?
  Why does it need to be a member of the groups most users are part of
  (usually 'users' by default) ?
 
  Tom Chiverton
  You don't have to be a mad scientist to believe in ColdFusion
 
 
 
 
 
 

~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk
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.



  1   2   3   >