Database Search (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

Kinux -> Database Search (6/10/2004 11:32:08)

Ok I'm still rather new to using both FP2003 and SQL but here's the problem I'm having. I have a database that I'm trying have queried by a search page I've made in FP2003. I already have a submissions page actively posting to this database perfectly. I setup a search.asp with a text box labeled "search" and had it post its data to Results.asp. I inputted a custom string in an attempt to get it to query across multiple fields in the table.

Here's the string I'm using:

SELECT * FROM "General Work" WHERE (WorkorderID LIKE '%::search::%' OR Location LIKE '%::search::%' OR TeacherName LIKE '%::search::%' OR Status LIKE '%::search::%') ORDER BY WorkorderID ASC

I can input text and it seems to query the database but it just doesn't post the results. I get the following error

"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."

Does anyone know what I am doing wrong or have any suggestions for me?
Let me know

Thanks



Kinux -> RE: Database Search (6/10/2004 13:36:59)

<% 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 * FROM ""GENERAL WORK"" WHERE Datesubmitted BETWEEN ::startdate:: and ::enddate:: ORDER BY Datesubmitted"
fp_sDefault="startdate=&enddate="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="workorders"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="WorkorderID"
fp_sMenuValue="WorkorderID"
fp_sColTypes="&WorkorderID=3&DateSubmitted=135&DateCompleted=135&SubmittedBy=201&SubmitterEmail=201&TeacherName=201&TeacherRoom=201&TeacherExtension=131&ProblemDescription=201&Comments=201&Location=201&Responder=201&status=201&priority=201&classification=201&UserEmail=201&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


Here's the code btw



Kinux -> RE: Database Search (6/10/2004 13:38:49)

Actually overlook that...that was from a different page :P



BeTheBall -> RE: Database Search (6/10/2004 13:42:04)

That error message is unfamiliar to me. However, if the field in the db is truly a date field, then this:

BETWEEN ::startdate:: and ::enddate::

Should be:

BETWEEN #::startdate::# and #::enddate::#

And, I would change:

FROM ""GENERAL WORK""

to

FROM [GENERAL WORK]

(Spaces in field names and table names should be avoided)



Kinux -> RE: Database Search (6/10/2004 13:47:02)

<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 * FROM ""General Work"" WHERE (Location LIKE '%::search::%' OR TeacherName LIKE '%::search::%' OR Status LIKE '%::search::%' OR WorkorderID LIKE '%::search::%') ORDER BY WorkorderID ASC "
fp_sDefault="search=&search=&search=&search="
fp_sNoRecords="<tr><td colspan=16 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="workorders"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="WorkorderID"
fp_sMenuValue="WorkorderID"
fp_sColTypes="&WorkorderID=3&DateSubmitted=135&DateCompleted=135&SubmittedBy=201&SubmitterEmail=201&TeacherName=201&TeacherRoom=201&TeacherExtension=131&ProblemDescription=201&Comments=201&Location=201&Responder=201&status=201&priority=201&classification=201&UserEmail=201&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

here's what I really was lookin to post



BeTheBall -> RE: Database Search (6/10/2004 14:09:55)

In your database, is WorkOrderID a text field or a numeric field?



Kinux -> RE: Database Search (6/10/2004 14:28:41)

Numeric. WorkorderID is a integer. The field is set as the primary key and seeds and 1 and counts up by 1



BeTheBall -> RE: Database Search (6/10/2004 16:26:24)

That may be part of your problem. You can't use "LIKE" with a numeric field and you don't surround a form field that is querying a numeric db field with single quotes. Try changing your SQL to this:

fp_sQry="SELECT * FROM ""General Work"" WHERE (Location LIKE '%::search::%' OR TeacherName LIKE '%::search::%' OR Status LIKE '%::search::%' OR WorkorderID = ::search::) ORDER BY WorkorderID ASC "



Kinux -> RE: Database Search (6/10/2004 17:05:58)

Ok I made a few changes.
- Changed SQL table name from "General Work" to "General" to avoid future
headaches
- Made suggested changes in the query string

- Fix up other pages so succesfully reposting data because of table name change

Inputted data into search field returned the following error:

Database Results Wizard Error
The operation failed.


<% end if %>
<%
fp_sQry="SELECT * FROM General WHERE (Location LIKE '%::search::%' OR TeacherName LIKE '%::search::%' OR Status LIKE '%::search::%' OR WorkorderID = ::search::) ORDER BY WorkorderID ASC "
fp_sDefault="search=&search=&search=&search="
fp_sNoRecords="<tr><td colspan=18 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="workorders"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="WorkorderID"
fp_sMenuValue="WorkorderID"
fp_sColTypes="&WorkorderID=3&DateSubmitted=135&DateCompleted=135&SubmittedBy=201&SubmitterEmail=201&TeacherName=201&TeacherRoom=201&TeacherExtension=131&ProblemDescription=201&Comments=201&Location=201&Responder=201&status=201&priority=201&classification=201&UserEmail=201&Timespent=201&cost=201&"
fp_iDisplayCols=18
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>

I appreciate you taking the time to help me out with this



BeTheBall -> RE: Database Search (6/10/2004 17:32:10)

Try this. Right-click within the database results region and select "Database Results Properties". This basically restarts the db results wizard. Proceed to step 3 and there click the "Default" button. Click "Edit" and for the value type in something like 999. Finish the wizard, save the page and test again.



Kinux -> RE: Database Search (6/10/2004 17:39:32)

Ok so I set the default value of search to "999" and it returned the same error.
I tried it again with a value that occured in the Database and got the same result.



BeTheBall -> RE: Database Search (6/10/2004 17:47:28)

"General" is a reserved word. Try changing your SQL to:

fp_sQry="SELECT * FROM [General] WHERE (Location LIKE '%::search::%' OR TeacherName LIKE '%::search::%' OR Status LIKE '%::search::%' OR WorkorderID = ::search::) ORDER BY WorkorderID ASC "



Kinux -> RE: Database Search (6/10/2004 17:57:40)

Ok made that change still no difference. I'm going to change table name to
different name.



BeTheBall -> RE: Database Search (6/10/2004 18:04:15)

To get a more descriptive error message, follow the instructions in the first post in this thread:

http://www.frontpagewebmaster.com/m-175524/tm.htm



Kinux -> RE: Database Search (6/10/2004 18:08:45)

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.



Kinux -> RE: Database Search (6/10/2004 18:17:53)

<html>

<head>
<meta name="ProgId" content="SharePoint.WebPartPage.Document">
<meta name="WebPartPageExpansion" content="full">
<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not Edit.
FP_LCID = 1033 %>
<meta http-equiv="Content-Language" content="en-us">
<% ' 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>New Page 1</title>
</head>

<body>

<form runat="server">

<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>WorkorderID</b></th>
<th ALIGN="LEFT"><b>DateSubmitted</b></th>
<th ALIGN="LEFT"><b>DateCompleted</b></th>
<th ALIGN="LEFT"><b>SubmittedBy</b></th>
<th ALIGN="LEFT"><b>SubmitterEmail</b></th>
<th ALIGN="LEFT"><b>TeacherName</b></th>
<th ALIGN="LEFT"><b>TeacherRoom</b></th>
<th ALIGN="LEFT"><b>TeacherExtension</b></th>
<th ALIGN="LEFT"><b>ProblemDescription</b></th>
<th ALIGN="LEFT"><b>Comments</b></th>
<th ALIGN="LEFT"><b>Location</b></th>
<th ALIGN="LEFT"><b>Responder</b></th>
<th ALIGN="LEFT"><b>status</b></th>
<th ALIGN="LEFT"><b>priority</b></th>
<th ALIGN="LEFT"><b>classification</b></th>
<th ALIGN="LEFT"><b>UserEmail</b></th>
<th ALIGN="LEFT"><b>Timespent</b></th>
<th ALIGN="LEFT"><b>cost</b></th>
</tr>
</thead>
<tbody>
<tr>
<td>
<table width="100%" border="1">
<thead>
<tr>
<th ALIGN="LEFT"><b>WorkorderID</b></th>
<th ALIGN="LEFT"><b>DateSubmitted</b></th>
<th ALIGN="LEFT"><b>DateCompleted</b></th>
<th ALIGN="LEFT"><b>SubmittedBy</b></th>
<th ALIGN="LEFT"><b>SubmitterEmail</b></th>
<th ALIGN="LEFT"><b>TeacherName</b></th>
<th ALIGN="LEFT"><b>TeacherRoom</b></th>
<th ALIGN="LEFT"><b>TeacherExtension</b></th>
<th ALIGN="LEFT"><b>ProblemDescription</b></th>
<th ALIGN="LEFT"><b>Comments</b></th>
<th ALIGN="LEFT"><b>Location</b></th>
<th ALIGN="LEFT"><b>Responder</b></th>
<th ALIGN="LEFT"><b>status</b></th>
<th ALIGN="LEFT"><b>priority</b></th>
<th ALIGN="LEFT"><b>classification</b></th>
<th ALIGN="LEFT"><b>UserEmail</b></th>
<th ALIGN="LEFT"><b>Timespent</b></th>
<th ALIGN="LEFT"><b>cost</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-columntypes="3,135,135,201,201,201,201,131,201,201,201,201,201,201,201,201,201,201" s-dataconnection="workorders" b-tableformat="TRUE" 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="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-criteria s-order s-sql="SELECT * FROM WORKORDERS WHERE (Location LIKE '%::search::%' OR TeacherName LIKE '%::search::%' OR Status LIKE '%::search::%' OR WorkorderID = ::search::) ORDER BY WorkorderID ASC " b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="search=&search=&search=&search=" s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="5" botid="0" u-dblib="../../../_fpclass/fpdblib.inc" u-dbrgn1="../../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region. The page must be fetched from a web server with a web browser to display correctly; the current web is stored on your local disk or network.</font></td></tr>" startspan --><!--#include file="../../../_fpclass/fpdblib.inc"-->
<% 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 * FROM WORKORDERS WHERE (Location LIKE '%::search::%' OR TeacherName LIKE '%::search::%' OR Status LIKE '%::search::%' OR WorkorderID = ::search::) ORDER BY WorkorderID ASC "
fp_sDefault="search=&search=&search=&search="
fp_sNoRecords="<tr><td colspan=18 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="workorders"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=5
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&WorkorderID=3&DateSubmitted=135&DateCompleted=135&SubmittedBy=201&SubmitterEmail=201&TeacherName=201&TeacherRoom=201&TeacherExtension=131&ProblemDescription=201&Comments=201&Location=201&Responder=201&status=201&priority=201&classification=201&UserEmail=201&Timespent=201&cost=201&"
fp_iDisplayCols=18
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="28100" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="WorkorderID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>WorkorderID<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"WorkorderID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="27661" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="DateSubmitted" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DateSubmitted<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"DateSubmitted")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="34917" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="DateCompleted" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>DateCompleted<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"DateCompleted")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33349" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="SubmittedBy" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>SubmittedBy<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"SubmittedBy")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="26670" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="SubmitterEmail" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>SubmitterEmail<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"SubmitterEmail")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="40056" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="TeacherName" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>TeacherName<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"TeacherName")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29065" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="TeacherRoom" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>TeacherRoom<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"TeacherRoom")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30353" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="TeacherExtension" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>TeacherExtension<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"TeacherExtension")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="44026" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="ProblemDescription" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ProblemDescription<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ProblemDescription")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="58307" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="Comments" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Comments<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Comments")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16369" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="Location" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Location<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Location")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16691" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="Responder" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Responder<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Responder")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="19823" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="status" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>status<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"status")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="19226" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="priority" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>priority<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"priority")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="19837" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="classification" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>classification<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"classification")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="42482" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="UserEmail" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>UserEmail<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"UserEmail")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="21317" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="Timespent" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Timespent<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Timespent")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="20899" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="WorkorderID,DateSubmitted,DateCompleted,SubmittedBy,SubmitterEmail,TeacherName,TeacherRoom,TeacherExtension,ProblemDescription,Comments,Location,Responder,status,priority,classification,UserEmail,Timespent,cost" s-column="cost" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>cost<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"cost")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="7072" --></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../../../_fpclass/fpdbrgn2.inc" i-groupsize="5" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| "> [1/5]</NOBR><BR></td></tr>" startspan --><!--#include file="../../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="9297" --></tbody>
</table>
<p> </td>
</tr>
</tbody>
</table>

</form>

</body>

</html>



BeTheBall -> RE: Database Search (6/10/2004 18:39:09)

If your server supports ASP.NET, try this advise from MS:

1. Open the ASP page in FrontPage 2003.
2. Right click your database results region and choose "Database Results Properties".
3. In the Database Results Wizard dialog box, follow these steps:
1. Click ASP.NET.
2. Click Use an existing database connection, and then click to select your database in the database connection box.
3. Click Next.
4. Select your correct Record source, and then click Next.
5. If fields are missing in the list of fields for your database, click Edit List to add missing Available fields to your Displayed fields, and then click OK.
6. Make any other changes to filter, to limit, or to sort the database results that you want.
7. Click Next two times, and then click Finish.
4. You must resave the page with an .aspx file extension.

Preview the .aspx page in your browser. Let us know if that works.



BeTheBall -> RE: Database Search (6/10/2004 18:46:50)

For my own curiosity, can you post the name of every single field in the WORKORDERS table?



Kinux -> RE: Database Search (6/11/2004 10:12:33)

Fields for table Workorder:

WorkorderID - Int
DateCompleted - Date
DateSubmitted - Date
SubmitterEmail - Text
TeacherName - Text
TeacherRoom - Text
TeacherExtension - Numeric
ProblemDescription - Text
Comments - Text
Location - Text
Responder - Text
Status - Text
Priority - Text
Classification - Text
UserEmail - Text
Timespent - Text
Cost - Text



