Search results for query: *

I'm just playing around with new html tags. Here is my first experiment, dynamic list box. Here is my code: <input list="frmUsers"> <datalist id="frmUsers"> <% sql="select FName+ ' ' +LName AS FullName, UID from members" Set rs = Server.CreateObject("ADODB.Recordset") rs.Open sql, conn...

Hoping someone can help. I am trying to create a record set with a list of hours worked. The results should produce a list sorted by last name, first name and total hours worked (by work code) so, I could see same name twice (or more) if they worked say overtime and ExtraDuty. Tables (with...

I can't seem to be able to evaluate an alias. I get the following error: ERROR: Invalid column name 'HydroDue'. Error Code: 207 I want to be able to get recordset of all bottle that have past their hydro date. I take the hydro date (last hydro) and then add the interval 'HydroInterval' and...

I need to retrieve a form field name from my page and dump it into some java script. The form fields are created dynamically in an asp page. here are the pertinent parts of the code: chkLeave(var) { if (window.document.form1.frmLeaveCode.value==window.document.form1.frmCode.value) So I...

I need to retrieve a form field name from my page and dump it into some java script. The form fields are created dynamically in an asp page. here are the pertinent parts of the code: chkLeave(var) { if (window.document.form1.frmLeaveCode.value==window.document.form1.frmCode.value) So I need...

I want to hide a set of table rows and have the ability to open a set as well. I am working with a dynamic table. So the rows I want to hide or open will have the same "id". I want all the rows with the same id to close or open. The problem I have right now, is that only the first row will show...

First, I thought that table I created was just going to track birthdays and then my small simple task grew. At first we just wanted to remind teachers of their student birthdays, then we added other data. I would have created a totally different schema had I known. But, here I am. We decided to...

I have the following expression, but need to allow carriage return. I have read several sites regarding this but can't seem to get a grip on how to do it. Can you please help? Current expression:"^[a-zA-Z0-9.,_ \-\r]+$" I need to add carriage return which is '\r' I just can't seem to be able...

This has happened to me a couple of times. Not sure why it happens. Here is what I have The form value entered is: 1/15/2011. Date doesn't matter. it happens with any date. when I process the form.... strD=Request.form("var") now lets spit out the results response.write(strD) will spit...

Here is my MS Access query: SELECT name_last, name_first, street + " " + Type AS NewStreet FROM Voters WHERE NewStreet IN ('canyon LN','Crest DR') When I run this, the "Enter Parameter Value" dialog box pops up. (for a value to use in "NewStreet") Any suggestions? My problem...

I have a very simple query. But, it just does not provide the results I want. Need to query table and get rows with distinct phone number. Do not want duplicate phone numbers. Here is my query that looks like it should work. Currently gives my duplicate phone numbers. SELECT Distinct(Phone)...

VS2010 will not allow me to use the ASGO when confuguring a data source for a FormView. Not only that, but I only see table that I created. I do see views as well. I just spent a S--- load of time scouring the web for answers. Some say the problem that it reuires a key to be selected in the...

I just can not seem to get this up and gong. Using Visual Studio Pro on net 3.5 ERROR: The following message may help in diagnosing the problem: The connection name 'FormsDemoConnectionString' was not found in the applications configuration or the connection string is empty...

SELECT U.FName, U.LName, U.EmployeeID,U.UserID, Count(D.DrillTime) FROM tr_Drills AS D INNER JOIN Tr_Individuals AS I ON D.DrillID = I.DrillID RIGHT JOIN Users AS U ON I.MemberID = U.UserID WHERE D.DrillTime>=3 AND D.DeptID=1 Group By U.LName, U.FName,U.EmployeeID,U.UserID Order By U.LName...

Is it possible to manipulate data using a non-sql function. Need to encrypt data to my recordset. Have to do it through sql statement. The encryption function is my own. I was hoping to do something like: Select MyEnctrypt(id) AS Eid FROM .....

Do not know why, but when ever I update a record (specifically the date colomn) the date gets incremented by one +1 day. I know that the value passed to it is correct, but when it updates the value to the database it just adds one day to the date value. I've pulled much of my hair out, all...

I'm trying to do a calculation within my select. strDate=DateAdd("m",-6,date) SELECT PPE_Manufacturers.Manufacturer, PPE_Inspection_Elements.Element, PPE_MFR_Models.Model, PPE_Items.MFR_Serial, PPE_Items.MONTH_YR_MFR, PPE_Items.MONTH_YR_MFR + PPE_Inspection_Elements.LifeYrs AS PLife...

I need to repalce a null date with a date plus 10 days. Here is what I thought would work. sql="SELECT App.PMDate, App.Title, App.Event, App.PMEndDate, App.PMRecur," sql=sql & " Uni.FDID,App.UnitID, Uni.VehicleID" sql=sql & " FROM AppPM App," sql=sql & " Units...

I need to group by an aggragate function. I have a bunch of users and I need to add up all their points, whether or not they have any. Need to list all users (and only distinct), then I need to sort by Points, Last Name. Here is what I have. It has two problems. Unable to get all users and can...

I can't seem to get the "between' to filter the date range needed. Can you tell where I'm screwing up? Here is the statement: select * from(select Distinct(Users.UserID),Users.UnitID, Users.LName,Users.FName, Users.DeptID,Users.Shift,LeaveRequests.Leavedate,SUM(Leave_Points.Points) over...