Controls

Re: Cascading DDListboxes

adamrharding — Fri, 25 Jan 2008 22:41:19 GMT

Foobar, Hi

Could you not just write a web service as a straight link to your datasource, that would do the job perfectly well.

The DBXL tool is great and can be used for so much more.

Cheers

Re: Cascading DDListboxes

foobar — Wed, 23 Jan 2008 09:35:40 GMT

Thanks Clayfox, Just downloaded it so will spend the morning playing around with it. Regards

Re: Cascading DDListboxes

Clay Fox — Tue, 22 Jan 2008 21:44:44 GMT

Hey there. Welcome to the forum.

You are trying to create a dynamic query, which I have seen done with a hack but I am not sure it could work in a browser based form.

I have a better solution for you...Web Services.

Check out the Database Accelerator Package of Web Services.Qdabra Database Accelerator Suite Version 2.1 - Developer

With it, you can create dynamic SQL queries which is what you are after. Being able to actually query secondary data sources is a must with large tables as you have found. DBXL also includes the ability to submit data back to SQL via webservices.

It can all work with Browser Based forms and there are webparts and other add-ons available.

If you would like a demonstration let me know.

Cascading DDListboxes

foobar — Tue, 22 Jan 2008 18:32:33 GMT

Firstly I apologize if this has already been brought up - and if it has I would appreciate a link to said topic :)

My scenario:

I have a SQL database, containing 1 sizable table (550+ rows) with 5 columns. I have no problem adding this to a form and so on - and can implement what I want to achieve using multiple data connections (and manually editing the SQL). But this solution isn't very flexible if new rows with different data are added to the database.

What I want to achieve is when an item is selected from a drop-down listbox, a subsequent drop-down listbox is made visible to the user that filters the data from the database to fit to parameters set by the first drop-down listbox, and so on propagating to the subsequent list boxes.

eg.

//during initialization of the form

sql_query as string; //global var
sql_query = "SELECT col_name FROM tbl_name WHERE col1 = 'item'"

dropdown_list_changedevent(.....)

{

dim col_name as string; //holds what the column name is, will be different for each changedevent

col_name = "col1"

buildquery(e.NewValue, col_name)

//do something to make the query run

}

function buildquery( NewValue as XmlEventArgs, col_name as string)

{

sql_query += " AND " & col_name & " = '" & NewValue.ToString

}

It may also be worth mentioning this would be for use as a form from SharePoint, and therefore would have the reduced functionality associated with the browser-only forms.

Is such functionality possible or would I have to resort to using my previous solution?

Regards