Hi Ben, Thanks for the suggestion. I will give it a try.
Robert did find a change that needs to be implemented in TeraScript and he is working on a fix and new build. May be related to JDBC version. Thanks Steve From: Ben Johansen <[email protected]> Sent: Tuesday, January 8, 2019 2:46 PM To: [email protected] Subject: Re: TeraScript-Talk: ODBC vrs JDBC 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]<mailto:[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]<mailto:[email protected]> Phone: 360-600-7775 ________________________________ To unsubscribe from this list, please send an email to [email protected]<mailto:[email protected]> with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to [email protected] with "unsubscribe terascript-talk" in the body.
