AnsweredAssumed Answered

ExecuteSQL help

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


ExecuteSQL help


     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.