Are there any programs with a gui which let you create a SQL database, create tables, define the primary and foreign keys and insert data? I am tired of having to use the mysql command line client, very tedious.
in my project i have existing csv file and all they have up to 20 lak records.
and they all i store in my sql database.
so plz help me how can i do this.
i use sql bulk insert query but they didn't run in asp.net
$.ajax({ type: "POST", url: "OMFG.php", data: info, success: function(){ }});
is what I'm using atm as a test and it works fine.
I need to get the url from the link I'm clicking, so I do:
var url = $(this).attr("href");
which works fine if I alert it out(the link includes http://samedomain.com/etc.php), but the ajax function doesn't post if I insert it into the ajax code:
$.ajax({ type: "POST", url: url, data: info, success: function(){ }});
Please help, as I'm screwed without this working.
Maybe this is a stupid question.
In php application I used to insert properly htaccess in home directory that redirect from example.com at www.example.com.
But with django how I have to do ?
Hellow all,
I have the following xml lines:
"phone" and "city" attributes are optional, but if "phone" exists, also "city" should exists and vise versa. Is it possible to insert such restriction to XML schema?
Thanks.
I find Vim's undo to be a bit too coarse. E.g. if I type something like this:
a // to go into edit mode
to be or not to ve
<esc> // to exit insert mode
Oops! I made a typo. I want to start undoing so I press u, but then it clears the whole line. Is there a way to undo word-by-word or character-by-character?
It's been ages since I last used Access as a back end but I'm being forced to. I'm using Enterprise Library 4.1, the Data Access Application Block.. with .NET 3.5 and I wanted to know the best way (code sample if possible) to write an insert query that will automatically give me the newly inserted auto-number back..or if it's not possible to do it in one step, how do you recommend doing it?
thanks for your help.
Dear reader,
I'm working on a project where the user can insert data into a document using fields, document properties and variables. The user also needs to be able to remove the data from the document. So far, I've managed to remove the document property and variable, but I'm not sure how I would go about removing the field (that's already inserted into the document). Please advise.
Yours sincerely,
Kevin
Besides doing it manually using regular expression search, is there other better ways to parse a JAD file?
I need to be able to search for and replace/insert a new MIdlet-Install-Notify property to a JAD file given, also updating the value of the MIDlet-Jar-URL property.
Using ANTLR or TinyPG is a bit overkill for my case.
TIA
Hi ,
I am getting the following exception "org.hibernate.HibernateException: The database returned no natively generated identity value "while adding data into database i am using the following code.Please let me know what is wrong
Sesion session=HibernateUtil.getSession();
Transaction tx = session.beginTransaction();
session.save(user);
logger.info("Successfully data insert in database");
tx.commit();
isSaved=true;
Thankx
if i try to add some data into my table error occurs:
Error:Msg 8101, Level 16, State 1, Line 1
An explicit value for the identity column in table 'ENG_PREP' can only be specified when a column list is used and IDENTITY_INSERT is ON.
insertinto ENG_PREP VALUES('572012-01-1,572012-01-2,572012-01-3,572013-01-1,572013-01-2',
'',
'500',
'',
'A320 P.001-A',
'Removal of the LH Wing Safety Rope',
'',
'',
'',
'0',
'',
'AF',
'12-00-00-081-001',
'',
'',
'',
'',
'',
'',
'' )
Hi,
While working with DB, I find useful using some tools, that help me to solve DB problems.
Some of them are:
1) Insert generator
2) A tool that can execute a script on a list of DB's
3) Finding a text in stored procedures and functions.
4) DB Back up scripts
My question is, what are most useful tools, scripts(anything else), that help you to work with MS SQL?
Thanks in advance.
I am using word 2007 and am inserting code into the document. I have a style with a fixed-width font and light grey background and all, and I use Notepad++ for syntax highlighting.
My problem is with a "line" of code that is too long to display, so is there a way to auto-insert an arrow symbol at the beginning of a such lines to indicate that it is the same line (kind of like hyphenating, except on long lines instead of long words)
So for e.g. something like this:
public static void foo(String abcdefg, Boolean 123,
?String xyz)
Hello
I installed Eclipse and Android ADT. When I create android project and try to run, I get following on main.out.xml file:
This document is empty.
Right click here to insert content
However, main.xml file has xml data for layout.
Please help what I need to do after right clicking. Thanks
Hello,
As the title said, I have a CAF file and I want to insert that file into a video file using ffmpeg(Programmatically ) using C.
CAF file has Linear PCM audio format
I am successfully able to build the video file and now want to add the audio to the video file from CAF (Core Audio Format) file.
Can anyone provide a sample please.
Thanks
I want to combine these two queries into one:
mysql_query("INSERTINTO categories (name, parent) VALUES ('$name', '$parent')");
mysql_query("UPDATE categories SET child='$child' WHERE ID = $id");
Can it be done?
Hello
I have a mysql database table to store country name and currency symbol - the CHARSET has correctly set to UTF8.
This is example data inserted into the table
insertinto country ( country_name, currency_name, currency_code, currency_symbol) values
('UK','Pounds','GBP','£');
When I look in the database - the pound symbol appears fine - but when I retrieve it from the database and display it on the website - a weird square symbol shows up with a question mark inside instead of the pound symbol.
You can look at it here - http://www.didyouswipe.com/profile/view-profile/user_id/181
Please advice
Thanks
how to implement a counter in label which decrements every time page is loaded in asp.net(vb)?
It would be better if that counter value is accessed from and updated into database..
I've tried this on buttonclick but the value is reset automatically to intial value everytime
as the button is insert and page is reloaded
Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.EventArgs)
Dim entries As Label = FindControl("label1")
entries.Text = entries.Text - 1
End Sub
I got a model TrackedItem with a generic relation linking to any model it is supposed to track.
If I do that:
t = TrackedItem(content_object=MyModel)
t.save()
t.save()
I get :
IntegrityError: (1062, "Duplicate entry '1' for key 'PRIMARY'")
Indeed, the first save has created an entry with "1" as a PK. But the second save should not insert, it should update.
How am I suppose to update a model I can't save twice?
With an ordinary model I can save as much as I want.
I have a list of tuples.
[
"Bob": 3,
"Alice: 2,
"Jane": 1,
]
When incrementing the counts
"Alice" += 2
the order should be maintained:
[
"Alice: 4,
"Bob": 3,
"Jane": 1,
]
When all is in memory there rather simple ways (some more or some less) to efficiently implement this. (using an index, insert-sort etc) The question though is: What's the most promising approach when the list does not fit into memory.
Bonus question: What if not even the index fits into memory?
How would you approach this?
I have a bunch of records with dates formatted as a string such as '04/17/2009'
I want to convert them to a mysql datetime field
I plan to use a foreach loop to read the old date value and insert the newly formatted value into a new field in each record
what would be the best way to convert that string...I thought php might have a way to do it automatically?
thanks
User writes a series of tags (, separated) and posts the form.
I build an array containing the tags and delete dupes with array_unique() php function.
I'm thinking of doing:
go through the array with foreach($newarray as $item) { ... }
check each $item for existence in the tags mySQL table
if item does not exists, insertinto tags table
Is there a FASTER or MORE OPTIMUM way for doing this?
Hey all,
I'm trying to set the title of the header of my entire UITableView, but am having no success.
For example, on this webpage:
http://www.iphonesdkarticles.com/2009/01/uitableview-sectioned-table-view.html
I am trying to replicate creating the "Countries" header programmatically. I have a UITableView that works and displays data. When I insert the following line:
self.navigationItem.title = @"Countries";
In my viewDidLoad method, nothing happens. Thoughts?
Everything possible with the OleDBDataReader class.
ExecuteReader() for SELECT statements, and ExecuteNonQuery() for DELETE, UPDATE and INSERT statements.
So why is OleDbDataAdapter class needed?