Announcement

Collapse
No announcement yet.

Creating a dropbox to populate data from table.

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

  • Creating a dropbox to populate data from table.

    Hello,.
    using scriptCase how to do that part ? like populating dropdown or such stuffs using db table records ?

    Also, how to achieve this :

    use select country -> he get states related to that country -> then he get related city based on state.

    ANy help will be thankful !

    i have seen a sample here, but have no idea how to get that working in ScriptCase.

    sample : http://www.scriptcase.net/scriptcase...-a-link-table/

    Also, if anyone can help over data concatenation ; like fetch records from table 1 and then update the all form fields in table 2 ??

    i have tried that using N:N relation stuff.. that works .. but i also get the table like you see in above example (object Double stuff).

    like this :

    http://i1351.photobucket.com/albums/...ps8934fb36.png
    Attached Files
    Last edited by rasttech990; 04-18-2013, 04:02 AM. Reason: pic change.

  • #2
    To create a dropbox you need to have a field which you set of type 'select'. Then in the lookup part you put the sql statment to populate your data.
    To make a dropbox dependent on another field then you go to this other field. In the section 'ajax processing' you will have the ability to select the fields to refresh when this value changes. You need to apply this fieldvalue to the sql using {myfield} construction.
    To fetch records from table 1 and update all the fields in table 2 you can apply your own php code to a button, an event or something like that.
    N:N field that is shown can be hidden in the field properties.
    Hope this helps.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development
    www.scriptcase.eu / www.scriptcase.nl

    Comment


    • #3
      Originally posted by aducom View Post
      To create a dropbox you need to have a field which you set of type 'select'. Then in the lookup part you put the sql statment to populate your data.
      To make a dropbox dependent on another field then you go to this other field. In the section 'ajax processing' you will have the ability to select the fields to refresh when this value changes. You need to apply this fieldvalue to the sql using {myfield} construction.
      To fetch records from table 1 and update all the fields in table 2 you can apply your own php code to a button, an event or something like that.
      N:N field that is shown can be hidden in the field properties.
      Hope this helps.

      Thanks a lot...

      But have bit issue.. firstly normal sql queries dont work over the scriptcase in my case..

      Can you give bit more explanation over this.

      2nd, how to do that please explain a more, as i want to add same feature to the save button instead of something done in separate.

      Comment


      • #4
        *** But have bit issue.. firstly normal sql queries dont work over the scriptcase in my case.. *** what do you mean? If sql is not working, nothing will be working
        2nd. Please look at the available video's first. This issue is very well explained in one of the movies.
        Albert Drent
        aducom software netherlands
        scriptcase partner, reseller, support and (turn-key) development
        www.scriptcase.eu / www.scriptcase.nl

        Comment


        • #5
          Originally posted by aducom View Post
          *** But have bit issue.. firstly normal sql queries dont work over the scriptcase in my case.. *** what do you mean? If sql is not working, nothing will be working
          2nd. Please look at the available video's first. This issue is very well explained in one of the movies.

          video seriously ? can you link me to which one video contain this info ?

          Comment


          • #6
            i am getting this error while making dropdown for country table only:

            Fatal error: Cannot redeclare form_website_01data_apl::$country in C:\Program Files (x86)\NetMake\v7\wwwroot\scriptcase\app\main_pro\f orm_website_01data\form_website_01data_apl.php on line 73

            :\ Is there any video tutorial that has seriously explained that.

            Comment


            • #7
              mmm, afaik it's the second sample on http://www.scriptcase.net/watch-scri...video-courses/
              Problem is that I couln't open them on ff nor ie. Somehow there's something broken? ANybody?:
              Albert Drent
              aducom software netherlands
              scriptcase partner, reseller, support and (turn-key) development
              www.scriptcase.eu / www.scriptcase.nl

              Comment


              • #8
                From the website I see there's a webinar tonight. This will give insight info on the product. Something to consider imho. see http://www.scriptcase.net/scriptcase-workshop-online/
                Albert Drent
                aducom software netherlands
                scriptcase partner, reseller, support and (turn-key) development
                www.scriptcase.eu / www.scriptcase.nl

                Comment


                • #9
                  i am going to watch video 2 sample. Hope that helps..

                  Also, can i use more than 1 relationship in 1 project ?

                  Comment


                  • #10
                    I'm not sure what you mean. You can have as many lookup's as you need. If you mean master-detail form you can show only one relation at a time afaik. Never tried to nest this as the form generally messes up with so much info on one screen. Are you able to see the video's from the webside? I cannot...
                    Albert Drent
                    aducom software netherlands
                    scriptcase partner, reseller, support and (turn-key) development
                    www.scriptcase.eu / www.scriptcase.nl

                    Comment


                    • #11
                      i Downloaded the video will check it out in sometime.

                      Also, i will soon update this thread with errors screenshots and issues.

                      Comment

                      Working...
                      X