#1 Yesterday, 10:27 AM
neon20

Registered User
   Join Date: Mar 2007
Posts: 1
Time spent in forums: 4 m 32 sec
Reputation Power: 0

Asp datetime problem with non-Unicode languages

--------------------------------------------------------------------------------

hi everybody,

i have datetime problem with my access database

im not able to update the datetime field in the msaccess table using

objcon.execute "update users set us_userlastlogin='" & now() & "' where us_userid= '" & us_userid & "'"


i have non-Unicode language as Arabic in Regional and Language Option in the control panel. When i change this to US english erything works fine.

But if it is arabic, the query is works as

update users set us_userlastlogin='03/03/2007 05:44:21 ã' where us_userid= 'anas'

instead of

update users set us_userlastlogin='03/03/2007 05:44:21 PM' where us_userid= 'anas'

ie the datetime field doesnt accept ã character

is there any convert or alternative methods for this?

thank you
neon

You need to surround date values with #'s and drop the single quotes to insert dates. EG:

sql = "INSERT INTO tbleName (fieldname) VALUES (#" & now() & "#);"

Change your query to:

objcon.execute "update users set us_userlastlogin=#" & now() & "# where us_userid= '" & us_userid & "'"

Ano observation : if your us_userid is an integer also drop the surrounding single quotes. I guess this is a habit of myn pointing this out. UserID's are commonly integer fields however if your us_userid field is a string leave it as is.

Im sorry I can not help you with non-Unicode languages, i have no experience with this.

Wind is your friend
Matt

hi matt
thank you for the reply

i tried # also and it didn't work. the userid field is text.

neon

Please define 'didnt work' what is your exact error, line number and the syntax on that line?

How do I get problematic SQL to work:
1..Comment out your execution line, response.write your statement and run the page.
2..Copy this syntax and paste it into the SQL window directley into Access. Does it work?
3..If not post the sql statement here indicating what data type the fields you use are EG:
   us_userlastlogin = date/time
   us_userid = text

Providing your two data types are as mentioned above, this should work:
objcon.execute "UPDATE users SET us_userlastlogin=#" & now() & "# WHERE us_userid='" & us_userid & "';"

NOTE
- The semi colon at the end is not a error correction, just good practice.
- Is there a value in the variable us_userid?

If it still doesnt work place this where ever you place your functions:
FUNCTION amDate(varDate)
   IF isNull(varDate) OR Trim(varDate) = "" OR varDate = "Null" THEN
      amDate = "Null"
   ELSE
      amDate = "" & Month(DateValue(varDate)) & "/" & Day(DateValue(varDate)) & "/" & Year(DateValue(varDate)) & " " & TimeValue(varDate) & ""
   END IF
END FUNCTION

And wrap it round your date value like so;
objcon.execute "UPDATE users SET us_userlastlogin=#" & amDate(now()) & "# WHERE us_userid='" & us_userid & "';"

This will insert a mm/dd/yyyy date type. What date type do you commonly use? Anyhow thats all I can think of. You need to post more specific errors.

Wind is your friend
Matt

hi matt

i could solve this problem by adding Session.LCID = 1033
in the global.asa

http://www.123hostnow.com/articles/LCID.asp

thank you very much for the helps that you provided.

neon