When a user updates a memo field via a form I want to add an addition at the
end to say something like
Updated dd/mm/yyyy

I have done this by adding a hidden field to the form which repeats the
field name with the value
Updated <%=Now()%>

However it shows up as
..... text, Updated dd/mm/yyyy

I get the usual FP warning about duplicate field names and it works but I
would like to get rid of the comma.

How can I prevent the comma showing up??

Thanks
M

You have to combine the two fields together prior to inserting/updating the single field in the
database. Each field on the form must be uniquely named.

Memo1 = request.form("memofield")
MUpdate = request.form("memoupdate")

Memo = Memo1 + "<br>" + "Updated " + MUpdate

This will require you to hand write the entire ASP/VBScript code to update the record.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Mettá" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> When a user updates a memo field via a form I want to add an addition at the end to say something
> like
> Updated dd/mm/yyyy
>
> I have done this by adding a hidden field to the form which repeats the field name with the value
> Updated <%=Now()%>
>
> However it shows up as
> .... text, Updated dd/mm/yyyy
>
> I get the usual FP warning about duplicate field names and it works but I would like to get rid of
> the comma.
>
> How can I prevent the comma showing up??
>
> Thanks
> M
>

Thanks, I will have a go.

M


"Thomas A. Rowe" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You have to combine the two fields together prior to inserting/updating
> the single field in the database. Each field on the form must be uniquely
> named.
>
> Memo1 = request.form("memofield")
> MUpdate = request.form("memoupdate")
>
> Memo = Memo1 + "<br>" + "Updated " + MUpdate
>
> This will require you to hand write the entire ASP/VBScript code to
> update the record.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WebMaster Resources(tm)
> http://www.ycoln-resources.com
> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
> ==============================================
> If you feel your current issue is a results of installing
> a Service Pack or security update, please contact
> Microsoft Product Support Services:
> http://support.microsoft.com
> If the problem can be shown to have been caused by a
> security update, then there is usually no charge for the call.
> ==============================================
>
> "Mettá" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> When a user updates a memo field via a form I want to add an addition at
>> the end to say something like
>> Updated dd/mm/yyyy
>>
>> I have done this by adding a hidden field to the form which repeats the
>> field name with the value
>> Updated <%=Now()%>
>>
>> However it shows up as
>> .... text, Updated dd/mm/yyyy
>>
>> I get the usual FP warning about duplicate field names and it works but I
>> would like to get rid of the comma.
>>
>> How can I prevent the comma showing up??
>>
>> Thanks
>> M
>>
>
>

<%Dim text1c
Text1c=request.form("text1")&request.form("text1b")%>


The above outputs Text1 and Text1b as one string on screen with <%=text1c%>
but it does not save to the db??

The sql reads as
bla...text1='::text1c::'...


What am I doing wrong?



"Mettá" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Thanks, I will have a go.
>
> M
>
>
> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> You have to combine the two fields together prior to inserting/updating
>> the single field in the database. Each field on the form must be uniquely
>> named.
>>
>> Memo1 = request.form("memofield")
>> MUpdate = request.form("memoupdate")
>>
>> Memo = Memo1 + "<br>" + "Updated " + MUpdate
>>
>> This will require you to hand write the entire ASP/VBScript code to
>> update the record.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WebMaster Resources(tm)
>> http://www.ycoln-resources.com
>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>> ==============================================
>> If you feel your current issue is a results of installing
>> a Service Pack or security update, please contact
>> Microsoft Product Support Services:
>> http://support.microsoft.com
>> If the problem can be shown to have been caused by a
>> security update, then there is usually no charge for the call.
>> ==============================================
>>
>> "Mettá" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> When a user updates a memo field via a form I want to add an addition at
>>> the end to say something like
>>> Updated dd/mm/yyyy
>>>
>>> I have done this by adding a hidden field to the form which repeats the
>>> field name with the value
>>> Updated <%=Now()%>
>>>
>>> However it shows up as
>>> .... text, Updated dd/mm/yyyy
>>>
>>> I get the usual FP warning about duplicate field names and it works but
>>> I would like to get rid of the comma.
>>>
>>> How can I prevent the comma showing up??
>>>
>>> Thanks
>>> M
>>>
>>
>>
>
>

I also tried

set Text1=('::Text1::'&'::Text1a::')

and
set Text1='::Text1::'&'::Text1a::'

within the sql update

Thanks
M


