I have a database table with fields "sign" and " horoscope". There will be 12 disctinct values for sign ( aries, taurus, etc.) The corresponding horoscope field will have the horoscope ( obviously). I have a page which is used to change the weekly horoscope. This is an HTML page with two fields SIGN and HOROSCOPE. These values are passed on to an ASP page which creates a filtered recordset based on the SIGN value received thru REQUSET.FORM. Then there is again a button which finally updates the data in the table.

I wanted to create only one ASP page to do this. But when i did it using ultradev, the problem is that how do i get the filtered recordset. I tried to make the current value of the SIGN field as the filter but somehow the page randomly updates any field.

Plz help

OK so i guess nobody in the UD world knows how to do this !!!