code below might help:

import iris

# sql statement
sql = "SELECT ID, Name, Age FROM Sample.Person WHERE Age = ?"
result = iris.sql.exec(sql, Myage)

for row in result:
    ## Unpack tuple directly
    id, name, age = row  
    #Access by index (0-based in this case)
    name = row[1]  # Name is 2nd column (index 1)
    
    # Print values
    print(f"ID: {id}, Name: {name}, Age: {age}")

Congrats to all the winners! Amazing stuff—so much to learn from you all!
 

Thanks @Evgeny Shvarov for sharing the Technological Bonuses Results.
Note that the iris-AgenticAI application now supports Vector Search, and the second article is also published.
 

Great app. Excellent work!

Congratulations to all the winners and participants. Your articles were truly inspiring and showcased exceptional creativity and insight.

I found that the issue was actually related to the Python installation itself. After resolving the installation problem, the application is now working fine.

Thank you all for your help and support

IRIS for Windows (x86-64) 2024.2 (Build 247U) Tue Jul 16 2024 09:57:03 EDT [Health:7.2.0-3.m2024.1.2]

Hi @Guillaume Rongier 
Still same issue

Hi @Guillaume Rongier 
I am getting the following error while calling iop on Windows


D:\temp\iop>iop -start
WARNING:root:Error importing pythonint312: irisinit failed
WARNING:root:Embedded Python not available
Traceback (most recent call last):
  File "<frozen runpy>", line 198, in _run_module_as_main
  File "<frozen runpy>", line 88, in _run_code
  File "D:\temp\iop\.venv\Scripts\iop.exe\__main__.py", line 4, in <module>
  File "d:\temp\iop\.venv\Lib\site-packages\iop\__init__.py", line 1, in <module>
    from iop._business_operation import _BusinessOperation
  File "d:\temp\iop\.venv\Lib\site-packages\iop\_business_operation.py", line 3, in <module>
    from iop._business_host import _BusinessHost
  File "d:\temp\iop\.venv\Lib\site-packages\iop\_business_host.py", line 8, in <module>
    from iop._decorators import input_serializer_param, output_deserializer
  File "d:\temp\iop\.venv\Lib\site-packages\iop\_decorators.py", line 3, in <module>
    from iop._dispatch import dispatch_deserializer, dispatch_serializer
  File "d:\temp\iop\.venv\Lib\site-packages\iop\_dispatch.py", line 15, in <module>
    def serialize_pickle_message(message: Any) -> iris.cls:
                                                  ^^^^^^^^
AttributeError: module 'iris' has no attribute 'cls'

Thanks @Laura Blázquez García for the nice article!

 

Congratulations @Mihoko Iijima 

Congratulations to all, and thanks to the community for this recognition and all the support. 
 

Thank you @Chris Stewart for the detailed explanation! The video was very informative and clear. I appreciate how well it covered the key points.

Thank you to the community for this recognition. It is an honor to be acknowledged, and I extend my congratulations to all the winners.

Thank you, @Evgeny Shvarov for the insights!

I've been using Docker and IPM in my projects, and they’ve been incredibly convenient. Docker simplifies the development environment setup and makes collaboration much easier, while IPM streamlines the installation process with minimal steps. Both have significantly improved my workflow.

Nice information, Thanks for sharing

Thanks @Anastasia Dyubaylo for sharing the review.

I'm once again a Writer Extraordinaire this year.

I also submitted my app for approval on OEx, but it's been several hours with no response.

Congratulation @Alberto Fuentes