Re: [sqlite] Using TOTAL and AS in the SQL of a Flex app

Ross Edwards <[EMAIL PROTECTED]> wrote: > I really don't know where to post this, as it involves both SQLite > and Flex 3, but, I'll try here first. Here's what I have in > FlexBuilder: > > > > sqlText = "SELECT Up18RODetail.ProductID, TOTAL(Up18RODetail.Qty) AS > :qtySum " + You cannot

[sqlite] Using TOTAL and AS in the SQL of a Flex app

I really don't know where to post this, as it involves both SQLite and Flex 3, but, I'll try here first. Here's what I have in FlexBuilder: sqlText = "SELECT Up18RODetail.ProductID, TOTAL(Up18RODetail.Qty) AS :qtySum " + "FROM Up18RODetail LEFT JOIN