Re: FLASH: CONNECTION Flash templets without USING Generator!!!

[John_Cho/IconixGroup%ICONIXGROUP]

I have this code and i was wondering where to put this in my flash piece. 


Do i place it in an "Get a url" or where else???? 


As how do i label my field name so that the ASP news where to pull from 

the SQL and place the right content?


I have some commented areas that I will be trying different way. Any help 

would be helpful!

<%


Set conntemp=Server.CreateObject("ADODB.Connection")


'Application("dbConn_ConnectionString") = "DSN=xxdevel;User 

Id=iconixx_developer;PASSWORD=password;Description=xxdevel;SERVER=DEVELOPMENT_NTS;UID=iconixx_developer;APP=Microsoft 

Development Environment;WSID=TGREENBERG_NTS"

'dbConn.Open Application("dbConn_ConnectionString")

strDSN="iconixx=" & server.mappath("iconixx") & "'DriverID=25;FIL=SQL 

Server;MaxBufferSize=512;PageTimeOut=15;"

conntemp.Open "driver={SQL Server};" & strDSN


Set flash=Server.CreateObject("ADODB.Recordset")


'Set rsBC.ActiveConnection = dbConn


strSQL="SELECT * FROM tblFlash"

flash.open strSQL, conntemp, adOpendynamic,adLockOptimistic

Q1=flash.fields("Q1")

Q2=flash.fields("Q2")

Q3=flash.fields("Q3")

Q4=flash.fields("Q4")

Q1A1=flash.fields("Q1A1")

Q1A2=flash.fields("Q1A2")

Q1A3=flash.fields("Q1A3")

Q1A4=flash.fields("Q1A4")


flash.Close

%>


---<>---<>---<>---<>---<>---<>---<>---<>---<>---<>---<>---<>---<>---<>---<>

John Cho




flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  Streaming Media WEST '99 Conference & Exhibition

  "The Worlds largest Internet Audio & Video Event"

 December 7 - 9, San Jose Convention Center, California


Reserve your space today at http://www.streamingmedia.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

  To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com