LSTSRV-L Archives

LISTSERV Site Administrators' Forum

LSTSRV-L

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Topic: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Eric Thomas <[log in to unmask]>
Thu, 8 Nov 2007 19:22:42 +0100
text/plain (11 lines)
> SQL> SELECT EMAIL,NAME,_MAXWELLPLACE FROM LISTSERV WHERE {fn
> SQL> UCASE(EMAIL)} LIKE ? {escape '*'}
> >>> 37000/1064: [MySQL][ODBC 3.51 Driver][mysqld-4.1.7-nt]You have an
> >>> error in your SQL syntax; check the manual that corresponds to your
> >>> MySQL server version for the right syntax to use near '{escape
> '*'}'

The syntax is correct, but it seems that the ODBC driver you are using does not recognize it. Some LISTSERV functions will not work then. There may be a newer ODBC driver that solves this problem.

  Eric

ATOM RSS1 RSS2