01-20-2009
Not working and getting following error:
./cpd.sh[19]: test: Specify a parameter with this command.
The select query returns multiple rows and single column.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
Lets say I have a few xml files:
1234567894.xml
abc_1234567895.xml
abc_000_1234567890.xml
abc_0000000_1234567893.xml
684_abc_000_1234567899.xml
The naming convention of the files is:
xxxxx_timestamp.xml OR timestamp.xml
where x can be anything
and I would like to order them by... (4 Replies)
Discussion started by: Leion
4 Replies
2. Homework & Coursework Questions
Hi guys I need you ,please help me
i have to do this for tomorow and i don't understand how to do
Q1 : Order the words of RADIO.txt by frequency
Q2 : Order the words of RADIO.txt in alphabétique order
Q3 : Order the words of RADIO.txt par ordre "rhymique" (exemple, put togeder words which are... (1 Reply)
Discussion started by: Lili
1 Replies
3. Shell Programming and Scripting
With an input file like this:
How can I get an output like this?
(In the quoted examples, the "_" sign represents an empty space)
Note that there are some minus signs and no spaces, in the example above the first character of the first line is an empty space, so each number spans 10... (16 Replies)
Discussion started by: lego
16 Replies
4. Shell Programming and Scripting
input
Predictions for job: 1299399580
**********************************************
gg18_qqq10_100017878_100017978_-
==============================================================================
zzz Factor: XXX, ttt: crsmsgw, Cutoff: 0.6429
seqe Position fff Coordinate K-mer Score ... (3 Replies)
Discussion started by: quincyjones
3 Replies
5. Shell Programming and Scripting
Is it possible to re-order certain rows as columns (of large files).
Few lines from the file for reference.
input
Splicing Factor: Tra2beta, Motif: aaguguu, Cutoff: 0.5000
Sequence Position Genomic Coordinate K-mer Score
97 chr1:67052604 uacuguu 0.571
147... (3 Replies)
Discussion started by: quincyjones
3 Replies
6. Shell Programming and Scripting
file1
1 SNP2 3
1 SNP3 3
1 SNP5 4
2 SNP1 4
2 SNP4 4
file2
SNP1 1 1 1
SNP5 5 5 5
SNP4 4 4 4
SNP2 2 2 2
SNP3 1 1 1
desired output (1 Reply)
Discussion started by: johnkim0806
1 Replies
7. Shell Programming and Scripting
1
2
4
5
3
I would like to use a script so that i can randomly rearrange these numbers such as
3
5
2
4
1
Thanks! (3 Replies)
Discussion started by: johnkim0806
3 Replies
8. Shell Programming and Scripting
Hi All,
I have directories under
/development/arun/weekly/
20120421
20120414
.
.
.
.
I need to arrange these directories in descending order.
folder name with recent date will be on top and then others. (1 Reply)
Discussion started by: Arun Mishra
1 Replies
9. Shell Programming and Scripting
Hi,
Could some one please help to order the batch number in sequence.
I will be getting bunch of files with batch number in folder1 which are not in sequence.
I need to move all files from folder1 to folder2 with batch number in sequence.
Header record looks like
PROCESS1... (8 Replies)
Discussion started by: zooby
8 Replies
10. Shell Programming and Scripting
Hello.
I have a script that writes parameters in alphabetic order.
But I have a parameter which have 3 lines. There is no continuation character ( '\' ). Each of the three lines finish with 'cr'. But line 2 and 3 of the concerning parameter start with a tab char (but should be one or more... (7 Replies)
Discussion started by: jcdole
7 Replies
LEARN ABOUT PHP
sqlite_exec
SQLITE_EXEC(3) SQLITE_EXEC(3)
sqlite_exec - Executes a result-less query against a given database
SYNOPSIS
bool sqlite_exec (resource $dbhandle, string $query, [string &$error_msg])
DESCRIPTION
bool sqlite_exec (string $query, resource $dbhandle)
Object oriented style (method): bool SQLiteDatabase::queryExec (string $query, [string &$error_msg])
Executes an SQL statement given by the $query against a given database handle (specified by the $dbhandle parameter).
Warning
SQLite will execute multiple queries separated by semicolons, so you can use it to execute a batch of SQL that you have loaded from
a file or have embedded in a script.
PARAMETERS
o $dbhandle
- The SQLite Database resource; returned from sqlite_open(3) when used procedurally. This parameter is not required when using the
object-oriented method.
o $query
- The query to be executed. Data inside the query should be properly escaped.
o $error_msg
- The specified variable will be filled if an error occurs. This is specially important because SQL syntax errors can't be fetched
using the sqlite_last_error(3) function.
Note
Two alternative syntaxes are supported for compatibility with other database extensions (such as MySQL). The preferred form is the
first, where the $dbhandle parameter is the first parameter to the function.
RETURN VALUES
This function will return a boolean result; TRUE for success or FALSE for failure. If you need to run a query that returns rows, see
sqlite_query(3).
The column names returned by SQLITE_ASSOC and SQLITE_BOTH will be case-folded according to the value of the sqlite.assoc_case configuration
option.
CHANGELOG
+--------+---------------------------------+
|Version | |
| | |
| | Description |
| | |
+--------+---------------------------------+
| 5.1.0 | |
| | |
| | Added the $error_msg parameter |
| | |
+--------+---------------------------------+
EXAMPLES
Example #1
Procedural example
<?php
$dbhandle = sqlite_open('mysqlitedb');
$query = sqlite_exec($dbhandle, "UPDATE users SET email='jDoe@example.com' WHERE username='jDoe'", $error);
if (!$query) {
exit("Error in query: '$error'");
} else {
echo 'Number of rows modified: ', sqlite_changes($dbhandle);
}
?>
Example #2
Object-oriented example
<?php
$dbhandle = new SQLiteDatabase('mysqlitedb');
$query = $dbhandle->queryExec("UPDATE users SET email='jDoe@example.com' WHERE username='jDoe'", $error);
if (!$query) {
exit("Error in query: '$error'");
} else {
echo 'Number of rows modified: ', $dbhandle->changes();
}
?>
SEE ALSO
sqlite_query(3), sqlite_unbuffered_query(3), sqlite_array_query(3).
PHP Documentation Group SQLITE_EXEC(3)