CodeCharge Studio
search Register Login  

Web Reports

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> CodeChargeStudio.Discussion

 CCS, PHP, MySQL - Custom Security

Print topic Send  topic

Author Message
JCF
Posted: 09/22/2002, 8:26 AM

I don't think this was sent so I am sending again - Sorry if there is a
double.

Hi All

I just don't understand why this is not working?

I have modified the Login function to add some more fields but the fields
never get filled with the data, I can login and it authenticates fine.

When I try use the other session vars - they are simply blank?

Here is the modification to the Login function:

function CCLoginUser($Login, $Password)
{

$db = new clsDBSD73();
$SQL = "SELECT ID, SecRights, SecUser, SecWorker, SecAdmin, Email,
SITENUM FROM CONTACTS WHERE LoginID=" . $db->ToSQL($Login, ccsText) . " AND
Password=" . $db->ToSQL($Password, ccsText);
$db->query($SQL);
$Result = $db->next_record();
if($Result)
{
CCSetSession("ID", $db->f("ID"));
CCSetSession("LoginID", $Login);
CCSetSession("UserPassword", $Password);
CCSetSession("SecRights", $db->f("SecRights"));
CCSetSession("SecUser", $db->f("SecUser"));
CCSetSession("SecWorker", $db->f("SecWorker"));
CCSetSession("SecAdmin", $db->f("SecAdmin"));
CCSetSession("Email", $db->f("Email"));
CCSetSession("SITENUM", $db->f("SITENUM"));

}
unset($db);
return $Result;
}


Looking for some suggestions - I don't know what to try next.

JCF








dsafar
Posted: 09/22/2002, 9:15 AM

This is a multi-part message in MIME format.

------=_NextPart_000_01F1_01C26228.FE7E5020
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Basic Troubleshooting as follows:
echo $SQL; Grab it and run it using phpmyadmin to see if it works.
make sure if($Result) code is getting executed (i.e echo "I'm Here" =
inside of {})

eliminate the obvious first.=20

"JCF" <jcf@mail.org> wrote in message =
news:amknf9$lj6$1@news.codecharge.com...
> I don't think this was sent so I am sending again - Sorry if there is =
a
> double.
>=20
> Hi All
>=20
> I just don't understand why this is not working?
>=20
> I have modified the Login function to add some more fields but the =
fields
> never get filled with the data, I can login and it authenticates fine.
>=20
> When I try use the other session vars - they are simply blank?
>=20
> Here is the modification to the Login function:
>=20
> function CCLoginUser($Login, $Password)
> {
>=20
> $db =3D new clsDBSD73();
> $SQL =3D "SELECT ID, SecRights, SecUser, SecWorker, SecAdmin, =
Email,
> SITENUM FROM CONTACTS WHERE LoginID=3D" . $db->ToSQL($Login, ccsText) =
.. " AND
> Password=3D" . $db->ToSQL($Password, ccsText);
> $db->query($SQL);
> $Result =3D $db->next_record();
> if($Result)
> {
> CCSetSession("ID", $db->f("ID"));
> CCSetSession("LoginID", $Login);
> CCSetSession("UserPassword", $Password);
> CCSetSession("SecRights", $db->f("SecRights"));
> CCSetSession("SecUser", $db->f("SecUser"));
> CCSetSession("SecWorker", $db->f("SecWorker"));
> CCSetSession("SecAdmin", $db->f("SecAdmin"));
> CCSetSession("Email", $db->f("Email"));
> CCSetSession("SITENUM", $db->f("SITENUM"));
>=20
> }
> unset($db);
> return $Result;
> }
>=20
>=20
> Looking for some suggestions - I don't know what to try next.
>=20
> JCF
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20

------=_NextPart_000_01F1_01C26228.FE7E5020
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2>Basic Troubleshooting as =
follows:</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><FONT face=3DArial size=3D2>echo $SQL; Grab it and run it using =
phpmyadmin to=20
see if it works.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>make sure if($Result) code is getting =
executed=20
(i.e echo "I'm Here" inside of {})</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BLOCKQUOTE>
<DIV dir=3Dltr><FONT face=3DArial size=3D2>eliminate the obvious first. =
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"JCF" <</FONT><A=20
href=3D"mailto:jcf@mail.org"><FONT face=3DArial =
size=3D2>jcf@mail.org</FONT></A><FONT=20
face=3DArial size=3D2>> wrote in message </FONT><A=20
href=3D"news:amknf9$lj6$1@news.codecharge.com"><FONT face=3DArial=20
size=3D2>news:amknf9$lj6$1@news.codecharge.com</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> I don't think =
this was sent=20
so I am sending again - Sorry if there is a<BR>> double.<BR>> =
<BR>> Hi=20
All<BR>> <BR>> I just don't understand why this is not =
working?<BR>>=20
<BR>> I have modified the Login function to add some more fields but =
the=20
fields<BR>> never get filled with the data, I can login and it =
authenticates=20
fine.<BR>> <BR>> When I try use the other session vars - they are =
simply=20
blank?<BR>> <BR>> Here is the modification to the Login =
function:<BR>>=20
<BR>> function CCLoginUser($Login, $Password)<BR>> {<BR>> =
<BR>>=20
    $db =3D new clsDBSD73();<BR>>     =
$SQL =3D=20
"SELECT ID, SecRights, SecUser, SecWorker, SecAdmin, Email,<BR>> =
SITENUM FROM=20
CONTACTS WHERE LoginID=3D" . $db->ToSQL($Login, ccsText) . " =
AND<BR>>=20
Password=3D" . $db->ToSQL($Password, ccsText);<BR>> =
   =20
$db->query($SQL);<BR>>     $Result =3D=20
$db->next_record();<BR>>     if($Result)<BR>>=20
    {<BR>>        =20
CCSetSession("ID", $db->f("ID"));<BR>>=20
        CCSetSession("LoginID",=20
$Login);<BR>>        =20
CCSetSession("UserPassword", $Password);<BR>>=20
        CCSetSession("SecRights",=20
$db->f("SecRights"));<BR>> =
       =20
CCSetSession("SecUser", $db->f("SecUser"));<BR>>=20
        CCSetSession("SecWorker",=20
$db->f("SecWorker"));<BR>> =
       =20
CCSetSession("SecAdmin", $db->f("SecAdmin"));<BR>>=20
        CCSetSession("Email",=20
$db->f("Email"));<BR>>        =20
CCSetSession("SITENUM", $db->f("SITENUM"));<BR>> <BR>>=20
    }<BR>>     unset($db);<BR>> =
 return=20
$Result;<BR>> }<BR>> <BR>> <BR>> Looking for some =
suggestions - I=20
don't know what to try next.<BR>> <BR>> JCF<BR>> <BR>> =
<BR>>=20
<BR>> <BR>> <BR>> <BR>> <BR>> <BR>> =
</FONT></BODY></HTML>

------=_NextPart_000_01F1_01C26228.FE7E5020--
JCF
Posted: 09/22/2002, 4:23 PM

This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C26254.571D2D20
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi=20

The $SQL is correct - I can run from the MySQL prompt, if I replace =
Login and Password.

I know the $Result is working because if I enter a name or password that =
is wrong, it tells me

I think all the Session Variable are being set but it is like I can not =
access them?

Thanks

JCF
"dsafar" <no_spam_dsafar@cool-offers.com> wrote in message =
news:amkqan$qau$1@news.codecharge.com...
Basic Troubleshooting as follows:
echo $SQL; Grab it and run it using phpmyadmin to see if it works.
make sure if($Result) code is getting executed (i.e echo "I'm Here" =
inside of {})

eliminate the obvious first.=20

"JCF" <jcf@mail.org> wrote in message =
news:amknf9$lj6$1@news.codecharge.com...
> I don't think this was sent so I am sending again - Sorry if there =
is a
> double.
>=20
> Hi All
>=20
> I just don't understand why this is not working?
>=20
> I have modified the Login function to add some more fields but the =
fields
> never get filled with the data, I can login and it authenticates =
fine.
>=20
> When I try use the other session vars - they are simply blank?
>=20
> Here is the modification to the Login function:
>=20
> function CCLoginUser($Login, $Password)
> {
>=20
> $db =3D new clsDBSD73();
> $SQL =3D "SELECT ID, SecRights, SecUser, SecWorker, SecAdmin, =
Email,
> SITENUM FROM CONTACTS WHERE LoginID=3D" . $db->ToSQL($Login, =
ccsText) . " AND
> Password=3D" . $db->ToSQL($Password, ccsText);
> $db->query($SQL);
> $Result =3D $db->next_record();
> if($Result)
> {
> CCSetSession("ID", $db->f("ID"));
> CCSetSession("LoginID", $Login);
> CCSetSession("UserPassword", $Password);
> CCSetSession("SecRights", $db->f("SecRights"));
> CCSetSession("SecUser", $db->f("SecUser"));
> CCSetSession("SecWorker", $db->f("SecWorker"));
> CCSetSession("SecAdmin", $db->f("SecAdmin"));
> CCSetSession("Email", $db->f("Email"));
> CCSetSession("SITENUM", $db->f("SITENUM"));
>=20
> }
> unset($db);
> return $Result;
> }
>=20
>=20
> Looking for some suggestions - I don't know what to try next.
>=20
> JCF
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20

------=_NextPart_000_000C_01C26254.571D2D20
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2719.2200" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Hi </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>The $SQL is correct - I can run from the MySQL =
prompt, if I=20
replace Login and Password.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I know the $Result is working because if I enter a =
name or=20
password that is wrong, it tells me</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I think all the Session Variable are being set but =
it is like=20
I can not access them?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>JCF</FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"dsafar" <<A=20
=
href=3D"mailto:no_spam_dsafar@cool-offers.com">no_spam_dsafar@cool-offers=
..com</A>>=20
wrote in message <A=20
=
href=3D"news:amkqan$qau$1@news.codecharge.com">news:amkqan$qau$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Basic Troubleshooting as =
follows:</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><FONT face=3DArial size=3D2>echo $SQL; Grab it and run it using =
phpmyadmin=20
to see if it works.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>make sure if($Result) code is =
getting executed=20
(i.e echo "I'm Here" inside of {})</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BLOCKQUOTE>
<DIV dir=3Dltr><FONT face=3DArial size=3D2>eliminate the obvious =
first.=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"JCF" <</FONT><A=20
href=3D"mailto:jcf@mail.org"><FONT face=3DArial=20
size=3D2>jcf@mail.org</FONT></A><FONT face=3DArial size=3D2>> wrote =
in message=20
</FONT><A href=3D"news:amknf9$lj6$1@news.codecharge.com"><FONT =
face=3DArial=20
size=3D2>news:amknf9$lj6$1@news.codecharge.com</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> I don't =
think this was=20
sent so I am sending again - Sorry if there is a<BR>> =
double.<BR>>=20
<BR>> Hi All<BR>> <BR>> I just don't understand why this is =
not=20
working?<BR>> <BR>> I have modified the Login function to add =
some more=20
fields but the fields<BR>> never get filled with the data, I can =
login and=20
it authenticates fine.<BR>> <BR>> When I try use the other =
session vars=20
- they are simply blank?<BR>> <BR>> Here is the modification to =
the=20
Login function:<BR>> <BR>> function CCLoginUser($Login,=20
$Password)<BR>> {<BR>> <BR>>     $db =3D new=20
clsDBSD73();<BR>>     $SQL =3D "SELECT ID, =
SecRights, SecUser,=20
SecWorker, SecAdmin, Email,<BR>> SITENUM FROM CONTACTS WHERE =
LoginID=3D" .=20
$db->ToSQL($Login, ccsText) . " AND<BR>> Password=3D" .=20
$db->ToSQL($Password, ccsText);<BR>>    =20
$db->query($SQL);<BR>>     $Result =3D=20
$db->next_record();<BR>>     if($Result)<BR>>=20
    {<BR>> =
       =20
CCSetSession("ID", $db->f("ID"));<BR>>=20
        CCSetSession("LoginID",=20
$Login);<BR>>        =20
CCSetSession("UserPassword", $Password);<BR>>=20
        CCSetSession("SecRights",=20
$db->f("SecRights"));<BR>> =
       =20
CCSetSession("SecUser", $db->f("SecUser"));<BR>>=20
        CCSetSession("SecWorker",=20
$db->f("SecWorker"));<BR>> =
       =20
CCSetSession("SecAdmin", $db->f("SecAdmin"));<BR>>=20
        CCSetSession("Email",=20
$db->f("Email"));<BR>> =
       =20
CCSetSession("SITENUM", $db->f("SITENUM"));<BR>> <BR>>=20
    }<BR>>     unset($db);<BR>>=20
 return $Result;<BR>> }<BR>> <BR>> <BR>> Looking for =
some=20
suggestions - I don't know what to try next.<BR>> <BR>> =
JCF<BR>>=20
<BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> =
<BR>>=20
</FONT></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_000C_01C26254.571D2D20--
Alexey Alexapolsky
Posted: 10/02/2002, 5:39 AM

This is a multi-part message in MIME format.

------=_NextPart_000_0054_01C26A29.97E277C0
Content-Type: text/plain;
charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

Currently in PHP pattern if session variable is set , it becomes =
available on the next page
and on current one it may not be accessible when it's just set and the =
fix will be available with CCS 1.1

--=20

Alex,
Support Engineer
CodeCharge Team

"JCF" <jcf@mail.org> wrote in message =
news:amljcs$5pv$1@news.codecharge.com...
Hi=20
=20
The $SQL is correct - I can run from the MySQL prompt, if I replace =
Login and Password.
=20
I know the $Result is working because if I enter a name or password =
that is wrong, it tells me
=20
I think all the Session Variable are being set but it is like I can =
not access them?
=20
Thanks
=20
JCF
"dsafar" <no_spam_dsafar@cool-offers.com> wrote in message =
news:amkqan$qau$1@news.codecharge.com...
Basic Troubleshooting as follows:
echo $SQL; Grab it and run it using phpmyadmin to see if it works.
make sure if($Result) code is getting executed (i.e echo "I'm =
Here" inside of {})
=20
eliminate the obvious first.=20
=20
"JCF" <jcf@mail.org> wrote in message =
news:amknf9$lj6$1@news.codecharge.com...
> I don't think this was sent so I am sending again - Sorry if there =
is a
> double.
>=20
> Hi All
>=20
> I just don't understand why this is not working?
>=20
> I have modified the Login function to add some more fields but the =
fields
> never get filled with the data, I can login and it authenticates =
fine.
>=20
> When I try use the other session vars - they are simply blank?
>=20
> Here is the modification to the Login function:
>=20
> function CCLoginUser($Login, $Password)
> {
>=20
> $db =3D new clsDBSD73();
> $SQL =3D "SELECT ID, SecRights, SecUser, SecWorker, SecAdmin, =
Email,
> SITENUM FROM CONTACTS WHERE LoginID=3D" . $db->ToSQL($Login, =
ccsText) . " AND
> Password=3D" . $db->ToSQL($Password, ccsText);
> $db->query($SQL);
> $Result =3D $db->next_record();
> if($Result)
> {
> CCSetSession("ID", $db->f("ID"));
> CCSetSession("LoginID", $Login);
> CCSetSession("UserPassword", $Password);
> CCSetSession("SecRights", $db->f("SecRights"));
> CCSetSession("SecUser", $db->f("SecUser"));
> CCSetSession("SecWorker", $db->f("SecWorker"));
> CCSetSession("SecAdmin", $db->f("SecAdmin"));
> CCSetSession("Email", $db->f("Email"));
> CCSetSession("SITENUM", $db->f("SITENUM"));
>=20
> }
> unset($db);
> return $Result;
> }
>=20
>=20
> Looking for some suggestions - I don't know what to try next.
>=20
> JCF
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20

