hello, everybody!
is it possible to create a criteria for the statement below???
SELECT p.statecode AS Vater, s.statecode AS Nachfolger
FROM processstate p, processstate s
WHERE s.lft BETWEEN p.lft AND p.rgt
AND s.statecode = 'D225'
ORDER BY p.lft;
i have problems to assign one table two
Jason Harrelson wrote:
I am new to Torque. I have been successful at creating my DB and classes.
Everything works correctly, excluding the primary key incrementing, or
populating at all. When I add a record to my account table, I get a 0 in
the primary key column. A second record added also
Hi!
I encoded a menu system in a database table. Each element has an ID, a Caption
and the ParentID (the ID of the parent element in the menu item, it is an ID of
an other record form the current table). Now I want to Join the table with
him-self to make a list with the caption of the element
Hello !
Im using torque 3.1 and wonder if it's possible to have a
schema name prefixed to the tablename.
The generated sql should look like this
select COL1 from creator.MYTABLE where ...
When I generated my objectmodel I specified
torque.database.schema = creator
in my build property file.
Have you looked at this?
http://wiki.apache.org/db-torque/FrequentlyAskedQuestions#head-9af89d84f
b1c39b1ef310505f7c6e3f4e53976bf
MG
-Original Message-
From: Dressler,Erik(externe MA) [mailto:[EMAIL PROTECTED]
Sent: Friday, June 10, 2005 10:55 AM
To: 'Apache Torque Users List'
Subject: