query of query not sorting properly
Copy link to clipboard
Copied
I am using query of query to run against a product search using verity. I have sort buttons that can sort the results by name or price, asc and desc. When sorting by price, it is not sorting properly. Here is an example:
And so on. What is going on? Is there any way to fix this? Thanks.
Copy link to clipboard
Copied
This is sorting properly. It is sorting as a string. To get it to sort numerically you need to convert it to a number.
Copy link to clipboard
Copied
Thank you for the help. I did not know this. How would I go about converting it? I have tried both a cast function from TSQL and a LSParseNumber(string) function from ColdFusion, but neither work. I'm not sure what to do.
Copy link to clipboard
Copied
Whats the database field type? What code have you tried already?

