Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › My sorting is not working and I may have some vulnerable GET code that should be updated.

View all replies to this thread

My sorting is not working and I may have some vulnerable GET code that should be updated.

Thread began 10/17/2019 1:14 pm by jo271221 | Last modified 10/18/2019 10:24 am by jo271221 | 378 views | 2 replies

10/18/2019 9:40 amRay BorduinWebAssist

The $_GET references are ok. They are always referenced with GetSQLValueString... that has SQL injection protection built in.

The issue with the sorting is due to the data type you are using. Since you are using varchar fields, the order is different than numeric ordering.

That column has a month set to "10"... well using a varchar sort, "10" comes before "2". I updated your SQL to convert the text value to an integer before sorting and that has fixed your issue.

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.