Search Results

Search found 31293 results on 1252 pages for 'database agnostic'.

Page 813/1252 | < Previous Page | 809 810 811 812 813 814 815 816 817 818 819 820  | Next Page >

• Oracle: how to add a text node into an existing element

  - by Alessandro Vernet

  In Oracle, you can write: update t set xml = updateXML(xml, '/a/b/text()', 'gaga') This works only if you already have some text in the <b> element. How to update the document and "add some text" in <b> if the document in the database looks like: <a> <b/> </a>

  Read the article

• Jeditable doubling up on linebreaks every edit

  - by st3

  I'm using var retval = value.replace(/<br[\s\/]?>/gi, '\n'); To strip the <br> tags from the textarea and nl2br('$_POST('newValueHere')') to insert into my database and to return back to jeditable to display the edits. The only problem I'm having is that each click on the editable field seems to make all the <br> tags be written twice? This makes no sense, does anyone have any ideas what could be going on?

  Read the article

• Succinct But Complete Example of WPF App?

  - by Eric J.

  Is there a succinct but complete example project or tutorial that brings together the pieces of the Microsoft stack for a complete application? WPF MVVM Business Objects EF Database I find plenty for WPF and plenty for EF, but am having trouble fully understanding how the EF generated classes relate to business objects, and how those business objects in turn fit into the MVVM pattern.

  Read the article

• GSP rendering programatically

  - by tuler

  Suppose I have a gsp snippet stored in my database. How do I programatically merge it with a data model to produce a string.

  Read the article

• SQL Update to the SUM of its joined values

  - by CL4NCY

  Hi, I'm trying to update a field in the database to the sum of its joined values: UPDATE P SET extrasPrice = SUM(E.price) FROM dbo.BookingPitchExtras AS E INNER JOIN dbo.BookingPitches AS P ON E.pitchID = P.ID AND P.bookingID = 1 WHERE E.[required] = 1 When I run this I get the following error: "An aggregate may not appear in the set list of an UPDATE statement." Any ideas?

  Read the article

• Sql server messed up degree symbol

  - by user228058

  Some of the degree sysmbols in my sql server database are displaying like this: 173-¦F. When I do a search for that - SELECT * FROM PRoduct WHERE description LIKE '%-¦%', it does not bring them up. How can I find (and replace) such characters?

  Read the article

• Django Admin Interface : New changes to models don't appear in admin interface even after syncdb !!

  - by Rohit

  Except admin other apps using those models work fine. Tables are created in database. What can be the problem with admin app? How do I fix it?

  Read the article

• How do I simply set up an alert/reminder for dates set in MS Access?

  - by Jonathan Garrido

  I have a database in MS Access and within it I am holding dates for expirations for SSL's. I want to set a reminder for any SSL that is soon to expire. Anyone know the easiest way to go about this?

  Read the article

• SQL Query to get the table names which use a particular column as a foriegn key

  - by vinayvasyani

  What sql query would you write to get the table names which have a particular foriegn key. Eg. Person_Table(person_id,name,address,...) Purchases_Table(purchaseid, purchased_by_id(fkey)....) AccountDetails_Table(AccountId,PersonID,....) Roles_Table(PersonId,RoleID) Now i want to find the table names where Person id is used as a foreign key. The above schema would return me Purchases_Table,AccountDetails_Table, Roles_Table Database: SQL Server

  Read the article

