Create A Link From A File Name In A DB
I have uploaded files to a SQL Server DB using Pure ASP Upload, and that was a snap, but what I would like to do is create a link in my recordset from the file name in the database to the actual file that resides in a folder in the database so that when a user clicks on the link, the file will open.
I've done this successfully using another program but it used an ACCESS DB and I want to use it with SQL Server. Plus the ACCESS DB used a field with a data type of Binary.
View Replies
ADVERTISEMENT
How would you go about creating a link on a desktop through an asp page.
You know the old trick click here to bookmark this page?. I need to take that a step further, i need a link that when clicked it creates a link on the desktop to that page.
View Replies
View Related
I'm working on making a form that when submitted checks to see if the user has typed in a link, if so it converts it to a hyperlink.
This is for a news submission form on one of my sites. I don't really care if it is a popup like SPF has, or not. Just wanted to see if anyone here has done something similiar, and which route they took.
View Replies
View Related
What I am wanting to do is list the last 10 submissions to a knowledge base and create a link to each one with the question text serving as the visual representation of the link.
I have searched the forums for info on how to do this in ASP and have come up empty. I will detail what I have so far.
I have a database table called kbase and want to have html table with links to the last 10 things entered. I just can't figure out how to get a dynamic link to point back to the database entry.
I may be missing something very simple here but as this is work related my time frame for learning is small at best. Code:
View Replies
View Related
I have 1 asp page.I throw x amount of items into a folder.The asp page automatically creates a link to each item in the folder.
View Replies
View Related
I am trying to create a link that takes a record ID and opens up a PDF file that is associated with the record ID in the database. The following code works
Response.Write "<a href=""file.asp?ID=" & rs("ID") & """>"
Response.Write rs("File Name") & "</a></td><td>"
I'm trying to rework this code to work a little more easier with Dreamweaver. I would like it to look a little more like this:
"<a href=""file.asp?ID=" & <%=(rsNews.Fields.Item("ID").Value)%> & """>" <%=(rsNews.Fields.Item("File Name").Value) & %>" </a>
I'm receiving a syntax error when I try and run it.
View Replies
View Related
Can i know how to link a hotspot to asp file? i'm using frame. i have leftframe and mainframe.
the left frame is fixed. when i click on the hot spot on the left frame pic, i wan it to link to register.asp but target on the main frame but it will have a dialog box prompt
File downloading
u are downloading from
register.asp from C://.........
do u want to
open save cancel info
View Replies
View Related
Currently I am developping a internet "directory browser"
My page 'default.asp' has following entries:
CurrentPATH = Request("MyLink")
Set oFSO = CreateObject("Scripting.FileSystemObject")
Set oFolder = oFSO.GetFolder(CurrentPATH)
Set oFolderContents = oFolder.Files
this works fine with 'default.asp?MyPath', where "MyPath" stands for i.e.
c: emp
but NOT with 'default.asp?MyFile', where MyFile stands for i.e.
c: empfile.txt
Is there a way to determine if the link contains a file or a path? Of course
you can check for a dot (after dot, normaly it is an extension, thus a
file), but I want to have it possible also to have dots in my directories...
Anybody?
View Replies
View Related
can i get an example of how to read values from a text file that will be used as links on my page. i'll have a .cvs file ala:
LINK ASP_PAGE
"click me1", "clickme1.asp"
"click me2", "clickme2.asp"
"click me3", "clickme3.asp"
i think i can figure out how to do the read, but need to know how to get it on the page where i need it.
View Replies
View Related
I'm working on a document management app that saves scanned docs as PDF files in a local directory, then saves document metadata in an Internet-based SQL server.
The SQL server is then queried to retrieve document info and links are created that point to the files.
The code points to the proper local directory and file, but I can't get the browser to open the document in a target frame. If I open a test doc locally it works fine.
View Replies
View Related
I'd like to create ASP file on ther server side. Can I use
fso.createtextfile("c:folder est.asp")
Do I need to create a folder too?
View Replies
View Related
is it possible to create a xml file and save so that i can upload with asp?
View Replies
View Related
How can I simply save some data into a flat file (.txt) ? I've some data available and if the user clicks on a button it will save that data into the flat file... The user also need to define the directory (as in VB the common dialog box)...
Is this possible ???
View Replies
View Related
I have Windows 2000 and recently included Internet Information Services. I
then created a simple ASP file and clicked on it. The Open With dialog
appears asking me to select a program. I copied an existing ASP file,
test.ASP from another computer where it runs successfully. When I copied it
to my computer it changed to test.ASP auto file. The other computer runs
Windows XP. I am not sure is this is the issue. I verified the IIS is up
and running on my computer. Is there anything that can be done to correct
this?
View Replies
View Related
I am using ASP code to create a Word document on the server and all is working except for one thing: I need to be able to insert page breaks. My existing style formatting for page breaks does not seem to insert a page break into the Word DOC. Suggestions? Code:
View Replies
View Related
I was wondering if it is possible to create an sql file using asp to back up a tables contents at all?basically I want to make a copy of each table we have on the server into an SQL file so we can move it elsewhere, the server techs want to charge us for the backup copy so I want to get around paying if possible.
View Replies
View Related
i'm using window XP (hope this is not the reason) i cant create a file in my computer but it works on my school server
**********************************************
Set fso = Server.CreateObject("Scripting.FileSystemObject")
Set OutputXMLFile = fso.CreateTextFile("c:xx.htm",true)
**********************************************
everytime i run this method my IE hang(???) so, is it my IIS configuration problem or else.
View Replies
View Related
I want to create pdf file for reports using asp code.
View Replies
View Related
I know this is a lot to ask but if you have time please have a look and see if you can figure out why the following page to create a new ASP page on the fly seems to work but the output page doesn't seem to be there: Code:
View Replies
View Related
So, is there anyone can post sample code which cab generate the invoice, also it can be viewed by PDF file online.
View Replies
View Related
is it possible to create and asp page that can. zip a file and ate the same time unzip it.
View Replies
View Related
In Outlook Express, we could schedule event reminder on the calendar. I have seen people doing this on their web site, where they have a list of events and a "Add to my calendar" link to let user to click on. When the link is clicked, the Outlook calendar will pop up with all the event's information in it. Then I can save that event to my Outlook calendar.
I want to give this ability to the people browsing my web site to add our events to their Outlook calendar.
View Replies
View Related
if this was possible to have the users able to create a file into your webroot.
View Replies
View Related
this is simple script
<%
set fs = CreateObject("Scriptpting.FileSystemObject")
With fs
Set xxx = fs.createfolder("some directory")
End With
Set fs = Nothing
%>
ntfs security all is normal
my problem is next. i have installed Norton Internet Security, and when Norton Internet security is installed then i cant create files using asp scripts in Interet Explorer. how can i create files using asp script trough internet explorer?
View Replies
View Related
I have a stored procedure that creates XML content the way I want it using FOR XML AUTO, ELEMENTS. At least when I run the query anyway. What I want is to use that SP in an ASP page. When opened, I want a dialog box to pop upwith the option to open or save as... to the client's HDD. Here's my header for the page. The recordset is below that. When I open the page, I get the Save As. I want, but no records are saved.
What I'm missing is how to deal with XML and the recordset thereof. It's more of a feed that a recordset. How do I get that feed into a file on the client machine?
<% Response.contenttype = "application/vnd.xml" %>
<% Response.AddHeader "Content-Disposition", "filename=Product.xml" %> .
View Replies
View Related
I have an ASP process that creates 'reports'. At the moment these reports are output to a semi-comma delimmeted text file that I open in XLS. I then run a macro that formats the page correctly for printing.
What I would really like to happen is the ASP page creates either an XLS of ..DOC file that would open in excel (or word) with the contents pre-formatted ready to print. I have been looking, but have been unable to find anything suitable on this. Could someone out there point me in the right direction.
View Replies
View Related
I have a page that creates an xls file based on a field entered from a database recordset. Works great.
I want another one that creates an xls file of all the records in the database by simply clicking a button, then automatically offers the xls file for download. Probably Response.Redirect, but I don't really know the syntax used with that. Code:
View Replies
View Related
I have a script in ASP 3.0 which creates a CSV file on the server. After the
code has run I want it to prompt the user to download the file (via the
browser). I have spent a frustrating hour trying this.
View Replies
View Related
im creating an asp using the file scripting object but i cant create the file in the local pf of the client, but rather saves on the server folder.
View Replies
View Related
I'm generating one report using ASP file in MS-Excel file. How to take the same report in PDF format.
View Replies
View Related
I'm trying to create a excel file from set of data. actually I'm using ASP + JScript.
I'm glad to hear your oppinion.
View Replies
View Related
I need to convert a jpg files sequence (001.jpg, 002.jpg, ... etc.), stored in a directory, to a mpeg file using some programming language. Does anybody know how to do it?
View Replies
View Related
How to create a text file on other computer in the network by using CreateTextFile method? Using the following code, I cannot create a file. Set fileObj=Server.CreateObject("Scripting.FileSystemObject") set file=fileObj.CreateTextFile("(computer name in the network)asp esting.txt") .
View Replies
View Related