R2i DotNetNuke® Forum

R2i wants you to have the opportunity to ask questions, post reviews, help others or just rant and rave about DotNetNuke® or any of the R2i Modules and Skins. Our team spends hour upon hour, day after day, working on custom DotNetNuke® modules and services; please feel free to ask us anything.
 
Query Filter with UserID
Last Post 01 Jan 1900 05:00 AM by . 1 Replies.
Printer Friendly
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Informative
ronblackUser is Offline
New Member
New Member
Posts:3

--
11 Jun 2007 05:27 PM  
I'm a complete newby so here goes.

I want to allow registered users to add and view personal records that no other user can see. I have built a table with all the fields, one of which is dnnuserid

I have used the quickbuider to build add/edit and list view pages. They work properly.

Now I would like to know how to populate the dnnuserid with the logged in user id, and how to retrieve the records based on eht loggd in userid.

Thanks In Advance

Ron
pauldesUser is Offline
Veteran Member
Veteran Member
Posts:1392

--
12 Jun 2007 02:05 AM  
When you add a record, for the userid column in your table, pass [ModuleId,System]. When you list the "personal records" you select the fields from the table....

WHERE tablename.userid = [UserId,System]
ListX....makes you look brilliant, even though you're not.
You are not authorized to post a reply.

Active Forums 4.1
 

New York, NY • Baltimore, MD • Vienna, VA • St. Louis, MO • Seatle, WA • 410.327.0007 • info@R2Integrated.com

Bookmark & Share Bookmark and Share