Closed

Need an error to be fixed

I have a django project and I am getting an SQL error. This SQL error is coming when userIDs are passed to the SQL query by a parameter(%empids%). However, if I hard code the userIDs in the SQL query, everything works fine.

I am sure userIDs are passed to the SQL query by the parameter (%empids%) properly, since the logs show it. I am suspecting it may be a data type issue, but not sure.

I am not able to share the entire project with you (legal issues), but I can share the relevant code segment.

Thanks.

Skills: Python, MySQL, Database Administration, SQL

See more: timely relevant issues, need speed fixed bugs, configure error need install gmcs, world need fixed, english grammartical error need proof read, need photos fixed, need script fixed, youtube video upload error fixed, need website fixed, paypal prestashop error fixed, need type data entry, need joomla site updated security issues fixed, hello freelancer i need simple logo design and i have a pretty good idea what type of design i want, hello freelancer i need simple logo design and i have a pretty good idea what type of design i, need someone to develop an android application that will be able to capture images of arabic sentences, need to fixed bugs in existing net application, need to hire a tech person to redo my entire blog, 1. The Paypal api adaptive payments issues can be fixed. However we need specific information on what need to be done over there

About the Employer:
( 2 reviews ) Lyons, Australia

Project ID: #21182031

15 freelancers are bidding on average $24 for this job

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

$55 USD in 1 day
(48 Reviews)
6.3
susanna2018

Hi, Client!! @$@$@$PLEASE CONTACT ME. I CAN DO IT WONDERFULLY.$@$@$@ ##% Your idea is attracted me to your world.%## I am Django expert. i have various skills. @@PLEASE GIVE ME CHANCE TO PROVE MY SKILLS@@ :-):-):-) More

$50 USD in 7 days
(45 Reviews)
6.0
$30 USD in 1 day
(5 Reviews)
2.9
rdevedzhiev

Hey there, i can help you out with the query

$21 USD in 1 day
(3 Reviews)
1.5
Farhan81o

Hello Dear! I'm a web developer with over 5 years experience and very strong in HTML5, CSS3, Javascript, jquery, PHP, MySQL Angular,... I 'm sure that would be finished for you with a good result when my talent be com More

$15 USD in 1 day
(0 Reviews)
0.0
PavelKuzmich

Hello, what SQL error are you getting? Try to simplify your SQL request and step by step check the result. SELECT userid FROM ( SELECT [login to view URL] FROM attshifts as a LEFT JOIN userinfo as u ON [login to view URL] = [login to view URL] More

$20 USD in 1 day
(0 Reviews)
0.0
rodrigollna

I think userIDs is integer. That's right? Try these possibilities - (% (empids) d) (with 'd' in place of 's') - (% (empid) s) (without 's' in variable name) -% (empids) s (without first parentheses) -% (empids) d (with More

$10 USD in 1 day
(0 Reviews)
0.0
send2biplab6

hello myself biplab from UBK INFOTECH I have a experiance design and development team android iOS php larvae ionic python ci ping me I can solve this problem. thanks and regards biplab

$30 USD in 2 days
(0 Reviews)
0.0
Filiumenterprise

Dear Sir, Read your requirements, and our skills match the required implementation. We are a fast - growing company, and have well- trained resources available to initiate your project immediately. Below, are a few in More

$30 USD in 7 days
(0 Reviews)
0.0
djangowriter

Just debug buddy try to print the inputs by each line and understand the control flow or maybe try to check in shell using ORM. i think you can do it. still if you cant . come to me . i will help you out . u can check More

$15 USD in 2 days
(0 Reviews)
0.0
awaisrafaqat2300

I have extensive working experience in MS SQL, Oracle & MySql, of more than 8 years. I can help you in completing your project. I can assure you the best quality of my work. Looking forward to hear from you. Thanks.

$15 USD in 1 day
(0 Reviews)
0.0
aipwork

You have an error in the query with brackets because you are trying to format a tuple into a string. See the text of the error: "Incorrect syntax near ')' ...") There was this code: sql = "[login to view URL] in (%(empids)s)" % { More

$10 USD in 1 day
(0 Reviews)
0.0
PiyushGupta55555

I have already worked on PL SQL in my previous projects. I have written packages, cursors, triggers and anonymous block. I have also faced such kind of errors in past So, I think I could resolve it asap.

$15 USD in 2 days
(0 Reviews)
0.0
gauravgangwar363

I have been working on Sql and pl/sql with some reputed organizations. I have worked on integration of webservices with database using Pl/sql and have experience in coding to handle large amount of data.

$23 USD in 4 days
(0 Reviews)
0.0
Abinaya48

Kindly let me an opportunity to showcase my talent since being new to freelance. I have vast experience in SQL and will fix in 1 hour.

$25 USD in 1 day
(0 Reviews)
0.0