SQL/ASP Approach To Alphabetical Links
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.
View Replies
ADVERTISEMENT
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.
View Replies
View Related
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.
Any reference paper or sample source code?
View Replies
View Related
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?
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
I'm able to pull the image from the database but I'm not able to pull the text from the record using this script. What am I doing wrong? Code:
View Replies
View Related
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?
View Replies
View Related
<%For iloop = ASC("A") to ASC("Z")
str = str & "<td class='alphabet' width='569' align='middle'><a href=" & chr(34) & "templatePage.asp?letter=" & chr(iloop) & chr(34) & ">" & chr(iloop) & "</a></td>"
Next%>
<%=Left(str,Len(str))%>
i need a '#' before the 'A' to bring up everything else, like in
the members page of this Forum.
View Replies
View Related
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)
View Replies
View Related
How can I exclude non-alphabetic characters from the string?
(all characters except A-Z, 0-9 and space, including -.,? etc)
What I mean is:
"Am I mad?" should produce "Am I mad"
or
"Left-Right" should produce "LeftRight"
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
I've got an array with the following values:
myarray(0) = btest
myarray(1) = htest
myarray(2) = atest
myarray(3) = gtest
How do i put them in alphabetical order?
myarray(0) = atest
myarray(1) = btest
myarray(2) = gtest
myarray(3) = htest
View Replies
View Related
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
View Replies
View Related
I am taking an ASP course and I am stuck with one error message that I can't seem to correct.Here are the links:
http://www40.brinkster.com/ccraigbro...assignment.txt
http://www40.brinkster.com/ccraigbro...assignment.asp
View Replies
View Related
links.asp?id=whatever how do i do this, i know response.write is part of the code but i forgot the rest of it.
View Replies
View Related
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?
View Replies
View Related
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.
View Replies
View Related
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: .....
View Replies
View Related
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
View Replies
View Related
I need to create a hyperlink to an .eml file so as to view it when the link is followed. The code is:
Response.Write "<a href='serverfoldermyeml.eml'>eml link</a>"
The problem is that the url automatically produced by this link is:
"mhtml:file://serverfoldermyeml.eml"
and the file cannot be found.
If I manually type "file:///serverfoldermyeml.eml" everything works fine.
How can I produce the correct url from my asp code? Any ideas?
View Replies
View Related
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
View Replies
View Related
win 2k pro
sql server 2k
asp - vbscript
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:
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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...
View Replies
View Related
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> ")
View Replies
View Related
I'm trying to add a Next and Previous link on a detail page but i'm not sure how to go about it....
First page displays listings.
Second page displays main item.
Now what i'm trying to do is maintain a next and previous buttons so people don't have to go back to the display listings page
View Replies
View Related
Please refer to altavista by search the 'asp'.
First page:
[<< Prev] 1 2 3 4 5 6 7 8 9 10 [Next >>]
Second page:
[<< Prev] 1 2 3 4 5 6 7 8 9 10 [Next >>]
BUT, at the 10th page:
[<< Prev] 5 6 7 8 9 10 11 12 13 14 [Next >>]
How do make this kind of navigational links in asp?
View Replies
View Related
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
View Replies
View Related
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
View Replies
View Related
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.
View Replies
View Related
