Digital Workshop

Dear all,

I've looked through quite a few previous postings about populating listboxes from a database and copied and pasted various scripts, none of which seem to work, even after adapting the variable names (both ways).

The first listbox I manually populate with 5 names which goes into a variable called Name. The second list box is supposed to be populated from whichever 'Name' is selected. I tried copying the cricket example from the forum, but that didn't work either. Any one got any ideas as to the best posting for advice or does anyone have an example. Really hope I can get some advice as I seem to be getting nowhere.

Simon, welcome to the forum.

One of the basic tools of reading the database is 'next record' of course. Similarly, once you've got one line placed in the ListBox you want to go to the next line. Let us know how you are approaching that.

I presume when you say 'variable', you have one variable for listbox1 and are using some other variable once a Listbox_selection is made? Make sure you know the difference with diff vars: pub, page persistent, and page. Also, a 'local var' declared inside a script function... is not available outside the function.

Post in the 'Advanced' area if you want more help with scripting.
You could also post your .imp file here for others to examine and see what you're doing... not obvious currently.

Also, what database are you using?

Hi Lar,

I seem to have got round it by using the database in the cricket example and expanding that to fit my publication, so I must have been doing something wrong with the connection side of things.

Many thanks for the reply. If I get things to work, I'll put the example on here.

Regards