I managed to find the problem with my script thanks to jmurray's help. However I am now left with a confusing puzzle and I cannot any information about a workaround.
The error I now get is:
Cannot modify or delete an object that was added using the COM+ Admin SDK
I know now the reason for this is because I changed the 'from' email address in my script. If I put it as 'service@safetouch.com' it works fine. If I change the address to ANYTHING else, I get the above error. Is this something that can be corrected through scripting? If not, any ideas where I should be looking?
I'm a Win2000 professional user - sP 4. I can't delete some folders in e:inetpubwwwroot....
I've created them by FrontPage2000 SR1. I enter Windows as Administrator, then I should be able to create /delete all objects. On the contrary, each time I attempt to erase the assigned folder Windows warns me so:
"Access is denied. The source file may be in use."
I have a problem with adding and deleting the categories that a product is added to within a shopping cart administration system. My tables are designed as follows:
Table: Products Uid: autonumber Name: text etc
Table: ProductCategory Uid: autonumber ProductID: number CategoryID: number
Table: Category Uid: number Name: text Etc
When I add a product to the database I also add the same product to different categories i.e. I insert product info into Products and the product unique ID into the ProductCatgory table, which links to the Category table. The ProductCatgory is the table that links both the Products and the Category table together when I construct queries. This all works fine and I am able to add a product to multiple categories and then display the categories/product accordingly in the actual shopping cart. Code:
How do I change the text between a carriage return and a colon ":" in a variable? I am calling a memo field in a recordset and want to change the format of text (colour) between these two points. How can I do it?
I want to erase a line (or modify a number) in a text file throught asp, how do I do that? I have noticed that there are three ways of opening files,
1=ForReading - Open a file for reading. You cannot write to this file. 2=ForWriting - Open a file for writing. (If open an existing file, it deletes everything) 8=ForAppending - Open a file and write to the end of the file.
How can I just skip a few lines and erase a destinated line or maybe change a word in a line. without using an brute force (copy the file back and forth...)?
I've built an array like this and I've put it into an application:
Code: If not isArray(Application("utenti"))thenDim online(1,4)online(0,0)=4 online(1,0)=1online(0,1)=5online(1,1)=1online(0,2)=7online(1,2)=1online(0,3)=9 online(1,3)=3online(0,4)=15online(1,4)=3application("utenti")=onlineEnd if Now is it possible to modify some values in this application-array?For example trying to set the value in position 1,1 equal to 3 I wrote: application("utenti")(1,1)=3 or
I've developed a web app that generates documents (like word files, opendocument, excel etc) let's the user download it to their computer, edit it, and then upload the modified version, where it would be stored in a database.
I'm trying to find a way to let the user edit the file on-the-fly, and when saving it automatically update the database. That is, I'm looking for a way to automate the download-open-edit-save-upload cycle. Ideally, when clicking on a link, the user would choose to open the file with the apropiate application, and when saving it the database would be updated. So, any ideas?
I have a databse in MS Excel which I would like to use it in ASP? I got instruction on how to open and display the Excel databes in ASP, but I cannot make it to modify/add/delete the records.
I'm looking for a code already written if it is possible (as i need to do this soon)I have a database(access) and the users submit data from a asp page and it stores the values. Then it also allows the users to login to the web page using the data (username and password) inserted by the user.
What i want is that when the user logins, to be able to modify the inserted data..Perhaps the user wants to change the e-mail address. I tried doing some search in google but the results were no good.
I would like to modify IE page setup before printing the window. But i want to do it without opening the FILE-> Page Setup window. In fact, i would like to remove the header and footer of pages beforeprinting them. but i want to do it using asp or vbscript and without any end user action.
From the ASP application I am trying to 1) open a template 2) add data to a couple of fields (passed from order.asp to invoice.asp) 3) do a Save As so that the user can save to client.
I have this code working fine for a word document, but I am having touble with the XLT. Any suggestions?
I have a program that will need to update a certain table entry repeatedly - so I want the transaction to take place without using up too much time or system resources. I basically want to update the field with the current time i.e. Now(). Let’s assume: The table is called tblExample. The field is called LastTime.
I could do this very easily using record sets, but I understand that using pure SQL is much faster than using record sets. So, how would I update the field using only SQL?
I've got quite 20 identical MDB files running on an IIS5 server. From time to time I need to go into various tables and add a field or two. It would be great if there were an application out there that could either: sync all MDB designs (and/or data) esignated to match one I've added some fields/tables to OR go into all designated MDBs and create new field(s) or table(s).
I've began writing something like this that right now just does part of (b) but I'd rather find something that is much more slick and complete.
I manage to solve the last problem, but now I've encountered another one. I think there is something wrong with the UPDATE statement in this code. I am using Oracle 8i and Sun One ASP. Code:
I have an Excel Template that is filled out in certain senarios. What I want to be able to do is access this existing Excel Template through a webpage, enter nessisary data into the template, and then e-mail these changes to certain people. The original Excel template needs to stay Unfilled out and unmodified once the process is complete. If saving a different copy to e-mail is nessisary that is ok. I have Created the Excel object on the server to be filled with database info from a query, but I'm not sure how to open an current excel document and then email that document onces it is filled out..
I need to alter a dremweaver Update Record function but am a bit lost with it. I basically need to take the values from 3 drop downs that let you selct the date (day, month year). I've written a variavble that adds these together to make a date:
If anyone can guide me to change my basic data results link bar buttons (First, Next, Previous Last). I will like to use my custom arrow buttons but don't know how. The default buttons are generated by default with i create a query. Where do i go to modify these buttons, and what code do i use in the new buttons i will like to use....
I'm not sure if ASP would be the right code to do this but I'm gonna ask anyway. I'm trying to make an admin section...the thing is I make this site but I don't get online that often to update the news. One person offers to do this. He doesn't have a clue on how to use FTP. So I'm looking for something that I can let him log in(on a browser) to update this specific file(only news.html), don't want him to see anything else there.
I can connect to my schools webserver via VPN, and edit the webcontent. However, I cannot connect to the SQL server. Does anyone know of an ASP script I can use to admin the database remotely?
This is a small Web Application, this contains basic XML functions using ASP including a XML driven user authentication, adding new records, viewing records, editing and deleting records. Code:
I want to call the redirect to the selected page depending on the username. It is comeing from a text file I would like for the login to automatically be written in to the = ("<%login%>") but this is worn.What i have below wokrs for only admin and anyone else who is not admin. Or I would like to be able to add a third and fourth. I don't mind hard coding the login if i have to.
if Request("login") = ("admin") then Response.Redirect "main.asp?action=login" else Response.Redirect "client.asp?action=login" end if
I have an access database on my website.Its tied in to an asp calendar page where people can click on a date and send me an email wanting to book that date. Could i sent a text message from my mobile to add a new date into my access database to book that date instead of having to go onto my admin section and add it in?what i trying to explain. Is this possible or impossible.
i have currently built a website with some administration. The user goes to a login page and put in there username/password. This then lets them access the admin stuff. Thats all ok. I then thought well instead of going to the login
www.blahblah.com/login.asp i would just type www.blahblah.com/adminarea.asp and low and behold i was in the admin are with no login required.
Can I use the Website Administration tool to manage users and roles for multiple ASP.NET applications using a single, common ASPNETDB? If so, what changes do I have to make to the web.config files for these various applications to allow authentication from that single ASPNETDB. I'd also like to be able to maintain the users/roles and application access from the web server rather than from my development computer. Right now it seems like I have to make changes to user/roles in each web app and then transfer the database and code over to the server, just to add a new user. And each app seems to have it's own ASPNETDB which defeats the goal of a single point of administration for the server.
I would like to create the facility for admins on my site to be able to edit certain html pages on there site. Is this possible and if so does anyone know of any good urls discussing this matter ?
I have to come up with an admin cntrol panel so the staff can change ,update there website as needed. I would like to use asp to create the admin panelor if you guys can tell me of a better way like using php or somthing.
How would I go about letting them update/change the text. Do I have the site load it from a database like access or sql or ? Remeber it should be user freidly no html coding just type and upload.
I have an ASP page that uses a COM componenemt on a Win2000 server. The same server contains my SQL Server 2000, which the COM object is querying on. I use a constant login/password to login into the SQL Server, so it shouldn't matter which domain user is using the page.
It works fine for every user -=that is defined in the Win2000 computer Admins list=- , it doesn't work at all for users that are not (Connection ailure)....
I am not sure why, since how I see it, it shouldn't matter to the SQL Server which user is trying to login (since I use the same constant user/password for all of them...).
It might be either an IIS or SQL Server problem (or maybe even Win2000 related), Anyone ever encountered such an issue
I have iis, .net and MSDE installed on my machine, I have also installed "web data admin" but i cant log into it. The green blinking arrow for the server is in the bottom of my window so it appears that MSDE is ok.I am entering the following info at the w.d.a login screen usrnm: sa pwd: mypassword server: production etsdk
however i get this message returned: Invalid username and/or password, or server does not exist. Also, please ensure that SQL Server Authentication is enabled on the server.I dont know What have i done wrong/ missed.
for the admin table and page layout, is it compulsory for the key field to have a primary key? or it's not necessary becoz of it is only plan to link up to the combo box in the pages for the end users?