topic Re: How to query in SQL using list from JSL in Discussions

How to query in SQL using list from JSL

UserID16644 — Thu, 07 Mar 2024 02:50:29 GMT

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

Re: How to query in SQL using list from JSL

mmarchandTSI — Thu, 07 Mar 2024 18:25:11 GMT

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

txnelson — Thu, 07 Mar 2024 22:31:29 GMT

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