List box populated via SQL connection string

[ChristJC]

Hello All

I am trying to find out the necessary code/syntax to populate a list box/drop down box when placed on a form inside an a5w page. I have read the help file but it appears to show how to populate for static choices only, I need to populate mine dynamically based on a SQL query. I have also scoured the message board but had no luck, I probably havent used the correct combination of search words. If anyone could point me in right direction I would greatly appreciate it.

Barring that, if anyone could tell me how to refer to a dialog component drop down list placed on a .a5w page using the correct code reference/syntax, that would do just as well

Cheers

Jason

[chadbrown]

Re: List box populated via SQL connection string

Hi on your dialog you should have a control which is a dropdown
go to 'choices' and pick 'dynamic' hopefully from there my picture should help.

[ChristJC]

Re: List box populated via SQL connection string

Hi Chad

Thanks for your reply. Absolutely, can definitely use that option, but I'm struggling to find how I can pass the chosen value from the list to the a5w page where the dialog has been inserted. In short, I am using the value to update an SQL table

tbl=table.open("attachment")
tbl.enter_begin()
tbl.Imagefilepath=fn
tbl.Date = NOW()-30
tbl.Caseid =
tbl.Text = attachtxt
tbl.enter_end(.t.)
tbl.close()

If you have any ideas, it would be greatly appreciated and eliminate the need for me to reach for the straight jacket. I have been researching this for ages

Cheers

Jason

[chadbrown]

Re: List box populated via SQL connection string

you could capture the current form controls value as a session variable then use it in youre insert statement.

Aftervalidate on the form would be something like this

dim session.vlistbox as c = ""
then later
session.vlistbox = currentformcontrols.vlistbox.value

then the session variable is set to the listbox value

[ChristJC]

Re: List box populated via SQL connection string

thanks for the suggestion. Still no luck, I must be doing something wrong. I should have mentioned that at the moment, the dialog component whilst sitting in an .a5w page, is inside a table just below the navigation menu. Should the dialog component be sitting into the form tags so the currentform code is recognised. I'm sure this is very simple to fix, very frustrating

Have attached a print screen

cheers

[chadbrown]

Re: List box populated via SQL connection string

Hi I am a little confused maybe its me but you should probably have a page that has just the dialog which has just the one control that is the dropdown list.
on submit have the page redirect to youre second page that has the rest of the info, or let me know what you are really trying to acheive on the page. sorry its a little vague.