use addslashes() function . before u insert any to db. Hari K T http://www.harikt.com/ http://ijust4u.blogspot.com/ --- On Mon, 16/2/09, abhishek jain <ejaincom@xxxxxxxxx> wrote: From: abhishek jain <ejaincom@xxxxxxxxx> Subject: Re: Insert problem To: php-objects@xxxxxxxxxxxxxxx Date: Monday, 16 February, 2009, 9:08 PM can you pl. check, it is a update query or an insert query, Further pl. let us know the o/p of the variable or the query. -- Regards, Abhishek jain ____________ _________ _________ __ From: Mohammad Al-Naji <mnaji.qx@gmail. com> To: php-objects@ yahoogroups. com Sent: Sunday, February 15, 2009 2:49:22 PM Subject: Re: Insert problem its text, i just found that it's inserted correctly in DB but PHP cannot read it all, it reads it truncated... On Sun, Feb 15, 2009 at 9:13 AM, abhishek jain <ejaincom@yahoo. com> wrote: > is BodyEn varchar and not text > > Pl. dump your table schema. > -- > Regards, > Abhishek jain > > ____________ _________ _________ __ > From: Mohammad Al-Naji <mnaji.qx@gmail. com <mnaji.qx%40gmail. com>> > To: php-objects@ yahoogroups. com <php-objects% 40yahoogroups. com> > Sent: Sunday, February 15, 2009 12:29:14 PM > Subject: Insert problem > > I'm trying to insert the following statement into MSSQL DB, the field type > is text but is not inserted completely, it's truncated. can anyone help? > > statement > > UPDATE Table > SET BodyEn = '<p align="left" > class="header_ black"><strong> Terms of Use </strong> </p> > <p align="left" > company test Telecom and related > companies ("company Telecom"), ("company International) > provides access to and allows use of this site (www.company- > test.com) > subject to the following terms:<br /> > 1. By using www.company- test.com you agree to > be legally bound by these terms, which shall take effect immediately on > your first use of www.company- test.com. If you do not agree to be legally > bound by all the following terms, please do not access and/or use > www.company- test.com. <br <http://www.company- test.com. %3cbr/> /> > <br /> > 2. company test Telecom may change these terms > at any time by posting changes online. Please review these terms regularly > to ensure you are aware of any changes made by company test Telecom. Your > continued use of www.company- test.com after changes are posted means you > agree to be legally bound by these terms as updated and/or amended. </p> > <p align="left" class="header_ black"><strong> Use of > www.company- test.com< /strong <http://www.company- test.com% 3c/strong>> > </p> > > <p align="left" > 3. You may not copy, reproduce, > modify, transfer, distribute, republish, download, post, broadcast, > transmit, make available to the public, or otherwise use the content on > this site (content includes but is not limited to text, layout, > information, communications, software, sounds, names images, pictures, > logos, icons, apparatus, product or process) in any form or by any means > (including but not limited to electronic, mechanical photocopying or > recording) except for your own personal, non-commercial use. You also agree > not to adapt, alter or create a derivative work from any > www.company- test.com content. Any other use of www.company- test.comcontent > requires the prior written permission of company test Telecom. <br /> > You understand and agree that you are responsible > for any content that you post or transmit on or through this site. You > agree not to cause, nor knowingly allow others to cause, any nuisance, > annoyance, or inconvenience, whether to company test Telecom or users of > www.company- test.com by any means.<br /> > 4. You agree to use www.company- test.com only for > lawful purposes, in a manner consistent with all applicable laws and > regulations and in a way that does not infringe the rights of, restrict or > inhibit anyone else"s use and enjoyment of www.company- test.com. > Specifically, you will not use www.company- test.com to post, transmit, > distribute, link to or solicit content that (a) violates or infringes any > laws, regulatory requirements or codes (b) infringes or violates any > copyright, trademark or any other intellectual property, personal or > proprietary rights of any person, or violates any obligation of confidence > or any other proprietary right; (c) contains any obscene, offensive, > defamatory or otherwise actionable material; (d) disrupts the normal flow > of dialogue within companytelecomtest. com; (e) undermines the security or > integrity of companytelecomtest. com, including without limitation by > importing any viruses, Trojan horses, time bombs or other disabling devices > intended to detrimentally interfere, damage, surreptitiously intercept or > expropriate such equipment, systems or networks; (f) contains any errors, > whether technical or otherwise; or (g) contains any material in any form > that would otherwise render company test Telecom liable or expose company > test Telecom to any proceedings whatsoever.< br /> > 5. You may not use any robot, spider, or other > automatic or manual device or process to monitor or copy our web pages or > any portion of the content contained herein without the express prior > written permission of company test Telecom.<br /> > 6. You may not use any device, software or > routine to interfere or attempt to interfere with the proper working of > www.company- test.com, or to impose an unreasonable or disproportionately > large load on the servers serving > www.company- test.com. <br<http://www.company- test.com. %3cbr/>/> > > 7. company test Telecom shall have the right (but > not the obligation) in its sole discretion to monitor, refuse or remove any > content that is available via www.company- test.com. Without limiting the > foregoing, company test Telecom shall have the right to remove any content > that violates these terms or is otherwise objectionable. </p> > <p align="left" class="header_ black"><strong> Content > Posted or Submitted to company test Telecom</strong> </p> > <p align="left" > 8. company test Telecom freely > welcomes the submission of comments, information, or feedback through > www.company- test.com, by all means and in any media now known or > hereafter > developed. By submitting information through this site you agree that the > information shall not be considered confidential and shall become the > property of company test Telecom, including an assignment of all rights and > titles to such information. Where assignment is not possible, company test > Telecom shall have the unrestricted right to use such information, with > right to reproduce, distribute, transmit, create derivative works of, > publicly display and publicly perform any materials and other information > (including, without limitation, ideas contained therein for new or improved > products and services) you submit to www.company- test.com, for any > purpose > and without compensation to you. You also grant to company the right > (though you acknowledge and agree that company test Telecom shall not be so > obliged) to use your name in connection with the submitted materials and > other information as well as in connection with all advertising, marketing > and promotional material related thereto. You agree that you shall have no > recourse against company test Telecom for any alleged or actual > infringement or misappropriation of any proprietary right in your > communications to us. <br /> > 9. Except for any personal, individually > identifying information which we have agreed to keep confidential, any > feedback, data, answers, questions, comments, suggestions, plans, ideas or > the like that you send to us via www.company- test.com, via e-mail or > otherwise, will be treated as being non-confidential and non-proprietary. > We assume no obligation to protect such information from disclosure and > will be free to reproduce, use, and distribute the information to others > without restriction. We will also be free to use any ideas, concepts, > know-how or techniques contained in information that you send us for any > purpose whatsoever including but not limited to developing, manufacturing > and marketing products and services incorporating such information. </p> > <p align="left" > class="header_ black"> <strong>Postings by Third > Parties and Hyperlinks to Third Party Websites</strong> </p> > <p align="left" > 10. www.company- test.com contains > hyperlinks to other websites which are neither maintained nor controlled by > company test Telecom, or may contain content posted on or via > www.company- test.com by third parties. company test Telecom shall not be > responsible for any errors or omissions in any content in > www.company- test.com, or the content, products or services of any > hyperlinked website or any hyperlink contained in a hyperlinked web site, > nor for the privacy and security practices employed by these other > websites, and shall not be liable for any loss or damage of any kind > incurred as a result of the use of any content posted or contained in > e-mails or otherwise transmitted or displayed via www.company- test.com, > or > arising from access to those websites. Use of www.company- test.com and > any > hyperlinks and access to such hyperlinked websites are entirely at your own > risk.<br /> > 11. You acknowledge that company test Telecom has > no control over and excludes all liability for any material on the Internet > which can be accessed by using www.company- test.com. Neither can we be > deemed to have endorsed the content.</p> > <p align="left" > class="header_ black"><strong> Hyperlinks from Third Party > Websites</strong> > </p> > <p align="left" > 12. You agree that caching, > deep-linking, hyper linking to, and framing of www.company- test.com or > any > of the contents are strictly prohibited.< br /> > 13. company test Telecom reserves all rights to > disable any links to, or frames of any site containing inappropriate, > profane, defamatory, infringing, obscene, indecent or unlawful topics, > names, material or information, or material or information that violates > any written law, any applicable intellectual property, proprietary, privacy > or publicity rights.</p> > <p align="left" > class="header_ black"><strong> Disclaimers and Limitation of > Liability</strong> </p> > <p align="left" > 14. You assume total responsibility > and risk for your use of www.company- test.com and the Internet. Neither > company test Telecom nor any content provider makes any express or implied > warranties, representations or endorsements whatsoever with regard to > www.company- test.com, any content or any merchandise, information or > service provided through www.company- test.com or on the Internet</p> ' > WHERE (ID = 41) > > -- > Kind Regards, > Mohammad Al-Naji > > [Non-text portions of this message have been removed] > > [Non-text portions of this message have been removed] > > > -- Kind Regards, Mohammad Al-Naji [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] Bring your gang together. Do your thing. Find your favourite Yahoo! group at http://in.promos.yahoo.com/groups/ [Non-text portions of this message have been removed]
