- ANNOUNCE: TinyTable Beta 1
ANNOUNCING TinyTables Beta 1 (0.7.3) TinyTable is a product designed to manage a small amount of tabular data. It's intended to fill the gap between a Tabula or an Z SQL Methods accessed SQL table, which are overkill for many tasks, and folder token properties, which allow only a single "column". TinyTable also makes it possible to look up an item within the list, or to return a subset of the list rows where columns equal particular values. Data within a TinyTable is directly editable within Zope, presented as rows of delimited text. The delimited character can be chosen to suit the data being used. Columns may be strings, ints, floats, or dates. TinyTable supports pluggable brains, much like Z SQL Methods do. This is the first Beta of TinyTable. It's believed to be stable, and the internal data format isn't expected to change incompatably before the final release. However, it's a Beta -- no guarantees. This version is "read-only", in the sense that the data can only be changed all at once, using the management interface. Future versions will add methods for setting individual rows and fields within a row, deleting rows, adding rows, etc. Have fun, and please report any problems you encounter!
I am pretty impressed with the TinyTable product however I can't seem to work out how to search using a variable. I'm trying to a tinytable to store a lookup table to convert integers from a database query into the description of that product. The following works but I can't work out how to put a variable in place of the '3'. Can this be done? Am I missing something obvious? <!--#in "product_categories('3')"--> <!--#var name --> <!--#/in--> thanks, Mike At 12:32 11/01/99 -0600, you wrote:
ANNOUNCING TinyTables Beta 1 (0.7.3)
TinyTable is a product designed to manage a small amount of tabular data.
<snip>
TinyTable also makes it possible to look up an item within the list, or to return a subset of the list rows where columns equal particular values.
The answer is simple: <!--#in "product_categories(cid)"--> <!--#var name --> <!--#/in--> The reason it wasn't working for me was that I had defined cid as a folder property of type int. (I do this so I don't have to enter the same value into a test form repeatedly) It needed to be a string. Hmm... these little problems always get me on a Sunday morning... Mike At 11:40 24/01/99 +1100, you wrote:
I am pretty impressed with the TinyTable product however I can't seem to work out how to search using a variable.
I'm trying to a tinytable to store a lookup table to convert integers from a database query into the description of that product.
The following works but I can't work out how to put a variable in place of the '3'. Can this be done? Am I missing something obvious?
<!--#in "product_categories('3')"--> <!--#var name --> <!--#/in-->
thanks,
Mike
At 12:32 11/01/99 -0600, you wrote:
ANNOUNCING TinyTables Beta 1 (0.7.3)
TinyTable is a product designed to manage a small amount of tabular data.
<snip>
TinyTable also makes it possible to look up an item within the list, or to return a subset of the list rows where columns equal particular values.
Michael Bailey wrote: Well, you already figured out the first part :^)
The reason it wasn't working for me was that I had defined cid as a folder property of type int. (I do this so I don't have to enter the same value into a test form repeatedly)
It needed to be a string.
If the column you're matching against is of string type, yes. The comparison is done using regular python rules, so 3 and '3' are different. If that column will contain only numeric id's, you can append ":int" to the name and then the values will be stored as integers. Column names can also be suffixed with ":float", ":date", and ":long" to get values of those other types.
participants (2)
-
Michael Bailey -
Ty Sarna