[ic] writing to a table

[Brent Kelly]

forgot to say:

[tag flag write]products[/tag]

should allow writing to products table. For more info check the ictags=20
reference for the [data] tag=20
(http://www.icdevgroup.org/cgi-bin/ic/docfly.html?mv_arg=3Dictags04.17)

Brent Kelly,
Zeald Ltd.

On Thu, 29 Aug 2002 07:54, Grant wrote:
> How can I write to a field in the products table in-page?  Is there any
> reason not to do this?
>
> My syntax must be way off in the following code.  I just wrote it to gi=
ve
> everyone an idea of how I'm trying to accomplish this.  I'm trying to
> search for all "Posters", then set the "unavailable" field in the produ=
cts
> table to "1" for any items that have a "discontinued" value of "1" and =
an
> inventory "quantity" equal to or less than "0".
>
> I hope to have it set up something like this:
>
> [search-region
> search=3D"co=3Dyes/sf=3Dcategory/se=3DPosters/op=3Deq/nu=3D0/sf=3Dinact=
ive/se=3D1/op=3D!=3D/nu=3D
>1 "]
> [search-list]
> [if-item-data type=3D"products" term=3D"discontinued" op=3D"eq" compare=
=3D"1"]
> [if-item-data type=3D"inventory" term=3D"quantity" op=3D"=3D<" compare=3D=
"0"]
> [set-item-data products unavailable]1[/set-item-data]
> [/if-item-data]
> [/if-item-data]
> [/search-list]
> [/search-region]
>
> I'm using the default database in 4.8.6.  Thanks!
>
> - Grant
>
> _______________________________________________
> interchange-users mailing list
> interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users