Post reply

SQL statement

  • March 13, 2006 at 11:40 am

    #626327

    Welcome to the forum.

    Concatenate the value behind, since the parser doesn't know the value of =aId"

    Rs2.Open "Select Filename from Filename where ArticleID=" & aId

    Even better would be using a stored procedure. (performance,security, reuse...)

     

  • March 27, 2006 at 7:09 am

    #628878

    Plus...if you'd had the SQL statement in a string variable you could've used the debugging window to print out the sql statement/variables etc.. and run it directly in QA to trace the problem...or in this case, you'd have seen immediately that the variable wasn't being passed..you can do this even when you convert to (Jo's suggestion of using) an sp..







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply