SQL DB problems - desparate

Michael · Aug 27, 2005

Hello,

I have a serious issue with FrontPage connections to a SQL database. I've
included code and all the error messages at the bottom of this message.

The environment is as follows: Win2003 Server running FP2002 Server
Extensions, connected via Ethernet to MS SQL 2000. All service packs
(Windows, Office, SQL) are applied to both servers as well as on my FP
authoring machine.

I had a number of pages that query databases working just fine up until
recently. I was having difficulty with a particular custom query in the DRW
that was hanging FrontPage. I attempted to edit the HTML directly, and when I
saved the page, suddenly all of my pages on the server that use variables
passed from other pages failed with the "Database Results Error" message.
Some say "Unable to find operator in query string." Others say I have missing
s-columnnames.

I futzed around for some time trying to return it to working order and
finally had to restore from a backup. It then worked again for a few days.

Tonight, I have been working on launching a SQL stored procedure from within
the site using ASP and ADO. I saved the page in FrontPage, and tested the
stored procedure. It launched and executed successfully. However, my problem
with all the DRW pages returned.

Note that the DRW pages that do not include a variable with the
::variablename:: syntax are all working. It is only the DRW regions with
custom queries that use the ::variablename:: syntax in the select statement
that have died. But they all died at once.

I have been reading other submissions of this type and the replies so I can
probably anticipate the answers to some of the questions:

- I have read KB 817029. It does not appear relevant. None of the pages I
have examined actually have any missing s-columnnames. The fields are fully
populated.
- I have deleted and recreated the database connection in FrontPage. I have
deleted and recreated the ODBC System DSN on the server. Neither helped.
- I only modified one page, but suddenly every page on my server that
included a DRW with the query including a parameter from a prior page e.g.
::Lastname:: is giving me the Database Results Error, which makes me think
something is corrupted on the server side.
- I tried creating a new web with new database results. It worked fine
provided I didn't pass parameters with ::variablename::.
- This isn't hosted by a third-party. The web server is five feet from me so
I know no patches were applied that caused it to break.
- I have already corrected one issue I was definitely having, which was a
virus scanner locking up the global.asa file. The file is now excluded from
my virus scans and everyone can write to global.asa as needed.
- I have tried enclosing anything resembling a keyword in square brackets.
The queries worked fine without them before the issue popped up, and adding
square brackets didn't help afterwards.

I saw a post that indicated there perhaps was a known issue with Office XP
SP3 that would cause all DRW pages on a server to suddenly go haywire similar
to the way mine have. Does anyone know about a resolution or hotfix for that?

Can anyone help me with other suggestions? I'm desparate!

Thank you.

- Michael Gibbons

=======================================
Code from one of the pages below: note s-columnnames are filled out
=======================================
<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Instructor Schedule</title>
</head>

<body>

<p>3.1.1 - Instructor Schedule Results</p>
<form method="POST" action="--WEBBOT-SELF--">
<input TYPE="hidden"
NAME="VTI-GROUP" VALUE="0"><table border="0" cellpadding="0" cellspacing="0"
style="border-collapse: collapse" bordercolor="#111111" width="901"
id="AutoNumber1">
<tr>
<td width="112" align="right">Instructor:</td>
<td width="789">
<table>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT instructorname FROM instructors where
instructorname='::instructorname::' "
fp_sDefault="instructorname="
fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="cs600proj"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&instructorname=129&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=1
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"instructorname")%></td>
</tr>

</tbody>
</table>
</td>
</tr>
<tr>
<td width="112" align="right">Year:</td>
<td width="789">
<table>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="select distinct cs600proj.dbo.TextAcademicYear(academicyear) as
year from quarters where
academicyear=cs600proj.dbo.CvtToAcademicYear('::academicyear::') "
fp_sDefault="academicyear="
fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="cs600proj"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&year=129&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=2
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"year")%></td>
</tr>

</tbody>
</table>
</td>
</tr>
<tr>
<td width="112" align="right">Quarter:</td>
<td width="789">
<table>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="select distinct cs600proj.dbo.TextQuarter(quarter) as theQuarter
from quarters where quarter=cs600proj.dbo.CvtToQuarter('::quarter::') "
fp_sDefault="quarter="
fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="cs600proj"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&theQuarter=129&"
fp_iDisplayCols=1
fp_fCustomQuery=True
BOTID=3
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"theQuarter")%></td>
</tr>

</tbody>
</table>
</td>
</tr>
</table>
<table>
</table>
</form>
<table width="100%" border="1">
<thead>
<tr>
<td><b>Time Period</b></td>
<td><b>Classroom</b></td>
<td><b>Course Number</b></td>
<td><b>Description</b></td>
<td><b>Number of Students</b></td>
</tr>
</thead>
<tbody>

<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database
Results component on this page is unable to display database content. The
page must have a filename ending in '.asp', and the web must be hosted on a
server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="select cs600proj.dbo.texttimeperiod(timePeriod) 'Time Period',
classroom 'Classroom',
cs600proj.dbo.textCourseNumber(cs.prefix,cs.courseNumber) 'Course Number',
c.coursedescription as 'Description', count(*) as 'Number of Students' from
classroomschedule cs join instructors i on cs.instructorid=i.instructorid
join studentschedule ss on cs.academicyear=ss.academicyear and
cs.quarter=ss.quarter and cs.prefix=ss.prefix and
cs.coursenumber=ss.coursenumber join catalog c on cs.prefix=c.prefix and
cs.coursenumber=c.coursenumber where
cs.academicyear=cs600proj.dbo.CvtToAcademicYear('::academicyear::') and
cs.quarter=cs600proj.dbo.CvtToQuarter('::quarter::') and
i.instructorname='::instructorname::' group by timePeriod, classroom,
cs.Prefix, cs.CourseNumber, c.coursedescription order by timePeriod,
classroom"
fp_sDefault="academicyear=&quarter=&instructorname="
fp_sNoRecords="<tr><td colspan=5 align=left width=""100%"">No classes
scheduled for selected quarter.</td></tr>"
fp_sDataConn="cs600proj"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Time Period"
fp_sMenuValue="Time Period"
fp_sColTypes="&Time Period=129&Classroom=3&Course
Number=129&Description=129&Number of Students=3&"
fp_iDisplayCols=5
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

<tr>
<td>
<%=FP_FieldVal(fp_rs,"Time
Period")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Classroom")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Course Number")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Description")%></td>
<td>
<%=FP_FieldVal(fp_rs,"Number of Students")%></td>
</tr>

</tbody>
</table>
<p><a href="3-1.asp">Back to Display Instructor Schedule</a></p>

</body>

</html>

==================================
Output from FrontPage below
==================================

3.1.1 - Instructor Schedule Results

Instructor: 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.

Year: Database Results Error
Unable to find operator in query string. Query string currently is select
distinct cs600proj.dbo.TextAcademicYear(academicyear) as year from quarters
where academicyear=cs600proj.dbo.CvtToAcademicYear('::academicyear::')

Quarter: Database Results Error
Unable to find operator in query string. Query string currently is select
distinct cs600proj.dbo.TextQuarter(quarter) as theQuarter from quarters where
quarter=cs600proj.dbo.CvtToQuarter('::quarter::')

Time Period Classroom Course Number Description Number of Students
Database Results Error
Unable to find operator in query string. Query string currently is select
cs600proj.dbo.texttimeperiod(timePeriod) 'Time Period', classroom
'Classroom', cs600proj.dbo.textCourseNumber(cs.prefix,cs.courseNumber)
'Course Number', c.coursedescription as 'Description', count(*) as 'Number of
Students' from classroomschedule cs join instructors i on
cs.instructorid=i.instructorid join studentschedule ss on
cs.academicyear=ss.academicyear and cs.quarter=ss.quarter and
cs.prefix=ss.prefix and cs.coursenumber=ss.coursenumber join catalog c on
cs.prefix=c.prefix and cs.coursenumber=c.coursenumber where
cs.academicyear=cs600proj.dbo.CvtToAcademicYear('::academicyear::') and
cs.quarter=cs600proj.dbo.CvtToQuarter('::quarter::') and
i.instructorname='::instructorname::' group by timePeriod, classroom,
cs.Prefix, cs.CourseNumber, c.coursedescription order by timePeriod,
classroom

Back to Display Instructor Schedule

Stefan B Rusynko · Aug 27, 2005

You have 4 DBRW in your page
(all the DBRW appear to have been heavily edited - but that may be a paste issue)
- 3 of which for some reason are wrapped in a form - but not as form fields (why use the form at all?)
- 1 of which uses complex joins and criteria
- all of which (but is may be a paste issue) have <br> tags in the grey SQL criteria code
(also recommend not using spaces in any new or existing field names)

Recommend you create a separate new page for each of the 4 DBRW, starting out simply to show all fields and then progressively
adding one criteria at a time (use a form for each first before you try to get querystrings)
Only combine them on 1 page when you get each working independently

| Hello,
|
| I have a serious issue with FrontPage connections to a SQL database. I've
| included code and all the error messages at the bottom of this message.
|
| The environment is as follows: Win2003 Server running FP2002 Server
| Extensions, connected via Ethernet to MS SQL 2000. All service packs
| (Windows, Office, SQL) are applied to both servers as well as on my FP
| authoring machine.
|
| I had a number of pages that query databases working just fine up until
| recently. I was having difficulty with a particular custom query in the DRW
| that was hanging FrontPage. I attempted to edit the HTML directly, and when I
| saved the page, suddenly all of my pages on the server that use variables
| passed from other pages failed with the "Database Results Error" message.
| Some say "Unable to find operator in query string." Others say I have missing
| s-columnnames.
|
| I futzed around for some time trying to return it to working order and
| finally had to restore from a backup. It then worked again for a few days.
|
| Tonight, I have been working on launching a SQL stored procedure from within
| the site using ASP and ADO. I saved the page in FrontPage, and tested the
| stored procedure. It launched and executed successfully. However, my problem
| with all the DRW pages returned.
|
| Note that the DRW pages that do not include a variable with the
| ::variablename:: syntax are all working. It is only the DRW regions with
| custom queries that use the ::variablename:: syntax in the select statement
| that have died. But they all died at once.
|
| I have been reading other submissions of this type and the replies so I can
| probably anticipate the answers to some of the questions:
|
| - I have read KB 817029. It does not appear relevant. None of the pages I
| have examined actually have any missing s-columnnames. The fields are fully
| populated.
| - I have deleted and recreated the database connection in FrontPage. I have
| deleted and recreated the ODBC System DSN on the server. Neither helped.
| - I only modified one page, but suddenly every page on my server that
| included a DRW with the query including a parameter from a prior page e.g.
| ::Lastname:: is giving me the Database Results Error, which makes me think
| something is corrupted on the server side.
| - I tried creating a new web with new database results. It worked fine
| provided I didn't pass parameters with ::variablename::.
| - This isn't hosted by a third-party. The web server is five feet from me so
| I know no patches were applied that caused it to break.
| - I have already corrected one issue I was definitely having, which was a
| virus scanner locking up the global.asa file. The file is now excluded from
| my virus scans and everyone can write to global.asa as needed.
| - I have tried enclosing anything resembling a keyword in square brackets.
| The queries worked fine without them before the issue popped up, and adding
| square brackets didn't help afterwards.
|
| I saw a post that indicated there perhaps was a known issue with Office XP
| SP3 that would cause all DRW pages on a server to suddenly go haywire similar
| to the way mine have. Does anyone know about a resolution or hotfix for that?
|
| Can anyone help me with other suggestions? I'm desparate!
|
| Thank you.
|
| - Michael Gibbons
|
| =======================================
| Code from one of the pages below: note s-columnnames are filled out
| =======================================
| <html>
|
| <head>
| <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
| Edit.
| FP_LCID = 1033 %>
| <meta http-equiv="Content-Language" content="en-us">
| <meta name="GENERATOR" content="Microsoft FrontPage 5.0">
| <meta name="ProgId" content="FrontPage.Editor.Document">
| <% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not
| Edit.
| FP_CharSet = "windows-1252"
| FP_CodePage = 1252 %>
| <meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
| <title>Instructor Schedule</title>
| </head>
|
| <body>
|
| <p>3.1.1 - Instructor Schedule Results</p>
| <form method="POST" action="--WEBBOT-SELF--">
| <input TYPE="hidden"
| NAME="VTI-GROUP" VALUE="0"><table border="0" cellpadding="0" cellspacing="0"
| style="border-collapse: collapse" bordercolor="#111111" width="901"
| id="AutoNumber1">
| <tr>
| <td width="112" align="right">Instructor:</td>
| <td width="789">
| <table>
| <tbody>
| 
| <% if 0 then %>
| <SCRIPT Language="JavaScript">
| document.write("<div style='background: yellow; color: black;'>The Database
| Results component on this page is unable to display database content. The
| page must have a filename ending in '.asp', and the web must be hosted on a
| server that supports Active Server Pages.</div>");
| </SCRIPT>
| <% end if %>
| <%
| fp_sQry="SELECT instructorname FROM instructors where
| instructorname='::instructorname::' "
| fp_sDefault="instructorname="
| fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records
| returned.</td></tr>"
| fp_sDataConn="cs600proj"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_sColTypes="&instructorname=129&"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=1
| fp_iRegion=BOTID
| %>
| 
| <tr>
| <td>
| <%=FP_FieldVal(fp_rs,"instructorname")%></td>
| </tr>
| 
| </tbody>
| </table>
| </td>
| </tr>
| <tr>
| <td width="112" align="right">Year:</td>
| <td width="789">
| <table>
| <tbody>
| 
| <% if 0 then %>
| <SCRIPT Language="JavaScript">
| document.write("<div style='background: yellow; color: black;'>The Database
| Results component on this page is unable to display database content. The
| page must have a filename ending in '.asp', and the web must be hosted on a
| server that supports Active Server Pages.</div>");
| </SCRIPT>
| <% end if %>
| <%
| fp_sQry="select distinct cs600proj.dbo.TextAcademicYear(academicyear) as
| year from quarters where
| academicyear=cs600proj.dbo.CvtToAcademicYear('::academicyear::') "
| fp_sDefault="academicyear="
| fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records
| returned.</td></tr>"
| fp_sDataConn="cs600proj"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_sColTypes="&year=129&"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=2
| fp_iRegion=BOTID
| %>
| 
| <tr>
| <td>
| <%=FP_FieldVal(fp_rs,"year")%></td>
| </tr>
| 
| </tbody>
| </table>
| </td>
| </tr>
| <tr>
| <td width="112" align="right">Quarter:</td>
| <td width="789">
| <table>
| <tbody>
| 
| <% if 0 then %>
| <SCRIPT Language="JavaScript">
| document.write("<div style='background: yellow; color: black;'>The Database
| Results component on this page is unable to display database content. The
| page must have a filename ending in '.asp', and the web must be hosted on a
| server that supports Active Server Pages.</div>");
| </SCRIPT>
| <% end if %>
| <%
| fp_sQry="select distinct cs600proj.dbo.TextQuarter(quarter) as theQuarter
| from quarters where quarter=cs600proj.dbo.CvtToQuarter('::quarter::') "
| fp_sDefault="quarter="
| fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records
| returned.</td></tr>"
| fp_sDataConn="cs600proj"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice=""
| fp_sMenuValue=""
| fp_sColTypes="&theQuarter=129&"
| fp_iDisplayCols=1
| fp_fCustomQuery=True
| BOTID=3
| fp_iRegion=BOTID
| %>
| 
| <tr>
| <td>
| <%=FP_FieldVal(fp_rs,"theQuarter")%></td>
| </tr>
| 
| </tbody>
| </table>
| </td>
| </tr>
| </table>
| <table>
| </table>
| </form>
| <table width="100%" border="1">
| <thead>
| <tr>
| <td><b>Time Period</b></td>
| <td><b>Classroom</b></td>
| <td><b>Course Number</b></td>
| <td><b>Description</b></td>
| <td><b>Number of Students</b></td>
| </tr>
| </thead>
| <tbody>
| 
| <% if 0 then %>
| <SCRIPT Language="JavaScript">
| document.write("<div style='background: yellow; color: black;'>The Database
| Results component on this page is unable to display database content. The
| page must have a filename ending in '.asp', and the web must be hosted on a
| server that supports Active Server Pages.</div>");
| </SCRIPT>
| <% end if %>
| <%
| fp_sQry="select cs600proj.dbo.texttimeperiod(timePeriod) 'Time Period',
| classroom 'Classroom',
| cs600proj.dbo.textCourseNumber(cs.prefix,cs.courseNumber) 'Course Number',
| c.coursedescription as 'Description', count(*) as 'Number of Students' from
| classroomschedule cs join instructors i on cs.instructorid=i.instructorid
| join studentschedule ss on cs.academicyear=ss.academicyear and
| cs.quarter=ss.quarter and cs.prefix=ss.prefix and
| cs.coursenumber=ss.coursenumber join catalog c on cs.prefix=c.prefix and
| cs.coursenumber=c.coursenumber where
| cs.academicyear=cs600proj.dbo.CvtToAcademicYear('::academicyear::') and
| cs.quarter=cs600proj.dbo.CvtToQuarter('::quarter::') and
| i.instructorname='::instructorname::' group by timePeriod, classroom,
| cs.Prefix, cs.CourseNumber, c.coursedescription order by timePeriod,
| classroom"
| fp_sDefault="academicyear=&quarter=&instructorname="
| fp_sNoRecords="<tr><td colspan=5 align=left width=""100%"">No classes
| scheduled for selected quarter.</td></tr>"
| fp_sDataConn="cs600proj"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=0
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice="Time Period"
| fp_sMenuValue="Time Period"
| fp_sColTypes="&Time Period=129&Classroom=3&Course
| Number=129&Description=129&Number of Students=3&"
| fp_iDisplayCols=5
| fp_fCustomQuery=True
| BOTID=0
| fp_iRegion=BOTID
| %>
| 
| <tr>
| <td>
| <%=FP_FieldVal(fp_rs,"Time
| Period")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Classroom")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Course Number")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Description")%></td>
| <td>
| <%=FP_FieldVal(fp_rs,"Number of Students")%></td>
| </tr>
| 
| </tbody>
| </table>
| <p><a href="3-1.asp">Back to Display Instructor Schedule</a></p>
|
| </body>
|
| </html>
|
| ==================================
| Output from FrontPage below
| ==================================
|
| 3.1.1 - Instructor Schedule Results
|
| Instructor: 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.
|
|
| Year: Database Results Error
| Unable to find operator in query string. Query string currently is select
| distinct cs600proj.dbo.TextAcademicYear(academicyear) as year from quarters
| where academicyear=cs600proj.dbo.CvtToAcademicYear('::academicyear::')
|
| Quarter: Database Results Error
| Unable to find operator in query string. Query string currently is select
| distinct cs600proj.dbo.TextQuarter(quarter) as theQuarter from quarters where
| quarter=cs600proj.dbo.CvtToQuarter('::quarter::')
|
|
| Time Period Classroom Course Number Description Number of Students
| Database Results Error
| Unable to find operator in query string. Query string currently is select
| cs600proj.dbo.texttimeperiod(timePeriod) 'Time Period', classroom
| 'Classroom', cs600proj.dbo.textCourseNumber(cs.prefix,cs.courseNumber)
| 'Course Number', c.coursedescription as 'Description', count(*) as 'Number of
| Students' from classroomschedule cs join instructors i on
| cs.instructorid=i.instructorid join studentschedule ss on
| cs.academicyear=ss.academicyear and cs.quarter=ss.quarter and
| cs.prefix=ss.prefix and cs.coursenumber=ss.coursenumber join catalog c on
| cs.prefix=c.prefix and cs.coursenumber=c.coursenumber where
| cs.academicyear=cs600proj.dbo.CvtToAcademicYear('::academicyear::') and
| cs.quarter=cs600proj.dbo.CvtToQuarter('::quarter::') and
| i.instructorname='::instructorname::' group by timePeriod, classroom,
| cs.Prefix, cs.CourseNumber, c.coursedescription order by timePeriod,
| classroom
|
| Back to Display Instructor Schedule
|

Michael · Aug 27, 2005

Thanks for your suggestion but I did that before I submitted the case. I
started a blank page, added a drop-down list query, which works, and then
tried to link a simple DRW, which resulted in the Database Results Error.

I have a table with two fields, an ID and a name. In the drop-down list
query I showed all the ID's. Then, in the DRW, the query returned the name
matching the ID in the drop-down list query. If I specify a literal number
for the ID in the DRW, I get a value in the results form. If I specify where
ID=::ID:: in the DRW query, I get the error messages. I don't have the test
page to submit any longer because I have overwritten it with several other
tests.

In any event, unless I am missing something, your answer does not account
for why all of the pages would suddenly have died at once.

Does anyone else have an idea? Thank you so much in advance!

- Michael

Michael · Aug 27, 2005

A quick update: I saw a suggestion in other posts to restore the _fpclass
folder only.

Fortunately, I had a backup of this, which I restored to the site,
overwriting the existing _fpclass. That resolved the issue with all of the
pages, which tells me that it really is a server thing and that something
triggered all of the pages to break at once.

I am up and running again, and with the new pages that triggered all the
failures running too, but I am concerned that it might happen again. I am
still working on this site and I know that I will need to integrate at least
one more SP by incorporating ASP code directly into the page. That's the
common thread that has "broken" the DRW regions in both instances - it came
following adding/modifying the HTML and ASP code itself.

Again, does anyone have an idea what is getting corrupted in _fpclass, and
why, and whether it is a known issue at MS, and whether there is a hotfix for
it or something?

Thanks so much!

- Michael Gibbons

p c · Aug 27, 2005

Long term solution: dump FP when it comes to dadabase Access and write
your own code in ASP. You will need to learn:

* ASP/VCBscript coding
* how to connect to the databases, retrieve, add, update and delete records
* stnadrd SQL sysntax for working with datbases.

There are plenty of tutorials on the web. You just need to learn som
basics and then waht you need. You can coniune using FP for web page
editing.

....PC

I am trying to understand this code...	3	Jul 26, 2008
Help with this calculation!!!	17	Oct 19, 2006
Question to Data Base Results Wizard Ouput	1	Jul 21, 2005
DRW manual code	4	Jul 13, 2005
Please help, FP generated code produces a "Too few parameters. Expected1" error!	7	Jun 6, 2005
any ideas why I can update one table in my database but not the other?	2	Sep 22, 2006
Numeric Formatting	0	Nov 15, 2006
editing database with frontpage	1	Feb 23, 2008

SQL DB problems - desparate

Michael

Stefan B Rusynko

Michael

Michael

p c

Ask a Question

Similar Threads