Say I have a DB with 10,000 records and using MySQL paging. I want to put a link setup at the top of the page with the alphabet that will pop to the proper page for each of the letters.
So: 1 A B C D...
Click on 1, goes to page 1, click on A goes to page 7, click on B goes to page 10.. so on so forth. how to find the pages either through an SQL subquery or through ASP. I can write code to make it happen, but I'm looking for a solution that will not hamper performance as much as an array dump and search.
I want to create a page that uses a horizontal alphabetical index such as
a b c .....
so when the user clicks on a letter they go to that section listing the manufacturer names beginning with that letter.
My question is that since I am pulling the names from a database, what is the best way to create the sections for each letter? My first thought is a basic and overkill solution creating a record set for each letter. Would I use arrays?
I know I could just create a separate page for each letter to display the corresponding entries. Would rather have one page at this time.
We need to create a user control (COM) in which it should be able to retrieve binary data from a given website after a user selects an item ID and clicks Retrive button.
We then can put this user control in a html page (generated by .asp page) so that internet users can use our data stored in our web server.
you have a DB that contains about 2000 records. Assume that the records are houses with addresses, already known to the user, [remember, there are rooms, bathrooms fireplaces, garages etc]. What I want is this: A user enters a known address in the form. The form seaches the DB and returns the address with full details. That is, search results will be like, Address 1234, number of rooms 3, bathrooms 3 etc. If the address the user seached for is not found, the user is redirected to a page that prompts them to add it to the DB. Also I would like for it [search results] to open in a mini window with an option for the user to close window after reviewing the records. I have thought of using a drop-down but discarded that, 'cos what happens if the DB records gets to be in the thousands?
I will have a web site where hotels can list themselves on it.One thing I am encountering that is a challenge, is that every hotel has different types of rooms. Also, every hotel has the normal high and low seasons, and some even have more seasons such as shoulder, weekend, etc. which affect room rates. So here is how I concieve the design: First, allow hotels to specify how many seasons they have, perhaps with a drop-down box of values such as 1,2,3...6,7 etc. They would then be presented with a series of text boxes, and asked to define the season, such as "High" "Low", etc. Adjacent to every season would be a beginning and ending date for that season. Next, they would be asked how many types of rooms they have, such as a drop down with 1,2,3,....5,6,7. Once decided,a form would present itself with form fields for the each room, such as description, ameneities, and most importanty, rates PER season. The seasons would be defined from previous step and would be unique for each hotel. Once complete, this would give a web site where I could list hotels and each would have its seasons, rooms and rates listed uniquely.Is this a good concept?
I have a table which stores details of businesses. These businesses have associated links to 2 tables called areas and categories. What I would like to be able to do is display a list of all the businesses in a particular area with a breakdown of all the different categories in that area together with a corresponding count of records.
i.e. pull out all the businesses for a given area and order by business category then for each category, display a count of the records in that particular category in that area.
What would be the best approach to sending a mass email out without clogging the server or running the risk that emails maybe lost (possibly due to a timeout).
Currently, I've been given the task with sending out a monthly newsletter to our customers (upon request of course). It is an easy task from what I can tell, simply bcc all the emails, set HTMLBody and TextBody and send it off. But, I will be sending this to 5000 clients and dont want any dropped emails.
Plus, is there a way to determine failed email address (due to bad domain names, bad email address, etc) and report it to the web application?
I'm working on a list of members.In my db I have two columns lastName and marriedName lastName is the member name before they got married and legLastName is their lastname after they got married.
Now I need to display theese two columns in alphabetical order in one list. If I for example have theese members: lastName, marriedName Anderson, Johnson Petersson, Svensson Nilsson, Persson Lindgren, Johnson
I want this result: Anderson Johnson (look for Andersson) Johnson(look for Lindgren) Nilsson Persson(look for Nilsson) Petersson Svensson(look for Petersson)
I have an online store with about 35,000 products in my database and no matter if you are listing all products in a catagory or viewing search results - all products are displayed in alphabetical order.
My problem is that some of my products start with the word "The" or "A" as the title - so they appear in alphabetical order under the letter "T" or "A". How do I get these items to appear in alphabetical order under the second word but still retain "The" or "A" as the first word of the title?
In other words - having "The World" appear alphabetically under "W" and "A Car" appear under "C" but keeping "The" and "A" as the first words.
Any help would be greatly appreciated. I know a fair bit about ASP/mySQL programming but just can't quite figure this one out.
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.
Im new to ASP, and have hit a snag.I am trying to build a page that has 'A-B-C-D...' links along the top of the page. When you click 'A', it goes to a table with everyones usernames and grabs the ones that start with the letter A. The problem is that the username field contains the names of people who wrote an article, so in some cases there are actually two names in this field. So for example, if it contained 'Bob, Jack', I would need 'Bob' to show up under B, and 'Jack' under J. Im totally stuck as to how I might do this. Changing the layout of my tables is no trouble if a different table setup helps
I am creating a spot where people can redownload items if they have access. I have everything written but the part where people actually get to the page due to a huge issue. So far there are 96 uniquie combinations of the 8 items they can download.
Here is the flow of my system.
Person creates a login, and in that login there is a spot to put in a specific code for the items they need to have access to. After that they are sent an email regarding login location and login info.
The login site has all of the verfication to login, but i am stuck at how to get the users to the actual page to download due to the 94+ combos of items, (and that number is only going to grow). Am i just screwed and this is impossible without taking a HEAVY hit to the server or do i need to find a program that does this?
How do you create the links similar to the links on the forum Viewing: ASP Free Forums > Programming > ASP Development > Post New Thread .If there is examples on the net please let me know.
I'm trying to make my URLs in ASP more search friendly, is there a way to do that? I'm using ASP.NET. Right now, I have an XSL file which is calling XML in my ASP files that builds the links. All content is generated from an XML file, so there is no database Here's a link example: .....
i have a search engine which contains all of the links in an access db.
basically what i am wanting to know is:
is there some code i can make to query all the results for a matching word such as "elephant" all the results (url) in the database would be opened and checked, Any broken links would be removed.
does any one know how to do this. what i was thinking of doing was creating some code to open all the pages that match a search....say 50 open
i could then click through them closing them individually to check all urls rather than doing it manually
A friend has told me that links that worked fine in IE 6 on a PC are now not working in IE 7. The only thing they can see is that these links have the following common traits: a) long file names, ie about 30 plus chars b) underscores in the filenames. c) They are derived from the old asp routine to force a pdf download rather than open them up in the browser window. I'm desperately trying to borrow a PC to install IE 7 (I don't want to affect my own PC in anyway at the moment) to test this
I got the below code from somewhere ages ago. I have a list of links on my site that link to other sites but I want to check if the link is a valid link automatically and if it fails after x checks (checks every 7 days) then to mark the link as a possible broken link
the below seems to take ages to process and was wondering if there is a better way to do the below. Code:
i am having a textarea in which the website links r entered by the user separated by a comma(,). and the same i am storing in the database field with type memo. now i want to retrieve the entered links and display all the links separated so when the user clicks on a particular link the page for that page opens us.
does anyone know how to request the static links off a page using XML and asp? I would really appreciate any help you can give me on the subject. I need full links including the http:// and everything.
I wish to hide links, i'm at present trying to 'float' as such invisible links over a background image.... the line i'm wishin to use that i think is right is
#links a i {visibility: hidden;}
when taken out we can see the links, as needed, but the minute i add this line, they should be invisible but still there, this is the case in IE but with FF they disappear completely...
I have a search box called r_name on the results page is requesting it but if a person searched for a pub name then i'd like to page by pub name if a person typed in a town then i'd like to page by rsTown and if a person typed in a postcode i'd like to page by postycode something like: Code: IF r_name = rsTown THEN Response.Write(" <a href=""search_results1.asp?<%rs="rsTown"%>& r_name & "&pageno=" & paging & """class=""textareatext"">" & paging+1 & "</a> ") END IF
the above bit of code is incorrect?! or Code: IF r_name = rsPubName THEN Response.Write(" <a href=""search_results1.asp?rsPubname=" & r_name & "&pageno=" & paging & """class=""textareatext"">" & paging+1 & "</a> ")
Is there an ASP command that can I use to make every occurance of a certain word into a link? For example, if I have an article about marketing, and I want every occurance of the word "marketing" to link to a page called marketing.htm, how would I do this using ASP
I have a site where an affiliate program has been wreaking some havoc with their affiliate links, and has now been cancelled.
The site is hosted on windows and the files are .asp files.I need to be able to redirect the affiliate IDs to something safer, such as domain.com/ instead of domain.com/aff.php?id=1
I have a db that users search to return records. However, I want them to see only 10 per page and then, a NEXT 10 link that will display the next 10 results.I have tried using LIMIT , but it only returns the specified number but no links or way for users to view them or the remaining the search results.
The search results is getting lengthy and users are beining to scroll, whine and complain.I am using Asp, MS SQL 7 on WINNT.
