bsgbiz_com
Posts: 8
|
| Posted: 09/09/2005, 1:00 PM |
|
I used the Authentication Builder to build the login App. How do I access the query builder to modify the login logic? I want to build a query so that more than 2 data fields are validated before access is granted. 4 fields are in Table 1, the 3rd or 4th fields will be in table 2. The user will only have to provide Login ID and Password. The logic will pull the First and Last Name for the login ID from Table 1 and look to see if the first and last name is in a list of authorized users listed in a second table.
In table 1, the query will look for LoginID AND Password and store First Name and Last Name. The query will then use AND = First Name in Table 2 And = Last Name in Table 2.
(SORRY for not using sql syntex.)
How will get get the First Name and Last Name from Table 1?
In general, I cannot find the query builder. (Duh)
Support told me that I can access it in step 2 of the Builder wizard, but I don't see where to access it.
Supposedly, it is available via the Grid Builder, but I can't add a grid to a page that has a grid.
Thanks!
_________________
Greg Bush |
 |
 |
bsgbiz_com
Posts: 8
|
| Posted: 09/09/2005, 1:28 PM |
|
More.... I have a list of authorized users in table 2, because the system lets anyone register in my shopping cart and pay for access.
Once they pay for access, they will get info on how to login. This is when the authorized members list is checked.
(syntex SP? above = syntax )
_________________
Greg Bush |
|
|
|
DonB
|
| Posted: 09/09/2005, 5:30 PM |
|
Sounds like you will have to develop your own custom login function(s). CCS
is designed to use one table with username, password, groupid and to grant
access based on which groupid a particular user belongs to. You described
another layer on top of that.
For the record (no pun intended) the query builder is accessed from the Data
Source property - there's a button that takes you to the query builder while
you have the Data Source opened for changes.
--
DonB
http://www.gotodon.com/ccbth
"bsgbiz_com" <bsgbiz_com@forum.codecharge> wrote in message
news:64321f0723e101@news.codecharge.com...
> More.... I have a list of authorized users in table 2, because the system
lets
> anyone register in my shopping cart and pay for access.
>
> Once they pay for access, they will get info on how to login. This is
when the
> authorized members list is checked.
>
> (syntex SP? above = syntax )
> _________________
> Greg Bush
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
bsgbiz_com
Posts: 8
|
| Posted: 09/09/2005, 9:07 PM |
|
Thanks. I'll post what I end up doing to make this work.
_________________
Greg Bush |
|
|
|
peterr
Posts: 5971
|
| Posted: 09/09/2005, 10:04 PM |
|
You may also be able to find related solutions discussed in the forums by searching for the name of the login function:
http://forums.codecharge.com/search.php?s_keyword=CCLog...g=2&s_forum[]=6
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
