Hi,
libpgtcl.so is a tcl library and not an apache module so you should load
it using:
load /usr/local/pgsql/lib/libpgtcl.so
whithin a tcl script.
(it would be a good idea to load it in the init script tho..)
Perki
follow up
admiting you have the first step done, and that you have a database name
bob with a table named alice with two columns named id and value.
"id" is an integer
and "value" a string (and you have at least one entry)
set conn [pg_connect bob]
set query "select id,value from alice"
pg_select $conn $query a {
hputs "<BR>$a(id) $a(value)"
}
set comm "insert into alice values(max(id)+1,'hello one more')
pg_exec $conn $comm
pg_disconnect $conn
J. c. B. wrote:
> Please help,
>
> On the page examples.ttml it says "You can, if everything is compiled
> right, load tcl modules, like libpgtcl.so (the Postgresql interface), so
> that you can interact with a database!"
>
> Does anyone know how to do this?
>
> I have mod_dtcl installed correctly as a static install. I have tested
> it and Tcl pages work. I put "LoadModule libpgtcl_module
> /usr/local/pgsql/lib/libpgtcl.so" in the httpd.conf file
>
> I get this error:
>
>> [root@server bin]# ./apachectl start
>> Syntax error on line 205 of /usr/local/apache/conf/httpd.conf:
>> Can't locate API module structure `libpgtcl_module' in >file
>> /usr/local/pgsql/lib/libpgtcl.so: /usr/local/apache/bin/httpd:
>> >undefined symbol: libpgtcl_module
>> ./apachectl start: httpd could not be started
>> [root@server bin]#
>
>
> Any Ideas?
>
> Question 2:
> Once I get the module loaded right does anyone have some code of a
> simple postgres "get pool" and a simple select statement from a ttml page?
>
> I also see that the mailing lists are no longer being hosted. What do
> you guys need in order to get the mailing list up? I'm excited about the
> mod_dtcl project. Mod_dtcl is already faster than Aolserver serving
> simple tcl-html pages! I'm excited to test mod_dtcl with database
> interaction.
>
> Thanks
> josh
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
