08-24-2011
thanks for your reply actually the comparison does not work and I tried to change the string value to numeric value ..can you please let me know how to do the same
Like if the flat file returns 9 and $result also has value 9
By doing comparison with == is not giving exact result
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi friends,
I want to use query string value to another variable but it gives following error when I use it with print out command,
Insecure dependency in open while running with -T switch at C:/Program Files/Apache Group/Apache2/cgi-bin/cdr_findere.pl line 119.
My code as follows,
my... (0 Replies)
Discussion started by: maheshsri
0 Replies
2. Shell Programming and Scripting
Hi All,
Is there any code in Perl which can differentiate between numeric and non-numeric input? (11 Replies)
Discussion started by: Raynon
11 Replies
3. Shell Programming and Scripting
hi
I've been searching all over the internet to simply do the following:
$tempfile = "/usr/school/tempfile.dat";
$myvar = param('add'); ###add is the variable assigned to a popup menu
`ls -l $myvar * >> $tempfile` ###I also tried `ls -l ${myvar}* >>$tempfile`
open(ADDLIST,... (6 Replies)
Discussion started by: mehdi9
6 Replies
4. Shell Programming and Scripting
if test $b -ne
then
echo "\n\n\n\tPassword reset has been done successfully"
else
echo "\n\n\n\tAn error occurred"
fi
i want to check whether $b is non-numeric so how to do that? (3 Replies)
Discussion started by: sachin.gangadha
3 Replies
5. Shell Programming and Scripting
Dear friends,
I am new to Unix/Linux. I am trying to run following query but getting an error msg... Please can u people help me in this?
Query:
echo "select status_ac from db_acct where acct_num=AAA000337" | dbaccess elstest
Error:
217: Column (amd000337) not found in any table in the... (2 Replies)
Discussion started by: anushree.a
2 Replies
6. Shell Programming and Scripting
Hi All,
I have 1 million records file. Using awk, I am counting the number of records. But as the number is huge, after crossing a number, awk is displaying it in exponential format.
At the end, I need to verify this count given by awk with expected count.
But as it is in exponential format,... (3 Replies)
Discussion started by: ssunda6
3 Replies
7. Shell Programming and Scripting
I have a customer who logged some cc and bank account numbers in their apache logs. I got the cc numbers x'd out with
sed -e 's/args=\{16\}/args=XXXXXXXXXXXXXXXX/g' -e 's/cardnum=\{16\}/cardnum=XXXXXXXXXXXXXXXX/g'but that wasn't too difficult due to the value being 16 digits.
The bank account... (7 Replies)
Discussion started by: mk4mzid
7 Replies
8. Shell Programming and Scripting
Hi Experts,
How to convert months into numeric format with the help of some script:
Suppose I want:
" Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec "
to be converted as :
" 01 | 02 | 03 | 04 | 05 | 06 | 07 | 08 | 09 | 10 | 11 | 12 "
Thanks in... (2 Replies)
Discussion started by: rveri
2 Replies
9. Shell Programming and Scripting
I have two variables,
my $filename = "abc_yyyy_mm_dd.txt";
my $filename1 = " abc_2011_11_07.txt";
I need to perform some operations after checking if $filename has $filename1 in it
i have used the below code,
if($filename =~ /^$filename1/)
{
----
--
} (2 Replies)
Discussion started by: irudayaraj
2 Replies
10. Programming
I have a string
opt="row234"
I want to put "row" in a string and 234 in an int.
In general it should be
opt="textnum"
I want to store text in a string and num in an int. (6 Replies)
Discussion started by: kristinu
6 Replies
LEARN ABOUT MOJAVE
dbicadmin5.18
DBICADMIN(1) User Contributed Perl Documentation DBICADMIN(1)
NAME
dbicadmin - utility for administrating DBIx::Class schemata
SYNOPSIS
dbicadmin: [-I] [long options...]
deploy a schema to a database
dbicadmin --schema=MyApp::Schema
--connect='["dbi:SQLite:my.db", "", ""]'
--deploy
update an existing record
dbicadmin --schema=MyApp::Schema --class=Employee
--connect='["dbi:SQLite:my.db", "", ""]'
--op=update --set='{ "name": "New_Employee" }'
OPTIONS
Actions
--create
Create version diffs needs preversion
--upgrade
Upgrade the database to the current schema
--install
Install the schema version tables to an existing database
--deploy
Deploy the schema to the database
--select
Select data from the schema
--insert
Insert data into the schema
--update
Update data in the schema
--delete
Delete data from the schema
--op
compatibility option all of the above can be supplied as --op=<action>
--help
display this help
Arguments
--config-file or --config
Supply the config file for parsing by Config::Any
--connect-info
Supply the connect info as trailing options e.g. --connect-info dsn=<dsn> user=<user> password=<pass>
--connect
Supply the connect info as a JSON-encoded structure, e.g. an --connect=["dsn","user","pass"]
--schema-class
The class of the schema to load
--config-stanza
Where in the config to find the connection_info, supply in form MyApp::Model::DB
--resultset or --resultset-class or --class
The resultset to operate on for data manipulation
--sql-dir
The directory where sql diffs will be created
--sql-type
The RDBMs flavour you wish to use
--version
Supply a version install
--preversion
The previous version to diff against
--set
JSON data used to perform data operations
--attrs
JSON string to be used for the second argument for search
--where
JSON string to be used for the where clause of search
--force
Be forceful with some operations
--trace
Turn on DBIx::Class trace output
--quiet
Be less verbose
-I Same as perl's -I, prepended to current @INC
AUTHORS
See "CONTRIBUTORS" in DBIx::Class
LICENSE
You may distribute this code under the same terms as Perl itself
perl v5.18.2 2014-01-30 DBICADMIN(1)