Stripping File Path Name Before Insert Into DB
Does anyone know of a function that will take the file pathname and just keep the file name before doing an insert into a database? Code:
View RepliesDoes anyone know of a function that will take the file pathname and just keep the file name before doing an insert into a database? Code:
View Repliesi am having a problem in how to create a Open File dialog to enable user to select a image file that will be stored into database. i just want the file path to be stored in database, not the image.
View Replies View Relatedif i got a file path as a variable say for Example:
c:folder1folder2folder3folder4file.txt (The Path could be any long)
how do i just store the Path of the file name and the file name seperately. like :
File Path=c:folder1folder2folder3folder4
File Name=file.txt
I have a problem. I tried my best but could not solve is. I have a
page where user selects the folder name from a drop down list. It takes
user to show.asp page, where it how all the files in the folder and
also user can click on them and download them. If I select name of the
folder from the list, on show.asp it shows all the files and their
link.
When I click on the link then most of the file which has long
name and have space in their names wont be hyper linked. For example if
files name is Virus Control.vsd or file name is INCIDENT-ACCIDENT
INVESTIGATION REPORT.htm. If I click on them it will say "The page
cannot be found". Code:
I have setup a site that allows users to login with a username and a password that are stored in a mysql database,
now what i need to do is set it up so the users can only download specific file(s) related to their username.
With my current set up using all asp and iis 5.0 all the users can download the same file from a certain directory.
I was thinking of somehow using the session variable of the username as a variable in the download path of the file, but i don't
know if this is a correct method of doing this or the correct syntax.
This does not seam to work for me in IE, but does in Netscape? What I am trying to accomplish is this.
On the footer of everypage we have a link that opens a comment page, example [<a href="#" onclick="javascript:view_win(/comment/comments2.asp');" class="notes">Send Comments</a>]. I am trying to write asp code to that takes the referering page and then gives the the filepath of that page which searches a database of web authors, and then returns the authors email address. after that I loop to add input sendto's for each one found. Code:
i want to trim the given path and get the file name with its extenstion:
i.e. only get the "XPIcon.jpg" in the following example
URLImage = "D:Documents and SettingsAdministratorDesktopXPIcon.jpg"
Note: the URLImage is always chaning, its not constant.
I'm needing some help on this. I need to know how to parse a file path for the file name in a browse box. Lets say I have a browse box in a form with the input of
C:/somedirectory/somefile.asp
I need a piece of code that could convert the input into just somefile.asp?
In my ASP file, located at the "/test" directory of the website, I include another ASP file as below.
<!--#include file="../templates/_header.asp"-->
Inside the _header.asp file, how can I get the current file (_header.asp) directory? I need to get the web relative/absolute directory of _header.asp, but instead even if I can get the physical directory location of that file should be fine.
I tried Request.ServerVariables("") with almost all the variables, but none gave me what I wanted. This is necessory, becase the location of _header.asp and the file which includes that can vary.
I am attempting to upload files to a folder on a remote server. However the folder is different for each user based on login. Is there anyway to do this using the code below. If not can someone tel me of a way to do it.
Dim DestinationPath
DestinationPath = Server.mapPath("UploadFolder")
what I'm doing is executing a query based on login for a varible called "uploadFolder", so I want my destination path to be something like
<% DestinationPath = Server.mapPath("rsRecord(uploadFolder)")%>
Of course my code doesn't work,
I am not able to save the file path into database remaining everything is working good i can upload the image to the folder and save the data to the database. I am using MySQL database .....
View Replies View Relateddoes any one here know of a good way to to determine whether or not a
given path is a directory (e.g., "c:mydir") or a file (e.g., "c:mydir
myfile.txt")?
i started attacking this problem by using filesystemobject to check
whether or not a directory existed for the path. if so, it was a
directory path. if not, i checked to see if a file existed for it. if
so, it was a file path. Code:
The file uploader code I've been using won't let me use Request.Form and BinaryRead on the same page so I've resorted to having the file upload code on another, seperate page that is spawned from the first. Trouble is, the path to store the file at is determined on the first page and I don't know how to pass it along to the second.
View Replies View RelatedI usually use SQL Server, but have occasionally had to use Access. This is
such an occasion. My research, mainly at aspfaq.com, has been that you need
to put the file path in your connection string, like this (watch out for the
wrap):
strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=c:mydirectorynamedbname.mdb;User Id=xxxxx;Password=xxxxxxx;"
Well, the host of this new site I am working on is asking me if a relative
path will work. I don't think it will, but thought I should ask.
I have one COM (.dll) for uploading files to server. Its working fine on server A but same code and file not working on server B giving error Path/File access error .
View Replies View RelatedI have a simple asp form which writes to a csv.
The code it's based on (from "ASP for Dummies") is:
Set peoplefile - _
filesys.OpenTextFile( _
"c:inetpubwwwrootgbgbpeople.txt",1)
The form is going live soon, and I'd like just a dash of due diligence
in terms of security. I tried using a relative link to the gbpeople.txt
file which didn't work. Is there a better way around this without
reinventing?
Is there a way to determine the filepath of an ASP script being executed, like so? First file contains:
<%
For Each x In arrNuggets
Server.Execute "/nuggets/" & x & "/default.asp"
Next
%>
The executed file, default.asp, needs to be able to figure out what it's parent folder name is.
Request.ServerVariables("SCRIPT_NAME") only returns the name of the first initial page loaded, and nothing about the page currently being executed.
I am trying to create a log of certain events on the website by writing them
to a text file. The logging code is in an "included" file that is inserted
into the pages that need to be monitored. Currently, the target text file is
just specified in the FSO MapPath as "thelog.txt", so it writes the log to a
text file within the same folder as the web page.
The problem is that I don't want to grant browsers Write access to my pages
folder, so I need to have a separate directory to hold the log text file
that browsers can have Write access to. The web site is hosted on a shared
server that I do not have direct access to. In the past, occasionally an
error has popped up that states the exact location, but I can not get that
to repeat. I know it is something like "D:customersmyuseridwww"
How can I find out the actual location on the server so I can use an
absolute path to write all the logs to one file in one location?
I have an upload script but i would like to show the person who uploaded the file the path to the file he uploaded. Ex: http://site.com/images/uploadedfile.jpg.
View Replies View Relatedive got a bit of code to check if a file exists and it works if I use the full path ie "C:Inetpubwwwrootfile.txt" can someone advise me how to get it so I can use the relative path ie "file.txt" where the file and the code are in the same directory? Code:
View Replies View RelatedI have a Physical path that I need to convert on the FLY I thought using Replace would be a good idea, and it almost works
function MapURL(path)
dim url2
'Convert a physical file path to a URL for hypertext links.
url2 = (path)
MapURL = Replace(url2, "", "/")
MapURL = Replace (url2,"E:","http://myscs/docLibraryDocs")
MapURL = Replace (url2, "IntranetLibrary", "")
end function %>
- Is it possible to have multiple replace on the same variable ?
- am I doing it the right way ? or is it possible to concatenate those replace in one go ?
Is there a limit on how many Replace one can use for one variable ?
The problem I have is that it takes the first two Replace in consideration but not the third one. If I remove or comment the second one then the First and the third one works fine. For some reason, it doesn't like to have the three in the same time.
by the way, the link I try to change is as follow: Code:
I need to load the file path of a file on a web server into a form text box. I tried using a normal form box using type=file but that just seems to return the file path from the local machine.
Ideally I'd like it if someone can get this to work with a file on a web server without using asp. If not then I suppose I'd have to use the FileSystemObject method. I can see how you can get a list of files from a remote server using FileSystemObject.
The problem I need help with is selecting a file path from the list of files into a text form box. The path of which I am then going to write to a database field.
I have a virtual path setup in order to give my web server access
to a file on my app server. I am using the file system object to check
for the existance of the file and if it exists, it has to validate the
file date.
The problem is I can't seem to find the file. I can successfully check
for the existance of a file on the web server, but once I enter the
virtual path it can't find anything. All three of these calls return
false...
fso.FileExists("http://server/localfolder/virtualfolder/test.txt")
fso.FileExists("/localfolder/virtualfolder/test.txt")
fso.FileExists(Server.MapPath("/localfolder/virtualfolder/test.txt"))
However these two calls work, so I assume I am referencing the file
correctly...
Response.Redirect "http://server/localfolder/virtualfolder/test.txt"
Response.Redirect "/localfolder/virtualfolder/test.txt"
Am I doing something wrong here? The virtual path is setup with an id
that has full access to the folder.
I have a form that uploads a file (i'm using Freeaspupload) and I wish to insert the name of the uploaded file into the database.
I'm just a little unsure of what code to use from the upload script to insert the name of the file.
<%
updatenewssql = "UPDATE news_tbl SET news_image = '" & Upload.UploadedFiles(fileKey).FileName & "' Where news_id = " & Request.Form("news_id") & " "
set updatenews = crofts.execute(updatenewssql)
%>
I have problem with physical path & virtual path on the server.
<!--#include virtual="country/inc.bottom.asp"-->
In this script it is working.
In all the file i have <!--#include file="../ar-inc.top.asp"--> this script.
I have about 10,000 files in the website.
i have a record that is returned by the database as domain/username. i want to be able to strip off "domain/" and just display "username". is this possible? if so, how would i go about doing this?
View Replies View RelatedMy ASP page allows user to enter comments into a form. To avoid
errors I'm having to strip out double quotes before saving to the
database. Is there anyway to encode these so that I can store them
instead, in the way was an URLEncode works?
I'm trying to replace all the " in my variable with ', but I can't seem to get it right.
editizecontent = Replace(Request("EDITIZE"), """, "'")
Would this work?
in my front end uses will type in a date in a text box. in the code it want to call each individual i.e the month the day and the year i am not sure of how to do this.
View Replies View RelatedI'm trying to make a form that allows the user to select multiple files from their computer, and then INSERTS those file names into an access database using ASP. I also don't want to have a seperate <input = file> tag for each one??? Is this possible?
View Replies View RelatedI'm using ASP to gernerate an RTF file as the result of a form. But, I need to have an image be at the top of the first page. I'm generating the RTF file from an example that I found on Microsoft.com using statements like below...
View Replies View Related
Can we use BULK INSERT for .dbf files
I would like to split my gui into 3 parts. First 2 row and then at the second row, into 2 column. How do i code so that the button form column 1 can result in the change of page in column 2.
View Replies View Related