[Zope] left(string, n) equivalent (newbie q.)

Luis Cortes lcortes@pollak.com
Thu, 15 Jun 2000 15:39:29 -0600


You should be able to use python's slice like so:

<dtml-if "word[:4] == 'help'" >
...

where "word" is the variable you want to use only 4 characters of.

Hope this helps,
bye.

----- Original Message -----
From: joel grimes <joelgrimes@hotmail.com>
To: <zope@zope.org>
Sent: Thursday, June 15, 2000 3:18 PM
Subject: [Zope] left(string, n) equivalent (newbie q.)


> Pardon my ignorance, I'm coming from a VB/Access background.
>
> I need to find an equivalent to using left(string, 4) in a zope SQL
method's
> select query.  My SQL book
> says I can use SUBSTRING(string, 1, 4) in a query but no luck.  I'm
> connecting to an Access database.
>
> btw - this mail list ROCKS!  I've never waited more than 10 minutes for a
> response.
>
> Thanks
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> 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 )