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

[Helen Triolo]

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