Bad translation of True/False in ASP
Posted on 2004-10-17
My recent system is WinXp SP2 and IIS 5.1 using the french canadian language
The following code don't work anymore in ASP (it was working fine with
win95 and PWS of Frontpage98)
sql = "UPDATE MyBase SET "
sql = sql & "Show= " & True
I found that he sql sent to the ODBC database is :
Update MyBase Set Show = Vrai
instead of the expected :
Update MyBase Set Show = True
The IIS ASP interpreter translate the Boolean value True in his french
equivalent Vrai , and the resulting string is not recognise by my Access
database who expected the True value.
How can I tell IIS to interpret the True/False value with it's english
equivalent while keeping my system interface in french?
Thank's for your help.