greymalking
Posts: 4
|
| Posted: 05/23/2005, 12:39 PM |
|
Hi... my friends... Help me Please !!!!!
I have a Login Form connected for a table called 'LOGIN' in the Access Database called DATAHOST.MDB with the conection called DATACAR created in the CODECHARGE with the fields below:
Codigo ----> Contain the ID-Users
Nivel ----> Contain the Level Users
Login ----> Contain the Login Users
Senha ----> Contain the Password Users
Usuario ----> Contain the Name Users
URL ----> Contain the Redirect Page Address
I need to redirect my user for your respective page stored in the field 'URL' of Database according your respective login and password stored in the fields 'LOGIN' (Login) and 'SENHA' (password).
How I do ???? Please... help-me!!!!
Very, Very thanks....
Greymalking
e-mail:greymalking@bol.com.br
_________________
E-mail: Greymalking@bol.com.br |
 |
 |
peterr
Posts: 5971
|
| Posted: 05/23/2005, 1:00 PM |
|
You can find solutions here: http://forums.codecharge.com/search.php?s_keyword=login...m[]=6&s_period=
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
greymalking
Posts: 4
|
| Posted: 05/23/2005, 6:58 PM |
|
I am Sorry Peterr...
I look for examples conform you said, but I not found nothing similar my problem, because in my case the URL to redirect the users is store for database in the field 'URL' conform login and password of users and in the your examples this is supplied the URL manually for code.
Do you understand my problem?
Do you can to give a code example conform my problem explained above?
Do you can help me? Please!!!
I need very very much to resolve this problem with urgency....
I thank you very much... Peterr
Greymalking
e-mail:greymalking@bol.com.br
_________________
E-mail: Greymalking@bol.com.br |
|
|
|
dhodgdon
Posts: 80
|
| Posted: 05/23/2005, 7:05 PM |
|
Hello Greymalking,
Let CCS handle the login operation and use the CCGetUserID(), which is created uniquely for each user, and CCDLookUp() to lookup the URL for the user from the login table. Once you lookup the URL simply redirect. I am not sure if this can go in the login page before unload event or if it needs to go in the after initialize event of the return page of the login record.
The forum search Peterr provided has a lot more information with details and variations. Just thought I would give you a quick solution though not necessarily the best.
_________________
Regards,
David Hodgdon
|
|
|
|
dhodgdon
Posts: 80
|
| Posted: 05/23/2005, 7:51 PM |
|
Hello Greymalking,
Example of my description...
dim userhomepage
dim dbconnection
set dbconnection = NewclsDBdatacar
dbconnection.open
userhomepage = CCDLookUp("url","login","codigo=" & dbconnection.ToSQL(CCGetUserID(),ccsInteger),dbconnection)
dbconnection.close
redirect = userhomepage
I know this works in the after initialize event of the return page. You will have to experiment to see if it works in the before unload event of the login page.
For more info on CCDLookUp:
http://docs.codecharge.com/studio/html/Components/Funct...LookUp.html?toc
For more info on CCGetUserID
http://docs.codecharge.com/studio/html/Components/Funct...UserID.html?toc
_________________
Regards,
David Hodgdon
|
|
|
|
peterr
Posts: 5971
|
| Posted: 05/23/2005, 8:51 PM |
|
Sorry Greymalking. I don't know your level of experience and I assumed that you would need to be able to modify some of the solution described by others. As David pointed you will need to use the CCDLookup function to retrieve the page URL/address.
So, try to implement the solution proposed by others to understand how it works, then test and apply the CCDLookup function.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
