We are currently facing a strange problem. We wrote an ASP application using some sessions and database-connectivity, nothing special.
On some machines (we are all using IE5.5 / IE6) those applications produce a 404 error.
The pages that are called do exist (I checked it thousands of times and it is only happens on some machines). Most of the machines have no problem with that pages and do not produce any errors which makes me belive that it is no real programmed problem.
The strange thing is that a reinstallation of IE mostly helped and if not we reinstalled the complete computer (as you can guess this is no real suitable way.
Maybe it has something to do with the sessions we use, but they are not so big.
I hope (not for the one who really has) that somebody has also experienced this kind of problem and can point me into the right direction.
I also tried different IE newsgroups but they had no idea, that's why I now try to ask ASP-programmers.
I have a table with one header, everytime I use this code (below) it returns EOF and I know for sure there is at least a zero there:Code:
set rs = server.createobject("adodb.recordset") rs.open "SELECT myonlyheader FROM mydatabase", "dsn=whatever" response.write rs("myonlyheader") rs.close set rs = nothing What am I doing wrong here?
I have about 26 checkboxes that place all of my contacts into categories so in my database for contacts i have a field called categories that contains all of the categeories that each contact belongs to seperated by a ",". 1,5,17 etc.
I need help getting these values out of the database so that when I user select category 17 they get all of the contacts that containg the 17 in their respective categories field.
On a site I have written some of the page's sometimes fail. It's where I have a currency in a text field - when the user attempts to update the value, the page throws an error. I have traced it down to being sometimes the currency is written as £60,00 instead of £60.00. So for some reason they're getting a commar instead of a period.
This only happens occasionally - the rest of the time the page works fine. The system the person is using doesn't change, and none of the code is changing. I've used FormatNumber with the paramaters of 2,,,0. Anyone had any experience of formating of currency just changing?
I have developed an ASP application that can send as much as say 150MB of XML data to the client, if all records (approx 6,000) in the database are returned. Normally, users would choose filtering options and at most about 500 records would be returned at any time. It is rare for this volume of data to be download, but it can happen
My application runs on a corporate intranet. A rival contactor's 'expert' believes that it is intolerable for my application to generate this much data under any circumstances as it would unduly load the network
Ofcourse it is a simple matter for me to elimate large volume transactions by limiting any client request to a lesser number of records. If they really wanted all records several transactions would be necessary. That is, a paging mechanism could be provided
Given that there are many very large documents, pictures, and other media held on this intranet server, which users can view at any time I don't perceive this as a problem. Its pretty much a double standard. Also, the server script timeout prevents the server from being overloaded.
I am recieving the Microsoft JET Database Engine (0x80040E14) Syntax error (missing operator) in query expression when updating data that contains single quote marks, for example: Code:
I'm using Query String and using arrays to select data for a flash file.The 'type mismatch' is where my array starts.I'm not sure i'm using it the right way or not?
I am receiving the following error when attempting to insert a new record into my database
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC Microsoft Access Driver] The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
The code below works 1st time through, but on the 2nd invocation (with TOTALLY different data), I get the above error message.
My database is an Access 2003 database, and everything else works fine !
Also, if I'm really trying to write a duplicate record, why doesn't it fall into my duplicate trap? Code:
A page I'm working on contains a registration form which is supposed to a) update an Access database using ASP and b) email the contents of the submitted form to the camp administrator.
This is my first experience with ASP, and with any kind of database interfacing language, for that matter. Currently I'm struggling with the record insertion. I'll worry about email afterwards.
I'm using Dreamweaver 8, which is generating all the code for me. I have a testing server set up on my local machine (in my working directory, in fact). I've told DW to connect to the databse (located in %siteroot%/database) through the testing server using a DSN (same DSN as on the web server). Code:
i have a access DB, and a asp page to add the records to the database, i work on visual interdev, i get error when i run the code as:
ADODB.Recordset (0x800A0CB3) object.provider is not compatible of performing requested operation. /project/addprocess.asp, line 37 'points to rs.addnew line
I have a very simple Access database with these fields:
ID | Team | Score
I want a user to enter the new score of the team into a form and then it's updated. All pretty straighforward - except I'm getting an error at the bottom of this page:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
I'm trying to create a piece of code that randomly selects a record from a database (providing the record has not already been chosen for any of the previous 4 sections). Here is my code:
I have a booking form, called classroomform. On this form the user requests a classroom number, location, date, start/end time and number of students.
As it stands, the data is submitted via a submit button and an insert query created using Dreamweaver.
I already have various validation on the form, such as javascript which error checks for invalid times etc and asp validation which checks for correct dates etc.
However, the final touch that I'm looking to do is to add some code to the form which checks for duplicate entries that are in the database. I basically want an error check which doesn't allow the user to enter a duplicate record that is based on classroom number, location, date, start/end time.
Code: SELECT * From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9 Now if i change this query to either of the below it reults in an error as nothing is puled from the database. Now if i run this query directly in Access, these 2 execute fine:
Code: SELECT Size From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9 Or to
Code: SELECT Distinct Size From Product WHERE CatId = 14 AND CatSubId = 13 AND CatSubSubId = 9 Size is a number (long integer) field.
Err.Number is -2147467259 Err.Description is blank. no description Err.HelpContext is 5003251
I have increased the script time out and command time out time and still the same thing.
I am using a Replace function to replace single quotes with double when submitting a text field in the database i.e. Replace (q, "'", "' ' ") which works fine. When I retrieve the field from the database which has apostrophe I am getting 'Object expected' error message. Is there a way to fix this?
This query sort on the basis of Lft and Rgt columns.
The name of the array is: aEmp.
My question here is how can I get only the LastName from the aEmp array into another array so that I can sort the names alphabetically and then display the employees in the alphabetical order.
Or is there is another way I could this by using the same array while keeping the lft and rgt sort of the query? If I sort based at the SQL query level, I can see the names sorted by the lft, rgt and lastname, but since the lastname is at the end of the sort list - it does not appear alphabetically.
In working with arrays, I have found that I am unable to dimension and array with a variable that has an integer value but I can redimension one this way. I haven't see any information that tells me if this is a requirement, although it appears to be because I get an error if I try it.
Ex.
Dim b b = 10 Dim a(b) ' this errors out but Dim a() ' this Redim a(b) ' works
I have been using recordsets to access data from a database.I then loop thru each row in a dataset and assign the values to the objects on my web page.The particular sql stmt that I have right now, only returns a single value from a database. I need to assign this single value to a variable in my asp code. Can I do this without using a recordset?
If I have to use a recordset, do I just do var1 = recordset("columnname") (I ofcource create the connection object, the sql stmt and stuff first).
I have an insert record form that posts fine to a db which automatically creates an ID how could I get the next page to do a preview using the ID just created by the DB to go to the right record?
I have a .asp page which lists a date, then a bunch of record lines for data that falls within that date, then the next date and it's bunch of data record lines. e.g.
Ship Date: 04/06/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx Data xxxxxxxxxxxxxxxxxxxxx
What I want is:
Ship Date: 04/06/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx 4: Data xxxxxxxxxxxxxxxxxxxxx
Ship Date: 11/07/04
1: Data xxxxxxxxxxxxxxxxxxxxx 2: Data xxxxxxxxxxxxxxxxxxxxx 3: Data xxxxxxxxxxxxxxxxxxxxx
How can I get these numbers printed againsts the records ?
I have a simple form submission but the problem is my SQL insert (or update) is failing if in the text field there is any single quotes (') I tried running the like replace(textfield,"'","") to just remove them but it will still error out on me. is there any other way to format the variable, do I need to use an escape character?
I am trying to send a 'single' data type to a sql server db cell that is formatted for 'decimal' from asp/ado code and it is converting it to an integer. Should I be using some other data type in sql server?
can i delete related data from 2 tables using a single sql statement? is my code correct? correct me if i wrong. i want to delete data where user click the delete link. Code:
sqlDelete = "DELETE FROM Reservation R, Quotation Q WHERE R.resID = " & request.querystring("id") & " And Q.resID = " & request.querystring("id")
