Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error when using multiline SQL variable assignment #109

Open
attibalazs opened this issue Nov 14, 2017 · 2 comments
Open

Error when using multiline SQL variable assignment #109

attibalazs opened this issue Nov 14, 2017 · 2 comments

Comments

@attibalazs
Copy link

I am using SQL server and get an error when using the variable assignment with multi line SQL:

%%sql result << select * from 
foo a 
join bar b on b.id = a.bar_id

(pyodbc.ProgrammingError) ('42000', "[42000] [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near '<'.

@vgrand
Copy link

vgrand commented Dec 1, 2017

Hi attibalazs

Which version of ipython-sql are you running? This feature is only available in version 0.3.9+ which is not the default version pip or conda installs.
See: #79

Hope that helps.

@ViktorQvarfordt
Copy link

ViktorQvarfordt commented Jan 1, 2018

One year has passed, the latest release is still 0.3.8. Is this package dead? #79

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants