Jeremy Dunck wrote:
Hi Jeremy, > > The syntax that MS SQL expects: > > select foo from bar where foo = @fooName > > Are we talking about literals or parameters? I'm talking about parameters. > That is, are you expecting: > > select colname from tablename where colname = 'somevalue' > or > select colname from tablename where colname = @somevariableholdingavalue > ? I'm expecting the latter but %s is being passed to the engine rather than @, causing the query to fail. See the traceback I posted for Adrian for a clear look at what I'm talking about. The example traceback I posted for Adrian occurs for every query Django tries to run against MS SQL . E.G - an insert query is being passed as: Insert into T1 value1, value2 values(%s, %s) Rich
