webForumDet fria alternativet

Skicka meddelanden med Flash & ASP (ASP relaterat!!!)

ASP

0 svar · 138 visningar · startad av MickeA.com

Medlem sedan feb. 20034 441 inlägg
Frågan#1

Hej.

Har en liten Community, Flash & ASP

Nu har jag fixat en grejj, för att medlemmar skall kunna skicka SMÅ, korta mess till varann.

Men det funakr inte-...

För att skicka:


Response.Expires = -1000

anv = Request.Querystring("anv")

Dim pm_fran
Dim pm_till
Dim pm

pm_fran = Request.Form("pm_fran")
pm_till = Request.Form("pm_till")
pm = Request.Form("pm")
pm_datum = now()
pm_last = "0"

Dim oConn
Dim oRec
Dim strSQL

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../../hemsida_db/db_forum.mdb"))

strSQL = "SELECT Anv_Namn FROM anv_data WHERE Anv_Namn = '" & anv & "'"

Set oRec = oConn.Execute(strSQL)

If oRec.EOF Then
	Response.Write("&finns=inte")
Else
	strSQL= "INSERT INTO pm_data (Pm, Pm_Till, Pm_Fran, Pm_Datum, Pm_Last) VALUES ('" & Replace(Replace(pm, "'", "''"), "&", "och") & "', '" & Replace(Replace(pm_till, "'", "''"), "&", "och") & "', '" & Replace(Replace(pm_fran, "'", "''"), "&", "och") & "', '" & Replace(datum, "'", "''") & "', '" & Replace(pm_last, "'", "''") & "');"

	Set oRec = oConn.Execute(strSQL)
	Response.Write("&finns=ja")
End If

Set oConn = NOTHING
Set oRec = NOTHING
Set strSQL = NOTHING

Response.Write("&loaded=true")

Och för att ta emot:


Response.Expires = -1000

anv = Request.Querystring("anv")

Dim pm_fran
Dim pm_till
Dim pm

Dim oConn
Dim oRec
Dim strSQL

Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("../../hemsida_db/db_forum.mdb"))

strSQL= "SELECT * FROM pm_data WHERE Pm_Last = 0 AND Pm_Till = '" & anv & "'"
Set oRec = oConn.Execute(strSQL)

If Not oRec.EOF Then
	pm_fran = oRec("Pm_Fran")
	pm_till = oRec("Pm_Till")
	pm = oRec("Pm")
	pm_datum = oRec("Pm_Datum")
		Response.Write("&datum=" & pm_datum)
		Response.Write("&pm_fran=<b>" & pm_fran & "</b> säger:")
		Response.Write("&pm_svar_fran=" & pm_fran)
		Response.Write("&pm=" & pm)
		Response.Write("&stat=skickat")
			strSQL = "UPDATE pm_data SET Pm_Last = 1 WHERE Pm_Last = 0 AND Pm_Till = '" & anv & "'"
			Set oRec = oConn.Execute(strSQL)

Else
	Response.Write("Inget Nytt PM")
End If			

strSQL = ""
Set oConn = NOTHING
Set oRec = NOTHING
Set strSQL = NOTHING

Response.Write("&loaded=true")

In Flash I got a Frameloop, which check:

if (stat == "skickat" && loaded == "true") {
	gotoAndStop(_currentframe+2);
}

MEN...

Det funakr inte alls. Man kan skicka till db'n, har kollat, men kolla-delen funkar inte...

Hjälp !

262 ms totalt · 4 externa anrop · v20260731065814-full.6fe65c25
121 ms — deklarationer (db)
0 ms — hämta statistik (cache)
136 ms — hämta tråd, inlägg och bilagor (db)
123 ms — ändringar (db)