Open Recordset
I am opening recordsets in my asp page with the following command:
rs.open mysql,cn,3,3
on occasion it isn't working and I have to do:
set rs=cn.execute(mysql)
I am opening recordsets in my asp page with the following command:
rs.open mysql,cn,3,3
on occasion it isn't working and I have to do:
set rs=cn.execute(mysql)
What does ADO.RecordSet.Open return when the SQL query is an UPDATE or INSERT query?
View Replies View RelatedI am createing a search engine and I need it to be able to open multiple databases with a one recordset.
View Replies View RelatedI am trying to display the content of a Table called
'Order Detail' directly from the database (e.g., Northwind.mdb). I have the following commands:
Set tableSet = Server.CreateObject("ADODB.Recordset")
tableSet.Open table_name, DB_name, adOpenForwardOnly, _
adLockOptimistic, adCmdTable
where, table_name = ''Order Detail" Or
table_name = 'Order Detail' Or different variations.
I always get error on the second command with the following message:
Syntax error in query. Incomplete query clause
which I believe because of space in the Table Name. How can I resolve this issue? (working with file or table name with space)?
Last week, my shopping cart was still working well until I began getting the following errors 2days ago..
Error Type:
ADODB.Recordset (0x800A0BCD)
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
../order/saveorder.asp, line 157
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)
Page:
GET /main/saveorder.asp
Could you check my code below and let me know what possibly the error is?
I have created a forum, in which I have 3 tables:
1: Table_Forum
2: Threads
3: Replies
I have it at the moment that on the main default.asp there is a recordset that will
display all records within that table, these are a list of forums that will be available.
I have a table that will show the forum name, and the description. This table is then looped using Do while not, now what i need to do is show how many records in the Treads table are related to each forum using asp. 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:
i want to open a dbf file in asp which is saved in a directory. The Path of the file is "F:mywebdb". The dbf file is saved in the above path and is called test.dbf. I write the following programm to retreive the records Code:
View Replies View RelatedIs it possible to struture a link in a Web site so that when clicked it will open a particular file on a CD-ROM? I didn't create the CD-ROM and the files are AVI and DCR.
View Replies View RelatedI try to open mht file generated by ASP use the
Content-Type = "application/msword".
When the browser show de "dowload dialog" and I click in the Save button the file open perfectly, but if I try to click in the Open button, the browser show the "downloading dialog" and stay perpetual trying to open the file.My problem is, I cant save the file in the local machine, I need the Open only in memory.
I want to Open a database with asp, I know the syntax to do with VB but how do I make the refference of the DAO in ASP?
View Replies View RelatedI have searched the web and books but so far I am drawing a big fat nada on this one.
I want to open a new window from an ASP page and everything I have found suggests to use JavaScript and not the server side VBScript. The problem is that the server side is what will decide were to send the user. Is there a way to exit or open a new window using JavaScript passing in variables fromVBScript server side then close the ASP page?
the new window will be in the SAME session as the opening window.I don't want to abandon the session of the opening window, just have a new one for the new window.
View Replies View Related