[Zope] Dynamic SQL problems.

[AM]

When you say format do you mean the underlying physical format ( as in 
InnoDB/ BDB etc ) or do you mean just the column names.

If it is the former then there  usually you can use the SHOW command to 
get details about the table ( I only know about MySQL, but PG is way 
ahead of MySQL in terms of features and it should be there ).

If it is the latter the same using SHOW COLUMNS will get you the list of 
columns. You can always use DTML in a ZSQL query to read off a 
dictionary of key value pairs.

So IMO use a ZSQL which does something like this:

insert into <table> (
  <dtml-in <var_name>.keys>
    <dtml-var sequence-item>  <dtml-if "not _['sequence-end']">,</dtml-if>
  </dtml-in> )
values (
  <dtml-in <var_name>.values>
    <dtml-var sequence-item>  <dtml-if "not _['sequence-end']">,</dtml-if>
  </dtml-in> )

I think that should do what you want.

to get the dictionary the easiest way is to process the input form in a 
python script that creates a dictionary from the form vars.

hth
am

Daniel Jackson wrote:

>I'm trying to create a dynamic table editor. The idea is you instance
>this product, give it the database host, user, pass, database name
>(Postgres in this case, BTW), and table, and you can edit that table via
>a nifty web interface. The problem is, I don't know what this table's
>format is beforehand, so I can't realy make any ZSQL methods for
>inserting new rows. Does anyone know how to work around this? 
>
>Thanks, DJ.
>
>
>
>
>_______________________________________________
>Zope maillist  -  Zope@zope.org
>http://lists.zope.org/mailman/listinfo/zope
>**   No cross posts or HTML encoding!  **
>(Related lists - 
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
>
>
>  
>

-- 
==================================================================
 Aseem Mohanty							   
 Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 
 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231		  	
==================================================================								  	
 "I saw `cout' being shifted "Hello world" times to the left and  
  stopped right there!!"                        -- Steve Gonedes  
==================================================================