...how to put all three of my class to work together. I think I'm really missing something here, just not sure what.<br>
<br>
<br>
import java.awt.*;<br>
import java.io.*;<br>
import java.sql.*;<br>
import java.net.URL;<br>
<br>
public class BRR extends Object {<br>
JVRConn conn; <br>...
...how to put all three of my class to work together. I think I'm really missing something here, just not sure what.<br>
<br>
<br>
import java.awt.*;<br>
import java.io.*;<br>
import java.sql.*;<br>
import java.net.URL;<br>
<br>
public class BRR extends Object {<br>
JVRConn conn; <br>...
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...
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...
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...
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>
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, ' \ '...
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+" '...
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>...
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>...
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>
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...
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>
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>
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>...
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...
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>...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.