I have an online application made up of ASP pages (IIS 5.0 on Windows 2000 Server) drawing data from a SQL Server database. Most of the time, everything works exactly as it should. Connections are opened to the database, queries are run and data is returned and writen out, connections are closed, etc.
However, every so often a page simply won't load. It isn't trying to load and then timing out or anything, it's like it's ignoring the page entirely. It shows the correct URL in the address bar of IE, but there's nothing but a blank white page displayed. Viewing the source of the blank page reveals that instead of the correct code for the page, we get this: Code:
I have a web site where I use cookies to navigate between the pages. The cookie is his id no which is nothing but his staff id no. All most all pages are dynamic and connected to sql server 2000 through ADOs. My problem is :
if any one logs in and enter bowse the pages and goes back uses other log in his old page is displaced rather than new one, untill he explicity uses the refresh button. Once he does that , it is working. Iam using javascript menus to navigate between pages.Previously when menus are not there pages were working fine.
Using IIS 5.0 and sometime some asp pages (absolutely randomly) showing as blank white pages. So far only one way of fixing it - restart whole server. Restarting IIS, or specific web server not helping, only whole server.
I enable server side and client side debugging, but no errors showing up...
In view source pages always look like this: ----------------------- <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=windows-1251"></HEAD> <BODY></BODY></HTML> -----------------------
We use Vignette V5.6 to display our site. In our CMA site, we have a page which has FRAMESET and in one of the frames we call a ASP page. There seems to be some problem that the frame shows the ASP page is blank. When we restart the IIS it works fine. But after some time it again shows the blank.
If we get one blank page, all the asp pages under the same virtual directory, called in the Frame shows blank. FYI. The Vignette template which contains the frame is marked for NO caching & For itnernal use only.
I'm trying to write an ASP interface that mimiks a .Net datagrid control. I'm having a problem when I'm in the middle of an Edit, Update, or a New Record.
If the user hits the wrong button, the program grabs the values in the textboxes using the request.form() and then redisplays them in the textboxes when the records table gets written back out to the page. This works fine as long as the form is submitted.
If it's just a page refresh (F5), the program doesn't get the latest changes to the textboxes and displays either a blank or whatever was in there the last time the form was submitted. Anybody got any ideas?
First I would question why you want to do this. If they get to the page by any means it should respond appropriately, whether refresh or by link. This is a stateless environment after all.
That being said...
I would take the approach of setting a session variable that gets set the first time they hit the page:
<% if session("NotTheFirstTime") = "" then 'write the onload session("NotTheFirstTime") = true end if %>
then based on that variable write or don't write the onload.
Of course, if the user can access the page from multiple links and the onload is valid for each link, regardless of how many times they hit the page, this won't work....
we're running IIS 5 and trying to do a simple update to a code behind file (Login.aspx.vb) we copy the file over to the server, but we're not seeing the updates. the server is still reporting errors on line numbers in the file that no longer exist. we've even stopped / restarted the service, with no luck.
i've created a simple web app that allows users to enter in information about a project in a web form and save that information to a database (Access). After a user enters in all the information, she can click on a link to go to an index.asp page that displays all the projects that have been added.
the problem i'm having occurs after the user enters in all their project information. when the user goes to the index page, the index page is suppposed to retrieve all records and display them, but it doesn't.
even after hitting the Refresh button in the browser, it won't display the latest project that the user just entered. however, if i add a second project and then go back to the index page, it will work fine and display both the first and second projects. so, it's like the first project won't be displayed until i enter in another project after it (like the first project is stuck). does anyone know what the problem may be?
What I need to know is how to click on a button that is labeled NEW, as in new record, and have the current form open to data input. That is a blank record. After the user then inputs the data to all the fields on the screen and hits the SAVE button the record will then be placed into the database table.
I am trying to use AUTH_USER from request.servervariables but the field is blank. I am using Windoze server 2003 with IIS5. I know there is a fix because I did it a long time ago with our old NT server running IIS4 but I cant remember how I got it to work. We are all authenticated users on our Domain so this is available, I am able to get IP info and such. I seem to remember some kind of ASP code that did the fix by altering the way the web server displays info.
I had a problem for a while where data was added on its own, and BLANK data. I found out it was because i was opening the processPage.asp to see if it was working, so that was inputting data out of the form that wasnt there. So i get blank data. Is there anyway i can make the process work ONLY if there is data in the form?? Code:
I am creating a directory of suppliers.I have a form that collects data - business name, address1, address2, town, city, county, country, postcode. The data is stored in separate fields in an Access database. Another page is used to display the data, one field per line. However, if some of the fields are blank, I want to suppress the blank liens as at the moment I am getting:
I have a drop down list, values coming from a db, when I come into the form I want it to have no value - how do I do this? Also, if I want to capture the value that a person selects from the drop down list do I need to use a session variable if I want to print it to the screen after they select it?
I want to clear the date in a field in an access table by entering a blank. Does anyone know the syntax for that in the select statement? This is via an asp page
The select statement I am trying to use <code> strQ ="Update Inquiries set ShutOffDate= 00/00/0000 WHERE CustomerID = "&CustomerID&"" </code>
I'm getting some errors in my .asp code somewhere but I can't seem to figure them out because all I get is a blank 500 error screen. I don't get any description of the error, just a blank screen so I don't know what the problem is.
Just wondering if there's a way to get the results easily because I do not have admin rights to the server so I can't make a custom 500 error page or i would.
All my fields give that error when I try to leave it blank when inserting a new record. The field is not required in the database, so what do I have to do to insert it as blank?
SQL:
Code: INSERT INTO Tablename (REQUIRED, NOTREQUIRED) VALUES ('tag', '') Error:
Code: [Microsoft][ODBC Microsoft Access Driver] Field 'Tablename.NOTREQUIRED' cannot be a zero-length string.
I am writing an application which when the code first loads there is a form which all the fields are blank. I then need to test some date fields to check if the end date is before the start date etc. The form fails to work. So I then wrote a test asp page which has a single box I then use an If...
Else statement if it is Blank then do nothing if it has data in the text box then display a message. The form works ok until I input text and then it does not detect any input text in it and therefore does not display the message. This is totally the oppoisite of the original application which does not detect the form is empty. Code:
I retrieved some data from the database and put it in a textbox but the words after the blank sapace cannot be shown, why is that? Name = rs("requestor") 'where the name is "Sam Siew"
Ok, I have two pages. One that displays the table (page a), and one that exports the table to Excel (page b). When you click the "Export to Excel" link on page a, page b automatically opens up the save/open dialogue box for the Excel document.
Everything works fine on my computer (whether you choose to open or save), however on MOST computers it seems, the Excel document is blank with the exception of the column headers. Here is the code for page b which does all the exporting. Code:
what i am trying to do is when the database field is empty to not display the box (table) that is in my css file, whereas when there's something in the field i would like the box to display!!! So i'm basically trying to get a 'when field empy, do nothing!!! my code at present generates the box no matter whether the field is full or not!!! Code:
How do I change a blank database entry, so when I retrieve it blank I output a string say <i>N/A</i> into a table? Currently I have an if/elseif/else like this.Code:
if tf.name = "ID" then Response.write(bla bla) else if tf.value = null then Response.write(bla bla) else Response.write(bla bla) end if
*Note, where the word null is, I have also used the string "" and it still does not work.
I'm using ASP FormMail to collect user info, but now I'm trying to figure out how to modify the code so that any blank fields from the form will not be displayed on the confirmation page/email. I tried to modify the code below in bold, but it gave me a syntax error. Code:
Just wondering if there is a way to give a default value to a form text box if it is left blank. I can set a default value for the textbox but then it shows up in the textbox and that is not what I want. I would like it just determine if the form is blank and change it to the needed value accordingly.
I'll ask a second part to this question as well in case I am going about this all wrong.
What I have is a search page where a user can search for names from a database. However if I have 5 textboxes of different criteria to search from then if all of them are filled then it would have to match a record in the database exactly....
but if only one or two textboxes are used then the other textboxes basically are now set to a wild card. In this case they would be "%". Also to make things more complicated I am using the frontpage DRW for the SQL query.
I have created a database were you submit a job by entering the fields which is fine if it is a site visit but if it is a phone call or remote help not all the fields need to be filled in but if there not filled in it wont submit the values to the database i get data mismatch error code is below.
I either need to be able to send them blank values to the database or ideally i wont to create a option box with Phone call, Site visit and remote help which when selected takes you to the correct page which have different values in the form to fill in.
