how to get variable into mysql script

Hi,
I am new at variables and connectors.

This works.
insert into test.persons (LastName) values (‘narly’);

This doesn’t.
insert into test.persons (LastName) values ( ${lastname} );

Here is the bar file
http://wikispeedia.org/Rhino_Registration--1.0.bar

Thanks for any leads!
jim

Hi,

You just only need to put the apostrophe ’ ’
So the query must be like this : insert into test.persons (LastName) values ( ‘${lastname}’ );
I hope it works.

Regards

Newbie:
I am trying to fill a Form with mysql data like in this video:
vid

I can’t get the groovy to be happy.
It says “cant find constructor”.

Q: What do I do? I have been trying for months.

Thanks!