Since I don't see a response to this question yet:



Yes, Oracle queries can take more than one parameter.  The 'Invalid or undefined dynamic query' means that you have some syntax issue in how you've defined the query in either the site configuration or list header.



Since LISTSERV.SLAC.STANFORD.EDU has a current support contract, you probably should send this to [log in to unmask] if you haven't already done so, along with copies of your site configuration, list header, and log files.  LSTOWN-L isn't really the right place for this question, as list owners don't have the ability to define DQL statements.  LSTSRV-L would be more appropriate since it is a site admin function.



-- 

Liam Kelly

Senior Consulting Analyst

L-Soft international

[log in to unmask]



L-Soft is celebrating 20 years!

Visit our new website: <http://www.lsoft.com/>



-----Original Message-----

From: [log in to unmask] [mailto:[log in to unmask]] On Behalf Of Charlotte Hee

Sent: Wednesday, December 17, 2014 6:35 PM

To: [log in to unmask]

Subject: Dynamic query syntax question



Hello,

 

I'm new to Listserv and have access to Listserv 16.0 from redhat linux and a dbms connect to an Oracle database. 

I'm trying to understand the example query in the documentation:



http://www.lsoft.com/manuals/15.5/dql%20overview.pdf



but it's not clear to me  if an Oracle query can take more than one parameter, e.g.

select email_address from Mytable where experiment = %1 and group = %2 and status = %3



The document seems to indicate it's possible 

  "Parameters are specified as %1 for the first parameter, %2 for the second one, and so forth."



but  when I try my query I get this error:

   Error: Invalid or undefined dynamic query



Does anyone have some example queries using multiple parameters?



thanks, Chee



############################



To unsubscribe from the LSTOWN-L list:

write to: mailto:[log in to unmask]

or click the following link:

http://peach.ease.lsoft.com/scripts/wa-PEACH.exe?SUBED1=LSTOWN-L&A=1



############################



To unsubscribe from the LSTOWN-L list:

write to: mailto:[log in to unmask]

or click the following link:

http://peach.ease.lsoft.com/scripts/wa-PEACH.exe?SUBED1=LSTOWN-L&A=1