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.
