i have problems inserting multiple records in symfony what happens is the 2nd up to the last records just updates the first record ex: $n = new Object(); // start loop until i = 5 $n->count = $i; $n->text = 'a'.$i; $n->save(); i++; //end loop after this loop theres only 1 record... count = 5, text= a5; is there a way to clear $n so...
Hi, I have an Access application in which I need to do a 'mass-update'. I have a form on which I have a dropdown, a listbox, and a checkbox. I also have a Update button, and when the user clicks it, I want to insert rows into my table with the same value for the dropdown and checkbox fields in all the rows, but I want different values f...
What I would like to do is insert a "t" into the path of the image like so: <img src="../images/elements/slideshow/1t.jpg" width="378" height="210" /> A little look at my script: var thumb_prefix = "t"; return '<li><a href="#"><img src="' + slide.src + thumb_prefix + '" width="121" height="67" /></a></li>'; This is just adding...
I am trying to insert data into my database, but keep getting error 1064. Which goes like this: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Add, Username, TalkID) VALUES ( 'trial' , 'andy' , 2 )' at line 1 The error occurred in C:\ColdFusion8\www...
Hello, Sometime you have many relationships in a table, and you need to insert data. It becomes a painful task when you constantly have to go check the ids of your parent rows for each foreign keys. Is there a tool that make this task easier, by allowing me to do a kind of ajax search for ids while I am inserting data? For exemple, ...
I have a stored procedure that inserts a row into a table with an autoincremented column. It gives me a warning but succeeds if i simply put "" for the value of the autoincremented column. The way I get rid of the error currently is to specify which columns the insert values are for... "insert into app_table(app_id,name,...) values(...)"...
I'm trying to create an SQLite 3 database from Python. I have a few types I'd like to insert into each record: A float, and then 3 groups of n floats, currently a tuple but could be an array or list.. I'm not well-enough versed in Python to understand all the differences. My problem is the INSERT statement. DAS = 12345 lats = (42,43,44,...
Hi I'm wondering are DetailsView/FormView and ObjectDataSource have enough capability for Inserting/Editing your records or not ? Or better ask you Do you prefer use them or make your form by your own ? Because some times it's not easy to use them for complicated task , On the other hand when you have a lot of fields , that's over ki...
Looking for a while now already for how to accomplish this. Seems that all solutions need unique fields with indexes. ...
Using http://www.cppreference.com/wiki/stl/deque/insert as a reference, I was inserting values into a deque at certain locations. For example, if deque A was: a, b, d, e, g with an iterator pointing to d, i can: A.insert(iter, c); // insert val c before loc iter //deque is now a, b, c, d, e, g and the iter still points to d....
Which option is better and faster? Insertion of data after creating index on empty table or creating unique index after inserting data. I have around 10M rows to insert. Which option would be better so that I could have least downtime. ...
could anybody help me to write nodes to existing xml file to a particular position using vb.net? <xml> <person> <name>a</name> </person> <person> <name>b</name> </person> <person> <name>c</name> </person> <person> <name>d</name> </person> </xml> here i want to insert a node just after the node person wh...
It seems INSERT and UPDATE do the same things to me. Is there any occasions where I should use INSERT instead of UPDATE and vice versa? ...
hi i tried to use the following query to insert data in a table nd got error insert into filmo_person_song (person_id, song_id, role_id) select person_id from filmo_person_song fps, filmo_song fs, filmo_role fr where fps.song_id = fs.song_id and fps.role_id = fr.role_id and fps.person_id = 43629; ERROR 1136 (21S01): Column count d...
I have a WPF Listbox defined in a DataTemplate that has its ItemsSource bound to an ObservableCollection. When new items are added to the collection, I want the ListBox to work in "insert mode", always adding to the front of the list, not the default append mode. How do I make the ListBox use the insert mode when not adding to it directl...
Hello everyone, I have the following 2 Entity’s in my xcdatamodel: ...
To give a simple analogy, I have a table as follows: id (PK) | gift_giver_id (FK) | gift_receiver_id (FK) | gift_date Is it possible to update the table in a single query in such a way that would add a row (i.e. another gift for a person) only if the person has less than 10 gifts so far (i.e. less than 10 rows with the same gift_giver_...
I have a MySQL (5.1.42 on OsX) running. I added a Foreign Key with this sql statement: ALTER TABLE `Portal`.`Mitarbeiter_2_BlackBerry` ADD CONSTRAINT `fk_Blackberry` FOREIGN KEY (`id` ) REFERENCES `Portal`.`Blackberry` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION , ADD INDEX `fk_Blackberry` (`id` ASC) But when i try to i...
Can I get from PHP a value back like the new id from the row I've just added to the database or should I make a SELECT to retrieve it? <?php $sql = "INSERT INTO my_table (column_1, column_2) VALUES ('hello', 'ciao')"; $res = mysql_query ($sql) or die (mysql_error ()); $sql = "SELECT column_id FROM my_table WHERE column_1 = 'hello'"; $...
I have two different queries in my php page for the same table, the first one is executed if I have two different values for two columns, but in some case, i can use only the first value, can I do it with the same query or should I use two different queries? // query 1 "INSERT INTO my_table (column_1, column_2) VALUES ('$value_1', '$val...