|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
PERL : Bind 2D array to SQL
Post 302487632 by sinpeak on Thursday 13th of January 2011 04:43:57 AM
01-13-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a SQL statement that includes a UNION that I can't get to work when I bind the parameters. (I am binding the parameters to prevent SQL injection.)
Does anybody have any suggestion on how I can use a SQL statement that includes a UNION and bind the params?
Code would be something like... (1 Reply)
Discussion started by: mh53j_fe
1 Replies
2. UNIX for Advanced & Expert Users
hi folks
i am facing problom while trying to access sql variable as array index ina unix shell script....script goes as below..
#!/bin/ksh
MAX=3
for elem in alpha beeta gaama
do
arr=$elem
((x=x+1))
Done
SQL_SERVER='servername'
/apps/sun5/utils/sqsh -S $SQL_SERVER -U user -P pwd -b -h... (1 Reply)
Discussion started by: sudheer157
1 Replies
3. Shell Programming and Scripting
Hi Everyone,
#!/usr/bin/perl
use strict;
use warnings;
my @test=("a;b;qqq;c;d","a;b;ggg;c;d","a;b;qqq;c;d");
would like to split the @test array into two array:
@test1=(("a;b;qqq;c;d","a;b;qqq;c;d"); and @test2=("a;b;ggg;c;d");
means search for 3rd filed.
Thanks
find the... (0 Replies)
Discussion started by: jimmy_y
0 Replies
4. Shell Programming and Scripting
Hi,
I have an array of strings. Each string has 4 comma separated values. I am binding this array to a SQL where I am required to do an INSERT after grouping.
The binding is done as :
$insertADWSth->bind_param_array(1,A_CONSTANT_STRING);... (1 Reply)
Discussion started by: sinpeak
1 Replies
5. Shell Programming and Scripting
Hi,
I want to know what exactly bind paameter does?
what exactly bind_param( 1, $siteName ) means?
what 1 means?
In some examples the bind_param is set like this:
bind_param( 2, $siteName1 )
bind_param( 3, $siteName2 )
$sth = $dbh->prepare( "
SELECT name,... (1 Reply)
Discussion started by: vanitham
1 Replies
6. Shell Programming and Scripting
Hi everyone
I have one question about using array in perl. let say I have several log file in one folder.. example
test1.log
test2.log
test3.log
and the list goes on..
how to make an array for this file? It suppose to detect log file in the current directory and all the log file will... (3 Replies)
Discussion started by: sayachop
3 Replies
7. Shell Programming and Scripting
I have an array and two variables as below,
I need to check if $datevar is present in $filename.
If so, i need to replace $filename with the values in the array.
I need the output inside an ARRAY
How can this be done.
Any help will be appreciated. Thanks in advance. (2 Replies)
Discussion started by: irudayaraj
2 Replies
8. UNIX and Linux Applications
#!/usr/local/bin/perl
use DBI;
use File::Copy;
use Time::Local;
use Data::Dumper;
-Comments Describing what I'm doing--------------
-I'm pulling information from a database that has an ID and Name. They are separated by a space and I'm trying to load them into a multidimensional array so as... (3 Replies)
Discussion started by: eazyeddie22
3 Replies
9. Shell Programming and Scripting
Hello,
Could someone please suggest if there is a way to pass an perl array(pass @v_array) to SQL as in below eg :
#!/usr/bin/perl
@v_array = (1,2,4,5,6,8);
$db_userid = 'ni71/ni711';
$bufTPO = qx{ sqlplus -s << EOF
$db_userid
set verify off
set feedback off
set... (1 Reply)
Discussion started by: arunshankar.c
1 Replies
10. Shell Programming and Scripting
Hi all,
I have declared an array in unix as below.
#!/bin/ksh
arr=()
for i in {0..4}
do
arr=$i;
done.
i want to insert these array variables into the oracle table.can you guys please help me in doing this. my code is as below.
value=`sqlplus -s fos/fos << EOF
begin
for j in... (10 Replies)
Discussion started by: Mukta
10 Replies
LEARN ABOUT DEBIAN
pp_popcon_cnt
PP_POPCON_CNT(1) User Commands PP_POPCON_CNT(1) NAME
pp_popcon_cnt - PredictProtein popularity contest usage counter SYNOPSIS
pp_popcon_cnt [OPTION] DESCRIPTION
The pp-popularity-contest package sets up a cron job that will periodically anonymously submit to the Rost Lab developers statistics about the most used Rost Lab packages on this system. This information helps us making decisions such as which packages should receive high priority when fixing bugs. It also helps us decide which packages should receive funding for further development and support. This information is also very important when the Rost Lab applies for funding. Without the funding we receive based on the usage statistics you volunteer none of the packages on this image could be made available to you at no cost. This binary collects the number of times a method was used. OPTIONS
--debug --help -p, --program program to record usage for -c, --count usage count to record, default: 1 --version EXAMPLES
pp_popcon_cnt --program preditprotein --count 1 FILES
/var/spool/pp-popcon AUTHOR
Laszlo Kajan SEE ALSO
predictprotein(1), ppvmi(7) 1.0.5 2012-04-04 PP_POPCON_CNT(1)