Sort error when used with Filter

Hi
I have been trying to use the DA Sort behaviour and have found it only works with a plain Recordset if you try to use with a Filter ie URL Parameter it cause a parse error when run in the browser.

So if you had a store product list that you displayed according to the category ie

SELECT *
FROM products
WHERE ProductCategoryID = colname

This would cause an error when used with the Sort Beahviour is there a workaround for this?

BTW the Sort behaviour works fine as this:

SELECT *
FROM products

Obviously not much use when needing to show only products etc from a certain criteria.

Thanks

Mike

can you provide some more specifics?

What is the exact text of the error?

Can you send a copy of a page that has this problem?

Hi Jason
I get a parse error as soon as I add the sort behaviour. Like I said it does not give an error when used with a plain recordset only when you add a URL Parameter to get filtered records.

As for the page I can but would rather email that.

Mike

what is the exact test of the error?

I need to know what the error is to be able to have any idea of the cause.

I dont have enough information to go by just knowing that it is a "parse error" This really doesn't tell me anything.

perhaps you could copy and past the error or send a screen shot?

Does the error occur in Dreamweaver or in the browser?

Hi
error is very vague:

-----
Parse error: parse error in C:\wamp\www\Prod_list_cat.php on line 102
-----

Running on a local server as you can see.

The area its pointing to is:

----
mysql_select_db($database_tendringpets, $tendringpets);
$query_ProductListCT = sprintf("SELECT * FROM products WHERE ProductCategoryID = %s", GetSQLValueString($colname_ProductListCT);
setQueryBuilderSource($query_ProductListCT,$WADA_Sort_1,false);
$query_limit_ProductListCT = sprintf("%s LIMIT %d, %d", $query_ProductListCT, $startRow_ProductListCT, $maxRows_ProductListCT);
$ProductListCT = mysql_query($query_limit_ProductListCT, $tendringpets) or die(mysql_error());
$row_ProductListCT = mysql_fetch_assoc($ProductListCT);
---

2nd line is 102

Hope thats a little more useful.

I can email the page if required.

Mike

but it includes a line number which is very helpful, also tells me the error is happening in the browser, all important details to help me see whats up.

I have created a support ticket so we can look into this issue further.

To view and edit your support ticket, please log into your support history:
login.php

Hi Jason
There is no Ticket available that I can see.

Logged out and in just in case but still nothing new.

Mike

Sorry, it is there now.

Thanks Ive updated it.

Mike