Pkira
10/1/2015 - 4:22 PM

SQL Connection

SQL Connection

import pyodbc

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=server;DATABASE=database;UID=user;PWD=pass')

cursor = conn.cursor()

cursor.execute('SELECT  \'d\' + rtrim(ltrim(str(L_art.IDA))) IDA, titulo, texto  FROM L_ART (nolock) INNER JOIN Texto ON Texto.IDA = L_ART.IDA WHERE L_ART.IDA = '+ str(id) +' ')
        
rows = cursor.fetchall()

for row in rows:
  articleid = row[0]