[RESOLVED] whats the error in the sql statment code?

**iyadd** · May 9th, 2009, 02:19 PM

Hi
whats the error in the sql statment code?

Code:

Adodc1.RecordSource = "select * from recept_Query where cheq_num like'" & Text8.Text & "' and where rec_type like'" & Text7.Text & "'"

ineed to make to condition in one selec statment like tha code?
thank yo

**brucevde** · May 9th, 2009, 02:27 PM

The keyword Where appears twice, once is enough.

**RobDog888** · May 9th, 2009, 02:31 PM

You also dont have the LIKE wildcard character ("%") in your sql string unless you plan on adding it to the textbox input manually.

**iyadd** · May 9th, 2009, 02:31 PM

no ineed to check too fields in one time

**RobDog888** · May 9th, 2009, 02:32 PM

Originally Posted by iyadd

no ineed to check too fields in one time

You can have multiple fields in your where clause

**iyadd** · May 9th, 2009, 02:33 PM

how?

**RobDog888** · May 9th, 2009, 02:42 PM

Code:

SELECT * FROM Table1 WHERE Field1 LIKE '&#37;blah%' AND Field2 LIKE '%stuff%'

The corrected code for the posted question is ...

Code:

Adodc1.RecordSource = "select * from recept_Query where cheq_num like '%" & Text8.Text & "%' and rec_type like '%" & Text7.Text & "%'"

**iyadd** · May 9th, 2009, 10:38 PM

RobDog888 THanks you very much......its correct and run succefully.....
thank you too
iyadd

**RobDog888** · May 10th, 2009, 01:05 PM

No prob. Glad to help

Ps, dont forget to Resolve your thread fromt he Thread Tools menu and choose "Mark Thread as Resolved"

**iyadd** · May 10th, 2009, 02:11 PM

Ok tahnk you too

Thread: [RESOLVED] whats the error in the sql statment code?