It is not working because you are using repeated formatting i.e. "%-15s %-20s %-20s\n" The following example shows one way of doing it (I just used one escape sequence to keep it simple).
Hi,
I am very confused with my printf command.
Somehow one variable can't line up with others...
newstart2 ="Mon Nov 11 01 00:00:00 2002"
printf "%-20s" $newstart2
Here is the output:
Mon Nov 11
01 00:00:00 2002
It spread out to two lines..
Why? (1 Reply)
Hi All,
is it poosible to Print the error messages in colors.., i am using KSH...,
i have tried the following,
echo "\033 Hi This is Sam!!!
But, when i tried to redirect in to a log file, i am getting as follows,
echo "\033 1 line, 31 characters
^[[34m Hi This is Sikki!!! ^[[0m
... (0 Replies)
Hello,
Could someone please help me to convert a string(s) of comma separated values into space padded columns in .ksh?
ex.
10-21-2008,someword,blah,127.0.0.1,8,3
10-21-2008,randomword,ick,128.0.111.128,1,0
converted to
10-21-2008 someword blah 127.0.0.1 8... (6 Replies)
1-) For the command below, I want to read second column: 32751. How will I get it ?
$ ps -ef|grep deneme
U00 32751 22745 0 16:30 pts/1 00:00:00 ksh deneme
U00 32762 32132 0 16:30 pts/2 00:00:00 grep deneme
2-) For the command below, how will I read all lines line by line? For... (1 Reply)
#!/usr/bin/ksh
var1="Hi World"
var2="Morning"
var3=$(echo "$var1" \n "$var2")
echo $var3
var3=$(printf "$var1 \n $var2")
echo $var3
Output
Any way to get
in my $var3 ? (7 Replies)
Hi ALL,
I am using SunOS 5.9 and KSH(bin/ksh)
The problem am facing is
error message diaplyed on screen
printf: 12099415.79 not completely converted
printf: + expected numeric value
printf: 11898578.29 not completely converted
When i try printing with
The output is... (6 Replies)
Hi All,
I am attempting to create a fixed length tilde delimited file using printf.
The variables are initialized to fixed length blank spaces
a=' '
b=' '
c=' '
d=' '
Sometimes the variable might contain values and sometimes they are... (5 Replies)
Hi all,
i have written this script:
awk -F';' '
BEGIN {
printf "\n"
printf "\n"
printf "\n"
printf "----------------------------------------------\n"
print " For test "
printf "----------------------------------------------\n"
test_200 = 0
test_300 = 0
test_500 = 0
test_1000 = 0... (11 Replies)
Hi,
I am trying to put stty columns 140 in .profile to set column width to 140 so I don't have to manully do it every time.
My main goal is to avoid seeing "Terminal too wide" message whenever I try to use vi editor in full screen.
I am on korn shell
echo $SHELL
/bin/ksh
So even... (8 Replies)
Discussion started by: pat_pramod
8 Replies
LEARN ABOUT PHP
cubrid_next_result
CUBRID_NEXT_RESULT(3) 1 CUBRID_NEXT_RESULT(3)cubrid_next_result - Get result of next query when executing multiple SQL statementsSYNOPSIS
bool cubrid_next_result (resource $result)
DESCRIPTION
The cubrid_next_result(3) function is used to get results of next query if multiple SQL statements are executed and CUBRID_EXEC_QUERY_ALL
flag is set upon cubrid_execute(3).
PARAMETERS
o $result
-$result comes from a call to cubrid_execute(3)RETURN VALUES
TRUE, when process is successful.
FALSE, when process is unsuccessful.
EXAMPLES
Example #1
cubrid_next_result(3) example
<?php
$conn = cubrid_connect("127.0.0.1", 33000, "demodb", "dba");
$sql_stmt = "SELECT * FROM code; SELECT * FROM history WHERE host_year=2004 AND event_code=20281";
$res = cubrid_execute($conn, $sql_stmt, CUBRID_EXEC_QUERY_ALL);
get_result_info($res);
cubrid_next_result($res);
get_result_info($res);
function get_result_info($req)
{
printf("
------------ get_result_info --------------------
");
$row_num = cubrid_num_rows($req);
$col_num = cubrid_num_cols($req);
$column_name_list = cubrid_column_names($req);
$column_type_list = cubrid_column_types($req);
$column_last_name = cubrid_field_name($req, $col_num - 1);
$column_last_table = cubrid_field_table($req, $col_num - 1);
$column_last_type = cubrid_field_type($req, $col_num - 1);
$column_last_len = cubrid_field_len($req, $col_num - 1);
$column_1_flags = cubrid_field_flags($req, 1);
printf("%-30s %d
", "Row count:", $row_num);
printf("%-30s %d
", "Column count:", $col_num);
printf("
");
printf("%-30s %-30s %-15s
", "Column Names", "Column Types", "Column Len");
printf("------------------------------------------------------------------------------
");
$size = count($column_name_list);
for($i = 0; $i < $size; $i++) {
$column_len = cubrid_field_len($req, $i);
printf("%-30s %-30s %-15s
", $column_name_list[$i], $column_type_list[$i], $column_len);
}
printf("
");
printf("%-30s %s
", "Last Column Name:", $column_last_name);
printf("%-30s %s
", "Last Column Table:", $column_last_table);
printf("%-30s %s
", "Last Column Type:", $column_last_type);
printf("%-30s %d
", "Last Column Len:", $column_last_len);
printf("%-30s %s
", "Second Column Flags:", $column_1_flags);
printf("
");
}
?>
The above example will output:
------------ get_result_info --------------------
Row count: 6
Column count: 2
Column Names Column Types Column Len
------------------------------------------------------------------------------
s_name char 1
f_name varchar 6
Last Column Name: f_name
Last Column Table: code
Last Column Type: varchar
Last Column Len: 6
Second Column Flags:
------------ get_result_info --------------------
Row count: 4
Column count: 5
Column Names Column Types Column Len
------------------------------------------------------------------------------
event_code integer 11
athlete varchar 40
host_year integer 11
score varchar 10
unit varchar 5
Last Column Name: unit
Last Column Table: history
Last Column Type: varchar
Last Column Len: 5
Second Column Flags: not_null primary_key unique_key
SEE ALSO cubrid_execute(3).
PHP Documentation Group CUBRID_NEXT_RESULT(3)