Hi, just wondered how in Jess if you have a String and a Variable how you can use them together such as this:
(import java.sql.*) (call Class forName com.mysql.jdbc.Driver) (bind ?connection (call DriverManager getConnection "jdbc:mysql://localhost:3306/test" "username" "password")) (bind ?statement (?connection createStatement)) (bind ?name "henry") (?statement executeUpdate "UPDATE rules SET rule1 = 'yes' WHERE name = '?name';") Where it executes a query that reads: UPDATE rules SET rule1 = yes WHERE name = henry; Thanks. -------------------------------------------------------------------- To unsubscribe, send the words 'unsubscribe jess-users [EMAIL PROTECTED]' in the BODY of a message to [EMAIL PROTECTED], NOT to the list (use your own address!) List problems? Notify [EMAIL PROTECTED] --------------------------------------------------------------------
