close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DataAssist sortable columns?

Thread began 12/08/2019 10:26 am by sandy170299 | Last modified 7/27/2021 1:45 pm by Ray Borduin | 569 views | 6 replies |

sandy170299

DataAssist sortable columns?

Is there any way using DataAssist to make column headings sortable? Is there a tutorial somewhere for DataAssist? Thanks.

Sign in to reply to this post

Ray BorduinWebAssist

There is a sort server behavior that you can use.

There is an old tutorial on the topic. It should still be relevant:
http://www.webassist.com/tutorials/How-to-enable-sorting-of-dynamic-data

Sign in to reply to this post
Did this help? Tips are appreciated...

sandy170299

Perfect! And it's working great. But here's the catch... One of my fields is based on an IF statement, so it could potentially be showing data from one field or the other field.

Basically, this is what is displayed in the recordset table results.

<?php if($to == $sess) {
echo $frm;
} else {
echo $to;
}

My question is ... which field would I actually bind the sort to given this scenario? Ack! :/

Also, I want to use a default sort order, which could complicate things even more. I guess I would have to use an if statement within the query to choose between two queries depending on if a sort order is specified or not? Is this possible?

EXAMPLE: if ((((!isset($_GET["sort"]))?$_GET["sort"]:"") = "")) { — something like this? Would this even work?

Thank you! :)

Sign in to reply to this post

Ray BorduinWebAssist

There is a default order by in the Server Behavior you can use to set the initial sort.

For the dynamic column display you could pass the column name in the url parameter and use it so it wouldn't matter which was being displayed.

Sign in to reply to this post
Did this help? Tips are appreciated...

DeanCollins

My problem is that, in the latest version of Windows 10, the "Select File" box has no radio button labeled File system" and no URL text box or "Parameters" button.

Sign in to reply to this post

Ray BorduinWebAssist

Yes, url parameters have to be added manually now. You can just add them to the url after selecting the page like:

page.php?param=value

You can get the correct syntax for dynamic values can be set using the bindings panel.

Sign in to reply to this post
Did this help? Tips are appreciated...

DeanCollins

Thanks!

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...