November 03, 2006, 06:07 PM
brandonkirschSREG in SQL Listener
Hello,
I'm trying to setup a SQL listener that checks for new orders that need to be processed. I am trying to use a special register to filter out orders running in different iWay configurations, say Dev for testing or Production for the real deal.
The SQL Query looks like this:
SELECT * FROM [INET].[dbo].[ELineTrafficCopNewOrders] WHERE iWayConfig = 'SREG(current_config)'
It isn't pulling any records, because according to the activity log the query is literally placing the text SREG(current_config) inside quotes.
How do I use a special register in this query? I have used SREG(variable_name) in FILE listeners just fine, I'm not sure what I'm doing wrong here. Any help is appreciated!