Re: C API mysql_query() malfunctioning (long)

2001-11-09 Thread brainheap
> "M. A. Alves" wrote: > > > I think the problem is in your query expression. you're absolutely right here > I have reformulated your > > original query using my style and that consistently results in 4 rows > > which I think is what you wanted. > > > > Original_Query : String := > >"se

Re: C API mysql_query() malfunctioning (long)

2001-11-09 Thread brainheap
"M. A. Alves" wrote: > I think the problem is in your query expression. I have reformulated your > original query using my style and that consistently results in 4 rows > which I think is what you wanted. > > Original_Query : String := >"select distinct Exhibition.InternalNumber,Exhibiti

Re: C API mysql_query() malfunctioning (long)

2001-11-09 Thread brainheap
"M. A. Alves" wrote: > My testing returns 16 rows in both ways (program using API vs. mysql > monitor). I have copied verbatim the query string from your C code (it > was the "query" constant right?) > > I think this contrasts with your results no? > yes when I typed in the same query in mys

newby question about datetime fields

2001-11-01 Thread brainheap
Hi ppl! I have a table with datetime type column in it. when I make request "select * from my_table order by my_datetime" I get the normal sort i.e. first the oldest dates but I want to get reverse sort to have most recent dates to be the first. How can I do this? Thanks for any help :0) Al

tuning user's variable understanding

2001-06-14 Thread brainheap
hi ppl! I have two consequent queries "select @g1=user from user_space where connects>10" and "select connect_time from connects where user=@g1" To prevent misunderstanding I say that I don't want to use joining as in my case tis very slow operation. My question is: when I proceed these two

re: re: Strange error message for create-select query

2001-05-24 Thread brainheap
Hi Sinisa! Sinisa Milivojevic wrote: > > Then it is very much possible that a table from which you have done > SELECT is corrupted. Check it out. > Yes it was. I used myisamchk -o first and myisamchk -r next - it repaired indexes as well but the result was the same :0( Any other idea? Maybe