Saturday, December 31, 2011

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:

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

Sunday, December 11, 2011

.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

Sunday, December 04, 2011

Saturday, December 03, 2011

girls in my life


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)

Related Concept
Pure air lovers society by wind energy company
Childrens art contest by using jam
Golu contest
Hair advices
Driving & vehicle maintenance tips

Max insurance

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

Facebook product /brands promotion peoples like:

International brands

Indian brands  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. (reverse 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
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

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

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

Thursday, December 01, 2011

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

top 10 adsense earners in tamilnadu

Name: Srinivas Tamada Location: Chennai, India but now is in USA Blog: Blog Niche: Ajax, PHP, Web Design. ...


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

:: Useful web links List