Re: ASP UPDATE problem.. Continued

Frank:
I will send you the SQL from the page I created that worked - as soon as I
get home.

--

~ 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
>
>
>