# ASP + Access = Dynamic Text

**URL:** <https://forum.kirupa.com/t/asp-access-dynamic-text/199447>\
**Category:** flash\
**Created:** [September 2, 2006, 4:24pm UTC](https://forum.kirupa.com/t/asp-access-dynamic-text/199447 "2006-09-02T16:24:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![JamesHolden](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/jamesholden/32/2780_2.png) [@JamesHolden](https://forum.kirupa.com/u/JamesHolden)\
**Post date:** [September 2, 2006, 4:24pm UTC](https://forum.kirupa.com/t/asp-access-dynamic-text/199447/1 "2006-09-02T16:24:53Z")

</div>

Im a noob in Flash and i really want your help in order to complete my final project…I try to make Flash integrate with ASP. I have read many tutorials and i managed so far to make Flash show the dynamic text. The problem is that i cant move to the next record in my database…I know that something is missing in my code but i dont know what…

ASP:

\<%@LANGUAGE=“VBSCRIPT” CODEPAGE=“1252”%\>  
\<!–#include file="…/Connections/dataConn.asp" --\>  
\<%

Dim rsCaseStudies

Set rsCaseStudies = Server.CreateObject(“ADODB.Recordset”)  
rsCaseStudies.ActiveConnection = MM\_dataConn\_STRING  
rsCaseStudies.Source = “SELECT \* FROM case\_studies”  
rsCaseStudies.CursorType = 1  
rsCaseStudies.CursorLocation = 2  
rsCaseStudies.LockType = 1  
rsCaseStudies.Open()

rsCaseStudies.Move CLng(Request(“Record”))

Response.write “company\_Name=”& Server.URLEncode(rsCaseStudies(“company\_Name”)) & “&”  
Response.write “sector=”& Server.URLEncode(rsCaseStudies(“sector”)) & “&”  
Response.write “description=”& Server.URLEncode(rsCaseStudies(“description”)) & “&”  
Response.write “url=”& Server.URLEncode(rsCaseStudies(“url”)) & “&”  
Response.write “solution=”& Server.URLEncode(rsCaseStudies(“solution”)) & “&”  
Response.write “technology=”& Server.URLEncode(rsCaseStudies(“technology”)) & “&”  
Response.write “TotalRecords=” & rsCaseStudies.RecordCount

rsCaseStudies.Close()  
Set rsCaseStudies = Nothing  
%\>

* * *

AS for the mc with the textfields:

onClipEvent(load)  
{  
CurrentRecord = 0;  
loadVariables (“caseStudies.asp?Record=0”, this);  
}  
onClipEvent(data)  
{  
caseName = company\_Name;  
caseDescr = description;  
caseTech = technology;  
caseSol = solution;  
caseUrl = url;  
caseSect = sector;  
}

* * *

AS for the “next” button:

on (release){

```
CurrentRecord++
if (CurrentRecord == TotalRecords)
  CurrentRecord = 0;

loadVariables("courses.asp?Record="(CurrentRecord), this);

```

}

* * *

Im not quite sure about the code in the next button…  
Any suggestions would be really helpful!