I've been using text files for Tab-Delimited/ADO/ASP sites so that users can update and display their products lists through my system with relative ease.
Only problem is that for the last few months or so, this system has been generating loads of timeouts. ISP has said that I should be looking to upgrade my system, as it is the mechanics of it that are creaking under the strain. My queries are:
a) Which REALLY performs better OLEDB DSN-less or ODBC DSN-less?
b) If I convert the system to use 1 Access DB rather than 50-odd tab-delimited text files will this REALLY perform better in relation to timeouts?
To give you some idea of the problems, the site can viewed by going to www.bardwells.co.uk and clicking the Product List link.
I just can't understand it because the pages on the whole are very lean and zippy (esp. ADSL), but its these exact same Broadband users who seem to have more trouble with timeouts than dial-up ones.
in one of my sql queries on an asp page i am trying to select some data from an access table. The problem is the search criteria is based on a yes/no field. I need to find any record where the value is null or true. So far i have this:
if ISNULL(orseof("Returned")) OR orseof("Returned") = True then
the ISNULL section works it is just the = true bit that doesn't.
How can my ASP serverscript read a JPG file and create a small thumbnail image? I don't mean simple resizing, but true resizing so that the image actually gets smaller in size. Is this possible without the use of a 3rd party component?Does anyone have a code example for me?
If response.buffer is set to true, and no response.flush has been executed, is it accurate to expect that my browser should not be rendering the content which I (well Ok, someone else) is sending in response.write statements?
i m trying to create a true and false quiz which accesses the questions from a access database processes the results and then writes back to the database
I dont know how to structure the code for the radio buttons,i also need to give the user immediate feedback, but i cant use pop up boxes
I am struggling with opening a database and reading data from it via SQL. Please tell me what is wrong with this code. I am trying to open up different tables and get information from them and put it on the one page. Code:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
This is the error I recieve when trying to run my site. I know why. I am passing a non existed URL Parameter. However I would like to recieve a MsgBox that says that such record doesn't exist. Code:
I have several pages I set up in my web site and I am having trouble with two of them - search and results. The stat_search uses a form which seems to work right and when I test the recordset on the stat_results page and enter a value it returns the right results.
When a value is entered from the stat_search page the results page displays the records with the right value and the Records _ of _ indicates the right number of records but when I use the Next or Last arrows to move to the next record I receive the ADODB.Field error. Code:
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/ism5315/readtrends.asp, line 46
What I'm trying to do is select the records from my table that match the sensor and gauge the user selects. I have time fields that are optional, and I'm trying to get the page to work if the user selects no time frame first.
Of course, there can be mutliple records for the gauge and sensors, so I created a loop that should run thru and select them all. But I am getting the above error. But I know I am getting into the loop because I have included a response.write sql to verify I am selecting the correct objects. Code:
Here's what I want to do (i'm kind of there in JavaScript, but want to move it to ASP).
I have 17 different html pages. quiz1.html > quiz17.html.
The user says take a quiz and it pops up a window holding quiz1.html.
Within each page is a true/false question. Upon answering the user is told:
1. what they answered. 2. if that is correct or not 3. a corresponding sentence about the question. 4. an image the corresponds to if they were corect or not.
(This is all done in javascript).
----
However, now I want to take these 17 questions and randomize them and choose 6 questions.
For example:
The window pops up and it's question 1 they do that then move to the next one. 1-6 (random out of 17.
ADODB.Fielderror '80020009' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. /admindemo/profiles_browse.asp, line 0
in my web page, i would like to user to see a ticked checkbox should the database = True however, i cannot seems to be getting it. Would anybody be able to help me out? Code:
I have a big asp file that has an error under certain conditions -- totally repeatable. However, it only fails when I set response.buffer = True at the top. WHen I set it False in order to debug it, it works every time! I even set it to True, but did a .Flush just before the error, and the error won't happen.
It only happens when response.buffer is True and no .response.flush is issued.
The error is a string variable turns-up empty and crashes a function requiring a date. I could test for this before the line where it crashes, but where did my data go? Why is the buffer affecting it?
Is there a way I can assign a value of true or false to a VBScript variable? I have a function where I want to initiate a value of false: Would this work? Code:
One of my fields is the customer's social security number, all originally entered as a 9-character string. How can I split and display that into 3-2-4 format?
What I need to do is get the content of a text file, one line at a time, and break it up using , as a delimiter.
So far I can open the file and print out all the content, but all I am getting is a million ???????'s on the screen, and not the file. Here is what I am using: Code: