Creating a dropbox to populate data from table.

Code Examples Form
#1

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-samples/php-form/update-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/p795/icode919/bug1_zps8934fb36.png

bug1.jpg

#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.

#3

[QUOTE=aducom;13828]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.[/QUOTE]

Thanks a lot…

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

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.

#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.

#5

[QUOTE=aducom;13831]*** 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.[/QUOTE]

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

#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\form_website_01data\form_website_01data_apl.php on line 73

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

#7

mmm, afaik it’s the second sample on http://www.scriptcase.net/watch-scriptcase-video-courses/
Problem is that I couln’t open them on ff nor ie. Somehow there’s something broken? ANybody?:

#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/

#9

i am going to watch video 2 sample. Hope that helps…

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

#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…

#11

i Downloaded the video will check it out in sometime.

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