Page 4 of 5 FirstFirst 12345 LastLast
Results 31 to 40 of 48

Thread: Has anybody used the new data sources tool?

  1. #31

    Default More delaying tactics by NOF

    Hi

    It's been a week since I sent an extract of the failing component to NOF support and I've had nothing back.

    Given that this is the component that many people want to work - being able to connect to an external database dynamically - I'm amazed that their develoers are not falling over themselves to find out what is wrong with it.

    I asked before, but is there anybody else using NOF that is being frustrated by this component?

    Ronnie

  2. #32

    Default

    Don't hold you breath on getting stability with the database components. I have used them since they were introduced and have found that they work well when you have them setup and then lo and behold the properties etc disappear occasionally when you open the page for editing. Closing down and restarting works sometimes re-optimising works other times. I have learned to live with it.

    There are several things like this in NOF. I like to call it NOF QUIRKS mode

    Your point about support responses .... don't hold your breath. They rarely visit here now. (I say they ... assuming there is more than one). Adam seems to be the only visible support person.
    NOF 2013: (AU1)......Windows 7 Ultimate Version 6.1 (Build 7601:SP1)
    Mac OSX 10.8.3.....Parallels Desktop 8 (8.0.18483)
    iMac 27" 2.7 GHz Intel Core 2 i5.....12Gb 1333 Mhz DDR3

  3. #33

    Default

    Hi Ritch

    The data sources panel was introduced in NOF 11 (it wasn't in NOF 10 anyway so I'm assuming NOF 11 had it). Is this what you use or is your comment referring to the database components where you have a choice of SQL environment (ASP, ASP.NET, Coldfusion, PHP) that have been around since I started using NOF (NOF 8)

    Would be interested to know as if it's the former, you're the only person I've met who has been able to get it to work.

    Thanks

    Ronnie

  4. #34
    Senior Member Thomas Frei-Herrmann's Avatar
    Join Date
    Apr 2010
    Location
    Berlin, Germany
    Posts
    998

    Default

    ... where is the problem - it works

    http://www.tommyherrmanndesign.com/n...nquelle-MySQL/
    Tommy

    Administrator at the German NOF-Forum

    NOF-Tutorials.com | German NOF-Forum | Overview of my tutorials | Facebook

  5. #35

    Default

    Hi

    You're back from your travels. Hope it was a good trip.

    If you look at your comment on reply #13, you confirm that some of the NOF buttons on the toolbar do not work. On your reply #18, you show a work around that you have tried to use, using a different button. And lastly, on looking at the HTML code on your test site, there is no evidence of "Bindings" that are necessary for the reload button to work(see below), and there is no evidence of the reload script which I have also copied below.

    I have a test NOF site and a test SQL and Web server. I am happy to send you the template of the data sources site so that you can make a comparison.

    But to be clear, what you are doing does not use the data sources toolbar RELOAD button, the third button from the right on the toolbar.

    But please prove me wrong. If you di, I'd be very happy.

    Ronnie


    BINDINGS SCRIPT
    <script type="text/javascript">
    var NOFDataSourceBindingsPath = 'binding10884.xml.php';
    var NOFDataSourceConnectionsPath = 'connection.xml.php';
    var NOFDataSourceActionPath = 'actions10884.xml.php';
    var NOFGatewayPath = '../scripts/datasource/php-gw.php';
    var NOFAjaxLoadingPicture = '../scripts/datasource/loading.gif';
    var NOFDataSourceRootPath = '../';
    var NOFDataSourceLocale = 'en';
    var NOFDataSourcePublishMode = 'Debug';

    NOF_ajaxVariables.setAjaxGateway(NOFGatewayPath);
    NOF_ajaxVariables.loadUrlVars();
    NOF_ajaxVariables.loadServerVars();
    NOF_ajaxVariables.loadEnvVars();
    NOF_ajaxVariables.loadCookieVars();
    </script>
    <script type="text/javascript">
    grid_LayoutRegion1 = new NOF_grid('LayoutRegion1');
    grid_LayoutRegion1.ajaxRequestFile = NOFGatewayPath;
    grid_LayoutRegion1.containerId = 'NOF11267LayoutRegion1';
    grid_LayoutRegion1.instanceName = 'grid_LayoutRegion1';
    grid_LayoutRegion1.iteratorNode = 'NOF11267LayoutRegion1';
    grid_LayoutRegion1.sql_id = '11267';
    grid_LayoutRegion1.recPerPage = -1;
    grid_LayoutRegion1.NOF_binding_path = NOFDataSourceBindingsPath;
    grid_LayoutRegion1.NOF_connection_path = NOFDataSourceConnectionsPath;
    grid_LayoutRegion1.NOF_root_path = NOFDataSourceRootPath;
    grid_LayoutRegion1.NOF_ActionPath = NOFDataSourceActionPath;
    grid_LayoutRegion1.init();
    grid_LayoutRegion1.addChildIterator();
    </script>

    END BINDINGS SCRIPT

    RELOAD SCRIPT
    <script type="text/javascript">
    function F_doLoaded() {
    document.main = new F_cMain();
    document.objectModel = new Object();
    F_OM('Layout','LayoutLYR', 'doc', '', new Array());
    F_OM('LayoutRegion1' , 'LayoutRegion1LYR', 'lyr', 'Layout',null,'',0);

    F_OM('LayoutRegion2' , 'LayoutRegion2LYR', 'lyr', 'Layout',null,'',0);

    F_OM('FormsEditField1' , '', 'tfd', 'LayoutRegion2',new Array(
    'Change','LayoutRegion1','DataSourceReloadData','grid_LayoutRegion1.action("int","11271","FormsE ditField1=" + NOF_ajaxForm.getElementValue( "LayoutRegion2FORM","FormsEditField1")+"");',0),'L ayoutRegion2FORM',0,'FormsEditField1');

    F_OM('NavigationBar1' , 'NavigationBar1LYR', 'nav', 'Layout',null,'',0);

    F_OM('NavigationBar2' , 'NavigationBar2LYR', 'nav', 'Layout',null,'',0);

    F_pageLoaded('Layout');
    }

    </script>

    END RELOAD SCRIPT

  6. #36
    Senior Member Thomas Frei-Herrmann's Avatar
    Join Date
    Apr 2010
    Location
    Berlin, Germany
    Posts
    998
    Tommy

    Administrator at the German NOF-Forum

    NOF-Tutorials.com | German NOF-Forum | Overview of my tutorials | Facebook

  7. #37

    Default

    Hi

    I've seen the work around that you do and I'm sure for technical people, creating your own is fine. But NOF is sold to non tech people like me and I, like others, rely on the buttons and the wizards where a user can fill in the blanks.

    With regard to Ajax, I remember you stating before that it does not work.

    However, what does work is the URL variable function. And, when a data source is attached to, say, a combo box on a form, it works. For example, I have a country combo box on a contact form and, rather than populate it by typing in many different countries one by one, I have connected to a MySQL Db Locations table and have populated the combo box with its contents. When the page loads, NOF runs and the combo box shows all the countries in the locations table.

    So, I think the FORM variable of the data source that the Reload button relies on is not capturing the user input when the user completes the form on a loaded page. In short, an empty variable is being passed to the MySQL Db and so the data returned is not correct.

    But what do I know - I'm just a beginner at this :-)

    Ronnie

  8. #38

    Default

    Hi

    So, another week goes by and nothing from NOF support except that they are so busy working on the first update for the German version of the software, they can't fix the data sources problem.

    Perhaps they will include a fix for the data sources in that version in which case, it's goodbye Britain, hello Berlin!

    auf wiedersehen :-)

    Ronnie

  9. #39

    Default

    Hi

    Just an update - there isn't one. Not a word from the support team at NOF

    Ho hum.

    Ronnie

  10. #40

    Default

    Hi

    Still nothing, not even "we're working on it" from the support team.

    Ronnie

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •