Newbie having SQL select problems with array in 2.5.8

[Ruslan Zasukhin]

On 1/2/08 11:26 PM, "Walton Sumner" <wsumner at im.wustl.edu> wrote:

Hi Walton,

> Here is a snippet of code that works only when the extra line is present:
> 
> function updateTable pName,pFieldList,pArray
>     local tKey, tCursor, tCount, tSQL, tItem, tValues, i, tResult
>     if pArray[1] = "" then return "Error: empty key value in array"
>     put "SELECT * FROM" && pName && "WHERE" && item 1 of pFieldList \
                      ^^^^^^^^^^^^^^^^^^

It seems to me this will produce SQL string as

    SELECT * FROMmytableWHERE

You need take care about spaces

>     put "SELECT * FROM " && pName && " WHERE" && item 1 of pFieldList \


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]