Announcement

Collapse
No announcement yet.

Small bug/restriction in show URL

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • jcallahan
    replied
    Looking back, I guess I understood Johnny's solution was to update the stored value in the database table using the REPLACE() function rather than what he actually suggested.

    So yeah, my "even better" is what he suggested..

    Leave a comment:


  • hancockm
    replied
    "Even better solution- used REPLACE() function over the source column on SQL statement in data source definition.

    That way the column value in the database agrees with to the actual IFS object name."

    jcallahan,

    The way you wrote that reply appears you are using the same solution he offered.

    Could you give an example showing how your type of REPLACE() function is better than his REPLACE() function.


    Thanks,

    Leave a comment:


  • jcallahan
    replied
    Even better solution- used REPLACE() function over the source column on SQL statement in data source definition.

    That way the column value in the database agrees with to the actual IFS object name.

    Leave a comment:


  • jcallahan
    replied
    Johnny:

    Thanks. Suspected hash was a reserved value.

    replacing # with the encoded value %23 resolved my issue.

    Leave a comment:


  • Johnny Major
    replied
    You could update your Data Source to replace the '#' with the encoded value of '%23' if you cant remove it from your file name.

    Example SQL:

    REPLACE(IFSFileNameFIeld, '#', '%23')

    Leave a comment:


  • Johnny Major
    replied
    Unfortunately, # is a reserved symbol and considered a URL.hash so we suggest removing the '#' from your file names.

    Leave a comment:


  • jcallahan
    started a topic Small bug/restriction in show URL

    Small bug/restriction in show URL

    When attempting to serve a pdf where the name includes the character #,
    the iFrame flashes briefly with the pdf and then displays an error message "requested URL portion-of-the-filename-up-to-the-# was not found on the server"



    Valence Framework 5.2.20191218.0
    Attached Files
Working...
X