Displaying 6 results from an estimated 6 matches for "emp_id".
Did you mean:
smp_id
2011 Sep 09
0
Mysql::Error error in acts as solr plugin
hi,
i am using acts_as_solr in plugin, in my table i got three
columns
emp_id, name, experience.
when i tried to run my application i got following error
"Mysql::Error: Unknown column ''employees.id'' in ''where clause'': SELECT
`employees`.* FROM `employees` WHERE (employees.id in (NULL))"
in my table i dont have column "id&q...
2005 Dec 05
1
Lack of 'LEFT JOIN' in Oracle 8, any patch for theta style (+)
Dears,
Oracle 8 don''t support ANSI syntax with :
SELECT e.emp_id,
e.fname,
e.lname,
j.jobdesc
FROM employe e
LEFT JOIN jobs j ON e.job_id = j.job_id
but only
SELECT e.emp_id,
e.fname,
e.lname,
j.jobdesc
FROM employe e,
jobs j
WHERE j.job_id (+) = e.job_id
JOIN syntax came with 9i.
An...
2010 Jun 10
1
Can RMySQL be used for a paramterized query?
...particular we made no attempt to define
> “bind
> variables”; this is a mechanism by which the contents of R/S objects are
> implicitly
> moved to the database during SQL execution. For instance, the following
> embedded SQL statement
> /* SQL */
> SELECT * from emp_table where emp_id = :sampleEmployee
> would take the vector sampleEmployee and iterate over each of its elements
> to get the result. Perhaps the DBI could at some point in the future
> implement
> this feature.
>
I can connect, and execute a SQL query such as "SELECT id FROM my_table",
and...
2011 Sep 08
8
acts_as_solr problem ActsAsSolr::SearchResults:
hi,
i am using acts_as_solr plugin when i tried with search
by
def search
puts "#####################"
# ids = params[:name]
@id = params[:query]
@emp = Employee.find_by_solr(@id)
puts "------------------------------#{@emp}"
respond_to do |format|
format.html{render :action => ''search''}
format.xml
end
2006 Feb 15
0
Need help setting up and iterating thru a tree
Guys,
Newbie here. Given the following table named Employee_Links:
ID Emp_ID Parent_ID
-- ------ ---------
1 200 100
2 300 100
3 300 200
4 400 100
5 500 400
6 500 300
I''d like to be able to generate a tree that looks like this:
100
|-200
|-300
|-500
|-300
|-400
|-500
Note that where 500''...
2011 Sep 14
5
rjs error TypeError: element.getElementsByTagName is not a function in rails 3+jquery
hi,
i am using rails 3.0.10
i am trying with sample application for searching data from table and
updating
my search.html.erb file is
<%= form_for (@employee) do |s|%
<div id ="search_details">
<%= s.text_field :name%>
<%= s.text_field :emp_id, :onfocus =>
''sal(document.getElementById(''employee_name'').value);''%>
</div>
<% end %>
when i click tab it calls sal() jquery function and i sent the data to
action, in action parameter is
processed well, but while replacing div with partial pa...