This is a multi-part message in MIME format.
------=_NextPart_000_03E3_01BFA415.B971E1A0
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
Custom StationeryI have a slight problem that I believe has been =
mentioned somewhere but would really like a simple and effective =
solution. The problem is that I have an action page that first inserts =
basic contact information where there is a primary key called ContactID.
This ContactID is then used to insert other data in several other tables =
in the database. However, I cannot seem to find an effective way to get =
this most recently added contact's ContactID.
I tried the Max Function but it didn't work at all... and I heard that's =
not the best way to do it... So I guess what I'm asking is whether there =
is a simple effective solution that a newbie like myself can =
implement... Thanks in advance guys!
Marco
[EMAIL PROTECTED]
------=_NextPart_000_03E3_01BFA415.B971E1A0
Content-Type: text/html;
charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Custom Stationery</TITLE>
<META content=3D"text/html; charset=3Dwindows-1252" =
http-equiv=3DContent-Type><BASE=20
href=3D"file://C:\Program Files\Common Files\Microsoft =
Shared\Stationery\"><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 =
Transitional//EN">
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<META content=3D"MSHTML 5.00.2920.0" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY background=3D"" bgColor=3D#fffbf0=20
style=3D"BACKGROUND-COLOR: #fffbf0; COLOR: #000000; FONT-FAMILY: =
Verdana; FONT-SIZE: 10pt">
<DIV>I have a slight problem that I believe has been mentioned somewhere =
but=20
would really like a simple and effective solution. The problem is =
that I=20
have an action page that first inserts basic contact information where =
there is=20
a primary key called ContactID.</DIV>
<DIV> </DIV>
<DIV>This ContactID is then used to insert other data in several other =
tables in=20
the database. However, I cannot seem to find an effective way to =
get this=20
most recently added contact's ContactID.</DIV>
<DIV> </DIV>
<DIV>I tried the Max Function but it didn't work at all... and I heard =
that's=20
not the best way to do it... So I guess what I'm asking is whether there =
is a=20
simple effective solution that a newbie like myself can implement... =
Thanks in=20
advance guys!</DIV>
<DIV> </DIV>
<DIV>Marco</DIV>
<DIV><A href=3D"mailto:[EMAIL PROTECTED]">[EMAIL PROTECTED]</A></DIV>
<DIV> </DIV>
<DIV> </DIV></BODY></HTML>
------=_NextPart_000_03E3_01BFA415.B971E1A0--
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
