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>
To: php-objects@xxxxxxxxxxxxxxx
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]
