[Zope] ZSQL 'Like'

[Jim Sanford]

if user is the variable holding the name 'Jim' (or whatever):

select * from some_table where username like <dtml-sqlvar
"_.string.strip(user)+'%'" type=string>
 __________________________________________________________________

              Jim Sanford
      .       Database Engineer
     / \  /   Accelerated Technology, Inc.
    /   /     720 Oak Circle Drive East
   /  /  \    Mobile, AL 36609
  / /     \   Voice: 334-661-5770  fax: 334-661-5788
 /         \  E-Mail: jsanford@atinucleus.com
              Web: http://www.atinucleus.com

 Source Code, No Royalties, Any CPU...It just make sense !
 __________________________________________________________________


----- Original Message -----
From: JB <jimbag@kw.igs.net>
To: <zope@zope.org>
Sent: Friday, November 19, 1999 2:02 PM
Subject: [Zope] ZSQL 'Like'


> I'm new to Zope and I'm trying to put togther a ZSQL search method. I
> want to take the input from the user form and create a LIKE clause
> rather than an = clause. This means I need to tack a percent sign onto
> the input.
> If the user enters 'Jim' I need the SQL method to create,
> WHERE firstname LIKE 'Jim%'. Whats the best way to do this in Zope?
>
> thanks
> jb
>
> _______________________________________________
> 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 )
>
>