Can we have one SQL query producing two CDBI classes

[prev] [thread] [next] [Date index for 2005/04/21]

Hi,

I've previously tried to do something of the form:

SingersClass->set_sql(
	both_persons_and_singers =3D> 'select * from PERSONS, SINGERS
	where SINGERS.PERSON_ID =3D PERSONS.ID'
);

My $sth =3D SingersClass->sql_both_persons_and_singers;
$sth->execute();

@persons =3D PersonsClass->sth_to_objects($sth);
@singers =3D SingesrClass->sth_to_objects($sth);

It didn't work, but I haven't got into the nitty-gritty of debugging it.


My only question is: would you expect it to work?=20

Thanks,

Ian

--
Dr Ian McDonald
Software Engineer, Interactive Drama & Entertainment
A300, 56-58 Wood Lane (CH), London W12 7SB
020 822 56162
ian.mcdonald@xxx.xx.xx / "Ian McDonald-ONLINE" (not "Ian MacDonald")



http://www.bbc.co.uk/

This e-mail (and any attachments) is confidential and may contain
personal views which are not the views of the BBC unless specifically
stated.
If you have received it in error, please delete it from your system.=20
Do not use, copy or disclose the information in any way nor act in
reliance on it and notify the sender immediately. Please note that the
BBC monitors e-mails sent or received.=20
Further communication will signify your consent to this.