SQL queries

01) join query:
select     products.productId, products.ProductName, products.IsApproved, products.ProductCode, products.ProductImage, products.ProductDescription, products.ProductCost,
        categorymaster.CategoryId, categorymaster.CategoryName
       
      FROM     products  INNER JOIN categorymaster  ON products.productId = categorymaster.CategoryId  where CategoryId='$id' and products.IsApproved='1' order by ProductId LIMIT $offset, $rowsPerPage";


02) count no of days in a month:
SELECT day(last_day('2011-02-1'));

today date:
SELECT DAY(CURRENT_DATE);

days between two date:
SELECT DATEDIFF('2006-07-10','2006-06-01');

.net project depolyment steps

  1. VS2005
  2. open your project in solution explorer
  3. go to menu click rebuild solution
  4. create datewise named folder
  5. publish website in that folder
  6. install IIS
  7. copy and paste that folder in wwwroot and explore default.aspx file

different websites

http://www.ownacolour.com
http://www.kingscooty.com/

themes module positions




localhost working on android emulator

Control Panel -> Programs and Features -> Turn Windows features on or off -> scroll down to Telnet Client.

command promot
telnet localhost "5554" = (EmulatorPortNumber)

telnet -> help-> redir add udp:1337:12345


202.88.237.157/xampp
http://10.0.2.2:8888/
127.0.0.1
198.168.0.99:8080

girls in my life

yes

Tips for HR



  • Conducting surveys through a structured form of Questionnaire related to job satisfaction & Work Conditions.
  • sending weekly inspirational quotes
  • organizing some workshops like team building games, corporate games etc, initiate some reward & recognition plans
  • start a monthly or quarterly newsletter
  • A host of other behavioral and functional training



New Web Application Concepts




I.            Community Concept for palmtec: (indirect product promotion)

No
Website
Related Concept
Company
1
Pure air lovers society by wind energy company
Suzlon
2
Childrens art contest by using jam
Kissan
3
Golu contest
Parle
4
www.sunsilkgangofgirls.com
Hair advices
Sunsilk
5
Driving & vehicle maintenance tips
TVS
6
http://yourhealthfirst.in/

Max insurance
7




Related Concepts website ideas:
  • Best POS Award website
  • Embedded Community
  • Business Ideas.com
  • 7 Wonders of India Voting website as like as http://www.new7wonders.com/ (sponsored/promoted by softland)


Facebook product /brands promotion peoples like:

International brands

Indian brands
http://www.facebook.com/pages/Palmtec/282175891811464  11


II.          Online Background verification

  1. Online fake profiles verification
  2. Incumbent Verification
  3. Employee Verification
  4. Matrimony Verification
  5. bidder Verification
  6. Portfolio verification
  7. Visa agent Verification
  8. Technical verification
  9. e-friend Verification
  10. Asset Verification
  11. Client Verification
  12. Tenant Verification
  13. Political candidate Verification
  14. website Verification
  15. quality certification, license & brand Misuse Verification
  16. general & criminal verification
  17. Cyber crime verification
III.          Mob2pc.com (reverse way2sms.com site)
                       
                        This project is used to save our SMS, mobile photos and videos directly send to a website and stored in that user accounts which can be set as public and private. So that anybody can save a important SMS and videos in some safety purposes and very useful in crime cases even though they broke or missed mobile.

IV.          2nd handsales.com
Same as eCommerce but only sales used things so that site is for specialized in second hand sales

V.           Online Lorry booking Website

In transport/Logistics domain regularly if a transport company can get a order for send good from Trivandrum to Delhi they search a contract for return transport because they not like their lorry is empty when return. Due to this they will stay after some days to get a transport booking from Delhi to Trivandrum, In this case if we have a site for booking a lorry it Is very useful to transport companies as well as public. So we can create this site in SaaS model by annual/monthly membership or PPP(pay per post) model to post or search for a transport order.

Industry statistics:
National Highways - 66,590 km
All roads - 3,300,000 km
Registered Lorries in Tamilnadu – 2,64,377

VI.         FindStolen.com
                  
