Tony, Not sure what database you're using, but the single quotes make me think Oracle. Just a stab, but did you COMMIT after altering your table to add the new column? Jim Gram -----Original Message----- From: Tony Hicks [mailto:[EMAIL PROTECTED]] Sent: Monday, December 11, 2000 1:17 PM To: CF-Server Subject: Irritating Database I was looking at my database yesterday and realized I didn't have an email column.... so I added it... I added the cfparam where necessary and I added the email='#email#' where necessary... That didn't work... it told me wrong number of parameters... no matter what i did, it told me that.... so I took the line out and the thing worked so I put it back in and it didn't work again.. I tried retyping it... that didn't help... what I don't understand is that I tried renaming the column and everything but its having a major problem... it won't recognize the email address column.... the edit profile page calls it from the db and that does not work! It will let me enter data manually but thats it... it occurred to me that this is the first column ive added since i made the datasource so i deleted the datasource and rebuilt it..... HELP! Here's the query... ------------------- <cfquery name=updateprofiles datasource=Community> update Members set Name='#form.Name#',Location='#form.Location#',Age='#form.Age#',Gender='#form ...Gender#',Interests='#form.Interests#',MyHomepage='#form.MyHomepage#',MyURL = '#form.myurl#',eadd='#form.eadd#' where ID=#ID# </cfquery> Your revisions have been accepted! --------------------- You might notice it says Name='#form.name#'... I've tried it Name='#Name#' and it works just fine but nothing will make it work on the eadd field... CAN ANYONE HELP? I'm thinking its just got to be a bug in CF 45? Thanks, Tony Hicks Professionally Designed Websites http://www.righteousdesigns.com ICQ: 5874143 AIM: Webmigit Y!: Webmigit mailto:[EMAIL PROTECTED] Tired of your web host? http://www.nextmill.net Need a Domain? Don't have a credit card? http://www.domainsbycheck.com Got your Free Online Business Card Yet? Here's mine: http://thecardfile.com/webmigit.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm ------------------------------------------------------------------------------ To unsubscribe, send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body or visit the list page at www.houseoffusion.com
