Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ItHurtsWhenIThink

    HTML5 datalist

    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...
  2. ItHurtsWhenIThink

    Grouping Issue

    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...
  3. ItHurtsWhenIThink

    Evaluating the alias

    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...
  4. ItHurtsWhenIThink

    asp/java mix

    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...
  5. ItHurtsWhenIThink

    java/asp mix

    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...
  6. ItHurtsWhenIThink

    Hide/show table rows

    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...
  7. ItHurtsWhenIThink

    Using Distinct and count in same query???

    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...
  8. ItHurtsWhenIThink

    allowing carriage return in regExp

    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...
  9. ItHurtsWhenIThink

    form Value changes as its passed to a variable

    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...
  10. ItHurtsWhenIThink

    Cancanate fields then search by new field

    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...
  11. ItHurtsWhenIThink

    Distinct query issue

    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)...
  12. ItHurtsWhenIThink

    Advanced SQL Generation Options disabled

    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...
  13. ItHurtsWhenIThink

    connection sql to membershipprovider

    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...
  14. ItHurtsWhenIThink

    Is the Right Join the WRONG Join??

    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...
  15. ItHurtsWhenIThink

    manipulate string using non-sql function

    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 .....
  16. ItHurtsWhenIThink

    date value increments by one when updating

    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...
  17. ItHurtsWhenIThink

    Select calculation issue

    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...
  18. ItHurtsWhenIThink

    Replacing Null value in query

    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...
  19. ItHurtsWhenIThink

    Grouping By Aggragate Function

    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...
  20. ItHurtsWhenIThink

    I think my INNER is out

    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...

Part and Inventory Search

Back
Top