Hi, I wrote a page that runs on a

[eyal]

Hi,
I wrote a page that runs on a DB with the criteria below:
sql = "SELECT * FROM main WHERE (((main.fixed)=off));"
Set R = c.Execute(SQL)
Do until r.EOF %>

ID: &nbsp;<%Response.Write r(&quot;id&quot%><BR>
Name: &nbsp;<%Response.Write r(&quot;name&quot%><BR>
Phone:&nbsp;<%Response.Write r(&quot;phone&quot%><BR>
Department:&nbsp;<%Response.Write r(&quot;dept&quot%><BR>
PC manufacture:&nbsp;<%Response.Write r(&quot;manuf&quot%><BR>
Software/ Hardware:&nbsp;<%Response.Write r(&quot;hardsoft&quot%><BR>
OS:&nbsp;<%Response.Write r(&quot;os&quot%><BR>
Description:&nbsp;<%Response.Write r(&quot;description&quot%><BR>
Urgency:&nbsp;<%Response.Write r(&quot;urgency&quot%><BR>
Date:&nbsp;<%Response.Write r(&quot;date&quot%><BR>
<STRONG>Fixed ? </STRONG>
<INPUT type=&quot;checkbox&quot; name=&quot;fixedyesno&quot; value=&quot;fixed&quot; ><BR>

<% r.MoveNext
loop
%>

When the user checks all or some of the checkboxes and press submit
I want the DB to get updated, my problem is how to update the relevant
record? (only the ones that been checked).

Thanks
Eyal [sig][/sig]

 

[crystalized]

I don't know if this will help but it might give you some ideas. This is an article for creating an updateable grid.

http://www.asptoday.com/articles/19990312.htm

[sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]