[pjm]

Hello.

I'm relatively new to ASP (VBscript) and I need the following help:

My goal is to retrieve the data from a cell column (access database) that is on the same row as other data cell which I know. How to do this?

Thanks for any help!

[angst]

sql = "select * from TableName where SomeData=SomeOtherData"

[Shane]

This should work...

Replace "column_name" with the column name you want to get information from. Replace "table_name" with your table name. Replace "another_column" with the name of the column that has the known value.

This code works well if you only want to get one record/result. If you want bring back multiple records, you will have to create a loop.

Code:

Dim sql, value
' Define a connection object
Set conn = Server.CreateObject("ADODB.Connection")
' open the connection
conn.open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("database.mdb") & ";" 

sql = "select column_name from table_name where another_column='something'"



Set RS = conn.Execute(sql)

If NOT RS.EOF Then
value = RS("column_name")
Else
value = "Record not found"
End If

RS.Close
Set RS = Nothing
conn.Close
Set conn = nothing

Response.Write(value)

[pjm]

Thanks Shane and angst for your answers.

Shane, thanks for writing the code in a very understanding way. It was exactly what I needed and it works perfectly. Thanks again.