Search Results

Search found 30279 results on 1212 pages for 'database drift'.

Page 778/1212 | < Previous Page | 774 775 776 777 778 779 780 781 782 783 784 785  | Next Page >

• Removal of table primary key in MySQL

  - by marionmaiden

  Hello, I've removed the primary key of one table of my MySQL database, but now, when I use the MySQL Administrator and try to edit some data of this table, it doesn't allow me to do this. The button edit that appears in the bottom of the table keeps visible, but disabled to click.

  Read the article

• ASP.NET - programmatically generated delete button

  - by WedTM

  I'm trying to create a simple button that deletes a row from the database. I would like to set the ID of the control to something like delete_MATERIALID_button however, when I do this: <asp:Button ID='delete_<%# Eval("MatID") %>_button' runat="server" Text="Delete" /> I get an error that the name can't be generated like that. I know that there must be a simple solution, I just can't figure it out.

  Read the article

• Change date format (in DB or output) to dd/mm/yyyy - PHP MySQL

  - by Jess

  MySQL stores the date in my database (by default) as 'YYYY-MM-DD' The field type for my date is 'DATE' (I do not need any time storage).. Is there a simple way to change it by default to DD/MM/YYYY ? I call up different dates in 2 different tables, and no where in any of my code do I have anything resembling a date variable or anything! Hopefully this is a straight forward change?

  Read the article

• .NET timezone information

  - by dotnetrocks

  What is the standard format for datetime with timezone in a C# ASP.NET application? Updated to clarify: In ASP.NET I need to check a datetime from a Domino database against a .NET DateTime. The client is asking what would be the best format in which he should provide the datetime with the timezone. Meaning which format is most easily readable by .NET?

  Read the article

• Images get rotated when retrieved from sqliite3 db.

  - by Deepika

  Dear All, I am making an application which saves the camera roll images as blob in sqlite3 database. When the image is retrieved, its dimensions changes(height and width get interchanged). This happens only on iphone and not on simulator. Please help

  Read the article

• PHP MySQL Select multiple tables

  - by Jordan Pagaduan

  Is it posibble to select 3 tables at a time in 1 database? Table 1: employee -- employee_id -- first_name -- last_name -- middle_name -- birthdate -- address -- gender -- image -- salary Table 2: logs -- log_id -- full_name -- employee_id -- date -- time -- status Table 2: logout -- log_id -- full_name -- employee_id -- date -- time -- status I wanted to get the value of employee table where $id of selected. Then the $id also get the value of log.time, log.date, logout.time, and logout.date. I already try using UNION but nothing happens.

  Read the article

• Need help converting SQL to EF4 please

  - by Ken Eldridge

  I need help converting this SQL statement, into EF4: Select Posts.PostID, Post, Comment from Posts left join Comments on posts.PostID = Comments.PostID Where CommentID not in ( Select PostID from Votes where VoteTypeID = 4 --4 = flagged comment type ) In my database, the Votes table stores either the PostID of reported posts, or CommentID of reported comments in the column Votes.PostID Thanks in advance!

  Read the article

• Selecting first records of a type in a given period

  - by Emanuil Rusev

  I have a database table that stores user comments: comments(id, user_id, created_at) I want to get from it the number of users that have commented for the first time in the past week. Here's what I have so far: SELECT COUNT(DISTINCT `user_id`) FROM `comments` WHERE `created_at` BETWEEN DATE_SUB(NOW(), INTERVAL 7 DAY) AND NOW() This would give the number of users that have commented, but it would not take into consideration whether these comments are first for these users.

  Read the article

• Stateless NHibernate for querying

  - by JontyMC

  We have a database that is updated via a background process. We are using NHibernate to query the data for display on the web UI, so we don't need change tracking or lazy-loading. If we mark all the mappings as mutable="false", is this the same as using a stateless session?

  Read the article

• Separation of ASpx pages on one m/c and application logic on another m/c

  - by venugopal

  We are using VB.NET and ASPx for our project. we would like to separate the aspx pages and put them on the IIS server (web server) on one m/c and the business logic and DAL layer on another IIS server (application server) on a different m/c .The database is on another m/c. Is such a configuration possible ? If so how can it be implemented?

  Read the article

• How to optimize an update SQL that runs on a Oracle table with 700M rows

  - by Bruno Rothgiesser

  UPDATE [TABLE] SET [FIELD]=0 WHERE [FIELD] IS NULL [TABLE] is an Oracle database table with more than 700 million rows. I cancelled the SQL execution after it had been running for 6 hours. Is there any SQL hint that could improve performance? Or any other solution to speed that up?

  Read the article

• Sql Select Query Question. Merge Rows

  - by Jono

  I have a single MYSQL Question and need help ASAP. Database: Email | Name | Tag [email protected] |Test Person | TagOne [email protected] |Test Person | Tag Two Need an SQL query that will return Email | Name | Tag [email protected] |Test Person | TagOne, Tag Two Any help?

  Read the article

• Avoiding Zends Error Messages

  - by Kieran

  I am using the Zend Framework for ACL's in codeigniter but if something is not right in the database or there is an error with the code that interfaces with the framework then the framework displays its own error messages. Is there a way to suppress these?

  Read the article

• Magento - How do I create a shopping cart price rule automatically?

  - by Laizer

  I'd like to create a shopping cart price rule that gives a user 10% off their order when and if they complete a process on my Magento site. There's a method here that inserts the rule directly to the database. That's a bit invasive for my tastes. How would I go about this using Magento methods?

  Read the article

• SQL Server: how to create multiple text files from a table

  - by Patrick

  hi, I need to extract data from my SQL Server database into multiple text files. I have a table with 4 columns: UserID, UserName, Tag, Score. I need to create a text file for each Tag (so basically I need to group by Tag and order by score). Before to start I would like to know what's the fastest way to create several text files: File titles = TAG field each line = userID

  Read the article

• What is the best way to use MySQL full-text search with a self-join?

  - by gersh

  I want to do something like: select a.a_ft,count(b.a_ft) FROM row a JOIN row b on match a.a_ft against (b.b_ft). However, this isn't legal. Basically, I just want to look for similar phrases in my database. What is the easiest way to do this?

  Read the article

• How to do authentication using SOAP ?

  - by WarDoGG

  How do i authenicate users with SOAP ? Will i have the user require to send his username/pass with every SOAP request and i authenticate him against the database ? Doesn't that seem to cause unnecessary queries ?

  Read the article

• Why does MS SQL Mgmt Studio Express keep forgetting my passwords?

  - by Ryan

  I have about had it with this tool, I check the save password box at the login dialogue but it just doesn't work. Sometimes it will for a few days, and then the password will just be gone. Nearly every time I load this thing up I have to track down the password again and type it in. Is there some password rule in the database that would be causing this? This is driving me absolutely crazy.

  Read the article

• how to implement single sign on for asp.net,mysql websites

  - by kranthi

  Hi, I am using mysql database for my asp.net website.I need to implement to single sign on for multiple instances of my website.Currently to check if a user has logged in I am using a user control which checks for a "loggedin" cookie with single instance of the website.Now I need to extend the logic to achieve single signon for multiple instances of the same site. Could someone please help. Thanks.

  Read the article

• Improve SQL Server 2005 Query Performance

  - by user366810

  I have a course search engine and when I try to do a search, it takes too long to show search results. You can try to do a search here http://76.12.87.164/cpd/testperformance.cfm At that page you can also see the database tables and indexes, if any. I'm not using Stored Procedures - the queries are inline using Coldfusion. I think I need to create some indexes but I'm not sure what kind (clustered, non-clustered) and on what columns. Thanks

  Read the article

• Easy way to keep counting up infinitely

  - by Andrew Alexander

  What's a good way to keep counting up infinitely? I'm trying to write a condition that will keep going until there's no value in a database, so it's going to iterate from 0, up to theoretically infinity (inside a try block, of course). How would I count upwards infinitely? Or should I use something else? I am looking for something similar to i++ in other languages, where it keeps iterating until failure.

  Read the article

• How to implement callback methods inside classes (PHP)

  - by sombe

  I need to use a class callback method on an array inside another method (the callback function belongs to the class). class Database { public function escape_string_for_db($string){ return mysql_real_escape_string($string); } public function escape_all_array($array){ return array_filter($array,"$this->escape_string_for_db"); } } Is this the right way to go about that? (I mean, in terms of the second parameter passed to array_filter)

  Read the article

• Most concise way to convert from date format: yyyy[3 digit day of year] to SQL datetime

  - by Seth Reno

  I'm working with an existing database where all dates are stored as integers in the following format: yyyy[3 digit day of year]. For example: 2010-01-01 == 2010001 2010-12-31 == 2010356 I'm using the following SQL to convert to a datetime: DATEADD(d, CAST(SUBSTRING( CAST(NEW_BIZ_OBS_DATE AS VARCHAR), 5, LEN(NEW_BIZ_OBS_DATE) - 4 ) AS INT) - 1, CAST('1/1/' + SUBSTRING(CAST(NEW_BIZ_OBS_DATE AS VARCHAR),1,4) AS DATETIME)) Does anyone have a more concise way to do this?

  Read the article

• I'm searching for a messaging platform (like XMPP) that allows tight integration with a web applicat

  - by loxs

  Hi, At the company I work for, we are building a cluster of web applications for collaboration. Things like accounting, billing, CRM etc. We are using a RESTfull technique: For database we use CouchDB Different applications communicate with one another and with the database via http. Besides, we have a single sign on solution, so that when you login in one application, you are automatically logged to the other. For all apps we use Python (Pylons). Now we need to add instant messaging to the stack. We need to support both web and desktop clients. But just being able to chat is not enough. We need to be able to achieve all of the following (and more similar things). When somebody gets assigned to a task, they must receive a message. I guess this is possible with some system daemon. There must be an option to automatically group people in groups by lots of different properties. For example, there must be groups divided both by geographical location, by company division, by job type (all the programers from different cities and different company divisions must form a group), so that one can send mass messages to a group of choice. Rooms should be automatically created and destroyed. For example when several people visit the same invoice, a room for them must be automatically created (and they must auto-join). And when all leave the invoice, the room must be destroyed. Authentication and authorization from our applications. I can implement this using custom solutions like hookbox http://hookbox.org/docs/intro.html but then I'll have lots of problems in supporting desktop clients. I have no former experience with instant messaging. I've been reading about this lately. I've been looking mostly at things like ejabberd. But it has been a hard time and I can't find whether what I want is possible at all. So I'd be happy if people with experience in this field could help me with some advice, articles, tales of what is possible etc.

  Read the article

• Extending Zend_Auth_Adapter_DbTable for Extra Checks

  - by Urda

  My google fu is weak today, but I cannot find a good article to do so. I would like to extend the Zend Adapter to check n extra columns on my database table. What is the best way to fully extend the adapter, so I can use it in the future without needing to dig through documentation again.

  Read the article

< Previous Page | 774 775 776 777 778 779 780 781 782 783 784 785  | Next Page >