Search Results

Search found 10329 results on 414 pages for 'berkeley db je'.

Page 231/414 | < Previous Page | 227 228 229 230 231 232 233 234 235 236 237 238  | Next Page >

• Invoking a PHP script from a mysql trigger

  - by Shyju

  Is there anyway invoke a PHP page / function when a record being inserted in to the mysql db table. We dont have control over the record insertion procedure.Is there some thing called trigger which can call a PHP script back ?

  Read the article

• mysql : possible to put IF statment in LEFT JOIN ?

  - by Haroldo

  Ok so i want to get an artists info from the db, but i want to know if they have any forthcoming events. To do this i need to traverse 2 tables, where events_artists is a 2 col link table... (this doesnt work but is what id like to do) SELECT art.*, events.event_id FROM art LEFT JOIN events_artists ON art.art_id = events_artists.art_id LEFT JOIN events ON events_artists.event_id = events.event_id IF ( {criteria} ) what should i be doing here to get this to work?!!

  Read the article

• database transaction rollback processing in PHP

  - by user198729

  try { $con->beginTransaction(); $this->doSave($con); $con->commit(); } catch (Exception $e) { $con->rollBack(); throw $e; } The code above is quite standard an approach to deal with transactions, but my question is:what if $con->rollBack() also fails? It may cause db lock,right?If so,what's the perfect way to go?

  Read the article

• SQL Complex Select - Trouble forming query

  - by JoshSpacher

  I have three tables, Customers, Sales and Products. Sales links a CustomerID with a ProductID and has a SalesPrice. select Products.Category, AVG(SalePrice) from Sales inner join Products on Products.ProductID = Sales.ProductID group by Products.Category This lets me see the average price for all sales by category. However, I only want to include customers that have more than 3 sales records or more in the DB. I am not sure the best way, or any way, to go about this. Ideas?

  Read the article

• SQLite database verification after nhibernate schema generation

  - by Berryl

  What is the simplest most effective way to verify that your SQLite db is actually out there after using NHib's schema generation tool? Cheers, Verryl

  Read the article

• How turn text links into HTML links at the client side with javascript

  - by xRobot

  In my db I have saved every links in the form: www.example.com or http://www.example.com Is there a way to turn this text links into HTML links at the client side ( e.g. javascript ) with tag and parameter like this ?: <a href="http://www.example.com" rel="nofollow">www.example.com</a>

  Read the article

• Large transactions causing "System.Data.SqlClient.SqlException: Timeout expired" error?

  - by Michael

  My application requires a user to log in and allows them to edit a list of things. However, it seems that if the same user always logs in and out and edits the list, this user will run into a "System.Data.SqlClient.SqlException: Timeout expired." error. I've read comments about increasing the timeout period but I've also read a comment about it possibly caused by uncommitted transactions. And I do have one going in the application. I'll provide the code I'm working with and there is an IF statement in there that I was a little iffy about but it seemed like a reasonable thing to do. I'll just go over what's going on here, there is a list of objects to update or add into the database. New objects created in the application are given an ID of 0 while existing objects have their own ID's generated from the DB. If the user chooses to delete some objects, their IDs are stored in a separate list of Integers. Once the user is ready to save their changes, the two lists are passed into this method. By use of the IF statement, objects with ID of 0 are added (using the Add stored procedure) and those objects with non-zero IDs are updated (using the Update stored procedure). After all this, a FOR loop goes through all the integers in the "removal" list and uses the Delete stored procedure to remove them. A transaction is used for all this. Public Shared Sub UpdateSomethings(ByVal SomethingList As List(Of Something), ByVal RemovalList As List(Of Integer)) Using DBConnection As New SqlConnection(conn) DBConnection.Open() Dim MyTransaction As SqlTransaction MyTransaction = DBConnection.BeginTransaction() Try For Each SomethingItem As Something In SomethingList Using MyCommand As New SqlCommand() MyCommand.Connection = DBConnection If SomethingItem.ID > 0 Then MyCommand.CommandText = "UpdateSomething" Else MyCommand.CommandText = "AddSomething" End If MyCommand.Transaction = MyTransaction MyCommand.CommandType = CommandType.StoredProcedure With MyCommand.Parameters If MyCommand.CommandText = "UpdateSomething" Then .Add("@id", SqlDbType.Int).Value = SomethingItem.ID End If .Add("@stuff", SqlDbType.Varchar).Value = SomethingItem.Stuff End With MyCommand.ExecuteNonQuery() End Using Next For Each ID As Integer In RemovalList Using MyCommand As New SqlCommand("DeleteSomething", DBConnection) MyCommand.Transaction = MyTransaction MyCommand.CommandType = CommandType.StoredProcedure With MyCommand.Parameters .Add("@id", SqlDbType.Int).Value = ID End With MyCommand.ExecuteNonQuery() End Using Next MyTransaction.Commit() Catch ex As Exception MyTransaction.Rollback() 'Exception handling goes here End Try End Using End Sub There are three stored procedures used here as well as some looping so I can see how something can be holding everything up if the list is large enough. Other users can log in to the system at the same time just fine though. I'm using Visual Studio 2008 to debug and am using SQL Server 2000 for the DB.

  Read the article

