--_c337051e-f9c0-4d79-81ec-2dea230a30c6_
Content-Type: text/plain; charset="Windows-1252"
Content-Transfer-Encoding: quoted-printable
I just reinstalled my pc its running danish win xp as it was before.
My application is in VB6 it connects to mysql on the same pc using myodbc. =
All this worked fine before the new install.
now im getting the following error:
SQL MSG:[MYDB.EXECUTE_CMD] (-2147217900) [MySQL][ODBC 3.51
Driver][mysqld-5.0.45-community-nt]Unknown column 'Falsk' in 'field
list'
SQL ERROR:insert into que
(action,commands,que_id,sandbox,comment,requested_by,submite d) values
('NPC','\"Count\"
Ungula',18285,Falsk,'NPC_requests:18285','Laurlybot',now())
If i print out the variable in visual basic it says its "false" yet
when it tryst to insert it into the database it uses the word "falsk"
which in danish is "false" how do i get it to use the English spelling? T=
his is probably has to do with why i cant insert dates into the database ei=
ther as it trys to use the danish format (DD-MM-YYYY) for those by default =
instead of mysqls default of YYYY-MM-DD.My application is rather large and =
i would rather not have to change all the boolean variables to something li=
ke tinyint storing 1 and 0.Thanks Linda
____________________________________________________________ _____
Make every IM count. Download Windows Live Messenger and join the i=92m Ini=
tiative now. It=92s free.=A0
http://im.live.com/messenger/im/home/?source=3DTAGWL_June07=
--_c337051e-f9c0-4d79-81ec-2dea230a30c6_--
