07-11-2013
put NULL in double quotes.. and if you are equating string better use = than -eq
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello
I want to check for NULL variable..
but this is not working..please help
thanks in advance
esham (2 Replies)
Discussion started by: esham
2 Replies
2. Shell Programming and Scripting
Hi,
i wrote If Conditions in my script, it's returns null and some values.
but i am unable to find when Null value getting. bec we need modification according null vales.
pls help me on this. (2 Replies)
Discussion started by: koti_rama
2 Replies
3. Shell Programming and Scripting
korn shell
If
then
update_smartcare_user_password "$u_id"
else
echo "Not a database user"
fi
i get this error
Syntax error at line *** : `then' is not expected.
what should i do.
I want to check whether $a is null or not. (2 Replies)
Discussion started by: sachin.gangadha
2 Replies
4. UNIX for Dummies Questions & Answers
Hi
I have a input file with many fields and each filed will be with in double quotes(""). i want to check fields contains balnk,null or space using condition using if. when i write code as below for if condition its not working
a=`awk -F ',' '{gsub("\"", "", $1);'NF==0';printf $1}'... (3 Replies)
Discussion started by: jayakumarrt
3 Replies
5. Shell Programming and Scripting
Hi,
I have variables like
var1
var2
var3
var4
in
if loop i am trying to check the condition
if(variable == "var") then
echo $variable
endif (0 Replies)
Discussion started by: vasanth.vadalur
0 Replies
6. Shell Programming and Scripting
hi,
i have 3 lines of output , if second line exists then only condition within the if loop has to exeute other wise it has exit from loop.
i had tried like this but not getting
please help me ...
Code:
if ; then
echo "success"
else
echo ""
Use code tags please,... (8 Replies)
Discussion started by: sreelu
8 Replies
7. Shell Programming and Scripting
Hi Champs!!!
im a newbie in unix, need ur expert help for my problem...
I need to search if there are any "NULL" entries in the string
String without Null
Str1: 203652|1000003653|tellt|RUPV|4649|1|07/28/2011 01:56:12
String with Null (RUPV is removed)
Str2:... (5 Replies)
Discussion started by: guruprasad7
5 Replies
8. Shell Programming and Scripting
Hello experts,
I'm stuck with this script for three days now. Here's what i need.
I need to split a large delimited (,) file into 2 files based on the value present in the last field.
Samp: Something.csv
bca,adc,asdf,123,12C
bca,adc,asdf,123,13C
def,adc,asdf,123,12A
I need this split... (6 Replies)
Discussion started by: shell_boy23
6 Replies
9. Shell Programming and Scripting
Hi,
I have a log file which is having some xml tags. I need to check the value for a particular xml field is null or not and if it is null i have to add current time as the value for that xml field.
I tried below code to check whether the word count is 0. But even if the xml field is null it... (16 Replies)
Discussion started by: Neethu
16 Replies
10. Shell Programming and Scripting
i have this code
for i in `cat sql_output.txt`
do
-- some script commands
done
sql_output.txt has 1 column with employee_ids
If the sql_output.txt is null then the do loop should not execute.
How can i implement this.
for i in `cat sql_output.txt`
If i is null or empty
then ... (5 Replies)
Discussion started by: rafa_fed2
5 Replies
LEARN ABOUT PHP
pg_escape_identifier
PG_ESCAPE_IDENTIFIER(3) PG_ESCAPE_IDENTIFIER(3)
pg_escape_identifier - Escape a identifier for insertion into a text field
SYNOPSIS
string pg_escape_identifier ([resource $connection], string $data)
DESCRIPTION
pg_escape_identifier(3) escapes a identifier (e.g. table, field names) for quering the database. It returns an escaped identifier string
for PostgreSQL server. pg_escape_identifier(3) adds double quotes before and after data. Users should not add double quotes. Use of this
function is recommended for identifier parameters in query. For SQL literals (i.e. parameters except bytea), pg_escape_literal(3) or
pg_escape_string(3) muse be used. For bytea type fields, pg_escape_bytea(3) must be used instead.
Note
This function has internal escape code and can also be used with PostgreSQL 8.4 or less.
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 string containing text to be escaped.
RETURN VALUES
A string containing the escaped data.
EXAMPLES
Example #1
pg_escape_identifier(3) example
<?php
// Connect to the database
$dbconn = pg_connect('dbname=foo');
// Escape the table name data
$escaped = pg_escape_identifier($table_name);
// Select rows from $table_name
pg_query("SELECT * FROM {$escaped};");
?>
SEE ALSO
pg_escape_literal(3), pg_escape_bytea(3), pg_escape_string(3).
PHP Documentation Group PG_ESCAPE_IDENTIFIER(3)