• How do I extract Info associated with any OpenID provider?

  - by Adnan

  OpenID providers like GOogle,Yahoo etc also stroes user info like Name,email etc. Is it possible to retrieve it by using OpenID Selector(http://code.google.com/p/openid-selector/)? If yes then how do I fetch it? is the OpenID URL same every time when a user logs in? if yes ten may I store that handler in DB? I am using PHP.

  Read the article

• Can I separate merged model into source parts?

  - by Yola

  Can I separate merged model into source parts? Need to do it for reason of upgrade to new versions my every or not every source part of db. It must work under 10.5, so i cant use inferredMappingModelForSourceModel.

  Read the article

• Can I delay window.open()?

  - by Jisaak

  So here is my basic problem. The user clicks the save button. Use Ajax to save the content via code-behind. THEN open a new window that loads the content from the DB. I just need a way to not open the window until the content has been saved. Right now it immediately opens a new window and the content isn't all saved yet. Any ideas?

  Read the article

• When using spring and hibernate, how are sessions/transactions handled?

  - by Blankman

  when using hibernate with spring, can someone explain how the session unit of work and transactions are handled? is the transaction started at the beginning of the page request, and committed at the end? can I have multiple db calls per request, that each have different transaction levels? e.g. some are left as default, while others are read-uncommitted?

  Read the article

• How to sort it!?

  - by user334269

  The following is my DB data, how can I sorting it by sid and prev_sid with php/mysql!? sid prev_sid type 000 197 app_home 197 198 page_teach 198 218 page_teach 199 211 page_step 211 207 link 218 559 page_step 559 199 page_step Result: sid prev_sid type 000 197 app_home 197 198 page_teach 198 218 page_teach 218 559 page_step 559 199 page_step 199 211 page_step 211 207 link 000 197 198 218 559 199 199 211 207

  Read the article

• Should I put the sqlite3 databases (for an RoR project) in the VCS?

  - by ryanprayogo

  What is the common way of dealing with the development.sqlite3 files with VCS (in particular, git)? If I commit this file to the VCS, will it be merged with another developer's copy? Or should each developer run the db:migrate task each time a new migration file is created?

  Read the article

• Help getting the following create table function to work with mysql and C#

  - by Matt

  string createTable = "CREATE TABLE IF NOT EXISTS " + m_strDatabase + "_TimeLogs (logName VARCHAR(16), logTime INTEGER, logCountry TEXT, UNIQUE(logName)) TYPE=MyISAM;"; When this runs, no table is created. No errors either. Im using an ODBC connector. the variable passes in the db name, so that the table created would be users_TimeLogs if the database was called users for example. Am I doing something wrong?

  Read the article

• JPA polymorphic oneToMany

  - by bob

  I couldn't figure out how to cleanly do a tag cloud with JPA where each db entity can have many tags. E.g Post can have 0 or more Tags User can have 0 or more Tags Is there a better way in JPA than having to make all the entities subclass something like Taggable abstract class? Where a a Tag entity would reference many Taggables. thank you

  Read the article

• Efficient SQL to count an occurrence in the latest X rows

  - by pulegium

  For example I have: create table a (i int); Assume there are 10k rows. I want to count 0's in the last 20 rows. Something like: select count(*) from (select i from a limit 20) where i = 0; Is that possible to make it more efficient? Like a single SQL statement or something? PS. DB is SQLite3 if that matters at all...

  Read the article

• Convert a time to specified time zone using C#?

  - by Ravi

  I'm working on an application in C# with .Net 3.5. I have time zone value of the User is stored in DB with this format (-05:00,1), where -5.00 represents EST time zone value and the 1 indicates that this time zone follows daylight saving (if 0 not a daylight saving zone). Now I want to convert any date time value into this timezone value considering the daylight saving value. Any help is appreciated. Thanks

  Read the article

• How important is it for me to pool my connections?

  - by Rio Mango

  It has been suggested to me that I rearrange my code to "pool" my ADO connections. On each web page I would open one connection and keep using the same open connection. But someone else told me that was important 10 years ago but is not so important now. If I make, let's say, 5 db calls on a web posting, is it problematic to be using 5 separate connections that I open/close?

  Read the article

• MS SQL tuning tools for finding overload

  - by SkyFox

  I use MS SQL server as a DBMS for my very big corporate DB (with different financial data). And some times my system go down. I don't understand why. What programs/tools I can use for finding process/program/thread, that overload my SQL-server? Thanks for all answers!

  Read the article

• How to represent "ALL" in Primary Key -foreign Key relationship.

  - by Rohit

  I have to create a db design to store blacklisted fax numbers. I have created a table and one column of this table is customerID which is a foreign key to table Customer. Now i want to have a faxnumber which is blacklisted for all customers. How should i proceed with this. Should i use Null in this case. Please provide options

  Read the article

• MySQL 5.0.22 export dump file not importing - syntax errors

  - by user348033

  Hello, I backed up my db with mysqldump from phpMyAdmin. Using MySQL 5.0.22. Made no changes to database file. Import fails. Found many instances of extra spaces using notepad, but now cannot find any other such extraneous spaces. Error is 1064. Any suggestions on how to import file properly? Thanks.

  Read the article

• how to save related models with non-null foreign key

  - by Fortress

  I have a model called user which has_one email. I put the foreign key (NOT NULL) inside users table. Now I'm trying to save it in the following way: @email = Email.new(params[:email]) @email.user = User.new(params[:user]) @email.save This raises a db exception, because the foreign key constraint is not met (NULL is inserted into email_id). How can I elegantly solve this or is my data modeling wrong?

  Read the article

• ASP.NET javascript close page after timeout?

  - by AliRiza Adiyahsi

  I want show an information page after success db opartions. And after the info I want to close each pages (information page and main page) I wrote this in button oncommand event: //but this code does not work Response.Write("<script language='javascript'>setTimeout('self.close();',3000);</script>"); at the same time, I want to show an information message. And then I want to close all, after three seconds.I hope I could explain :) Thanks.

  Read the article

• DotNetNuke allowprint/minimize&maximize

  - by Idealflip

  Hello all, Does anyone know of a DB setting in DotNetNuke, where you can configure ALL modules to disable print or maximize&minimize? Just so I don't have to configure every module individually. How can I make it a default? Thanks again!

  Read the article

• When should I think about implementing my User authentication / session?

  - by Jason N

  After spending some time wireframing my ideas, I want to start building my rails app. However, I'm well aware that later down the line I'd like to consider multiple user accounts. Should I be thinking about the implementation of this from this early stage, or is this something I can implement without too much fuss later? It seems like something that would be stupid to attempt later, but part of me just wants to get the guts of the thing working - a couple of simply forms and writing/reading some stuff from the db.

  Read the article

< Previous Page | 227 228 229 230 231 232 233 234 235 236 237 238  | Next Page >