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

Scott Andreas---Learning Services, Inc interchange-users@interchange.redhat.com
Thu Dec 27 14:48:00 2001


I agree...

There has to be a simple solution to this problem

I have tried adding in [item-code] to the tag but that result brought in the
image for all records...not good.


Other code I have tried are

      [if explicit]      <----which displays a graphic for all records
	[condition]
		$updated = $values = {updated};
		return 1 if $updated = 1;
		return 0;
	[/condition]
		<IMG src="newcon.gif" ALT="this is a new contact">
	[else]
		<IMG src=blank.gif">
	[/else]
	[/if]
and
	[if type=data term=contacts::updated op="eq" compare="1"]     <----which
displays nothing
		<IMG src="newcon.gif" ALT="this is a new contact">
	[/if]
and
	[if value updated == 1]             <----which displays nothing
		<IMG src="newcon.gif" ALT="this is a new contact">
	[/if]
and
	[if type=data term="contacts::updated::1 op="eq" compare='[item-param
updated]']       <----which displays nothing
		<IMG src="newcon.gif" ALT="this is a new contact">
	[/if]


There should be a simple solution is all I want is to evaluate the result
and if the column has a value of 1 in it then display the graphic else
display nothing. The other problem is that the column could contain a NULL
record so evaluating if the record is NULL would not work.


Thanks for your help

-----Original Message-----
From: interchange-users-admin@interchange.redhat.com
[mailto:interchange-users-admin@interchange.redhat.com]On Behalf Of
Scott Andreas---Learning Services, Inc
Sent: Thursday, December 27, 2001 9:56 AM
To: 'IC mailing list'
Subject: [ic] [if type=date term=HELP]



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!!


Any help would be appreciated

Thanks

J. Scott Andreas :)
IS/Programmer/WebDevelopement
Learning Services, Inc.
e-mail: sandreas@learningservicesinc.com
phone: 1-800-877-9378 ext. 146
fax: (541) 744-2056

      |
      |__earning
      (__
       __)ervices
        |
        |ncorporated
       ---    __o
     ---   _-\<,_
      --- (_)/ (_)


_______________________________________________
interchange-users mailing list
interchange-users@interchange.redhat.com
http://interchange.redhat.com/mailman/listinfo/interchange-users