Thanks It is all good now...
-----Original Message----- From: Ernie Pena [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 19, 2002 7:51 AM To: CF-Talk Subject: Re: <<<>>> SQL Question JON, I've run in to this problem before and if you are using MS ACCESS then its as simple as selecting autonumber for your ID field, however if your using SQL server (any ver) you have to make the ID field Data Type ="int" and the Identity value to yes and you are good to go. Ernie Pena Sr. CF Developer M.D. Anderson ----- Original Message ----- From: "CF_JONNY" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, March 18, 2002 3:12 PM Subject: <<<>>> SQL Question When inserting a new record I get an error saying that the autoID fields cannot use a null value. how do I write the sql like this? <CFQUERY NAME="reg_ath" DATASOURCE="name" DBTYPE="ODBC" > INSERT INTO ATHLETES (athid, athFirstName, athLastName, athAge, AthEmail , athStreet , AthCity , athState, athZip, athgoals ) VALUES (#Form.athId#, ' #FORM.athFirstName#', '#FORM.athLastName#' , #FORM.athAge # ,'#athEmail#', '#FORM.athStreet#' , '#FORM.athCity#' , '#FORM.athState#' , #FORM.athZip#, ' #FORM.athGoals# ') </CFQUERY> On form page; <input type="hidden" name="athid"> JON _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
