Search Results

Have you tried this. First do a select to get the ID or IDs of the one and only Kevin Bacon, then do the main select while excluding the very short list of IDs that are KB. SELECT DISTINCT(name) FR …

Exactly as predicted. There is a primary key on the ID column and it is ONLY on the ID column. This means that there can be only one row in the table with that ID. The result is each ID can only own …

It sounds like you are keeping multiple rows for multiple purchases of the same user and stock symbol combinations in the portfolio table. This requires searching all of those rows and subtracting fr …

Shouldn't ON DUPLICATE KEY UPDATE shares = shares + newshares use VALUES for newshares?

Before I answer, here's a pillow for your forehead so that you don't hurt yourself when you slap it! ;-) It's DELETE FROM, not DELETE * FROM. Just remove the *. And, no, deleting each column indiv …

Yes, you will need to check that the info to be inserted qualifies before inserting. Do that with a select on the appropriate tables combined with some logic in your code before attempting the insert …

Instead, try AGAINST (?)", Also, you must have a FULLTEXT index across all the columns in your query and include no other columns in that index. This index is created in the database, not coded in a …

It looks like you're working from the IDE and not the appliance. I had a similar problem. It seemed like the URL to use that was returned by the server when I started it was wrong. I went back and re …

Or you could create and run an SQL command to "ALTER TABLE tablename DROP PRIMARY KEY;" Or you could just delete the table through the interface or via SQL command and recreate it the way you want it … Hint: You might want to generate the SQL command to create the current table using the interface first. …

Is the table name spelled correctly? Most people spell it with a T in the middle, portfolio, not porfolio. Check the actual spelling of the table name in the database. If this answers your questio …

There may be, but it would be extremely complicated and you simply don't want to. It would require dynamically creating a table with every user. Imagine the nightmare with thousands or millions of us …

;-) db.execute("UPDATE test SET price=:price, total=:total WHERE symbol=:symbol", price=price, total=total, symbol=quote['symbol']) This SQL code says to update the price and total for EVERY row in the …

If you're building a "sandbox" environment, with 10 users, just about any two modern computers with decent memory (not minimal) will work. Just make sure they meet the minimum requirements of the sof …

The issue here was in the syntax of the SQL query. When looking for multiple elements from a subquery, it's necessary to use "IN" in the query. …

Did you test the query directly on the database? My gut says that the "/" in the buy/sell column name is causing problems. Try changing the column name in the table to something without any special ch …