Hi Frank -
are you able to look in your error logs and see if your Table call is
producing an error message ?
On Sep 10, 2006, at 7:04 AM, Frank Grellert wrote:
> Hi,
> I'm new to sqlalchemy, is there anyone, who can help me with
> integrating sqlalchemy with cgi?
>
> I'am using Postgres 8.1 and python 2.35
>
> Here's what I've done so far:
>
> * snip * * snip * * snip * * snip * * snip * * snip * * snip * * snip
> * * snip * * snip * * snip *
>
> db = 'databasename'
> scheme = 'schemename'
> tabelle = 'tablename'
> form = cgi.FieldStorage()
> name = form.getvalue('name')
> vname = myquery(name, db, table, scheme)
>
> * snip * * snip * * snip * * snip * * snip * * snip * * snip * * snip
> * * snip * * snip * * snip *
>
> myquery() is a procedure which works well on the shell and returns the
> query-result but it fails if I use it within a cgi-script,
> myquery(name, db, table, scheme) connects successful to the database,
> but it is unable
> to open the table. The line
>
> a = Table(table, metadata, autoload='True', schema =scheme)
>
> returns a mistake.
>
> Any Ideas?
>
> Thanks!
> Frank
>
> ----------------------------------------------------------------------
> ---
> Using Tomcat but need to do more? Need to support web services,
> security?
> Get stuff done quickly with pre-integrated technology to make your
> job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache
> Geronimo
> http://sel.as-us.falkag.net/sel?
> cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Sqlalchemy-users mailing list
> Sqlalchemy-users@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
Sqlalchemy-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users
