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.

...'Declare a command and assign a SQL string to it Dim sqlcomm As SqlCommand = sqlconn.CreateCommand() sqlcomm.CommandText = "SELECT * FROM Students" 'Declare a datareader Dim drd1 As SqlDataReader = sqlcomm.ExecuteReader() While drd1.Read()...

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.

...sp_PriceIncrease Go CREATE PROCEDURE sp_PriceIncrease(@MajorID int , @Percent int = 5) AS UPDATE BookPriceIncrease_ByMajor SET Price = Price + (Price*(@Percent/100)) WHERE MajorID = @MajorID GO EXECUTE sp_PriceIncrease 1,15 GO SELECT MajorID, BookID, Price FROM BookPriceIncrease_ByMajor; GO

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

...Go CREATE PROCEDURE sp_PriceIncrease(@MajorID int , @Percent int = 5) AS UPDATE BookPriceIncrease_ByMajor SET Price = Price + (Price*(@Percent/100)) UPDATE BookPriceIncrease_ByMajor SET @MajorID = MajorID GO EXECUTE sp_PriceIncrease 1,10 GO SELECT MajorID, BookID, Price FROM...

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.

...with a NumberFormatException: empty string. Could someone please tell me why this is not being caught by strSquare.length? import javax.swing.*; import java.awt.*; import java.awt.event.*; import java.math.*; public class SquareRoots extends JFrame { public static void main(String[]...