Forum Discussion

JackSparrow's avatar
JackSparrow
Frequent Contributor
9 years ago

facing an runtime python error "int object has no attribute split "

Hi All, Am trying to save the extracted data from the DB to a list but am facing the python runtime error "int  object has no attribute split"   def TestProc(): AConnection = ADO.CreateADOConn...
  • baxatob's avatar
    baxatob
    9 years ago

    Try to update your code:

     

    ...

    data_container = [] # create an empty list

while not RecSet.EOF:  
    rows = RecSet.Fields.Item["empno "].Value
    data_container.append(rows) # add retrieved value to the list
    RecSet.MoveNext()

    ...

    After the while loop will be completed, data_container list should contain all requested values from your table.

  • baxatob's avatar
    baxatob
    9 years ago

    Try this:

     

    Log.Message(str(data_container))

    That is not the best solution, but it should help you to understand the output using Log.Message() method.

JackSparrow's avatar
JackSparrow
Frequent Contributor

1) Expectation of my function is to extract the data from the database

2)i was able to extract the data but the data was coming in the column format but i want them in a list so i was trying to split the column wise value and assassin that into a List so that i can compare two Lists

baxatob's avatar
baxatob
Community Hero
9 years ago

Try to update your code:

 

...

data_container = [] # create an empty list

while not RecSet.EOF:  
    rows = RecSet.Fields.Item["empno "].Value
    data_container.append(rows) # add retrieved value to the list
    RecSet.MoveNext()

...

After the while loop will be completed, data_container list should contain all requested values from your table.

  • JackSparrow's avatar
    JackSparrow
    Frequent Contributor
    9 years ago

    But when am trying to print data_container through Log.Message its showing empty

    • baxatob's avatar
      baxatob
      Community Hero
      9 years ago

      Try this:

       

      Log.Message(str(data_container))

      That is not the best solution, but it should help you to understand the output using Log.Message() method.

      • JackSparrow's avatar
        JackSparrow
        Frequent Contributor
        9 years ago

        thanks for your time and guidance ,am struggling alone and learning so many things thanks a lot baxatob