sir paul or anybody, could you please help me with several questions:

1. SqlGridSelectedView works fine in querying the database and displaying the records. what really bothers me is that, you have to enter the statement manually on the module. WHAT IF (actually this is what I really need), I need to change the select statement dynamically, showing records of a certain employee that is logged in???

example: I log in as hapidose, then I click on a page 'summary' that has the sqlgridselectedview module. I would like to see my quiz scores, quiz dates and others with my employee number 1111. It should display ONLY MY RECORDS. and when another employee logs in, say, paul, he should see his own records. so how can I go about with this using the module???

2. This also goes out to updating records...

Thanks so much sirs/madams, I hope you could help a newbie with this. THANKS!!!

Why not just use the built in token '[DNN:UserID]'? I use this and the role token '[DNN:Roles]'. i.e.Where user 'IS IN [DNN:Roles]'

Both of these are covered in the User manual (p.33).

---

this is really great! even if still don't grasp the idea, atleast i know that this is possible, whew! thank you so much to both of you who took time to answer my question, I will get to this very shortly and I will update you guys if I will be able to pull it of. again, many thanks to you guys and I am very happy because in my work, nobody helps me with this because I'm the only developer. thank you very much for the knowledge, you shall be rewarded by the greater entity one way or another. =P

 

sir paul, you must be proud of these small things, people trying to contribute and spreading out the goodness of your work, again many thanks! more power to you and your endeavors.

 

I'll get back to you guys for updates!