I am using asp within frontpage in this situation.
I am doing a simple select from one table, the table has a date field, the select should basically show the next 5 upcoming events based on date. I want to use a "current date" variable in there so the events that show are not in the past (i.e. upcoming events, not past).
I created a query in access and used the now() function for the date, but when I do, that the query does not work within the asp page (it does work within access itself).
All I need to do is select all records where a certian field is empty. Depending on the status of the orders there will be a 1, 2 or 3 in the status field. If an order is declined nothing is written. I just want to view all records where the status = "" but it's not showing any. and I confimed that they are there.
Code:
if action = "Declined" then strSQL = "SELECT * FROM Orders WHERE status = ''" strTitle = "Declined/Failed Orders" end if
I have what I think is a simple question but I am finding nothing but complicated answers.I have a web site running on IIS6. One directory used to use an alternate account as the anonymous user (not the IUSR_ServerName account) to connect to a database, etc. Now the pages in that directory no longer do anything special and I just want to start using the default IUSR_ServerName account again. I put that account back in, but what do I put in as the password? I am reading all about security improvements, network service vs. local system, unprivileged vs. priveleged, etc. I realize there is no longer a "Let IIS control password for anonymous account" option, but all I want to know is, HOW DO YOU GET IT BACK TO THE DEFAULT
I am trying to get a form to insert info into a access database. I am using dreamweaver 2004, i created the form with 4 text fields and a submit button. Ive added a ODBC connection and dreamweaver can qurery my table.
I added an insert record server behaviour, and i figured dreamweaver does all the work for you but when i saved and uploaded the page to my test server it would not submit and redirect to my chosen page, it only refresh the form.Has anyone out there done this before and can notice a step that im missing. Do i need to setup a recordset? because ive tried that as well and no success.
I have a select box which has "onchange = "test()"" property that invokes javascript function which checks the select box and returns flag. The question is how can I access this flag in ASP .
I want to select a random record from a table within my Access database, however I am running into problems. When the page is executed, it always shows the same record. Code:
I would like to use Frontpage to design a website but use Visual Studio .Net to do the coding( ASP.NET). I am new to Frontpage and was wondering what the best way to do this.
I have a form that submits results to my email box called TechSupport.htm (created in FrontPage 2002).It works fine.When I add a dropdown box with data from a legitimate Access .mdb (with a verified database connection),FP urges me to change the extension to .asp which I do: TechSupport.asp.Then the dropdown works fine, but the form stops working. I think the problem is because I change the name to .asp. Specifically, when I click Submit, it pauses as if it's processing, but then it returns to TechSupport.asp instead of redirecting to the form confirmation page.
I'm using Win2000 with IIS and FrontPage server extensions. I've tried it on my local machine (with a local inetpub) as well as on our corporate web server (IIS and FP extensions), but it fails in both places. Also,I have several other .asp pages that work just fine.
Trying to setup an ASP project and a FrontPage project under a personal server talking to an Access database all on my hard disk running Windows XP Pro. I have the components:
a web server under which I can run the FrontPage project a Visual Basic ASP.NET project which it insisted on installing under a different web server an Access database
..NET framework is installed (don't ask me where) Frontpage extensions are installed (don't ask me where) IIS is installed (don't ask me where) Are there instructions somewhere as to how to bring (or install) everything that is needed to make this work?
I have written a asp code where i send an email to the person when he/she specified her email id before hitting submit.I catch that email id and check whether the 2 dates entered by the person has a difference of less than 30 days .I used the datediff function.
My server where we have hosted our site doesnt give IUSR permission to the pickup directory and i cannot run this code on the server.But the administrator is telling me to use the Front Page extensions to send email and i have never used FP extensions before to send an email.
Can anybody help me to know how i can do this without changing my code?
I did a very simple database in Access. It's for locating archived blueprints that we have here. We are scanning them into the computer then archiving the files. The database contains all relevant information pertaining to the drawing. Some examples are filename, job_number, title, drafter, etc. I would like to have a web browser as the searching interface so everyone can easily search from any machine if they need to find an old drawing. Now I have been messing with the DRW in FrontPage but have had various degrees of luck. I would prefer to have a search box with a pulldown menu to specify what field to search. Say if I wanted to search for a specific job number I would select job_number and enter 04001 and voila! In a perfect world at least...I took 1 database class in college and that has been some years ago now. A crash course seems neccesary at this point or if someone could just walk me through I know I will start remembering things.
Ive been using frontpage 2002 for my databse but would love to know more about ASP. Frontpage can generate asp codes but can anybody help how to use frontpage and at the same time create my own ASP codes for viewing database in ACCESS, add, edit, delete, update database. Also I tried using Frontpage for my database, but the problem is i cannt edit the codes for its so complicated.
what i wold like to perform is view the database in access in my browser, update on it, delete a record, edit it, and when adding new record, a new number for the applicant[its like auto number, i tired using ACCESS to auto number, its nice nice. =) i know there is a a way by using ASP.].
I'm a web designer and developer with experience using nix, Apache, PHP, MySQL and so on. Within the space of a few days, however, I've been asked to overhaul two ASP sites, each with some databases, and one designed to interface with FrontPage. I know very little about ASP and have never used FrontPage.
learning to work with ASP and FrontPage? With one site, my intention is to somehow create an idiot-proof CMS to enforce template/appearance across a number of sub-sites. Easy in PHP -- just create a web-based admin interface -- but my client would very much like to have the content managers keep their FrontPage.
I installed IIS+Frontpage serverextension and I use frontpage.I use Interdev too but when I want to create file in my server directory(inetpub/wwwroot)it givs me a message that I can't create my Interdev file.Do you know what the problem is?
if is it possible to connect a database (access 2000) through frontpage? i try to do this and i got an error. in frontpage, there is a option to connect database. then we have to publish a web and after you can store your data through form. all these steps i have already clear. but i can't.
My background is primarily the Linux/PHP route, so I am encountering some IIS problems with our school's course instructional server. We have a Linux server and an IIS server, and for a specific project, they requested it to be in ASP, and the server admin would prefer us to use the IIS server, rather than Chilisoft, so its all good there.
However, I don't know how IIS works, so I don't know why this is: but I have to connect with Frontpage, and I can't use FTP or SSH. Is there a way around this? I dread using Frontpage. I've asked him to install some type of FTP service on the server, but he said that he can't yet because then he would have to go through the politics of having the school's network admin running more tests on it to make sure it doesn't compromise anything.
So it seems I am either going to have to use Frontpage or find a way around this on my own. And I would prefer the latter foremost.
I know that this is not the most appropriate forum for this question, but after the excellent advice i have recieved from some members about various things I figured I would wrack your brains. The situation is this: The webserver in question is settled behind a firewall, and you can only get ftp access if your ip address is on a trusted list. A colleague of mine wants to access it from home but due to the fact that he has a dynamic ip address he is unable to be added to the trusted list.
I assumed that his access would be denied, and sure enough when i configured dreamweaver for the site it did indeed fail to connect. So far this makes sense, but then I discovered that if, when on the website in IE, if he clicks the edit with frontpage button frontpage will open and give him access to the site once he has logged in with the correct username/pass. He really needs to be able to access the site via dreamweaver so im wondering if anyone can explain how FrontPage is able to get access and if this information can be used to get dreamweaver connecting.
i am trying to make user login and password then when it log in it is go to diffrent page in the website this page is frame page whitch contain three frame
when i put the index page " the main page " in the server.execute("index.asp") it is dispaly nothing
how can i make it dispale the frame
but when i put single page to the server.execute("student.asp")' go to student page
Does anyone have any idea what secret location I would look in to eliminate this error. I received the error when trying to publish the website from one server to another.
Server error: The folder that would hold URL 'agency/rgn/r2/_overlay/region2.htm_nav_sumipntg010_hbtn.gif' does not exist on the server.
Since the 'agency/rgn/r2/' folder does not exist on either of the servers anymore, I don't have any idea where the error is coming from.
if there is anything that needs to be done to convert my intranet web pages (html & asp) created in frontpage to say... InterDev, Web matrix, Octane8, or Dreamweaver. I notice some header information that looks specific to frontpage.
I created a new database using the Frontpage 2003 wizard. Everything works Fine but I would like to have the option to Delete the database (What I mean is anything that was puyt in to get rid of it.) after they are done putting in what they have to put in. Is there a way to do this I can't find one.
I'm having trouble with webbots in FrontPage 2002. How do I edit the Nav in FP 2002? I can only see the properties when I Right Click. The Nav was auto generated when I ran the Wizard to create a site. But how do I rename them or add to the Nav?
does a version of visual interdev come with frontpage? also has anyone used visual interdev, how cool, easy is it? Is it worth the $1,000? or only for large compaines.
I want to run an asp content management system. I was just wondering, does asp run ok on a linux based server with Microsoft FrontPageŽ extensions 2002?
A system I use uses advanced encryption for passwords. It was taken from some sample script and adapted some where. However this was I think intended to be for passwords. So nothing too long.
However the time has come where I need to create a function to encrypt a large amount of text. It has to encrpt a large amount of text but nothing too advanced is needed to be honest. Just so its unreadable because its written to a text file on drive. It has to be a function though then capable of decrypting the encrypted text.
Any ideas ? Again Dont have to be nothing too flash. I mean I had a go at just changing letters to different letters but the function got huge with all the replaces.
I have written some code which should dynamically build a table which is then populated with questionas and possible answers. The format of the answers will vary ie they may be in the form of a radio button which will be rated from 1-5, checkbox or a selectbox.
The first problem I have is if I do not comment out <select></select> I get an error message saying the page can not be found. when I do take it out I get asp timeout. Code:
I have only begun to look into ASP due to an assignments requirements.I usually code in PHP,one feature in PHP is to be able to do an if.else statement,where if a certain statement is true then a chunk of HTML can be outputted.
Basically I want to be able to do this in ASP to use with a simple authentication system which I will construct.I have just got a fat book on ASP,and am beginning to read through it
I am not an ASP programmer, but I need help with the syntax. I have a simple if/else statement that I need to translate into ASP. Begin Pseudocode
if { (id == 1,2,3,4,5,6), then print "Private" } else { Print <a href="https://www.mydomain.com/file.asp?ID=<%=rs("ID")%>" target="_blank">Register</a> } End Pseudocode