------=_NextPart_000_0054_01C26A29.97E277C0
Content-Type: text/html;
charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT size=3D2>Currently in PHP pattern if session variable is set =
, it=20
becomes available on the next page</FONT></DIV>
<DIV><FONT size=3D2>and on current one it may not be accessible when =
it's just set=20
and the fix will be available with CCS 1.1</FONT></DIV>
<DIV><BR>-- <BR><BR>Alex,<BR>Support Engineer<BR>CodeCharge =
Team<BR></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>"JCF" <<A href=3D"mailto:jcf@mail.org">jcf@mail.org</A>> =
wrote in=20
message <A=20
=
href=3D"news:amljcs$5pv$1@news.codecharge.com">news:amljcs$5pv$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT size=3D2>Hi </FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>The $SQL is correct - I can run from the MySQL =
prompt, if I=20
replace Login and Password.</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I know the $Result is working because if I enter a =
name or=20
password that is wrong, it tells me</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>I think all the Session Variable are being set but =
it is=20
like I can not access them?</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>Thanks</FONT></DIV>
<DIV><FONT size=3D2></FONT> </DIV>
<DIV><FONT size=3D2>JCF</FONT></DIV>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; =
MARGIN-RIGHT: 0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
<DIV>"dsafar" <<A=20
=
href=3D"mailto:no_spam_dsafar@cool-offers.com">no_spam_dsafar@cool-offers=
..com</A>>=20
wrote in message <A=20
=
href=3D"news:amkqan$qau$1@news.codecharge.com">news:amkqan$qau$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2>Basic Troubleshooting as =
follows:</FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV><FONT face=3DArial size=3D2>echo $SQL; Grab it and run it =
using=20
phpmyadmin to see if it works.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>make sure if($Result) code is =
getting=20
executed (i.e echo "I'm Here" inside of {})</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BLOCKQUOTE>
<DIV dir=3Dltr><FONT face=3DArial size=3D2>eliminate the obvious =
first.=20
</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"JCF" <</FONT><A=20
href=3D"mailto:jcf@mail.org"><FONT face=3DArial=20
size=3D2>jcf@mail.org</FONT></A><FONT face=3DArial size=3D2>> =
wrote in message=20
</FONT><A href=3D"news:amknf9$lj6$1@news.codecharge.com"><FONT =
face=3DArial=20
size=3D2>news:amknf9$lj6$1@news.codecharge.com</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> I don't =
think this was=20
sent so I am sending again - Sorry if there is a<BR>> =
double.<BR>>=20
<BR>> Hi All<BR>> <BR>> I just don't understand why this is =
not=20
working?<BR>> <BR>> I have modified the Login function to add =
some=20
more fields but the fields<BR>> never get filled with the data, I =
can=20
login and it authenticates fine.<BR>> <BR>> When I try use the =
other=20
session vars - they are simply blank?<BR>> <BR>> Here is the=20
modification to the Login function:<BR>> <BR>> function=20
CCLoginUser($Login, $Password)<BR>> {<BR>> <BR>> =
   =20
$db =3D new clsDBSD73();<BR>>     $SQL =3D "SELECT =
ID,=20
SecRights, SecUser, SecWorker, SecAdmin, Email,<BR>> SITENUM FROM =

CONTACTS WHERE LoginID=3D" . $db->ToSQL($Login, ccsText) . " =
AND<BR>>=20
Password=3D" . $db->ToSQL($Password, ccsText);<BR>> =
   =20
$db->query($SQL);<BR>>     $Result =3D=20
$db->next_record();<BR>>     =
if($Result)<BR>>=20
    {<BR>> =
       =20
CCSetSession("ID", $db->f("ID"));<BR>>=20
        CCSetSession("LoginID",=20
$Login);<BR>>        =20
CCSetSession("UserPassword", $Password);<BR>>=20
        CCSetSession("SecRights", =

$db->f("SecRights"));<BR>> =
       =20
CCSetSession("SecUser", $db->f("SecUser"));<BR>>=20
        CCSetSession("SecWorker", =

$db->f("SecWorker"));<BR>> =
       =20
CCSetSession("SecAdmin", $db->f("SecAdmin"));<BR>>=20
        CCSetSession("Email",=20
$db->f("Email"));<BR>> =
       =20
CCSetSession("SITENUM", $db->f("SITENUM"));<BR>> <BR>>=20
    }<BR>>     unset($db);<BR>>=20
 return $Result;<BR>> }<BR>> <BR>> <BR>> Looking =
for some=20
suggestions - I don't know what to try next.<BR>> <BR>> =
JCF<BR>>=20
<BR>> <BR>> <BR>> <BR>> <BR>> <BR>> <BR>> =
<BR>>=20
</FONT></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0054_01C26A29.97E277C0--

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright © 2003-2004 by UltraApps.com  and YesSoftware, Inc.