Search Results

Search found 31891 results on 1276 pages for 'database schema'.

Page 551/1276 | < Previous Page | 547 548 549 550 551 552 553 554 555 556 557 558  | Next Page >

• Changing the default ActiveRecord id from 0 to 1000000

  - by jrk

  Hello there, I'd like to change the minimum for the id of created objects from 1 to 1000. So when I create in rails my first model object it gets the ID 1000 and not 1. Is there a way to set this in the schema/migration files?

  Read the article

• Copy (or USE) data from two tables in different databases

  - by Z77

  I don-t know how to use one table from one database and second table from another databse at the same time or copy data from table in one database to table from another databse. I tried following query: select * into NewTable from existingdb.dbo.existingTable; But it doesnt't work.

  Read the article

• MySQL: NOW() giving me zeros

  - by Tunji Gbadamosi

  I have a table which I want to record the timestamp of every order at every insertion time. However, I'm getting zero values for the timestamps. Here's my schema: CREATE TABLE IF NOT EXISTS orders( order_no VARCHAR(16) NOT NULL, volunteer_id VARCHAR(16) NOT NULL, date TIMESTAMP DEFAULT NOW(), PRIMARY KEY (order_no), FOREIGN KEY (volunteer_id) REFERENCES volunteer(id) ON UPDATE CASCADE ON DELETE CASCADE)

  Read the article

• Automating R Script

  - by ETD

  I have written an R script that pulls some data from a database, performs several operations on it and post the output to a new database. I would like this script to run every day at a specific time but I can not find any way to do this effectively. Can anyone recommend a resource I could look at to solve this issue? I am running this script on a Windows machine.

  Read the article

• Getting the list LocalAdmins for a set of Server - C#

  - by PK

  I have a list of computers (stored in a database) and I want to find out the localadmins on those computers programmatically so that I can store that information in the database too. I understand this can be done using powershell. But looking for a way to do the same thing using C# how do I do that

  Read the article

• Many to many in linq with vb.net

  - by user512623

  I have 3 tables in a database: image of the database I have been looking online for a long time trying to find out how in linq and vb.net how i can do a query that has access to both the event and individual table for example showing all the events individual 1 is taking part in ect. i was wondering if anyone could point me in the right direction or know of any good tutorial sites with good examples of things similar. Thanks in advance :) Luke.

  Read the article

• Difference between time() and current time() PHP

  - by Belgin Fish

  Hi, I'm currently creating a subscription membership for my website. I'm storing the date their subscription started in my database using time() (not extra parameters) If not, how can i find the number of days between the current time() and the time() stored in the database? Thanks!

  Read the article

• How can I query all rows that are currently before data specified in one column in table?

  - by newbie

  I need to get all rows tha are valid, ValidDate is column that shows how long these database items are valid. I need to get only valid items from the database. How can I do that? I use SQL Server.

  Read the article

• How hard is it to determine what procedures/functions no longer compile?

  - by Dave

  In sql server how difficult would it be to determine what procedures/functions no longer compile? In other words, if I scripted out alter statements for all procedures and functions in a database, I'd like to know which of these statements are going to fail? I've been working on cleaning up a database I've inherited which has gone through years of changes and I'd like to what objects are going to raise errors when something tries to execute it.

  Read the article

• Mocking ISession.Query<T>() for testing consumer

  - by TheCloudlessSky

  I'm trying to avoid using an in memory database for testing (though I might have to do this if the following is impossible). I'm using NHibernate 3.0 with LINQ. I'd like to be able to mock session.Query<T>() to return some dummy values but I can't since it's an extension method and these are pretty much impossible to test. Does anyone have any suggestions (other than using an in memory database) for testing session queries with LINQ?

  Read the article

• MDF and LDF Files size

  - by Nazim

  I was wondering if there was any recommended max size for MDF and/or LDF Files for an SQL server instance. For example, if I want to create a 400 GBytes Database, is there a rule to help me decide how many mdf files I should create ? or should I just go ahead and create a single gigantic 400Gbytes mdf file? If so is this going to somehow affect the database performances ?

  Read the article

• dragging and dropping in asp.net?

  - by sam

  Hi Guys, I am new to web development, I am coding some ASP.NET, I watched many videos about using LINQ to SQL, I am happy I learned something, but is it the good way of using is: dragging and dropping and that's done??? what are the best practices to use LINQ to access Database ( my database is not only SQL server..MYSQL..) Thanks

  Read the article

