[ic] query more-list losing value-extended / searchspec

IC ic at tvcables.co.uk
Wed May 26 14:53:41 UTC 2010


Hi folks,

When using more=1 inside an sql query how do you retain the searchspec past
the initial page?

This question seems to have been raised a couple of times but no fix was
found.

I am using:-

[query sql="some sql statement"
         type=list
         more=1
         ml=20]
[list]

display code...

[/list]

[more_list]
	Matches [matches] of [match-count] shown.<BR>
 	[more]
[/more_list]
[/query]

The more pages show the correct products but have lost the searchspec and
scratch variables.

If I set a scratch:-

[seti somescratch][value-extended name="mv_searchspec" index="1"
ascii="1"][/seti]

The scratch gets overwritten with the new empty searchspec on the first more
page, so how can I retain the searchspec or a scratch through the more pages
generated by the query?

Thanks,
Andy.




More information about the interchange-users mailing list