[ic] [if type=date term=HELP]

[Marty Tennison]

>
> I'm trying to output a graphic on a mysql database with a contacts table.
>
> We auto data into the database certain records for our salesreps.
>
> In the 'updated' column we insert a record of 1 into said column.
>
> What I want to do is...
> When the sales rep views the result list and see's a graphic which
> represents "1" in the column. Then, they goto that row record which will
> automatically change the 'updated' column record to the date viewed
>
> My problem is trying to get the graphic to display.
>
> I've tried many different variation but I'm stumped...Is what I have is
>
> [if type=data term="contacts::updated" op="eq" compare=1]
> 	<IMG src="newcon.gif" ALT="new contact">
> [/if]
>
> Which, of course, displays nothing!!
>

To check for a true-false value you only need to specify the table, column
and key.  This is covered in the templates documents of the interchange
documentation.

http://interchange.redhat.com/cgi-bin/ic/dev-4.8/ictemplates_9.html

example:[if type=data term="<TABLE>::<COLUMN/FIELD>::<CODE/SKU>"]

Working example:  Note, you must change "some-code" to a valid key in your
table.
[if type=data term="contracts::updated::[some-code]"]
	The field contains a value
[else]
	The field does not contain a value
[/else]
[/if]