[sqlalchemy] Re: Invalid Parameter Type Error on SQL Server Insert

2014-11-13 Thread Jonathan Vanasco
Notice the error: 'Invalid parameter type. param-index=2 param-type=list And then the values you're putting in on index 2: (u'url', None, [2L] You're submitting a list, instead of single value. Your problem is this line: ins_id = result.inserted_primary_key according to the docs

[sqlalchemy] Re: Invalid Parameter Type Error on SQL Server Insert

2014-11-13 Thread Chris Leonard
That solved it, thank you! I'd been struggling with this for 2 days, awesome to move on to other things. In hindsight it seems so simple. I posted this question on SO yesterday with no response. If you have an account there care to make a few extra points, copy/paste your answer and I'll