I have a database that contains a release list for some products. It's constructed like this:
ID (autonumber)
ProductID (relatednumber)
Date - the date for release
Approx - (number related to text en other table = ApproxRelation)
ApproxYear - (number)
The Approx is a number related to antoher table containing the corresponding text - like "1st quarter", "January", "March" and so on.
I want to sort the release of the products by date, but then mix the sorting with the approximated dates. Like: Code:
I created a script which suppose to sort on 2 fields. Everything works fine with no errors except when I click on the field that suppose to sort the data it does nothing.
This is the code: Created on test table name Reports2 3 fields id, r_date, r_doc_title
I have to sort a table that get is recordset from another query, all this workes fine, the problem is that I have to then sort the table on three different fields based on what the user select in the combo box. Code:
I am trying to create a page where someone can search an Association directoy by category. The results page should then pull up all the companies that fall under that category and sort the company names alphabetically. The search & results pages are loading, but show no results under all categories. Code:
I have the following code which connects to an access database table and prints out each record. For some reason, the ASC is not sorting the records for me. Can anyone see the problem? Code:
What i'm trying to do is, get this report to return data where there is a null result or a non equal result. Meaning in my code that I join SQL1.Col001 = producer.Producer#. I want to return only the results where those two don't match up with anything. Kinda confusing. Let me know if you need anymore clarity. Code:
I'm building a site search function that returns database records matching user-entered keywords.
Once the recordset has returned results, I have a function that counts the number of keyword occurances in the searched field to determine the relevancy of each record.
This all works fine, but now I need to order the recordset by the calculated relevancy of each record (highest to lowest number of keyword matches).
A previous thread gave me an idea of how to do this but no coding examples. The suggested solution was to;copy the recordset into new disconnected recordset, (rsNew for example)iterate through rsNew and add the RelevanceSort rsNew according to the Relevance columndisplay the data inside rsNew rather than objRSIt's the first two points I am unsure of. How do I copy the recordset to a new disconnected one, and how do I iterate through it adding the relevance values?
I am trying to sort data from the same table by fileName and docNumber. For example, I have two drop down boxes (per section) 1 with fileName the other with docNumber and want each to be displayed in alphabetical and numerical respectively.
So what I’m trying to ask is should I use separate recordsets for each and use an “order by” statement or is there a better away. I have 8 drop down boxes per page so this could potentially mean 8 recordsets?
I want to add these 2 TIMES.I retreive this information from a form.Any kind of information about adding these 2 date fields will be too helpful.I'm storing this in an Access DataBase.
Is there a quick way so when I execute Code: if not rs.eof then for each tf in rs.fields Response.write(tf.Name) next end if I can somehow have it sort the values in alphabetical order, and then when my response.write executes, every iteration will go from a-z
I have three tables in my db, joined together. The connection works fine, but I want to stop the first two tables from listing their info. for each call to the third table.
ex: table 1 - page title, description table 2- section title, description table 3 - links, and their info.
For each page, there are mulitple sections and links, so I don't want the section title to appear each time I display a new link.
I have successfully paged through a recordset on my page using the .recordCount, etc. methods, the only thing is I have 2 independent recordsets looping on the page, which when there was not paging involved this worked fine, however now I need to span the results of BOTH of these across pages, I just cannot seem to figure out how!
I have one set of records paging fine, but the other either messes the page up, or shows on the first page of results and no more of the other recordset, etc.... so yeah that is basically the problem I am hitting, so I was just wondering is there any examples or ways you could tell me to do this??
I'm trying to only show 10 records at a time. I have the first 10 records showing. The problem is that when I click the Next button I get an error message: ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. Also different people are going to search for different things so there will always be a different amount of records returned each time. I can't figure this out. My code is:
I've had an ASP project dumped on me written in VBScript. I'm actually a C#/ASP.NET developer and am struggling trying to find a way to sort the result of a XPath query executed using SelectNodes?
I'd rather not rely on external XSL files if possible.
I have this database that contains four columns (ID, Name, Qty1, Qty2). I can display the data on an ASP just fine but what I want is to display the data in Ascending order of the total number between Qty1 and Qty2 of each record (Qty1 + Qty2 = QtyTotal). Obviously the total number is not stored somewhere in the database. So how can I accomplish this?
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD) Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. ../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page: GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I would like to display the difference between the logging time [Session("start"] and the current time [now]. In hours minutes and seconds, I have tried a couple of things but all I see is gobbledy gook.
I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.
I need to need to reload that sign in url every few hours Code:
there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time. for example, if computer date/time is two months or 2 weeks before the database date/time do something
I try to find a script in ASP that combines sorting and paging. I already found various scripts that do one or the other but none does it both. I know I should combine them, but it is very difficult at my level of asp knowledge.
I have a set of records which are sorted AtoZ in display. Problem comes is like:
A.1 A.10 A.2 A.20 A.3 A.4 A.5 A.6 A.7 A.8 A.9
Actually A.10 is required after A.9 and A.20 after A.19.
I have searched for this, but found that on every page it sorts records like this. Also, I can not sort items based on ID (auto increment) because certain items are added at later time and some first.
I'm programming as ASP site to show the results of dynamically querying a MS Access database and outputting the results in a table. I've got that part to work. But, what I can't get to work is for the header row of the table to be links to sort the data ascending or descending by that particular field. All I can get to work is having a little +/- next to the column header and those sort it, but I can't figure out how to get the headers themselves to do both sorts when clicked.....can anyone out there help??? Thank you in advance!!! Also, if anyone knows about Access 2000, I've never tried doing this in it before, but I need to export one of the field to be links to HTML pages that describe those seminars, has anyone done that? Just figured I'd ask while I'm typing this
I have never sorted a recordset - using rs.Sort - i have no problem sorting it in SQL. All the tutorials i get say that i have to use a client cursor location, so this is my code:
I have a table that is just dumping an entire database data. I would like to have the values of the columns re-sort the data. Not the column heads for the data displayed under the column head varies.
For example, one column, Components, displays 80 components types and another column, Category, displays 40 categories types. When a visitor clicks on one of the component values, it should then display only that data. I've done this before but, it has been a very long time. I remember creating a link surrounding the recordset in my table but what was written.
I'm trying to display number of records query and the results I'm getting are only for 10 and not the total number of records queried. For example if I query field "CA" and I know California has 12 records it still only gives me 10 records. Attached is the script.
I am trying to create a query to list products alphabetically. I want to have the letters of the alphabet on the web page and when someone clicks on the letter A for example, I want to list all the products beginning with the letter A. For B, all the products beginning with the letter B, and so on.
In my query, I know I need something like WHERE (((Product) Like "A*")), but how do I structure the query so I'm not listing Like "A*" for each of the 26 letters of the alphabet.
On my webpage I am having people search for house listings. www.fsbowesternwisconsin.com/buy.asp). They get done searching and they get the results. After the search has been done I want a drop down menu where they can then sort the results (bedrooms, bathrooms, location, etc etc). Its like how eBay works.
