gettingstarted
[Top] [All Lists]

Dependable PopupMenus with MySQL problem

To: gettingstarted at lists dot realsoftware dot com
Subject: Dependable PopupMenus with MySQL problem
From: Scriptdude <scriptdude at gmail dot com>
Date: Thu, 28 Apr 2005 09:28:40 +0200
Delivered-to: gettingstarted at lists dot realsoftware dot com
Hi all,

I completed the Quickstart & User Guide and checked the Language Ref. before asking it here, but I can't seem to solve this.

I have 2 popupmenu's in my learning-curve-application. I want to populate them from my Car database with 2 tables (makes, models).

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?
_______________________________________________
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>

<Prev in Thread] Current Thread [Next in Thread>