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

[Chris Tifer]

Response.Write strSQL 


and see that it did indeed pass the ZoneID in correctly.

That error you're getting happens sometimes when the 

query is not constructed correctly.


Chris

http://www.emailajoke.com (all ASP)


-----Original Message-----

From:

ownerchinwag [dot] com

 [

ownerchinwag [dot] com]On">mailto:ownerchinwag [dot] com]On

 Behalf Of Flash

Casey

Sent: Thursday, August 03, 2000 3:41 PM

To:

flasherchinwag [dot] com

Subject: FLASH: What am i doing wrong? (asp and flash)



I have an access database and am trying to display

data from a few tables using asp. 


When the user clicks on a button in my flash movie it

calls the asp page to open.


I want to pass one variable to the asp page and use

that in my SQL WHERE statement.


Im not sure if i have an asp coding error or flash

error so ill show both pieces of code.


here is the flash button code

*************************************

On (Release)

      Load Variables ("../ResidentialListings.asp",

"", vars=POST)

      Set Variable: "Zone" = "R"

      Get URL ("../ResidentialListings.asp",

window="main", vars=POST)

End On

***************************************

here is the SQL statement.

***************************************

	strSQL = "SELECT DevelopmentName, LandID, CityID,

DevelopmentWebsite, DevelopmentPrice,

DevelopmentBedrooms, DevelopmentBathrooms,

DevelopmentSqFeet FROM Developments WHERE ZoneID =" &

Request.Form("Zone") & ";"

****************************************


Here is the error

***************************************

Microsoft OLE DB Provider for ODBC Drivers error

'80040e10' 


[Microsoft][ODBC Microsoft Access Driver] Too few

parameters. Expected 1. 


/pages/canada/ResidentialListings.asp, line 28 

****************************************


This is driving me nuts so any help would be

appreciated.




__________________________________________________

Do You Yahoo!?

Kick off your party with Yahoo! Invites.

http://invites.yahoo.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

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

 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