OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

MySQL and Calc sheets ...

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
gillesdeshays
General User
General User


Joined: 14 Jul 2005
Posts: 5

PostPosted: Thu Jul 14, 2005 7:39 pm    Post subject: MySQL and Calc sheets ... Reply with quote

I have my old mysql database wich is now "connected" on OOo via ODBC ...

Everything works well ...

But i cannot find how to do what i need ....

I want to return in a cell, a text, extracted from a column in a table (anglais) of the database using LIKE fucntion ....

in my DB table i have a column called "transid" which contains a reference and an other called "expr" wich contains the english name of the reference ....

Refernce are like that : YY-X-XXXX-XXX where Y : letters and X : numbers

I need to "call" the english name (expr) in the DB which correspond to a reference in the calc sheet ...

On my calc sheet , the first column contains the refernce without the last 4 characters ( YY-X-XXXX ) and i want to use it to "call" the corresponding english name (expr) and return it in a cell ...

I tryied many many things without any success ...

the sql equivalent may be :
SELECT `expr` FROM `anglais` WHERE `transid` LIKE 'B12'
where B12 is a cell ....

But i can't make it works ....

Can somebody help me ? Wink

Thanks !

PS: i hope being enough clear .)
Back to top
View user's profile Send private message Visit poster's website
gillesdeshays
General User
General User


Joined: 14 Jul 2005
Posts: 5

PostPosted: Fri Jul 15, 2005 12:35 am    Post subject: Reply with quote

mmmmmmmmmm .... doesn't inspire anybody .... Crying or Very sad
Back to top
View user's profile Send private message Visit poster's website
gillesdeshays
General User
General User


Joined: 14 Jul 2005
Posts: 5

PostPosted: Sun Jul 17, 2005 5:48 am    Post subject: Reply with quote

Today i can tell that i really cannot understand how works the database with OOo ... !!!

I cannot find any tutorial to help me and i notice that there s many newbies like me which have many difficulties to export data from a dB to a cell ...

Sad
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group