0 Replies Latest reply on Mar 17, 2009 2:12 PM by DMcQ

    Parameterize SQL statement

    DMcQ Level 1
      Maybe I'm missing this in the AIR docs, but I don't see anything that warns me about using parameters for only certain parts of a SQL query. However, it seems like I can't do this:

      stmt.text = "SELECT * FROM :tableName WHERE :foreignKeyColumnName=:foreignKeyID"

      ( I need this kind of functionality based on the simple DAO-style manager I'm using for Object->DB mapping. )

      Are there restrictions on where parameters can be used? If so, has anybody tackled this issue in a different way?

      Thanks for any thoughts.

      Daniel M