I have stored a .gif and jpeg file in the database as the BLOB object.
Now I am trying to create a report which displays that gif file along with another information.
Is there a way I can display the BLOB objects on the page without having to use any crystal report tool or anything ?
Just wondering if any one can tell me why on my machine in Inetpub, when I
want to display data from a blob column, I get data that is like =
"4�D�6�5�7�3�7�3�6", using Response.BinaryWrite. My ado version is 2.8, does
it have some thing to do with missing some thing?
I figured out yesterday how to get a blob in, then found an easier way (basically put them all in access then import them into sql).
My problem is getting them out. I dont care if its ASP, PHP or what, but I dont know exactly how I would go about getting it.
I have 2 fields in the database, one is the blob data, and the other is just a name, so I'll be selecting on that, and then displaying its corresponding blob data (tif files).
How would I go about doing this? I've never done blobs, I've normally just done an echo $variable type of thing for string and integers and such.
I need some help with ADO types. I use an stored procedure to insert records in a table. One of columns needed is a Blob type (subtype Text). In adition I use ADODB.command configured as I show:
...
oProcedure.Parameters.Append oProcedure.CreateParameter("Description", adLongVarChar, adParamInput, 1234567, description)
...
But it doesn't work well. After call, the table shows something like binary data.
I'd tried to use other ADO types like adVarChar, adVarWChar, adLongVarBinary,... with same result or type errors.
I'm searching some code samples that using blob data type with asp.
View Replies View RelatedI am feeling it tough to retreive a image(blob) from oracle to asp.
I am getting an unspecified error while running the select query.
Could anyone please let me know how to retreive a blob from oracle 9i to ASP.
I have problem to insert a record contains a blob field . Everything fine except the blod field . Platform :VStudio 2003, database :Firebird.net 1.5
View Replies View Relatedanyone know of an application that integrates with Dreamweaver to allow me to work with blob images from a SQL database and put them in an ASP.NET page?
View Replies View RelatedIm trying to display a default image on my asp page that pulls data from a sql server database but i can't get the default image to display. I get error messages saying type mismatch everytime on line 25... Code:
View Replies View RelatedI have stored a Blob (jpg) in mySQL, I now want to retrieve it and paste it on a page, What do I do?
View Replies View RelatedHow would a guy go about inserting BLOB files into an Oracle database? My company wants me to put logos in a database, and then depending on the client logging in, display a certain image. My boss wants an interface to allow for us to upload them to the database, also.
I personally think just dropping them into a centralized directory and then storing the path, or the image name in a char or varchar field would make more sense, but. Can someone help me with this, or give me any ideas? I've floated the idea to him to buy a third-party component to facilitate the upload, but he's not really appreciative of that idea.
What about .NET? From what I understand, it has very good file upload capabilities. I already have the framework installed on our server, so I should be able to use it if needed. Would that be a better route to go?
I am currently working on a document management system for my company's Marketing department. They wish to be able to upload files to the server.
Rather than deal with the many permissions issues we have had in the past with saving and deleting these files to the server's file system, this time we are trying to use SQL server BLOB fields to store the files.
The premise is simple -- a user clicks on the link and the file is then shown in the browser. The documents are mostly word, Quark, and Adobe Illustrator documents. I was thinking the code would go something like this: Code:
I don't know how to upload word doc, images and other files into Oracle Blob fields with binary format.
I tried with the following code, normally it's inserting, suppose if i try to convery binary. 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.
I was working with filesystemobject in asp.
When i give filesysstemobject.copyfile the system will be gogin searching indefelty and IIS will get crash..
Why this pblm occurs..
I would like to know if someone has already exchange ASP objects by SOAP with the SOAP Toolkit 3.0 ? Is-it possible ?Because, I have to connect, with ASP, to a Web Service and send to him array of objects.
View Replies View RelatedI'm so glad i finally found a web development forum! It's been a while and it's not easy to find. Until someone recommended this site to me.
Enough about that... I really want to learn about COM objects and don't really know where to go to find out about such things.
If someone could direct me to the right place, i'd be extremely grateful.
I've already learned ASP and PHP (though i have to admit that i am not an expert and I don't think i'll ever be one), but i aim to be a "jack of all trades".
anyone have better information on IIS 5.0 memory behaviour on setting objects to nothing?
Connections and recordsets of course should be set to nothing, but should for example XMLNode object be set to nothing?
I have a object which I declare as a application object "gObj".
I need to use "gObj" with all sessions. I need "gObj" to have access based on the user's id. Is this possible without creating multiple gObj's?
Code would be something like:
Application_OnStart
set gobj = Server.Create( "someDll" )
gobj.uname = "somename"
gobj.port = 1234
gobj.pwd = "pwd"
I've created a simple pop-up form that
takes the required info and sends it via e-mail. Right now, I've got
the From E-mail, the To E-mail, the Subject, and the TextBody. It
works, and it's fine, but I'd like to spruce it up a little so I can
make it more personalized. Can I add other objects? I've been
searching for a general reference online that lists all my choices for
ObjCDO, but can't find anything, and any ideas of my own ("FirstName",
"Comments", etc.) have been shot down as not being supported.
I build a ATL object that is used in an ASP page.
Can I insert events inside this ATL object?
ATL is builded in C++
I have a website with a large collection of pages. Many of these dynamic pages use multiple objects created via the Server.CreateObject method. There are filesystem objects, recordsets, browsertype objects, you name it. I need a script that will loop through all of the objects and Set them = Nothing to destroy them.
I imagine the script would be somewhat like this.
For Each obj In ServerObjects
If IsObject(obj) Then
Set obj = Nothing
End If
Next
I created a label, a textbox and a button when i build the webform and try to see it with the explorer it only show the label
The other 2 objects (textbox and Button) at the Visual Basic.Net editor at the properties are visible and in the code i have
<asp:TextBox id="TextBox1" runat="server" Width="122px"></asp:TextBox>
What can I do that
I've read that you shouldn't store objects in Session variables.
I've read these reasons:
- The object takes up memory that may not be freed until the session times
out. Better to create the object only when you actually use it.
- Causes poor performance because the thread that created the object has to
service all requests for it.
Assuming I can live with the memory and performance implications (a big if,
but let's assume it for a minute), what other reasons are there?
1) can any one tell me what are built in objects in ASP 3.
in asp 2 it was
request
response
session
application
server
object context object
2)what are asp variables ?
I have a problem with including an object in my asp page. I�ve translated an algoritm I found that was written in javascript and it needs a method, floor(), from System.Math to work.
in javascript you can just write Math.floor(x+1) but it seems asp doesn�t automatically include that Math object. It�s a little weird since the method Round() can be used withour any includes of any kind and thats a part of the Math object!
So... How do I do to access this floor() method?
I tried to write:
<%Imports System.Math %>
but it doesn�t seem to do the trick.
Can i get any asp sample codes to retreive photo's from access database
For instances:To get codes on your pages Response.write......
similiar for images.
Set obj = Server.CreateObject("")
can the above statement be used to create any objects other than a recordset?
I have scripts on a server that awhile back had new option/server packs installed (to accomodate security and net framework issues) and my classic asp date references
"Date()" and "Now" will sometimes flip flop the formatting of the date from 10/3/2003 to 3/10/2003 (european mode).
What would be a good way to use an include file to perhaps an asp.net date object, or where would I find a good reference to using an aspx file to calculate and display the date properly so that I can avoid this flip flop snafu of the date formatting.
ISessionObject is created each time When any ASP Page is started executing and destroys on the page ends (not session end) while the session state (data) is originated already somewhere from where ISessionObject fetches.
When user Request another page the ISessionObject is again constructed and the data from original location is loaded from there.Same with IApplication type object & IScriptingContext object.
I've a client-server application written in Access. Some of the codings make use of OLE so that the Access application creates a Word document on the fly and fit in relevant values.I'm examining if using ASP pages can do similar function (to create and manipulate OLE objects)?Anybody knows if ASP can do?
View Replies View RelatedI want to have a little box on my asp login panel. I want to be able to display the following
Number of databases
Number of tables
Number of users (logins)
Time/Date of last update
Last user logged in
How can I go about doing this? What code do I need?
I'm creating a small program in Dreamweaver. The first screen is a login screen that contains a form, which asks for the users Email address and a password. The form is called 'login' which contains 2 fields, email: (called 'login') and password: (called 'password').
Anyway, to cut a long story short, I've managed to do all the authorisation stuff. A back-end database which contains a table called 'users' has all authorised emails and passwords. So when a user logs in, the login criteria is checked against the email/password in the Microsoft SQL database table, if it matches, they are redirected to the user account page.
At the top of the user account page I want it to say "Welcome! <Insert user email address here>" I know it may have something to do with session objects which are passed on but I have no idea how to program it.