RSS

Monthly Archives: December 2012

search comma separated values in mysql


if you use  MySQL Database Table Column that keep data comma separated  and you want to search specific Data Value Then you search like that……

SELECT * from voucherformredeam WHERE FIND_IN_SET(‘4364363’, RedeamVouchercode)

Default Function of MySQL: which is case sensitive

FIND_IN_SET 

Parameter Value:

4364363

Column Field:

RedeamVouchercode

 

 

Comma Search

Advertisements
 
Leave a comment

Posted by on December 24, 2012 in My SQL

 

Tags: , , ,

there is no row at position 0


it is always good to validate wether the dataset has data or is empty you can use something like this to cover all validations

if(ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//process data
}
else
{
// it is empty
}

 
1 Comment

Posted by on December 7, 2012 in ASP Dot Net C#

 

Tags: , ,

Directory – List All Industry Types


 

 

Business Type
Accounting, Auditors, Tax & Bookkeepers  
Advertising & Public Relations  
Agriculture Products & Services  
Airlines, Aviation Services / Supplies  
Animal Products  
Apparel / Accessories / Textiles  
Architectural, Engineering & Technical  
Associations and Non-Profit Organizations  
Banking & Financial Services  
Beverages, Alcoholic & Non-alcoholic  
Building Systems / Materials / Fixtures  
Business Consultancy & Advisory  
Computer & IT Products & Services  
Construction General  
Education & Training  
Entertainment & Recreation
Environmental Products & Services  
Executive Search & Personnel Recruitment  
Farm Equipment  
Food Manufacturing / Distribution / Services  
Freight Forwarders / Couriers  
Gases, Natural & Processed  
Government  
Greater Phuket Member  
Health / Hygiene Products & Services  
Hospitals  
Hotels / Restaurants / Caterers  
Industrial Equipment  
Information & Communications Technology  
Inspection, Safety & Security  
Insurance  
Laos Business Chapter  
Legal Practice  
Manufacturing – Automotive  
Manufacturing – Consumer  
Manufacturing – Electronics  
Manufacturing – Industrial  
Manufacturing – Other  
Manufacturing -Chemical Elements & Allied Products  
Marketing & Communications  
Outplacement Services  
Petroleum & Petroleum Products  
Pharmaceutical & Medicinal Products  
Power & Electrical  
Printing & Publishing  
Property & Real Estate Services  
Retail Consumer Products  
Schools  
Scientific & Medical Instruments  
Security, Investigative Services & Products  
Sourcing, Trading & Buying  
Transport Vehicles & Parts  
Transportation & Logistics  
Travel & Tourism  
Valuation & Disposal  

55 of 55 Records

 
Leave a comment

Posted by on December 4, 2012 in Others

 

Tags: , ,