Search Results

Search found 40870 results on 1635 pages for 'database design'.

Page 533/1635 | < Previous Page | 529 530 531 532 533 534 535 536 537 538 539 540  | Next Page >

• Parsing complicated query parameters

  - by Will

  My Python server receives jobs that contain a list of the items to act against, rather like a search query term; an example input: (Customer:24 OR Customer:24 OR (Group:NW NOT Customer:26)) To complicate matters, customers can join and leave groups at any time, and the job should be updated live when this happens. How is best to parse, apply and store (in my RDBMS) this kind of list of constraints?

  Read the article

• Which DB (SQL) is better supported in Erlang ?

  - by Konstantin

  Hello! What do you recommend me to use with Erlang -- MySQL or Postgres ? Which DB has better (more mature, more stable, faster) driver for Erlang ?

  Read the article

• In mysql or postgres, is there a limit to the size of an IN (1,2,n) statement?

  - by Kyle

  I've got quite a few SQL statements like such: SELECT foo FROM things WHERE user_id IN (1,2,3..n) Is there a known limit to the number of elements that will safely fit in an IN clause like that?

  Read the article

• Hows does Drupal 6 interact with MySQL for connections and transactions?

  - by Mike Munroe

  Hows does Drupal 6 interact with MySQL for connections and transactions? Does connection pooling get used? How are transactions handled? At what level are these things managed by Drupal vs being handed off to be handled by MySQL? I did a good amount of searching on the web and within Stack Overflow, but mainly, I only found articles for tweaking Drupal performance and scaling needs.

  Read the article

• Regarding data storage in ecommerce applications

  - by geeth

  Why is MainFrame better choice to stores data related to customer, orders etc? I work with a online retail store, they use .net technologies for applications and MainFrames for storing product, customer, order etc related data. Is SQL DB server not a good option for these type of applications? How is MainFrames better choice than SQL DB? Please provide your insight.

  Read the article

• In Django, what is a one-to-one relationship?

  - by alex

  I've always been using ForeignKeys.

  Read the article

• How Assigning query return value to local a variable, and how to use that in where condition?

  - by Ayyappan.Anbalagan

  I am using mysql stored procedure; I need to assign query retuned value to local variable. And i have to check the condition using the local variable..... or It my query Select Meterial_Id from hemaepdb.transaction where CustId=1; Instead of Meterial_Id i need to get the Meterial_name from Material table.....

  Read the article

• Using C# to read/write from excel spreadsheet.

  - by Aaron

  Hi there, I need to make a program that writes some data to an excel spreadsheet. Something basic along the lines of First name, last name, phone number, e-mail per row with each category in its own column. I don't even know where to start. If someone could tell me which assemblies to reference and maybe point me to a website or a book that covers writing/reading data from an excel spreadsheet via a c# program that would be great. Many thanks.

  Read the article

• Drupal 6: moving localhost to server | clear cached data

  - by artmania

  Hi friends, I worked on localhost to build my drupal site. then, I moved to server. Steps: Clear cache tables (Site Configuration Performance Clear Cached Data button) on localhost Export db and then import on live server Move files/folders to live server Edit settings.php to reflect live server config everything is working great until I make Clear Cached Data on Server. than my custom theme, custom front page, etc... all mess up :( What can be the problem? I appreciate helps so much!! Thanks! !!SORTED!! I used a subtheme for Zen, named mgf . then I had taken a back-up as mgf- somehow after I make Clear Cached Data, Drupal links to this mgf- which is old and doesnt have latest stylings. I just removed this folder from themes, and it linked to the right-latest mgf.

  Read the article

• Changing javascript confirm dialog box to bootstrap

  - by Scape Goat

  I already this something Here is the original code: <script type='text/javascript'> function delete_user( id ){ var answer = confirm('Are you sure?'); //if user clicked ok if ( answer ){ //redirect to url with action as delete and id to the record to be deleted window.location = 'delete.php?id=' + id; } } </script> How do I remove the old javascript confirm dialog box and replace it with bootstrap?

  Read the article

• Google App Engine: Which is its RDBMS?

  - by Vimvq1987

  According to this: http://code.google.com/appengine/docs/whatisgoogleappengine.html it seems that GAE only uses Datastore to store data, which is equivalent with Table service on Windows Azure Platform. Does anyone know that which RDBMS it uses? or such thing exists or not?

  Read the article

• SQL Server: compare columns in two tables.

  - by maxt3r

  Hi, I've recently done a migration from a really old version of some application to the current version and i faced some problems while migrating databases. I need a query that could help me to compare columns in two tables. I mean not the data in rows, I need to compare the columns itself to figure out, what changes in table structure I've missed.

  Read the article

• User activity vs. System activity on the Index Usage Statistics report

  - by Zachary G Jensen

  I recently decided to crawl over the indexes on one of our most heavily used databases to see which were suboptimal. I generated the built-in Index Usage Statistics report from SSMS, and it's showing me a great deal of information that I'm unsure how to understand. I found an article at Carpe Datum about the report, but it doesn't tell me much more than I could assume from the column titles. In particular, the report differentiates between User activity and system activity, and I'm unsure what qualifies as each type of activity. I assume that any query that uses a given index increases the '# of user X' columns. But what increases the system columns? building statistics? Is there anything that depends on the user or role(s) of a user that's running the query?

  Read the article

• how to display table data more clearly. in oracle sqlplus

  - by Nubkadiya

  here is the way my sqlplus display the table data. but i want to show them as Name | Address | name1 | address1 | name2 | address2 | name3 | address3 |

  Read the article

• Differences between DB2 and Oracle

  - by Ondrej Slinták

  We had a talk with colleagues about databases yesterday as we will have a DB2 education in few weeks. I'm wondering, what are the differences between DB2 and Oracle as two major enterprise solutions? Are there any limitations in comparison to each other? Are there any tasks more suitable for DB2 or Oracle? (I found this article, but I somehow doubt it covers everything)

  Read the article

• Codeigniter: how to track activity w/o using multiple db rows?

  - by Kevin Brown

  I need to track the completion of tasks for users. I started by having a row called "first_login", "profile_complete", "other_thing_complete", etc... I'd like to combine these all into one row "activity_state". I just don't know how to properly store data in this field, and how to retrieve it. What kind of field should it be, and how should I read/write to it?

  Read the article

• Money type field returns Dollar, but regional set to UK (Windows 7)

  - by Gareth

  Hi, On a Windows 7 machine with Advantage Data Architect version 9.10.0.11, money type data is returned as Dollars, instead of Pounds. Sometimes, it will suddenly switch to Pounds, without me changing any settings. Everything else returns Pounds correctly (regional settings is UK with £ as the currency symbol). Has anyone else had this problem and/or found a solution? If I run any reports using the money data type field I can't be sure that it's going to be accurate. And no, I can't change the field type and handle the currency symbol myself. Any help would be appreciated.

  Read the article

• Simple check for SELECT query empty result

  - by den-javamaniac

  Hi. Can anyone point out how to check if a select query returns non empty result set? For example I have next query: SELECT * FROM service s WHERE s.service_id = ?; Should I do something like next: ISNULL(SELECT * FROM service s WHERE s.service_id = ?) to test if result set is not empty?

  Read the article

• Sql server Identity issue

  - by pranay

  I have query like below declare @str_CustomerID int Insert into IMDECONP38.[Customer].dbo.CustomerMaster ( CustomerName , CustomerAddress , CustomerEmail , CustomerPhone ) values ( ‘werw12e’ , ‘jkj12kj’ , ‘3212423sdf’ , ‘1212121' ) select @str_CustomerID= scope_identity() after execution it returns null in my parameter i want to get value of identity how can i do that

  Read the article

• Tracking Votes and only allowing 1 vote per member

  - by MikeAdams

  What I'm trying to do is count the votes when someone votes on a "page". I think I lost myself trying to figure out how to track when a member votes or not. I can't seem to get the code to tell when a member has voted. //Generate code ID $useXID = intval($_GET['id']); $useXrank = $_GET['rank']; //if($useXrank!=null && $useXID!=null) { $rankcheck = mysql_query('SELECT member_id,code_id FROM code_votes WHERE member_id="'.$_MEMBERINFO_ID.'" AND WHERE code_id="'.$useXID.'"'); if(!mysql_fetch_array($rankcheck) && $useXrank=="up"){ $rankset = mysql_query('SELECT * FROM code_votes WHERE member_id="'.$_MEMBERINFO_ID.'"'); $ranksetfetch = mysql_fetch_array($rankset); $rankit = htmlentities($ranksetfetch['ranking']); $rankit+="1"; mysql_query("INSERT INTO code_votes (member_id,code_id) VALUES ('$_MEMBERINFO_ID','$useXID')") or die(mysql_error()); mysql_query("UPDATE code SET ranking = '".$rankit."' WHERE ID = '".$useXID."'"); } elseif(!mysql_fetch_array($rankcheck) && $useXrank=="down"){ $rankset = mysql_query('SELECT * FROM code_votes WHERE member_id="'.$_MEMBERINFO_ID.'"'); $ranksetfetch = mysql_fetch_array($rankset); $rankit = htmlentities($ranksetfetch['ranking']); $rankit-="1"; mysql_query("INSERT INTO code_votes (member_id,code_id) VALUES ('$_MEMBERINFO_ID','$useXID')") or die(mysql_error()); mysql_query("UPDATE code SET ranking = '".$rankit."' WHERE ID = '".$useXID."'"); } // hide vote links since already voted elseif(mysql_fetch_array($rankcheck)){$voted="true";} //}

  Read the article

• How do I add an index to a column that is datetime?

  - by alex

  In mysql. It's a date column

  Read the article

• Solr admin with only JRE possible?

  - by Camran

  I have installed JRE on my Ubuntu server. However, not JDK. When I execute solr to start, everything seems fine. But I cant access the solr/admin page. Wonder if this is possible without the JDK? Or do I have to have JDK installed? Thanks

  Read the article

• How to find definition of predefined code in Oracle 9i?

  - by Vineet

  I am using Oracle 9i and want to know to the definition(code) of predefined functions in Oracle like,REVERSE(),REPLACE(). Is there any library of oracle where i can serach these library functions! Please Suggest!!

  Read the article

• maximum concurrent connections for ubuntu?

  - by ryn6

  i would like to ask how many concurrent connections can ubuntu handle? i heard that xp a maximum of 10 connections.. i will use it as an OS for my small server and will be using mysql on it..

  Read the article

• How to organise team work on mysql databases?

  - by shurik2533

  How to organise team work on mysql databases? Probably, something like svn, but for databases

  Read the article

< Previous Page | 529 530 531 532 533 534 535 536 537 538 539 540  | Next Page >