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!

Search results for query: *

  • Users: request
  • Order by date
  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 -...
  16. request

    How to replace Aged crystal functions with formulas???

    I tried to implement as per the suggestion {table.def_date} >= {table.setup_date}-29 and {table.def_date} <= {table.setup_date} I put the above in a formula. Now I want to create the summary total on this formula. However, now when I right click on this formula is does not show me...
  17. request

    How to replace Aged crystal functions with formulas???

    I am not sure what you mean by table.datetime. Please let me know. Also, can you give me an example of atleast for 2 aging buckets. aged0to30days aged31to60days. thanks a ton.
  18. request

    How to replace Aged crystal functions with formulas???

    I have used the crystal functions Aged0to30days, Aged31to60days and so on in my crystal report. However, I have to replace the above Aged functions with a formula that will calculate the 0-30 days, 31-60 days and so on using the database field steup_date as the reference instead of today's date...
  19. request

    How to avoid displaying too much space between 2 fields

    I have to display 4 dropdowns on a form, with a pair of dropdown on each line. F1 F2 F3 F4 where F1,F2,F3,F4 are the dropdowns. For formatted display, I have used <TABLE> tag with <TR> tag around F1/F2 and F3/F4. However, my display is getting messed up. There is too much...
  20. request

    Transpose QUestion ...

    SantaMufasa: I am sorry I did not completely state my query. However, in my query in the stored procedure, I do have group by and the same number of columns in select clause. However, I do not want my output to look as follows; NAME REGHRS PRODHRS VACHR ---- ---------- ----------...

Part and Inventory Search

Back
Top