View Single Post
  #1 (permalink)  
Old 06-02-2008, 10:57 AM
mozaharul mozaharul is offline
Senior Member
 
Join Date: Mar 2008
Posts: 117
Default SQL-lite select using AND operator

I am trying to select rows from a database depending on 2 conditions. Tried to use AND but this did not work (see code below). Any suggestions?

cmd.CommandText="select name,perm_id,permid_moth from motherno where hpid = "&txthhidm.Text&" & AND & motherno = "&(txthhidm.Text&*100)+&txtmemno.Text&""

Regards
Reply With Quote