"Mettá" <(E-Mail Removed)> wrote in message
news:u1nBTW$(E-Mail Removed)...
> <%Dim text1c
> Text1c=request.form("text1")&request.form("text1b")%>
>
>
> The above outputs Text1 and Text1b as one string on screen with
> <%=text1c%> but it does not save to the db??
>
> The sql reads as
> bla...text1='::text1c::'...
>
>
> What am I doing wrong?
>
>
>
> "Mettá" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Thanks, I will have a go.
>>
>> M
>>
>>
>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message
>> news:(E-Mail Removed)...
>>> You have to combine the two fields together prior to inserting/updating
>>> the single field in the database. Each field on the form must be
>>> uniquely named.
>>>
>>> Memo1 = request.form("memofield")
>>> MUpdate = request.form("memoupdate")
>>>
>>> Memo = Memo1 + "<br>" + "Updated " + MUpdate
>>>
>>> This will require you to hand write the entire ASP/VBScript code to
>>> update the record.
>>>
>>> --
>>> ==============================================
>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>> WebMaster Resources(tm)
>>> http://www.ycoln-resources.com
>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>> ==============================================
>>> If you feel your current issue is a results of installing
>>> a Service Pack or security update, please contact
>>> Microsoft Product Support Services:
>>> http://support.microsoft.com
>>> If the problem can be shown to have been caused by a
>>> security update, then there is usually no charge for the call.
>>> ==============================================
>>>
>>> "Mettá" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> When a user updates a memo field via a form I want to add an addition
>>>> at the end to say something like
>>>> Updated dd/mm/yyyy
>>>>
>>>> I have done this by adding a hidden field to the form which repeats the
>>>> field name with the value
>>>> Updated <%=Now()%>
>>>>
>>>> However it shows up as
>>>> .... text, Updated dd/mm/yyyy
>>>>
>>>> I get the usual FP warning about duplicate field names and it works but
>>>> I would like to get rid of the comma.
>>>>
>>>> How can I prevent the comma showing up??
>>>>
>>>> Thanks
>>>> M
>>>>
>>>
>>>
>>
>>
>
>

Ok, based on my example:

Memo1 = request.form("memofield")
MUpdate = request.form("memoupdate")
MemoA = Memo1 + "<br>" + "Updated " + MUpdate


SQL Insert Statement:

Memofile = '" & MemoA & "'

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================

"Mettá" <(E-Mail Removed)> wrote in message
news:u1nBTW$(E-Mail Removed)...
> <%Dim text1c
> Text1c=request.form("text1")&request.form("text1b")%>
>
>
> The above outputs Text1 and Text1b as one string on screen with <%=text1c%> but it does not save
> to the db??
>
> The sql reads as
> bla...text1='::text1c::'...
>
>
> What am I doing wrong?
>
>
>
> "Mettá" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> Thanks, I will have a go.
>>
>> M
>>
>>
>> "Thomas A. Rowe" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
>>> You have to combine the two fields together prior to inserting/updating the single field in the
>>> database. Each field on the form must be uniquely named.
>>>
>>> Memo1 = request.form("memofield")
>>> MUpdate = request.form("memoupdate")
>>>
>>> Memo = Memo1 + "<br>" + "Updated " + MUpdate
>>>
>>> This will require you to hand write the entire ASP/VBScript code to update the record.
>>>
>>> --
>>> ==============================================
>>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>>> WebMaster Resources(tm)
>>> http://www.ycoln-resources.com
>>> FrontPage Resources, WebCircle, MS KB Quick Links, etc.
>>> ==============================================
>>> If you feel your current issue is a results of installing
>>> a Service Pack or security update, please contact
>>> Microsoft Product Support Services:
>>> http://support.microsoft.com
>>> If the problem can be shown to have been caused by a
>>> security update, then there is usually no charge for the call.
>>> ==============================================
>>>
>>> "Mettá" <(E-Mail Removed)> wrote in message
>>> news:(E-Mail Removed)...
>>>> When a user updates a memo field via a form I want to add an addition at the end to say
>>>> something like
>>>> Updated dd/mm/yyyy
>>>>
>>>> I have done this by adding a hidden field to the form which repeats the field name with the
>>>> value
>>>> Updated <%=Now()%>
>>>>
>>>> However it shows up as
>>>> .... text, Updated dd/mm/yyyy
>>>>
>>>> I get the usual FP warning about duplicate field names and it works but I would like to get rid
>>>> of the comma.
>>>>
>>>> How can I prevent the comma showing up??
>>>>
>>>> Thanks
>>>> M
>>>>
>>>
>>>
>>
>>
>
>