Search Results

Search found 31968 results on 1279 pages for 'database training'.

Page 375/1279 | < Previous Page | 371 372 373 374 375 376 377 378 379 380 381 382  | Next Page >

• Is it bad practice to use an enum that maps to some seed data in a Database?

  - by skb

  I have a table in my database called "OrderItemType" which has about 5 records for the different OrderItemTypes in my system. Each OrderItem contains an OrderItemType, and this gives me referential integrity. In my middletier code, I also have an enum which matches the values in this table so that I can have business logic for the different types. My dev manager says he hates it when people do this, and I am not exactly sure why. Is there a better practice I should be following?

  Read the article

• Average time from database list in C# with ASP MVC?

  - by Jacob Huggart

  I have a list of times that I have acquired from a sql database and I need to find the average time. I tried just doing list.average() and list.sum(), but neither of those work with timespan lists. What do you all suggest? btw, time is returned in a hh:mm:ss format.

  Read the article

• How can I query the database culture (SQL Server 2005) ?

  - by Quandary

  How can I query the database culture (SQL Server 2005) ? I have problems inserting and getting dates, because the client's servers don't run on the same culture as my developer server. I can adjust the date, but I need to know the server's culture...

  Read the article

• How to submit/update/delete data through InfoPath Form to an MS Access Database on Sharepoint 2007

  - by yreddy

  Hi I want submit Data/update/delete through InfoPath Form to an MS Access Database on Sharepoint 2007 (MOSS 2007), If custome code require please give code. Thanks

  Read the article

• How to performance test a Rails application without rebuilding the test database?

  - by Cheng

  I would like to do some performance testing of a Rails app. I want to test the app with real world data, which is 100 MB in size. The problem is, Rails' test environment always rebuilds the database from fixtures, which always overwrites the real world data. So how should I do the performance test?

  Read the article

• Reading an XML file and store data to mysql database.

  - by Jack Brown

  Hi I need the following php script to do a currency conversion using a different XML file. Its a script from white-hat design http://www.white-hat-web-design.co.uk/articles/php-currency-conversion.php The script needs to be amended to do the following: 1, The php script downloads every 24 hours an xml file from rss.timegenie.com/foreign_exchange_rates_forex rss.timegenie.com/forex.xml rss.timegenie.com/forex2.xml 2, It then stores the xml file data/contents to a mysql database file ie currency and rate. Any advice would be appreciated.

  Read the article

• how to get data from a datagridview and insert into database without using databinding?

  - by KATy

  hi guys i ve a datagrid and wen a button s clicked i want the values from the datadrid to the database.. without databind to dataset/datatable.. thanx in advance

  Read the article

• Any gotchas in migrating database connectivity to the JDK 2.0 style ?

  - by Everyone

  Looking at some old application code which uses explicit driver loading as Class.forName(...).newInstance I have been told to change this to use the JDK2.0 mechanism to establish a database connection using ContextLookup, and DataSource. Are there any gotchas I should be aware of?

  Read the article

• Best way to get a Web Service to return a database result as XML?

  - by John

  I am building a webservice using jax-rs and querying a DB2 z/OS database with SQLJ and getting the result set as an arraylist. I would like to return this list as XML, but not sure how to do it. Does anyone have an example of returning a result set as XML and is using an Arraylist the best way to do this? Should I use JAXB? if so how?

  Read the article

• How can I plot graphs with MS Chart controls using data from the database?

  - by Allan

  I need a sample code on how I can plot a graph in a C# application using the MS Chart add on in Visual Studio 2008 using linq to sql to collect the data from the database?

  Read the article

• word macro to save a selected range into database.

  - by Thunder

  Is there a way in word to save a selected portion into the database as range object.So that we can later retrieve it . It is required to generate a report in word ,the section needs to be repeated many times. I have searched net for quite some time but not much material is found. thanks.

  Read the article

• Excel macro to change external data query connections - e.g. point from one database to another

  - by Rory

  I'm looking for a macro/vbs to update all the external data query connections to point at a different server or database. This is a pain to do manually and in versions of Excel before 2007 it sometimes seems impossible to do manually. Anyone have a sample? I see there are different types of connections 'OLEDB' and 'ODBC', so I guess I need to deal with different formats of connection strings?

  Read the article

