Re: [Zope] ZSQL question

2000-10-17 Thread Paul Zwarts
> 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

[Zope] ZSQL question

2000-10-17 Thread George Osvald
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 mailli

[Zope] zsql question (cannot render query template)

2000-07-07 Thread Oliver Frommel
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 t