SQL and recordsets

[Guest meashy]

Hello every one,I have a table with Code, company, website, discription fieldsI am trying to creat a search that matches the Code field and displays the rest of the fields in a table I am using dreamweaver, I am wondering if i should create a query in access first for the Code criteria, or i can just do it with SQL???thanks alot

[justsomeguy]

If the data (i.e. the code field) is dynamic, you will want to build a SQL query and send it to the database. The recordset will be processed differently depending on which language you are using to connect to the database.