• WordPress - moving from one host to another

  - by Maor

  I am trying to move a WordPress installation from one server to another one, including all of the SQL data, and the file-system data (photos,template files). I just have a problem changing the URLs in the database, since I need to replace the new URL with the old one. I would love to have some suggestions about how can I replace the URLs (maybe there's a rplace statement in SQL?) Thanks in advance.

  Read the article

• How to update table with ON DELETE CASCADE without dropping and recreating

  - by pukipuki

  During development of a PostgreSQL database, I made foreign keys in every table. The problem is that I forgot to select ON DELETE CASCADE option. I need to set that options on all tables. It seems I can only drop and recreate every constraint manually. Does anybody know any shortcuts?

  Read the article

• JDBC ODBC bridge for Mac OSX

  - by Saurabh Lalwani

  Hi, I am having a hard time establishing a connection to my database file using JDBC-ODBC bridge. The driver I am using is sun.jdbc.odbc.JdbcOdbcDriver but I believe it is not present on Mac OSX by default and hence throws an exception for class not found. I googled for the driver but could not find much useful information. Can somebody please help me establish the connection? Or send me any link which contains information I am looking for? Thanks,

  Read the article

• Convert sql query

  - by nisha

  I have used this query in sql,pls convert this query to use for access database. Table structure is UserID,Username,LogDate,LogTime WITH [TableWithRowId] as (SELECT ROW_NUMBER() OVER(ORDER BY UserId,LogDate,LogTime) RowId, * FROM @YourTable), [OddRows] as (SELECT * FROM [TableWithRowId] WHERE rowid % 2 = 1), [EvenRows] as (SELECT *, RowId-1 As OddRowId FROM [TableWithRowId] WHERE rowid % 2 = 0) SELECT [OddRows].UserId, [OddRows].UserName, [OddRows].LogDate, [OddRows].LogTime, [EvenRows].LogDate, [EvenRows].LogTime FROM [OddRows] LEFT JOIN [EvenRows] ON [OddRows].RowId = [EvenRows].OddRowId

  Read the article

• ASP.NET Session size limitation

  - by eugeneK

  Is there some kind of Session size limitation or advisable value to not to surpass ? In my web application i create few DataTables to store user selections which are stored in session until user approves selections so i add those values to database. problem is i don't know whether session is reliable enough to keep few objects in or not ? thanks

  Read the article

• Table lock after integrity maintanence completion

  - by bdhar

  I am using SQL Server 2000. I have a database with n number of tables in it. I have configured a maintenance plan. If I enable integrity check and run the plan, I am not able to enter any data through VC++/ADO. Is there anything I have to check?

  Read the article

• Event for "end edit" in a text box

  - by eli.rodriguez

  I am using a textbox in winform (c#) and using the text of to make consults in a database. But i need constantly consult the text of the textbox every time that text change. So for these i use the KeyUp. But this event is too slow. Is any event that just fire when the textbox editing has been finished ?. I consider for finish 2 conditions The control lost focus. The control has 200ms without keypress

  Read the article

• Change date format (in DB or output) to dd/mm/yyyy - PHP MySQL

  - by Jess

  MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ? I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or anything! Hopefully this is a straight forward change?

  Read the article

• Redirection in Rails

  - by Cyborgo

  Hi, I have a small question regarding rails. I have a search controller which searches for a name in database, if found shows the details about it or else I am redirecting to the new name page. Is there anyway after redirection that the name searched for to automatically appear in the new form page? Thanks in advance.

  Read the article

• What is the best forum plug-in solution for the Symfony framework?

  - by Zoja

  I'm looking for a good solution to integrate a forum into a symfony application. Something like phpBB would be excellent. I've seen phpBB plugins to integrate with symfony but that's not enough for my purposes, also, mapping database tables is a lame approach in my opinion. If anybody knows a good working forum component for Symfony then I would really apreciate it. :) Thanks!

  Read the article

• Diminishing programmer wants to get back to programming

  - by Marcus TV

  I last programmed actively in 2002. It is almost 8 years now. I learned C and then moved to Visual Basic for our thesis project in the university. I would like to ask suggestions on what programming language should I learn and put to profitability use in areas such as desktop applications, web development, and database applications.

  Read the article

• Empty object check

  - by developer

  Is there a way to know if all the properties in an object are empty. My object represents fields from database and I want to know if a particular record is present or not. NULL doesnt seem to work.

  Read the article

• xslt or php for rendering output

  - by Arsenal

  I'm creating something where users can upload an xml and data get's imported to the database. Now I'm building some kind of a preview page where users will get to see how their input will look once it's stored. What would be the fastest (in execution time), using XSL to transform the xml to a html page, or using php to render the output? My guess is XSL is far more suitable (+ faster) for this (and by using a DTD there's no need for code written validation, right?)

  Read the article

• create setup in java swing application

  - by adesh

  I am working on java swing application in which i have to give html files to the client to browse them in swing API. Now i want to create the setup for the project so that user could install the software on their computer and i want to include html files , java classes some jar files and ms access database also how could i use the path of directory created after the installation of software. Please suggest the code if possible

  Read the article

• Problem with setting text into a uneditable JTextField

  - by The Z

  I have a tabbed pane with a couple of uneditable JTextFields which I want to fill in with information from a database. However, when I set the text in the text fields to anything, it doesn't show up when I run the program. When I get the text and print it out, it does show. What could be the problem here?

  Read the article

• cannot select items list from telerik mvc combox box

  - by user384080

  I'm trying to implement the comboboxfor as follow: @(Html.Telerik().ComboBoxFor(model => model.ProductId) .AutoFill(true) .HighlightFirstMatch(true) .DataBinding(binding => binding.Ajax().Select("GetProductByKeyword", "Product")) I managed to populate the list but does not allow me to select from the list. Also, I need to show the product name but at the same time I need to bind the productId as this is Id will stored in the database. any ideas?

  Read the article

< Previous Page | 809 810 811 812 813 814 815 816 817 818 819 820  | Next Page >