MX Dynamic Table Sorter Forum :: Sorter and alias
This thread was displayed: 246 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
Molly Boucher
07-13-2006 01:11:13 GMT +2
|
Hello,
I have a recordset containing an alias for one of the field
names. It seems that I can’t sort by the
column with the alias. I simplified my
recordset for testing purposes. The simplified
recordset is
SELECT ProjectID, ProjectName, ProjectType1,
ProjectSubType1, ProjectType2, ProjectSubType2 AS SubType2 FROM tblProject ORDER BY orderParam
I would like to sort by all columns, but get an error (Too
few parameters. Expected 1.) when sorting by SubType2. I am using version 1.8.0, Dreamweaver 8.0.2
and VB script.
Any advice would be greatly appreciated. Thanks!
|
|
|
Catalin ANASTASOAIE[InterAKT]  07-13-2006 16:09:53 GMT +2
|
Hello,
Please make a zip folder containing your page and your database file and then upload it in order for us to take a look at your page and try to find the problem.
Best Regards,
Catalin Anastasoaie
|
|
|
Molly Boucher
07-14-2006 18:47:05 GMT +2
|
Attached is a zip of the page and db file. I run into an error when sorting by the column labeled Type2. Here's a link to the page too. Thanks for taking a look.
Molly
|
|
|
Florin CARLIG[InterAKT] 07-20-2006 15:50:58 GMT +2
|
Hello Molly,
Indeed, this problem seems to be caused by a bug in our software. Unfortunately, for the moment we cannot offer a fix, but it will be addressed in the next version of MXTable Sorter.
Please accept our appologies for this inconvenience.
Regards,
Florin
|
|
|
