Is there a way to limit the number of characters shown from a db field on a web page. In other words, instead of showing the entire title of a work order, I may only want to show the first 30 characters followed by .... Does anyone know how to do this?
View RepliesHow would I limit the amount of Characters that show in the display:
[ <% =objRS("Title")%> ]
Like a Left Trim I only want 12 to 20 characters to show.
How would I limit the amount of Characters that show in the display:
<% =objRS("Title")%>
Like a Left Trim I only want 12 to 20 characters to show.
How would I limit the amount of Characters that show in the display:
<% =objRS("Title")%>
Like a Left Trim I only want 12 to 20 characters to show.
I am looking to return the first 50 characters from a database field. Does anyone know if there is a SQL function that returns a defined amount of characters from a database field?
View Replies View RelatedI'm pulling product descriptions from the database and would like to limit the number of charcters that is displayed. Also, I'd like to add ... at the end.
Something like:
This long text is boring blah blah blah
would dispaly as:
This long text is bor
I have a Visual FoxPro table with Memos fields, and when i insert into the table a value that cames from a TEXTAREA field on a form, give me an error. Why? if the table field is MEMO?
View Replies View RelatedI have an site that is running asp,sql server and iss.
The problem is, when I click on the any link, on the IE status bar it
says Done but there is just a blank page is shown.
When I refresh the page, it works and shows normally.
What would be the solution?
I have a script that uses filesystemobject that reads files from a given path, in my case images. It is runningon a server that is 2000 adv svr w/ all current patches.
The script prior to some patch updating worked fine and showed the pictures.
Now the pictures no longer show when looking at the source code the absolute path of the fileis correct but will not display the image. I tried it on another 2000 adv svr and the script worked fine. I cannot find the difference between the settings. Does anyone have an idea what could be happening?
I have a page "view.asp" that it would have it shows a notice, and it has a button in this same page that opens one popup "print.asp" with the same notice, only text for impression, but the problem that occurs is that when I am in view seeing id40 and clico in the button that opens popup "print.asp" that it would have to open the same notice, is opened the last inserted notice in the DB and not the one that I tava seeing in "view.asp", because this happens... Code:
View Replies View RelatedRecently changes were made to my pc. So I am now using another profile (which is a copy of the old profile), in order to enter a different domain when signing in to windows xp.
Since those changes, when I am trying to view asp pages through localhost, I am getting a 500 error, saying the page can not be displayed.
After shutting down and restarting, it works again (maybe a shutdown is not necessary, but only a reatsrt. I haven't tried).
When it was not working, I have checked the IIS and the directory "WEB SITES" state was "Running".
I do not remember anything regarding IIS, as I installed it a long time ago and once it worked, I did not have to do anything more. I do not want to reinstall, as I do not remember how, and it will take me a lor of time now.
i would like to sum the total of the Daily Sum Total Field name. Code:
View Replies View RelatedIs there a way to put a cap on the amount of lines you can type into a textarea?
View Replies View RelatedI need to populate a select form input (combo box) with about 22,000 rows of data. This is taking an unacceptable amount of time to load. And this data is only going to grow in the future.
I'm using a stored procedure to get the data. Not sure if that's the most efficient. I'm using classic asp. I'm open to any suggestions because I'm not even sure where to look to get options.
i have a textbox that has a value $6.00 for example the user has
to enter a dollar value which has to be less then $6.00 so for example if the user enters 4.00 an alert should be fired telling him he has forgotten his dollar sign ("$") then when he enters it properly like this $5.00 i have to check the value is less then $6.00 and it has to be done in javascript
the textbox which holds the $6.00 value is called saleprice
the textbox which holds the $5.00 or value less then $6.00 is called userprice
I've been working on a script that finds and updates a record in
database based on the user's input. When I try it I get this error:
Active Server Pages, ASP 0113 (0x80004005)
The maximum amount of time for a script to execute was exceeded. Yo
can change this limit by specifying a new value for the propert
Server.ScriptTimeout or by changing the value in the IIS administratio
tools.As I can't post a message for some reason whenever I try to include m
script in this message, see attached .txt file for code.
I want to calculate the sum of all invoices so to be displayed total sum of them
I'm trying with this: Code:
Is it possible to run a script after specified amount of time after login. I made an online test tool. I want to end the test after 20 minutes.
At present one who is writing the exam clicks this endtest script. I want to handle this from software, if he takes more than the given time.
I am using couple of dropdowns on a form which pulls data from one of our
tables.
The data list is quite large (500+) and it takes users a lot of time to find
the correct item. Users are getting quite frustrated using the dropdowns as
they have to scroll for a long time.
I have three text boxes. One text box holds a beginning date, a second holds an end date, and the third box holds the number of days in between. I would like the page to figure out the number of days in between the two dates without having to type in the number of days.
Is that possible to do without having to use some kind of confirmation page. I mean using a confirmation page would work also, but I wanted to cut out the number of steps that a user needs to complete the assigned task.
Text Box 1: Beginning Date
Text Box 2: Ending Date
Text Box 3: Number of Days in Between
I have been writing a photoalbum in ASP and I am trying to receive an undetermined amount of files.
A more detailed explanation:
The client side (Javascript) generates a new file upload box as soon as the file in the first box is selected...the name of the file upload boxes is bestand[] so that the input is received in an array.
Now I am trying to receive all the files with ASP and store them on the server....
I will need to send bewteen 2 asp pages very large amounts of data
what is the best way to send it and to read it?
for ex. I know this method:
For i = 1 To Request.QueryString.Count - 1
Response.write(Request.QueryString.Key(i))
Next
how can I make an if condition where the condition checks has the user inputted atleast 3 numbers in the text field. Code:
if variable1 < 3Numbers then
response.redirect "error.asp"
else
execute something
I have fought with this problem all day long and I can not get this work.
unable to reterive large amount of data(100k) from a textarea control using request object in ASP. It gives runtime error.
View Replies View RelatedI have an ASP app that allows administrators to add articles to a database for viewing by the public. What I want to do is display a summary of the article and give the user the visitor to the website the option to click "more..." to view all of the article.
View Replies View RelatedThis is my first asp form so please be gentle with me It's a publications ordering form. I've got the form and the asp code setup, when the form is sent the name of the publication comes through but not the amount ordered - i'm sure i've made a simple mistake somewhere - can anyone spot why the order amount isn't coming through. Code:
View Replies View Relatedi wirte SQL statment to collect information from oracel database but after 5 minutes i got the following measage
Error Type:
Active Server Pages, ASP 0113 (0x80004005) The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools. Code:
The problem concerns 2 tables, cart_products and cart_shoppingcart.
Cart_products contains all the product data (eg, prices, product's key name, etc), but most importantly, it contains the quantity of stock (prod_quantity) for each item.
cart_shoppingcart contains all of the user's items in their shoppingcart, including those that are part of an (customer) order; these have the order_number to differentiate from those that aren't in any order (their Order_number is 'no_order', the others have the order number).
Now, what I want to do is this:
For every item in the order (ie, every entry in cart_shoppingcart that matches the username and order number), take the quantity (x) the customer is ordering, then take the quantity of stock remaining (y), then subtract x from y to create the new stock level (z) and update the appropriate record in cart_products with z (all this with SQl preferably).
I was thinking of using a Do while loop, but realised that it wouldn't work as I'd have to use several SQL statements and then I'd run into a problem the minute ASP reads "objrec.movenext".
I got a access file with about. 90+ "posts" or what they are named. But my asp site only list the 50 last.. Any1 know why? Code:
View Replies View RelatedHow can i limit the number of users on my .ASP page, i want only one user to
be using the page at a time,
The query i have on my page is big and takes a lot of my system resources.
I have an HTML form with a textarea. When passing large
amount of data in the textarea, the Processing asp pages
catch an error message as follows:
Error Type:
(0x80020009)
Exception occurred.
The error is generated once the trim or length or replace
function is called on the field when long text is passed
in the textarea.
Is there a max limit on the string length that these
functions can process? What else can be done to done to fix this problem?
I am trying to figure out how to create a
registration form that can limit that amount of people who are signing
up for an event.
The form has to take in consideration the number of
guests the attendee is bringing table seating location. How can
interact with the database in order to do this. I know how to create a
form and send that information to a database.
Anyone used LIMIT in their queries before?? I've been reading up on it, but all of the examples I tried don't seem to work. Here is what I have:Code:
Set rs = CatalogCS2.Execute("SELECT * FROM products p " & _
" INNER JOIN applications a ON p.prodcode = a.prodcode " & _
" INNER JOIN inventory i ON p.prodcode = i.prodcode " & _
" WHERE DATEDIFF(d, a.app_launchdate, getdate()) <= '30' " & _
" ORDER BY a.app_launchdate DESC LIMIT 0,10 ")
Seems pretty straight forward, but I can't really find any good articles on it.