Professional Web Applications Themes

Updating part of the text in an NTEXT field - Microsoft SQL / MS SQL Server

SQL Server Version - 7 Table - Pages Field - Content Hi, I need to update an ip address in an ntext field. I have looked at UPDATEXT, the trouble is the ip address does not appear in the same place within each row. The contents of the field were popuulated at run-time. I need to send them something they can run in query yzer. Any ideas? Thanks for any help in advance. Rocky...

  1. #1

    Default Updating part of the text in an NTEXT field

    SQL Server Version - 7

    Table - Pages

    Field - Content
    Hi,

    I need to update an ip address in an ntext field. I have looked at UPDATEXT, the trouble is the ip address does not appear in the same place within each row. The contents of the field were popuulated at run-time. I need to send them something they can run in query yzer. Any ideas?

    Thanks for any help in advance.

    Rocky




    Rocky Guest

  2. #2

    Default Re: Updating part of the text in an NTEXT field

    [url]http://www.aspfaq.com/2445[/url]





    "Rocky" <rockydial.pipex.com> wrote in message
    news:bejiih$4vr$1titan.btinternet.com...
    SQL Server Version - 7

    Table - Pages

    Field - Content
    Hi,

    I need to update an ip address in an ntext field. I have looked at UPDATEXT,
    the trouble is the ip address does not appear in the same place within each
    row. The contents of the field were popuulated at run-time. I need to send
    them something they can run in query yzer. Any ideas?

    Thanks for any help in advance.

    Rocky


    Aaron Bertrand [MVP] Guest

  3. #3

    Default Re: Updating part of the text in an NTEXT field

    Thanks but its not quite what I am after.



    "Aaron Bertrand [MVP]" <aaronTRASHaspfaq.com> wrote in message
    news:u8c27xtRDHA.304tk2msftngp13.phx.gbl...
    > [url]http://www.aspfaq.com/2445[/url]
    >
    >
    >
    >
    >
    > "Rocky" <rockydial.pipex.com> wrote in message
    > news:bejiih$4vr$1titan.btinternet.com...
    > SQL Server Version - 7
    >
    > Table - Pages
    >
    > Field - Content
    > Hi,
    >
    > I need to update an ip address in an ntext field. I have looked at
    UPDATEXT,
    > the trouble is the ip address does not appear in the same place within
    each
    > row. The contents of the field were popuulated at run-time. I need to send
    > them something they can run in query yzer. Any ideas?
    >
    > Thanks for any help in advance.
    >
    > Rocky
    >
    >

    Rocky Guest

  4. #4

    Default Re: Updating part of the text in an NTEXT field

    So maybe you could better explain what you're after, since that piece of
    code will certainly do what your original post seemed to require.


    "Rocky" <rockydial.pipex.com> wrote in message
    news:bejq9i$hc9$1titan.btinternet.com...
    > Thanks but its not quite what I am after.

    Aaron Bertrand - MVP Guest

  5. #5

    Default Re: Updating part of the text in an NTEXT field


    Hi, I was a bit hasty with my last reply. I made some changes to the
    exmaple code and it seems to have worked fine. Thanks again for your
    help.

    Regards

    Rocky


    *** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
    Don't just participate in USENET...get rewarded for it!
    Darren Rockett Guest

Similar Threads

  1. only show part of a dynamic text field
    By ccarterca in forum Macromedia Dynamic HTML
    Replies: 1
    Last Post: October 28th, 03:25 PM
  2. ntext field not showing up (ASP)
    By tony in forum ASP Database
    Replies: 1
    Last Post: May 27th, 06:51 PM
  3. Updating a text field in SQL Server 2000
    By Michael Walton in forum ASP Database
    Replies: 9
    Last Post: December 23rd, 01:54 PM
  4. SQL SELECT Based on *PART* a text Field?
    By wetchman in forum ASP
    Replies: 3
    Last Post: September 15th, 07:54 PM
  5. SQL - Updating Empty Text Field is enterring -1
    By Aaron Bertrand - MVP in forum ASP Database
    Replies: 1
    Last Post: June 26th, 10:28 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139