>
> I created 2 MySQL DatabaseQuery controls:
>
> Query1:
> SELECT make, make_id FROM makes
>
> Query2:
> SELECT model, model_id FROM models WHERE make_id = '%1'
>
>
> Bindings:
>
> Query1 :
> Bind pmMakes with list data from Query1 results
>
> Query2:
> Bind Query2 parameter with string data from pmMakes RowTag
> Bind pmModels with list data from Query2 results
>
> The first PopupMenu gets populated with the Makes, but the
> second Popupmenu stays empty. I attached the bind from Query1
> to a EditField to see if the ID was returned and the
> EditField is nicely displaying the ID number, so the query works.
>
> Am I doing something wrong?
> _______________________________________________
Are you sure you want the % sign in there, and are you sure you want to bind
to the rowtag, and not something else? is make_id in the DB a numeric, and
you are passing in (in query 2) a string instead? I use mysql extensively,
but hate bindings with a passion, so never use them. Thus my questions may
be off base.
Mike
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|