i have an access database which has one table called marks and the table contains 5 fields
ID : auto number
stu_id: number
course_number: number
course_title: text
grades: number

now i want the student to enter his student id number and be able to see his grades for all courses taken during the semester.

so this ASP script does not seem to work, what am i doing wrong?
what changes needed?

Dim stu_id
stu_id=request.form("student_id")

Dim oConn, sConnString,sql
Set oConn = Server.CreateObject("ADODB.Connection")
sConnString = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("dbname.mdb") & ";"
oConn.Open(sConnString)
sql = "SELECT * FROM table_name WHERE id=" & stu_id &""

Dim results
set results=oConn.Execute(sql)

'
'statements for processing or displaying results
'
oConn.Close

Am I wrong in thinking you need to terminate sql queries in Access with a semi-colon?

IE.

sql = "SELECT * FROM table_name WHERE id=" & stu_id &";"

thanks
but that did not solve the problem

sql = "SELECT * FROM table_name WHERE stu_id=" & stu_id &";"

it did not solve the problem

anyone has a sugestion for me?

Uh. Do you have any idea whatsoever what you're doing?

table_name should be (surprise) your table name, which you've said is marks. You'll also want to use stu_id rather than id as xelav suggested.

In the future, if you're going to report a problem, try and give a bit more information than 'it did not solve the problem'. Define exactly what 'its not working' means, and pass on any error messages or output that you get.

You'd be greatly benefited by reading just about any SQL tutorial on the Net. The syntax can vary slightly from implementation to implementation, but there are a lot of references out there.

An example just like your question would be on about page 2 or 3.

could you please post a link to a good tutorial you use

thanks

please help me

i just need a link to a good tutorial

someone please help me

I think its: www.sqlfreaks.com

If not google "SQL Freaks".. Lots of info on that site for you..

thanks but i'm getting site not found
and when searching google i do not get any related links

http://mysqlfreaks.com/ << there you go.. I thought it was sqlfreaks but its mysqlfreaks

thanks for the link

actually i'm looking for a tutorial about asp and access database not mysql

Dim stu_id
stu_id = cInt(request.form("student_id"))

if stu_id > 0 then
sql = "SELECT * FROM marks WHERE id=" & stu_id
end if

Your basic error was having a " at the end of your SQL statement. you don't need anything after the statement if it ends in a variable like that.

Chip-

If that actually generates a fatal error, VB is even more crappy than I previously thought...

it may be a problem from the editor

well, VB translates "" to " in a SQL query, so his statement would look like this to the DB:

SELECT * FROM marks WHERE id=10"