On Mon, 16 Dec 2002 16:02, you wrote: > I just found out that Velocity does not like the VARIABLE being an > FORIEGN KEY. I comment out the foriegn key part from the Schema > file, and it worked (for both VARCHAR and INT, but not FLOAT).
Velocity does not support floating point numbers. You will need to use a MathTool (from jakarta-velocity-tools CVS) for this: http://www.teamup.com/jakarta-velocity-tools/tools/docs/MathTool.html > But this has just defeated my whole purpose, I want to display items > in TABLE 2 when it matches the ID in TABLE 1, without FORIEGN key, > how do I join them up? If you have a look at your BaseInvoiceItem Torque object, you will see that your primary keys are represented by *Key objects (such as NumberKey, StringKey, ObjectKey...). You can't treat them like primitives or java.lang objects. Try something like this: #set ($id = "$entry.Id") #if ($id == "13") do stuff here... #end This converts the NumberKey to a String and uses String comparison. There might be a better way to do this... Regards, -- Rodney -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
