Re: Query Fails In PHP db2_exec But Is Good in System I Navigator.

So I stripped the outer select for the ID...

INSERT INTO MyLibrary.ZTEST ( METHOD, AGENT, IP ) VALUES ( 'GET', 'Mozilla/5.0 (Windows NT 10.0; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0', '76.187.52.97' );

This worked...


On 2015-12-04 12:10, Rob wrote:

Yes... added the error code... and after converting single quotes to double quotes.... I get this now...

[ 89 ] sQry: INSERT INTO MyLibrary.ZTEST ( METHOD, AGENT, IP ) VALUES ( "GET", "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:42.0) Gecko/20100101 Firefox/42.0", "76.187.52.97" );
42703 - SQLSTATE=42703 SQLCODE=-206 Column or global variable 76.187.52.97 not found.

I even went through and upper cased everything... even though it goes against my nature... I feel like a 3 year old with a big crayon that does not know any better!

On 2015-12-04 12:02, Mike Pavlak wrote:

Did you add the diagnostic functions (db2_stmt_error() db2_stmtm_errmsg())
to your code? What do they say?

Mike Pavlak
Cell: (408)679-1011 Office: (708)233-5880


-----Original Message-----
From: WEB400 [mailto:web400-bounces@xxxxxxxxxxxx] On Behalf Of Rob
Sent: Friday, December 04, 2015 12:01 PM
To: Web Enabling the IBM i (AS/400 and iSeries)
Subject: Re: [WEB400] Query Fails In PHP db2_exec But Is Good in System I
Navigator.

I did notice that when I created the tables in SiN...( Sounds funny )..
that it reported that the tables would not be journaled.

I have since gone into SiN and dropped the table.

I then created the table from the PHP script.

Mike Paviak suggested I change the credentials of the table. I do not
know how to do that at the moment... So I figured if I create the table
using PHP... it would have the same credentials as the PHP script.

No JOY!

I have changed single quotes to double quotes... Still NO JOY!

I am back... took a moment to get some more head bangs on my desk!

I was about to strip the outer select meant to retrieve the ID of the
record just inserted. and test again.

On 2015-12-04 11:54, Buck Calabro wrote:

On 12/4/2015 11:34 AM, Rob wrote:

if ( $oDB = db2_pconnect( '', '', '', array( 'i5_naming' =>
DB2_I5_NAMING_OFF ) ) )

Very often, newcomers to our platform are surprised by journaling and
commitment control. Rather, they are surprised at the lack thereof.
It is possible that iNavigator is set to COMMIT(*NONE), but I don't
see anything like that in the PHP connexion string, so the default
would be to perform table I/O under commitment control. If
MyLibrary.zTest is not journaled, then it is impossible to perform I/O
to it under commitment control.

The typical choices are:
1) Journal the table so COMMIT and ROLLBACK work as expected.
2) Tell PHP that you want to operate with no commitment control, so
INSERT ... WITH NC

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list To post a message email: WEB400@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at
http://archive.midrange.com/web400.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus