Fetch Files
What are the ASP codes required to fetch files from a remote location?
View RepliesWhat are the ASP codes required to fetch files from a remote location?
View RepliesI have a webpage with a form. This form submits data that goes to a mdb file
(id (AutoNumber), name, email contry etc.). I would like to make another
page where I can type the ID number and it will show all the fields only for
that id.
query = "SELECT table. * FROM table where table.lastname=" & lname
How can I fetch all the rows with the lastname field equals to lname variable?
I want to save the details of phases. On selecting a phase, there are 3 columns, task ,start date, end date in a row. Next to it, a button'Add task' is displayed. on clicking this, another row appears below. When i click submit, the data is saved if the following condition is truw: The end date should not be less than start date. how do i retieve the data of all the rows.
View Replies View RelatedI'm trying to make a sorting feature for my site which will allow the user to click a drop down menu, click the item they only want displayed, click a button, and then the results will only display that particular item.
I also would like the drop down menu to auto-fill because there are about 20 different categories available. is there and easy way to do this?
I have an excel file having textfields, I want to get its value from the ASP page. What is the way to get it?
View Replies View RelatedI need to run a query to get records with date within 30 days from current date.What I used to do with SQL server 2000 was the following:
Date30More = Date+30
MPQry = "SELECT * FROM SOP_T where Rev_Date < '" & Date30More
This stops working with Oracle because Rev_Date in Oracle is in the format of "DD-MON-YYYY HH:MM:SS PM". Therefore, I received an error message as the following:
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Oracle][ODBC][Ora]ORA-01858: a non-numeric character was found where a numeric was expected
I've a large database that I am working with. The problem is right now I've so many sample data in the datbase all the testing data in it. I want to clear the database and reset the AutoNumber so that it starts at 1 and goes up by one.I know that its possible in Access and I've done it before, problem is the tables have relationship and lots of them.
the way I know to rest the AutoNumber require me to break the relationship but it will take very long time for me to rectreate them again and I might not get them same at the end.Is there a way to rest the AutoNumber without having to break the relationship?
im trying to connect to access and display some infor. from table. but it cant work, many errors occur, saying dat the<%language="VB" runat="server"ris not found in server. what i need to add in so that i can take infor. from acess? some codes.?
Example:
SELECT* FROM Detail... bla... bla... bla...
A client has an OLE field called Signature in an Access database. The field contains a GIF image of a scanned signature (that a product has been received). How can I show this on an ASP page?
View Replies View RelatedI'm looking to display information pulled from a database based on information the user puts into a text box. The user will enter their sales rep number and I want to hit a table and return their name as soon as they tab off of the text box.
View Replies View Relatedwhenever i fetch any numeric value, having a zero at the end, e.g. 32080, from a database with a recordset object, i find that the value becomes stripped of the last zero, i.e. it becomes 3208.
View Replies View RelatedThere are 26 prizes available in a competition a client is running and he wants to be able to select these at random.
I thought the best way of doing this would be to construct a simple ASP page which displays 26 random records from the database.
The fields I wish to display are called name, email and address, and these are located in the table called Competition (this is an MS Access db).
I have a text box when user type (Name) on it and push search button,if
database has this name information such as(phone, address,...) comes in
several text box, if user want to update these information ,change text
in text box and save it, I couldn't write the update code for this
situation,
Is it possible to fetch data records from other website and store in a
database dynamically.
I mean to say i want to fetch data from a yellow pages website. showing records of different companies.
i.e, http://www.website.com/data.aspx?Co...1&DirectoryID=2
So, now I want a script which goes on this path and copy data after that go on next page which is CompanyID=3&DirectoryID=2 and follow the procedure.
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.
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 was wondering how some sites let you search by using a form, then present the results as static .htm files.
The reason I ask is that I tend to use ASP to process form information, then give the user a list of results presented on an .asp page. The list is simply drawn from a database in real-time and formatted into a template page.
The problem with this is that search engines can't see any of the information in the database, since they can't do the form submission. Is there a way around this?
When DLLs are compiled in VB, in addition to the dll, there are also
exp and .lib files created. Can somebody tell me what these are for?
Do I need to include them when I deploy my application?
I want to include just the result of a PHP file within an ASP file. <--#include won't work, it just imports the text.Is there an alternate way to do this?
View Replies View RelatedChecking our IIS log files we often get the chinese bots probing our sites. My only concern at the moment is that when an item is called by ID (i.e. select category from table where categoryid = id) and the id is called from either a querystring or a form request, I use CLng (i.e. CLng(request.querystring("id")) to convert the id to a long int to prevent the bots injecting the variable with any non-numeric characters.
View Replies View Relatedhow can i do a ftp function to upload and downlaod file to the server without using a 3rd party component?
View Replies View Relatedcan somebody advise me, how to put a few text files into zip archive on IIS5
on user request on some asp page?
IYHO, if I have say 10 different product categories that extract their data
from say 10 text files or an Access DB, is it more efficient to have an ASP
for each product category to query each section or 1 which parses the lot??
The only reason I am asking is for multiple user access I have this strange
belief that if 1 page is getting requested and queried by 10 simultaneous
visitors then 'spreading the load' on different pages would help.
Is my logic correct or do the ISP fairies have this in hand??
when the user submit a form, all the form data's will be saved
as a pdf file
is it possible?
yes means. by what way we can get this..?
For doing this we have to use any third party tools..?
I would like to capture the data from a textarea box and save it to a file.
View Replies View Relatedi want to know what is the difference between using a .asp include file and .inc include file.I know how an Asp Include file works , but some place i have seen .Inc as Include file. What is the difference?
View Replies View RelatedDoes anyone know of a COM object, or if it is possible to display content in the browser of a file in a zip file.
In other words, I have a zip file with like 100 images. I have a script that will knows which zip to look at and what the file name is inside the zip. What I want is to display in my browser the image that is in the zip file .Not sure if this is possible or not, I've been searching the web for a way to do this. Any help would be great.
I wanted to know whether we can zip files on the fly without using any
components.
i have just installed windows server 2003 standard edition
but when i try to run any asp files it gives this error :
The page cannot be found
The page you are looking for might have been removed, had its name changed, or is temporarily unavailable.also i couldn't log in my hotmail account
si i searched the help files i found some issue about the security level so i changed the security level and i could log in my hotmail account
how to use ASP for working .DBF files ?
View Replies View RelatedI'm looking into ways of creating zip files on my server without components to install. It's so I can let users of my site select files they would like to download and zip them up on the fly and download.
View Replies View Related