Search results

  1. P

    Answered Lock Table Overflow, Increase -l On Server (915)

    I have a program reading data from a JSON response. The data is initially read into temp-tables and after the JSON has been successfully processed I copy the temp-table data to the database. One of the temp-tables sometimes is getting 7,600+ rows of data which causes the copy from temp-table to...
  2. P

    Question The Character Encoding Of The Html Document Was Not Declared.

    Thank you for the suggestion. Yes the page is created with webspeed. I did have the content type set to output-content-type("text/html":U). I went ahead and updated it to output-content-type("text/html~;charset=utf-8":U). which did help because the error reported earlier no longer comes...
  3. P

    Question The Character Encoding Of The Html Document Was Not Declared.

    I have a website that redirects a user to a external host for payment processing. When the user is returned to my website depending on the results of the payment processing I need to redirect the user to a final webpage with POST method so their order can be completed. I call the javascript code...
  4. P

    Question Responding To Post Notification

    Thank you for the suggestions. I have implemented change. Vendor does not provide a way to test this specific item so I will not know until code has been deployed .
  5. P

    Question Responding To Post Notification

    I have a WebSpeed application that is receiving a POST notification from a vendor that includes an XML document. When the WebSpeed page receives the post the vendor requires a respond back with the word 'OK' as acknowledgement that notification was successfully received. How would I handle such...
  6. P

    Error Load Xml Error: Unsupported Protocal In Url

    I am attempting to process an XML document from a vendor using the LOAD statement as below. ghDocument:LOAD("FILE":u, "c:\sample.xml", FALSE) NO-ERROR. However I am getting the following error X-NODEREF or X-DOCUMENT LOAD got an error: FATAL ERROR: file 'c:\sample.xml', line '1', column '0'...
  7. P

    Answered check for existance of Json value before reading to temp-table

    Quick update. Adding the NO-ERROR worked for now. The reason I asked about this option is because the vendor I am working sometimes nests the json in a way that READ-JSON is not able to support so I wanted to have the information for those cases. Where I can I always use the READ-JSON. I will...
  8. P

    Answered check for existance of Json value before reading to temp-table

    I am reading data from a json file into a temp-table provided by an external vendor. Some fields on the json file are not included every time. How do I check if a field exists on the json file before I attempt to read it. A simplified version of my code looks as follows USING...
  9. P

    Question Using write-json to generate json from prodataset

    I am developing a program to generate json from a dataset that includes several nested temp-tables. When I write the output, the nested temp-tables are written as array objects - something like -> dataLoader": [{"url": "data/266m.csv", "format": "csv", ...}]. Larger json example is below {...
  10. P

    Question Error passing JSON: expected bracket, but found brace (15358)

    Hello Mollyfud, I used the information you provided earlier and put together a program that looks to be working. As it is the first time I written this kind of code they are probably ways to improve the code but for now it looks to be getting the job done. On a high level my latest code looks as...
  11. P

    Question Error passing JSON: expected bracket, but found brace (15358)

    Hi Mollyfud, Thank you for the examples especially the one loading data to a temp-table. Gives me a good starting point. One quick question - how would I go about accessing the nested arrays such as the images and descriptions in the JsonObject?
  12. P

    Question Error passing JSON: expected bracket, but found brace (15358)

    I need to write a progress program to read data from a JSON file with nested information into a dataset in Progress. I keep getting an error 'Error passing JSON: expected bracket, but found brace (15358)'. How can I update the program to get past this error. I don't have control over the...
  13. P

    Answered Error reading JSON data into a temp-table

    -cpinternal UTF-8 -cpstream UTF-8 worked for the files I needed to process. I was able to load all files into temp-tables successful. Thank you for the suggestions.
  14. P

    Answered Error reading JSON data into a temp-table

    The session codepage parameters on my machine are set to -cpinternal ISO8859-1 & -cpstream ISO8859-1 I started session with prowin32 -cpinternal UTF-8 -cpstream UTF-8 and the json files without error under on that session.
  15. P

    Answered Error reading JSON data into a temp-table

    I have a simple program to read data from a json file into progress temp-tables. Program works well most of the time, but I am running into some data that causes an error as follows 'Unable to convert JSON to native data type for field 'name' in temp-table 'ttregions'. (15363) Sample data...
  16. P

    Adding Repeating information to HTML page

    Yes this code would be running on WebSpeed. No there is only one domain. Also the example I provided shows country locations but that is just a simplified version for the code. It is possible for the phone number to change based on other factors such as client balance. There is only one...
  17. P

    Adding Repeating information to HTML page

    I need to add footer information to several html pages that includes the contact details. The details can vary by customers location and there is a table that contains the information for each location. I am looking for a solution similar to an include file, but that can works on html. The...
  18. P

    Question Receive XML notification on webpage

    Not yet. I got pulled into something else but it's still on my list of items to get done. Hoping to work on it later this week.
  19. P

    Question Receive XML notification on webpage

    Thank you for the sample code. I will give this a try and let you know the results.
  20. P

    Question Receive XML notification on webpage

    I found and tried the code below but it does not look to be working. I have an installation of OE 11.1 on Windows 2008 Server. Also the vendor will only sent response to a secure HTTPS URL. {src/web/method/cgidefs.i} define variable XMLDocHandle as handle no-undo. define variable...
Back
Top