Re: Spell Checking a Textarea Field

2001-06-29 Thread W Luke

http://www.spellchecker.net/ is quite good.

Rgds

--
Will
new media discussion for Berkshire -=- http://bnm.lukrative.com
local classifieds -=- http://www.localbounty.com
e: [EMAIL PROTECTED]  icq: 31099745

- Original Message - 
From: Steve Reich [EMAIL PROTECTED]
Newsgroups: cf-talk
Sent: Friday, June 29, 2001 2:21 AM
Subject: Spell Checking a Textarea Field


 How can I have my users spellcheck a textarea?
 
 Thanks,
 Steve
 
 


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Closing Connections to a locked Access Database

2001-06-29 Thread Les Mizzell

Picking up a previously existing site that used some weird connection
scripts with an Access database.  Site is on a shared server, so I only have
FTP access.

Here's the problem...the database has been locked for what seems like
forever now on the server with that darned .lbd file, and thusly I can't FTP
a new version of the database to the site!

Is there a short script of some sort I could place in a file and ftp out to
the site that would FORCE all data connections to close - assuming nobody is
browsing at the moment??

Thanks!

--
Les Mizzell

Who Needs Intel?
ATHLON INSIDE!



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Closing Connections to a locked Access Database

2001-06-29 Thread W Luke

Hi Les,

I get this problem too.  I got my hosting people to uncheck the maintain
connection box in CF Admin which has helped.

hth

--
Will
new media discussion for Berkshire -=- http://bnm.lukrative.com
local classifieds -=- http://www.localbounty.com
e: [EMAIL PROTECTED]  icq: 31099745


- Original Message -
From: Les Mizzell [EMAIL PROTECTED]
Newsgroups: cf-talk
Sent: Friday, June 29, 2001 12:32 PM
Subject: Closing Connections to a locked Access Database


 Picking up a previously existing site that used some weird connection
 scripts with an Access database.  Site is on a shared server, so I only
have
 FTP access.

 Here's the problem...the database has been locked for what seems like
 forever now on the server with that darned .lbd file, and thusly I can't
FTP
 a new version of the database to the site!

 Is there a short script of some sort I could place in a file and ftp out
to
 the site that would FORCE all data connections to close - assuming nobody
is
 browsing at the moment??

 Thanks!

 --
 Les Mizzell
 
 Who Needs Intel?
 ATHLON INSIDE!




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Closing Connections to a locked Access Database

2001-06-29 Thread Dave Hannum

Simply ftp up and run a script that queries the database, but requests a
table that does not exist.  This will throw an error and break the
conneciton.

Dave


- Original Message -
From: Les Mizzell [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Sent: Friday, June 29, 2001 7:32 AM
Subject: Closing Connections to a locked Access Database


 Picking up a previously existing site that used some weird connection
 scripts with an Access database.  Site is on a shared server, so I only
have
 FTP access.

 Here's the problem...the database has been locked for what seems like
 forever now on the server with that darned .lbd file, and thusly I can't
FTP
 a new version of the database to the site!

 Is there a short script of some sort I could place in a file and ftp out
to
 the site that would FORCE all data connections to close - assuming nobody
is
 browsing at the moment??

 Thanks!

 --
 Les Mizzell
 
 Who Needs Intel?
 ATHLON INSIDE!




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cffile, cfregistry, and clusters, oh my

2001-06-29 Thread Todd Ashworth

I need some suggestions on several different topics here.

1.  We have a web app that will be used by many, many people.  We would like
to host this app on a cluster of servers.  The catch is, we want everyone to
use the same copy of code for the app, but each person/company needs their
own database.  If we get 1000 companies using this thing, I don't want to
have to replicate 1000 different DSNs for the different databases accross
all of the clustered servers.  What I would like to do is find a way to
connect to the various databases without having to use a DSN.  We tried
using OLEDB and specifying the database file, but we couldn't get that to
work.  Maybe someone could explain to me how to get OLEDB to work with
Sybase 7, or maybe tell me another way to do what I'm trying to do.

2.  We want people who want to use the app to be able to sign up for it on
the web site and begin using it almost immediately, without any intervention
on our part.  Signing up for the app requires that the sign up program
creates some folders and registry entries on each server in the cluster.  Is
there an example, or tutorial where the best way to handle this is
explained?

Thanks

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SOT BrainBench CF 4.51 Test

2001-06-29 Thread Jeffry Houser

At 05:57 PM 06/28/2001 -0700, you wrote:
I just took the BrainBench test for CF 4.51 programming.

It consisted of 40 multiple-choice questions.

I thought it was reasonable... mostly!

I think that 7 or 8 of the questions did *not* belong in the test.
They were related to the CF Administrator, Java and C++ programming
of CFX custom tags, managing  a Verity collection, etc.

   I think that it is good for a CF Programmer to know some stuff about 
custom tags, verity collections (I.E. it is built into ColdFusion), and the 
CF Administrator.  All our CF-related topics.  I do not remember specifics 
of when I took the test.




Several of the questions involved lists and they were defined in error:

cfset myList = 1, 2, 3, 4

instead of


cfset myList = 1,2,3,4

   Unless I'm mistaken, either one of the statements above is a valid CF 
statement, and also a valid list.  The invalid-ness of this would depend on 
the question and the answers.


Anyone have any comments or experience with this?

   I have nothing else to share.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out June 2001
--
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
--
It's okay to be mean to the evil people who make life unbelievable
But try to be nice to me


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Closing Connections to a locked Access Database

2001-06-29 Thread Neil Clark

Run a bogus call on the DB and that will free up it up.  Or make sure you
are not running a keep alive of DB connections.



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CF Mall with no per store charge.

2001-06-29 Thread Angél Stewart

Hey,

Does anybody know about any Over The Counter application which will allow me to create 
a Mall system without having to
purchase a new license everytime a store is added? I.E. an Unlimited Store License?

-Gel


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists




RE: cffile, cfregistry, and clusters, oh my

2001-06-29 Thread Raymond Camden

 1.  We have a web app that will be used by many, many people.  We
 would like
 to host this app on a cluster of servers.  The catch is, we want
 everyone to

Is it one company per box? Or multiple? If it's one company per box, then
just use the same DNS name and point to the a different db on your db server
for each company.

If it's multiple companies, then use DNS connections. This is possible in
CF5.


 2.  We want people who want to use the app to be able to sign up for it on
 the web site and begin using it almost immediately, without any
 intervention
 on our part.  Signing up for the app requires that the sign up program
 creates some folders and registry entries on each server in the
 cluster.  Is

First, I'd _strongly_ consider rethinking your strategy. Why do you want to
use the registry? Why do you want to make physical paths? It's certainly
possible to do what you want w/o doing either. If you want to store data,
use a database instead of the registry. If you want each client to be able
to do, www.myapp.com/companyname, then use something like
www.myapp.com/a.cfm/companyname, to create 'fake' folders.


Ray Camden


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



virtual memory error

2001-06-29 Thread Paul Sizemore

I keep getting an occasional virtual memory error on my CF 4.5.1 sp 2 with
Win 2K. 

Today it happened during the workday for the first time. 

We have 512 mg ram (Monday it will be 1 gig). I use a few CFX tags,
cfx_ping, cfx_domainuser, cfx_filereadlines,cfx_zip (I just made sure that
all were locked, some weren't, but not any that are in heavy use). 

I assume the swap is on C: with the Bins; scripts and .cfm files are on E:,
DBs are on other boxes. The box is used as a secondary DNS. 

We currently have very low usage on this box.

Does anyone have any general or specific ideals on what the problem could
be. 


Paul Sizemore

Finish Line
3308 N Mitthoeffer Rd
Indianapolis, IN 46235
W: 317-899-1022 ext 3516


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SOT BrainBench CF 4.51 Test

2001-06-29 Thread Dick Applebaum

At 9:43 AM -0700 6/29/01, Jeffry Houser wrote:
At 05:57 PM 06/28/2001 -0700, you wrote:
I just took the BrainBench test for CF 4.51 programming.

It consisted of 40 multiple-choice questions.

I thought it was reasonable... mostly!

I think that 7 or 8 of the questions did *not* belong in the test.
They were related to the CF Administrator, Java and C++ programming
of CFX custom tags, managing  a Verity collection, etc.

I think that it is good for a CF Programmer to know some stuff about
custom tags, verity collections (I.E. it is built into ColdFusion), and the
CF Administrator.  All our CF-related topics.  I do not remember specifics
of when I took the test.

I agree... I also think it is *good* for a CF Programmer to know 
JavaScript, COM, DHTML, regexp, DBA, etc. The question is should they 
comprise 20% of a test on CF programming?

Manipulation (not design and administration) of SQL databases is a 
valid subject as it is so widely used and closely ingrained within CF.

  Several of the questions involved lists and they were defined in error:

 cfset myList = 1, 2, 3, 4

instead of


 cfset myList = 1,2,3,4

Unless I'm mistaken, either one of the statements above is a valid CF
statement, and also a valid list.  The invalid-ness of this would depend on
the question and the answers.


No, the format given in the test is not a valid list (they did not 
specify any delimiters in the list manipulation functions).  In the 
context of the questions (there were 4 or 5) none of the answers were 
correct.

Dick

  Anyone have any comments or experience with this?

I have nothing else to share.


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out June 2001
--
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
--
It's okay to be mean to the evil people who make life unbelievable
But try to be nice to me



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Groundhog Day?

2001-06-29 Thread Braver, Ben

Ummm, isn't Groundhog Day in February?? g
(y'know, deja vu all over again...)

Ben


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: CF-talk Admin

2001-06-29 Thread Bruce, Rodney


Mike

Thanks for the update on the list.

Two questions,

I like to save emails with good ideas, and thankfully there are
quite a few from the list.  but with the DNS problems I have been missing
them. I am using the web site to browse the list. Is there a way to get
copies of these old emails from the list?

Is there a way to search the archives on a topic?

again thanks for all the hard work.

Rodney 

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Dupe CFID/CFTOKEN pairs being assigned

2001-06-29 Thread Scott Weikert

(Yes, this is related to my session hijacking issue)

I've added some code in my app to, I *thought*, refresh the ID/Token pairs
better - trying to put the info in memory-based cookies instead of
file-based cookies, so that closing the browser will kill the cookie, and
the user will get a new id/token pair.

It worked great for me, from outside the client's network, coming across the
net - but users inside the LAN are still being assigned the same id/token
pair - by this I mean MULTIPLE users are getting this assigned pair.
Moreover it's a pair that was assigned yesterday, at the very least - I
can't tell how long this particular pair of values has been in use. I just
know I started tracking this stuff yesterday and multiple people are getting
the pair. I get to work this morning to check, and I see more folks coming
in and getting this pair.

What gives??? This is driving me nuts. :(
--Scott


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: SOT BrainBench CF 4.51 Test

2001-06-29 Thread Jeffry Houser

At 08:47 AM 06/29/2001 -0700, you wrote:
At 9:43 AM -0700 6/29/01, Jeffry Houser wrote:
 At 05:57 PM 06/28/2001 -0700, you wrote:
 I just took the BrainBench test for CF 4.51 programming.
 
 It consisted of 40 multiple-choice questions.
 
 I thought it was reasonable... mostly!
 
 I think that 7 or 8 of the questions did *not* belong in the test.
 They were related to the CF Administrator, Java and C++ programming
 of CFX custom tags, managing  a Verity collection, etc.
 
 I think that it is good for a CF Programmer to know some stuff about
 custom tags, verity collections (I.E. it is built into ColdFusion), and the
 CF Administrator.  All our CF-related topics.  I do not remember specifics
 of when I took the test.

I agree... I also think it is *good* for a CF Programmer to know
JavaScript, COM, DHTML, regexp, DBA, etc. The question is should they
comprise 20% of a test on CF programming?

   However, all of those things are separate entities from CF.
   Verity, CF Admin, and CFX tags are not separate.  I was under the 
impression that BrainBench only had one CF test, not separate ones for CF 
Programming, one for CF Administration, etc..


--
Jeffry Houser | mailto:[EMAIL PROTECTED]
AIM: Reboog711  | ICQ: 5246969 | Phone: 860-229-2781
--
Instant ColdFusion 5.0  | ISBN: 0-07-213238-8
Due out June 2001
--
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
--
It's okay to be mean to the evil people who make life unbelievable
But try to be nice to me


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



cf_addBusinessDays

2001-06-29 Thread Adrian Cesana

Anyone using this tag?

If so what do you use for the output variable?  Looks like it would be
OUTDATE, but I get a numeric result.

cf_addbusinessDays indate=0628/2001 days=-5

gives me:

cfoutput#outdate#/cfoutput  = 37063


Im must be doing something wrong?

-Adrian


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: cffile, cfregistry, and clusters, oh my

2001-06-29 Thread Todd Ashworth

|  1.  We have a web app that will be used by many, many people.  We
|  would like
|  to host this app on a cluster of servers.  The catch is, we want
|  everyone to
|
| Is it one company per box? Or multiple? If it's one company per box, then
| just use the same DNS name and point to the a different db on your db
server
| for each company.

I'm not sure I understand.  Let me try to explain again.  We have an app.  1
machine isn't going to be able to handle 1000 companies using that app.  So,
we have a cluster of, say, 5 machines and 1 database server.  Any company
can hit any machine in the cluster depending on when they show up.  Right
now, we are using a different DNS for each company.  Since they could hit
and of the 5 machines, we would need to have all 1000 DSNs on all 5
machines.  This doesn't sound like the best idea.  A single DSN where we can
pass the name of the database file to access would be much better, but I'm
having trouble getting this to work.  Is it even possible?

| If it's multiple companies, then use DNS connections. This is possible in
| CF5.

I don't follow this statement.  Also, what if we don't have 5.0 yet?

|  2.  We want people who want to use the app to be able to sign up for it
on
|  the web site and begin using it almost immediately, without any
|  intervention
|  on our part.  Signing up for the app requires that the sign up program
|  creates some folders and registry entries on each server in the
|  cluster.  Is
|
| First, I'd _strongly_ consider rethinking your strategy. Why do you want
to
| use the registry?

To create the DSN entries.

| Why do you want to make physical paths?

We need to create a folder on the image server for each company to store
their images in.  I can see a way to do this, so this isn't much of a
problem.

| If you want each client to be able
| to do, www.myapp.com/companyname,
| then use something like
| www.myapp.com/a.cfm/companyname, to create 'fake' folders.

I'm not sure I follow you here either.

Thanks

Todd



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]

2001-06-29 Thread Steve Reich

I am having a problem with the encrypt/decrypt functions. Here is my code:

*** This creates the user when they register...

cfset dbPassword=#Encrypt(password, application.seed)#

cfquery name=CreateUser datasource=#application.dsn#
username=#application.dsn_username# password=#application.dsn_password#
   INSERT INTO users
   (fname,lname,email,username,password)
   VALUES('#fname#','#lname#','#email#','#username#','#dbPassword#')
/cfquery

*** This validates a registered user

cfset dbPassword = #Encrypt(password, application.seed)#

cfquery name=CheckUser datasource=#application.dsn#
username=#application.dsn_username# password=#application.dsn_password#
  SELECT userid
  FROM users
  WHERE username='#username#'
  AND password='#dbPassword#'
/cfquery

The problem is that if I output the encrypted password on my page, I get...

(6 W=SO*;E^JD

The field in the DB says...

(6 W=SO*;E^H

Obviously, they don't match, so the user can't get in. I've tried using a
variety of seed values, including various lengths. It seems that the last
one or two chars always come out differently? My questions are, what is a
good length for the seed value and should this be alphnumeric or will any
ascii character work? Also, I'm not sure why I can encrypt the same value
twice and not get the same value. I'm thinking my problem must be in the
seed string length, but I'm not sure? Are there known issues with this? Why
am I having this problem? Can someone shed some light?

Thanks,
Steve




~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]

2001-06-29 Thread Steve Reich

 Also, I'm not sure why I can encrypt the same value
 twice and not get the same value. I'm thinking my problem must be in the
 seed string length, but I'm not sure? Are there known issues with this?
Why
 am I having this problem? Can someone shed some light?


After a little more trial and error, it appears that the first 12 characters
are consistant. Anything after that can change, even if encrypting the same
string with the same seed value. I guess I can do something like..

if password =  Left(dbpassword, 12)

I would still appreciate a logical explanation of this if someone knows more
about this

Thanks,
Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]

2001-06-29 Thread Raymond Camden

Maybe it's just a wierd browser thing. What do you see if you View SOurce?

===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia

Email   : [EMAIL PROTECTED]
ICQ UIN : 3679482

My ally is the Force, and a powerful ally it is. - Yoda

 -Original Message-
 From: Steve Reich [mailto:[EMAIL PROTECTED]]
 Sent: Friday, June 29, 2001 1:57 PM
 To: CF-Talk
 Subject: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]


 I am having a problem with the encrypt/decrypt functions. Here is my code:

 *** This creates the user when they register...

 cfset dbPassword=#Encrypt(password, application.seed)#

 cfquery name=CreateUser datasource=#application.dsn#
 username=#application.dsn_username#
 password=#application.dsn_password#
INSERT INTO users
(fname,lname,email,username,password)
VALUES('#fname#','#lname#','#email#','#username#','#dbPassword#')
 /cfquery

 *** This validates a registered user

 cfset dbPassword = #Encrypt(password, application.seed)#

 cfquery name=CheckUser datasource=#application.dsn#
 username=#application.dsn_username#
 password=#application.dsn_password#
   SELECT userid
   FROM users
   WHERE username='#username#'
   AND password='#dbPassword#'
 /cfquery


~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]

2001-06-29 Thread Dick Applebaum

Steve

I encountered a similar problem... here is how I resolved it.

1) I defined the field in the db that holds the encrypted value as 
NVarChar(255).  This is a unicode field. The 255 length takes care of 
encrypted passwords are larger than the original.

