Search Results

Search found 63598 results on 2544 pages for 'sql add on'.

Page 542/2544 | < Previous Page | 538 539 540 541 542 543 544 545 546 547 548 549  | Next Page >

• mysql circular dependency in foreign key constraints

  - by Flavius

  Given the schema: What I need is having every user_identities.belongs_to reference an users.id. At the same time, every users has a primary_identity as shown in the picture. However when I try to add this reference with ON DELETE NO ACTION ON UPDATE NO ACTION, MySQL says #1452 - Cannot add or update a child row: a foreign key constraint fails (yap.#sql-a3b_1bf, CONSTRAINT #sql-a3b_1bf_ibfk_1 FOREIGN KEY (belongs_to) REFERENCES users (id) ON DELETE NO ACTION ON UPDATE NO ACTION) I suspect this is due to the circular dependency, but how could I solve it (and maintain referential integrity)?

  Read the article

• how to add lines numbers to : QTextEdit ?

  - by radi

  i am writing a visual basic ide , and i need to add lines numbers to QTextEdit and highlight current line . i have found this tutorial but it is written in java and i write my project in c++ so where to find tutorial like that in c++ , or if there is a ready to use component ? thanks .

  Read the article

• Date Difference, Excluding certain Times and Dates

  - by Josefvz

  Hi Folks. I'm looking for a way to determine the difference between two dates. A normal SQL DATEDIFF statement won't cut it because I need to excluded non working Hours and days Namely Weekends and any time between 16:00 - 7:00. Something similar to the NETWORKDAYS function in excel. I'm codeing an excel spreadsheet. Using VBA connect to a SQL server to pull data.

  Read the article

• javascript autocompletion for DSL. (e.g.: SQL)

  - by chacko

  I want to give the user a web-page where he can type some simple SQL. select * from myTable. What I would like is to have the autocompletion area to help typing: sel [selECT] select * f [select * fROM] select * from [select * fROM column1] [select * fROM column2] ... Anybody can suggest if there is a nice open source library for this ? I am not really interested in the SQL (I will have to parse a DSL) I am more interested on a powerful autocompletion text area widget.

  Read the article

• How do you use (get values from keys, add items) Hashtables in F#

  - by Russell

  I woudl like to know how to use a System.Collections.Hashtable in F#. The reason it is a Hashtable is because I am referencing C# assemblies. How would I call the following methods? - Add - Get value from key I have not been able to find anything useful in google about this. Any help would be appreciated. Thanks

  Read the article

• How do I use Perl to parse the output of the sqlplus command?

  - by benjamin button

  I have an SQL file which will give me an output like below: 10|1 10|2 10|3 11|2 11|4 . . . I am using this in a Perl script like below: my @tmp_cycledef = `sqlplus -s $connstr \@DLCycleState.sql`; after this above statement, since @tmp_cycledef has all the output of the SQL query, I want to show the output as: 10 1,2,3 11 2,4 How could I do this using Perl?

  Read the article

• How to add local roadmap to Google map

  - by tacoen

  I live in rural areas, my town doesn't had roads in google maps. How can I add my own or create it. Where to start?

  Read the article

• Django admin: how do I add an unrelated model field to a model change/add page?

  - by NP

  I have the following models: class Foo(models.Model): field1 = models.IntegerField() ... class Bar(models.Model): field1 = models.IntegerField() ... class Foo_bar(models.Model): foo = models.ForeignKey(Foo) bar = models.ForeignKey(Bar) ... In the admin, I want it so that in the Foo change/add page, you can specify a Bar object, and on save I want to create a Foo_bar object to represent the relationship. How can I do this through customizing the Admin site/ModelAdmins? Thanks.

  Read the article

• Android: add badge to icons internal to my app

  - by user310287

  Hi, I am trying to add badges to the icons in my android app. e.g. in the facebook app(for iPhone), in the home page the number of pending requests is shown on the requests icon. Can someone provide any links/ideas on how to do this? Thanks

  Read the article

• Linq to SQL in and not in

  - by pranay_stacker

  what is in and not in equals in Linq to sql ? fore example select * from table in ( ...) and select * from table not in (..) what is equal to above statement in Linq to sql ?

  Read the article

• How to select a row with a missing entry in historization?

  - by Viper

  from the following data basis i need to select all IDQ's which do not have an entry for the 11.11.2011. IDQ | DATE ---------------- 1 | 08.11.2011 1 | 09.11.2011 1 | 10.11.2011 1 | 12.11.2011 1 | 13.11.2011 i can't figure out how to express the sql select IDQ from TBL_WITH_IDQ T where not exists ( DATE = '11.11.2011' ) // sql does not the job Database is a Oracle 11g. maybe someone can help me?

  Read the article

