RECORSETS

[alexfusion]

Hello Everyone!!!
This is a simpple question for you the experts! but not for me.
I am working with databases but I have a concept that is no clear enough for me:
What is exactly a Recorset?
Is it a pointer to the fields of the table I am workng with,or it is a subset of the fields of the entire table.
I am reading about attributes such as optimistic,pesimistic,etc,you know.
I am sure that you can make this concept very clear to me.
Thank you so much!!!!!!!!

Alejandro

mixale@hotmail.com

 

[GunJack]

Hey Alejandro,

A recordset is an object often used in VB programming or in ASP scripting. I suppose it's named that way because it contains sets or records from a database. If you performed a query such as "select * from table1" and assigned the results to a recordset object, the recordset object would contain every row from table1. You could then loop through the recordset object and view each record at a time. If you're looking for an analogy, a recordset object would be most like a table. It contains data consisting of rows with a specific number of fields. You create a recordset object, perform a query, and then assign the results of the query to the recordset object (not technicaly accurate). If your query returns some of the rows from a table, you could think of it as a subset of the original table.

In CF though (since you posted to the CF forum), you don't have to worry about recordsets as they aren't part of the language. If you do a <cfquery>, you could think of it as creating a recordset behind the scenes that you view with a <cfoutput> tag.

Hope this helps,
GJ

 

[strantheman]

Have you ever used SQL before Alejandro? GunJack is refering to is a result of filtering out only the fields you want. SQL allows you to get, cold fusion will help you format the output.

Im not sure what a pesimistic recordset is, stop studying and code something. let us know if you have a problem