Recent content by request

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