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. (daler@iea-software.com)_________________________________________________________________ IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs Internet Solutions for Today | http://www.iea-software.com