Search Results

Search found 39491 results on 1580 pages for 'insert id'.

Page 762/1580 | < Previous Page | 758 759 760 761 762 763 764 765 766 767 768 769  | Next Page >

• Sql server Identity issue

  - by pranay

  I have query like below declare @str_CustomerID int Insert into IMDECONP38.[Customer].dbo.CustomerMaster ( CustomerName , CustomerAddress , CustomerEmail , CustomerPhone ) values ( ‘werw12e’ , ‘jkj12kj’ , ‘3212423sdf’ , ‘1212121' ) select @str_CustomerID= scope_identity() after execution it returns null in my parameter i want to get value of identity how can i do that

  Read the article

• Problems making an accurate Visual Studio scheme for Vim (vim scheme specialist needed) .

  - by janoChen

  I'm trying to make an accurate Visual Studio scheme. I set hi function to blood color (#9A1102) for the "CSS function" (selector). But now the brackets with properties (id, class) in html elements also have blood color: (ironically the same color here in Stackoverflow). But I want them blue (#2902FC) e.g.: <div class="first"> <div id="nopic"> Sample of code: " Syntax highlighting hi Comment guifg=#777777 gui=none hi Todo guifg=#8f8f8f gui=none hi Constant guifg=#e5786d gui=none hi String guifg=#2902FC gui=none hi Identifier guifg=#2902FC gui=none hi Function guifg=#9A1102 gui=none hi Type guifg=#EF2811 gui=none hi Statement guifg=#9A1102 gui=none hi Keyword guifg=#9A1102 gui=none hi PreProc guifg=#2902FC gui=none hi Number guifg=#2902FC gui=none hi Special guifg=#2902FC gui=none " Bottom hi Question guifg=white gui=none hi Question ctermfg=white term=none hi ModeMsg guifg=white gui=none

  Read the article

• Want to avoid the particular rows from select join query... See description

  - by OM The Eternity

  I have a Select Left Join Query whis displays me the rows for the latest changedone(its a time) column name ("field" should not be equal) column name ("trackid" should not be equal), and column name "Operation should be "UPDATE" ", below is the query I am talking about... SELECT j1. * FROM jos_audittrail j1 LEFT OUTER JOIN jos_audittrail j2 ON ( j1.trackid != j2.trackid AND j1.field != j2.field AND j1.changedone < j2.changedone ) WHERE j1.operation = 'UPDATE' AND j2.id IS NULL Now here I don't want a row to be displayed with a two particular column's value i.e. "field's value" the value is "LastvisitDate" and "hits" Now if if append the condition in the above query that " AND j1.field != 'lastvistDate' AND j1.field != 'hits' " theni do not get any result... The table structure is jos_audittrail: id trackid operation oldvalue newvalue table_name live changedone(its a time) I hope i have given the details properly If u still find something missing I will try to provide it more better way... Pls help me to avoid those two rows with those to mentioned value of "field"

  Read the article

• Nhibernate inserting with values on a bag

  - by Phil Whittaker

  I am using a where clause on a bag to filter a bag. Is there any way to make nhibernate insert these filter values into the database?

  Read the article

• MySQL: Query to obtain recipes using all given ingredients.

  - by John_A

  hi I have the following simplified tables: CREATE TABLE recipe(id int, name varchar(25)); CREATE TABLE ingredient(name varchar(25)); CREATE TABLE uses_ingredient(recipe_id int, name varchar(25)); I want to make a query that returns all id's of recipes that contain both Chicken and Cream. I have tried SELECT recipe_id FROM uses_ingredient INNER JOIN (SELECT * FROM ingredient WHERE name="Chicken" OR name="Cream") USING (name) GROUP BY recipe_id HAVING COUNT(recipe_id) >= (SELECT COUNT(*) FROM theme); which gives me :"ERROR 1248 (42000): Every derived table must have its own alias" and is probably wrong too. Next I tried SELECT recipe_id FROM (SELECT * FROM ingredient WHERE name="Chicken" OR name="Cream") AS t INNER JOIN uses_ingredient USING (name) GROUP BY recipe_id HAVING COUNT(recipe_id)>= (SELECT COUNT(*) FROM t); which gives "ERROR 1146 (42S02): Table 'recipedb.t' doesn't exist" I want to avoid creating temporary tables including using ENGINE=MEMORY.

  Read the article

• doctrine default values and relations

  - by Skirmantas

  Concept: Lets say we have table Properties with columns id and name (lets say with some predefined values: "Good" "Better" "Best"). Another table Users has column property_id with many to one relation on Properties (property_id = id). Users has default value on property_id, lets say 1 which means "Good". We might have another table analogue to Users however with default property, lets say "Better". What I need is ability to change default value for Users or other tables in administrator's panel. In mysql I can set default value for column like this: ALTER TABLE <Table> CHANGE <Column> DEFAULT <NEW_DEFAULT_VALUE> I can retrieve default value: SELECT DEFAULT(<Column>) FROM <Table> LIMIT 1 Is it possible to achieve this concept with Doctrine? What I actually need is such method in my table class: class UserTable extend Doctrine_Table { /* ... */ getDefaultProperty() { } setDefaultProperty($value) { /* $value can be either integer or Doctrine_Record */ } }

  Read the article

• how to design a db like Facebook where users can update their status and of the fb page as admin

  - by Harsha M V

  i am designing a database where users can update status messages of theirs and they can create pages groups like facebook fan page and post status like the admin of the page and not as a user. user(id, name..) group(id, name...) group_admin(group_id, user_id) this is my set up. Is this the way to do it. How to post under the group as an admin. will i need to make a check to every user if he is the admin or not ?

  Read the article

• How do I change mysql settings so that it is default UTF-8 for everything?

  - by alex

  I am getting "ASCII encoding" errors when I insert into my database because I did a fresh install of the MYSQL. I'd like to change the default to UTF-8 again.

  Read the article

• How do I get all the <li> elements from within a div using Watin?

  - by Nick

  Hello.. I have never used Watin before today. I need to get a collection of elements that are within a <div id="myDiv"> <ul> <li>a</li> <li>b</li> <li>c</li> </ul> </div> I only want the li elements within the div id='myDiv'.. Thanks for any help!

  Read the article

• Detecting when HTML5 audio is finished playing (more than once)?

  - by user386911

  I am having a problem detecting when an tag is finished playing an mp3. When I do something like this: myAudio.addEventListener("ended", function() { alert("ended"); }); It only occurs the first time the audi is played. When I play the audio again, nothing happens. The same thing occurs when I use the onended=doThis(); method. I've heard maybe there is a way to do it in jquery, but I haven't been able to get it to work. I've also heard there might be a way to fix it by changing the audio div id everytime the mp3 is played, but this doesn't work for me because I need the id to stay the same. Anyone got any ideas?

  Read the article

• Wrapping an array of elements.

  - by fivetwentysix

  I'm trying to write an unobtrusive script and I don't want to add any html that's not needed unless javascript is enabled. Using MooTools 1.2.4, is it possible to wrap a an array of elements with say for example: tags? Desired effect: Before: <p>Something</p> <p>Something1</p> <p>Something2</p> <p>Something3</p> Wishful thinking javascript code: $$('p').wrapWith(new Element('div', {id: 'master'})); After: <div id="master"> <p>Something</p> <p>Something1</p> <p>Something2</p> <p>Something3</p> </div>

  Read the article

• Syntax problem when checking for a file

  - by Luke

  This piece of code has previously worked but I have C&P it to a new place and for some reason, it now won't work! <? $user_image = '/images/users/' . $_SESSION['id'] . 'a.jpg'; if (file_exists(realpath(dirname(__FILE__) . $user_image))) { echo '<img src="'.$user_image.'" alt="" />'; } else { echo '<img src="/images/users/small.jpg" alt="" />'; } ?> As you can see, I am checking for a file, if exists, showing it, if not, showing a placeholder. The $_SESSION['id'] variable does exist and is being used elsewhere within the script. Any ideas what the problem is? Thanks

  Read the article

• How to change the background color of a h:inputText control inside a rich:Panel

  - by kiransri

  I need to change the background color of some h:inputText controls inside a rich panel based on a condition. This is to distinguish these controls as readonly. I tried using styleClass and style properties but both did not work. styleClass is ignored and style colors only half of the textbox. 1) styleClass code : In css : .readonlycontrol { background-color: #C0C0C0; } In .xhtml page: <rich:panel styleClass="inputpanel"> <f:facet name="header" > <h:outputText value= "#{cardreqmsg.apptinfo}"/> </f:facet> <h:panelGrid columns="4" cellpadding="2" border="0"> <h:inputText id ="name" styleClass="readonlycontrol" readonly="true"/> ......... 2) style code: <h:inputText id ="name" readonly="true" style="background-color:#C0C0C0"/> Any help would be greatly appreciated

  Read the article

• hibernate pagination mechanism

  - by haicnpmk44

  I am trying to use Hibernate pagination for my query (PostgreSQL ) i set setFirstResult(0), setMaxResults(20) for my sql query. My code like below: Session session = getSessionFactory().getCurrentSession(); session.beginTransaction(); Query query = session.createQuery("select id , customer_name , address from tbl_customers "); query.setFirstResult(0); query.setMaxResults(20); List<T> entities = query.list(); session.getTransaction().commit(); but when viewing SQL hibernate log, i still see full sql query: Hibernate: select customer0_.id as id9_, customer0_.customer_name as dst2_9_, customer0_.addres as dst3_9_ from tbl_customers customer0_ Why there is no LIMIT OFFSET in query of Hibernate pagination SQL log? Does anyone know about Hibernate pagination mechanism? I guess that Hibernate will select all data, put data into Resultset, and then paging in Resultset, right?

  Read the article

• Validation library for PHP/mysql

  - by Industrial

  Hi! Is there any lightweight validation library available for PHP that easily can check if a specific string or value is valid for a known database type - Something like this: if (is_MEDIUMINT($var)) { $this->db->insert($anothervar); } Thanks!

  Read the article

• jQuery Draggable Problem

  - by Jimbo

  Im trying to get a div to be movable within the constrains of the browser window, by dragging the titlebar inside the div. My code is as follows: <div id='container'> <h3 class='title' id='titlebar'>My Title</h3> </div> <script type='text/javascript'> $(document).ready(function(){ $("#titlebar").draggable({ containment: 'window', scroll: false, helper: $('#container') }); }); </script> Something is wrong with this (it wont do anything at all) but I cant see the problem!

  Read the article

• How to save links with tags and parameters in TextField

  - by xRobot

  I have this simple Post model: class Post(models.Model): title = models.CharField(_('title'), max_length=60, blank=True, null=True) body = models.TextField(_('body')) blog = models.ForeignKey(Blog, related_name="posts") user = models.ForeignKey(User) I want that when I insert in the form the links, then these links are saved in the body from this form: http://www.example.com or www.example.com to this form ( with tag and rel="nofollow" parameter ): <a href="http://www.example.com" rel="nofollow">www.example.com</a> How can I do this ? Thanks ^_^

  Read the article

• Android Convert Central Time to Local Time

  - by chedstone

  I have a MySql database that stores a timestamp for each record I insert. I pull that timestamp into my Android application as a string. My database is located on a server that has a TimeZone of CST. I want to convert that CST timestamp to the Android device's local time. Can someone help with this?

  Read the article

• mysql error dont understand what it is saying

  - by sea_1987

  Cannot add or update a child row: a foreign key constraint fails (`mydb`.`job_listing_has_employer_details`, CONSTRAINT `job_listing_has_employer_details_ibfk_2` FOREIGN KEY (`employer_details_id`) REFERENCES `employer_details` (`id`)) INSERT INTO `job_listing_has_employer_details` (`job_listing_id`, `employer_details_id`) VALUES (6, '5') What does this mean? The two ID's I am inserting into the table exsist.

  Read the article

• Stocket server crashing with unhandled exception

  - by Rob

  We have a c# (3.5 framework) socket server which is a console app, after about 3000 connections (or less, it's quite random), we get an unhandled exception which crashes the app completely. We're really struggling to find out what's happening and where, the only info we get is below, can anyone shed any light? It should be noted that EVERYTHING is wrapped up in try catch{} Description: Stopped working Problem signature: Problem Event Name: CLR20r3 Problem Signature 01: qrushrserver.exe Problem Signature 02: 1.0.0.0 Problem Signature 03: 4bf56a0c Problem Signature 04: System Problem Signature 05: 2.0.0.0 Problem Signature 06: 49cc5ec9 Problem Signature 07: 2c0b Problem Signature 08: 40 Problem Signature 09: System.Net.Sockets.Socket OS Version: 6.0.6002.2.2.0.1296.17 Locale ID: 2057 Faulting application app_name.exe, version 1.0.0.0, time stamp 0x4bf56a0c, faulting module mscorwks.dll, version 2.0.50727.4200, time stamp 0x4a9ee32d, exception code 0xc0000005, fault offset 0x00000000001c89ca, process id 0x%9, application start time 0x%10. .NET Runtime version 2.0.50727.4200 - Fatal Execution Engine Error (000007FEF8E4664E) (80131506)

  Read the article

• To find busstop with timetable data and more near me(current postion)

  - by Sabby

  I am developing an application which helps the user to find the bus stops near him through his current latitude and longitude. This will also give the time table of the bus, route direction, bus name etc. I searched over the google but didn't get success. I tried the trimet api, but that was also not much helpful as it only works for Portland area and the pin is always dropped on the map on Portland. Please help me! Is there any api to do this? This app is for our client. User will input the route id, loc id or what and will get all the detail of near by bus stops and their lat,long.

  Read the article

• Jquey: select tag onchange function problem

  - by Syom

  i start learning jquery few days ago, and i like it very much. but now i have a problem, that can't solve alone. i have two selects <select id="select1"> <option value="1">1day</option> <option value="2">2day</option> <option value="3">3day</option> </select> <select id="select2"> <option value="1">1day</option> <option value="2">2day</option> <option value="3">3day</option> </select> i need to set #select2 the same value with #select1, when #select1 changes i've red some questions about select tag here, but i need to set "selected" attribute to that option, which have the same value. how can i do it? Thanks

  Read the article

• reading into table: comma values and quotes SQL

  - by every_answer_gets_a_point

  i have a string like this something = "something, something1, "something2, something else", something3" i need it to be read into a table like this: field1 = "something" field2= "something2" field3 = "something2, something else" field4 = "something3" please notice that the double quotes in the something string signified that the string inside the quotes is to be placed in one field anyone know how to do this with an insert into statement or some other way? the answer can be purely sql or can be vba with sql. thanks!

  Read the article

• How do I see the results of unique records added after adding records to mysql

  - by billy

  I'm a PHP noob. I have a database that I will update weekly with a CSV. So far I've managed to upload the file to the server, open the file with PHP, and insert the data in my table. Now I want to return the unique records that were added (on screen or in a file). How do I do this?

  Read the article

• button submit with 2 different behaviour

  - by kawtousse

  hi, how could i set a variable with a submit button in order to differenciate 2 behaviours, so first time the same submit button will insert in database and in second time it updates database values. Thanks.

  Read the article

< Previous Page | 758 759 760 761 762 763 764 765 766 767 768 769  | Next Page >