Multiple parameters in Query from ASP?

  • Thread starter Thread starter George Hester
  • Start date Start date
G

George Hester

I have the Query in the database it works. I get two windows that come up; the first asking for the first paramater the second asking for the second. The "SQL" looks like this (ADODB OLEDB Provider Jet 4.0 Access 2000 format)

INSERT INTO tblLoadOLE ( OLEPath, OLEFile )
VALUES ([@newOLEPath], [@newOLEFile]);

Now the second field cannot be just typed in. It is an OLE Field and to put something in there I actually have to run Form and enter three things. What they are exactly I don't belive matters here but it saves binary data to the database. Which is what I want to do.

But running this in the ASP:

DataConn.Execute "exec usp_UpdateImage ???" I am not sure what to enter tfor the paramaters. There are two. I tried this:

DataConn.Execute "exec usp_UpdateImage [C:\Inetpub\wwwroot\uploaddemo\files, ]" No. Tried this:

DataConn.Execute "exec usp_UpdateImage ([C:\Inetpub\wwwroot\uploaddemo\files],[ ])" No. Syntax error. Any ideas how to send two paramaters? I was following this article:

http://www.stardeveloper.com/articles/display.html?article=2001050101&page=2

Thanks.
 
Answer:

DataConn.Execute "exec usp_UpdateImage 'C:\Inetpub\wwwroot\uploaddemo\files',''"

--
George Hester
__________________________________
I have the Query in the database it works. I get two windows that come up; the first asking for the first paramater the second asking for the second. The "SQL" looks like this (ADODB OLEDB Provider Jet 4.0 Access 2000 format)

INSERT INTO tblLoadOLE ( OLEPath, OLEFile )
VALUES ([@newOLEPath], [@newOLEFile]);

Now the second field cannot be just typed in. It is an OLE Field and to put something in there I actually have to run Form and enter three things. What they are exactly I don't belive matters here but it saves binary data to the database. Which is what I want to do.

But running this in the ASP:

DataConn.Execute "exec usp_UpdateImage ???" I am not sure what to enter tfor the paramaters. There are two. I tried this:

DataConn.Execute "exec usp_UpdateImage [C:\Inetpub\wwwroot\uploaddemo\files, ]" No. Tried this:

DataConn.Execute "exec usp_UpdateImage ([C:\Inetpub\wwwroot\uploaddemo\files],[ ])" No. Syntax error. Any ideas how to send two paramaters? I was following this article:

http://www.stardeveloper.com/articles/display.html?article=2001050101&page=2

Thanks.
 
Back
Top