close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

display latest clients added

Thread began 4/15/2010 2:15 pm by mr hankey | Last modified 4/16/2010 5:37 pm by Jason Byrnes | 686 views | 5 replies |

mr hankey

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

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

mr hankey

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

Sign in to reply to this post

Jason ByrnesWebAssist

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?

Sign in to reply to this post

mr hankey

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

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...