# \[asp\] Updating records in flash

**URL:** <https://forum.kirupa.com/t/asp-updating-records-in-flash/60638>\
**Category:** programming\
**Created:** [August 11, 2004, 7:48am UTC](https://forum.kirupa.com/t/asp-updating-records-in-flash/60638 "2004-08-11T07:48:17Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![nutype](https://avatars.discourse-cdn.com/v4/letter/n/91b2a8/32.png) [@nutype](https://forum.kirupa.com/u/nutype)\
**Post date:** [August 11, 2004, 7:48am UTC](https://forum.kirupa.com/t/asp-updating-records-in-flash/60638/1 "2004-08-11T07:48:17Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 20, 2004, 8:32am UTC](https://forum.kirupa.com/t/asp-updating-records-in-flash/60638/2 "2004-08-20T08:32:46Z")

</div>

what do you need ?

how to write update code in asp

or how to call the update.asp correctly ?

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 20, 2004, 8:35am UTC](https://forum.kirupa.com/t/asp-updating-records-in-flash/60638/3 "2004-08-20T08:35:18Z")

</div>

Amitgeorge,  
I was able to figure it out. Didn’t realize it was much easier than I thought. Anyway this is what I came up with:

```auto

<% 
Dim registration, oConn, lname, sqlString  

ID = request.QueryString("ID")
'lname = Lcase(lname)
'sqlString = "SELECT * FROM Registration where NameLast = '" & lname & "'"
sqlString = "SELECT * FROM Registration where ID = '" & ID & "'"
'sqlString = Lcase(sqlString)

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

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

'registration.AddNew
'registration("nameFirst") = request.Form("NameFirst")
'registration("nameLast") = request.Form("NameLast")
registration("jobTitle") = request.QueryString("jobTitle")
registration("company") = request.QueryString("company")
registration("addressOne") = request.QueryString("addressOne")
registration("city") = request.QueryString("city")
registration("state") = request.QueryString("state")
registration("zip") = request.QueryString("zip")
'registration("JobTitle") = request.Form("JobTitle")
registration.Update

if registration.EOF Then
Response.Write "&success=false"
Else
Response.Write "&success=true"
End If

registration.Close 
Set registration = Nothing 

oConn.Close 
Set oConn = Nothing 
%>

```

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [August 21, 2004, 6:09am UTC](https://forum.kirupa.com/t/asp-updating-records-in-flash/60638/4 "2004-08-21T06:09:29Z")

</div>

good for you