cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
UserID16644
Level V

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

2 REPLIES 2
mmarchandTSI
Level V

Re: How to query in SQL using list from JSL

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

 

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

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? 

Jim

Recommended Articles