Apostropy Problem
-
Hi All, I m inserting values with the help of a Query in a table. There is a field named Company. I m using 'txtCompany' to insert the value to this field. Now the problem is that when Some One's Company Name like Jan's. Means the apstropy will give error. Any Suggession. Example INSERT INTO Delivery VALUES ('Company'). If company Name is "Shah's" then there will be error. Please Help Thanks in Advance.
-
Hi All, I m inserting values with the help of a Query in a table. There is a field named Company. I m using 'txtCompany' to insert the value to this field. Now the problem is that when Some One's Company Name like Jan's. Means the apstropy will give error. Any Suggession. Example INSERT INTO Delivery VALUES ('Company'). If company Name is "Shah's" then there will be error. Please Help Thanks in Advance.
in my openion there is only one way to solve this problem permanently. you have to use stored procedure to insert data ok happy coding sebastian aten india
-
Hi All, I m inserting values with the help of a Query in a table. There is a field named Company. I m using 'txtCompany' to insert the value to this field. Now the problem is that when Some One's Company Name like Jan's. Means the apstropy will give error. Any Suggession. Example INSERT INTO Delivery VALUES ('Company'). If company Name is "Shah's" then there will be error. Please Help Thanks in Advance.
which database you are using? if using sql: then when you write insert statment where you are passing vlues of that columns you must pass under [dfdf] if you are using oracle this is not possible from user side. you must use regular expression to avoid apostrophy.