I'm working on a Fantasy Racing Site and it works nicely. However, the guys tell me they want to make changes. If I have one table listing all drivers and their points for each week and another table listing league participants and their drivers (drivers can be duplicated on other rosters).
If I have a particular driver and somebody else has the same driver. everything is fine. However, when I wish to change that driver after the 4th week how do I stop accumlating his points but continue to accumulate for the other person? Does this make any sense?
if there was any site with a public domain example of how league tables (such as football/soccer tables) could be maintained using ASP and Access databases.
I am displaying a list of data from a sql database. I have hyperlinked each field as i want the user to be able to click on this link, the page refreshes and all entries that are the same as the user clicked on are at the top of the list. I am using a query string as the link.
I'll get right to the point. I'm displaying an alphabetical listing of names from a recordset in the following manner: A abe alex ... B barb bob ... C craig etc...
Presently, I'm using a for..next statement to cycle through the alphabet, and displaying the matching names for each letter via a loop. Here is the code:
display just a listing of files in this manner.For example.If i select D: drive it should give me all files in root directory and sub folders and sub sub folders.
The operation is like a dos command dir /s/o/b
I am using this for sitmap for one of my client, who has more than 100 folders and 50 sub folder and 10 sub sub folders that he has more than 7000 html pages
I am tring to build a registration online form that participants will be able to choose from about 75 diferent courses divided into various sessions and choosing a course per session.The problem I have is that I cant figure out the best way to do this: 1. either to make them static pages and then submit the values the participant chooses into a database and use the values for billing etc. Like this i will be able to validate / control what the users chooses e.g they dont choose overlapping courses. 2 my second option is to list them in a database and then list them on my page , which is easier but how do I validate what the participant chooses and how do I move the values to the next page and making sure the right course goes to the right session.
Is it possible to list directories of different computers in a network?
For instance, I have the script on "server 1", "server 2" is another computer in its network places under the same domain. I want to have a asp or asp.net script list the contents of "server 2" from "server 1".
Is this possible? all the asp scripts Ive seen so far can only list files from the computer/server its on.
I've managed to get file listings, do textstreams, move around in the file system a bit, just wondering how I get folder listings as I would file listings... Here's what I've tried, but it's not quite working:
Set objFile=objFSO.GetFile(strPhysicalPath) Set objFolder=objFile.ParentFolder Set objFolderFolders=objFolder.Folders
For Each objFolderItem in objFolderFolders mess=mess & "<tr><td><a href=""" & objFileItem.Name & """>" & objFolderItem.Name & "</td><td></td><td></td><td></td><td></td></tr>" Next [/vbs]
I have been searching google and other search engines and have not come up with anything for this question of mine. Maybe I'm not typing in the right stuff. I am writing a couple of scripts that require me to display a list of information from a database from one catagory. I have never needed to do this before and am trying to find out how I should go about doing it
Assume I enter number 1 in "from" and 10 in "to" - I want the ASP to return: 1,2,3,4,5,6,7,8,9,10 and insert this into an Access database over 10 rows into the 'number' field.
At work I was asked to add a link to a directory listing page. This page is with the link is located behind a secure page requiring a username and password. When I added the link I also went to iis and checked to make this directory have directory browsing listing checked.
Everything is fine however now this directory is open if you just post the complete link to it in the URL bypassing the login page. Is this a nornal behavoir and is their anything that can be done to make it prevent it to be opened?
as i enter text in the textbox i want to narrow down there result in the box below that has all the listing of the products. i.e as i enter 'a' in textbox it will filter all products starting with 'a' then if i enter 'b' as second character it will show onlythose products that are starting with 'ab'... so how could i do that.
anyone know of a good ASP Application that will allow me to do featured listings/ or sponsored listings on a page? These need to be text based links - like google style probably.
What the above code is supposed to do, obviously, is write a person's e-mail address out, and at the same time include that address in a hyperlink so that someone could e-mail that person. The problem is that it doesn't show up. There is no error code or anything- the output just does not show up.
I would like to list all files and folders on a password protected directory (basick auth). I know how to list all files and folders in a normal directory but i don't know how to do so for a password protected one, due to the fact that i couldn't find any article/book that explains how to do so and also the fact that to the best of my knowledge there is no way to pass a username and a password to the File object in order to authenticate to the webserver as an other user, all i could think of was to pass the user/pass to this directory in the header (with response.AddHeader ) but that doesn't seem to work (even though i am not sure i used the correct syntax for the header).
I have an access db with 5 fields, ID, Category, BusinessName, Address and Phone. I want to list the records like so but can't think how my loop and check to see if the category has been changed should look. Can anyone help?
I have an Access Database with only one table (tblBooks) with 5 fields: id, TestNumber, Book, Author, ReadingLevel, PointValue. I would like to have alphabetical listing of the records displayed by hyperlinks on the top of the page like:
<Previous All | A | B | C | ....| Y | Z | Others Next>
Also would like to have only 25 records per page and bottom page numbering. I know this is a newbie question but I haven't being able to figure it out.
I have a Table (Table-name:Problem_List) and Column (Column-name:Title). There are many records in this table with the same (or similar) titles. What i'm trying to achieve, is a list of this column, but instead of 2000 rows, I need the similar names counted list like this...
Blocker : (100) Serious : (34) Warning : (430) etc.
I remember some code in VBScript that would list the contents of a directory.The difference was that it was nicely set out,each filetype ahd their associated document and if the folder contained another folder,cliking on the folder icon would take you to that page fodler where it would list the contents of that folder.can someone please point me to a nice pre-written script.
I am creating something for our intranet and i want to list the files and folders of a directory, i found some code to do this.The only problem is that it lists the asp file used to for example if i go to:"http://myserver/listing.asp" In the file listing will be "listing.asp" amongst a lot of marketing documents.Is there a way to block/stop this one file from being listed?
I plan to learn at some point). I just need a script so I can get a project I'm working on done. That being said, I need to take the listing of a directoy on the web site (a folder called drawing in the web pages directory) and dump it into a combo box for the user to select from.
When the user selects an item, it need to set a session variable that contains the filename so i can access it later on in a javascript. I think that its pretty simple, but as I said, I'm clueless about it.
I did not write this page but I would like to do something similar but have 2 coloumns on the same page where one column would list the files in one sub folder (e.g. articles) and the other column would list the files from another sub folder 9e.g. Newsletters)
if i wanna list data from 2 tables at the same time, is that possible. i have 2 tables: itemsorderd and orders, which both have OrderID.
now i want to list the 2 fields from itemsorder which are Quantity and ProductID, as well as all the fields from orders, which contains the shipping details. how can i do that in a single SQL statement ? also if i wanna delete all these datas associated with the OrderID, how can i do that ?
