Re: Web Page for Adding Customers

Dale E. Reed Jr. ( (no email) )
Tue, 03 Feb 1998 00:50:05 -0800

Jeff Cummings wrote:
> I'm working on designing a web page for adding Master Accounts and Sub Account.
> My from adds the Master Account just fine, but what I'm having problems with is getting the Customer ID
> for the Master Account that was just added to store in the Sub Account.
> Anyone have experience or ideas? All of my testing so far has not worked. I know what I need to do, it just
> doesn't seem to do it.
> Using NT Server, IIS 3 and using .IDX and .HTX files.

Basically, you need to do a:

select newcustid=@@Identity

immediately after the insert and that will give you the CustomerID. See the
archives, as I have made more in-depth posts about this in the past.

-- Dale E. Reed Jr.  (       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |