Professional Web Applications Themes

#38784 [NEW]: odbc_fetch_row call - PHP Bugs

From: keagle at westar dot com Operating system: Windows XP PHP version: 4.4.4 PHP Bug Type: Performance problem Bug description: odbc_fetch_row call Description: ------------ I'm having a problem getting 'odbc_fetch_row' to return true. Therefore, I am unable to fetch each row of my table. Is there something I'm leaving out in my code? I've tried everything I can think of. Please help. Thank you. Reproduce code: --------------- $sql = "SELECT PARAMETER_ID, DESCRIPTION from MDR_PARAM"; $res = odbc_exec($conn, $sql); $num_rows = odbc_num_rows($res); $num_fields = odbc_num_fields($res); $parameter_counter = 0; if(odbc_fetch_row($res, 0)) echo("odbc_fetch_row: SUCCESS ...\n\n"); else echo("odbc_fetch_row: FAILURE ...\n\n"); while(odbc_fetch_row($res)) { $param_id = ...

  1. #1

    Default #38784 [NEW]: odbc_fetch_row call

    From: keagle at westar dot com
    Operating system: Windows XP
    PHP version: 4.4.4
    PHP Bug Type: Performance problem
    Bug description: odbc_fetch_row call

    Description:
    ------------
    I'm having a problem getting 'odbc_fetch_row' to return true. Therefore, I
    am unable to fetch each row of my table. Is there something I'm leaving out
    in my code? I've tried everything I can think of. Please help. Thank you.


    Reproduce code:
    ---------------
    $sql = "SELECT PARAMETER_ID, DESCRIPTION from MDR_PARAM";
    $res = odbc_exec($conn, $sql);

    $num_rows = odbc_num_rows($res);
    $num_fields = odbc_num_fields($res);

    $parameter_counter = 0;

    if(odbc_fetch_row($res, 0))
    echo("odbc_fetch_row: SUCCESS ...\n\n");
    else
    echo("odbc_fetch_row: FAILURE ...\n\n");

    while(odbc_fetch_row($res)) {
    $param_id = odbc_result($res, "PARAMETER_ID");
    $description = odbc_result($res, "DESCRIPTION");

    $mdr_parameters[$description] = $param_id;
    $parameter_counter++;
    }
    $r = odbc_free_result($res);

    Expected result:
    ----------------
    I would have expected "SUCCESS" to be output as opposed the "FAILURE"
    following the 'if' statement. And, I would have expected to fall into the
    'while' loop, but to no avail.

    Actual result:
    --------------
    odbc_fetch_row: FAILURE ...

    --
    Edit bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    --
    Try a CVS snapshot (PHP 4.4): [url]http://bugs.php.net/fix.php?id=38784&r=trysnapshot44[/url]
    Try a CVS snapshot (PHP 5.2): [url]http://bugs.php.net/fix.php?id=38784&r=trysnapshot52[/url]
    Try a CVS snapshot (PHP 6.0): [url]http://bugs.php.net/fix.php?id=38784&r=trysnapshot60[/url]
    Fixed in CVS: [url]http://bugs.php.net/fix.php?id=38784&r=fixedcvs[/url]
    Fixed in release: [url]http://bugs.php.net/fix.php?id=38784&r=alreadyfixed[/url]
    Need backtrace: [url]http://bugs.php.net/fix.php?id=38784&r=needtrace[/url]
    Need Reproduce Script: [url]http://bugs.php.net/fix.php?id=38784&r=needscript[/url]
    Try newer version: [url]http://bugs.php.net/fix.php?id=38784&r=oldversion[/url]
    Not developer issue: [url]http://bugs.php.net/fix.php?id=38784&r=support[/url]
    Expected behavior: [url]http://bugs.php.net/fix.php?id=38784&r=notwrong[/url]
    Not enough info: [url]http://bugs.php.net/fix.php?id=38784&r=notenoughinfo[/url]
    Submitted twice: [url]http://bugs.php.net/fix.php?id=38784&r=submittedtwice[/url]
    register_globals: [url]http://bugs.php.net/fix.php?id=38784&r=globals[/url]
    PHP 3 support discontinued: [url]http://bugs.php.net/fix.php?id=38784&r=php3[/url]
    Daylight Savings: [url]http://bugs.php.net/fix.php?id=38784&r=dst[/url]
    IIS Stability: [url]http://bugs.php.net/fix.php?id=38784&r=isapi[/url]
    Install GNU Sed: [url]http://bugs.php.net/fix.php?id=38784&r=gnused[/url]
    Floating point limitations: [url]http://bugs.php.net/fix.php?id=38784&r=float[/url]
    No Zend Extensions: [url]http://bugs.php.net/fix.php?id=38784&r=nozend[/url]
    MySQL Configuration Error: [url]http://bugs.php.net/fix.php?id=38784&r=mysqlcfg[/url]
    keagle at westar dot com Guest

  2. #2

    Default #38784 [Opn->Bgs]: odbc_fetch_row call

    ID: 38784
    Updated by: [email]tony2001php.net[/email]
    Reported By: jkeagle at knology dot net
    -Status: Open
    +Status: Bogus
    -Bug Type: Performance problem
    +Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:
    >odbc_fetch_row($res, 0)
    The row number is 1-based.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-11 21:51:31] jkeagle at knology dot net

    Note: num_rows & num_fields were output and return valid numbers.

    ------------------------------------------------------------------------

    [2006-09-11 21:48:14] jkeagle at knology dot net

    Description:
    ------------
    I'm having a problem getting 'odbc_fetch_row' to return true.
    Therefore, I am unable to fetch each row of my table. Is there
    something I'm leaving out in my code? I've tried everything I can think
    of. Please help. Thank you.

    Reproduce code:
    ---------------
    $sql = "SELECT PARAMETER_ID, DESCRIPTION from MDR_PARAM";
    $res = odbc_exec($conn, $sql);

    $num_rows = odbc_num_rows($res);
    $num_fields = odbc_num_fields($res);

    $parameter_counter = 0;

    if(odbc_fetch_row($res, 0))
    echo("odbc_fetch_row: SUCCESS ...\n\n");
    else
    echo("odbc_fetch_row: FAILURE ...\n\n");

    while(odbc_fetch_row($res)) {
    $param_id = odbc_result($res, "PARAMETER_ID");
    $description = odbc_result($res, "DESCRIPTION");

    $mdr_parameters[$description] = $param_id;
    $parameter_counter++;
    }
    $r = odbc_free_result($res);

    Expected result:
    ----------------
    I would have expected "SUCCESS" to be output as opposed the "FAILURE"
    following the 'if' statement. And, I would have expected to fall into
    the 'while' loop, but to no avail.

    Actual result:
    --------------
    odbc_fetch_row: FAILURE ...


    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    tony2001@php.net Guest

  3. #3

    Default #38784 [Bgs]: odbc_fetch_row call

    ID: 38784
    User updated by: jkeagle at knology dot net
    Reported By: jkeagle at knology dot net
    Status: Bogus
    Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:

    Could you be more specific?


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-12 09:33:00] [email]tony2001php.net[/email]
    >odbc_fetch_row($res, 0)
    The row number is 1-based.

    ------------------------------------------------------------------------

    [2006-09-11 21:51:31] jkeagle at knology dot net

    Note: num_rows & num_fields were output and return valid numbers.

    ------------------------------------------------------------------------

    [2006-09-11 21:48:14] jkeagle at knology dot net

    Description:
    ------------
    I'm having a problem getting 'odbc_fetch_row' to return true.
    Therefore, I am unable to fetch each row of my table. Is there
    something I'm leaving out in my code? I've tried everything I can think
    of. Please help. Thank you.

    Reproduce code:
    ---------------
    $sql = "SELECT PARAMETER_ID, DESCRIPTION from MDR_PARAM";
    $res = odbc_exec($conn, $sql);

    $num_rows = odbc_num_rows($res);
    $num_fields = odbc_num_fields($res);

    $parameter_counter = 0;

    if(odbc_fetch_row($res, 0))
    echo("odbc_fetch_row: SUCCESS ...\n\n");
    else
    echo("odbc_fetch_row: FAILURE ...\n\n");

    while(odbc_fetch_row($res)) {
    $param_id = odbc_result($res, "PARAMETER_ID");
    $description = odbc_result($res, "DESCRIPTION");

    $mdr_parameters[$description] = $param_id;
    $parameter_counter++;
    }
    $r = odbc_free_result($res);

    Expected result:
    ----------------
    I would have expected "SUCCESS" to be output as opposed the "FAILURE"
    following the 'if' statement. And, I would have expected to fall into
    the 'while' loop, but to no avail.

    Actual result:
    --------------
    odbc_fetch_row: FAILURE ...


    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    jkeagle at knology dot net Guest

  4. #4

    Default #38784 [Bgs->Opn]: odbc_fetch_row call

    ID: 38784
    User updated by: keagle at westar dot com
    -Reported By: jkeagle at knology dot net
    +Reported By: keagle at westar dot com
    -Status: Bogus
    +Status: Open
    Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:

    By stating that the row number is "1-based", do you mean that rows are
    indexed (1 .. last)? If so, this doesn't help answer my question. The
    call returns false(0) regardless of the parameters passed into the call
    (1 or 0). Why is it that I can't get a positive value returned out of
    this call? It doesn't make sense. odbc_fatch_row($res) always returns a
    negative value and odbc_result won't return anything I can use.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-12 13:40:06] jkeagle at knology dot net

    Could you be more specific?

    ------------------------------------------------------------------------

    [2006-09-12 09:33:00] [email]tony2001php.net[/email]
    >odbc_fetch_row($res, 0)
    The row number is 1-based.

    ------------------------------------------------------------------------

    [2006-09-11 21:51:31] jkeagle at knology dot net

    Note: num_rows & num_fields were output and return valid numbers.

    ------------------------------------------------------------------------

    [2006-09-11 21:48:14] keagle at westar dot com

    Description:
    ------------
    I'm having a problem getting 'odbc_fetch_row' to return true.
    Therefore, I am unable to fetch each row of my table. Is there
    something I'm leaving out in my code? I've tried everything I can think
    of. Please help. Thank you.

    Reproduce code:
    ---------------
    $sql = "SELECT PARAMETER_ID, DESCRIPTION from MDR_PARAM";
    $res = odbc_exec($conn, $sql);

    $num_rows = odbc_num_rows($res);
    $num_fields = odbc_num_fields($res);

    $parameter_counter = 0;

    if(odbc_fetch_row($res, 0))
    echo("odbc_fetch_row: SUCCESS ...\n\n");
    else
    echo("odbc_fetch_row: FAILURE ...\n\n");

    while(odbc_fetch_row($res)) {
    $param_id = odbc_result($res, "PARAMETER_ID");
    $description = odbc_result($res, "DESCRIPTION");

    $mdr_parameters[$description] = $param_id;
    $parameter_counter++;
    }
    $r = odbc_free_result($res);

    Expected result:
    ----------------
    I would have expected "SUCCESS" to be output as opposed the "FAILURE"
    following the 'if' statement. And, I would have expected to fall into
    the 'while' loop, but to no avail.

    Actual result:
    --------------
    odbc_fetch_row: FAILURE ...


    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    keagle at westar dot com Guest

  5. #5

    Default #38784 [Opn->Bgs]: odbc_fetch_row call

    ID: 38784
    Updated by: [email]tony2001php.net[/email]
    Reported By: keagle at westar dot com
    -Status: Open
    +Status: Bogus
    Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:

    Use odbc_errormsg() to get the reson why it fails.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-12 14:59:34] keagle at westar dot com

    By stating that the row number is "1-based", do you mean that rows are
    indexed (1 .. last)? If so, this doesn't help answer my question. The
    call returns false(0) regardless of the parameters passed into the call
    (1 or 0). Why is it that I can't get a positive value returned out of
    this call? It doesn't make sense. odbc_fatch_row($res) always returns a
    negative value and odbc_result won't return anything I can use.

    ------------------------------------------------------------------------

    [2006-09-12 13:40:06] jkeagle at knology dot net

    Could you be more specific?

    ------------------------------------------------------------------------

    [2006-09-12 09:33:00] [email]tony2001php.net[/email]
    >odbc_fetch_row($res, 0)
    The row number is 1-based.

    ------------------------------------------------------------------------

    [2006-09-11 21:51:31] jkeagle at knology dot net

    Note: num_rows & num_fields were output and return valid numbers.

    ------------------------------------------------------------------------

    [2006-09-11 21:48:14] keagle at westar dot com

    Description:
    ------------
    I'm having a problem getting 'odbc_fetch_row' to return true.
    Therefore, I am unable to fetch each row of my table. Is there
    something I'm leaving out in my code? I've tried everything I can think
    of. Please help. Thank you.

    Reproduce code:
    ---------------
    $sql = "SELECT PARAMETER_ID, DESCRIPTION from MDR_PARAM";
    $res = odbc_exec($conn, $sql);

    $num_rows = odbc_num_rows($res);
    $num_fields = odbc_num_fields($res);

    $parameter_counter = 0;

    if(odbc_fetch_row($res, 0))
    echo("odbc_fetch_row: SUCCESS ...\n\n");
    else
    echo("odbc_fetch_row: FAILURE ...\n\n");

    while(odbc_fetch_row($res)) {
    $param_id = odbc_result($res, "PARAMETER_ID");
    $description = odbc_result($res, "DESCRIPTION");

    $mdr_parameters[$description] = $param_id;
    $parameter_counter++;
    }
    $r = odbc_free_result($res);

    Expected result:
    ----------------
    I would have expected "SUCCESS" to be output as opposed the "FAILURE"
    following the 'if' statement. And, I would have expected to fall into
    the 'while' loop, but to no avail.

    Actual result:
    --------------
    odbc_fetch_row: FAILURE ...


    ------------------------------------------------------------------------


    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    tony2001@php.net Guest

  6. #6

    Default #38784 [Bgs->Opn]: odbc_fetch_row call

    ID: 38784
    User updated by: jkeagle at knology dot net
    -Reported By: keagle at westar dot com
    +Reported By: jkeagle at knology dot net
    -Status: Bogus
    +Status: Open
    Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:

    I tried the odbc_errormsg() call and got an empty string. I also tried
    odbc_error() and got the same result.
    The problem is that a negative value is returned for each call to
    odbc_fetch_row as if there are no rows to fetch. What is misleading is
    that I can execute odbc_num_rows($res) and get 662, which is what I
    expected to get. Also, a call to odbc_num_fields($res) was called and
    returned the expected value of 2. What I don't understand is why I
    can't "fetch a row" out the same result variable ($res). Everytime I
    make a call to odbc_fetch_row($res), a negative value (0) is returned.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-12 16:45:59] [email]tony2001php.net[/email]

    Use odbc_errormsg() to get the reson why it fails.

    ------------------------------------------------------------------------

    [2006-09-12 14:59:34] keagle at westar dot com

    By stating that the row number is "1-based", do you mean that rows are
    indexed (1 .. last)? If so, this doesn't help answer my question. The
    call returns false(0) regardless of the parameters passed into the call
    (1 or 0). Why is it that I can't get a positive value returned out of
    this call? It doesn't make sense. odbc_fatch_row($res) always returns a
    negative value and odbc_result won't return anything I can use.

    ------------------------------------------------------------------------

    [2006-09-12 13:40:06] jkeagle at knology dot net

    Could you be more specific?

    ------------------------------------------------------------------------

    [2006-09-12 09:33:00] [email]tony2001php.net[/email]
    >odbc_fetch_row($res, 0)
    The row number is 1-based.

    ------------------------------------------------------------------------

    [2006-09-11 21:51:31] jkeagle at knology dot net

    Note: num_rows & num_fields were output and return valid numbers.

    ------------------------------------------------------------------------

    The remainder of the comments for this report are too long. To view
    the rest of the comments, please view the bug report online at
    [url]http://bugs.php.net/38784[/url]

    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    jkeagle at knology dot net Guest

  7. #7

    Default #38784 [Opn->Bgs]: odbc_fetch_row call

    ID: 38784
    Updated by: [email]kalowskyphp.net[/email]
    Reported By: jkeagle at knology dot net
    -Status: Open
    +Status: Bogus
    Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:

    Why are you trusting odbc_num_rows?

    And fix your odbc_fetch_row call.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-12 18:04:20] jkeagle at knology dot net

    I tried the odbc_errormsg() call and got an empty string. I also tried
    odbc_error() and got the same result.
    The problem is that a negative value is returned for each call to
    odbc_fetch_row as if there are no rows to fetch. What is misleading is
    that I can execute odbc_num_rows($res) and get 662, which is what I
    expected to get. Also, a call to odbc_num_fields($res) was called and
    returned the expected value of 2. What I don't understand is why I
    can't "fetch a row" out the same result variable ($res). Everytime I
    make a call to odbc_fetch_row($res), a negative value (0) is returned.

    ------------------------------------------------------------------------

    [2006-09-12 16:45:59] [email]tony2001php.net[/email]

    Use odbc_errormsg() to get the reson why it fails.

    ------------------------------------------------------------------------

    [2006-09-12 14:59:34] keagle at westar dot com

    By stating that the row number is "1-based", do you mean that rows are
    indexed (1 .. last)? If so, this doesn't help answer my question. The
    call returns false(0) regardless of the parameters passed into the call
    (1 or 0). Why is it that I can't get a positive value returned out of
    this call? It doesn't make sense. odbc_fatch_row($res) always returns a
    negative value and odbc_result won't return anything I can use.

    ------------------------------------------------------------------------

    [2006-09-12 13:40:06] jkeagle at knology dot net

    Could you be more specific?

    ------------------------------------------------------------------------

    [2006-09-12 09:33:00] [email]tony2001php.net[/email]
    >odbc_fetch_row($res, 0)
    The row number is 1-based.

    ------------------------------------------------------------------------

    The remainder of the comments for this report are too long. To view
    the rest of the comments, please view the bug report online at
    [url]http://bugs.php.net/38784[/url]

    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    kalowsky@php.net Guest

  8. #8

    Default #38784 [Bgs]: odbc_fetch_row call

    ID: 38784
    User updated by: keagle at westar dot com
    -Reported By: jkeagle at knology dot net
    +Reported By: keagle at westar dot com
    Status: Bogus
    Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:

    You people are UNBELIEVABLY helpful .... NOT!!!!!


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-13 15:38:46] [email]kalowskyphp.net[/email]

    Why are you trusting odbc_num_rows?

    And fix your odbc_fetch_row call.

    ------------------------------------------------------------------------

    [2006-09-12 18:04:20] jkeagle at knology dot net

    I tried the odbc_errormsg() call and got an empty string. I also tried
    odbc_error() and got the same result.
    The problem is that a negative value is returned for each call to
    odbc_fetch_row as if there are no rows to fetch. What is misleading is
    that I can execute odbc_num_rows($res) and get 662, which is what I
    expected to get. Also, a call to odbc_num_fields($res) was called and
    returned the expected value of 2. What I don't understand is why I
    can't "fetch a row" out the same result variable ($res). Everytime I
    make a call to odbc_fetch_row($res), a negative value (0) is returned.

    ------------------------------------------------------------------------

    [2006-09-12 16:45:59] [email]tony2001php.net[/email]

    Use odbc_errormsg() to get the reson why it fails.

    ------------------------------------------------------------------------

    [2006-09-12 14:59:34] keagle at westar dot com

    By stating that the row number is "1-based", do you mean that rows are
    indexed (1 .. last)? If so, this doesn't help answer my question. The
    call returns false(0) regardless of the parameters passed into the call
    (1 or 0). Why is it that I can't get a positive value returned out of
    this call? It doesn't make sense. odbc_fatch_row($res) always returns a
    negative value and odbc_result won't return anything I can use.

    ------------------------------------------------------------------------

    [2006-09-12 13:40:06] jkeagle at knology dot net

    Could you be more specific?

    ------------------------------------------------------------------------

    The remainder of the comments for this report are too long. To view
    the rest of the comments, please view the bug report online at
    [url]http://bugs.php.net/38784[/url]

    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    keagle at westar dot com Guest

  9. #9

    Default #38784 [Bgs]: odbc_fetch_row call

    ID: 38784
    User updated by: jkeagle at knology dot net
    -Reported By: keagle at westar dot com
    +Reported By: jkeagle at knology dot net
    Status: Bogus
    Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:

    If I knew how to fix the odbc_fetch_row call I wouldn't have submitted
    the problem. Thanks for nothing.


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-13 16:54:04] keagle at westar dot com

    You people are UNBELIEVABLY helpful .... NOT!!!!!

    ------------------------------------------------------------------------

    [2006-09-13 15:38:46] [email]kalowskyphp.net[/email]

    Why are you trusting odbc_num_rows?

    And fix your odbc_fetch_row call.

    ------------------------------------------------------------------------

    [2006-09-12 18:04:20] jkeagle at knology dot net

    I tried the odbc_errormsg() call and got an empty string. I also tried
    odbc_error() and got the same result.
    The problem is that a negative value is returned for each call to
    odbc_fetch_row as if there are no rows to fetch. What is misleading is
    that I can execute odbc_num_rows($res) and get 662, which is what I
    expected to get. Also, a call to odbc_num_fields($res) was called and
    returned the expected value of 2. What I don't understand is why I
    can't "fetch a row" out the same result variable ($res). Everytime I
    make a call to odbc_fetch_row($res), a negative value (0) is returned.

    ------------------------------------------------------------------------

    [2006-09-12 16:45:59] [email]tony2001php.net[/email]

    Use odbc_errormsg() to get the reson why it fails.

    ------------------------------------------------------------------------

    [2006-09-12 14:59:34] keagle at westar dot com

    By stating that the row number is "1-based", do you mean that rows are
    indexed (1 .. last)? If so, this doesn't help answer my question. The
    call returns false(0) regardless of the parameters passed into the call
    (1 or 0). Why is it that I can't get a positive value returned out of
    this call? It doesn't make sense. odbc_fatch_row($res) always returns a
    negative value and odbc_result won't return anything I can use.

    ------------------------------------------------------------------------

    The remainder of the comments for this report are too long. To view
    the rest of the comments, please view the bug report online at
    [url]http://bugs.php.net/38784[/url]

    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    jkeagle at knology dot net Guest

  10. #10

    Default #38784 [Bgs]: odbc_fetch_row call

    ID: 38784
    Updated by: [email]kalowskyphp.net[/email]
    Reported By: jkeagle at knology dot net
    Status: Bogus
    Bug Type: ODBC related
    Operating System: Windows XP
    PHP Version: 4.4.4
    New Comment:

    While I agree the response wasn't terribly helpful, this also isn't a
    support forum. There are better avenues for that where functionality
    can be explained.

    Currently, you've written very little that has shown a bug in PHP
    itself (I'll cede a bit better doentation as a tangential to the
    original statement).


    Previous Comments:
    ------------------------------------------------------------------------

    [2006-09-13 16:59:47] jkeagle at knology dot net

    If I knew how to fix the odbc_fetch_row call I wouldn't have submitted
    the problem. Thanks for nothing.

    ------------------------------------------------------------------------

    [2006-09-13 16:54:04] keagle at westar dot com

    You people are UNBELIEVABLY helpful .... NOT!!!!!

    ------------------------------------------------------------------------

    [2006-09-13 15:38:46] [email]kalowskyphp.net[/email]

    Why are you trusting odbc_num_rows?

    And fix your odbc_fetch_row call.

    ------------------------------------------------------------------------

    [2006-09-12 18:04:20] jkeagle at knology dot net

    I tried the odbc_errormsg() call and got an empty string. I also tried
    odbc_error() and got the same result.
    The problem is that a negative value is returned for each call to
    odbc_fetch_row as if there are no rows to fetch. What is misleading is
    that I can execute odbc_num_rows($res) and get 662, which is what I
    expected to get. Also, a call to odbc_num_fields($res) was called and
    returned the expected value of 2. What I don't understand is why I
    can't "fetch a row" out the same result variable ($res). Everytime I
    make a call to odbc_fetch_row($res), a negative value (0) is returned.

    ------------------------------------------------------------------------

    [2006-09-12 16:45:59] [email]tony2001php.net[/email]

    Use odbc_errormsg() to get the reson why it fails.

    ------------------------------------------------------------------------

    The remainder of the comments for this report are too long. To view
    the rest of the comments, please view the bug report online at
    [url]http://bugs.php.net/38784[/url]

    --
    Edit this bug report at [url]http://bugs.php.net/?id=38784&edit=1[/url]
    kalowsky@php.net Guest

Similar Threads

  1. Call CSS
    By MattFlex3 in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: May 10th, 06:32 AM
  2. #38784 [Opn]: odbc_fetch_row call
    By jkeagle at knology dot net in forum PHP Bugs
    Replies: 0
    Last Post: September 11th, 09:51 PM
  3. CFC Call Hanging on Second Call
    By kg4awg in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: September 27th, 11:50 PM
  4. remote call procedure call failed
    By Dave Warwick in forum Windows Networking
    Replies: 0
    Last Post: July 5th, 03:59 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139