2) I do *not* check the password in the SQL, rather in CF after it 
has been retrieved, e.g.:

cfquery NAME=Login .

   SELECT UserID, Password
   FROM   Customer
   WHERE  UserID = '#form.UserID#'

/cfquery

cfif NOT Login.Recordcount eq 1
   cfset Error = Invalid UserID and Password.
cfelse
   cfif form.Login_Password NEQ Decrypt(LoginAction.Password, key)
 cfset Error = Invalid UserID and Password.
   cfelse
 !--- Login OK ---
 .
 .
 .

HTH

Dick

At 1:57 PM -0400 6/29/01, Steve Reich wrote:
I am having a problem with the encrypt/decrypt functions. Here is my code:

*** This creates the user when they register...

cfset dbPassword=#Encrypt(password, application.seed)#

cfquery name=CreateUser datasource=#application.dsn#
username=#application.dsn_username# password=#application.dsn_password#
INSERT INTO users
(fname,lname,email,username,password)
VALUES('#fname#','#lname#','#email#','#username#','#dbPassword#')
/cfquery

*** This validates a registered user

cfset dbPassword = #Encrypt(password, application.seed)#

cfquery name=CheckUser datasource=#application.dsn#
username=#application.dsn_username# password=#application.dsn_password#
   SELECT userid
   FROM users
   WHERE username='#username#'
   AND password='#dbPassword#'
/cfquery

The problem is that if I output the encrypted password on my page, I get...

(6 W=SO*;E^JD

The field in the DB says...

(6 W=SO*;E^H

Obviously, they don't match, so the user can't get in. I've tried using a
variety of seed values, including various lengths. It seems that the last
one or two chars always come out differently? My questions are, what is a
good length for the seed value and should this be alphnumeric or will any
ascii character work? Also, I'm not sure why I can encrypt the same value
twice and not get the same value. I'm thinking my problem must be in the
seed string length, but I'm not sure? Are there known issues with this? Why
am I having this problem? Can someone shed some light?

Thanks,
Steve





~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]

2001-06-29 Thread Steve Reich

 Maybe it's just a wierd browser thing. What do you see if you View SOurce?


No.. I checked that. It's very strange because there is no consistency to
it. Some strings encrypt the same everytime, others don't.

If I run this in my browser

cfset encryptedPW = #Encrypt(password, k39dkjw*kd@kfoe%kfps037)#

cfoutput#encryptedPW #-#Len(encryptedPW)#/cfoutput

and then hit refresh... it toggles between these two values...

(78XD6IF#J5(
and
(78XD6IF#J5'

 but it returns the Len of both strings as 14. Something with ASCII,
either spaces or line feeds might be one of the chars that could be messing
me up. In the database field (SQL7), visually you can see some box
characters that represents an ASCII character that can't be displayed.
Help!!

Thanks,
Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Trim Question

2001-06-29 Thread Brian Scott Barnett

For some reason, a custom tag that I am using is adding beginning and
trailing spaces to the output.  Does this happen when the tag takes a little
while for the CF App server to process?

It's causing a display issue in some versions of Netscape.  Any idea how I
might be able to trim the spaces?

The code calling the custom tag is:

cfmodule template=./customtags/flasher5.cfm
flash_src=flash/spotlight_new.swf flash_width=168 flash_height=213
flash_quality=high flash_bgcolor=white flash_loop=yes
image_src=images/home_page/home_page_3-3.gif image_width=168
image_height=213 image_border=0 image_alt=Spotlight

Thanks!

Brian


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]

2001-06-29 Thread Steve Reich

cfif form.Login_Password NEQ Decrypt(LoginAction.Password, key)
  cfset Error = Invalid UserID and Password.
cfelse


Dick,

That did the trick! I was trying to compare two encrypted strings and I
should have been comparing their decrypted values. Thanks for the help
it was driving me nuts!

Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Encrypt/Decrypt Functions [NOT cfencrypt/cfdecrypt]

2001-06-29 Thread hof

AFAIK it is a feature that Encrypt() does not always return the same value, but
is always decryptable to the same value. I think I read it in the comment of an
Allaire employee in the Allaire forums.

Anyhow, I believe one should not use the Encrypt() at all. Use Hash(), it is one
way (nice for safety) and a public algorithm (MD5 is the name among
cryptographers I believe), so it is even usable from other applications.
Personally, I have zero faith in any cryptographic algorithm that is not open
source.

Jochem

--
It isn't possible I lied in this message, it is probable.

~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Application Variables

2001-06-29 Thread Steve Reich

Seems basic, but I've never really addressed this. Assuming this code is in
my application.cfm file, what is the difference in these two

cfset bgcolor=black

and...

cfset application.bgcolor=black

I guess I need a quick lesson on application variables. I know they are
included in the scope defined in the cfapplication tag, but what are pros
and cons?

I have a small dev box with only 256 RAM. I have CF 4.5 and SQL7 running on
it so as you can imagine, it's quite slow. I'm wondering how much RAM is
used storing application variables? Could I increase performance (albeit
more theoretically) by not using application vars?

If I am looking for server performance over speed, the first one seems the
way to go since it's not a persistent variable. I'm only faking it by
putting it in the app.cfm file. Along this line, do I even need application
variables? What's the story?

Thanks,
Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Trim Question

2001-06-29 Thread Steve Reich

Try #Trim(OutputVariable)#. Otherwise, you will need to go into your
custom tag and figure where the code is adding the spaces. It's not a
problem of CF Server adding the spaces.

HTH,
Steve

Brian Scott Barnett [EMAIL PROTECTED] wrote in message
000701c100df$c9b69e20$[EMAIL PROTECTED]">news:000701c100df$c9b69e20$[EMAIL PROTECTED]...
 For some reason, a custom tag that I am using is adding beginning and
 trailing spaces to the output.  Does this happen when the tag takes a
little
 while for the CF App server to process?

 It's causing a display issue in some versions of Netscape.  Any idea how I
 might be able to trim the spaces?

 The code calling the custom tag is:

 cfmodule template=./customtags/flasher5.cfm
 flash_src=flash/spotlight_new.swf flash_width=168 flash_height=213
 flash_quality=high flash_bgcolor=white flash_loop=yes
 image_src=images/home_page/home_page_3-3.gif image_width=168
 image_height=213 image_border=0 image_alt=Spotlight

 Thanks!

 Brian


 Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
 Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Fw: Trim Question

2001-06-29 Thread Brian Scott Barnett

Please disregard my question.  Immediately after I sent it, I found the
offending spaces, buried away in the custom tag.  I deleted them from there
and it solved the problem.

Sorry to bug the list over my dumb mistake!

Brian

- Original Message -
From: Brian Scott Barnett [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 29, 2001 2:08 PM
Subject: Trim Question


 For some reason, a custom tag that I am using is adding beginning and
 trailing spaces to the output.  Does this happen when the tag takes a
little
 while for the CF App server to process?

 It's causing a display issue in some versions of Netscape.  Any idea how I
 might be able to trim the spaces?

 The code calling the custom tag is:

 cfmodule template=./customtags/flasher5.cfm
 flash_src=flash/spotlight_new.swf flash_width=168 flash_height=213
 flash_quality=high flash_bgcolor=white flash_loop=yes
 image_src=images/home_page/home_page_3-3.gif image_width=168
 image_height=213 image_border=0 image_alt=Spotlight

 Thanks!

 Brian



Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Re: Spell Checking a Textarea Field

2001-06-29 Thread Steve Reich

 http://www.spellchecker.net/ is quite good.


Wow! That is very cool (and cheap)... thanks!

Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



RE: Application Variables

2001-06-29 Thread stas

There are several benefits to Application metrics, unfortunately I don't
know about any metrics. Maybe some of the gurus here can help you in that
department.

Application vars are shared. So as soon as you have more than one user, you
shoud start reaping some performance benefits.

You can set an Application variable on any page of your site if you need to
access a global variable, not just in Application.cfm.

You can assign a query recordset into an Application variable, it may be
less expensive for you to check for an existance of an Application variable
as  opposed to running your query every time and again (and for each user).

As far as your simple example there is probably no measurable benefit.

Also, there's that little matter of convinience of NOT using Application
variables all over the place, as you must cflock them. The applications
we've designing were never high traffic apps, so I've never ran into a
problem by not using CFLOCK, however, since 4.5 came out, we've turned on
the automatic read locking, and made sure that writes are explicitely
locked.

One final point, RAM is very cheap now. You can pick up a 256MB DIMM for
$50.

-Original Message-
From: Steve Reich [mailto:[EMAIL PROTECTED]]

Seems basic, but I've never really addressed this. Assuming this code is in
my application.cfm file, what is the difference in these two

cfset bgcolor=black

.and...

cfset application.bgcolor=black

I guess I need a quick lesson on application variables. I know they are
included in the scope defined in the cfapplication tag, but what are pros
and cons?

I have a small dev box with only 256 RAM. I have CF 4.5 and SQL7 running on
it so as you can imagine, it's quite slow. I'm wondering how much RAM is
used storing application variables? Could I increase performance (albeit
more theoretically) by not using application vars?

If I am looking for server performance over speed, the first one seems the
way to go since it's not a persistent variable. I'm only faking it by
putting it in the app.cfm file. Along this line, do I even need application
variables? What's the story?

Thanks,
Steve
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



select box formatting/validation

2001-06-29 Thread Terri Stocke

Hey all,

I have a two-part question that I'm really hoping someone can answer.

I have a multiple-select list that is populated from one table in my db. The 
list is constructed in such a way that there are main categories that each 
have their own subcategory. Some of those subcategories have their own 
subcategories. The main categories are all in uppercase, and the 
subcategories are indented, as appropriate, throughout the list.

I don't want users to be able to select every item--I want them to have to 
select as far as they possibly can within the subcategories. So...

QUESTION 1: Is there a way to disable selection ability on certain items 
within the select box (just don't allow it to be highlighted when clicked), 
and if so, how?

QUESTION 2: How do I conditionally format the look of each of these menu 
items within this one select list? I have been successful in conditionally 
changing words to uppercase, or indenting, but I cannot get it to 
conditionally bold a word, change the font size, add a line break, etc. I've 
tried style sheets, but you have to actually specify the class in the TD 
tag, which won't work. I need to be able to optionally format the OPTION 
tags.

I know a DHTML menu or a javascript would be better--that way I could just 
display the subcategories for selection as appropriate--but the customer 
really likes being able to see every possible category and subcategory in 
one box all at once.

Thanks in advance for any and all insights!

***By the way, like most, I am not receiving any CF-Talk mail. Could you 
please cc me on all responses so I can get them immediately? Thanks!***

Terri
~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



CFEXECUTE and locked files

2001-06-29 Thread Michael Sprague

I am using CFEXECUTE to run a command line utility on Windows 2000. I use
the outputfile attribute, and it does create a text file with the correct
output in it.  ColdFusion does have full access permissions to the directory
where the file resides.  However, I cannot read the file with CFFILE. The
error message I get says that the file is locked.  I tried putting in a
delay between the CFEXECUTE and the CFFILE, but nothing seems to work - not
even a 20 second delay.

There is a bug report (19123) that mentions this issue, but it was supposed
to be fixed in the release version of CF5. I am running the most recent
release.

Anyone have advice on how to resolve this?

Code:

cfexecute name=c:\winnt\addusers.exe arguments=#domain# /c
f:\temp\usermagr\adduser.txt
outputfile=f:\temp\usermagr\output.txt/cfexecute

cffile action=READ file=f:\temp\usermagr\output.txt variable=results


-Mike

--
Michael Sprague
Web Developer, Hamilton College
198 College Hill Road
Clinton, NY 13323
[EMAIL PROTECTED]
315-859-4087
http://www.hamilton.edu
--


Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists



Attachments CFPOP

2001-06-29 Thread Steve Reich

Is there a way to detect an attachment without having to download it to the
server? If a user has a 2 mb attachment, and 50 email messages, it's going
to be a while I want my users to see that there is an attachment, but
only download if they choose to. Is there a work around?

Thanks,
Steve



~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists