I have a page that creates a .CSV file that has been migrated over to
Windows Server 2003 from Windows 2000 Server. It worked fine before I
moved it, but now when it creates the .CSV file, and you open it, the
first row opens in cell A1 and the second row opens in cell A2. Code:
i'm trying to make a form that will pull details from a record that is found with (asset Number) but comes up with this error: 2342 "A RunSQL action requires an argument consisting of an SQL Statement"
Dim SQL As String
SQL = "SELECT *"
SQL = SQL + " FROM Computer"
SQL = SQL + " WHERE (((Computer.Asset)=" & TxtAsset.Value & "));"
DoCmd.RunSQL SQL
I am recieving a weird error when I try to run asp scripts on my local
machine, I can use pages that access a database, but when I try to write to
the file system ie upload a file I get the error message below.
any ideas?
The xml document I'm trying to create is in the wrong format.
<catalog><disc></disc><title>AVI 2</title></catalog>
Here is how it should look:
<catalog><disc><title>AVI 2</title></disc></catalog>
Code:
I'm using MSXML2.DOMDocument.4.0 to create an XML document on-the-fly.
Everything is going great except that at some point I need to create an empty XML element with a start and an end tag, not only an end tag.
Eg. I need to create <Signature></Signature> instead of <Signature />
However, MSXML2.DOMDocument.4.0 refuses to create the empty element with a start and an end tag.
It insists on creating only the closing end tag, even if I try to set text value for the element to "". Code:
My client has various Access databases that they want to be able to access (using MS Access, not through ASP pages). I thought I'd be able to create the link from an HTML page but when I do that and click the link, the file is downloaded to the local temp folder. I want the database to open directly from the web server, and then changes must be saved.
View Replies View RelatedTrying to figure out how to make a pulldown menu, which when something is selected, another pulldown menu comes up with limited options (based on the input from the first). I've seen examples using Jscript, but none using VB. The rest of my page is done in VB. Any suggestions? Is this possible?
View Replies View Relatedmy ASP code creates a form and an array of chekbox with this statement response.write "<input type='checkbox' name='chkProduct" & Cstr(counter) & "' value='delete'>" all goes well and i also have a button that points to a VBScript function passing one parameter the counter start value so i can loop throught the checkboxs on the client side and determine if checked or not.
Ok i can display my command "document.frmProductCart.chkProduct & (Cstr(counter)) & .checked" as a string in alert but cannot make it as a command like it should be, anyone got any pointers ?
I got an error saying
Microsoft VBScript runtime error- Error '800a000d'
Type mismatch
/briansforums/default.asp, line 923
also another error called Code:
I am trying to display data from three tables in an MS Access database. Here is my code:
View Replies View RelatedCDONTS is not working on my webserver. IIS 5.0 Windows 2000
I am using this code
<%
Dim objNewMail
Set objNewMail = CreateObject("CDOnts.NewMail")
objNewMail.From ="webmaster@test.com"
objNewMail.To = "***@***.com"
objNewMail.Subject = "Test"
objNewMail.MailFormat=0
objNewMail.BodyFormat=0
objNewMail.Body = "<html><b>test test</b></html>"
objNewMail.Send
Set objNewMail=nothing
%>
But it gives me error
__________
Microsoft VBScript runtime error '800a0046'
Permission denied
/test.asp, line 11
_________
I have also referred this Microsoft KB but no help....
I'm trying to send an email with a list of people in the body of the email but when i ty to send the mail i get the error
Microsoft VBScript compilation error '800a03ea'
Syntax error
/admin/tr1.asp, line 124 do while not rsp.eofwmail is the body of the email.I'm completely stumped here. Code:
I am accessing the same error-containing ASP page on an ISP server using w2k IE6 but with different effect. On the first computer I get several line of HTML outputed by ASP, shown correctly by the browser, followed by a descriptive error message:
Microsoft VBScript runtime error '800a000b'
Division by zero
followed by the number of the error-making line. On the second machine my HTML is not displayed at all. Instead I am getting that meaningless error page sayng that The page cannot be displayed, HTTP 500 - Internal server error. How can I get the second computer be more informative about the errors?
I found this code on writing to a csv file within this form. I have modified the connection and command slightly. I keep getting this error and can't figure it out!
Microsoft VBScript compilation error '800a0408'
Invalid character
/Expat/CSV_test.asp, line 38
^
Also, I have not created a csv file - not sure whether I need to create one with the headers/field names etc first. All I have done is the code below. Is this enough to create the csv file?
When I do the click event, I get this error:
Microsoft VBScript runtime error '800a01a8'
Object required: '' /get.asp, line 13
The Server is running on NT.
I have all of a sudden started to receive this error on my site. I have no idea what script it is executing, why it is now failing, what is going on? All I have been able to find out is that Microsoft has had the same problem on their site.
Microsoft VBScript compilation error '800a03f6'
Expected 'End'
?, line 0
I have just tried setting up a POST USER A COMMENT and when I go to post a comment i get this:
Microsoft VBScript runtime error '800a000d'
Type mismatch: 'LBound'
/ws/viewmember.asp, line 103
Line 103:
Code:
For MM_i = LBound(MM_fields) To UBound(MM_fields) Step 2
Getting this error:
Microsoft VBScript runtime error '800a0046'
Permission denied
/OperationsManageFiles.asp, line 28
I have an asp page written entirely in jscript with a vbscript used as an include file which one variable on the page must access.
When the page runs, I run into jscript complilation errors when it tries to access the include file (since it is written in vbscript), and I can't figure out how to get the two to work together. How do you get both scripting languages to work on the same page?
i would like to add a user and set file permission to a file with ASP.
(No component). is that possible ? do you have a link ? an example ?
I know how to use ASP to create and write into a .CSV file on the server, but I have a small problem. Every time I write to the file I am adding new lines each time. I don't know how to wipe the previous contents out, and I thought this is probably a no-brainer for you guys ...
So, I'm looking either to delete the file at the start of the process and start from scratch or
* open the file
* wipe all contents from file
* write to the newly cleaned file
How can i create a ZIP file from a folder (full of files) of the server.?
View Replies View RelatedCan i create a pdf file with asp by using my database information..?
View Replies View RelatedAll I want is a txt file I can write to... and I have a hard time doing it. Only a text file, which I can write strings too (incl timing). My ASP books do not have anything on it and some examples here dont work either.
View Replies View RelatedIs there any way to create a tif file from ASP? I would like to essentially create a tif of a formatted textual document.
View Replies View RelatedIm trying to create an XML file dynamically with asp and a data base. everything is working well until the bit where i need to write the file to my server.
I have been using this:
Code:
Set WriteStuff = rsPhotos.OpenXMLFile(strSiteLocationURL & "P4M_new_images.xml", 2, True)
But I now realize that my xml feed is not a .txt file, so I changed it OpenTextFile to OpenXMLFile but it does not work?
i want to generate invoice or bill of an order from an asp application and i want that in xls format and cannot be edited. is there any way to do it......? if yes plz let me know how or the source or tutorials for the same. In short i want to generate invoice in a manner in which user can't edit his invoice which he receives in his email........and i want to do this free......not buying any component.
View Replies View RelatedI get a "-2147467259" error (unspecified error) when I try to instantiate an
object on my web page. the object is in registered in the Component
Services and when I test the component manually by a VB app, it works fine.
My web site virtual directory security settings allows me to execute scripts
(if that helps).
I have been able to create and Active Server Page that when I link to
it will ask if I want to download to an excel file which I do want. It
works well, but there is one thing that I haven't been able to get to
work yet.
The ASP page has a logo picture in it and I want the picture to
download into the excel file also. It doesn't. My code is the
following:
Response.ContentType = "application/vnd.ms-excel"
Response.Buffer = true
Response.Clear
Response.AddHeader "Content-Disposition",
"attachment;filename=svra_excel.xls"
<!--#INCLUDE FILE="svra_report.asp"-->
the svra_report.asp is another page with the excel info in it.
Does anyone know how I can get the logo to download also?
I have manage to create a word doc from lotus notes using the createobject("Word.Application"). Now I wanted to add some text in a field on the template. I want to know how to insert a newline in the field.Also I have created a table in the doc file, now i wanted to know how to place at a desired position in the file.
View Replies View RelatedI do not get an error, but I also do not get any data in the excel file. I
know it is connecting to the db Code:
When an introducer is logged onto our site, I want to create a separate directory for them and place in this an index.asp page that will redirect including a variable to identify them.
I have created the folder with no problem, but when I try and create the ASP file, I'm getting errors. Code:
I need to extract some blobs (chm files, actually) from a database and save their contents on the server (recreate chm files).
I tried to do it in several ways (writing the contents to a stream and save the stream to file, writing the contents directly to file, I couldn't figure out how to do it by using the class ADODB.File) but none of them worked.