730391_en-US

liliconcom

How to query in SQL using list from JSL

Hi all, 

How can I insert a list from JSL to my SQL query?

 

Currently I am using this to get the list that I need:

 

NameList = Associative array( dtNames:"Names" ) << Get Keys; 

And will use it as a SQL query

 

dt = Open Database( "DSN=db;UID=uname;PWD=pw;APP=JMP;DATABASE=dbname;", 
"select name, age, address, sex
from  db_Details
where name in ('"||NameList||"')", // Im getting an error here
"Details" );

I am using JMP 15

Automation and ScriptingRe: How to query in SQL using list from JSL

I do this a lot for creating SQL queries.  Try this.

 

NameList = Substitute( Char( NameList ), "{", "", "}", "", "\!"", "'" );

Re: How to query in SQL using list from JSL

See an additional Discussion item intitled How to skip item on JSL list in SQL query if it does not exist?