field order for adding to tables

Just wondering if the order of the fields in a query matters when querying a table with asp. that is, if the table has columns labeled "RecordID, FirstName, Initial, LastName, etc" in that order, do i have to do my "INSERT INTO" command with the fields in that same order, or could i do "FirstName, RecordID, LastName, Initial, etc" ? i think it doesnt matter. am i right?
(boy, can you tell i'm a n00b at this or what? lol)

I do not think that this matters as long as you specify the field names, but the easiest way to tell is to try it out and see what the outcome is.

Far as I know it does not matter. But something to keep in mind when returning fields the order that they are in the querey is the order they are in the field objects. But this only matters if your accessing the records by index number.

thx onslaught
for some odd reason i don't yet have access to read the database i'll be posting to, so trying to find out is not as easy as asking someone (hopefully) knowledgeable online :-)
(btw, you don't play planetside as onslaughtXIV by any chance, do you?)

Nope, afraid not.
But for the most part, you should be able to list the fields in any order as you desire, just as long as you r field list match your input fields that you are sending.

also thx ninja. not accessing by record number this time, but i'll keep that in mind