Search Results

Search found 10028 results on 402 pages for 'berkeley db'.

Page 222/402 | < Previous Page | 218 219 220 221 222 223 224 225 226 227 228 229  | Next Page >

• Php framework for fast developing

  - by nucleartux

  Please advise a php framework for fast developing and for don't digress to write often using code(auth, db/orm,etc..). Requrements: Active community Easy to use simple many to many and many to one relations auth. mechanism RoR like Please sorry for english.

  Read the article

• Variable table or column names.

  - by Frank Computer

  INFORMIX-SQL or any other SQL-based DB: Suppose I have an app where depending on the value of some columns, example: company.code char(3) {abc} company.brach char(2) {01} Can I construct table name "abc01" for inclusion in SELECT * FROM abc01; ? In other words, a variable table name.. same question applies for column names.

  Read the article

• SSIS to copy data from one table to another, where not in destination table

  - by alex

  I'm in the process of creating an SSIS package on a server (server1) that looks at the data in a sql db on another site (server2) and copies relevant rows across. The SQL statement required is: SELECT * FROM server2.ordersTable WHERE OrderID Not In (SELECT OrderID FROM server1.ordersTable This selects data from server1 which isn't in the table on server2 (based on order id) I then need to insert the result into a table on server1 How would I approach this? What components do I need etc...?

  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

• CSV is not creating format problems with integer value when generated through SSIS package

  - by paranjai

  Hi I am trying to generate a CSV file from DB Query as source one of my column is having datatype nvarchar(50) with values as "01050007029604301001" After the export when the csv file is viewed using Excel the value appears as "1.0500E18" . How can i stop this . Please suggest

  Read the article

• Oracle on Linux with ASP.NET Windows Authentication Impersonation

  - by user118190

  Can someone please direct me on how to do this type of setup, i.e. I have a Windows Server with ASP.NET pages and would like to pass those credentials using Integrated Windows Authentication to a Linux-based Oracle DB.

  Read the article

• Concate String In MYSQL

  - by streetparade

  How can i concate this string in mysql desc=desc+$desct what i want is each time i insert a variable from PHP that the string is added to the string which was already in db and seperated with || the field desc should look like this desc 10||30||90||710 say i want to add the value 20 desc 10||30||90||710||20 then the desc field should look like this How can i implement this?

  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

• 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

• TSQL to combine a date field and a time field

  - by justSteve

  Using logparser to import IIS logs to a db results in one column that has the date value and a second field for time: 2010-05-25 00:00:00.000 2010-01-01 11:11:58.000 I'd like to code an INSERT AFTER trigger that combines the 2 fields.

  Read the article

• Factory(:user) hits database?

  - by davidegp

  Playing around with factories, which I read weren't supposed to hit the database, allowing you to avoid having your controller specs interacting with the DB. But when I fire up the Rails console in test and use a factory to create a sample user, I noticed an actual user gets created in the database. Huh? (Using Rails 2.3.8 and Factory Girl 1.2.3.)

  Read the article

• What trace flags are needed for detecting deadlocks

  - by AngryHacker

  I am trying to get better information on deadlocks that are occurring in my DB. After reading this article, it's still unclear to me whether I should be using trace flag 1204, 1222 or both.

  Read the article

• Case Statements versus coded if statements

  - by Eric

  What is more efficient - handling with case statements in sql or handling the same data using if statements in code. I'm asking because my colleague has a huge query that has many case statements. I advised her to take stress off of the DB by coding the case statements. I've found that it is more efficient...but why?

  Read the article

• python+gae compatible web ui toolkit with ajax but degrades gracefully when there is no js?

  - by lankerisms

  I am searching for a web toolkit that is Python compatible social/db/wiki like google-appengine compatible has built in pagination handles 'relationships' between entities uses ajax modal dialogs but degrades very gracefully on browsers that dont have js good ui decisions that make it gracefully degrade even on mobile, text and braille/speech interfaces.

  Read the article

• How do I keep connection in object explorer

  - by dotnet-practitioner

  This is regarding SQL server 2008 management studio.. I connect to different environment DB and every time I launch the Sql management console, I have to sign up every time to get those connections back in object explorer. Is there a way I could persist the connection so I don't have to login every time to different environments?

  Read the article

• Hibernate - how to create list of pojos?

  - by AspNewbie

  I am very new to Hibernate. I have MySQL database and mapped pojos. What should I do next? I know little bit LINQ to SQL from .NET, and it generates me List of mapped objects. So basically, what are my next steps after creating POJOS if I want to have List of them and do CRUD operations upon them and data will be also saved in DB not only in java objects ? kthx

  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

• Hibernate query cache automatically refreshed on external update?

  - by artgon

  I'm creating a service that has read-only access to the database. I have a query cache and a second level cache enabled (READ_ONLY mode) in Hibernate to speed up the service, as the tables being accessed change rarely. My question is, if someone goes into the DB and changes the tables manually (i.e. outside of Hibernate), does the cache recognize automatically that it needs to be cleared? Is there a time limit on the cache?

  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

• Where can I get SQL for default Oracle's "HR" schema?

  - by Dmitry

  I'm studying Oracle database and have to do some exercises with default "HR" schema. But I think that data in my tables is changed from default values (many students have access to DB and may be someone changed data). Where can I get SQL to construct default "HR" schema?

  Read the article

• Problem in importing the CSV file containing multiple commas in a sigle field

  - by kakaajee

  Hi Experts, I am having an issue with importing a large(60MB) CSV file in MYSQL DB. The problem arises when an address field has multiple comma seperated values e.g. home no, street no, town etc. I tried to use BigDump for it but, the problem did not solved because of a single field containing multiple comma separated values. Any idea, suggestion or solution from experts how to handle it? Please reply, because I am sick of it. Thanks

  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

• Sync Framework - calling Synchronize only when connection exists?

  - by kamilo

  Hello, How can I call Synchronize method on an agent but only when connection to remote db exists? I'm very new to sync framework so forgive me my ignorance. Thanks in advance :)

  Read the article

• SQL commands generated in Django by running sqlall

  - by k-g-f

  In my Django app, I just ran $ python manage.py sqlall and I see a lot of SQL statements that look like this, when describing FK relationships: ALTER TABLE `app1_model1` ADD CONSTRAINT model2_id_refs_id_728de91f FOREIGN KEY (`model2_id`) REFERENCES `app1_model2` (`id`); Where does "7218de91f" come from? I would like to know because I'd like to manually write SQL statements to accompany models changes in the app so that my db's can be kept up to date.

  Read the article

< Previous Page | 218 219 220 221 222 223 224 225 226 227 228 229  | Next Page >