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

    help with query -- distinct count

    Thanks! Over-thinking on my part again...[sadeyes]
  2. mrDrive

    help with query -- distinct count

    Hi, I have a table: uid task_id yr ------------------------ 1 101 08 2 101 09 3 102 08 4 102 09 5 102 10 I need to determine 2 things: 1) distinct list of yr's 2) count of task_id's for a particular yr So, in my...
  3. mrDrive

    Problem getting parameter from url

    Hmmm...quirky. Worked for me too. Thanks!!!!!
  4. mrDrive

    Problem getting parameter from url

    Hi all, I have a link on my page that allows users to add a title (heading) to the page. It does so by showing a textbox and button when they click on the "Click to add title" link. I'm basically trying to tack a "title" param to the current url like this: <a href="javascript:;"...
  5. mrDrive

    JSTL &lt;c:set&gt; tag

    Hi, I'm executing a query with JSTL and trying to assign resultset values to variables using the <c:set> tag like this: <c:catch var="err1"> <sql:query dataSource="jdbc/asdf" scope="page" var="detail"> MonthlyProgressReport ${contractorID}, '${taskID}' </sql:query> </c:catch> <c:forEach...
  6. mrDrive

    Stored Procedure Problem

    Cool. Does what I'm looking for without the "return" lines. Thanks for the help!
  7. mrDrive

    Stored Procedure Problem

    Ahh. I'm trying to create new primary key values for each table then inject them into my insert statements.
  8. mrDrive

    Stored Procedure Problem

    Hi, I have a (relatively) simple stored procedure that I'm executing from a Java class. CREATE PROCEDURE [dbo].[AddNewUser] @NewContrID int, @Name varchar(100), @Addr varchar(200), @City varchar(200), @St varchar(20), @Zip varchar(50), @NewUserID int, @UserName varchar(25), @Pwd...
  9. mrDrive

    Simple for loop problem

    No, it's actually (in this case) a select element with the multiple attribute added. So when I use "request.getParameterValues" it treats it as an array. I've got the same problem when I use a for loop on an different array: String CommaDeleneatedString =...
  10. mrDrive

    Simple for loop problem

    Hi, I'm very new to JSP. When I use a for loop to iterate through an array, it always prints "null" at the end of the loop. Here's how I'm using it: String[] myArray = request.getParameterValues("selectElement"); int i; for (i=0; i < myArray.length; i++) { out.println("myArray[" + i +...
  11. mrDrive

    Problem with comma-delineated field

    Wow, that's a really clever solution! That looks like the winner. Thanks a bunch! [2thumbsup]
  12. mrDrive

    Problem with comma-delineated field

    Kool! Nice solution JK, "unorthodox" maybe, but so is making me build an app with a poorly designed 2000+ record table. I'd love to restructure the table, but I try keep the interns on my good side. LOL Thanks for the help!
  13. mrDrive

    Problem with comma-delineated field

    Hi, I have a field in myTable ("States") that is a comma-delineated integer list. RecordID States ------------------------------ 1 1 2 1,2 3 12 I'm trying to write a query that will return rows where a specific integer value is present. When I use the LIKE...
  14. mrDrive

    Question About &quot;Reconverting&quot; Data Types

    Cool thanx! Never used that function before.
  15. mrDrive

    Question About &quot;Reconverting&quot; Data Types

    Hi, I'm linking to a SQL Server view to generate a report in Access. In my view, I'm selecting a bit field that has some null values. When I select the bit field, I convert it to CHAR() so that any null values show as empty strings in Access: select ISNULL(CONVERT(char(20),bit_field1),'') AS...
  16. mrDrive

    Question about CAST function

    Ahh! Thank you very much!
  17. mrDrive

    Question about CAST function

    Hi, I have a query that adds together a number of bit fields together to basically give me the "number of true values" for a record: select field1, field2, cast(bol_field1 as int) + cast(bol_field2 as int) as trueCount from myTable My problem is that either bol_field1 or bol_field2 can be...
  18. mrDrive

    New Window w/ Form Submission

    That did it ("return validateForm();")...thank you very much!!!
  19. mrDrive

    New Window w/ Form Submission

    Ooops! I'm too slow, I guess...
  20. mrDrive

    New Window w/ Form Submission

    Thanks much for the help... Yes, I am still getting the same error... Here's the source of the page that generates the form: <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <link href="includes/style.css" type="text/css" rel="stylesheet"> <script>...

Part and Inventory Search

Back
Top