Re: FLASH: What am i doing wrong? (asp and flash) #2

[Helen Triolo]

Chris,


I didn't mean my comment to reflect on your answer (but actually

response.write is what you'd use to send the variable back from asp to

Flash and I thought FlashCasey was trying to get things sent the other

way).  It referred to a post I had just sent (which still hasn't shown

up on the list here) that was in error.  And for Flash Casey, in

addition to that change to the sql string, it also had this suggestion

for the Flash part:


Change to either

    Set Variable: "Zone" = "R"

    Load Variables ("../ResidentialListings.asp", 0, vars=POST)

 

or


    Set Variable: "Zone" = "R"

    Get URL ("../ResidentialListings.asp", window="main", vars=POST)


depending on whether you want to return control to the Flash movie (1st

option), where you can check for a value returned from the asp, or pass

control to the asp file (2nd option).  (I usually use the 2nd option

first to test that things are working and then switch to the 1st, but it

sounds from your description like option 2 is what you want).


Regards and sorry for the confusion,

Helen

---------------------------------------------------

Helen Triolo � http://i-Technica.com � 301-424-6037

Flash Q&A archive � http://i-technica.com/flashlist


Chris Tifer wrote:

> 

> Might be better if we take this off list.  My e-mail is

>

webmasteremailajoke [dot] com

> 

> But, how did the result turn out with the Response.Write strSQL?

> Did you get what you expected?

> 

> Chris Tifer

> 

> -----Original Message-----

>

From: ownerchinwag [dot] com [ownerchinwag [dot] com]On">mailto:ownerchinwag [dot] com]On Behalf Of Helen

> Triolo

> Sent: Thursday, August 03, 2000 7:30 PM

>

To: flasherchinwag [dot] com

> Subject: Re: FLASH: What am i doing wrong? (asp and flash) #2

> 

> Blah, no, sorry -- sent that off too fast.  Try this sql instead:

> 

>    strSQL = "SELECT DevelopmentName, LandID, CityID,

>  DevelopmentWebsite, DevelopmentPrice,

>  DevelopmentBedrooms, DevelopmentBathrooms,

>  DevelopmentSqFeet FROM Developments WHERE ZoneID ='" &

>  Request.Form("Zone") & "'"

> 

> Because Zone is text, it has to have quotes around it.  Those chr(34)

> things I included in the last post are useful if you need to include

> double quotes in the query, but your situation wasn't one of them.  Hope

> this post gets through to the list shortly after the other, so I don't

> send you off on a useless tangent...

>


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

 Full flasher archive now available online at:

 http://www.chinwag.com/flasher/archive.shtml

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

To unsubscribe or change your list settings go to

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

helpchinwag [dot] com