Why don't you just try it? Just by reading the thread (I started it a while back now so can't remember) I would say you need the .equals() method to return for you...

Haha good to see an old post is still helping people

Hi thanks for that, but it turned out the whole of the code can be simplified using IF EXISTS, arghh this is so obvious when I think about it. Sorry about the newbie post everyone

Yes I know that, hence if it already exists it should do an update! Not a replace.

The following stored procedure is supposed to add a new record to the database OR update Mdescript if it already exists. However I keep getting errors such as primary key violations. Please take a...

Thanks but theres and even easier method:

axWindowsMediaPlayer1.Ctlcontrols.stop();

Hey I know this must be simple, but how do I prevent windows media player playing automatically when the form it is contained on is loaded?

Thanks

No I know that in order to compare a String you have to call its method .equals but how I check if a String is NOT equal to something? Will it be something like if ("hello" != String.equal())?? or...

Hi,

I have a JSP which searches through a database of categories and displays each one with a unique link if clicked. When the link is clicked it sends it to itself and saves it into a variable. ...

Sorry. I have a JSP which accesses an Access database and prints its records to screen. What I want to be able to do is to access the records and print them by there row number in the record set. ...

In a JSP how do I access a record by its number?

Thanks mate I was being stupid....newbie ya see? Lol I figured out by myself, thanks anyway :-)

I have a string stored in a session variable.....how do I get that string back out as I get the error:Type mismatch: cannot convert from Object to String

Is there a toString() method or something?...

After all that! All I had to do was put square brackets around date because it is a reserved word! I was ready to hit the computer ;-)

Thanks for your help guys

Okay, I'm starting to think theres something wrong with my computer because this is beyond a joke. This is what I have now:

if (submit != null)

{

try {
String sql = "Update Questions Set...

Oh them ? were intentional? I replaced them LOL. Okay so here it is now...I seem to be getting somewhere. I've taken the WHERE out, but I don't understand how it knows which record to update. ...

Okay, having taken into consideration everything on this post I have created a new statement:

PreparedStatement ps = conn.prepareStatement("UPDATE Questions WHERE ID ="+ID+" (Question, Answer,...

I have a JSP which inserts date into a MS Access database. But I keep receiving the error:

24: statement.executeUpdate("INSERT INTO Questions WHERE ID ='"+ID+"'(\"Question\", \"Answer\",...

OKay thanks, now I'm getting the error:

org.apache.jasper.JasperException: Attempted a bean operation on a null object....

Okay, here we go. I am trying to learn how to use javabeans properly and so I've created a small bean which just writes text to the screen. I keep getting the error:
...

Yea thanks I figured it out from ur previous post, thanks 4 ur help

I know I'm probably being dumb here but I cannot seem to compile a java bean. Here is my code:



package beans;

import java.sql.*;

public class example
{

Okay thanks for you're help but I've just come from a C# background (hence I didn't know the different between == and equals() and I've only been learning the language for a few weeks

Hey, I'm having a problem with an if statement. I want to check if variable key and id are the same. They are both strings and when I print them to screen they certainly look the same. However...

Its ok its been solved now

How do I round numbers to say 2 decimal places?

Okay now I'm getting errors about doubles and integers the values in the database are stored as doubles

Type mismatch: cannot convert from double to int

136: double useful =...

I'm having problems performing math in JSP. I have a line:

double percentage = (useful / nonuseful) * 100;

which is giving me an error, how do I fix this?

Thanks

Hey,

I have a primary JSP which inlcudes a secondary JSP which is dynamic. How do I pass parameters FROM the secondary JSP back the PRIMARY JSP not the other way around?

For example I have a...

Hey, I've managed to solve this....turns out I had to declare the variables i.e. String question = null; outside the loop.

Please take a lot at this. Tomcat is reporting the variable editQuestion cannot be resolved.



<%
String key = request.getParameter("edit");
ResultSet columns1 =...

I've got this code which seems right but I keep getting: An error occurred at line: 19 in the jsp file: /viewFAQ.jsp
Syntax error, insert "AssignmentOperator Expression" to complete Assignment
...