Re: Way OT: Internet Backbone

2004-02-06 Thread Alan Rafael Bleiweiss
At 04:35 PM 2/3/04, you wrote:
If you are serving North America then you should really host with
AboveNet or UUnet in Vienna, VA. If you'd like more than one location,

SNIP

If you'd like the dirty details on why the above providers are the best
and what makes those specific cities the best I am happy to spell that

Matt, Please - info - I'm about to sign with Navisite for my own rack at 
their Hudson St. facility here in
NY and then we are planning on bringing up our redundant rack in their 
Silicon Valley center...

Before I do though I'd greatly appreciate your dirty details!(Didn't 
AboveNet go through a major
financial fiasco recently?Navisite just went public this year...
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




easy dhtml menu

2004-02-06 Thread Daniel Farmer
I need to create a simple DHTML menu. Does anyone know of some good ones out there?

I need to integrate it with my site, preferably it will use layers.

~~
Daniel Farmer
Coldfusion Developer / Sales / Producer
613.284.1684
~~
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Serial Number

2004-02-06 Thread Pascal Peters
 
  Okay, now you've asked for it ;-). Here's one I've wondered 
 about for 
  a long time: Is there a good way to negate a _substring_ as 
 opposed to 
  being specific about each individual character? Lemme think of a
  (lame) example...
  
  1. see jane
  2. hear jane
  3. watch jane
  
  Is there a good way to match 1 and 2, besides doing something like 
  this... [^h][^e][^a][^r] jane or (see|watch) jane (say I don't 
  know about the words see or watch beforehand)
 
 I've never found a way to do this with pure regex.Which is 
 not to say that there isn't one.However, there's a 
 workaround I use when I need to do this.It has some 
 limitations, but it's generally useful.
 

AS I am in Europe, Ben Doom usually beats me with the good answers, but
here there may be a pure regexp solution if you are on CFMX. You can use
negative lookahead:

cfscript
string = ArrayNew(1);
string[1] = see jane;
string[2] = hear jane;
string[3] = watch jane;
regexp = \b(?!hear)\w+\sjane;
/cfscript
cfoutput
cfloop from=1 to=#ArrayLen(string)# index=i
#string[i]#: #REFindNoCase(regexp,string[i])#br/cfloop
/cfoutput

This will match two words, where the second word is jane and the first
is NOT hear.

Of course, if you want to match only jane NOT preceeded by hear you
would need lookbehind, which (sadly) isn't supported in CFMX.

(?!\bhear\s)jane

On CF5, you can't do all this and Ben's solution will help there

Pascal
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Serial Number

2004-02-06 Thread Pascal Peters
On CFMX, you can use negative lookahead to determine if the first part
is NOT only letters or numbers:

REFindNoCase(^(?![a-z]{3}|\d{3})\w{3}.*\d{7}$,str)

On CF5 I would do 2 operations:
Use the regexp provided below. If it checks, extract the first three
digits and see if they contain a letter AND a number.

Pascal 

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: vrijdag 6 februari 2004 4:18
 To: CF-Talk
 Subject: Re: Serial Number
 
 This worked, but, the first 3 must contain letter(s) AND 
 number(s), not
 letter(s) OR number(s). How would I do that?Thanks!
 
 
  refind(^[a-zA-Z0-9]{3}.*[0-9]{7}$, str)
 
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: XML storage

2004-02-06 Thread Thomas Chiverton
On Thursday 05 Feb 2004 20:32 pm, Jochem van Dieten wrote:
 Matt Liotta wrote:
 parts. The CLOB method, on the other hand, avoids these context
 issues. Instead of mapping schema to rows, the database preserves
 the data context and hierarchy in one unit. However, a SQL query
 cannot look inside the field holding the document and interpret

That's just plain wrong - certainly in Oracle 9i, and probably other heavy 
weight RDMS, there is a native XMLType column, and you can do XPath querys 
stright to it with SQL.

 it€”the only way to examine parts of a document is to return the
 whole thing in a result set.

Which makes that wrong too :-)
However in your other reply you go on to talk about databases with a native 
XMLType, so I'm sure you must have been aware of that.

I'm also of the view that if you are starting to have to worry about one extra 
disk (or more likly memory cache) read, you need to spend some more money on 
your database :-)

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Linux ODBC Socket

2004-02-06 Thread Thomas Chiverton
On Thursday 05 Feb 2004 23:58 pm, Dave Carabetta wrote:
 I don't believe that ODBC works on *nix systems. 

There are ODBC drivers in Java, that run on Linux (and any other O/S), afaicr.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Yet another OT Mail Relay move question

2004-02-06 Thread Dirk De Bock - Lists
What pending mail? Incoming or outgoing? You should be able to run the two mailservers simultaneously if you make sure to use different ports. 
That way you can have the postoffice server available on nonstandard ports so that people can still retrieve their old mail.
- Original Message - 
From: Alan Rafael Bleiweiss 
To: CF-Talk 
Sent: Friday, February 06, 2004 7:11 AM
Subject: Yet another OT Mail Relay move questionDoes anyone have any experience in how to move pending email
to the new server?(I've got fifty virtual domains...)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: jRockit

2004-02-06 Thread Thomas Chiverton
On Thursday 05 Feb 2004 20:35 pm, Samuel Neff wrote:
 I've talked to one of the CFMX engineers about using jRockit with CFMX 6.1
 and he said that they did extensive testing and found that it was faster in
 most situations but developed stability problems and random error messages
 when put under heavy load.

We couldn't even get CFMX61 under WebLogic to start up with Jrockit :-)

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:jRockit

2004-02-06 Thread Spectrum Web
Do you can send links to download IBM JVM? It's free? Open Source? Faster? Stable?

Thanks in advance

On Feb 5, 2004, at 2:36 PM, Michael Wolfe wrote:

Can anyone tell me more about jRockit?

I don't know about JRockit in particular, but I do know that there are 
faster JVMs out there than Sun's.I used to get very good results with 
IBM's.It's strange that Sun doesn't make the fastest JVM, and that 
Java does not run better on Solaris than on other operation systems, 
but it's true.

If you get ColdFusion working with JRockit, let us know what it's like.

Christian

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFDJ Spell Check Article this Month

2004-02-06 Thread Josen Ruiseco
In CFDJ this month Darron Schall wrote an article on how to add spell checking functionality to a site with open source Java. He does not, however, reveal the code for the _javascript_ interface that enables a user to replace, ignore, replace all, and ignore all, etc. 

Does anyone have this code written and available for others? If not, perhaps Ben Forta would be willing to share a portion of his CFX_SpellCheck source code to help us finish the project :-).

Here's a link to the article...

http://sys-con.com/coldfusion/articleprint.cfm?id=698
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Different query results in Access/ColdFusion

2004-02-06 Thread Christy Roberts
So using preservesinglequotes() will ensure that if people enter
apostrophes, it won't affect the results?I should definitely use that. :-)
What does CF_SQL_VARCHAR do? 

 
However, that wasn't what was causing my problem - someone on another board
figured it out last night.It was the groupby clause in the output query.
I removed that, and it works like a CHARM

 
But I would be interested in hearing about the other two options you
suggested.

 
Thanks
Christina
:-)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFDJ Spell Check Article this Month

2004-02-06 Thread Darron J. Schall
Sorry, I didn't have time to actually write that portion of the code.The article itself was already longer than it should've been, so I just threw that out as an idea of where to go from here.

I think I would implement that by having a list of ignored words.The spell check engine reports back the location of the error in the string, so you can see if the word at that location is ignored.. if not, pop up a window and ask if they want to replace it with something.If they chose to ignore all then add it to the ignore words list.. and keep doing that as you loop through the list of spelling errors.

-d
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Different query results in Access/ColdFusion

2004-02-06 Thread Pascal Peters
While you are right about cfqueryparam you are completely wrong about
preservesinglequotes.

PreserveSingleQuotes stops CF from escaping single quotes in the SQL.
This would mean that if you use it as below and somebody entered
O'connor street for Form.civicaddress, the query would throw an error.

