PDA

View Full Version : [ASP] Updating records in flash


nutype
08-11-2004, 08:46 AM
Hello everyone, I'm in dire need of help.

I currently have a form in flash that needs to be updated. I can pull data from my ASP page (through a filemaker DB) into flash and even run a search against it. However, I'm having trouble creating the update functionality. If somebody could point me in the right direction or get me started, you will have my eternal gratitude!

Please help!

Roger Chinchill
08-11-2004, 10:51 PM
Post all the files that you are using. Lets take a look at it.

nutype
08-11-2004, 11:46 PM
This is my ASP page that updates the recs


<%
Dim registration, oConn, sqlString, ID, JobTitle

ID = request.QueryString("ID")
JobTitle = request.QueryString("JobTitle")



sqlString = "UPDATE Registration SET jobTitle = '" & JobTitle & "' WHERE ID = '" & ID & "'"

Set registration = Server.CreateObject("ADODB.Recordset")
Set oConn = Server.CreateObject("ADODB.Connection")

oConn.ConnectionString = "AllAsText=0;ApplicationUsingThreads=1;Driver=FileM aker Pro;FetchChunkSize=100;FileOpenCache=0;IntlSort=0; MaxTextlength=255;ServerAddress=127.0.0.1;Translat ionOption=0;UseRemoteConnection=1" & Server.MapPath("registration.fp5")
oConn.Open
registration.Open sqlString, oConn, 2, 3


registration.Close
Set registration = Nothing

oConn.Close
Set oConn = Nothing
%>