|
| |
|
|
MikeO
Posts: 16
From: near Geneva France
Status: offline
 |
Updating an Access Database from a Table in a Form - 2/12/2002 18:34:30
Can somebody help as I am a little rusty on VBScript.
I have a table with generated by DRW which has been modified to include text boxes on each row. Submit sends an array to my .asp update page for each box eg
RecID : 3,56,77,105,122,123......
Slection : Y,Y,N,Y,N,Y, ......
What is the VB syntax for using these arrays, ie how are they Dim'ed as an array and how can I find the number of occurrences so I can use For n = 1 to x to update the database ?
Thanks.
Mike O
|
|
|
|
Mojo
Posts: 2441
From: Chicago
Status: offline
|
RE: Updating an Access Database from a Table in a Form - 2/12/2002 19:08:45
There are a few way to dim an array --
Dim arr(5)
Dim arr() - dynamic
Redim arr(10)- can change size of the array
The above are for single dimension array's. There are assorted details about each that you should check out.
I you had a string "RecID" that looked like:
"3,56,77,105,122,123"
You could do something like:
arrRecID = Split(RecID,",")
For i = 0 to UBound(arrRecID)
...
Next
Remember that VBS starts a count at zero (0).
Joe
| |
|
|
|
MikeO
Posts: 16
From: near Geneva France
Status: offline
|
RE: Updating an Access Database from a Table in a Form - 2/13/2002 0:21:23
Hi Spooky, looks like the old place has had a lick of paint since I was last around.
Mike O
| |
|
|
|
MikeO
Posts: 16
From: near Geneva France
Status: offline
|
RE: Updating an Access Database from a Table in a Form - 2/17/2002 14:38:29
Thanks Joe, it works now.
My problem was it's not a true array, the values are seperated by ", " not ","
Mike O
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
