Just looked back and saw you were using the semi-colon to separate, but do you need to force a separate line in there too?
Frank. Frank Cazabon On 26/03/2012 08:56 AM, Frank Cazabon wrote: > > On 26/03/2012 12:58 AM, MB Software Solutions, LLC wrote: >> I wasn't going to bother trying that, as T-SQL is SQL Server and I am >> using MySQL. But, it didn't take much effort, so I did it since you >> offered. Nope. No good. No different. Thanks though for trying. > I think Stephen was hinting that you need to make sure that you are > using the correct syntax for your backend database. It looks to me > like you build up a string of selects without any sort of indication > that they are separate selects. In effect you are building up this: > > Select myfields1 from table 1 select myfields 2 from table 2 select > myfields3 from table3 > > I would expect any backend to choke on that, so you need to try it > like building up your sql command like this: > > Select myfields1 from table 1 > > select myfields 2 from table 2 > > select myfields3 from table3 > > using any line terminator that MySQL expects. > > Of course you may have it formatted like this already, but the sample > code you gave doesn't give that impression > > Frank. > > Frank Cazabon > > > > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
