ASP.NET Discussion - Language in access

Print Page | Close Window

Language in access

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: ASP.NET Discussion
Forum Description: Discussion and chat on ASP.NET related topics.
URL: https://forums.webwiz.net/forum_posts.asp?TID=7997
Printed Date: 28 March 2026 at 4:08am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Language in access

Posted By: Boecky
Subject: Language in access
Date Posted: 11 December 2003 at 1:35am

I have a weird experience with following sql command:
strCmd = "SELECT * FROM tblSomething WHERE Lang = 'nl' ORDER BY Something_ID DESC"

Previous command will work, but if I change Lang to Language, it won't work anymore
strCmd = "SELECT * FROM tblSomething WHERE Language = 'nl' ORDER BY Something_ID DESC"

Off course I change this in my db too

Does anyone know why this is, and how I can solve it? Coz I really wanna use the word Language

Replies:

Posted By: Leeb65
Date Posted: 11 December 2003 at 2:16am

strCmd = "SELECT * FROM tblSomething WHERE [Language] = 'nl' ORDER BY Something_ID DESC"

Try that

Lee

Posted By: Boecky
Date Posted: 11 December 2003 at 2:26am

thanks, that works!

Is 'language' a reserved word or something?

Posted By: Leeb65
Date Posted: 11 December 2003 at 2:33am

Ja, it's a VS reserved word, at least as far as I know.

You can set a documents language using it. Both Lang and Language are used.

Posted By: MorningZ
Date Posted: 11 December 2003 at 5:31am

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/odbc/htm/odappcpr_17.asp - MSDN's list of reserved words

access absolutely sucks in that it is waaaay too picky with column names.. SQL Server is much much much more forgiving.. and if you are used to SQL Server, just wrapping all the Access columns in [ ]'s solves 100% of those problems

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: Leeb65
Date Posted: 11 December 2003 at 5:35am

Good tip MorningZ, although I only ever use SQL Server now.

Posted By: Diep-Vriezer
Date Posted: 11 December 2003 at 10:08am

Have you tried XML? I'm in luv with XML now.

BTW, I also use SQL, since the loads of probs I had with Acces.

-------------
Gone..

Posted By: MorningZ
Date Posted: 11 December 2003 at 10:51am

i wouldnt fall too in love with XML.. its usefull in a few situations, but the lack of relationships and lack of a true query language is a MAJOR shortcoming

as for Access vs SQL.. Access works fine for any site with low traffic as long as its coded properly (mainly properly closing/disposing of threads to the database).. it is enough to get the job done

-------------
Contribute to the working anarchy we fondly call the Internet

Posted By: Diep-Vriezer
Date Posted: 12 December 2003 at 2:28am

Mmm, the query thing is a bit of a shame, yes, but I think MS will improve that.

I use it mainly as a configuration sheet for seperate pages, because it is so easy to update (using a control panel).

-------------
Gone..