BeTheBall -> RE: Database Search (6/11/2004 10:20:01)

What about "SubmittedBy" is that in the db or has it been removed? Is your site on an intranet or is it public?



BeTheBall -> RE: Database Search (6/11/2004 10:47:41)

Since you are having the same problem as here:

http://www.frontpagewebmaster.com/m-204562/tm.htm

My offer to look at your pages/db is also extended to you. Just PM or Email me for my email address if interested.



Kinux -> RE: Database Search (6/11/2004 10:57:00)

SubmittedBy is still there I just missed typing it in.
As for the page its on a live webserver but requires authentication.
So its intended for the use of those only inside our district.
I tried the ASP.NET solution yesterday with no success.



BeTheBall -> RE: Database Search (6/11/2004 19:42:50)

Go back to this post:

http://www.frontpagewebmaster.com/m-175524/tm.htm

A few posts from the beginning, there is an attachment. Download it. Open your _fpclass folder and paste in the downloaded files. When prompted as to whether you want to replace the existing files, click "Yes to All".

If your _fpclass folder isn't shown, click Tools - Web Settings - Advanced and mark the show documents in hidden directories checkbox.

That should resolve the problem. There appears to be a flaw in the include files that shipped with FP 2003. The flaw presents itself when trying to use a search form to filter database results.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.125