select id from mytable where id=45 order by name,name2;
Why do you want to select id if you already know it ? Do you not want to specify a starting value for name and name2 ?
I'll presume you want to select a row by its 'id' and then get the previous and next ones in the name, name2 order. I'll guess the id is UNIQUE so these two other rows won't have the same id.
If I guessed right I have the solution, if I'm not please explain what you wanna do more precisely ;)
sorry for being unclear.
but you guessed right. ID is UNIQUE and and I want to select a row by its ID and also get the previous and next ones in the name, name2-order.
For the selected row I need all datafields and for the next and previous I need only the ID (to have it referenced on the dataoutputpage for a certain row).
I'm very looking forward for your solution. thnx a lot,
peter
and then I'd like to select the two entries that would come before and after according to the order "name,name2";
id is not ordered, but there is an index on (name,name2) so the needed infomation about previous, next should be stored somewhere in this index.
My current solution is to read all the data without the WHERE-clause and then fetch the needed ones, which is quite time-demanding.
thnx, peter
-- mag. peter pilsl goldfisch.at IT-management tel +43 699 1 3574035 fax +43 699 4 3574035 [EMAIL PROTECTED]
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