Any user can post his stolen things/vehicle details and any user can post related details to that stolen things.


VII.       Tvstars.com (thunderchoices.com)
                       
Now a days tv serials and live programs are becoming very popular and more advertisers concentrating area.
[Ex: galatta.com & indiaglitz.com]

CSS limitations

  1. no option for zigzag borders
  2. no option for border opacity, border image, text border, opacity for background, radius for outline, text break
  3. no option for double height text and double width text in font style
  4. first letter capital and underline in a word as like as in VB application softwares 
  5. Selectors are unable to ascend
  6. One block declaration cannot explicitly inherit from another
  7. Vertical control limitations 
  8. Inconsistent browser support
  9. Lack of column declaration and variables
  10. Absence of expressions
  11. Lack of orthogonality
  12. Unexpected margin collapsing
  13. Float containment
  14. Lack of multiple backgrounds per element
  15. Inability of children to override some properties set on a parent

:: Useful web links List

Site Keyword tags

Abbreviations (1) Acting choices (1) actress-actors (2) addons (1) ads (33) adsense drawbacks (1) advantages (6) advantages of chennai (1) Advantages of Links directory (1) advantages of plastic cheppal stand (1) advices (2) affiliates (1) all ads (1) amazon (1) android (2) articles (34) asp (6) ASP dot Net design issues (1) astrolgy (2) autobiography (2) automobile (1) avoid hacking (1) avoid snake bite (1) backgrounds (1) banners (2) BCS (2) Best category for best collections (1) best PPT Presentations (1) best things (1) biodata (1) blog (1) Blog Advertising (1) blog stats (1) blogger (1) blogger drawbacks (1) blogs (3) Browser errors (2) Browser Issues (5) bus ticketing machines (2) business (2) business loss (11) Business Plan (1) Business rental (1) business wise drawbacks (1) Buying Expired Domains (1) capgemini (1) Car buying tips (1) certified professional (1) cheat frauds (7) Cinema industry (1) cities (15) clients (2) Closed IT/Software companies (1) closed websites (1) codings (21) Commented topics of my blog (1) comments (6) companies (11) Construction (1) contacts (1) Copyright (1) creativity (1) Credit Card Prefix Numbers (1) css (7) CSS drawbacks (1) CSS elements combination (1) CSS errors (2) css ID rules (1) css limitations (1) css links (1) css selectors (1) Cute babies (1) cv (1) demonetization (1) design category (2) disclaim (1) DNS error (1) Documentation (3) domain (2) drawbacks (9) Drawbacks in Madurai bus stand (1) drawbacks of legins (1) drawbacks of strike (2) drawbacks_others (3) duty (1) education (2) electronics (2) emails (1) embedded (2) empty post (1) emptyland (1) Error Code and Message (1) eshop (13) Extra expenses (1) Face detection apps use (1) family (1) FAQ (2) FENG OFFICE (1) finance loans (2) firecrackers (1) firewall nonblockable sites (1) food (3) For sales (1) Free (1) fresh content (6) friends (2) fun (1) general - new - temp (5) GHS (3) girls (8) google (5) google Ads (1) Google Adsense Revenue Sharing Sites (1) government (1) GPS merits (1) graphicsbg (1) Green earth (1) Hacking Methods (1) hand held machines (1) handicapped reservation (1) header wordings (1) health (2) Helpful Slogams (1) HM (1) home shifting (1) how to avoid social media spam (1) HTML (5) html encoder (1) HTML5 website layout (2) IBM (1) IDEA (1) IE (1) IE problems (1) india (1) infosys (1) internet (1) Internet/Social Media Marketing (1) interview questions (4) ISBN (1) IT hardware products for rental (2) IT Hardware-software (2) ja (1) jallikattu (1) javascripts (2) job (7) job analysis (1) joomla (2) KSRTC (1) kvic (1) links (33) links_background verification websites (1) links_blogs (8) Links_certifications (1) links_different websites (1) links_letterwise (1) Links_mobile websites (2) Links_My Designs (3) links_my SMM (2) links_other states (1) Links_Product_brand websites (1) links_Reciprocal Links (1) links_SEO/SEM (1) links_Tamilnadu (1) links_tenders (2) links_tools (2) links_UI design (1) links_use for all* (2) list (1) list of industrial estate (1) list of IT parks (1) list of toll free numbers (1) M2M (1) Madurai (1) Madurai 2020 (1) Mail box folder maintenance (1) Malayalam (1) Malayalam movie my reviews (1) manjula miss (1) Manufacturing Industries (1) marketing (3) marketing ideas (1) me at divisional sports (1) MNC site bugs (1) mobile (4) monthly extra (1) Multiple options in codings (1) my (2) my achievements (1) my achivements (1) My advt - ads (10) My all ads (1) My best collections (1) my best ideas (1) my comments (2) My cousin's post in FB (1) My donations (1) my friends with actor actress (1) My Google dashboard (1) My horoscope (2) my linkedin profile (1) My online interview (1) My Portfolio (2) my posts links (1) My questions (2) my SEO experience (1) my social media profiles (2) my stack overflow profiles (1) My Stackoverflow site answers (2) My works (1) Names (1) nested html (1) Netscape Navigator (1) new blogs (1) New build house for sale (1) New Concepts (1) news (4) online earnings (3) online generators (1) online scams (2) open office drawbacks (1) Open source (2) Opera (1) orkut drawbacks (1) Others view (21) our grandparents (1) Our ID and Numbers (1) outsource statistics (1) own ideas (15) own ideas_aboutme (13) own views (51) page pixel collapse when scrolling in firefox (1) Page Speed Performance (1) parallax scrolling websites (1) Partners (2) Personals (1) photos (23) Photos - art (3) Photos_actress (7) photos_screenshots (1) PHP (3) plans (1) Plots for sale (2) poems (3) policy (1) Pollution Facts (1) powercut (1) Powerpoint (1) press release (1) Problems and solutions - ATM (1) Problems and solutions - Education (2) Problems and solutions - Hardware (4) Problems and solutions - Mobilephones (4) Problems and solutions - NGO (7) Problems and solutions - Software (6) Problems and solutions - Website (7) problems in browsing center/internet cafe (1) Products (16) programmers problems (1) programs (7) proxy software (1) Quality guidelines (2) Rajamani (1) realesate (2) reasons for power shortage (1) Recent comments (1) relatives (2) relatives business (1) resume (1) RS 232 dotmatrix printers (1) rti (1) sales (6) SBI (1) search engine (2) search type websites (1) security (2) Security Alert regarding Serious CMS Attack (1) SEM portfolio (2) SEO Difficulty (1) SEO for blogs (1) SEO portfolio (1) SEO tools (2) SEO-SMM-ORM Plan (1) SEO/SEM (29) sil ads (1) Site Tags (4) siteworth (1) slogans (1) SMS benefits (1) Social Interest - public use (33) social media marketing (13) Social Media Optimization (1) social media widgets (1) softland-palmtec (2) software errors (1) Software Testing (6) Softwares (8) solairaja (1) sports (1) SQL (1) SQL queries (3) stars (1) statistics (10) stop software patents (1) tablet Grip and interaction (1) Tamil - Tamilar - Tamilnadu (22) TATA (1) TCS (1) technicals (11) Technology (5) tenders (4) Testing Tips (1) text magics (1) Thanks (1) Things to do before you die in India (1) Things to Watch in 2014 (1) thirumalai (1) Tips (5) Tips - Buseness tips (23) Tips - Health tips (8) Tips - life tips (18) tips for demo video preparation (1) Tips for doing SEO/SMM (3) Tips for Good-Employee (1) Tips for HR (2) Tips for old money (1) tours (1) Travels (1) TV (1) UI Certifications Q & A (1) UI design (4) useful best software latest versions (1) Useful websites for HTML Developer (1) videos (1) visa (1) vista icons (1) w3c standards (1) wallpapers (2) ways to find a job (1) Web design (9) Web design and developments (34) Web developments (6) Web Services (1) web UI design shapes (1) webhosting (10) Website Features (1) website templates (1) Widgets collections (4) Yahoo (1) சுயசரிதம் (1)