Search Results

Search found 25022 results on 1001 pages for 'lua table'.

Page 630/1001 | < Previous Page | 626 627 628 629 630 631 632 633 634 635 636 637  | Next Page >

• Exporting Stata results

  - by Max M.

  I'm sure this is an issue anyone who uses Stata for publications or reports has run into: how do you conveniently export your output to something that can be parsed by a scripting language or Excel? There are a few ADO files that to this for specific commands (try findit tabout or findit outreg2). But what about exporting the output of the table command? Or the results of an anova? I'd love to hear about how Stata users address this problem for either specific commands or in general.

  Read the article

• Number query in sql

  - by Nisha

  I have table in sql as User Account 1 25 1 31 1 35 1 44 1 50 1 59 and output need in as three columns 1 25 31 1 35 44 1 50 59

  Read the article

• Need help with joins in sqlalchemy

  - by Steve

  I'm new to Python, as well as SQL Alchemy, but not the underlying development and database concepts. I know what I want to do and how I'd do it manually, but I'm trying to learn how an ORM works. I have two tables, Images and Keywords. The Images table contains an id column that is its primary key, as well as some other metadata. The Keywords table contains only an id column (foreign key to Images) and a keyword column. I'm trying to properly declare this relationship using the declarative syntax, which I think I've done correctly. Base = declarative_base() class Keyword(Base): __tablename__ = 'Keywords' __table_args__ = {'mysql_engine' : 'InnoDB'} id = Column(Integer, ForeignKey('Images.id', ondelete='CASCADE'), primary_key=True) keyword = Column(String(32), primary_key=True) class Image(Base): __tablename__ = 'Images' __table_args__ = {'mysql_engine' : 'InnoDB'} id = Column(Integer, primary_key=True, autoincrement=True) name = Column(String(256), nullable=False) keywords = relationship(Keyword, backref='image') This represents a many-to-many relationship. One image can have many keywords, and one keyword can relate back to many images. I want to do a keyword search of my images. I've tried the following with no luck. Conceptually this would've been nice, but I understand why it doesn't work. image = session.query(Image).filter(Image.keywords.contains('boy')) I keep getting errors about no foreign key relationship, which seems clearly defined to me. I saw something about making sure I get the right 'join', and I'm using 'from sqlalchemy.orm import join', but still no luck. image = session.query(Image).select_from(join(Image, Keyword)).\ filter(Keyword.keyword == 'boy') I added the specific join clause to the query to help it along, though as I understand it, I shouldn't have to do this. image = session.query(Image).select_from(join(Image, Keyword, Image.id==Keyword.id)).filter(Keyword.keyword == 'boy') So finally I switched tactics and tried querying the keywords and then using the backreference. However, when I try to use the '.images' iterating over the result, I get an error that the 'image' property doesn't exist, even though I did declare it as a backref. result = session.query(Keyword).filter(Keyword.keyword == 'boy').all() I want to be able to query a unique set of image matches on a set of keywords. I just can't guess my way to the syntax, and I've spent days reading the SQL Alchemy documentation trying to piece this out myself. I would very much appreciate anyone who can point out what I'm missing.

  Read the article

• How to implement a link that can get bonus for 5 times by different people on a Social Network?

  - by Jian Lin

  How can we generate a link that can be clicked on by 5 different people on a Social Network game, so that each of the five people can get a bonus? The link will be published as a "newsfeed" on the Social Network such as Facebook. The link shouldn't be easily "generated" by any people as a cheating method. Also, what database table(s) should be added to handle: 1) the bonus can be claimed up to 5 times 2) must be claimed by different people ?

  Read the article

• VSTS 2008 Database Edition doesn't seem to know 'DATEADD' constants, any ideas?

  - by Marcel Marchon

  I'm trying to implement a database build using VSTS 2008 Database Edition. The build always fails on the following constraint: ALTER TABLE [dbo].[tablename] ADD CONSTRAINT [DF_tablename_date] DEFAULT (CONVERT([varchar],dateadd(hour,(-1),getdate()),(1))) FOR [date]; The error that it shows is the following: TSD03082: The name "hour" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted. Anybody have an idea what is wrong here?

  Read the article

• MySQL: Getting "busiest" or "most popular" hour from a datetime field?

  - by k00k

  Consider the following table which has the fields - id (int) and date_created (datetime): id date_created 1 2010-02-25 12:25:32 2 2010-02-26 13:40:37 3 2010-03-01 12:02:22 4 2010-03-01 12:10:23 5 2010-03-02 10:10:09 6 2010-03-03 12:45:03 I want to know the busiest/most popular hour of the day for this set of data. In this example, the result I'm looking for would be 12. Ideas?

  Read the article

• Convert a value based on range

  - by Chris

  I need to convert a number to another value based on a range: ie: 7 = "A" 106 = "I" I have a range like this: from to return-val 1 17 A 17 35 B 35 38 C 38 56 D 56 72 E 72 88 F 88 98 G 98 104 H 104 115 I 115 120 J 120 123 K 123 129 L 129 infinity M The values are fixed and do not change. I was thinking a lookup table would be required, but is there a way it could be done with a function on an analytics function inside of oracle?

  Read the article

• What kind of events should be created for a CRUD application?

  - by Mohit Deshpande

  I have an application that is centered around a database (ORM is LINQ-SQL) that has a table called Assignment. I am using the repository pattern to manipulate the database. My application is basically going to perform CRUD operations. I am new to delegates and events and I am asking you what events I should create (like maybe AssignmentCreating, AssignmentCreated) and what kind of delegate to use (like maybe a custom delegate or just an EventHandler)?

  Read the article

• h2 in-memory tables, remote connection

  - by Carolyn

  I am having problems with creating an in memory table, using H2 database, and accessing it outside of the JVM it is created and running in. The documentation structures the url as "jdbc:h2:tcp:///mem:' I've tried many combinations, but simply cannot get the remote connection to work. Is this feature working, can anyone give me the details of how they used this.

  Read the article

• How to show the user one day behind messages in Vb.net webform?

  - by ahmed

  I am working on a Incoming and outgoing messages webform, I would like to show the users the only messages in their INBOX of one day behind. I have a dropdown where I'm giving the selection of All and Pending messages. But if the users have any pending messages in INBOX of just one day behind ,they have to choose All to retrieve the messages. So how do I retrieve messages from message table of just one day behind ? I am using SQL 2000 vb.net web application.

  Read the article

• RoR Beginner Routing error

  - by WANNABE

  I've created a DB and a table within that DB called genre. Now when I try to connect to this using the URL, I get the following error message: Routing Error No route matches "/genre" with {:method=:get} Thanks for your help in advance.

  Read the article

• What does <h:messages> do in JSF ?

  - by 29b5k

  Hi all, I am learning JSF and came across this line: <h:messages layout="table"></h:messages> in a sample application ? Am not sure what does this line do? I get no error when removing the line from the code, and am able to run it and get the same output ?

  Read the article

• SQL Server 2008 - Difference between time(0)

  - by lugeno

  I've a table with working_hours time(0), lunch_hours time(0) What I have to do is the following: If lunch_hours is greater that one hour, I have to calculate the offset Example: lounch_hour = 01:30:00 = offset = 00:30:00 Once done I've to subtract the offset from the working_hours value Example: offset = 00:30:00, working_hours = 07:30:00 = working_hours = 07:00:00 The result must be in time(0) format (hh:mm:ss) I've tried several solutions but still not working. Used DATEDIFF probably didn't used in correct way. Thanks for any help Bye!

  Read the article

• Entity Framework Polymorphism

  - by Chubbs

  Hey guys, I wanted some help with trying to implement a simple polymorphic relationship using Entity Framework. An example of a relationship I would like to implement: Comment table ItemType ('Video', 'User') ItemID Body Video has many Comments User has many Comments No idea the best way to do this, I come from a Ruby on Rails way of thinking.

  Read the article

• How to use this json string with jquery autocomplete?

  - by Pandiya Chendur

  I have two textboxes in my page, <asp:TextBox ID="TxtClientName" runat="server"></asp:TextBox> <asp:TextBox ID="TxtClientMob" runat="server"></asp:TextBox> and i have a json string, {"Table" : [{"ClientName" : "Pandiya","ClientMobNo" : "9566643707"}, {"ClientName" : "Bala","ClientMobNo" : "9994403569"}]} Is it possible to use this json string to autocomplete in two textboxes seperating keys ClientName and ClientMobNo in jquery..... Any suggestion....

  Read the article

• I want Oracle Query for Formatted Output

  - by reply2viveksshah

  The following is my table design: Ecode Degree YOQ 7654321 SSC 2000 7654321 HSC 2002 7654321 Bcom 2006 7654321 MCA 2010 7654322 SSC 2002 7654322 HSC 2004 7654322 Bcom 2007 7654323 SSC 2002 7654323 HSC 2004 7654323 BE 2008 I want the following formatted output using an oracle query: Ecode Degree year 7654321 SSC,HSC,Bcom,MCA 2000,2002,2006,2010 7654322 SSC,HSC,Bcom 2002,2004,2007 7654323 SSC,HSC,BE 2002,2004,2008 How can this be done?

  Read the article

• SQLCE qand C#; Populate a DataSet with ALL the Tables from a SQLCE DB

  - by Zion

  How would I Populate a DataSet with ALL the Tables from a SQLCE DB. Is this possible in ONE SQL select statement? I know that I can call seperate select statements with the names of the table I need data from but I need a generic solution that just dumps all the tables from the SQLCE DB into a Dataset. Thanks

  Read the article

• Building a datagrid to show different tables depending on Request.QueryString

  - by Justen

  So, I have a control with a datagrid in it and I was wondering if depending on the value I get back from the a Request.QueryString if I could set the table name to that (that is the value being sent) and then have it build the columns? I have about 3 different tables, and they have different amounts of columns, and of course with different names.

  Read the article

• Printing contents of a div

  - by Hulk

  The contents of the following div re derived dynamically. i.e, A table is added dynamically to this div with some button .My question is how to print the content of this div(window.print) and not other things in the page <div id="newdiv" name="newdiv"></div> Thanks..............

  Read the article

• what is the best way to store time interval in a SQL server database

  - by oo

  i have a table where i want to track time so a valid entry might be: 1 hour 3 mins 47 mins 10 hours 3 mins 14 seconds what field type is best used for this. i obviously could use varchar . .but i thought there might be something better as i would like to run queries to total the amount of time over a number of records.

  Read the article

• Rating System Database Structure

  - by Harsha M V

  I have two entity groups. Restaurants and Users. Restaurants can be rated (1-5) by users. And rating fromeach user should be retrievable. Resturant(id, name, ..... , total_number_of_votes, total_voting_points ) User (id, name ...... ) Rating (id, restaurant_id, user_id, rating_value) Do i need to store the avg value so that it need not be calculated every time ? which table is the best place to store avg_rating, total_no_of_votes, total_voting_points ?

  Read the article

• How to extract content from other websites automatically?

  - by Vijay

  I want to extract a specific data from the website from its pages... I dont want to get all the contents of a specific page but i need only some portion (may be data only inside a table or content_div) and i want to do it repeatedly along all the pages of the website.. How can i do that?

  Read the article

• C# tableadapter add/update/delete

  - by ChrisMuench

  I'm using the table adapter in C# where visual studio generates the code for you. I have inserts and updates working just fine using the following code. However when trying to delete using the .update it gives me the following error. Update requires a valid DeleteCommand when passed DataRow collection with deleted rows. this.workersTableAdapter.Update(this.nursery_dbDataSet_workers.workers);

  Read the article

• Hibernate orm for a view

  - by EugeneP

  How do you ORM a view? Is there any difference with a table in terms of reverse engineering? In my case, I have a whole pile of joined tables that will be read-only in an application. So, if I need sort of a 1 Object with all collections in proper order, instead of long chains of relationships - collection with another etc, it'll be simpler. What do you think and how do you accomplish this?

  Read the article

• How to set up my belongs_to and has_many reference

  - by dagda1

  Hi, I have an ExpenseType object that I have created with the following migration: class CreateExpenseTypes < ActiveRecord::Migration def self.up create_table :expense_types do |t| t.column :name, :string, :null => false t.timestamps end end I can see the table name is the pluralised expense_types. My question is, how do I reference this type in a belongs_to relationship? Is it: belongs_to :expensetype or is it belongs_to :expense_type I do not seem able to set it up correctly. Cheers

  Read the article

< Previous Page | 626 627 628 629 630 631 632 633 634 635 636 637  | Next Page >