Re: Why does this SQL Insert Fail -- WEB400

It's on a Windows PC using a MySQL DB there.

-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Peter_Vidal@xxxxxxxx
Sent: Tuesday, November 24, 2009 10:30 AM
To: Web Enabling the AS400 / iSeries
Subject: Re: [WEB400] Why does this SQL Insert Fail

I used to have something like that (and this might be a super-silly
question) but: is the file being journaled?
PETER VIDAL
PALL CORPORATION | SR SYSTEM ANALYST @ WH APPLICATION DEVELOPMENT GROUP
10540 RIDGE RD., SUITE 203, NEW PORT RICHEY, FL 34654-5111
727-815-3104 ||| FAX: 727-815-3120 ||| WWW.PALL.COM

"SCIENCE IS ORGANIZED KNOWLEDGE. WISDOM IS ORGANIZED LIFE."
IMMANUEL KANT(1724 - 1804)

"Shannon ODonnell" <sodonnell@xxxxxxxxxxxxxxxxxxxxxxxxx>
Sent by: web400-bounces@xxxxxxxxxxxx
11/24/2009 11:28 AM
Please respond to
Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>

To
<web400@xxxxxxxxxxxx>
cc

Subject
[WEB400] Why does this SQL Insert Fail

Hi,

Trying to do a simple PHP SQL to insert a row into a MySQL database and it
keeps failing.

I've tried it with hard coded values and also with variables.

The DB was created fine, and I was able to connect to it fine.

Also, the user profile has all rights to the DB.

But it keep failing.

Is there a way to get more diagnostic info maybe so that I can see WHY it
fails or barring that, can someone see any reason why this would fail
(coded
incorrectly maybe?)

Thanks!

$XmittalBatchNum = $sta->transmittal->aheader->XmittalBatchNum;

$TransmittalDate = $sta->transmittal->aheader->TransmittalDate;

$Agency = $sta->transmittal->aheader->Agency;

$RB_UserID = $sta->transmittal->aheader->RB_UserID;

$CashAmountTotal = $sta->transmittal->aheader->CashAmountTotal;

$CheckAmountTotal = $sta->transmittal->aheader->CheckAmountTotal;

$CreditAmountTotal = $sta->transmittal->aheader->CreditAmountTotal;

$CitationCount = $sta->transmittal->aheader->aCount;

$cxn=mysqli_connect("localhost", "shannon" , "mypass", "sta")

or die("Error Connecting to database");

$query = "INSERT INTO TBH-Table (

XmittalBatchNum,

TransmittalDate,

Agency,

RB_UserID,

CashAmountTotal,

CheckAmountTotal,

CreditAmountTotal,

aCount

)

VALUES('$XmittalBatchNum',

'$TransmittalDate',

'$Agency',

'$RB_UserID',

'$CashAmountTotal',

'$CheckAmountTotal',

'$CreditAmountTotal',

'$aCount')";

echo "<htmL><body><center>".$query."</center></body></html>";

$result = mysqli_query($cxn, $query)

or die("Unable to insert record: \n"."Transmittal Batch Num:
".$XmittalBatchNum);

echo "<h4>Record Added to Database</h4>";

?>

Shannon O'Donnell

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.