|
 |
asp_web_howto thread: give a unique number to a set of events
Message #1 by "Dovidas, Mark" <Mark.Dovidas@b...> on Mon, 18 Dec 2000 11:51:22 -0500
|
|
Hi,
I'm trying to give a unique number to a set of events being entered into a
database.( Autonumber is already used.) I have a group of events that are
calculated by code (ex: dates of the 1st Tuesdays of each month). There is
a good chance of a lot of info within them to be similar.
The only idea I can come up with is to add the Date & Time Serial numbers
and assign that result to the whole batch of numbers.
One other question- I am doing this to edit these events all at once, all I
can do is delete them and rewrite them. I wrote a sql statement but it
doesn't cut it if the dates are changed. If anyone has any ideas...
Thanks
---
MaximumASP offers enhanced hosting solutions on the Windows 2000 platform. Dedicated processor, RAM, and server resources provide
dedicated server performance at virtual server prices. Commercial components provided; custom components allowed.
---
You are currently subscribed to asp_web_howto as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_web_howto-$subst('Recip.MemberIDChar')@p2p.wrox.com
Message #2 by "Morgan, Rob" <Rob.Morgan@o...> on Mon, 18 Dec 2000 14:27:55 -0500
|
|
Use a sequence table using the create sequence command.
-----Original Message-----
From: Dovidas, Mark [mailto:Mark.Dovidas@b...]
Sent: Monday, December 18, 2000 11:51 AM
To: ASP Web HowTo
Subject: [asp_web_howto] give a unique number to a set of events
Hi,
I'm trying to give a unique number to a set of events being entered into a
database.( Autonumber is already used.) I have a group of events that are
calculated by code (ex: dates of the 1st Tuesdays of each month). There is
a good chance of a lot of info within them to be similar.
The only idea I can come up with is to add the Date & Time Serial numbers
and assign that result to the whole batch of numbers.
One other question- I am doing this to edit these events all at once, all I
can do is delete them and rewrite them. I wrote a sql statement but it
doesn't cut it if the dates are changed. If anyone has any ideas...
Thanks
---
MaximumASP offers enhanced hosting solutions on the Windows 2000 platform. Dedicated processor, RAM, and server resources provide
dedicated server performance at virtual server prices. Commercial components provided; custom components allowed.
---
You are currently subscribed to asp_web_howto as: $subst('Recip.EmailAddr')
To unsubscribe send a blank email to leave-asp_web_howto-$subst('Recip.MemberIDChar')@p2p.wrox.com
|
|
|
View Cart
