Search Results

Search found 26283 results on 1052 pages for 'temporary table'.

Page 723/1052 | < Previous Page | 719 720 721 722 723 724 725 726 727 728 729 730  | Next Page >

  • MySQL Joining three tables

    - by text
    I am doing a query with three tables, the problem was one table has many occurrences of id of another. sample data: users: id answers: id:1 user_answer :1 id:1 user_answer :2 id:1 user_answer :3 Questions: id:1 answers :answer description id:2 answers :answer description id:3 answers :answer description How can I get all user information and all answer and its description, I used GROUP by user.id but it only returns only one answer. I want to return something like this list all of users answer: Name Q1 Q2 USERNAME ans1,ans2 ans1,ans2 comma separated description of answer here

    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

  • MySQL - Limit a left join to the first date-time that occurs?

    - by John M
    Simplified table structure (the tables can't be merged at this time): TableA: dts_received (datetime) dts_completed (datetime) task_a (varchar) TableB: dts_started (datetime) task_b (varchar) What I would like to do is determine how long a task took to complete. The join parameter would be something like ON task_a = task_b AND dts_completed < dts_started The issue is that there may be multiple date-times that occur after the dts_completed. How do I create a join that only returns the first tableB-datetime that occurs after the tableA-datetime?

    Read the article

  • Rails 3.0 method_missing: undefined method in validator

    - by user567592
    == Schema Information Schema version: 20110111000403 # Table name: places # id :integer not null, primary key name :string(255) latitude :float longitude :float a place can be defined by latitude and longitude or by name # class Place < ActiveRecord::Base validates_precence_of :name, :if = lat_long_not_def? def lat_long_not_def? latitude.blank? || longitude.blank? end end

    Read the article

  • MATLAB: comparing 2 columns content

    - by Patrick
    hi, I need to compare the content of 2 tables, more exactly 2 columns (1 column per table) in Matlab to see, for each element of the firsts column, there is an equal element in the second column. Should I use a for loop or is there any MATLAB function doing this ? thanks

    Read the article

  • How should i store availability calendar information in mysql? for [id] [date] [available/unavailab

    - by Haroldo
    I'm building a simple calendar for holiday cottages to show when they are booked or available. What would be the fastest mysql table design for this, bearing in mind when users mark dates as available/booked they will do so via a start date and an end date. i can see 2 obvious options Store 'booked' data for every day [more rows] or, store 'booked' data with 2 columns a start_date and end_date [more processing?] Which is best or is there another method i'm missing?

    Read the article

  • Select random line in SQL database

    - by Jensen
    Hi, I would like to select a random line in my database. I saw this solution on a website: SELECT column FROM table ORDER BY RAND() LIMIT 1 This SQL query run but someone said me that it was a non performant query. Is there another solution ? Thx

    Read the article

  • Python templates for huge HTML/XML

    - by newtover
    Hello, Recently I needed to generate a huge HTML page containing a report with several thousand row table. And, obviously, I did not want to build the whole HTML (or the underlying tree) in memory. As result, I built the page with the old good string interpolation, but I do not like the solution. Thus, I wonder whether there are Python templating engines that can yield resulting page content by parts.

    Read the article

  • Records featch for DataTable

    - by Ravi
    Hi, I have added 1000 records into DataTable using C#.Net. This data table contains TimeStamp column for specified data stored time. Data stored into 10.00AM to 11.00AM every 10 seconds once. Here i want to featch only 10.15AM to 10.30AM records using C#. Thanks

    Read the article

  • ModalPopupExtender with thmbnail (problem in javascript)

    - by arny
    this is the code,it is not working in Firefox,Chrome,to show full size image unless user click on image for couple of times, I basically replace the thmbnail image with full size image in javascript, here is my code, TransitionDuration="50" FramesPerSecond="40" RequireOpenedPane="false" SelectedIndex="-1" SuppressHeaderPostbacks="true" HeaderCssClass="accordionHeader" ContentCssClass="accordionContent" OnItemDataBound="Accordion1_ItemDataBound" OnItemCommand="Accordion1_ItemCommand" ' ' Width="90px" Height="70px" onclick="togglePopupImage2(this);" CssClass="thumbnail" BorderColor="Navy" BorderStyle="Solid" BorderWidth="1" <table> <tr> <td style="background-color: #2E4d7B; height: 15px; color: White; font: arial bold 12px; padding: 5px"> <label id="imgText" runat="server"> </label> </td> </tr> <tr> <td> <asp:Image ID="imgPopup" CssClass="imgpopup" runat="server" /> </td> </tr> <tr> <td align="center" style="background-color: #2E4d7B; height: 25px;"> <asp:Button ID="btnCancel" runat="server" Text="Close" CssClass="closeimage"/> </td> </tr> </table> </asp:Panel> And javascript code: function togglePopupImage2(thumbnail2) { var imageurl = thumbnail2.src; var temp = new Array(); temp = imageurl.split('.'); var imagepopup = temp[0].substring(0, temp[0].length - 3) + "." + temp[1]; var img = new Image(); img.src = imagepopup; $get('ctl00_MainContentCPH_UserInterfaceID').style.visibility = 'visible'; $get('ctl00_MainContentCPH_imgPopup').src = img.src; //alert(img.src); if (img.width > 750) { if (screen.width == '1024' || screen.width == '800') { $get('ctl00_MainContentCPH_imgPopup').width = 550; //to show the picture in 1024 or 800 resolutions } else { $get('ctl00_MainContentCPH_imgPopup').width = 750; } } else { $get('ctl00_MainContentCPH_imgPopup').width = img.width; } if (img.height > 568) { if (screen.width == '1024' || screen.width == '800') { $get('ctl00_MainContentCPH_imgPopup').height = 350; //to show the picture in 1024 or 800 resolutions } else { $get('ctl00_MainContentCPH_imgPopup').height = 568; } } else { $get('ctl00_MainContentCPH_imgPopup').height = img.height; } // } } Please find the error and let me know what is the right way to achieve this? Thanks in advance

    Read the article

  • Getting rows which include a value with MySQL

    - by sundowatch
    I have a MySQL query which gets including some vars like that: messages TABLE receiver cols user1 rows : 1,3,5 user2 rows : 2,3 user3 rows : 1,4 I want to get rows which includes '3' value. So I will get 'user1' and 'user2'. I tried that but naturally it doesn't work. mysql_query("SELECT * FROM messages WHERE receiver='3'"); How can I do this?

    Read the article

  • getting rows which including a value with mysql

    - by sundowatch
    I have a mysq query which gets including some vars like that: messages TABLE receiver cols user1 rows : 1,3,5 user2 rows : 2,3 user3 rows : 1,4 I want to get rows which includes '3' value. So I will get 'user1' and 'user2'. I tried that but naturally it doesn't work. mysql_query("SELECT * FROM messages WHERE receiver='3'"); How can I do this?

    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

  • MySQL select column length in php

    - by Patrick
    Hello! How do i get the actual max length of a specified column in php? For instance, this table: id - int(11) name - string(20) I want in php to select the maximum number of characters that a field can have, like SELECT length(name) from table1 and it should then return 20 (since its the maximum number of characters for that field).

    Read the article

  • mysql_fetch_row() not a valid result resource

    - by user1717305
    I am confused, I don't know what's wrong. I'm about to transfer all data from my first table to the other. Here is my code: $getdata = mysql_query("SELECT Quantity, Description, Total FROM ordercart"); while($row = mysql_fetch_row($getdata)) { foreach($row as $cell){ $query1 = mysql_query("INSERT INTO ordermem (Quantity, Description, Total) VALUES ($cell)",$connect); } mysql_free_result($getdata); } I get the error: Warning: mysql_fetch_row(): 5 is not a valid MySQL result resource.

    Read the article

  • Get consolidated results with following tables

    - by Ted
    I have a scenario. Here's my table structure is: ID LoginDate RemovalDate ---------------------------------------- 1 2009/08/01 NULL 2 2009/09/12 2010/01/02 3 2009/08/31 2009/10/29 4 2010/02/17 NULL 5 2009/10/18 2009/11/22 I want a consolidated results of how many ID's were not removed in a particular month. So the result set should be Date NotRemoved_ID -------------------------- 2009/08 2 2009/09 3 2009/10 3 [One ID got removed in 2009/10] 2010/02 2 [Two got removed in 2009/11 and 2010/01] Please help.

    Read the article

< Previous Page | 719 720 721 722 723 724 725 726 727 728 729 730  | Next Page >