Great...Pray tell, what was the "lesson learned?"
-----Original Message-----
From: Tony Hicks [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 11, 2000 3:28 PM
To: CF-Server
Subject: It works
Ok.... Everyone it works just fine...
Can I ask another question... I have a textarea or two and is there a way to
make it so that if it says
"Tony Hicks
Righteous Designs"
then I can put #signature# somewhere on the page and it will output it that
way... so the source would have to say
"Tony Hicks<br>
Righteous Designs"?
And also I'd like to ask if any of you mind your names being included in a
special thanks to file?
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: "Bruce Heerssen" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, December 11, 2000 2:18 PM
Subject: RE: A very Irritating Database
> Tony, maybe this will help.
>
> Run the following code:
>
> <cfquery name=updateprofiles datasource=Community>
> select * from Members
> </cfquery>
> <cfoutput>#test.columnlist#</cfoutput>
>
> if the email column does not appear then the field is not in the database.
> Verify that the datasource is pointing to the correct file and that you
are
> updating the correct database. If it does appear then the problem does not
lie
> in the database. In that case, have yet another look at your code.
>
> hth
>
> - Bruce
>
> P.S. While I was writing this, Claudio Betancourt replied with a good idea
> (compacting and repairing the database). If the above does not work, try
that.
>
>
> <tip type="coldfusion" author="Bruce Heerssen">
> If you need a quick list of all the columns in a query, ColdFusion makes
it easy
> for you by providing a variable, called columnlist, that you can reference
in
> your cfoutputs. Just call it like so:
> "<cfoutput>#queryName.columnlist#</cfoutput>", and CF will output a
> comma-delimited list of all the columns returned by the query.
> </tip>
>
> > -----Original Message-----
> > From: Tony Hicks [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, December 11, 2000 1:49 PM
> > To: CF-Server
> > Subject: Re: A very Irritating Database
> >
> >
> > I'm using CF 45 trial version... Windows 98 SE, Microsoft Access... 32
mb
> > ram 166 pentium...
> >
> > Let me point out that this is not a real server... i just use it for
> > development so it doesn't even try to handle a server load...
> >
> > The table "members" serves two purposes... login purpose and profile
> > purpose... the login is encrypted and it works fine now... every other
> > field of data works great...
> >
> > It just refuses to read the email... it'll read every other field of
> > data....
> >
> > 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: "Gram, Jim" <[EMAIL PROTECTED]>
> > To: "CF-Server" <[EMAIL PROTECTED]>
> > Sent: Monday, December 11, 2000 1:39 PM
> > Subject: RE: A very Irritating Database
> >
> >
> > > 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#',
M
y
> > U
> > > 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#',
M
y
> > U
> > > 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
