Re: FLASH: database to Flash

[Carlos Cardoso]

Respondendo (replying)  "Cheri Harder" <

chericahome [dot] com

> 

> 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.


Try printing the SQL variable in both cases and look at the differences.

You will discover the '"' (I don't know the symbol's name in english) is

missing. 


Try it:


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

"'" & ";"


[]'s

Carlos Cardoso -

cardosopobox [dot] com

em breve: Redes - Curso Basico e Rapido 

e FLASH4 - Para Principiantes

==================================

www.carloscardoso.com          

Tech Writer, BOFH & Trekker

Linux Reg user # 92301 




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