Let's see your table description and the query you're running against it.
Also anything else you can think of (DB type, O/S, all that jazz).
Jim Gram
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 2:26 PM
To: CF-Server
Subject: A very Irritating Database
Ok... sometimes you can check, recheck, and still check cf code for errors
and not see it... so I restored from backups... and typed everything again,
and it errors like mad.... the same error...
If inside the the cfoutput tag i put #name# it calls the name field at the
row i specify and outputs correctly but if i put #email# its blank...
completely blank... totally irritatingly blank... and i just tried removing
the name field and re-inserting it and re-adding the data and it works
correctly... so what could be the problem... anyone know? anyone at all? and
yes ive tried restarting various programs, restarting the computer, and
everything to no avail... OUCH...
OH YEAH... thanks to everyone who has given me feedback on this list...
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
----- Original Message -----
From: "William J. Riley" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, December 11, 2000 12:41 PM
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#',MyU
R
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#',MyU
R
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
