What you might want to do is create a "order by" variable so that your customers can select in what order they want the records to be displayed.
eg:
strSQL = "Select * from Table where * = * Order By" & Request.Querystring("sort") - "sort" being the name...
Actually, what I've got the information on hours worked stored in the database, it's just that for each 1 record in the Employees table, I may have at least 10 time records in the Clock table, and I want to display the the employee name from the Employees table 1 time, then each record with the...
I'll give it a shot.
There are multiple in-out times.
In - Out Lunch - In Lunch - Out
I'll mess around with the code and see if I can get it to work. Thanks for the response.
I am working on a time clock application, and I've got most of it completed. The problem I'm having is the way I want to display information.
I have two tables. Employees and Clock.
There are similar fields (eg. Employees.EmplCode = Clock.EmployeeCode), so I have been able to select both...
I'm trying to connect a VERY small network with 10/100 switches. I've been having a few problems. I have a sonicwall plugged into our dsl line. The LAN port on the sonicwall is plugged into a Linksys switch. Computers plugged into the same switch can access the internet. There's another...
i need to submit a form that is located in the top frame with a page in the bottom frame using the document object.
what i am doing is trying to update a database record and have the updated results displayed in the search without the user clicking the search button again. Please Help.
I need to make a few stored procedures that will allow access to a few sql stored procedures (such as sp_password and sp_addlogin) without granting premissions. If anyone could help i would greatly appreciate it.
bjgrem
The database is SQL, and i need to create a view with a certain number of records displayed per page (say, first 20 on this page, next 20 on next page... etc.) <br><br>thanks.
I am working on a records database and i need to know how to make a search where the user selects a number of results to display from a drop-down list.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.