• In a web farm environment, should we base the system date/time to the web servers or the database se

  - by leypascua

  Assuming there are a number of load-balanced web servers in a web farm, is it safe to use DateTime.Now in the application code for getting the system date/time or should we leave this responsibility to the database server? Would there be a chance that machine date/time settings on all servers in the webfarm are out of sync? If date/time will be the responsible of the DBMS, how will this strategy work if we have load-balanced replicated DBs?

  Read the article

• What is the most efficient way to populate class attributes with a row from a database query?

  - by ensnare

  Looking to have a database query set all the instance variables in a class: Example: def populate(self, if): #Perform mysql query self._name = row['name'] self._email = row['email'] ... What's the fastest way to do this? Or is this not recommended (with a better approach)? Thanks.

  Read the article

• Is there any MS SQL database designer software like MySQL workbench?

  - by newbie

  I need to design database for MS SQL Server, is there any MySQL workbench like software for that? I have access to MSDN, so it can also be commercial product that can be found form MSDN.

  Read the article

• Where does Drupal store user permissions in the database?

  - by Ryan Nelson

  Does anyone know where Drupal stores, in the Database, the role of a user? It's not in the users table, and I can't seem to find it. I can find where it defines the role, defines the role's permissions, but I can't find where it defines what Role a certain User is. Anyone know? Thanks!

  Read the article

• how to import the excel file to sql database using vb.net?

  - by subhashiniskmr

  I have a more data in excel file .so i have to import it into sql database using vb.net.can anyone send the source code?

  Read the article

• problem to Get Date, month Year separately From database in Php File ?

  - by aamir Fayyaz

  i want to separate date, month, time, hour, min ,sec getting from database, for count down timer, in data base stored date is 2010/10/10: me using this code : $m=date('m',$row['Date']); $d=date('d',$row['Date']); output is month=31 date = 12....

  Read the article

• How can I get all the database names in a sql server instance using tsql?

  - by Yousui

  Hi guys, How can I get all the database names in a sql server instance using tsql? Great thanks.

  Read the article

• How can I force NHibernate to hit the database when querying for an entity?

  - by Chris Holmes

  I have a situation where I need NHibernate to ignore its caches and just hit the database because the data has changed (another user on another computer has changed the data). How is this possible? So far I have had no luck. Get, Load, Linq query, doesn't matter. NHibernate is not getting the most recent data.

  Read the article

• PHP: How do you safeguard application/server/database from your employees?

  - by Patrick

  What do you guys do (system/framework wise) to safeguard things like 1) employees writing malicious code to destroy your server 2) employees reading all your database sensitive information 3) generally programmers that have access to your back-end and potential damages that they can do. Is there any PHP scripts that guards against these, etc.?

  Read the article

• Using serializable in hibernate what underlying database types do i use.

  - by joe90

  I need to use a serializable type in hibernate (to store a Subject (security)) All this works fine. I just need to know what the underlying database types are for the following databases: MSSQL - I used 'image' db2 - postgre - mysql - Thanks..

  Read the article

• i have two tables in my sql database of 1 million records, is there a way to find out the non matchi

  - by sharma

  i have two large tables in a database. table 1 with 2 fields rank,name and table2 with 2 fields rank,name. both are of 1 million records. can you write php sql code to fetch those records which exists in table2 but does not exist in table1.

  Read the article

• How can i learn Table Name in database an column name?

  - by Phsika

  How can i learn table Name in database an how can i learn any Table's Column name? SELECT Col.COLUMN_NAME, Col.DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS AS Col LEFT OUTER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE AS Usg ON Col.TABLE_NAME = Usg.TABLE_NAME AND Col.COLUMN_NAME = Usg.COLUMN_NAME LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS Con ON Usg.CONSTRAINT_NAME = Con.CONSTRAINT_NAME WHERE Col.TABLE_NAME = 'Addresses_Temp' AND Con.Constraint_TYPE = 'PRIMARY KEY' But it returns to me empty data:(

  Read the article

• In python, is there a simple way to connect to a mysql database that doesn't require root access?

  - by Matthew

  I'm writing a script to parse some text files, and insert the data that they contain into a mysql database. I don't have root access on the server that this script will run on. I've been looking at mysql-python, but it requires a bunch of dependencies that I don't have available. Is there a simpler way to do this?

  Read the article

< Previous Page | 371 372 373 374 375 376 377 378 379 380 381 382  | Next Page >