Author Topic: data retrieval error...  (Read 267 times)

0 Members and 1 Guest are viewing this topic.

Offline rainpropTopic starter

  • Irregular
  • Posts: 27
    • View Profile
data retrieval error...
« on: March 16, 2010, 01:13:47 PM »
hi, wat does this mean?how to solve it??

data retrieval error:
unknown column 'department.DEP_RATE' in 'field list'

thanks..

Offline nafetski

  • Enthusiast
  • Posts: 270
    • View Profile
Re: data retrieval error...
« Reply #1 on: March 16, 2010, 01:15:49 PM »
It means the 'department.DEP_RATE' column is unknown :P

Seriously tho, tha'ts what it means.

department should be your table, and DEP_RATE should be the field it's accessing.  Make sure the case is right (that it's caps), and make sure that table has that field.

Dev Environment: Mac - OSX Snow Leopard / Eclipse / Kohana PHP Framework
Job: Sr Software Developer: (Large scale enterprise)
Notice:  Most of my forum posts I write on my iPhone while taking a dump.  This means that I don't test most of my code, and I might sound like I'm impatient...really I'm just busy punching a grumpy
Also: I've hit Google so many times it's asking for a divorce

Offline rainpropTopic starter

  • Irregular
  • Posts: 27
    • View Profile
Re: data retrieval error...
« Reply #2 on: March 16, 2010, 01:23:34 PM »
thanks alot..its solved now..  :D