There are a few cases where CF doesn't escape single quotes
automatically when using vars in the sql, and then you have to escape
them manually using Replace(var,','',all). Using cfqueryparam
fixes this too.

Pascal

 -Original Message-
 From: J E VanOver [mailto:[EMAIL PROTECTED] 
 Sent: donderdag 5 februari 2004 22:52
 To: CF-Talk
 Subject: RE: Different query results in Access/ColdFusion
 
 For ANY character data, you must either use CFQUERYPARAM or
 preservesinglequotes() or you are BEGGING for trouble.
 
 
 SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo ON 
 (tblPropertyInfo.PropID=tblRegistryInfo.PropID)
 AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
 WHERE CivicAddressStreet LIKE 
 '%#preservesinglequotes(Form.civicaddress)#%'
 AND Municipality = '#preservesinglequotes(Form.municipality)#'
 AND DocType = 'CONVEYANCE'
 ORDER BY CivicAddressNumber asc
 
 Or better:
 
 SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo ON 
 (tblPropertyInfo.PropID=tblRegistryInfo.PropID)
 AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
 WHERE CivicAddressStreet LIKE cfqueryparam cfsqltype=CF_SQL_VARCHAR
 value=%#Form.civicaddress#%
 AND Municipality = cfqueryparam cfsqltype=CF_SQL_VARCHAR
 value=#Form.municipality#
 AND DocType = 'CONVEYANCE'
 ORDER BY CivicAddressNumber asc
 
 This form ALSO protects you from SQL invasion attacks --
 people entering SQL commands into form fields in order to 
 cause mischief in your databases.
 
 Jevo
 
 -Original Message-
 From: Christina Robson [mailto:[EMAIL PROTECTED]
 Sent: Thursday, February 05, 2004 10:50 AM
 To: CF-Talk
 Subject: Re:Different query results in Access/ColdFusion
 
 
 Good idea, Bryan. :)Ok, here's my SQL statement!This 
 gives me different results depending on what I sort on.I've 
 yet to find a way to ensure it always gives me the right 
 results, regardless of how I sort it. Argh. :)
 
 Thanks!
 Christina
 
 cfquery name=getpropinfo datasource=#application.dns_name2#
 dbtype=ODBC
 
 SELECT * FROM tblPropertyInfo INNER JOIN tblRegistryInfo ON 
 (tblPropertyInfo.PropID=tblRegistryInfo.PropID)
 AND (tblPropertyInfo.PropDate=tblRegistryInfo.PropDate)
 WHERE CivicAddressStreet LIKE '%#Form.civicaddress#%'
 AND Municipality = '#Form.municipality#'
 AND DocType = 'CONVEYANCE'
 ORDER BY CivicAddressNumber asc
 
 /cfquery
 


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX install errors - says port 51010 is not open

2004-02-06 Thread Critter
oi CF-Talk,!!

ispecificallyhave that port opened on the computer, but the last screen in the install process
says the install was not successful due to the blocking of that port..

any suggestions?

/crit

-- 

=-=-=-=-=-=-=-=-=-=-=-=-=-[ Help me fight to keep my son in the US ]-=
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://keepmysoninthe.us ]-=

---
[This E-mail scanned for viruses by Declude Virus]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: jRockit

2004-02-06 Thread Kwang Suh
IIRC, CFMX comes with and uses the IBM JRE, not Sun's.

-Original Message-
From: Spectrum Web [mailto:[EMAIL PROTECTED] 
Sent: February 6, 2004 2:58 AM
To: CF-Talk
Subject: Re:jRockit

Do you can send links to download IBM JVM? It's free? Open Source? Faster?
Stable?

Thanks in advance

On Feb 5, 2004, at 2:36 PM, Michael Wolfe wrote:

Can anyone tell me more about jRockit?

I don't know about JRockit in particular, but I do know that there are 
faster JVMs out there than Sun's.I used to get very good results with 
IBM's.It's strange that Sun doesn't make the fastest JVM, and that 
Java does not run better on Solaris than on other operation systems, 
but it's true.

If you get ColdFusion working with JRockit, let us know what it's like.

Christian
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




MS Update broke security

2004-02-06 Thread Robert Everland III
Here is the issue I have. A month ago I had a question about authentication for basic authentication and how to do it with ColdFusion. I eventually found out that you can do this http://user:[EMAIL PROTECTED] and the user won't be prompted for a username or password. Well the last update of Internet Explorer broke this functionality. So I ask everyone out there, how do I do this without making the url that way. I have tried headers, cfheader and nothing I do seems to make the browser know that it needs to cache that password for future use. Is there anything in java I can do, anything at all. HELP!!
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MS Update broke security

2004-02-06 Thread Jochem van Dieten
Robert Everland III wrote:

 Here is the issue I have. A month ago I had a question about authentication for basic authentication and how to do it with ColdFusion. I eventually found out that you can do this http://user:[EMAIL PROTECTED] and the user won't be prompted for a username or password. Well the last update of Internet Explorer broke this functionality. So I ask everyone out there, how do I do this without making the url that way. I have tried headers, cfheader and nothing I do seems to make the browser know that it needs to cache that password for future use. Is there anything in java I can do, anything at all.

Not with Basic Authentication.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MS Update broke security

2004-02-06 Thread Schuster, Steven
They didn't break it, it is supposed to not work that way. So actually they
fixed it.



-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 8:08 AM
To: CF-Talk
Subject: MS Update broke security

Here is the issue I have. A month ago I had a question about authentication
for basic authentication and how to do it with ColdFusion. I eventually
found out that you can do this http://user:[EMAIL PROTECTED]
http://user:[EMAIL PROTECTED]and the user won't be prompted for a
username or password. Well the last update of Internet Explorer broke this
functionality. So I ask everyone out there, how do I do this without making
the url that way. I have tried headers, cfheader and nothing I do seems to
make the browser know that it needs to cache that password for future use.
Is there anything in java I can do, anything at all. HELP!!

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:MS Update broke security

2004-02-06 Thread Robert Everland III
Well when 90% of the world uses IE and they have this functiuonality since version 3 http://support.microsoft.com/default.aspx?kbid=200351 , then they broke it.

Bob

They didn't break it, it is supposed to not work that way. So actually they
fixed it.

 

 

 

-Original Message-
From: Robert Everland III [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 8:08 AM
To: CF-Talk
Subject: MS Update broke security

 

Here is the issue I have. A month ago I had a question about authentication
for basic authentication and how to do it with ColdFusion. I eventually
found out that you can do this http://user:[EMAIL PROTECTED]
http://user:[EMAIL PROTECTED]and the user won't be prompted for a
username or password. Well the last update of Internet Explorer broke this
functionality. So I ask everyone out there, how do I do this without making
the url that way. I have tried headers, cfheader and nothing I do seems to
make the browser know that it needs to cache that password for future use.
Is there anything in java I can do, anything at all. HELP!!

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MS Update broke security

2004-02-06 Thread Thomas Chiverton
On Friday 06 Feb 2004 13:07 pm, Robert Everland III wrote:
 how do I do this without making the url that way. I have tried headers,

You can chage registery keys to get back the old (broken) ability to use 
[EMAIL PROTECTED] in URLs.
Ask the the MS web site which ones, I've no idea.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX install errors - says port 51010 is not open

2004-02-06 Thread Thomas Chiverton
On Friday 06 Feb 2004 14:02 pm, Critter wrote:
any suggestions?

netstat -alpn|grep 51010 to see what's actualy there (it may be the CF you 
just installed :-) ) ?

But I bet you're on windows. Firewall on ? Services running ?

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:MS Update broke security

2004-02-06 Thread Robert Everland III
Yeah I saw that, doesn't really help me though, I need something that will allow me to get internet explorer to cache the username and password. I don't want to use basic authentication, I'm using an application that everyone wants to have secure, but doens't have built in security. So the only way to secure it was through basic authentication.

Bob

On Friday 06 Feb 2004 13:07 pm, Robert Everland III wrote:
 how do I do this without making the url that way. I have tried headers,

You can chage registery keys to get back the old (broken) ability to use 
[EMAIL PROTECTED] in URLs.
Ask the the MS web site which ones, I've no idea.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MS Update broke security

2004-02-06 Thread Jochem van Dieten
Robert Everland III wrote:

 Yeah I saw that, doesn't really help me though, I need something that will allow me to get internet explorer to cache the username and password. I don't want to use basic authentication, I'm using an application that everyone wants to have secure, but doens't have built in security. So the only way to secure it was through basic authentication.

What exactly are the requirements?

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MS Update broke security

2004-02-06 Thread Thomas Chiverton
On Friday 06 Feb 2004 13:38 pm, Robert Everland III wrote:
 Yeah I saw that, doesn't really help me though, I need something that will
 allow me to get internet explorer to cache the username and password. I

IE has an option to remeber paswords - use that ?

Unfortunetly nither is anything you can enable from the web server.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:MS Update broke security

2004-02-06 Thread Robert Everland III
Well for the application they don't have requirements on making sequirty work, it doesn't even really support it. The whole application is based on NT permissions, so when you use everyone it just works normal, so if we wanted security I had to make the permissions based on our NT users and groups and then made a popup for basic authentication so that users would be able to log on. Recently we moved that website to a different url in preperation for a new website launch that no longer uses NT users and groups and goes off of a datbase for authentication. The problem with this now is that a user will be prompted to use our documentation application that still has to use basic authentication. To get by this I was putting the username and password in the url string and then everything just worked. Now my requirements are to find someway, anyway to get Internet Explorer to cache those passwords. I don't care if I encode the username and password in clear text inside a webpage, just anyway that I can get the browser to cache it so a user can't see it. hope that explains it for you. The product by the way is Ehelp which was recently aquired by Macromedia.

Bob

 Robert Everland III wrote:
 
  Yeah I saw that, doesn't really help me though, I need something 
 that will allow me to get internet explorer to cache the username and 
 password. I don't want to use basic authentication, I'm using an 
 application that everyone wants to have secure, but doens't have built 
 in security. So the only way to secure it was through basic 
 authentication.
 
 What exactly are the requirements?
 
 Jochem
 
 
 -- 
 I don't get it
 immigrants don't work
 and steal our jobs

 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:MS Update broke security

2004-02-06 Thread Robert Everland III
that's just it I can't use anythign that requires user intervention. By caching passwords I mean being able to pass the username and password to the browser some way to let it know that Im using basic authentication. Once I do that the browser automatically caches the username and password until you end the browser session. So if I can get something whethere it's _javascript_, java, html, or something else to be able to get the browser to know that there is a username and password for that site it would fix my issue.

Bob

On Friday 06 Feb 2004 13:38 pm, Robert Everland III wrote:
 Yeah I saw that, doesn't really help me though, I need something that will
 allow me to get internet explorer to cache the username and password. I

IE has an option to remeber paswords - use that ?

Unfortunetly nither is anything you can enable from the web server.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MS Update broke security

2004-02-06 Thread Jochem van Dieten
Robert Everland III wrote:

 Well for the application they don't have requirements on making sequirty work, it doesn't even really support it. The whole application is based on NT permissions, so when you use everyone it just works normal, so if we wanted security I had to make the permissions based on our NT users and groups and then made a popup for basic authentication so that users would be able to log on. Recently we moved that website to a different url in preperation for a new website launch that no longer uses NT users and groups and goes off of a datbase for authentication. The problem with this now is that a user will be prompted to use our documentation application that still has to use basic authentication. To get by this I was putting the username and password in the url string and then everything just worked. Now my requirements are to find someway, anyway to get Internet Explorer to cache those passwords. I don't care if I encode the username and password in clear text inside a webpage,
 ju

Please fix your mail application (sending lines longer as 1000 
characters is forbidden, more then 80 only if you have a very 
good reason) and try again so we can all see the rest of the message.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MySQL and CF

2004-02-06 Thread Gabriel Robichaud
I use mySQL all the time.You cant beat the cost for the amount of
performance/robstness you get.



From: Cutter (CF-Talk) [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 9:56 AM
To: CF-Talk
Subject: SOT: MySQL and CF

Let me preface this by saying that I don't fault anyone for their 
opinions. They are their opinions and as such deserve respect as such. 
When speaking of the below scenario I can see (especially considering 
the slow pace of mySQL dev in the past [which is no longer the case]) 
why someone may have thought along these lines.

Recently I was looking at evaluating a CF RAD tool under development (no

details yet, but I'll let you know if and when I'm able). The tool 
looked like it would do all the things I wanted, yet I came to find out 
it didn't support mySQL.

When I asked about this I was told that support had not been included 
because a) mySQL didn't support foreign keys, and b) because of this 
lack of functionality (and others) it wasn't a serious database
player.

I will post part of my response to this at the end of this message, but 
my question for the community is this, how many of us here use mySQL? Or

have used it in a site they've developed for a client? How many passed 
up using mySQL because of similar perceptions as those state above?

I'm not trying to start a debate or a flame war here, I'm just trying to

gage the perceptions out there in my fellow development community. I 
know that there are quite a few people here that develop third party 
apps for CF developers and I think it would be beneficial (for us all) 
to see what the percentages might me on this.

Here is a snippit of my response:

MySQL supports foreign keys when the table is of the InnoDB type (MySQL

supports several different engines). Support for this has been around 
since at least 4.0, though I think it may even go back as far as 3.23.

The Alpha build of 5.0 was released this last month. E-week reported in 
testing that it was incredibly stable and that the new addition of 
stored procedure support was a major plus. As I understand it views are 
to be supported possibly as early as 5.1.

Cutter

P.S. Anyone who may be looking for some good beginner information on 
MySQL should check out the excellent book MySQL Tutorial by Luke 
Welling and Laura Thomson. Though it only covers 4.x, it is very easy to

read and understand and provides short targeted tutorials for getting 
yourself up and going. I've been working with MySQL for about 3 years 
now and I've come to find I've only been scratching the surface of what 
it's capable of. 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Serial Number

2004-02-06 Thread Ben Doom
You mean it must contain 3 each of letters and numbers?I think that, 
while it is possible to do this with a really ugly kluge of a regex, 
you'd be better off looping over the string using left(), mid(), and 
right().

Unless you mean that it must be 3 letters, then three numbers, in which 
case it's easy.

I'm sorry, you're just going to have to clarify again.Can you list 
examples, too?

--Ben Doom

[EMAIL PROTECTED] wrote:
 This worked, but, the first 3 must contain letter(s) AND number(s), not
 letter(s) OR number(s). How would I do that?Thanks!
 
 refind(^[a-zA-Z0-9]{3}.*[0-9]{7}$, str)

 On Thu, 5 Feb 2004 12:08:26 -0800 (PST), in cf-talk you wrote:

How would I check to see if the first three digits of a number are
alpha-numeric and the last 7 are numbers?

Thanks!





 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MS Update broke security

2004-02-06 Thread Thomas Chiverton
On Friday 06 Feb 2004 13:59 pm, Robert Everland III wrote:
 that's just it I can't use anythign that requires user intervention. 

Then you can't do security.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Cold Fusion administrator loading blank page

2004-02-06 Thread Michael Hodgdon
Hey CF Guru's.I was hoping to get some help on this.I have a ColdFusion server that I am building to mirror an existing development server.I started the server and started testing this morning when I realized that the java class path was incorrect, it was not serving up cfx tags correctly.After updating the java class path in coldfusion administrator, I had to restart the server.The server restarted fine, at least it claims to have started fine.The problem is that my ColdFusion server loads up blank white pages.I can't get to the administrator, nor do I receive any error message.

Any ideas?

MSH
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: SOT: MySQL and CF

2004-02-06 Thread Yves Arsenault
I also use MySQL

With the projects that I'm involved with, I don't necessarily need every 
option in a DB server, but with MySQL, I will never complain on 
performance.

And of course, I don't use all of MySQL's current functionality..

My 2 cents.

Yves A

On Fri, 06 Feb 2004 09:56:06 -0500, Cutter (CF-Talk) 
[EMAIL PROTECTED] wrote:

 Let me preface this by saying that I don't fault anyone for their
 opinions. They are their opinions and as such deserve respect as such.
 When speaking of the below scenario I can see (especially considering
 the slow pace of mySQL dev in the past [which is no longer the case])
 why someone may have thought along these lines.

 Recently I was looking at evaluating a CF RAD tool under development (no
 details yet, but I'll let you know if and when I'm able). The tool
 looked like it would do all the things I wanted, yet I came to find out
 it didn't support mySQL.

 When I asked about this I was told that support had not been included
 because a) mySQL didn't support foreign keys, and b) because of this
 lack of functionality (and others) it wasn't a serious database player.

 I will post part of my response to this at the end of this message, but
 my question for the community is this, how many of us here use mySQL? Or
 have used it in a site they've developed for a client? How many passed
 up using mySQL because of similar perceptions as those state above?

 I'm not trying to start a debate or a flame war here, I'm just trying to
 gage the perceptions out there in my fellow development community. I
 know that there are quite a few people here that develop third party
 apps for CF developers and I think it would be beneficial (for us all)
 to see what the percentages might me on this.

 Here is a snippit of my response:

 MySQL supports foreign keys when the table is of the InnoDB type (MySQL
 supports several different engines). Support for this has been around
 since at least 4.0, though I think it may even go back as far as 3.23.

 The Alpha build of 5.0 was released this last month. E-week reported in
 testing that it was incredibly stable and that the new addition of
 stored procedure support was a major plus. As I understand it views are
 to be supported possibly as early as 5.1.

 Cutter

 P.S. Anyone who may be looking for some good beginner information on
 MySQL should check out the excellent book MySQL Tutorial by Luke
 Welling and Laura Thomson. Though it only covers 4.x, it is very easy to
 read and understand and provides short targeted tutorials for getting
 yourself up and going. I've been working with MySQL for about 3 years
 now and I've come to find I've only been scratching the surface of what
 it's capable of.


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MySQL and CF

2004-02-06 Thread C. Hatton Humphrey
 I will post part of my response to this at the end of this 
 message, but my question for the community is this, how many 
 of us here use mySQL? Or have used it in a site they've 
 developed for a client? How many passed up using mySQL 
 because of similar perceptions as those state above?

While I will agree that MySQL is still growing in compliance and
functionality, it is a good solution for an inexpensive database system for
those who have to choose between it and MS Access.I have a number of sites
that run off MySQL, enough that I have it running locally for development
purposes and am actually working on a set of UDF's to compensate for the SQL
Syntax difference between MSSQL Server and MySQL.

To say that it, wasn't a serious database player, is a narrow-minded
statement.

Regards!
Hatton

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.572 / Virus Database: 362 - Release Date: 1/27/2004
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MS Update broke security

2004-02-06 Thread Schuster, Steven
Roflmao

Ok that was funny...

Do the users have set IP addresses, you could use the CGI variables to maybe
do it that way. It would suck and be tied to a PC...nah that wouldn't
work



-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 10:08 AM
To: CF-Talk
Subject: Re: MS Update broke security

On Friday 06 Feb 2004 13:59 pm, Robert Everland III wrote:
 that's just it I can't use anythign that requires user intervention. 

Then you can't do security.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: XML storage

2004-02-06 Thread Matt Liotta
That's just plain wrong - certainly in Oracle 9i, and probably other 
 heavy
weight RDMS, there is a native XMLType column, and you can do XPath 
 querys
stright to it with SQL.

Both SQL Server and Oracle allow you to use proprietary syntax to 
access data contained in XML documents, but it is not straight SQL as 
defined by ISO. Remember, ISO defines the SQL standard and currently 
SQL does not support XML.

Which makes that wrong too :-)
However in your other reply you go on to talk about databases with a 
 native
XMLType, so I'm sure you must have been aware of that.

All relational databases process data using resultsets. It doesn't 
matter what syntactical sugar they add or how things come out at end of 
a query being executed; all the data used to produce the result was 
processed as resultsets. That means that the XML too has to be in the 
form of a resultset in order for a relational database to work with it. 
There is simply no other way as relational databases don't have 
hierarchical query engines.

Now you can snipe the article all you want, but it was written for IT 
managers and as such isn't perfect technically. If you really care 
about these issues then I should you read some of the research papers 
coming out of Jim Gray's team at Microsoft. Jim Gray was one of the top 
database researchers in the world before joining Microsoft and his team 
seems to be doing the most innovation in the relational/XML field 
currently. You might also be interested in the following. However, it 
is patented and as such doesn't seem likely to show up in databases 
anytime soon.

http://portal.acm.org/citation.cfm?id=640996dl=ACMcoll=portal

I'm also of the view that if you are starting to have to worry about 
 one extra
disk (or more likly memory cache) read, you need to spend some more 
 money on
your database :-)

That is flawed logic. Spatial problems in databases can't be overcome 
with adding disks. Certainly adding disks can help, but there really is 
a finite limit on how many disks you can add. As such scalability will 
continue to be a problem as the database grows and you can't add more 
disks.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MS Update broke security

2004-02-06 Thread Josh Remus
Honestly, none of this has sounded secure at all, actually.
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 10:08 AM
To: CF-Talk
Subject: Re: MS Update broke security

On Friday 06 Feb 2004 13:59 pm, Robert Everland III wrote:
 that's just it I can't use anythign that requires user intervention.

Then you can't do security.

--
Tom Chiverton
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MS Update broke security

2004-02-06 Thread Schuster, Steven
For instance:

Putting the username and password in the URL. :-)

Steve



-Original Message-
From: Josh Remus [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 10:22 AM
To: CF-Talk
Subject: RE: MS Update broke security

Honestly, none of this has sounded secure at all, actually.
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 10:08 AM
To: CF-Talk
Subject: Re: MS Update broke security

On Friday 06 Feb 2004 13:59 pm, Robert Everland III wrote:
 that's just it I can't use anythign that requires user intervention.

Then you can't do security.

--
Tom Chiverton
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Please help - Windows XP Virtual Drives.. I need help

2004-02-06 Thread Jon Block, College Publisher Developer
This is basically a repost but I really need a solution and there have got
to be other developers dealing with this problem... here's the problem - It
seems Windows XP (probably Windows 2003 Server too) does not see my virtual
drives. I'm having the same problem with Apache. By virtual drives, I mean
network mapped drives or local mappings I create with subst. Take a look at
this source code where I try to create a Y: drive and then look at the
result I get I'm totally stuck and I need help!!! The problem seems to
be that services in Windows XP can't see the damn virtual drives. In my code
sample below, it looks like CF is spawning a DOS prompt that runs as the
logged in user rather than the service. I've tried setting the permissions
on both the virtual drive and the physical source directory to be open to
everybody. I've also tried setting the Coldfusion Application Server user
role to run as the local account and the administrator of the machine. I've
also tried toggling the interact with desktop option. Nothing seems to
work.

PLEASE HELP! Thank you!!!
--
cfexecute returns cfexecute name=C:\WINDOWS\SYSTEM32\subst.exe
arguments=Y: C:\virtualdrives\ydrive timeout=6/cfexecutebr
cfoutput
	Here are the drives that I can see...br
	CFLOOP index=i
list=a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z
		directoryExists(#i#:\) = #directoryExists(#i#:\)#br
	/CFLOOP
/cfoutput
--
cfexecute returns Drive already SUBSTed 
Here are the drives that I can see...
directoryExists(a:\) = NO
directoryExists(b:\) = NO
directoryExists(c:\) = YES
directoryExists(d:\) = NO
directoryExists(e:\) = NO
directoryExists(f:\) = NO
directoryExists(g:\) = NO
directoryExists(h:\) = NO
directoryExists(i:\) = NO
directoryExists(j:\) = NO
directoryExists(k:\) = NO
directoryExists(l:\) = NO
directoryExists(m:\) = NO
directoryExists(n:\) = NO
directoryExists(o:\) = NO
directoryExists(p:\) = NO
directoryExists(q:\) = NO
directoryExists(r:\) = NO
directoryExists(s:\) = NO
directoryExists(t:\) = NO
directoryExists(u:\) = NO
directoryExists(v:\) = NO
directoryExists(w:\) = NO
directoryExists(x:\) = NO
directoryExists(y:\) = NO
directoryExists(z:\) = NO
directoryExists(z:/) = NO
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




About CF calendar..

2004-02-06 Thread Hassan Arteaga Rodriguez
Hi there:

 
I'm looking for a nice calendar(free also) for my site...Juts to click and
get a selected date.

 
Regards

 
__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:Fusetalk Q

2004-02-06 Thread Michael Dinowitz
Well, looks like I'll have to write a full agent.
1. get thread list. 
2. If thread is in DB and the record count is higher than the Db, get that thread content
3. parse full thread to get new messages from it
Fun. :)

I just confered with another team mm member that has develoepd with fusetalk
and reviewed the source code (it's available for additional price).He says
their only message view is full thread.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




WDDX Error!

2004-02-06 Thread Ruben Ghosal
I have a Shopping cart custom tag where I am deserializing the cart and returning it to the calling page if it is found. While deserializing I am getting the following error. 

WDDX packet parse error at line 1, column -1. Whitespace required before attributes. 

Here is the code sample

 
cfstoredproc datasource=#attributes.datasource# procedure=spShoppingCartSelect
cfprocparam cfsqltype=CF_SQL_VARCHAR value=#attributes.client# dbvarname=@cfid null=No type=In	
cfprocresult name=qGetCart
/cfstoredproc	

cfif qGetCart.recordcount
cfwddx action="" input=#qGetCart.cart# output=stCart
/cfif

I am getting error on the above line..it was CF 5.0 before now it's MX 6.1 can anybody please help?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX install errors - says port 51010 is not open

2004-02-06 Thread Critter
oi Thomas!!

weirdiopenedall ports installed it fine this time, then allowed only my needed ports
and it's working fine now.

-- 

=-=-=-=-=-=-=-=-=-=-=-=-=-[ Help me fight to keep my son in the US ]-=
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://keepmysoninthe.us ]-=

Friday, February 6, 2004, 9:31:42 AM, you wrote:

TC On Friday 06 Feb 2004 14:02 pm, Critter wrote:
any suggestions?

TC netstat -alpn|grep 51010 to see what's actualy there (it may be the CF you 
TC just installed :-) ) ?

