Could you try the statement below? select replace(option_value, 'wordpress', 'Hello World') from wp_postmeta; I are Troll :suss:

And this case , it's the internet ip address and not the pc ip address, isn't it? 2nd thing is that, when using this code, how to suppply internet address for it, do I have to get a code to detect the internet ip address and then pass it to the MAC Function? THanks

That was my experience as well, but at least you managed to do it with one step less than me. ;) My advice is free, and you may get what you paid for.

How exactly do you reckon this will return the row count? What is cmd1.CommandText in this case?

Now you surprise me. :laugh: :laugh: Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Prolific encyclopedia fixture proof-reader browser patron addict? We all depend on the beast below.

SELECT id FROM AdCampaign WHERE FREETEXT(Keyword, 'going'); Error: Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'AdCampaign' because it is not full-text indexed.

USE pubs IF EXISTS (SELECT name FROM sysobjects WHERE name = 'au_info2' AND type = 'P') DROP PROCEDURE au_info2 GO USE pubs GO CREATE PROCEDURE au_info2 @lastname varchar(30) = 'D%', @firstname varchar(18) = '%' AS SELECT au_lname, au_fname, title, pub_name FROM authors a INNER JOIN titleauthor ta ON a.au_id = ta.au_id INNER JOIN titles t ON t.title_id = ta.title_id INNER JOIN publishers p ON t.pub_id = p.pub_id WHERE au_fname LIKE @firstname AND au_lname LIKE @lastname this example was taken from msdn like examples Marc Clifton wrote: That has nothing to do with VB. - Oh crap. I just defended VB!

I would suggest the more "proper" way to do this would be to set up proper foreign key relationships along with cascade options in the database. Then you don't have to worry about this at all.

Use a StringBuilder instead of a list. "WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes. My blog | My articles | MoXAML PowerToys | Onyx

in SQL single quote's can be used to delimit string literals, so if you need them as part of your data, try one of the following: 1. use SQLParameter, which is always the better option as it prevents SQL Injection vulnerability; 2. or double the single quote(s) inside your data Now why would you want single quotes at the extremes of your data in the first place? Maybe you are misinterpreting some piece of documentation? :) Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Prolific encyclopedia fixture proof-reader browser patron addict? We all depend on the beast below.

Using JavaScript you can go back or forward in the browser's navigation history. Most of the time you want to go back one page. For doing that, use the following code: history.go(-1);

This is very common issue and you can easily find it over here. Server Error in '/' Application. "Validation of viewstate MAC failed.[^] Cheers ! Abhijit Jana | MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

You would have to monitor the text boxes' onKeyUp event. For every invoke of the event you would copy the content of the respective text box and represent in the respective area. Example: /** * variable x is the id of the text box you want copied * and y is the id of the tag you want the text box's value to be copied to **/ function copy(x,y) { var text=document.getElementById(x).value; document.getElementById(y).innerText = text; } The above should be placed in a script tag preferably within your head tag. Then add the following code to the respective textboxes: