Hello See SQL

update wp_postmeta set option_value = replace(option_value, ‘nkhba.net\wordpress’, ‘alamhamasat.net’);

In the field option_value of wp_postmeta the following text a:6:{s:5:"width";i:350;s:6:"height";i:280;s:14:"hwstring_small";s:23:"height='96' width='120'";s:4:"file";s:90:"D:\hshome\c259998\nkhba.net\wordpress/wp-content/uploads/2009/10/ououousoouououusoouso.jpg";s:5:"sizes";a:2:{s:9:"thumbnail";a:3:{s:4:"file";s:33:"ououousoouououusoouso-150x150.jpg";s:5:"width";i:150;s:6:"height";i:150;}s:6:"medium";a:3:{s:4:"file";s:33:"ououousoouououusoouso-300x240.jpg";s:5:"width";i:300;s:6:"height";i:240;}}s:10:"image_meta";a:10:{s:8:"aperture";i:0;s:6:"credit";s:0:"";s:6:"camera";s:0:"";s:7:"caption";s:0:"";s:17:"created_timestamp";i:0;s:9:"copyright";s:0:"";s:12:"focal_length";i:0;s:3:"iso";i:0;s:13:"shutter_speed";i:0;s:5:"title";s:0:"";}}< When I run that query above, it should affect the bold string (nkhba.net\wordpress) in the text above and change it to ("alamhamasat.net") corresponding to the query But MySql responds me that (0) rows were affected. please help

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

This code to find the MAC address of a PC connected to the internet. What's a sName in the code?

public class GetMacAddressFromIPAddress
{
[DllImport("iphlpapi.dll", ExactSpelling=true)]
public static extern int SendARP( int DestIP, int SrcIP, [Out] byte[] pMacAddr, ref int PhyAddrLen );
public string GetMacAddress(string sName)
{
string s = string.Empty ;
System.Net.IPHostEntry Tempaddr = null;
Tempaddr = (System.Net.IPHostEntry)Dns.GetHostByName(sName);
System.Net.IPAddress[] TempAd = Tempaddr.AddressList;
string[] Ipaddr = new string[3];
foreach(IPAddress TempA in TempAd)
{
Ipaddr[1] = TempA.ToString();
byte[] ab = new byte[6];
int len = ab.Length;
int r = SendARP( (int) TempA.Address, 0, ab, ref len );
string sMAC = BitConverter.ToString( ab, 0, 6 );
Ipaddr[2] = sMAC;
s = sMAC;
}
return s;
}
}

modified on Tuesday, May 25, 2010 4:01 AM

1 - Visual studio 2008 is already installed with sql server 2005 express edition installed implicity with it. 2 - Sql server 2005 management studion Express Edition is already installed. 3 - Today, I downloaded the one with Advanced Services and installed it but it did not compledte installation, please see following snapshots and guide me: A) http://tareemnet.com/pic/full-text-search1.jpg B) http://tareemnet.com/pic/full-text-search2.jpg C) http://tareemnet.com/pic/full-text-search3.jpg D) http://tareemnet.com/pic/full-text-search4.jpg

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.

how to get number of records selected?

SqlDataReader dr1 = cmd1.ExecuteReader();

string result = ""; append("Ali","Salim",&result); public void append(string a, string b, string result) { result = a +" "+ b; } Error: Error 11 Argument '4': cannot convert from 'string*' to 'string' D:\app\pup\Code\TBrectangular.aspx.cs 23 262 D:\app\

I need it in general, because the word I search for is not determined explicity, but it's also retrieved from database.

SELECT a.id AS [CampaignID],
b.id AS [ZoneID],
a.adheadline,
a.adtext,
a.displayurl,
a.targeturl
FROM adcampaign a
INNER JOIN adzone b
ON a.sitecategory = b.category
AND a.LANGUAGE = b.LANGUAGE
AND a.keyword LIKE '%' + b.keyword + '%';

visit: http://www.cise.ufl.edu/~mschneid/Service/Tutorials/TutorialSDT.html[^]

When we search with for "mobile" word, using "like" as follows:

select ID from Table where column like '%mobile%'

we can get: mobile, bile. But we can not get mobility or mobilization in result, even though they are related words for mobile word we are searching for. So, Do you have solutions to handle those related words, I mean when search for mobile, we can get in result the words mobility and mobilization?

modified on Thursday, May 6, 2010 3:07 PM

make it as

'%'+b.keyword+'%'

I had an error with % at end of query <pre>select a.AdHeadline,a.AdText,a.DisplayUrl, a.TargetUrl from AdCampaign a inner join Adzone b on a.sitecategory=b.category and a.language=b.language and a.keyword like %b.keyword%;</pre> Error: Msg 102, Level 15, State 1, Line 2 Incorrect syntax near 'b'.

Could I replaceany of the dqual "=" into "like"?

How to form this logic in a true sql? Select * from AdCampaign where category and language and keyword in (select sitecategory, language, keyword from Adzone)

Ex: Tables: 1) Account: ID,UserName,Pass 2) Campaign: ID,AccountID,Date,Balance 3) CampaignSpec: ID,CampaignID,Spec,Color Note: Account.ID = Campaign.AccountID and Campaign.ID = CampaignSpec.CampaignID

please clarity more.. and read the question.

I want the function to return a string and not a list string Function:

public List<string> ReturnZoneCode(string sql1)
{
using (SqlConnection con1 = new SqlConnection())
{
con1.ConnectionString = ConfigurationManager.ConnectionStrings["Connectionstring"].ToString();
//string sql1 = "select " + colu + " from " + tbl + " where " + cond1 + " ='" + value1 + "' and " + cond2 + " = " + value2 + "";
using (SqlCommand cmd1 = new SqlCommand(sql1, con1))
{
con1.Open();
using (SqlDataReader dr = cmd1.ExecuteReader())
{
List<string> objList = new List<string>();
while (dr.Read())
{
objList.Add(dr["ZoneCode"].ToString());
}
return objList;
}
}
}

I got a null value. please help me to return a string and not

List

I'd like to change to the previous one... :)

how? give me code in c#

List<string> ZoneCode = ReturnZoneCode("select ZoneCode from AdZone where ID = 20 and AccountID=530");
TextBox1.Text = Convert.ToString(ZoneCode.ToString());

In the code above I called the function(Note: I edited the signature) and I want to bind the returned List into a textbox. Problem what I have that the Textbox is not bounded the the value returned from the call, but it had the following: "System.Collections.Generic.List`1[System.String]"