output of db back in drop down list

Archive: output of db back in drop down list

marcp
17th January 2006 10:36 UTC

output of db back in drop down list
I'm working on an application installer that needs to install itself in a database.

AT a certain stage I would like to feed data from the database into a drop down to let the user make a selection for the next step.

What is the general way to do that. Let a query run and write entries for dropdown in file and then read that to set combo entries or is there a better way to do this?

kichik
17th January 2006 15:03 UTC

There's no better way I can think of.

iceman_k
18th January 2006 14:03 UTC

Re: output of db back in drop down list

Originally posted by marcp
I'm working on an application installer that needs to install itself in a database.

AT a certain stage I would like to feed data from the database into a drop down to let the user make a selection for the next step.

What is the general way to do that. Let a query run and write entries for dropdown in file and then read that to set combo entries or is there a better way to do this?

That's how I do it.
Alternatively you can write a plugin which can do the database query for you.

marcp
18th January 2006 14:58 UTC

I'm currently run a query, spool output to $TEMP in out file and read it back into installer. Work's fine for me...

Currently I have enough troubles glueing everything together, so I leave the plugin part to an experienced user :)

Till now I end up with two new problems after solving one. But I look at it the bright side it keeps me busy (lol) :D :D