Problem SQL ADO

[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_M K_DESCRIP,VO_VI N_NO,VO_MODEL,V O_BODY,VO_DESCR IPTION" + \
"FROM D014800 LEFT OUTER JOIN D014900 ON (VA_MK_NUMBER_V ER =
VO_MAKE_NO) AND (VA_MK_YEAR = VO_YEAR)" + \
"WHERE (((VA_MK_YEAR)= ?) AND ((VA_MK_DESCRIP )=?) AND
((VO_MODEL)=?)) "

I have tried it with a "INNER JOIN", "JOIN", "LEFT JOIN" etc and get
the following error each time with a syntax error just after the word
INNER, JOIN, or
LEFT sample message below:

com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft OLE DB
Provider for SQL Server', "Incorrect syntax near the keyword 'LEFT'.",
None, 0, -2147217900), None)

OR

com_error: (-2147352567, 'Exception occurred.', (0, 'Microsoft OLE DB
Provider for SQL Server', "Incorrect syntax near the keyword 'INNER'.",
None, 0, -2147217900), None)

any help appreciated

[infidel]

Re: Problem SQL ADO

> "SELECT[color=blue]
> VA_MK_YEAR,VA_M K_DESCRIP,VO_VI N_NO,VO_MODEL,V O_BODY,VO_DESCR IPTION" + \
> "FROM D014800 LEFT OUTER JOIN D014900 ON (VA_MK_NUMBER_V ER =
> VO_MAKE_NO) AND (VA_MK_YEAR = VO_YEAR)" + \
> "WHERE (((VA_MK_YEAR)= ?) AND ((VA_MK_DESCRIP )=?) AND
> ((VO_MODEL)=?)) "[/color]

Doesn't look like you have a space between "VO_DESCRIPTION " and "FROM"

SQL statements are a good place to use Python's triple-quote feature:

sql = """\
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_VE R = VO_MAKE_NO AND
VA_MK_YEAR = VO_YEAR
)
WHERE VA_MK_YEAR = ?
AND VA_MK_DESCRIP = ?
AND VO_MODEL = ?
"""

[len]

Re: Problem SQL ADO

Thanks

You are correct. That was the problem.