Trouble with concatenating some SQL

[colezpapa3]

Having a problem with this concatenation....
lID is numeric and docName is a string....

This is the original line....
str = "Select * from Issues WHERE LinkID = " & lID


I want to concatenate the following line and having some trouble....

DocumentName = '" & docName & "'


thx

 

[SkipVought]

Hi,

 str = "Select * from Issues WHERE LinkID = " & lID & " AND DocumentName = '" & docName & "'"

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[colezpapa3]

Skip,

I believe I tried it that way and received an error message "Too few parameters...expected 1

 

[SkipVought]

That is bacause one of your FIELDS is incorrectly defined in your SQL.

Is LinkID a NUMERIC field? If TEXT, then you need 'delimiters'.

Skip,

_{Just traded in my old subtlety...
for a brand NUANCE!}

 

[Golom]

Usually "Too few parameters...expected 1" means that you are specifying something as a field name that doesn't exist in the table. If the query started to fail when you added the "DocumentName = " clause then check the table to be sure that the field name really is "DocumentName".

 

[colezpapa3]

OK I got it. Thanks