Hi all,

I created a table like this

create table t_table (
   id INTEGER PRIMARY KEY NOT NULL AUTO_INCREMENT ,
   name TEXT NOT NULL,
   description TEXT
    );

the table contains some records but the description fields defaults to null
for all the records allready entered

In asp (iis5) I loop till EOF

    adodataconnection ...
    ...
    Set recordset = adodataconnection.Execute ("select * from t_table")
    recordset.MoveFirst
    Do Until recordset.EOF
        ...
        recordset.MoveNext
    Loop

    recordset.MoveFirst                ' <- sequence error

    recordset.Close

I get a sequence error when I try to go back to the first record

however if i enter ONE record with a description .. it works

Is there anyone out there that can point out the logic behind this ?

Thanks in advance

Dirk Vermeer



---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to