TC But I bet you're on windows. Firewall on ? Services running ?

---
[This E-mail scanned for viruses by Declude Virus]
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Please help - Windows XP Virtual Drives.. I need help

2004-02-06 Thread Burns, John
Just because it's created doesn't mean the account that CF is running
under has permissions to it.Not sure if it would return that it exists
or not based on your permissions. You could probably use the command
line syntax to max a specific drive as a specific user.

Net use Y: \\serve\share password /USER:domain\username

Or something like that.Someone else may be able to add more info.
I've never used the subst.exe command.

John

-Original Message-
From: Jon Block, College Publisher Developer
[mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 10:29 AM
To: CF-Talk
Subject: Please help - Windows XP  Virtual Drives.. I need help

This is basically a repost but I really need a solution and there have
got to be other developers dealing with this problem... here's the
problem - It seems Windows XP (probably Windows 2003 Server too) does
not see my virtual drives. I'm having the same problem with Apache. By
virtual drives, I mean network mapped drives or local mappings I create
with subst. Take a look at this source code where I try to create a Y:
drive and then look at the result I get I'm totally stuck and I need
help!!! The problem seems to be that services in Windows XP can't see
the damn virtual drives. In my code sample below, it looks like CF is
spawning a DOS prompt that runs as the logged in user rather than the
service. I've tried setting the permissions on both the virtual drive
and the physical source directory to be open to everybody. I've also
tried setting the Coldfusion Application Server user role to run as the
local account and the administrator of the machine. I've also tried
toggling the interact with desktop option. Nothing seems to work.

PLEASE HELP! Thank you!!!
--
cfexecute returns cfexecute name=C:\WINDOWS\SYSTEM32\subst.exe
arguments=Y: C:\virtualdrives\ydrive timeout=6/cfexecutebr
cfoutput
	Here are the drives that I can see...br
	CFLOOP index=i
list=a,b,c,d,e,f,g,h,i,j,k,l,m,n,o,p,q,r,s,t,u,v,w,x,y,z
		directoryExists(#i#:\) =
#directoryExists(#i#:\)#br
	/CFLOOP
/cfoutput
--
cfexecute returns Drive already SUBSTed 
Here are the drives that I can see...
directoryExists(a:\) = NO
directoryExists(b:\) = NO
directoryExists(c:\) = YES
directoryExists(d:\) = NO
directoryExists(e:\) = NO
directoryExists(f:\) = NO
directoryExists(g:\) = NO
directoryExists(h:\) = NO
directoryExists(i:\) = NO
directoryExists(j:\) = NO
directoryExists(k:\) = NO
directoryExists(l:\) = NO
directoryExists(m:\) = NO
directoryExists(n:\) = NO
directoryExists(o:\) = NO
directoryExists(p:\) = NO
directoryExists(q:\) = NO
directoryExists(r:\) = NO
directoryExists(s:\) = NO
directoryExists(t:\) = NO
directoryExists(u:\) = NO
directoryExists(v:\) = NO
directoryExists(w:\) = NO
directoryExists(x:\) = NO
directoryExists(y:\) = NO
directoryExists(z:\) = NO
directoryExists(z:/) = NO
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MySQL and CF

2004-02-06 Thread Doug White
IMHO any software publisher that does not support MySQL is not worthy of
purchase.This especially as MySQL has evolved into a major player in the
Database market.

In my case, I originally had a copy of (name omitted) for eStore cart and it had
built in support for everyone EXCEPT MySQL.I was forced to hack the
application to create MySQL support and once that was done it worked pretty
well, that is until several Open Source eStore apps became available for the
Linux/MySQl platform.

Now, with the later releases of MySQL, it is again considered a major database
player, and we have also include support on our Windows servers as well.

In my opinion, PostGres is the best of all the open source databases, as being
scalable, fast, and stable, but few CF developers target that platform, while
the MySQL product is being increasingly requested by clients.Not everyone needs
Oracle functionality, including many that are using that platform, and most of
the pundits are now saying that MySQL is becoming a real competitor.

All this said, while our services include supporting the database product of the
client's choice, SQL2K if still by far the most requested.

==
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
==
Aspire to Inspire before you Retire or Expire!

- Original Message - 
From: Cutter (CF-Talk)
To: CF-Talk
Sent: Friday, February 06, 2004 8:56 AM
Subject: SOT: MySQL and CF

Let me preface this by saying that I don't fault anyone for their
opinions. They are their opinions and as such deserve respect as such.
When speaking of the below scenario I can see (especially considering
the slow pace of mySQL dev in the past [which is no longer the case])
why someone may have thought along these lines.

Recently I was looking at evaluating a CF RAD tool under development (no
details yet, but I'll let you know if and when I'm able). The tool
looked like it would do all the things I wanted, yet I came to find out
it didn't support mySQL.

When I asked about this I was told that support had not been included
because a) mySQL didn't support foreign keys, and b) because of this
lack of functionality (and others) it wasn't a serious database player.

I will post part of my response to this at the end of this message, but
my question for the community is this, how many of us here use mySQL? Or
have used it in a site they've developed for a client? How many passed
up using mySQL because of similar perceptions as those state above?

I'm not trying to start a debate or a flame war here, I'm just trying to
gage the perceptions out there in my fellow development community. I
know that there are quite a few people here that develop third party
apps for CF developers and I think it would be beneficial (for us all)
to see what the percentages might me on this.

Here is a snippit of my response:

MySQL supports foreign keys when the table is of the InnoDB type (MySQL
supports several different engines). Support for this has been around
since at least 4.0, though I think it may even go back as far as 3.23.

The Alpha build of 5.0 was released this last month. E-week reported in
testing that it was incredibly stable and that the new addition of
stored procedure support was a major plus. As I understand it views are
to be supported possibly as early as 5.1.

Cutter

P.S. Anyone who may be looking for some good beginner information on
MySQL should check out the excellent book MySQL Tutorial by Luke
Welling and Laura Thomson. Though it only covers 4.x, it is very easy to
read and understand and provides short targeted tutorials for getting
yourself up and going. I've been working with MySQL for about 3 years
now and I've come to find I've only been scratching the surface of what
it's capable of.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:MS Update broke security

2004-02-06 Thread Robert Everland III
Sorry, I'm using the web interface. I'll see if I can fix it up
Well for the application they don't have requirements on making sequirty work, it doesn't even really support it. The whole application is based on NT permissions, so when you use everyone it just works normal, so if we wanted security I had to make the permissions based on our NT users and groups and then made a popup for basic authentication so that users would be able to log on. Recently we moved that website to a different url in preperation for a new website launch that no longer uses NT users and groups and goes off of a datbase for authentication. The problem with this now is that a user will be prompted to use our documentation application that still has to use basic authentication. To get by this I was putting the username and password in the url string and then everything just worked. Now my requirements are to find someway, anyway to get Internet Explorer to cache those passwords. I don't care if I encode the username and password in clear text inside a webpage, just anyway that I can get 
the browser to cache it so a user can't see it. hope that explains it for you. The product by the way is Ehelp which was recently aquired by Macromedia. 

Bob 

 Robert Everland III wrote:
 
  Well for the application they don't have requirements on making 
 sequirty work, it doesn't even really support it. The whole 
 application is based on NT permissions, so when you use everyone it 
 just works normal, so if we wanted security I had to make the 
 permissions based on our NT users and groups and then made a popup for 
 basic authentication so that users would be able to log on. Recently 
 we moved that website to a different url in preperation for a new 
 website launch that no longer uses NT users and groups and goes off of 
 a datbase for authentication. The problem with this now is that a user 
 will be prompted to use our documentation application that still has 
 to use basic authentication. To get by this I was putting the username 
 and password in the url string and then everything just worked. Now my 
 requirements are to find someway, anyway to get Internet Explorer to 
 cache those passwords. I don't care if I encode the username and 
 password in clear text inside a webpage,

 
 ju
 
 Please fix your mail application (sending lines longer as 1000 
 characters is forbidden, more then 80 only if you have a very 
 good reason) and try again so we can all see the rest of the message.
 
 Jochem
 
 -- 
 I don't get it
 immigrants don't work
 and steal our jobs

 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: WDDX Error!

2004-02-06 Thread Raymond Camden
Can you show us the packet? I seem to remember an issue with WDDX packets
when I was working on getting Spectra running on MX.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: XML storage

2004-02-06 Thread Jochem van Dieten
Matt Liotta wrote:
 
 Both SQL Server and Oracle allow you to use proprietary syntax to 
 access data contained in XML documents, but it is not straight SQL as 
 defined by ISO. Remember, ISO defines the SQL standard and currently 
 SQL does not support XML.

ISO/IEC 9075-14:2003 was released on December 15 (I just got it).

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Fusetalk Q

2004-02-06 Thread Samuel R. Neff
And don't forget...

4.Rewrite every time MM changes the style/html and breaks your
regexp/tokenizer.

:-)

I actually have a full mm webforum parser I wrote about a year ago to
display threads I'm participating in on my blog, but it doesn't work any
more since the html it triggered off changed.

Sam

---
Blog: http://www.rewindlife.com
Charts: http://www.blinex.com/products/charting
---

 -Original Message-
 From: Michael Dinowitz [mailto:[EMAIL PROTECTED] 
 Sent: Friday, February 06, 2004 9:32 AM
 To: CF-Talk
 Subject: Re:Fusetalk Q
 
 Well, looks like I'll have to write a full agent.
 1. get thread list. 
 2. If thread is in DB and the record count is higher than the 
 Db, get that thread content
 3. parse full thread to get new messages from it
 Fun. :)
 
 I just confered with another team mm member that has 
 develoepd with fusetalk
 and reviewed the source code (it's available for additional 
 price).He says
 their only message view is full thread.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: XML storage

2004-02-06 Thread Matt Liotta
ISO/IEC 9075-14:2003 was released on December 15 (I just got it).

I don't know what changed in the specification as I haven't looked. 
However, clearly that release was well after the article was written.

-Matt
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Linux ODBC Socket

2004-02-06 Thread Bryan Stevenson
Go get CoolMenus at DHTMLCentral.comfree...easycross-browser back to v. 4 of IE and Netscape

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

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Dave Carabetta 
To: CF-Talk 
Sent: Thursday, February 05, 2004 3:58 PM
Subject: Re: Linux  ODBC Socket

 Hi,
 My colleague and I are new to Linux and notice there is no ODBC Socket
 option in the datasources page, is this a feature of MX? If so, can I
 create ODBC datasources some other way in ColdFusion MX on Linux (RedHat).


I don't believe that ODBC works on *nix systems. In the examples that come
with MX, the Windows version comes with an Access DB with the sample data
(set up via ODBC), but the *nix versions come with a Pointbase database, I
think, which does not use ODBC.

Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:MS Update broke security

2004-02-06 Thread Roger Benningfield
Bob,

Okay, this is pure theory... I haven't actually tested it, so it might not work at all.

(1) Change your URLs from http://#username#:[EMAIL PROTECTED]/ to http://foo.com/auth/#ToBase64(username  :  password)#/

(2) Install ISAPI Rewrite

(3) Create a rewrite condition that looks for /auth/(.*)/

(4) If authorization info is found, rewrite the URL to omit the auth info, and then set the Authorization header to the base64 string in the original URL

Again, *in theory*, you'll end up being able to authenticate without user intervention.

--
Roger Benningfield
JournURL: http://journurl.com/
blog: http://admin.support.journurl.com/
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: SOT: MySQL and CF

2004-02-06 Thread Jochem van Dieten
Cutter (CF-Talk) wrote:

 Let me preface this by saying that I don't fault anyone for their 
 opinions. They are their opinions and as such deserve respect as such. 
 When speaking of the below scenario I can see (especially considering 
 the slow pace of mySQL dev in the past [which is no longer the case]) 
 why someone may have thought along these lines.

You mean that the 17 months that 4.0 spent in Beta is going to be 
substantially shorter for 5.0? I don't suppose that is an 
official claim of MySQL AB?

 I will post part of my response to this at the end of this message, but 
 my question for the community is this, how many of us here use mySQL?

Not if I can help it, but unfortunately I am sometimes forced to 
use it.

 How many passed 
 up using mySQL because of similar perceptions as those state above?

I make my decisions based on facts, not perceptions.

 MySQL supports foreign keys when the table is of the InnoDB type (MySQL 
 supports several different engines). Support for this has been around 
 since at least 4.0, though I think it may even go back as far as 3.23.

4.0.12 was the first stable release with what MySQL calls foreign 
keys.

 The Alpha build of 5.0 was released this last month. E-week reported in 
 testing that it was incredibly stable and that the new addition of 
 stored procedure support was a major plus.

Stored procedures are server wide instead of database wide, so 
they are unusable in a hosted environment with a shared database 
server.

 As I understand it views are to be supported possibly as early as 5.1.

5.0 alpha was released last month. We are about 28 months past 
the release of 4.0 alpha, and there isn't a 4.1 stable yet. Do 
your own math, but even if they make it in 5.1 I don't think I 
would call that 'early'.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX install errors - says port 51010 is not open

2004-02-06 Thread Josh
ya, we have run into the same thing several times...

there's a technote out there somewhere about this.

Josh

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Critter wrote:

 oi Thomas!!

 weirdiopenedall ports installed it fine this time, 
 then allowed only my needed ports
 and it's working fine now.

 -- 

 =-=-=-=-=-=-=-=-=-=-=-=-=-[ Help me fight to keep my son in the US ]-=
 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-[ http://keepmysoninthe.us ]-=

 Friday, February 6, 2004, 9:31:42 AM, you wrote:

 TC On Friday 06 Feb 2004 14:02 pm, Critter wrote:
 any suggestions?

 TC netstat -alpn|grep 51010 to see what's actualy there (it may be 
 the CF you
 TC just installed :-) ) ?

 TC But I bet you're on windows. Firewall on ? Services running ?

 ---
 [This E-mail scanned for viruses by Declude Virus]

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MySQL and CF

2004-02-06 Thread Bryan Stevenson
I agree...MySQL is not a real databasenot just because of the FK issue which is only fixed by using InnoDBit also doesn't have stored procs/triggers/rollback.I'd say rollback is just too scary to go withoutlet's face it...transactions fail and they need to be rolled back to avoid data corruption.Without this feature you just have to code the functionality into your application which means higher cost, more points of failure, tougher to maintain

my 2 cents

Cheers

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

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Cutter (CF-Talk) 
To: CF-Talk 
Sent: Friday, February 06, 2004 6:56 AM
Subject: SOT: MySQL and CF

Let me preface this by saying that I don't fault anyone for their 
opinions. They are their opinions and as such deserve respect as such. 
When speaking of the below scenario I can see (especially considering 
the slow pace of mySQL dev in the past [which is no longer the case]) 
why someone may have thought along these lines.

Recently I was looking at evaluating a CF RAD tool under development (no 
details yet, but I'll let you know if and when I'm able). The tool 
looked like it would do all the things I wanted, yet I came to find out 
it didn't support mySQL.

When I asked about this I was told that support had not been included 
because a) mySQL didn't support foreign keys, and b) because of this 
lack of functionality (and others) it wasn't a serious database player.

I will post part of my response to this at the end of this message, but 
my question for the community is this, how many of us here use mySQL? Or 
have used it in a site they've developed for a client? How many passed 
up using mySQL because of similar perceptions as those state above?

I'm not trying to start a debate or a flame war here, I'm just trying to 
gage the perceptions out there in my fellow development community. I 
know that there are quite a few people here that develop third party 
apps for CF developers and I think it would be beneficial (for us all) 
to see what the percentages might me on this.

Here is a snippit of my response:

MySQL supports foreign keys when the table is of the InnoDB type (MySQL 
supports several different engines). Support for this has been around 
since at least 4.0, though I think it may even go back as far as 3.23.

The Alpha build of 5.0 was released this last month. E-week reported in 
testing that it was incredibly stable and that the new addition of 
stored procedure support was a major plus. As I understand it views are 
to be supported possibly as early as 5.1.

Cutter

P.S. Anyone who may be looking for some good beginner information on 
MySQL should check out the excellent book MySQL Tutorial by Luke 
Welling and Laura Thomson. Though it only covers 4.x, it is very easy to 
read and understand and provides short targeted tutorials for getting 
yourself up and going. I've been working with MySQL for about 3 years 
now and I've come to find I've only been scratching the surface of what 
it's capable of.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: CFMX install errors - says port 51010 is not open

2004-02-06 Thread Jochem van Dieten
Critter wrote:
 
 weirdiopenedall ports installed it fine this time, then allowed only my needed ports
 and it's working fine now.

That is my experience too. The installation instrutions list a 
number of ports, but clearly not all.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: About CF calendar..

2004-02-06 Thread Josh
We have one free for download, it suppot date and time(optional) and 
also support US and EURO dates:

http://exciteworks.com/popDateTime_readme.cfm

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Hassan Arteaga Rodriguez wrote:

 Hi there:


 I'm looking for a nice calendar(free also) for my site...Juts to click and
 get a selected date.


 Regards


 __
 MSc. Hassan Arteaga Rodrguez
 Microsoft Certified System Engineer.
 DIGI- Grupo de Desarrollo
 COPEXTEL, S.A.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: jRockit

2004-02-06 Thread Dave Carabetta
IIRC, CFMX comes with and uses the IBM JRE, not Sun's.


Incorrect. MX 6.1 comes with the Sun 1.4.2 JRE.

http://www.macromedia.com/support/coldfusion/releasenotes/mx/mx61_release_notes.html

Under the Updates to Integrated Products section, you'll note the JRE 
bundled with MX.

Regards,
Dave.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:Another CFLogin issue - Roles

2004-02-06 Thread Michael Dinowitz
I'm trying to trace the error and one main thing I find is that if there's 2 CFLOGIN tags on the page, the second one always assumes that your not logged in. 

-- begin code --
cfapplication name=test sessionmanagement=Yes loginstorage=Session
CFLOGIN applicationtoken=test/CFLOGIN

CFLOGIN applicationtoken=test
	CFLOGINUSER name=username2 password=password2 roles=admin
	not logged in
	CFABORT
/cflogin
logged in
-- end code--
Now my issue was that I was running a CFLOGINUSER within a CFC which was called from within a CFLOGIN block (outside of the CFC) and the CFLOGINUSER was within a CFLOGIN within the CFC. The two CFLOGIN blocks probably interacted. This means that the external CFLOGIN affects the internal CFLOGINUSER. I'll have more info soon.
(the code above is not production, it only showcases an issue).
Also, the IsUserInRole() function will not take more than one role where the docs says that it can take a list.

Eh? Code inside cflogin blocks will NOT run if you are logged in. Do you
have a firm example that dispproves this? If so please share as it would be
a bug.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MySQL and CF

2004-02-06 Thread Josh
I agree MySQL is a must.It is fast and easy to use.I also use and 
recommend PostgreSQL when a client needs stored procs udfs etc.

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Doug White wrote:

 IMHO any software publisher that does not support MySQL is not worthy of
 purchase.This especially as MySQL has evolved into a major player in the
 Database market.

 In my case, I originally had a copy of (name omitted) for eStore cart 
 and it had
 built in support for everyone EXCEPT MySQL.I was forced to hack the
 application to create MySQL support and once that was done it worked 
 pretty
 well, that is until several Open Source eStore apps became available 
 for the
 Linux/MySQl platform.

 Now, with the later releases of MySQL, it is again considered a major 
 database
 player, and we have also include support on our Windows servers as well.

 In my opinion, PostGres is the best of all the open source databases, 
 as being
 scalable, fast, and stable, but few CF developers target that 
 platform, while
 the MySQL product is being increasingly requested by clients.Not 
 everyone needs
 Oracle functionality, including many that are using that platform, and 
 most of
 the pundits are now saying that MySQL is becoming a real competitor.

 All this said, while our services include supporting the database 
 product of the
 client's choice, SQL2K if still by far the most requested.

 ==
 Stop spam on your domain, Anti-spam solutions
 http://www.clickdoug.com/mailfilter.cfm
 For hosting solutions http://www.clickdoug.com
 ==
 Aspire to Inspire before you Retire or Expire!

- Original Message -
From: Cutter (CF-Talk)
To: CF-Talk
Sent: Friday, February 06, 2004 8:56 AM
Subject: SOT: MySQL and CF

Let me preface this by saying that I don't fault anyone for their
opinions. They are their opinions and as such deserve respect as such.
When speaking of the below scenario I can see (especially considering
the slow pace of mySQL dev in the past [which is no longer the case])
why someone may have thought along these lines.

Recently I was looking at evaluating a CF RAD tool under development (no
details yet, but I'll let you know if and when I'm able). The tool
looked like it would do all the things I wanted, yet I came to find out
it didn't support mySQL.

When I asked about this I was told that support had not been included
because a) mySQL didn't support foreign keys, and b) because of this
lack of functionality (and others) it wasn't a serious database 
 player.

I will post part of my response to this at the end of this message, but
my question for the community is this, how many of us here use mySQL? Or
have used it in a site they've developed for a client? How many passed
up using mySQL because of similar perceptions as those state above?

I'm not trying to start a debate or a flame war here, I'm just trying to
gage the perceptions out there in my fellow development community. I
know that there are quite a few people here that develop third party
apps for CF developers and I think it would be beneficial (for us all)
to see what the percentages might me on this.

Here is a snippit of my response:

MySQL supports foreign keys when the table is of the InnoDB type (MySQL
supports several different engines). Support for this has been around
since at least 4.0, though I think it may even go back as far as 3.23.

The Alpha build of 5.0 was released this last month. E-week reported in
testing that it was incredibly stable and that the new addition of
stored procedure support was a major plus. As I understand it views are
to be supported possibly as early as 5.1.

Cutter

P.S. Anyone who may be looking for some good beginner information on
MySQL should check out the excellent book MySQL Tutorial by Luke
Welling and Laura Thomson. Though it only covers 4.x, it is very easy to
read and understand and provides short targeted tutorials for getting
yourself up and going. I've been working with MySQL for about 3 years
now and I've come to find I've only been scratching the surface of what
it's capable of.

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: About CF calendar..

2004-02-06 Thread Hassan Arteaga Rodriguez
Thanks Josh

 
__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

_

