thanks -- it now works like a charm
Garry Saddington wrote:
On Wed, 2007-09-05 at 16:16 -0700, onsombal wrote:
is there an easy way to make the following ZSQL query case-insensitive?
select * from clients
dtml-sqlgroup where
dtml-sqltest firstname op=like type=string
is there an easy way to make the following ZSQL query case-insensitive?
select * from clients
dtml-sqlgroup where
dtml-sqltest firstname op=like type=string optional
dtml-or
dtml-sqltest lastname op=like type=string optional
dtml-or
dtml-sqltest client op=like type=string
I'm attempting to pass multiple variables via the url string. field1
field2 are form variables to be passed on a redirect.
field1 = 'foo'
field2 = 'bar'
For the command below, I do not get a python syntax error unless I remove
the + symbols:
return
Here's the scenario:
1. insertNew is a Z SQL Method for creating a new record in pgsql table1
Argument list = field1, field2, field3
SQL Query:
INSERT INTO table1 (field1, field2, field3)
VALUES (
dtml-sqlvar field1 type=string,
dtml-sqlvar field2 type=string,
dtml-sqlvar field3
I tried the techniques you suggested and it results in the same error --
KeyError: 'form.submitted'
field1 = changed_field1
context.insertNew(field1=field1) -- I also tried the other technique and
got the same error.
I tried your technique with the following changes to my pfg (ploneformgen)
for
['fbkurl'] = fbkurl
#create record in usdb listing table
context.listingsCreateRow()
And it works!
Charlie Clark-2 wrote:
Am 27.08.2007, 21:59 Uhr, schrieb onsombal [EMAIL PROTECTED]:
I'm assuming the form results are stored as an object represented as a
dictionary. If so
