ofirhgy (10/7/2012)

---

hay....

I want insert to table (table name is: "portfolioForExpert") 2 values:
1) expertID
2) portfolioID (value of "1" represent: "stocks", value of "2" represent" "bonds")

but I want it only if the combination of these two value does'nt exists in the table yet...

so I try this command: (by the way I use webMatrix+asp.net so "INSERT IGNORE" will not work...)

updateQuery="INSERT INTO portfolioForExpert(ExpertID,portfolioID)VALUES(@0,'2')WHERE NOT EXISTS(SELECT * FROM portfolioForExpert WHERE ExpertID=@0 AND portfolioID='2')";

db.Execute(updateQuery,ExpertToEdit.ToString());

but I get error like this:

"There was an error parsing the query. [ Token line number = 1,Token line offset = 67,Token in error = WHERE]" (I think its means about the first WHERE....But I don't sure..)

I try everything but I do'nt find a problem with that...

could somebody help me please?

Thanks in advance!!

ofir.