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

    Rounding error

    Howdy Madawc, That is what I thought. It should work. When I view the query the form is using it shows 3.5. I did a formula and converted it to a string and printed it out and it comes out as 4.0. I am going to play with changing my query to import the value into different fields (AS newValue1)...
  2. ksbigfoot

    Rounding error

    I am using Crystal Reports 10. I view the query my report is using and when I run it through Query Analyser it shows the values to be 3.5 But when the value is placed in the details area, it is displayed as 4.00 I have formatted the field by clicking Format Field -> Customize. Decimal 1.00...
  3. ksbigfoot

    Direction on how to publish vb.net app

    Howdy RiverGuy, I am using VS 2005. I gave you a star as you pointed me in the right direction to read more. Thanks ksbigfoot
  4. ksbigfoot

    Direction on how to publish vb.net app

    Are ClickOnce and Windows Installer Deployment the only two options for deployment? I can't use ClickOnce as we have a group that does the deployments. The group that does the deployments don't like .exe files as they can't tell what is being created.
  5. ksbigfoot

    Direction on how to publish vb.net app

    Is this to simple a question? I publish my code and I get an .exe file and some other files. People deploying don't like just clicking on a .exe file. Is there a different way to publish a vb.net app other than a .exe file?
  6. ksbigfoot

    How to load array in JSP getAttribute

    I am new at and using Struts. I'm not sure how to do the following: I am loading an Arraylist of TitleNames. Each TitleName is related to a List of pictures (MyList). MyList is a class that I created that contains all the fields needed to describe the picture. In my code at the top of my jsp...
  7. ksbigfoot

    name value pairs checking if they exist

    That works perfectly. Thank you and star to you.
  8. ksbigfoot

    name value pairs checking if they exist

    I have "Imports System.Configuration", but the ConfigurationManager is not coming up in the list. So I can't get this line: ConfigurationManager.AppSettings Do you know why?
  9. ksbigfoot

    name value pairs checking if they exist

    I am reading from the app.config file successfully using the following code. 'Read in String from app.config file Dim VarSettings As New System.Configuration.AppSettingsReader() Dim oString As Object = VarSettings.GetValue("LogPath", GetType(String)) Dim strPath As String = oString.ToString()...
  10. ksbigfoot

    Direction on how to publish vb.net app

    Do I just take the files that are in my \bin\Release\ folder and use those files? I don't know if there is a benefit of using a webservice or something like that over this way.
  11. ksbigfoot

    Direction on how to publish vb.net app

    I am calling my vb.net app from a batch file. The batch file calls a module within my vb.net app which starts off the whole process. Just wondering what you would suggest on what the vb.net app should run as?
  12. ksbigfoot

    How to access XML in Dataset

    I figured out that I could do this: ds.Tables(1).Rows(0).Item(0).ToString() ds.Tables(1).Rows(0).Item(1).ToString() ds.Tables(1).Rows(0).Item(2).ToString() ds.Tables(1).Rows(1).Item(0).ToString() ds.Tables(1).Rows(1).Item(1).ToString() ds.Tables(1).Rows(1).Item(2).ToString() Just have to write...
  13. ksbigfoot

    How to access XML in Dataset

    I am using VS 2005. My dataset read this XML <Rows xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> <Row id="12345678890" peopleid="12345"> <Field id="F1" type="Varchar">Val1</Field> <Field id="F2" type="Varchar">Val2</Field> <Field id="F3" type="Varchar">Val3</Field>...
  14. ksbigfoot

    How to format Date using to_date

    Forgot to mention that my date field in my Oracle database is in the format 'yyyy-mm-dd hh24:mi:ss'
  15. ksbigfoot

    How to format Date using to_date

    Howdy BJCooperIT, I put to_date('2008-01-17 5:23:20 PM', 'yyyy-mm-dd hh:mi:ss am') and I get the error message: "Error while trying to retrieve text for error ORA-00972
  16. ksbigfoot

    How to format Date using to_date

    My date is in this format: 2008-01-17 5:23:20 PM I am using: to_date('2008-01-17 5:23:20 PM', 'yyyy-mm-dd hh24:mi:ss'), but this gives me an error. Do you know how the to_date should look?
  17. ksbigfoot

    INSERT INTO with Sequence.nexval

    If I read the value into a variable, when I run the query above, would every record contain the same value in Table1_ID?
  18. ksbigfoot

    change double 3 decimal places to 2 decimal places

    Thanks Golom & JerryKlmns, Makes sense now. Thanks again and star to you both. ksbigfoot
  19. ksbigfoot

    change double 3 decimal places to 2 decimal places

    Howdy Golom, Where would I run this code?
  20. ksbigfoot

    change double 3 decimal places to 2 decimal places

    I have a field of type Double, it originally had 3 decimal places. I changed it to 2 decimal places, but the 3 decimal places are still in the table. How would I change the numbers to 2 decimal places?

Part and Inventory Search

Back
Top