how to sort and selection, plz help

Question

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        companycn              yageo     国巨en              yageo     yageocn              kemet     kemetcn              vishay    vishayen              nxp        nxpwhen sort=y and lang=en, result list will be yageo, nxphow can I do to get it?Thanks in Advance!Valley

bregent · Answer

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.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.