07-25-2018
executesql is the first obvious thing to check it, perhaps there's an sql error of some sort.
9 More Discussions You Might Find Interesting
1. HP-UX
Can someone tell me the right or exact syntax to check if the large file options is set on a filesystem
Thanks! (2 Replies)
Discussion started by: catwomen
2 Replies
2. AIX
Hello,
I get this message : "Value too large to be stored in data type" when I try to open a 3Gb file.
Can someone helps me to resolve the problem.
Thank you very much (5 Replies)
Discussion started by: limame
5 Replies
3. Shell Programming and Scripting
Hi all,
I have a large log file that gets created daily.
I need to be able to pull text out of the log when I hit a pattern including the 7 lines above it and the 3 lines below and output it to a new text file.
Line 1
Line 2
Line 3
Line 4
Line 5
Line 6
Line 7
Pattern
Line 9
Line 10... (11 Replies)
Discussion started by: bas
11 Replies
4. Shell Programming and Scripting
Hi! I have a large set of pairs of text files (each pair in their own subdirectory) and each pair shares head/tail (a couple of first and last lines) but differs in the middle part. I need to delete the heads/tails and keep only the middle portions in which they differ. The lengths of heads/tails... (1 Reply)
Discussion started by: dobryden
1 Replies
5. Shell Programming and Scripting
I need to find some data in a large no. of files. The data is in the following format :
VALUE A VALUE B VALUE C VALUE D
10 4 65 1
12 4.5 65.5 2
10.75 5.1 ... (2 Replies)
Discussion started by: cooker97
2 Replies
6. Shell Programming and Scripting
Hi all,
I need a script to delete a large set of files from a directory under / based on an input file and want to redirect errors into separate file.
I have already prepared a list of files in the input file.
Kndly help me.
Thanks,
Prash (36 Replies)
Discussion started by: prash358
36 Replies
7. AIX
root@test8:/config1>oslevel -s
5300-01-00-0000
root@test8:/config1>oslevel -r
5300-01
while moving a file sized 9GB i got this message
root@test8:/configapp>mv bkp_14JUN16_oraapp_2.tgz /oraapp
bkp_14JUN16_oraapp_2.tgz: Value too large to be stored in data type.
possibly need APAR... (2 Replies)
Discussion started by: filosophizer
2 Replies
8. UNIX for Beginners Questions & Answers
Hi
I have the following sample of data: my full data dimention is 900,000* 1119
rs987435 C G 1 1 1 0 2
rs345783 C G 0 0 1 0 0
rs955894 G T 1 1 2 2 1
rs6088791 ... (7 Replies)
Discussion started by: marwah
7 Replies
9. Shell Programming and Scripting
Hello!
I have quite a bit of map data that I have to edit. I originally had a DOS script that would reverse x1, y1 coordinates in order to change the direction of a particular segment in a map file. It worked wonderfully and all was well, but my bossman told me that there is a boatload of nodes... (9 Replies)
Discussion started by: Mothra
9 Replies
LEARN ABOUT PHP
mssql_fetch_row
MSSQL_FETCH_ROW(3) MSSQL_FETCH_ROW(3)
mssql_fetch_row - Get row as enumerated array
SYNOPSIS
array mssql_fetch_row (resource $result)
DESCRIPTION
mssql_fetch_row(3) fetches one row of data from the result associated with the specified result identifier. The row is returned as an
array. Each result column is stored in an array offset, starting at offset 0.
Subsequent call to mssql_fetch_row(3) would return the next row in the result set, or FALSE if there are no more rows.
PARAMETERS
o $result
- The result resource that is being evaluated. This result comes from a call to mssql_query(3).
RETURN VALUES
Returns an array that corresponds to the fetched row, or FALSE if there are no more rows.
EXAMPLES
Example #1
mssql_fetch_row(3) example
<?php
// Connect to MSSQL and select the database
$link = mssql_connect('MANGOSQLEXPRESS', 'sa', 'phpfi');
mssql_select_db('php', $link);
// Query to execute
$query = mssql_query('SELECT [id], [quote] FROM [quotes] WHERE [id] = '42'', $link);
// Did the query fail?
if (!$query) {
die('MSSQL error: ' . mssql_get_last_message());
}
// Fetch the row
$row = mssql_fetch_row($query);
// Print the 'quote'
echo 'Quote #' . $row[0] . ': "' . $row[1] . '"';
?>
The above example will output something similar to:
Quote #42: "The answer to everything..."
NOTES
Note
This function sets NULL fields to the PHP NULL value.
SEE ALSO
mssql_fetch_array(3), mssql_fetch_object(3), mssql_data_seek(3), mssql_result(3).
PHP Documentation Group MSSQL_FETCH_ROW(3)