Search Results

Search found 63114 results on 2525 pages for 'set identity insert'.

Page 141/2525 | < Previous Page | 137 138 139 140 141 142 143 144 145 146 147 148  | Next Page >

  • Preview result of update/insert query whithout comitting changes to database in MySQL?

    - by Camsoft
    I am writing a script to import CSV files into existing tables within my database. I decided to do the insert/update operations myself using PHP and INSERT/UPDATE statements, and not use MySQL's LOAD INFILE command, I have good reasons for this. What I would like to do is emulate the insert/update operations and display the results to the user, and then give them the option of confirming that this is OK, and then committing the changes to the database. I'm using InnoDB database engine with support for transactions. Not sure if this helps but was thinking down the line of insert/update, query data, display to user, then either commit or rollback transaction? Any advise would be appreciated.

    Read the article

  • Insert a datetime value with GetDate() function to a SQL server (2005) table?

    - by David.Chu.ca
    I am working (or fixing bugs) on an application which was developed in VS 2005 C#. The application saves data to a SQL server 2005. One of insert SQL statement tries to insert a time-stamp value to a field with GetDate() TSQL function as date time value. Insert into table1 (field1, ... fieldDt) values ('value1', ... GetDate()); The reason to use GetDate() function is that the SQL server may be at a remove site, and the date time may be in a difference time zone. Therefore, GetDate() will always get a date from the server. As the function can be verified in SQL Management Studio, this is what I get: SELECT GetDate(), LEN(GetDate()); -- 2010-06-10 14:04:48.293 19 One thing I realize is that the length is not up to the milliseconds, i.e., 19 is actually for '2010-06-10 14:04:48'. Anyway, the issue I have right now is that after the insert, the fieldDt actually has a date time value up to minutes, for example, '2010-06-10 14:04:00'. I am not sure why. I don't have permission to update or change the table with a trigger to update the field. My question is that how I can use a INSERT T-SQL to add a new row with a date time value ( SQL server's local date time) with a precision up to milliseconds?

    Read the article

  • Using Qt CSS to set own Q_PROPERTY(QFont)

    - by Kamil Klimek
    Hi there. I'm using Qt 4.6.2 and i have problem with QCSS. I have own Q_PROPERTY(QFont myFont READ myFont SET setMyFont). I want to change it with QCSS but it doesn't work. I've tried using normal font syntax but it doesn't work. I've also tried few other combinations like: qproperty-myFont: font(serif 20 1 0) font(serif 20 bold) QFont(serif 20 1 0) QFont(serif 20 bold) QFont(bold 20px serif) etc.

    Read the article

  • Regex to match all of a set except certain ones

    - by Davy8
    I'm sure this has been asked before, but I can't seem to find it (or know the proper wording to search for) Basically I want a regex that matches all non-alphanumeric except hyphens. So basically match \W+ except exclude '-' I'm not sure how to exclude specific ones from a premade set.

    Read the article

  • Drupal: how to set theme language programmatically?

    - by takpar
    How can i change drupal default language programmatically somewhere in code (like template.php)? (i need to overwrite default language set by admin in some cases.) i'm using drupal 6. PS: please read my own answer for more detail. and if you may help solve that PS: later i saw a module that was what i wanted. make sure take a look at it: Administration Language Drupal Module

    Read the article

  • ASP.NET UpdateProgress template does not disapper when panel in UpdatePanel has display set to none

    - by Greg Balajewicz
    I am using very simple code where I have a update panel with some panels inside and a submit button. On submit, i hide one of the panels using this code: panel.Style.Add("display", "none"); I am also using a UpdateProgress which works great in all but this case. When i set the display to none using this code, the UpdateProgress template does not disappear! remove the line, all is well .... No idea why...

    Read the article

  • Why do I get this error when trying to set up a class variable

    - by Jennifer
    I'm new to PHP so maybe I am overlooking something here but the following: class someClass { var $id = $_GET['id']; function sayHello() { echo "Hello"; } } gives the following error: Parse error: syntax error, unexpected T_VARIABLE in C:\xampp\htdocs\files\classes.php on line 13 If instead of $_GET['id'] I set the variable $id to a string, everything is fine though.

    Read the article

  • Set inner table border in HTML

    - by ripper234
    How do I set the "inner border" - the border between different cells. By setting style attributes I manage to control the outer border, but the inner border just stays the same gray color and the same width. What attributes should I tweak to control the inner border?

    Read the article

  • mysql fetch result parent id and category id by single query?

    - by Karthik
    I have the table and values like this, CREATE TABLE `category` ( `id` INT( 4 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , `category` VARCHAR( 50 ) NOT NULL , `parent` INT( 4 ) NOT NULL ) INSERT INTO `category` VALUES (1, 'MCA', 9); INSERT INTO `category` VALUES (2, 'M Tech', 9); INSERT INTO `category` VALUES (3, 'B Tech', 9); INSERT INTO `category` VALUES (4, 'BioTech', 9); INSERT INTO `category` VALUES (5, 'InfoTech', 9); INSERT INTO `category` VALUES (6, 'Chemical', 10); INSERT INTO `category` VALUES (7, 'Indus', 10); INSERT INTO `category` VALUES (8, 'Physics', 10); INSERT INTO `category` VALUES (9, 'Information Science', 0); INSERT INTO `category` VALUES (10, 'Others Science', 0); I need a single query for getting the values in terms of category and subcategory. 3rd values zero as category and others are subcategory.

    Read the article

  • How to set text editable in GtkEntry

    - by paultop6
    Hi Guys, Pretty straight foward question, I have a GtkEntry widget that i want to set to be editable. I know the function i should use is: gtk_editable_set_editable But i dont know how to make it take a GtkEntry widget as an arguement Can anyone help me? Regards Paul

    Read the article

  • Set custom keyboard for android application

    - by dAnjou
    Hi, i know that there is the possibility to set a special keyboard with these attributes. But i need my own keyboard as default. How can i do that? How can my app change the settings? As an example, let's say: i want the example SoftKeyboard as default for my app. Is that even possible? Thanks for your efforts :)

    Read the article

  • Generating a URL pattern when provided a set of 5 or so URLs

    - by ryan
    Provided with a set of URLs, I need to generate a pattern, For example: http://www.buy.com/prod/disney-s-star-struck/q/loc/109/213724402.html http://www.buy.com/prod/samsung-f2380-23-widescreen-1080p-lcd-monitor-150-000-1-dc-8ms-1920-x/q/loc/101/211249863.html http://www.buy.com/prod/panasonic-nnh765wf-microwave-oven-countertop-1-6-ft-1250w-panasonic/q/loc/66357/202045865.html http://www.buy.com/prod/escape-by-calvin-klein-for-women-3-4-oz-edp-spray/q/loc/66740/211210860.html http://www.buy.com/prod/v-touch-8gb-mp3-mp4-2-8-touch-screen-2mp-camera-expandable-minisd-w/q/loc/111/211402014.html Pattern is http://www.buy.com/prod/[^~]/q/loc/[^~].html

    Read the article

  • Set item.selected in ASP.NET Menu Control

    - by BillB
    ASP.NET newbie here. When on a page I'd like to set the corresponding menu item to selected. My approach is this: On Home.aspx.cs: Menu menu = (Menu)Master.FindControl("Menu1"); if (menu.Items.Count > 0) { menu.FindItem("Home").Selected = true; } Trouble is, menu.item.count == 0. My menu is bound to a sitemap, if that matters. Thanks, Bill

    Read the article

  • UCMA 1.0 Set Presence Status

    - by Paleta
    Hi everyone, I'm asking here because I've search everywhere and could not find a correct solution about how to properly set a presence status using UCMA 1.0 Can you point me in the right direction? Thanks.

    Read the article

  • PHP Detect if any URL variables have been set

    - by zuk1
    Hey guys, it's kind of hard to explain but basically I want to detect if any variables have been set through the URL. So with my IF statement all of the following should return true: http://domain.com/index.php?m=100 http://domain.com/index.php?q=harhar http://domain.com/index.php?variable=poo&crazy=yes and all the following return false: http://domain.com/index.php http://domain.com/test.php http://domain.com/no_variables.php Any ideas?

    Read the article

< Previous Page | 137 138 139 140 141 142 143 144 145 146 147 148  | Next Page >