Forums Register Login

Shell Script Basic

+Pie Number of slices to send: Send
Hi ,

i am working in a file #!/bin/sh


when i use below for loop its working fine , the value in $FORM_form_id_numbers is as 1234ad,45466,7890 and i am able to get each individual value separated by comma

IFS=","
for numb in "$FORM_form_id_numbers"; do
echo $numb
done


Also after preparing below sql i am able to have contents in out.log file

$ISQL << ! > ${L}/out.log
SELECT * FROM db_outerlayer..logger WHERE number_id="wer123_4545"
go
!


My problem starts when i put my sql in the for loop , after doing so i didnt get any error's not it provide any result , and out.log is empty , permission's for the out.log is proper.


IFS=","
for numb in "$FORM_form_id_numbers"; do

$ISQL << ! > ${L}/out.log
SELECT * FROM db_outerlayer..logger WHERE number_id=$numb
go
!

done


What is the problem in the above for loop which calls this sql.

Thank you in Advance
+Pie Number of slices to send: Send
I think you are not appending to out.log so every time that file is getting created.
And in last execution may be nothing is written to the file.
Use >> instead to see all the output appended.
Danger, 10,000 volts, very electic .... tiny ad:
a bit of art, as a gift, that will fit in a stocking
https://gardener-gift.com


reply
reply
This thread has been viewed 854 times.
Similar Threads
Log4j
Create Object in DoWhile Send to Arraylist
calling a PL/SQL procedure from a Java application
need help using StringTokenizer
How to Parse Multitple Entities In Hibernate NativeSQL Returned List
More...

All times above are in ranch (not your local) time.
The current ranch time is
Mar 28, 2024 07:32:40.