[NTLUG:Discuss] OT: sql embedded in shell script (sh) passing parameters

[jeremyb@univista.com]

Can we see the entire query please?

My first guess would be that you'r including the table namein the field
name.   Is 'ih' the table name?


-----Original Message-----
From: Sean Cook [mailto:lists at lohengrin.net] 
Sent: Friday, September 05, 2003 8:41 AM
To: NTLUG Discussion List
Subject: Re: [NTLUG:Discuss] OT: sql embedded in shell script (sh) passing
parameters

* fredjame at concentric.net [2003.09.05 07:39]:
 
> <Code Snippet>
> sqlplus username/password at sid << EOF
> (omitted for brevity)
> AND ih.inv_type = $InvType

Have you tried escaping your quotation...

AND ih.inv_type = \'$InvType\'

> /
> exit
> EOF
> <\Code Snippet>
> 
-- 
I'm sorry, but my karma just ran over your dogma.

_______________________________________________
https://ntlug.org/mailman/listinfo/discuss