Update Query again

F

Francis Phillips

Hi,

I have been trying to get this update query working all day - I am still
waiting for MS to get back I got referred to the specialist team in the
US...

Anyways - I am trying to update 5 fields in an access table.

I have tried with the wizard creating a database interface but that only
allows the whole table to be updated and when you remove the fields you
don't want it give me the:

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

I am beginning to wonder if it is possible to do an update on a portion of a
table - these queries worked fine when I was using FP2000 but since
upgrading to FP2003 they have stopped working giving the above v helpful
message. Nothing else has changed on my system except the upgrade so I am
assuming this is a FP2003 issue.

As I say I have looked at the wizards output and the queried and the say and
they get verified fine - can anybody suggest anything or alternatively give
me the number to macromedia :)

Thanks

Frank
 
D

David Berry

Check and make sure that the folder that contains your database has Read and
Write access. If this is on your ISP's server they might have to check this
for you.
 
F

Francis Phillips

I have checked this and it seems fine.

I am at a complete loss about what could be causing this.

Any other suggestions would be really welcome.#

Thanks
 
F

Francis Phillips

Hi,

I have spent the last hour or so trying this - it does not seem to make any
difference..

Any other ideas?

Many Thanks

Frank
 
T

Thomas A. Rowe

Sorry no other ideas, as I prefer to hand code and not rely on the FP database components.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
 
F

Francis Phillips

Hi,

Thanks for this:

I now get the error:

Database Results Wizard 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 already looked at this and my webot looks like:


<!--webbot bot="DatabaseRegionStart"
s-columnnames="FinanceContact,FinanceContactJobTitle,FinanceContactTelNumber
,FinanceContactE-Mail" s-columntypes="202,202,202,202"
s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns
s-criteria s-order s-sql="Update Organisations SET
organisations.[FinanceContact]= '::Fin1::',
organisations.[FinanceContactJobTitle]= '::Fin2::',
organisations.[FinanceContactTelNumber] = '::Fin3::',
organisations.[FinanceContactE-mail] = '::Fin4::' Where
(organisations.[OrganisationName] = ::OrganisationName::)"
b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Fin1=&Fin2=&Fin3=&Fin4=&OrganisationName=test"
s-norecordsfound="No records returned." i-maxrecords="1" i-groupsize="0"
botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is
the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
startspan --><!--#include file="_fpclass/fpdblib.inc"-->

Any other suggestions please?
Does anyone know of a resource where I can teach my self how to to this by
hand?#

Thanks

Frank
 
K

Kathleen Anderson [MVP - FrontPage]

The recommended 'easy' fix is to replace the includes in the '_fpclass'
folder with the old versions from FP2000/2
http://www.frontpagewebmaster.com/m-175524/tm.htm


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



Francis Phillips said:
Hi,

Thanks for this:

I now get the error:

Database Results Wizard 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 already looked at this and my webot looks like:


<!--webbot bot="DatabaseRegionStart"
s-columnnames="FinanceContact,FinanceContactJobTitle,FinanceContactTelNumber
,FinanceContactE-Mail" s-columntypes="202,202,202,202"
s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE"
s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns
s-criteria s-order s-sql="Update Organisations SET
organisations.[FinanceContact]= '::Fin1::',
organisations.[FinanceContactJobTitle]= '::Fin2::',
organisations.[FinanceContactTelNumber] = '::Fin3::',
organisations.[FinanceContactE-mail] = '::Fin4::' Where
(organisations.[OrganisationName] = ::OrganisationName::)"
b-procedure="FALSE" clientside suggestedext="asp"
s-defaultfields="Fin1=&Fin2=&Fin3=&Fin4=&OrganisationName=test"
s-norecordsfound="No records returned." i-maxrecords="1" i-groupsize="0"
botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="&lt;table border=0
width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
bgcolor=&quot;#FFFF00&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This
is
the start of a Database Results
region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
startspan --><!--#include file="_fpclass/fpdblib.inc"-->

Any other suggestions please?
Does anyone know of a resource where I can teach my self how to to this by
hand?#

Thanks

Frank


Kathleen Anderson said:
To see the true error, open the hidden folder /_fpclass/ and edit the
fpdbrgn1.inc file

At about line 19, change :

fp_DEBUG = False

to :

fp_DEBUG = True


--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx
Click to expand...
Click to expand...
 
S

Stefan B Rusynko

Try renaming the DB field FinanceContactE-mail to FinanceContactE_mail or better still FinanceContactEmail

Although Access allows spaces and punctuation in field names, the accepted practice is to avoid them or use the under_score

As for learning some basic DB queries using ASP try starting at http://asp101.com/samples/




| Hi,
|
| Thanks for this:
|
| I now get the error:
|
| Database Results Wizard 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 already looked at this and my webot looks like:
|
|
| <!--webbot bot="DatabaseRegionStart"
| s-columnnames="FinanceContact,FinanceContactJobTitle,FinanceContactTelNumber
| ,FinanceContactE-Mail" s-columntypes="202,202,202,202"
| s-dataconnection="Database1" b-tableformat="FALSE" b-menuformat="FALSE"
| s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE"
| b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns
| s-criteria s-order s-sql="Update Organisations SET
| organisations.[FinanceContact]= '::Fin1::',
| organisations.[FinanceContactJobTitle]= '::Fin2::',
| organisations.[FinanceContactTelNumber] = '::Fin3::',
| organisations.[FinanceContactE-mail] = '::Fin4::' Where
| (organisations.[OrganisationName] = ::OrganisationName::)"
| b-procedure="FALSE" clientside suggestedext="asp"
| s-defaultfields="Fin1=&Fin2=&Fin3=&Fin4=&OrganisationName=test"
| s-norecordsfound="No records returned." i-maxrecords="1" i-groupsize="0"
| botid="0" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
| u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="BODY" preview="&lt;table border=0
| width=&quot;100%&quot;&gt;&lt;tr&gt;&lt;td
| bgcolor=&quot;#FFFF00&quot;&gt;&lt;font color=&quot;#000000&quot;&gt;This is
| the start of a Database Results
| region.&lt;/font&gt;&lt;/td&gt;&lt;/tr&gt;&lt;/table&gt;"
| startspan --><!--#include file="_fpclass/fpdblib.inc"-->
|
| Any other suggestions please?
| Does anyone know of a resource where I can teach my self how to to this by
| hand?#
|
| Thanks
|
| Frank
|
|
| message | > To see the true error, open the hidden folder /_fpclass/ and edit the
| > fpdbrgn1.inc file
| >
| > At about line 19, change :
| >
| > fp_DEBUG = False
| >
| > to :
| >
| > fp_DEBUG = True
| >
| >
| > --
| > ~ Kathleen Anderson
| > Microsoft MVP - FrontPage
| > Spider Web Woman Designs
| > web: http://www.spiderwebwoman.com/resources/
| > blog: http://msmvps.com/spiderwebwoman/category/321.aspx
| >
| >
| >
| > | > > Hi,
| > >
| > > I have been trying to get this update query working all day - I am still
| > > waiting for MS to get back I got referred to the specialist team in the
| > > US...
| > >
| > > Anyways - I am trying to update 5 fields in an access table.
| > >
| > > I have tried with the wizard creating a database interface but that only
| > > allows the whole table to be updated and when you remove the fields you
| > > don't want it give me the:
| > >
| > > Database Results Wizard Error
| > > The operation failed. If this continues, please contact your server
| > > administrator.
| > >
| > > I am beginning to wonder if it is possible to do an update on a portion
| of
| > > a
| > > table - these queries worked fine when I was using FP2000 but since
| > > upgrading to FP2003 they have stopped working giving the above v helpful
| > > message. Nothing else has changed on my system except the upgrade so I
| am
| > > assuming this is a FP2003 issue.
| > >
| > > As I say I have looked at the wizards output and the queried and the say
| > > and
| > > they get verified fine - can anybody suggest anything or alternatively
| > > give
| > > me the number to macromedia :)
| > >
| > > Thanks
| > >
| > > Frank
| > >
| > >
| >
| >
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Embedded Excel into Word with Tables 0
How to automate update on weekly reports spreadsheet 0
Mail Merge file containing a Word Table 0
Excel freezing after sharing document by Email 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Outlook emails loading very slowly 0
Sub projects added as read only in Master file which are saved on sharepoint 1

Top