Results 1 to 3 of 3

Thread: Parameterized URL Problem

  1. #1
    Member
    Join Date
    Feb 2001
    Location
    UK
    Posts
    76

    Parameterized URL Problem

    Does anyone know how dates are handled in a Parameterized URL?

    I'm calling a custom fix inspect form using a parameterized URL that has a an ER select statement for the F95921 table for the FRROLE, TOROLE and EFFDATE primary key. I知 sending a date (EFFFDATE) as a parameter in Julian date format (I知 sending the value 116287) but I知 getting the following errors in the jas.log:-

    10 Jun 2019 09:57:04,320 [SEVERE] NEALS - [BASE] com.jdedwards.database.base.JDBException: [INCORRECT_CONVERSION_TO_DBFORMAT] Formatting error on converting EFFDATE of Everest type 11 from OneWorld to database format. java.lang.IllegalArgumentException
    10 Jun 2019 09:57:04,320 [SEVERE] NEALS - [BASE] com.jdedwards.database.base.JDBException: [INCORRECT_CONVERSION_TO_DBFORMAT] Formatting error on converting EFFDATE of Everest type 11 from OneWorld to database format. com.jdedwards.database.base.JDBException: [INCORRECT_CONVERSION_TO_DBFORMAT] Formatting error on converting EFFDATE of Everest type 11 from OneWorld to database format.

    The parameterized URL works if I don't include the date, but the date is required to make the record unique.

    Should dates be sent in Julian date format or another format or can't I use dates in a parameterized URL?

    Thanks,

    Neal
    Neal Scarr
    QSoftware Global Limited

    XE SP.24 to E9.2 TR 9.2.0.2

  2. #2
    Member
    Join Date
    Mar 2009
    Location
    Phoenix, AZ USA
    Posts
    54
    Neal,
    The parameters should be entered the same way as if you were typing them directly into the target form. For example, your jdedate of 116287 should work if put in the parameter list as 10/13/2016, if you're using the USA date format of MM/DD/YYYY.

    Good Luck!
    Regards,
    Kim Schmidt

    - E1 9.1.4 ,TR 9.2.2 , iSeries, DB2
    - formerly Xe, 8.0, SQL Server, Oracle

  3. #3
    Member
    Join Date
    Feb 2001
    Location
    UK
    Posts
    76
    Hi Kim,

    Your suggestion worked! Many thanks.

    Neal
    Neal Scarr
    QSoftware Global Limited

    XE SP.24 to E9.2 TR 9.2.0.2

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwardsョ & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwardsョ & Company and, or Oracle.