Re: ASP UPDATE problem.. Continued

Frank:
This is the SQL from the web I created with the restructured database:

s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' , PMCREW =
'::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' , INSTRUCTOR =
'::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 = '::instruct2::' ,
crew3 = '::crew3::' , crew4 = '::crew4::' WHERE (xrecnbr = ::xrecnbr:"

It looks pretty much like yours and it does update the database.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/


"Frank Smith" <noanswer@earthlink.net> wrote in message
news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
> For years things have been fine - and now, not so good.
>
> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
> attached) where the record contents are displayed for User editing.
> This page shows the correct record.
> On POST "updatef.asp" is called to do the DB changes - except nothing
> happens, no changes.
>
> UPDATE schedule SET
> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
> amcrew='::amcrew::',pmcrew=':mcrew::',
> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
> WHERE (xrecnbr=::xrecnbr:
>
> After going to FP2003, the above SQL UPDATE "contains an error" -- I sure
> cannot see it.
> IF I remove all the fields except one, the string Validates.
>
> Any ideas?
>
> Note for Kathleen if you see this, new DB structure being used
>
>
>

Thanks
I must be getting far tooooooo old for this stuff.

Your SQL looks like mine - But does verify/no errors
With no error messages, the sequence from sched2.asp -> update3.asp ->
updatef.asp just does not update the DB - no changes ever posted.
schedule.mdb has permissions of R/W/E "for the world" so that is not an
issue.


"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
message news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
> Frank:
> This is the SQL from the web I created with the restructured database:
>
> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
> ':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' , PMCREW =
> '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' , INSTRUCTOR =
> '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 = '::instruct2::' ,
> crew3 = '::crew3::' , crew4 = '::crew4::' WHERE (xrecnbr = ::xrecnbr:"
>
> It looks pretty much like yours and it does update the database.
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
> "Frank Smith" <noanswer@earthlink.net> wrote in message
> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
>> For years things have been fine - and now, not so good.
>>
>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
>> attached) where the record contents are displayed for User editing.
>> This page shows the correct record.
>> On POST "updatef.asp" is called to do the DB changes - except nothing
>> happens, no changes.
>>
>> UPDATE schedule SET
>> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
>> amcrew='::amcrew::',pmcrew=':mcrew::',
>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
>> WHERE (xrecnbr=::xrecnbr:
>>
>> After going to FP2003, the above SQL UPDATE "contains an error" -- I sure
>> cannot see it.
>> IF I remove all the fields except one, the string Validates.
>>
>> Any ideas?
>>
>> Note for Kathleen if you see this, new DB structure being used
>>
>>
>>
>
>

Stupid question time - do I need Windows XP Pro for these pages?
I have XP Home.

"Frank Smith" <noanswer@earthlink.net> wrote in message
news:e62erA92FHA.400@TK2MSFTNGP09.phx.gbl...
> Thanks
> I must be getting far tooooooo old for this stuff.
>
> Your SQL looks like mine - But does verify/no errors
> With no error messages, the sequence from sched2.asp -> update3.asp ->
> updatef.asp just does not update the DB - no changes ever posted.
> schedule.mdb has permissions of R/W/E "for the world" so that is not an
> issue.
>
>
> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
> message news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
>> Frank:
>> This is the SQL from the web I created with the restructured database:
>>
>> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
>> ':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' , PMCREW =
>> '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' , INSTRUCTOR =
>> '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 = '::instruct2::' ,
>> crew3 = '::crew3::' , crew4 = '::crew4::' WHERE (xrecnbr = ::xrecnbr:"
>>
>> It looks pretty much like yours and it does update the database.
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>>
>>
>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
>>> For years things have been fine - and now, not so good.
>>>
>>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
>>> attached) where the record contents are displayed for User editing.
>>> This page shows the correct record.
>>> On POST "updatef.asp" is called to do the DB changes - except nothing
>>> happens, no changes.
>>>
>>> UPDATE schedule SET
>>> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
>>> amcrew='::amcrew::',pmcrew=':mcrew::',
>>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
>>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
>>> WHERE (xrecnbr=::xrecnbr:
>>>
>>> After going to FP2003, the above SQL UPDATE "contains an error" -- I
>>> sure cannot see it.
>>> IF I remove all the fields except one, the string Validates.
>>>
>>> Any ideas?
>>>
>>> Note for Kathleen if you see this, new DB structure being used
>>>
>>>
>>>
>>
>>
>
>

Yes, for this to work on your PC, you need to be running Windows XP Pro and
IIS.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/




"Frank Smith" <noanswer@earthlink.net> wrote in message
news:uHQ0tE92FHA.400@TK2MSFTNGP09.phx.gbl...
> Stupid question time - do I need Windows XP Pro for these pages?
> I have XP Home.
>
> "Frank Smith" <noanswer@earthlink.net> wrote in message
> news:e62erA92FHA.400@TK2MSFTNGP09.phx.gbl...
>> Thanks
>> I must be getting far tooooooo old for this stuff.
>>
>> Your SQL looks like mine - But does verify/no errors
>> With no error messages, the sequence from sched2.asp -> update3.asp ->
>> updatef.asp just does not update the DB - no changes ever posted.
>> schedule.mdb has permissions of R/W/E "for the world" so that is not an
>> issue.
>>
>>
>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
>> message news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
>>> Frank:
>>> This is the SQL from the web I created with the restructured database:
>>>
>>> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
>>> ':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' , PMCREW
>>> = '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' , INSTRUCTOR
>>> = '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 = '::instruct2::'
>>> , crew3 = '::crew3::' , crew4 = '::crew4::' WHERE (xrecnbr =
>>> ::xrecnbr:"
>>>
>>> It looks pretty much like yours and it does update the database.
>>>
>>> --
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>> web: http://www.spiderwebwoman.com/resources/
>>>
>>>
>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
>>>> For years things have been fine - and now, not so good.
>>>>
>>>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
>>>> attached) where the record contents are displayed for User editing.
>>>> This page shows the correct record.
>>>> On POST "updatef.asp" is called to do the DB changes - except nothing
>>>> happens, no changes.
>>>>
>>>> UPDATE schedule SET
>>>> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
>>>> amcrew='::amcrew::',pmcrew=':mcrew::',
>>>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
>>>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
>>>> WHERE (xrecnbr=::xrecnbr:
>>>>
>>>> After going to FP2003, the above SQL UPDATE "contains an error" -- I
>>>> sure cannot see it.
>>>> IF I remove all the fields except one, the string Validates.
>>>>
>>>> Any ideas?
>>>>
>>>> Note for Kathleen if you see this, new DB structure being used
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

You need to be running against a web server, so yes, XP Pro would be needed with IIS installed for
test locally.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
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.
==============================================

"Frank Smith" <noanswer@earthlink.net> wrote in message news:uHQ0tE92FHA.400@TK2MSFTNGP09.phx.gbl...
> Stupid question time - do I need Windows XP Pro for these pages?
> I have XP Home.
>
> "Frank Smith" <noanswer@earthlink.net> wrote in message
> news:e62erA92FHA.400@TK2MSFTNGP09.phx.gbl...
>> Thanks
>> I must be getting far tooooooo old for this stuff.
>>
>> Your SQL looks like mine - But does verify/no errors
>> With no error messages, the sequence from sched2.asp -> update3.asp -> updatef.asp just does not
>> update the DB - no changes ever posted.
>> schedule.mdb has permissions of R/W/E "for the world" so that is not an issue.
>>
>>
>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in message
>> news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
>>> Frank:
>>> This is the SQL from the web I created with the restructured database:
>>>
>>> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER = ':ISPATCHER::' , PHONE =
>>> '::PHONE::' , AMCREW = '::AMCREW::' , PMCREW = '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW =
>>> '::PMTOW::' , INSTRUCTOR = '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 =
>>> '::instruct2::' , crew3 = '::crew3::' , crew4 = '::crew4::' WHERE (xrecnbr = ::xrecnbr:"
>>>
>>> It looks pretty much like yours and it does update the database.
>>>
>>> --
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>> web: http://www.spiderwebwoman.com/resources/
>>>
>>>
>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
>>>> For years things have been fine - and now, not so good.
>>>>
>>>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt attached) where the record
>>>> contents are displayed for User editing.
>>>> This page shows the correct record.
>>>> On POST "updatef.asp" is called to do the DB changes - except nothing happens, no changes.
>>>>
>>>> UPDATE schedule SET xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
>>>> amcrew='::amcrew::',pmcrew=':mcrew::',
>>>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
>>>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::' WHERE
>>>> (xrecnbr=::xrecnbr:
>>>>
>>>> After going to FP2003, the above SQL UPDATE "contains an error" -- I sure cannot see it.
>>>> IF I remove all the fields except one, the string Validates.
>>>>
>>>> Any ideas?
>>>>
>>>> Note for Kathleen if you see this, new DB structure being used
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

I do my coding on my machine then publish and see if all works, so I guess I
can stay with XP Home.
I am baffled by the non-updating of the DB, this is not rocket science
stuff, just a simple update.


"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
message news:e3adhQ92FHA.3296@TK2MSFTNGP09.phx.gbl...
> Yes, for this to work on your PC, you need to be running Windows XP Pro
> and IIS.
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
>
>
> "Frank Smith" <noanswer@earthlink.net> wrote in message
> news:uHQ0tE92FHA.400@TK2MSFTNGP09.phx.gbl...
>> Stupid question time - do I need Windows XP Pro for these pages?
>> I have XP Home.
>>
>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>> news:e62erA92FHA.400@TK2MSFTNGP09.phx.gbl...
>>> Thanks
>>> I must be getting far tooooooo old for this stuff.
>>>
>>> Your SQL looks like mine - But does verify/no errors
>>> With no error messages, the sequence from sched2.asp -> update3.asp ->
>>> updatef.asp just does not update the DB - no changes ever posted.
>>> schedule.mdb has permissions of R/W/E "for the world" so that is not an
>>> issue.
>>>
>>>
>>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
>>> message news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
>>>> Frank:
>>>> This is the SQL from the web I created with the restructured database:
>>>>
>>>> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
>>>> ':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' , PMCREW
>>>> = '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' , INSTRUCTOR
>>>> = '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 =
>>>> '::instruct2::' , crew3 = '::crew3::' , crew4 = '::crew4::' WHERE
>>>> (xrecnbr = ::xrecnbr:"
>>>>
>>>> It looks pretty much like yours and it does update the database.
>>>>
>>>> --
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> web: http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>>> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
>>>>> For years things have been fine - and now, not so good.
>>>>>
>>>>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
>>>>> attached) where the record contents are displayed for User editing.
>>>>> This page shows the correct record.
>>>>> On POST "updatef.asp" is called to do the DB changes - except nothing
>>>>> happens, no changes.
>>>>>
>>>>> UPDATE schedule SET
>>>>> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
>>>>> amcrew='::amcrew::',pmcrew=':mcrew::',
>>>>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
>>>>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
>>>>> WHERE (xrecnbr=::xrecnbr:
>>>>>
>>>>> After going to FP2003, the above SQL UPDATE "contains an error" -- I
>>>>> sure cannot see it.
>>>>> IF I remove all the fields except one, the string Validates.
>>>>>
>>>>> Any ideas?
>>>>>
>>>>> Note for Kathleen if you see this, new DB structure being used
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Is it working on your live site?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/




"Frank Smith" <noanswer@earthlink.net> wrote in message
news:e0$by892FHA.2676@TK2MSFTNGP15.phx.gbl...
>I do my coding on my machine then publish and see if all works, so I guess
>I can stay with XP Home.
> I am baffled by the non-updating of the DB, this is not rocket science
> stuff, just a simple update.
>
>
> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
> message news:e3adhQ92FHA.3296@TK2MSFTNGP09.phx.gbl...
>> Yes, for this to work on your PC, you need to be running Windows XP Pro
>> and IIS.
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>>
>>
>>
>>
>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>> news:uHQ0tE92FHA.400@TK2MSFTNGP09.phx.gbl...
>>> Stupid question time - do I need Windows XP Pro for these pages?
>>> I have XP Home.
>>>
>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>> news:e62erA92FHA.400@TK2MSFTNGP09.phx.gbl...
>>>> Thanks
>>>> I must be getting far tooooooo old for this stuff.
>>>>
>>>> Your SQL looks like mine - But does verify/no errors
>>>> With no error messages, the sequence from sched2.asp -> update3.asp ->
>>>> updatef.asp just does not update the DB - no changes ever posted.
>>>> schedule.mdb has permissions of R/W/E "for the world" so that is not an
>>>> issue.
>>>>
>>>>
>>>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote
>>>> in message news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
>>>>> Frank:
>>>>> This is the SQL from the web I created with the restructured database:
>>>>>
>>>>> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
>>>>> ':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' ,
>>>>> PMCREW = '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' ,
>>>>> INSTRUCTOR = '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 =
>>>>> '::instruct2::' , crew3 = '::crew3::' , crew4 = '::crew4::' WHERE
>>>>> (xrecnbr = ::xrecnbr:"
>>>>>
>>>>> It looks pretty much like yours and it does update the database.
>>>>>
>>>>> --
>>>>> ~ Kathleen Anderson
>>>>> Microsoft MVP - FrontPage
>>>>> Spider Web Woman Designs
>>>>> web: http://www.spiderwebwoman.com/resources/
>>>>>
>>>>>
>>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>>>> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
>>>>>> For years things have been fine - and now, not so good.
>>>>>>
>>>>>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
>>>>>> attached) where the record contents are displayed for User editing.
>>>>>> This page shows the correct record.
>>>>>> On POST "updatef.asp" is called to do the DB changes - except nothing
>>>>>> happens, no changes.
>>>>>>
>>>>>> UPDATE schedule SET
>>>>>> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
>>>>>> amcrew='::amcrew::',pmcrew=':mcrew::',
>>>>>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
>>>>>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
>>>>>> WHERE (xrecnbr=::xrecnbr:
>>>>>>
>>>>>> After going to FP2003, the above SQL UPDATE "contains an error" -- I
>>>>>> sure cannot see it.
>>>>>> IF I remove all the fields except one, the string Validates.
>>>>>>
>>>>>> Any ideas?
>>>>>>
>>>>>> Note for Kathleen if you see this, new DB structure being used
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Nope.
I have the forms and the DB on two different hosting services FP server and
neither update the DB.
No error messages generated and no updates posted.
The code is attached "updatef.txt"

Weird to say the least


"Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
message news:OJO$FN%232FHA.3000@TK2MSFTNGP12.phx.gbl...
> Is it working on your live site?
>
> --
>
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> web: http://www.spiderwebwoman.com/resources/
>
>
>
>
> "Frank Smith" <noanswer@earthlink.net> wrote in message
> news:e0$by892FHA.2676@TK2MSFTNGP15.phx.gbl...
>>I do my coding on my machine then publish and see if all works, so I guess
>>I can stay with XP Home.
>> I am baffled by the non-updating of the DB, this is not rocket science
>> stuff, just a simple update.
>>
>>
>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
>> message news:e3adhQ92FHA.3296@TK2MSFTNGP09.phx.gbl...
>>> Yes, for this to work on your PC, you need to be running Windows XP Pro
>>> and IIS.
>>>
>>> --
>>>
>>> ~ Kathleen Anderson
>>> Microsoft MVP - FrontPage
>>> Spider Web Woman Designs
>>> web: http://www.spiderwebwoman.com/resources/
>>>
>>>
>>>
>>>
>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>> news:uHQ0tE92FHA.400@TK2MSFTNGP09.phx.gbl...
>>>> Stupid question time - do I need Windows XP Pro for these pages?
>>>> I have XP Home.
>>>>
>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>>> news:e62erA92FHA.400@TK2MSFTNGP09.phx.gbl...
>>>>> Thanks
>>>>> I must be getting far tooooooo old for this stuff.
>>>>>
>>>>> Your SQL looks like mine - But does verify/no errors
>>>>> With no error messages, the sequence from sched2.asp -> update3.asp ->
>>>>> updatef.asp just does not update the DB - no changes ever posted.
>>>>> schedule.mdb has permissions of R/W/E "for the world" so that is not
>>>>> an
>>>>> issue.
>>>>>
>>>>>
>>>>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote
>>>>> in message news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
>>>>>> Frank:
>>>>>> This is the SQL from the web I created with the restructured
>>>>>> database:
>>>>>>
>>>>>> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
>>>>>> ':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' ,
>>>>>> PMCREW = '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' ,
>>>>>> INSTRUCTOR = '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 =
>>>>>> '::instruct2::' , crew3 = '::crew3::' , crew4 = '::crew4::' WHERE
>>>>>> (xrecnbr = ::xrecnbr:"
>>>>>>
>>>>>> It looks pretty much like yours and it does update the database.
>>>>>>
>>>>>> --
>>>>>> ~ Kathleen Anderson
>>>>>> Microsoft MVP - FrontPage
>>>>>> Spider Web Woman Designs
>>>>>> web: http://www.spiderwebwoman.com/resources/
>>>>>>
>>>>>>
>>>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>>>>> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
>>>>>>> For years things have been fine - and now, not so good.
>>>>>>>
>>>>>>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
>>>>>>> attached) where the record contents are displayed for User editing.
>>>>>>> This page shows the correct record.
>>>>>>> On POST "updatef.asp" is called to do the DB changes - except
>>>>>>> nothing
>>>>>>> happens, no changes.
>>>>>>>
>>>>>>> UPDATE schedule SET
>>>>>>> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
>>>>>>> amcrew='::amcrew::',pmcrew=':mcrew::',
>>>>>>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
>>>>>>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
>>>>>>> WHERE (xrecnbr=::xrecnbr:
>>>>>>>
>>>>>>> After going to FP2003, the above SQL UPDATE "contains an error" -- I
>>>>>>> sure cannot see it.
>>>>>>> IF I remove all the fields except one, the string Validates.
>>>>>>>
>>>>>>> Any ideas?
>>>>>>>
>>>>>>> Note for Kathleen if you see this, new DB structure being used
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

I did some more tinkering, like reducing all the fields down to one - no
change.
Hardcoded a String to stuff in a field - no change....

THEN hardcoded the RecordNumber to Update - Bingo!! - the variable
::xrecnbr:: Must not have a value.
It should be passed from "update3.asp" in the POST.
Update3.txt is attached to see if one of you super MVP's can find the
answer.

"Frank Smith" <noanswer@earthlink.net> wrote in message
news:eTZR1s%232FHA.3036@TK2MSFTNGP15.phx.gbl...
> Nope.
> I have the forms and the DB on two different hosting services FP server
> and
> neither update the DB.
> No error messages generated and no updates posted.
> The code is attached "updatef.txt"
>
> Weird to say the least
>
>
> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
> message news:OJO$FN%232FHA.3000@TK2MSFTNGP12.phx.gbl...
>> Is it working on your live site?
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web: http://www.spiderwebwoman.com/resources/
>>
>>
>>
>>
>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>> news:e0$by892FHA.2676@TK2MSFTNGP15.phx.gbl...
>>>I do my coding on my machine then publish and see if all works, so I
>>>guess
>>>I can stay with XP Home.
>>> I am baffled by the non-updating of the DB, this is not rocket science
>>> stuff, just a simple update.
>>>
>>>
>>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
>>> message news:e3adhQ92FHA.3296@TK2MSFTNGP09.phx.gbl...
>>>> Yes, for this to work on your PC, you need to be running Windows XP Pro
>>>> and IIS.
>>>>
>>>> --
>>>>
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> web: http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>>
>>>>
>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>>> news:uHQ0tE92FHA.400@TK2MSFTNGP09.phx.gbl...
>>>>> Stupid question time - do I need Windows XP Pro for these pages?
>>>>> I have XP Home.
>>>>>
>>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>>>> news:e62erA92FHA.400@TK2MSFTNGP09.phx.gbl...
>>>>>> Thanks
>>>>>> I must be getting far tooooooo old for this stuff.
>>>>>>
>>>>>> Your SQL looks like mine - But does verify/no errors
>>>>>> With no error messages, the sequence from sched2.asp ->
>>>>>> update3.asp ->
>>>>>> updatef.asp just does not update the DB - no changes ever posted.
>>>>>> schedule.mdb has permissions of R/W/E "for the world" so that is not
>>>>>> an
>>>>>> issue.
>>>>>>
>>>>>>
>>>>>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote
>>>>>> in message news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
>>>>>>> Frank:
>>>>>>> This is the SQL from the web I created with the restructured
>>>>>>> database:
>>>>>>>
>>>>>>> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
>>>>>>> ':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' ,
>>>>>>> PMCREW = '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' ,
>>>>>>> INSTRUCTOR = '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 =
>>>>>>> '::instruct2::' , crew3 = '::crew3::' , crew4 = '::crew4::' WHERE
>>>>>>> (xrecnbr = ::xrecnbr:"
>>>>>>>
>>>>>>> It looks pretty much like yours and it does update the database.
>>>>>>>
>>>>>>> --
>>>>>>> ~ Kathleen Anderson
>>>>>>> Microsoft MVP - FrontPage
>>>>>>> Spider Web Woman Designs
>>>>>>> web: http://www.spiderwebwoman.com/resources/
>>>>>>>
>>>>>>>
>>>>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
>>>>>>> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
>>>>>>>> For years things have been fine - and now, not so good.
>>>>>>>>
>>>>>>>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
>>>>>>>> attached) where the record contents are displayed for User editing.
>>>>>>>> This page shows the correct record.
>>>>>>>> On POST "updatef.asp" is called to do the DB changes - except
>>>>>>>> nothing
>>>>>>>> happens, no changes.
>>>>>>>>
>>>>>>>> UPDATE schedule SET
>>>>>>>> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
>>>>>>>> amcrew='::amcrew::',pmcrew=':mcrew::',
>>>>>>>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
>>>>>>>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
>>>>>>>> WHERE (xrecnbr=::xrecnbr:
>>>>>>>>
>>>>>>>> After going to FP2003, the above SQL UPDATE "contains an error" --
>>>>>>>> I
>>>>>>>> sure cannot see it.
>>>>>>>> IF I remove all the fields except one, the string Validates.
>>>>>>>>
>>>>>>>> Any ideas?
>>>>>>>>
>>>>>>>> Note for Kathleen if you see this, new DB structure being used
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
>

In updatef.txt at the top of the page in code view below
<% Response.Buffer = True %>
Add
<% xrecnbr = Request.Form("xrecnbr") %>

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontP...53/Default.aspx
_____________________________________________


"Frank Smith" <noanswer@earthlink.net> wrote in message news:OmVdhE$2FHA.4048@TK2MSFTNGP10.phx.gbl...
|I did some more tinkering, like reducing all the fields down to one - no
| change.
| Hardcoded a String to stuff in a field - no change....
|
| THEN hardcoded the RecordNumber to Update - Bingo!! - the variable
| ::xrecnbr:: Must not have a value.
| It should be passed from "update3.asp" in the POST.
| Update3.txt is attached to see if one of you super MVP's can find the
| answer.
|
| "Frank Smith" <noanswer@earthlink.net> wrote in message
| news:eTZR1s%232FHA.3036@TK2MSFTNGP15.phx.gbl...
| > Nope.
| > I have the forms and the DB on two different hosting services FP server
| > and
| > neither update the DB.
| > No error messages generated and no updates posted.
| > The code is attached "updatef.txt"
| >
| > Weird to say the least
| >
| >
| > "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
| > message news:OJO$FN%232FHA.3000@TK2MSFTNGP12.phx.gbl...
| >> Is it working on your live site?
| >>
| >> --
| >>
| >> ~ Kathleen Anderson
| >> Microsoft MVP - FrontPage
| >> Spider Web Woman Designs
| >> web: http://www.spiderwebwoman.com/resources/
| >>
| >>
| >>
| >>
| >> "Frank Smith" <noanswer@earthlink.net> wrote in message
| >> news:e0$by892FHA.2676@TK2MSFTNGP15.phx.gbl...
| >>>I do my coding on my machine then publish and see if all works, so I
| >>>guess
| >>>I can stay with XP Home.
| >>> I am baffled by the non-updating of the DB, this is not rocket science
| >>> stuff, just a simple update.
| >>>
| >>>
| >>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote in
| >>> message news:e3adhQ92FHA.3296@TK2MSFTNGP09.phx.gbl...
| >>>> Yes, for this to work on your PC, you need to be running Windows XP Pro
| >>>> and IIS.
| >>>>
| >>>> --
| >>>>
| >>>> ~ Kathleen Anderson
| >>>> Microsoft MVP - FrontPage
| >>>> Spider Web Woman Designs
| >>>> web: http://www.spiderwebwoman.com/resources/
| >>>>
| >>>>
| >>>>
| >>>>
| >>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
| >>>> news:uHQ0tE92FHA.400@TK2MSFTNGP09.phx.gbl...
| >>>>> Stupid question time - do I need Windows XP Pro for these pages?
| >>>>> I have XP Home.
| >>>>>
| >>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
| >>>>> news:e62erA92FHA.400@TK2MSFTNGP09.phx.gbl...
| >>>>>> Thanks
| >>>>>> I must be getting far tooooooo old for this stuff.
| >>>>>>
| >>>>>> Your SQL looks like mine - But does verify/no errors
| >>>>>> With no error messages, the sequence from sched2.asp ->
| >>>>>> update3.asp ->
| >>>>>> updatef.asp just does not update the DB - no changes ever posted.
| >>>>>> schedule.mdb has permissions of R/W/E "for the world" so that is not
| >>>>>> an
| >>>>>> issue.
| >>>>>>
| >>>>>>
| >>>>>> "Kathleen Anderson [MVP - FrontPage]" <spiderwebwoman@mvps.org> wrote
| >>>>>> in message news:uvgUTm12FHA.2196@tk2msftngp13.phx.gbl...
| >>>>>>> Frank:
| >>>>>>> This is the SQL from the web I created with the restructured
| >>>>>>> database:
| >>>>>>>
| >>>>>>> s-sql="UPDATE schedule SET xdate = '::xdate::' , DISPATCHER =
| >>>>>>> ':ISPATCHER::' , PHONE = '::PHONE::' , AMCREW = '::AMCREW::' ,
| >>>>>>> PMCREW = '::PMCREW::' , AMTOW = '::AMTOW::' , PMTOW = '::PMTOW::' ,
| >>>>>>> INSTRUCTOR = '::INSTRUCTOR::' , ipilot = '::ipilot::' , instruct2 =
| >>>>>>> '::instruct2::' , crew3 = '::crew3::' , crew4 = '::crew4::' WHERE
| >>>>>>> (xrecnbr = ::xrecnbr:"
| >>>>>>>
| >>>>>>> It looks pretty much like yours and it does update the database.
| >>>>>>>
| >>>>>>> --
| >>>>>>> ~ Kathleen Anderson
| >>>>>>> Microsoft MVP - FrontPage
| >>>>>>> Spider Web Woman Designs
| >>>>>>> web: http://www.spiderwebwoman.com/resources/
| >>>>>>>
| >>>>>>>
| >>>>>>> "Frank Smith" <noanswer@earthlink.net> wrote in message
| >>>>>>> news:u5q2Q1y2FHA.3188@TK2MSFTNGP12.phx.gbl...
| >>>>>>>> For years things have been fine - and now, not so good.
| >>>>>>>>
| >>>>>>>> A page passes a Parameter (xrecnbr) to the page "Update3.asp" (txt
| >>>>>>>> attached) where the record contents are displayed for User editing.
| >>>>>>>> This page shows the correct record.
| >>>>>>>> On POST "updatef.asp" is called to do the DB changes - except
| >>>>>>>> nothing
| >>>>>>>> happens, no changes.
| >>>>>>>>
| >>>>>>>> UPDATE schedule SET
| >>>>>>>> xdate='::xdate::',dispatcher='::dispatcher::',phone=':hone::',
| >>>>>>>> amcrew='::amcrew::',pmcrew=':mcrew::',
| >>>>>>>> crew3='::crew3::',crew4='::crew4::',amtow='::amtow::',pmtow=':mtow::',
| >>>>>>>> instructor='::instructor::',ipilot='::ipilot::',instruct2='::instruct2::'
| >>>>>>>> WHERE (xrecnbr=::xrecnbr:
| >>>>>>>>
| >>>>>>>> After going to FP2003, the above SQL UPDATE "contains an error" --
| >>>>>>>> I
| >>>>>>>> sure cannot see it.
| >>>>>>>> IF I remove all the fields except one, the string Validates.
| >>>>>>>>
| >>>>>>>> Any ideas?
| >>>>>>>>
| >>>>>>>> Note for Kathleen if you see this, new DB structure being used
| >>>>>>>>
| >>>>>>>>
| >>>>>>>>
| >>>>>>>
| >>>>>>>
| >>>>>>
| >>>>>>
| >>>>>
| >>>>>
| >>>>
| >>>>
| >>>
| >>>
| >>
| >>
| >
| >
| >
|
|
|