Highlighted

can't query sql data

Avatar

29-09-2008

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

$sourceSet.DataConnection.open()



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



Help??