SQL Syntax

Results 1 to 2 of 2

Thread: SQL Syntax

  1. #1
    Kelsi Guest

    Default SQL Syntax

    &nbsp;<BR>What is the syntax for an sql select statement that uses a table that has been passed in by the ASP function? <BR>Ex. aspfunction (tablename)<BR>Select * from tablename<BR><BR>What is the syntax to let the select statement know that tablename is a variable?

  2. #2
    Dave Eisenberg Guest

    Default RE: SQL Syntax

    You must concatinate it as one string, then use it:<BR>mySQL = "SELECT * FROM " & PassedParameter<BR>myRecordset.Open mySQL . . . etc...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •