Search Results

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

Page 846/1252 | < Previous Page | 842 843 844 845 846 847 848 849 850 851 852 853  | Next Page >

• Handling ties when ranking from the highest to the lowest

  - by Undgerman

  I am trying to make a ranking manager for a small project.The totals are stored in the database.I can easily get the max and min using mysql and also arrange the records descending.The problem comes in when there is a tie.I need to show a tie in the form:1,2,3,3,4,5,6,7,7,7,7, etc.The repeated numbers will show the ties.I have been thinking of ways of achieving the above but i need more ideas;mine is seems long and complicated. Can anybody share his/her idea of doing the ties.

  Read the article

• Oracle scheduler job log output

  - by JOTN

  I'm using dbms_scheduler to execute a PL/SQL stored procedure. I would like to be able to have that code create some text logging output and associate it with the run to verify it's working, but I can't find anything to do that in the docs. Is there a facility to do this that I'm missing? This is an 11g database running under Unix. It would be real nice if I could use dbms_output so I could also run it from sqlplus and get output.

  Read the article

• A Query to remove relationships that do not belong [closed]

  - by Segfault

  In a SQL Server 2008 R2 database, given this schema: AgentsAccounts _______________ AgentID int UNIQUE AccountID FinalAgents ___________ AgentID I need to create a query that does this: For each AgentID 'final' in FinalAgents remove all of the OTHER AgentID's from AgentsAccounts that have the same AccountID as 'final'. So if the tables have these rows before the query: AgentsAccounts AgentID AccountID 1 A 2 A 3 B 4 B FinalAgents 1 3 then after the query the AgentsAccounts table will look like this: AgentsAccounts AgentID AccountID 1 A 3 B What T-SQL query will delete the correct rows without using a curosr?

  Read the article

• Is it expensive to hold on to PreparedStatements? (Java & JDBC)

  - by sbook

  I'm trying to figure out if it's efficient for me to cache all of my statements when I create my database connection or if I should only create those that are most used and create the others if/when they're needed.. It seems foolish to create all of the statements in all of the client threads. Any feedback would be greatly appreciated.

  Read the article

• Can I use anything other than BIGINT as Primary Key data type in SQLite?

  - by weenet

  I was psyched about the possibility of using SQLite as a database solution during development so that I could focus on writing the code first and dynamically generating the db at runtime using NHibernate's ShemaExport functionality. However, I'm running into a few issues, not the least of which is that it seems that SQLite requires me to use Int64 for my primary keys (vs, say, Int32 or Guid). Is there any way around this?

  Read the article

• c# .net MVC4 Model to represent table or form

  - by Matthew Chambers

  Hello I am a little confused with regards to models in mvc 4 and thought someone may be able to point me in the right direction. This would be most appreciated. For example if i have a table that has the following fields [StringLength(100, ErrorMessage = "The {0} must be at least {2} characters long.", MinimumLength = 5)] public string UserName { get; set; } [Required(ErrorMessage="Email Address is Required")] [StringLength(15, ErrorMessage = "Email Address must be between {0} and {1} in size",MinimumLength = 5 )] [DataType(DataType.EmailAddress)] [Display(Name="Email")] public string Email { get; set; } [MaxLength(25)] [Display(Name="Mobile Telephone Number")] public string Mobile {get;set;} [MaxLength(500)] [Display(Name="Headline")] public string Headline {get;set;} [Required] [StringLength(200)] [Display(Name = "First Name")] public string FirstName {get;set;} [Required] [StringLength(200)] [Display(Name="Surname")] public string Surname { get; set;} public virtual int? DayOfBirthId { get; set; } public virtual DayOfBirth DayOfBirth { get; set; } public virtual int? MonthOfBirthId { get; set; } public virtual MonthOfBirth MonthOfBirth { get; set; } public virtual int? YearOfBirthId { get; set; } public virtual YearOfBirth YearOfBirth{get;set;} This is my user profile table in the database. However I would like a form that the user registers to the site with. When they first register i do not need all the details such as telephone all i really need is there username, email address and password. Do i create another model for this. Or do i have one model and on the controller set the fields to null or empty string that are not required on registration. I have validation also so would this be set for data that has not been entered on the form. My question is ultimately should all forms represent models- should the database be redesigned to meet this required. Or should the controller set the values that are not required. Or should there be another model that represents the form be created which maps to this table. I am a little confused on this and clarification of anyone would be most appreciated.

  Read the article

• SSIS with different table structures

  - by Grace

  I have a flat file source from Excel that has a structure like this: **People** Day1 Day2 Day3 Day4 Person1 someValue ... Person2 Person3 And i would like the package to put this information in a database with standard columns 'Person', 'Day', 'Value'. Does anybody know how to do this - at the moment because the days are going along the top, the package is assuming these are seperate data columns when they are not really and the mapping is not working.

  Read the article

• How to enforce unique field value in java Google App Engine

  - by supercobra

  Hello there, I am try to find out how to enforce uniqueness in fields other than the unique id. Example: @PersistenceCapable(identityType = IdentityType.APPLICATION) public class User implements IsSerializable { @PrimaryKey @Persistent(valueStrategy = IdGeneratorStrategy.IDENTITY) private Long id; @Persistent private String name; @Persistent private String email; // <= I want this to be unique as well } In the example above, how can I enforce uniqueness of the email value across the database? Daniel

  Read the article

• Handling Session timeout in asp.net so all info. is aviable before create/update record

  - by Jack

  I'm having problem with some data missing in the record. I've a ASP.net web app that take some information from the user then create a record on the database. It's your typical CRUD app but I've noticed lately that some record are missing couple fields. Where they are null value. I think it might have been an Session issue. What's the best way to handle session time out in a typical CRUD app? Thanks

  Read the article

• How to manipulate sql connection string in C#

  - by Liveonthree

  Hi i'm trying to manipulate the sql connection string so instead of running the original copy of our database it runs from the copy one folder up in our C# project.

  Read the article

• How to insert Google Adsense in a single post after the <!--More--> Tag

  - by Bob Cavezza

  I'm using wordpress, and I want to add the adsense javascript tags where the Read More tag goes in a blogpost. It's stored as <!--more--> in the database, but when you use the_content() this is automatically changed before I have the chance to use a str_replace() function. I'm looking to place an adsense tag for each post in the single.php page where the teaser ends. Has anyone been able to do this?

  Read the article

• sql delete from rows value

  - by gloris

  The database includes a table with a rows: html/css/java/php How with sql query delete "java"? The result would be: html/css/php

  Read the article

• Simple tool/steps for obfuscating/scrubbing production data

  - by Krishna Kumar

  I am involved in a project where I need to provide subset of our production data (for a date range) to one of my co-workers for trouble shooting.I would like to insert a scrubbed subset of the production data into a new database table that my co-worker can access. Please suggest best approach to achieve this.

  Read the article

• Cascading drop down list in asp.net mvc 2.0?

  - by mary

  hello i want to implement cascading drop down list in asp.net mvc 2.0 from database. i had implementated it on mvc 1.0 but its not working in mvc 2.0 thank you.

  Read the article

• Passing data between asp.net pages

  - by user204588

  Hello, I'm wondering the opinion of what is the best way to pass a lot of values between pages. I was thinking of either saving the values to a database, using context.Items[], or Session[]. I'm not sure about what is the best method. I'm passing probably around 40 variables.

  Read the article

• bat file. delete until success?

  - by acidzombie24

  I run a bat file to clean up and sometimes it takes a few seconds for my app to full close. In it i delete a database. Instead of waiting or running it multiple times i would like the bat file to continue its attempts until it has a success. How can i do that?

  Read the article

• Python vs Groovy vs Ruby? (based on criteria listed in question)

  - by Prembo

  Considering the criteria listed below, which of Python, Groovy or Ruby would you use? Criteria (Importance out of 10, 10 being most important) Richness of API/libraries available (eg. maths, plotting, networking) (9) Ability to embed in desktop (java/c++) applications (8) Ease of deployment (8) Ability to interface with DLLs/Shared Libraries (7) Ability to generate GUIs (7) Community/User support (6) Portability (6) Database manipulation (3) Language/Semantics (2)

  Read the article

• Set given time to 00:00:00 in PHP/MySQL

  - by hypnocode

  Hi, I'm retrieving a date from a MySQL database that shows up like this: '2010-03-09 09:11:30' How can I change the date to '2010-03-09 00:00:00'? I'm using PHP to perform the query. Thanks!

  Read the article

• add item to combobox outside of the array - flex

  - by Adam

  I've got a combo box that's data provider is coming form a database query. Now I'd like to add one hard coded item to be included in the combobox a sort of reset item that would reset the combobox to display its prompt message. Any idea how to do this? Thanks!

  Read the article

• Remove all styles from dynamic label in asp.net

  - by kad1r

  I have a label and I got some text from database. text format like: Windows Server 2008 ...etc But sometimes there are different fonts or something like style. How can I remove all of them quickly? I know I can make it with replace command. But is there any quick way for it?

  Read the article

• hibernate proxy ..

  - by abc

  load() just returns a proxy by default and database won’t be hit until the proxy is first invoked. what does it mean by proxy exactly here ?

  Read the article

• i m new to sharepoint , where coding take place in sharepoint application as other normar asp.net a

  - by girish

  hello, i m new to sharepoint and bit confuse, i don't understand where coding take place in sharepoint as other asp.net application. how it work if i have to create a page for adding record to database.

  Read the article

• How can I extract a range of lines from a text file on unix?

  - by Adam J. Forster

  I have a ~23000 line sql dump containing several databases worth of data. I need to extract a certain section of this file (i.e. the data for a single database) and place it in a new file. I know both the start and end line numbers of the data that I want. Does anyone know a unix command (or series of commands) to extract all lines from a file between say line 16224 and 16482 and then redirect them into a new file?

  Read the article

• iphone programming getting data from remote server

  - by user320023

  HI, I'm new to iphone programming and developing travel application, which retrieve most of it data from remote database. What is the best way to implement this solution? I thought of generating XML files in server side and getting data via XML files to iPhone app and displaying them... Is there better implementation to this, thank you in advance? Waruna.

  Read the article

• Can I tell sitecrawlers to visit a certain page?

  - by Ace

  Hi there! I have this drupal website that revolves around a document database. By design you can only find these documents by searching the site. But I want all the results to be indexed by Googlebot and other crawlers, so I was thinking, what if I make a page that lists all the documents, and then tell the robots to visit the page to index all my documents..? Is this possible, or is there a better way to do it?

  Read the article

< Previous Page | 842 843 844 845 846 847 848 849 850 851 852 853  | Next Page >