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 tr
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: auto_inc
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 the
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 a
February 2001 02:09
> To: Julian Strickland; [EMAIL PROTECTED]
> Subject: Re: Quoting numbers? (was Re:MySQL Tables)
>
> That's very true but these days, some languages/databases allow for
> strings
> to be assigned to numbers and vice versa without the need for conver
You also need a space after the where before the quote to generate 'Where
StartTime' as opposed to 'WhereStartTime'
> -Original Message-
> From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
> Sent: 23 February 2001 11:35
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: An
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:
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: [EMAI
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 Me
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
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 Mes
> 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
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: J
Try using the following:-
Format(Date,"-mm-dd") instead of
???/
> -Original Message-
> From: Apolinaras "Apollo" Sinkevicius [SMTP:[EMAIL PROTECTED]]
> Sent: 15 January 2001 20:43
> To: [EMAIL PROTECTED]
> Subject: Default value for
14 matches
Mail list logo
