|
| |
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
 |
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
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 41
Joined: 6/10/2004
Status: offline
|
RE: Database Search - 6/10/2004 13:38:49
Actually overlook that...that was from a different page :P
| |
|
|
|
BeTheBall
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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)
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
RE: Database Search - 6/10/2004 14:09:55
In your database, is WorkOrderID a text field or a numeric field?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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 "
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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 "
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 41
Joined: 6/10/2004
Status: offline
|
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"><<</font>WorkorderID<font size="-1">>></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"><<</font>DateSubmitted<font size="-1">>></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"><<</font>DateCompleted<font size="-1">>></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"><<</font>SubmittedBy<font size="-1">>></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"><<</font>SubmitterEmail<font size="-1">>></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"><<</font>TeacherName<font size="-1">>></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"><<</font>TeacherRoom<font size="-1">>></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"><<</font>TeacherExtension<font size="-1">>></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"><<</font>ProblemDescription<font size="-1">>></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"><<</font>Comments<font size="-1">>></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"><<</font>Location<font size="-1">>></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"><<</font>Responder<font size="-1">>></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"><<</font>status<font size="-1">>></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"><<</font>priority<font size="-1">>></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"><<</font>classification<font size="-1">>></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"><<</font>UserEmail<font size="-1">>></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"><<</font>Timespent<font size="-1">>></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"><<</font>cost<font size="-1">>></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
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
BeTheBall
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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?
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
BeTheBall
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
|
|
Kinux
Posts: 41
Joined: 6/10/2004
Status: offline
|
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
Posts: 6355
Joined: 6/21/2002
From: West Point Utah USA
Status: offline
|
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.
_____________________________
Duane
Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
