RE: sorting columns... I know, I know... (Full Version)

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



Message

BeTheBall -> RE: sorting columns... I know, I know... (1/25/2007 20:31:09)

Take out the single quotes that surround "& Request("SortColumn") &".

fp_sQry="SELECT * FROM viewclasses ORDER BY "& Request("SortColumn") &" ASC"



BeTheBall -> RE: sorting columns... I know, I know... (1/25/2007 20:41:18)

Terrible answers from me today. This should be the correct line:

fp_sQry="SELECT * FROM viewclasses ORDER BY "& SortColumn &" ASC"

It's worth noting that rdouglas gave the correct answer in his initial post. Moreover, your code would have worked from the beginning were it not for the inherent FP problem covered in the post I referred to above (http://www.frontpagewebmaster.com/m-175524/tm.htm)



aipnit -> RE: sorting columns... I know, I know... (1/26/2007 12:23:23)

Well then, thanks to all those with the dedication and patience for assisting me because....

It is working perfectly now. Even the dates are sorting the correct way!

Love this forum!

THANKS!
AP



aipnit -> RE: sorting columns... I know, I know... (1/26/2007 13:01:35)

I am so sorry... but unfortunately I do have one more question ... is there a way to have search options on the same page as the results page?

I tried to input some search options and received an error:

Database Results Wizard Error
Description: Syntax error in ORDER BY clause.
Number: -2147217900 (0x80040E14)
Source: Microsoft JET Database Engine



aipnit -> RE: sorting columns... I know, I know... (1/29/2007 14:15:22)

Duane,

Regarding the sorting columns as discussed, I have added search criteria and now it doesn't work.

I have been looking at the following threads and trying to implement them into my situation, but I haven't come up with a solution.
http://www.frontpagewebmaster.com/m-251079/key-sort%252Ccolumns/tm.htm#251147
http://www.frontpagewebmaster.com/m-183746/key-sort%252Ccolumns/tm.htm#183746

However, because my search criteria doesn't match my result columns, I can't get it to work. I assume that is why. For example, my search is: CARESApplicable, Category, and/or Keyword and my results are: CourseTrainingName, StartDate, ClassDayEve, Location1, CARESApplicable.

Here is my code that I have adjusted from reading the above threads: 

<a href="default.asp?SortColumn=CourseTrainingName&CourseTrainingName=<%=Session("CourseTrainingName")%>">
<font color="#0000FF">CourseTrainingName</font></a>
   <a href="default.asp?SortColumn=StartDate&StartDate=<%=Session("StartDate")%>">
   <font color="#0000FF">StartDate</font></a>
<a href="default.asp?SortColumn=ClassDayEve&ClassDayEve=<%=Session("ClassDayEve")%>">
<font color="#0000FF">ClassDayEve</font></a>
   <a href="default.asp?SortColumn=Location1&Location1=<%=Session("Location1")%>">
   <font color="#0000FF">Location1</font></a>
<a href="default.asp?SortColumn=CARESApplicable&CARESApplicable=<%=Session("CARESApplicable")%>">
<font color="0000FF">CARESApplicable</font></a>

<% end if%>
<% 
If Request.Form("CourseTrainingName") <>"" Then 
Session("CourseTrainingName") = Request.Form("CourseTrainingName") 
Else 
Session("CourseTrainingName") = "%" 
End If 
CourseTrainingName= Session("CourseTrainingName") 
%>
<%
fp_sQry="SELECT * FROM viewclasses WHERE (CARESApplicable LIKE '%::CARESApplicable::%' AND Category LIKE '%::Category::%' AND Keyword LIKE '%::Keyword::%') ORDER BY ::SortColumn:: ASC"   
fp_sDefault="SortColumn=CourseTrainingName"
fp_sNoRecords="<tr><td colspan=5 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="CARES_DB"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&CourseTrainingName=202&StartDate=135&ClassDayEve=202&Location1=202&CARESApplicable=202&"
fp_iDisplayCols=5
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>


The error that comes up is below - I have checked out the MS knowledge base article, but it doesn't seem to apply.

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.

One or more form fields were empty. You should provide default values for all form fields that are used in the query.

Thank you again!
AP



BeTheBall -> RE: sorting columns... I know, I know... (1/29/2007 17:55:09)

I recommend you replace the files in the _fpclass folder with the ones Spooky provided in the 4th post of this thread:

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

There is an error in the files that were included in post 2000 versions of FP and that error is what is causing the bulk of your problems.



aipnit -> RE: sorting columns... I know, I know... (1/30/2007 15:54:16)

Duane,

That solved the problem perfectly! That is so weird that MS hasn't had a fix for that other than copying over their own files with older ones... hmm.

Thank you so much.

I honestly hate bothering you more, I know that you are so busy. But I have another problem regarding this issue (that is why I didn't start another thread):

If you go to www.childnet.org/amy you will see how the page pulls up classes/trainings from a database.

However, if you choose something from the drop down or type in a keyword to filter your class choices - the filtered list will come up, but when you click on the column to sort it, it doesn't sort through the filtered classes, it pulls all of them from the database again and sorts those.

Does that make sense?

Here is the code I have right now:


<a href="default.asp?SortColumn=CourseTrainingName">
<font color="#0000FF">CourseTrainingName</font></a></b></th>
<th ALIGN="LEFT"><b>
<a href="default.asp?SortColumn=StartDate">
<font color="#0000FF">StartDate</font></a></b></th>
<th ALIGN="LEFT"><b>
<a href="default.asp?SortColumn=ClassDayEve">
<font color="#0000FF">ClassDayEve</font></a></b></th>
<th ALIGN="LEFT"><b>
<a href="default.asp?SortColumn=Location1&">
<font color="#0000FF">Location1</font></a></b></th>
<th ALIGN="LEFT"><b>
<a href="default.asp?SortColumn=CARESApplicable">
<font color="0000FF">CARESApplicable</font></a></b></th>

fp_sQry="SELECT * FROM viewclasses WHERE (CARESApplicable LIKE '%::CARESApplicable::%' AND Category LIKE '%::Category::%' AND Keyword LIKE '%::Keyword::%') ORDER BY ::SortColumn:: ASC"
fp_sDefault="SortColumn=CourseTrainingName"




BeTheBall -> RE: sorting columns... I know, I know... (1/30/2007 16:41:44)

That is because the links do not include all the parameters that are needed for the SQL statement to properly filter the results. You would need to modify the link as follows:

default.asp?SortColumn=CourseTrainingName&CARESApplicable=<%=Request("CARESApplicable")%>&Category=<%=Request("Category")%>&Keyword=<%=Request("Keyword")%>

You would need to do the same for each column heading. The code is identical for each column except for the value that follows SortColumn=

Make sense?



aipnit -> RE: sorting columns... I know, I know... (1/31/2007 12:32:03)

Duane:
Yup - it is true... you are awesome!!

I adjusted a couple of typos to make my final links (corresponding differently to each SortColumn=) to:

default.asp?SortColumn=CourseTrainingName&CARESApplicable=<%=Request("CARESApplicable")%>&Category=<%=Request("Category")%>&Keyword=<%=Request("Keyword")%>">

Again... thank you so much! What a great way to end a thread!!

AP



BeTheBall -> RE: sorting columns... I know, I know... (1/31/2007 16:01:33)

Glad you were able to sort through my absent minded typing. [&:]



Page: <<   < prev  1 [2]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.078125