You need to insert the following line between two SQL statements.
dtml-var sql_delimiter
Remember you can't use it with more than one SELECT.
sql_delimiter is usefull only to separate more than one
INSERT, UPDATE, DELETE.
Jos
Andy McKay wrote:
Ive looked through the docs and Im sure I saw
Hi all,
I'm trying to insert data into a MySQL table using a SQL Method
without success.
Zope return me the following message:
"Error, Exceptions.SystemError: unknown opcode"
Any ideas?
Thanks
José
___
Zope maillist - [EMAIL PROTECTED]
from ZSQL Methods User's Guide, last row on pag. 22:
"Note that no more than one SQL select statement may be used in a single SQL
Database Method."
Diny van Gool wrote:
Hi,
I want to execute multiple SQL statements in one SQL-Method. In the
mailinglist archives i found the answer but
Use an External Method like this one.
# Perché non usare un metodo esterno?
from DateTime import Date
def lastDay(year,month):
try:
last = Date(year,month+1,1)-1
return last.day
except:
return 31
José
Eric Walstad wrote:
Hi Paolo,
I have a Python Metho... er
Tino Wildenhain wrote:
Hi,
anybody had time for testing? May be we could have it in the next
zope release. Any comments, remarks? How about an alternatively or
extra "name"-attribute wich defaults to "sequence" ?
Another issue: what about an alias for dtml-var called something
like:
Paolo Quaglia wrote:
Hi
to all,I'm
a new Zope user/developer ... Zope has impressed me very much!Ihave
a couple of questions.I
want to build a new intranet site for my company using Zope, but:1.
How can I import and use Python modulesFor
example I want to use the function sleep(secs) that
There isn't a SQL standard command to show the tables in the database.
Thus evry database has a different command to do such job.
For example:
DBMaker:
to show TABLES: select * from SYSTABLE
to show COLUMNS: SELECT COLUMN_NAME,TYPE_NAME,PRECISION FROM
SYSCOLUMN WHERE
Great!
Thank you very much Curtis.
Curtis Maloney wrote:
On Tue, 14 Nov 2000, Jose Soares wrote:
Hi all,
I'm trying to display the column names of a Record object without success.
I'm able to access column data using sequence-item but I don't know
how to display column names
Hi all,
I'm trying to display the column names of a Record object without success.
I'm able to access column data using sequence-item but I don't know
how to display column names.
dtml-var standard_html_header
dtml-in "desc(cmd=cmd_sql)" size=50 start=query_start
dtml-if sequence-start