From: Josh [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 10:53 AM
To: CF-Talk
Subject: Re: About CF calendar..

We have one free for download, it suppot date and time(optional) and 
also support US and EURO dates:

http://exciteworks.com/popDateTime_readme.cfm

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Hassan Arteaga Rodriguez wrote:

 Hi there:


 I'm looking for a nice calendar(free also) for my site...Juts to click and
 get a selected date.


 Regards


 __
 MSc. Hassan Arteaga Rodrguez
 Microsoft Certified System Engineer.
 DIGI- Grupo de Desarrollo
 COPEXTEL, S.A.
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: jRockit

2004-02-06 Thread Christian Cantrell
On Feb 6, 2004, at 8:58 AM, Kwang Suh wrote:

 CFMX comes with and uses the IBM JRE, not Sun's.

JRun and ColdFusion use Sun's JRE.

IBM's can be found here:

http://www-106.ibm.com/developerworks/java/jdk/index.html

Christian
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFLogin issue - Roles

2004-02-06 Thread Raymond Camden
 I'm trying to trace the error and one main thing I find is 
 that if there's 2 CFLOGIN tags on the page, the second one 
 always assumes that your not logged in. 

You mean 2 blocks of cflogin tags? I'd consider that a bug, but also
non-standard usage. There should only be one cflogin block per request
(imho). 

Just remove the second cflogin block.

In my opinion, CF should simply throw an error if two or more blocks are
encountered.

 -- begin code --
 cfapplication name=test sessionmanagement=Yes 
 loginstorage=Session CFLOGIN applicationtoken=test/CFLOGIN
 
 CFLOGIN applicationtoken=test
 	CFLOGINUSER name=username2 password=password2 
 roles=admin
 	not logged in
 	CFABORT
 /cflogin
 logged in
 -- end code--
 Now my issue was that I was running a CFLOGINUSER within a 
 CFC which was called from within a CFLOGIN block (outside of 
 the CFC) and the CFLOGINUSER was within a CFLOGIN within the 
 CFC. The two CFLOGIN blocks probably interacted. This means 
 that the external CFLOGIN affects the internal CFLOGINUSER. 
 I'll have more info soon.
 (the code above is not production, it only showcases an issue).
 Also, the IsUserInRole() function will not take more than one 
 role where the docs says that it can take a list.

Yes, it will take more then one role. This works fine in all my tests.
However, do not forget thatit will do an AND check. So if you pass A,B it
will only return true if the user is in both.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MySQL and CF

2004-02-06 Thread Jochem van Dieten
Bryan Stevenson wrote:

 I agree...MySQL is not a real databasenot just because of the FK issue which is only fixed by using InnoDBit also doesn't have stored procs/triggers/rollback.

Transactions are supported, and rollback works.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MySQL and CF

2004-02-06 Thread Vince Bonfanti
Not to comment at all on its technical merits, anyone using MySQL should be
familiar with their licensing terms. Specifically, MySQL is *not* free for
commercial development. If you use MySQL for a commercial product and don't
purchase a commercial license, then you run the risk of inadvertently
releasing your source code for free.

MySQL is released under GPL, unlike Linux, for example, which is released
under LGPL. Under the LGPL, if you write an application that runs on Linux
you can redistribute that application without releasing the source code.
Under the GPL, however, if you release an application that runs on MySQL,
then you must release the source code of your application.

Here are the relevant quotes from the MySQL licensing page on their web
site:

 http://www.mysql.com/products/licensing.html

Regarding their Open Source license, which is the GPL:

 The Open Source License allows you to use the software at no charge
under the condition that if you use MySQL in an application you
redistribute, the complete source code for your application must be
available and freely redistributable under reasonable conditions.

If you don't want to release the source code of your application, you must
purchase a commercial license:

 The Commercial License, which allows you to provide commercial software
licenses to your customers or distribute MySQL-based applications within
your organization. This is for organizations that do not want to release the
source code for their applications as open source / free software; in other
words they do not want to comply with the GNU General Public License (GPL).

Note that it's not just the MySQL database that's covered under these
license terms--they also apply to the MySQL JDBC and ODBC drivers. (This is
the reason BlueDragon no longer ships the MySQL JDBC driver).

So if you use MySQL--be careful. If you don't purchase a commercial license,
anyone can demand that you give them your source code under the terms of the
GPL license.

Vince Bonfanti
New Atlanta Communications, LLC
http://www.newatlanta.com
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: About CF calendar..

2004-02-06 Thread Josh
No problem Hassan!Enjoy!

Let me know if you have any questions about the tag.

Where are you located?in South America it looks like...I lived down 
there for several years.

Josh

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Hassan Arteaga Rodriguez wrote:

 Thanks Josh


 __
 MSc. Hassan Arteaga Rodrguez
 Microsoft Certified System Engineer.
 DIGI- Grupo de Desarrollo
 COPEXTEL, S.A.

_

 From: Josh [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 06, 2004 10:53 AM
 To: CF-Talk
 Subject: Re: About CF calendar..

 We have one free for download, it suppot date and time(optional) and
 also support US and EURO dates:

 http://exciteworks.com/popDateTime_readme.cfm

 ---
 Exciteworks -- expert hosting for less!
 http://exciteworks.com
 specializing in reseller accounts

 Hassan Arteaga Rodriguez wrote:

  Hi there:
 
 
  I'm looking for a nice calendar(free also) for my site...Juts to 
 click and
  get a selected date.
 
 
  Regards
 
 
  __
  MSc. Hassan Arteaga Rodrguez
  Microsoft Certified System Engineer.
  DIGI- Grupo de Desarrollo
  COPEXTEL, S.A.
 
_

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: jRockit

2004-02-06 Thread ksuh
Hmm, did 6.0 use IBM's?I distinctly remember reading something about that.

Oh well, maybe I'm just on crack :)

- Original Message -
From: Christian Cantrell [EMAIL PROTECTED]
Date: Friday, February 6, 2004 8:59 am
Subject: Re: jRockit

 On Feb 6, 2004, at 8:58 AM, Kwang Suh wrote:
 
  CFMX comes with and uses the IBM JRE, not Sun's.
 
 JRun and ColdFusion use Sun's JRE.
 
 IBM's can be found here:
 
 http://www-106.ibm.com/developerworks/java/jdk/index.html
 
 Christian
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MySQL and CF

2004-02-06 Thread Bryan Stevenson
Thanks Jochem...Well that's news to meit didn't appear to last time I checked.Oh wellit's still missing too much IMHO...but admittedly most of my clients require apps which need the whole ball of waxso It's still MS SQL Server or Oracle.

I must say though our current project is running CFMX on RedHat with a Windows 2000 DB Server and this setup is quite nice.

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

-
Macromedia Associate Partner
www.macromedia.com
-
Vancouver Island ColdFusion Users Group
Founder  Director
www.cfug-vancouverisland.com
- Original Message - 
From: Jochem van Dieten 
To: CF-Talk 
Sent: Friday, February 06, 2004 8:06 AM
Subject: Re: MySQL and CF

Bryan Stevenson wrote:

 I agree...MySQL is not a real databasenot just because of the FK issue which is only fixed by using InnoDBit also doesn't have stored procs/triggers/rollback.

Transactions are supported, and rollback works.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
 - Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: Another CFLogin issue - Roles

2004-02-06 Thread Michael Dinowitz
  I'm trying to trace the error and one main thing I find is
  that if there's 2 CFLOGIN tags on the page, the second one
  always assumes that your not logged in.

 You mean 2 blocks of cflogin tags? I'd consider that a bug, but also
 non-standard usage. There should only be one cflogin block per request
 (imho).
It is non-standard, but something that popped up as I'm testing this.
Basically, using the CFLOGINUSER inside the CFC causes some strange results
and that double CFLOGIN issue may be one of them. I'm still looking.
The bottom line may be that its better to leave the CFLOGINUSER outside the
CFC.

  Also, the IsUserInRole() function will not take more than one
  role where the docs says that it can take a list.

 Yes, it will take more then one role. This works fine in all my tests.
 However, do not forget thatit will do an AND check. So if you pass A,B it
 will only return true if the user is in both.
Ah, the docs imply an OR case. I've tested it and it is the AND case as you
say. One of these days I'm going to rewrite those docs in a major way. :(
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFLogin issue - Roles

2004-02-06 Thread Simon Horwith
Ray,
What about a situation where you have certain display elements that only
show to logged-in users?Why not wrap cflogin around those elements?I
know you're immediate answer is use conditional logic to see if
getAuthUser()returns an empty string, but I don't see why one is better
than the other.Using getAuthUser() means using conditional logic (yes, I
know that cflogin is an explicit conditional check) which is more sore on
the eyes and requires a developer to expend more thought in order to figure
out what the conditional logic is.cflogin is intended to be wrapped
around code to run when people aren't logged in.GetAuthUser() is supposed
to return the name of the logged-in user.Right now, getAuthUser() happens
to return an empty string when you're not logged in, but that functionality
isn't set in stone.If that functionality is set in stone, I still think
cflogin leaves less doubt about the intention of the code.Thoughts?

~Simon
Simon Horwith
CTO, Etrilogy Ltd.
Member of Team Macromedia
Macromedia Certified Instructor
Certified Advanced ColdFusion MX Developer
Certified Flash MX Developer
CFDJList - List Administrator
http://www.how2cf.com/

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 06 February 2004 16:04
To: CF-Talk
Subject: RE: Another CFLogin issue - Roles

 I'm trying to trace the error and one main thing I find is
 that if there's 2 CFLOGIN tags on the page, the second one
 always assumes that your not logged in.

You mean 2 blocks of cflogin tags? I'd consider that a bug, but also
non-standard usage. There should only be one cflogin block per request
(imho).

Just remove the second cflogin block.

In my opinion, CF should simply throw an error if two or more blocks are
encountered.

 -- begin code --
 cfapplication name=test sessionmanagement=Yes
 loginstorage=Session CFLOGIN applicationtoken=test/CFLOGIN

 CFLOGIN applicationtoken=test
 CFLOGINUSER name=username2 password=password2
 roles=admin
 not logged in
 CFABORT
 /cflogin
 logged in
 -- end code--
 Now my issue was that I was running a CFLOGINUSER within a
 CFC which was called from within a CFLOGIN block (outside of
 the CFC) and the CFLOGINUSER was within a CFLOGIN within the
 CFC. The two CFLOGIN blocks probably interacted. This means
 that the external CFLOGIN affects the internal CFLOGINUSER.
 I'll have more info soon.
 (the code above is not production, it only showcases an issue).
 Also, the IsUserInRole() function will not take more than one
 role where the docs says that it can take a list.

Yes, it will take more then one role. This works fine in all my tests.
However, do not forget thatit will do an AND check. So if you pass A,B it
will only return true if the user is in both.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: About CF calendar..

2004-02-06 Thread Hassan Arteaga Rodriguez
Thanks again..
I'm living in Cuba
Regards
__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

_

From: Josh [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 11:07 AM
To: CF-Talk
Subject: Re: About CF calendar..

No problem Hassan!Enjoy!

Let me know if you have any questions about the tag.

Where are you located?in South America it looks like...I lived down 
there for several years.

Josh

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Hassan Arteaga Rodriguez wrote:

 Thanks Josh


 __
 MSc. Hassan Arteaga Rodrguez
 Microsoft Certified System Engineer.
 DIGI- Grupo de Desarrollo
 COPEXTEL, S.A.

_

 From: Josh [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 06, 2004 10:53 AM
 To: CF-Talk
 Subject: Re: About CF calendar..

 We have one free for download, it suppot date and time(optional) and
 also support US and EURO dates:

 http://exciteworks.com/popDateTime_readme.cfm

 ---
 Exciteworks -- expert hosting for less!
 http://exciteworks.com
 specializing in reseller accounts

 Hassan Arteaga Rodriguez wrote:

  Hi there:
 
 
  I'm looking for a nice calendar(free also) for my site...Juts to 
 click and
  get a selected date.
 
 
  Regards
 
 
  __
  MSc. Hassan Arteaga Rodrguez
  Microsoft Certified System Engineer.
  DIGI- Grupo de Desarrollo
  COPEXTEL, S.A.
 
_
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MySQL and CF

2004-02-06 Thread ksuh
Yikes!Well, I'll never be using mySQL again.

- Original Message -
From: Vince Bonfanti [EMAIL PROTECTED]
Date: Friday, February 6, 2004 9:05 am
Subject: RE: MySQL and CF

 Not to comment at all on its technical merits, anyone using MySQL 
 should be
 familiar with their licensing terms. Specifically, MySQL is *not* 
 free for
 commercial development. If you use MySQL for a commercial product 
 and don't
 purchase a commercial license, then you run the risk of inadvertently
 releasing your source code for free.
 
 MySQL is released under GPL, unlike Linux, for example, which is 
 releasedunder LGPL. Under the LGPL, if you write an application 
 that runs on Linux
 you can redistribute that application without releasing the source 
 code.Under the GPL, however, if you release an application that 
 runs on MySQL,
 then you must release the source code of your application.
 
 Here are the relevant quotes from the MySQL licensing page on 
 their web
 site:
 
 http://www.mysql.com/products/licensing.html
 
 Regarding their Open Source license, which is the GPL:
 
 The Open Source License allows you to use the software at no 
 chargeunder the condition that if you use MySQL in an application you
 redistribute, the complete source code for your application must be
 available and freely redistributable under reasonable conditions.
 
 If you don't want to release the source code of your application, 
 you must
 purchase a commercial license:
 
 The Commercial License, which allows you to provide 
 commercial software
 licenses to your customers or distribute MySQL-based applications 
 withinyour organization. This is for organizations that do not 
 want to release the
 source code for their applications as open source / free software; 
 in other
 words they do not want to comply with the GNU General Public 
 License (GPL).
 
 Note that it's not just the MySQL database that's covered under these
 license terms--they also apply to the MySQL JDBC and ODBC drivers. 
 (This is
 the reason BlueDragon no longer ships the MySQL JDBC driver).
 
 So if you use MySQL--be careful. If you don't purchase a 
 commercial license,
 anyone can demand that you give them your source code under the 
 terms of the
 GPL license.
 
 Vince Bonfanti
 New Atlanta Communications, LLC
 http://www.newatlanta.com
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




CFMX performance data MMC thingy

2004-02-06 Thread Douglas.Knudsen
Running CFMX on JRun, the J2EE way, on a winblows 2000 server box.I'm trying to pull the perf data via the performances MMC snap in for CFMX and get nada.I can see ColdFusion MX Server in the Performance object dropdown and I can see the list of coubnters, but I can't choose any of them.I see the below errors in the event log too. Anyone else have this problem?Google ain't helping me today.

The Open Procedure for service ColdFusion MX Application Server in DLL C:\WINNT\system32\cfperfmon_mx.dll failed.Performance data for this service will not be available. Status codereturned is data DWORD 0. 

'The data buffer created for the ColdFusion MX Application Server 
service in the C:\WINNT\system32\cfperfmon_mx.dll library is not 
aligned on an 8-byte boundary. This may cause problems for 
applications 
that are trying to read the performance data buffer. Contact the 
manufacturer of this library or service to have this problem corrected 
or to get a newer version of this library.' 

--
Douglas Knudsen
Alltel ACI IT Rapid Response Team

**
The information contained in this message, including attachments, may contain 
privileged or confidential information that is intended to be delivered only to the 
person identified above. If you are not the intended recipient, or the person 
responsible for delivering this message to the intended recipient, ALLTEL requests 
that you immediately notify the sender and asks that you do not read the message or its 
attachments, and that you delete them without copying or sending them to anyone else.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: About CF calendar..

2004-02-06 Thread Hassan Arteaga Rodriguez
Josh:

 
I put js files and images inside my site within a folder /MySite/Calendar/
when i try to run a paga i got htis error:

 
:Could not find the included template Calendar/popDateTime4.js. Note: If you
wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm)
with CFINCLUDE then you must create a mapping for the path using the
ColdFusion Administrator. Using relative paths (e.g. TEMPLATE=index.cfm or
TEMPLATE=../index.cfm) does not require the creation of any special
mappings. It is therefore recommended that you use relative paths with
CFINCLUDE whenever possible. 
The error occurred on line 173.

 
this is the code...
cf_popDateTime formName=myForm
fieldName=Making_Date
time=no
euro=no
scriptPath=Calendar/

 
Regards,

 
__
MSc. Hassan Arteaga Rodrguez
Microsoft Certified System Engineer.
DIGI- Grupo de Desarrollo
COPEXTEL, S.A.

_

From: Josh [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 11:07 AM
To: CF-Talk
Subject: Re: About CF calendar..

No problem Hassan!Enjoy!

Let me know if you have any questions about the tag.

Where are you located?in South America it looks like...I lived down 
there for several years.

Josh

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Hassan Arteaga Rodriguez wrote:

 Thanks Josh


 __
 MSc. Hassan Arteaga Rodrguez
 Microsoft Certified System Engineer.
 DIGI- Grupo de Desarrollo
 COPEXTEL, S.A.

_

 From: Josh [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 06, 2004 10:53 AM
 To: CF-Talk
 Subject: Re: About CF calendar..

 We have one free for download, it suppot date and time(optional) and
 also support US and EURO dates:

 http://exciteworks.com/popDateTime_readme.cfm

 ---
 Exciteworks -- expert hosting for less!
 http://exciteworks.com
 specializing in reseller accounts

 Hassan Arteaga Rodriguez wrote:

  Hi there:
 
 
  I'm looking for a nice calendar(free also) for my site...Juts to 
 click and
  get a selected date.
 
 
  Regards
 
 
  __
  MSc. Hassan Arteaga Rodrguez
  Microsoft Certified System Engineer.
  DIGI- Grupo de Desarrollo
  COPEXTEL, S.A.
 
_
 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MySQL and CF

2004-02-06 Thread Jochem van Dieten
Vince Bonfanti wrote:
 
 Note that it's not just the MySQL database that's covered under these
 license terms--they also apply to the MySQL JDBC and ODBC drivers. (This is
 the reason BlueDragon no longer ships the MySQL JDBC driver).

It is also the main reason for, after years of a symbiotic 
relationship, PHP 5 not shipping with MySQL drivers.

Jochem

-- 
I don't get it
immigrants don't work
and steal our jobs
- Loesje
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Bank of America estores, cfhttp, http_referer, troubles

2004-02-06 Thread Matt Robertson
Check the archives for Bank of America, but in a nutshell:

BofA requires that you have a list of trusted referrers.You'll find
the BofA server is going to ignore your header assignment.So add the
BofA server as a trusted referring server and everything will magically
work.Nice security, huh?I did this as a temp workaround until BofA
tech staff came back with the same solution; making it permanent.

Don't they have an XML-based system now that doesn't require this
malarkey?And if you are on CF 6+ you should be able to use their
COM-based system (assuming COM works, of course).I was running CF 4.5
at the time so I couldn't go there.


 Matt Robertson [EMAIL PROTECTED] 
 MSB Designs, Inc.http://mysecretbase.com


-Original Message-
From: Mark Muellers [mailto:[EMAIL PROTECTED] 
Sent: Thursday, February 05, 2004 5:22 PM
To: CF-Talk
Subject: Re:Bank of America estores, cfhttp, http_referer, troubles

Andrea,

I'm also having the same problem.I'd HUGELY appreciate if you would
share how you solved this problem.

Thanks in advance,
Mark

I am trying to set up our new estores code for credit card processing.
I
have been using authorize.net in the past and never had any problems
with
cfhttp.

However, now I keep getting a message from Bank of America saying:

IOC_reject_description=The site that originated the order request is
not
authorized to POST transactions.

I have confirmed that I have put my site domain and IP into their
management
configuration setup, so it's not that.

I know people have mentioned problems with the fact that Bank of
America
requires you to send an http_referer header, which I have been trying
to do
using cfhttpparam. Here is my code:

CFHTTP URL="">
useragent=Mozilla/4.0
(compatible; MSIE 5.5; Windows NT 5.0) METHOD=post
throwonerror=Yes
resolveurl=Yes port=443
 CFHTTPPARAM NAME=http_referer TYPE=CGI
value=http://community.cancersource.com
 CFHTTPPARAM NAME=ioc_merchant_id TYPE=FormField
VALUE=#ioc_merchant_id#
 CFHTTPPARAM NAME=ioc_order_total_amount
TYPE=FormField
VALUE=#ioc_order_total_amount#
 CFHTTPPARAM NAME=ecom_billto_postal_name_first
TYPE=FormField VALUE=#ecom_billto_postal_name_first#
 CFHTTPPARAM NAME=ecom_billto_postal_name_last
TYPE=FormField VALUE=#ecom_billto_postal_name_last#
 CFHTTPPARAM NAME=ecom_billto_postal_street_line1
TYPE=FormField VALUE=#ecom_billto_postal_street_line1#
 CFHTTPPARAM NAME=ecom_billto_postal_city
TYPE=FormField
VALUE=#ecom_billto_postal_city#
 CFHTTPPARAM NAME=ecom_billto_postal_stateprov
TYPE=FormField VALUE=#ecom_billto_postal_stateprov#
 CFHTTPPARAM NAME=ecom_billto_postal_postalcode
TYPE=FormField VALUE=#ecom_billto_postal_postalcode#
 CFHTTPPARAM NAME=ecom_billto_postal_countrycode
TYPE=FormField VALUE=#ecom_billto_postal_countrycode#
 CFHTTPPARAM NAME=ecom_billto_online_email
TYPE=FormField VALUE=#ecom_billto_online_email#
 CFHTTPPARAM NAME=ecom_payment_card_name
TYPE=FormField
VALUE=#ecom_payment_card_name#
 CFHTTPPARAM NAME=ecom_payment_card_number
TYPE=FormField VALUE=#ecom_payment_card_number#
 CFHTTPPARAM NAME=ecom_payment_card_expdate_month
TYPE=FormField VALUE=#ecom_payment_card_expdate_month#
 CFHTTPPARAM NAME=ecom_payment_card_expdate_year
TYPE=FormField VALUE=#ecom_payment_card_expdate_year#
/CFHTTP

Does anyone have any insight into what I may be doing wrong?

Thank you.

Andrea


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: About CF calendar..

2004-02-06 Thread Josh
is the script path relative to the calling page?

I will take a look at this further in a few minutes for you.-- gotta 
head to a meeting!

Josh

---
Exciteworks -- expert hosting for less!
http://exciteworks.com
specializing in reseller accounts

Hassan Arteaga Rodriguez wrote:

 Josh:


 I put js files and images inside my site within a folder /MySite/Calendar/
 when i try to run a paga i got htis error:


 :Could not find the included template Calendar/popDateTime4.js. Note: 
 If you
 wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm)
 with CFINCLUDE then you must create a mapping for the path using the
 ColdFusion Administrator. Using relative paths (e.g. 
 TEMPLATE=index.cfm or
 TEMPLATE=../index.cfm) does not require the creation of any special
 mappings. It is therefore recommended that you use relative paths with
 CFINCLUDE whenever possible.
 The error occurred on line 173.


 this is the code...
 cf_popDateTime formName=myForm
fieldName=Making_Date
time=no
euro=no
scriptPath=Calendar/


 Regards,


 __
 MSc. Hassan Arteaga Rodrguez
 Microsoft Certified System Engineer.
 DIGI- Grupo de Desarrollo
 COPEXTEL, S.A.

_

 From: Josh [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 06, 2004 11:07 AM
 To: CF-Talk
 Subject: Re: About CF calendar..

 No problem Hassan!Enjoy!

 Let me know if you have any questions about the tag.

 Where are you located?in South America it looks like...I lived down
 there for several years.

 Josh

 ---
 Exciteworks -- expert hosting for less!
 http://exciteworks.com
 specializing in reseller accounts

 Hassan Arteaga Rodriguez wrote:

  Thanks Josh
 
 
  __
  MSc. Hassan Arteaga Rodrguez
  Microsoft Certified System Engineer.
  DIGI- Grupo de Desarrollo
  COPEXTEL, S.A.
 
 _
 
  From: Josh [mailto:[EMAIL PROTECTED]
  Sent: Friday, February 06, 2004 10:53 AM
  To: CF-Talk
  Subject: Re: About CF calendar..
 
  We have one free for download, it suppot date and time(optional) and
  also support US and EURO dates:
 
  http://exciteworks.com/popDateTime_readme.cfm
 
  ---
  Exciteworks -- expert hosting for less!
  http://exciteworks.com
  specializing in reseller accounts
 
  Hassan Arteaga Rodriguez wrote:
 
   Hi there:
  
  
   I'm looking for a nice calendar(free also) for my site...Juts to
  click and
   get a selected date.
  
  
   Regards
  
  
   __
   MSc. Hassan Arteaga Rodrguez
   Microsoft Certified System Engineer.
   DIGI- Grupo de Desarrollo
   COPEXTEL, S.A.
  
 _
 
_

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX performance data MMC thingy

2004-02-06 Thread Debbie Dickerson
Performance monitor integration is not available in the J2EE configuration:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm

 
You might want to check out the TechNote about using JRun's metrics:
http://www.macromedia.com/support/coldfusion/ts/documents/metrics_logging.ht
m
http://www.macromedia.com/support/coldfusion/ts/documents/metrics_logging.h
tm 

_

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 11:26 AM
To: CF-Talk
Subject: CFMX performance data MMC thingy

Running CFMX on JRun, the J2EE way, on a winblows 2000 server box.I'm
trying to pull the perf data via the performances MMC snap in for CFMX and
get nada.I can see ColdFusion MX Server in the Performance object
dropdown and I can see the list of coubnters, but I can't choose any of
them.I see the below errors in the event log too. Anyone else have this
problem?Google ain't helping me today.

The Open Procedure for service ColdFusion MX Application Server in DLL
C:\WINNT\system32\cfperfmon_mx.dll failed.Performance data for this
service will not be available. Status codereturned is data DWORD 0. 

'The data buffer created for the ColdFusion MX Application Server 
service in the C:\WINNT\system32\cfperfmon_mx.dll library is not 
aligned on an 8-byte boundary. This may cause problems for 
applications 
that are trying to read the performance data buffer. Contact the 
manufacturer of this library or service to have this problem corrected 
or to get a newer version of this library.' 

--
Douglas Knudsen
Alltel ACI IT Rapid Response Team


**
The information contained in this message, including attachments, may
contain 
privileged or confidential information that is intended to be delivered only
to the 
person identified above. If you are not the intended recipient, or the
person 
responsible for delivering this message to the intended recipient, ALLTEL
requests 
that you immediately notify the sender and asks that you do not read the
message or its 
attachments, and that you delete them without copying or sending them to
anyone else. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: jRockit

2004-02-06 Thread Dave Watts
 Hmm, did 6.0 use IBM's?I distinctly remember reading 
 something about that.

No, it didn't, although it did use Jikes for something or other.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFLogin issue - Roles

2004-02-06 Thread Raymond Camden
 Ray,
What about a situation where you have certain display 
 elements that only show to logged-in users?Why not wrap 
 cflogin around those elements?I know you're immediate 
 answer is use conditional logic to see if 
 getAuthUser()returns an empty string, but I don't see why 
 one is better than the other.Using getAuthUser() means 
 using conditional logic (yes, I know that cflogin is an 
 explicit conditional check) which is more sore on the eyes 
 and requires a developer to expend more thought in order to 
 figure out what the conditional logic is.cflogin is 
 intended to be wrapped around code to run when people aren't 
 logged in.GetAuthUser() is supposed to return the name of 
 the logged-in user.Right now, getAuthUser() happens to 
 return an empty string when you're not logged in, but that 
 functionality
 isn't set in stone.If that functionality is set in stone, 
 I still think
 cflogin leaves less doubt about the intention of the code.
 Thoughts?
 

In my mind, cflogin should not be used as a login check. It should only be
used to manage the login system as whole. Sure it _acts_ a bit like a
conditional check, but that is not its true purpose. This to me is enough to
say that getAuthUser is better than cflogin for determining if a user is
logged in.

Why do you say GetAuthUser() is not set in stone? That can be applied to
_any_ function. Even if MACR changed it so that users not logged in returned
XXX or somesuch, you could use use it as a way to see if the user is
authenticated.

As a side note, you _can_ use cflogin to determine if the user is logged
in. For a site where logins are optional, you can have this in
Application.cfm:

cflogin
	cfset request.userisloggedin = false
	!--- normaly code here o handle potential log ons, and set the
request var above to true if need be ---
/cflogin

someotherfile.cfm:

	cif request.userisloggedin
	.
	/cfif
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFLogin issue - Roles

2004-02-06 Thread Raymond Camden
   I'm trying to trace the error and one main thing I find 
 is that if 
   there's 2 CFLOGIN tags on the page, the second one always assumes 
   that your not logged in.
 
  You mean 2 blocks of cflogin tags? I'd consider that a bug, 
 but also 
  non-standard usage. There should only be one cflogin block per 
  request (imho).
 It is non-standard, but something that popped up as I'm testing this.
 Basically, using the CFLOGINUSER inside the CFC causes some 
 strange results and that double CFLOGIN issue may be one of 
 them. I'm still looking.
 The bottom line may be that its better to leave the 
 CFLOGINUSER outside the CFC.

I've always said this. ;) To me, cflogin user is a application specific
implementation. Your CFC should be more vague and simply handle the
authentication. Let the app handle how to remember that the user is logged
in. But we disagreed about this before. :)

Please log a bug about the N uses of cflogin. I still say it shouldn't be
used like that, but certainly it needs to work correctly if it can be used
more than once.

   Also, the IsUserInRole() function will not take more than 
 one role 
   where the docs says that it can take a list.
 
  Yes, it will take more then one role. This works fine in 
 all my tests.
  However, do not forget thatit will do an AND check. So if 
 you pass A,B 
  it will only return true if the user is in both.
 Ah, the docs imply an OR case. I've tested it and it is the 
 AND case as you say. One of these days I'm going to rewrite 

There is a CFLib function that will do an OR check for you. I believe it is
called IsUserInAnyRole.
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: RE: jRockit

2004-02-06 Thread ksuh
Ah, maybe that was it.

- Original Message -
From: Dave Watts [EMAIL PROTECTED]
Date: Friday, February 6, 2004 9:50 am
Subject: RE: jRockit

  Hmm, did 6.0 use IBM's?I distinctly remember reading 
  something about that.
 
 No, it didn't, although it did use Jikes for something or other.
 
 Dave Watts, CTO, Fig Leaf Software
 http://www.figleaf.com/
 phone: 202-797-5496
 fax: 202-797-5444
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Please help - Windows XP Virtual Drives.. I need help

2004-02-06 Thread Dave Watts
 This is basically a repost but I really need a solution and 
 there have got to be other developers dealing with this 
 problem... here's the problem - It seems Windows XP (probably 
 Windows 2003 Server too) does not see my virtual drives. I'm 
 having the same problem with Apache. By virtual drives, I mean
 network mapped drives or local mappings I create with subst. 
 Take a look at this source code where I try to create a Y: 
 drive and then look at the result I get I'm totally stuck 
 and I need help!!! The problem seems to be that services in 
 Windows XP can't see the damn virtual drives. In my code
 sample below, it looks like CF is spawning a DOS prompt that 
 runs as the logged in user rather than the service. I've tried 
 setting the permissions on both the virtual drive and the 
 physical source directory to be open to everybody. I've also 
 tried setting the Coldfusion Application Server user role to 
 run as the local account and the administrator of the machine. 
 I've also tried toggling the interact with desktop option. 
 Nothing seems to work.

By default, CF runs as SYSTEM (the local account you mentioned), and
neither SYSTEM nor the local Administrator account have rights to network
resources. If you want CF to be able to access network resources via Windows
Networking, you'll need to run it as a user with the appropriate rights.
This isn't specific to XP or Windows Server 2003, either, but is true for
all versions of Windows NT and its descendents.

You probably don't even need to map the drives, either; you should be able
to use the UNC paths directly, once you've configured CF to run as a user
with the appropriate rights.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFLogin issue - Roles

2004-02-06 Thread Simon Horwith
I guess what I don't understand is why you think cflogin should not be
used as a log-in check.That's exactly what it is (and that's all that it
is).GetAuthUser(), by definition, returns the username of the current
user.You happen to be able to use both to determine whether or not someone
is logged-in... I'm not sure whether there's any performance difference
between the two (I'd think cflogin would be quicker in determining if
someone's logged-in, but the difference would never be significant enough to
matter anyway).So I guess it's really just a personal preference thing.I
use both... if I'm in the display layer, I like cflogin.If I'm anywhere
else, I generally use getAuthUser() primarily because so much of my code
is cfscript.

~Simon

Simon Horwith
CTO, Etrilogy Ltd.
Member of Team Macromedia
Macromedia Certified Instructor
Certified Advanced ColdFusion MX Developer
Certified Flash MX Developer
CFDJList - List Administrator
http://www.how2cf.com/

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 06 February 2004 16:48
To: CF-Talk
Subject: RE: Another CFLogin issue - Roles

 Ray,
What about a situation where you have certain display
 elements that only show to logged-in users?Why not wrap
 cflogin around those elements?I know you're immediate
 answer is use conditional logic to see if
 getAuthUser()returns an empty string, but I don't see why
 one is better than the other.Using getAuthUser() means
 using conditional logic (yes, I know that cflogin is an
 explicit conditional check) which is more sore on the eyes
 and requires a developer to expend more thought in order to
 figure out what the conditional logic is.cflogin is
 intended to be wrapped around code to run when people aren't
 logged in.GetAuthUser() is supposed to return the name of
 the logged-in user.Right now, getAuthUser() happens to
 return an empty string when you're not logged in, but that
 functionality
 isn't set in stone.If that functionality is set in stone,
 I still think
 cflogin leaves less doubt about the intention of the code.
 Thoughts?


In my mind, cflogin should not be used as a login check. It should only
be
used to manage the login system as whole. Sure it _acts_ a bit like a
conditional check, but that is not its true purpose. This to me is enough
to
say that getAuthUser is better than cflogin for determining if a user is
logged in.

Why do you say GetAuthUser() is not set in stone? That can be applied to
_any_ function. Even if MACR changed it so that users not logged in
returned
XXX or somesuch, you could use use it as a way to see if the user is
authenticated.

As a side note, you _can_ use cflogin to determine if the user is logged
in. For a site where logins are optional, you can have this in
Application.cfm:

cflogin
cfset request.userisloggedin = false
!--- normaly code here o handle potential log ons, and set the
request var above to true if need be ---
/cflogin

someotherfile.cfm:

cif request.userisloggedin
.
/cfif
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX performance data MMC thingy

2004-02-06 Thread Douglas.Knudsen
thanks debbie.Teh tech note helped get something.

 
But in the end this sucks!I can't use the fancy windows tool for perf monitoringmy event log is filled with the below errors, one entry every min or two 24x7 and the Perf Monitor MMC tool has CFMX listed but all teh counters are 'greyed out' .Someone have suggestions?How does one load test their apps now using the J2EE version?

 
Doug

-Original Message-
From: Debbie Dickerson [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 11:39 AM
To: CF-Talk
Subject: RE: CFMX performance data MMC thingy

Performance monitor integration is not available in the J2EE configuration:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm

You might want to check out the TechNote about using JRun's metrics:
http://www.macromedia.com/support/coldfusion/ts/documents/metrics_logging.ht
m
http://www.macromedia.com/support/coldfusion/ts/documents/metrics_logging.h
tm 

_

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 11:26 AM
To: CF-Talk
Subject: CFMX performance data MMC thingy

Running CFMX on JRun, the J2EE way, on a winblows 2000 server box.I'm
trying to pull the perf data via the performances MMC snap in for CFMX and
get nada.I can see ColdFusion MX Server in the Performance object
dropdown and I can see the list of coubnters, but I can't choose any of
them.I see the below errors in the event log too. Anyone else have this
problem?Google ain't helping me today.

The Open Procedure for service ColdFusion MX Application Server in DLL
C:\WINNT\system32\cfperfmon_mx.dll failed.Performance data for this
service will not be available. Status codereturned is data DWORD 0. 

'The data buffer created for the ColdFusion MX Application Server 
service in the C:\WINNT\system32\cfperfmon_mx.dll library is not 
aligned on an 8-byte boundary. This may cause problems for 
applications 
that are trying to read the performance data buffer. Contact the 
manufacturer of this library or service to have this problem corrected 
or to get a newer version of this library.' 

--
Douglas Knudsen
Alltel ACI IT Rapid Response Team


**
The information contained in this message, including attachments, may
contain 
privileged or confidential information that is intended to be delivered only
to the 
person identified above. If you are not the intended recipient, or the
person 
responsible for delivering this message to the intended recipient, ALLTEL
requests 
that you immediately notify the sender and asks that you do not read the
message or its 
attachments, and that you delete them without copying or sending them to
anyone else. 
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MySQL and CF

2004-02-06 Thread Matt Robertson
The Commercial License, which allows you to provide commercial software
licenses to your customers or distribute MySQL-based applications within
your organization...

So then, is an app that uses mySQL based on it?Is an application
that can easily support various platforms, of which one is mySQL,
based on mySQL?While I'm no lawyer it seems to me the two are not
the same animal.

Now, for something like BD and CF, where to offer mySQL functionality
(which is an 'application' in and of itself) then your use of the jdbc
connectors to provide db connectivity does clearly meet the based on
standard.However, unless an application is genuinely written to run
only on mySQL (which would include the use of any mysql-specific
feature, anywhere in the app, where no alternative in the code is
provided) then it seems to me the app is not based on mySQL and
doesn't meet this standard for licensing.

Worth looking into:mySQL used to provide an express 'out' for
commercial ISP's; exempting them from buying a license.I'd have to
read their licensing over again to be sure its still there.


 Matt Robertson [EMAIL PROTECTED] 
 MSB Designs, Inc.http://mysecretbase.com

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFLogin issue - Roles

2004-02-06 Thread Raymond Camden
 I guess what I don't understand is why you think cflogin 
 should not be used as a log-in check.That's exactly what it 
 is (and that's all that it is).GetAuthUser(), by 
 definition, returns the username of the current user.You 
 happen to be able to use both to determine whether or not 
 someone is logged-in... I'm not sure whether there's any 
 performance difference between the two (I'd think cflogin 
 would be quicker in determining if someone's logged-in, but 
 the difference would never be significant enough to matter 
 anyway).So I guess it's really just a personal preference 
 thing.I use both... if I'm in the display layer, I like 
 cflogin.If I'm anywhere else, I generally use 
 getAuthUser() primarily because so much of my code is cfscript.

I don't think I quite made my point clear. I'm not saying cflogin
shouldn't be used as a login check - obviously you can use it to force login
when a person isn't logged in. My feeling was that it should not be used
PURELY as a conditional, ie,

	cflogin
		display stuff here for non logged in users
	/cflogin

It should be used as a conditional check for login that _also_ handles the
login of the user, potentially aborting the process. etc.

Obviously a nitpicky difference and something I don't expect others to agree
with. ;)

So, someone go to the Macromedia forum and request for a real
isAuthenticated() function.

Btw - as a side note (I blogged this before so sorry for repeating myself) -
be careful when writing security related UDFs. As you know, getAuthUser()
returns an empty string if you aren't logged in. You may be tempted to write
this UDF:

function isAuthenticated() {
	return getAuthUser() neq ;
}

However, if you try to call it (there is no bug with just declaring it), you
get:

Function isAuthenticated is not supported in ColdFusion MX. 

Why? IsAuthenticated() was one of the old Advanced Security funcitons. AS
was removed in MX. However, instead of just removing the functions, CF
actually has a hook in it so even if you define your own UDF, you can't
call it. (And yes, I've already reported this. :)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MS Update broke security

2004-02-06 Thread Thomas Chiverton
On Friday 06 Feb 2004 15:30 pm, Schuster, Steven wrote:
 Putting the username and password in the URL. :-)

I guess it would work, meet all the requirements.
But still... :-)

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MySQL and CF

2004-02-06 Thread Thomas Chiverton
On Friday 06 Feb 2004 16:06 pm, Jochem van Dieten wrote:
 Bryan Stevenson wrote:
  I agree...MySQL is not a real databasenot just because of the FK
  issue which is only fixed by using InnoDBit also doesn't have stored
  procs/triggers/rollback.

 Transactions are supported, and rollback works.

And stored procs are along soon.

-- 
Tom Chiverton 
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:MS Update broke security

2004-02-06 Thread Jeremy Brodie
Its time to focus on a solution to solve the problem. From a solutions perspective, the best long term solution would be querry off of Active Directory LDAP server and use that to determine users and roles however, what I suggest below is more of a short term fix that can be impemented today and buy time for the permanent solution using Active Directory/LDAP.

Step 1: Have the person login in using basic authentication
Step 2: If you are using IIS, two CGI variables will be created:
cgi.auth_user and cgi.auth_password. 
Step 3: Create a database table containing the username and password. If there is not a record, run a querry or a stored proceedure to insert the record. If the password has been changed then, use the cgi variable to change the passwrod. 
Step 4: Set a session variable noting the person has logged in. If you need the username and password for other applications, then look up the information in the database.

P.S. There was a good reason MS fixed this behavior in their browser. Turns out Phishers and Spammers were using this technique to gather credit card information from unsupecting users ruining their credit ratings!

Reference url: http://news.com.com/2100-7355-5153534.html?tag=cd_top

Jeremy Brodie
Edgewater Technology

web: http://www.edgewater.com
phone:(703) 815-2500
email: [EMAIL PROTECTED]

For instance:

 

Putting the username and password in the URL. :-)

 

Steve

 

 

-Original Message-
From: Josh Remus [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 10:22 AM
To: CF-Talk
Subject: RE: MS Update broke security

 

Honestly, none of this has sounded secure at all, actually.
-Original Message-
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 10:08 AM
To: CF-Talk
Subject: Re: MS Update broke security

On Friday 06 Feb 2004 13:59 pm, Robert Everland III wrote:
 that's just it I can't use anythign that requires user intervention.

Then you can't do security.

--
Tom Chiverton
Advanced ColdFusion Programmer

Tel: +44(0)1749 834997
email: [EMAIL PROTECTED]
BlueFinger Limited
Underwood Business Park
Wookey Hole Road, WELLS. BA5 1AF
Tel: +44 (0)1749 834900
Fax: +44 (0)1749 834901
web: www.bluefinger.com
Company Reg No: 4209395 Registered Office: 2 Temple Back East, Temple
Quay, BRISTOL. BS1 6EG.
*** This E-mail contains confidential information for the addressee
only. If you are not the intended recipient, please notify us
immediately. You should not use, disclose, distribute or copy this
communication if received in error. No binding contract will result from
this e-mail until such time as a written document is signed on behalf of
the company. BlueFinger Limited cannot accept responsibility for the
completeness or accuracy of this message as it has been transmitted over
public networks.***

_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: Another CFLogin issue - Roles

2004-02-06 Thread Simon Horwith
well, I'm not sure why you think it should also handle logging a user in
whenever it's used, but it's not a big deal either way.I take back what I
said about it purely being a conditional check tag... obviously it does a
little more if you think about it's attributes, but I don't think it's a big
deal one way or the other.The fact that there is no longer an
isAuthenticated() function, as you mention, is a much bigger deal (and it's
re-introduction would put this debate to rest as well).

~Simon

Simon Horwith
CTO, Etrilogy Ltd.
Member of Team Macromedia
Macromedia Certified Instructor
Certified Advanced ColdFusion MX Developer
Certified Flash MX Developer
CFDJList - List Administrator
http://www.how2cf.com/

-Original Message-
From: Raymond Camden [mailto:[EMAIL PROTECTED]
Sent: 06 February 2004 17:19
To: CF-Talk
Subject: RE: Another CFLogin issue - Roles

 I guess what I don't understand is why you think cflogin
 should not be used as a log-in check.That's exactly what it
 is (and that's all that it is).GetAuthUser(), by
 definition, returns the username of the current user.You
 happen to be able to use both to determine whether or not
 someone is logged-in... I'm not sure whether there's any
 performance difference between the two (I'd think cflogin
 would be quicker in determining if someone's logged-in, but
 the difference would never be significant enough to matter
 anyway).So I guess it's really just a personal preference
 thing.I use both... if I'm in the display layer, I like
 cflogin.If I'm anywhere else, I generally use
 getAuthUser() primarily because so much of my code is cfscript.

I don't think I quite made my point clear. I'm not saying cflogin
shouldn't be used as a login check - obviously you can use it to force
login
when a person isn't logged in. My feeling was that it should not be used
PURELY as a conditional, ie,

cflogin
display stuff here for non logged in users
/cflogin

It should be used as a conditional check for login that _also_ handles the
login of the user, potentially aborting the process. etc.

Obviously a nitpicky difference and something I don't expect others to
agree
with. ;)

So, someone go to the Macromedia forum and request for a real
isAuthenticated() function.

Btw - as a side note (I blogged this before so sorry for repeating
myself) -
be careful when writing security related UDFs. As you know, getAuthUser()
returns an empty string if you aren't logged in. You may be tempted to
write
this UDF:

function isAuthenticated() {
return getAuthUser() neq ;
}

However, if you try to call it (there is no bug with just declaring it),
you
get:

Function isAuthenticated is not supported in ColdFusion MX.

Why? IsAuthenticated() was one of the old Advanced Security funcitons. AS
was removed in MX. However, instead of just removing the functions, CF
actually has a hook in it so even if you define your own UDF, you can't
call it. (And yes, I've already reported this. :)
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX performance data MMC thingy

2004-02-06 Thread Burns, John
Stupid question, but how do you add cf into the performance monitor on a
normal install of CF? I've never done it before but would like to see
what kind of info it would give me.If someone can give a simple
step-by-step, that'd be appreciated.

John 

-Original Message-
From: Debbie Dickerson [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 11:39 AM
To: CF-Talk
Subject: RE: CFMX performance data MMC thingy

Performance monitor integration is not available in the J2EE
configuration:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm

 
You might want to check out the TechNote about using JRun's metrics:
http://www.macromedia.com/support/coldfusion/ts/documents/metrics_loggin
g.ht
m
http://www.macromedia.com/support/coldfusion/ts/documents/metrics_loggi
ng.h
tm 

_

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 11:26 AM
To: CF-Talk
Subject: CFMX performance data MMC thingy

Running CFMX on JRun, the J2EE way, on a winblows 2000 server box.I'm
trying to pull the perf data via the performances MMC snap in for CFMX
and
get nada.I can see ColdFusion MX Server in the Performance object
dropdown and I can see the list of coubnters, but I can't choose any of
them.I see the below errors in the event log too. Anyone else have
this
problem?Google ain't helping me today.

The Open Procedure for service ColdFusion MX Application Server in DLL
C:\WINNT\system32\cfperfmon_mx.dll failed.Performance data for this
service will not be available. Status codereturned is data DWORD 0. 

'The data buffer created for the ColdFusion MX Application Server 
service in the C:\WINNT\system32\cfperfmon_mx.dll library is not 
aligned on an 8-byte boundary. This may cause problems for 
applications 
that are trying to read the performance data buffer. Contact the 
manufacturer of this library or service to have this problem corrected 
or to get a newer version of this library.' 

--
Douglas Knudsen
Alltel ACI IT Rapid Response Team



**
The information contained in this message, including attachments, may
contain 
privileged or confidential information that is intended to be delivered
only
to the 
person identified above. If you are not the intended recipient, or the
person 
responsible for delivering this message to the intended recipient,
ALLTEL
requests 
that you immediately notify the sender and asks that you do not read the
message or its 
attachments, and that you delete them without copying or sending them to
anyone else. 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: MySQL and CF

2004-02-06 Thread Doug White
That post may be somewhat misleading.If you are using the open source version
of MySQL, you are under NO obligation to reveal the source code of the
application you develop which uses the database.The only reveal obligation
you will have is if you modify the MySQL source code itself. That is a
reasonable requirement of the license.

This little thing was omitted from the post on CF-Talk, and I caution anyone to
takes the post literally to mean that your application which uses the database
is automatically open source as well.It just ain't so.

No user should be afraid to use proprietary code to access a MySQL database

==
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
==
Aspire to Inspire before you Retire or Expire!

- Original Message - 
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Friday, February 06, 2004 10:18 AM
Subject: RE: MySQL and CF

Yikes!Well, I'll never be using mySQL again.

- Original Message -
From: Vince Bonfanti [EMAIL PROTECTED]
Date: Friday, February 6, 2004 9:05 am
Subject: RE: MySQL and CF

 Not to comment at all on its technical merits, anyone using MySQL
 should be
 familiar with their licensing terms. Specifically, MySQL is *not*
 free for
 commercial development. If you use MySQL for a commercial product
 and don't
 purchase a commercial license, then you run the risk of inadvertently
 releasing your source code for free.

 MySQL is released under GPL, unlike Linux, for example, which is
 releasedunder LGPL. Under the LGPL, if you write an application
 that runs on Linux
 you can redistribute that application without releasing the source
 code.Under the GPL, however, if you release an application that
 runs on MySQL,
 then you must release the source code of your application.

 Here are the relevant quotes from the MySQL licensing page on
 their web
 site:

 http://www.mysql.com/products/licensing.html

 Regarding their Open Source license, which is the GPL:

 The Open Source License allows you to use the software at no
 chargeunder the condition that if you use MySQL in an application you
 redistribute, the complete source code for your application must be
 available and freely redistributable under reasonable conditions.

 If you don't want to release the source code of your application,
 you must
 purchase a commercial license:

 The Commercial License, which allows you to provide
 commercial software
 licenses to your customers or distribute MySQL-based applications
 withinyour organization. This is for organizations that do not
 want to release the
 source code for their applications as open source / free software;
 in other
 words they do not want to comply with the GNU General Public
 License (GPL).

 Note that it's not just the MySQL database that's covered under these
 license terms--they also apply to the MySQL JDBC and ODBC drivers.
 (This is
 the reason BlueDragon no longer ships the MySQL JDBC driver).

 So if you use MySQL--be careful. If you don't purchase a
 commercial license,
 anyone can demand that you give them your source code under the
 terms of the
 GPL license.

 Vince Bonfanti
 New Atlanta Communications, LLC
 http://www.newatlanta.com




 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: MySQL and CF

2004-02-06 Thread Barney Boisvert
It seems there's some disagreement about what the GPL means.MySQL is
distributed under the GPL, so MySQL AB can't add any restrictions on use
beyond what are already in the license.If you need to do things that the
GPL doesn't let you (like distribute MySQL as part of a non-GPL software
package, or distribute a modified version of MySQL under non-GPL license),
then MySQL AB also provides commercial licenses for your use.

In general, as long as you're not distributing software, the GPL is very
thin on limitations.And even if you are distributing something that is
based on or derived from MySQL, you're not limited to a GPL license for that
software as long as it can be considered reasonably considered independent
and separate works in themselves (from subsection 2 of the Terms section).

Someone pointed out that as long as your app is not strictly bound to
MySQL-specific syntax (LIMIT clause, for example), then you're safe from
licensing restrictions.Even if your code uses MySQL-specific syntax, that
doesn't necessarily bind it either.As long as your code can be considered
it's own separate work (and is distributed separately), then you're fine.
On the flip side, if you have purely non-MySQL-specific application code,
but you distribute it bundled with MySQL, then you ARE bound by the GPL,
even though your app is totally independent of MySQL.

Cheers,
barneyb

 -Original Message-
 From: Vince Bonfanti [mailto:[EMAIL PROTECTED] 
 Sent: Friday, February 06, 2004 8:06 AM
 To: CF-Talk
 Subject: RE: MySQL and CF
 
 Not to comment at all on its technical merits, anyone using 
 MySQL should be
 familiar with their licensing terms. Specifically, MySQL is 
 *not* free for
 commercial development. If you use MySQL for a commercial 
 product and don't
 purchase a commercial license, then you run the risk of inadvertently
 releasing your source code for free.
 
 MySQL is released under GPL, unlike Linux, for example, which 
 is released
 under LGPL. Under the LGPL, if you write an application that 
 runs on Linux
 you can redistribute that application without releasing the 
 source code.
 Under the GPL, however, if you release an application that 
 runs on MySQL,
 then you must release the source code of your application.
 
 Here are the relevant quotes from the MySQL licensing page on 
 their web
 site:
 
http://www.mysql.com/products/licensing.html
 
 Regarding their Open Source license, which is the GPL:
 
The Open Source License allows you to use the software 
 at no charge
 under the condition that if you use MySQL in an application you
 redistribute, the complete source code for your application must be
 available and freely redistributable under reasonable conditions.
 
 If you don't want to release the source code of your 
 application, you must
 purchase a commercial license:
 
The Commercial License, which allows you to provide 
 commercial software
 licenses to your customers or distribute MySQL-based 
 applications within
 your organization. This is for organizations that do not want 
 to release the
 source code for their applications as open source / free 
 software; in other
 words they do not want to comply with the GNU General Public 
 License (GPL).
 
 Note that it's not just the MySQL database that's covered under these
 license terms--they also apply to the MySQL JDBC and ODBC 
 drivers. (This is
 the reason BlueDragon no longer ships the MySQL JDBC driver).
 
 So if you use MySQL--be careful. If you don't purchase a 
 commercial license,
 anyone can demand that you give them your source code under 
 the terms of the
 GPL license.
 
 Vince Bonfanti
 New Atlanta Communications, LLC
 http://www.newatlanta.com
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: CFMX performance data MMC thingy

2004-02-06 Thread Douglas.Knudsen
hmm...I found this
http://livedocs.macromedia.com/coldfusion/6/Installing_CFMX_for_J2EE/differences3.htm
Performance monitoring is not supported in ColdFusion MX for J2EE.

 
hmphh

 
Doug

-Original Message-
From: Knudsen, Douglas 
Sent: Friday, February 06, 2004 11:59 AM
To: CF-Talk
Subject: RE: CFMX performance data MMC thingy

thanks debbie.Teh tech note helped get something.

But in the end this sucks!I can't use the fancy windows tool for perf monitoringmy event log is filled with the below errors, one entry every min or two 24x7 and the Perf Monitor MMC tool has CFMX listed but all teh counters are 'greyed out' .Someone have suggestions?How does one load test their apps now using the J2EE version?

Doug

-Original Message-
From: Debbie Dickerson [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 11:39 AM
To: CF-Talk
Subject: RE: CFMX performance data MMC thingy

Performance monitor integration is not available in the J2EE configuration:
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm
http://livedocs.macromedia.com/coldfusion/6.1/htmldocs/basico24.htm

You might want to check out the TechNote about using JRun's metrics:
http://www.macromedia.com/support/coldfusion/ts/documents/metrics_logging.ht
m
http://www.macromedia.com/support/coldfusion/ts/documents/metrics_logging.h
tm 

_

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Friday, February 06, 2004 11:26 AM
To: CF-Talk
Subject: CFMX performance data MMC thingy

Running CFMX on JRun, the J2EE way, on a winblows 2000 server box.I'm
trying to pull the perf data via the performances MMC snap in for CFMX and
get nada.I can see ColdFusion MX Server in the Performance object
dropdown and I can see the list of coubnters, but I can't choose any of
them.I see the below errors in the event log too. Anyone else have this
problem?Google ain't helping me today.

The Open Procedure for service ColdFusion MX Application Server in DLL
C:\WINNT\system32\cfperfmon_mx.dll failed.Performance data for this
service will not be available. Status codereturned is data DWORD 0. 

'The data buffer created for the ColdFusion MX Application Server 
service in the C:\WINNT\system32\cfperfmon_mx.dll library is not 
aligned on an 8-byte boundary. This may cause problems for 
applications 
that are trying to read the performance data buffer. Contact the 
manufacturer of this library or service to have this problem corrected 
or to get a newer version of this library.' 

--
Douglas Knudsen
Alltel ACI IT Rapid Response Team


**
The information contained in this message, including attachments, may
contain 
privileged or confidential information that is intended to be delivered only
to the 
person identified above. If you are not the intended recipient, or the
person 
responsible for delivering this message to the intended recipient, ALLTEL
requests 
that you immediately notify the sender and asks that you do not read the
message or its 
attachments, and that you delete them without copying or sending them to
anyone else. 
_ 
_ 
_
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re:Fusetalk Q

2004-02-06 Thread Michael Dinowitz
I never forget that. :)
I always add a report function to my agents so that if they fail, I get emailed with the information. 

And don't forget...

4.Rewrite every time MM changes the style/html and breaks your
regexp/tokenizer.

:-)

I actually have a full mm webforum parser I wrote about a year ago to
display threads I'm participating in on my blog, but it doesn't work any
more since the html it triggered off changed.

Sam
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: About CF calendar..

2004-02-06 Thread Cutter (CF-Talk)
Hassan,

The scriptPath attribute of popDateTime is the path to the popDateTime 
folder (which contains the .js script and images, etc. necessary for the 
tag to work). I use this in a few places on our site (mostly backend 
editors and stuff).

Cutter

Josh wrote:
 is the script path relative to the calling page?
 
 I will take a look at this further in a few minutes for you.-- gotta
 head to a meeting!
 
 Josh
 
 ---
 Exciteworks -- expert hosting for less!
 http://exciteworks.com
 specializing in reseller accounts
 
 Hassan Arteaga Rodriguez wrote:
 
 Josh:


 I put js files and images inside my site within a folder 
 /MySite/Calendar/
 when i try to run a paga i got htis error:


 :Could not find the included template Calendar/popDateTime4.js. Note:
 If you
 wish to use an absolute template path (e.g. TEMPLATE=/mypath/index.cfm)
 with CFINCLUDE then you must create a mapping for the path using the
 ColdFusion Administrator. Using relative paths (e.g.
 TEMPLATE=index.cfm or
 TEMPLATE=../index.cfm) does not require the creation of any special
 mappings. It is therefore recommended that you use relative paths with
 CFINCLUDE whenever possible.
 The error occurred on line 173.


 this is the code...
 cf_popDateTime formName=myForm
fieldName=Making_Date
time=no
euro=no
scriptPath=Calendar/


 Regards,


 __
 MSc. Hassan Arteaga Rodrguez
 Microsoft Certified System Engineer.
 DIGI- Grupo de Desarrollo
 COPEXTEL, S.A.

_

 From: Josh [mailto:[EMAIL PROTECTED]
 Sent: Friday, February 06, 2004 11:07 AM
 To: CF-Talk
 Subject: Re: About CF calendar..

 No problem Hassan!Enjoy!

 Let me know if you have any questions about the tag.

 Where are you located?in South America it looks like...I lived down
 there for several years.

 Josh

 ---
 Exciteworks -- expert hosting for less!
 http://exciteworks.com
 specializing in reseller accounts

 Hassan Arteaga Rodriguez wrote:

  Thanks Josh
 
 
  __
  MSc. Hassan Arteaga Rodrguez
  Microsoft Certified System Engineer.
  DIGI- Grupo de Desarrollo
  COPEXTEL, S.A.
 
 _
 
  From: Josh [mailto:[EMAIL PROTECTED]
  Sent: Friday, February 06, 2004 10:53 AM
  To: CF-Talk
  Subject: Re: About CF calendar..
 
  We have one free for download, it suppot date and time(optional) and
  also support US and EURO dates:
 
  http://exciteworks.com/popDateTime_readme.cfm
 
  ---
  Exciteworks -- expert hosting for less!
  http://exciteworks.com
  specializing in reseller accounts
 
  Hassan Arteaga Rodriguez wrote:
 
   Hi there:
  
  
   I'm looking for a nice calendar(free also) for my site...Juts to
  click and
   get a selected date.
  
  
   Regards
  
  
   __
   MSc. Hassan Arteaga Rodrguez
   Microsoft Certified System Engineer.
   DIGI- Grupo de Desarrollo
   COPEXTEL, S.A.
  
 _
 
_


 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: RE: MySQL and CF

2004-02-06 Thread ksuh
But if I create an application that uses mySQL for profit, I must obtain a mySQL commercial license, correct?Or not?

- Original Message -
From: Barney Boisvert [EMAIL PROTECTED]
Date: Friday, February 6, 2004 10:39 am
Subject: RE: MySQL and CF

 It seems there's some disagreement about what the GPL means.
 MySQL is
 distributed under the GPL, so MySQL AB can't add any restrictions 
 on use
 beyond what are already in the license.If you need to do things 
 that the
 GPL doesn't let you (like distribute MySQL as part of a non-GPL 
 softwarepackage, or distribute a modified version of MySQL under 
 non-GPL license),
 then MySQL AB also provides commercial licenses for your use.
 
 In general, as long as you're not distributing software, the GPL 
 is very
 thin on limitations.And even if you are distributing something 
 that is
 based on or derived from MySQL, you're not limited to a GPL 
 license for that
 software as long as it can be considered reasonably considered 
 independentand separate works in themselves (from subsection 2 of 
 the Terms section).
 
 Someone pointed out that as long as your app is not strictly bound to
 MySQL-specific syntax (LIMIT clause, for example), then you're 
 safe from
 licensing restrictions.Even if your code uses MySQL-specific 
 syntax, that
 doesn't necessarily bind it either.As long as your code can be 
 consideredit's own separate work (and is distributed separately), 
 then you're fine.
 On the flip side, if you have purely non-MySQL-specific 
 application code,
 but you distribute it bundled with MySQL, then you ARE bound by 
 the GPL,
 even though your app is totally independent of MySQL.
 
 Cheers,
 barneyb
 
  -Original Message-
  From: Vince Bonfanti [EMAIL PROTECTED] 
  Sent: Friday, February 06, 2004 8:06 AM
  To: CF-Talk
  Subject: RE: MySQL and CF
  
  Not to comment at all on its technical merits, anyone using 
  MySQL should be
  familiar with their licensing terms. Specifically, MySQL is 
  *not* free for
  commercial development. If you use MySQL for a commercial 
  product and don't
  purchase a commercial license, then you run the risk of 
 inadvertently releasing your source code for free.
  
  MySQL is released under GPL, unlike Linux, for example, which 
  is released
  under LGPL. Under the LGPL, if you write an application that 
  runs on Linux
  you can redistribute that application without releasing the 
  source code.
  Under the GPL, however, if you release an application that 
  runs on MySQL,
  then you must release the source code of your application.
  
  Here are the relevant quotes from the MySQL licensing page on 
  their web
  site:
  
 http://www.mysql.com/products/licensing.html
  
  Regarding their Open Source license, which is the GPL:
  
 The Open Source License allows you to use the software 
  at no charge
  under the condition that if you use MySQL in an application you
  redistribute, the complete source code for your application must be
  available and freely redistributable under reasonable conditions.
  
  If you don't want to release the source code of your 
  application, you must
  purchase a commercial license:
  
 The Commercial License, which allows you to provide 
  commercial software
  licenses to your customers or distribute MySQL-based 
  applications within
  your organization. This is for organizations that do not want 
  to release the
  source code for their applications as open source / free 
  software; in other
  words they do not want to comply with the GNU General Public 
  License (GPL).
  
  Note that it's not just the MySQL database that's covered under 
 these license terms--they also apply to the MySQL JDBC and ODBC 
  drivers. (This is
  the reason BlueDragon no longer ships the MySQL JDBC driver).
  
  So if you use MySQL--be careful. If you don't purchase a 
  commercial license,
  anyone can demand that you give them your source code under 
  the terms of the
  GPL license.
  
  Vince Bonfanti
  New Atlanta Communications, LLC
  http://www.newatlanta.com
  
  
  
  

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




Re: RE: MySQL and CF

2004-02-06 Thread Doug White
Not unless you distribute the MySQL database with your application.If the
client downloads and installs MySQL on their own server (or host, as the case
may be) then you do not have to have a license for code that addresses their own
database. At least not a license from MySQL.

==
Stop spam on your domain, Anti-spam solutions
http://www.clickdoug.com/mailfilter.cfm
For hosting solutions http://www.clickdoug.com
==
Aspire to Inspire before you Retire or Expire!

- Original Message - 
From: [EMAIL PROTECTED]
To: CF-Talk
Sent: Friday, February 06, 2004 11:59 AM
Subject: Re: RE: MySQL and CF

But if I create an application that uses mySQL for profit, I must obtain a
mySQL commercial license, correct?Or not?

- Original Message -
From: Barney Boisvert [EMAIL PROTECTED]
Date: Friday, February 6, 2004 10:39 am
Subject: RE: MySQL and CF

 It seems there's some disagreement about what the GPL means.
 MySQL is
 distributed under the GPL, so MySQL AB can't add any restrictions
 on use
 beyond what are already in the license.If you need to do things
 that the
 GPL doesn't let you (like distribute MySQL as part of a non-GPL
 softwarepackage, or distribute a modified version of MySQL under
 non-GPL license),
 then MySQL AB also provides commercial licenses for your use.

 In general, as long as you're not distributing software, the GPL
 is very
 thin on limitations.And even if you are distributing something
 that is
 based on or derived from MySQL, you're not limited to a GPL
 license for that
 software as long as it can be considered reasonably considered
 independentand separate works in themselves (from subsection 2 of
 the Terms section).

 Someone pointed out that as long as your app is not strictly bound to
 MySQL-specific syntax (LIMIT clause, for example), then you're
 safe from
 licensing restrictions.Even if your code uses MySQL-specific
 syntax, that
 doesn't necessarily bind it either.As long as your code can be
 consideredit's own separate work (and is distributed separately),
 then you're fine.
 On the flip side, if you have purely non-MySQL-specific
 application code,
 but you distribute it bundled with MySQL, then you ARE bound by
 the GPL,
 even though your app is totally independent of MySQL.

 Cheers,
 barneyb

  -Original Message-
  From: Vince Bonfanti [EMAIL PROTECTED]
  Sent: Friday, February 06, 2004 8:06 AM
  To: CF-Talk
  Subject: RE: MySQL and CF
 
  Not to comment at all on its technical merits, anyone using
  MySQL should be
  familiar with their licensing terms. Specifically, MySQL is
  *not* free for
  commercial development. If you use MySQL for a commercial
  product and don't
  purchase a commercial license, then you run the risk of
 inadvertently releasing your source code for free.
 
  MySQL is released under GPL, unlike Linux, for example, which
  is released
  under LGPL. Under the LGPL, if you write an application that
  runs on Linux
  you can redistribute that application without releasing the
  source code.
  Under the GPL, however, if you release an application that
  runs on MySQL,
  then you must release the source code of your application.
 
  Here are the relevant quotes from the MySQL licensing page on
  their web
  site:
 
 http://www.mysql.com/products/licensing.html
 
  Regarding their Open Source license, which is the GPL:
 
 The Open Source License allows you to use the software
  at no charge
  under the condition that if you use MySQL in an application you
  redistribute, the complete source code for your application must be
  available and freely redistributable under reasonable conditions.
 
  If you don't want to release the source code of your
  application, you must
  purchase a commercial license:
 
 The Commercial License, which allows you to provide
  commercial software
  licenses to your customers or distribute MySQL-based
  applications within
  your organization. This is for organizations that do not want
  to release the
  source code for their applications as open source / free
  software; in other
  words they do not want to comply with the GNU General Public
  License (GPL).
 
  Note that it's not just the MySQL database that's covered under
 these license terms--they also apply to the MySQL JDBC and ODBC
  drivers. (This is
  the reason BlueDragon no longer ships the MySQL JDBC driver).
 
  So if you use MySQL--be careful. If you don't purchase a
  commercial license,
  anyone can demand that you give them your source code under
  the terms of the
  GPL license.
 
  Vince Bonfanti
  New Atlanta Communications, LLC
  http://www.newatlanta.com
 
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: RE: MySQL and CF

2004-02-06 Thread Tom Kitta
You mean that you just created CFML application that uses mySQL as a backend
and sell that application, right? Then as long as you don't distribute mySQL
with it (for any small app 99% of cases you would not) I understand that GPL
does not require you to show your code to anyone you don't wish to show it
too. Also, same thing holds for websites that use mySQL as a backend.
Otherwise mySQL would be only useful for strictly non-commercial
applications and it would simply be useless to most people.

TK

[Tom Kitta]
 -Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, February 06, 2004 12:59 PM
To: CF-Talk
Subject: Re: RE: MySQL and CF

But if I create an application that uses mySQL for profit, I must obtain a
mySQL commercial license, correct?Or not?

- Original Message -
From: Barney Boisvert [EMAIL PROTECTED]
Date: Friday, February 6, 2004 10:39 am
Subject: RE: MySQL and CF

 It seems there's some disagreement about what the GPL means.
 MySQL is
 distributed under the GPL, so MySQL AB can't add any restrictions
 on use
 beyond what are already in the license.If you need to do things
 that the
 GPL doesn't let you (like distribute MySQL as part of a non-GPL
 softwarepackage, or distribute a modified version of MySQL under
 non-GPL license),
 then MySQL AB also provides commercial licenses for your use.

 In general, as long as you're not distributing software, the GPL
 is very
 thin on limitations.And even if you are distributing something
 that is
 based on or derived from MySQL, you're not limited to a GPL
 license for that
 software as long as it can be considered reasonably considered
 independentand separate works in themselves (from subsection 2 of
 the Terms section).

 Someone pointed out that as long as your app is not strictly bound to
 MySQL-specific syntax (LIMIT clause, for example), then you're
 safe from
 licensing restrictions.Even if your code uses MySQL-specific
 syntax, that
 doesn't necessarily bind it either.As long as your code can be
 consideredit's own separate work (and is distributed separately),
 then you're fine.
 On the flip side, if you have purely non-MySQL-specific
 application code,
 but you distribute it bundled with MySQL, then you ARE bound by
 the GPL,
 even though your app is totally independent of MySQL.

 Cheers,
 barneyb

  -Original Message-
  From: Vince Bonfanti [EMAIL PROTECTED]
  Sent: Friday, February 06, 2004 8:06 AM
  To: CF-Talk
  Subject: RE: MySQL and CF
 
  Not to comment at all on its technical merits, anyone using
  MySQL should be
  familiar with their licensing terms. Specifically, MySQL is
  *not* free for
  commercial development. If you use MySQL for a commercial
  product and don't
  purchase a commercial license, then you run the risk of
 inadvertently releasing your source code for free.
 
  MySQL is released under GPL, unlike Linux, for example, which
  is released
  under LGPL. Under the LGPL, if you write an application that
  runs on Linux
  you can redistribute that application without releasing the
  source code.
  Under the GPL, however, if you release an application that
  runs on MySQL,
  then you must release the source code of your application.
 
  Here are the relevant quotes from the MySQL licensing page on
  their web
  site:
 
 http://www.mysql.com/products/licensing.html
 
  Regarding their Open Source license, which is the GPL:
 
 The Open Source License allows you to use the software
  at no charge
  under the condition that if you use MySQL in an application you
  redistribute, the complete source code for your application must be
  available and freely redistributable under reasonable conditions.
 
  If you don't want to release the source code of your
  application, you must
  purchase a commercial license:
 
 The Commercial License, which allows you to provide
  commercial software
  licenses to your customers or distribute MySQL-based
  applications within
  your organization. This is for organizations that do not want
  to release the
  source code for their applications as open source / free
  software; in other
  words they do not want to comply with the GNU General Public
  License (GPL).
 
  Note that it's not just the MySQL database that's covered under
 these license terms--they also apply to the MySQL JDBC and ODBC
  drivers. (This is
  the reason BlueDragon no longer ships the MySQL JDBC driver).
 
  So if you use MySQL--be careful. If you don't purchase a
  commercial license,
  anyone can demand that you give them your source code under
  the terms of the
  GPL license.
 
  Vince Bonfanti
  New Atlanta Communications, LLC
  http://www.newatlanta.com
 
 
 
 

 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




RE: RE: MySQL and CF

2004-02-06 Thread Barney Boisvert
Only if you distribute MySQL as part of your application.

If the application runs on your server then you don't need a license.If
you distribute the application for clients to install on their servers, and
you require that they have MySQL installed to run you app, then it's kind of
grey, but I would say you probably DON'T need a license, especially if the
binding from your app to a MySQL database is minimal (no native function
libraries, etc).If you distribute an installer package that installs your
app and MySQL in one fell swoop, then you definitely need a commercial
license.

Note, I'm not a lawyer, just a code monkey.However, I'm quite confident my
interpretation is very close accurate.

 -Original Message-
 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
 Sent: Friday, February 06, 2004 9:59 AM
 To: CF-Talk
 Subject: Re: RE: MySQL and CF
 
 But if I create an application that uses mySQL for profit, I 
 must obtain a mySQL commercial license, correct?Or not?
 [Todays Threads] 
 [This Message] 
 [Subscription] 
 [Fast Unsubscribe] 
 [User Settings]




  1   2   >