navigation
a webmaster learning community
     Home    Register     Search      Help      Login    
Sponsors

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums
 

Advanced search
Recent Posts

 Todays Posts
 Most Active posts
 Posts since last visit
 My Recent Posts
 Mark posts read

Microsoft MVP

 

Update part of text in memo field

 
View related threads: (in this forum | in all forums)

Logged in as: Guest
Users viewing this topic: none
Printable Version 

All Forums >> Web Development >> ASP and Database >> Update part of text in memo field
Page: [1]
 
AndyUK

 

Posts: 2
Joined: 6/19/2008
Status: offline

 
Update part of text in memo field - 6/19/2008 4:02:39   
I have Access 2000 db, a Table name FORUM_REPLY , table name R_MESSAGE and it is a memo field.

I would like to know if it is possible to amend part of the text stored in this table.

I have hr height="1" and I would like all occurances changed to hr size="1"

Is this possible, if yes any help would be greatly appreciated.
Andy

pd_it_guy

 

Posts: 172
Joined: 3/4/2008
Status: offline

 
RE: Update part of text in memo field - 6/20/2008 18:02:20   
Are you looking for a more or less standalone routine that you can run to do a periodic cleansing of the database, to make that substitution a permanent part of the datafield, or rather, when that memo field is extracted to look at, or send on for other purposes, to only make the change then to the updated information but leave the original as was.

In other words, is there a mechanism now in place that prevents any more hr height- hr size inversions, and we only need to fix what is there now or is the error an ongoing thing, and corrections done as a regular processing routine.

(in reply to AndyUK)
Page:   [1]

All Forums >> Web Development >> ASP and Database >> Update part of text in memo field
Page: [1]
Jump to: 1





New Messages No New Messages
Hot Topic w/ New Messages Hot Topic w/o New Messages
Locked w/ New Messages Locked w/o New Messages
 Post New Thread
 Reply to Message
 Post New Poll
 Submit Vote
 Delete My Own Post
 Delete My Own Thread
 Rate Posts