Click to See Complete Forum and Search --> : Really elementary database query question.


solafide
12-03-2004, 10:39 AM
I know NO ASP, but I do know Javascript. I want to get a specific record field from a Access database. Is there a function that I could use for this? I really appreciate your help. Thanks!

Billy

lmf232s
12-03-2004, 06:42 PM
SELECT [Field] FROM [DatabaseName] WHERE [FIELD] = '[SOMEVALUE]'

if you need a connection string you can get it here.
look at the OLE DB Provider for Microsoft Jet
http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

and for SQL help this may help.
http://www.w3schools.com/sql/default.asp