www.webdeveloper.com

Search:

Type: Posts; User: zimonyi

Page 1 of 7 1 2 3 4

Search: Search took 0.03 seconds.

  1. Replies
    2
    Views
    2,436

    Hello, if you have a Date object you can...

    Hello,

    if you have a Date object you can create a Calendar object from that Date.

    Calendar cal = new Calendar();
    cal.setTime(yourDbDate);
    cal.add(Calendar.DATE, -7);

    Archie
  2. Replies
    4
    Views
    1,731

    You should also generally (especially if you have...

    You should also generally (especially if you have an infinite loop with A LOT of conditions) keep printing your conditions, because most likely you have a value that is never set the way you want to,...
  3. Replies
    4
    Views
    1,731

    The following line in your code: while...

    The following line in your code:


    while ((continuePlaying) && (wonGame) && (isMoveValid=false))


    should probably be:
  4. Replies
    2
    Views
    1,147

    Correct syntax is either: SELECT t.name FROM...

    Correct syntax is either:


    SELECT t.name FROM trace t, trans c WHERE t.name = 'name1' OR t.name= 'name 3' OR t.name = 'name4' OR t.name = 'name5' AND t.id=c.id;

    or


    SELECT t.name FROM...
  5. Replies
    4
    Views
    4,722

    Which database are you using? How many levels...

    Which database are you using?

    How many levels do you have? Is it static? I.e you can always only have three?

    If so, I suggest you create three different function in whatever programming...
  6. Replies
    4
    Views
    4,356

    Change your AND to an OR between the dates. If...

    Change your AND to an OR between the dates.

    If you use AND it means that both the requirements need to be met.

    What you want is to see if any start date is the same or greater then your start...
  7. Replies
    9
    Views
    2,392

    What happens if you just run this part of your...

    What happens if you just run this part of your select?


    select '101-a',now(),2675,0,'ASC','2010-12-18',0.00 from tblassoc

    Achie
  8. Replies
    9
    Views
    2,392

    Hello, if you just run the SELECT statement,...

    Hello,

    if you just run the SELECT statement, what result do you get?

    Archie
  9. What type is your column post_date in the...

    What type is your column post_date in the database?

    What type is your variable $timestamp?

    Archie
  10. Replies
    1
    Views
    1,391

    Hello, in many database you can create so...

    Hello,

    in many database you can create so called anonymous tables which you have done there with your tables which you alias as "a".

    I would suggest that you make some of your calculcations...
  11. This below should do the trick: UPDATE...

    This below should do the trick:

    UPDATE wp_posts p, wp_gdsr_data_article d
    SET p.views = d.views
    WHERE p.id = d.post_id;

    Since I haven't tested it, you might want to make a backup or copies of...
  12. I understood that, but different databases might...

    I understood that, but different databases might use different syntax, so if you let me know which database you are using, I can come up with the correct update syntax.

    Archie
  13. Ok, first begin with removing all data from the...

    Ok, first begin with removing all data from the wp_posts table views column:


    UPDATE wp_posts SET views = NULL;

    Then you want to copy all views from the table wp_gdsr_data_article into the...
  14. Replies
    2
    Views
    3,040

    In regards to your second problem, I think you...

    In regards to your second problem, I think you should do the same as my suggestion for your first problem.

    Archie
  15. Replies
    2
    Views
    3,040

    Hello, in regards to your first problem,...

    Hello,

    in regards to your first problem, meaning the printLetters(char c) method, I would not make the printLetters() method recursive.

    Instead I would call another private method that does the...
  16. Replies
    2
    Views
    3,305

    Hello, Sesame documentation...

    Hello,

    Sesame documentation

    Just start reading.

    Archie
  17. Do you have data in the column views today? ...

    Do you have data in the column views today?

    Which of the tables should contain the "master" data?

    If you only want to copy all the data from one table to the other it is pretty easy but if not,...
  18. Thread: distinct

    by zimonyi
    Replies
    9
    Views
    1,863

    That's not what I meant. I mean that if he only...

    That's not what I meant. I mean that if he only wants the name, he might as well use DISTINCT (which is what it is for).

    Using GROUP BY will work just as well but is also used together with those...
  19. Thread: distinct

    by zimonyi
    Replies
    9
    Views
    1,863

    Even if it is GROUP BY, my queries will still...

    Even if it is GROUP BY, my queries will still return the same results even if we remove DISTING and add GROUP BY.

    GROUP BY will also return unique rows so I still think you need to provide...
  20. Thread: distinct

    by zimonyi
    Replies
    9
    Views
    1,863

    Ok, again, you cannot DISTINCT on a single...

    Ok, again, you cannot DISTINCT on a single column. You DISTINCT on a row.

    So, with your example rows in your table, then the following query:


    SELECT DISTINCT name1 FROM table;

    would...
  21. Replies
    3
    Views
    1,355

    Will you have many applications? If not, then...

    Will you have many applications?

    If not, then I would suggest a simple form for creating users, and a simple login/password form for logging on.

    It should be enough if you use HTTPS (i.e....
  22. Thread: distinct

    by zimonyi
    Replies
    9
    Views
    1,863

    Since SQL does what you ask of it, can you tell...

    Since SQL does what you ask of it, can you tell me exactly what you mean by DISTINCT on ID1 and ID2?

    DISTINCT will make each row unique in all its column values. Nothing more, nothing less. You...
  23. I seem to have missed you response but glad it...

    I seem to have missed you response but glad it all worked out.

    Archie
  24. Replies
    2
    Views
    822

    It should be, the configure commands: ...

    It should be, the configure commands:

    --enable-soap
    --with-xmlrpc

    should give you what you need in order to allow for web services.

    Archie
  25. Replies
    2
    Views
    1,604

    Can you please ask your question? You can only...

    Can you please ask your question?

    You can only ever INSERT one row at a time if you have the data yourself (and not selecting it from other tables).

    So basically you would need to store your...
Results 1 to 25 of 160
Page 1 of 7 1 2 3 4
HTML5 Development Center



Recent Articles