Search results for query: *

how do I convert string to a number value. I have the database field value as 1 which is of the type string. I have to convert this value 1 into number datatype and add 1 to it. Please let me know. Thanks in advance for your help.

In my Crystal report, I need to show the alternate line displayed in yellow color. How can I do it? Also, I am suppressing some lines in my report if a given record has the same id as the previous record. Please help.

I have fields on my form page that go beyond the page. However, the vertical scroll bar on the right do not automatically show up. Why? Please let me know if there is a way that I can fix this. Thanks.

I have a page divided into 2 frames . The code is as follows: <cfoutput> <frameset name="CreateCustMain" rows="235,200,*" framespacing='0' frameborder='1' border='0'> <frame name="CreateCustTop" src="frm_customer_top.cfm" marginwidth='0' marginheight='0' noresize scrolling='no'></frame> <frame...

I have defined as follows: <cfparam name="URL.cust_name_hold" default=""> Later on, if I have to check if URL.cust_name_hold has a value or not, how will I write the IF statement? Please let me know. Thanks.

If I want to display a certain field in a formatted form when the page is displayed, on what event can I do this. e.g. I have the text box for phone number on my Edit form. I have written a javascript to format the phone number. However, when the Edit form is displayed, I want to display the...

I have a page divided into 2 frames. The upper frame is a search screen whereas the lower frame displays the search results. Also, when the records are displayed in the lower frame, there are 2 hyperlinks -> Edit and Del displayed next to each record. My problem is if I click on Del hyperlink...

I have a field last_update of the type DATE in ORacle. To update this field with today's date, I am doing as follow: last_update = #createODBCDate(now())# However, this gives an error. What wrong am I doing here? Please help.

Is there a way that when the user is typing in the text box, that the letters get typed in the uppercase. Please let me know. Thanks in advance.

I have defined the checkbox as follows in my form: <tr align="left"> <th width="15%" align="right">Int'l Ind</th> <td> <input type="checkbox" name="intl_ind" id="intl_ind"> </td> </tr> In my javascript, I am doing as follows: var ind=customerInfo[ind].intl_ind; if (ind == '1') {...

I have 2 dropdowns on my screen. One is for cust_code and the other is for svc_code. A given cust_code can have multiple svc_code values. Hence, when a cust_code value is selected from the dropdown, then the svc_code dropdown need to be refreshed and be populated with the values that are valid...

how can i calculate median thru a SQL QUERY. To the query below, I need to add MEDIAN(TOTAL_HOURS) for each HRID. Please help. My query is as follows: SELECT A.HRID, LTRIM(RTRIM(A.LAST_NAME)) || ', '||LTRIM(RTRIM(A.FIRST_NAME)) || ' '||LTRIM(RTRIM(A.MIDDLE_NAME)) AS EMPLOYEE_NAME...

How do I set autocommit off in my stored procedure. itried using the command set autocommit off but this gives me an error please help. thanks.

I have a stored procedure where I have the following query: v_item_no := 0; select min(item_no) into v_item_no from order_items where status = 'A'; retCode := SQL%ROWCOUNT; If the record does not exist in order_items table, then the value of v_item_no should be 0. ALso, retCode should...