List:MySQL ODBC« Previous MessageNext Message »
From:Peter Carter Date:March 22 2000 11:51pm
Subject:Re: Line Breaks
View as plain text  
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.

Thread
Line BreaksDannie M Stanley22 Mar
  • Re: Line BreaksPeter Carter23 Mar
    • Re: Line BreaksDannie M Stanley23 Mar
      • Re: Line BreaksPeter Carter23 Mar
        • Re: Line BreaksDannie M Stanley23 Mar
          • Re: Line BreaksPeter Carter23 Mar