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] with "unsubscribe terascript-talk" in the body.
