Hi Tony,
You can do so by creating a variable first, and then outputting that
variable in a TextArea tag.
<cfset signature = "Tony Hicks&##10;Righteous Designs">
where is the control character for Line Feed. So put another # to
escape the original # in CF.
Then
<form action="">
<textarea cols="20" rows="2"
name="sig"><cfoutput>#signature#</cfoutput></textarea>
</form>
Hassan Khawaja
Web Applications Developer
[EMAIL PROTECTED]
----- Original Message -----
From: "Tony Hicks" <[EMAIL PROTECTED]>
To: "CF-Server" <[EMAIL PROTECTED]>
Sent: Monday, December 11, 2000 2:27 PM
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
