Alphabetical Listings
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
ADVERTISEMENT
I have need to show a list of areas indented hierarchically on an ASP web
page like the following example. Code:
View Replies
View Related
I've been working on a Web site for a business (my first non-personal site)
and I want to help my client get the best search engine listing. Because this
is my first for-profit site, I'm not sure what I need to do for optimal
search engine placement. I've been poking around the Web, and I think I have
a good start, but there are a few questions still remaining:
1) What do I need to do in order to actually GET a page listed in a search
engine to begin with? Do I contact the search engines somehow, or are the
listings somehow updated automatically.
2) I've seen tips that advise putting meta keywords, etc., on EVERY page on
the site. However, we want users to only come to the site via the "front
door" - the index page. I don't see much reason to put a bunch of keywords on
a page that might be the third part of an application process - coming to the
site on that page would cause visitors to be confused. If I limited the
search engine keywords to just the index page, would that hurt the listing?
View Replies
View Related
I've started using stored procedures but I have a problem. My stored proc works fine but when I want to use it to list results on several pages I get an error. My previous code:
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 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
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
View Related
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
