how to sort and selection, plz help

[Valley88]

Hello,

I have a access database list, and I can sort with alphabetical list like a, b, c, ...

But now, I only want to get chinese list as chinese version is selected, to get english list as english version is selected, because the database list includes chinese and english information, for example:

Language name        company

cn              yageo     国巨

en              yageo     yageo

cn              kemet     kemet

cn              vishay    vishay

en              nxp        nxp

when sort=y and lang=en, result list will be yageo, nxp

how can I do to get it?

Thanks in Advance!

Valley

[bregent]

Are you asking how to filter your recordset? If that's the case, then you need to pass the language key to the SQL select statement to be used in the WHERE clause. For example:

SELECT * from MyTable WHERE lang = "en"

If this is not what you are asking, then please include more details.

[Valley88]

Actually, I cannot get correct answer.

I have a list with many data

How can I get a list with alphabetic=a and language=en thru following?

list.asp?sort=a&lang=en

[Valley88]

Thanks, now I got it.

[hotels-travels]

this

SELECT * from MyTable WHERE lang = "en"

[Valley88]

I used:

SELECT *

WHERE tb like 'MMColParam%' and Language = 'MM_lang'