Fel i join — webForum

LR^evil.sidMedlem sedan maj 2002560 inlägg

4 feb. 2004 00:02#1

Varför fungerar inte denna fråga?

	Dim SQL: SQL = SQL & "select "
	         SQL = SQL & "n.id, r.id, g.id, l.id "
		 SQL = SQL & "from "
		 SQL = SQL & "news n, releases r, guestbook g, live l "
		 SQL = SQL & "where "
		 SQL = SQL & "n.id => "&ArrCookie(0)&" and "
		 SQL = SQL & "r.id => "&ArrCookie(1)&" and "
		 SQL = SQL & "g.id => "&ArrCookie(2)&" and "
		 SQL = SQL & "l.id => "&ArrCookie(3)
'		 SQL = SQL & "limit 0,0 "

[MySQL][ODBC 3.51 Driver][mysqld-4.0.14-nt]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '=> 0 and r.id => 0 and g.id => 0 and l.id => 0' at line 1

LR^evil.sidMedlem sedan maj 2002560 inlägg

4 feb. 2004 00:14#2

Dim SQL: SQL = SQL & "select "
         SQL = SQL & "n.id, r.id, g.id, l.id "
	 SQL = SQL & "from "
	 SQL = SQL & "news n, releases r, guestbook g, live l "
	 SQL = SQL & "where "
	 SQL = SQL & "n.id > "&ArrCookie(0)&" and "
	 SQL = SQL & "r.id > "&ArrCookie(1)&" and "
	 SQL = SQL & "g.id > "&ArrCookie(2)&" and "
	 SQL = SQL & "l.id > "&ArrCookie(3)

Fungerar fint... jag som inte tänkter riktig genom vad jag skulle göra.