CaptainChainsaw

That makes sense, thank you

Hi, Just a quick question. Would I have to quote "False" when testing for the response condition here? if($SOAP_RESPONSE->DataName == False){ // do something } if($SOAP_RESPONSE->DataName == "False"){ // do something else } In the XML response: <DataName>False<DataName> I thought it should work without quotes. Cheers

Fair enough, is there a way around this? I've tried creating another certificate using the common name "www.myserver.dev.com" and got this: [error] Init: Multiple RSA server certificates not allowed

Hi all, I've been trying to figure out a problem I've got with SSL. I have installed a certificate with the common name "*.dev.com" and it works for https://www.myserver.dev.com and https://myserver.dev.com. Common Name (e.g. server FQDN or YOUR name) []:*.dev.com The problem is when I try to post to https://www.myserver...dir/script.php. If a point the browser to this URL I get served the page but if I post within an iframe I get this: SSL certificate problem, verify that the CA cert is OK. Details: error:14090086:SSL routines:SSL3_GET_SERVER_CERTIFICATE:certificate verify failed I've tried posting to: https://www.myserver.../dir/script.php and script.php Each time I get this error message. I can't see why, as far as I can tell this should work. Anyone got any ideas? Cheers, CaptainChainsaw

Problem solved, this fixed it: $r=$SOAP_RESPONSE->ProcessApplicationDataResult; $data = simplexml_load_string($r); echo "app date: ".$data->ApplicationDate; Cheers

Hi all, I've got this SOAP response: [ProcessApplicationDataResult] => <Response> <ApplicationDate>2/7/2013 10:16:36 AM</ApplicationDate> <IsApproved>False</IsApproved> <RedirectURL></RedirectURL> <Offer> <Amount></Amount> </Offer> </Response> How do I access the values? I've tried: $SOAP_RESPONSE->ProcessApplicationDataResult->ApplicationDate; $SOAP_RESPONSE->ApplicationDate; $SOAP_RESPONSE['ProcessApplicationDataResult']->ApplicationDate; This should be extremely easy to do. Thanks in advance, CaptainChainsaw

That might be an option but performance is high priority and another db hit might have an effect on that. These card types and other details currently aren't stored on the DB they're simply values on a form, adding the details to a DB and not updating the form dynamically using db values would mean changes in two places.

Hi all, I'm looking to design a OO system that interacts with 3rd parties who use SOAP, GET AND POST. These 3rd parties each have their own way of more or less doing the same thing. For example. Say I want to pass them a credit card name, one 3rd party may expect "Mastercard" and another might expect "MSC" to be passed. At the moment I'm thinking I could, for example have a set method like so: $card->setMastercard("MASTERCARD"); Another method to find the correct mapping for it: $card->findMapped(); This may mean a scaleabilty problem if a new card is added in the future. I could create a method is some subclass that takes these details as params, perhaps something like: $thirdParty->('$URL_TO_POST_TO', 'SOAP' ,array(' "MSC" => "MASTERCARD, "VIS" => "VISA" '), // etc ); This would make it potentially a nightmare if a lot of params need passed in but would mean if another card was added, the code wouldn't need changed and it would just mean adding another element in the array. Anyone got any tips or suggestions on how best to tackle this? I'm thinking GET/POST/SOAP parent classes and a "3rd party" subclass. These are just rough ideas. Thanks in advance, CaptainChainsaw

Those results seem to be correct - thanks for your help Barand - all sorted

Thank you Barand, adding the brackets is now producing results. I'll need to check it further to see that the results are correct - looking good though! Cheers, CaptainChainsaw

Hi, Unfortunately backticks isn't the issue, works fine with either. Think the problem is deeper. Cheers, CaptainChainsaw

Hi all, The SQL I'm looking at calculates the the average age within the select and this works fine: (AVG((TO_DAYS(NOW())-TO_DAYS(pl.dob)))/365.242199) AS averageage The problem is when I want to count the ages that are within age groups. The example below should give the total number of ages within the 18-24 group. I can't get this to work, it displays zeros when the select statement is executed, there aren't any sql errors. SUM((case when (TO_DAYS(NOW())-TO_DAYS(pl.dob)/365.242199) BETWEEN 18 AND 24 then 1 else 0 end)) AS '18-24', Can anyone suggest a solution to this? CaptainChainsaw

Got it sorted, I had to make some other elements absolute.

Hi all, I'm trying to get the text "Borrow:", "+ Interest:" and "= You repay*:" to stay fixed while the values that displayed via javascript in the span tags change. The values in the span tags can have different lengths which means at the moment the text doesn't stay fixed. Anyone know how I can get the text to stay fixed while the values change? I've tried setting it to "absolute" but when the page is zoomed in on the text doesn't stay inline with the rest of the page. HTML: <div id="sliderToolResults_Borrow">Borrow: <span id="resultRequested" class="sliderResultBorrow"></span> </div> <div id="sliderToolResults_Interest"> + Interest: <span id="resultInterest" class="sliderResultInterest"></span> </div> <div id="sliderToolResults_Repay"> = You repay*: <span id="resultTotal" class="sliderResult"></span> </div> CSS: #sliderToolResults_Borrow { position:relative; left: 50px; top: -30px; font-style:italic; float: left; } #sliderToolResults_Interest { position:relative; left: 70px; top: -30px; font-weight: 100; float: left; } #sliderToolResults_Repay { position:relative; left: 140px; top: -30px; font-weight: 100; float: left; } #sliderrepay { position: absolute; } #sliderBorrowResult { color: #ff9900; position:relative; left: 45px; bottom: -5px; } #sliderInterestResult { color: #ff9900; position:relative; left: 45px; bottom: -5px; } #sliderRepayResult { color: #ff9900; position:relative; left: 450px; bottom: -5px; } Any ideas? Any help would as always be appreciated. Cheers, CaptainChainsaw

Got this fixed. Adding in this code got it working: else if(is_safari) { return 'Leave page?'; }