Fabian Zubler's Profile

Get Satisfaction uses Javascript and cookies.

You'll need to enable Javascript and cookies to log-in and participate.

Recent activity

Subscribe to this feed

Fabian Zubler replied on August 26, 2009 06:37 to the question "Use input fields as variables in SQL mapping?" in dbCOPY:

I would like to fill a table in an sql database with some values which come out of an excel sheet. On the mapping page, most of the fields can be mapped automatically (same field name), but for one field, I have to do an sql statement. In this statement, I would like to use an input field (from excel) as a variable.

Example:
Fields in excel: xls_1, xls2
Statement: SELECT T1.Code FROM table T1 WHERE T1.db1 = <value>

Is this possible actually (to use the <value>)?</value></value>

Do you think this answers the question? Mark it as answered
Fabian Zubler asked a question in dbCOPY on August 25, 2009 12:16:

Use input fields as variables in SQL mapping?
On the field mapping, I would like to do an SQL statement with using an input field as a variable. How do I have to declare this variable?

Examle:
Input fields: in_1, in_2
Statement: SELECT Code FROM Table T1 WHERE in_1 = 'xxx'