Hello. As many of you know, Mike Heins is a walking wealth of knowledge when it comes to Interchange, Perl, and database access and control. I have decided to try and assemble tips that may be helpful to our clients on this and upcoming pages. At some point I will index and organize them. But first I will assemble them as they become available to me. Some will simply be quick references to functions or things that are little known about Interchange, and may be difficult if not impossible to find in the Documentation. So without further ado....
|Date Tip Added||Master Category||Title||Description|
|20050107||Tags||Display meta label for column||
Ever need to display the meta label for a column in your interchange page? Use the display tag, heres how:
[display table=table column=column key=key label=1 type=display]
|20060109||Database||Database Reserved Words||
Reserved words - Postgres, as well as many other SQL databases have many "reserved words", which are never allowed as identifiers. In other words you cannot use them for column names! In addition, another little known fact about Interchange is that "ID" is a type of "interchange reserved word" and also cannot be used to name a column. Interchange will generally not display a very informative error message when you try to create a new table and use a reserved word for a column name, and often error out with the error :"table <yourtablename> failed: list_fields execute on <yourtablename>. So be familiar with the reserved names, you can find a list here
http://www.postgresql.org/docs/7.2/interactive/sql-keywords-appendix.html (one that will not work with mysql is "group")
|20050107||Catalog Configuration||Multiple Error Log Locations||
Did you know that you can customize which errors from Interchange land in the error log, and even direct specific errors to specific locations? Suppose you are getting multiple "Attempt to order missing product code:" errors, and you want to redirect them from the error.log to a file "<catroot>/logs/missing_product.log" so that you can
a. Make the error log more efficient and readable
b. Isolate the missing product information for further and easier review.
Just add this to the catalog.cfg:
ErrorDestination "Attempt to order missing product code: %s" logs/missing_product.log
|20060325||Tags||Usertag creation tips||
This is an excerpt from an email Kevin Walsh sent to the userlist on March 25, 2006. It is an excellent description of how usertags can be created properly. Appended to the end of the message is a comment added by Mike in the same thread.
If you have a UserTag like this:Kevins reply was prompted by a question, and Mikes followup addendum answered a few more questions:
[foobar foo="aaa" bar="bbb" baz="ccc"] Tag body [/foobar]
Is the variable $body specific ?
In other words could $Body or $MyStuff be used in place $body ?
|20090306||General||Why does MSIE cache my pages?||
FAQ: Why does MSIE cache my pages?