Search Results

Search found 23955 results on 959 pages for 'insert query'.

Page 113/959 | < Previous Page | 109 110 111 112 113 114 115 116 117 118 119 120  | Next Page >

• Is there a way to generate messages with timestamps to insert into mysql database

  - by Sarah

  Hello guys Can i generate up to 500 messages with timestamps and insert them at once to appear also at once on my page. If it is not a very good idea tell me. Thanks in advance.

  Read the article

• Easy way to use Images in WPF

  - by j-t-s

  Hi All I've only just started using WPF. (I'm a WinForms guy), and from what I can see, trying to simply drag an image onto the Window is a huge PAIN. There seems to be no way where you can just select an option to tell it what picture to put indide the image control. I've seen so many sites within the last 10 minutes with atleast 10lines of code just to insert animage into a window. Is there an easier way?

  Read the article

• Python/sqlite - selecting records after insert

  - by javovo

  Is there an sqlite equivalent to INSERT...;SELECT @@IDENTITY? If so, please show me the code or point me towards it. Thanks!

  Read the article

• my sql insert query not working

  - by Piyush

  I am inserting userId.It is displaying correct but inserting 0 in spite of actual userId. mycode- If(! empty($userIDToCheck) || $userIDToCheck != '' ) { echo $userIDToCheck; $sql = "INSERT INTOpnpdb.ruser(userid) VALUES ('$userIDToCheck');"; mysql_query($sql)or die(mysql_error()); echo "Done"; } Output : pi203713 Done But is database it is inserting "0"???

  Read the article

• upload a image and insert directly into CKEditor

  - by Timmeh

  I'd like to create the same kind of function tumblr has for uploading images and then inserting them directly into the WYSIWYG editor. I was planning on using uploadify to upload the image, then I am not sure of the method for inserting into the CKEditor. Has anyone done anything similar or know of a plugin that could do this? Ideally I'd like it to insert the image wherever the text cursor was last placed. Thanks in advance, Tim

  Read the article

• VIM Blockwise Insert

  - by tesmar

  HI all! I would like to insert a hash at the beginning of a selected block of text in VIM (ruby comment). I selected the lines in Visual Mode, but how do I perform the same operation to all lines? Thank you in advance!

  Read the article

• Insert one DefaultStyledDocument into another DefaultStyledDocument

  - by Paul Reiners

  I want to insert one DefaultStyledDocument into another DefaultStyledDocument. How do I do this? I know of this method: AbstractDocument.insertString(int offs, String str, AttributeSet a) What I really want is something like this: DefaultStyledDocument.insertDocument(int offs, AbstractDocument doc) Is there a way of doing this?

  Read the article

• How to automatically reseed after using identity_insert?

  - by Earlz

  Hello, I recently migrated from a PostgreSQL database to a SQL Server database. To switch the data over I had to enable IDENTITY_INSERT. Well come to find out that I get all sorts of strange errors due to duplicate identity values(which are set as primary keys) upon doing an insert in any of the tables. I have quite a few tables. What would be the easiest way of automatically reseeding the identity of every table so that it is after max(RID)?

  Read the article

• i want to insert values from table1 to table2 with incremantal value

  - by adnan

  i tried something like this but the id value is not changing, getting the value for first record and set the value for all rest... insert into table1 (Id,b,c,d) (select (select max(Id)+1 from table1),x,y,z from table2 where... )

  Read the article

• Dates that intersect

  - by MikeAbyss

  Hi everyone, I've been researching this problem for awhile now and I can't seem to come to a solution, hopefully someone here can help. Currently I'm working with Microsoft SQL server management, I've been trying to do the following: Previously, the old query would just return the results that fit between two dates Heres the previous query: SELECT e.Name, o.StartDate, o.EndDate FROM dbo.Name e, dbo.Date o WHERE where e.Name = o.Name and o.StartDate <= '2010-09-28 23:59:59' and o.EndDate >= '2010-9-28 00:00:00' and e.Name like 'A' Example table that is produced after the query runs (The real table has a lot more rows obviously :P) : Name Start End A 2010-09-28 07:00:00 2010-09-28 17:00:00 A 2010-09-28 13:45:00 2010-09-28 18:00:00 A 2010-09-28 08:00:00 2010-09-28 16:00:00 A 2010-09-28 07:00:00 2010-09-28 15:30:00 However we need to change this, so that the query does the following: find the dates that intersect for a day x find the dates that don't intersect for a day x I've found a real useful site regarding this http://bloggingabout.net/blogs/egiardina/archive/2008/01/30/check-intersection-of-two-date-ranges-in-sql.aspx However the date to compare against is inputted, mine on the other hand has to all dates that intersect/don't intersect. Thanks for the help everyone.

  Read the article

• SSIS Package performance during bulk insert

  - by vartika

  SSIS performance degrades when using bulk insert task in for each loop to upload multiple files into one target table. how to maintain SSIS performance

  Read the article

• Question about Benchmark function in Mysql ( Incredible results ).

  - by xRobot

  I have 2 tables: author with 3 millions of rows. book with 20 miles rows. . So I have benchmarked this query with a join: SELECT BENCHMARK(100000000, 'SELECT book.title, author.name FROM `book` , `author` WHERE book.id = author.book_id ') And this is the result: Query took 0.7438 sec ONLY 0.7438 seconds for 100 millions of query with a join ??? Do I make some mistakes or this is the right result ?

  Read the article

• Insert span next to textbox using jquery

  - by Pankaj

  Hello All I have a text box. i want to insert <Span>Invalid value</span> next to that text box using Jquery.

  Read the article

• SSMS: The Query Window Keyboard Shortcuts

  Simple-Talk's free wallchart of the most important SSMS keyboard shortcuts aims to help find all those curiously forgettable key combinations within SQL Server Management Studio that unlock the hidden magic that is available for editing and executing queries. The Future of SQL Server MonitoringMonitor wherever, whenever with Red Gate's SQL Monitor. See it live in action now.

  Read the article

• sql select from a large number of IDs

  - by Claudiu

  I have a table, Foo. I run a query on Foo to get the ids from a subset of Foo. I then want to run a more complicated set of queries, but only on those IDs. Is there an efficient way to do this? The best I can think of is creating a query such as: SELECT ... --complicated stuff WHERE ... --more stuff AND id IN (1, 2, 3, 9, 413, 4324, ..., 939393) That is, I construct a huge "IN" clause. Is this efficient? Is there a more efficient way of doing this, or is the only way to JOIN with the inital query that gets the IDs? If it helps, I'm using SQLObject to connect to a PostgreSQL database, and I have access to the cursor that executed the query to get all the IDs.

  Read the article

• [CakePHP] Dynamic fields on insert/edit form

  - by user198003

  hi all, let's say that i have 3 tables: books properties book_properties of course, i would like that when i want to insert new book (or update existing), to fill the form. fields that exist on form have to be defined as records in table properties. when i fill up those fields, data has to be saved in table book_properties. can you help me by giving some advices and references, how to achieve that? thank you very much in advance!

  Read the article

• Insert into a table using a view

  - by Jack Mills

  I have some data in a view which I want to insert into a table (same table schema) what's the easiest, cleanest way to do it.

  Read the article

• mysql join with conditional

  - by Conor H

  Hi There, I am currently working on a MySQL query that contains a table: TBL:lesson_fee -fee_type_id (PRI) -lesson_type_id (PRI) -lesson_fee_amount this table contains the fees for a particular 'lesson type' and there are different 'fee names' (fee_type). Which means that there can be many entries in this table for one 'lesson type' In my query I am joining this table onto the rest of the query via the 'lesson_type' table using: lesson_fee INNER JOIN (other joins here) ON lesson_fee.lesson_type_id = lesson_type.lesson_type_id The problem with this is that it is currently returning duplicate data in the result. 1 row for every duplicate entry in the 'lesson fee' table. I am also joining the 'fee type' table using this 'fee_type_id' Is there a way of telling MySQL to say "Join the lesson_fee table rows that have lesson_fee.lesson_type_id and fee_type_id = client.fee_type_id". UPDATE: Query: SELECT lesson_booking.lesson_booking_id,lesson_fee.lesson_fee_amount FROM fee_type INNER JOIN (lesson_fee INNER JOIN (color_code INNER JOIN (employee INNER JOIN (horse_owned INNER JOIN (lesson_type INNER JOIN (timetable INNER JOIN (lesson_booking INNER JOIN CLIENT ON client.client_id = lesson_booking.client_id) ON lesson_booking.timetable_id = timetable.timetable_id) ON lesson_type.lesson_type_id = timetable.lesson_type_id) ON horse_owned.horse_owned_id = lesson_booking.horse_owned_id) ON employee.employee_id = timetable.employee_id) ON employee.color_code_id = color_code.color_code_id) ON lesson_fee.lesson_type_id = lesson_type.lesson_type_id) ON lesson_fee.fee_type_id = client.fee_type_id WHERE booking_date = '2010-04-06' ORDER BY lesson_booking_id ASC How do I keep the format(indentation) of my query?

  Read the article

• how to insert both image and button in android at the same screen

  - by antony joe

  i need to insert 2 images and 2 buttons.action required is that whn i click on th first button corrsponding image should be displayed.same action required for other button also but second image should be displayed.

  Read the article

• SQL RDBMS : one query or multiple calls

  - by None None

  After looking around the internet, I decided to create DAOs that returned objects (POJOs) to the calling business logic function/method. For example: a Customer object with a Address reference would be split in the RDBMS into two tables; Customer and ADDRESS. The CustomerDAO would be in charge of joining the data from the two tables and create both an Address POJO and Customer POJO adding the address to the customer object. Finally return the fulll Customer POJO. Simple, however, now i am at a point where i need to join three or four tables and each representing an attribute or list of attributes for the resulting POJO. The sql will include a group by but i will still result with multiple rows for the same pojo, because some of the tables are joining a one to many relationship. My app code will now have to loop through all the rows trying to figure out if the rows are the same with different attributes or if the record should be a new POJO. Should I continue to create my daos using this technique or break up my Pojo creation into multiple db calls to make the code easier to understand and maintain?

  Read the article

• MySql mutliple tables

  - by Chris Harrison

  I've been looking into JOIN, subqueries and other ways of doing this, but I can't work out the best way to do this is... I have a table (ps_category_product): id_product, id_category I want to perform a query on it like: SELECT id_product FROM ps_category_product WHERE id_category='$this_cat' BUT, I only want to perform this query where the ID's are returned by a query on another table (ps_product): id_product, active SELECT id_product FROM ps_product WHERE active='1' Can anyone help me with getting these two queries working together?

  Read the article

• Visual Studio 2008 Intellisense for Events auto insert

  - by Morder

  Does anyone know the attributes or xml comments required to get the "new EventHandler(blah); (Press TAB to insert)" ability when you += an event?

  Read the article

• Which method is best method for speed? in MSSQL, Store procedure.

  - by AjmeraInfo

  I have select, insert, update and delete query. if i have to write all query in same store procedure that is good for performance or i should write all query in separate store procedure?

  Read the article

• SQL Server create a row in Table B for every row in Table A and put the ID in Table A

  - by ScottyDoesKnow

  I know how to create a row in Table B for every row in Table A: INSERT INTO [dbo].[TableB] SELECT 0, 5, 3, [TableAColumn] FROM [dbo].[TableA] But I need to also put the ID of each new TableB row into a column in TableA, and I can't figure out how to do that.

  Read the article

• Looking for a Function that insert "Any" form values to mysql

  - by jasmine

  I am Looking for a Function that insert "Any" form values to mysql, update or delete. (not OOP) I have found a function here: http://tr.php.net/manual/en/function.mysql-query.php Thanks in advance

  Read the article

< Previous Page | 109 110 111 112 113 114 115 116 117 118 119 120  | Next Page >