[2008] Insert mysql

[wence]

whats wrong with this insert function

m_con = New SQLiteConnection(ConfigurationManager.ConnectionStrings("constr").ToString)
            m_con.Open()
            m_sqlstate = "" : m_sqlstate = "INSERT INTO support_action (case_id,product_id,member_id,support_id,action_datetime,action_text)" & _
                                       "VALUES ()"
            m_da = New SQLiteDataAdapter(m_sqlstate, m_con)

[axion_sa]

No values specified, and the use of a data adapter over a command to execute a non-query statement. Also, initialising the m_sqlstate string twice

Parameterized commands: http://www.vb-helper.com/howto_net_d...zed_query.html

[mendhak]

whats wrong with this insert function

m_con = New SQLiteConnection(ConfigurationManager.ConnectionStrings("constr").ToString)
            m_con.Open()
            m_sqlstate = "" : m_sqlstate = "INSERT INTO support_action (case_id,product_id,member_id,support_id,action_datetime,action_text)" & _
                                       "VALUES ()"
            m_da = New SQLiteDataAdapter(m_sqlstate, m_con)

If you get any exceptions or error messages, always mention them. It doesn't matter if the answer is obvious.