Search Results

Search found 8267 results on 331 pages for 'insert into'.

Page 160/331 | < Previous Page | 156 157 158 159 160 161 162 163 164 165 166 167  | Next Page >

• convert date string to mysql datetime field

  - by mjr

  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

  Read the article

• Is that possible to do bulk copy in mysql.

  - by Ayyappan.Anbalagan

  I need to insert multiple rows in my Mysql database.my rows are available in my dataset. i am using for loop to send the row one by one is that right way?...

  Read the article

• mysql composite unique on FK's

  - by m2o

  I want to implement the following constraints in mysql: create table TypeMapping( ... constraint unique(server_id,type_id), constraint foreign key(server_id) references Server(id), constraint foreign key(type_id) references Type(id) ); This throws a 'ERROR 1062 (23000): Duplicate entry '3-4' for key 'server_id'' when I issue an insert/update that would break the constraint. Is this type of constraint even possible? If so how? Thank you.

  Read the article

• Checking for Error during execution of a procedure in oracle

  - by Sumit Sharma

  create or replace procedure proc_advertisement(CustomerID in Number, NewspaperID in number, StaffID in Number, OrderDate in date, PublishDate in date, Type in varchar, Status in varchar, Units in number) is begin insert into PMS.Advertisement(CustomerID, NewspaperID, StaffID, OrderDate, PublishDate, Type, Status, Units) values(CustomerID,NewspaperID, StaffID, OrderDate, PublishDate, Type, Status, Units); dbms_output.put_line('Advertisement Order Placed Successfully'); end; How to check for if any error has occurred during the execution of the procedure and if any error has occurred then I wish to display an error message.

  Read the article

• main.out.xml error

  - by husainsn

  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

  Read the article

• HTML form and a file element

  - by CoderMyself

  Is is possible to insert value in an input element of a html form if the element is of type "file"? How to do so, if it is possible?

  Read the article

• Iinsert FLV video in latex document

  - by Kami

  Hi, I'm trying to insert a flv video in a latex document. I've tried the following : \begin{figure}[h!] \centering \includegraphics[scale=1]{animation/animation1.flv} \caption{My animation} \label{Anim1} \end{figure} But it's not working at all ! Does anyone know how to do this ? I would avoid to convert the video because I don't know what kind of codec the reader would have.

  Read the article

• Tools, scripts for working with MS SQL 2008

  - by hgulyan

  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.

  Read the article

• Get Autonumber from newly inserted record in Access 2007 using Enterprise Library 4.1

  - by silverCORE

  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.

  Read the article

• Cocoa Touch - setting text of header of UITableView

  - by Mark

  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?

  Read the article

• What is PrimeFaces p:editor based on?

  - by AlanObject

  I want to add some client-side functionality to the PrimeFaces p:editor, but for some reason I am not able to uncover what JavaScript client side code they used to build the component. Could anyone point me to that? P.S. two things I want to do is make the component resizable (PrimeFaces doesn't support that) and I want to add shortcut buttons to insert pre-programmed text. Any hints about how this will done will be appreciated.

  Read the article

• Rails ActiveRecord Transaction does not finish

  - by PanosJee

  Hi everyone, I have a Transaction for a batch insert/update block and all of sudden it stopped working. The are no errors or exception risen and it seems like Rails stops just before the end of the Transaction blog so the methods does not return. I restarted both MySQL and the system but still.

  Read the article

• Problem Reading Value from a drop down list populated with AJAX

  - by mouthpiec

  Hi, I have a PHP page with two drop down lists. I am using AJAX to populate the second one according to the choice made of the first drop down list. My problem is that when i am posting both values of the two dropdownlists to another php page in which an INSERT query is being made, the value of the second dropdown list is blank (as if no value was selected from the second drop down list). Can you please take a look at this code and let me know what I am doing wrong?

  Read the article

• How do I add a form in an Excel sheet?

  - by Raj Kumar

  How can I add an input form in an Excel sheet. I want to insert values into an Excel cell using the form.

  Read the article

• Why is OleDbDataAdapter needed?

  - by iTayb

  Everything possible with the OleDBDataReader class. ExecuteReader() for SELECT statements, and ExecuteNonQuery() for DELETE, UPDATE and INSERT statements. So why is OleDbDataAdapter class needed?

  Read the article

• Google App-Engine Java Group By and Count(*) queries

  - by Manjoor

  I am able to insert, filter and order records but can't use a simple count!! I am wondering if there a way to get no of total rows in a table?? Is there a way to use GROUP BY in query?

  Read the article

• problem with date in sql CE

  - by Gold

  i have sqlCE DataBase, i have Tdate field (datetime) i notice that his format is: MM/DD/YYYY in my C# program i work with date in: DD/MM/YYYY format. how i can insert to my sqlCE data base my C# format ?

  Read the article

• Linq to SQL Compact - Transaction or just SubmitChanges

  - by eWolf

  I'm using Linq to SQL on an SQL Compact database. I have a function where I insert multiple records into the database. I only call SubmitChanges at the end of the function. Would using a transaction (using the TransactionScope class) bring me any more performance or advantages?

  Read the article

• filter some data(row) in zend view

  - by Behrang

  I have 1.Table:user(userId,userName,userGroup) 2.Model:userModel 3.usercontroller there i a simple code: Controller: class UserController extends Zend_Controller_Action { public function getuser() { $userModel = new userModel(); $this-view-usergroup = $userModel; } } Model: class Model_UserGroupModel extends Zend_Db_Table_Abstract { public function getuser( { $select = $this-select(); return $this-fetchAll($select); } } view: please tell me what code I must insert in view to only have user with specific row like user with group teacher also i use partialoop???

  Read the article

• default value support for Entity Framework object construction to avoid having to set this column pa

  - by Greg

  Hi, In entity framework is there a way to have a default value for a column such that Linq to Entity won't require this parameter when constructing a new object? For example I've marked on column in the EF designer with a default value (I typed in "All" as it was a string). But if I try to construct a new record and not specify this parameter I still get a FOREIGN KEY constraint exception. The INSERT statement conflicted with the FOREIGN KEY constraint "FK_FunctionalityTypeInterfaceRelationship"

  Read the article

• Conditional statements bug in Google Chrome

  - by Pedro Reis

  When I use a conditional statement targeting IE6 and below with some PHP code Google Chrome disregards the statement and inserts the code. Example: It will insert the content of ie6.php in the body anyway. Anybody got this problem before?

  Read the article

• intercept Calendar task,meetings

  - by kamiomar

  Dear, is there any way to intercept calendar task,meetings. Means track task and meeting on insert,edit and update. Thanks.

  Read the article

• Drupal SQL injection attacks prevention and apostrophe handling in Forms

  - by jini

  in typical PHP applications I used to use mysql_real_escape_string before I did SQL inserts. However I am unable to do that in Drupal so would need some assistance. And without any sort of function like that, user input with apostrophes is breaking my code. Please suggest. Thank You My SQL is as follows: $sql = "INSERT INTO some_table (field1, field2) VALUES ('$field1', '$field2')"; db_query($sql);

  Read the article

• SQL Server 2008. I want to be able to edit multi line character data like I used to be able to in En

  - by George

  I want to be able to insert and update rows with embedded carriage returns even if the column if of type text or ntext. Since there seems to be no GUI way to do this, does anyone know of a free tool that does?

  Read the article

• What's A Good Real Time Html Editing Extension?

  - by David

  Hi, i always like to real-time edit a web page source in the browser and updated as i type, but firebug really sucks, i can't insert scripts in the current page, some times the changes i type aren't updated at all, Is there any robust firefox/chrome extension for that? i try to temporarely edit/add code to an existing web page in the internet, not a local one Thanks

  Read the article

< Previous Page | 156 157 158 159 160 161 162 163 164 165 166 167  | Next Page >