Forum Discussion

mrezahoseini's avatar
mrezahoseini
Contributor
10 years ago

send parameters in Delete Query

Hello   Thank you in advance for your kind assistance   I have a problem in Delete Query, when I 'm gonna use varaiable in Delete Query instead of hard code, like this code, what shall I do??   ...
  • mrezahoseini's avatar
    mrezahoseini
    10 years ago

    yes, my problem was solved like this :

     

     

     

    function Delete()

    {
    var AConnection, Driver;
    AConnection = ADO.CreateADOConnection();
    AConnection.ConnectionString = "Provider=MSDAORA.1;Password=autocm931;User ID=autocm931;Data Source=srv28;Persist Security Info=True";
    AConnection.LoginPrompt = false;
    AConnection.Open();
    var Driver = DDT.ExcelDriver("C:\\Add-Exchange.xls", "Sheet1");
    var k = aqConvert.VarToStr(Driver.Value(0));
    var str = "delete from exchange ex where ex.name like '"+k+"'"
    AConnection.Execute_(str);
    DDT.CloseDriver(Driver.Name);
    AConnection.Close();

    }

     

     

    Thanks for ur consideration

mrezahoseini's avatar
mrezahoseini
Contributor

Thanks for your reply, but unfortunately it has an error like this, when it comes to your reply line:

 

2015-02-24_13-43-46.jpg

tonydugay's avatar
tonydugay
Contributor
10 years ago

maybe the missing space is the issue after like - I have added it....?

 

also maybe (depending on the DB need to add %k%?

 

AConnection.Execute("delete from exchange ex where ex.name like " +  k);  

 

here is a bit of code I use:

 

Qry.SQL = "select TOP 1 * from _SitesToOwners "

+ "inner join _Sites "

+ "on _Sites.Id = _SitesToOwners.Site_Id "

+ "where _Sites.SiteName" + "  like '%(closed)%' "

+ "and _Sites.RecEndDate "

+ "order by newid()";

 

  • marin's avatar
    marin
    Frequent Contributor
    10 years ago