• Changing a field's nullable attribute in Django after the model is committed?

  - by Rhubarb

  So I have a model that has a field, which originally defaulted to not allow nulls. I want to change it to allow nulls, but syncdb doesn't make the change. Is it as simple as changing it in the database and reflecting it in the models.py file just for the next time its run against a new database?

  Read the article

• asp code for excel upload

  - by vicky

  i want to upload an excel file from the client to the server using asp .then it shud check the field name of the file with the oracle database table and then save its content in the database. can somebody help me with this....??

  Read the article

• Rails, Is there any way in my view use link_to to grab the contents of a specific field and place it

  - by Datatec

  Basically I am trying to capture the value of the form field before it is saved to the database. Then I intend to use that value in my controller to update a specific field in the database, using @taskforms.update_attribute('notes', $notes) I need to do this because I know of no other way to update that that does not require the full record to be validated.

  Read the article

• How do I add my SQL 2005 DB to my VS MVC 2 project?

  - by Jason

  I want to use the built-in membership functionality that comes with the SQL Express database that is created when the project is built but I want to use it in my SQL Server database without having to re-create the wheel so to speak.

  Read the article

• Where to keep config data other than config file (Windows App)?

  - by user144842

  My Windows application GUI is accepting some required application configuration fields from the user. I need to store them of course, but I wanna hide these fields from the user. I cannot use database to store these configs. I want to avoid using app.config either. (No app.config encryption) Any suggestions, Where and in which format i should store fields. (Field example is: Accepting database User credentials, Task Schedule info etc.)

  Read the article

• connect to mysql using c++

  - by hero

  is it possible to connect to an mysql database and issue queries using c++? i found some sample code from the internet but they all use mysql! so u need to install mysql first on the computer. what i want is to use a program from different locations where i don't have mysql installed to access a remote mysql database. is this possible?

  Read the article

• Creating app data on first use

  - by rity

  I once read somewhere that apps should not copy data while doing an installation but rather all data creation must be done the first time the app is used. Q1: Does this apply to Windows Mobile apps also? Q2: Is it not okay then to copy a blank database to the \appdata\product\ folder and populate it when the user uses the app or must I wait for the user to se the app to even create the database. Win Mobile C# .NET

  Read the article

• SQL Server replication question.

  - by schar

  I had inherited this SQL Server where we put data in a table (Call TableA) on a database (DB-A). I can see the tableA in another database on the same server ( DB-B) gets the same data right away. Any ideas how this is implemented? I am trying to see the trace but so far no luck. Any one has an idea? At this stage I am not sure if its replication. This is a guess

  Read the article

• How to create a constructor in a php class?

  - by almost dead

  All methods in my php class must connect to the database, so I think it is a good idea to connect to the database in the constructor function (in the first place, to speak so). Is it normal to do so? And how to create a constructor in PHP?

  Read the article

• Storing Images

  - by Mike

  Hello All, How to Store Large size Images into iPhone Application? Images are taken from UIImagePickerController but saving into Database and retrieving from Database crash the application.

  Read the article

• Simple DB2 Query for connection validation

  - by Eric Tuttleman

  I'm looking for a simple DB2 query that can be used to test if a database connection in pool is still valid. It needs to be a generic query that would execute regardless of which databases exist. For other database servers, I've used something like 'SELECT 1' or 'SELECT version();' What would be an equivalent for DB2? Thanks!

  Read the article

• XML Document straight to Stored Proc Mapping in NHibernate

  - by ZekeTheGeek

  Hello. I'm building a mechanism to take XML data from a queue and call stored procs to save the data from the XML document directly to the database. This seems like something that NHibernate could address, but of course most of the information I find discusses going from objects to database instead of another data format (XML, in this case). Is there a way to use NHibernate in this fashion or am I barking up the wrong tree? Thanks.

  Read the article

• convert &uuml; to u

  - by Remus Rigo

  hi all I'm using a database that contains contacts (fields like name, address, ...). If i'm using in my database a city that contains special chars (like ü) or html codes (like &uuml;), then how can i convert them to u, so when i search for a city that contains that a special char should be shown in the result...

  Read the article

< Previous Page | 547 548 549 550 551 552 553 554 555 556 557 558  | Next Page >