> I have a CF site, which also has a Perl Forums application.  The
> user authentication process in the Forums is run from a .txt file
> that looks like this:
>
> password|username|securitylevel|firstname|lastname|email|status
>
> The records are separated by a carriage return.  The user
> authentication process I use at the front of the site for CF login
> has the same fields in an Access table (username, password, security,
> firstname, last name, email, status). What I'd like to do, is upon
> registration of a new user - update the .txt file above with the
> new user registration information from the Access database. Does
> this make sense?  I want to eliminate users having to register
> for a username at the CF application, and then again at the Perl
> application.
>
> I don't have access to cfcontent or cffile... can I still do this?

If you can't use CFFILE, this will obviously be a bit difficult. However,
you do have some options.

1. Change the Perl application so that it uses the database instead of the
text file. This is probably the best approach, although it will require a
bit of tinkering, obviously.

2. Check to see if the server will let you instantiate the FileSystemObject,
which is what you'd use in ASP if you wanted to write to a text file. The
server probably has ASP installed, and you could probably instantiate this
object using CFOBJECT, although I haven't actually tried to do this.

3. Use a Perl script to modify the file. You could call this script via
CFHTTP from your CF application. This wouldn't be very efficient, though.

4. I don't know enough about Access to know whether this is possible, but
you might be able to associate an event handler to the table so that when a
record is inserted, an Access VBA routine writes to the file.

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

------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to