RE: Lock the database?

[Paris Lundis]

Thanks Jay!

Going to try wrapping my code and see what happens :)

Love this list...  

I got smart a while back and wrote an error notification that dumps 
each error to email... works great for getting me moving on bug 
fixes... but some days I get swamped with those not so obvious bugs - 
this being one of them...

Will let you know my experience with the code...

-paris
[finding the future in the past, passing the future in the present]
[connecting people, places and things]


-Original Message-
From: "Jay Sudowski - Handy Networks LLC" <[EMAIL PROTECTED]>
Date: Mon, 06 Aug 2001 20:36:00 -0700
Subject: RE: Lock the database?

> Hi Paris,
> 
> I'd recommend using cftry / cfcatch.  Credit for the info below goes
> to
> Steve Nelson.  He's discussing his cf_max_id tag.  Hope this helps.
> 
> Jay
> 
> What about locking issues?  
> 
> Microsoft Access in particular may throw errors if you use this tag
> if
> simultaneous people try
> and create records at the same time, even if you use the
> cftransaction
> tag and/or the cflock tag.  If that is 
> happening, you should probably upgrade to SQL Server or another
> multi-user database engine.
> 
> But, in the mean time, let CF error handling fix this problem for
> you.
> (this is sooo slick :)
> 
> 
>   
>   
>  datasource="#application.mainDSN#"
>   tablename="users"
>   primarykey="userid">
> 
>datasource="#application.mainDSN#">
>   insert into
> users(userid,firstname,lastname,email)
>   
> values(#max_ID#,'#trim(attributes.firstname)#','#trim(attributes.last
> nam
> e)#','#attributes.email#')
>   
>   
> 
>   
>   
> 
>   
>   
> 
> -Original Message-
> From: Paris Lundis [mailto:[EMAIL PROTECTED]] 
> Sent: Monday, August 06, 2001 11:19 PM
> To: CF-Talk
> Subject: Lock the database?
> 
> 
> So I have some code that logs page information on every page and
> across 
> multiple servers...
> 
> The idea is to slap the data into Access and fold a database file a
> day 
> vs. the overhead and in box disk issues with SQL Server.. not to 
> mention cost...
> 
> Scenario
> 
> 2 users access a page... one on SERVER A the other on SERVER B...
> Same
> code .. same database (Access) in both and stored on a NAS storage 
> device...
> 
> Both folks go to the page at the same time...
> 
> 
>update dailyimpressions
>where record = #record#
> 
> 
> Now that work across a few million pages a month, but generate a few
> - 
> 50-100 errors a day of :
> 
> ODBC Error Code = S1000 (General error)
> [Microsoft][ODBC Microsoft Access Driver] Could not update; currently
> locked by user 'adm' on machine 'CRAPO1'.
> 
> 
> SQL = "insert into dailyimpressions ETC.
> 
> WHat would any of you recommend to lock the database call /reduce 
> errors spun out?
> 
> Interested in hearing everyone's input... Locks.. ehh...
> 
> -paris
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Locked Database

[Tony Gruen]

of course, there is always the option of taking a little performance hit and
setting the DSN up to not maintain the DB connection.

Tony Gruen

-Original Message-
From: CFHelp [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 7:12 PM
To: CF-Talk
Subject: Locked Database


Is there some code I can put into a page to unlock an access database?


Rick Eidson
Owner
http://www.kchost.net/
KChost is getting ready to launch it's enews service
Now you can moderate your own affordable newsletter
Promote you products and services even sell advertising. Plans start at
$5 a month for 500 emails. FREE Trial account.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Locked Database

[Todd Ashworth]

> I'd have to think that Disable Database Connections would also be
> immediate (but I'm honestly not sure). And while it may be more
> intrusive then momentarily unlocking the database with a bad query, if
> Rick's site is popular, disabling database connections to the db may be
> the only way to go because other users may relock the database before he
> can initiate / complete his upload.  Similarly, if users try to query
> his database while he's uploading the database, they will receive an
> error.
...
> - Jay

ack .. I lapsed into the mindset of a database that doesn't need uploading
to update the DB structure.  My bad :(

Todd

>
> -Original Message-
> From: Todd Ashworth [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 11:05 PM
> To: CF-Talk
> Subject: Re: Locked Database
>
>
> > Usually sending a bad query to the data source will break the lock.
> > You can also set "disable database connections" in the CF
> > Administrator.  If you disable db connections, make sure you enable
> > them again, otherwise your site won't work :-)
>
> The bogus query is a better option .. it is less intrusive and more
> immediate than the "disable database connections" one.  The other method
> I was refering to in my last post is the CFusion_DBConnections_Flush()
> function.  That tends to break all DB connections without having to
> change anything on the CF server.  To use it, set some temp variable to
the function .. .eg:  
>
> Todd
>
> > Jay Sudowski
> > -
> > Handy Networks LLC
> > TEL: 877-70-HANDY
> > FAX: 888-300-2FAX
> > URL: www.handynetworks.com 
> > -
> > Providing reseller and dedicated Windows 2000 web hosting solutions.
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Lock the database?

[Jay Sudowski - Handy Networks LLC]

Hi Paris,

I'd recommend using cftry / cfcatch.  Credit for the info below goes to
Steve Nelson.  He's discussing his cf_max_id tag.  Hope this helps.

Jay

What about locking issues?  

Microsoft Access in particular may throw errors if you use this tag if
simultaneous people try
and create records at the same time, even if you use the cftransaction
tag and/or the cflock tag.  If that is 
happening, you should probably upgrade to SQL Server or another
multi-user database engine.

But, in the mean time, let CF error handling fix this problem for you.
(this is sooo slick :)





  

insert into
users(userid,firstname,lastname,email)

values(#max_ID#,'#trim(attributes.firstname)#','#trim(attributes.lastnam
e)#','#attributes.email#')









-Original Message-
From: Paris Lundis [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 06, 2001 11:19 PM
To: CF-Talk
Subject: Lock the database?


So I have some code that logs page information on every page and across 
multiple servers...

The idea is to slap the data into Access and fold a database file a day 
vs. the overhead and in box disk issues with SQL Server.. not to 
mention cost...

Scenario

2 users access a page... one on SERVER A the other on SERVER B... Same
code .. same database (Access) in both and stored on a NAS storage 
device...

Both folks go to the page at the same time...


   update dailyimpressions
   where record = #record#


Now that work across a few million pages a month, but generate a few - 
50-100 errors a day of :

ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Could not update; currently 
locked by user 'adm' on machine 'CRAPO1'.


SQL = "insert into dailyimpressions ETC.

WHat would any of you recommend to lock the database call /reduce 
errors spun out?

Interested in hearing everyone's input... Locks.. ehh...

-paris
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Lock the database?

[Paris Lundis]

So I have some code that logs page information on every page and across 
multiple servers...

The idea is to slap the data into Access and fold a database file a day 
vs. the overhead and in box disk issues with SQL Server.. not to 
mention cost...

Scenario

2 users access a page... one on SERVER A the other on SERVER B...
Same code .. same database (Access) in both and stored on a NAS storage 
device...

Both folks go to the page at the same time...


   update dailyimpressions
   where record = #record#


Now that work across a few million pages a month, but generate a few - 
50-100 errors a day of :

ODBC Error Code = S1000 (General error)
[Microsoft][ODBC Microsoft Access Driver] Could not update; currently 
locked by user 'adm' on machine 'CRAPO1'.


SQL = "insert into dailyimpressions ETC.

WHat would any of you recommend to lock the database call /reduce 
errors spun out?

Interested in hearing everyone's input... Locks.. ehh...

-paris



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Locked Database

[Jay Sudowski - Handy Networks LLC]

I'd have to think that Disable Database Connections would also be
immediate (but I'm honestly not sure). And while it may be more
intrusive then momentarily unlocking the database with a bad query, if
Rick's site is popular, disabling database connections to the db may be
the only way to go because other users may relock the database before he
can initiate / complete his upload.  Similarly, if users try to query
his database while he's uploading the database, they will receive an
error.  I'd also think that it would be very possible some sort of
corruption or instability to seep into the file he's uploading if
ColdFusion tried to repeatedly open a connection to the database before
the upload has been completed.

- Jay

-Original Message-
From: Todd Ashworth [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 06, 2001 11:05 PM
To: CF-Talk
Subject: Re: Locked Database


> Usually sending a bad query to the data source will break the lock.  
> You can also set "disable database connections" in the CF 
> Administrator.  If you disable db connections, make sure you enable 
> them again, otherwise your site won't work :-)

The bogus query is a better option .. it is less intrusive and more
immediate than the "disable database connections" one.  The other method
I was refering to in my last post is the CFusion_DBConnections_Flush()
function.  That tends to break all DB connections without having to
change anything on the CF server.  To use it, set some temp variable to the function 
.. .eg:  

Todd

> Jay Sudowski
> -
> Handy Networks LLC
> TEL: 877-70-HANDY
> FAX: 888-300-2FAX
> URL: www.handynetworks.com 
> -
> Providing reseller and dedicated Windows 2000 web hosting solutions.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Subject: RE: I dont understand session locking :(

[Reed Powell]

Matthew, I love that shotgun analogy!  Let me take a stab at this issue.

Since session variables are, by their very nature, session-specific, under
normal circumstances there will never be any contention between sessions for
the same variable, either reading or writing.  Not "never," just "almost
never."  One example would be when an anxious user starts stabbing at a
SUBMIT key (the timing gets a little close in this case), or (better case)
an HREF link to a page that starts something up in another window and that
same anxious user.

Here's how it's been explained to me in the past:

But that's not the reason for the locking.  I can have an app where I know
for 100% certain that there can never be two sessions at the same time, and
I still need to lock the session vars.  The reason is that I'm not only
alerting the other CF application pages to stay away (Matthew's Do Not
Disturb sign), I'm also telling the CF server's memory manager to stay away.
Matthew's shotgun isn't always in the hands of the other CF application
level pages - it's also in the hands of the CFSERVER itself, when it
performs memory management for all the session vars of all the users of all
the apps on that particular server.  When it needs to start doing memory
management tasks (ie, blasting away with the shotgun) then that room had
better be real empty. You'll probably get lucky most of the time, but sooner
or later it's going to be your session var that CF was moving around to make
room for someone else's "session.structuredarrayfromhell" variable, and
wham! Someone is going to get corrupted.  If CFSERVER had to check on each
and every reference to a variable throughout your app, just to see if it was
a session var (which is what it tries to do when you turn on the "automatic"
locking) then the performance would go straight down the tubes.  But, since
it is pretty likely that you will be referencing more than one session var
within a close proximity of code, then YOU know better as to where to put
the read or exclusive lock to get the best performance.  Remember, there's
overhead with setting up and tearing down the lock itself, as well as the
performance hit on forcing certain parts of the code to become
single-threaded.  You cannot do much about the latter, but you can reduce
the overhead for the actual locking/unlocking process by using intelligent
locks, rather than letting CF "automatically" put a lock around each
discrete session variable reference. In fact, I'd be willing to bet that
this would generate two "automatic" locks:



I don't know how much the CF memory management is changing with the changes
that are going on with the underlying engine.  I'd love to see some comments
on this from the Allaire crowd, talking at the system level, instead of just
the application programming level.

-reed

FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF 5.0 Enterprise Server install problems

[Neil H.]

Yes CF 4.5 works ok.  It just runs and runs. It being Ikernel.exe.  I have
stopped all non essential services.  I have too much that can't be replaced
like verity collections, custom tags and some login information for SQL
server DSN's.

Thanks,

Neil

- Original Message -
From: "Mike Brunt" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 4:35 PM
Subject: RE: CF 5.0 Enterprise Server install problems


> Is CF4.5 still running ok after the aborted install of CF5.0.
>
> Kind Regards - Mike Brunt, EmbeeMedia
> Tel: 562.790.8631
> http://www.embeemedia.com
> Instant Messaging Handles: -
> AIM (AOL): MediaEmbee
> MSN: [EMAIL PROTECTED]
> Yahoo: MediaEmbeeYH
>
> -Original Message-
> From: Neil H. [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 1:17 PM
> To: CF-Talk
> Subject: Re: CF 5.0 Enterprise Server install problems
>
> Reinstalling isn't an option.  Any other ideas what I can do to upgrade
this
> to 5.0?
>
> Thanks,
>
> Neil
>
> - Original Message -
> From: "Neil H." <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Sunday, July 29, 2001 2:31 PM
> Subject: CF 5.0 Enterprise Server install problems
>
>
> > When attempting to install CF 5.0 nothing happens!  Let me explain: It
> does
> >  mention that CF 4.5 is installed and that it will be upgraded.  That is
> >  fine. But then nothing.  I watch Ikernel.exe, which is Install Shield,
> just
> >  consume memory.  The only way to kill it is to end the task in task
> > manager.
> >  Once I do that I receive an error about the RPC service is unavailable.
> > The
> >  RPC service is running so I don't know what is happening.  I manually
> >  stopped CF executive and application server in addition to site minder.
> >  This made no difference.  If anyone has any ideas they would be
> > appreciated.
> >
> >  Thanks,
> >
> >  Neil
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Locked Database

[Todd Ashworth]

> Usually sending a bad query to the data source will break the lock.  You
> can also set "disable database connections" in the CF Administrator.  If
> you disable db connections, make sure you enable them again, otherwise
> your site won't work :-)

The bogus query is a better option .. it is less intrusive and more
immediate than the "disable database connections" one.  The other method I
was refering to in my last post is the CFusion_DBConnections_Flush()
function.  That tends to break all DB connections without having to change
anything on the CF server.  To use it, set some temp variable = to the
function .. .eg:  

Todd

> Jay Sudowski
> -
> Handy Networks LLC
> TEL: 877-70-HANDY
> FAX: 888-300-2FAX
> URL: www.handynetworks.com 
> -
> Providing reseller and dedicated Windows 2000 web hosting solutions.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Locked Database

[Jay Sudowski - Handy Networks LLC]

Hi -

Usually sending a bad query to the data source will break the lock.  You
can also set "disable database connections" in the CF Administrator.  If
you disable db connections, make sure you enable them again, otherwise
your site won't work :-)

Jay Sudowski
-
Handy Networks LLC
TEL: 877-70-HANDY
FAX: 888-300-2FAX
URL: www.handynetworks.com  
-
Providing reseller and dedicated Windows 2000 web hosting solutions.


-Original Message-
From: CFHelp [mailto:[EMAIL PROTECTED]] 
Sent: Monday, August 06, 2001 10:12 PM
To: CF-Talk
Subject: Locked Database


Is there some code I can put into a page to unlock an access database?
 
  
Rick Eidson
Owner
http://www.kchost.net/
KChost is getting ready to launch it's enews service
Now you can moderate your own affordable newsletter
Promote you products and services even sell advertising. Plans start at
$5 a month for 500 emails. FREE Trial account.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Locked Database

[Todd Ashworth]

The simplest way is to make a bogus call to the database that will
definately produce an error (such as a call to a table or column that
doesn't exist).  That will cause the Access engine to drop connections to
the database and will unlock it.  There is a way that works for databases
besides Access, but that should do what you want :)

Todd

- Original Message -
From: "CFHelp" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 10:11 PM
Subject: Locked Database


> Is there some code I can put into a page to unlock an access database?
>
>
> Rick Eidson
> Owner
> http://www.kchost.net/
> KChost is getting ready to launch it's enews service
> Now you can moderate your own affordable newsletter
> Promote you products and services even sell advertising. Plans start at
> $5 a month for 500 emails. FREE Trial account.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Locked Database

[CFHelp]

Is there some code I can put into a page to unlock an access database?
 
  
Rick Eidson
Owner
http://www.kchost.net/
KChost is getting ready to launch it's enews service
Now you can moderate your own affordable newsletter
Promote you products and services even sell advertising. Plans start at
$5 a month for 500 emails. FREE Trial account.
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFMAIL and MS SMTP

[Christopher Olive, CIO]

we use IIS's SMTP extensively with CFMAIL.

do you have IIS set to allow the CF machine to relay?  it's a common error,
and one that most security minded folks ignore, since they turn it off by
default.

chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com



-Original Message-
From: Cameron Childress [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 3:57 PM
To: CF-Talk
Subject: CFMAIL and MS SMTP


I'm attempting to send mail from CF to IIS4's SMTP service.  For some reason
it doesn't look like it's accepting the mail.  CF spools it fine, and the
cfusion/logs/mail.log file doesn't report any errors.
cfusion/logs/sentmail.log reports that the message was sent correctly.  The
message does not end up in cfusion/mail/undeliverd.

The SMTP service's logs report the following:

19:32:15 130.205.XXX.XXX MAIL FROM - 250
19:32:15 130.205.XXX.XXX RCPT TO - 250
19:32:15 130.205.XXX.XXX QUIT - 0

It looks like the data is being sent to the SMTP service, but then the
message just vanishes into thin air!  It's not in the queue directory or the
badmail directory or any other directory in the SMTP service's root.  It
also doesn't get received by the recipient, and a review of the mail server
it's addressed to reveals that MS SMTP didn't even try to open a connection
to it.

Has anyone else seen anything like this?  Anyone else use the MS SMTP
service for outgoing mail?

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: I dont understand session locking :(

[Todd Ashworth]

> i know why, but i dont know why!  Why won't CF just lock it all the time
> automatically

You can set up automatic read locking in CF Admin, though I *think* it gives
you less control on a line by line level if you need it =-/

>  who would want shared data with sessions when they can already use an
application variable for that.

They shouldn't as long as the data isn't dependant upon who is accessing it.
Application variables are application wide, meaning all users see the same
info.  Session variables are user speciffic, meaning each user can have some
different data, but it's still a shared memory variable.  They both exist
for a reason :)

> Also I dont understand nested
> lockings and how it works.  All I usually end up doing is putting a
Session
> lock around every session variable I see.  or if the session is used in a
> CFIF tag, i put the lock around that CFIF tag (not the closing CFIF tag).
> Or if there are a bunch of session variavles being read/written to, i put
a
> session lock over them.  heck, why not just surround the whole page with
one

This might be a 'broad' explanation of why this is bad, but here ya go:  If
you wrap a lock around a section of code, that code can become
single-threaded .. meaning that only one person can have access to that code
at one time.  If you wrap an entire page with a lock, then it potentially
can't be executed by more than 1 person at a time.  This can be a serious
performance issue, as I'm sure you can see.  That's why it's important only
to lock the section of code you absolutely need to.  I might be way off, but
that's just how I've always thought of it .. why lock more than you have to?

Say you have 10 Session variables and 9 are read from and one is written to.
A read lock will allow several people to read from that variable at once,
but prevents someone from writing to it until all the reads are done.
Exclusively locking a variable will not let anyone access the variable in
any way as long as there is one person accessing that variable.  I doesn't
make much sense to exclusively lock all 10 variables when you only have to
do one.  This might cause some serious performance hits if that page is at
all popular.

In the case where you have a bunch of Session variables that are being read
and written to all in a short period of time, you will have to use your best
judgement as to when to locks groups of code, or individual lines.  There is
a performance hit to grouping entire blocks of code in a lock, but there is
also one to making a lock, letting it go, and then recreating a new one
repetatively.

I've only made a very generalised explanation, and I'm probably not 100%
accurate in a few places, but you should get a basic answer to your
questions from it :)

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: I don't understand session locking :(

[Todd Ashworth]

> 
>
> Are you saying I need to place a lock around the  tag?

Yep.

Simple rule .. you should always lock a session variable whenever it is
used. :)  For this reason, I prefer and reccomend, Client variables (stored
in a database), but if you have an app where perfomance isn't a major issue,
and you don't plan on ever having to move it to a clustered environment,
then Session variables will be fine.

Todd

- Original Message -
From: "Bruce, Rodney" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 6:59 PM
Subject: RE: I don't understand session locking :(


> Question here as well
>
> I have done locks when ever I set a Session var.
> Do I have to use a lock  when ever I use the var?
> i.e:
>
> 
> 
> 
>
>
> 
>
> Are you saying I need to place a lock around the  tag?




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I don't understand session locking :(

[Dave Watts]

> I have done locks when ever I set a Session var.
> Do I have to use a lock  when ever I use the var?
> i.e:
> 
>   
>   
>   
> 
> 
> 
> 
> Are you saying I need to place a lock around the  tag?

Yes, you need to place a lock around any reads or writes of Session
variables. If you don't lock reads as well as writes, and there's any
possibility of the two operations happening simultaneously (and there
usually is), then the lock you put on the write is useless by itself.

Locking in CF (and in databases as well) is essentially a cooperative
venture. Placing one lock on one piece of code doesn't do any good if
another piece of code accesses the resource without a lock.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Is the "Authenticate User" query in Advanced Security User Directory dialog correct?

[Lawrence B. Afrin, M.D.]

Howdy --

Taking my first stab at an Advanced Security config using CF5, have got
it working except for one nagging little problem:

Scenario (all names changed to protect the innocent ;-) :

In the "Users" User Directory (implemented in SQL Server, accessed via
ODBC), I have defined two groups, "Database Users" and "Database
Administrators".  Also have defined two users, "Ulysses User" and "Andy
Admin", the former belonging to the "Database Users" group and the
latter belonging to the "Database Administrators" group.

(P.S.  I've used SQL Server's Query Analyzer to look at the SmUser,
SmGroup, and SmUserGroup tables to verify these entries.)

Security Context #1: "Database"
User Directory "Users"
Only Applications protected
One policy, both "Database Users" and "Database Administrators" allowed
to execute applications.

Security Context #2: "DatabaseAdmin"
User Directory "Users"
Only Applications protected
One policy, only "Database Administrators" allowed to execute
applications.

The Application.cfm that oversees the routine "Database" .cfm's starts
like this (copied straight out of the CF5 docs):




  

  
  



  

and it works just fine, allowing both Users and Administrators to access
the other .cfm's in the same directory.

In another directory I've got another Application.cfm that oversees the
.cfm's only the Admins should get to, and it's essentially identical to
the first Application.cfm except the cfapplication specifies
name="DatabaseAdmin", and in the cfauthenticate tag the securityContext
is specified as "DatabaseAdmin".

The Problem: When I call up admin pages, cfauthenticate in the admin
Application.cfm is authenticating users in both the Database Users as
well as the Database Administrators group, when the policy for the
DatabaseAdmin security context clearly says to allow only those users in
the Database Administrators group.  In other words, Ulysses User is
(inappropriately) getting access to the admin directory.

The only reason I can figure out this is happening is that, in the User
Directory listing for "Users", the "Authenticate User" query is a simple

select Name from SmUser where Name = '%s' and Password = '%s'

(This is the default query.)

In fact, I (think I) verified that this is the problem by changing the
DatabaseAdmin policy for Application protection.  I removed "Database
Administrators" from the list of allowed users and added just "Andy
Admin".  Then I tried again calling up one of the pages in the admin
directory, and when the login form came up, I again tested using
"Ulysses User" as the userid.  Darnit, Ulysses User was authenticated,
even though the policy says to only allow Andy Admin in.

(P.S. Yes, I made sure to flush the Authentication and Authorization
caches in between policy changes and testing attempts.)

If the above SQL is truly all that's required to authenticate a user,
it's clearly inadequate.  It's not valid to authenticate a user simply
by seeing whether the username (with appropriate password) exists in the
User Directory.  Authentication has to take into account group
membership.  That is, cfauthenticate should first run the "Authenticate
User" query and *then*, if the submitted userid isn't explicitly listed
in the list of allowed users for the specified securitycontext, it needs
to go through each of the *groups* that're in the list of allowed users
and execute the "Is Group Member" SQL for each of those groups.  If any
of *those* queries comes back with a hit, *then* the user is
authenticated, otherwise the user is rejected.

But that doesn't seem to be what cfauthenticate/Advanced Security is
doing.  All it seems to be doing is a simple lookup in SmUser, and if
you're listed there, congratulations, you're in.

I seriously doubt CF5 would have been allowed out the door with a flaw
as basic as this in it.  Therefore, I must be missing something, but I
sure can't figure out what.

If anybody (1) has made it this far through this ridiculously long
message, and (2) knows what I'm missing, and (3) cares to help, I sure
would appreciate it

-- Larry Afrin
   Med. Univ. of S.C.
   [EMAIL PROTECTED]



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I don't understand session locking :(

[Bruce, Rodney]

Question here as well

I have done locks when ever I set a Session var.
Do I have to use a lock  when ever I use the var?
i.e:








Are you saying I need to place a lock around the  tag?



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion Developer - beginner

[Schlosser, JoAnn]

Check with Advanced Solutions in Austin.  They are the leaders in
Association Management software and their web interface is written in Cold
Fusion.  

JoAnn A. Schlosser
Consultant
Association Management Software
Grant Thornton LLP
Washington, D. C.
703.837.4428



-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 6:48 PM
To: CF-Talk
Subject: Cold Fusion Developer - beginner



Hello,

Does anyone know of any open Cold Fusion positions
available in the Austin TX or Houston TX area
requiring about 1 year of experience?

Thanks!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Cold Fusion Developer - beginner

[Rich Tretola]

I am looking for some work in the Rochester, NY area as well.
1 1/2 years CF experience.
Thanks,
Rich

-Original Message-
From: Amanda Stern [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 6:48 PM
To: CF-Talk
Subject: Cold Fusion Developer - beginner



Hello,

Does anyone know of any open Cold Fusion positions
available in the Austin TX or Houston TX area
requiring about 1 year of experience?

Thanks!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Cold Fusion Developer - beginner

[Amanda Stern]

Hello,

Does anyone know of any open Cold Fusion positions
available in the Austin TX or Houston TX area
requiring about 1 year of experience?

Thanks!
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: I dont understand session locking :(

[Matthew W Jones]

The following is a great analogy that was previously posted by Peter
Theobald 

"Alot of people are making this incorrect assumption.
Let me give an analogy that should make it easier to remember:

Cold Fusion's Advisory Locking, or "Shotguns in a dark room"

---

Imagine a big dark room. It is so dark that you cannot see anything in it at
all.
Your resource, an important bit of information, is in the room.

When you want to read the information, you hand a "Do Not Disturb" sign on
the door 
handle and go in to feel around and get a copy of the information.  It did
not take 
you very long to hang up the "Do Not Disturb" sign so your read was not
delayed very 
much by "read locking".

When you want to write the information you load the information up into your
trusty 
shotgun (along with a few rounds of buckshot), open the door to the dark
room and 
start blasting away. However, if there is a "Do Not Disturb" sign on the
door OF 
COURSE you cannot start shooting because there is someone in the room. You,
as writer, 
will have to wait until the "Do Not Disturb" sign is taken off the door. If
there are 
multiple "Do Not Disturb" signs on the door you will have to wait until
everyone comes 
out of the room and takes their "Do Not Disturb" signs. Your write is
potentially 
delayed by "write locking" or "exclusive locking".

Now imaging someone wants to read the information. They just need to get it
really 
quickly and don't bother to hang a "Do Not Disturb" sign because they are
only reading 
the information and will be really quick anyway.
Chances are no one will come by with a shotgun, and if they do they will
take a while 
to load it up. But if you take this chance sooner or later someone's gonna
get shot!"

-Original Message-
From: Fuon See Tu [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 4:40 PM
To: CF-Talk
Subject: I dont understand session locking :(


i know why, but i dont know why!  Why won't CF just lock it all the time 
automatically who would want shared data with sessions when they can already

use an application variable for that.  Also I dont understand nested 
lockings and how it works.  All I usually end up doing is putting a Session 
lock around every session variable I see.  or if the session is used in a 
CFIF tag, i put the lock around that CFIF tag (not the closing CFIF tag).  
Or if there are a bunch of session variavles being read/written to, i put a 
session lock over them.  heck, why not just surround the whole page with one

session lock?  can someone help me grasp the concept of a session lock 
please?

:)
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Zip Code - Address Object

[Ken Monroe]

Hello!

Has anyone worked with the "Address Object" from MelissaData.com?  I'm
having problems calling the object methods, although it seems to be
initialized fine...

Thx


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Any horror stories from not locking session vars?

[Kelly Matthews]

hahahahahhahaha my cats don't seem to mind they have a limited vocabulary
too! :)

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 5:24 PM
To: CF-Talk
Subject: RE: Any horror stories from not locking session vars?


At 04:44 PM 8/6/2001 -0400, you wrote:
>LOCK LOCK LOCK is all i can say!

Must make dinner conversations very repetitive.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Any horror stories from not locking session vars?

[Matt Robertson]

Allaire article from the Reference Desk entitled ColdFusion Locking Best Practices:

http://www.allaire.com/handlers/index.cfm?id=17318&method=full

>From the CF instruction manual:

http://www.allaire.com/cfdocs/Administering_ColdFusion_Server/03_Configuring_ColdFusion_Server/admin0312.htm#1059602

ColdFusion Locking by Ben Forta:

http://www.allaire.com/handlers/index.cfm?ID=17196&Method=Full&Title=Locking%20in%20ColdFusion&Cache=False

Those are the Big Three on the subject that are found at the Allaire site.

Cheers,

--Matt--

 
 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: anyone else had this problem?

[Philip Arnold - ASP]

> Sorry for this being off topic, but I am sure someone here will
> know what's causing this ..
>
> I'm getting a spam message coming in.   No problem, I can handle that,
> except every time I check my mail with MS Outlook2000 there are
> 10 identical
> copies of it there.  Leave it for 10 minutes, there are 10 copies of this
> email there.   Check in 4 minutes,  10 copies.  Check in an hour,
> 10 copies. For a long time I thought this was a spammer with a virus of
> some kind, but the fact that there's always 10 emails there, not hundreds
> or a few, leads me to think that perhaps I've got a problem with Outlook.
>
> On the other hand, if I had a virus or something in my Outlook, I'd have
> thought this would be happening with dozens of messages, not just one.
>
> I've updated my McAfee and scanned my system and it hasn't thrown up
> anything of interest.
>
> Has anyone else experienced this problem? Can you give me
> some clues as to where to look?
>
> I've already followed up the obvious things like tracing the origin of the
> message through the headers, but if the problem is my end that won't show
> anything.

I had a similar issue with my CF-Talk messages (thus not a virus), check
your Rules Wizard to make sure you're not making dupes of the message by
having it move the message several times under different rules - if needs
be, turn all of your rules off and then re-introduce them one by one

It took ages for me to track down the problem, but eventually found that it
was Outlook 2000 and it's Organise option which caused my heart-ache

HTH

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

I dont understand session locking :(

[Fuon See Tu]

i know why, but i dont know why!  Why won't CF just lock it all the time 
automatically who would want shared data with sessions when they can already 
use an application variable for that.  Also I dont understand nested 
lockings and how it works.  All I usually end up doing is putting a Session 
lock around every session variable I see.  or if the session is used in a 
CFIF tag, i put the lock around that CFIF tag (not the closing CFIF tag).  
Or if there are a bunch of session variavles being read/written to, i put a 
session lock over them.  heck, why not just surround the whole page with one 
session lock?  can someone help me grasp the concept of a session lock 
please?

:)
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Dave Watts]

> > You can use the classic "ATM machine" example typically used to 
> > explain concurrency and basic transactional logic.
> 
> Is that the one where the client spends all his time at the ATM
> withdrawing money to pay you to fix the site?  ;-)

If that example works well enough to convince the client to use locking,
then yes.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Jeff Beer]

> You can
> use the classic "ATM machine" example typically used to 
> explain concurrency
> and basic transactional logic.


Is that the one where the client spends all his time at the ATM
withdrawing money to pay you to fix the site?  ;-)

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Braver, Ben]

Zac - 
LOL
and would the appropriate breakfast be "Locks" and bagels 
-Ben

-Original Message-
From: Zac Belado [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 2:24 PM
To: CF-Talk
Subject: RE: Any horror stories from not locking session vars?


At 04:44 PM 8/6/2001 -0400, you wrote:
>LOCK LOCK LOCK is all i can say!

Must make dinner conversations very repetitive.
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Zac Belado]

At 04:44 PM 8/6/2001 -0400, you wrote:
>LOCK LOCK LOCK is all i can say!

Must make dinner conversations very repetitive.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Alex]

yes

On Mon, 6 Aug 2001, Yager, Brian T Contractor/NCCIM wrote:

> So, what you are saying is put a lock around ALL thing reguarding Session
> variables (Read, write, etc)?
> 
> -Original Message-
> From: Dave Watts [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 3:44 PM
> To: CF-Talk
> Subject: RE: Any horror stories from not locking session vars?
> 
> 
> > I have been asked to do a code review of a site and I have 
> > found that the developers don't bother to lock session variables 
> > when then read or write them. Does anybody have an good horror 
> > stories about the dangers of doing this so I legitimately show 
> > the customer why this is a problem. He is a nontechnical person 
> > so any talk of needing to single-thread processes when using 
> > shared variables won't mean a thing to him. Since I always lock 
> > around the variables I can't give him any personal horror stories. 
> > Perhaps some of you have heard of some (I KNOW they won't come 
> > from YOUR sites because you always follow best practices ;-) but 
> > maybe you inherited some.)
> 
> As someone who spends a lot of time reviewing the applications of others, I
> can tell you that I've seen several occurrences where the omission of proper
> locking of session variables caused applications to fail under load. For the
> most part, NDAs prevent disclosure of further detail, but if your client
> wants to pay someone like me lawyers' rates to fix an application after a
> failed deployment, rather than having it done right the first time, that's
> fine by me.
> 
> However, just because he's a non-technical person, you should be able to
> explain the basic problem to him enough for him to understand it. You can
> use the classic "ATM machine" example typically used to explain concurrency
> and basic transactional logic.
> 
> Dave Watts, CTO, Fig Leaf Software
> http://www.figleaf.com/
> voice: (202) 797-5496
> fax: (202) 797-5444
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

OT:Backup Policies and Disaster Recovery

[Daryl Fullerton]

Hi all,

Sorry for the OT post.

Anyone got any good URL's that deal with Backups and Disaster Recovery
for Data centres and in particular CF focused data centres.

We are upgrading all our procedures and policies at the moment and i am
seeking info or white papers on this matter.

Cheers

D

Daryl Fullerton,
Managing Partner,
BizNet Solutions,
Allaire Premier Partner (Ireland)
133 - 137 Lisburn Road
Belfast
BT9 7AG
N.Ireland

Direct +44 (0) 28 9022 7888
Tel  +44 (0) 028 9022 3224
Fax +44 (0) 028 9022 3223


[EMAIL PROTECTED]
Http://www.BizNet-Solutions.com

[EMAIL PROTECTED] (Chairman)
Http://www.cfug.ie The Irish Cold Fusion User Group

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Dave Watts]

> So, what you are saying is put a lock around ALL thing 
> regarding Session variables (Read, write, etc)?

Yes, that's what you want to do.

Very often, if you don't do this, an application will work fine during the
limited testing that happens during development, but once it's put under
load, it will fail almost immediately.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Kelly Matthews]

LOCK LOCK LOCK is all i can say! 

-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:11 AM
To: CF-Talk
Subject: Any horror stories from not locking session vars?


I have been asked to do a code review of a site and I have found that the
developers don't bother to lock session variables when then read or write
them. Does anybody have an good horror stories about the dangers of doing
this so I legitimately show the customer why this is a problem.  He is a
nontechnical person so any talk of needing to single-thread processes when
using shared variables won't mean a thing to him. Since I always lock around
the variables I can't give him any personal horror stories. Perhaps some of
you have heard of some (I KNOW they won't come from YOUR sites because you
always follow best practices ;-) but maybe you inherited some.)

TIA

Don
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Yager, Brian T Contractor/NCCIM]

So, what you are saying is put a lock around ALL thing reguarding Session
variables (Read, write, etc)?

-Original Message-
From: Dave Watts [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 3:44 PM
To: CF-Talk
Subject: RE: Any horror stories from not locking session vars?


> I have been asked to do a code review of a site and I have 
> found that the developers don't bother to lock session variables 
> when then read or write them. Does anybody have an good horror 
> stories about the dangers of doing this so I legitimately show 
> the customer why this is a problem. He is a nontechnical person 
> so any talk of needing to single-thread processes when using 
> shared variables won't mean a thing to him. Since I always lock 
> around the variables I can't give him any personal horror stories. 
> Perhaps some of you have heard of some (I KNOW they won't come 
> from YOUR sites because you always follow best practices ;-) but 
> maybe you inherited some.)

As someone who spends a lot of time reviewing the applications of others, I
can tell you that I've seen several occurrences where the omission of proper
locking of session variables caused applications to fail under load. For the
most part, NDAs prevent disclosure of further detail, but if your client
wants to pay someone like me lawyers' rates to fix an application after a
failed deployment, rather than having it done right the first time, that's
fine by me.

However, just because he's a non-technical person, you should be able to
explain the basic problem to him enough for him to understand it. You can
use the classic "ATM machine" example typically used to explain concurrency
and basic transactional logic.

Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Dave Watts]

> I have been asked to do a code review of a site and I have 
> found that the developers don't bother to lock session variables 
> when then read or write them. Does anybody have an good horror 
> stories about the dangers of doing this so I legitimately show 
> the customer why this is a problem. He is a nontechnical person 
> so any talk of needing to single-thread processes when using 
> shared variables won't mean a thing to him. Since I always lock 
> around the variables I can't give him any personal horror stories. 
> Perhaps some of you have heard of some (I KNOW they won't come 
> from YOUR sites because you always follow best practices ;-) but 
> maybe you inherited some.)

As someone who spends a lot of time reviewing the applications of others, I
can tell you that I've seen several occurrences where the omission of proper
locking of session variables caused applications to fail under load. For the
most part, NDAs prevent disclosure of further detail, but if your client
wants to pay someone like me lawyers' rates to fix an application after a
failed deployment, rather than having it done right the first time, that's
fine by me.

However, just because he's a non-technical person, you should be able to
explain the basic problem to him enough for him to understand it. You can
use the classic "ATM machine" example typically used to explain concurrency
and basic transactional logic.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CF 5.0 Enterprise Server install problems

[Mike Brunt]

Is CF4.5 still running ok after the aborted install of CF5.0.

Kind Regards - Mike Brunt, EmbeeMedia
Tel: 562.790.8631
http://www.embeemedia.com
Instant Messaging Handles: -
AIM (AOL): MediaEmbee
MSN: [EMAIL PROTECTED]
Yahoo: MediaEmbeeYH

-Original Message-
From: Neil H. [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 1:17 PM
To: CF-Talk
Subject: Re: CF 5.0 Enterprise Server install problems

Reinstalling isn't an option.  Any other ideas what I can do to upgrade this
to 5.0?

Thanks,

Neil

- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, July 29, 2001 2:31 PM
Subject: CF 5.0 Enterprise Server install problems


> When attempting to install CF 5.0 nothing happens!  Let me explain: It
does
>  mention that CF 4.5 is installed and that it will be upgraded.  That is
>  fine. But then nothing.  I watch Ikernel.exe, which is Install Shield,
just
>  consume memory.  The only way to kill it is to end the task in task
> manager.
>  Once I do that I receive an error about the RPC service is unavailable.
> The
>  RPC service is running so I don't know what is happening.  I manually
>  stopped CF executive and application server in addition to site minder.
>  This made no difference.  If anyone has any ideas they would be
> appreciated.
>
>  Thanks,
>
>  Neil
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Upload Directories

[Dave Watts]

> Since cffile will only do a file at a time does anyone know 
> of a custom tag or something that I can use to upload an entire 
> directory?

By itself, there's no capability within a browser to select a directory of
files to upload. So, if you want to do that, you'll have to use an ActiveX
or Java client of some sort:

http://www.softartisans.com/softartisans/filetransfer.html

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: CF 5.0 Enterprise Server install problems

[Neil H.]

Reinstalling isn't an option.  Any other ideas what I can do to upgrade this
to 5.0?

Thanks,

Neil

- Original Message -
From: "Neil H." <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Sunday, July 29, 2001 2:31 PM
Subject: CF 5.0 Enterprise Server install problems


> When attempting to install CF 5.0 nothing happens!  Let me explain: It
does
>  mention that CF 4.5 is installed and that it will be upgraded.  That is
>  fine. But then nothing.  I watch Ikernel.exe, which is Install Shield,
just
>  consume memory.  The only way to kill it is to end the task in task
> manager.
>  Once I do that I receive an error about the RPC service is unavailable.
> The
>  RPC service is running so I don't know what is happening.  I manually
>  stopped CF executive and application server in addition to site minder.
>  This made no difference.  If anyone has any ideas they would be
> appreciated.
>
>  Thanks,
>
>  Neil
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Another little bit off topic subject..

[Brandon Wood]

Perfect...you rock.


- Original Message -
From: "Bernd VanSkiver" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 2:29 PM
Subject: Re: Another little bit off topic subject..


> CF_GetEmail
>
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34736D-2830-11D4-AA
> 9700508B94F380&method=Full
>
> Bernd VanSkiver
> [EMAIL PROTECTED]
> ColdFusion Developer
>
> - Original Message -
> From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Monday, August 06, 2001 11:36 AM
> Subject: RE: Another little bit off topic subject..
>
>
> > > Does anyone have a good and simple code set to parse out e-mail
> addresses
> > > from an CFHTTP request result.  I have been grappling with a few
> > > things but
> > > can't seem to come up with a rounded solution that will find
> > > every occurance
> > > of an e-mail address in a HTTP output and create a list of those
> addresses
> > > that I can use to output later.
> > >
> > > Any suggestions or solutions would be appreciated
> >
> > I think there's a tag in the Developer's Exchange, but I don't know it's
> > exact name
> >
> > Philip Arnold
> > Director
> > Certified ColdFusion Developer
> > ASP Multimedia Limited
> > T: +44 (0)20 8680 1133
> >
> > "Websites for the real world"
> >
> > **
> > This email and any files transmitted with it are confidential and
> > intended solely for the use of the individual or entity to whom they
> > are addressed. If you have received this email in error please notify
> > the system manager.
> > **
> >
> >
> >
> >
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFMAIL and MS SMTP

[Cameron Childress]

I'm attempting to send mail from CF to IIS4's SMTP service.  For some reason
it doesn't look like it's accepting the mail.  CF spools it fine, and the
cfusion/logs/mail.log file doesn't report any errors.
cfusion/logs/sentmail.log reports that the message was sent correctly.  The
message does not end up in cfusion/mail/undeliverd.

The SMTP service's logs report the following:

19:32:15 130.205.XXX.XXX MAIL FROM - 250
19:32:15 130.205.XXX.XXX RCPT TO - 250
19:32:15 130.205.XXX.XXX QUIT - 0

It looks like the data is being sent to the SMTP service, but then the
message just vanishes into thin air!  It's not in the queue directory or the
badmail directory or any other directory in the SMTP service's root.  It
also doesn't get received by the recipient, and a review of the mail server
it's addressed to reveals that MS SMTP didn't even try to open a connection
to it.

Has anyone else seen anything like this?  Anyone else use the MS SMTP
service for outgoing mail?

-Cameron


Cameron Childress
elliptIQ Inc.
p.770.460.1035.232
f.770.460.0963
--
http://www.neighborware.com
America's Leading Community Network Software


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF5 and Multi-Part email

[Christian L. Watt]

^%$#&^$@$#*(*&
Sorry...Had to get that out

With CF 4 I had a Multi-Part header email that worked just fine.  Now, I run
in CF5 and no luck...it puts it in text only.  I have tried the cfmailparam
and now have only one content type, but it is still grabbing the first Mime
boundry and showing the entire email (HTML TO) in text format.  Both Old and
new examples included...PLEASE HELP I have a deadline of tomm.
to get this working...

Christian

old:










#myPlainMsgTop#

new--











#myPlainMsgTop#

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Another little bit off topic subject..

[Bernd VanSkiver]

CF_GetEmail
http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34736D-2830-11D4-AA
9700508B94F380&method=Full

Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer

- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 11:36 AM
Subject: RE: Another little bit off topic subject..


> > Does anyone have a good and simple code set to parse out e-mail
addresses
> > from an CFHTTP request result.  I have been grappling with a few
> > things but
> > can't seem to come up with a rounded solution that will find
> > every occurance
> > of an e-mail address in a HTTP output and create a list of those
addresses
> > that I can use to output later.
> >
> > Any suggestions or solutions would be appreciated
>
> I think there's a tag in the Developer's Exchange, but I don't know it's
> exact name
>
> Philip Arnold
> Director
> Certified ColdFusion Developer
> ASP Multimedia Limited
> T: +44 (0)20 8680 1133
>
> "Websites for the real world"
>
> **
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed. If you have received this email in error please notify
> the system manager.
> **
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Upload Directories

[Pete Freitag]

Yup, CF_AutoCopy it will copy directories recursively too.
You can get it here: http://www.cfdev.com/products/index.cfm?ref=126

/pete

-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 2:55 PM
To: CF-Talk
Subject: RE: Upload Directories




Read your directory with  ... find out how many files there
are, then use  to loop over the  tag, reading the files
dynamically as you go.

H.


Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


> -Original Message-
> From: Joshua Tipton [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 11:56 AM
> To:   CF-Talk
> Subject:  Upload Directories
>
> Since cffile will only do a file at a time does anyone know of a custom
> tag
> or something that I can use to upload an entire directory?
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Upload Directories

[Pete Freitag]

Yup, CF_AutoCopy it will copy directories recursively too.
You can get it here: http://www.cfdev.com/products/index.cfm?ref=126

/pete

-Original Message-
From: Owens, Howard [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 2:55 PM
To: CF-Talk
Subject: RE: Upload Directories




Read your directory with  ... find out how many files there
are, then use  to loop over the  tag, reading the files
dynamically as you go.

H.


Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


> -Original Message-
> From: Joshua Tipton [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 11:56 AM
> To:   CF-Talk
> Subject:  Upload Directories
>
> Since cffile will only do a file at a time does anyone know of a custom
> tag
> or something that I can use to upload an entire directory?
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Upload Directories

[Owens, Howard]

Read your directory with  ... find out how many files there
are, then use  to loop over the  tag, reading the files
dynamically as you go.

H.


Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


> -Original Message-
> From: Joshua Tipton [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 11:56 AM
> To:   CF-Talk
> Subject:  Upload Directories
> 
> Since cffile will only do a file at a time does anyone know of a custom
> tag
> or something that I can use to upload an entire directory?
> 
> 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Upload Directories

[Joshua Tipton]

Since cffile will only do a file at a time does anyone know of a custom tag
or something that I can use to upload an entire directory?


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfftp or cffile

[Owens, Howard]

I haven't tried writing something that would allow a user to select an
entire directory of stuff from their hard disk and upload it. I can't think
how this would be done.

But I have written applications that create a series of files (up to 20 at a
time) on my development machine and then CFFTP the them to the server.

Is this the kind of thing you're looking to do?

H.

Howard Owens
Internet Operations Coordinator
www.insidevc.com
[EMAIL PROTECTED]
AIM: GoCatGo1956


> -Original Message-
> From: Joshua Tipton [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 7:12 AM
> To:   CF-Talk
> Subject:  cfftp or cffile
> 
> Can an entire directory be uploaded in one swipe using cfftp or cffile?
> 
> 
> 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CDONTS on NT Workstation

[Dave Watts]

> I have PWS installed on NT4 workstation.  I'm trying to test 
> out a tag that uses CDONTS. I've registered cdo.dll and made 
> sure that mapi32.dll was also on the machine (I'm using 
> Outlook 97). I need an SMTP server, and it's not an option to 
> install from OPtion Pack 4 on NT workstation. Is there a
> workaround (to still use NT4 workstation)?

If all you need is SMTP, there are plenty of third-party SMTP servers
available for NT Workstation. I've use Post.Office 3.x for this before; it
provides SMTP and up to 10 POP mailboxes for free:

http://www.openwave.com/products/legacy/post_office/

There are lots of other ones, I'm sure, as well.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Help with sql server

[Dave Watts]

> I have converted a access database to sql server 7.0 my 
> tables have not changed but everytime i try and access any 
> page that has a database call i recieve the following error
> 
> ODBC Error Code = S0002 (Base table not found)
> 
> [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
> 'report2s'.

The most common cause for this problem, in my experience, is the failure to
enter the database name (not the database server name) into the appropriate
field when configuring the datasource. By default, with SQL Server, if you
do that, you'll usually get the master database.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Any horror stories from not locking session vars?

[Chris Norloff]

-- Original Message --
from: "Don Vawter" <[EMAIL PROTECTED]>
>I have been asked to do a code review of a site and I have found that the
>developers don't bother to lock session variables when then read or write
>them. Does anybody have an good horror stories about the dangers of doing
>this so I legitimately show the customer why this is a problem.  

Hijacked sessions
Corrupt data
Server crashing

That might help, or get an Allaire document that says session variables have to be 
locked, to show that the previous coders didn't even follow the software builder's 
advice.

Chris Norloff



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Downloading Files via CFContent

[Dick Applebaum]

Check the archives... I posted a solution within the last several weeks.

Dick

At 1:20 PM -0400 8/6/01, Curtis C. Layton wrote:
>I'm trying to download files using CFContent using the following code.
>
>
>
>Is there a way to change the default file name from the cold fusion
>template's name to the actual file name?  I'm trying to have users download
>files, but I don't want them to open the files in their browser.  I want to
>mask the location of the files.  Please help.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Downloading Files via CFContent

[Curtis C. Layton]

I'm trying to download files using CFContent using the following code.



Is there a way to change the default file name from the cold fusion
template's name to the actual file name?  I'm trying to have users download
files, but I don't want them to open the files in their browser.  I want to
mask the location of the files.  Please help.


Curtis C. Layton
Senior Web Applications Developer
Words In Progress, Inc.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cf mail hanging

[Rick Lamb]

I'm having a periodic problem where a message is hung in the cf mail spooler
directory on the cf server and is sent over and over again until it's
cleared out. When I log onto the server there is usually a Dr. Watson error
that need to be cleared out before the message can be delete. Anyone have
any ideas on what may be causing this? The server is a Pentium NT 4.0, IIS
5.0 and cf server 4.5.

Thanks,

Rick


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: A little bit off topic..

[Alex]

work for  a small company. IMO a year at a small company (under 5 people
in IT) is equivalent to 3 years at a big company.

On Mon, 6 Aug 2001, Tangorre, Mike wrote:

> Thanks Jim..  :-)
> 
> 
> 
> Michael T. Tangorre
> 
> Web Applications Developer
> Office Phone: 703-558-4746
> Cellular Phone: 607-426-9277
> AIM: CrazyFlash4
> Personal Email: [EMAIL PROTECTED]
> Work Email: [EMAIL PROTECTED]
> School Email: [EMAIL PROTECTED]
> 
> This Email contains MillenniuM Information
> Systems, LLC Privileged Information which
> is Customer or Business Sensitive.
> 
> 
> 
> -Original Message-
> From: Jim McAtee [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 11:29 AM
> To: CF-Talk
> Subject: Re: A little bit off topic..
> 
> 
> If at all possible, try to decide what kind of company you'll be working
> for when you graduate.  Small?  Large?  If you're a developer at a
> sizable company, administration skills aren't particularly necessary.
> If you work for a small company (or yourself), you may be expected to do
> everything from development to system and site administration, to
> cleaning toilets.
> 
> Most Win2K/NT admins learn by doing... that is they point and click and
> never really understand what the server software is doing.  Right now
> (witness Code Red) it's a disaster, but Microsoft has been steering down
> this road for years.  They wanted the receptionist to be able to run the
> file & print server - now she administers the company web server.
> 
> If you want to go into administration, commit to it and expect more than
> a few sleepless nights when you can't figure out why IIS is crashing
> every 45 minutes.  Or, if you're a developer, and this is how you'll
> make your living, expand your development skills.  Learn JavaScript C++,
> Java, Perl.  If you've got even a fingernail's worth of artistic skills,
> learn to use PhotoShop or other graphics tools, at least to the point
> where you can slap together simple buttons and banners.
> 
> Jim
> 
> 
> -Original Message-
> From: Tangorre, Mike <[EMAIL PROTECTED]>
> To: CF-Talk <[EMAIL PROTECTED]>
> Date: Friday, August 03, 2001 2:46 PM
> Subject: A little bit off topic..
> 
> 
> >I could use some input on a few issues:
> >
> >I am almost done with college and wanted to spend my last year (light
> credit
> >load)
> >really hoaning in on some skills that I would like to improve in:
> Windows
> >2000 Server
> >administration, web site administration, CF 5, and Flash 5. From these
> >topics listed
> >what are some really good books for reference and learning?
> >
> >I just got the new CF 5.0 book.. it rocks!
> >Looking at Win2K there are tons of books, and website
> administration...not
> >too sure.
> >I have a lot of experience in CF and Flash, but I am new to the server
> side
> >of things,
> >especially administration.
> >
> >Any info would be greatly appreciated.
> >
> >Michael T. Tangorre
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CF with CrypKey

[David Clay]

Has anyone used CrypKey with CF to generate security codes to secure applications, 
programs, etc...

If so, how well did it work and where would I get information to set up such a 
function.

Thank you for your time.

Dave Clay
Internet Facilitator
Trus Joist, A Weyerhaeuser Business
5995 Greenwood Plaza Blvd, Suite 100
Greenwood Village, CO 80111
303.770.8506
303.770.8506
   
   
   
   
   
   
   
   
   


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: A little bit off topic..

[Braver, Ben]

that's ok, Ben has been known to provide input even when NOT asked 

-Original Message-
From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:07 AM
To: CF-Talk
Subject: RE: A little bit off topic..


note to self... don't ask for Ben's input.  



Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Braver, Ben [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 1:08 PM
To: CF-Talk
Subject: RE: A little bit off topic..


No, not "english", "English" .

-Original Message-
From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:02 AM
To: CF-Talk
Subject: RE: A little bit off topic..


english?
That's funny.. well not really.



Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 11:03 AM
To: CF-Talk
Subject: RE: A little bit off topic..


A.

I recently got the Mark Minasi Windows 2000 server book. Very good, and I've
already found it incredibly useful.



-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2001 23:57
To: CF-Talk
Subject: RE: A little bit off topic..


On Friday, August 03, 2001 Tangorre, Mike [SMTP:[EMAIL PROTECTED]]
wrote:
> I am almost done with college and wanted to spend my last year
> really hoaning in on some skills that I would like to improve in.

How about English? ;)
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CDONTS on NT Workstation

[Carlisle, Eric]

I have PWS installed on NT4 workstation.  I'm trying to test out a tag that
uses CDONTS.  I've registered cdo.dll and made sure that mapi32.dll was also
on the machine (I'm using Outlook 97).  I need an SMTP server, and it's not
an option to install from OPtion Pack 4 on NT workstation.  Is there a
workaround (to still use NT4 workstation)?

Thanks,
Eric Carlisle

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: A little bit off topic..

[Tangorre, Mike]

note to self... don't ask for Ben's input.  



Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Braver, Ben [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 1:08 PM
To: CF-Talk
Subject: RE: A little bit off topic..


No, not "english", "English" .

-Original Message-
From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:02 AM
To: CF-Talk
Subject: RE: A little bit off topic..


english?
That's funny.. well not really.



Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 11:03 AM
To: CF-Talk
Subject: RE: A little bit off topic..


A.

I recently got the Mark Minasi Windows 2000 server book. Very good, and I've
already found it incredibly useful.



-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2001 23:57
To: CF-Talk
Subject: RE: A little bit off topic..


On Friday, August 03, 2001 Tangorre, Mike [SMTP:[EMAIL PROTECTED]]
wrote:
> I am almost done with college and wanted to spend my last year
> really hoaning in on some skills that I would like to improve in.

How about English? ;)
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: A little bit off topic..

[Braver, Ben]

No, not "english", "English" .

-Original Message-
From: Tangorre, Mike [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:02 AM
To: CF-Talk
Subject: RE: A little bit off topic..


english?
That's funny.. well not really.



Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 11:03 AM
To: CF-Talk
Subject: RE: A little bit off topic..


A.

I recently got the Mark Minasi Windows 2000 server book. Very good, and I've
already found it incredibly useful.



-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2001 23:57
To: CF-Talk
Subject: RE: A little bit off topic..


On Friday, August 03, 2001 Tangorre, Mike [SMTP:[EMAIL PROTECTED]]
wrote:
> I am almost done with college and wanted to spend my last year
> really hoaning in on some skills that I would like to improve in.

How about English? ;)
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Another little bit off topic subject..

[Philip Arnold - ASP]

> Does anyone have a good and simple code set to parse out e-mail addresses
> from an CFHTTP request result.  I have been grappling with a few
> things but
> can't seem to come up with a rounded solution that will find
> every occurance
> of an e-mail address in a HTTP output and create a list of those addresses
> that I can use to output later.
>
> Any suggestions or solutions would be appreciated

I think there's a tag in the Developer's Exchange, but I don't know it's
exact name

Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133

"Websites for the real world"

**
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: OLE Object

[Hirschman, Miriam]

> -Original Message-
> From: Hirschman, Miriam 
> Sent: Monday, August 06, 2001 12:13 PM
> To:   '[EMAIL PROTECTED]'
> Subject:  OLE Object
> 
> 
> 
>   -Original Message-
>   From:   Hirschman, Miriam 
>   Sent:   Monday, August 06, 2001 11:55 AM
>   To: '[EMAIL PROTECTED]'
>   Subject:OLE Object
> 
>   Hi,
> 
>   I am using an Access DB and one of the fields is an OLE
> Object.  I would like to pull that field and create a link to that
> document.  The document can be a Word or Excel document.
> 
>   Thanks for your help.
> 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Documentation and numbers to back up best practices?

[Jeffry Houser]

At 12:01 PM 08/06/2001 -0400, you wrote:
> > Again, after reading this in CFDJ, I tried a test.
> > Setting 100
> > variables using cfset and the same 100 variables
> > inside of cfscript
> > both take the same amount of time, within a few
> > milliseconds.
>
>The only test I ever did showed that CFSET was
>significantly faster than setting the variables in
>CFSCRIPT, although everything i read says that CFSCRIPT is
>faster.

   I really think it has something to do with the number of CFSETs you 
perform.  I believe the number most commonly quoted is 3.  A CFSCRIPT block 
with 3 assignments is quicker than three CFSETs.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
I'm looking for a room-mate in the Hartford CT area, starting in August
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
http://www.instantcoldfusion.com
--
DotComIt, LLC
database driven web data using ColdFusion, Lotus Notes/Domino
--
Far Cry Fly, Alternative Folk Rock
http://www.farcryfly.com | http://www.mp3.com/FarCryFly


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Documentation and numbers to back up best practices?

[Norman Elton]

> Again, after reading this in CFDJ, I tried a test.
> Setting 100 
> variables using cfset and the same 100 variables
> inside of cfscript 
> both take the same amount of time, within a few
> milliseconds.

The only test I ever did showed that CFSET was 
significantly faster than setting the variables in 
CFSCRIPT, although everything i read says that CFSCRIPT is 
faster.

I figure if I really need to shave of a bazillionth of a 
microsecond, I'll reconsider. But in the mean time, I've 
found that they both perform fine.

Norman

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Documentation and numbers to back up best practices?

[Matthew W Jones]

origin for #2

CFML Language Reference
Chapter 4 :  ColdFusion Expressions: Operands, Operators and Other
Constructs  

states

Although you aren't required to use the prefix unless two variables in
different scopes have the same name, for readability and processing speed,
it is recommended that you use prefixes. For example, the variable
"Form.lastname" is far more self-evident than a variable called "lastname."


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:28 AM
To: CF-Talk
Subject: Re: Documentation and numbers to back up best practices?


1. From Allaire dealing with memory variable overflows.
2. Best practice based on the order of evaluation of variables. Origin
unknown
3. Best practice from the SQL days that predate CF.
4. An article I wrote in Fusion Authority a while back (issue 8?). If you 
look on www.houseoffusion.com in the Michael's Articles link you'll see it 
in there.

At 11:09 AM 8/6/01, you wrote:
>Partly out of curiousity and partly out of need, I'm wondering whether
>anyone has any "ammunition" for discussions about best practices.  For
>example, things like:
>
>1. lock shared variables
>2. prefix variables with a scope
>3. select only columns you need instead of select *
>4. cfscript is faster than multiple  statements when there's more
>than 3
>etc.
>
>Granted, these are not hard and fast rules (except #1), but everyone seems
>to accept them as the best or proper way to do things.  I hear many (and I
>do this as well) use the phrase, "according to Allaire...".
>
>Does anyone have any references that back things like this up?  From
>Allaire, from personal experimentation, etc.?  I'm looking for somewhat
>official information as opposed to "I tried this once and...".  The kind of
>stuff you could bring into a meeting and hand out and people would accept,
>you know?
>
>TIA for anything you can offer.
>
>Evan
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CFPROC BLOCKFACTOR

[Dave Watts]

> Ok... say I'm using a stored procedure that is, in this case, 
> calling several other stored procedures to return multiple results 
> sets back to cold fusion to reduce the number of round trips to 
> the database... Anyone know if I would calculate the BLOCKFACTOR 
> by adding up the lengths of all the columns for all the sprocs 
> that are called by the main calling sproc or would I use the 
> length from the widest sproc of the bunch...?

If you're setting a BLOCKFACTOR for a single stored procedure which returns
multiple recordsets, you'll want to set it to the maximum number of the
longest records that may be returned, and will fit within the 32 Kb buffer.
So, just use the length from the "widest" recordset returned.

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Another little bit off topic subject..

[Brandon Wood]

Does anyone have a good and simple code set to parse out e-mail addresses
from an CFHTTP request result.  I have been grappling with a few things but
can't seem to come up with a rounded solution that will find every occurance
of an e-mail address in a HTTP output and create a list of those addresses
that I can use to output later.

Any suggestions or solutions would be appreciated

Thanks,
Brandon Wood



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Documentation and numbers to back up best practices?

[Bud]

On 8/6/01, Evan Lavidor penned:
>Partly out of curiousity and partly out of need, I'm wondering whether
>anyone has any "ammunition" for discussions about best practices.  For
>example, things like:

No ammunition, but from my experiencing and testing.

>1. lock shared variables

Of course

>2. prefix variables with a scope

Sometimes easier not to.

>3. select only columns you need instead of select *

Only if you only need a couple of fields. My experience shows that 
using * when selecting all or most of the fields in a table, 
especially if there are alot of them, is MUCH faster. I now try it 
both ways and go with the fastest.

>4. cfscript is faster than multiple  statements when there's more
>than 3

Again, after reading this in CFDJ, I tried a test. Setting 100 
variables using cfset and the same 100 variables inside of cfscript 
both take the same amount of time, within a few milliseconds.
-- 

Bud Schneehagen - Tropical Web Creations

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

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CFPROC BLOCKFACTOR

[Correa, Orlando (ITSC)]

Ok... say I'm using a stored procedure that is, in this case, calling
several other stored procedures to return multiple results sets back to cold
fusion to reduce the number of round trips to the database... Anyone know if
I would calculate the BLOCKFACTOR by adding up the lengths of all the
columns for all the sprocs that are called by the main calling sproc or
would I use the length from the widest sproc of the bunch...?

Thanks,
Orlando Correa

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: A little bit off topic..

[Tangorre, Mike]

Thanks Jim..  :-)



Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 11:29 AM
To: CF-Talk
Subject: Re: A little bit off topic..


If at all possible, try to decide what kind of company you'll be working
for when you graduate.  Small?  Large?  If you're a developer at a
sizable company, administration skills aren't particularly necessary.
If you work for a small company (or yourself), you may be expected to do
everything from development to system and site administration, to
cleaning toilets.

Most Win2K/NT admins learn by doing... that is they point and click and
never really understand what the server software is doing.  Right now
(witness Code Red) it's a disaster, but Microsoft has been steering down
this road for years.  They wanted the receptionist to be able to run the
file & print server - now she administers the company web server.

If you want to go into administration, commit to it and expect more than
a few sleepless nights when you can't figure out why IIS is crashing
every 45 minutes.  Or, if you're a developer, and this is how you'll
make your living, expand your development skills.  Learn JavaScript C++,
Java, Perl.  If you've got even a fingernail's worth of artistic skills,
learn to use PhotoShop or other graphics tools, at least to the point
where you can slap together simple buttons and banners.

Jim


-Original Message-
From: Tangorre, Mike <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Friday, August 03, 2001 2:46 PM
Subject: A little bit off topic..


>I could use some input on a few issues:
>
>I am almost done with college and wanted to spend my last year (light
credit
>load)
>really hoaning in on some skills that I would like to improve in:
Windows
>2000 Server
>administration, web site administration, CF 5, and Flash 5. From these
>topics listed
>what are some really good books for reference and learning?
>
>I just got the new CF 5.0 book.. it rocks!
>Looking at Win2K there are tons of books, and website
administration...not
>too sure.
>I have a lot of experience in CF and Flash, but I am new to the server
side
>of things,
>especially administration.
>
>Any info would be greatly appreciated.
>
>Michael T. Tangorre
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CodeCharge editor - anybody have experience with this?

[Ann Harrell]

They are coming up with more and more "canned apps" and the user community
seems willing to share solutions also. They will be coming out with a
"studio" edition that will be able to work directly with Homesite,
Frontpage, Dreamweaver and possibly Netobjects.

The code for the GotoCode site is available to registered users. Their tech
support answers within hours. I consider it a good way to learn other
languages besides CF. Most of their user base is PHP and ASP. For $279 you
get all the apps, 1 year tech support and 2 years product updates.

There are two schools of thought:
1) Find ways to do everything in CodeCharge
2) Generate basic templates and tweak outside to your hearts content.


http://www.codecharge.com/?221


Ann Harrell

PS For one site I even pasted a CFgraph tag into codecharge and it works
fine after taking out a generated CFLoop.



> -Original Message-
> From: Clint Tredway [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 10:00 AM
> To: CF-Talk
> Subject: RE: CodeCharge editor - anybody have experience with this?
>
>
>
> I would agree. I have tried it and its great if you want one of
> their canned apps, but if you are looking to build something that
> they have not built already, its a big pain.
>
> My 2cents...
>
>
> -- Original Message --
> from: "Simon Whittaker" <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> date: Mon, 06 Aug 2001 14:54:46 +0100
>
> I have used it briefly - It is a very good tool for creating quite
> complex projects as a beginner although anything out of the ordinary
> poses a problem. It is also very useful for converting projects (created
> in codecharge) into another language (ie PHP->CFML). In my recollection
> It is difficult, if at all possible,  to access the code until after the
> project is finished and even then it is maybe less than perfect. All in
> all a good tool for the beginner but it ends up easier coding it
> yourself if you know cfml.
>
> Cheers
>
> Simon
>
> -Original Message-
> From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> Sent: 06 August 2001 14:58
> To: CF-Talk
> Subject: CodeCharge editor - anybody have experience with this?
>
>
> Just wondering if anyone on this list has tried this editor and, if
> so, what your experiences have been with it.
>
> http://www.codecharge.com/index2.html
>
> Regards,
> Stephen
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Documentation and numbers to back up best practices?

[Michael Dinowitz]

1. From Allaire dealing with memory variable overflows.
2. Best practice based on the order of evaluation of variables. Origin unknown
3. Best practice from the SQL days that predate CF.
4. An article I wrote in Fusion Authority a while back (issue 8?). If you 
look on www.houseoffusion.com in the Michael's Articles link you'll see it 
in there.

At 11:09 AM 8/6/01, you wrote:
>Partly out of curiousity and partly out of need, I'm wondering whether
>anyone has any "ammunition" for discussions about best practices.  For
>example, things like:
>
>1. lock shared variables
>2. prefix variables with a scope
>3. select only columns you need instead of select *
>4. cfscript is faster than multiple  statements when there's more
>than 3
>etc.
>
>Granted, these are not hard and fast rules (except #1), but everyone seems
>to accept them as the best or proper way to do things.  I hear many (and I
>do this as well) use the phrase, "according to Allaire...".
>
>Does anyone have any references that back things like this up?  From
>Allaire, from personal experimentation, etc.?  I'm looking for somewhat
>official information as opposed to "I tried this once and...".  The kind of
>stuff you could bring into a meeting and hand out and people would accept,
>you know?
>
>TIA for anything you can offer.
>
>Evan
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: A little bit off topic..

[Jim McAtee]

If at all possible, try to decide what kind of company you'll be working
for when you graduate.  Small?  Large?  If you're a developer at a
sizable company, administration skills aren't particularly necessary.
If you work for a small company (or yourself), you may be expected to do
everything from development to system and site administration, to
cleaning toilets.

Most Win2K/NT admins learn by doing... that is they point and click and
never really understand what the server software is doing.  Right now
(witness Code Red) it's a disaster, but Microsoft has been steering down
this road for years.  They wanted the receptionist to be able to run the
file & print server - now she administers the company web server.

If you want to go into administration, commit to it and expect more than
a few sleepless nights when you can't figure out why IIS is crashing
every 45 minutes.  Or, if you're a developer, and this is how you'll
make your living, expand your development skills.  Learn JavaScript C++,
Java, Perl.  If you've got even a fingernail's worth of artistic skills,
learn to use PhotoShop or other graphics tools, at least to the point
where you can slap together simple buttons and banners.

Jim


-Original Message-
From: Tangorre, Mike <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Date: Friday, August 03, 2001 2:46 PM
Subject: A little bit off topic..


>I could use some input on a few issues:
>
>I am almost done with college and wanted to spend my last year (light
credit
>load)
>really hoaning in on some skills that I would like to improve in:
Windows
>2000 Server
>administration, web site administration, CF 5, and Flash 5. From these
>topics listed
>what are some really good books for reference and learning?
>
>I just got the new CF 5.0 book.. it rocks!
>Looking at Win2K there are tons of books, and website
administration...not
>too sure.
>I have a lot of experience in CF and Flash, but I am new to the server
side
>of things,
>especially administration.
>
>Any info would be greatly appreciated.
>
>Michael T. Tangorre


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CodeCharge editor - anybody have experience with this?

[Ann Harrell]

Try news.codecharge.com / codecharge.discussion

As the user base increases the complex issues are being addressed. Also
visit www.gotocode.com and check out the discussion group there.

Ann Harrell

> -Original Message-
> From: Stephen Hait [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 8:58 AM
> To: CF-Talk
> Subject: CodeCharge editor - anybody have experience with this?
>
>
>
> Just wondering if anyone on this list has tried this editor and, if
> so, what your experiences have been with it.
>
> http://www.codecharge.com/index2.html
>
> Regards,
> Stephen
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Documentation and numbers to back up best practices?

[Evan Lavidor]

Partly out of curiousity and partly out of need, I'm wondering whether
anyone has any "ammunition" for discussions about best practices.  For
example, things like:

1. lock shared variables
2. prefix variables with a scope
3. select only columns you need instead of select *
4. cfscript is faster than multiple  statements when there's more
than 3
etc.

Granted, these are not hard and fast rules (except #1), but everyone seems
to accept them as the best or proper way to do things.  I hear many (and I
do this as well) use the phrase, "according to Allaire...".

Does anyone have any references that back things like this up?  From
Allaire, from personal experimentation, etc.?  I'm looking for somewhat
official information as opposed to "I tried this once and...".  The kind of
stuff you could bring into a meeting and hand out and people would accept,
you know?

TIA for anything you can offer.

Evan


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: A little bit off topic..

[Tangorre, Mike]

english?
That's funny.. well not really.



Michael T. Tangorre

Web Applications Developer
Office Phone: 703-558-4746
Cellular Phone: 607-426-9277
AIM: CrazyFlash4
Personal Email: [EMAIL PROTECTED]
Work Email: [EMAIL PROTECTED]
School Email: [EMAIL PROTECTED]

This Email contains MillenniuM Information
Systems, LLC Privileged Information which
is Customer or Business Sensitive.



-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 11:03 AM
To: CF-Talk
Subject: RE: A little bit off topic..


A.

I recently got the Mark Minasi Windows 2000 server book. Very good, and I've
already found it incredibly useful.



-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2001 23:57
To: CF-Talk
Subject: RE: A little bit off topic..


On Friday, August 03, 2001 Tangorre, Mike [SMTP:[EMAIL PROTECTED]]
wrote:
> I am almost done with college and wanted to spend my last year
> really hoaning in on some skills that I would like to improve in.

How about English? ;)
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Joel Parramore]

Somewhat related: is there any reason to do locking when you're only
*reading* from application variables?


> -Original Message-
> From: Don Vawter [mailto:[EMAIL PROTECTED]]
> Sent: Monday, August 06, 2001 10:11 AM
> To: CF-Talk
> Subject: Any horror stories from not locking session vars?
>
>
> I have been asked to do a code review of a site and I have found that the
> developers don't bother to lock session variables when then read or write
> them. Does anybody have an good horror stories about the dangers of doing
> this so I legitimately show the customer why this is a problem.  He is a
> nontechnical person so any talk of needing to single-thread processes when
> using shared variables won't mean a thing to him. Since I always
> lock around
> the variables I can't give him any personal horror stories.
> Perhaps some of
> you have heard of some (I KNOW they won't come from YOUR sites because you
> always follow best practices ;-) but maybe you inherited some.)
>
> TIA
>
> Don
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CodeCharge editor - anybody have experience with this?

[Clint Tredway]

I would agree. I have tried it and its great if you want one of their canned apps, but 
if you are looking to build something that they have not built already, its a big pain.

My 2cents...


-- Original Message --
from: "Simon Whittaker" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
date: Mon, 06 Aug 2001 14:54:46 +0100

I have used it briefly - It is a very good tool for creating quite
complex projects as a beginner although anything out of the ordinary
poses a problem. It is also very useful for converting projects (created
in codecharge) into another language (ie PHP->CFML). In my recollection
It is difficult, if at all possible,  to access the code until after the
project is finished and even then it is maybe less than perfect. All in
all a good tool for the beginner but it ends up easier coding it
yourself if you know cfml.

Cheers

Simon

-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: 06 August 2001 14:58
To: CF-Talk
Subject: CodeCharge editor - anybody have experience with this?


Just wondering if anyone on this list has tried this editor and, if 
so, what your experiences have been with it.

http://www.codecharge.com/index2.html

Regards,
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: A little bit off topic..

[Will Swain]

A.

I recently got the Mark Minasi Windows 2000 server book. Very good, and I've
already found it incredibly useful.



-Original Message-
From: David Shadovitz [mailto:[EMAIL PROTECTED]]
Sent: 03 August 2001 23:57
To: CF-Talk
Subject: RE: A little bit off topic..


On Friday, August 03, 2001 Tangorre, Mike [SMTP:[EMAIL PROTECTED]]
wrote:
> I am almost done with college and wanted to spend my last year
> really hoaning in on some skills that I would like to improve in.

How about English? ;)
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Any horror stories from not locking session vars?

[Lonny Eckert]

Sure, I inherited one.

It was a Customer Service application where the customer's unique
identification number was a session variable.  The application made heavy
use of frames to split information along the lines of "current" and
"historical" activity.

Needless to say there were more than one CS rep using the application at the
time.  Any time one of the reps entered in identification criteria while
another rep was using the Application caused the Application to fail.

But hey it worked great in development/test when just a single user was
using the Application.

Suggestion:  No great need to tell them horror stories when you can show
them first-hand.  Just crash the app in dev/test by having multiple people
challenge that portion of the code at the same time.


Lonny Eckert
Hesta Corporation
[EMAIL PROTECTED]
Hesta 610-230-2500 x147


-Original Message-
From: Don Vawter [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:11 AM
To: CF-Talk
Subject: Any horror stories from not locking session vars?


I have been asked to do a code review of a site and I have found that the
developers don't bother to lock session variables when then read or write
them. Does anybody have an good horror stories about the dangers of doing
this so I legitimately show the customer why this is a problem.  He is a
nontechnical person so any talk of needing to single-thread processes when
using shared variables won't mean a thing to him. Since I always lock around
the variables I can't give him any personal horror stories. Perhaps some of
you have heard of some (I KNOW they won't come from YOUR sites because you
always follow best practices ;-) but maybe you inherited some.)

TIA

Don
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: Any horror stories from not locking session vars?

[[EMAIL PROTECTED]]

Reasons to CFLOCK shared memory scopes:
1.) Allaire/Macromedia ( the company that made the Application server ) says
to.
2.) I have personally seen strange, un-diagnosable errors that really could
not be pinned to anything.  Corrupt memory or PCODE and everything goes bad.
Maybe CFLOCKing would fix, but too many people avoid it like the plague.
3.) You can get undesirable results when using frames as each
request(navbar.cfm and body.cfm) process without regard to the other thread.
So, navbar.cfm begins processing and modifies the SESSION scope in the
middle of a transaction that the Body.cfm is processing involving the same
SESSION variables.  Who loses?  You do.  Even if the site doesn't crash the
server, incorrect information can insue.

A further suggestion is to avoid SESSION, APPLICATION and SERVER variables
completely.  Build a site that will be ready for loadbalancing WITHOUT
sticky sessions now and don't even fool with server specific shared memory
scopes.

2¢

~.net³




- Original Message -
From: "Don Vawter" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 10:10
Subject: Any horror stories from not locking session vars?


> I have been asked to do a code review of a site and I have found that the
> developers don't bother to lock session variables when then read or write
> them. Does anybody have an good horror stories about the dangers of doing
> this so I legitimately show the customer why this is a problem.  He is a
> nontechnical person so any talk of needing to single-thread processes when
> using shared variables won't mean a thing to him. Since I always lock
around
> the variables I can't give him any personal horror stories. Perhaps some
of
> you have heard of some (I KNOW they won't come from YOUR sites because you
> always follow best practices ;-) but maybe you inherited some.)
>
> TIA
>
> Don
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfftp or cffile

[Tom Davison]

I know you cannot upload a dir with cffile upload.
- Original Message -
From: "Joshua Tipton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, August 06, 2001 9:11 AM
Subject: cfftp or cffile


> Can an entire directory be uploaded in one swipe using cfftp or cffile?
>
>
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfftp or cffile

[Carlisle, Eric]

CFFILE is capable of uploading one file per form field.  The user has to
select each file they choose to upload.  I've never tried using multiple
file fields on a form, but I imagine that would work.  It's not a wildcard
operation, though :P.  BTW, CFFTP is for FTPing files from the ColdFusion
server to another machine.  It's not a daemon.

Eric Carlisle

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:22 AM
To: CF-Talk
Subject: RE: cfftp or cffile


It will be web page that people will upload files to a server.


-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:12 AM
To: CF-Talk
Subject: RE: cfftp or cffile


>From the server or to the server?

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:12 AM
To: CF-Talk
Subject: cfftp or cffile


Can an entire directory be uploaded in one swipe using cfftp or cffile?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Subject: RE: Form question

[Susan Allen]

Shannon:
I'm using this on an intranet, and the user(s) have the Adobe Reader within the 
browser, not the writer, so they can still fill out forms but cannot change them.  My 
custom button calls a .cfm, which sends an html acknowledgement page to the browser, 
and doesn't show a c:/ path in the browser at all.  In other words, the pdf form 
submit button just redirects to a .cfm page, basically, where all the real stuff takes 
place.  In Actions, I just made the button Type "Submit Form," selected the url (in 
form "http://yadda yadda"), and specified which fields from the pdf form to send.  If 
you'd like to send me your code offlist, don't hesitate.

Susan Hamilton Allen
Information Technology Manager
MEVATEC Corporation
White Sands Missile Range, NM

>>> Shannon Rhodes 8/2/2001 7:05:26 AM >>>
Question for Susan:  I attempted to do just what you suggested (created an
Acrobat form containing a button with the action to submit to a CF page as
well as to print).  I ended up giving up on the idea because its behavior
seemed too erratic.  I had to add security so no one could copy or alter the
text (legal mumbo jumbo) and with the form secured I could press the submit
button all day and nothing was going to happen (though it would still
print).  If I took off the security, it would sometimes submit but mostly
just print.  If I took off the print option, it would submit but it wouldn't
e-mail the contents as I'd set it up with  (same way I've done a
million times with HTML forms), and probably related to that was the problem
that it would choke if the person didn't include an e-mail address (though
it was not a required field and no other field had that problem).  Also,
when my CF page appeared upon submit, my address bar displayed a path on the
c:\ drive (probably to Acrobat Reader) so I don't know if that will cause
end user confusion or not.  I gave up, thinking this is too crazy, but I'll
persevere if you say PDF submissions do in fact work with CF.  (I'm not even
going to TRY populating the PDF form from the database!!!).

