search

catfan / Medoo

The lightweight PHP database framework to accelerate the development.
https://medoo.in
MIT License
4.84k stars 1.15k forks source link

get() return the first row of the result,error find in mssql and oracle #91

Closed inspurhua closed 3 years ago

inspurhua commented 10 years ago

we use "select top 1 xxxx from yyy" at mssql and sybase,but medoo default use limit 1; we use "select xxx from yyy where rownum=1",but medoo default use limit 1;

ghost commented 7 years ago

I confirm this error when using ONLY medoo msSQL settings using v1.4.5.

For now, i use directly the query() method since meddo doesnt parse the correct query when used with MsSQL.

njxqlus commented 6 years ago

Same in Oracle. LIMIT 1 was added to simple select sql: 

get('USER_TABLE', ['USER_SETTINGS'], [
    'USER_LOGIN' => $userID,
]);
magnetic5355 commented 6 years ago

still an error v1.6