Tim Morrison
|
| Posted: 03/27/2003, 8:43 AM |
|
I have 2 tables in MS-SQL
Login
UserID
LoginName
Password
GroupID
Projects
ProjectID
UserID
ProjectName
Status
After a user logs in using CodeCharge's login builder, how do I limit the
list of projects to those who match the {UserID}?
TIA
Tim Morrison
|
|
|
 |
Janka
|
| Posted: 03/27/2003, 8:48 AM |
|
In form at the right side data>properties>DataSourse click on ... and then
built SQL query where Field name userid is equal to userId and set type to
session.
"Tim Morrison" <sales@kjmsoftware.com> wrote in message
news:b5v9nm$8fo$1@news.codecharge.com...
> I have 2 tables in MS-SQL
>
> Login
> UserID
> LoginName
> Password
> GroupID
>
> Projects
> ProjectID
> UserID
> ProjectName
> Status
>
> After a user logs in using CodeCharge's login builder, how do I limit the
> list of projects to those who match the {UserID}?
>
> TIA
>
> Tim Morrison
>
>
|
|
|
|
Tim Morrison
|
| Posted: 03/27/2003, 9:22 AM |
|
Perfect.... I looked all over, but didnt see the "..."
Thank you.
Tim Morrison
"Janka" <bmw524@inbox.lv> wrote in message
news:b5va12$98s$1@news.codecharge.com...
> In form at the right side data>properties>DataSourse click on ... and then
> built SQL query where Field name userid is equal to userId and set type to
> session.
>
> "Tim Morrison" <sales@kjmsoftware.com> wrote in message
>news:b5v9nm$8fo$1@news.codecharge.com...
> > I have 2 tables in MS-SQL
> >
> > Login
> > UserID
> > LoginName
> > Password
> > GroupID
> >
> > Projects
> > ProjectID
> > UserID
> > ProjectName
> > Status
> >
> > After a user logs in using CodeCharge's login builder, how do I limit
the
> > list of projects to those who match the {UserID}?
> >
> > TIA
> >
> > Tim Morrison
> >
> >
>
>
|
|
|
|
Janka
|
| Posted: 03/27/2003, 9:39 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_01EB_01C2F498.BBB67B20
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_01EC_01C2F498.BBB67B20"
------=_NextPart_001_01EC_01C2F498.BBB67B20
Content-Type: text/plain;
charset="iso-8859-4"
Content-Transfer-Encoding: quoted-printable
It is a button: Please look at the picture
"Tim Morrison" <sales@kjmsoftware.com> wrote in message =
news:b5vc09$e2p$1@news.codecharge.com...
> Perfect.... I looked all over, but didnt see the "..."
>=20
> Thank you.
>=20
> Tim Morrison
>=20
> "Janka" <bmw524@inbox.lv> wrote in message
>news:b5va12$98s$1@news.codecharge.com...
> > In form at the right side data>properties>DataSourse click on ... =
and then
> > built SQL query where Field name userid is equal to userId and set =
type to
> > session.
> >
> > "Tim Morrison" <sales@kjmsoftware.com> wrote in message
> >news:b5v9nm$8fo$1@news.codecharge.com...
> > > I have 2 tables in MS-SQL
> > >
> > > Login
> > > UserID
> > > LoginName
> > > Password
> > > GroupID
> > >
> > > Projects
> > > ProjectID
> > > UserID
> > > ProjectName
> > > Status
> > >
> > > After a user logs in using CodeCharge's login builder, how do I =
limit
> the
> > > list of projects to those who match the {UserID}?
> > >
> > > TIA
> > >
> > > Tim Morrison
> > >
> > >
> >
> >
>=20
>
------=_NextPart_001_01EC_01C2F498.BBB67B20
Content-Type: text/html;
charset="iso-8859-4"
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-4">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; =
mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: LV; =
mso-fareast-language: LV; mso-bidi-language: AR-SA">It=20
is a button: Please look at the picture</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; =
mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: LV; =
mso-fareast-language: LV; mso-bidi-language: =
AR-SA"></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; =
mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: LV; =
mso-fareast-language: LV; mso-bidi-language: AR-SA"><IMG=20
height=3D178 src=3D"cid:01e601c2f487$f82dab20$0e0d0c0b@mephabaltic.com" =
width=3D202=20
v:shapes=3D"_x0000_i1025"></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Tim Morrison" <</FONT><A=20
href=3D"mailto:sales@kjmsoftware.com"><FONT face=3DArial=20
size=3D2>sales@kjmsoftware.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message </FONT><A href=3D"news:b5vc09$e2p$1@news.codecharge.com"><FONT =
face=3DArial=20
size=3D2>news:b5vc09$e2p$1@news.codecharge.com</FONT></A><FONT =
face=3DArial=20
size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> Perfect.... I =
looked all=20
over, but didnt see the "..."<BR>> <BR>> Thank you.<BR>> =
<BR>> Tim=20
Morrison<BR>> <BR>> "Janka" <</FONT><A=20
href=3D"mailto:bmw524@inbox.lv"><FONT face=3DArial=20
size=3D2>bmw524@inbox.lv</FONT></A><FONT face=3DArial size=3D2>> =
wrote in=20
message<BR>> </FONT><A =
href=3D"news:b5va12$98s$1@news.codecharge.com"><FONT=20
face=3DArial =
size=3D2>news:b5va12$98s$1@news.codecharge.com</FONT></A><FONT=20
face=3DArial size=3D2>...<BR>> > In form at the right side=20
data>properties>DataSourse click on ... and then<BR>> > =
built SQL=20
query where Field name userid is equal to userId and set type to<BR>> =
>=20
session.<BR>> ><BR>> > "Tim Morrison" <</FONT><A=20
href=3D"mailto:sales@kjmsoftware.com"><FONT face=3DArial=20
size=3D2>sales@kjmsoftware.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message<BR>> > </FONT><A=20
href=3D"news:b5v9nm$8fo$1@news.codecharge.com"><FONT face=3DArial=20
size=3D2>news:b5v9nm$8fo$1@news.codecharge.com</FONT></A><FONT =
face=3DArial=20
size=3D2>...<BR>> > > I have 2 tables in MS-SQL<BR>> > =
><BR>>=20
> > Login<BR>> > > UserID<BR>> =
>=20
> LoginName<BR>> > =
> =20
Password<BR>> > > GroupID<BR>> >=20
><BR>> > > Projects<BR>> > =
> =20
ProjectID<BR>> > > UserID<BR>> >=20
> ProjectName<BR>> >=20
> Status<BR>> > ><BR>> > > =
After a=20
user logs in using CodeCharge's login builder, how do I limit<BR>>=20
the<BR>> > > list of projects to those who match the =
{UserID}?<BR>>=20
> ><BR>> > > TIA<BR>> > ><BR>> > > Tim=20
Morrison<BR>> > ><BR>> > ><BR>> ><BR>> =
><BR>>=20
<BR>> </FONT></BODY></HTML>
------=_NextPart_001_01EC_01C2F498.BBB67B20--
------=_NextPart_000_01EB_01C2F498.BBB67B20
Content-Type: image/jpeg;
name="clip_image002.jpg"
Content-Transfer-Encoding: base64
Content-ID: <01e601c2f487$f82dab20$0e0d0c0b@mephabaltic.com>
/9j/4AAQSkZJRgABAQEAYABgAAD//gAcU29mdHdhcmU6IE1pY3Jvc29mdCBPZmZpY2X/2wBDAAoH
BwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIfIiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8
SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7
Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCACyAMoDASIAAhEBAxEB/8QAGwAAAgMBAQEAAAAAAAAAAAAA
AAQDBQYHAgH/xABJEAACAQIEAgcDBwcKBgMAAAABAgMEEQAFEiEGExQVIjFUk9EyQVEjVWFkktLT
FjVCRHSisgdDUlNxc4GRlKMkJTNyobFFYrP/xAAZAQEBAQEBAQAAAAAAAAAAAAAAAQIDBAX/xAAs
EQEAAQIDBgUEAwAAAAAAAAAAAQIRExRhA0FRoeHwBBIxgZEhUrHRIkJi/90ABAAo/9oADAMBAAIR
AxEAPwDelam509Ft7tUrg/49g4NNV9U86T8PHPqbhCizqorq+anzGpll4ikonFI6qsMZNzK10bYX
37h3bjFLU8EVkUMVRS19DVQ1NRJBSWnCvUFZhENKnY3J1bEgAG5G1/TT4amf7curnO0mNzremq+q
edJ+Hg01X1TzpPw8cth/k/zOesjpqasoZ9VXJRvIrSBYpkQuVbUgJ2BsQCNu/Hml4IzKsemajnpq
mmqYJZ0qY9enTG2lxpK6yblRYKb6hb32uVo+/l1TFng6ppqvqnnSfh4NNV9U86T8PHNDwFmsTzia
oooEgSCRpJ5TEpSUkBu0AVsVNwwB22B2u6nCFJJmWR0sFTzHzGiSeSCSUo4JRmJDCNlC9m1tz/7E
y1H3cupizwb7TVfVPOk/Dwaar6p50n4eObrwZm3VHWVo9HRelcvt35fx1adF7drTqvb3e7Eeb8O1
eQpEK6SNZZLfJKslxsCe0VCNa4B0sdzix4WmZtFXLqYs8HTNNV9U86T8PBpqvqnnSfh45EuJlxrJ
f65dWcfR1fTVfVPOk/Dwaar6p50n4eOWriRcMnry6mPo6dpqvqnnSfh4NNV9U86T8PHN1xKuJk9e
XUx9HQ9NV9U86T8PBpqvqnnSfh4wK4lXDKa9/Jj6NzpqvqnnSfh4NNV9U86T8PGLXEq4mU17+TH0
a/TVfVPOk/Dwaar6p50n4eMquJVwymvfyZjRpdNV9U86T8PBpqvqnnSfh4z64lXEyupmNF3pqvqn
nSfh4NNV9U86T8PFSuHaBEkqQsihl0sbEkXspPuxJ8NERe/fyRt7zaxnTVfVPOk/Dw2kNOUUyVYV
7DUFRiAfoO1/8sZmDiuhq6iooqfJqlKyljdqlJo2VaYgdnW2ux1966C1xvsN8NZXNJUZVRzytqkk
gR3NrXJUE450bKmv0nl1br2k0esMVnGRcV1UFflUGVxPQzZrJXpLzUDkkFR3v3W3ta+I+puNOhZR
SplkUXU0jyU0iyxltTOHu12INiBbb/PFrmH5xqf75/8A2cD5fWx0/SXo51hIB5hjIWx7je1vfjpH
ia4i1o79ydnBzJ5uJ6fPKaprchigo1q5qyeOjkQtLM8bJq7cpt39wIG527sIRQ8YwrDBDklJFRQ0
01N0RZQY2SU3e5Mhe5NjswtYW994sGJj1cI7918kcXwZTxJHl1dQU3D9JSwV6xCVY59RBRiwILSG
xN7H3WHuw5SR8W0tTl1V1NSyVOWxcmGZ5Bcx6WUKwEgUgBzvYHYbne6yI8jrHGpd2ICqouSfgMT5
ZDHUZrSQSrqjknRGF7XBYA4s+IqndHP9phwjnyviGto4IKzIqWeSnpxTxVDTaXVBfTssgUkX94/t
viXMKPijMcsgy1stjhpYH1rGlRr3C6Ru8jEAC9gCBudsaOspuHcuhE1dDSUsbNpDz1LopPfa5fv2
P+WJYssyWeFJoaKCSORQyOk0hVgdwQQ24xMzVwjn+zChhV4TzwfqX+6nriReFs6H6l/up642yZZk
sjSKlFAzRNpcLNISpsDY9rY2IP8AYRj31PlPzdH5kn3sazlenfumBSxQ4Yzkfqf+6nrj2vDWbj9U
/wBxPXBDDLUSiKCJ5ZG7kRSxP+Ax6qKaopXEdTBJC5FwsiFSR8d8M1tNEwaXteHc2H6p/uL649rw
/mg/Vf8AcX1wpj0iPIbIpYgE2AvsBcn/ACF8M1XoYNJ1chzMfq3+4vriRcjzEfq/76+uKzEq07tS
yVII0RuqEe+7BiP4Thma9DBpWS5NmA/V/wB9fXEgyiuH8x++vrikwYmZr0MGlfLlVaP5n94euJFy
2sH8z+8PXGdwYZmvQwaWmXL6ofzX7w9cSLQ1I/m/3hjK4MMxXoYNLWrSTj9D/wAjEqrWUwaSngjk
l0sFWR9K3II3IB+N/TGNwYzO3rmLfRY2NMTdYQcM1lLLzqbK8thnKyK061U3MkEm7a2NzJvv272P
djQZfRTUmW0tNJYvDCiMVOxIAG2MfgxiiuaPRqqiKvUxmH5xqf75/wD2cWE1VQyV1LHPTQNCEpxL
OGctpCJqGzW9xGwv/jhqoq8hWplWbLHeQOQ7am3N9z7eIum8O/NL/bf7+Obb4ZIYaSWSpShetWJt
IQRlba4tJsnZLD5Q277d9xiSKWiaSGNxScvVSxMdCA6Gj+VJNr3uBdu9fiL48dO4dH/xL/bf7+Dp
3DnzS/2n+/gJsuegp6anllaErA0Uqza4w+rmKWGgDmGwLjckG1wO61fRcz8paPm8nX0mK/J0aO8d
2js/5Ya6dw580v8Aaf7+PcOaZBTzxzxZW6yRsHU6mNiDcfp4BnPpDBUZRVGGeSOCtLSciB5WUGCV
QdKAm12A7vfinro6zkSsiVNJR1lW1RE0cVQzxDQgCmKBlddbc2Tc2H6QDNYW/wCU1F/VT/ZHrg/K
ai/qp/sj1xm0tKPLFzCKirqqrp645nWwQSPtMqBDDCkj6UIXmKwc6VtIdNha4OLfhRqw0dXHVSTy
pHU6ad54JYmZOWhO0pLkay4uxPdttYCX8pqL+qn+yPXB+U1F/VT/AGR64WkUuTMi5iNfLsYZVtK+
lWJjYAE3Frk27x34mSOm6RLBWRwQRuFlBppVfTpvdQxZvaXVtfdtHcMTpWcOqiqcslcgAFmZrt9J
s9seuncOfNL/AGn+/jTL5z6KXLHk6NTBpFkaW0iJokLNpCqVL2A0W0nT8f0sTirpen1jqaRDHPJF
SlY41UqySgXsLMt9G7XAv8CcQ9O4c+aX+0/38HTuHPml/tP9/AQTcvqmTX0aKXUb6OVIZm1+7T2o
wB8OyQPdfdaL8yVX7TD/AAy4sOncOfNL/af7+Dp3DnzS/wBp/v4CiwYvencOfNL/AGn+/g6dw580
v9p/v4CiwYvencOfNL/af7+Dp3DnzS/2n+/gKLBi96dw580v9p/v4OncOfNL/af7+AosGL3p3Dnz
S/2n+/g6dw580v8Aaf7+AosGL3p3DnzS/wBp/v4OncOfNL/af7+Ao85jnqM1NPBW9C5lROzzaEay
pHJIR22Vd9FrlgB3k2xXtRTJQxVZ4t7EsjxgaMu71Ck79K0n2xsCSPeBcXtcwnelz5apIppOVUT6
uSbOuqKWMMO2h2LjuZT8CDj62e1LUMUA63DpI7l9c3aDBQB+cNW2k97Eb7AblutG1qpi0W+In8wl
n//QigjngE1NU1HSJaapmgabQE16JWS9h3bL3Y0z5YivQUlHl0FVNUUaVDGaZlZib3As6jb4d9hj
NpI00tVUNE8PSKueYRuRqVXldgDYkXsw7icWcGeZjTcoxzJqgXRG7Qozou+wYgm252vizN5uLGj4
egNdl8L1kcj1kKyiF4n2UoxJJDDuKgd9zfu2395flFPTU9Q1Qwmmlyp6lEMQKxg+yQxN9W3w9/fi
oTN69KqnqVntLTRCKJtC9lQCLWtvsT34+pnWYJT8gTgpyTBcxqW5Z/R1EXt9F8QS0eVQV+epl1NX
cyJ76ajlEXsuo9kn4i2Gafh2Kr6JyK1/+OWQwa4QO0l7hrMbDYWIv39wtuh1vX9Z9Z8//i/6zQv9
HT3Wt3fRggzevpui8qfT0TXyewp0ava929/pwDknD6Q5clRLmEMcr0wqFjYqAwPco7Wotb/62vtf
DEvCyLVTU0VcXenmhjlLQ6RaQgAr2je1xsbYqWzOqenWCRo5EROWpkhRmVd9gxFxa+2+3ux7kzrM
ZHqJGqTrqShlZVAJKeyRYbWt7rYBqTKoaCKSsqGNTFT17UrQjscywJvq3t3d1v8AHHnOaOmhoqCp
po0XpCvqaEtymKtbsh+0D8b7d1vfiJs/zNipFQEKzc4GOJEu9iCxsBe4JBv34Wqq6orBGszgpECE
REVFW5ubKoA3wC+DBgwBgwYMAYMGDAGDBgwBgwYMAYMGDAGDBgwG3q84zDJ8ky18vpkqWnzGZJoi
jO7RKJ5XEYBF5CI7KDtci/xwxNxnTUcNfVz8makhro6enkiqIYxIrU8cwbVLIqt7bWse622xOJcv
SgnpaGSoq0jloK2edF5ii7Hmx2YH3aZCfdvbCtLw3k2XvLLl+ez0c7zySLLHNCxiRxGDCqshURgQ
xAC1wEABtcEGIuNaSql00OXV1ZHIyR08sYiVah2hWcKut1IPKbVdgo7JF72B8L/KBkEmaU1DFUa+
k8kJLrjXeVVaMctmEpuHTdUIGrcizafuWZFkWVR0iQZkWFJOk6a50N2WlFMAbAbaBf8A7vo2wZdk
mU5UKeKjzyeKmiWISU4qIws7RoqK7sF130xoCFZVOncEFgQ0uDC/WFF4yDzV9cHWFF4yDzV9cAxg
wv1hReMg81fXB1hReMg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9c
BXyZ7l2U8uGtmeNp5J3UiF3VUSSzO7KCEUa1uzEAX78ejxPlQgWUSVLszMvISjmadSACdUIXWoAZ
DcqBZ0/pLeszLLKPOYZw2awU5koq+hsbNYTupD+0O7l93vv3jC2acM5ZmOZT5ia7KZ5ZZ2kWPMKV
amFFaKFD2da9q9OpDXFgzCx78BeRcUZPNW9FiqnkOpE5ywSGDU6qyDnaeXdg6WGrcsoG5Ax7bPIJ
6WlfLR0yaupuk0kZJjEkd0GosR2VHNQnYtYmysRbFVDkuXwUM9JHm8ASSupKpTpjXSIBAAtlIXfk
e4ADVsNt4aPJ5KKSk5XEtEseXULUdCFpxrVS0RHNJkIfaEA6Ql9TWKm1gu8hzjrqheo5cI5cpj5l
NNzoJdgdUclhrXfSTYWZWHuubPFPlIp6AVUtTmlLUVVbPz53jtGmoIkYCqWYgaY172O9ztewsOsK
LxkHmr64BjBhfrCi8ZB5q+uDrCi8ZB5q+uAYwYX6wovGQeavrg6wovGQeavrgGMGF+sKLxkHmr64
OsKLxkHmr64BjHJ85/Pdf+0yfxHHUOsKLxkHmr645dm7K+c1zKwZWqJCCDcEajgNxT18tHlFHT0y
oaqvrZqeBpASiNeVyzAbkBY2Nha5sLrfUJ3zOvyzlUlZH1tXz65I4svgWC0S6QzHmy22Z1HtXOoW
GxOIKRKCryZIKirSCaKolkilWRVkgfmPZlv3GxIsQQQSCCCQfj5dTvypW4qqjWQ61Ss1U3MEb6dU
duXo0kopvp1XHfa4wHqm4xoqybVBSVj0PNhi6fpQRapkjaMaS3M350Y9jYtvYAkQpx3l65WmY1lH
WUEM1MtTTGpMQ6QhZFBBVyF7UsY7ZUDXfuDESQZLkFLQvRU9YsVO1TTVCoJ1OgwCEIoJudNoEve5
Nzv8PDZFkTUWXUvWRAy2kFLTuJ01LZonVztYsrQRkbae+4INsB6ouNqHM4EOWUlTXVLNIrU1PJAz
IECFjr5nLIHNj9lye3a1w2mGLjBooDUZnTvSU0eYVdOajlh0ljhFQbqFcupCwC5K7nYLY3Wd8so2
5Uw4lqlro9Y6bzoWkZX06k0shjVfk4/ZQbrfvZi3ioyLIqsPDUZkZKNp5ZxSGdAitKkqSgEDXZue
7G7bG1rAWwEsvFqwzR0kmS5iK+SVUSivBzCGSRlfVzNGm0Mg9q917txe2y6vizOiWqhV0BZ43RwN
UboxR1Nri4ZSLgkG2xIscU8GVZYmYQZhU53JW1kMquJ5pYVJCpKioQiqukc+Q917nckADFhl5yzL
aZ4Ia6Jleeacl5VJ1SSNIw2913NvotgLLBhfrCi8ZB5q+uDrCi8ZB5q+uAYwYX6wovGQeavrg6wo
vGQeavrgCh/6Df30v8bYYxX0ddRrCwargB5shsZB3F2Iwx1hReMg81fXAMYML9YUXjIPNX1wdYUX
jIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxgwv1hReMg81fXB1hReMg81fXAMYML9YUXjIPNX1wd
YUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxjk+c/nuv8A2mT+I46h1hReMg81fXHLs3ZXzmuZ
WDK1RIQQbgjUcBsRW5hTZdlVNl0lNFLXZjPAZKiFpVRQJ5L6Vdbm8YHf78S1HFseVUE75nGjT0dW
KOYxzRQo7mMSBlM0igAqy9m5INx2gNRjjpaTMMspFfNny+ooq2aeOSF4tasTKliJFYWKyH3fDEr5
Vlg5U1NnclLWpr110csLSza9OvXrVlN+XH3KNIRVXSo04D5lvFgrjm1StK8mW0arNBWKyRpJGaeK
XSdbghvlCbkKoFrkG+Gct4khzzI6vMMng6VNT60FNz4+1KFDBOYjMm4ZdwSBq33BARpuHsko6HoU
GbyJT8qEaOdEflYRGI57lb6wIY9vYOndTc3dy+lo8vp65Fz+SaorpTLJVSvDzFblrGCoVAmwRbXU
7998B//R39DxJMkbCqm6wqpJVip6Ony2SimJKuxJWeT2SqOQxKj5NgCTthleLsvaizGq5NSBltIa
qoQqupbNKjIN7FlaCQHfT3WJBvhc5NlzuamXiCeXMAyNHXtJAJYgodQAoQRkWllG6E9s77LaGq4b
yaeimpYs9npRVwPBWPFNCWqlZndi2pGCnVLKewF9s+4KADy8V08qSGDL66VxVyUUSBEU1EyGTWqF
mAICxM2okC2wJYFRDJxxlMGdRZRUB4Kp2ijkR5YdUUsgUqhQPrY9tRqRWUX9rZrSPluU9CSCHNTB
JDVy1kNQksZeKSRpC1gwKkWldbFTsfiAcEVBQxVvSV4gnAkZJKmITxKtTKqqodyFDAkIl1Uqp02K
2LAh6z2qzqmzLLIcuq6GKKunNORUUjysjCKWTVdZVuLRgWt77392Ct4uy+hpJp5YalmgapEsCKpl
jWFWdnZb7KQE0k9/Oi7tQw3VnLKypop5K6INRTmeMLKtixjeOx+i0h/xtimzTK6evi4idavL0qcy
pHpKVuYAFUxBSz7XDM1gxF7pFFtdcAxW8bUOWQOczpKmhqVaNVpqiSBWcOHKnXzOWAeVJ7Tg9i1r
ldVtlGa0ud5XDmNE+qGXUAbg2KsVYXBINmBFwSDa4JFjinOTZc7mpl4gnlzAMjR17SQCWIKHUAKE
EZFpZRuhPbO+y2tqOeipKVIOs1nK3LSzTqzuSbkn3DcnYAAdwAAAAV+Z5pmGU5fHPRUNNVrJW8hx
NVNCVaScRoRaNri7791gNr4ffOIaWempa9XgqZ1S5WKR4FdjYLztAS5bYA2JJXa5AwnUrR5jlq0z
ZhBCUrkqLlgbiOoEoFrjv02v9N98Vua8P0WZZ5HmPWeWdmpgqNVRTrLURcpkbRFLrHLQ6NxpO7uf
0rAPtDxqK3hzLatV0V9T0LmxTU0sSMJZYkkMesDWq8zvUsBdbk3F72gz3LsznaGkmdm060LwuizJ
cDXGzACRd17SEjtLv2hfNUvDaLSZbT1vENFN1VFBDStDBy7pHLDI2u8jamPR0AI0gXY2O1muGsgy
nhycPDVZSFig6PE1PSxwzOlxvNJcmRuyNxoBJYlTtpDV4ML9YUXjIPNX1wdYUXjIPNX1wDGDC/WF
F4yDzV9cHWFF4yDzV9cAxgwv1hReMg81fXB1hReMg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGOT
5z+e6/8AaZP4jjqHWFF4yDzV9ccuzdlfOa5lYMrVEhBBuCNRwGXzikop+KuIqivjnkio4xMI4JVj
ZiZIk9oq23bJ7vdivg4ZfMq2FMukYQ1VKaqISQyyuiiQxlWESMSQyntWAIseyTpFrnAzGm4qzmSH
JWzCmrPkXWSKUowDI2xQqbhkHv8AjhBZc7PMiqOHmqKN9GijenmWKLRq0adJDC2t+9jcsS12N8fW
2dX8ItO6Pw8tUfWUNfwyaPqynapVK+qZopqVg7ujieSK40IQV7AFgSxN7Ai2F6/IJcnzimoc0m6N
FPoc1HJfsxlipfQwV9iG2IBNttiCbOor+Iqqs6XNkLNPzJjq6NKPkpS5khsDbQTK+/ti+zCwspXR
ZrXT0bHhtooKOMRpTRwT6GXWzkEli25du5h9Fsbiqd8szD3WZBE7qaaHoNPHG0k9VPmCVkIAZV2a
FO8M6gqAx7akgDfC7cMVoq6Gn5sBOYVQp4HDNpN1iZXO1wpWZD3X77gEWw8KjOkUU8XDXLoSrCSi
WCcxyFihJLFi4N4ozswHYHxa8tPmXEENXDUS8O9JNNMs1IktPOFpiqoo06WBI0xRjtlvYHvJJnmm
N5aFY3DU8bIJq6jiU0qVcrl2YQROE0FwqkgkyKtgCb7kabMZY+D8zmyiXNICs1MiySIyRy6ZY0JD
OG0aVHZbZyrbd24v7Vs96W80uRyzRy0sVLLA9PKEkjjVAtypDA3jRrgjcfAkYJOt5KTo7cNXKK8c
EhppmanjZmYooJKkXdrFgzDVsbgEXzTxLRwZ7Bh7qTNvmus/07+mDqTNvmus/wBO/pjp5qeLNpI4
MPdSZt811n+nf0wdSZt811n+nf0w81PEtLomdpxB+QXCsuR1c9Oop2SUQ1YhaRiF0KBqBdjZrKLn
4DfGWFVxsZmjOe1iqqhuc+bhYWBuBplMmhiSrCwJPZb+ibbipTMn4P4RgoKGOploJ4queOSqjgZD
H3IQ5Htajv7tPdvily7LuKaHL4aEUMsMUcKo0lFnUFPK5WSZx2rns/LEFbblVNx3Y8ezriKdztVE
33qGSp44ipOkyZxmKDS7cpsyImsjMrnla9dlKNfs7aSe4HF9wFWcTvx3DTZlmVfLBTVElNUxS1jO
ok5UpCkaiDvGxuLjs/2YXlyTiiashqpMpgLx0dTTMOs4TqMxmOq7OTtzveSTp3O+NDwxRV9NxMld
WZWlH0msarrKhs0glQPyplsiL2gC0x7y1tt/fi110+WfTklNM3j1dPwYX6wovGQeavrg6wovGQea
vrj5r0mMGF+sKLxkHmr64OsKLxkHmr64BjGa4lz6nyAS1ddVTQUqsql0R3Ckja4UGwv7ztcj44ve
sKLxkHmr64zma5jl1TUVEMh50Tgo6mFmVxaxHdYjv+g4krBfJeKqPiGGWbKq+eojiYKzlJEW/fYF
gLn+zuuPiMPUs8yUFIqyuoFNFsGI/QGKygmynLKGKioo2gp4V0pGsL2A/wAtz7yTuTviGokpayly
5Gra2makMMjCnV15hRACj9ndCe8e+2Mqvuk1H9fJ9s451jQZZTUmWTxS9cZvV8uAw6KpnkVruX1k
ad3F9N/6IAxQEFSQQQR3g4sJLbVecy5NkmWmOuoaBavMZoJKquQtFEtp3vbWm5KAe178SyccUmXZ
TRVOZBDPVtMIhHLFCk6Rvp5ytM6rpYFGA1E2cW1AFsMZelBPS0MlRVpHLQVs86LzFF2PNjswPu0y
E+7e2Pj5Vlico0WdyUD0+tadoJYW5MT6S0Sh1YaNSKQLXW1lIXs40iCu43p3yzMqjJYHrTRZeasz
nQIoiYTLGHQuslmGnuW29rghrTV/FopYK1Hy2upqqly9q6QSRJIsKWlsWKyaSbxeyGudQ+DFfNXk
WRZjUo+YZkayCGB4IaeadCIlePluRIAJSWUm+pzcm/eFI9yZVllRS5hDV53JVPmNCKKeaSWFXKAy
kEaVChvlmHdbZdu+4fMz4pmhpZp8vyupqI4quKmE55YSZjUpDIiAyBgwJcAsAt1vci1yTjjKYM6i
yioDwVTtFHIjyw6opZApVCgfWx7ajUisov7WzW+vlWWMtREM7kSlmlM6Uwlh0QTc0S81SV1FuYNV
mZl3I02sB7ioKGKt6SvEE4EjJJUxCeJVqZVVVDuQoYEhEuqlVOmxWxYEI6DiKbNeI6COCmqYMtqc
vnqYpJRHpqgHg0OtmLqNLnZgp7QuLjbR4zuWZVlmV10FRHncksdJTPS0tNLLDy6eJih0qQoY25aA
FmY2G9yb4uusKLxkHmr64BjBhfrCi8ZB5q+uDrCi8ZB5q+uAYwYX6wovGQeavrg6wovGQeavrgKW
p4h6pzTLcvel1w181RzajmW5FplROzYltUkyLta17nYG0sPFuXcpmqy8DLPPG4SN5ViSOZ4uZIyr
aNTy2N3sNm3OknEM1DlmZTiWsrIDAaespJYC4HMSaRCTqBBG0fu/pXuLb1VNwwIctno5OJ6Wdswg
kp8ymeBQ0yPLNITGA4Ebf8RILkOPZ7IsQQ3GDC/WFF4yDzV9cHWFF4yDzV9cAxgwv1hReMg81fXB
1hReMg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxgwv1hReMg81
fXB1hReMg81fXAMY5PnP57r/ANpk/iOOodYUXjIPNX1xy7N2V85rmVgytUSEEG4I1HAaurzmXJsk
y0x11DQLV5jNBJVVyFooltO97a03JQD2vfiWTjiky7KaKpzIIZ6tphEI5YoUnSN9POVpnVdLAowG
omzi2oAthjL0oJ6WhkqKtI5aCtnnReYoux5sdmB92mQn3b2x8fKssTlGizuSgen1rTtBLC3JifSW
iUOrDRqRSBa62spC9nASx8XZfNFJVwQ1M2WwQc+or1VRFCvKEwBUkSE6GQ9lD7QHeDbxLxdDTzR0
tTlWYw1ssqxpSaI3kbWkjI10cqFPJkFy2xF20r2seXyjJ2aoj63kFHWRGOrpDUo6VN4hFqZ2Bk1a
FUXDj2Qe8kkgyrLEzCDMKnO5K2shlVxPNLCpIVJUVCEVV0jnyHuvc7kgAYCDNOLhTV1E6Q1MOWR1
dRHVVzKhidYoJy6hbmS6vF36RfQbEgi7lVxBN+R+YZ7BQvA1PSS1FOtQ8ciyhY9ateJ2BU/9wP8A
4OF3ybLumpPDxBPBHDPLUw06SQFIppFkDOCyFibyu1ixFz3WAGPcWT5JFkeZZUcxVxmvNNXPzIlk
kaRdLPZVCBrAdy7kXNySSH//0trHxzT0EE8tfmFDmUCtEkFZl5SKGSRxITFqklKBlWPUSZBcOotc
jVZ5Txdl+d1cVPQQ1M3MgE7SqqmKNdUiEFwSpIeJl7JN7grqUMwYzNMvzKOH/ma001PLzYJ4ZY9c
TaWUkBgym6uw3B9r42I8UFPllBVy1YzU1E80EcMjz1CsW0NI+r3WJMrbCygWCgAWwFVLxRVR8T1e
XrWZc/IroKZMtCHpcqOkTNKDr9leYzHsEaYzuNyGhxxlPT62gIfpVK2hYklhkaZuYsQACOdBLui2
k0e19DabGkOWUdTWzx10RatnE8gaVbBhGkdh9Fox/jfFHJw5liQjlZ1JN0SmMOX08tRCkdNZ43j0
sIyx0tDFYvr2XcNc3CWr/lAy6gDJXUdTSVSTtCaaompo27KRuW1tKIyLSx7atW/dsSNFRVkGYUMF
bSycynqYlliexGpWFwbHcbH34ymV5JyxLW13EZhzWad5DUU80EjKjJEhju0QRgeRG1+WpFrfEtpo
avL4II4UrYisahQXqNbEAW3ZiST9JNzgJKH/AKDf30v8bYYxX0ddRrCwargB5shsZB3F2Iwx1hRe
Mg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxgwv1hReMg81fXB1
hReMg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxjk+c/nuv/aZP
4jjqHWFF4yDzV9ccuzdlfOa5lYMrVEhBBuCNRwGrq85lybJMtMddQ0C1eYzQSVVchaKJbTve2tNy
UA9r34lk44pMsymirc3CItS0w58csSI6Rvp5yo7h2V1s4CBzZgBquCzGXpQT0tDJUVaRy0FbPOi8
xRdjzY7MD7tMhPu3tj5neVZZnXSP+dyUXTKbotV0aWE8+LtWU61a1uY+62Pa3vYWD1U8Y0VHNqnp
KxKHmzRdP0oYtUKSNINIbmbcmQexuV2uCCZuHuKcv4k6QtGbSU2kyR86KWwa+k6ondd9LbXuLbgA
gmkqchhrs55U+YwDIllmm6L0xW5jTRyJILCNXS5mka/Nb4BRcadBl/RqLmNPn0lfJJYcypmjGkC9
gFRVUd53tc+8kAABT03EmYK2rMZoaaRpYYzQnLZUkjLzRxkCV5Asyrr0l0FrsrWsQrT1PHNHQR1B
zHLqyheGWOEJUS06h3dWfSJBKY1YIpYh2U2K9+pQfrZNl1RLHNmHEE9fLC0bQyTSQKYwsscpAEaK
CGaKO9wTZdiLm/imyOgpqGKmHE1VI1PLzqad5KfmQOQ4dgRGA7OJH1FwxJYn2t8A2/EsVTw7S5xl
hSSOoq6eDt2YDXULDILqbEi7WIJUkAgkd5mPEgy7OurhR1NbLIsIigp0QMWcTsTreRRbTTtttb4t
qsvqrpMvrMmXLZM6kBWWObpXPjaXmJIJA3aBX2lG2nSBsABYCCLKssGaU2Z1GdyVdXT6LSSywjXp
WdRcIqjuqX7gPZX6bgjm3HkUOUSVdBE6y8h6iBaiEMs8Rp55YpOy40qxgbv7XZsVXUGGpo55KmlS
aakmpHa94Zihdd7b6GZd+/Ynvxmzwtw28VNDNXGWKnpIqPltUKBJGkU0Q1EAG5Woe5BG4W1rG95R
1NNTUqQzZutW63vNM8Ydt776Aq7d2wHdgH8GF+sKLxkHmr64OsKLxkHmr64Cvq80bKcvhmWkeoE2
YrTNpcKIxJPo1m/eAWGwBJJHcLkRVPEUsGYzItEj0VLVw0U8xnIlEsvL06Y9NmX5aO5LA+1sbDVD
mcQzTKVpabNqOjkSuWo1zJzQRHNzFFg695Vd791/jceanLaefMZnXOaVKKqq4a2eEqDKZYuXp0ya
7KvyMdwVJ9rcXGkGMm4ilzSekE1EkEWY0hraJ0nLs0QKX5gKjQ1pU2Bce1vsL3uM1k2W0+Vz0hmz
mlniy6kNFRIihGWIlL8wlzra0SbgIPa23Fr3rCi8ZB5q+uAYwYX6wovGQeavrg6wovGQeavrgGMG
F+sKLxkHmr64OsKLxkHmr64BjBhfrCi8ZB5q+uDrCi8ZB5q+uAYwYX6wovGQeavrg6wovGQeavrg
GMcnzn891/7TJ/EcdQ6wovGQeavrjl2bsr5zXMrBlaokIINwRqOA6RkP5qX++m//AFbFjgwYAwYM
GAMGDBgDBgwYAwYMGAMGDBgF6H/oN/fS/wAbYYwYMAYMGDAGDBgwBgwYMAYMGDAGDBgwBjk+c/nu
v/aZP4jgwYD/2Q==
------=_NextPart_000_01EB_01C2F498.BBB67B20--
|
|
|
|
Tim Morrison
|
| Posted: 03/27/2003, 11:26 AM |
|
This is a multi-part message in MIME format.
------=_NextPart_000_012E_01C2F464.811A3300
Content-Type: multipart/alternative;
boundary="----=_NextPart_001_012F_01C2F464.811A3300"
------=_NextPart_001_012F_01C2F464.811A3300
Content-Type: text/plain;
charset="iso-8859-4"
Content-Transfer-Encoding: quoted-printable
my fault.... I MEANT that i looked all over BEFORE I read your =
message.... your description of where it was was perfect.
Tim
"Janka" <bmw524@inbox.lv> wrote in message =
news:b5vd0l$gju$1@news.codecharge.com...
It is a button: Please look at the picture
"Tim Morrison" <sales@kjmsoftware.com> wrote in message =
news:b5vc09$e2p$1@news.codecharge.com...
> Perfect.... I looked all over, but didnt see the "..."
>=20
> Thank you.
>=20
> Tim Morrison
>=20
> "Janka" <bmw524@inbox.lv> wrote in message
>news:b5va12$98s$1@news.codecharge.com...
> > In form at the right side data>properties>DataSourse click on ... =
and then
> > built SQL query where Field name userid is equal to userId and set =
type to
> > session.
> >
> > "Tim Morrison" <sales@kjmsoftware.com> wrote in message
> >news:b5v9nm$8fo$1@news.codecharge.com...
> > > I have 2 tables in MS-SQL
> > >
> > > Login
> > > UserID
> > > LoginName
> > > Password
> > > GroupID
> > >
> > > Projects
> > > ProjectID
> > > UserID
> > > ProjectName
> > > Status
> > >
> > > After a user logs in using CodeCharge's login builder, how do I =
limit
> the
> > > list of projects to those who match the {UserID}?
> > >
> > > TIA
> > >
> > > Tim Morrison
> > >
> > >
> >
> >
>=20
>
------=_NextPart_001_012F_01C2F464.811A3300
Content-Type: text/html;
charset="iso-8859-4"
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-4">
<META content=3D"MSHTML 6.00.2800.1141" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>my fault.... I MEANT that i looked all =
over BEFORE=20
I read your message.... your description of where it was was=20
perfect.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Tim</FONT></DIV>
<BLOCKQUOTE=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV>"Janka" <<A =
href=3D"mailto:bmw524@inbox.lv">bmw524@inbox.lv</A>>=20
wrote in message <A=20
=
href=3D"news:b5vd0l$gju$1@news.codecharge.com">news:b5vd0l$gju$1@news.cod=
echarge.com</A>...</DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; =
mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: LV; =
mso-fareast-language: LV; mso-bidi-language: AR-SA">It=20
is a button: Please look at the picture</SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; =
mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: LV; =
mso-fareast-language: LV; mso-bidi-language: =
AR-SA"></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2><SPAN=20
style=3D"FONT-SIZE: 12pt; FONT-FAMILY: 'Times New Roman'; =
mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: LV; =
mso-fareast-language: LV; mso-bidi-language: AR-SA"><IMG=20
height=3D178 =
src=3D"cid:012901c2f496$cba40130$6801a8c0@kjm.kjmsoftware.com"=20
width=3D202 v:shapes=3D"_x0000_i1025"></SPAN></FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>"Tim Morrison" <</FONT><A=20
href=3D"mailto:sales@kjmsoftware.com"><FONT face=3DArial=20
size=3D2>sales@kjmsoftware.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message </FONT><A href=3D"news:b5vc09$e2p$1@news.codecharge.com"><FONT =
face=3DArial =
size=3D2>news:b5vc09$e2p$1@news.codecharge.com</FONT></A><FONT=20
face=3DArial size=3D2>...</FONT></DIV><FONT face=3DArial size=3D2>> =
Perfect.... I=20
looked all over, but didnt see the "..."<BR>> <BR>> Thank =
you.<BR>>=20
<BR>> Tim Morrison<BR>> <BR>> "Janka" <</FONT><A=20
href=3D"mailto:bmw524@inbox.lv"><FONT face=3DArial=20
size=3D2>bmw524@inbox.lv</FONT></A><FONT face=3DArial size=3D2>> =
wrote in=20
message<BR>> </FONT><A =
href=3D"news:b5va12$98s$1@news.codecharge.com"><FONT=20
face=3DArial =
size=3D2>news:b5va12$98s$1@news.codecharge.com</FONT></A><FONT=20
face=3DArial size=3D2>...<BR>> > In form at the right side=20
data>properties>DataSourse click on ... and then<BR>> > =
built SQL=20
query where Field name userid is equal to userId and set type =
to<BR>> >=20
session.<BR>> ><BR>> > "Tim Morrison" <</FONT><A=20
href=3D"mailto:sales@kjmsoftware.com"><FONT face=3DArial=20
size=3D2>sales@kjmsoftware.com</FONT></A><FONT face=3DArial =
size=3D2>> wrote in=20
message<BR>> > </FONT><A=20
href=3D"news:b5v9nm$8fo$1@news.codecharge.com"><FONT face=3DArial=20
size=3D2>news:b5v9nm$8fo$1@news.codecharge.com</FONT></A><FONT =
face=3DArial=20
size=3D2>...<BR>> > > I have 2 tables in MS-SQL<BR>> >=20
><BR>> > > Login<BR>> > > =
UserID<BR>> > > LoginName<BR>> =
>=20
> Password<BR>> >=20
> GroupID<BR>> > ><BR>> > =
>=20
Projects<BR>> > > ProjectID<BR>> =
>=20
> UserID<BR>> > =
> =20
ProjectName<BR>> > > Status<BR>> =
>=20
><BR>> > > After a user logs in using CodeCharge's login =
builder,=20
how do I limit<BR>> the<BR>> > > list of projects to those =
who=20
match the {UserID}?<BR>> > ><BR>> > > TIA<BR>> =
>=20
><BR>> > > Tim Morrison<BR>> > ><BR>> >=20
><BR>> ><BR>> ><BR>> <BR>>=20
</FONT></BLOCKQUOTE></BODY></HTML>
------=_NextPart_001_012F_01C2F464.811A3300--
------=_NextPart_000_012E_01C2F464.811A3300
Content-Type: image/jpeg;
name="clip_image002.jpg"
Content-Transfer-Encoding: base64
Content-ID: <012901c2f496$cba40130$6801a8c0@kjm.kjmsoftware.com>
/9j/4AAQSkZJRgABAQEAYABgAAD//gAcU29mdHdhcmU6IE1pY3Jvc29mdCBPZmZpY2X/2wBDAAoH
BwgHBgoICAgLCgoLDhgQDg0NDh0VFhEYIx8lJCIfIiEmKzcvJik0KSEiMEExNDk7Pj4+JS5ESUM8
SDc9Pjv/2wBDAQoLCw4NDhwQEBw7KCIoOzs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7Ozs7
Ozs7Ozs7Ozs7Ozs7Ozs7Ozv/wAARCACyAMoDASIAAhEBAxEB/8QAGwAAAgMBAQEAAAAAAAAAAAAA
AAQDBQYHAgH/xABJEAACAQIEAgcDBwcKBgMAAAABAgMEEQAFEiEGExQVIjFUk9EyQVEjVWFkktLT
FjVCRHSisgdDUlNxc4GRlKMkJTNyobFFYrP/xAAZAQEBAQEBAQAAAAAAAAAAAAAAAQIDBAX/xAAs
EQEAAQIDBgUEAwAAAAAAAAAAAQIRExRhA0FRoeHwBBIxgZEhUrHRIkJi/90ABAAo/9oADAMBAAIR
AxEAPwDelam509Ft7tUrg/49g4NNV9U86T8PHPqbhCizqorq+anzGpll4ikonFI6qsMZNzK10bYX
37h3bjFLU8EVkUMVRS19DVQ1NRJBSWnCvUFZhENKnY3J1bEgAG5G1/TT4amf7curnO0mNzremq+q
edJ+Hg01X1TzpPw8cth/k/zOesjpqasoZ9VXJRvIrSBYpkQuVbUgJ2BsQCNu/Hml4IzKsemajnpq
mmqYJZ0qY9enTG2lxpK6yblRYKb6hb32uVo+/l1TFng6ppqvqnnSfh4NNV9U86T8PHNDwFmsTzia
oooEgSCRpJ5TEpSUkBu0AVsVNwwB22B2u6nCFJJmWR0sFTzHzGiSeSCSUo4JRmJDCNlC9m1tz/7E
y1H3cupizwb7TVfVPOk/Dwaar6p50n4eObrwZm3VHWVo9HRelcvt35fx1adF7drTqvb3e7Eeb8O1
eQpEK6SNZZLfJKslxsCe0VCNa4B0sdzix4WmZtFXLqYs8HTNNV9U86T8PBpqvqnnSfh45EuJlxrJ
f65dWcfR1fTVfVPOk/Dwaar6p50n4eOWriRcMnry6mPo6dpqvqnnSfh4NNV9U86T8PHN1xKuJk9e
XUx9HQ9NV9U86T8PBpqvqnnSfh4wK4lXDKa9/Jj6NzpqvqnnSfh4NNV9U86T8PGLXEq4mU17+TH0
a/TVfVPOk/Dwaar6p50n4eMquJVwymvfyZjRpdNV9U86T8PBpqvqnnSfh4z64lXEyupmNF3pqvqn
nSfh4NNV9U86T8PFSuHaBEkqQsihl0sbEkXspPuxJ8NERe/fyRt7zaxnTVfVPOk/Dw2kNOUUyVYV
7DUFRiAfoO1/8sZmDiuhq6iooqfJqlKyljdqlJo2VaYgdnW2ux1966C1xvsN8NZXNJUZVRzytqkk
gR3NrXJUE450bKmv0nl1br2k0esMVnGRcV1UFflUGVxPQzZrJXpLzUDkkFR3v3W3ta+I+puNOhZR
SplkUXU0jyU0iyxltTOHu12INiBbb/PFrmH5xqf75/8A2cD5fWx0/SXo51hIB5hjIWx7je1vfjpH
ia4i1o79ydnBzJ5uJ6fPKaprchigo1q5qyeOjkQtLM8bJq7cpt39wIG527sIRQ8YwrDBDklJFRQ0
01N0RZQY2SU3e5Mhe5NjswtYW994sGJj1cI7918kcXwZTxJHl1dQU3D9JSwV6xCVY59RBRiwILSG
xN7H3WHuw5SR8W0tTl1V1NSyVOWxcmGZ5Bcx6WUKwEgUgBzvYHYbne6yI8jrHGpd2ICqouSfgMT5
ZDHUZrSQSrqjknRGF7XBYA4s+IqndHP9phwjnyviGto4IKzIqWeSnpxTxVDTaXVBfTssgUkX94/t
viXMKPijMcsgy1stjhpYH1rGlRr3C6Ru8jEAC9gCBudsaOspuHcuhE1dDSUsbNpDz1LopPfa5fv2
P+WJYssyWeFJoaKCSORQyOk0hVgdwQQ24xMzVwjn+zChhV4TzwfqX+6nriReFs6H6l/up642yZZk
sjSKlFAzRNpcLNISpsDY9rY2IP8AYRj31PlPzdH5kn3sazlenfumBSxQ4Yzkfqf+6nrj2vDWbj9U
/wBxPXBDDLUSiKCJ5ZG7kRSxP+Ax6qKaopXEdTBJC5FwsiFSR8d8M1tNEwaXteHc2H6p/uL649rw
/mg/Vf8AcX1wpj0iPIbIpYgE2AvsBcn/ACF8M1XoYNJ1chzMfq3+4vriRcjzEfq/76+uKzEq07tS
yVII0RuqEe+7BiP4Thma9DBpWS5NmA/V/wB9fXEgyiuH8x++vrikwYmZr0MGlfLlVaP5n94euJFy
2sH8z+8PXGdwYZmvQwaWmXL6ofzX7w9cSLQ1I/m/3hjK4MMxXoYNLWrSTj9D/wAjEqrWUwaSngjk
l0sFWR9K3II3IB+N/TGNwYzO3rmLfRY2NMTdYQcM1lLLzqbK8thnKyK061U3MkEm7a2NzJvv272P
djQZfRTUmW0tNJYvDCiMVOxIAG2MfgxiiuaPRqqiKvUxmH5xqf75/wD2cWE1VQyV1LHPTQNCEpxL
OGctpCJqGzW9xGwv/jhqoq8hWplWbLHeQOQ7am3N9z7eIum8O/NL/bf7+Obb4ZIYaSWSpShetWJt
IQRlba4tJsnZLD5Q277d9xiSKWiaSGNxScvVSxMdCA6Gj+VJNr3uBdu9fiL48dO4dH/xL/bf7+Dp
3DnzS/2n+/gJsuegp6anllaErA0Uqza4w+rmKWGgDmGwLjckG1wO61fRcz8paPm8nX0mK/J0aO8d
2js/5Ya6dw580v8Aaf7+PcOaZBTzxzxZW6yRsHU6mNiDcfp4BnPpDBUZRVGGeSOCtLSciB5WUGCV
QdKAm12A7vfinro6zkSsiVNJR1lW1RE0cVQzxDQgCmKBlddbc2Tc2H6QDNYW/wCU1F/VT/ZHrg/K
ai/qp/sj1xm0tKPLFzCKirqqrp645nWwQSPtMqBDDCkj6UIXmKwc6VtIdNha4OLfhRqw0dXHVSTy
pHU6ad54JYmZOWhO0pLkay4uxPdttYCX8pqL+qn+yPXB+U1F/VT/AGR64WkUuTMi5iNfLsYZVtK+
lWJjYAE3Frk27x34mSOm6RLBWRwQRuFlBppVfTpvdQxZvaXVtfdtHcMTpWcOqiqcslcgAFmZrt9J
s9seuncOfNL/AGn+/jTL5z6KXLHk6NTBpFkaW0iJokLNpCqVL2A0W0nT8f0sTirpen1jqaRDHPJF
SlY41UqySgXsLMt9G7XAv8CcQ9O4c+aX+0/38HTuHPml/tP9/AQTcvqmTX0aKXUb6OVIZm1+7T2o
wB8OyQPdfdaL8yVX7TD/AAy4sOncOfNL/af7+Dp3DnzS/wBp/v4CiwYvencOfNL/AGn+/g6dw580
v9p/v4CiwYvencOfNL/af7+Dp3DnzS/2n+/gKLBi96dw580v9p/v4OncOfNL/af7+AosGL3p3Dnz
S/2n+/g6dw580v8Aaf7+AosGL3p3DnzS/wBp/v4OncOfNL/af7+Ao85jnqM1NPBW9C5lROzzaEay
pHJIR22Vd9FrlgB3k2xXtRTJQxVZ4t7EsjxgaMu71Ck79K0n2xsCSPeBcXtcwnelz5apIppOVUT6
uSbOuqKWMMO2h2LjuZT8CDj62e1LUMUA63DpI7l9c3aDBQB+cNW2k97Eb7AblutG1qpi0W+In8wl
n//QigjngE1NU1HSJaapmgabQE16JWS9h3bL3Y0z5YivQUlHl0FVNUUaVDGaZlZib3As6jb4d9hj
NpI00tVUNE8PSKueYRuRqVXldgDYkXsw7icWcGeZjTcoxzJqgXRG7Qozou+wYgm252vizN5uLGj4
egNdl8L1kcj1kKyiF4n2UoxJJDDuKgd9zfu2395flFPTU9Q1Qwmmlyp6lEMQKxg+yQxN9W3w9/fi
oTN69KqnqVntLTRCKJtC9lQCLWtvsT34+pnWYJT8gTgpyTBcxqW5Z/R1EXt9F8QS0eVQV+epl1NX
cyJ76ajlEXsuo9kn4i2Gafh2Kr6JyK1/+OWQwa4QO0l7hrMbDYWIv39wtuh1vX9Z9Z8//i/6zQv9
HT3Wt3fRggzevpui8qfT0TXyewp0ava929/pwDknD6Q5clRLmEMcr0wqFjYqAwPco7Wotb/62vtf
DEvCyLVTU0VcXenmhjlLQ6RaQgAr2je1xsbYqWzOqenWCRo5EROWpkhRmVd9gxFxa+2+3ux7kzrM
ZHqJGqTrqShlZVAJKeyRYbWt7rYBqTKoaCKSsqGNTFT17UrQjscywJvq3t3d1v8AHHnOaOmhoqCp
po0XpCvqaEtymKtbsh+0D8b7d1vfiJs/zNipFQEKzc4GOJEu9iCxsBe4JBv34Wqq6orBGszgpECE
REVFW5ubKoA3wC+DBgwBgwYMAYMGDAGDBgwBgwYMAYMGDAGDBgwG3q84zDJ8ky18vpkqWnzGZJoi
jO7RKJ5XEYBF5CI7KDtci/xwxNxnTUcNfVz8makhro6enkiqIYxIrU8cwbVLIqt7bWse622xOJcv
SgnpaGSoq0jloK2edF5ii7Hmx2YH3aZCfdvbCtLw3k2XvLLl+ez0c7zySLLHNCxiRxGDCqshURgQ
xAC1wEABtcEGIuNaSql00OXV1ZHIyR08sYiVah2hWcKut1IPKbVdgo7JF72B8L/KBkEmaU1DFUa+
k8kJLrjXeVVaMctmEpuHTdUIGrcizafuWZFkWVR0iQZkWFJOk6a50N2WlFMAbAbaBf8A7vo2wZdk
mU5UKeKjzyeKmiWISU4qIws7RoqK7sF130xoCFZVOncEFgQ0uDC/WFF4yDzV9cHWFF4yDzV9cAxg
wv1hReMg81fXB1hReMg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9c
BXyZ7l2U8uGtmeNp5J3UiF3VUSSzO7KCEUa1uzEAX78ejxPlQgWUSVLszMvISjmadSACdUIXWoAZ
DcqBZ0/pLeszLLKPOYZw2awU5koq+hsbNYTupD+0O7l93vv3jC2acM5ZmOZT5ia7KZ5ZZ2kWPMKV
amFFaKFD2da9q9OpDXFgzCx78BeRcUZPNW9FiqnkOpE5ywSGDU6qyDnaeXdg6WGrcsoG5Ax7bPIJ
6WlfLR0yaupuk0kZJjEkd0GosR2VHNQnYtYmysRbFVDkuXwUM9JHm8ASSupKpTpjXSIBAAtlIXfk
e4ADVsNt4aPJ5KKSk5XEtEseXULUdCFpxrVS0RHNJkIfaEA6Ql9TWKm1gu8hzjrqheo5cI5cpj5l
NNzoJdgdUclhrXfSTYWZWHuubPFPlIp6AVUtTmlLUVVbPz53jtGmoIkYCqWYgaY172O9ztewsOsK
LxkHmr64BjBhfrCi8ZB5q+uDrCi8ZB5q+uAYwYX6wovGQeavrg6wovGQeavrgGMGF+sKLxkHmr64
OsKLxkHmr64BjHJ85/Pdf+0yfxHHUOsKLxkHmr645dm7K+c1zKwZWqJCCDcEajgNxT18tHlFHT0y
oaqvrZqeBpASiNeVyzAbkBY2Nha5sLrfUJ3zOvyzlUlZH1tXz65I4svgWC0S6QzHmy22Z1HtXOoW
GxOIKRKCryZIKirSCaKolkilWRVkgfmPZlv3GxIsQQQSCCCQfj5dTvypW4qqjWQ61Ss1U3MEb6dU
duXo0kopvp1XHfa4wHqm4xoqybVBSVj0PNhi6fpQRapkjaMaS3M350Y9jYtvYAkQpx3l65WmY1lH
WUEM1MtTTGpMQ6QhZFBBVyF7UsY7ZUDXfuDESQZLkFLQvRU9YsVO1TTVCoJ1OgwCEIoJudNoEve5
Nzv8PDZFkTUWXUvWRAy2kFLTuJ01LZonVztYsrQRkbae+4INsB6ouNqHM4EOWUlTXVLNIrU1PJAz
IECFjr5nLIHNj9lye3a1w2mGLjBooDUZnTvSU0eYVdOajlh0ljhFQbqFcupCwC5K7nYLY3Wd8so2
5Uw4lqlro9Y6bzoWkZX06k0shjVfk4/ZQbrfvZi3ioyLIqsPDUZkZKNp5ZxSGdAitKkqSgEDXZue
7G7bG1rAWwEsvFqwzR0kmS5iK+SVUSivBzCGSRlfVzNGm0Mg9q917txe2y6vizOiWqhV0BZ43RwN
UboxR1Nri4ZSLgkG2xIscU8GVZYmYQZhU53JW1kMquJ5pYVJCpKioQiqukc+Q917nckADFhl5yzL
aZ4Ia6Jleeacl5VJ1SSNIw2913NvotgLLBhfrCi8ZB5q+uDrCi8ZB5q+uAYwYX6wovGQeavrg6wo
vGQeavrgCh/6Df30v8bYYxX0ddRrCwargB5shsZB3F2Iwx1hReMg81fXAMYML9YUXjIPNX1wdYUX
jIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxgwv1hReMg81fXB1hReMg81fXAMYML9YUXjIPNX1wd
YUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxjk+c/nuv8A2mT+I46h1hReMg81fXHLs3ZXzmuZ
WDK1RIQQbgjUcBsRW5hTZdlVNl0lNFLXZjPAZKiFpVRQJ5L6Vdbm8YHf78S1HFseVUE75nGjT0dW
KOYxzRQo7mMSBlM0igAqy9m5INx2gNRjjpaTMMspFfNny+ooq2aeOSF4tasTKliJFYWKyH3fDEr5
Vlg5U1NnclLWpr110csLSza9OvXrVlN+XH3KNIRVXSo04D5lvFgrjm1StK8mW0arNBWKyRpJGaeK
XSdbghvlCbkKoFrkG+Gct4khzzI6vMMng6VNT60FNz4+1KFDBOYjMm4ZdwSBq33BARpuHsko6HoU
GbyJT8qEaOdEflYRGI57lb6wIY9vYOndTc3dy+lo8vp65Fz+SaorpTLJVSvDzFblrGCoVAmwRbXU
7998B//R39DxJMkbCqm6wqpJVip6Ony2SimJKuxJWeT2SqOQxKj5NgCTthleLsvaizGq5NSBltIa
qoQqupbNKjIN7FlaCQHfT3WJBvhc5NlzuamXiCeXMAyNHXtJAJYgodQAoQRkWllG6E9s77LaGq4b
yaeimpYs9npRVwPBWPFNCWqlZndi2pGCnVLKewF9s+4KADy8V08qSGDL66VxVyUUSBEU1EyGTWqF
mAICxM2okC2wJYFRDJxxlMGdRZRUB4Kp2ijkR5YdUUsgUqhQPrY9tRqRWUX9rZrSPluU9CSCHNTB
JDVy1kNQksZeKSRpC1gwKkWldbFTsfiAcEVBQxVvSV4gnAkZJKmITxKtTKqqodyFDAkIl1Uqp02K
2LAh6z2qzqmzLLIcuq6GKKunNORUUjysjCKWTVdZVuLRgWt77392Ct4uy+hpJp5YalmgapEsCKpl
jWFWdnZb7KQE0k9/Oi7tQw3VnLKypop5K6INRTmeMLKtixjeOx+i0h/xtimzTK6evi4idavL0qcy
pHpKVuYAFUxBSz7XDM1gxF7pFFtdcAxW8bUOWQOczpKmhqVaNVpqiSBWcOHKnXzOWAeVJ7Tg9i1r
ldVtlGa0ud5XDmNE+qGXUAbg2KsVYXBINmBFwSDa4JFjinOTZc7mpl4gnlzAMjR17SQCWIKHUAKE
EZFpZRuhPbO+y2tqOeipKVIOs1nK3LSzTqzuSbkn3DcnYAAdwAAAAV+Z5pmGU5fHPRUNNVrJW8hx
NVNCVaScRoRaNri7791gNr4ffOIaWempa9XgqZ1S5WKR4FdjYLztAS5bYA2JJXa5AwnUrR5jlq0z
ZhBCUrkqLlgbiOoEoFrjv02v9N98Vua8P0WZZ5HmPWeWdmpgqNVRTrLURcpkbRFLrHLQ6NxpO7uf
0rAPtDxqK3hzLatV0V9T0LmxTU0sSMJZYkkMesDWq8zvUsBdbk3F72gz3LsznaGkmdm060LwuizJ
cDXGzACRd17SEjtLv2hfNUvDaLSZbT1vENFN1VFBDStDBy7pHLDI2u8jamPR0AI0gXY2O1muGsgy
nhycPDVZSFig6PE1PSxwzOlxvNJcmRuyNxoBJYlTtpDV4ML9YUXjIPNX1wdYUXjIPNX1wDGDC/WF
F4yDzV9cHWFF4yDzV9cAxgwv1hReMg81fXB1hReMg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGOT
5z+e6/8AaZP4jjqHWFF4yDzV9ccuzdlfOa5lYMrVEhBBuCNRwGXzikop+KuIqivjnkio4xMI4JVj
ZiZIk9oq23bJ7vdivg4ZfMq2FMukYQ1VKaqISQyyuiiQxlWESMSQyntWAIseyTpFrnAzGm4qzmSH
JWzCmrPkXWSKUowDI2xQqbhkHv8AjhBZc7PMiqOHmqKN9GijenmWKLRq0adJDC2t+9jcsS12N8fW
2dX8ItO6Pw8tUfWUNfwyaPqynapVK+qZopqVg7ujieSK40IQV7AFgSxN7Ai2F6/IJcnzimoc0m6N
FPoc1HJfsxlipfQwV9iG2IBNttiCbOor+Iqqs6XNkLNPzJjq6NKPkpS5khsDbQTK+/ti+zCwspXR
ZrXT0bHhtooKOMRpTRwT6GXWzkEli25du5h9Fsbiqd8szD3WZBE7qaaHoNPHG0k9VPmCVkIAZV2a
FO8M6gqAx7akgDfC7cMVoq6Gn5sBOYVQp4HDNpN1iZXO1wpWZD3X77gEWw8KjOkUU8XDXLoSrCSi
WCcxyFihJLFi4N4ozswHYHxa8tPmXEENXDUS8O9JNNMs1IktPOFpiqoo06WBI0xRjtlvYHvJJnmm
N5aFY3DU8bIJq6jiU0qVcrl2YQROE0FwqkgkyKtgCb7kabMZY+D8zmyiXNICs1MiySIyRy6ZY0JD
OG0aVHZbZyrbd24v7Vs96W80uRyzRy0sVLLA9PKEkjjVAtypDA3jRrgjcfAkYJOt5KTo7cNXKK8c
EhppmanjZmYooJKkXdrFgzDVsbgEXzTxLRwZ7Bh7qTNvmus/07+mDqTNvmus/wBO/pjp5qeLNpI4
MPdSZt811n+nf0wdSZt811n+nf0w81PEtLomdpxB+QXCsuR1c9Oop2SUQ1YhaRiF0KBqBdjZrKLn
4DfGWFVxsZmjOe1iqqhuc+bhYWBuBplMmhiSrCwJPZb+ibbipTMn4P4RgoKGOploJ4queOSqjgZD
H3IQ5Htajv7tPdvily7LuKaHL4aEUMsMUcKo0lFnUFPK5WSZx2rns/LEFbblVNx3Y8ezriKdztVE
33qGSp44ipOkyZxmKDS7cpsyImsjMrnla9dlKNfs7aSe4HF9wFWcTvx3DTZlmVfLBTVElNUxS1jO
ok5UpCkaiDvGxuLjs/2YXlyTiiashqpMpgLx0dTTMOs4TqMxmOq7OTtzveSTp3O+NDwxRV9NxMld
WZWlH0msarrKhs0glQPyplsiL2gC0x7y1tt/fi110+WfTklNM3j1dPwYX6wovGQeavrg6wovGQea
vrj5r0mMGF+sKLxkHmr64OsKLxkHmr64BjGa4lz6nyAS1ddVTQUqsql0R3Ckja4UGwv7ztcj44ve
sKLxkHmr64zma5jl1TUVEMh50Tgo6mFmVxaxHdYjv+g4krBfJeKqPiGGWbKq+eojiYKzlJEW/fYF
gLn+zuuPiMPUs8yUFIqyuoFNFsGI/QGKygmynLKGKioo2gp4V0pGsL2A/wAtz7yTuTviGokpayly
5Gra2makMMjCnV15hRACj9ndCe8e+2Mqvuk1H9fJ9s451jQZZTUmWTxS9cZvV8uAw6KpnkVruX1k
ad3F9N/6IAxQEFSQQQR3g4sJLbVecy5NkmWmOuoaBavMZoJKquQtFEtp3vbWm5KAe178SyccUmXZ
TRVOZBDPVtMIhHLFCk6Rvp5ytM6rpYFGA1E2cW1AFsMZelBPS0MlRVpHLQVs86LzFF2PNjswPu0y
E+7e2Pj5Vlico0WdyUD0+tadoJYW5MT6S0Sh1YaNSKQLXW1lIXs40iCu43p3yzMqjJYHrTRZeasz
nQIoiYTLGHQuslmGnuW29rghrTV/FopYK1Hy2upqqly9q6QSRJIsKWlsWKyaSbxeyGudQ+DFfNXk
WRZjUo+YZkayCGB4IaeadCIlePluRIAJSWUm+pzcm/eFI9yZVllRS5hDV53JVPmNCKKeaSWFXKAy
kEaVChvlmHdbZdu+4fMz4pmhpZp8vyupqI4quKmE55YSZjUpDIiAyBgwJcAsAt1vci1yTjjKYM6i
yioDwVTtFHIjyw6opZApVCgfWx7ajUisov7WzW+vlWWMtREM7kSlmlM6Uwlh0QTc0S81SV1FuYNV
mZl3I02sB7ioKGKt6SvEE4EjJJUxCeJVqZVVVDuQoYEhEuqlVOmxWxYEI6DiKbNeI6COCmqYMtqc
vnqYpJRHpqgHg0OtmLqNLnZgp7QuLjbR4zuWZVlmV10FRHncksdJTPS0tNLLDy6eJih0qQoY25aA
FmY2G9yb4uusKLxkHmr64BjBhfrCi8ZB5q+uDrCi8ZB5q+uAYwYX6wovGQeavrg6wovGQeavrgKW
p4h6pzTLcvel1w181RzajmW5FplROzYltUkyLta17nYG0sPFuXcpmqy8DLPPG4SN5ViSOZ4uZIyr
aNTy2N3sNm3OknEM1DlmZTiWsrIDAaespJYC4HMSaRCTqBBG0fu/pXuLb1VNwwIctno5OJ6Wdswg
kp8ymeBQ0yPLNITGA4Ebf8RILkOPZ7IsQQ3GDC/WFF4yDzV9cHWFF4yDzV9cAxgwv1hReMg81fXB
1hReMg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxgwv1hReMg81
fXB1hReMg81fXAMY5PnP57r/ANpk/iOOodYUXjIPNX1xy7N2V85rmVgytUSEEG4I1HAaurzmXJsk
y0x11DQLV5jNBJVVyFooltO97a03JQD2vfiWTjiky7KaKpzIIZ6tphEI5YoUnSN9POVpnVdLAowG
omzi2oAthjL0oJ6WhkqKtI5aCtnnReYoux5sdmB92mQn3b2x8fKssTlGizuSgen1rTtBLC3JifSW
iUOrDRqRSBa62spC9nASx8XZfNFJVwQ1M2WwQc+or1VRFCvKEwBUkSE6GQ9lD7QHeDbxLxdDTzR0
tTlWYw1ssqxpSaI3kbWkjI10cqFPJkFy2xF20r2seXyjJ2aoj63kFHWRGOrpDUo6VN4hFqZ2Bk1a
FUXDj2Qe8kkgyrLEzCDMKnO5K2shlVxPNLCpIVJUVCEVV0jnyHuvc7kgAYCDNOLhTV1E6Q1MOWR1
dRHVVzKhidYoJy6hbmS6vF36RfQbEgi7lVxBN+R+YZ7BQvA1PSS1FOtQ8ciyhY9ateJ2BU/9wP8A
4OF3ybLumpPDxBPBHDPLUw06SQFIppFkDOCyFibyu1ixFz3WAGPcWT5JFkeZZUcxVxmvNNXPzIlk
kaRdLPZVCBrAdy7kXNySSH//0trHxzT0EE8tfmFDmUCtEkFZl5SKGSRxITFqklKBlWPUSZBcOotc
jVZ5Txdl+d1cVPQQ1M3MgE7SqqmKNdUiEFwSpIeJl7JN7grqUMwYzNMvzKOH/ma001PLzYJ4ZY9c
TaWUkBgym6uw3B9r42I8UFPllBVy1YzU1E80EcMjz1CsW0NI+r3WJMrbCygWCgAWwFVLxRVR8T1e
XrWZc/IroKZMtCHpcqOkTNKDr9leYzHsEaYzuNyGhxxlPT62gIfpVK2hYklhkaZuYsQACOdBLui2
k0e19DabGkOWUdTWzx10RatnE8gaVbBhGkdh9Fox/jfFHJw5liQjlZ1JN0SmMOX08tRCkdNZ43j0
sIyx0tDFYvr2XcNc3CWr/lAy6gDJXUdTSVSTtCaaompo27KRuW1tKIyLSx7atW/dsSNFRVkGYUMF
bSycynqYlliexGpWFwbHcbH34ymV5JyxLW13EZhzWad5DUU80EjKjJEhju0QRgeRG1+WpFrfEtpo
avL4II4UrYisahQXqNbEAW3ZiST9JNzgJKH/AKDf30v8bYYxX0ddRrCwargB5shsZB3F2Iwx1hRe
Mg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxgwv1hReMg81fXB1
hReMg81fXAMYML9YUXjIPNX1wdYUXjIPNX1wDGDC/WFF4yDzV9cHWFF4yDzV9cAxjk+c/nuv/aZP
4jjqHWFF4yDzV9ccuzdlfOa5lYMrVEhBBuCNRwGrq85lybJMtMddQ0C1eYzQSVVchaKJbTve2tNy
UA9r34lk44pMsymirc3CItS0w58csSI6Rvp5yo7h2V1s4CBzZgBquCzGXpQT0tDJUVaRy0FbPOi8
xRdjzY7MD7tMhPu3tj5neVZZnXSP+dyUXTKbotV0aWE8+LtWU61a1uY+62Pa3vYWD1U8Y0VHNqnp
KxKHmzRdP0oYtUKSNINIbmbcmQexuV2uCCZuHuKcv4k6QtGbSU2kyR86KWwa+k6ondd9LbXuLbgA
gmkqchhrs55U+YwDIllmm6L0xW5jTRyJILCNXS5mka/Nb4BRcadBl/RqLmNPn0lfJJYcypmjGkC9
gFRVUd53tc+8kAABT03EmYK2rMZoaaRpYYzQnLZUkjLzRxkCV5Asyrr0l0FrsrWsQrT1PHNHQR1B
zHLqyheGWOEJUS06h3dWfSJBKY1YIpYh2U2K9+pQfrZNl1RLHNmHEE9fLC0bQyTSQKYwsscpAEaK
CGaKO9wTZdiLm/imyOgpqGKmHE1VI1PLzqad5KfmQOQ4dgRGA7OJH1FwxJYn2t8A2/EsVTw7S5xl
hSSOoq6eDt2YDXULDILqbEi7WIJUkAgkd5mPEgy7OurhR1NbLIsIigp0QMWcTsTreRRbTTtttb4t
qsvqrpMvrMmXLZM6kBWWObpXPjaXmJIJA3aBX2lG2nSBsABYCCLKssGaU2Z1GdyVdXT6LSSywjXp
WdRcIqjuqX7gPZX6bgjm3HkUOUSVdBE6y8h6iBaiEMs8Rp55YpOy40qxgbv7XZsVXUGGpo55KmlS
aakmpHa94Zihdd7b6GZd+/Ynvxmzwtw28VNDNXGWKnpIqPltUKBJGkU0Q1EAG5Woe5BG4W1rG95R
1NNTUqQzZutW63vNM8Ydt776Aq7d2wHdgH8GF+sKLxkHmr64OsKLxkHmr64Cvq80bKcvhmWkeoE2
YrTNpcKIxJPo1m/eAWGwBJJHcLkRVPEUsGYzItEj0VLVw0U8xnIlEsvL06Y9NmX5aO5LA+1sbDVD
mcQzTKVpabNqOjkSuWo1zJzQRHNzFFg695Vd791/jceanLaefMZnXOaVKKqq4a2eEqDKZYuXp0ya
7KvyMdwVJ9rcXGkGMm4ilzSekE1EkEWY0hraJ0nLs0QKX5gKjQ1pU2Bce1vsL3uM1k2W0+Vz0hmz
mlniy6kNFRIihGWIlL8wlzra0SbgIPa23Fr3rCi8ZB5q+uAYwYX6wovGQeavrg6wovGQeavrgGMG
F+sKLxkHmr64OsKLxkHmr64BjBhfrCi8ZB5q+uDrCi8ZB5q+uAYwYX6wovGQeavrg6wovGQeavrg
GMcnzn891/7TJ/EcdQ6wovGQeavrjl2bsr5zXMrBlaokIINwRqOA6RkP5qX++m//AFbFjgwYAwYM
GAMGDBgDBgwYAwYMGAMGDBgF6H/oN/fS/wAbYYwYMAYMGDAGDBgwBgwYMAYMGDAGDBgwBjk+c/nu
v/aZP4jgwYD/2Q==
------=_NextPart_000_012E_01C2F464.811A3300--
|
|
|
|
DonB
|
| Posted: 03/27/2003, 12:45 PM |
|
I've set up my login form with event code that writes the session id (for
ASPers, that's Session.SessionID) to my User table (where the login reads
username and password as users log in.
Then I set up my queries so they join with the user table so my WHERE
clauses depend on the current session id matching what was written when they
logged on to access any data in the database. No match, no rows returned
and/or no rows inserted/updated.
The session var for UserID is pretty secure since it's all server-side, but
I feel my approach was pretty much impenetrable. I don't know if the
Session variable could be hacked (well, I guess the answer is "yes" because
anything is possible).
DonB
"Tim Morrison" <sales@kjmsoftware.com> wrote in message
news:b5vc09$e2p$1@news.codecharge.com...
> Perfect.... I looked all over, but didnt see the "..."
>
> Thank you.
>
> Tim Morrison
>
> "Janka" <bmw524@inbox.lv> wrote in message
>news:b5va12$98s$1@news.codecharge.com...
> > In form at the right side data>properties>DataSourse click on ... and
then
> > built SQL query where Field name userid is equal to userId and set type
to
> > session.
> >
> > "Tim Morrison" <sales@kjmsoftware.com> wrote in message
> >news:b5v9nm$8fo$1@news.codecharge.com...
> > > I have 2 tables in MS-SQL
> > >
> > > Login
> > > UserID
> > > LoginName
> > > Password
> > > GroupID
> > >
> > > Projects
> > > ProjectID
> > > UserID
> > > ProjectName
> > > Status
> > >
> > > After a user logs in using CodeCharge's login builder, how do I limit
> the
> > > list of projects to those who match the {UserID}?
> > >
> > > TIA
> > >
> > > Tim Morrison
> > >
> > >
> >
> >
>
>
|
|
|
|
Tim Morrison
|
| Posted: 03/27/2003, 1:18 PM |
|
The process suggested by "Janka" seems to be working fine. Ive been trying
to hack it, but cannot so far.
Tim Morrison
"DonB" <dbweb2@premiersi.com> wrote in message
news:b5vntm$c0g$1@news.codecharge.com...
> I've set up my login form with event code that writes the session id (for
> ASPers, that's Session.SessionID) to my User table (where the login reads
> username and password as users log in.
>
> Then I set up my queries so they join with the user table so my WHERE
> clauses depend on the current session id matching what was written when
they
> logged on to access any data in the database. No match, no rows returned
> and/or no rows inserted/updated.
>
> The session var for UserID is pretty secure since it's all server-side,
but
> I feel my approach was pretty much impenetrable. I don't know if the
> Session variable could be hacked (well, I guess the answer is "yes"
because
> anything is possible).
>
> DonB
>
> "Tim Morrison" <sales@kjmsoftware.com> wrote in message
>news:b5vc09$e2p$1@news.codecharge.com...
> > Perfect.... I looked all over, but didnt see the "..."
> >
> > Thank you.
> >
> > Tim Morrison
> >
> > "Janka" <bmw524@inbox.lv> wrote in message
> >news:b5va12$98s$1@news.codecharge.com...
> > > In form at the right side data>properties>DataSourse click on ... and
> then
> > > built SQL query where Field name userid is equal to userId and set
type
> to
> > > session.
> > >
> > > "Tim Morrison" <sales@kjmsoftware.com> wrote in message
> > >news:b5v9nm$8fo$1@news.codecharge.com...
> > > > I have 2 tables in MS-SQL
> > > >
> > > > Login
> > > > UserID
> > > > LoginName
> > > > Password
> > > > GroupID
> > > >
> > > > Projects
> > > > ProjectID
> > > > UserID
> > > > ProjectName
> > > > Status
> > > >
> > > > After a user logs in using CodeCharge's login builder, how do I
limit
> > the
> > > > list of projects to those who match the {UserID}?
> > > >
> > > > TIA
> > > >
> > > > Tim Morrison
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
Tim Morrison
|
| Posted: 03/27/2003, 1:23 PM |
|
A sample of what I am working on can be found at http://www.kjmsoftware.com
(Click on "Client Login" , username & password is guest)
Tim
"DonB" <dbweb2@premiersi.com> wrote in message
news:b5vntm$c0g$1@news.codecharge.com...
> I've set up my login form with event code that writes the session id (for
> ASPers, that's Session.SessionID) to my User table (where the login reads
> username and password as users log in.
>
> Then I set up my queries so they join with the user table so my WHERE
> clauses depend on the current session id matching what was written when
they
> logged on to access any data in the database. No match, no rows returned
> and/or no rows inserted/updated.
>
> The session var for UserID is pretty secure since it's all server-side,
but
> I feel my approach was pretty much impenetrable. I don't know if the
> Session variable could be hacked (well, I guess the answer is "yes"
because
> anything is possible).
>
> DonB
>
> "Tim Morrison" <sales@kjmsoftware.com> wrote in message
>news:b5vc09$e2p$1@news.codecharge.com...
> > Perfect.... I looked all over, but didnt see the "..."
> >
> > Thank you.
> >
> > Tim Morrison
> >
> > "Janka" <bmw524@inbox.lv> wrote in message
> >news:b5va12$98s$1@news.codecharge.com...
> > > In form at the right side data>properties>DataSourse click on ... and
> then
> > > built SQL query where Field name userid is equal to userId and set
type
> to
> > > session.
> > >
> > > "Tim Morrison" <sales@kjmsoftware.com> wrote in message
> > >news:b5v9nm$8fo$1@news.codecharge.com...
> > > > I have 2 tables in MS-SQL
> > > >
> > > > Login
> > > > UserID
> > > > LoginName
> > > > Password
> > > > GroupID
> > > >
> > > > Projects
> > > > ProjectID
> > > > UserID
> > > > ProjectName
> > > > Status
> > > >
> > > > After a user logs in using CodeCharge's login builder, how do I
limit
> > the
> > > > list of projects to those who match the {UserID}?
> > > >
> > > > TIA
> > > >
> > > > Tim Morrison
> > > >
> > > >
> > >
> > >
> >
> >
>
>
|
|
|
|
|
