•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 423,532 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,340 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser: Programming Forums
Views: 470 | Replies: 2
 |
•
•
Join Date: Dec 2007
Posts: 3
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
i have a column "discription" in my item table that is full of HTML code. It was created using and editor like the one i am using here. It is five pages long when i print it out.
I need to update the column in all records of the table. It is full of single and double quotes. In the quarey i am trying to use update and it really fails badley.
I can update one row at a time but with 10K of records it will take some time.
Can i wrap this code in sometinge that will allow SQL not to go nuts when i try to use it as an update
OR
Can i edit one record and set all of the other records to equal the edited one
I need to update the column in all records of the table. It is full of single and double quotes. In the quarey i am trying to use update and it really fails badley.
I can update one row at a time but with 10K of records it will take some time.
Can i wrap this code in sometinge that will allow SQL not to go nuts when i try to use it as an update
OR
Can i edit one record and set all of the other records to equal the edited one
•
•
Join Date: Aug 2007
Location: KSA
Posts: 147
Reputation:
Rep Power: 2
Solved Threads: 26
Junior Poster
Hi,
How are you updating the table. 10K is not that big number when speaking about data bases.
How are you updating the table. 10K is not that big number when speaking about data bases.
It is never about the number of languages you know, you either have the logic of programming or you don't ...
Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
Some of the codes I post are collected from different sites during the past couple of years, so I would like to thank them for their help and for enabling me to help.
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,098
Reputation:
Rep Power: 8
Solved Threads: 240
If you are updating using php, you can use mysql_real_escape_string or addslashes to escape all the special characters like \, ' and ".
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
|
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
•
•
•
•
ajax asp code css database decimal seperator thousand seperator when using sql server deleting records from ms sql table where columns have duplicate values developer development div dreamweaver firefox google checkout google checkout vat hacker html html api javascript management studio 2005 microsoft microsoft windows msdn news office security skype software sql sql cache dependency with polling-based invalidation survey symantec tables vista vista updates voip w3c web windows update windows vista wysiwyg xml
- Help me in username and password validation through accessing the database (ASP.NET)
- Please help, cant change homepage in IE. Log provided. (Viruses, Spyware and other Nasties)
Other Threads in the MS SQL Forum
- Previous Thread: Adding a database to my rogram.
- Next Thread: Brief description of a thread.
