Here's my question/problem:
What is the best route to go to store images and 'news articles' in a database?
Is it best to give each an ID(autonumber) and then another field set in a table in access equal to the url for the said file
For example..: www.domain.com/?file=1234
In my access table I would have file 1234 equal to suchandsuch.inc or html or whatever
We have created an ActiveX dll file in VisualBasic .This file is for extracting the the embedded OLE objects through the Access databvase stored as Loing binary formats.The files include .doc files,.tiff files ,.xls etc.We need a sample code call this activex dll files and the also call the functions ,Procedures in the dll file in the asp Can someone please provide me with the code for the activex dll file.
View Replies View RelatedI want to include some asp if statements inside a do until loop, predicated on the recordset going until EOF. I do not have any < % %> delimiters inside the include file. The below doesnt show the character I want to display:
<% do until rs.eof
response.write rs("position")
<!-- #include file="inc_.asp" -->
loop %>
while hard coding the character with another response.write statement will.
I have a standard Header.asp that I want to include in every other page in
my site. Header.asp is located in the root folder, but the calling pages are
in various folders/levels. Since the relative paths specified in header are
subject to change and are based on the relative path of the calling page,
problems arise. (Strangley, using the IFRAME method of including a header
doesn't react the same way.)
The solution I believe lies in using absolute paths in the Header.asp file
using the "virtual" include qualifier. But this assumes your development
directory structure is the same as your production environment. So I guess
that is the answer. Use absolute paths and set up your development directory
structure to be identical to your production.
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
I have the following line of code that is part of a form that displays a record from a database;
<textarea name="name" cols="60" rows="20" value="<% =rscms_example("body") %>" </textarea>
Could you please tell me where I am going wrong on it? I know its probably very simple, but I am terrible at forms anyway.
how to download files from database to a certain path. using asp and sql server 7
View Replies View RelatedI am doing a flash map with different categories-shops, services etc.
I want when people click on shops to view all the shops icons(buttons) in the map. They have to be pulled from a database using ASP. How do you save and pull swf files in Access database?
Does anyone know the ASP code for taking a PDF file and a Microsoft Excel spreadsheet and inserting them into an Oracle database?
View Replies View RelatedI am developing a forum style website using ASP and I need to have a file attachment function when people post notices. Does anyone know how to do this? So far has only helped with showing me how to upload files to a server but I need to upload them into the access database to retrieve it when needed. Is this possible?
View Replies View Relatedi am working with asp form where the user can upload files to a folder or to the database, uploading files in folder in working, but the database one is not working it give me the following error:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
/test/uploadexmple.asp, line 48
and here is my code:
I have intermediate experience with asp, and sql. I am stumped on how to properly do a project, and hoping that one of you can point me in the right direction instead of playing the trial/error game for 2 weeks!!
Basically, I have a program that exports information into a html file for viewing of results. The file contains event information, user information, and results of each individual user along with statistics of the event. I want to take this generated file, and import it directly into a sql database (point and click upload of sorts to be user friendly) for further data mining. Code:
I want to upload a file then add a record in a database using info from the uploaded file. I can't figure this out. If anyone has something working that isn't this please let me know. I would rather have this working as I don't want to recode the whole thing.
First the upload doesn't work. The MBRequest(file1).Save isn't supported in this manner. I know you can use .save to upload a file.
Second You'll see that MBRequest is called to form a filename. The filename is called in another page to form a link to the file......
I have just uploaded the files to a where they will reside and am now getting the following error
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file '
syd9004papc$InetpubwwwrootGMS_Statsgms_st ats.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I have checked IIS on the server where this DB resides and have allowed as much rights as I can ... Has anyone seen this error before? I realise it must have something to do with security but I don't know if it's IIS or DB related?
I'm having some problems writing files to my Access database using ASP. I have a table with a couple of fields, one being of OLE datatype, that holds the file. I'm able to write and read small images, but I'm getting corrupted files when I try Word files, and my code is erroring out when I try to writing pdf files.
I think I've found the problem with the uploading of the pdf file (I think I need to adjust some IIS setting to allow larger file uploads), but I don't know what's going on with the word documents. They are small, so upload fine. Does anyone have any experience writing files to Access?
I have attached the file upoading system in this thread.
It is working fine with MS Access Database but when i change the database to MS Sql Server then its upload not works i think its security problem, or the problem is that when i import the MS Access table into MS SQL server it change the field datatype from oleobject to image.
is it possible to download binary files from database(sql).. ?
View Replies View RelatedI write search files webpage.when users enter part or all of a file name and asp page send back a list of only the files(that user can click to open files) whose names contain the text they entered.I want to save data about accessing files such as file name ,accessed date of fileto my database(Microsoft Access).I don't know how to write a adding code to do this. Code:
View Replies View RelatedI 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:
Can a php file be executed inside an asp file? I need to execute a php file in another asp file but i'm not so sure it's possible.
My server can run both asp and php and they run without any problems... I just need to find a way to include the execution results of the php file in the asp one.
Is it possible to use SSI and include the executed php file and then the executed asp file in a main ssi file?
I have installed PWS in windows 98 in each of the system at various places and put my Sales program files in the WWWROOT directory in all the branches. I'm afraid that the users may tamper my ASP files. Is there any way of converting .ASP files to .exe files so that the dont see my program.
View Replies View RelatedI have got a vb exe. I want to call that vb exe from an asp page. I have saved it in the server but I dont know how to execute that from the asp page.
View Replies View RelatedI am running a project in which i use a web application writen in ASP to create some quizes, then i would like to call a compilor (dll) to compile the data i created and change it to .mms file in order to be able to send it to mobile device.
Can you please guide me on how to call the dll file from my ASP application?
I have created an Active Server Component (ASC) as a bridge between ASP and my existing C++ DLLs that we use in our PC-based program. Our intent is to re-use as much code as possible.
when I call the ASC from ASP, and then call the DLL, the security profile that is specified in IIS is no longer associated with the process, and therefore, any "network-related" calls fail due to insufficient privileges.
I don't know if there is "another" way to call the DLL from the ASC or not, or any way tospecifically load a DLL with a certain security profile.
i am calling an exe from asp program. Its not working fine. When i execute the exe through the dos program directly i get the desired result. My exe will convert files in the folder to encrypted files.
But when i call it thru asp program its not working fine. I have tried the
following method.
a) Calling the exe through shell program.
b) Calling the exe through ASPEXEC.
c) Calling the exe through the Batch Files.
I would like to know your suggestions.
Here's a problem I can't solve.
Let n sub procedures A1, ... An
sub A1()
end sub
....
sub An()
end sub
....
I want to call indirectly one of them with a variable name like
this :
Ex :
myProc="A5"
Call myProc()
....
This doesn't work. Is there a way to solve this problem ?
i've got two pages. they have the same name for two sub procedures that do pretty much the same thing and have the same number and types of arguments. i either run one page, the other page or both. when i run page1 it somehow is accessing page2 even if it isn't called with an include statement.
page 1 is using the sub with the same name from another page even if it isn't included. so what's going on? is that normal? should i just make one page instead of 2? didn't think that sub's could jump accross pages that weren't included, but i could be wrong.
Where's the best place for me to include all my functions that I want to call throughout different pages? Should I just put them all in one ASP file and include that page on every page? Or use global.asa somehow (how??)?
Anyways, I was just wondering because I didn't want to slow things down if I could help it (I didn't know if having another big file attached to every page when I'm just using a small portion of it was very effective or not)
in my serverside vbscript I have:
call MySub();
......
......
then in the <Head>section I have:
sub MySub()
msgbox("Holding not found")
end sub
when I run it I get a typemismatch against the serverside call.
Anybody any ideas?
I want to create tables in my database programatically. I know i can do it using adodb connection object. I have too many tables, views and stored procedures. If I have to write a code, I will have to write 1000 lines of code. I dont think, thats the best way to do it.
I already have a sql script for these tables, views and stored procedures. I want to know if i can execute that sql script directly from ASP.
I will explain the background, to give a better understanding of my situation. We have a website, which uses the existing database to generate reports. If we want to host that website (as a service) to third parties, we create a new database for every customer, create all the necessary tables, views and stored procedures in the new database. I want to make all the table creation programmatic. Is it possible?
I'm working on a project and the designer guy uses templates for everything. THis is fine except I have to call a JScript function when the page loads and I have no access to the body tag. Is there a way to call the function as the page loads from a VBScript command?
View Replies View RelatedI have the following problem. I want to call a JavaScript Function from ASP
I am reading back values from a db and based on those values I want to check a checkbox.
If the value in the db field in yes then I want to check the checkbox but if it's no I want to leave the
checkbox unchecked.
My alert box is displaying but Im getting an error at the line
document.getElementById("chkStatus").checked = "true";
Im wanting to call a sub funvtion on another page from vbs that is:
<SCRIPT LANGUAGE=vbscript RUNAT=Server>
sql="exec SomeStoredProc"
call DoConnection(sql)
Response.write(recordset.getstring)
call DBClose()
</SCRIPT>
the DoConnection sub is in another page called MyDBConnection in a folder call Common.
I know that I can use serverside includes and embed my con in the page using <%%> but I want the use runat server How can I make call to a function in an external page?