[Zope] Simple SQL (?)

[Jenny Campbell]

Thanks - it's working fine now!!

Jenny


Tino Wildenhain wrote:

> Hi Jenny,
>
> Jenny Campbell wrote:
> >
> > Hi there
> >
> > I know there's probably a really simple answer to this but I can't see it for looking. I've made an ODBC connection to a Access 97 database and am
> > trying to run the following query:
> >
> >                     select ph_user, ph_location, ph_directno,   ph_extension, ph_mobile_ext
> >                     from tblPhone
> >                     where ph_user matches '*John*'
> >                     order by 1
> >
> > but get the following error:
> >
> > Error, sql.error: ('37000', -3100, "[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing  operator) in query expression 'ph_user matches
> > '*John*''.")
> >
> > Ideally, I would like to be able to search against a table for ph_user using their first name only and return all the other fields. Would appreciate
> > any advice. We're using Zope 1.10.3
>
> I'm not familar with Access, but most databases use something like:
>
> like '%John%'
> or ideally: like @lower('%john%') to catch all posibilities
> Please refer to your Access manual for this.
>
> If you would like to distinguish first name, second name, you could make
> seperate fields for the names.
>
> HTH
> Tino Wildenhain

--
Jenny Campbell
User Support - Applications
Eastern Equities Limited
Ph: 06-876 7943  Fax: 06-876 8811

---------------------------------