× 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.



Sorry. Should have said that I'd tried it both ways already.

It did not work.

I've not used MySQL much so it's probably something really obvious that I
just don't know about.




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

I don't know PHP and don't use it -- but looking at your SQL the variables
in your VALUES section are enclosed in quotes. Would it work if you omitted
the quotes?

Syd


-----Original Message-----
From: web400-bounces@xxxxxxxxxxxx [mailto:web400-bounces@xxxxxxxxxxxx] On
Behalf Of Shannon ODonnell
Sent: 24 November 2009 16:25
To: web400@xxxxxxxxxxxx
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.