Forum Discussion

royd's avatar
royd
Regular Contributor
8 years ago
Solved

if else error - (SQL query)

I am getting an error when running flowing script:     var dbObj = ADO.CreateADOQuery(); dbObj.ConnectionString = "Provider=SQLOLEDB;Server=xxx.xx.xxx.xx;Database=THC_AppServices;User Id=user;Pass...
  • royd's avatar
    royd
    8 years ago

    Hi Robert

     

    Thank you for pointing that out. I seldom make these types of mistake, I would not be surprised at all. So, I double checked. It is fine for a change! :) I guess I messed up while pasting the code.

     

    Thank you for the suggestion.

Marsha_R's avatar
Marsha_R
Champion Level 3

Line: 27 Column: 3. is to tell you that the error detected is on line 27 and 3 characters over from the left.

 

First, is this the whole error and the whole script?  I don't see 27 lines in what you posted.  

 

Also, sometimes a problem is actually before the bit where the error is flagged, so don't count on that line/column being precise.

royd's avatar
royd
Regular Contributor
8 years ago

Hi Marsha

 

Line 27 is:

 

 

if (dbObj.FieldByName("DescLong").AsString === "id_DIRECTED_LOGIN_DISABLED")  //line 27

 commented at the end of line as "//line27"

 

Also, I ran the script without if - else portion, runs fine, logs the expected value from the table.