Excel Data Link Query, multiple parameters

Permanently deleted user

December 04, 2012 14:30

Hello, how should I build a Excel Data Link Query with multiple parameters?

 

It works fine when there's only one parameter, for example,

 

SELECT * FROM "sheet1$" WHERE ID = ? 

 

(Parameter Name = theID, Field = id)

 

But how about if there’s more than one parameter, how it knows the "?" refers to which parameter? Thanks

0

• 

  Ryan Cooney

  December 05, 2012 01:15

  Hi Jack,

  For ODBC data connections you just use multiple question marks. The order of the "?"s in the SQL statement must match the order of the parameters defined in the Site.

  --Ryan

  0

Please sign in to leave a comment.