Search results for query: *

Good for you, because I was wrong anyway. Lucky for me, your code tipped me off on how to fix something I was working on. So, thank you!

Nevermind. I needed SelectedItem instead.

I'm pretty new to this too, but I think your problem is that the myReader.read() comes after the .HasRows. It will always not have rows before the read starts.

When I run my program, it fills up the listbox properly, but when I try getting the SelectedValue, it comes back empty. I tested it by having a msgbox pop up with just the SelectedValue. Can someone tell me why the value wouldn't work? Public Class frmCourseList Public strStudents As...

You're the man, GHolden. Just a silly misplaced parenthesis. Thanks for your help!

Price field is MONEY. I just tried changing it to FLOAT, but it didn't help.

Tried it. Both price columns have the same value.

The first three are $39.95, 35.95, 37.50 After executing, table Books and table BookPriceIncrease_ByMajor still have the same values they had before executing.

By adding yours directly beneath the CREATE PROCEDURE block, I get the correct @MajorID returned, but the calculation still doens't happen.

I like that little joke, GHolden. Do I have your permission to use that too? DROP TABLE BookPriceIncrease_ByMajor SELECT Majors.MajorID, Majors.Description, Books.BookID, Books.Title, Books.AuthorName, Books.pub_id, Books.BooksOnHand, Books.Price INTO BookPriceIncrease_ByMajor FROM...

bborissov, cfstarlight, I've tried your suggestion, but the calculations are still not being done. I do not get any errors during execution, but none of the prices ever get changed, no matter how many times I execute it. I'm wondering if the calculation is even taking place.

I believe you'll want a SELECT INTO statement to accomplish this. I'm pretty sure most people on this forum prefer you to post the code you've tried. Partly because if this is homework, they'd like to know you've tried it yourself, and not just trying to get others to do your homework for...

As is, this code executes with no errors; however, it doesn't seem to be performing the calculation. I think this may be because the line SET @MajorID = MajorID is in the wrong place. Anytime I try to move it though, I get an error Msg 102, Level 15 State 1 Line 2. For the life of me, I can't...

I'm not sure I understand how I could use the UPDATE because the SET would be different every time. Isn't SET static? Thanks for your help. I'm going to read up on the JOIN stuff again.

I'm having trouble figuring out how to fill a table with data from 3 other tables. Here's a simple example... CREATE TABLE dbo.Transcripts( StudentID int, First_Name CHAR(20), Last_Name CHAR(20), Semester int, ClassID CHAR(5), Title CHAR(50), Grade int, Credits int, GPA...

Thanks a lot! That isn't how I wanted it to look, but I see that it will work better than what I was trying to do. I'm still unclear on what makes it look for all the dinos, instead of just the first one. Why doesn't it need some sort of loop to find them all?

When viewed in HTML, this shows three different tables. I'm trying to get these all into one table. Can someone explain to me, in layman's terms, what makes this Stylesheet create a new table every time? <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet...

I'm trying to run an example out of a java book and I'm just no good with command line stuff. I'm trying to connect to an example db2 database. I always compile and run java stuff from the jdk bin directory (C:\Program Files\Java\jdk1.6.0\bin). I have a program that is telling me to include...

Thank you very much. I tried a try/catch earlier and it didn't work. Not sure what I did different this time, but it worked.

I have marked exactly where my error is occurring. I'm trying to check the contents of a textbox to see if the user entered a number. When I run the program, and click the "Calculate" button, I should get a JOptionPane error box. Instead, I get a long error in the command prompt starting with...