01-07-2013
hi jim
I did try the same.... but i did get error...
so i taut of asking help from this forum...
m getting this var1 value from DB with a simple select query....
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
hi all,
Newbie to Unix and AIX. So my apologies if this is in the wrong place, etc.
Working on box -
uname# uname -a
AIX appt 3 5 00C08AAF4C00
when i type man (some valid command)
it just returns me to the # prompt.
Its running on the KSH shell.
man was working but i was trying... (14 Replies)
Discussion started by: djdavies
14 Replies
2. AIX
hi all,
Newbie to Unix and AIX. So my apologies if this is in the wrong place, etc.
Working on box -
uname# uname -a
AIX appt 3 5 00C08AAF4C00
when i type man (some valid command)
it just returns me to the # prompt.
Its running on the KSH shell.
man was working but i was trying... (6 Replies)
Discussion started by: djdavies
6 Replies
3. Shell Programming and Scripting
how to make a line BLINKING in output and also how to increase font size in output
suppose in run a.sh script
inside echo "hello world "
i want that this should blink in the output and also
the font size of hello world should be big ..
could you please help me out in this (3 Replies)
Discussion started by: mail2sant
3 Replies
4. UNIX for Advanced & Expert Users
#include <stdio.h>
#include <math.h>
// this function calculates the volume of a Cylinder
int main(void)
{
int r; // radius
int h; // height
double M_PI; // pi
int pOne = pow (r, 2);
// get user input of radius and height
printf ("Enter your... (3 Replies)
Discussion started by: pwanda
3 Replies
5. Shell Programming and Scripting
Hi
I'm creating a script that creates files from svn checkout and compress them using tar.gz
the script gets the repository name from command line argument
i need to capture a number from the last line of the output and create a file name from it.
the svn returns output of all the file... (5 Replies)
Discussion started by: tzvio
5 Replies
6. Shell Programming and Scripting
jnkjhjkhbjkhb (1 Reply)
Discussion started by: vinayrao
1 Replies
7. Shell Programming and Scripting
Hi Guys,
I am trying to convert a file which has a row based output to a column based output. My original file looks like this:
1
2
3
4
5
6
1
2
3
1
2
3 (8 Replies)
Discussion started by: npatwardhan
8 Replies
8. Shell Programming and Scripting
Hi,
i have a script, which is incomplete, am on my way developing it.
Input
1,12,2012,IF_TB001
2,12,2012,3K3
3,Z56,00000,25,229,K900,00, ,3G3, ,USD, ,0000000000,000, , , , 550000000
3,Z56,00000,53,411,W225,00,000, , ,USD,OM170,0000000000,000, , , , -550000000
4,Z56,COUNT, 4,SUM LOC,... (19 Replies)
Discussion started by: selvankj
19 Replies
9. Shell Programming and Scripting
Sed command to replace a line in a file using line number from the output of a pipe.
Is it possible to replace a whole line piped from someother command into a file at paritcular line...
here is some basic execution flow..
the line number is 412
lineNo=412
Now i have a line... (1 Reply)
Discussion started by: vivek d r
1 Replies
10. UNIX for Beginners Questions & Answers
Input file:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18 (6 Replies)
Discussion started by: Sagar Singh
6 Replies
LEARN ABOUT PHP
mssql_query
MSSQL_QUERY(3) MSSQL_QUERY(3)
mssql_query - Send MS SQL query
SYNOPSIS
mixed mssql_query (string $query, [resource $link_identifier], [int $batch_size])
DESCRIPTION
mssql_query(3) sends a query to the currently active database on the server that's associated with the specified link identifier.
PARAMETERS
o $query
- An SQL query.
o $link_identifier
- A MS SQL link identifier, returned by mssql_connect(3) or mssql_pconnect(3). If the link identifier isn't specified, the last
opened link is assumed. If no link is open, the function tries to establish a link as if mssql_connect(3) was called, and use it.
o $batch_size
- The number of records to batch in the buffer.
RETURN VALUES
Returns a MS SQL result resource on success, TRUE if no rows were returned, or FALSE on error.
EXAMPLES
Example #1
mssql_query(3) example
<?php
// Connect to MSSQL
$link = mssql_connect('KALLESPCSQLEXPRESS', 'sa', 'phpfi');
if (!$link || !mssql_select_db('php', $link)) {
die('Unable to connect or select database!');
}
// Do a simple query, select the version of
// MSSQL and print it.
$version = mssql_query('SELECT @@VERSION');
$row = mssql_fetch_array($version);
echo $row[0];
// Clean up
mssql_free_result($version);
?>
NOTES
Note
If the query returns multiple results then it is necessary to fetch all results by mssql_next_result(3) or free the results by
mssql_free_result(3) before executing next query.
SEE ALSO
mssql_select_db(3), mssql_connect(3).
PHP Documentation Group MSSQL_QUERY(3)