Re: [Zope] ZSQL question
> I have a table with lots of data in my Gadfly database. I would like to add > a couple of new columns to that table. Is it at all possible to add columns > to existing table or do I have to create a new table all together? > Nope, ALTER TABLE ADD i think should do it... Let me check ALTER TABLE memberlist ADD name VARCHAR Yep... that does it. Although I had tested this in PGSQL, Im sure it works for GadFly also. Since you are also inserting a new column you may want to initialize all current reocrds with a value, but I cant remember what it was... If you really need it, let me know, I'll dig in for you. Cheers, -- Paz Oratrix Development BV http://www.oratrix.com GRiNS SMIL Editor - ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] ZSQL question
I have a table with lots of data in my Gadfly database. I would like to add a couple of new columns to that table. Is it at all possible to add columns to existing table or do I have to create a new table all together? Regards, George ___ Zope maillist - [EMAIL PROTECTED] 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 )
[Zope] zsql question (cannot render query template)
Hi, I have a simple SQL method which just does a select on all rows, ie. "select * from users", which works. for security reasons I want to embed the sql statement in another dtml if- clause, like that: select * from users (checkperm is a DTML method which returns either 0 or 1) when I try to test the SQL method I get the following error: Error, exceptions.NameError: REQUEST SQL used: Could not render the query template! what am I doing wrong? thanks -Oliver ___ Zope maillist - [EMAIL PROTECTED] 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 )