|
|
Posted by Steve on 01/31/08 05:41
"Ivan Marsh" <annoyed@you.now> wrote in message
news:pan.2008.01.30.22.27.46.903923@you.now...
> On Wed, 30 Jan 2008 14:10:02 -0600, Steve wrote:
>
>
>> "Ivan Marsh" <annoyed@you.now> wrote in message
>> news:pan.2008.01.30.17.44.49.792094@you.now...
>>> On Wed, 30 Jan 2008 11:34:57 -0600, Steve wrote:
>>>
>>>
>>>> "NC" <nc@iname.com> wrote in message
>>>> news:093fa743-0beb-4582-b9e2-8baaf8531f0b@s37g2000prg.googlegroups.com...
>>>>> On Jan 28, 1:37 pm, Martin <martinval...@comcast.net> wrote:
>>>>>>
>>>>>> I'm trying to adapt a PHP script that was written to use MySQL, so
>>>>>> that it will work with an MSAccess MDB file.
>>>>>
>>>>> Good luck...
>>>>>
>>>>>> An important part of the script makes use of the SQL "LIMIT" keyword
>>>>>> available in MySQL. eg: "SELECT MyField FROM MyTable LIMIT 40,10" to
>>>>>> select 10 records beginning at the 41st record.
>>>>>>
>>>>>> Can anyone tell me how I can achieve this same functionality when
>>>>>> using ODBC functions to access an MDB file?
>>>>>
>>>>> You can't. Access does not support LIMIT clauses.
>>>>
>>>> BULLSHIT !!!
>>>>
>>>> *acheive ... functionality*...the two key words. i've given an
>>>> explanation of at least one way...which falsifies your claim, btw.
>>>
>>> No... you have not.
>>
>> christ almighty!!!
>>
>> <quote>
>> the easiest way is to select into a temp table where one of the columns
>> is an auto-number...the query then becomes WHERE blah BETWEEN x AND n
>> </quote>
>>
>> do you need the message id too?
>>
>> but while i'm at it:
>>
>> ===========
>>
>> create table companies
>> (
>> company NUMBER ,
>> name TEXT ,
>> region NUMBER
>> )
>>
>> SELECT *
>> FROM
>> (
>> SELECT (
>> SELECT COUNT(*)
>> FROM companies AS r
>> WHERE r.Company < co.Company
>> ) AS RowNum ,
>> co.Company AS Company ,
>> co.Name AS Name ,
>> co.Region AS Region
>> FROM companies AS co
>> )
>> WHERE RowNum BETWEEN 50 AND 100 ORDER BY RowNum
>
> ...and have you verified that any of this works with PHP/ODBC hitting a
> MDB file?
uhmmm, that's the funny thing about odbc...it DOESN'T have a thing to do
with queries! it is a communacative pass-thru between a caller and a db
resource. but yes, i tested it. works just fine.
>> fuck you very much.
>
> I'm sorry you have a tiny dick but if you can't be civil you can kiss my
> ass you two year old pansy.
hey, if you didn't make stupid suggestions...check that...insane suggestions
and then demonstrate that you can't read, maybe my response would be less
frank. you notice that in my second response to you, i backed off quite a
bit (almost civil in tone :) when i thought i'd just mis-understood you.
nope, you just kept forging ahead.
and, who uses the word 'pansy' anymore? sad though, that this two year old
pansy has to set your saged knoggin right.
Navigation:
[Reply to this message]
|