SQL search with integer variable

[jrgmrz]

I´m using this statement using an integer variable (fol ) to do the search, but I get this error :

Run-Time error '3061'
too few parameters expected 1.

Set RS = DB.OpenRecordset("SELECT * FROM Detfact WHERE Folio = fol", dbOpenDynaset)


Thanks...

[chrisjk]

If it's a string value it must have quotes around it...

Set RS = DB.OpenRecordset("SELECT * FROM Detfact WHERE Folio = 'fol';", dbOpenDynaset)

[chrisjk]

Sorry, I misread!!...
try this

Set RS = DB.OpenRecordset("SELECT * FROM Detfact WHERE Folio = " & fol & ";", dbOpenDynaset)

[TimJ]

String values don't require ' ' around them
do this

dim strSQL as string

strSQL = "SELECT * FROM Detfact WHERE Folio =" & " " & fol

Set RS = DB.OpenRecordset( strSQL , dbOpenDynaset)

[TimJ]

The prior is for integer values only. If it is a string variable then


strSQL = "SELECT * FROM Detfact WHERE Folio =" & " " & "'" fol & "'"


Set RS = DB.OpenRecordset( strSQL, dbOpenDynaset)

[TimJ]

Correction, I missed an &

The prior is for integer values only. If it is a string variable then


strSQL = "SELECT * FROM Detfact WHERE Folio =" & " " & "'" & fol & "'"


Set RS = DB.OpenRecordset( strSQL, dbOpenDynaset)

[chrisjk]

Originally posted by TimJ
String values don't require ' ' around them

Don't know where you learned that mate but you do need quotes around string values in SQL, otherwise you get the error he described. Not only that but you contradicted yourself by including quotes anyway. I'd also like to point out you can edit posts, rather than making 2 correction posts.

Folio =" & " " & "'" & fol & "'"

What the hell is that?!? It should be Folio = '" & fol & "';". I suggest you learn how to code before slagging me off.

Ignore all the bollocks he just gave you..if you want to get an integer value from a variable into an SQL statement, do this.

Set RS = DB.OpenRecordset("SELECT * FROM Detfact WHERE Folio = " & fol & ";", dbOpenDynaset)

If that variable contains a string, do this...

Set RS = DB.OpenRecordset("SELECT * FROM Detfact WHERE Folio = '" & fol & "';", dbOpenDynaset)

If you just want a straight SQL statement with no variable interpolation to include a number do this...

Set RS = DB.OpenRecordset("SELECT * FROM Detfact WHERE Folio = 8;", dbOpenDynaset)

To do the same but with strings, do this...

Set RS = DB.OpenRecordset("SELECT * FROM Detfact WHERE Folio = 'fol';", dbOpenDynaset)

And lastly, if you want to use Dates, put # instead of ' in all above examples and make sure it is in mm/dd/yy format.

[Ianpbaker]

ROFLMFAO

[parksie]

Easy now, Chris

[chrisjk]

Hey, he said I was wrong. If i were, then fine, but I ain't so