• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
a problem with get_where

#1
[eluser]edhrx[/eluser]
Hi
this code
$query = $this->db->get_where('mem_sys_views', array('mode' => $mode,
'action' => $action));

Gives me this
Error Number: 1054

Unknown column 'form_id' in 'where clause'

SELECT * FROM (`mem_sys_views`) WHERE `form_id` = 'bfcebbbd76ff508773d7a974e308bae5' AND `mode` = 'member' AND `action` = 'edit'
Note form_id is not in the 'where' array

I'm guessing (at the moment)it comes from a previous call to where() or get_where()
Do I somehow need to 'clear' the where clause before creating another

I'm on the latest version of CI

best wishe Ed


Messages In This Thread
a problem with get_where - by El Forum - 03-26-2008, 03:33 AM
a problem with get_where - by El Forum - 03-26-2008, 03:42 AM
a problem with get_where - by El Forum - 03-26-2008, 03:42 AM
a problem with get_where - by El Forum - 03-26-2008, 04:39 AM
a problem with get_where - by El Forum - 04-02-2008, 01:15 PM
a problem with get_where - by El Forum - 04-02-2008, 03:51 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2020 MyBB Group.