this should be an easy one. I have a script which I use to add a new record to a database. Simple enough. But I have always used this string in opening up a database for just such a purpose:
"SELECT * from images"
Ok, I obviously don't want to select all every time I want to add record, so how would I just get access to that table without opening all of the records? Would it be -
"SELECT images
I'm using ASP to pull info from a database and open it in Word. Everything works fine but I want to specify the paper size to be Legal. Is this possible or am I stuck with Letter size?
I try to use as much functions as possible. So I have written a function to open a database and retreave the information from a specified field but it don't want to work. This is the function I use Code:
I have a database that was originally in Excel. After modifying it, I have saved it with .txt and another one with .csv format. DB.txt (Text (Tabl delimited)(*.txt) DB.csv (Text Comma Separated Value) (*.csv). What is the command/statement in oppening database record for these formats?
I have two servers is it possible to open a database connect on one server to access the database on the other. If so can anyone give me an example of the path.
how to open or do a connection to open switchboard in the Acccess database? Really Really need help from you who knows the code to open the switchboard in access database using asp. or Is there a way to link switchboard form to the asp page so that when i click on a link , it will open up the switchboard form (lets say the form's name is called "Contact") from the Access Database ?
Basically everytime I need a page to access a database I will create a connection object, and then at the end of the page I will close the connection object.
Would it be more sensible to create all the connections to the database that a user will need when they first visit the site, and then close these connections once they leave the site. (Using something to do with Start Session and End Session).
I am looking for the basic code to open, select and close a mySQL database using asp code. I am experienced in php and have a site using php to access this database but this client would like one page using asp.
The SQLServer and Web server are different computers. The error I got when logging on as ONLINE/ONLINE is "Cannot open database requested in login '<mydbname>'. Login fails. /<mysitename>/validate.asp, line 12
Line 12 is: objConnection.Open Session("ConnectionParameter")
In global.asa, the setting is:
If Session("DataBaseBrand") = "SQLSERVER" Then Session("ConnectionParameter") = "DSN=Alecto;UId=ONLINE;Pwd=ONLINE"
The names of UserID/Password fields on the form are dfsUserID/dfsPasswd
I 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.
When 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?
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:
how 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:
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?
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.
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.?