Hi Greg,
It's probably better to put your conditional in the SQL query, especially
for a password database. Some database won't actually return you the
password field (eg., LDAP), but they will let you do this:
SELECT ID,PASSWORD
FROM Table2
WHERE (ID = '#id1#') AND (PASSWORD = '#password1#')
Then you can check the number of returned rows using queryname.recordcount.
If no rows, then bad username/password, else okay.
Hope that helps,
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-----Original Message-----
From: Roadrunner [mailto:[EMAIL PROTECTED]]
Hello masters,
I'm new to Cold Fusion and have been doing my homework. Here's the scenario
and it's very simple. A password and an id is being entered via the form.
That info is being compared against a database with two columns one column
called ID the other PASSWORD.
....
IMPORTANT NOTICE:
This e-mail and any attachment to it is intended only to be read or used by
the named addressee. It is confidential and may contain legally privileged
information. No confidentiality or privilege is waived or lost by any
mistaken transmission to you. If you receive this e-mail in error, please
immediately delete it from your system and notify the sender. You must not
disclose, copy or use any part of this e-mail if you are not the intended
recipient. The RTA is not responsible for any unauthorised alterations to
this e-mail or attachment to it.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
