I have a table on my ASP page that is dynamically generated depending on the
parameters the user sets (the values they enter in input boxes).  The first
column of this table is a checkbox followed by a few more fields.  The checkbox:

'I can't copy and paste my code (% and HTML tags) because it comes out jarbled in
the posting so I'm simplifying...

name=Choose value=rsDistro.Fields("sku").Value" type=checkbox

As you see above the value of the checkbox column is only set to one field, the
sku field.  This is a problem since there are two primary keys that make a unique
record in this recordset (order_date and sku).  How do I set the value of the
checkbox to both primary keys?

(
Background on why I'm trying to figure out the above:
I'm writing client-side javascript and server-side VBScript.  Once I figure this
out I want to be able to update this record:

Dim intSKU, dtOrderDate, sql
intSKU = Request.Form("sku")
dtOrderDate = Request.Form("order_date")
...
sql = "UPDATE table1 SET qty = intQty WHERE sku = intSKU and order_date =
dtOrderDate"
...
)

Thank you for any help you can give.

Lynn

Seperate the values with a comma for example
and take it from there

value='" + rs("bla1") + "," + rs("bla2") + "'

--
--
Best Regards
  Vidar Petursson
 ==============================
   Microsoft Internet, Client, SDK MVP
 ==============================
 http://www.icysoft.com
 http://www.dna.is



 ==============================
  No matter where you go there you are
 ==============================
--

Hi,

I have a table on my ASP page that is dynamically generated depending on the
parameters the user sets (the values they enter in input boxes).  The first
column of this table is a checkbox followed by a few more fields.  The
checkbox:

'I can't copy and paste my code (% and HTML tags) because it comes out
jarbled in
the posting so I'm simplifying...

name=Choose value=rsDistro.Fields("sku").Value" type=checkbox

As you see above the value of the checkbox column is only set to one field,
the
sku field.  This is a problem since there are two primary keys that make a
unique
record in this recordset (order_date and sku).  How do I set the value of
the
checkbox to both primary keys?

(
Background on why I'm trying to figure out the above:
I'm writing client-side javascript and server-side vbscript.  Once I figure
this
out I want to be able to update this record:

Dim intSKU, dtOrderDate, sql
intSKU = Request.Form("sku")
dtOrderDate = Request.Form("order_date")
...
sql = "UPDATE table1 SET qty = intQty WHERE sku = intSKU and order_date =
dtOrderDate"
...
)

Thank you for any help you can give.

Lynn