How ASP sorts prices from low to high and high to low

By default, the order by publication time is changed like this:

if request("odr")="up" thenelseif request("odr")="down" thenend if

Looking at the source program, it should look like this:

Amend the above line to read:

if request("odr")="up" thenelse

end if

Sort from lowest to highest.

Procedure: if request("order")="2" thensql="select * from table name order by **field name"

elsesql="select * from table name order by **field name desc"

end if

Yes, such as the **field price

price=rs("price")

sql="select * from table order by cast(price as int) desc"

This is from descending, that is, from high to low.

sql="select * from table order by cast(price as int) asc"

This is ascending, i.e. from low to high.

You don't have to ask for a hero.

Then show all the heroes, and then click on the lower left corner to arrange by coins, and naturally there will be a subtitle that can be arranged by coins, bonds, and subtitles.

Tap once from low to high and tap twice from high to low.

I won't go into the ** to see?。。

When you get to the store, you can sort it yourself.

Apple is the highest, then IBM, Dell, HP, Lenovo, Acer, Asus is about the same, and finally there are some domestic second- and third-tier brands such as Shenzhou, Founder, Great Wall, 7-Up, Haier.

I don't know what you mean, different brands of notebooks have different in-depth fields, even if the same configuration** will have a big gap, or the same** configuration is also different, can not be generalized. For example, Apple is used to install 13, ThinkPad is used for business office, Asus is an expert in making game books, and Dell is cost-effective, these are all different.

Mac Sony Lenovo Shenzhou.

Others can be ignored.

The black sour branch and the red sour branch should be made of the same material, but the former has been for a long time, and the flower branch is worse, and it is much cheaper.

There aren't many of them in Laos right now, and there's a lot of them on the market.

The sorting** is not added to the ** you posted, but to be added to the statement in the query data opening library, I don't know what your statement looks like, and I don't know what your time field is, so I can only give you a hint.

order by id (database ID) desc (sorting method, desc is the simplest ID number, the larger the number, the higher the first, asc is from small to large).

The same as above, but the id is replaced with the field name of the time.

Sort in the inquiry statement.

It is not in the above statement.

Query statements. "select * from the table order by adddate desc",conn,1,1 'Descending chronology.

select * from the table order by adddate asc",conn,1,1 'Ascending time.

Looking at the SQL statement, from high to low, it is "......id desc", then from low to high is "......id asc”

SQL statement"desc"Instead"asc"Can!

Modify SQL query statementsOrder by id desc, descending order is desc ascending order is asc

The SQL Server database has a newid function, sql="select top 10 * from tablename order by newid()"

The access database also provides an RND function, which can be randomized by the following SQL statement:

sql="select top 10 * from tablename order by rnd(id)"

However, the reason for the caching of the access database record set is that the access database random record can not be obtained from **, and the cache needs to be eliminated by random SQL statements.

randomize