[Zope] newbie - odbc missing operator

Mon, 16 Aug 1999 11:24:22 -0500

This is a multi-part message in MIME format.

------=_NextPart_000_000A_01BEE7D9.E3526560
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Using dbase, I want to find all records which have a phone that begins =
with a specific area code. I try
select name, phone
from contact1
where phone startswith '(918)'
(The same query works with crystal report.)
which produces...
Error, sql.error: ('37000', -3100, "[Microsoft][ODBC dBase Driver] =
Syntax error (missing operator) in query expression 'phone1 startswith =
'(918)''.")

I can use =3D as an operand but need to know how to use other odbc =
operands.=20
Also, anyone know where a list of operands for dbase might be located on =
the internet.
Michael Guidry
michael.guidry@trigenttechnologies.com

------=_NextPart_000_000A_01BEE7D9.E3526560
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2><PRE>Using dbase, I want to find all =
records which have a phone that begins with a specific area code. I =
try</PRE><PRE>select name, phone
from contact1
where phone startswith '(918)'</PRE><PRE>(The same query works with =
crystal report.)</PRE><PRE>which produces...
<STRONG>Error, <EM>sql.error</EM>:</STRONG> ('37000', -3100, =
"[Microsoft][ODBC dBase Driver] Syntax error (missing operator) in query =
expression 'phone1 startswith '(918)''.")
</PRE><PRE>I can use =3D as an operand but need to know how to use other =
odbc operands. </PRE><PRE>Also, anyone know where a list of operands for =
dbase might be located on the internet.</PRE></FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Michael Guidry<BR><A=20
href=3D"mailto:michael.guidry@trigenttechnologies.com">michael.guidry@tri=
genttechnologies.com</A></FONT></DIV></BODY></HTML>

------=_NextPart_000_000A_01BEE7D9.E3526560--