At 03:24 PM 4/4/2001 -0700, Julio Cuz, Jr. wrote:
>Every time I run the following code, I get this error if I use a NUMBER
>for the 'Email' case:
>"Warning: Unable to jump to row 0 on PostgreSQL result index 2 in
>/html/rccd/remodel/display2.php on line 35"
The problem is that your query is equivalent to going:
SELECT * FROM "Remodel" WHERE "WO" LIKE 1; // or some other numerical value
The "WO" is a string because it is in quotes so you are saying:
WHERE string = integer
Ain't gonna happen so the result is always empty. What you want probably
is (assuming WO is a column name):
$sql = "SELECT * FROM \"Remodel\" WHERE WO=\"".$find."\"";
It is equals since you are using an integer instead of a string (like is
for strings).
>or, if I use a string (i.e. [EMAIL PROTECTED]), I get this error message:
>"Warning: PostgreSQL query failed: ERROR: Attribute 'jcuz' not found in
>/html/rccd/remodel/display2.php on line 33"
Same problem. "EMAIL" means the string "EMAIL" not the column called "EMAIL".
Cheers,
Ron
-----------------------------------------------------------------------------
Island Net AMT Solutions Group Inc. Telephone: 250 383-0096
1412 Quadra Toll Free: 1 800 331-3055
Victoria, B.C. Fax: 250 383-6698
V8W 2L1 E-Mail: [EMAIL PROTECTED]
Canada WWW: http://www.islandnet.com/
-----------------------------------------------------------------------------
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]