?
Solved

records are ordered by "drop down box" and text box for query

Posted on 2015-01-12
6
Medium Priority
?
26 Views
Last Modified: 2016-07-07
moved pages from frontpage to asp
add, edit, delete all done and working, displaying all records in web page no problem
===
I would like to add a drop down box and it would select the order ie last name, file number or town
also a text box which if something was imputed it would only list that record(s). if the text box was empty, all records would be displayed.
0
Comment
Question by:dataspeak
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
6 Comments
 
LVL 44

Accepted Solution

by:
Rainer Jeschor earned 1000 total points
ID: 40546354
Hi,
there is a really nice Javascript library called DataTables.net
(http://www.datatables.net/)
Their site has a lot of samples and I guess this plugin should do the trick (it depends a little bit on your generated HTML code).
HTH
Rainer
0
 

Author Comment

by:dataspeak
ID: 40546440
I'm using access with 8000 records
the java script "nice" but reads all records into the html page then sorts and displays.
I don't think this will work
i need record pointers.
i will attach a file with part code
information.txt
0
 
LVL 51

Assisted Solution

by:Steve Bink
Steve Bink earned 1000 total points
ID: 40546820
The datatables library is a jQuery plugin, and I've been using it for an internal analytics engine.  It will suit this project well enough if you take the time to learn what you can do with it.

For example, it can provide automatic or scripted filtering and sorting.  It can also be told to fetch data via AJAX instead of populating it with a static table/list/whatever.  It has options for client- *OR* server-side record processing.  

This library will 100% work for you, but there is some learning curve you'll have to go through.
0
 
LVL 51

Expert Comment

by:Steve Bink
ID: 41697111
#40546354 and #40546820
0

Featured Post

Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Use Wufoo, an online form creation tool, to make powerful forms. Learn how to choose which pages of your form are visible to your users based on their inputs. The page rules feature provides you with an opportunity to create if:then statements for y…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question