Search Results - VBForums

Search:

Type: Posts; User: smendoza

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Re: Display information from Excel in VB.net program?

    take a look at this post on the forum.
    http://www.vbforums.com/showthread.php?761447-Get-a-single-cel-value-from-excel-into-a-textbox-vb-net

    It should get you started on how to at least read a...
  2. Re: sql server 2005 - Is it possible to return datatype date in short format?

    Because you didn't change the datetime to DATE.


    select Convert(DATE,CONVERT(nvarchar(10),CURRENT_TIMESTAMP, 101))
  3. Re: sql server 2005 - Is it possible to return datatype date in short format?

    Try this



    select Convert(date,CONVERT(nvarchar(10),CURRENT_TIMESTAMP, 101))


    you have datetime instead of date, that's why it's returning the time.
  4. Replies
    4
    Views
    86

    Re: Help with mysql command text

    Do you want to delete the record where it meets your criteria or are you trying to alter the database schema?
  5. Replies
    5
    Views
    180

    Re: PostgreSQL update fails MySql works

    Off topic but, what are your license fears?
  6. Re: Does Oracle have a DEVELOPERS edition like MS SQL?

    I think you can use whatever version of their DB standard, enterprise, and I think express now? (think they have an express version) for development purposes.
    ...
  7. Replies
    6
    Views
    147

    Re: Help with T-SQL Corelated Query

    Good eye TG, I didn't even notice that! :eek:
  8. Replies
    6
    Views
    147

    Re: Help with T-SQL Corelated Query

    Does the table tblEmployers exists?
  9. Re: Query that finds rows that aren't duplicates

    You can use having and count() like the way I did. I was looking to show a count of the results only display the ones whom have a count of one.

    take a look here http://sqlfiddle.com/#!2/b654cd/1...
  10. Replies
    35
    Views
    1,038

    Re: How fast and accurate can you type?

    I was bored so I'll add to this old thread.. 73wpm with 8 mistakes
  11. Re: Query that finds rows that aren't duplicates

    give this a try


    select rl.RetailPct, rm.MenuID
    from RestaurantLoc rl
    join RestaurantMeal rm on rm.RestLocId = rl.RestLocID
    where MenuID = 2657
    group by rl.retailPct, rm.MenuID
    having...
  12. Replies
    12
    Views
    1,226

    Re: Java on Android Decoding a string

    Here is my little test I used when I first started messing with Jackson

    my class for the json data structure.



    import java.math.BigDecimal;
    import java.util.List;
    import...
  13. Replies
    12
    Views
    1,226

    Re: Java on Android Decoding a string

    Yeah, I thought that too when first looked at the page. But yes, it does parse JSON strings. http://wiki.fasterxml.com/JacksonInFiveMinutes
  14. Replies
    12
    Views
    1,226

    Re: Java on Android Decoding a string

    I use jackson https://github.com/FasterXML/jackson-core I've never tried it for Android dev though.
  15. Re: Need an explanation of a java function

    Check the Java docs http://docs.oracle.com/javase/7/docs/api/java/util/Arrays.html

    String a = "a" per the java docs is returning the hashcode for the string object.

    array.hashCode() per the...
  16. VS 2010 Re: Mac Address Changer *not working, need help*

    the vpn I use isn't that slow, 6MB downstream and around 5MB up. It's $30 something a year, works like a charm and is not slow.
  17. VS 2012 Re: Accessing Windows Security through Visual Basic

    try
    Net use * /delete /y
  18. Re: Database Corruption issue with Sql Express localdb

    What about doing the silent install then restoring a backup of the blank database?
  19. Re: Database Corruption issue with Sql Express localdb

    Are you attaching the database through your app or SSMS?
  20. Re: Database Corruption issue with Sql Express localdb

    You're only attaching the database one time correct? or are you using the attachDbFileName each time you run your program?
  21. Replies
    20
    Views
    1,209

    Re: Making Stupid Android Apps For Education?!!

    lol I feel you're anti Java Shaggy, It's okay this a vbforum.
  22. Replies
    20
    Views
    1,209

    Re: Making Stupid Android Apps For Education?!!

    It's really what you're use to. There was a bit of learning curve when I started using Eclipse, then I got use to it.
  23. Re: How to group by a table based on another table

    select distinct(fp.studentid), fg.feegroupname
    from feeGroups as fg inner join feeTypes ft
    on fg.feeGroupID = ft.feeGroupID
    inner join feesPayment fp
    on fp.feeTypeID = ft.feeTypeID
    where...
  24. Replies
    2
    Views
    859

    Re: 2D Boolean Arrays?

    Another way is using maps.
    http://docs.oracle.com/javase/tutorial/collections/interfaces/map.html



    public class MapTest {
    public static void main(String args[]){
    Map<Integer, Boolean>...
  25. Re: I want an alternative to SQL/MySQL Database

    I wouldn't recommend access because the sql syntax is MS ACCESS syntax and I waste a lot of time looking the correct syntax. There are a few other reason but I don't feel like explaining them.
  26. Re: I want an alternative to SQL/MySQL Database

    When you say network do you mean over LAN or WAN? If it's LAN, I'm assuming you allowed remote connections and the client pc had the correct driver installed too?
  27. Replies
    22
    Views
    457

    VS 2010 Re: Restore database from file

    Here is a quick example I threw together.



    Imports System.Data.SqlClient
    Imports System.Data.Sql

    Private Sub restoreDB()
    Dim sqlCmd As New SqlCommand
    Dim connstr As String =...
  28. Replies
    22
    Views
    457

    VS 2010 Re: Restore database from file

    That wasn't what I mean. I meant after that line of code has been executed what are the results? But since TG said the connection hasn't been corrected my post doesn't really matter until that's been...
  29. Replies
    22
    Views
    457

    VS 2010 Re: Restore database from file

    OHhh, I thought he changed to connection string to connect to master and was no getting a syntax error when trying restore the database.
  30. Replies
    22
    Views
    457

    VS 2010 Re: Restore database from file

    Have you looked at what your app built for strQuery? It's saying you have an error in your syntax, I would use to the debugger to grab what app have created for strQuery.
  31. Replies
    22
    Views
    457

    VS 2010 Re: Restore database from file

    What is the error message that the sql server is returning. Have you tried to restore the database in SMSS to make sure your tsql you're using is correct?
  32. Replies
    12
    Views
    451

    Re: GROUP BY with condition count

    select t.carta, t.data_cont
    from t
    where t.data_cont >= 3
    group by t.carta, t.data_cont
  33. Re: SQL Server 2008 R2: Check if IP address is in a range

    I would typically have my front end do the checking for me.
  34. Re: My Windows 8.1 woes continue... but it's logitechs fault

    Interesting thought on the dock-able solution that would be pretty cool. LIke FD said, hopefully it wont break the bank. I would hope it will give you the flexibility to upgrade certain components as...
  35. Re: My Windows 8.1 woes continue... but it's logitechs fault

    So what about people how use their pcs for online gaming. I'm not talking about playing solitaire, I mean MMO's and FPS games? Those would be kind of hard to do on a touch screen.
  36. Re: My Windows 8.1 woes continue... but it's logitechs fault

    So what about people how use their pcs for online gaming. I'm not talking about playing solitaire, I mean MMO's, FPS games? Those would be kind of hard to do on a touch screen.
  37. Re: MySQL Insert Into Two Databases

    I see in the other post you're using mysql, is the database on the same server? If it's on the same server with the same connection you have open just call the insert statement to the other db like...
  38. Replies
    5
    Views
    412

    Re: Need SSIS help - migrate Informix table

    Im assuming you mapped the columns too.
  39. Replies
    8
    Views
    317

    Re: SQL Select using column numbers

    Why do you want to query the data but column position? I can't think of any reason to query it by position?
  40. Replies
    5
    Views
    412

    Re: Need SSIS help - migrate Informix table

    I don't use SSIS but make sure in your target table all the columns data types match and are the correct length. They could be getting truncated, was there any error messages?
Results 1 to 40 of 235
Page 1 of 6 1 2 3 4



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.