I had the same problem today. Mine had to do with the '#quotemarks#' . I
wasn't using '' when quoting text fields. Didn't work.
Maybe you made your email field numeric.
John Cesta
http://www.cybersmarts.net
-------------------------------------------------
ColdFusion ASP and ActiveState PERL Hosting
Includes 10 Domains
--------------------------------------------
SearchIt PRO - IIS Logfile Management Software
DomainReportIt PRO - Transfer IIS installs
http://www.serverautomationtools.com
-----Original Message-----
From: William J. Riley [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 1:42 PM
To: CF-Server
Subject: RE: Irritating Database
There are 2 very easy things you can do to debug your app. 99.9% chance this
is a coding issue on your side.
1)Copy you whole query and place it in a cfoutput to check the values of the
parameters as in..
<CFOUTPUT>
update Members
set
Name='#form.Name#',Location='#form.Location#',Age='#form.Age#',Gender='#form
....Gender#',Interests='#form.Interests#',MyHomepage='#form.MyHomepage#',MyUR
L
=
'#form.myurl#',eadd='#form.eadd#'
where ID=#ID#
</CFOUTPUT>
2) Use a <CFUPDATE> tag in place of your SQL update, if this works it is
clear sign there is a problem with the query.
if it fails then the problems is when the form.eadd being set before the
update.
Regards,
William J. Riley
Administrator
Atlantic Computer Systems & Services
Edge Web Hosting
Phone:(410) 363-4626
Fax:(410) 363-8526
[EMAIL PROTECTED]
http://www.edgewebhosting.net
-----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#',MyUR
L
=
'#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
