Re: [mv] Update with [sql type=set ]

[Bill Randle <billr@exgate.tek.com>]

******    message to minivend-users from Bill Randle <billr@exgate.tek.com>     ******

Jose Luis wrote:
> 
> 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]

Not sure if this is the problem, but did you try it with the WHERE part
like this:
	where (user='[data session username]' AND
	address_number='[data session arg]')
(without the leading "address_book." part)?

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

I don't think you can. You have to use a [search-region], [sql] or [query] type
tag.

	-Bill
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list