Search results for query: *

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>...

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...

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.

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.

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...

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...

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.

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...

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...

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...

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.

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...

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.

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???

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 -...

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...

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.

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...

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...

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 ---- ---------- ----------...