Search results for query: *

Hi there, I have the following script to validate a form radio button. The visitor is registering for a class and they must choose a class before moving on. This script works great with a list of items but if there is only one item and even when it's selected, the alert box comes up anyway...

Hello, I have a timekeeing application that "they" want to change. At first there were only a few users, but now there are more users and somebody has cheated. Right now I have a form pulling from a table with the following fields: time_in time_out task job number The time_in box has a drop...

Greetings, I am using a sql view to extract a list based on a zip code input. This works but it's slow because of the enormous amount of records the query has to look through. Is there a better way to do this and if so, how? I am not familiar with stored procedures or how to write one or call...

Hi guys, I'm not a javascript guru at all, and couldn't find a thread that helped, but I have a script when you mouseover a button, a menu slides out to the right. Works great on my 17" monitor, but on a larger monitor, the slide out menu is covering the button. Finally figured out I have the...

Hi there, I don't know how to search for this and I'm Javascript challenged so hopefully somebody here can help me. I have a navigation bar with images for buttons. The site is ASP and data driven. There are three categories that have sub categories and the client wants me to create a slide...

Hi all, Company is moving site to a different host and moving SQL server in house to save $$ (no laughing please). I think there will be a slowdown in performance. Any thoughts of how to generally optimize performance in the site? I know this is an open ended question, but there is a lot we...

I originally posted this in the ASP forum, but they suggested I try here. This is a weird one. I have a sql 2000 table with telephone billings from sept-oct. When I execute the following statement, I get the time column mixed in with the phone number column. When I remove the word distinct...

This is a weird one. I have a sql 2000 table with telephone billings from sept-oct. When I execute the following statement, I get the time column mixed in with the phone number column. When I remove the word distinct from the query, I get only the phone numbers. What's up with that? I...

hello everyone, question about the following code. Is there a way to sort these files by date descending? i.e. the files that display from this code are weekly timesheets and named by the date, so january's would be 1-1-2004 but since they are sorting by name, the most recent is at the bottom...

Hello there, I'm using the following in active server pages that calculate prices on lumber when orders are created. The user adds an item and quantity and the calculation is made. I'm not proficient with stored procedures, but would like to know if it would make more sense to write a stored...

Hi there, this is probably too complicated to post but this forum is so helpful, maybe somebody can point me in the right direction. I'm converting an application that allows the user to create lumber orders. There are 5 different formulas to determine pricing, i.e. SF, MBF, CSF, etc. Each...

Hello, I am setting up a page where customers can look up their customer number by entering their first and last names, but since some have the same first name and last name (i.e. kim brown), I would like to partially display their email address but put * before the @ sign so their entire email...

Hello, I'll bet this is an elementary question. I have a text file I am converting and posting to a SQL database. But the first 15 records in this text file are going into a NOTES field in the SQL db and I want to append all of these together before I post to the database. In other words, I...

Hi there, How would you determine the current date plus five days in advance? Like today is date() and I need date() + 5 days? Thank you very much.

Hello, I am trying to do some dynamic content editing and have a few fields that were inserted from a dropdown box. When the user wants to edit the record, what is the best way to show the dropdown box dynamically. i.e. my code is like this: set rs=db.execute("select * from workstations...

Hello, I've spent way too long trying to figure out how to group products with their categories and THEN show a subtotal at the end and show it all in a report. I have a list of products sold in a date range. They need to be grouped by category, grouped by product and show the total items...

Hello, I have the following code I use for previous and next buttons with a table that has an autonumber field as the primary key, so aff is numeric. Simple and works fine. aff=Request.QueryString(&quot;aff&quot;) nextaff=aff+1 prevaff=aff-1 response.Write &quot;<td valign=top><input...

Hello, I have a table that collects the username and date/time they logged in and logged out and the session id. How would I calculate the duration of their visit? Thanks for your help! charles

Hello to this great forum. I'm new here so please bear with me. I know about =, >, <, and <> but is there an operator for &quot;like&quot; in an IF statement, as there is in a SQL statement? Here's what I need: I'm using: for each fld in oRs.fields if fld.name &quot;is like&quot...