Re: [sqr-users] Add comments to an input string.

[Ray Ontko <rayo@ontko.com>]

You can't change the value of an ASK variable, but under 
certain circumstances you can do something like this:

I'm guessing that you're trying to use INV_NUM in a where
clause:

where invoice_number in ({INV_NUM})

Try this:

let $inv_num_list = translate('{INV_NUM}',' ',',')
...
where invoice_number in ([$inv_num_list])

Ray

On Wed, May 12, 2004 at 03:41:49PM -0500, DICKMAN, ERIC C. wrote:
> Hello everyone,
> 
> I have a input parameter that I am passing into my SQR file. For Example,
> 'ask INV_NUM'. INV_NUM is a String that looks something like '000 001 002
> 003 004 005'. Is it possible to add commas to the blank spaces in SQR, so
> the String looks like '000,001,002,003,004,005'.
> 
> Thanks,
> 
> Eric
> 
> NOTE: The Texas Department of Protective and Regulatory Services (TDPRS) has
> changed its name to the Department of Family and Protective Services(DFPS)
> resulting in the following e-mail address format change for all employees:
> firstname.lastname@dfps.state.tx.us 
> 
> _______________________________________________
> sqr-users mailing list
> sqr-users@sqrug.org
> http://www.sqrug.org/mailman/listinfo/sqr-users
----------------------------------------------------------------------
Ray Ontko   rayo@ontko.com   Phone 1.765.935.4283   Fax 1.765.962.9788
Ray Ontko & Co.   Software Consulting Services   http://www.ontko.com/

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users