05-19-2010
Two things: a) if you run this with set -x does it appear to interpolate all of your variables correctly?; and, b) if it does, and you take this same interpolated find query and run it manually, does it work then?
I also notice the extra ;-char at the end of the find query. Why do you need to include this? The find shouldn't need additional prompting.
Last edited by curleb; 05-19-2010 at 08:23 AM..
Reason: android...again
10 More Discussions You Might Find Interesting
1. UNIX for Advanced & Expert Users
when i use the following command
find / -name '*.*' -exec grep -il 'text' {} \;
I can redirect the errors to /dev/null. This happens only in ksh but not in csh. the 2>/dev/null is not working in csh. Can you some one suggest an alternative for this in csh ? (3 Replies)
Discussion started by: dhanamurthy
3 Replies
2. UNIX for Advanced & Expert Users
Hi experts,
I have a shell script (korn shell on aix) where I am giving find command with file options which are read from a configuration file. For some reason I am getting an error find: 0652-017. I have put set -x in the shell script and the command looks okay. If I cut it and paste it in the... (6 Replies)
Discussion started by: kodermanna
6 Replies
3. UNIX for Dummies Questions & Answers
I have a script that has the following command:
find /home/user -name test.dat
The script works as desired when running normally. However, when I run the script preceding it with 'sh', it fails. Is there something I need to account for when preceding the execution of the script with 'sh'? (1 Reply)
Discussion started by: bsavitch
1 Replies
4. Shell Programming and Scripting
I am running shell scripts on windows using Cygwin tool.
In my shell scripts, i want to add an error check, that verify whether a certain command is available or not.
For example if SED comamnd is not available in Cygwin, then it should exit with error message.
How do i write such shell... (2 Replies)
Discussion started by: mmunir
2 Replies
5. Shell Programming and Scripting
Hi,
I am trying to execute the below in Ksh (telnet)
find ./request.txt -mmin -30
It says
find: bad option -mmin
What i am trying to do is by using find command i am checking wheather the file request.txt is there for 30 minutes or not
Please help (1 Reply)
Discussion started by: chinniforu2003
1 Replies
6. Shell Programming and Scripting
hi
I am a newbee in Shell scripting (hardly 7 days)
I have to execute a shell script which looks like this
#!/bin/sh
var1=`date +"%Y%m%d"`
echo $var1
find . -name "$var1*" -exec mv {} Delete/ \;
the find command in the script is running independently but when kept in this script it is... (24 Replies)
Discussion started by: sweetnsourabh
24 Replies
7. UNIX for Dummies Questions & Answers
Hello all,
Something strange going on with a shell script I'm writing. It's trying to write a list of files that it finds in a given directory to another file. But I also have a skip list so matching files that are in that skip list should be, well uhm, skipped :)
Here's the code of my... (2 Replies)
Discussion started by: StijnV
2 Replies
8. Shell Programming and Scripting
Hi all,
Please i need an explanation for the following statements
ref_file=/tmp/cleanfiles export ref_file
touch `TZ=WAT+2 date "+%Y%m%d%H%M"` $ref_file
find . ! -name . -prune -type f ! -newer $ref_file -exec store_file.sh {} \; (1 Reply)
Discussion started by: anish_1982
1 Replies
9. Shell Programming and Scripting
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk... (2 Replies)
Discussion started by: Ashunayak
2 Replies
10. HP-UX
Hi All,
I am using below snippet to search for a string (read from a file 'searchstring.out') in all locations (/) and then iterate over the files found to write the locations and the respective owner to an output file.
However, this doesn't work as I believe the find command doesn't exit's... (11 Replies)
Discussion started by: Vipin Batra
11 Replies
LEARN ABOUT PHP
fbsql_query
FBSQL_QUERY(3) 1 FBSQL_QUERY(3)
fbsql_query - Send a FrontBase query
SYNOPSIS
resource fbsql_query (string $query, [resource $link_identifier], [int $batch_size])
DESCRIPTION
Sends a $query to the currently active database on the server.
If the query succeeds, you can call fbsql_num_rows(3) to find out how many rows were returned for a SELECT statement or
fbsql_affected_rows(3) to find out how many rows were affected by a DELETE, INSERT, REPLACE, or UPDATE statement.
PARAMETERS
o $query
- The SQL query to be executed.
Note
The query string shall always end with a semicolon.
o $
link_identifier -A FrontBase link identifier returned by fbsql_connect(3) or fbsql_pconnect(3).If optional and not specified, the
function will try to find an open link to the FrontBase server and if no such link is found it will try to create one as if
fbsql_connect(3) was called with no arguments.
o $batch_size
-
RETURN VALUES
fbsql_query(3) returns TRUE (non-zero) or FALSE to indicate whether or not the query succeeded. A return value of TRUE means that the query
was legal and could be executed by the server. It does not indicate anything about the number of rows affected or returned. It is perfectly
possible for a query to succeed but affect no rows or return no rows.
For SELECT statements, fbsql_query(3) returns a new result identifier that you can pass to fbsql_result(3).
fbsql_query(3) will also fail and return FALSE if you don't have permission to access the table(s) referenced by the query.
EXAMPLES
The following query is syntactically invalid, so fbsql_query(3) fails and returns FALSE:
Example #1
fbsql_query(3) example
<?php
$result = fbsql_query("SELECT * WHERE 1=1")
or die ("Invalid query");
?>
The following query is semantically invalid if my_col is not a column in the table my_tbl, so fbsql_query(3) fails and returns FALSE:
Example #2
fbsql_query(3) example
<?php
$result = fbsql_query ("SELECT my_col FROM my_tbl;")
or die ("Invalid query");
?>
SEE ALSO
fbsql_affected_rows(3), fbsql_db_query(3), fbsql_free_result(3), fbsql_result(3), fbsql_select_db(3), fbsql_connect(3).
PHP Documentation Group FBSQL_QUERY(3)