Visual Basic, SQL Query using WHERE and AND

SQL Query using WHERE and AND

Author	Message
Scott Stewa #1 / 3	SQL Query using WHERE and AND Sorry if this appears twice. I got a page fault when I posted the first time and don't know if it went through. I am trying to use an SQL query to create a recordset using parameters from two drop down boxes. DIM strSQL as string strSQL="Select * FROM MyFile WHERE IDCategory=" & _ cboIndex.ItemData (cboIndex.ListIndex) & _ "AND LanguageID=" & cboLanguage.ItemData(cboLanguage.ListIndex) datMain.Recordsource=strSQL datMain.Refresh I get an error "Too few parameters. Expected 1" Without the AND and the second condition it works fine. How can I use more than one condition to get the recordset I want? Thanks, Scott
Fri, 10 Sep 2004 20:46:46 GMT

wuxapia #2 / 3	SQL Query using WHERE and AND It may be because you have no space before the AND. Just a thought. Wuxapian. Quote: > Sorry if this appears twice. I got a page fault when I posted the > first time and don't know if it went through. > I am trying to use an SQL query to create a recordset using parameters > from two drop down boxes. > DIM strSQL as string > strSQL="Select * FROM MyFile WHERE IDCategory=" & _ > cboIndex.ItemData (cboIndex.ListIndex) & _ > "AND LanguageID=" & > cboLanguage.ItemData(cboLanguage.ListIndex) > datMain.Recordsource=strSQL > datMain.Refresh > I get an error "Too few parameters. Expected 1" > Without the AND and the second condition it works fine. How can I use > more than one condition to get the recordset I want? > Thanks, > Scott
Fri, 10 Sep 2004 21:11:08 GMT

Frank Ad #3 / 3	SQL Query using WHERE and AND See inline.. Quote: >I am trying to use an SQL query to create a recordset using parameters >from two drop down boxes. >DIM strSQL as string >strSQL="Select * FROM MyFile WHERE IDCategory=" & _ > cboIndex.ItemData (cboIndex.ListIndex) & _ > "AND LanguageID=" & >cboLanguage.ItemData(cboLanguage.ListIndex) if MsgBox ("Are you sure you want to execute" & vbcrlf & strSQL & _ " ?", vbYesno, "Take a good look at the spaces !!!") = vbYes Then Quote: >datMain.Recordsource=strSQL >datMain.Refresh End If Quote: >I get an error "Too few parameters. Expected 1" Basicly if your combo1 is "Hello" and your combo2 is "world" then your strSQL would look like this.. : Select * FROM MyFile WHERE IDCategory=HelloAND LanguageID=world HTH Regards, Frank
Sat, 11 Sep 2004 00:06:29 GMT

Page 1 of 1

[ 3 post ]