lite problem med en sql-fråga

[red]	session ( "usr" ) = "tor"

	driver = ("driver={microsoft access driver (*.mdb)}; dbq=" & server.mappath("\test\db.mdb"))

	set con = server.createobject("adodb.connection")
	con.open driver

	set r = con.execute ( " select id_memb from memb where usr = '"&session ( "usr" )&"' " )

	[/red]sql = " select * from link, memb, text where "
	sql = sql & "memb.usr = '"&session ( "usr" )&"' "
	sql = sql & "and link.linkId = "&r ( "id_memb" )&" "
	sql = sql & "and text.textId = "&r ( "id_memb" )&" "[red]

[blue]line 17[/blue]	set rs = con.execute ( sql )[/red]

felmeddelande:

[red]Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause.
/test/dataTable.asp, line 17
[/red]

vad är det som är fel?

Text är ett reserverat ord (datatyp). Byt ut det tabellnamnet.

Fulfix är att klamra i SQL-frågan:

	sql = " select * from link, memb, [text] where "
	sql = sql & "memb.usr = '"&session ( "usr" )&"' "
	sql = sql & "and link.linkId = "&r ( "id_memb" )&" "
	sql = sql & "and [text].textId = "&r ( "id_memb" )

Mvh,

ok. thnx!

.additional

finns det något sammlat document om vilka ord som är reserverade?

http://www.aspfaq.com/show.asp?id=2080

Mvh,

njut! thnx