Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Sort again

Thread began 5/31/2018 11:39 am by vernon webb | Last modified 5/31/2018 1:00 pm by Ray Borduin | 628 views | 4 replies |

5/31/2018 11:39 am | #1 vernon webb

Sort again

This is a different page with the sort setup on it. When I click a column header the page refreshes and then only one record is now being displayed on the page

5/31/2018 12:02 pm | #2 vernon webb

I've actually found the problem it's throwing an error on line 555 which simply doesn't make sense sense it's a simply echo from the recordset...

5/31/2018 12:14 pm | #3 Ray BorduinWebAssist

The recordset is in an IF statement, so it doesn't always exist. I've updated your code so that the IF statement includes the code that writes the value so that it won't try to reference a recordset that hasn't been created.

Did this help? Tips are appreciated...

5/31/2018 12:46 pm | #4 vernon webb

OK it's working but the sort isn't. Feel like I'm going in circles.

5/31/2018 1:00 pm | #5 Ray BorduinWebAssist

You had a whole bunch of static orders set in your sort server behavior. Those should be added to the SQL statement directly so that the sort server behavior only has the dynamic sort column. I've updated that and the page works properly now.

Did this help? Tips are appreciated...

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.