on 3/22/00 11:29 AM, Dannie M Stanley at dan@stripped wrote:
> I am using Microsoft Query to merge information into a Microsoft Word
> document. It works fine except when one of the statmenets gets too long.
> Example:
>
> SELECT somefield1, somefiled2
> FROM sometable
> WHERE someval = someotherval AND ((someval = someotherval) OR (someval =
> someotherval) OR (someval = someotherval) OR (someval = someotherval)
>
> It puts a line break in the middle of the SQL statment and MySQL doesn't
> concate the line. Does anyone have information on this or know a work
> around?
>
>
> Thanks,
> DS
>
> --
> Dannie M Stanley
> Webmaster/Developer
>
> SpinWeb Net Designs, Inc - http://www.spinweb.net
> Voice: (765) 215-7148 Fax: (603) 843-1403
>
>
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail myodbc-thread1363@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail myodbc-unsubscribe@stripped instead.
>
Do the line break yourself.....
...
SELECT somefield1, somefiled2
FROM sometable
WHERE someval = someotherval
AND ((someval = someotherval)
OR (someval = someotherval)
OR (someval = someotherval)
OR (someval = someotherval)
...
Will prevent MS Query from breaking it up on it's own.
