>
> pk = self.Form.getBizobj("rechnung").getPK()
> sql = """SELECT rechnung_position.name, preis, anzahl
> FROM rechnung
> INNER JOIN rechnung_position ON rechnung.id=rechnung_id
> WHERE rechnung.id=%s
> ORDER BY position"""
> tmpCursor.execute(sql, (pk, ))
>
> See if that works better for you.
>
First thank you for your super fast answer, unfortunately that didn't change
anything!
Still the same error when I call:
ds_artikel = tmpCursor.getDataSet()
Could there be a problem with my table-layout or its interpretation of dabo?
Here the SQL-Snippet of the table:
CREATE TABLE IF NOT EXISTS `rechnung_position` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`rechnung_id` int(11) NOT NULL,
`name` varchar(300) NOT NULL,
`preis` float NOT NULL,
`anzahl` int(11) NOT NULL,
`position` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `rchnung_id` (`rechnung_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1665 ;
--
-- Daten für Tabelle `rechnung_position`
--
INSERT INTO `rechnung_position` (`id`, `rechnung_id`, `name`, `preis`,
`anzahl`, `position`) VALUES
(9, 1, 'Fassung', 130, 1, 0),
(2, 0, 'test2', 0, 2, 0),
(10, 2, 'Spray', 3, 1, 0),
(8, 1, 'Gläser', 79, 2, 0),
...
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/1367337062.5128.36.camel@max
