Re: Dynamic variables within unix script file...
From: Diana Tracy <bs794_at_cleveland.Freenet.Edu>
Date: 27 Jan 1994 16:58:12 GMT
Message-ID: <2i8rr4$ha8_at_usenet.INS.CWRU.Edu>
Date: 27 Jan 1994 16:58:12 GMT
Message-ID: <2i8rr4$ha8_at_usenet.INS.CWRU.Edu>
In a previous article, Brian.Sakach_at_DaytonOH.NCR.COM (Brian Sakach) says:
>
>What do you do if the parameter you pass is text with embedded
>spaces and the number of spaces varies. For instance, the input
>might be 1 to 5 words for a 'name' parameter...
>
> George Earl Jones
> George Jones
> George Earl Jones, III
>
Try calling the script with the variable in double quotes. I'm not positive
that this will work, but I have a vague memory of doing it myself...
A rather stupid alternative would be to do something like
select * from table where name = rpad(&1, ' ') || rpad(&2, ' ')...
-- Diana Tracy, System Designer -- Excitement, Adventure bs794_at_cleveland.Freenet.Edu -- and Really Wild ThingsReceived on Thu Jan 27 1994 - 17:58:12 CET