• add array element to row returned from sql query

  - by bert

  I want to add an additional value into an array before passing it to json_encode function, but I can't get the syntax right. $result = db_query($query); // $row is a database query result resource while ($row = db_fetch_object($result)) { $stack[] = $row; // I am trying to 'inject' array element here $stack[]['x'] = "test"; } echo json_encode($stack);

  Read the article

• Add space after the Exercise environment

  - by Flavius

  Hi I can't figure out how to add a space (say 3em) after the Exercise environment . I don't want to do it manually for every exercise, but automatically, by using \addtolength or redefining the environment or something. For leaving some space in front of it I managed to come up with this: \renewcommand{\ExerciseHeader}{\vskip 3em\centerline{\textbf{\large\smallpencil \ExerciseHeaderNB\ExerciseHeaderTitle% \ExerciseHeaderDifficulty\ExerciseHeaderOrigin\medskip}}} Thanks.

  Read the article

• Can I dynamically add content to a frame?

  - by user309641

  I have a frame and I want to dynamically add content to it with javascript or jquery but I can't do something like $('#myframe').html() like I could for a DIV. Is this possible?

  Read the article

• dynamically add uitextfield in the uiscrollview in iphone

  - by jaiminpanchal27

  i have an array of some values and i want to dynamically create textfields for all the string objects inside the array and add it to the scrollview.. how to do it..

  Read the article

• Transmogrify into date from multiple columns

  - by Dave Jarvis

  What is a better way to program the following SQL: str_to_date( concat(convert(D.DAY, CHAR(2)), '-', convert(M.MONTH, CHAR(2)), '-', convert(M.YEAR, CHAR(4))), '%e-%m-%Y' ) as AMOUNT_DATE I want to convert the columns D.DAY, M.MONTH, and M.YEAR to a date field using MySQL. The above works, but seems much more complicated than it needs to be. (If there's an ANSI SQL way to do it, that would be even better.) Thank you!

  Read the article

• Sharepoint: Add css and javascript to a web part page

  - by Rick

  I have created a web part Page and need to add css and javascript code to it. I am using Sharepoint 3.

  Read the article

• MSSQL using SSH-tunnel from Visual Studio

  - by pbt

  Hi, I recently contacted a web host regarding support for external database access to a Microsoft SQL Database included in a package they offer. They replied saying that it is only possible with an SSH-tunnel. Is it possible to connect to a MS SQL database in Visual Studio using an SSH-tunnel? It is important for me to be able to access the database from my local machine (for debugging, generating LINQ classes, editing tables, etc). Or, how should I go about working with their database?

  Read the article

• how to add List<string> in Session state

  - by nhoyti

  Hi guys, Is there a way to add List in session? or any other way to pass the values of List in another page?

  Read the article

• How to manually add Core Data to project?

  - by marko

  E.g. what "Use Core Data for storage" checkbox option means when creating new Window or Navigation based project? How to add Core Data for Tab Bar Application? How to initialize managedObjectModel, managedObjectContext, persistentStoreCoordinator?

  Read the article

• Django - Add rows to MySQL database

  - by yeenow123

  So I already have a database setup with a few columns and a few rows already inserted in. I'm trying to create a view that you would just input information into a form and press Submit, then a row would be added to the MySQL database with the information you just typed in. I believe you can do this with admin, but I would like to try without admin and I'm not sure if this is possible? I've been using the MySQL commandline to add rows as of now..

  Read the article

• Do Java annotations add notation or functionality?

  - by cafe

  Are Java annotations used for adding functionality to Java code besides just adding documentation about what's going on in the code? What's the most advanced/complex functionality you could add to your code through an annotation?

  Read the article

• Programmatically creating linked tables in access

  - by newtoaccess

  Hi all, We need to find a way to programatically *link all the tables* in a SQL Server database to an access db. We will be invoking this access database from a program that uses .net/SQL Server 2008. While invoking the application we would like to add the linked tables so that the users can just run the reports/modules from access without having to worry about linking the tables. Is there a way we can do this? Thanks!

  Read the article

• NHibernate Empty Set Clauses in SQL Update Statements

  - by Brian Wilkinson

  I'm getting SQL update statements from NHibernate having a empty set clause ie UPDATE SET WHERE x == ? This propblem is occuring when a child entity is being updated for some reason the sql statement is being run against the Parent Entity, for some reason NHibenate is saying the parent has changed but when the set clause is being built no changes are found, can anyone help. The application I am constructing isn 3 tier. The domain entities are light weight data contract only entities.

  Read the article

• Connect to web-service/API in MySQL?

  - by Jesse Figueroa

  I'm creating a sql based procedure which can Accept a table load the values one at a time send the variables to a remote API Record the response of the API Write the response to a table for viewing later I have successfully implemented 1,2, and 5. I am hoping there may be some way of choosing an address to contact and for SQL to listen too for a response. Please let me know if you have any suggestions!

  Read the article

< Previous Page | 538 539 540 541 542 543 544 545 546 547 548 549  | Next Page >