Re: BUG in UNION implementation?! Confimation or Explaination please

2007-07-11 Thread Joshua J. Kugler
On Wednesday 11 July 2007 00:34, Anders Karlsson wrote: > UNION will only return distinct rows. This is according to spec and to > the SQL Standard. And of course, to no one's surprise, this also matches the mathematical definition of union: j -- Joshua Kugler Lead

[OT] Re: General MySQL Question: Ed Reed (CA, United States of America) Medium

2007-01-29 Thread Joshua J. Kugler
On Monday 29 January 2007 12:57, Ed Reed wrote: > I just didn't enjoy the location. When it was in Orlando a few years ago, > it was great. There were plenty of things to do and see; different places > to eat every night. I had a really good time. Then the following year I > went to Santa Clara and

Re: Visual Basic 6 + MySQL

2007-01-22 Thread Joshua J. Kugler
On Sunday 21 January 2007 16:41, Nuno Vaz Oliveira wrote: > > Just FYI: you can get the "Express" version of the VB.Net portion of > > Visual Studio for free: > > http://msdn.microsoft.com/vstudio/express/default.aspx That way, > > you're much more likely to have a fully supported app. I've not t

Re: Visual Basic 6 + MySQL

2007-01-21 Thread Joshua J. Kugler
On Sunday 21 January 2007 08:17, Nuno Vaz Oliveira wrote: > Hello Miles, > > > At 04:39 PM 1/19/2007, Nuno Vaz Oliveira wrote: > > > > Why VB6? This isn't an anti-Microsoft position, but that language has > > been left to die on the vine. So I'd think about .NET, or RealBASIC, > > or ... or Yo

Re: making graphs with MySQL data

2007-01-12 Thread Joshua J. Kugler
On Friday 12 January 2007 12:51, C.R.Vegelin wrote: > Dear List, > > I have a MySQL database (V5.0.x) and I need to make graphs. > Does anyone know about good utilities to make graphs ? > I would appreciate your expertise or links. If you're using Python, matplotlib is an excellent package. If yo

Re: Urgent please..

2006-11-15 Thread Joshua J. Kugler
On Wednesday 15 November 2006 18:14, Renish wrote: > Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on > php.exe and nothing seems to happen. > I have intalled > 1) webserver-Apache2 > 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks.

Re: Workbench

2006-10-30 Thread Joshua J. Kugler
On Sunday 29 October 2006 17:43, David Thole wrote: > On Oct 22, 2006, at 11:37 AM, João Cândido de Souza Neto wrote: > > Hi everyone. > > > > I´m using mysql workbench to design my database and am heaving a snag. > > > > How can i rename my object? It always gets the name "test" and i > > did not

Re: mysqlclient in Apache

2006-10-19 Thread Joshua J. Kugler
On Wednesday 18 October 2006 20:44, Dan Nelson wrote: > In the last episode (Oct 18), Danny Swarzman said: > > I'm developing an Apache module that uses mySQL. It needs to be able > > to talk to a remote host. > > > > I'm doing this in a Mac. > > > > I have a simple program in C that calls mysql_re

Bug in mysqldump or mysql-server 5.0?

2006-07-28 Thread Joshua J. Kugler
[I searched the bug database...please let me know if I missed an already filed or fixed bug.] I am trying to dump a database from MySQL 4.0.24 using the client tools from 5.0. Debian server, Ubutnu 6.06 client. I use this command line (watch for wrap): mysqldump -u jkugler -p -h dbserver --a

Re: I don't understand why SCSI is preferred.

2006-07-12 Thread Joshua J. Kugler
On Tuesday 11 July 2006 19:26, mos wrote: > SCSI drives are also designed to run 24/7 whereas IDE drives are more > likely to fail if used on a busy server. This used to be the case. But there are SATA drives out there now being made for "enterprise class," 100% duty cycle operations. See, for

Re: DWHS inc.

2006-02-15 Thread Joshua J. Kugler
ady has a Southern California mirror (H.E. in San Diego), but they might be willing to take on another. j- k----- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is L

Re: this listserv function...?

2005-12-19 Thread Joshua J. Kugler
in existence? Or is there some great reason > why the mysql lists are different than everyone else's lists? KMail has a handy little feature whereby when you press "L" while reading a message it replies to list. I use that all the time. j- k- -- Joshua J. Kugler --

Re: MySQL and Mandrake 10.2

2005-07-26 Thread Joshua J. Kugler
to the network, but I do not what. Anyone an > idea? -- > > > Prof. Pascal Francq > Université libre de Bruxelles > CAD/CAM Department > Avenue F.D. Roosevelt, 50 > CP 165/14 > B-1050 Brussels > BELGIUM > Tel. +32-2-650 47 65 > Fax +32-2-650 47 24 -- Joshua J. Kug

Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-03-03 Thread Joshua J. Kugler
C with a USB cable and then sync the 2 DBs. So what I want > to do is move the sync app to the CE Device and connect to MYSQL > directly from the mobile device. > > Hope this gives you a better idea of the problem. > > Regards > Hough > > >>> "Joshua J. Kugl

Re: Connect to MYSQL server from Wi-Fi enabled Windows CE device

2005-03-01 Thread Joshua J. Kugler
? If it's a standard ethernet connection, there is no difference than if you were plugged into a wall. What exactly are you looking for in your search? j- k----- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on

Re: New to MySQL on Linux

2005-02-11 Thread Joshua J. Kugler
andrake or Fedora, their installer tools will resolve all the dependencies for you. Hope that gets you started a little. If you need more detail, feel free to ask. j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heav

Re: GRANT can't grant with a password?

2005-01-11 Thread Joshua J. Kugler
gt; > If you don't have privs to the mysql.user table you definitely should not > be able to do that. -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count

Re: GRANT can't grant with a password?

2005-01-10 Thread Joshua J. Kugler
mysql db. j- k- On Saturday 08 January 2005 05:55, Gleb Paharenko said something like: > Hello. > > As said at: > > http://dev.mysql.com/doc/mysql/en/SET_PASSWORD.html > > Only clients with access to mysql database can set passwords for > other accounts. > &

GRANT can't grant with a password?

2005-01-07 Thread Joshua J. Kugler
RT, UPDATE, DELETE, CREATE ON rubric.* TO 'user'@'localhost' run as the user in question, worked and created the user, albeit with no password. Is there a way for a user with GRANT privs to create a user *with* a password? j- k- -- Joshua J. Kugler -- Fairbanks, Al

Re: Unique IDs

2005-01-07 Thread Joshua J. Kugler
hen we get connectivity. But I > don't have a handle on how to update the sub tables that have a FK pointer. > > Any ideas? > > Thanks! > -Andy -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, an

Re: Upgrading from 3.23.58 to 4.1

2004-12-07 Thread Joshua J. Kugler
there > any incompatiblities between the two versions, or any gotchas to the > upgrade? > > -- > A. Clausen > [EMAIL PROTECTED] -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that

Re: MySQL server is taking all my hardrive space

2004-10-21 Thread Joshua J. Kugler
physical size of > each table. They do not correspond to 10Gb, much less in fact, but the > dir where MySQL resides /var/lib/mysql is > consuming about 10Gb of my hard drive. > > What can be going wrong here? > > I am running 4.0.20-Max-log > > Thanks, > > C.F.

Re: MySQL Secure Connection(e.g. SSL) Question

2004-08-25 Thread Joshua J. Kugler
> > can > > > accomplish this task or an alternative solution? > > > > Thank You > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe:http://lists.mysql.com/[EMAIL PROTE

Re: mySQL on MAC

2004-07-13 Thread Joshua J. Kugler
e here who works with mySQL on a MAC? Any helpful insights? -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jesus Christ is LORD -- Count on it! -- MySQL General Mailing List For list archives:

Re: table scope

2004-07-13 Thread Joshua J. Kugler
alled linking, but I couldn't find > out whether mysql has that or not. > > If not, are there any alternatives anyone can suggest? > > Thanks > Alex -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth,

Re: No Response from Server

2004-07-13 Thread Joshua J. Kugler
a blank serevr was also choked by the usage. This started > > > happening bcz. DB is growing day by day and is quite big in size. Can > > > any body tell me what can i do. Should i use MYSQL Clusters or any > > > other thing ... i'll be so gratefull > > > > &

Re: No Response from Server

2004-07-12 Thread Joshua J. Kugler
t; happening bcz. DB is growing day by day and is quite big in size. Can > any body tell me what can i do. Should i use MYSQL Clusters or any > other thing ... i'll be so gratefull > > regards, > s.ahmad > Lahore, Pakistan -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:1370629

Re: problem importing .csv (excel format) into mysql

2004-07-08 Thread Joshua J. Kugler
is too large for the field, and MySQL is rolling it over. What is the type of your key? Int? Big int? And what is in that field in the Excel file? What kind of numbers? j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in

Re: DBF to MySQL

2004-07-08 Thread Joshua J. Kugler
ams in applescript, a little > obj-C, and SQL. I don't know if I can even implement those classes. > >>> LOAD DATA INFILE 'myfile.cdf' INTO TABLE mytable > >>> FIELDS TERMINATED BY ',' ENCLOSED BY '"' > >>> LINES TERM

Re: DBF to MySQL

2004-07-07 Thread Joshua J. Kugler
(or .xls file for that > > matter) and place it in a table in a MySQL database. Is this something > > that I can do with the server side MySQL application, or do I need to > > figure out a way to do it on the client side? Any description of the > > method would be very

Re: INSERT DISTINCT?

2004-07-07 Thread Joshua J. Kugler
for one or more of the columns as the row to be > inserted? That is, without using a method outside SQL? > > Thanks, > > John -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in heaven, on earth, and under the earth, that Jes

Re: BLOB's - General Guidance

2004-05-27 Thread Joshua J. Kugler
ve ever come across for this type of > application is that there's no advantage to keeping the image in the db > itself. Just keep them as files on the server, store a filename &/or > location in the db if necessary, and use your middleware to display the > images. Its faster

Re: Last inserted ID

2004-05-05 Thread Joshua J. Kugler
t; | LastID | > > ++ > > | 3575 | > > ++ > 1 row in set (0.00 sec) > > However, when I run this from my PHP script, I get a value of 0. > > Any clues as to how to resolve this? > > Thanks! > > -Erich- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:1

Re: Plz help quick - mysql/php/web server undefined function all of a sudden

2004-05-03 Thread Joshua J. Kugler
ut a hiccup. > > thanks for the help, > -- > Chip Wiegand > Computer Services > Simrad, Inc > www.simradusa.com > [EMAIL PROTECTED] > > "There is no reason anyone would want a computer in their home." > --Ken Olson, president, chairman and founder of Digital Equipm

Re: triggers (or too-many-crappy-questions)

2004-05-01 Thread Joshua J. Kugler
ost came across the list that is answered in the archives or the docs, a message could be bounced back saying so. It would probably cut list traffic by half. j- k- -- Joshua J. Kugler -- Fairbanks, Alaska -- ICQ#:13706295 Every knee shall bow, and every tongue confess, in

Re: libmysql setting it's own signal handlers?

2004-05-01 Thread Joshua J. Kugler
OK...thanks for the clarification. It helps. And it's good to know that what I'm doing won't break anything. j- k- On Thursday 29 April 2004 07:16 pm, Sasha Pachev said something like: > Joshua J. Kugler wrote: > > I have a program that is using (via a front en

Re: Connect string for ASP

2004-05-01 Thread Joshua J. Kugler
ar All > > I am using ASP. Can anyone give me the connection code to connect to a > MySQL database without using ODBC DSN? > > Thanks > > Michael Johnson > Director > > BPEnet EMEA > Sun iForce Premier Solution, Sales, Change Management & Development > Partner

libmysql setting it's own signal handlers?

2004-04-29 Thread Joshua J. Kugler
libmysql, my signal handler works fine. What does libmysql do to the signal handlers when it initializes? I don't have the source for it in front of my, or I would probably go digging my self. Running up against a deadline as it is. :) Thanks! j- k- -- Joshua J. Kugler Fair

Re: What is your mysql debugging strategy?

2004-04-27 Thread Joshua J. Kugler
d paste the SQL in there, and see what error it gives me. As in 'You have an error near' type messages. j- k- -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Ever

Re: SELECT duplicate rows

2004-04-21 Thread Joshua J. Kugler
rk--it should specify: > table1.column1=table2.column1, etc. However, I need it to match columns on > all of the tables in the database (of which there are many), rather than > just two. > > Any ideas? > > Thanks, > > John > > on 4/21/04 12:57 AM, Joshua J. Kugler

Re: SELECT duplicate rows

2004-04-21 Thread Joshua J. Kugler
every row whose > first 3 columns are duplicated in at least one other row in any of the > tables? Essentially, a command to find duplicate entries in the database . -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --.

Re: Multi-User Issues

2004-04-15 Thread Joshua J. Kugler
ed the archives by the title and by your name with no luck. If > you don't feel like going into detail, could you point out some good > links to learn more about the subject. > > Regards, > > Justin Palmer > > > > -Original Message- > From: Joshua J. Kugle

Re: Learning curve

2004-04-15 Thread Joshua J. Kugler
you think? Also, how long would > it take me to learn the necessary information? Lastly, how long would > it take to develop such a system? > > I appreciate your time and information! > Thanks, > Mike T. Caskey -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems

Re: Too many server instances

2004-04-12 Thread Joshua J. Kugler
everal instances of mysql server running concurrently > on the box. Each one of them allocates 512M for the > buffer pool and the box grinds to a halt, completely > out of RAM to do anything! > > I've included a snippet of the top command display (I > hope that you can re

Re: disabling backslash as an escape character in strings

2004-04-08 Thread Joshua J. Kugler
y may escape backslashes in the > MySQL way and switching the whole server to ANSI mode would break them. > > I'm using MySQL 3.23 but I'm willing to upgrade to the latest 4.0x if it > can solve this problem. -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Sys

Re: MSSQL Server to MYSQL migration problems

2004-04-06 Thread Joshua J. Kugler
_keys key key_len ref rowsExtra > postulantes ALL /NULL/ /NULL/ /NULL/ /NULL/ 4499 > > Thanks for your help, im still confused :( > > Joshua J. Kugler wrote: > >MySQL is very stable on large databases...I would suspect inefficient > > in

Re: MSSQL Server to MYSQL migration problems

2004-04-05 Thread Joshua J. Kugler
day 05 April 2004 05:41 pm, Rodrigo Galindez said something like: > Im using SQLYog to display results. It lets me to display blob data > types. By the way, i was trying to do some queries with phpmyadmin ... > but, it "hungs" ... hmmm ... inestability with large databases in

Re: MSSQL Server to MYSQL migration problems

2004-04-05 Thread Joshua J. Kugler
es (blob data > types now) but I can't in the MYSQL migrated data base, ... it just > don't display anything. Any ideas ? Is there any issue problem when > migrating MSSQL image column types to MYSQL ? > Thanks in advance, cheers from Argentina, -- Joshu

Re: Transaction Not supported

2004-03-31 Thread Joshua J. Kugler
y nonses ;) > > What I did was trying to use something like this which to my knowledge > doesnt work on MySQL servers. > > $dbh->commit(); > $dbh->rollback(); > > /Jonas > > > ----- Original Message - > > From: "Joshua J. Kugler" <[EMAIL

Re: Transaction Not supported

2004-03-30 Thread Joshua J. Kugler
#Begins the transaction $dbh->do('BEGIN'); . . . . $dbh->do('COMMIT'); What does your code look like? j- k- -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAI

Re: High resolution timestamps

2004-03-23 Thread Joshua J. Kugler
wrote: > Hello, > > Recently I've been needing high-resolution timestamps > (year/month/day/hour/minute/seconds/microseconds) in MySQL (to store > network packets, mmm). Is this a planned feature for MySQL in the > future? -- Joshua J. Kugler Fairbanks, Alaska

Re: https access to phpmyadmin - mysql

2004-03-11 Thread Joshua J. Kugler
r a long time for other applications. > > What I am looking for are phpmyadmin specific instructions as to how to > configure phpmyadmin to use mod_ssl and > and DISALLOW http logins and only allow https logins and use of phpmyadmin. > > Thanks anyone. -- Joshua J. Kugler Fairb

Re: Security

2004-03-11 Thread Joshua J. Kugler
abase > so that they can update the customer table (for example address change) and > add transactions to the transaction table. What I do not want to happen is > that customer A is able to modify customer B's record. > In short how would you restrict customer a to see transactions that

Re: Security

2004-03-10 Thread Joshua J. Kugler
> -Original Message----- > From: Joshua J. Kugler [mailto:[EMAIL PROTECTED] > Sent: Wednesday, March 10, 2004 5:34 PM > To: Mulugeta Maru; MySQL > Subject: Re: Security > > > Only being able to see certain rows is not a function of MySQL, it is a > function of the applic

Re: Security

2004-03-10 Thread Joshua J. Kugler
customer order details, > etc) in say abc database what will I have to do to make sure when customer > A logs in to the database can only see his/her account, orders, order > details without getting access to other customer accounts. -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant

Re: Mysql timed actions... Confused

2004-03-10 Thread Joshua J. Kugler
onds > 2004/03/09 06:50:01OK, 77526 bytes29 seconds > 2004/03/09 06:55:00OK, 77526 bytes28 seconds > 2004/03/09 07:00:00OK, 77532 bytes28 seconds > 2004/03/09 07:05:00OK, 77526 bytes1 seconds -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant

Re: Span a database transaction across multiple CGI scripts

2004-03-10 Thread Joshua J. Kugler
_ > Do you Yahoo!? > Yahoo! Search - Find what you’re looking for faster > http://search.yahoo.com -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, a

Re: Saving file into database

2004-03-09 Thread Joshua J. Kugler
se the file. I am using a perl interafce. Is this at all > possible??? > > And would it be possible to then read that file from a c++ interface? -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED

Re: Selectinmg most recent dates from multiple table items

2004-03-07 Thread Joshua J. Kugler
; each of the sensors and have it sorted it by the sensor ID? > > This isn't obvious to me from reading the documentation on queries and > I've been searching and reading through messages without success yet. > I suspect a big part of the problem is I'm fairly new t

Re: mysql import problem

2004-03-04 Thread Joshua J. Kugler
gt; columns or the details about the db file.How can i import such a file. > > How do you want to import this file? Do you want to load the whole file > into specific field? -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-..

Re: Information request

2004-03-04 Thread Joshua J. Kugler
nt I would like to try. > > So where do I get information about the protocol and the operations > possible via the protocol? > > Best regards > Søren -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL

Re: Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
.html > > Hint: Take a look at the paragraph that follows the table that lists > the formatting specifiers. -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED] ICQ#:13706295 Every knee shall bow, and e

Re: Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
On Wednesday 03 March 2004 08:04 pm, Sasha Pachev wrote: > Joshua J. Kugler wrote: > > In the manual that came with MySQL 4.0.17 (at least in the Mandrake > > packages of such) it says I can use %f to get the microseconds in a > > DATE_FORMAT call. This does not work, howev

Re: FW: query

2004-03-03 Thread Joshua J. Kugler
our example is using 2 table. > > ~Elle~ > > -----Original Message- > From: Joshua J. Kugler [mailto:[EMAIL PROTECTED] > Sent: Thursday, March 04, 2004 11:08 AM > To: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: FW: query > > Oh, so what you're loo

Re: FW: query

2004-03-03 Thread Joshua J. Kugler
same > value for several fields. > Example : table customer with field customer_id, address, DOB, Services > I need to know that customer data in my table have more than 1 record for 1 > customer. So he/she has more then 1 customer_id. > I need to query the double record, not the DISTINC

Re: locking

2004-03-03 Thread Joshua J. Kugler
sing > to be done now. > > For speed, I'd now like several processes to grab work from the table. > > I am not sure how mysql handles locking. > > While a process is seizing a row (changing row status from > 'waiting' to 

Re: Dream MySQL Server?

2004-03-03 Thread Joshua J. Kugler
tical. A client on Windows, Mac, or *nix can talk to a MySQL server on a Windows, Mac, or *nix server, and will never know the difference. All it knows it that it is connecting to port 3306 and it's talking to a MySQL server. There is no difference among operating systems. j-----

Microseconds in the 4.0.x series...

2004-03-03 Thread Joshua J. Kugler
announcement or the 4.0.17 documentation? Is there a way to get sub-second resolution in 4.0.17, or must I rely on my application? Thanks! j- k- -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .--.- ..- --. .-.. . .-. [EMAIL PROTECTED

Re: A problem with access to data source, please help!!!!

2004-03-01 Thread Joshua J. Kugler
-- > > ------------+ > 1 row in set (0.00 sec) > > > I need a help, >thanks in advance > Rafael -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .

Re: Xserve G5

2004-03-01 Thread Joshua J. Kugler
king of purchasing some new hardware to run our MySQL server. > The 64-bit architecture is something we would like to take advantage of. > > Is this good, bad, otherwise? Any comments would be appreciated. > > Thanks > > TOM -- Joshua J. Kugler Fairban

Re: Using mod_auth_mysql with Apache 2

2004-03-01 Thread Joshua J. Kugler
; MySQL: > > Auth_MySQL_Info hostname user password > > Is this right? Where in the httpd.conf should this be placed. > > Any help would be great! > > Thanks, > > James -- Joshua J. Kugler Fairbanks, Alaska Computer Consultant--Systems Designer .--- --- ... ..- .-

Re: WHERE clauses across rows...

2004-02-27 Thread Joshua J. Kugler
next_row='word') > > > > Is this even possible? I'd hate to issue hundreds of queries to check if > > "strt word" is split across rows. > > > > Should I investigate setting variables equal to the col4, and on a failed > > search, use that

WHERE clauses across rows...

2004-02-26 Thread Joshua J. Kugler
the "old col4" pairs with anything in col1? Or am I better off searching for the good case, and on failure, go and look for 'strt' in col4, then when I get a row, see if 'word' is in col1 on the next row (via another query)? Ideas? Tips? Suggestions? Thanks mu

Re: Is there any way to search a whole database for a value?

2003-03-11 Thread Joshua J . Kugler
A request such as this make me think the database is not properly normalized. If there is one value that can be in several columns, it is very likely those columns need to be broken into their own table, so that they can be queried with a SELECT statement that has only one column in its WHERE c

Re: what is wrong with this perl mysql code?

2003-03-04 Thread Joshua J . Kugler
You need quotes around $username in your SQL query, unless you've already run $username thorough $dbh->quote(); j- k- On Tuesday 04 March 2003 13:11, Jianping Zhu wrote: > I am writing a simple login system by using perl( this is almost my first > program in perl), After user pick a user

Re: problem: Loosing .MYD Files

2003-02-26 Thread Joshua J . Kugler
Daniel - This might be a long shot, but since I've actually run into this problem before, here goes: Check your partitions. I had a server on which this very thing happened, and it turned out there were overlapping partitions. This was all fine and dandy until data was written to those overl

Re: Different value from same function

2003-02-18 Thread Joshua J . Kugler
Your INT in your table is a signed INT, which is going to have a maximum value of 2^31, thus your IP address is causing the field to "roll over." You need to change your IP column to UNSIGNED INT. That should solve your problem. j- k- On Tuesday 18 February 2003 12:33, Aaron Conaway

Re: Applications for creating reports for MySQL

2003-02-06 Thread Joshua J . Kugler
How much work do you want done for you? Perl and Python are great apps for writing MySQL reports, and you can output all the report to a text file, which would be great for a reader. But as "report applications," can't help you there. Sorry. j- k- On Tuesday 04 February 2003 09:10,

/usr/bin/safe_mysqld: 5: command not found (WAS: Re: 3.23.54 compile error)

2002-12-14 Thread Joshua J . Kugler
I got that as well., and like the case below, MySQL is up and running just fine. I tried looking in safe_mysqld for a spurious '5' but couldn't find anything. Does anyone know what's up with the most recent safe_mysqld? j-- k- On Thursday 12 December 2002 17:16, Gabriele Carioli wrote

Re: Now() and Timestamp

2002-11-21 Thread Joshua J . Kugler
> INSERT INTO $tablename > (sender, recipient, whenread, whensent, subject, > messagetext, folder, priority, condition) > VALUES > ('$directorid', '$SendTo', '00', NOW(), '$SetSubject', > '$MessageText', 'Inbox', '$SetPriority', 'TO') Easy as that! j- k- mysql, sql -- Jo

Re: last_insert_id()

2002-11-12 Thread Joshua J . Kugler
This looks like the same problem I have with MS Access. It seems MS Access uses the SELECT id FROM table_name WHERE is IS NULL, and this syntax clears the last insert ID field. My solution is here: --- One Line URL, might wrap --- http://groups.google.com/groups?hl=en&safe=off&threadm=9ehc8i%2

Re: AutoNumber Question

2002-11-11 Thread Joshua J . Kugler
The correct behavior is the number starting at the last number used. If you are using MyISAM tables, you should see this behavior. If you are using the old style ISAM tables, it will restart at 1 every time. j- k- On Monday 11 November 2002 11:41, Jessee Parker wrote: > I have a scrip

Re: Dual processors and mysql

2002-10-14 Thread Joshua J . Kugler
MySQL is multithreaded, so your OS will send separate threads to different processors. So, yes, MySQL will automatically take advantage of multiple processors, no need to tell it explicitly. j- k- On Monday 14 October 2002 08:49, Dyego Souza do Carmo wrote: > Hello all... > > I´m comp

Re: MySQl db as filesystem.

2002-10-12 Thread Joshua J . Kugler
There has been such a project for quite a while. Take a look at http://no.spam.ee/~tonu/ and find the link about SQLFS. j- k- On Thursday 10 October 2002 02:58, Alex Polite wrote: > Is there any way I could display a MySQL database as a filesystem > under Linux? > > alex -- Joshua Ku

Re: resetting mysql server "gently"

2002-10-10 Thread Joshua J . Kugler
I agree completely with Egor! You should not be killing your processes to solve load problems. If there is a load problem 1) You need to write your applications better, 2) you need to have a better database structure, 3) you need to analyze where indexes would help you, or 4) you need a more

Re: Mixing Linux and Windows and paying for it

2002-09-30 Thread Joshua J . Kugler
On Monday 30 September 2002 10:13, Drulli B wrote: > Hi, > > I have a grand total of two very important but possibly humiliatingly daft > questions, that I hope some kind soul will patiently solve: > > 1. Can I run a mySQL server on a Linux computer, and query it through > myODBC running on a Wind

Re: Bitten by a strange bug...

2002-09-03 Thread Joshua J . Kugler
Tom - I'll address what I can I had the same problem with fields being truncated on direct connections (the problem does not manifest on ODBC table attaches in Access). IIRC, the way to "solve" this problem is to make sure the "optimize columns widths" (option 1) in the ODBC properties.

Re: MD5

2002-06-20 Thread Joshua J . Kugler
If you are running Linix, at the prompt type: md5sum filename I'm sure you can get md5sum for other Unices as well. j- k- On Thursday 20 June 2002 13:00, Kiss Dániel wrote: > Hi everyone, > > Can anyone tell me how to create an MD5 checksum on a file. > I tried to do this by using the

Re: Problems with UPDATE in v3.23.49 (is this a bug)

2002-04-05 Thread Joshua J . Kugler
It's not illogical at all. You often want (sometimes need) that field to make sure a record has not changed when you go back to update the row. MS Access (and others) uses this so as not to overwrite changes made since the record was retrieved. You can't always rely on the client to set field=N

Re: MyODBC for Core Business, followup...

2002-03-06 Thread Joshua J . Kugler
To all: This is in response to a request for more information. I thought others may find it useful. > Thanks so much for your reply. It's good news to hear that > someone is relying on MyODBC for an important purpose, much of the > usage I've seen seemed rather small. Like I said, we h

Re: How "compressable" is a typical MySQL database?

2002-02-17 Thread Joshua J . Kugler
Oh. OK. Didn't know that. Thanks. j- k- On Saturday 16 February 2002 22:26, Jeremy Zawodny wrote: > On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote: > > In that case, i would highly recommend using mysqldump to backup > > your databases. Simply compressing the actual

Re: How "compressable" is a typical MySQL database?

2002-02-16 Thread Joshua J . Kugler
In that case, i would highly recommend using mysqldump to backup your databases. Simply compressing the actual DB's could give you tables in inconsistent states, UNLESS you first shut down your DB server, then run the backup. Something to think about. j- k- On Saturday 16 February 2

Re: forms?

2002-02-12 Thread Joshua J . Kugler
Using Perl/CGI and DBI::MySQL would work for forms. You could take the input from the browser, and print the results back to the browser. Would that work? j- k- On Monday 11 February 2002 05:20, Jim Hatridge wrote: > Hi all... > > First of all, I think that MySQL is really great. The

Re: LIKE work around??

2002-02-11 Thread Joshua J . Kugler
Umm, I take it you haven't read the documentation? MySQL fully supports LIKE. Can you tell us the error you are getting? Along with the full query? j- k- On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote: > MySQL doesn't support LIKE does it? I got an error when I tried. --

Re: LIKE work around??

2002-02-07 Thread Joshua J . Kugler
Umm, I take it you haven't read the documentation? MySQL fully supports LIKE. Can you tell us the error you are getting? Along with the full query? j- k- On Thursday 07 February 2002 11:11, Rutledge, Aaron wrote: > MySQL doesn't support LIKE does it? I got an error when I tried. --

Re: i686 Binary on i586 OK?

2002-02-01 Thread Joshua J . Kugler
You can try...but, an i686 binary may use machine code instructions that are not present in the i586 chip. Thus, the program will crash with an "illegal instruction" message. j- k- On Friday 01 February 2002 16:11, Steve wrote: > I'm wanting to install mysql on an older i586 machine r

Re: Problem with MySQL and SMP?

2002-01-11 Thread Joshua J . Kugler
Yes, this had occured to me. I am thinking about downgrading to kernel 2.4.8, or such. Not sure I really want to do that, but I'd rather do that than face system lock ups. j- k- On Friday 11 January 2002 08:55, Sinisa Milivojevic wrote: > If nothing works as you said, no ssh, no cons

Re: Problem with MySQL and SMP?

2002-01-11 Thread Joshua J . Kugler
We are having the same problem. Mandrake 8.1, kernel 2.4.17, MySQL 3.23.47. Dual PIII-500, 512MB of RAM, Mylex DAC960 RAID 5. After being up for a few days, the system completely froze. No ssh, no console, nothing. Had to hard reset the server. Yes, we compiled MySQL: we have to. Our appli

What kind of crashes with GCC 2.96?

2002-01-07 Thread Joshua J . Kugler
On the MySQL download page, there is a warning for GCC 2.96/x86/Linux that reads thus: "Several of our users have reported random crashes and table corruption with MySQL binaries compiled with gcc 2.96 on the x86 Linux platform." I was wondering what kind of crashes users had experienced. Cra

Re: Are there any openly-accessible MySQL server [I can use for testing]?

2001-12-27 Thread Joshua J. Kugler
Umm, why not just install a copy locally? You can get a binary for just about any OS. And a local copy would be much faster than working over the internet. j- k- On Thursday 27 December 2001 06:31, David Ayliffe wrote: > I am writing a conversion tool for MySQL and I could do with so

  1   2   >