SQL-lite select using AND operator

[mozaharul]

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

[giannimaione]

Hi Mozaharul,

try it:

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

or
YourQuery="select name,perm_id,permid_moth from motherno where hpid = " & txthhidm.Text & " AND motherno = " & ((txthhidm.Text*100) + txtmemno.Text)
msgbox(YourQuery):' only for testing
cmd.CommandText=YourQuery

are you sure that txthhidm and txtmemno are ONLY numeric value???

[mozaharul]

Hi giannimaione,

Thanks for the help.

txthhidm and txtmemno are both numeric value.

I'm not clear about the last two quotes have been dropped from my code. Off course, the syntax generated error. Could you please explain ?


Best regards,

Mozaharul

[giannimaione]

Hi mozaharul

Originally Posted by mozaharul

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

in your code there are two errors syntax
1) & AND &
2) &txtmemno.Text&""

Sorry, but i am not more explain , and i am sorry for my bad english

[mozaharul]

Hi giannimaione,

Its OK, thanks for the explanation.


regards,

[giannimaione]

Hi mozaharul
i have missing quotes

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

here i have correct code:
cmd.CommandText="select name,perm_id,permid_moth from motherno where hpid = '" & txthhidm.Text & "' AND motherno = " & ((txthhidm.Text*100) + txtmemno.Text)