Forum Discussion

IP's avatar
IP
Occasional Contributor
15 years ago

[RESOLVEDD]Using variables for insertion values via DataSink

Newbie Hi, I have made a testcase which works fine. However I'm trying to store the results from the webrequest in a mysql-database which gives me some trouble. The Data-connection works fine fo...
IP's avatar
IP
Occasional Contributor
15 years ago
Hi,

Sorry for the missing sql-query.

The working sql-query (fixed value) is:                            insert into test(naam) values ('1')
The not-working sql-query (variable)                                insert into test(naam) values (${DataSource#surname})
The error I get with the last query is: "java.lang.Exception: SQL problem occured"
Kind regards

Recent Discussions