You have an odd number of brackets in each case, you are missing a " ) "
-Original Message-
From: Kinney Baughman [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 11:18 PM
To: [EMAIL PROTECTED]
Subject: What's the syntax for using ENCODE()?
Hi,
I'm trying to
The behavior differs between ISAM tables and MyISAM ones. Its all in the
manual.
-Original Message-
From: Bard dZen [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, February 28, 2001 1:23 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re:
You need to re structure it using a table called say Questions with the
following sorts of fields
QID Id number
QTitle Title eg Question1
Q The question text
A The answer text
R The rank or score of the question
That way you add questions simply by adding records to the table.
you might find
It would seem that you are getting the character corresponding to the ASCII
code 53 as the result of the first query. Try inserting the value for logo
in your table without the quotes round the 53 and see if the results of the
queries become consistent. IMHO this is a bug because the two queries
It's all to do with data types, traditionally and across most languages
quotes are used to delimit STRINGS
and a string is NOT a number although may represent one when displayed.
-Original Message-
From: Pete Harlan [SMTP:[EMAIL PROTECTED]]
Sent: 21 February 2001 20:51
To: [EMAIL
The distributions come with a text version of the manual so you can download
one and print it yourself
but beware it is rather large.
-Original Message-
From: Thalis A. Kalfigopoulos [SMTP:[EMAIL PROTECTED]]
Sent: 21 February 2001 21:05
To: [EMAIL PROTECTED]
Subject: Re:
You could try the Sendkeys command in VB to pre answer the message box
SendKeys {ENTER}, False ' Answer for box before it appears
'if the Wait parameter was true the Answer would go into the sheet cell
'but with it false the Dialog box appears before the Answer is sent
-Original
Try rebuilding the indexes.
-Original Message-
From: Alaiddin Tayeh [SMTP:[EMAIL PROTECTED]]
Sent: 15 February 2001 10:34
To: [EMAIL PROTECTED]
Subject: Select Problem
Linux , Apache, MySQL
I have a problem in my MySQL database, this is the senario:
I made an update
Try this
SELECT * FROM maintable AS M, wordindex AS YL
WHERE
YL.Word IN ('billy' , 'bob' , 'john' )
AND
YL3.RecordNumber = M.RecordNumber
AND
M.Price = 1000
LIMIT 0,50;
Your query is probably slow because you are cubing the size of the wordindex
by invoking it three times
-Original
This works for me in access
SELECT families.objid, families.name, families.parentid, families_1.objid,
families_1.name, families_1.parentid
FROM families LEFT JOIN families AS families_1 ON families.objid =
families_1.parentid
WHERE ((families.parentid)=0);
-Original Message-
From:
Heres the minimal version just to list children
SELECT families_1.name
FROM families INNER JOIN families AS families_1 ON families.objid =
families_1.parentid
WHERE (((families.objid)=1) AND ((families.parentid)=0));
I dont actually use mySQL but am considering it as an option but
11 matches
Mail list logo