Prepaired Statement

Quick question this time

Could someone please tell me the correct syntax for making a Prepaired statement. I need to insert an int (i) into the sql, as well as sort by alphabetical order.

This is what I figured it should be:

Check out this link Prepared Statements

Also, I *think* your code should work, provided you change this

to this

Check out the link and let us know what hang ups you are having, error messages, logic errors, etc

This message was edited 3 times. Last update was at 04/28/2006 08:37:58

Also, you may want to simplify things a bit if you're using PreparedStatements. It takes a little more code but, especially if you start dealing with Strings, it makes your life much simpler.

Something instead like:

Thanks guys.

Can't believe I left the "+" out

The connection is being dealt with in another class, so I think I can get away with it as it is...we shall see