|
|
Posted by Ivan Marsh on 01/31/08 17:02
On Wed, 30 Jan 2008 23:41:29 -0600, Steve wrote:
> "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.
That's all I ask for. Your first two examples didn't work so it wouldn't
be too smart to blindly trust a third. It's funny that something you
professed to be so easy took you three attempts.
>>> 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.
Why don't you try just not being an arrogant asshole in the first place?
> and, who uses the word 'pansy' anymore? sad though, that this two year
> old pansy has to set your saged knoggin right.
What's sad is that you think you have to be a dick to get your point
across. Rater than offering useful suggestions you go straight to being an
arrogant, insulting piece of crap and then it still takes you three tries
to get the code right... sort of proves my point that you don't have the
same functionality as you would with an SQL server doesn't it?
--
I told you this was going to happen.
Navigation:
[Reply to this message]
|