[mv] Update with [sql type=set ]

[Jose Luis <macross@mixmail.com>]

Hello ,  I was trying to update a table with sql tag , but I can't
get work it with " where  statement" (without where it works ). please
could someone help me ? , here is my code :

[sql type=set base=address_book interpolate=1]
          update address_book
   set
  sfname='[value filter=strip name=sfname]',
  slname='[value filter=strip name=slname]',
   saddress1='[value filter=strip name=saddress1]',
  saddress2='[value filter=strip name=saddress2]',
             scity='[value filter=strip name=scity]',
  sstate='[value name=state filter="strip uc"]',
  szip='[value name=szip filter=digits]',
  scountry='[value scountry]',
  sphone='[value filter=strip name=sphone]'
  where (address_book.user='[data session username]' AND address_book.address_number='[data session arg]')
 [/sql]

and how can  I access to any table (with the tag [data]) that has two primary keys .
 
 
 

Thanks , bye