dcsimg
www.webdeveloper.com

Search:

Type: Posts; User: RunningDude87

Search: Search took 0.01 seconds.

  1. PLSQL modify decode function to check for NULL and empty string

    Hi,

    I need the following query to select 0 when the value is NULL or empty string, not just NULL. Can I modify this Decode function to handle that?

    select Decode(value, NULL, 0, 1)
    from table...
  2. What I ended up doing is this: select...

    What I ended up doing is this:

    select ascii(substr(value, 0, 1)) from table

    This gave me the ascii value of the first character in the string, which ended up being chr(49824). I'm now looking...
  3. Selecting text value with leading whitespace

    Hi,

    My query:

    select value from table where value = '0123'

    is not returning anything because the actual value is ' 0123'
    I put the space character in a Unicode generator and it tell me...
  4. Ok yes I was able to order it in the from clause,...

    Ok yes I was able to order it in the from clause, then apply the ROWNUM. It worked for what I'm trying to do. Thanks!
  5. Yes I did mean 123%. The order by id would would...

    Yes I did mean 123%. The order by id would would except the 123 isn't necessarily the first id. Sorry should have clarified that.
  6. PLSQL Limiting results with ROWNUM not accurate

    Hi,

    I have a table that basically has the following data:

    id number
    1 123
    2 1230
    3 1231
    4 1232
    5 1233
  7. strtotime not giving expected answer for day of week

    If 0 - 6 is Sunday thru Saturday, the following gives me 6, which is correct since 10-04-2014 was on a Saturday.
    $dayOfWeek = date( "w", strtotime('2014-10-04'));

    However, I expect 09-04-2014 to...
  8. Replies
    4
    Views
    1,281

    Thank guys!!! Using an object to store data...

    Thank guys!!! Using an object to store data worked great for me. And I did have parentheses around the for loop, just typed it in wrong.
  9. Replies
    4
    Views
    1,281

    Javascript Dynamic variables names

    I'm trying to create variable names on the fly in a for loop, something like below:

    for i = 0; i<data.rows.length; i ++ {
    var a + data.rows.[i].c[1].v = ' some value';
    var b +...
  10. JSP Resultset not iterating multiple times

    Hi,

    I'm trying to use JSP resultset.next() multiple times to print HTML tables. However, it doesn't seem to want to work. I can print one or the other fine, but not both. I'm trying something...
  11. Replies
    1
    Views
    1,197

    Selecting date range

    I'm trying to select a range of dates, something like:

    select * from table where dateColumn between currentDate and currentDate - 35

    Any hints? Thanks!
  12. Replies
    0
    Views
    1,098

    Testing Existence of Foreign Keys

    I need part of a script to test the existence of foreign keys and print the results. My way isn't going to work because the script will hit both print statements. Is there a better way to write this?...
  13. Replies
    0
    Views
    761

    Web tool for ping testing

    I have a ping application I need to test. I'm looking for an application that I can install on the machine I'm pinging that can delay and/or prevent the response to be sent back. So far I've tried...
  14. Replies
    1
    Views
    1,198

    Case Statement is Select

    I'm trying select information from 2 temp tables and place it in a third temp table. I'm inner joining the first two where #MyCars.Make and #Dealerships.Make equal each other. However, where they...
  15. Replies
    1
    Views
    1,993

    Changing data types

    Hi,

    I need to change a smallint to text in a Select statement. What's the best way to approach this?

    Thanks!
  16. Replies
    0
    Views
    899

    SQL Commit

    I have a VBScript that needs to update a table. However, when the script executes the SQL it never completes. The script object and/or SQL are trying to lock and update the DB row at the same time....
  17. Replies
    3
    Views
    2,216

    Ok, so forget my first bad post. Basically, it's...

    Ok, so forget my first bad post. Basically, it's a piece of a .jsp file.

    The error message is thrown at the start of: <% var fld1;

    The error message starts with:

    Error message :...
  18. Replies
    3
    Views
    2,216

    Some JavaScript Help

    Hello,

    Is there anything initially wrong with this JavaScript? I don't see any issues with it but there's an error message coming from the blank space below. Thank you.


    <OPTION...
  19. Replies
    2
    Views
    3,689

    Thanks this helps a lot!

    Thanks this helps a lot!
  20. Replies
    2
    Views
    3,689

    PowerPoint Slideshow on Intranet

    I am looking to embed a PowerPoint slideshow into my company's Intranet website. I want the slideshow to reside on my company's network which is not public. Is this possible without having to use...
  21. Replies
    2
    Views
    2,006

    Sorry, I should have mentioned that this is an...

    Sorry, I should have mentioned that this is an Intranet site.
  22. Replies
    2
    Views
    2,006

    Reading local files

    Hi,

    There is a slideshow on my website that reads in the address of local images and puts them in a slideshow rotation to be displayed on the page. I currently have to "hard code" the addresses...
Results 1 to 22 of 22
HTML5 Development Center



Recent Articles