Re: Problem SQL ADO

2005-09-28 Thread len
Thanks You are correct. That was the problem. -- http://mail.python.org/mailman/listinfo/python-list

Re: Problem SQL ADO

2005-09-27 Thread infidel
> "SELECT > VA_MK_YEAR,VA_MK_DESCRIP,VO_VIN_NO,VO_MODEL,VO_BODY,VO_DESCRIPTION" + \ > "FROM D014800 LEFT OUTER JOIN D014900 ON (VA_MK_NUMBER_VER = > VO_MAKE_NO) AND (VA_MK_YEAR = VO_YEAR)" + \ > "WHERE (((VA_MK_YEAR)=?) AND ((VA_MK_DESCRIP)=?) AND > ((VO_MODEL)=?))" Doesn't look like you h

Problem SQL ADO

2005-09-27 Thread len
Using Python on WinXP going against MS SQL 2000 server. Connection is fine and I have executed several queries successfully. The following SQL statement however gives me an error and I have tried it several different ways: "SELECT VA_MK_YEAR,VA_MK_DESCRIP,VO_VIN_NO,VO_MODEL,VO_BODY,VO_DESCRIPTIO