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!

Register Log in
  • Congratulations Chriss Miller 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. getjbb

    Concatenate Date and Time fields

    Garan, Thank you so much for the solution. Have a Happy New Year. getjbb
  2. getjbb

    Concatenate Date and Time fields

    Garan, Thanks you for the response, but I do not have the privilege to change the date format. Is there a way of getting around setting NL-DATE-FORMAT? Perhaps another way to get the needed results. Thanks, getjbb
  3. getjbb

    Concatenate Date and Time fields

    Could someone please help me. I need to concatenate two fields, date and time. I tried the following: DECLARE v_date DATE := to_date('09-MAR-2015','DD-MON-YYYY'); v_time VARCHAR2(6) := '050520'; v_full DATE; BEGIN v_full := TO_DATE(TO_CHAR(v_date, 'DD-MON-YYYY')...
  4. getjbb

    I need to create a JSON Array from XML Data

    It was my understanding that a JS Object, which Xmldoc is, was not the same as JSON. My problem is that the web service I am using only accept XML file, but my final data has to be in the JSON format in order for me to use it, therefore I cannot use the JS Object of Xmldoc, unless it can be...
  5. getjbb

    I need to create a JSON Array from XML Data

    Hello, I have am new to Javascript(Dojo) and I need to create a JSON Array from XML data coming back from an AJAX call. I do not know what to do after parsing the incoming data and assigning it to an XMLDOC var: var XMLDOC = dojox.xml.DomParse.parse(data); I am trying to keep from having to...
  6. getjbb

    Object type returns error

    Thanks, Dagon
  7. getjbb

    Object type returns error

    I am using 9i: My problem is I am trying to return a table from a function, but I am getting the following error: ORA-06550: line 2, column 36: PLS-00302: component 'GET_TAB_PRODS' must be declared ORA-06550: line 2, column 10: PL/SQL: Item ignored ORA-06550: line 8, column 3: PLS-00320: the...
  8. getjbb

    Convert string to an Array

    Sorry, forgot subject line, again.. I have a string: ,off,on,off I want to parse the data into an array. I found and tweaked (bolded) the following code, but the result was: <blank line> (think this is coming from the first ',') off on off ---------------------------------------...
  9. getjbb

    I have a string: ,off,on,off

    I have a string: ,off,on,off I want to parse the data into an array. I found and tweaked (bolded) the following code, but the result was: <blank line> (think this is coming from the first ',') off on off --------------------------------------- FUNCTION SPLIT (p_in_string VARCHAR2, p_delim...
  10. getjbb

    Error Message: Missing ; Before Statement

    Thank you all so much. getjbb
  11. getjbb

    Error Message: Missing ; Before Statement

    I am getting back the error: Missing ; before statement chkBox.innerHTML = "<input type=checkbox onclick=is_checked() id="cbox + index" name="cbox + index">"+field1+""; And it is pointing to the cbox that is bolded. Whatever help given will be appreciated. The piece of code is within a...
  12. getjbb

    Call an Oracle Stored Procedure From a Javascript Function

    Sorry forgot a Subject... I am not no sure this is the correct forum to be asking this question or should it be asked in the Oracle forum since it relates to htp.p but.... I am trying to pass an array from a JavaScript function to an Oracle stored procedure: var g_check_ids = ; var g_on_off =...
  13. getjbb

    Using Decode

    taupirho -- Thank you so much, I was able to use your code. getjbb
  14. getjbb

    Using Decode

    Actually it has to be in the where clause of a select statement. The result ('Y' or 'N') is being compared to a database field: WHERE DECODE(database_field, NULL, 'N','N','N','Y') = DECODE(incoming_param,'I', 'Y', 'E', 'N', 'A', 'Y' or 'A', 'N') getjbb
  15. getjbb

    Using Decode

    'A' is a parameter coming into a procedure, which is a value set from one of three radio buttons ('I' (Include), 'E' (Exclude), 'A' (All) ). The values of 'Y' and 'No' are being compared against each field within a cursor select. If 'A' is not 'N' or 'Y',which mean it is NULL it should be set...
  16. getjbb

    Using Decode

    DECODE(database_field, NULL, 'N','N','N','Y') = DECODE(incoming_param,'I', 'Y', 'E', 'N', 'A', 'Y' or 'A', 'N') if incoming_param = 'I' then 'Y' elsif incoming_param = 'E' then 'N' elsif incoming_param = 'A' then <I want the be able to capture a row if it is either 'Y' or 'N' when...
  17. getjbb

    Using Decode

    How can I use decode where a value can be either yes or no: DECODE(some_variable, NULL, 'N','N','N','Y') = DECODE('E', 'I', 'Y', 'E', 'N', 'A', 'Y' or 'A', 'N') In other words if the value if 'A' I want rows where a certain field has 'Y' and 'N' getjbb
  18. getjbb

    Looping through an Associative Array

    Thank you so much, LKBrwnDBA. This helps a lot.
  19. getjbb

    Looping through an Associative Array

    If I have an associative array as follows: bookkeeping(EXAM1) := 'Inventory'; bookkeeping(EXAM2) := 'Accounts receivable'; bookkeeping(EXAM3) := 'Inventory'; bookkeeping(EXAM4) := 'Property, plant and equipment'; bookkeeping(EXAM5) := 'Assets'; bookkeeping(EXAM6) := 'Accounts receivable'...
  20. getjbb

    For Loop to access checkbox name

    feherke- What I meant by it did not work is when I the function was called the value was not set to on or off. I took out the period after the form name (theform) and now it work (Thanks). I change the value checkbox value because I need to know what the value is further down in my code to...

Part and Inventory Search

Back
Top