Hi Gary
You can achive this by many ways. One way is...
First you have number of records returned from the Store procedure and you
got equal number of empty fields for Quantity Returned and name the fields
dynamically with the suffix of line numbers... (say QtyReturned1,
QtyReturned2..etc)
Also While fetching the records, build list (say LineItemList) for the line
Numbers. Now when you post the form, you can loop thru the list
(LineNumberList) and get the value of the exact QtyReturned field by using
the List index of the LineItemList...and then you can this value..
I hope this will help if still you have problem write me, i can send you
some sample codes
Regards
-Balaji
From: "Houk, Gary" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: <[EMAIL PROTECTED]>
Subject: Quick Array help please!
Date: Wed, 26 Sep 2001 11:38:58 -0400
OK, I've had the books open for a while now and I'm still stumped. Here
is my problem:
There is a stored procedure that returns me the following:
line number
product
description
quantity ordered
price
I use this sp on my form page. As I output it, I need to add in a text
box for Quantity Returned. I have that. Now the problem begins. I need a
way of associating the text box with the line it is on. I guess I could
use the line number. The problem is, that on my action page, I need to
insert the new Quantity Returned field, along with all of the other line
items, back into the table. How do I associate this field with each
line? Our DB Admin mentioned that I should probably use an array. I had
it working for just calling up the products, but I have no idea how to
change the Return quantity field or loop over it to get the info into a
database.
Thanks in advance for any help/code examples.
- Gary
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
