Binary Output Retrieved From Db
I'm attempting to read data written to a MySQL database and view it in the browser. I've searched the net for over 3 days and I've seen many posts that say it works great, but it's not working for me. The only thing that displays properly is a text file. Everything else is garbled. I desire to store & read PDF files though. Here's my code:
<%@ Language = VBSCRIPT %>
<% Option Explicit %>
<!-- #include file="dbConn.asp" -->
<!--#include file="adovbs.inc"--> ...
View Replies
ADVERTISEMENT
For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics.
The benefit of the program is that it stores all kind of information in a central Microsoft Database that easily can be manipulated. A thumbnail of the picture is also stored in de MDB as long binary (jpeg format)
I made a small script that extracts all kind of information of the MDB by use of queries and ASP. This works perfect for string/numerical information.
I am wondering if I can also write the stored (jpg)thumbnail to the asp file so that I have a preview of my picture.
Can this be done? What is the syntax?
I tried already :
Response.BinaryWrite BinData
Where BinData is the contents of the Thumbnail field. When I take a look at the MDB table in design view, the DataType of this field is "OLE object", if I open the table, the contents of the field displays "long binary data".
View Replies
View Related
For a while I am working with ThumbsPlus ( http://www.cerious.com/ ) as manager for pics.
The benefit of the program is that it stores all kind of information in a central Microsoft Database that easily can be manipulated. A thumbnail of the picture is also stored in de MDB as long binary (jpeg format)
I made a small script that extracts all kind of information of the MDB by use of queries and ASP. This works perfect for string/numerical information.
I am wondering if I can also write the stored (jpg)thumbnail to the asp file so that I have a preview of my picture.
Can this be done? What is the syntax?
I tried already:
Response.BinaryWrite BinData
Where BinData is the contents of the Thumbnail field. When I take a look at the MDB table in design view, the DataType of this field is "OLE object", if I open the table, the contents of the field displays "long binary data".....
View Replies
View Related
In retrieve among other data an emailaddress from an SQL table and put it in a tabel (see code below)
How can I make the email address an active mailtolink
greetz
edwin
<ItemTemplate>
<table border="0" width="100%">
<tr>
<td valign="top" width="115px">
<%# DataBinder.Eval(Container.DataItem, "User_name") %></td>
<td valign="top" width="180px">
<%# DataBinder.Eval(Container.DataItem, "User_Email") %></td>
View Replies
View Related
I added a column to my Access database and defined it as hyperlink.
I added some URL in the fields and i was able to see the underline under each address.
In my code i added the following line :
Response.Write("<td align=right>" & oRS("info").Value & "</td></tr>")
(The hyperlinks defined in my database as info).
I'm able to see the hyperlink when i retrieve all other data but it appears as
#http://www...asp# and with no underline what is the reason and how can i change this ?
View Replies
View Related
does anyone knows how i can layout items retrieved from db such as example from this online shop site . most items retrieeved from db such as Accesss are always in vertical layout.
View Replies
View Related
I haven't started to mess with this yet, but is it possible to store
.ASP source script in a Database field, then use ADO to get the string
from the field and then force the scripting host to interpret that
string from the database and flush it into the buffer for output to
the browser? I was thinking you'd have to use EVAL() on the string or
something...Anyone done this yet?
I was working with Vignette story Server a couple of years ago, and
all of the TCL source script and html is stored completely in the
database, only cached pages are in virtual directories.
View Replies
View Related
The link for the photos are requested from the server and so the photo
appears on screen. I can produce a long list by using the response.write ***
& "<br>" or whatever. but is it possible to have it start on the next line
after say 5 photos in a line. i.e. where each - is a photo
- - - - -
- - - - -
- - - - -
rather then
- - - - - - - - - - - - - -
or
-
-
-
-
etc.
View Replies
View Related
Im doing a password retrieval page that is working fine, but it wont appear in the html page i want it to.
1)When i dont try and put it on any page the text appears no problemo on a white background.
2)When i attempt to put it on my designed page all that appears is my designed HTML page with none of this text. Code:
View Replies
View Related
I have a feedback form which asks someone to enter their personal details and then submits them to db. There are input, checkboxes and selection boxes on form.
Now I want to allow user to edit this form. When user clicks 'edit', I retrieve all the values from db and populate the text boxes.
What happens with the options and checkboxes. How can I get these to reflect what their values in db? Also I have some drop downs allowing user to select date of birth ie. day drop down, month drop down and year drop down. How do I show user the details we have for them if I'm using drop downs?
View Replies
View Related
I'm having problems retrieving certain images from my web server, such as, Dozier SrB9057.
The problem I'm having is w/, Jr., Sr., II, and III get the drift. How can I get rid of the space in between the last name and Sr?
Now, the Sr is included in the field along with last name.
Here's my code:
strSQL = "Select * from vw_licenseholder_PrimAddr where L_ID = 5940"
Set rs1 = objConn.Execute(strSQL)
ImagePath = "w:" ....
View Replies
View Related
Am storing images on a database and users query the database to retrieve the images. I want to add a zoom in and zoom out button that will enlarge and reduce the images depending on which button the user clicks.
View Replies
View Related
While trying to retrieve a large number of records, I would like to show a progress bar to indicate that the user are to wait. How can I do so?
View Replies
View Related
The user basically queries the database for some data, and I initially retrieve just part of the data matching the query...
I display the Primary Key as a hyperlink..and when the user clicks on a particular retrieved data..i want to display all the contents about that element alone on another new page...
The problem i am facing is that i do not know the syntax to use the onClick event within an ASP code:
View Replies
View Related
I managed to retrieve a table from a database and displays records on the browser using the ASP code below.
but I also want some of the retrieved record be clickable and editable so if a user decides to upadate a record it can be clicked and updated. there are two options either redirect to another page and the selected records will be displayed again to be edited or edit them on the same page,I m not sure how to make the selected records editable using the code below. Code:
View Replies
View Related
I have this dynamic array(shown below) that I need to match to values (1 - 10) that I am returning from the database via DSN connection object.
The values I need to match are on the same page (in their own table) but I am not sure how to match up the array indexes to these values. I want to be able to display the array result as part of or nested in another table. Code:
View Replies
View Related
Here is a written descripton of my webpage.
One frame split down the middle. The left side is the menu and the right
displays what is selected from the menu.
the user selects from the menu and on the right, clicks on "download image"
link. the user is presented with a download dialog box. The user saves the
image and when it is completed goes and selects another item from the menu.
But this time nothing happens.
It is like i have to refresh the page before anything works again. It is
like it is stuck on the ASP binary stream file that forced the download.
on my link i have
<a href="donwload.asp" target="right">download image</a>
How can i fix this?
View Replies
View Related
I have many office files saved in sql server. The system sends them by one
web page: RequestFile.asp. So every file has the same name requestFile.asp.
How can i change requested URL on the server from
www.domain.com/requestFile.asp to www.domain.com/someFileName.doc????
I am able to rise "Save or open downloaded file" dialog
View Replies
View Related
I am having trouble trying to output an image using Binary.Write. I have a page which displays a record. One of the fields is an image and I want to display this on the page.
My question is this: Is it possible to use the Binary write command i.e. Binary.Write("MyDatabaseField") on the same page that I want the image displayed on?
If not Is there a way to nest it inside an image tag as follows:
Response.Write("<img src=" & binaryWrite("mydatabasefield" & ">")
View Replies
View Related
I'm working on a client project where i'm importing some data from a programme to a sql database.One of my fields contains a value which is created by bit flags Within this value are 10 bit flags, and i need to find out the value of each flag. An example of one of the bit flags is 0x0001
I'm guessing that it is to do with Binary and I need to apply a bit masks, but that's where my expertise ends.
View Replies
View Related
I am using XMLhttp and responsebody to receive info from a webpage
I dont use responsetext since i need the international chars едц
The information I recieve is binary is there any fast way to convert the
binary data to text ?
I used this function but its slow compared to response.binarywrite
and i need the information in a string so I can alter it with my script.
So is there any way to convert Binary to Text just as fast as
response.binarywrite ?
Function BinaryToString(Binary)
Dim I, S
For I = 1 To LenB(Binary)
S = S & Chr(AscB(MidB(Binary, I, 1
Next
BinaryToString =
View Replies
View Related
Does anyone know of a "pure ASP" upload script that does not use the binary read? I am sure many people are looking for this as well..as you cannot use the binary and request.form in the same script. I am trying to integrate a file upload into an already built script using request.form.
View Replies
View Related
What I would like to do is load a file's contents from a file on the server
and put the contents.
into a record in a database. For this I need to load the contents in binary
format into a
variable. Anywhere I looked, I've only found text I/O in ASP.
(FileSystemObject and TextStream).
How can I load any kinds of file into a byte array? Or is it enough to load
it as a text stream
and then treat the loaded string as a byte array?
View Replies
View Related
I'm having problems with a simple binary write. The page is just supposed to write a JPEG back to the browser but the image does not display (the "X" image shows).
Any help is appreciated. Here's the full code:
<%@LANGUAGE="VBSCRIPT"%>
<%
Response.Expires = 0
Response.Buffer = TRUE
Response.Clear
Response.ContentType = "image/jpeg"
set fso = Server.CreateObject("Scripting.FileSystemObject")
set fl = fso.GetFile("c:afterWF.jpg")
Response.BinaryWrite fl
%>
View Replies
View Related
How can I insert a binary file into a SQL Server db using asp? It must be possible cause SQL Server has a datatype called "varbinary".
View Replies
View Related
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.
View Replies
View Related
I am working on an app that needs to stream binary files(such as PDF or WORD docs) to the browser. I cannot just pass a URL pointing to the file directly. I've tried the following in an ASP file:
Code:
Response.ContentType = "application/doc"
Response.BinaryWrite strData
where strData contains the binary data content of the WORD file in a string variable (for PDF, I would set the content type to "application/pdf").
However, the browser displays the data itself, rather than hosting the doc in the appropriate browser applet.
View Replies
View Related
i have searched and can't seem to find how to do this
here it will ask the user to enter in a sequence of binary numbers that are separated by a period. For an IP there are 4 sets of 8 numbers that are separated by a period; 32 numbers, 3 periods. Once the user entered 0 and 1 i have to somehow convert that to octal and display the result on a new page with the octal answer.
View Replies
View Related
I have an exe file on a server that reads an XML file ( as a parameter) and generates a new file for downloading. However, most servers won't allow an exe file to create the new binary file. Is there any way that I can execute the exe file and have it download straight to the client instead of saving to the server?
View Replies
View Related
I need to perform a task where I read PDF file on the server and send it to the client without using Redirect.
The problem is that As far as I have read ASP and VBscript does not have a support for reading binary files so I need to use external dll developed in VB but the hosting company does not Let me register the dll. I there any other way to send pdf file to the client???
View Replies
View Related
When I run an asp script, I can view the contents on the screen in pdf format. But instead of displaying the information to the screen, I want to be able to save the same information into a binary file with a pdf extension.
Does anybody know how to do that?
I have listed the coded that writes it to the screen, but now want to be able to write the information into a file ....
View Replies
View Related
I use AspUpload to save files in a MSSQL database, orks just fine.Now I need to copy this binary from one table to another. DataType is image.
I found the answer:in MSSQL ntext, text and image datatypes of large values have to be handled by Transact-SQL fuctions handling data block by block.(the field itself has only a pointer to the data).
View Replies
View Related
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.
View Replies
View Related
