Welcome Guest, Not a member yet? Register   Sign In
Seeing query before submitting
#1

[eluser]Unknown[/eluser]
This may be a newbie question, but something I can't find in the docs very easily:

Is there a way to see a query string that's built before actually running the query? I know last_query shows you what was run, but for debugging, I'd like to see it without actually submitting it.

$data = array(
'myfield1' => $EmployeeNo,
'myfield2' => date("Y-m-d")
);

$this->db->where('recordno', $RecordNumber);
$this->db->update('propertytable', $data);

This will actually execute the query -- how do I just get a string of what the query will look like to confirm it's being built correctly with my data?


Messages In This Thread
Seeing query before submitting - by El Forum - 06-14-2010, 05:20 PM
Seeing query before submitting - by El Forum - 06-14-2010, 09:32 PM



Theme © iAndrew 2016 - Forum software by © MyBB