Can anyone help please? I can't get a rising input query to work at all. Batch Inputs work fine. Rising Inputs always gives me this error:

External search command 'dbxquery' returned error code 1. Script output = "RuntimeError: Failed to run query: "SELECT * FROM (select * from (SELECT BWTXNID,CURRENCY FROM ALANK_HOSTTXNREQUEST order by bwtxnid) {{WHERE $rising_column$ > ?}}) t", params: "None", caused by: Exception(' java.sql.SQLException: Missing IN or OUT parameter at index:: 1.',). "
						
External search command 'dbxquery' returned error code 1. Script output="RuntimeError,Failed to run Query 'SELECT * FROM (SELECT * FROM 

'ActivePortal'. 'public'.'np_user_history_v')t',caused by:

BadStatusLine('").'
						
I think you might be better off creating a new question for this, the error looks a little different to (my) original error of "Missing IN or OUT parameter". The original question is not valid for later DB Connect versions and fixed per my comments. In a new question add what DB Connect version being used, what DB type, and is this only happening on one input, or everywhere? Before you do, maybe look at why you need quotes inside the select statement, are they needed or can you get it to work without them?
						
After a bit of delay, just getting back to this. I noticed that if I use the actual column name in advanced mode (where BWTXNID > ?), the SQL command works as expected, returning rows after the value provided. But it gives the error when using the double parenthesis nor the $rising_column$. I'm wondering if, because it is DB Connect v2.3, I no longer need the double parenthesis and $rising_column$? When I look here, I do not see any mention of $rising_column$ that is mentioned in many previous answers, http://docs.splunk.com/Documentation/DBX/2.3.1/DeployDBX/Createandmanagedatabaseinputs. 
						Splunk, Splunk>, Turn Data Into Doing, Data-to-Everything, and D2E are trademarks or
						registered trademarks of Splunk Inc. in the United States and other countries. All other brand
						names, product names, or trademarks belong to their respective owners.