altSQLite variable substitution

[Dave Cragg]

On 11 Dec 2006, at 03:02, Mark Wieder wrote:


>
> Here's the errant line:
> revExecuteSQL dbID, "INSERT INTO CDData(id) VALUES(:1)", "tSSN"
>
> and this one works:
> revExecuteSQL dbID, "INSERT INTO CDData(id) VALUES(" &tSSN& ")"

When using the ":1" variety, doesn't the variable have to be an  
array. I.e. the value you need should be in tSSN[1]. Or have I  
misunderstood?

Cheers
Dave