updating tables using variables..

[liverpool alan]

Hi again,
Just wondering if any of you guys know anything about passing a variable into an SQL statement....e.g...
INSERT INTO TEST Data ( 1, ""+variable , 'Thursday', 1, 5 )
Can anybody clarify whether this is even possible (in any shape or form)???
Thanks,
alan

[hemanth kumar]

Originally posted by liverpool alan:
Hi again,
Just wondering if any of you guys know anything about passing a variable into an SQL statement....e.g...
INSERT INTO TEST Data ( 1, ""+variable , 'Thursday', 1, 5 )
Can anybody clarify whether this is even possible (in any shape or form)???
Thanks,
alan

"insert into test values (1,'" + variable +"','Thursday',1,5)"

[liverpool alan]

Thanz for that......
Alan

[Thomas Paul]

Alan,
Not to get technical but your name does not appear to follow the guidelines required for names on JavaRanch. When you registered you agreed to use a first name and last name and not use an obviously ficticious name. I must ask you to re-register with your real name. Thanks.
------------------
Moderator of the JDBC Forum