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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ceaton

    PLEASE HELP!!!

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

    DIRE STRAIGHTS -- NEED HELP ASAP!!!

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

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

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

    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 &quot;O'Brian&quot; and if they where<br> null, that it is what the function getAsSQLString does. <br> I shortened this code for posting purposes. I gathered...
  6. ceaton

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

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

    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, ' \ '...
  9. ceaton

    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=&quot; ' &quot;+s+&quot; '...
  10. ceaton

    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 &quot;O'Brian&quot;. 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>...
  11. ceaton

    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=&quot;null&quot;; }<br>...
  12. ceaton

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

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

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

    SQL SELECT stmt

    I forgot to mention that I will also need to pass an 's similar to &quot;Plaintiff's Drug Addiction&quot;. 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>
  16. ceaton

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

    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 &quot;O'brien&quot;, 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 = &quot;INSERT...
  18. ceaton

    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 &quot;O'brian&quot; or &quot;Plaintiff's&quot; 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>...
  19. ceaton

    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 = &quot;INSERT INTO caseInfo(caseName...
  20. ceaton

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

Part and Inventory Search

Back
Top