Hey guys i am facing a problem in my sql statement. I am trying to check if there is such a value in the database.
The problem i am facing is how do i check if the value is found. I read up and found that a query will return a value of TRUE if the query is a success and a FAIL if there is an error. How do i call these values and then based the check on it?
Could someone please advise on a good way to implement error checking in a script?
i am taking input from a file, iserting it's values into two commands and sending the output of each to seperate log files. i need to check those log files for for an occurance of 'error', stop the command if... (3 Replies)
Here is my problem
I'm designing a script that will have to accept user input from the command line using the read command.
The problem is that I have to check the input which should be in the format of
<first name> <last name> <phone number (8 digits long)>
The input can also be
... (4 Replies)
I'm trying to create a directory from my Perl script. Only if the there was an error I want to let the user know about it. So if the folder exists is ok.
This is what I think should work:
`mkdir log 2>/dev/null`;
if($? == 0 || $? == errorCodeForFileExists)
{ everyting is fine }
else
{... (3 Replies)
I am creating a script that will automatically use sftp to connect to a site and download a file, extract the tar and then delete the tar file once completed.
What I am stuck on is the error checking for this process.
Here is the code so far:
Now this works for me as is, but i need... (0 Replies)
HI all;
I am new to the KSH scripting and i was asked to do some error checking using KSH,in the log file, i donot know how to do error checking ,so please let me know some tips and the vague code if possible.
Thanks in anticipation
vinay (1 Reply)
What i need to do is when the database connection is not successful , the script should move to next list i.e skip the current.
But when i do this -
if ; then
break;
fi
The script break but it goes to the condition -
if ; then
for LIST in $LISTS
do
for TABLE in $TABLES
do... (2 Replies)
I am currently wrapping up a assignment for one of my classes. I need help writing some error checking logic. The problems I am having are:
keeping track of the records I have deleted and reported it back using echo.
I have no idea how to do this.
ensuring that line numbers fall... (1 Reply)
Kindly help on below script:
<<
i='find ...'
if then
echo 'File Exists'
else
echo 'File Does Not Exist'
>>
If i has some file name then it runs properly but if i has nothing ( blank value) then it throws an error. I dont exactly remember right now but error seems like:... (2 Replies)
HI All,
Whenever I write a shell script I always check if a command got executed successfully, even for the commands like cd, mv, rm and others, and even for the cases when there is ALMOST nothing to stop this commands from executing with success. so I am wondering if it is an overkill. I am... (1 Reply)
Hi,
I need to run multiple scripts in parallel. The scripts needs to ensure that x scripts are always running. I trigger 6 jobs in parallel, as soon as one finishes it triggers the next one, but id something fails it should stop processing any further jobs. I was able to get hold of a script which... (7 Replies)
Discussion started by: wahi80
7 Replies
LEARN ABOUT PHP
pg_put_line
PG_PUT_LINE(3)PG_PUT_LINE(3)pg_put_line - Send a NULL-terminated string to PostgreSQL backendSYNOPSIS
bool pg_put_line ([resource $connection], string $data)
DESCRIPTION pg_put_line(3) sends a NULL-terminated string to the PostgreSQL backend server. This is needed in conjunction with PostgreSQL's COPY FROM
command.
COPY is a high-speed data loading interface supported by PostgreSQL. Data is passed in without being parsed, and in a single transaction.
An alternative to using raw pg_put_line(3) commands is to use pg_copy_from(3). This is a far simpler interface.
Note
The application must explicitly send the two characters "." on the last line to indicate to the backend that it has finished send-
ing its data, before issuing pg_end_copy(3).
Warning
Use of the pg_put_line(3) causes most large object operations, including pg_lo_read(3) and pg_lo_tell(3), to subsequently fail. You
can use pg_copy_from(3) and pg_copy_to(3) instead.
PARAMETERS
o $connection
- PostgreSQL database connection resource. When $connection is not present, the default connection is used. The default connection
is the last connection made by pg_connect(3) or pg_pconnect(3).
o $data
- A line of text to be sent directly to the PostgreSQL backend. A NULL terminator is added automatically.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
pg_put_line(3) example
<?php
$conn = pg_pconnect("dbname=foo");
pg_query($conn, "create table bar (a int4, b char(16), d float8)");
pg_query($conn, "copy bar from stdin");
pg_put_line($conn, "3 hello world 4.5
");
pg_put_line($conn, "4 goodbye world 7.11
");
pg_put_line($conn, "\.
");
pg_end_copy($conn);
?>
SEE ALSO pg_end_copy(3).
PHP Documentation Group PG_PUT_LINE(3)