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

all: Thanks for your solutions. It worked.

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.

Thanks a lot, everyone. Actually, I tried doing as follows in CF and it works good: style="text-transform:uppercase" Thanks.

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.

Thanks, mmcc79.

dallasweb: The way my code is, CF_TwoSelectsRelated does not work for me. However , I have the following question: We have a table CUSTOMER where the cust_code/svc_code combination form the primary key. I have a query as follows: select cust_code,svc_code from customer order by cust_code...

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') {...

webmigit: thanks for your suggestion. Will fix my code accordingly. However, I am hoping somebody can help me. I have reached a stage where I cannot proceed with my coding. Any help will be appreciated.

philhege: Nothing is working from me. The reason is my code is not straightforward. Please see part of my code. In the comboselect below, when the cust_code is selected, the dropdown for svc_code has to be populated pertaining to the selected cust_code. For populating the fields, I am calling...

Also, I have 2 queries as below : For the first dropdown, select cust_code from customer order by cust_code For the second dropdown, select distinct svc_code from customer where cust_code = (value selected in the first dropdown) Please let me know if you need more info. thanks.

philhege: Is <CF_TwoSelectedTags> valid with CF 5.0? If yes, then this is not available in our list of installed custom tags. Also, when I say Javascript only, I mean if I could implement this onChange event of the first dropdown. Please let me know. Thanks a ton.

Thanks for your response. Also, I searched this forum for my query. I found several postings. However, I have finally figured out that I need to implement this using JavaScript only. I have 2 dropdowns. Ths first dropdown is cust_code that is being populated from customer table. When the user...

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