The Database Results Wizard is for displaying data, not updating data
- and you can not edit the colored code starting w/ "fp_sQry= ..."
- you need to be editing the grey code above it (starting with s-sql=...)
To update data you should try the Database Interface wizard (instead of the Database Results Wizard) as a web template
- to tweak the DBRW to update records see and download the code from
http://home.att.net/~codelibrary/FrontPage/drw.htm
| To create the updaterecord.asp page I used the database results wizard to
| create the update using this custom query:
|
| fp_sQry="UPDATE Alumni SET
|
GradYear='::GradYear::',Title='::Title::',Fname='::Fname::',Lname='::Lname::',Suffix='::Suffix::',Address1='::Address1::',City='::City::',Zip='::Zip::',Salutation='::Salutation::',Hphone='::Hphone::',Wphone='::Wphone::',email='::email::',Comments='::Comments::',AdditionalComments='::AdditionalComments::',Employer='::Employer::',Occupation='::Occupation::',Position=':
osition::',Mstatus='::Mstatus::',Parish=':
arish::',Spouse='::Spouse::',Child1='::Child1::',Child2='::Child2::',Child3='::Child3::',Child4='::Child4::',Pname=':
name::',ClassRep='::ClassRep::',
Tdate='::Tdate::' WHERE ID='::ID::'"
|
| I get this error message: Database Results Error
| Your page contains a query with user input parameters that could not be
| resolved.
| This could happen if your DatabaseRegionStart webbot has an empty or missing
| s-columnnames or s-columntypes attributes. You may need to read Microsoft
| Knowledge Base Article 817029.
|
| One or more form fields were empty. You should provide default values for
| all form fields that are used in the query.
|
| When I apply the workaround2 and save the page the code changes to
| fp_sQry="SELECT * FROM Alumni WHERE (ID = '::ID::')"
|
| if I try pasting the UPDATE Alumni SET back in, I can’t save the page.
|
| "Stefan B Rusynko" wrote:
|
| > When I submit your 1st page I get your 2nd page w/o an error
| > - doesn't mean it updated anything
| > What errors are you getting
| >
| > FYI
| > Your second page may not be visible in many browser since all it has is
| > <html>
| > <table>
| > <tbody>
| > </tbody>
| > </table>
| > <p align="center"><a href="AlumFind.asp">Done</a></p>
| > </html>
| >
| > --
| >
| > _____________________________________________
| > 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.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | Yes. Most of the time the workaround does the trick. But when I apply the
| > | workaround to the update query to write to the database, the page will not
| > | write to the database. from this page:
| > |
http://www.diocesephoenix.org/school/seton_catholic_hs/Alumni/Alum-edit.asp?ID=4587
| > | to this one:
| > |
http://www.diocesephoenix.org/school/seton_catholic_hs/Alumni/updaterecord.asp
| > |
| > | Any other suggestions as to what is causing it, and what I can do to fix it
| > | permanently?
| > |
| > | "Stefan B Rusynko" wrote:
| > |
| > | > Have you tried Workaround 2 on those pages?
| > | >
| > | > --
| > | >
| > | > _____________________________________________
| > | > 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.net-sites.com/sitebuilder/newsgroups.asp
| > | > _____________________________________________
| > | >
| > | >
| > | > |I did that, thank you. This is the message I am getting now:
| > | > | Database Results Error
| > | > | Your page contains a query with user input parameters that could not be
| > | > | resolved.
| > | > | This could happen if your DatabaseRegionStart webbot has an empty or missing
| > | > | s-columnnames or s-columntypes attributes.
| > | > | You may need to read Microsoft Knowledge Base Article 817029.
| > | > |
| > | > | I have read the article, talked to support where the site is hosted, they
| > | > | installed a patch, and in some cases, if I completely regenerate the database
| > | > | results, it will work without the second work around that calls for cutting
| > | > | and pasting the s-columnnames and types. In a couple of places it doesn't
| > | > | work: such as:
| > | > |
http://www.diocesephoenix.org/school/seton_catholic_hs/Gerard/Update/AlumFind.asp
| > | > | Any more suggestions as to what is causing it, and what I can do to fix it?
| > | > |
| > | > | "Stefan B Rusynko" wrote:
| > | > |
| > | > | > Temporarily to see more details on the error, open the hidden folder /_fpclass/ and edit the
| > | > | > fpdbrgn1.inc file and at about line 19, change :
| > | > | > fp_DEBUG = False
| > | > | > to :
| > | > | > fp_DEBUG = True
| > | > | >
| > | > | > --
| > | > | >
| > | > | > _____________________________________________
| > | > | > 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.net-sites.com/sitebuilder/newsgroups.asp
| > | > | > _____________________________________________
| > | > | >
| > | > | >
| > | > | > |I am the website developer for
www.setoncatholic.org. The public, at several
| > | > | > | different computers, receive this message:
| > | > | > |
| > | > | > | Database Results Error
| > | > | > | The operation failed. If this continues, please contact your server
| > | > | > | administrator.
| > | > | > |
| > | > | > | at this page, and every similar page in my web that has database results:
| > | > | > |
http://www.diocesephoenix.org/school/seton_catholic_hs/Parents/Hours/Search.asp
| > | > | > |
| > | > | > | It worked 36 hours ago, when I looked at the fpdb folder, the "allow scripts
| > | > | > | to be run" and "allow files to be browsed" were not checked, so I checked
| > | > | > | them, and we had changed from Internet Explorer and Navigator to Internet
| > | > | > | Explorere only, and I have now changed that back again. Although I have seen
| > | > | > | many error messages, I have not seen this one before. Any ideas what else to
| > | > | > | try.
| > | > | >
| > | > | >
| > | > | >
| > | >
| > | >
| > | >
| >
| >
| >
