Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
PLEASE HELP!!!
I'm in need of some help rather fast, project due!!<br> <br> I have this project due and the boss is<br> breathing down our necks, anyway I need to know how to call some<br> classes. I have this button on an applet from which I need to trigger<br> the following class. <br> <br> void... -
DIRE STRAIGHTS -- NEED HELP ASAP!!!
I'm in need of some help rather fast, project due!!<br> <br> I am so new to java and I have this project due and the boss is breathing down our necks, anyway I need to know how to call some classes. I have this button on an applet from which I need to trigger the following class. <br> <br>... -
Writing an "Object Class"
Okay, I'm getting confused on an issue of writting an object class. Does anyone know how to do this and can explain to me how to do this in a nutshell or have examples?<br> Maybe even a site that shows how to do this... this is imperative for me to finish my project.<br> <br> <br> Thanks for... -
Now onto UPDATE SQL
I need to retreive my id key from an Access database and compare it to the current record I'm working on how do I go about doing that, this is what I've come up with so far and this doesn't seem to work. <br> <br> docketNum is within my access db and fileNum is the current record I'm working... -
INSERT INTO problem
This is the entire SQL that I needed to perform an INSERT. I had 96 total fields to INSERT so they needed to be checked for words like "O'Brian" and if they where<br> null, that it is what the function getAsSQLString does. <br> I shortened this code for posting purposes. I gathered... -
SQL SELECT stmt
Thanks a million Otto!<br> <br> It works like a champ!!<br> <br> Courtney <p> Courtney<br><a href=mailto: ceaton@lrp.com> ceaton@lrp.com</a><br><a href= > </a><br> -
INSERT INTO problem
I got it to work, thanks for your help.<br> <br> Courtney <p> Courtney<br><a href=mailto: ceaton@lrp.com> ceaton@lrp.com</a><br><a href= > </a><br> -
SQL SELECT stmt
Otto,<br> <br> I was mistaken when I told you that I tried that, I hadn't.<br> <br> This is what I did try:<br> <br> public String getAsSQLString(Label tf) {<br> String s;<br> <br> s=tf.getText();<br> if (s.charAt(i)==' \ ' ') { s.insert(i, ' \ '... -
INSERT INTO problem
Here is the code I'm trying to get to work properly.<br> <br> public String getAsSQLString(Label tf) {<br> String s;<br> <br> s=tf.getText();<br> if (s.charAt(i)=='\ ' ') { s.insert(i, '\ ' '); }<br> else { s=" ' "+s+" '... -
INSERT INTO problem
I'm not trying to display the data, I'm trying to INSERT the data, Access accepts everything except for something like "O'Brian". Anything with an apostrophe in the word.<br> <br> Is there some kind of other way to insert apostrophe words?<br> <br> Thanks,<br> <br> Courtney <p>... -
INSERT INTO problem
This is the snippet of code that goes through each of my strings, maybe there is something missing?<br> <br> public String getAsSQLString(Label tf) {<br> String s;<br> <br> s=tf.getText();<br> if ((s==null) ¦¦ (s.length()==0)) { s="null"; }<br>... -
INSERT INTO problem
Thanks anyway, I have my question posted in the Java(sun) forum also. I've had Otto help me, but I've run into this little problem and thought someone else may be able to help.<br> <br> <p> Courtney<br><a href=mailto: ceaton@lrp.com> ceaton@lrp.com</a><br><a href= > </a><br> -
SQL SELECT stmt
I am using jdk1.2.2 and I tried that one :-( earlier and got errors for everyone of my Inserts. Unbelievable isn't!<br> <br> I tried a bunch of various ways with the single quote and the double quote with the escape and I can't get it to work.<br> <br> <p> Courtney<br><a href=mailto... -
INSERT INTO problem
I tried that and it doesn't work out right, thanks for trying!<br> <br> <p> Courtney<br><a href=mailto: ceaton@lrp.com> ceaton@lrp.com</a><br><a href= > </a><br> -
SQL SELECT stmt
I forgot to mention that I will also need to pass an 's similar to "Plaintiff's Drug Addiction". Will this function work with this also?<br> <br> Thanks <p> Courtney<br><a href=mailto: ceaton@lrp.com> ceaton@lrp.com</a><br><a href= > </a><br> -
SQL SELECT stmt
Thanks Otto for the help, but the code won't compile.<br> <br> I'm getting errors on this part of the code:<br> <br> if (sb.charAt(i)== ' ' ' ) { sb.insert(i, ' ' ' );<br> <br> Invalid character constant. and it points to the first single quote on each one. These are single quotes right?<br>... -
INSERT INTO problem
I have an INSERT INTO query with several fields, one of which is a name field. The problem I'm having is if the person has a name like "O'brien", the query is then rejected due to the single apostrophe. Here is the bit of my query that I'm using.<br> <br> String query = "INSERT... -
SQL SELECT stmt
Hey Otto, That all works great, yes of course there is but to this. When I need to pass a name such as "O'brian" or "Plaintiff's" it is giving me an error. How do I get around this?<br> <br> Thanks,<br> <p> Courtney<br><a href=mailto: ceaton@lrp.com>... -
SQL SELECT stmt
Basically what I need to know how to do is pass a null value to the database. I cannot use an SQL server because this is a stand-alone applications which will be installed by the user from a CD-ROM. So for example if I have the SQL<br> <br> String query = "INSERT INTO caseInfo(caseName... -
SQL SELECT stmt
I guess I don't really fully understand because all of the fields that I'm getting my information from are all labelFields. Aren't these String fields? In my database (MSAccess) all of the fields are TextFields. So why would it matter if the data is numerical? I also really didn't fully...
