can button show something other than value?

[brian4cards]

http://www.igearonline.com/subscribe/admin.asp

I created a table that is filled with database records. On each row of
the table I have a delete submit button to delete that record. I need
to associate one of the database fields with the delete button so I can
send that information back to the server side. Something like:

<input type="submit" name="delete" value= <% =rs.Fields(6) %> />

Then on server side i can do Request.Form("delete") and get the
database field to use for my query statement. But I still want the
button to say 'Delete'. Anyone have any suggestions?

[Jim Moe]

brian4cards wrote:

<input type="submit" name="delete" value= <% =rs.Fields(6) %> />

Then on server side i can do Request.Form("delete") and get the
database field to use for my query statement. But I still want the
button to say 'Delete'. Anyone have any suggestions?

Looks like you already found a solution using the ID attribute. Its
value should be quoted.
Or you could use <input type="hidden" ...> to identify the database field.

--
jmm dash list (at) sohnen-moe (dot) com
(Remove .AXSPAMGN for email)

[brian4cards]

Im not sure what you mean by using the ID attribute. Can i do <
input.........id= <% =rs.Fields(6) %> /> and then return the id value
to server side?

[Benjamin Niemann]

Jim Moe wrote:

brian4cards wrote:

<input type="submit" name="delete" value= <% =rs.Fields(6) %> />

Then on server side i can do Request.Form("delete") and get the
database field to use for my query statement. But I still want the
button to say 'Delete'. Anyone have any suggestions?

Looks like you already found a solution using the ID attribute. Its
value should be quoted.
Or you could use <input type="hidden" ...> to identify the database
field.

The problem is probably that you cannot enclose each table row in a <form>
of its own...

I usually do this sort of thing by using buttons like
<input type="submit" name="deleteNNN" value="Delete row">
where NNN is the database id that identifies the row.
In by server-side script I scan all name/value pairs in the form looking for
any name that matches the regular expression "delete\d+" and extract the id
from it.

--
Benjamin Niemann
Email: pink at odahoda dot de
WWW: http://www.odahoda.de/

[Benjamin Niemann]

Benjamin Niemann wrote:

Jim Moe wrote:

brian4cards wrote:

<input type="submit" name="delete" value= <% =rs.Fields(6) %> />

Then on server side i can do Request.Form("delete") and get the
database field to use for my query statement. But I still want the
button to say 'Delete'. Anyone have any suggestions?

Looks like you already found a solution using the ID attribute. Its
value should be quoted.
Or you could use <input type="hidden" ...> to identify the database
field.

The problem is probably that you cannot enclose each table row in a <form>
of its own...

If the whole table is not a child of a form element (the other table cells
do not contain any input element), every delete button could be wrapped
into a form with any hidden inputs you may need.

--
Benjamin Niemann
Email: pink at odahoda dot de
WWW: http://www.odahoda.de/

[Jim Moe]

brian4cards wrote:

Im not sure what you mean by using the ID attribute. Can i do <
input.........id= <% =rs.Fields(6) %> /> and then return the id value
to server side?

My mistake. I confused this with another discussion.
Use <input type="hidden" ...>.

--
jmm dash list (at) sohnen-moe (dot) com
(Remove .AXSPAMGN for email)

[Harlan Messinger]

brian4cards wrote:

http://www.igearonline.com/subscribe/admin.asp

I created a table that is filled with database records. On each row of
the table I have a delete submit button to delete that record. I need
to associate one of the database fields with the delete button so I can
send that information back to the server side. Something like:

<input type="submit" name="delete" value= <% =rs.Fields(6) %> />

Then on server side i can do Request.Form("delete") and get the
database field to use for my query statement. But I still want the
button to say 'Delete'. Anyone have any suggestions?

One way to handle it--which admittedly makes your page bigger--is to put
a separate form in each Edit and each Delete cell, rather than wrapping
the whole table in a single form.

<td ...>
<form ...>
<div>
<input type="hidden" name="personID" value="<%= rs.Fields(6) %>">
<input type="submit" name="delete" value="Delete">
</div>
</form>
</td>

[brian4cards]

Thank you all for your help, the multiple form technique worked!!

[Leif K-Brooks]

brian4cards wrote:

<input type="submit" name="delete" value= <% =rs.Fields(6) %> />

Then on server side i can do Request.Form("delete") and get the
database field to use for my query statement. But I still want the
button to say 'Delete'. Anyone have any suggestions?

Well, in theory you could use <button type="submitt" name="delete"
value="<% =rs.Fields(6) %>">Delete</button>, but unfortunately Internet
Explorer's lack of working support for <button> makes this impractical.

As a practical solution, you could give each button a different name, as
in <input type="submit" name="delete<% =rs.Fields(6) %>" valie="Delete">
and then check which name is present on the server side.

[brian4cards]

Adding those forms made each row larger (i guess that is what you were
talking about). Is there anyway to minimize the height of the rows?