[FX.php List] Pointing Clients to correct FM DB based on login info

[Jonathan Schwartz]

Jon,

Do *you* know what database the registrant should be directed to?  If 
so, then Bob's suggestion is an easy way to go.  We also assume the 
the registrant is pre-registered with username and password with the 
target database name already populated.

HTH.

Resident Beginner,

Jonathan


At 3:42 PM -0500 8/20/06, Bob Patin wrote:
>Jon,
>
>You could create a table that had the following fields:
>
>username
>password
>database_name
>
>Then, when they login (by providing a good username/password pair 
>from the above table in a FIND query), you'd then retrieve the 
>database_name from the same record.
>
>Then, you could set $dbname to $database_name from the above query.
>
>Then, in a 2nd query, you assign the database by using your $dbname variable.
>
>Bob Patin
>Longterm Solutions
><mailto:bob at longtermsolutions.com>bob at longtermsolutions.com
>615-333-6858
><http://www.longtermsolutions.com>http://www.longtermsolutions.com
>
>CONTACT US VIA INSTANT MESSAGING:
>AIM or iChat: longterm1954
>Yahoo: longterm_solutions
>MSN: <mailto:tech at longtermsolutions.com>tech at longtermsolutions.com
>ICQ: 159333060
>
>
>On Aug 20, 2006, at 3:36 PM, Jon Montgomery wrote:
>
>>Hi,
>>How do I set up a login procedure that will direct clients to one 
>>of 26 FM data bases? These clients belong to a pool that will 
>>attend and conference in various sites throughout the state. When 
>>they login, to give them permission to enter conference 
>>information, I would like it to direct them to the proper data 
>>base. I am afraid if I give them all 26 choices to select from on a 
>>page, they may select the wrong conference to enter their data.
>>I have been told that this can be done, but my mind is not thinking 
>>outside the box, or I just don't know the box well enough to think 
>>outside of it yet. Any and all help will be greatly appreciated.
>>I do find all of the posts very educational and have learned from 
>>them. Thank you for this way of QUICK FX.PHP education.
>>
>>Jon Montgomery
>>
>>--
>>Jon W. Montgomery, Vice President and Webmaster
>>Illinois Grade School Music Association - Southern Division
>>Email at: <mailto:vicepresident at onecliq.net>vicepresident at onecliq.net
>>School email at : 
>><mailto:jwmontgomery at dqud300.perry.k12.il.us>jwmontgomery at dqud300.perry.k12.il.us
>>Home phone: (618) 542-2287
>>School phone: (618) 542-2646 ext. 1133
>>Web Site: <http://www.igsmasouth.org>www.igsmasouth.org
>>
>>
>>If this email is spam, report it here:
>><http://www.OnlyMyEmail.com/reportSpam?Id=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi5jb20%3D>http://www.OnlyMyEmail.com/ReportSpam
>>_______________________________________________
>>FX.php_List mailing list
>><mailto:FX.php_List at mail.iviking.org>FX.php_List at mail.iviking.org
>><http://www.iviking.org/mailman/listinfo/fx.php_list>http://www.iviking.org/mailman/listinfo/fx.php_list
>>
>>
>>
>>--
>>If this email is spam, report it here:
>><http://www.OnlyMyEmail.com/reportSpam?Id=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi5jb20%3D>http://www.OnlyMyEmail.com/reportSpam?Id=NDIyMTM6MTU2OTkyNzUyOmJvYkBwYXRpbi5jb20%3D
>>
>
>
>_______________________________________________
>FX.php_List mailing list
>FX.php_List at mail.iviking.org
>http://www.iviking.org/mailman/listinfo/fx.php_list


-- 

Jonathan Schwartz
FileMaker 8 Certified  Developer
Associate Member, FileMaker Solutions Alliance
Schwartz & Company
jonathan at eschwartz.com
http://www.eschwartz.com
http://www.exit445.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20060820/4966f53d/attachment.html