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

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

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

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

I have created a screen which has the stored procedure at it back end. On the screen, there is a field called as TITLE. The user can enter any value of TITLE and hit <SEARCH>. e.g the TITLE is ORACLE HANDBOOK. The user can enter the TITLE as 'RAC', 'HAND' , etc. How can I use INSTR function...

I have the stored procedure output as follows: name reghrs prodhrs vachrs TA 2 0 0 TA 0 6 0 DA 8 0 0 DA 0 2 0 DA 0 0 3 Instead, I want my stored procedure output to look as follows: name reghrs prodhrs vachrs...

I have a CF screen where I have to enter the search criteria. Once the search criteria is entered, the SUBMIT button is clicked to display the records that meet the search criteria on the LIST screen. At the end of each record displayed on the LIST screen, there is a checkbox. The user can...

I am creating a Crystal report where the stored procedure will be used. In my stored procedure there will be 2 tables used -> EMPLOYEE and TIME In my report I have to display the records as follows: Employee Time Now, all the employees will not have the time entered. In other words, all...

I have a stored procedure in which I want to execute a shell script. How can I do it?

I have Oracle 8i version. I have to code a stored procedure in which I have to send an-email to certain people whether the procedure fails or succeeds. How can I do it? Please help. Any assistance will be greatly appreciated. thanks.

I am calling a crystal report from my COld Fusion page. After the crystal report runs, I need to know if the report had run successfully or not. This has to be returned to the Cold Fusion page, so that some updates can be done on the Cold Fusion page if the report had run successfully. Please...

I have the following CFGRID related questions: 1. On a single page, I have 4 <CFGRID>. The problem is when I reach that page, sometimes some of the grids are partially populated or sometimes some of the grids are not populated or sometimes all the grids are populated correctly. Why does this...

We have a report in Crystal Report 7.0. When I run the report in crystal and try to export it in .RTF (Rich Text Format),there is some space left at the top of each page in .rtf file. However, if I export the same report to a Word document, it looks good. Please let me know why do you think...

Currently, we have Cold Fusion 4.5 but we want to migrate to Cold Fusion 5.0. When I am testing the code that I had in Cold Fusion 4.5, in Cold Fusion 5.0, it gives me an error for CFGRID. On the form page, I have as follows: <cfgrid name=&quot;DisplayInfo&quot; height=&quot;75%&quot...