insert into text data
Posted in 2004
?L???V — — source: Usenet: comp.databases.informix
Our ASP program is listed below, which insert data into informix text field (c1 is char, c2 is text data type). It works but something strange when I try to query the data through isql tool. The c2 filed is "21" not "2", and I can't query the data by isql's form utility. It must use sql command select * from t1 where c1="11". <% set conn = server.createobject("adodb.connection") conn.open #dsn#, #uid#, #pwd# v_c1 = "11" v_c2 = "2" sql = "insert into t1(c1, c2)" & _ " values ('" & v_c1 & "','" & v_c2 & "')" conn.execute sql %> thanks you all!