Having found out how to find PHP problems. I am now trying to solve them, but I have no clue on this one. I made use of mysql_error and I have found: 1054: Unknown column 'o.user_id' in 'on clause' Is there something wrong with this: $sql="SELECT o.*, u.user_name, u.email, od.artist_id,cm.nexchange_price FROM ".$tableprefix."...
Let's say I had a table full of records that I wanted to pull random records from. However, I want certain rows in that table to appear more often than others (and which ones vary by user). What's the best way to go about this, using SQL? The only way I can think of is to create a temporary table, fill it with the rows I want to be more...
Is there a way to simplify this working code? This code gets for an object all the different vote types, there are like 20 possible, and counts each type. I prefer not to write raw sql but use the orm. It is a little bit more tricky because I use generic foreign key in the model. def get_object_votes(self, obj): """ Get a dicti...
I've been wanting to build my own gaming community site (like http://fragbite.com) for a long time. I have started many times but just quit after a couple days because it gets very messy. I've been playing around with PHP and MySQL off and on for 3 years, but I've never gotten in to OOP. I have tried, but I usually end up with the "old ...
For a program with an OO front-end and a SQL back-end, can one have each parent class map to its own table and each child class map to it's own table, then use joins in queries to allow returning all the child class's attributes? If so, is it advisable? ...
I'll be the first one to admit my SQL skills are lacking. Now... Let's say we've got a database table called Posts with three columns: Id, RootId, and DateTime. What I'd like to do is get the last (by DateTime) 20 distinct RootId values. Here's the caveat though: RootId may be NULL, in which case we should consider that record as dis...
If I have this SQL query: "select distinct top 1 'PostId' = isnull(RootPost,Id), PostedDateTimeUtc from Post order by PostedDateTimeUtc desc" And I need to enumerate the results with a DataContext. That is to say, how do I send this SQL to a DataContext and parse the result? How do I do that? What would a method that returns the resul...
Greetings, Just a bit of backgroung information - I am currently working on a relatively large desktop-based requirements management utility, and have come across an issue for which I believe I know the solution, but am hesitant to implement without further thought. Basically, at anytime during the usage of this requirements management...
I'm using MS Query Analyzer (as part of SQL Server 2000) to write T-SQL scripts to pull data out of a DB. This involves querying some tables, iterating through the results (using a cursor), some basic processing of the results and putting the processed data into another table. This is working pretty well as I can view the tables and stor...
I am importing raw data in groovy, hundreds of thousands of entries. I use the table fields as the keys of a hash map and then use the add(hash) method on a groove sql Dataset. The Dataset goes to a postgres table and the ID field is autogenerated from a sequence. I need to get the ID of each record as it is inserted. In java + hiberna...
There are a ton of sql join q's already but I didn't see my answer so here goes . . . I am working with WPDB (Wordpress database)/EZSql/MySQL 5.0. Trying to achieve the 'simple' desired output below has not proven to be easy. Current output MemberID MemberName FruitName -------------- --------------------- --...
Is there a way using SQL to list all foreign keys for a given table? I know the table name / schema and I can plug that in. ...
I write the following query: select id, (select NameEn from [Campaign] where id=CampaignId) as CampaignName, createdDate, (select Name, IdNo, Email, MobileNo from [Members] where id=MemberId) from Transactions and error occurs: "Only one expression can be specified in the select list when the subquery is not in...
Take for example an application which has users, each of which can be in exactly one group. If we want to SELECT the list of groups which have no members, what would be the correct SQL? I keep feeling like I'm just about to grasp the query, and then it disappears again. Bonus points - given the alternative senario, where it's a many t...
How to rearrange column order in sql server ? right now my column is showing like below when i physically right click and take properties: in sql server 2005 colA1 colA2 colA3 colA4 colB1 colB2 colB3 colA5 colA6 Since i know these columns (colA5,colA6) are created new ! How to make it like this ? colA1 colA2 colA3 colA4 colA5 colA...
Hi, I'm a novice to SQL scripting. I am trying to figure out a design problem, involving some arithmetic computation. I have two tables temp1 and temp2 with two columns account no., ( Common in both tables ) balance ( float data type ). I want to compare the balance columns in temp1 and temp2. print out the no. of accounts and percen...
if i m using query as SELECT * FROM TABLE_NAME WHERE COLUMN1 = "ABC"; or SELECT COLUMN1 FROM TABLE_NAME WHERE COLUMN1 = "ABC"; and COLUMN1 field of table does not contain data ABC what it will return? ...
I am trying to insert data from one table to another with same structure, select * into tbltable1 from tbltable1_Link i am getting the following error message : There is already an object named 'tbltable1' in the database. ...
I have a table that could have thousands (millions maybe?) of records. It is basically an audit trail table that stores special log entries. It's called "Logs". There is also a related table called "LogsExtended" which stores zero or many additional records for each entry in the Logs table. There is a foreign key relationship setup, co...
In SQL server, I am trying to insert values from one table to another by using the below query : delete from tblTable1 insert into tblTable1 select * from tblTable1_Link I am getting the following error : Column name or number of supplied values does not match table definition. I am sure that both table having same structure,colum...