Please use addslashes().
Regards,
Swatantra Bhargava
---------------------------------------
On Mon, Feb 16, 2009 at 9:08 PM, abhishek jain <ejaincom@xxxxxxxxx> wrote:
> 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@xxxxxxxxx <mnaji.qx%40gmail.com>>
> To: php-objects@xxxxxxxxxxxxxxx <php-objects%40yahoogroups.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]
>
>
>
--
Swatantra Bhargava
Team Leader
[Non-text portions of this message have been removed]
