• Can anyone get IBM/Lotus Dev's E-commerce DB to work?

    By Donald A Russell 2 decades ago

    Can anyone get Lotus Dev's E-commerce DB working?

    >> http://www-128.ibm.com/developerworks/lotus/library/ls-e_commerce_3/index.html

    I cannot get it working and Lotus does not support it. The BP that designed it is no longer available!



    Or does anyone have a good E-commerce DB?

    Please let me know or send to TRHS@Comcast.net

    • Yep

      By Dakota Pup 2 decades ago

      Yeah, I got that Library dB working, now granted it's been ohhh, ummm, a good 5 years ago. I'm not sure what version I was even running, though I'm quite sure it was R5. I'd be happy to play with it again and see if I can recall what made it work for me if anybody's interested.

    • Well Found 1 Bug

      By Dakota Pup 2 decades ago

      The first issue Ive found (and somebody feel free to correct me if I'm wrong, I've been away from Lotus for quite some time) is in the Catalog By Category view, Untitled Column value from the db reads:



      unid := @Text(@DocumentUniqueID);

      db := @ReplaceSubstring(@Subset(@DbName; -1); "\"; "/");

      url := "/" + db + "/CatalogByCategory/" + unid + "!OpenDocument";

      blank := "";

      brblank := "
      " + blank + blank;

      strAuthorsDisplay := @Implode (AuthorsDisplay; brblank);



      blank + "" + Title + "" + brblank + "" + strAuthorsDisplay + brblank + "Available: " + @If (Available = "1"; "Now"; AvailableWhen) + " " + AvailableMedia + "

      "



      and Should read



      unid := @Text(@DocumentUniqueID);

      db := @ReplaceSubstring(@Subset(@DbName; -1); "\"; "/");

      url := "/" + db + "/CatalogByCategory/" + unid + "?OpenDocument";

      blank := "";

      brblank := "
      " + blank + blank;

      strAuthorsDisplay := @Implode (AuthorsDisplay; brblank);



      blank + "" + Title + "" + brblank + "" + strAuthorsDisplay + brblank + "Available: " + @If (Available = "1"; "Now"; AvailableWhen) + " " + AvailableMedia + "

      "



      Notice the Url string… the ! is replaced with a ? This seems to allow the document to open properly when viewing in a browser.



      Hope this helps somebody out there!