Database syntax

[Pete]

You can use the :1, :2, etc syntax for updates as well as inserts,
irrespective of how many columns you are updating.



On Tue, Dec 20, 2011 at 1:39 PM, Bob Sneidar <bobs at twft.com> wrote:

> No just inserts. After that you only need to include columns that have
> altered in your SQL statements, if you are concerned about efficiency,
> although the statements themselves use very little bandwidth. What will use
> bandwidth is select statements that return large data sets, but I don't
> think that will be an issue for you.




-- 
Pete
Molly's Revenge <http://www.mollysrevenge.com>