Search:

Type: Posts; User: smendoza

Page 1 of 7 1 2 3 4

Search: Search took 0.03 seconds.

  1. Re: MySQL , Why this procedure not rolls back

    I think you need to declare your exit handlers inside of the transaction. Declare them after the start transaction declaration, currently they're declared before you declare the start transaction....
  2. Replies
    3
    Views
    650

    Re: Challenges of legacy data

    garbage in garbage out.
  3. Re: Is there a limit / criteria in creating Foreign key in MySQL

    nm I read the question wrong and I can't delete my pointless post.
  4. Re: Is there a limit / criteria in creating Foreign key in MySQL

    If I recall it's because you have a constraint in your database already called "IDS" try changing the name of the constraints name to something on than "IDS"
  5. Re: Converting String to String Array and vice-versa [Java]

    Or something like this.



    String myString = "{Hello}{Bye}{Ouch}";

    myString = myString.replace("{", "");

    String[] myStringArray = myString.split("}");
  6. Re: How to "Allow Remote Connections" for Sql Server 2008 Express on a Client w/o SSM

    They changed it a bit from 2005 to 2008 Clicky here
  7. Re: Can't seem to fix the permissions to debug a Stored Procedure?

    You need to have "execute" permission for the sproc. Take a look at the link it will show you how to add your user to be able to execute the sproc.
    ...
  8. Replies
    7
    Views
    762

    Re: mysql compared to mssql

    I agree, the mssql query optimizer seems better that's just my opinion. At work we use both mysql and mssql, it comes down to have a good design and index. Our myssql server runs fast we don't have...
  9. Replies
    1
    Views
    2,522

    Re: Weighted Average Cost In MySql

    I'm going to guess and say you have some NULL values in the database, in that case you will want to use the COALESCE() function. The coalesce function returns whatever value you tell it to, for...
  10. Replies
    190
    Views
    35,760

    Re: above 50 years old and still programming

    tg, even worse when you have another manager that likes to try to throw you under the bus to cover his own a$$.
  11. Replies
    11
    Views
    1,019

    Re: connection issue

    add "explain extended" before you queries , this will tell you that the mysql optimizer is doing if you curious to see what it's doing. But I'm guessing the data set on your local pc is much smaller...
  12. 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...
  13. 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))
  14. 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.
  15. Replies
    4
    Views
    688

    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?
  16. Replies
    5
    Views
    1,764

    Re: PostgreSQL update fails MySql works

    Off topic but, what are your license fears?
  17. 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.
    ...
  18. Re: Help with T-SQL Corelated Query

    Good eye TG, I didn't even notice that! :eek:
  19. Re: Help with T-SQL Corelated Query

    Does the table tblEmployers exists?
  20. 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...
  21. Replies
    35
    Views
    2,946

    Re: How fast and accurate can you type?

    I was bored so I'll add to this old thread.. 73wpm with 8 mistakes
  22. 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...
  23. Replies
    12
    Views
    4,617

    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...
  24. Replies
    12
    Views
    4,617

    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
  25. Replies
    12
    Views
    4,617

    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.
  26. 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...
  27. Replies
    29
    Views
    4,252

    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.
  28. VS 2012 Re: Accessing Windows Security through Visual Basic

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

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

    Are you attaching the database through your app or SSMS?
  31. 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?
  32. Replies
    21
    Views
    3,791

    Re: Making Stupid Android Apps For Education?!!

    lol I feel you're anti Java Shaggy, It's okay this a vbforum.
  33. Replies
    21
    Views
    3,791

    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.
  34. 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...
  35. Replies
    2
    Views
    1,783

    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>...
  36. 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.
  37. 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?
  38. Replies
    22
    Views
    2,437

    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 =...
  39. Replies
    22
    Views
    2,437

    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...
  40. Replies
    22
    Views
    2,437

    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.
Results 1 to 40 of 246
Page 1 of 7 1 2 3 4



Click Here to Expand Forum to Full Width