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
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