I am creating ASP pages which call for information from a database, however when I have completed the page in FP, exit, and go to Access to modify a Query, I am told the Database is still in use and that only "Shared access " is available.This does not happen if I reboot the computer.The page was generated by Access "HTML Wizard.I am using FP98 and W98.
View RepliesI've been writing web pages that pops up smaller windows when links are
clicked. I noticed that very often after the small window is poped up, the
mouse pointer remains busy instead of returning to the normal pointer.
Does anyone seen this problem before and know how to resolve it?
Code I use is like this:
function viewproductdetail(sku)
{
g =
open(page,'g','status=no,toolbar=no,menubar=no,hei ght=550,width=500,scrollba
rs=yes');
g.focus();
}
I have stolen code from another thread in this forum that I am attempting to modify. The original code uses a Microsoft Access database file but I can't create one cos I don't have Microsoft Access. Instead I am using Microsoft Works to create a dBASE IV .dbf file.
This is the code i have attempted to use but it doesnt work. Code:
How can you insert a quote ' or " into a database from a forum without getting an sql error due to the quotes closing, or opening a new field in the sql string.
View Replies View RelatedI have a Parks Database where anyone can see a complete list of parks we have. What I would like is for people to be able to sort this list by certain parameters, one of them being a "District" parameter, but could conceivably be parameters such as Sort By "Playground" to see a list of Parks with Playgrounds.
Is there a way for me to do this via some sort of hyperlink to the "District", that if it's clicked on, does a new form (Maybe a form named sortViaDistrict) within the same page? I'm not too sure how to do something like this. Code:
I've got a little user poll system and I'm trying to create an 'edit' form. The form relates to 2 database tables, one holds the poll details (title, start date, end date, etc) and the other holds the answers/options (answer_id, answer, etc). I've successfully setup the form so it updates the poll details but I can't work out how to update the answers? Code:
View Replies View RelatedIt will export a database (Access) table to an Excel sheet.
Set rsC = Server.CreateObject("ADODB.Recordset")
rsC.Open "select * from CFL WHERE Emp_no = '"&empno&"'",myConn,1,3
'**** create excel file
Response.ContentType = "application/vnd.ms-excel"
Response.AddHeader "Content-Disposition", "attachment; filename=CFL.xls" .......
my script is working properly but i want to create another sheet of the Excel file because i will export multiple tables from the dtabase to an Excel file with multiple sheets. it only creates one sheet?
I've got to learn how to read/write dBase IV files fast. Please provide a good quick start / tutorial and / or some good links here.
View Replies View RelatedThe scenario is that the user enters a description of a special offer into a text box and then can add that record to a database field using the insert method of asp. However, an error occurs if the description has any apostrophes in. For example,
special offer 1: andy's prize plums
could cause an error because the insert looks something like this
"insert into offersTable(offerDescription) values (' " & request.form("description") & "'"
is there some way to escape all naughty characters so they don't cause a problem. Any suggestions very welcome.
I have a dbase containing login details for 21,000 members. I also have a
forum that I am about to implement.
When the user gets to the main site, he has to login (this is done by
checking his credentials against DB1) When he is logged in, all his details
are stored in session variables. Clicking on the forum link will take him to
the forum where he has to log-in or register. Currently, the forum checks
cookies to see if there is a valid name and password and then checks these
against it's own DB (herein called DB2) or requires the user to
login/register
I plan to modify the forum so that the login is bypassed and the forum
accepts the current session name and password as the login. (This is so that
all names on the site main site, chat, forum etc are uniform, i.e Dave47 in
a chat room, is Dave47 in the forum, is Dave47 in the members area etc)
so...what I need to do (if you're still with me) is.
When a new user registers on the main site, his details are put into DB1
*and* DB2. , can I have two data sources open at once?
The reason I need two DBs is that the information in DB1 is a lot less than
is needed by the forum in DB2.
Also how can I copy selected fields from DB1 (name, password for existing
users) into DB2? like I said..there's 21,000 and to do it manually would
take forever.
I am currently working on a small asp application. Now I would like to store the complete database connection in the application object. Note I want to store the connection NOT the connectionstring. For that purpose I wrote a small asp include which connects to the dbase and stores the connection object to the application object. However when I use this include in my pages then it doesnt work. What I am doing wrong? Here is the code:
View Replies View RelatedI've been tasked with integrating an older management system based on
DBF files with my snappy new ASP application to provide users of the
ASP application with real-time data from the management system.
I figure with DBF files, I should use either the DBase drivers or the
FoxPro drivers to connect to the database. Code:
I'm required to write ASP code to open some .OFT (Outlook template) files from within a web app. Does anyone know how to accomplish this ?
View Replies View RelatedI devolop a webpage using ASP.NET. i want to redirect my page to certiain links stored in the database. the links can be either URL or Word documents sored in the server. here is my problem. when i redirect my page, if it is a document, it opens the MS.Word appilication.
instead, is there any possibility to open those documents in IE itself with out any confirmation ?
I have an application that generates PDF documents (from an ASP page). In some cases, I need to generate a PDF then provide a link to that PDF from the web page - this I can do fine. In other cases, I want to generate the PDF, but then immediately open the PDF in the browser; in this case, once I have generated the PDF, I am simply using 'Response.Write MyPDFPath' to open the document.
However, for some people this doesn't work, but for some it does. And I can't figure out why results are different. In both cases, the browser address changes to match the URL for the PDF document, but in some cases, all you can see is a blank screen. If you click on the Refresh/Reload button, the PDF displays perfectly - so it's not a show-stopper, but it is a bit of an inconvenience.
Has anyone got any ideas why this may be happening? Is there a better way of opening the PDF? I thought of streaming directly to the client, but that would present the user with an Open/Save/Cancel dialog, which although is more intuitive, it's hardly any easier than clicking on Refresh.
I'm dynamically creating a PDF file using a 3rd-Party component. I've got this much working...
However, once the PDF has been created, I want to open it in the browser. This is where I am struggling...
I can create a page with a link to the PDF, but I dont know how to open the PDF in the browser directly.
How can I open an .exe File from ASP without getting any message?
View Replies View RelatedWhen I try to open an Excel file from ASP thro' HREF it works fine. But i give the same file in Response.Redirect it says "page cannot be displayed" even when the file exists. Is this related to server configuration?
View Replies View Relatedi have a radio button when a user clicks it i want to open up a excel sheet
and want to display the records from the table
i want to only display specific fields from the table not all fields
Can someone tell me how it can be done in asp 3.0
I would like to open a new window (Function is called NewWindow and is writtent in VBscript) when a user submits a form. All the samples I found on the web indicate something like the following: Code:
View Replies View Relatedhow can i open a new window with a if statment but still getting variables values?
tit=Request("title")
if x=1 then
something
else
Response.Redirect("<A href="http://www.test.com/lookup?q="&tit">http://www.test.com/lookup?q="&tit")
end if
I donīt mind using java, but i donīt know how
I am working on a website and have a couple links that open up a new window. My webpage is .ASP as well as the windows I am opening. Currently the link open into a new window. However, I would like to be able to set the the size of the window that is opened.
This is the code I am currently using:
<p><a href="Search/search_owner1_form.asp" target="reportWindow" class="style2">OWNER 1</a></p>
I have problem i want created simple site
This site should epitomize table about organizer free or busy room in month
the rooms is 6 but people should mark
I have a Word doc already created that I want to open from an asp page. I want it to open in Word and allow the user to modify if necessary. I currently have it opening (using href), but it is opening in IE. I think I should be able to do it with javascript to open word and then call that function on the link to the doc. Can someone give me some pointers?
View Replies View Relatedanyone knows some program which can be opened directly by creating an object within an asp file ?
something like word or excel (Set objWord=Createobject("Word.Application") for instance )
I have an asp like this
<td width="49%" align="left" class="HD"><a onclick ="javascript:newwin('DNA.ppt','server/delivery/Documents/')">rs("Report")</a></td>
function newwin(docname,url){
location.target="new";
location.href="viewdoc.asp?docname=" & docname & "&url=" & url;
}
in the viewdoc.asp i need to check the file type and set the content type accordingly.also the viewdoc.asp must load in a new page and display the document passed.
can anybody help me with a piece of code???
In our ASP page, we call XMLHttp to download XML files. When calling our
page using localhost (localhost/myWebSite/myPage.htm), it works, but when
calling using the IP address of the web server
(xx.x.x.xxx/myWebSite/myPage.htm), I got "Permission denied" error in the
HTTP.Open statement.
Set http = CreateObject("Microsoft.XmlHttp")
http.open "Get", "http://" & "xx.x.x.xxx" & "/XMLFiles/N-1min.xml",
ALSE --> permission denied error
Why do I get permission denied error on the HTTP.Open, and how to fix it ?
I have an the following asp. How to have this asp to open in another
window when it is called?
<% something %>
I am looking for an open source, very simple CMS that allows an administrator to add pages, news articles, and maybe a staff directory.
We don't need new users to signup, or comment, or anything along those lines. Maybe a wysiwyg editor included. Just for a homepage, a news section (that may include many sub-cats, pages).
I have a website set up that can pull data from Access database tables and display them on the webpage depending on users' selection. Is it possible to have ASP open up Microsoft Excel and dump the data into it, plot graphs, calculate averages, etc.?
View Replies View RelatedI have a submit button that a form uses to submit the contents of that form to another page.
<input type="submit" class="input" onclick="this.form.action='checkname.asp';">
Is there any way to open a new window and perform the action in the onclick event?
Is there any way to keep a window on top using window.open? I can't use a modal or window.focus onload b/c I have to get inputs
View Replies View RelatedI have an .Net project that has an ASP page, that has links. When a user clicks on one of the hyperlinks, it opens an Excel page, in IE. One of the cells in the Excel Workbook contains a link to a PDF document.
If the user clicks on the PDF link, it's opened in the current page. I'd like to know if it's possible to open the PDF in a new page. So it would basically be opening a PDF from the Excel document - that is opened in IE. Code: