|
|
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
blueproximity
BLUEPROXIMITY(1) BLUEPROXIMITY(1) NAME
blueproximity - locks/unlocks your desktop tracking a bluetooth device SYNOPSIS
blueproximity DESCRIPTION
blueproximity helps you adding a little more security to your desktop. It does so by detecting one of your bluetooth devices, most likely your mobile phone, and keeping track of its distance. If you move furter than a certain distance from your computer for longer than a given time, it automatically locks your desktop (or starts an arbitrary shell command). The "distance" must be specified as a measure of blue- tooth signal strength rather than in meters, but BlueProximity's setup procedure helps with this by showing you an indicator of current signal strength. Once away, if you return nearer than a given level for a set time your computer unlocks magically without any interaction (or starts any other shell command you want). Have a look at the package documentation in your distribution's doc directory, likely /usr/share/doc/blueproximity, to read the complete html manual or visit the website http://blueproximity.sourceforge.net . OPTIONS
blueproximity doesn't support any command-line parameter. FILES
~/.blueproximity/*.conf Config files for each profile. SEE ALSO
gnome-screensaver-command(1). AUTHOR
blueproximity was written by Lars Friedrichs <larsfriedrichs@gmx.de>. This manual page was written by Francesco Namuri <francesco@namuri.it> and Lars Friedrichs for the Debian project and Ubuntu (but may be used by others). Lars Friedrichs February 06, 2008 BLUEPROXIMITY(1)