I am trying to run an update statement to show a value on a front end ASP page. What I would like to see is if the value from the update statement in null I want to display a zero on the front end.
I wrote this statement and thought it would do that but it still doesnt appear as a zero it just shows nothing because null cannot be displayed. Code:
iis runs on win2k3. i need to have a web-based app that among others does something like this:
1. login - validate against the local user database.
2. user must belong to a certain group (say backup operators group).
3. create a web-based front end to the task scheduler. create, modify, delete schedules.
i dont have a starting point with regards to the three requirements.
Currently working on transferring site to a new host. Site uploaded, but we are unable to browse asp pages ?
View Replies View RelatedWe've recently rebuilt our entire website with a normalized database
structure (previous structure was horrific). The structure is great now,
but we also recoded approximately 5000 ASP pages. Site went up today with
minimal difficulty (probably 10 minor problems). Then, at about 4pm, the
entire web server locked up and we weren't able to access it. I couldn't
get into it via remote desktop, explorer or any other means and the site
locked up entirely. Any idea what could be causing this (outside of a
fluke)?
I always heard people saying IIS ASP front end, and MS-SQL back end. ASP is
for server side programming and dynamic content generation, how could it is
called front end? Because I thought it is executed in the server, which is
back end? I think I am confused with the term front end and back end here.
iis runs on win2k3.i need to have a web-based app that among others does something like this:
1. login - validate against the local user database.
2. user must belong to a certain group (say backup operators group).
3. create a web-based front end to the task scheduler. create, modify, delete schedules.
i dont have a starting point with regards to the three requirements
I have a website using ASP. All the codes are written in Front Page (Microsoft Office for Windows XP).
I want to use Front Page 2003 and Microsoft Office 2003.The website codes are going to transfer to the Front Page 2003.
Would it going to be a problem since all the codes were originally created in Office for windows XP?
I've been charged with coming up with an application that would allow a user to type in a social security number, have a page retrieve the person's information from a SQL Server DB and then convert that information to an XML file. Has anyone had any kind of experience.
View Replies View RelatedI have my database created and i need to do the front end of it on the website but i have no idea how to get the information from the database to the website.
View Replies View Relatedinserting a 0 in front of a number? i dont think i can do it with data type "int" so i changed to "nvarchar" and for some reason upon inserting it still takes the 0 away
inserting - "0600" for example.. only 600 is inserted.. but if i manually input it it works.. errrr
I have created a workorder form on Front Page that employees use to send in computer and other maintenance problems. In the form properties, I can choose to send the data to a database OR send it in an email, but can not choose both. We have it going to a database so we can better manage the data. But we would also like to send an email notification when a new record is added to the database.
I've tried this in Access on the database end but came up emptyhanded. The Access gurus have suggested it's something I need to do in html on the form. My html is very limited so I'm hoping someone can tell me if this is possible, and how I would go about doing it. The HTML gurus suggested it was an ASP issue.
Why is it when I enter a date in a date field and update, sometimes it will be displayed in US format (month, day) and sometimes in English (day, month) and is there any way around this?
View Replies View RelatedOur application launches a webbrowser window with a command to (more than
one) asp's on the host. The window is reused for subsequent commands.
Unfortunately, the old window is usually underneath some other window and
unaccessable from the application.
Is there (preferably) a browser-independant method to command the window to
front from the asp?
my site (which I am currently redeveloping) has 3 different sections to the site. All which well contain different information.
What I want to know is how can I make the starting page of the site display information which the users is looking for.
eg. if the user always go to one section of the site the main page well show information relevant to that section. (I hope you know what I mean)
So I was thinking about how to do this and this is what I came up with.
Set a cookie for the site and each section has there own number value (eg. 1 to 10)
When the user hits the main page it gets the values of all 3 sections from the cookies and checks which has the most value (eg 3, 5, 10).
Based upon the highest value each section has there own .asp include which is shown to the user.
i wanna connect front page forms with the database for searching and updation .. how can i do it.. in asp it ask to host the web it doesn't works on disk drive..any one help to solve this proplem..any alternative
View Replies View RelatedI have 2 webs under my default web running win2003
1. A front-page intranet
2. A asp (not .net) web is fine
Both allow anonomous access. My front page web always gets a BLANK Request.ServerVariables("Logon_User"). The asp web gets the logon_user OK. Both webs have a global.asa that has Code:
I have FrontPage 2003 on my XP laptop. I need to test some web pages with *.asp codes which worked perfectly well with my old Win95 computer in the past. Of course I had to install Personal Web Server to it in order to do the job.
The help files of FP, gives the clue that it has the facilities to behave like a server and test interactive web pages. But I haven't seen the use of ASP pages with it. I do not wish to install a server on my XP just to test ASP pages.
I m using front page. I have used some button and value of all button is different so its width show different. I want to equal width of all buttons. I dont want to use link button.
View Replies View RelatedI'm trying to put the 4 latest(by publication date) articles published in my press table on the front page of my site. What's the logic here:
Show only the 4 latest articles
and if there is no addition to the article db:
Show latest articles for 1 month.
I have installed Front page server Extention on IIS 5.0 it was working fine.
I was able to load project from Visual Interdav and doing well. Yesterday I
installed a security update from Microsoft and after that every thing stop
working and I am getting the error below when ever I am trying to connect to
server using V Interdev. Error Shows that FP Server Extention is not
installed but its there even I removed it and installed it back error is
still there.
"An HHTP error occured. The server could not complete your request. Contact
your Internet Service Provider or Web Server administrator to make sure that
the server has the FrontPage Server Extensions installed, and that the Web
application exists on that server" Code:
I m using front page. I have used some button and value of all button is different so its width show different. I want to equal width of all buttons. I dont want to use link button.
View Replies View RelatedI want to call a recordset so you can edit the details and then obviously pass the parameters onwards into the db. However, the user guide just says this:
To process other fields in the form, use the Form collection of the upload object the same way you would use the Form collection of the Request object. For example, if your form had a text element named UserName, your processing code would include: Code:
i need to convert the escape values which are by mistake updated in DB.
example:
this is a sample text string
is updated in DB as
this%20is%20a%20sample%20text%20string
here %20 is the space.
like wise there are many entries for :,'
is there way that i can update all this in a update statement?
or use asp to to update the records?
I have a variable SET which has the value Of 1, 2, 3, .., N.
SET=val1, val2, val3, val4, ..., valN
What is the commend or procedure to extract individual values, val1, val2, ...
Well, my script consists in check if the typed code doesn't exist in the DATABASE, but thats not the problem... the problem is that the PAGE1.ASP (that check the code) redirects to the ADD.ASP that will add those codes to the database!
Response.Redirect("add.asp?cod_1=" + cod_1 + "&cod_2=" + cod_2 + "&cod_3=" + cod_3 + "&cod_4=" + cod_4 + "&cod_5=" + cod_5 + "&sexo1=" + sexo1 + "&sexo2=" + sexo2 + "&sexo3=" + sexo3 + "&sexo4=" + sexo4 + "&sexo5=" + sexo5)
That's the line in page1.asp that redirects to the add.asp. So, when the database is completed empty and, the page1.asp checks that there ins't any problem with it and redirect to the add.asp that doesn't update my database!! So, it continues without any record. But, if the database has, at least, one record, the script works normally without any problem!
Another thing that I noticed is that when I, manually, type the adress Http://127.0.0.1/add.asp?cod_1=176096, for example, and the the database is empty, the script does the UPDATE and adds the code to the table!
I have no idea that the problem is. Does any one have a clue?
The goes the add.asp script: ....
I'm not sure if this is an ASP thing, a IIS thing, or a GoDaddy (where my domain is registerd and forwarded from) thing...
First I'll start by saying I run my own Windows XP web server and do all the coding myself..
I've noticed in the past (and never really gave it much thought, because the site works fine), that when I switch pages within my site, that the URL line is not always updated.
For example, I go into the pictures section, view a few pictures, then select the "Home" tab... The URL will stay with the variables that were passed when I was viewing the pictures. Therefore, if I do a "refresh", the page goes back to the pictures I was previously looking at, not the home page.
I've tried this on multiple computers at multiple sites, and with multiple browsers... And seems to happen rather consistantly...
Anyone have any thoughts?
I am looking at updating a notes part of my data base. I am calling two fields (first name and last) from the data base and putting them into read only text box (as i dont want the details changing). All of this is contained within a form. I am also calling a feild from the database called notes which originally has been inserted using a <textarea> tag. The problem i face is that you cant put values into a <textarea> (ie. i can put data from the database into the value tag of a textbox but <textarea> doesn't have a value tag). Due to this i am putting existing notes onto the page as text. Under this i have do have a <textarea> to put the new notes in.
The problem i have is that i some how need to store the existing data in the notes field and then add it to the new notes that i will be adding. I just don't know how to put the data i am getting from the notes field in the database into a variable.
Having problems writing an update script because in one of my fields I'm adding a chunk of HTML that contains ' characters. Obviously this throws up an error. How do I get around this?
View Replies View RelatedI'm trying to create and assign variables with the values from my db but can't work out the code getting my " & ' mixed up.
i = 1
do until i = 6 or rsSet.EOF
rBlock(i) = rsSet("rBlock'" & (i) & "'")
i= i + 1
rsSet.MoveNext
loop
whats better ADO or SQL
for example, an INSERT statement or an objrecordset.update blah blah?
same with .net
should I C# to update or SQL
I have an XML file which i'm trying to append elements to using an html form and ASP with javascript scripting inside the ASP file. Code:
View Replies View RelatedI have a function below that works fine. It takes a XML dox parses it, etc.
What I need to do is after the update of a record, I need to query the same table again for another record. If it finds this second record, I need to update it.
The problem is I can't get it to work, mostly because I don't completely understand the .open() method. Can I requery and the test for the existance of a returned record - if so how? Code:
I placed a post a couple of weeks ago discussing how I was having trouble using ASP and the XMLDOM to differentiate between the text content of Parent and Child Nodes in an XML file.
ie:
IF PARENT.text > "" Then
'Do Something with PARENT.text
ElseIf CHILD.text > "" Then
'Do something with the CHILD.text
End If
The problem being that I couldn't differentiate between the text values of PARENT and CHILD.
I've managed to work around that problem in a fashion but I'm begining to think that I'm going about this with the entirely wrong approach.
All I want to do is edit the following XML file through ASP: * Note that there are attributes with values and some nodes and child nodes have text values as well Code: