Try this.getPeer().doSelect(criteria); Gunter M.
> -----Urspr�ngliche Nachricht----- > Von: Dieter Engelhardt [mailto:[EMAIL PROTECTED]] > Gesendet: Montag, 9. Dezember 2002 16:11 > An: Turbine Users List > Betreff: AW: select * from ... > > > I still stick in the same question. > > What i've done is this: > > public List getOrt(int iOrt_ID) throws Exception > { > Criteria criteria = new Criteria(); > criteria.add(this.getPeer().ORT_ID, iOrt_ID); > return = BasePeer.doSelect(criteria); > } > > What i get is: > org.apache.torque.TorqueException: Syntax error or access > violation: You have an error in your SQL syntax near 'FROM > TB_ORT WHERE TB_ORT.ORT_ID=1070' at line 1 > > When i debug i find the SQL-Statment "select form ta_ort ....." > > Obviously the * is missing. > > If i add each Column with criteria.addSelectColumn() it works fine. > > Is there a Methode to select all Columns? I bet that this is posible. > > Thanx for your help. > > -----Urspr�ngliche Nachricht----- > Von: Gaasch, Derek [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 7. Dezember 2002 01:28 > An: 'Turbine Users List' > Betreff: RE: select * from ... > > > 2.2 rc1 > > are you sure your OM files & tables are as you expect them to > be? Does the problem only happen with a join (i.e. can you do > a simple select with an empty criteria object? Or with just a > criteria added --like a primary key > id?) > > -----Original Message----- > From: Dieter Engelhardt [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 5:22 PM > To: Turbine Users List > Subject: AW: select * from ... > > Thats not the problem because if i put al my columes into the > criteria, ir works. > > Like if i ad a statement it works fine > > Criteria criteria = new Criteria(); > criteria.addSelectColumn(this.getPeer().SomeColumn); > List v = this.getPeer().doSelect(criteria); > > What version of Turbin do you user? > > > -----Urspr�ngliche Nachricht----- > Von: Gaasch, Derek [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 7. Dezember 2002 01:15 > An: 'Turbine Users List' > Betreff: RE: select * from ... > > > Put the id in quotes? > > -----Original Message----- > From: Dieter Engelhardt [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 5:14 PM > To: Turbine Users List > Subject: AW: select * from ... > > The problem is described below. > I get an exception. > > Im using TDK 2.2 rc1. > > -----Urspr�ngliche Nachricht----- > Von: Gaasch, Derek [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 7. Dezember 2002 01:07 > An: 'Turbine Users List' > Betreff: RE: select * from ... > > > And the problem is? > > Criteria c = new Criteria(); > c.add(SomePeer.ID,"1155"); > SomePeer.doSelect (c); > > http://jakarta.apache.org/turbine/torque/criteria-howto.html > > > -D > > > -----Original Message----- > From: Dieter Engelhardt [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 4:40 PM > To: Turbine Users List > Subject: AW: select * from ... > > This might work, but i need to add some extra criteria > like select * from sometab where id = id_value > > -----Urspr�ngliche Nachricht----- > Von: Gaasch, Derek [mailto:[EMAIL PROTECTED]] > Gesendet: Samstag, 7. Dezember 2002 00:36 > An: 'Turbine Users List' > Betreff: RE: select * from ... > > > Just use an empty Criteria object. > > > SomePeer.doSelect (new Criteria()) > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Friday, December 06, 2002 3:51 PM > To: Jakarta-Turbine > Subject: select * from ... > > How do i accomplish a simple select * from sometable without > specifing every selectColumn. > > Example: > > Criteria criteria = new Criteria(); > criteria.addJoin(TbOrtPeer.OLP_ID, TbOrtLookupPeer.OLP_ID); > criteria.add(this.getPeer().ORT_ID, iOrt_ID); List v = > this.getPeer().doSelect(criteria); > > i'll get an exception "Syxntaxerror in SQL-Statement" > > It looks like the statement misses the * as a wildcard for > all columns. > > If i try add criteria.addSelectColumn("*"); > > I get an exception "Malformed column name in Criteria select: > '*' is not of the form 'table.column'" > > What's wrong? > How can i do it right? > > Thanx for your help > Dieter > > > > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > > > -- > To unsubscribe, e-mail: > <mailto:turbine-user-> [EMAIL PROTECTED]> > For > additional commands, > e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
