ASPSmartUpload Form Problem

[telmessos]

Hi all,

I am trying to ASPSmartUpload component to get info + upload files to the server. My form sends the location and sublocation information and the following code gets it. If I make the form send info only it works fine but when I add ENCTYPE="multipart/form-data" to the form the line with "ors2=DbObj.Execute(SQL2)" gives EOF or BOF error.

Could you please help? Thanks

Ceyhun



Dim Mevkii
Dim loc
Mevkii=Request.Form("SubLocation")
loc=Request.Form("location")

SET DbObj=Server.CreateObject("ADODB.CONNECTION")
DSNName="Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=test;Uid=root;Pwd=testpass;"
DbObj.Open DSNName
SQL2="Select *from sublocations where Location='"&loc&"' and SubLocation='"&Mevkii&"'"
ors2=DbObj.Execute(SQL2)

[Master Shake]

You will need to create your upload object and use it to get your form data.

Go here for info:
http://www.aspsmart.com/aspSmartUpload/liblocal/docs/Requirements.htm


Master Shake