problem in the login (mssql)

[eluser]Tim Brownlaw[/eluser]
Well that's given it no room for confusion by giving it the complete table path ( if it's called that! )


What else have you tried?

Does something like

Code:

$query = $this->db->get('[user]')

do anything userful (useful) ?

What I was trying to suggest before was to create a standard PHP connection and query on your mssql and see if that worked and why... With the idea being trying to see whats different when done via CI... Standard "divide and conquer" investigating ( debugging )

But as you've got this far... it's time to try out a few other things ( like above ) and see what happens.

Cheers
Tim

[eluser]huangxiao[/eluser]
Hi Tim,

$query = $this->db->get('[user]')

still working

but why we should put this

[ ]

inorder to work.

[eluser]Tim Brownlaw[/eluser]
Ok, how do you know that it works?

What does $query hold?
use var_dump($query); after it and check it's not false

What happens when you use $query = $this->db->get(’user’);



Cheers
Tim

[eluser]huangxiao[/eluser]
It would not work if i don't put this symbol [ ]


Thank you in advance

[eluser]Tim Brownlaw[/eluser]
Well it appears, from my reading, that is what mssql uses.

So "they" use [ ] instead of ' '
I'm not sure of all the other little niggling issues that using anything 'mssql' entails, but If that works - use it!

Cheers
Tim