Recent content by mrDrive

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

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

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

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:;"...

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

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

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

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

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

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

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

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!

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

Cool thanx! Never used that function before.

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