Re: [ic] update queries using [query]

[interch <interch@web3.valley-internet.com>]

Hmmm this might possibly be a bug, since I can't see how it should do this
regardless of whether I have the query right or not.

Here is the code:

[tag flag write]country[/tag]


[query sql="update country set shipmodes = 'TEST' where code =
'US'" table=country]
[/query]
[export country]

Here is the line in the database (default dbm) for code US.  I have the
type set to PIPE.

US|0||US|GNDRES FEG 1DA|United States|USA|840 


After running the query the line above is not changed, but at the end of
country.txt this line has been inserted:

||||GNDRES FEG 1DA



Chris


On Sun, 15 Jul 2001, interch wrote:

> 
> Ok I can't get this to work at all in IC 4.7.5.  No errors in error.log,
> just nothing happens.  selects work just fine.
> 
> [loop list="access area cat products country mv_metadata userdb variable"]
> [flag type=write table="[loop-code]"]
> [/loop]
> [tag flag write]country[/tag]
> [set mv_data_enable]1[/set]
> 
> [query sql="update country set shipmodes = 'TEST' where code =
> 'US'" table=country]
> [/query]
> 
> 
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users
>