Oh, and thanks everybody for your great answers to my question yesterday
(just got them on Digest).

Shannon Rhodes
[EMAIL PROTECTED] 



Date: Wed, 01 Aug 2001 15:13:26 -0500
From: "Susan Allen" <[EMAIL PROTECTED]>

I've done a lot of converting Word docs to .pdf and building the form
functionality into the .pdf.  You can add a button (and code it NOT to show
on the form if it is printed) that will call a .cfm and do whatever: write
to the database, etc.  You can also fill the .pdf form automatically from a
database.  Is that too clungy for you?  I've used it very successfully for
an app that required a lot of mathematical calculations based on a few
inputs; the .pdf does all the math, and then the results are written to the
db.  It takes some time to get the form the way you want, but it looks like
the users' "paper" they were used to, and you can build a good deal of
functionality into it via java.

-Original Message-
From: Tangorre, Mike [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 10:31 AM

Well you could save the word doc as HTML, then open the document up and add
the HTML for the fields. BE WARNED, Microsoft HTML is nasty to work in...
all kinds of crazy things going on.

-Original Message-
From: Braver, Ben [mailto:[EMAIL PROTECTED]] 
Sent: Wednesday, August 01, 2001 1:06 PM

But I'm being asked to convert an existing "paper-style" MS Word document to
a web form where info can be captured and emailed.

My question is: is there a way to "overlay" form elements onto an existing
doc saved as HTML without doing the form over from scratch?
Thanks.


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfftp or cffile

[Joshua Tipton]

It will be web page that people will upload files to a server.


-Original Message-
From: Carlisle, Eric [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:12 AM
To: CF-Talk
Subject: RE: cfftp or cffile


>From the server or to the server?

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:12 AM
To: CF-Talk
Subject: cfftp or cffile


Can an entire directory be uploaded in one swipe using cfftp or cffile?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: cfftp or cffile

[Carlisle, Eric]

>From the server or to the server?

-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 10:12 AM
To: CF-Talk
Subject: cfftp or cffile


Can an entire directory be uploaded in one swipe using cfftp or cffile?
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Any horror stories from not locking session vars?

[Don Vawter]

I have been asked to do a code review of a site and I have found that the
developers don't bother to lock session variables when then read or write
them. Does anybody have an good horror stories about the dangers of doing
this so I legitimately show the customer why this is a problem.  He is a
nontechnical person so any talk of needing to single-thread processes when
using shared variables won't mean a thing to him. Since I always lock around
the variables I can't give him any personal horror stories. Perhaps some of
you have heard of some (I KNOW they won't come from YOUR sites because you
always follow best practices ;-) but maybe you inherited some.)

TIA

Don




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfftp or cffile

[Joshua Tipton]

Can an entire directory be uploaded in one swipe using cfftp or cffile?




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: CodeCharge editor - anybody have experience with this?

[Simon Whittaker]

I have used it briefly - It is a very good tool for creating quite
complex projects as a beginner although anything out of the ordinary
poses a problem. It is also very useful for converting projects (created
in codecharge) into another language (ie PHP->CFML). In my recollection
It is difficult, if at all possible,  to access the code until after the
project is finished and even then it is maybe less than perfect. All in
all a good tool for the beginner but it ends up easier coding it
yourself if you know cfml.

Cheers

Simon

-Original Message-
From: Stephen Hait [mailto:[EMAIL PROTECTED]]
Sent: 06 August 2001 14:58
To: CF-Talk
Subject: CodeCharge editor - anybody have experience with this?


Just wondering if anyone on this list has tried this editor and, if 
so, what your experiences have been with it.

http://www.codecharge.com/index2.html

Regards,
Stephen
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

cfftp

[Stuart Miller]

Anyone have problems uploading large files with cfftp? My code runs fine
with small files but throws an error trying to upload 3 or 4 mb.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Auto deleting Emails - help needed

[Nick Betts]

Cheers Larry!   Good advice.

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: 06 August 2001 14:38
To: CF-Talk
Subject: RE: Auto deleting Emails - help needed


Nick;

I created an Unsubscribe template on my site that if they click on
Unsubscribe in an email, it will bring them to my template and give them
one
more chance to change their mind or else they can click and remove
themselves from the table.  This also generates an email to me, to let
me
know that they have removed themselves from the list.

Larry & Sheila Juncker
Fort Dodge, IA

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:26 AM
To: CF-Talk
Subject: RE: Auto deleting Emails - help needed


Hi,
If users send an email with "UNSUBSCRIBE" as the subject how would I go
about automatically deleting their details from a database?

TIA.
Nick.

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: 06 August 2001 14:15
To: CF-Talk
Subject: RE: Administrator Email Change


Have you set up your ColdFusion Administrator Email to the
[EMAIL PROTECTED]? I believe that all email goes to that address.

Larry Juncker
Cold Fusion Developer
Fort Dodge, IA

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:05 AM
To: CF-Talk
Subject: Administrator Email Change


Is there a way to change the email address that is linked to on the
generic
error page by application.

For example, we've got www.domain1.com and we want error messages for
our
site to have an email link to [EMAIL PROTECTED]  On the same server
we
have www.domain2.com, and we want the error pages for that site to have
the
site administrator email link to [EMAIL PROTECTED]

Any ideas?

Thanks!
Hatton Humphrey
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: cfscript - pros/cons

[tom muck]

If you do the loop with CFLOOP you aren't getting an accurate timing,
because you are opening and closing the  tags for each iteration
of the loop.  Also, as the original post said, the construct is different,
because there are times when you might want more than CASE statement to
execute, which you can do with CFSCRIPT because it requires the break
statement.

tom
www.basic-ultradev.com


"Zac Belado" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> At 03:00 AM 8/5/2001 +1000, you wrote:
> >There are many areas where cfscript is not optimised, but having said
> >that I can't vouch for CF5.0.
>
> Just did a quick test under CF 5. Iterated a switch statement 10,000 times
> and iterated a similar CFSwitch statement the same number of times. (Loop
> was done using CFLoop in order to eliminate loop structures as a timing
issue)
>
> switch (cfscript)  1753
>
> cfsswitch 811
>
> So its still not optimised.
>
>
>
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Re: [Help with sql server]

[Alex]

try...
where ID IN (4,5,6)

"Neo Fusion" <[EMAIL PROTECTED]> wrote:
I have converted a access database to sql server 7.0 my tables have not
changed but everytime i try and access any page that has a database call i
recieve the following error


ODBC Error Code = S0002 (Base table not found)


[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name
'report2s'.


SQL = "SELECT picture, lastupdated, id FROM report2s WHERE ((id)=4 Or (id)=5
Or (id)=6)"

Data Source = "xx"


The error occurred while processing an element with a general identifier of
(CFQUERY), occupying document position (3:1) to (3:55) in the template file
e:\inetpub\wwwroot\evisions\index.cfm.


Date/Time: 08/06/01 00:04:38
Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Remote Address: 127.0.0.1
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Auto deleting Emails - help needed

[Larry Juncker]

Nick;

I created an Unsubscribe template on my site that if they click on
Unsubscribe in an email, it will bring them to my template and give them one
more chance to change their mind or else they can click and remove
themselves from the table.  This also generates an email to me, to let me
know that they have removed themselves from the list.

Larry & Sheila Juncker
Fort Dodge, IA

-Original Message-
From: Nick Betts [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:26 AM
To: CF-Talk
Subject: RE: Auto deleting Emails - help needed


Hi,
If users send an email with "UNSUBSCRIBE" as the subject how would I go
about automatically deleting their details from a database?

TIA.
Nick.

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: 06 August 2001 14:15
To: CF-Talk
Subject: RE: Administrator Email Change


Have you set up your ColdFusion Administrator Email to the
[EMAIL PROTECTED]? I believe that all email goes to that address.

Larry Juncker
Cold Fusion Developer
Fort Dodge, IA

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:05 AM
To: CF-Talk
Subject: Administrator Email Change


Is there a way to change the email address that is linked to on the
generic
error page by application.

For example, we've got www.domain1.com and we want error messages for
our
site to have an email link to [EMAIL PROTECTED]  On the same server
we
have www.domain2.com, and we want the error pages for that site to have
the
site administrator email link to [EMAIL PROTECTED]

Any ideas?

Thanks!
Hatton Humphrey
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Auto deleting Emails - help needed

[Nick Betts]

Hi,
If users send an email with "UNSUBSCRIBE" as the subject how would I go
about automatically deleting their details from a database?

TIA.
Nick.

-Original Message-
From: Larry Juncker [mailto:[EMAIL PROTECTED]]
Sent: 06 August 2001 14:15
To: CF-Talk
Subject: RE: Administrator Email Change


Have you set up your ColdFusion Administrator Email to the
[EMAIL PROTECTED]? I believe that all email goes to that address.

Larry Juncker
Cold Fusion Developer
Fort Dodge, IA

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:05 AM
To: CF-Talk
Subject: Administrator Email Change


Is there a way to change the email address that is linked to on the
generic
error page by application.

For example, we've got www.domain1.com and we want error messages for
our
site to have an email link to [EMAIL PROTECTED]  On the same server
we
have www.domain2.com, and we want the error pages for that site to have
the
site administrator email link to [EMAIL PROTECTED]

Any ideas?

Thanks!
Hatton Humphrey
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Administrator Email Change

[Larry Juncker]

Have you set up your ColdFusion Administrator Email to the
[EMAIL PROTECTED]? I believe that all email goes to that address.

Larry Juncker
Cold Fusion Developer
Fort Dodge, IA

-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 8:05 AM
To: CF-Talk
Subject: Administrator Email Change


Is there a way to change the email address that is linked to on the generic
error page by application.

For example, we've got www.domain1.com and we want error messages for our
site to have an email link to [EMAIL PROTECTED]  On the same server we
have www.domain2.com, and we want the error pages for that site to have the
site administrator email link to [EMAIL PROTECTED]

Any ideas?

Thanks!
Hatton Humphrey
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

RE: Administrator Email Change

[Ben Forta]

The address in the default error pages are based on what is set in the
Administrator, and that is system wide.

But, use , and just specify the address you want in your 
tag. You can pass a variable or expression to the MAILTO attribute.

--- Ben



-Original Message-
From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED]]
Sent: Monday, August 06, 2001 9:05 AM
To: CF-Talk
Subject: Administrator Email Change


Is there a way to change the email address that is linked to on the generic
error page by application.

For example, we've got www.domain1.com and we want error messages for our
site to have an email link to [EMAIL PROTECTED]  On the same server we
have www.domain2.com, and we want the error pages for that site to have the
site administrator email link to [EMAIL PROTECTED]

Any ideas?

Thanks!
Hatton Humphrey
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Administrator Email Change

[C. Hatton Humphrey]

Is there a way to change the email address that is linked to on the generic
error page by application.

For example, we've got www.domain1.com and we want error messages for our
site to have an email link to [EMAIL PROTECTED]  On the same server we
have www.domain2.com, and we want the error pages for that site to have the
site administrator email link to [EMAIL PROTECTED]

Any ideas?

Thanks!
Hatton Humphrey


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

CodeCharge editor - anybody have experience with this?

[Stephen Hait]

Just wondering if anyone on this list has tried this editor and, if 
so, what your experiences have been with it.

http://www.codecharge.com/index2.html

Regards,
Stephen



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists