Hyvä päivä!
Olen erittäin kiitollinen, jos löytyy ratkaisu tähän ongelman.
Toista viikkoa, ilman tulosta olen yrittänyt ratkaista ongelman.
Koneessa on WinXP(SP2), IIS, MySql(4.1)
Tehty web sivu, jossa käyttäjä syöttää tietoa. Kaikki näytä toimivaan
hyvin,
kunnes syötetään TextBoxi:n, yli 6 merkki
On Monday, March 07, 2005 23:03, GH wrote:
> Greetings, I would like to know if it is possible to do a mail merge
> in Microsoft Office with a mySql database as the source?
>
> Thanks
You can use install MyODBC, set up a DSN, and then use this in Office.
http://dev.mysql.com/downloads/connecto
Greetings, I would like to know if it is possible to do a mail merge
in Microsoft Office with a mySql database as the source?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Monday, March 07, 2005 22:19, digvijoy chatterjee wrote:
> I have Mysql 4.1.9 on RHES-3.0 installed by rpms..the default socket
> path and database creation directory is /var/lib/mysqlnow there
> is a a dearth of space in /var therefore i would like to move the
> database files to somethin
I have Mysql 4.1.9 on RHES-3.0 installed by rpms..the default socket
path and database creation directory is /var/lib/mysqlnow there is a
a dearth of space in /var therefore i would like to move the database
files to something like /usr which has lots of free space , creating
Symlinks does not
Hi All,
I need to answer the floowing quetions even I'm a newbie of C programming.
Anyone helps me out?
Q: Using mysql client, after issuing sql statements, we can see how
long it takes to get results, like;
1 row in set (0.01 sec)
Does the time, 0.01 sec in this case, mean what kind of time?
I
=
>How-To-Repeat:
mysql < -
===
-- MySQL dump 10.9
--
-- Host: localhostDatabase: devmail
-- --
-- Server version 4.1.11-nightly-20050307-debug-log
/*!40101 SET @O
Eric Bergen said:
> Apache 1.3 with php (not sure about tomcat) is a pre forked daemon. Any
> connection pooling numbers will be per child. Try setting your
> connection numbers per child (for most php apps this is 1) and let us
> know what happens. I'm guessing it will create as many connections a
Hi,
Sometimes our Internet conection goes down and then all conections via
tcp/ip to our the mysql server (v.4.1.5) are slow.
I've read in the manual that one could use --skip-name-resolve as a
possible solution to this problem under windows.
The thing is that I've set this option int /etc/my.cnf
Apache 1.3 with php (not sure about tomcat) is a pre forked daemon.
Any connection pooling numbers will be per child. Try setting your
connection numbers per child (for most php apps this is 1) and let us
know what happens. I'm guessing it will create as many connections as
there are apache childre
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005 04:59:27 PM:
> Thanks Sean,
>
> I am using standalone Apache/Tomcat 4.1.31
>
> mysql> \s
> --
> mysql Ver 12.21 Distrib 4.0.15, for Win95/Win98 (i32)
>
> Connection id: 184
> SSL:Not in use
> Serve
"Scott Purcell" <[EMAIL PROTECTED]> wrote on 03/07/2005 04:29:18 PM:
> Hello,
>
> I am working with a traditional database pooling class basically
> putting connection objects into a Vector. When I run the code from
> a main, it appears solid. I have run 10s of thousands of back to
> back que
Hi !
I'm having a problem.
In my 2nd database acces, na error as occured: "Cannot run server: System
could not find specific path (3)."
In first Access i did not have problem; i have accessed data base via
phpMyAdmin.
Now, i can't do that !
Why ?
Someone can help me !!!
Thanks.
Cum
MySQL keeps throwing error 1114 on temp files (those
that MySQL creates behind the scenes when executing a
query and start with #), which is pretty dumb because
there's no way for the user to set the maximum row
size on temp table files. It seems that MySQL is
wrongly setting the temp size and then
Hello,
I am working with a traditional database pooling class basically putting
connection objects into a Vector. When I run the code from a main, it appears
solid. I have run 10s of thousands of back to back queries and all is good.
Problem is when I connect it to a web-app, and reboot the
Since those two queries don't seem to have any relation other than
being from the same table it seems more logical to keep them two
separate queries.
On Mon, 7 Mar 2005 15:30:16 -0500, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> "Dave Kennedy" <[EMAIL PROTECTED]> wrote on 03/06/2005 05:09:36 P
Check the size of your partition that contains /tmp directory.
Just in case symlink it to a bigger partition. Your temporary table may
be bigger than the available space in /tmp
Luck,
Mihail
Homam S.A. wrote:
Whenever I try to update an ISAM table (through a join
with nother small lookup table, a
"Dave Kennedy" <[EMAIL PROTECTED]> wrote on 03/06/2005 05:09:36 PM:
>
> SELECT sum(col1) AS total1
> FROM t1
> GROUP by col1
>
> SELECT col1, sum(col2) AS total2
> FROM t2
> GROUP by col2
>
> Table t1 contains 4 rows to sum for each value in col1
>
> Table t2 contains 8 rows to sum for each v
Hi Michael,
Thanks for getting back.
I did not change ownerships when I moved files.
I made a separate data directory mysqldata inside basedir as you suggested.
As of now both these are owned by mysql because I wasn't sure which files
exactly belong to datadir and which don't. I have moved followi
Whenever I try to update an ISAM table (through a join
with nother small lookup table, also ISAM), I get the
following error:
Error Code : 1114
The table '#sql_910_0' is full
I read the following in the documentation:
http://dev.mysql.com/doc/mysql/en/full-table.html
But none of the reasons lis
How's this
+--+---+
| Variable_name| Value |
+--+---+
| character_set_client | latin1|
| character_set_connection
I have 3 different MySQL server setups. On two of the servers, one
running 4.0 and one running 4.1, I have seen a peculiar problem. It
seems that when a client server is taken offline for a period of time
(few hours to couple of days) and is brought back online, MySQL has a
problem resolving th
I agree with Greg, your data structure may be getting in your way. It's
more "normalized" to make a list of values into rows of values, not into
lots of columns.
I may have had a similar design problem as you are facing. I have to deal
with LOADS of laboratory analysis data (lots of data point
Ok, thanks.
-
Christian Caron
> -Original Message-
> From: Greg Fortune [mailto:[EMAIL PROTECTED]
> Sent: 7 mars, 2005 13:58
> To: mysql@lists.mysql.com
> Cc: Caron, Christian
> Subject: Re: what is select_limit (and what is it used for)?
>
>
> It only affects the client and only when t
It only affects the client and only when the --safe-updates, --i-am-a-dummy,
-U flag is used. I assume it just places an explicit limit clause of LIMIT
1000 on the end of any select statement run from the client. It's meant to
keep less experienced users from running a couple of cross product
Hi,
the default "select_limit" is set to 1000. What does this mean and how can
it affect a server?
Is there some information out there about this variable? I can't find
anything except a one line description on the MySQL site...
-
Christian Caron
--
MySQL General Mailing List
For list archives
Any chance of condensing some of the flag fields into bit fields?
Alternatively, can you represent the variables as (rule id, variable name,
variable value) in a single table rather than using lots of columns/tables?
Greg Fortune
On Monday 07 March 2005 10:31 am, Kevin Cowley wrote:
> Unfortun
Hello.
> Pointers were I went wrong would be appreciated
What's the default character set for your server? Please, send
us an output of the following statement:
show variables like '%char%';
Please, use mysql command line client.
"John Berman" <[EMAIL PROTECTED]> wrote:
> Usi
Unfortunately both limits are getting in our way.
We have approximately 32,000 variables scattered across a number of
tables that we need to convert to bitmaps. The problem is that about
1500 of these variables need to go in a single bitmap hence the problems
with the 1024/64 column/table limit.
The join table limit in MySQL is dictated by the arch that's running
on. 32 tables for 32bit and 64 tables for 64bit (Somebody correct me
if I'm wrong). I believe this is due to using a bitmap inside the join
optimizer to keep track of tables. 64 tables is a very hefty query it
makes me think that
At 05:18 PM 3/6/2005, Harrison Fisk wrote:
Hi,
On Mar 6, 2005, at 12:51 PM, mos wrote:
At 10:07 PM 3/2/2005, you wrote:
Hello.
You may use ALTER TABLE .. DISABLE KEYS to speed up the loading process
on the MyISAM table.
I gave that a try but I had to cancel "Alter Table ... Enable Keys" after
49 h
news <[EMAIL PROTECTED]> wrote on 03/05/2005 04:21:26 PM:
> Probably a real n00b question.
>
> I am writing a simple contact management database with MySQL (version
> 3.23.49-8.9, Debian Woody). I'd like users to be able to enter the
first
> few characters of a contact's name to do a search,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Scott Purcell wrote:
> Hello
> I am using org.gjt.mm.mysql.Driver to connect a web-app to a mysql database.
> I ran into an error, I could use some help with.
>
> I have a database that has a timestamp field
> CREATE TABLE FOO (
>create_date
> I'd like users to be able to enter the first
> few characters of a contact's name to do a search, and I'd
> like the option of doing inexact matches or phonetic matches.
MySQL does have the SOUNDEX function; see the docs for details...
SELECT * FROM people WHERE SOUNDEX(lastname) = SOUNDEX(
Hello
I am using org.gjt.mm.mysql.Driver to connect a web-app to a mysql database. I
ran into an error, I could use some help with.
I have a database that has a timestamp field
CREATE TABLE FOO (
create_date TIMESTAMP,
approved_date TIMESTAMP,
) TYPE=InnoDB;
Now when I insert int
Thanks! I'll try and import using ODBC. Is there any good web sites
about ODBC and its operations that I can learn about it?
Scott
On Mon, 07 Mar 2005 09:26:56 +1100, Daniel Kasak
<[EMAIL PROTECTED]> wrote:
> Scott Hamm wrote:
>
> >How do I create a table using:
> >
> >date_format('2004-10-03
Does anyone know if there is a method of circumventing or changing the
default join limits of 64 tables or 1024 columns? We're running Mysql
4.1.4 using MyISAM tables
Kevin Cowley
Product Development
Alchemetrics Ltd
SMARTER DATA , FASTER
Tel: 0118 902 9000 (swithcboard)
Tel: 0118 902 9099 (direc
Hello.
Are you doing FLUSH PRIVILEGES after granting?
Metal Host Contact <[EMAIL PROTECTED]> wrote:
> I have installed in a single user called "metal-host"
> more than 10 databases all with different names
> and in different php scripts (phpbb phpnuke mambo etc).
> the problem is th
Carlos Bergueira wrote:
Hi,
I need to know some things:
- Where can i get (url of document) the MySql database fields ? (For example, i
need to list all tables of a database (database: mydb) and for each table
properties like comments, size, record number, etc ?). I use PHP to write
output.
- I nee
Hi, Carlos
> - Where can i get (url of document) the MySql database fields ? (For
example, i
> need to list all tables of a database (database: mydb) and for each table
> properties like comments, size, record number, etc ?).
You should use "SHOW TABLE STATUS" it will provide you with any info tha
Hi,
I need to know some things:
- Where can i get (url of document) the MySql database fields ? (For example, i
need to list all tables of a database (database: mydb) and for each table
properties like comments, size, record number, etc ?). I use PHP to write
output.
- I need to do the same wit
41 matches
Mail list logo
