AnsweredAssumed Answered

ExecuteSQL help

Question asked by leonaisse on Jun 17, 2013
Latest reply on Jun 17, 2013 by philmodjunk

Title

ExecuteSQL help

Post

     Hi all

     Can anyone see whats wrong with this, its returning ?

     ExecuteSQL ( "Select emailAddr from dbo.suppliers where ID = ?"; "";  ""; $supplierID )

     $supplierID has a numeric value.

     dbo.suppliers is a shadow table using an external datasourse (MS SQL) DSN.

     Any ideas? Can I use ExecuteSQL on shadow tables or do i need to use Execute SQL?

     If i have to use Execute SQL how do i get the returned value into a variable? Basically im trying to get more detail about a supplier based on the supplierID value selected in a Pop Up menu.

      

     Thanks

      

     Leonaisse

Outcomes