Go Back   CodingForums.com > Search Forums
Reload this Page Search Results

Before you post, read our: Rules & Posting Guidelines

Page 1 of 16 1 2311 Last »
Showing results 1 to 25 of 383
Search took 2.02 seconds. Search: Posts Made By: Kiwi
Forum: Computer/PC discussions 02-09-2010, 03:02 PM
Replies: 0
Views: 855
Posted By Kiwi
Work Autoformatting of Lists

Hello. I've been trying to make some changes to the formatting in Word 2007. With the auto-format, if you type 1. blah, it converts this to a list. What I want to do is change the list indents that...
Forum: Computer/PC discussions 05-19-2009, 05:46 PM
Replies: 5
Views: 1,253
Posted By Kiwi
Thanks

Thanks both of you. I did have a trojan - some VXGame variant. I've removed that and it seems to be running a lot better. It must have snuck under the virus scanner's radar somehow (we use AVG Pro)....
Forum: Computer/PC discussions 05-19-2009, 12:50 PM
Replies: 5
Views: 1,253
Posted By Kiwi
Laptop Performance Issues

Hello there,

I've got a laptop that's been progressively getting slower and slower. The machine's oldish, but still reasonably good spec (an HP NC8430 with 2GB of ram). It's got Windows XP and...
Forum: MySQL 06-14-2005, 01:54 AM
Replies: 3
Views: 975
Posted By Kiwi
You need some way of identifying the most recent...

You need some way of identifying the most recent record - a timestamp or an auto-increment field, for example. If you don't have this, then it's difficult.
Forum: MySQL 06-09-2005, 01:09 AM
Replies: 4
Views: 1,041
Posted By Kiwi
Databases aren't generally optomised to handle...

Databases aren't generally optomised to handle image data. They can do it, but generally it seems a little pointless to me. More sensible is to save the file in a directory and include a reference...
Forum: MySQL 06-07-2005, 12:09 AM
Replies: 5
Views: 989
Posted By Kiwi
SELECT COUNT(*) FROM <tablename>

SELECT COUNT(*) FROM <tablename>
Forum: MySQL 05-28-2005, 01:03 PM
Replies: 3
Views: 989
Posted By Kiwi
Alternatively, you could use SQL... SELECT...

Alternatively, you could use SQL...

SELECT DISTINCT
*
FROM
table
Forum: MySQL 05-26-2005, 11:33 AM
Replies: 2
Views: 598
Posted By Kiwi
The default mySQL tables (MyISAM) doesn't support...

The default mySQL tables (MyISAM) doesn't support foreign keys. The mySQL engine parses the syntax, but doesn't actually enforce it. InnoDB tables do support foreign keys. You will need to add a...
Forum: MySQL 05-20-2005, 11:54 PM
Replies: 1
Views: 684
Posted By Kiwi
It would be easier to create a unique index on...

It would be easier to create a unique index on the field/fields you don't want duplicated.
Forum: PHP 05-19-2005, 06:11 AM
Replies: 4
Views: 840
Posted By Kiwi
Simple Photo Album

Hi,

I'm looking for a simple photo-album script.

What I am looking for is a very simple system where I can put an image in a folder and have it automatically appear on a web-page. What I want...
Forum: MySQL 05-18-2005, 12:48 AM
Replies: 2
Views: 667
Posted By Kiwi
SELECT * FROM car WHERE 'make' = '$make' AND...

SELECT * FROM car
WHERE 'make' = '$make'
AND 'model' = '$model'

You will need to write come code to convert your $type variable to two variables: $make and $model.

In my idealised world of...
Forum: MySQL 05-17-2005, 09:30 PM
Replies: 2
Views: 1,092
Posted By Kiwi
It means that you can't have a free text field as...

It means that you can't have a free text field as a part of an index. You need to specify the length of the field. The reason is that an index effectively creates another table containing the...
Forum: MySQL 05-17-2005, 01:57 AM
Replies: 5
Views: 947
Posted By Kiwi
It's that "partially" supported that gets me...

It's that "partially" supported that gets me every time - that and the lack of these features in the default implementation that makes it look a bit toy-like.

The problem is partly mySQL itself,...
Forum: MySQL 05-16-2005, 09:32 PM
Replies: 5
Views: 947
Posted By Kiwi
I mean the lack of views, stored procedures and...

I mean the lack of views, stored procedures and triggers that are all essential to a strong relational implementation. The lack of any sort of referential integrity in the default mySQL table type...
Forum: MySQL 05-16-2005, 08:00 AM
Replies: 5
Views: 947
Posted By Kiwi
In short, no. MySQL is first and foremost a...

In short, no.

MySQL is first and foremost a database engine. What you're looking for is really application level. MySQL's relational implementation is pretty weak. And even in a strong...
Forum: MySQL 05-12-2005, 02:30 AM
Replies: 7
Views: 929
Posted By Kiwi
SELECT DISTINCT A.id FROM AUCTIONS AS A LEFT...

SELECT DISTINCT A.id
FROM AUCTIONS AS A
LEFT JOIN (AUCTION_BIDS AS B ON A.id = B.auction)
HAVING MAX(B.bid) < <value>

This will return a null value for B.bid if there is no corresponding record...
Forum: MySQL 05-06-2005, 05:13 AM
Replies: 3
Views: 782
Posted By Kiwi
When you're running a complex query always...

When you're running a complex query always specify the table... it makes life so much easier when trying to figure out what's going on.

I'm not sure if this work, but...

The restricted...
Forum: MySQL 05-05-2005, 10:29 AM
Replies: 1
Views: 721
Posted By Kiwi
lyrics LIKE "%$term%"

lyrics LIKE "%$term%"
Forum: MySQL 04-28-2005, 11:30 PM
Replies: 1
Views: 574
Posted By Kiwi
update is a reserved work in SQL - you will need...

update is a reserved work in SQL - you will need to put it in 'quotes' to include it as a field in the query. I would suggest renaming the field - using a reserved word as a field name is very bad...
Forum: MySQL 04-28-2005, 06:34 AM
Replies: 8
Views: 1,348
Posted By Kiwi
The temp table will look something like this: ...

The temp table will look something like this:

CREATE TABLE ProductPerson (
ProductID INT(11) NOT NULL,
PersonID INT(11) NOT NULL,
FOREIGN KEY (ProductID) REFERENCES tblProducts(ProductID),
...
Forum: MySQL 04-28-2005, 01:07 AM
Replies: 8
Views: 1,348
Posted By Kiwi
The basic problem I see is that you are joining...

The basic problem I see is that you are joining two logically related tables via a third table (images). Having to go through the images tables to find which people are associated with which...
Forum: MySQL 04-27-2005, 04:30 AM
Replies: 8
Views: 1,348
Posted By Kiwi
DISTINCT restricts the results to a unique...

DISTINCT restricts the results to a unique combination of fields. In this case, you're focusing on the wrong field: two records are produced in the result set because you have two PeopleIDs returned...
Forum: MySQL 04-21-2005, 11:20 PM
Replies: 12
Views: 1,328
Posted By Kiwi
I'm not sure how Access handles aggregates and...

I'm not sure how Access handles aggregates and aliases - I think it might be case sensitive. It might be worth changing the S.* to S.Member_ID. Also double check I haven't dropped any commas and...
Forum: MySQL 04-20-2005, 02:17 PM
Replies: 6
Views: 805
Posted By Kiwi
SELECT a.P_ID, a.P_CATEGORY, a.P_DESC, a.P_PRICE,...

SELECT a.P_ID, a.P_CATEGORY, a.P_DESC, a.P_PRICE, a.P_BUTTON, a.P_PIC
FROM tbl_product AS a
WHERE a.P_CATEGORY = (
SELECT DISTINCT b.P_CATEGORY
FROM tbl_product AS b
WHERE a.P_CATEGORY...
Forum: MySQL 04-20-2005, 02:10 PM
Replies: 12
Views: 1,328
Posted By Kiwi
Actually, I use SQL like this quite regulary -...

Actually, I use SQL like this quite regulary - which is why I knew the answer. Scripting was invented to overcome the weaknesses in SQL, but it's too often used to overcome gaps in knowledge of SQL...
Showing results 1 to 25 of 383
Page 1 of 16 1 2311 Last »

 
Forum Jump

All times are GMT +1. The time now is 02:23 PM.