can't query sql data



I'm connecting fine to a SQL DB. Used the "help" sample in LS 8.0 help to enter an ID that should query the data for a specific data set. Using "click" and "FormCalc", I get an error. This is my code:

//Change the commandType from TABLE to TEXT. TEXT

//is the equivalent of SQL Property

$sourceSet.DataConnection.#command.query.commandType = numeric

//Set the Select Node. Select in this case will be

//whatever SQL Property you want

$sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat(Select*from licenses Where userid = , ListBox1.rawValue,)

//Reopen the Data connection


I've tried the Javascript version of this, and I get no error, but nothing at all happens.