RE: FLASH: getting a SQL response into flash

[Damian Morton]

> From: Vipin Kanwar

> Sent: Sunday, February 27, 2000 4:56 PM

> Subject: FLASH: getting a SQL response into flash

>

> I'm at it again. Here's another of those database, asp question.

>

> Can someone tell me how to get the results of a SQL query (from an asp

> file) into a flash movie?


The following code will execute an SQL statement and return a set of results

in the correct format for your flash application.


Assuming the SQL table 'myTable' has the columns 'name', 'address', 'age',

you will get the following variables loaded into your movieclip


name1=fred

address1=myaddress

age1=20

name2=john

address2=hisaddress

age2=35

numrecords=2


NOTE: you will also need to escape the strings written using response.write;

this means changing all spaces to '%20' and such. Theres a function to do it

in JScrpt, but not in VBscript. Shouldnt be too hard to write your own - i

just dont happen to have one handy. ALternatively, you could make this a

Jscript page.


----------------------------- sql.asp ---------------------------------

<%

response.expires = -1

response.contenttype = "application/x-www-urlformencoded"


set rs = con.execute "select * from myTable where name like 'smith%'"


i = 0

while not rs.eof

	i = i + 1

	for f in rs.fields

		response.write f.name & i & "=" & f.value & "&"

	next

	rs.movenext

wend


response.write "numrecords="&i

%>



flasher is generously supported by...

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

     flashforward2000 and The Flash Film Festival

  "The World’s Premier Flash Solutions Conference and Expo"

 March 27-29, Nob Hill Masonic Center, San Francisco, California


-Register before Feb 25 and save $200!!-- www.flashforward2000.com

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

To unsubscribe or change your list settings go to

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

helpchinwag [dot] com