I created, in my search form, a form pulldown list element which i called 'sortby' and when I submit my search, i replaced my 'order by' SQL statement with the varSortby which had the value of the 'sortby' list.

here is my list code (for my dvd database):

<select name="sortby">
<option value="title">Title</option>
<option value="edition">Edition</option>
<option value="rating">Rating</option>
<option value="year">Year</option>
<option value="length">Length</option>
<option value="producer">Producer</option>
<option value="isbn">ISBN</option>
</select>

here is my SQL var:

<%
Dim rsSearch__varSortby
rsSearch__varSortby = "xyz"
if (Request.Form("sortby" <> "" then rsSearch__varSortby = Request.Form("sortby"
%>

and here is my SQL ORDERBY string:

"' ORDER BY '" + Replace(rsSearch__varSortby, "'", "''"

Rather than the usual "' ORDER BY Title '" or what ever Dreamweaver does for you.

Remove ' from ORDER BY string.

" ORDER BY " + Replace(rsSearch__varSortby, "'", "''"

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
I created, in my search form, a form pulldown list element which i called 'sortby' and when I submit my search, i replaced my 'order by' SQL statement with the varSortby which had the value of the 'sortby' list.

here is my list code (for my dvd database):

&lt;select name="sortby"&gt;
&lt;option value="title"&gt;Title&lt;/option&gt;
&lt;option value="edition"&gt;Edition&lt;/option&gt;
&lt;option value="rating"&gt;Rating&lt;/option&gt;
&lt;option value="year"&gt;Year&lt;/option&gt;
&lt;option value="length"&gt;Length&lt;/option&gt;
&lt;option value="producer"&gt;Producer&lt;/option&gt;
&lt;option value="isbn"&gt;ISBN&lt;/option&gt;
&lt;/select&gt;

here is my SQL var:

&lt;%
Dim rsSearch__varSortby
rsSearch__varSortby = "xyz"
if (Request.Form("sortby" &lt;&gt; "" then rsSearch__varSortby = Request.Form("sortby"
%&gt;

and here is my SQL ORDERBY string:

"' ORDER BY '" + Replace(rsSearch__varSortby, "'", "''"

Rather than the usual "' ORDER BY Title '" or what ever Dreamweaver does for you.


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

This wasn't really a question, but a help for those with questions about it.

The ORDER BY string works fine.

I do have a question however about how to number the results. Suppose I pull all records, rather than the first 10... I place a # column. I would like to have the first result show a '1' in the first row, a '2' in the second row and so on.

Anyone know how to do this?

For some reason, my first - previous - next - last navigation hasn't been working lately, so I am forced to pull the entire record. <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>

When using Repeat Region Server Behavior, UD creates variable Repeat1__index. That where is stored information about record number.

To display it code should look like:

&lt;%=Repeat1__index%&gt; - &lt;%=(RecordsetName.Fields.Item("FielName".Value)%&gt;

<BLOCKQUOTE id=quote><font size=1 face="Verdana, Arial, Helvetica" id=quote>quote:<hr height=1 noshade id=quote>
This wasn't really a question, but a help for those with questions about it.

The ORDER BY string works fine.

I do have a question however about how to number the results. Suppose I pull all records, rather than the first 10... I place a # column. I would like to have the first result show a '1' in the first row, a '2' in the second row and so on.

Anyone know how to do this?

For some reason, my first - previous - next - last navigation hasn't been working lately, so I am forced to pull the entire record. <img src=../images/dmxzone/forum/icon_smile_sad.gif border=0 align=middle>


<hr height=1 noshade id=quote></BLOCKQUOTE id=quote></font id=quote><font face="Verdana, Arial, Helvetica" size=2 id=quote>

Viktor Farcic

TalkZone Manager

I couldn't quite follow that example. Has anyone done it using PHP? And, would it still work, if I didn't want to associate these "row numbers" with any distinct record, I'd just like to have a ascending column of row numbers before the actual data in the record? So that, when I sort the table by some other field, then those numbers wouldn't go out of order (they would still be ascending from top to bottom).

Thank you.

Less is more1