Your query does not mention an "email" column. Add it to the query and it
will be updated.
----- Original Message -----
From: "Tony Hicks" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, December 11, 2000 1:16 PM
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
