freelanceprogrammers.org Forum Index » Cold Fusion
<dev>This Is Pissing Me Off
Joined: 05 Apr 2000
Posts: 10
<dev>This Is Pissing Me Off
Ok I have tryed several of the ideas and some of my own but it keeps doing
math! Does anybody have something they have written and that works that I
could compare mine to? And how do you use <CFAUTHENTICATE> and security
context and all that other stuff? Here is what I have
Tablename: Users
Fields: Username and Password
Variables: form.pw, form.username
Comparing database.user.password TO form.PW
Any help will be appreciated greatly.
John Williams
Director Of Technical Services
JWilliams@...
AIS Inc.
Phone: (410)561-0778
Fax: (410)561-9657
Joined: 05 Apr 2000
Posts: 7
<dev>This Is Pissing Me Off
The example I posted earlier today works just fine .. using it on a
production site actually.
Todd Ashworth
----------------------------------------------
Saber Corporation
Web Application Development
www.sabersite.com
(803) 327-0137 [111]
(803) 328-2868 (fax)
----- Original Message -----
From: "John H Williams" <jwilliams@...>
To: "Cold Fusion List (E-mail)" <cold_fusion@onelist.com>
Sent: Wednesday, April 05, 2000 3:59 PM
Subject: [cold_fusion] <dev>This Is Pissing Me Off
> Ok I have tryed several of the ideas and some of my own but it keeps doing
> math! Does anybody have something they have written and that works that I
> could compare mine to? And how do you use <CFAUTHENTICATE> and security
> context and all that other stuff? Here is what I have
>
> Tablename: Users
> Fields: Username and Password
> Variables: form.pw, form.username
> Comparing database.user.password TO form.PW
>
> Any help will be appreciated greatly.
>
> John Williams
> Director Of Technical Services
> JWilliams@...
> AIS Inc.
> Phone: (410)561-0778
> Fax: (410)561-9657
Joined: 05 Apr 2000
Posts: 7
<dev>This Is Pissing Me Off
P.S. Try changing <CFIF #password# EQ #Form.PW#> to <CFIF #password# IS
#Form.PW#>
Todd Ashworth
----------------------------------------------
Saber Corporation
Web Application Development
www.sabersite.com
(803) 327-0137 [111]
(803) 328-2868 (fax)
----- Original Message -----
From: "John H Williams" <jwilliams@...>
To: "Cold Fusion List (E-mail)" <cold_fusion@onelist.com>
Sent: Wednesday, April 05, 2000 3:59 PM
Subject: [cold_fusion] <dev>This Is Pissing Me Off
> Ok I have tryed several of the ideas and some of my own but it keeps doing
> math! Does anybody have something they have written and that works that I
> could compare mine to? And how do you use <CFAUTHENTICATE> and security
> context and all that other stuff? Here is what I have
>
> Tablename: Users
> Fields: Username and Password
> Variables: form.pw, form.username
> Comparing database.user.password TO form.PW
>
> Any help will be appreciated greatly.
>
> John Williams
> Director Of Technical Services
> JWilliams@...
> AIS Inc.
> Phone: (410)561-0778
> Fax: (410)561-9657
>
>
>
>
> ------------------------------------------------------------------------
> PERFORM CPR ON YOUR APR!
> Get a NextCard Visa, in 30 seconds! Get rates as low as
> 0.0% Intro or 9.9% Fixed APR and no hidden fees.
> Apply NOW!
> http://click.egroups.com/1/2121/4/_/291057/_/954965063/
> ------------------------------------------------------------------------
>
>
Joined: 05 Apr 2000
Posts: 7
<dev>This Is Pissing Me Off
try <CFIF CheckPW IS "0">
-1 means that string 1 is less than string 2
0 means they are =
1 means that string 1 is greater than string 2
Todd Ashworth
----------------------------------------------
Saber Corporation
Web Application Development
www.sabersite.com
(803) 327-0137 [111]
(803) 328-2868 (fax)
----- Original Message -----
From: "John H Williams" <jwilliams@...>
To: <cold_fusion@egroups.com>
Sent: Wednesday, April 05, 2000 4:44 PM
Subject: RE: [cold_fusion] <dev>This Is Pissing Me Off
> Nope tryed that before I sent the email out. Ill attatch my cfm file.
Joined: 05 Apr 2000
Posts: 7
<dev>This Is Pissing Me Off
Or, John .. I have changed the code you sent me and streamlined it a little
bit. This should work without a hitch. I have attached the file too.
<!--- look for the passed username AND password directly in the query. If
the values aren`t in there, then they don`t have a login and no reults will
be returned .. It will be like the query never ran. If they do have a
login, then the query will return values which you can test for further down
the page -->
<CFQUERY name="Login" datasource="Darkroom" maxrows="1" dbtype="ODBC"
username="Dahktah" password="030086">
SELECT * From users WHERE username = `#Form.Username#` AND password =
`#Form.PW#`
</CFQUERY>
<html>
<HEAD><TITLE>Untitled</TITLE></HEAD>
<BODY>
<!--- Check to see if the Query.Variable exists. If it does, then that
means that the passed username AND password were found in the database and
the query returned values ... It doesn`t really matter what it returned ..
All that matters is that it found a match. If you wanted to be picky, you
could check to see if Login.password is defined too, but it`s not really
necessary. --->
<CFIF IsDefined(`Login.username`)>
Login OK
<CFELSE>
<table width="100%" height="100%" border=0><tr><td align=middle
valign=center>
<table border="2" cellpadding="0" cellspacing="2" height=75 width=125>
<FORM action="login.cfm" method="POST">
<tr>
<td align=center>
<font color=ff0000><b>INCORRECT LOGIN:</b></font><br>
Username:<br><INPUT type="Text" name="Username">
</td>
</tr>
<tr><td align=center>Password:<br><INPUT type="Password"
name="PW"></td></tr>
<tr><td align=center><INPUT type="submit" value="Login"></td></tr>
</FORM>
</table>
</TD>
</TR>
</TABLE>
</CFIF>
</BODY>
</HTML>
Todd Ashworth
----------------------------------------------
Saber Corporation
Web Application Development
www.sabersite.com
(803) 327-0137 [111]
(803) 328-2868 (fax)
----- Original Message -----
From: "John H Williams" <jwilliams@...>
To: <cold_fusion@egroups.com>
Sent: Wednesday, April 05, 2000 4:44 PM
Subject: RE: [cold_fusion] <dev>This Is Pissing Me Off
> Nope tryed that before I sent the email out. Ill attatch my cfm file.
>
> -----Original Message-----
> From: Jeff Cabell [mailto:jeffc@...]
> Sent: Wednesday, April 05, 2000 4:38 PM
> To: cold_fusion@egroups.com
> Subject: RE: [cold_fusion] <dev>This Is Pissing Me Off
>
>
> URGH! I knew there was something I was forgetting to do.
>
> Jeff Cabell
> jeffc@...
>
> ----------------
> Never take life seriously, nobody gets out alive anyway.
>
> > -----Original Message-----
> > From: Todd Ashworth [mailto:todd@...]
> > Sent: Wednesday, April 05, 2000 4:36 PM
> > To: cold_fusion@egroups.com
> > Subject: Re: [cold_fusion] <dev>This Is Pissing Me Off
> >
> >
> > P.S. Try changing <CFIF #password# EQ #Form.PW#> to <CFIF
> > #password# IS
> > #Form.PW#>
> >
> > Todd Ashworth
> > ----------------------------------------------
> > Saber Corporation
> > Web Application Development
> > www.sabersite.com
> > (803) 327-0137 [111]
> > (803) 328-2868 (fax)
> >
> > ----- Original Message -----
> > From: "John H Williams" <jwilliams@...>
> > To: "Cold Fusion List (E-mail)" <cold_fusion@onelist.com>
> > Sent: Wednesday, April 05, 2000 3:59 PM
> > Subject: [cold_fusion] <dev>This Is Pissing Me Off
> >
> >
> > > Ok I have tryed several of the ideas and some of my own but
> > it keeps doing
> > > math! Does anybody have something they have written and
> > that works that I
> > > could compare mine to? And how do you use <CFAUTHENTICATE>
> > and security
> > > context and all that other stuff? Here is what I have
> > >
> > > Tablename: Users
> > > Fields: Username and Password
> > > Variables: form.pw, form.username
> > > Comparing database.user.password TO form.PW
> > >
> > > Any help will be appreciated greatly.
> > >
> > > John Williams
> > > Director Of Technical Services
> > > JWilliams@...
> > > AIS Inc.
> > > Phone: (410)561-0778
> > > Fax: (410)561-9657
> > >
> > >
> > >
> > >
> > >
> > --------------------------------------------------------------
> > ----------
> > > PERFORM CPR ON YOUR APR!
> > > Get a NextCard Visa, in 30 seconds! Get rates as low as
> > > 0.0% Intro or 9.9% Fixed APR and no hidden fees.
> > > Apply NOW!
> > > http://click.egroups.com/1/2121/4/_/291057/_/954965063/
> > >
> > --------------------------------------------------------------
> > ----------
> > >
> > >
> >
> >
> >
> > --------------------------------------------------------------
> > ----------
> > DON`T HATE YOUR RATE!
> > Get a NextCard Visa, in 30 seconds! Get rates as low as
> > 0.0% Intro or 9.9% Fixed APR and no hidden fees.
> > Apply NOW!
> > http://click.egroups.com/1/2120/4/_/291057/_/954966775/
> > --------------------------------------------------------------
> > ----------
> >
> >
>
> ------------------------------------------------------------------------
> PERFORM CPR ON YOUR APR!
> Get a NextCard Visa, in 30 seconds! Get rates as low as
> 0.0% Intro or 9.9% Fixed APR and no hidden fees.
> Apply NOW!
> http://click.egroups.com/1/2121/4/_/291057/_/954966865/
> ------------------------------------------------------------------------
>
>
>
> ------------------------------------------------------------------------
> Get a NextCard Visa, in 30 seconds!
> 1. Fill in the brief application
> 2. Receive approval decision within 30 seconds
> 3. Get rates as low as 2.9% Intro or 9.9% Fixed APR
> Apply NOW!
> http://click.egroups.com/1/2646/4/_/291057/_/954967755/
> ------------------------------------------------------------------------
>
>
All times are GMT
Page 1 of 1
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Freelace Website Designer - Customer web design and software building.
China Wholesale - Electronics Products
Character Studio - Tutorials and Help
China Wholesale - Electronics Products
Character Studio - Tutorials and Help