Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

Search In

Update query with inner join

Hello readers, today we will discuss about the "SQL query with INNER JOIN". UPDATE (SELECT table1.value as OLD, table2.CODE as NEW FROM table1 INNER JOIN table2 ON table1.value = table2.DESC WHERE table1.UPDATETYPE='blah' ) t SET t.OLD = t.NEW

How to use search_read in OpenERP(Odoo)?

A search_read function is now available. It will do a search and return a list of dict. In below code i have explain search_read self.search_read([], ['name']) [{'id': 3, 'name': u'Administrator'}, {'id': 7, 'name': u'Agrolait'}, {'id': 43, 'name':

How to use selection method in OpenERP(Odoo)?

Its indicate no selection constraint in database. Selection must be set as a list of tuples or a callable that returns a list of tuples In below code i have explain search_read aselection = fields.Selection([('a', 'A')]) aselection = fields.Selectio

How to use api returns in OpenERP(Odoo)?

Api unity of returned value will return a RecordSet of specified model based on original returned value: In below code i have explain api_returns @api.returns('res.partner') def afun(self): ... return x # a RecordSet Note- And if an old API functi

How to create a UIAlertView in swift

Hello friends , To create UIAlertView in swift -> UIAleartView is deprecated in iOS 9, so you need to use UIAlertController instead . let alertController = UIAlertController(title: “test alert”, message: “this is a test alert”, preferredStyle:

HUD (Head Up Display) in Unity

HUD (Head Up Display) A head-up display or heads-up display—also known as a HUD—is any transparent display that presents data without requiring users to look away from their usual viewpoints. The origin of the name stems from a pilot being able to v

low sound when recorded audio is played

Sometimes we record audio from AudioRecorder and when we play the same audio, it runs with a quite low volume even if volume is set to 1.0 i.e maximum. Use below lines of code to avoid such issues: AVAudioSession* audioSession = [AVAudioSession shar

How to create a transparent image with CSS?

<!DOCTYPE html> <html> <head><title>css3</title> <style> div.bg { width:500px; background:#000; border:2px solid #00ff00; } div.transparent-box { width:400px; margin:40px; background-color:#fffff

Date/Time Operations in php

Sometime there is a need to perform different operation on dates for ex: You may need to : 1) Add two dates/time 2) Subtract two dates/times for ex- to calculate your age by deducting your date of birth from current date. And many more. Yo

Can you catch the Hummingbird- Google's latest search algorithm

The hummingbird, outsmarting the panda, the penguin and you The new google algorithm does justice to its nomenclature, its fast in its processing and furious with its accuracy. Humminbird is the freshest Google algorithm, which assimilates the bes

1 200 720
Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: