Re: FLASH: database to Flash

[Cheri Harder]

Very specific question now.  I'm on the home stretch.


SQL = "SELECT * FROM tblStaff WHERE strID=" & "8" & ";"

gives me the correct response from the Excel data source with Flash in

IE5.5. (The input field is hard-coded as the number 8)


SQL = "SELECT * FROM tblStaff WHERE strID=" & Request.Form("Input") & ";"

(the variable "Input" is provided by the Flash file) gives me nothing in

Flash using IE 5.5.  It works using an HTML form for the Input.  It also

works PERFECTLY with Netscape with Flash.


Entire ASP code follows:

<%

  'Open the connection in the usual manner

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

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

  Connection.Open "people"


  'Select data from tblStaff where strID is the same as the number in the

Input field


 SQL = "SELECT * FROM tblStaff WHERE strID=" & Request.Form("Input") & ";"

 'SQL = "SELECT * FROM tblStaff WHERE strID=" & "8" & ";"

  Recordset.Open SQL,Connection,1,2


  'If no such number is found then send back 'Not Found'

 If Recordset.EOF Then

  KnownAs = "Not"

  Surname = "Found"


  'Otherwise the variables KnownAs & Surname are the returned first name and

surname!

 Else

  KnownAs = Recordset ("strKnownAs")

  Surname = Recordset ("strSurname")

 End If

 Recordset.Close

 Connection.Close


  'Send this back as part of a URL which Flash can interpret

 response.write("KnownAs="+Server.URLEncode(KnownAs))

 response.write("&Surname="+Server.URLEncode(Surname))

 %>


Flash button code:


On (Release)

      Load Variables ("testasp.asp", "", vars=POST)

      Set Variable: "Input" = ""

End On


Any ideas of where to look for problem with IE?  I have IE5.5 beta...on PC.

~~~~Cheri Harder~~~~~

charderawsolution [dot] com

Advantage Web Solution

"Developing your internet storefront"

www.awsolution.com





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