create

How to create and update spreadsheet using OLEDB in C#?

HI! all I am creating .xls spreadsheet file using following code using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\temp.xls;Extended Properties='Excel 8.0;HDR=Yes'")) { conn.Open(); OleDbCommand cmd = new OleDbCommand("CREATE TABLE [NewSheet] ([Column1] string, [Column2] string)...

Create CRM Organizations on Load Balancing network

I'm trying to understand how to create CRM Organization on Load Balancing network. I've three web servers (Web01, Web 02, Web03); three application servers (App01, App02, App03) and a SQL Server (SQL01). I already have Load Balancer setup and there is already one organizaiton setup by someone on all web servers. This organization is I...

PROBLEM WITH FPDF

Hello i'm trying to create a report using FPDF from a website using php, see i need to put a signature line at the en of the report, but I don't know how, can you help me?? ...

How do i create a table dynamically with dynamic datatype from a PL/SQL procedure

CREATE OR REPLACE PROCEDURE p_create_dynamic_table IS v_qry_str VARCHAR2 (100); v_data_type VARCHAR2 (30); BEGIN SELECT data_type || '(' || data_length || ')' INTO v_data_type FROM all_tab_columns WHERE table_name = 'TEST1' AND column_name = 'ZIP'; FOR sql_stmt IN (SELECT * FROM test1 WHERE zip IS NOT NULL) ...

WebRequest.Create problem

My requirement is downlaoding a HTTM page. Like and I am using WebRequest.Create. But the line HttpWebRequest request = (HttpWebRequest) WebRequest.Create("http://www.mayosoftware.com"); Is throwing an exception {"Configuration system failed to initialize"}. I am working in a compmany. Does it due to proxy or anything? But it’s occu...

[C# n MySQL] Creating a database using Connector/NET Programming?

How to create a database using connector/net programming? How come the following doesn't work? string connStr = "server=localhost;user=root;port=3306;password=mysql;"; MySqlConnection conn = new MySqlConnection(connStr); MySqlCommand cmd; string s0; try { conn.Open(); s0 = "CREATE DATABASE IF NOT...

Find contacts created after a particular time-stamp

Hi, is it possible to know the time at which a contact was created. Actually I want to find all contacts created after a particular time (say 12:00 pm 29th march 2010). I thought that the contact ids were assigned in an increasing order and just noting the largest id at that point would suffice. But with Android 2.0, the internal syn...

Rails controller when no ActiveRecord model ?

Hello, I'm trying to create a rails web app that does not use ActiveRecord framework as I have no relational database back end. So far I managed to create a simple example application that works perfectly for listing, showing and editing my records. However I'm facing some problems when it comes to the record creation. The issue is...

How to add the java application to the mac installer

HI Any one can get the idea to create the APP file to make my application to install in macos Thnaks in advance ...

How to Create Element in XSLT When Copying Using Templates

Hello, I'm trying to create an element in an XML where the basic content is copied and modified. My XML is something like <root> <node> <child>value</child> <child2>value2</child2> </node> <node2>bla</node2> </root> The number of children of node may change as well as the children of root. The XSLT should copy the wh...

How do I use a .NET class in VBA? Syntax help!

ok I have couple of .NET classes that I want to use in VBA. So I must register them through COM and all that. I think I have the COM registration figured out (finally) but now I need help with the syntax of how to create the objects. Here is some pseudo code showing what I am trying to do. EDIT: Changed Attached Objects to return an Arr...

Excel VBA to Create SQL Table

Hi All, I have found the following code which is suppose to create a SQL table within a SQl Database. The database is specify in dbpath and the table to be created is in tblname. However when i run this code i have a problem finding to right SQL database. For example if i specify the dbpath as "WIN2k8\Test\ABC" ie the machine name i...

Creating share programmatically fails with error 9

ObjectGetOptions options = new ObjectGetOptions(); ManagementPath p = new ManagementPath("\\\\server01\\root" + "\\cimv2:Win32_Share"); // Make a connection to a remote computer. ManagementScope scope = new ManagementScope("\\\\server01\\root\\cimv2"); scope.Connect(); // Create a ManagementClass object ManagementClass managementClas...

ADD COLUMN to sqlite db IF NOT EXISTS - flex/air sqlite?

I've got a flex/air app I've been working on, it uses a local sqlite database that is created on the initial application start. I've added some features to the application and in the process I had to add a new field to one of the database tables. My questions is how to I go about getting the application to create one new field that is ...

MOSS - Create folder with read only..

The following works. How do I add ReadOnly = true to this newly created folder (Item. Folder. ReadOnly) SPListItem myItem = properties.ListItem; SPList documentLibrary = myItem.ParentList; SPListItem folder = documentLibrary.Folders.Add(documentLibrary .RootFolder.ServerRelativeUrl, SPFileSystemObjectType.Folder, "My New Folder"); fol...

creating email forwarding accounts on the fly using PHP

Hi, i was wondering if it was possible to create email forwading accounts on the fly as I have created subdomains for uses profiles i.e. user.profile.com and was wondering if I could create [email protected] to forward to their email account? Regards, Phil ...

table lock while creating table using select

Using mysql version 5.0.18 I am creating a table TT, Client 1 set autocommit = false; start transaction Create table TT select * from PT; PT has tow columns pk bigint not null,name varchar(20) Client 2 set autocommit = false start transaction insert into PT values(123,'text'); While inserting a row in PT , it is waiting for the table ...

how to write or create (when no exist) a file using python and Google AppEngine

this is my code: f = open('text/a.log', 'wb') f.write('hahaha') f.close() and it is not create a new file when not exist how to do this , thanks updated class MyThread(threading.Thread): def run(self): f = open('a.log', 'w') f.write('hahaha') f.close() error is : Traceback (most recent call last): ...

DB2 Child Table Not Working - Create Table

I have a bit of a task before me. (DB2 Database) I need to create a table that will be a child table (is that what it is called in SQL?) I need it so that it has a foreign key constraint with my other table, so when the parent table is modified (record deleted) the child table also loses that record. Once I have the table, I also need t...

What's the proper workaround for creating a div with a table in it with images in the table?

I want this: <div id="display"> <div id="slideshow1"> <table cellspacing=0><tr><td style="height:200px;padding:0;vertical-align:middle"> <img ... /> </td></tr></table> </div> </div> And I'm using this: var thelistt = localStorage.getItem('thelist') var trt = document.createElement("div"); trt.setAttribu...