I do not understand your question. What exactly is not working? Is the
problem that you can not select data from the table, or that you can not
place the value into a cell?
I have added questions inline.
Thomas Martens wrote:
Hi,
I've a little problem with calc and sql. I've a table in this format:
+----+----------+----------+
|cid | surename | forename |
+----+----------+----------+
| 1 | testi | test |
+----+----------+----------+
Where is this table? Can you access the table?
Well, now to my problem. I want enter the 'cid' in a cell from a
spreedsheet,e.g. in E3.
And in A1 I want the output from:
SELECT `forename`,`surename` FROM `users` WHERE `cid` = 'E3'.
Are you asking the SQL format to access a sheet? Is your sheetname
really "users"?
But I haven't any idee, how to realize this in a function or so.
I use unixodbc, and the database connection and query works in OO. I
just need a formula/funtion or so....any hint, link or example would be
great:-)
Thanks Thomas
Are you using macros?
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.sxw
My Macro Book: http://www.hentzenwerke.com/catalog/oome.htm
Free Info: http://www.pitonyak.org/oo.php
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
