I have an asp page that uploads binary files. I am trying to pass the binary data to a function in a dll (written in c++) to process it. The file I'm testing with is the range of bytes from 0x00 to 0x51. When the data is passed to the function, it is passing it as the string "A^? ".
which is what is printed out when I do a Response.Write. How can I pass the binary data to the function? A Response.BinaryWrite prints out the correct contents of the file. Why won't it pass it as binary?
I'm using ADODB.Stream to open a binary file on the server and write it down to the browser using Response.BinaryWrite. It's working fine, but i need to make some changes to the binary data before it is send to the browser.
I'm trying to use REPLACE, but it's not finding a string that i know it's in the binary file. Using InstrB i've found that the search inside the binary data is being done in a Unicode format, but i don't know how to make an ascii search&replace operation on binary data.
Does anyone know a website with a guide on how to upload binary data to a MySQL database using ASP?I have a script that i spent a lot of hours on getting to work,but after i upgraded my MySQL server it doesn't work anymore
I'm just getting an error from the odbc driver(upgraded from 2.5X odbc driver to 3.51X):
Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC Driver Manager] Invalid string or buffer length
I'm trying to do the upload via AspSmartUpload,with a script that opens the record and uses .AddNew to the recordset.
I am storing PDFs as Binary data in MS SQL but do not know how to open the PDF files in ASP. Seperately, how do I capture the filename when I do a multipart/form-data?
I am having the following error when submitting dynamic data to an SQL Server database:
String or binary data would be truncated. This is of course happening when longer datafields are being inserted. I've tried changing the data types in the database itself, but that does not solve the problem. Do I need to change the data type of the field before it is submitted to the database?
i have the following update statment that this error is coming from i dont realy understand why it is thorwing the error up becuase when i was testing it i change the letter 'c' to and 'a' so not sure why it would need truncated. what does this error actual mean or what do i look for Code:
I have one EXE file that customer need to download from my website. But I have one text file of Max 250 bytes of text in in that I want to append to the END of the Binary EXE file and give that for download to user. How can I do that. Please suggest. I think we need to go for some BinaryWrite kind of procedure using ADO Stream.
If lJt = "GENERAL" OR lJt = "GOODS_DETAIL" Then 29: Set objUpload = Server.CreateObject("DXUpload.Form") lAction = objUpload( "ACTION" ) Else lAction = request( "ACTION" ) End If
___
here's my code... I can't see why this error occured...
I'm using conn as ADODB.Connection object. when I write:
conn.execute "insert into table (binarydata) values ('" & binarydatastringvariable & "')" it returns the error:
Unclosed quotation mark before the character string '(here is some string given)'. How can I insert binary data to a ms sql server 2000 table without using adodb.recordset?
I'm trying to submit an image object, along with some other text fields to another web server from within an ASP page but am stuck on getting the image to be submitted with the form.
In a bit more detail:
1. When this particular page is executed, I want the server to pull an image from a db (stored as a BLOB) along with a few other text fields. This part is easy and I have no problems with it.
2. I want to submit the image, along with the text fields to a second webserver which typically accepts its input from a form (ie, the second webserver usually has a webpage where a user enters some information into form and browse for a file. When clicking submit, the form fields along with the file are submitted to the second server).
The reason for this is that I'm trying to migrate from one web based photo album to another which uses a data structure that is complicated and difficult to interface with, so I'm using the web based image upload functionality of the new album. Code:
I'm trying to setup an ASP page to POST an image across to another page- essentially simulating what a browser does when you use <input type=file> in a HTML form.
I'm able to correctly setup the headers etc and do the POST, but I'm unable to include the binary data of the image.
The only way i've been able to do it is if I base64 encode the image. I'm using MSXML2.ServerXMLHTTP to do the POST, and I can't seem to do the .send with a form body that includes the binary data of the image. Code:
Has anyone else found a memory leak using ADO streams to access binary data held in a database. I have searched through this forum and have not come across anyone else, so maybe it is just me.
The scenario is as follows: Windows 2000 SP3 MDAC 2.7 SP1 IIS5 MySQL 3.23 MyODBC 2.50
If I query the database and do a response.binarywrite everything works fine and no memory leak. eg. response.binarywrite myrecordset("blobfield")
If I read the very same BLOB field into a ADOstream I then get a memory leak in DLLHOST.EXE of how big that binary field was. ie If the picture is 140k in size DLLHOST.EXE increases its memory size by 140k.
This keeps on happening until DLLHOST.EXE is something like 250 MBytes in size at which point it stops working. Quick restart of the IIS Web service and I get all my memory back.
The command I am using to get the data into the ADOstream is picturestream.write myrecordset("blobfield")
I have also tried putting the binary data into a variable first before inserting it into the stream: set x=myrecordset("blobfield") picturestream.write x
The stream is closed and set to nothing at the end of processing. Everything is cleanly shut down. Through testing I know the memory leak occurs once the data has been written into the stream. The stream is correctly created as type binary.
The stream problem I am encountering does not seem to be limited to ASP, I tried it using Visual Basic to create a COM component to do the same job and still got a memory leak.
So the questions are: 1. Has anyone come across this before or fixed it? 2. Is there another way of getting binary data out of MySQL, something like the opposite of LoadFile?
I have wasted so much time on this problem but cannot find, having searched Microsoft's knowledge base and the rest of the web, any reference to the problem.
Here is my code: ... dim fname fname = rsAddwg2("file_name") response.write("<td align=center onclick=""tst(fname);"">" & revno & "</td>") ....
I'm trying to pass te variable fname to function tst, but I keep getting this error message "Error: 'fname' is undefined. I have a feeling that there is something wrong with my syntax but I can't figure it out.
how to pass an asp session variable to a local variable withing a javascript function. Something like this:
var zip = <%=Session("clzip")%>
but it's the quotes around "clzip" that is throwing a syntax error I think. I've tried single quotes and no quaotes. Can't get it to work. Anyone have any ideas?
I am passing a variable called businessID from one page to the next page in my URL. On the next page I want to use the value of businessID to query my access database in a SELECT statement. How do I put this in my SELECT statement?
"SELECT * from tlbbusiness where businessID = (im not sure) "
I need to pass data though a URL ill explain my situation. I have made oen page using JavaScript and ASP (have to use these for my project) which basically allows the user to search a database to find a link to a car which most suits them. This is shown by this-
This sends the user to a separate page showing the full details of the car on the specific page.
On this new page i need to read from the URL what the value of carnumber is and then write the full details fo the car to the page. there is a different carnumber for each car in the database. Code:
We are attempting to do an on-line registration system using asp and MySQL. Unfortunately, it doesn't appear that the information from the input form is passing to the execute form. In fact, it doesn't look as though it is even getting to the database.
I am very new to asp and the person I'm working with is used to working with MS SQL, so this could be a syntax issue......
I have written some stored procedures in SQL and these procedures return some value. I want these values to be captured by the ASP code. I am able to access the tables using ADO( recordsets ) but is there a way to pass data returned from stored procedures to vairables in ASP code.
I have a asp page created which pulls information from an access database. One of the things it pulls from the database is the address. I want to put a link on this page which when clicked will open a smaller new window asking the user to input their address. Once they input the address and hit submit, the 2 addresses, user inputted (as starting point) and the one from database (ending point) needs to be inputted such that a url is formed, leading to the directions page on yahoo or mapquest or any other site.
My question is how do I take the ending address and pass it over to this new page (using http_referrer???) and then construct the url to the directions page.
