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:
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".
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".....
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
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 ?
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.
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.
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.
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?
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.
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:
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:
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:
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.
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:
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.
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.
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).
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.
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:
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.
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.
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?
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???
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 ....
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).
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.