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
Ranch Hand
Joined: Mar 15, 2001
Posts: 55
posted
0
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
Greenhorn
Joined: Nov 08, 2000
Posts: 18
posted
0
Thanz for that...... Alan
Thomas Paul
mister krabs
Ranch Hand
Joined: May 05, 2000
Posts: 13974
posted
0
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
0
