At 08:03 AM 8/4/00 -0500, you wrote:
>Dave, Jennifer,
>
>Thanks for the reply. I should explain more in depth...I need the column
>name which is S5 to appear w/o quotes since it is being referred to.
>
>In the textarea I gave the name as dynamic (#col#) based on what the
>previous page passes in a hidden field as: <input type="hidden" name="col"
>value="S5">.
>
>The #Trim(S5)# is the data; S5 is the field or column name. It interprets
>the data as the field name.
You don't need to set the name of the field dynamically to the name of the
field on the previous page. You should name it the column of the table that
you want the info to go into. You can set the value to the name of the
contents of the field from the page before. I think I'm confused.
If you are using CFInput or CFUpdate you might have better luck using
CFQuery and writing out the SQL statement. Maybe that's what you need to know.
I'm confused about what you are trying to do. Could you send the code that
sends info to the database?
> I've been getting an error:
>
>--------------
>Error Diagnostic Information
>Field name not found in the specified table.
>
>Table = 'sept_00' Field = 'HHH'
>Data Source = "aug_00"
>SQL = ""
>---------------
>
>I'm hoping to use this one page w/the dynamic column for all my updating.
>
>See my code:
>
><form method="POST" action="monthupdate2.cfm">
><input type="hidden" name="id" value="#Trim(id)#">
><input type="hidden" name="month" value="#month#">
><input type="submit" value="Update"></td>
>
><textarea rows="4" name="#col#" cols="10"
>wrap="virtual">#Trim(S5)#</textarea></font></b>
>
></form>
>
> >-----Original Message-----
> >From: David Hannum [mailto:[EMAIL PROTECTED]]
> >Sent: Thursday, August 03, 2000 7:15 PM
> >To: [EMAIL PROTECTED]
> >Subject: Re: field name
> >
> >
> >Do this:
> >
> >#Evaluate("form.col")#
> >
> >This will give you the value of the form field col
> >
> >Dave
> >
> >
> >----- Original Message -----
> >From: Robert Orlini <[EMAIL PROTECTED]>
> >To: <[EMAIL PROTECTED]>
> >Sent: Thursday, August 03, 2000 3:44 PM
> >Subject: field name
> >
> >
> >> Hello,
> >>
> >> How can I strip the # sign's from a field so that just the text shows.
> >>
> >> I have the following hidden field:
> >> <input type="hidden" name="col" value="#S1#">
> >>
> >> S1 is the column name and I need to set it up as a variable for
> >a textarea
> >> to be edited and update the appropriate column in the table.
> >>
> >> Here is the textarea specifics:
> >> <textarea rows="4" name="#col#" cols="10" wrap="virtual">#col#</textarea>
> >>
> >> The next form uses thois info to go to the column and update it.
> >>
> >> I would like the #col# to generate just S1 (the column name) not what
> >> dymanic text located in that column (which is what it is doing).
> >>
> >> Thanks...appreciated.
> >>
> >> RO
> >> Web Admin
> >>
> >>
> >--------------------------------------------------------------------------
> >----
> >> Archives: http://www.mail-archive.com/[email protected]/
> >> To Unsubscribe visit
> >http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> >send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> >the body.
> >
> >-------------------------------------------------------------------
> >-----------
> >Archives: http://www.mail-archive.com/[email protected]/
> >To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
>
>------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
>send a message to [EMAIL PROTECTED] with 'unsubscribe' in
>the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
