[thelist] asp/vbscript array problems
Ken Schaefer
Ken at adOpenStatic.com
Mon May 2 18:26:58 CDT 2005
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
: 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/
More information about the thelist
mailing list