I am new to web design and also to database. I have created a database using MS ACCESS. I only have one table. I am using dreamweaver mx and coldfusion. I am having a problem trying to get the right recordset query to pull the information from the database. For my search page I have dropdown lists for Gender and State. The recordset query is for my results page. The colums are both from the same table.I know the first part of the sql which is :
SELECT "state", gender, age, username
FROM chat (table name)
Where
I can't figure out how to get two columns from one table and not even sure if it can be done. Thanks ahead
Rich

Hi,

SELECT column1, column2
FROM tableName
WHERE condition

What code are you using? I'm assuming it's ASP VBScript? Let me know.

Cheers,

Janusz

======================
www.xlibris.co.uk
janusz.monkey-it.co.uk

ASP | VBScript | IIS 5.1 | Windows XP Pro | Linux Redhat 9 | SuSE 9 Pro | Linux FreeBSD 4.9 | PHP 5.0.0 Beta 2 | MySQL 4.0 | Apache 2.0.48 | Macromedia Studio w/t Flash 2004 | Microsoft Office Pro 2003 | Mozilla Firebird 0.7 | IE 6 | B.O.R.E.D @ HoMe

janusz_monkey im using dreamweaver mx to write html with cfml embeded. Coldfusion is the application server i am using. My problem is getting the WHERE correct.
WHERE gender ='male' OR 'female ' AND state(cant get the rest).
If your in the USA we have 52 states.I dont even know if the first part is right.