Never mind, figured it out..........
thanks DB ----- Original Message ----- From: "Douglas L. Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, November 12, 2001 8:05 PM Subject: What am I doing wrong here? > I am trying to populate the ID field of this table with the following. > Please help > > > <CFQUERY DATASOURCE="#application.dsn#" NAME="insert_cust_login"> > INSERT INTO cust_contacts > VALUES ( '#custNum#', > '#f_name#', > '#l_name#', > '#email#', > '#password#' ) > > > > DECLARE @maxid int > BEGIN > SELECT @maxid = MAX(ID) > FROM cust_contacts > WHERE custNum = '#custNum#' > IF @maxid IS NULL > SELECT @maxid = 1 > ELSE > SELECT @maxid = @maxid + 1 > END > > </CFQUERY> > > > > <CF_SIGNATURE > NAME="Douglas L. Brown" > EMAIL="[EMAIL PROTECTED]" > PHONE="714.538.6611" > WEB="http://www.carnivorepc.com";> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
