04-10-2007
7 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Is there anyway to use the fr*$%& number pad in VI?
Anyway? Anyway at all?
All it does now random movements and inserts of characters (2 Replies)
Discussion started by: nelsonenzo
2 Replies
2. Shell Programming and Scripting
Pad zeros to a number and assign it to a variable
like i get 1 in $i ,i want it to be $i as 01 (6 Replies)
Discussion started by: anumkoshy
6 Replies
3. UNIX for Dummies Questions & Answers
Hi All
I need a pad a . to befoure a last digi
ex 1258 --> 125.8
help to do
thanks (4 Replies)
Discussion started by: nalakaatslt
4 Replies
4. Programming
I need to right-pad with zeros a string by using (s)printf.
I looked up the manual and tried with
printf("%-19s", buffer);
which right-pad the string with spaces. So I tried
printf("%019s", buffer);
which left-pad the string with zeros. So I tried both
printf("%-019s", buffer);... (9 Replies)
Discussion started by: emitrax
9 Replies
5. Shell Programming and Scripting
I have number/strings like below
input =23412133
output = 234121330000 (depends on the number give at runtime)
i need to padd zeros based on runtime input . i tried below
printf ' %d%04d\n', "23412133";
But the precision 4 is static here how can i pass this as runtime input.
i am... (11 Replies)
Discussion started by: greenworld123
11 Replies
6. Shell Programming and Scripting
I'm using cygwin bash to submit scheduled tasks (kinda like cron jobs) in windows and the following script is giving me grief. I need to format the current time with leading zeros before 10AM for the hour field. In this example, I manually typed in "09:50" instead of using the `printf...`... (2 Replies)
Discussion started by: siegfried
2 Replies
7. UNIX for Beginners Questions & Answers
I need to pad 0 to a number on the right. to make it 9 digit in total.
My number is 2457
output should be 245700000
Please do wrap your samples/codes into CODE TAGS as per forum rules. (3 Replies)
Discussion started by: varun22486
3 Replies
LEARN ABOUT PHP
maxdb_sqlstate
MAXDB_SQLSTATE(3) 1 MAXDB_SQLSTATE(3)
maxdb_sqlstate - Returns the SQLSTATE error from previous MaxDB operation
Procedural style
SYNOPSIS
string maxdb_sqlstate (resource $link)
DESCRIPTION
Object oriented style
string$maxdb->sqlstate ()
Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. '00000' means no
error. The values are specified by ANSI SQL and ODBC.
Note
Note that not all MaxDB errors are yet mapped to SQLSTATE's. The value HY000 (general error) is used for unmapped errors.
RETURN VALUES
Returns a string containing the SQLSTATE error code for the last error. The error code consists of five characters. '00000' means no
error.
EXAMPLES
Example #1
Object oriented style
<?php
$maxdb = new maxdb("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
/* Table City already exists, so we should get an error */
if (!$maxdb->query("CREATE TABLE hotel.city (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.
", $maxdb->sqlstate);
}
$maxdb->close();
?>
Example #2
Procedural style
<?php
$link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
/* Table City already exists, so we should get an error */
if (!maxdb_query($link, "CREATE TABLE hotel.city (ID INT, Name VARCHAR(30))")) {
printf("Error - SQLSTATE %s.
", maxdb_sqlstate($link));
}
maxdb_close($link);
?>
The above example will output something similar to:
Warning: maxdb_query(): -6000 POS(20) Duplicate table name:CITY [I6000] <...>
Error - SQLSTATE I6000.
SEE ALSO
maxdb_errno(3), maxdb_error(3).
PHP Documentation Group MAXDB_SQLSTATE(3)