Garry Saddington wrote:
Andreas Jung wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I would assume that you can use DTML-IN for looping and generating
multiple SQL statements of the same kind. You have to ensure that
the statements having a proper delimiter (there was something
-var
Uni_Longitude/
/dtml-in
/markers
or just let the ZSQL get the argument from the REQUEST:
markers
dtml-in uniSingleByCode
mrk nm=dtml-var Uni_Name lat=dtml-var Uni_Latitude lng=dtml-var
Uni_Longitude/
/dtml-in
/markers
HTH
regards
Garry
dtml-or
dtml-sqltest client op=like type=string optional
/dtml-sqlgroup
Thanks... Jim
If you use Postgresql then change the 'like' to 'ilike'.
Regards
Garry
___
Zope-DB mailing list
Zope-DB@zope.org
http://mail.zope.org/mailman/listinfo
://www.plope.com/Books/2_7Edition/RelationalDatabases.stx
there you find examples how to use a query with like.
robert
Here's an example of how to use like and wildcards in sqlvar's
select * from students
where surname ilike dtml-sqlvar expr='%'+surname+'%' type=string
Regards
Garry
How can I access a Psycopg_database_connection within a python script.
So far I have this which only returns a connection instance, but I want
to pass the connection a query string.
query1=context.Psycopg_database_connection('select * from studentdetails')
return query1
Regards
Garry
Charlie Clark wrote:
On 2006-02-22 at 22:10:20 [+0100], garry [EMAIL PROTECTED] wrote:
I am importing a large data set via Zope into a Postgres database. Data
items may or may not exist so I am using the optional argument in the
zsql methods. What I want is that if the data is missing