Create an insert trigger... CREATE TRIGGER GetID ON [Name of your table] FOR INSERT AS SELECT [Name of your ID column] FROM inserted -Rich ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
- SQL INSERTS - return ID Matt Eschenbaum
- RE: SQL INSERTS - return ID Erik Yowell
- RE: SQL INSERTS - return ID Trey Rouse
- Re: SQL INSERTS - return ID Richard Fantini
- Re: SQL INSERTS - return ID Bryan LaPlante
- Re: SQL INSERTS - return ID Tony Schreiber
- RE: SQL INSERTS - return ID mjohnson
- RE: SQL INSERTS - return ID Metzy Martinez
- RE: SQL INSERTS - return ID mjohnson
- RE: SQL INSERTS - return ID Costas Piliotis
