need solution for storing '(single quotation) in sql database
-
I developed an project in vb for storing some quotations in sql db and displaying it on ASP web page on daily basis. when i am adding quotes in the database, whenever i am using single quotation mark i am getting some run time error .. i need a solution to solve this problem. Give me an instant solution to rectify this problem regards,:doh:
Tech_spidy
-
I developed an project in vb for storing some quotations in sql db and displaying it on ASP web page on daily basis. when i am adding quotes in the database, whenever i am using single quotation mark i am getting some run time error .. i need a solution to solve this problem. Give me an instant solution to rectify this problem regards,:doh:
Tech_spidy
Hi Replace single quotation with double quotation before sending to database. it will be like this comment's will be comment''s
Cheers Navaneeth!!
-
Hi Replace single quotation with double quotation before sending to database. it will be like this comment's will be comment''s
Cheers Navaneeth!!
hi Navaneeth, thanks for ur immediate response.. see while displaying some motivational quotes like, it wouldn't look good.. In official sites we can't go display like this. thanks for ur temprory solution. if you/anyone know the exact solution please reply.. regards,:(
Tech_spidy
-
hi Navaneeth, thanks for ur immediate response.. see while displaying some motivational quotes like, it wouldn't look good.. In official sites we can't go display like this. thanks for ur temprory solution. if you/anyone know the exact solution please reply.. regards,:(
Tech_spidy
-
hi Navaneeth, thanks for ur immediate response.. see while displaying some motivational quotes like, it wouldn't look good.. In official sites we can't go display like this. thanks for ur temprory solution. if you/anyone know the exact solution please reply.. regards,:(
Tech_spidy
Hi Tech_Spidy Don't worry. In database only single quote will be stored. It won't store '' in table.
Cheers Navaneeth!!
-
I developed an project in vb for storing some quotations in sql db and displaying it on ASP web page on daily basis. when i am adding quotes in the database, whenever i am using single quotation mark i am getting some run time error .. i need a solution to solve this problem. Give me an instant solution to rectify this problem regards,:doh:
Tech_spidy
Use parameters to insert strings in to the database. That way you don't have to escape quotation marks. And you improve the security of your application.
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
-
Use parameters to insert strings in to the database. That way you don't have to escape quotation marks. And you improve the security of your application.
Upcoming events: * Glasgow Geek Dinner (5th March) * Glasgow: Tell us what you want to see in 2007 My: Website | Blog | Photos
ok.. i will try tht. thanks for ur response. regards:)
Tech_spidy
-
I developed an project in vb for storing some quotations in sql db and displaying it on ASP web page on daily basis. when i am adding quotes in the database, whenever i am using single quotation mark i am getting some run time error .. i need a solution to solve this problem. Give me an instant solution to rectify this problem regards,:doh:
Tech_spidy
-
Hi Tech_Spidy Don't worry. In database only single quote will be stored. It won't store '' in table.
Cheers Navaneeth!!
Thank you so much navaneeth.. wht u suggested is exactly working.. regards:)
Tech_spidy
-
In SQL 2000 there is some thing called SET QUOTEDIDENTIFIER ON/OFF Pls check this. would help you.
thanks for ur response krish. but i m using sql server for this wat navaneeth suggested is working exactly . regards:)
Tech_spidy