Error incorect sintax dbo

Question

1.00/5 (2 votes)

See more:

Error incorect sintax dbo or incorect sinaxt worker, if delete dbo...

What I have tried:

string pronadji = "SELECT brojprijavnice2 AS Redni_broj, radnik AS Radnik, vrijemeprijave AS Vrijeme_Prijave, vrijemeodjave AS Vrijeme_odjave"
                                + "FROM dbo.worker WHERE vrijemeprijave <= convert(date, getDate()) and vrijemeodjave <= convert(date, getDate()) and status = 'odjavljen'";

Posted 13-Mar-18 6:01am

Goran Bibic

Updated 13-Mar-18 6:17am

Add a Solution

2 solutions

Solution 1

The only thing I can see right off hand is that you should put square brackets around the field "status". It's a reserved word in SQL.

Along with that, you should also do convert(date, ...) on the field names as well, to make sure you're just comparing dates.

You may also want to qualify the table name with the name of the database (this is probably your actual problem).

[mydatabase].[dbo].[worker]

For what it's worth, you should always enclose field names, and table names with square brackets just to make sure you're not colliding with SQL reserved words, as well as fully qualifying table names as shown above.

Posted 13-Mar-18 6:17am

#realJSOP

Updated 13-Mar-18 6:20am

v2

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

PeejayAdams · Accepted Answer · 2018-03-13T06:18:00

Solution 2

You're missing a space before "FROM" but please look into SQL Injection and research how to pass parameters to SQL queries safely.

Posted 13-Mar-18 6:18am

PeejayAdams

Comments

#realJSOP 13-Mar-18 12:21pm

I didn't catch that. He'd been warned about sql injection prior to this question.

PeejayAdams 13-Mar-18 12:30pm

Horses and water.