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 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:
View Replies View RelatedCan't find anything in MSDN that explains this ASP error; I'm trying to post data into sql dbase, and this error points to the SQL execute line. Code:
View Replies View RelatedI'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.
How is it possible to upload binary data (like images or MIDI files) to the server? the code to (if necessary) a password protected FTP account?
View Replies View RelatedI 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?
View Replies View RelatedI write the code as follows. But I cannot print the binary data as meaningful data format. any idea?
Response.Buffer = True
Const adTypeBinary = 1
Set objStream = Server.CreateObject("ADODB.Stream")
objStream.Type = adTypeBinary
response.binarywrite rs("abc")
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.
DXUpload.Form.1 Error '80020009'
Failed to read binary data.
/backoffice/album/album_save.asp, Line 29
___
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...
any advice to sort it out?
I Would like to know the code for reading/writng binary data.
View Replies View RelatedI 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 have images stored in database how can display them in asp?
View Replies View RelatedI have images stored in database how can display them in asp?
View Replies View RelatedI'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.
How can I display the first 20 characters of a long string?How can I insert some character inside of the string on every 5th character?
View Replies View RelatedI have a form that collects the date and time of an event.
I create a string to hold all of the data in the correct format for MySQL and it (the string) looks like this...
2007-03-03 17:30:00
I am then using CDate to convert the string to a DateTime type.
and since I am in the US it gets converted like this...
3/3/2007 5:30:00 PM
per my regional system settings...
I grabbed this code from the forums here which I have used before...
Function ISODate( dt )
If Not IsDate( dt ) Then
ISODate = "NULL"
Else
dt = CDate( dt ) ' safety
ISODate = "'" & Year(dt) & "-" & Month(t) & "-" & Day(dt) & "'"
End If
End Function
ISODate = "'" & Year(dt) & "-" & Right("0" & Month(t),2) & "-" & Right("0" & Day(dt),2) & "'"
My question is How do I modify it to add the time to the ISODate function and then include it in my insert statement correctly?
I have an asp page with a form, which has a lot of fields 30 to 40 .Is there an easier way to loop through all the fields submitted to the insert page or is the only way to do it using the standard, request.form for each field and then INSERT INTO Reports (ReportID, ReceivedDa very lengthy for this amount of fields. Perhaps there is a way of looping through some sort of collection ?
View Replies View RelatedI have a form that collects the date and time of an event. I create a string to hold all of the data in the correct format for MySQL and it (the string) looks like this...
2007-03-03 17:30:00
I am then using CDate to convert the string to a DateTime type.
and since I am in the US it gets converted like this...
3/3/2007 5:30:00 PM
per my regional system settings...
I grabbed this code from the forums here which I have used before... Code:
I am having terrible time in converting a string to a datetime field in my asp page. I am keep on getting error on the following stateement. What would be the correct syntax on converting string to datetime for inserting into a sql table?? I did write the add_str out on the browser, everything looks correct...
Error message:
[Microsoft][ODBC SQL Server Driver][SQL Server]Syntax error converting datetime from character string. Code:
I have the belwo code which i mean to do an multiple checkbox insert. I have managed to get it so i puts all the checkbox values into a string seperated by a comma, and it insert into a database, however just not how i need it to.
Curently inserst like :-
When users fill out my text area field, there is a chance that there
will be no line feeds or cariage returns or spaces and just one really
long word.
THIS CAUSES A MAJOR PROBLEM! What I am trying to do is
force a vbCrLf if a string is long than 80 characters in a row. So if
a string is a total of 500 characters with no line feeds, spaces, or
returns, I want to force a vbCrLf every 80 characters so that is
doesn't overflow my preview text field on the next page.
Any suggestions on how the algorithm would be for this in VBscript
ASP?
I've been choosing to insert data ni my db using a recordset with methods AddNew and Update. I would like some advices to make my coding opractice better. For example: am I doing it right? Is there a better to do what I'm doing and so on...:
Code:
set rsExample = Server.CreateObject("ADODB.RecordSet")
rsExample.Open "example", MyConn, adOpenStatic, adLockOptimistic, adCmdTable
rsExample.AddNew
rsExample("id")=id
rsExample("firstName") = firstName
rsExample("lastName") = firstName
rsExample("subject") = subject
rsExample("message") = message
rsExample("new") = 1
rsExample("date") = now
I have a form form.asp to insert data into the table1 of the db.mdb file. In db.mdb file I have two tables one is table1 and other is table2 now the fields in both table are as
Table1
ID (AutoNumber)
Name (Text)
Roll No. (Number)
Class (Text)
Address (Text)
Result (Text)
Table2
ID (AutoNumber)
Roll No. (Text)
Result (Text)
Now I want that whenever that data is posted into table1 then table2 should autoupdate the corresponding data. how this is possible?
Is it possible to insert values in a Database with a
checkbox? Say I have a recordset and if the check box is checked I
want to insert the value of the of the field in the DB.
<%=rsqa.Fields.Item("recini").Value%>
That is a persons initials, i want to insert those initials in a column
if it is checked, if it isnt checked nothing is inserted..
I have created an empty table(.mdb) with 2 columns
Order(AutoNumber) and BuildingID(text)
and i use :
cn.execute "Insert into [Temp](BuildingID) values ("&Buildingid&") "
to insert buildingID into the table
however all buildingid start with 0 with be omitted,
eg. buildingid = "00003333" after insert into the table become "3333"
i have checked that response.write len(buildingid) = 8
What is the problems?
i have 2 web pages where in the first page, the user is allowed to make a series of selections from combo boxes (one of which is position eg programmer) and when the user clicks next(next1 button), a 2nd page appears with a table in it in the format below (the user is being rated on the different duties he performs in this page and the duties are retrieved dynamically based on the position the user selected in page 1):
userid duty score
user1 duty1 score1
user2 duty2 score2
user3 duty3 score3
etc
when the user has filled in the scores, he clicks next (next2 function) to save the data in a table in the db. i am able to retrive all data except the duty. can anybody help me out. Code:
How do i insert data into an Excel Sheet, Along with the provider to be used.
View Replies View Relatedi wanted to do a sign up page using vbsript for new pple to register as member, but therr is also error: too few parameters, expected 2. Code:
View Replies View RelatedI didn't know how to use asp to update or insert the excel data ....
View Replies View Related