learn linux and unix commands - unix shell scripting

On ROWNUM and Limiting Results

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Limiting the Script

Greetings. I have script to monitor the disk space of folder it runs every 17 min with help of cron. It sends email when disk size reaches to 85 %. Now the issue is that it continousely generates email until we clear some space in that folder. Is it possible to restrict the Script to send only...

2. UNIX for Advanced & Expert Users

Limiting access to postqueue

Hi, I have a Debian 6 machine running Postfix 2.7.1. The email server works pretty well. I discovered that any non-root user can access to the mail queue using postqueue command just like root. How can I limit this access?

3. Solaris

Limiting Connections from a single IP

I'm looking for a way to limit connections to a Solaris 10 box from any single IP. The problem is that I've had more experience doing this with IPTables on Linux, rather than with IPFilter, which I've found to be somewhat feature-poor. I hope there is some way to do this using IPFilter, I've...

4. Shell Programming and Scripting

Can ctag and cscope support recording search results and displaying the history results ?

Hello , When using vim, can ctag and cscope support recording search results and displaying the history results ? Once I jump to one tag, I can use :tnext to jump to next tag, but how can I display the preview search result?

5. Shell Programming and Scripting

Replace first field with Rownum in a file

Hi, I've a file which is "|" delimited. I want to replace the first field with rownum, how can I do it with awk or sed command? There is no header record. sample file 1195|ABC|DEF|30 LATE DR||CHARLOTTE|NC||NONE@NONE.COM|I|1 1227|PQR|STU|3 KING DR||LIVONIA|NJ|481524071|YAHOO@YAHOO.COM|I|3...

6. Solaris

Limiting number of processors used by an application

Hello, Using a Solaris SunOS 5.10, is there anyway to limit the number of processors utilised by an external vendor application over the server, from the unix OS perspective?

7. HP-UX

Limiting SFTP Users While Not Limiting Regular Users?

Hi, I have searched the web and have come back with nothing that is satisfactory for what I require. SFTP is my corporations new file transfer standard. What I require is a method to lock down SFTP users to their directory (they may go to sub directories) while not restricting regular users. ...

8. HP-UX

limiting failed logins to three

I have tried limiting failed logins to three by the following method logins -ox \ | awk -F: '($8 != "LK" && $1 != "root") { print $1 }' \ | while read logname; do /usr/lbin/modprpw -m umaxlntr=3 "$logname" done /usr/lbin/modprdef -m umaxlntr=3 but it is failing on the 4th... any ideas?...

9. Cybersecurity

Problem with limiting logins to one in AIX 5.3

I am migrating from 5.2 to 5.3 AIX. In previous versions of AIX, including 5.2, I've been able to limit user's logins to 1 by using the following script named Block_user: #!/bin/ksh USER=$1 NUM=`who | grep $USER | cut -c1-8 | wc -l` #The above ' is not a single quote but back quote if ]...

10. UNIX for Dummies Questions & Answers

Limiting access

Hi, I'm new to linux and unix, and i have couple of problems: 1) how can i limit the access for a user, for example, i created a user, and i want that this user will be able to be only in one directory, and will see only the files i want him to. 2) I have a domain name, and i want that every...

LEARN ABOUT PHP

sqlsrv_next_result

SQLSRV_NEXT_RESULT(3)													     SQLSRV_NEXT_RESULT(3)

sqlsrv_next_result - Makes the next result of the specified statement active

SYNOPSIS

       mixed sqlsrv_next_result (resource  $stmt)

DESCRIPTION

	Makes the next result of the specified statement active. Results include result sets, row counts, and output parameters.

PARAMETERS

	      o $stmt
		- The statment on which the next result is being called.

RETURN VALUES

	Returns TRUE if the next result was successfully retrieved, FALSE if an error occurred, and NULL if there are no more results to retrieve.

EXAMPLES

       Example #1

	      sqlsrv_next_result(3) example

	       The  following  example executes a batch query that inserts into a table and then selects from the table. This produces two results
	      on the statement: one for the rows affected by the INSERT and one for the rows returned by the SELECT. To get to the  rows  returned
	      by the SELECT, sqlsrv_next_result(3) must be called to move past the first result.

	      <?php
	      $serverName = "serverNamesqlexpress";
	      $connectionInfo = array("Database"=>"dbName", "UID"=>"userName", "PWD"=>"password");
	      $conn = sqlsrv_connect( $serverName, $connectionInfo);

	      $query = "INSERT INTO Table_1 (id, data) VALUES (?,?); SELECT * FROM TABLE_1;";
	      $params = array(1, "some data");
	      $stmt = sqlsrv_query($conn, $query, $params);

	      // Consume the first result (rows affected by INSERT) without calling sqlsrv_next_result.
	      echo "Rows affected: ".sqlsrv_rows_affected($stmt)."<br />";

	      // Move to the next result and display results.
	      $next_result = sqlsrv_next_result($stmt);
	      if( $next_result ) {
		 while( $row = sqlsrv_fetch_array( $stmt, SQLSRV_FETCH_ASSOC)){
		    echo $row['id'].": ".$row['data']."<br />";
		 }
	      } elseif( is_null($next_result)) {
		   echo "No more results.<br />";
	      } else {
		   die(print_r(sqlsrv_errors(), true));
	      }
	      ?>

SEE ALSO

       sqlsrv_query(3), sqlsrv_fetch_array(3), sqlsrv_rows_affected(3).

PHP Documentation Group 												     SQLSRV_NEXT_RESULT(3)