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
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 this sql statement
sql=" Select * from table where id="&myarray(0)
I want to order by column1.How do you add "order by column1" using an array?
I put the result into an array getting from another db, the arrangement should not be changed,
MemberList = "'007910', '006853', '007965'"
SQL = "Select MemberID, name From Member"
SQL = SQL & " Where MemberID In (" & MemberList & ")"
Set rs = GetMdbStaticRecordset( "Member.mdb", SQL)
While not rs.eof
........ Wend
But the order changes to 006853 first, then 007910....007965 . Is it possible to use "order by" to keep the arrangement.
SQL = SQL & " Order By '" & MemberList & "'"
Is there a function ASP ordering an array list in alphabatic order? something like
HTML Code:
<%
Dim A
Dim i
Dim N
A=array('bdj', 'asda', 'dasd','etc')
N=UBound(A)
for i=0 to N
displayInAlphabaticOrderFunction(A)
<%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.
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"
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.
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.
I dump the entire recordset into an array:
If not rs.EOF Then
aEmp = rs.GetRows()
Contents of the array are in this order:
EmpID,EmpName,Indent,Sub_ID,Lft,Rgt,MgrID, LastName
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array
with a variable that has an integer value but I can redimension one this
way. I haven't see any information that tells me if this is a requirement,
although it appears to be because I get an error if I try it.
Ex.
Dim b
b = 10
Dim a(b) ' this errors out but
Dim a() ' this
Redim a(b) ' works
Code:
I want to create a new array called arrNames2 and copy contents of arrNames to arrNames2.
I then want to loop through my db and add more names (while going through the loop) to arrNames2. What is the best way to do this? Do I have to keep redim the array wehn I add more names?
I have a code looking like this, but i can't seem to get it to work:
strSQL = "SELECT * FROM files WHERE Subject = 1 ORDER BY ID DESC"
What am i doing wrong?
This is a follow up to a question I asked two weeks ago which I thought was solved but on further inspection I realised it wasn't working fully. I have an ORDER BY on my search results page, the search uses two dropdown menus, the first one is start character (A-Z), and the other is grade.
The problem I have is that the ORDER BY work perfectly when I leave the start character dropdown blank, and when I use the grade selection dropdown, but when I select a start character I get this error message:
Microsoft JET Database Engine error '80040e14'
Characters found after end of SQL statement.
/html/advanced_comic_search.asp, line 56
Can any one shed any light on this for me?
I have records which I want to display a certain way, i.e. the records are in the database like this:
24TR
9L
133JF
But I want to display them as:
9L
133JF
24TR
Is it possible?
I am using an sql inner join like below:
strSQL = "SELECT * FROM tblPage INNER JOIN tblNews ON tblNews.NewsID=tblPage.pageID ORDER BY newsDate DESC"
However this orders both by newsDate which causes problems with the ordering of the page, As I want the page not to be ordered just the news item.
An ASP page outputs data from the query
"Select ThisAndThat from comments WHERE pageURL='" & pageURL & "' ORDER BY
threadID, datesent"
(Access mdb)
threadID is a string (OK, I know!), which means that 103 displays before 99.
Is there a way to write the SQL query to order them numerically? This would
be much easier for me than changing the data type and hunting down every
page that INSERTS or UPDATES the db.
I am extremely confused about how i should go about doing this:
I have puled out current orders and have displayed in a table .These orders have their own order numbers.
Once the person clicks on first order,the order is displayed in a form,where the user can edit the order details and hit submit.
Now when he hits submit ,I want his to go the previous page where the orders are displayed in table ,so that he can click on the next order and process it/OR may be whent he user hits submit ,i want the next order directly to be displayed in the form.
I have a table in my database with several numbers.(2, 5, 8, 0, 9, 0).Now i retrieve the numbers to my page using "order by numbers", and my page look like this.
0
0
2
5
8
9
I want the lowest number to be first, but if the number is 0 (zero) I want it to go to the bottom.Can that be done
At the moment I have:
SQL = "SELECT sample.* FROM sample WHERE (id = " & teamid & ") ORDER by pos"
Which orders my players like:
ATT
DEF
GK
MID
in alphabetical order.
Is there anyway to specify this order so that it still orders the players by "pos"(position) but in this order:
GK
DEF
MID
ATT
i want to order by NUMBERS:
BUS n 1
bus n 2
ect.
bus n 10 bus n 11
But the order goes like this:
bus n 1
bus n 10
bus n 11
bus n 2
how can i get right order:
bus n 1
bus n 2
bus n 10
bus n 11 ....
I am performing a basic sql query. select * from tablename order by featured asc, id asc
BUT...I want all those listings with FEATURED as a Y to show up first.
All other listings should show up afterwards.
How do I do this? I may be thinking too hard about it.
I have one table wich has a unique ID feild for each record and other feilds, and another table that has one field that is a number that contains the an ID from the other table and another field that contains some text.
I want to open with sql the first table, but order its records alphabetically by the text in the second table. is it possible? Code:
I have used ASP for years using MS Access and have used MSSQL quite a lot as
well. I have never came across something like this before.
MSSQL table names and types:
ProductName nvarchar
ShortDescription nText
ThumbNail nvarchar
etc
When I have the recordset in the order as follows, all works well:
(Recordset2.Fields.Item("ProductName").Value)
(Recordset2.Fields.Item("ShortDescription").Value)
(Recordset2.Fields.Item("Thumbnail").Value)
Though if I have the Thumbnail first the description does'nt show.
I've got a site with PayPal and Google Checkout payment options. The checkout page formats two HTML forms, containing bespoke cart code - one posts to PayPal, the other to Google Checkout.When an order is placed, it needs to be updated back on my site, so that the order is marked as 'paid' in the database. When this is done with PayPal, I just provide a hidden field in the form called 'invoice' containing my id number for that transaction. This is returned in my IPN, and I update the database accordingly. However, I can't find a similar field in Google. Their example code all seems to be in XML and is WAAAAAAAAY more complicated than I need it to be. I just need to send a value with my cart code to Google Checkout, and have that value returned after the transaction has completed.
I've set up Google Callback, and the page is being called and the order is being written to my google log txt file, I just need this to contain my order id number for the transaction so I can just add the logic to update the database based on this id number.
Does anyone know how to organise data in alphabetical order when using a select statement???
When i use mine, i have been using ASC and it justs put the newest record added!
I've written the following piece of code which is embedded in HTML. For some reason when the script is processed the last response.write statment is displayed before the information in the while loop. I can't seem to figure out why this is happenming.
Any ideas? Code:
I am processing the variables from a form submission with a for/next loop. The problem is that the order of the variables are NOT written IN ORDER.
Form field 1 prints fine but then it jumps to Form field 9 and then back to Form field 4 then to Form field 2, etc. IS there a way to process the form variables in a loop in ORDER? field 1, field 2, field 3, etc? Code:
I have a form that is created dynamically, and all is working fine. But I want users to add an sort order to help list phrases in a certain order.
<input type="text" name="AdvantSort" value="" size=1>
<input type="checkbox" name="Advantages" value="10">
Phrase1
<input type="text" name="AdvantSort" value="" size=1>
<input type="checkbox" name="Advantages" value="20">
Phrase2
so on, so forth...
And one clicks on the form, and a SQL statement is executed.
However, when I create the SQL statement,
INSERT INTO table1
(FormId,AdvantageId,SortOrder)
VALUES (<call from form ID>,<advantages>,<advantsort>)
Then it loops to allow the next phrase to be entered. The statement also takes the value from every other sort order value including that ones that are in different lines. Which in result, gives me an error, saying the insert columns exceed that of the available columns in the table.
can i set a list of users to be ordered by two fields soo
This:
user 1
user 2 Admin
user 3
user 4 Admin
Becomes
User 2 Admin
User 4 Admin
User 1
User 3
orginal
Code:
strSQL = "SELECT [username], [ID], [email], [admin], [suspend], [Timestamp], [last_login] FROM tblUsers ORDER BY username"
If I have several fields:
a | b | c | d | e
and the original SQL = SQL & " ORDER BY a ASC ".
I want to place links to b, c, d, e to make the table of results to show by ascending order of b (or , c, d, e).
do I need to place an "if/ end if" in the sql or do I put some statement in the paging?
example
a (ORDER BY a ASC)| b | c | d | e
1 | 3 | z
2 | 2 | y
3 | 1 | x
4 | 5 | w
5 | 4 | v
to
a | b (ORDER BY b ASC)| c | d | e
3 | 1 | x
2 | 2 | y
1 | 3 | z
5 | 4 | v
4 | 5 | w