insert

insert simple text into iframe ? not .htm file

hi, is it possible to insert simple text into iframe ? trying to do small texteditor with this tutorial http://www.devarticles.com/c/a/HTML/Building-a-WYSIWYG-HTML-Editor-Part-1/ and want to have some text in iframe, which i can then change.. but i don't want to get that text from some external html file. it is possible to insert te...

MySQL cuts off string at special chars

Hello, I'm trying to insert remote POST data (articles sent by iSnare) into MySQL with PHP. Data comes successfully from remote POST sender and I can write it to plain-text file without a problem. Unfortunately, when it comes to insert it into MySQL, MySQL cuts off string (article) at special char. I tried many things but still I'm uns...

MySQL Insert & Joins

i saw this In MySQL, joins work for INSERT, UPDATE, and DELETE statements. It's possible to change data in more than one table when joining tables in an UPDATE or DELETE statement. in an answer for a question from the mysql certification guide. is it true? inserts with joins? an example of it? ...

MYSQL INSERT SELECT problem

Hey all, i have a little difficulty in understanding how to do some INSERT SELECT. For instance i have two tables. TABLE : users id | name | gender 1 | John | m 2 | Mary | f TABLE : website fid | url | id 1 | www.desilva.biz | 2 2 | gidhelp.com | 4 Now let's say i want to add anoth...

Silverlight Asynchronous Crud Insert: One-to-One relationship ?!?!

I've been following this tutorial on how to implement a Silverlight application. The tutorial uses the Northwind database for its examples. I have been using the code samples to implement the same functionality as the tutorial shows into my own application with my own database. The last part of the tutorial shows how to add new items and...

Grouping values for INSERTion into table

I'd like to be able to insert some values into a table using a single INSERT statement, but I'm having trouble determining the best way. The data I'm inserting is bootstrap (or hard-coded) data, ie. not available in another table. Here's what I've tried so far. create table #t (id int) insert into #t values (1) --- (a) insert into #t ...

MySQL delete all results of sub-query

Tonight may be the night I crack... Okay, so if you would like a back story, look at my previous question I have finally decided that if this is possible, It's not worth the time it will take to figure out, since I really should have had this done before tonight anyway. So I decided to go another route: Figuring out which of my record...

Setting up/Inserting into Many-to-Many Database with Python, SQLALchemy, Sqlite

I am learning Python, and as a first project am taking Twitter RSS feeds, parsing the data, and inserting the data into a sqlite database. I have been able to successfully parse each feed entry into a content variable (e.g., "You should buy low..."), a url variable (e.g., [u'http://bit.ly/HbFwL']), and a hashtag list (e.g., #stocks', u'#...

how to set a null value to a field in a table using oracle sql developer tool ?

Hi, Oracle SQL Developer allows you to update field values directly to the table without needing to write a sql script. However it doesnt allow you to set a null value for a field? the update script that gets generated is below : UPDATE "TABLE" SET field_required = 'null' WHERE ROWID = 'AAAnnZAAFAAAGMfAAC' AND ORA_ROWSCN = '14465324' An...

No simple way to "include" in Java?

When logically something seems as if it would be dead simple, then it turns out to be completely convoluted, I have not used Java much, so please forgive my ignorance. Here is what I am trying to do: I have a nice clean algorithm in one .java file, and I want to feed it from an initialized array. The array contains over 40,000 elements...

How to parse XML and insert content into HTML form using jQuery ?

Hello ! I have a simple XMl file with image tags: XML: <img src="images/image1" alt="My Image 1" /> <img src="images/image2" alt="My Image 2" /> <img src="images/image3" alt="My Image 3" /> <img src="images/image4" alt="My Image 4" /> I need to insert this content ("src" attrib) inside a <div> tag in my HTML form. HTML: <div id="p...

how to insert javascript code via jquery ?

hello, here is my code: <html> <head> <script src="http://ajax.googleapis.com/ajax/libs/jquery/1.3.2/jquery.js"&gt;&lt;/script&gt; </head> <body> <div id="example"> </div> <script type="text/javascript"> function insert() { var data = '<script type="text/javascript"> function test() { a = 5; }<\/script...

Increase performance on DELETE/INSERT on remote server

In this scenario there are two database servers: one is in our LAN (Server A) and one on our remote location (Server B). We want to transfer the data of our projects from Server A to Server B. To do this we first remove the existing data on Server B for a certain ProjectID and after that simply insert the data from Server A to Server B....

How to track number of views in the most efficient way?

I've this blog-like system (LAMP) and I'd like to track number of views of every article. Now, is it better to update the article's views column every time the article is viewed or use some temp table, where I'd store only the article ID, and then (let's say every hour) run a query that would take the data from the temp table and update ...

what am i doing wrong with my vba?

i cannot see why this would be an issue. i use the msgbox to display my strSQL, but it looks perfectly fine. Dim strSQL As String strSQL = "INSERT INTO Jobs (Date, RefNo, ProjectID, PManager, PDesc, PONo, Src_Qty, WC_Qty, Rate, Total, Note, Company) " strSQL = strSQL & "VALUES (" & JobDate.Value & ", '" _ & T...

Using vim to get filename into files

Hi folks, I have a number of text files (700+) and I need to get each file's name into the start of every line in the file. Example, for filename myfile0072.txt mike 160 jane 174 to myfile0072.txt mike 160 myfile0072.txt jane 174 I don't have access to bash or c or perl or anything at work. Is there something I can do in vi...

Whats the best way to INSERT (500-700) words into an MySQL database, for the purpose of a dictionary/histogram

I have to create a histogram/dictionary of all words found in parsing an html file. This includes a dictionary of all words found, and a histogram of their frequency. I cant think of how to do this with PHP/MySQL because there could be potentially 2000 words that would have to be INSERTED at once =/ Any ideas? ...

Number of Records in Insert Statement (Oracle)

I'd like to report on the number of records inserted in an Oracle insert statement. I'm inserting from a statement, so I could run my select twice and a count, but I'd rather keep it all in a single statement. Is there a way? ...

Insert Variables into a table which is selected from a PHP variable name

So, I want to insert some data into a MySQL table where the table name that the data is being put into is a PHP Variable. Something like this: $tablename = "databasetable"; $insert = mysql_query( "INSERT INTO '".$tablename."' (column1, col2) VALUES ('Blah', 'Blah') "); But that of course doesn't work, so I'm not sure what to do. B...

Using insert rows in a UITableView

I'd like my UITableView to behave like the the table in the Contacts editor, i.e. the user should hit Edit and an "add new category" row should appear at the bottom of each section. I'm using the below code to do this, but the problem is that there is no smooth transition as there is in Contacts. Instead, the new row suddenly appears. ...