Select query in sql not retrieving the value in database

Question

If i have employee_id with integer (like 1001) alone, am getting the answer

example the code like this ,

   $claimprocess = Employee::find()
                    ->where("employee_id = '1004'  and importcompany_id = 1")
                    ->andwhere(" status != 'Deleted' and relationship = 'Self'")
                    ->all();

if i have a employee_id with combination interger and character, am not able get a answer(like E1004),

example code like below,

$claimprocess = Employee::find()
                    ->where("employee_id = 'E1004'  and importcompany_id = 1")
                    ->andwhere(" status != 'Deleted' and relationship = 'Self'")
                    ->all();

When I execute this code, am getting error like below

Exception (Database Exception) 'yii\db\Exception' with message 'SQLSTATE[42S22]: Column not found: 1054 Champ 'E1004' inconnu dans where clause The SQL being executed was: SELECT * FROM employee WHERE (employee_id = E1004 and importcompany_id = 1) AND ( status != 'Deleted' )'

UPDATED:

actually am getting that value(E1004) from another variable, I use the variable instead of value, for understanding purpose I have used a value there in my question

employee_id = E1004 it need to be employee_id = 'E1004'

Noman
– Noman

2015-08-10 07:12:58 +00:00
Commented Aug 10, 2015 at 7:12 — Noman
– Noman, Commented Aug 10, 2015 at 7:12

Narendrasingh Sisodia · Accepted Answer · 2015-08-10 09:03:00Z

3

You need to enclose your employee_id value i.e. E1004 within quotes its because it contains string literals. So your query looks like a

->where("employee_id = 'E1004'  and importcompany_id = 1")

edited Aug 10, 2015 at 9:03

answered Aug 10, 2015 at 7:12

Narendrasingh Sisodia

21.4k6 gold badges51 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Nodemon Over a year ago

actually am getting that value from another variable, i use the variable instead of value, for understanding purpose i have used a value there in my question

Narendrasingh Sisodia Over a year ago

So enclose that variable along with quotes then

Mureinik · Accepted Answer · 2015-08-10 07:13:31Z

1

String literals in SQL are denoted with single quotes ('). Without them, the database would interpret E1004 as a column name, and fail the query, since your table doesn't have such a query.

$claimprocess = Employee::find()
                ->where("employee_id = 'E1004'  and importcompany_id = 1")
                ->andwhere(" status != 'Deleted' and relationship = 'Self'")
                ->all();

answered Aug 10, 2015 at 7:13

Mureinik

316k54 gold badges402 silver badges406 bronze badges

Comments

sanjeev · Accepted Answer · 2015-08-10 07:14:55Z

0

You need to pass the value correctly , as if now you are not passing the value correctly , hence Yii is not generating Sql query correctly. You can pass second parameter to to where clause

    $claimprocess = Employee::find()
                        ->where("employee_id = ':employee_id'  and importcompany_id = 1" , array(':employee_id'=>'E1004'))
                        ->andwhere(" status != 'Deleted' and relationship = 'Self'")
                        ->all();

answered Aug 10, 2015 at 7:14

sanjeev

4,6512 gold badges22 silver badges28 bronze badges

5 Comments

Nodemon Over a year ago

Actually am passing literal value, i have a variable that contains value like 1003, E1004. i understanding purpose i have used value instead of variable

Nodemon Over a year ago

i have use like this $claimprocess = Employee::find() ->where("employee_id = $employee_id and importcompany_id = 1") ->andwhere(" status != 'Deleted' and relationship = 'Self'") ->all();

sanjeev Over a year ago

->where("employee_id = ':employee_id' and importcompany_id = 1" , array(':employee_id'=>$valueVariable))

sanjeev Over a year ago

try like this

$claimprocess = Employee::find() ->where("employee_id = '$employee_id' and importcompany_id = 1") ->andwhere(" status != 'Deleted' and relationship = 'Self'") ->all();

sanjeev Over a year ago

great :) , sometime we forget the basics

Collectives™ on Stack Overflow

Select query in sql not retrieving the value in database

3 Answers 3

2 Comments

Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related