just wondering something. have you tried adding o1. to the as value. ie. o1.OV_ID as o1.OV_ID2
> On Jan 1, 2019, at 4:41 PM, Fogelson, Steve <[email protected]> wrote: > > I am converting an app from using a MySQL ODBC connector to MySQL JDBC > connector and am finding a few differences > > Below is part of a SQL build for a Custom SQL Query > <@assign request$SearchQuery "SELECT"> > <@assign request$SearchQuery "<@var request$SearchQuery> o1.OV_ID, "> > <@assign request$SearchQuery "<@var request$SearchQuery> o1.OP_ID, "> > <@assign request$SearchQuery "<@var request$SearchQuery> o1.OV_ID AS OV_ID2, > "> > <@assign request$SearchQuery "<@var request$SearchQuery> o1.OP_ID AS OP_ID2, > "> > <@assign request$SearchQuery "<@var request$SearchQuery> o1.OV_SKU, "> > > You notice that I setup an alias for a couple fields. This syntax worked fine > with the MySQL ODBC connector, but doesn’t work with the MySQL JDBC connector. > > ODBC > OptionValues1 Headers > OV_ID > OP_ID > OV_ID2 > OP_ID2 > OV_SKU > > JDBC > OptionValues1 Headers > OV_ID > OP_ID > OV_ID > OP_ID > OV_SKU > > The JDBC connector doesn’t take the alias names. Is it something with my > syntax or do I have to do something different? > > Thanks in advance for the help. > > Steve Fogelson > Internet Commerce Solutions > > To unsubscribe from this list, please send an email to > [email protected] <mailto:[email protected]> with "unsubscribe > terascript-talk" in the body. Ben Johansen http://www.webspinr.com [email protected] Phone: 360-600-7775 ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
