× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. WEB400
  3. November 2009

Re: Why does this SQL Insert Fail

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




As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow-Ups:
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

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.