Search Results

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

Page 732/1052 | < Previous Page | 728 729 730 731 732 733 734 735 736 737 738 739  | Next Page >

• ADO.NET Data model and JSON

  - by ognjenb

  public ActionResult Example() { var q = from i in proba.name select i; return View(); } How with this data make Json data and put them to table (on some View - no strongly typed)

  Read the article

• sqlite insert into: do the column names have to match?

  - by P a u l

  (This question is specific to SQLite3, but it may be common to all SQL I don't know.) This doesn't seem to work. Is it because the column names don't match? (If they match, it works.) If this is true, how can I select from a different field in the source table? INSERT INTO [ImagePoint] (ImageID, PointID, X, Y) SELECT Image2ID, PointID, X, Y FROM Point

  Read the article

• SELECT Data from multiple tables?

  - by Kyle R

  I have 3 tables, with 3 fields all the same. I basically want to select information from each table For example: userid = 1 I want to select data from all 3 tables, where userid = 1 I am currently using: SELECT r.*, p.*, l.* FROM random r LEFT JOIN pandom p ON r.userid = p.userid LEFT JOIN landom l ON l.userid = r.userid WHERE r.userid = '1' LIMIT 0, 30 But it doesn't seem to work.

  Read the article

• sqlite and visualstudio

  - by dban10

  How do I set an identity column for sqlite in visual studio? I am performing a new query and am trying to create a new table using script.

  Read the article

• Order and group by date in Mysql

  - by Alexd2

  Hi all and thanks in advance. I have a small problem which can not resolve, I have this table, and I want to sort by date and group it (but I only show 1 per idCAT) | id | idcat | name | date | | 1 | 3 | xx | 2011-01-02 | | 2 | 4 | xf | 2011-01-02 | | 3 | 3 | cd | 2011-01-01 | | 4 | 1 | cg | 2011-01-04 | | 5 | 4 | ce | 2011-01-06 | would like to stay that way, try in a way but I can not | 2 | 4 | xf | 2011-01-01 | | 3 | 3 | cd | 2011-01-02 | | 4 | 1 | cg | 2011-01-04 |

  Read the article

• How to iterate through luabind class (in lua or in c++)?

  - by kFk

  How to iterate through luabind class (in lua or in c++)? class 'A' function A:__init() -- Does not work -- self is userdata, not a table for i, v in pairs(self) do end end Thanks

  Read the article

• What is the best .NET type for collections where each key can have multiple values?

  - by srinig29

  Hi friends, I have one key but different values for that key, I tried HashTable but i dont think that is the rite way of doing it. I'll explain in detail what is is requirment is: I have a Key - "Asp.net" for that i have n no of values - 61, 67, 100 So i have to store this somewhere like Dictionary or hash table. TIA

  Read the article

• sql: connecting tables that have no relation

  - by every_answer_gets_a_point

  if i have two tables that have nothing in common i want to do a select as follows: column from table1, column from table 2 how do i do it?

  Read the article

• Any other way to import data files(like .csv) in python sqlite3 module ?[not insert one by one]

  - by cyaos

  in sqlite3's client CLI, there is " .import file TABLE_name " to do it. But, I do not want to install sqlite3 to my server at present. in python sqlite3 module, we can creat and edit a DB. But, I have not found a way to import data-file to a TABLE, except inserting rows one by one. any other way? Thanks.

  Read the article

• access forms: forcing UCASE in a textbox

  - by every_answer_gets_a_point

  i would like to force the textbox to immediately change the text to UCASE as soon as the user moves away from the field. is this possible? the important thing is that this text will be used in a SQL query to update a table.

  Read the article

• Docmd.TransferText to update data

  - by every_answer_gets_a_point

  i am using Docmd.TransferText to import data from a text file into my access table. i would like it to do the following: if the record already exists, then update it if the record does not exist then add it how do i accomplish this? currently i have this line: DoCmd.TransferText acImportDelim, yesyes, "table3", "C:\requisition_data_dump.txt", True

  Read the article

• php fetch user data from mysql

  - by milodinosaur

  hi, currently i have 2 table in mysql structure: messages id | content | user_id | time submessages id | subcontent | msg_id | user_id | time submessages msg_id is FK for messages id. Now i need to query from php $cur_user = $user->current; // current user id. SELECT * FROM messages WHERE id > '{$_GET['id']}' // problem here how do i query submessages that posted by others not include current user? thank you.

  Read the article

• What is wrong with this sql statement?

  - by chandru_cp

  I am trying to fetch records based on two dates from sql server... Select * from table where CreatedDate between @StartDate and @EndDate and i pass 5/12/2010 and 5/12/2010 (ie) fetching records for today... I have 17 records dated 5/12/2010 but none seems to get selected.... EDIT: I use this but when i debug my value it shows 5/12/2010 12:00:00AM DateTime baseDate = DateTime.Today; var today = baseDate; GetBookingReportByDate(today,today);

  Read the article

• How to check group for containing certain elements in SQL?

  - by noxvile

  I have a simple table: id num 1 7 1 5 1 4 2 5 2 4 2 7 3 4 3 7 How to select ids having num 5 as well as 7 and 4 For this example ids: 2, 3

  Read the article

• I want to check if $('#td1').text() === "x"?

  - by M.z

  I want to check if innerHtml have X or O , so i can not add again any thing else , but it's not working . it stop after adding the check code , I'm trying here to do a simple X O game to get more familiar with javascript and jquery . also I'm not sure if can do this with jQuery . <script type="text/javascript" > function ranFun() { return Math.floor((Math.random() * 9) + 1); } var a; function Elment(a) { document.getElementById("td" + a).innerHTML = "O"; } function call() { var x = ranFun(); switch (x) { case 1:case 2 :case 3: case 4 :case 5 : case 6 : case 7 : case 8 : case 9 : Elment(x); break; default: break; } } function tdElm(c) { if ($('#td1').text() === "x" || $('#td1').text() == "o") return false; else { document.getElementById("td" + c).innerHTML = "x"; call(); } } </script> <BODY> <center> <h1 >" X ,O Game "</h1> <table > <tr> <td id="td1" onclick="tdElm(1);" ></td> <td id="td2" onclick="tdElm(2);"></td> <td id="td3" onclick="tdElm(3);"></td> </tr> <tr> <td id="td4" onclick="tdElm(4);"></td> <td id="td5" onclick="tdElm(5);"></td> <td id="td6" onclick="tdElm(6);"></td> </tr> <tr> <td id="td7" onclick="tdElm(7);"></td> <td id="td8" onclick="tdElm(8);"></td> <td id="td9" onclick="tdElm(9);"></td> </tr> </table> </center> </BODY>

  Read the article

• How to create a UITableView only?

  - by suse

  Hi, Can i create a table by using only a UITableView without a UITableViewController? Is it possible, if it so how to do that programatically?

  Read the article

• selectively update prepared statement

  - by user309584

  for an prepared statement update table t set a = ? ,b = ? where i = ? column a to stay column a ie. a=a and only need to setInt for b and visa versa, without needing another statement. Is there a concise way of doing this?

  Read the article

• iPhone to host server to mySQL and back?

  - by ronbowalker

  Can someone please direct me to process for doing this? I have already done the Login verification exercise using mySQL for the dbase on my host server (thanks to kiksy). Now I am trying to move forward and "Query" from the iPhone a list of "users" that currently occupy the table (iphoneusers) in MySQL. And of course get it back to the iPhone via the php connection. Any help would be very much appreciated. ronbowalker

  Read the article

• Is there a better way to select tables based on how many rows they have via jQuery?

  - by bubbahotep

  I'm looking to grab a group of tables that have more than X rows with jQuery. Currently, I'm doing something similar to: $("table").each(function(){ if($(this).find("tr").length > x){ tableArray[tableArray.length] = $(this); } }); and then acting on the members of the tableArray. Is there a better way of getting these tables, perhaps a nice selector I've missed? Thanks

  Read the article

• MySQL Can't Handle Parameters for Stored Procedures

  - by Takkun

  I'm trying to make a stored procedure but it doesn't seem to be recognizing the parameters I've given it. Procedure create procedure test_pro(IN searchTable VARCHAR(55)) begin select * from searchTable limit 10; end // Trying to execute mysql> call test_pro('exampleTable'); ERROR 1146 (42S02): Table 'db.searchTable' doesn't exist It isn't replacing the searchTable with the parameter that is passed in.

  Read the article

• how to search a string in structure variable ( C# )

  - by deep

  public struct Items { public string Id; public string Name; } public Items[] _items = null; if (_items.Contains("Table")) { // i need to check the structure and need to return correponding id } and am having a list of variables in my structure variable... i need to search a Name in the structure(_items) and i want to return the Corresponding Id. how to do this,

  Read the article

• MySQL database populated dropdown box and PHP search

  - by Sanel Bajric

  I have question regarding search on webpage with textbox and dropdown box. I have table with fields: ID First name Last name Company name Occupation Description Now i need to make search form which will be populated from database (field Occupation) and textbox where I can put whatever I want, and then get results from database based on those on web page. I am really sorry but i am totally begginer and only need some examples of such kind of code and much help :) Thank you

  Read the article

• Which is the best way to store a key which matches multiple values in C#?

  - by srinig29

  Hi friends, I have one key but different values for that key, I tried HashTable but i dont think that is the rite way of doing it. I'll explain in detail what is is requirment is: I have a Key - "Asp.net" for that i have n no of values - 61, 67, 100 So i have to store this somewhere like Dictionary or hash table. TIA

  Read the article

• SQL & PHP - Which is faster mysql_num_rows() or 'select count()'?

  - by Joel

  I'm just wondering which method is the most effective if I'm literally just wanting to get the number of rows in a table. $res = mysql_query("SELECT count(*) as `number` FROM `table1`"); $count = mysql_fetch_result($res,0,'number'); or $res = mysql_query("SELECT `ID` FROM `table1`"); $count = mysql_num_rows($res); Anyone done any decent testing on this?

  Read the article

• How can I connect two DB tables using Rails?

  - by jfedick

  I have two DB tables that when one field is updated, a corresponding field needs to be updated in another DB table with that same information. How can I connect those fields (and tables) together using the Rails framework?

  Read the article

< Previous Page | 728 729 730 731 732 733 734 735 736 737 738 739  | Next Page >