display latest clients added

hi i have created this recordset:

SELECT *
FROM clients JOIN users ON clients.ClientUserID = users.UserID
ORDER BY clients.DateCreated DESC

however i only get 1 client returned when i click test yet there is 3 in there.

i did have at bottom:

LIMIT 5

but that made no difference, could someone tell me what i am missing to be able to display latest 5 clients added?

similar to display latest 5 orders in your powerstore demo but instead i want to use my latest clients added.

thanks for your help

that looks like it should do the trick, there are two things I can think of:


1) you have not included a repeat region around the recordset out put.

2) There is not a match in the in the users.UserID column for the other clients.ClientUserID records, try using a right join or a left join.

hi jason,

i have looked at the database online and can see there is no client_userid for the other clients.

i have looked at my insert page and i have created a client_userid hidden field and set the value of it to the session variable userid however it does not seem to be inserting into the database??

have i missed something out?

thanks again

change it to a text field so you can see if it is actually getting a value. edit type="hidden" to type="text", you can always change it back.



have you bond the client_userid hidden form element to the client_userid column in the insert record server behavior?

mmmmmmm, not sure what i did was when i went throught the wizard was select the client_userid to be a hidden field on page. i then selected the client_userid hidden form field and clicked the lightning bolt next to it and chose the session variable userid.

what other steps should i have taken?

i will try what you said re using a text field instead to see if it gets a value and report back to you.

thanks again jason

just change the type attribute to text so you can see right away if the element has an value.