I have a need to be able to select one of four sort orders. What I would like to be able to do is to select one from a group of radio buttons to determine the sort order. As this is not part of SGSV, I'm looking for an alternative way of doing this.

Does anyone have any ideas?

Joe,

This is where I resort to a stored procedure. One of the parameters passed in will be the store order. I use a DisplayValue list to define the appropriate selection and pass the corresponding value to the stored procedure.

Typically in the stored procedure you build the required SQL and use the exec statement to execute the build up SQL String.

Hope this helps
Paul.

That will work fine for display, but it won't work inside of a SQL query.

But, I am beginning to understand that one way of viewing SGSV is as a very versatile tool for passing parameters to stored procedures and then displaying the results.

So, I will be rewriting my advanced search to utilize a stored procedure. I was already using one to format a complex response.

Again, thanks for this wonderful module.