July 5th, 2004, 06:20 PM
|
|
Registered User
|
|
Join Date: Jun 2004
Posts: 19
Time spent in forums: 13 m 48 sec
Reputation Power: 0
|
|
|
FLASH creating form help....
Hi... I'm making a simple flash to asp page... where I want to submit data to a DB from Flash.
I created both but when I click the submit button... the data that I'm entering into the text field
doesn't get stored in the DB. But the autonumber is being incremented everytime. Can any one help me with
this please?
Here is the action script and the asp code.
ACTION SCRIPT
Code:
on(press){
getURL("http://localhost/test/collegeForm.asp","post");
}
ASP CODE
Code:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
strColleges = Request.Form("colleges")
'Response.Write(strMajor) & "<br>"
'Response.Write(strColleges) & "<br>"
MyPath=Server.MapPath("uginfo.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath
SQL = "INSERT INTO collegeInfo (colleges) VALUES('"&strColleges&"')"
'Response.Write(SQL)
conn.Execute(SQL)
%>
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
