It is currently Mon May 20, 2019 10:25 am

Post new topic Reply to topic  [ 2 posts ] 
Visual Query Builder UserLogon 
Author Message

Joined: Thu Apr 09, 2009 5:45 pm
Posts: 3
Post Visual Query Builder UserLogon
Hi there,

I am currently building an update database page and want to show field values based on a UserLogon

however i can't seem to get the query right, can some one help me out?

table table
(table.username = "UserLogon")

how do you get the value of the user logon in the query right?

greetings jim

Wed Feb 17, 2010 11:46 pm
Profile E-mail

Joined: Thu Jan 28, 2010 3:20 am
Posts: 5
Post Re: Visual Query Builder UserLogon
I'm new and not an expert database guy, but the tool has been great.

If you have security on (the users are logging in), you can set filter by user. dbQ sets a "Session variable" for the user based on their userlogin. It can then automatically filter so they only access records with a field that matches their userlogin within the record.

If you need to do a custom php to update the table, you can access the _SESSION variable also.

Fri Feb 19, 2010 11:52 am
Profile E-mail
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Copyright © 2004-2008 TheDevShop Ltd. All Rights Reserved