asp_databases thread: code for creating a customer id using asp for an access database
Message #1 by bizman1@s... on Sun, 7 Oct 2001 15:03:25
|
|
I would like to know if anyone has written asp code for generating a
customer id using asp. I am new to asp and have written the code for
accessing and writing to an access database but would like to find some
code on the best way to create a customer id that I can search on besides
the autonumber feature in access using asp any help would be appreciated.
thanks
Message #2 by "Ken Schaefer" <ken@a...> on Mon, 8 Oct 2001 13:04:07 +1000
|
|
What's wrong with autonumbers?
That said, there are plenty of ways to generate GUIDs. Have you done a
search at 4guysfromrolla.com or any of the other large ASP sites.
http://www.4guysfromrolla.com/webtech/041600-2.shtml might be something
useful to read.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <bizman1@s...>
Subject: [asp_databases] code for creating a customer id using asp for an
access database
: I would like to know if anyone has written asp code for generating a
: customer id using asp. I am new to asp and have written the code for
: accessing and writing to an access database but would like to find some
: code on the best way to create a customer id that I can search on besides
: the autonumber feature in access using asp any help would be appreciated.
: thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by David Cameron <dcameron@i...> on Mon, 8 Oct 2001 10:26:04 +1000
|
|
Use the autonumber. If you use something other than that for referencing
tables in Access you are likely to run into problems with referential
integrity. If you are bent on using other options (and possibly breaking
your database) then generate a GUID.
regards
David Cameron
nOw.b2b
dcameron@i...
-----Original Message-----
From: bizman1@s... [mailto:bizman1@s...]
Sent: Monday, 8 October 2001 1:03 AM
To: ASP Databases
Subject: [asp_databases] code for creating a customer id using asp for
an access database
I would like to know if anyone has written asp code for generating a
customer id using asp. I am new to asp and have written the code for
accessing and writing to an access database but would like to find some
code on the best way to create a customer id that I can search on besides
the autonumber feature in access using asp any help would be appreciated.
thanks
|