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 <foge...@askics.net> 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 > lists...@terascript.com <mailto:lists...@terascript.com> with "unsubscribe > terascript-talk" in the body. Ben Johansen http://www.webspinr.com b...@webspinr.com Phone: 360-600-7775 ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.