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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by request

  1. request

    How to display messages as soon as the checkbox is checked ...

    I have a checkbox defined as follows on a form: <form name=&quot;form1&quot; action=&quot;act_MList.cfm&quot; method=&quot;post&quot; <td><input type=&quot;Checkbox&quot; name=&quot;Request&quot; value=&quot;#orderid#&quot; align=&quot;right&quot; onclick=&quot;checkAvailability()&quot;></td>...
  2. request

    How to pass the checked values to the next screen ...

    Let me restate my problem that I had originally put : I have a display page where I am displaying records with a checkbox at the end of each record. It looks like as follows: Title Copies CopiesAvailable &quot;Checkbox&quot; On this page, the user can check one or multiple checkboxes. On...
  3. request

    how to specify the max field length for a text box ...

    if I have a text box where the field value has to be entered and the size of the field in the database is 50, how can I specify thhis so that the user can enter max. 50 characters in the text box. Please help.
  4. request

    how to type uppercase

    I have text boxes on a form. When the user types in those text boxes, the values should be displayed in the uppercase. How do I do it? Please help.
  5. request

    How to retrieve NULL field values from the table using LIKE '%'

    I have a stored procedure which has 4 input parameters. An input parameter may not have a value. I have the WHERE clause coded as follows: where field1 like 'p1'||'%' and field2 like 'p2'||'%' and field3 like 'p3'||'%' and field4 like 'p4'||'%' Where p1,p2,p3,p4 are the input...
  6. request

    Too much space b/w two fields on the screen ...WHy?

    I have a cold fusion page with the following: <tr> <th>Copies:</th> <td> <input type=&quot;text&quot; name=&quot;copies&quot; value=&quot;<cfoutput>#GetMediaLibraryDetails.copies#</cfoutput>&quot;> </td> <th>Copies&nbsp;Available:</th> <td> <input...
  7. request

    temp table for each user ????

    Turkbear: Can you please give me an example of how Pl/SQL table can be used so that I can insert / delete records from it. I need 2 columns in PL/SQL table - > name , hours. Please help. thanks.
  8. request

    temp table for each user ????

    Is there a way to create a temp table in ORacle 8 that would be local to each user. I have a crystal report in which I am using the stored procedure. In my stored procedure, I am deleting from a temp table and repopulating it based on the parameter values entered by the user. Now, if multiple...
  9. request

    Determining dates For Saturday for given mmyyyy ...

    Please let me state an example to clarify my question. e.g. in jan 2003, there are 5 weeks. However, for the first week, the number of WEEKDAYS that acutally belong to Jan 2003 is 3. For the second, third, fourth weeks, the number of WEEKDAYS that actually belong to Jan 2003 is 15 (5 days per...
  10. request

    Determining dates For Saturday for given mmyyyy ...

    carp: Since I am going to use the query in a stored procedure, I have used PL/SQL table for an array declaration. Now, I have to determine for a given weekend_date, how many days actually belong to a given month/year. How can I do it? e.g. if the input month/year is Jan 2003, then for the...
  11. request

    Determining dates For Saturday for given mmyyyy ...

    lewisp: Thanks for your great response. Is there a way to store all the weekend dates in an array so that i can go thru a loop and read each value of weekend date. Please let me know. thanks a ton.
  12. request

    Value not carried over across the section. WHY???

    All: Thanks for your suggestions. Let me explain what I am doing in my report. 1. I have a stored procedure embedded in my report. The stored procedure returns 3 columns -> name, setup_date, balance. 2. In my report, I have done grouping by name. 3. The purpose of the report is to create a...
  13. request

    Value not carried over across the section. WHY???

    I cannot use whileprintingrecords in the detail formula. The reason is I am creating a summary on this formula in my report. If I use whileprintingrecords in the detail formula, I can no longer summarize on this formula. Please help. Thanks a ton.
  14. request

    Determining dates For Saturday for given mmyyyy ...

    if for a given month/year, I need to determine the dates for all the Saturdays that month/year and store them in an array, how will I do it? Please help???
  15. request

    Value not carried over across the section. WHY???

    In my report header, I have formula called as EndDate whileprintingrecords; dateVar maxdate; maxdate := date(Maximum ({sp_outstanding_balance;1.setup_date})); maxdate; In my details, I have the formula cal_30_day as follows: dateVar maxdate; numberVar Num_of_days := maxdate -...
See more

Part and Inventory Search

Back
Top