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

[Chris Tifer]

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


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

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

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


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

 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

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

 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