Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Desktop dynamic mysql query with parameters works; In service DOES NOT

I have a problem that only occurs with the service and not the desktop.  I have this dynamic mysql query that uses 2 parameters: date and hour.  I changed some of the names of the values like the hos...
General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Thanks Eyelyn but the article seems to be not so clear with regards to my situation.  The post you provided is Excel and mine issue is with MySQL.  

     

    Furthermore, my primary point is that the desktop version allows my query without issue. It only is the service that the problem presents itself. Makes me think that the code or parser on the service is either more strict or has not been updated to reflect the desktop.

     

    Your post states the combine problem comes about when there is an “External Data Source” and “Another Query”.  I ask, which is the “Another Query” in my query?  I only have 1 SQL query albeit, it’s dynamic.  Could it be that the mere fact that the variable DimShipper is introduce makes the service parser believe that is the "Another Query"?  Just because it's a variable??? 

     

    If so, I can not circumvent this because I have then 2 “Another Queries”.  I have the “table_name” and the “hour” which is necessary for the sql.  I have made a workaround by creating a dynamic view that the user updates on a separate CGI page I made but I would like to find out what specifically is wrong or if it is indeed a code update that needs to take place on the service.

     

    The other “functions” by the way I use after the Source assignment are as follows:

     

     Table.DuplicateColumn

     Table.RemoveColumns

     Table.RenameColumns

     Table.ReplaceValue

     Table.Sort

     Table.SplitColumn

     Table.TransformColumnTypes

     

    Any further suggestions or insights would be greatly appreciated but I think my issue is not apples to apples at least with that Excel post and the issue being the discrepancy between the desktop version and servcie  The service and desktop, in my opinion, should have the same behavior.

     

    Thanks!

     

    Bryant