Search results for query: *

I have 2 sets of checkboxes and I don't want the customer to submit the form unless they have checked at least one checkbox in either set. I am giving each set of checkboxes the same name because of the code used to send the information through an e-mail. This is what I have: <script...

I'm not sure how to do this but I have a database that has Incidents that have an IncidentID. There are usually multiple records for an IncidentID - they are seperate events for each Incident. I was searching for the records by the timestamp date but I wouldn't get all of the events for a...

I have a month and year that I am passing from another page and I want to compare it to the current date and even when they are the same it's not recognizing them as being the same. Here's the code: sMonth = Request.Form("Month") sYear = Request.Form("Year") CurrentMonth = Month(Date)...

I am trying to get an average of some fields and instead of 48.85 it's returning 48. How can I fix this?

I'm having a problem with using a matrix. It's hard to explain but basically I have two tables. I want the columns from one table to return rows in the matrix and the rows in another table to be the columns in the matrix. It works great when there is data for each one but if there isn't then...

I need to create a date that shows the previous month with just the month & year, not the day or time but actually use the month's name instead of the number. I used the following to get the previous month: =DateSerial(iif( Month(DateTime.Now)=1, Year(DateTime.Now)-1, Year(DateTime.Now)), iif(...

I have a monthly report and the user needs to select the report they want according to the month and year. The user will generally be wanting to view the previous month's report but they might want an older one. The first report generated was for October 2006 but when 2007 comes real soon I...

I have a varchar column in a table that holds the month and date of a report. In order to retrieve the reports that were created this month I need to do the following select statement: Select * From tDbhreports Where RepPeriod = '10/2006' However I don't want to hardcode the date. I need it...

I can't figure out how to get the new Request ID from a Private Function in a class. It is called from a Public Function but only checks to see if it True. This is the original code. I'm only including the pertinent code: process_scripts.asp <include file = func_lib.asp> errMsg =...

I have a form that I'm having a problem with. I need to return the values that are in the database and have blank textboxes for those fields that don't have any values for adding more later (with a total of 12 textboxes). The only way I can think of to do this is to have the variable name...

I have a form that has 5 text boxes that each need to be filled with 4 random numbers when one button is pressed to generate them. I don't know Javascript that well so I researched on the internet and found some code to generate random numbers. The code looks like it should work (from my...

I'm trying to do a loop but it's different than others I've done. I need to loop through a recordset of Case ID's that are sequential starting with #1 but some of them have been deleted so I need it to get to the next available number. In other words I might have these numbers in the...

I'm having a problem entering a Null in a date field when the date is not available yet. I tried the following: If "WribRecd" = "" Then objCmd.Parameters.Append _ objCmd.CreateParameter("WribRecd", adDBTimeStamp, adParamInput, 4, DBNull) Else objCmd.Parameters.Append _...

I have a form that has two fields for uploading files but they need to go to 2 seperate directories. "Attachment" should go to the "documents" directory. "ExamFile" should go to the "tests" directory. I've been researching it and found some information about it but I still can't get it to...

I have a page that has two date fields (for a date range) and a drop down list. When the page is opened, it defaults to a date range of the last 30 days. The drop down list defaults to "All" so it lists all records for the last month. The user can change the dates and/or the specific...

I have a form that has one section that has 8 rows on it for a user to input Section Titles and Number of Questions. They have the ability to enter some of the information, save it and return later to add more information. If, for instance, they have only entered 3 rows into this section, I...

I need the items that were already checked to appear checked when they open the form again for updates. However the way I have the code it only returns the first one that it finds. I need it to look for each of the three options and have them checked if they are in the field. Here is what I...

I need to retrieve a SQL generated value but I can't get it to work because I'm also returning an Identity. Here is the stored procedure: CREATE PROCEDURE dbo.stoAddRequest @YearMonth int = Null, @JurID int = Null, @Title varchar(100) = Null, @ReqType varchar(50) = Null...

I have a form that has a drop down list that I am getting the values of from the database. It also runs a query when opening to list all entries in the database. Now I need to send the value of one of the items selected in the drop down to narrow down the list using a "Go" button. I had it...

I have a parent table that has a primary key of RequestID. I have 4 other tables that use the Request ID as a foreign key. Unfortunately during testing some records were entered into the parent table but subsequent records were not entered into any of the other tables. The way I originally...