[thelist] asp/vbscript array problems

[Ken Schaefer]

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Pringle, Ron
: Subject: [thelist] asp/vbscript array problems
: 
<snip>
: 
: Basically, its an events calendar that can have multiple dates assigned to
: an event. For each date for a particular event there can be Agendas and
: Minutes assigned to it. Because there are multiple dates for events, I
: have
: to grab the last dateID from the eventDates table so that I can increment
: it
: by 1 for each event date and write it to the committeeDocs table to create
: the relation between the two tables.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Warning, Warning, Warning!

Why don't you just use an autonumber field (assuming Access) and have the
DBMS take care of generating the IDs for you? You can use SELECT @@IDENTITY
to get newly generated IDs if required.

Cheers
Ken

--
www.adOpenStatic.com/cs/blogs/ken/