Welcome Guest, Not a member yet? Register   Sign In
Error in Query
#1

[eluser]Tamilmani[/eluser]
I have used SQL AZURE PHP DRIVERie is
Quote:sqlsrv
.

My Query is
Code:
$this->db->select('*');
        $this->db->from('member');
        $this->db->join('people', 'people.p_id = members.p_id');
        $this->db->order_by('members.p_id', 'asc');
        $query = $this->db->get();
If i used above query , i got a error message like as

Code:
A PHP Error was encountered
Severity: Notice

Message: Undefined property: CI_DB_sqlsrv_driver::$_random_keyword

Filename: database/DB_active_rec.php

Line Number: 916

Any suggestion please ?
#2

[eluser]davidk43[/eluser]
Very late reply as only just been looking at this myself.

Take a look here: http://ellislab.com/forums/viewreply/803049/

I added the suggested code into the top of the sqlsrv driver class and that error went away. I think those vars just needed declaring.

If any ninja coders are reading this. With sqlsrv now on version 2 and M$ committing a bit more to PHP it would be great for sqlsrv to be treated a bit more seriously. The guys writing up to version 1.1 of the driver have done a great job however to really harness MSSQL you need to get into stored procedures and xquery abilities that provides etc which is pretty impossible looking at the current active record class. I could however be very wrong as its beyond my skill but I'm now using the the current sqlsrv driver for basic queries with a native query running off the active connection for all stored procedure queries. A bit rubbish but gets the job done. Just about.




Theme © iAndrew 2016 - Forum software by © MyBB