1 Reply Latest reply on Jun 17, 2013 8:48 AM by philmodjunk

    ExecuteSQL help



      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.