Generate several sql insert from an sql select sentence
How can I generate some insert sql sentences using a specific select query. Are there any tool from Ms Sql Server 2008? or else? ...
import
How to install pyobjc on SnowLeopard's non-default python installation
Hi everybody. I'm having problems installing pyobjc on SnowLeopard. It came with python 2.6 but I need 2.5 so I have installed 2.5 successfully. After that I have installed xcode. After that I have installed pyobjc with "easy_install-2.5 pyobjc" But when I start my python 2.5 and from cmd line try to import Foundation, it says "no modu...
How to create a new IDA project based on an existing one with different offsets?
I have an existing IDA Pro project for a C166 processor embedded application. This project already has many functions, variables, etc defined. There are different versions of the embedded application I am looking at. The different versions of the application are 99% the same, but with slight variations in code and data that cause functi...
Why does Python's __import__ require fromlist?
In Python, if you want to programmatically import a module, you can do: module = __import__('module_name') If you want to import a submodule, you would think it would be a simple matter of: module = __import__('module_name.submodule') Of course, this doesn't work; you just get module_name again. You have to do: module = __import__...
Should I use `import os.path` or `import os`?
According to the official documentation, os.path is a module. Thus, what is the preferred way of importing it? # Should I always import it explicitly? import os.path Or... # Is importing os enough? import os Please DON'T answer "importing os works for me". I know, it works for me too right now (as of Python 2.6). What I want to kno...
What does the Microsoft.WebApplication.targets import do in VS 2010 web application projects?
Visual Studio 2010 seems to insist on having this import in web application projects <Import Project="$(MSBuildExtensionsPath32)\Microsoft\VisualStudio\v10.0\WebApplications\Microsoft.WebApplication.targets" /> What does this import give us and is it really required? On a side note if you remove this import with a text editor Visual ...
How to import csv files
How can I import CSV file data into SQL Server 2000 table? I need to insert data from CSV file to table twice a day. Table has more then 20 fields but I only need to insert value into 6 fields. ...
Best way to migrate export/import from SQL Server to oracle
Hi guys! I'm faced with needing access for reporting to some data that lives in Oracle and other data that lives in a SQL Server 2000 database. For various reasons these live on different sides of a firewall. Now we're looking at doing an export/import from sql server to oracle and I'd like some advice on the best way to go about it......
Read tab delimited text file into MySQL table with PHP
I am trying to read in a series of tab delimited text files into existing MySQL tables. The code I have is quite simple: $lines = file("import/file_to_import.txt"); foreach ($lines as $line_num => $line) { if($line_num > 1) { $arr = explode("\t", $line); $sql = sprintf("INSERT INTO my_table VALUES('%s', '%s', '%s', ...
Passing variables in python when using from a import *
How can I make this print "baz" when I run b.py? a.py def foo(): global bar print bar b.py from a import * bar = "baz" foo() ...
Importing Ascii/Grid file with MapXtreme2008 ?
We are looking at upgrading to MapXtreme2008 from MapX4.5/Vertical Mapper3 with the 60 days trial version. We are not able to import Ascii/Grid file with MapXtreme. We have try posting on the MapXtreme forum, but no answer so far. Thanks. http://en.wikipedia.org/wiki/ESRI_grid ...
How to make Excel strip ALL quotes from CSV text fields
When importing a CSV file into Excel, it only strips the double-quotes from the FIRST field on the line, but leaves them on all other fields. How can I force Excel to strip the quotes from ALL strings? For instance, I have a CSV file: "text1", "text2", "numeric1", "numeric 2" "abc", "def", 123, 456 "abc", "def", 123, 456 "abc", "de...
Vim & Java: add java import statements automatically
The tip. The errors are "E349: No identifier unders cursor", "E433: No tags file" and "E426: tag not found: public". I feel them unrelated or I cannot understand their message. I have the code in "~/.vimrc" and pressed "F1", "F9" and "ESC". A related tip but more advanced. so how can I add Java import statements automatically in Vim? [A...
#import still gets "duplicate symbol" error
When I compile my iPhone app, xCode gives "duplicate symbol" error for my variables in MyConstants.h I thought if I used: #import "MyConstants.h" it would avoid that? But I still have the problem. Added info: The error occurs during "linking". (I'm just using xCode's "Build and Go" button.) I also tried the (unnecessary with #im...
LWJGL not working
I'm working on a homework assignment to modify code given by my professor using LightWeight Java Game Library. The problem is that I can't fully load the test code to begin testing modifications. I've linked against the jar file as it says to in the modifications, but I still have one lingering error. The import statement import org.lwj...
Should I *always* import my file references into the database in drupal?
I have a cck type with an image field, and a unique_id text field. The file name of the image is based on the unique_id. All of the content, including the image itself is being generated automatically via another process, and I'm parsing what that generates into nodes. Rather than creating separate fields for the id and the image, and do...
Import module stored in a cStringIO data structure vs. physical disk file
Is there a way to import a Python module stored in a cStringIO data structure vs. physical disk file? It looks like "imp.load_compiled(name, pathname[, file])" is what I need, but the description of this method (and similar methods) has the following disclaimer: Quote: "The file argument is the byte-compiled code file, open for reading...
export and import utf8 data in mysql: best practices
We're often faced with the need to send a data file to one of our clients with data from the database he/she needs to translate. Most of the time this export is CSV or XLS. Most of the time we create a csv dump with phpmyadmin and get an xls file in return with the translated data. The problem is that most of the time the data is UTF8 an...
Oracle 10g express edition import
How can i import a DMP file into my oracle 10g expression edition database? I tried with imp but its showing an error: IMP-00010: not a valid export file, header failed verification IMP-00000: Import terminated unsuccessfully How can i solve this? ...
Import Eclipse workspace with cyclic dependencies to NetBeans
I'm trying to import an Eclipse workspace consisting of about 10 projects (3 web applications and other class libraries) to NetBeans. The problem is that these projects have some circular dependencies. When I try to import the workspace into NetBeans, it gives lots (about 50? 60?) warnings about the circular dependencies. After frenetic...