[ic] writing to a table

Brent Kelly interchange-users@icdevgroup.org
Wed Aug 28 17:02:01 2002


try:

[date table=3D"products" field=3D"unavailable" key=3D"[item-code]" value=3D=
"1"]

i presume using [item-data] tag and removing key=3D"" from the above exam=
ple=20
should work too but haven't tried that. Also may have to set that table t=
o=20
allow writing before you try update it..

hope that helps,

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