Blog

SELECT a.account_no, (CASE WHEN e.reading_month IS NULL then “” WHEN e.reading_month IS NOT NULL then STR_TO_DATE(CONCAT(e.reading_month,” “,e.reading_year), “%m %Y”) end) as reading_date, (CASE WHEN e.reading_month IS NULL then “” else e.reading end) as reading FROM swws_users as a, water_reading as e WHERE e.account_no = a.account_no OR e.account_no is NULL AND (CASE WHEN e.reading_month IS NULLRead more

Im using Amastys Gallery plugin to implement into a tab on the product page, however the above error has come up when I pasted the code into my custom template. I have called my tab in the local.xml <block type=”catalog/product_view” name=”catalog.product.gallery” template=”catalog/product/view/gallery.phtml”> <action method=”addToParentGroup”><group>detailed_info</group></action> <action method=”setTitle” translate=”value”><value>Gallery</value></action> </block> And the below code is within myRead more

I am having a hard time figuring this out in MS SQL. Hope you can guide me with this. Let me tell you my story: I have a daily attendance report for merchandisers. Within a day, the merchandisers are moving from one store to another. So they have an application where they would time in,Read more

I am trying to write a query that displays all unique columns that are allowed to be null in Oracle. The information I need is in these 3 tables: ALL_TAB_COLUMNS ALL_IND_COLUMNS ALL_INDEXES I am having difficulty joining these tables to display the information I’m looking for. Any help would be appreciated. Looking for output suchRead more

I have installed postgresql version 9.3.14 on High Sierra via HomeBrew. Upon trying to access the server via psql, I was being prompted for a password for the user postgres. Using postgres as the password got me into the database, but I was confused, as I have never been prompted for a password for theRead more

I am new to magento.I am trying to create a view for the purchase history for users.Already there is a page to display this(As I am using a template).But as a experiment I tried to create a new page with the same content.As my first step. I created a new php block and then IRead more

I tried to create a simple Javascript method to recursively parse a JS Object and find out if any of its values or sub values is set to null or is empty string. I could’t break on when using Array.map() or Array.forEach() so I went with this : const isValidObject = (obj) => { letRead more

When I load my layout I catch exception. My layout : <?xml version=”1.0″?> <layout version=”0.1.0″> <agentdeposit_success_success> <reference name=”head”> <action method=”addItem”><type>skin_js</type><name>js/finalizeorder.js</name></action> </reference> <reference name=”root”> <action method=”setTemplate”><template>page/1column.phtml</template></action> </reference> <reference name=”content”> <block type=”agentdeposit/success” name=”agentdeposit_success” template=”agentdeposit/success_form.phtml” /> </reference> </agentdeposit_success_success> </layout> My controller: <?php class Payment_AgentDeposit_SuccessController extends Mage_Checkout_Controller_Action { public function successAction() { $ this->loadLayout(); $ this->renderLayout(); } } andRead more

I have a doubt about databases, if its better use one table with repeated values or with null values, or its better to create new tables in a 1 to 1 relationship. For example, in a conferecence management software, a user can register and can create conferences. So, in the user profile the user canRead more

I have a function: Task<Result> GetSomething(string params) { var website = getWeb(params); if (website.StatusCode != HttpStatusCode.OK) { //do something } else { return website } } I have some solutions to deal with error: return null return a tuple with the result and a bool indicates if successful or not, like return (null, false); andRead more