Search results for query: *

Is there a way of disabling the running totals in an excel pivot table ? Pivot ----- Sum of Count Total MM a 30 MM Total 30 --> Not Required PP a 10 d 10 PP Total 20 --> Not Required RM a 50 d 30 RM Total 80 --> Not Required Grand Total 130 Data (to create above pivot)...

I am exporting a grid view to excel using the the code as below; using System; using System.Data; using System.Configuration; using System.IO; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using...

I am doing private DataTable CreateDataTable() { DataTable myDataTable = new DataTable(); DataColumn myDataColumn; myDataColumn = new DataColumn(); myDataColumn.DataType = Type.GetType("System.String"); myDataColumn.ColumnName =...

How can I set a string as follows string mm="amt (€)"; ? When I display I am getting amt (€) thanks for any help.

That would be the sysdate, while I need a constant which is a date. thx, Matt

Hi Mufasa, the thing is I have to load data from files having a date in the file name (MM_20090309_EXEC_2.csv) and need to have the date in the name as one of the entries. So I used sed in Unix to change the controlfile to the date and need to load hope to load it as a constant. I have a...

I need to load a date as a constant into a table. I tried; LOAD DATA APPEND INTO TABLE "HLR_OWNER"."FOR" FIELDS TERMINATED BY ',' (MS, IM, Filedate "to_date('20090309','YYYYMMDD')" ) but I get; Record 1: Rejected - Error on table "FOR", column FILEDATE. Column not found before end of logical...

I need to pass a parameter having an * representing a list of files >touch mm1 >touch mm2 emacs tt.ksh FF=mm* echo call $FF >chmod u+x tt.ksh > ./tt.ksh call mm1 mm2 How can I display call mm* ? thx

I have a method public List<string> getMList() { List<string> listM=null; listContracts.ForEach(delegate(Cobj contract) { listM.Add(contract.M); }); return (listM); }...

Using Visual Studio 2005, c# I have in Source view; <td style="width: 193px; height: 31px;"> Name </td> <td style="width: 327px; height: 31px"> <asp:TextBox runat="server" ID="txtName" AutoPostBack="true"...

I tried HttpContext.Current.Response.Charset = "UTF-16"; (as below) and some others but still no luck. thanks. public class GridViewExportUtil { /// <summary> /// /// </summary> /// <param name="fileName"></param> /// <param...

Exporting to excel (VS 2005 .Net c#), I am having problems with the €. 10660 56660 € 158,58 € 158,58 is becoming 10660 56660 € 158,58 € 158,58 It is the footer of a grid, extracted using if (gv.FooterRow != null) {...

Hi Mufasa, all, I want to have two SQL programs; 1. Loads array into memory and passes the array to program 2. 2. Performs processing on the array So that in SQL I run say; SQL> @load_array SQL> @process_array So how can I define the array such that process_array can see what was loaded...

I have a script that loads a huge array. Kind of Declare PROCEDURE pLoadArray (vaCustcode_num IN OUT vacustcodednno) IS iarraysize INTEGER := 3000; i INTEGER; vErrorMessage VARCHAR2 (256) := ''; BEGIN FOR i IN 1 .. iarraysize LOOP...

I need to use in xls v2003 the option; Edit --> Fill --> Series for some reason Series is shaded and cannto be selected. Down , Right , Up, Left and Justify are not shaded. If I start a blank worksheet it works so I am having to make series on a blank worksheet and paste them in. Any help...

Hi all, I was wondering if a way of doing select * from table name where column in array (); without looping as below; for i in 1 .. 100 loop select * from table name where column_name=array (i); end loop; which would mean retriving the values one by one which is not so good as the...

Is there an easy way of checking if a date is in the format YYYYMMDD ? I have a script that takes a date as input and need it to exist with error in the case of an invalid date. eg >check_report 20070788 ERROR invalid date thanks

Hi Mufasa, problem solved. It seems the temp file was not actually in use and could just be deleteed. Not sure how it came about but problem is solved. thanks

Hi all, is dbverify not designed to handle temp tablespaces ? As below it works on system but will not accept a temporary tablespace. thanks C:\ora_920\oradata\IMSII>dbv file=SYSTEM0.DBF blocksize=8192 DBVERIFY: Release 9.2.0.1.0 - Production on Thu Apr 5 10:28:31 2007 Copyright (c) 1982...

Can any of you supply me with IZ0-032 study materials. Testking or any other is fine . Your help is appreciated Thanks