Re: Batch mode / stored prodecure question?

2003-02-10 Thread Jerry
Pass it to a script or handeler program that does the dB work then passes back what you need to the radius ? Jerry - Jeremy Hutchings Apps R&D Cable and Wireless - - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]

Re: Merge table limit

2003-02-10 Thread Jerry
- Original Message - From: "Jerry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 08, 2003 9:33 AM Subject: Merge table limit > Hello all. > > Does any one know, or can anyone point me in the direction of the limits of > a number o

Re: Applications for creating reports for MySQL

2003-02-10 Thread Jerry
If your going to HAVE to use windows 2000, you'll have to odbc and create the form with vb. I've always used web front ends and had the PDF generated on the fly, to have to use 2000 is going to mess things up no end. Jerry - Original Message - From: "Octavian Rasnita&quo

Merge table limit

2003-02-09 Thread Jerry
table for a year that will encompass them all (i.e. 9.1 billion rows). Has anyone had 365 tables in a merge table ? or more ? Thanks Jerry - Jeremy Hutchings Apps R&D Cable and Wire

Re: mysql limitations

2003-02-08 Thread Jerry
http://www.mysql.com/doc/en/Table_size.html More lightly to be file system than dB I think depending on the version. Jerry Apps-R&D Cable and Wireless - Original Message - From: "Martin Hudec" <[EMAIL PROTEC

Re: encrypted password

2003-02-06 Thread Jerry M. Howell II
thing like MD5("jian1830") this would do an MD5 hash -- Jerry M. Howell II - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: Book recomendations

2003-01-08 Thread Jerry M. Howell II
it works for the advanced person because I'm not realy advanced but mabe skim through it if the bookstores have it and see what you think or read the reviews on the book on bn.com or mabe others on the list could give feedback on this. -- J

Riddle Me This...

2002-12-26 Thread Jerry Barnes
Given the two tables: "fruit_table", and "vegetable_table", how do I get the "Desired ResultSet" below? Thanks... fruit_table +-++ | date| fruit | +-++ | 2002-12-16 00:00:00 | Apple | | 2002-12-17 00:00:00 | Banana | +--

Re: mysql and php

2002-12-02 Thread Jerry M . Howell II
idn't compare the database to the script in the first place. gr On Mon, 2 Dec 2002 23:34:45 -0500 Jerry M. Howell II <[EMAIL PROTECTED]> wrote: > Error in input query > > start of php database code * > > $connection = mysql_conne

Re: mysql and php

2002-12-02 Thread Jerry M . Howell II
t from the command line and can access the database just fine it might be a scripting error but I've searched the web for templates and they all seem to use this format so I'm stumped On Mon, 2 Dec 2002 23:59:35 -0500 daniel <[EMAIL PROTECTED]> wrote: > this is a vague one , wou

mysql and php

2002-12-02 Thread Jerry M . Howell II
u all feal it's nessisary topost it here. Is there any permision issues I should look into or something they might have overlooked in the install? I apreciate any help I can get on this issue. thnx -- Jerry M. Howell II -

RE: one mysql-test issue

2002-11-19 Thread Yu, Jerry
I run the mysql-test as root. -Original Message- From: Matthew Smith [mailto:[EMAIL PROTECTED]] Sent: 2002Äê11ÔÂ19ÈÕ 16:25 To: Yu, Jerry; [EMAIL PROTECTED] Subject: RE: one mysql-test issue Does it have write permissions for the user running the tests? M -Original Message

RE: one mysql-test issue

2002-11-19 Thread Yu, Jerry
Sure, the directory exists. :) Rgds --Jerry -Original Message- From: Matthew Smith [mailto:[EMAIL PROTECTED]] Sent: 2002Äê11ÔÂ19ÈÕ 15:51 To: Yu, Jerry; [EMAIL PROTECTED] Subject: RE: one mysql-test issue Does the directory /usr/local/mysql/var/run exist? If not, try creating it

one mysql-test issue

2002-11-18 Thread Yu, Jerry
ns. > > Does anyone meet the same problem before? How to resolve it? Any comments > are appreciated! > > Yours sincerely > "Jerry Yu, Opinions expressed are those of the author and do not represent > Intel Corporation" > --

Re: ODBC install and remote connection quetions

2002-11-03 Thread Jerry
David Lloyd wrote: How do you mean not able to "see it"? Under the control panel there should be an "ODBC Data Source Administrator"... (mysql, query) DSL The driver is not listed in the driver. I cannot select it from the list of drivers as it

ODBC install and remote connection quetions

2002-11-02 Thread Jerry
m? I am using Win98 2nd edition. I downloaded and installed My ODBC. For some reason, I am not able to see the MySQL ODBC driver. What do I need to do so that it is available to me? I am really lost with this. Jerry - B

Date as field default

2002-10-28 Thread Jerry
What do I put in a date field's default value if I want the MySQL database to insert the current date in the field when a new record is inserted? TIA, Jerry - Before posting, please check: http://www.mysql.com/manua

CONFIG_SMP redefine warnings while compiling...

2002-10-03 Thread Jerry Lundström
+#ifndef CONFIG_SMP #define CONFIG_SMP +#endif #include #endif -- Jerry Lundström | System Developer/Administrator | Tiscali AB Ringvägen 100 C | S - 104 60 Stockholm | P: +46-8-691 47 00 mailto:[EMAIL PROTECTED] | www.tiscali.se

Stability of 4.0.x

2002-08-21 Thread Jerry van Leeuwen
consider the 3.23.x features to be inside 4.0.x? ... have there been (m)any recent bugs in the 4.0.x tree for features that used to work fine in 3.23.x? Any indications (especially from the MySQL developers) would be appreciated greatly, Jerry van Leeuwen

Re: Combining queries

2002-08-14 Thread Jerry van Leeuwen
'1' SELECT SUM(testResume='1'), SUM(HighRank='1') FROM Resume ; Basically in both cases you make (very ugly!) use of the fact that boolean expressions evaluate to '1' for true, and '0' for false. Regards, Jerry MySQL, SQL -

WWW-Authenticate question!

2002-08-12 Thread JeRRy
t; ALSO, if I have more than one page for the members how do I protect these? So if they have not got a valid login they get asked for it or referred back to the login / main page? Or is there a way to have all my pages in the one PHP file? (I think thi

Using PHP for login/Members Area!

2002-08-10 Thread JeRRy
Hi, I would like to create a members area on my site, using mySQL for the database to hold usernames and passwords to login to the area. I need to know the following if anyone can help please. - What code would I need to make a login page form that has username and password? (lets say the table

PHP form to mySQL

2002-08-10 Thread JeRRy
Hi, I am trying to setup a PHP form to send to mySQL database. I know how to connect to mySQL but need help getting the information in the form to update into the mySQL database. I have the following table called contacts, I'd like the form to have the following fields. firstName lastName emai

various questions about my.ini /or my.cnf

2002-08-01 Thread Jerry Arkema
t.txt" into table pet; If I don't fully qualify the input file name I get: mysql> load data local infile "pet.txt" into table pet; ERROR: File 'pet.txt' not found (Errcode: 2) It doesn't appear that my.ini is being use

various questions about my.ini /or my.cnf

2002-08-01 Thread Jerry Arkema
t.txt" into table pet; If I don't fully qualify the input file name I get: mysql> load data local infile "pet.txt" into table pet; ERROR: File 'pet.txt' not found (Errcode: 2) It doesn't appear that my.ini is being use

How to compile mysql in dynamic way?

2002-07-31 Thread Yu, Jerry
The the configure file and make file are so complicated. Could you tell me a straightforward method to compile MySQL dynamicly. :-) I want to run the MySQL upon NGPT. Thanks! yours sincerely Yu Ronghua (Jerry) Intel China Software Lab Tel: 021- 52574545 ext. 1328 INet: 8-752-1328

Help: How to compile mysql in dynamic way?

2002-07-31 Thread Yu, Jerry
The the configure file and make file are so complicated. Could you tell me a straightforward method to compile MySQL dynamicly. :-) I want to run the MySQL upon NGPT. Thanks! yours sincerely Yu Ronghua (Jerry) Intel China Software Lab Tel: 021- 52574545 ext. 1328 INet: 8-752-1328

Re: Unable to Install MyODBC on Windows 98 PC

2002-06-12 Thread Jerry Burg
Jerry Burg Contour Information Services, Inc. Allied Reports [EMAIL PROTECTED] 818.881.1087 / Fax 818.881.1155 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

New MySQL releases: when?

2002-05-02 Thread Jerry van Leeuwen
ce if somewhere on the MySQL web-site there is an indicator of the current status of new releases, ... waiting isn't bad, as long as you can have an idea of what you are waiting for. :) Jerry van Leeuwen Business Analyst - Trans Data Tel: 02 - 9630 3533 Mobile: 0407

Good color coded SQL editor for MySQL?

2002-04-30 Thread Jerry
Does anyone know of a good color coded SQL editor for MySQL that works in Windows? TIA, Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Good color coded SQL editor for MySQL?

2002-04-30 Thread Jerry
Does anyone know of a good color coded SQL editor for MySQL that runs on Windows? TIA, Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

RE: query returns a BLOB for no reason

2002-04-26 Thread Jerry Jackson
Victoria, you solved my problem!!! (after we spent way too much time trying to figure out what was wrong with our SQL syntax) Where should we ship the beer to? Thanks from all of us at BCA! - Jerry Jackson Director of Software Development

query returns a BLOB for no reason

2002-04-26 Thread Jerry Jackson
ND tblSystemType_2.intSystemTypeID Thanks for any suggestions or answers anyone is kind enough to provide. - Jerry Jackson Director of Software Development BCA Technologies, Inc. (407) 659-0653 ext. 320 [EMAIL PROTECTED] --

query returns a BLOB for no reason....

2002-04-24 Thread Jerry Jackson
0) ORDER BY tblSystemType_1.intSystemTypeID AND tblSystemType_2.intSystemTypeID Thanks for any suggestions or answers anyone is kind enough to provide. - Jerry Jackson Director o

Re: Impact of Free ORACLE

2002-03-25 Thread Jerry Winegarden
TECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > -- *** Jerry WinegardenOIT/Technical Support Duke

What's this in my netstat?

2002-01-12 Thread jerry
Hi- Anyone know what web.mysql.com is doing? It's from a netstat on a RH 7.2 running mysql 3.23.47 myhost.mydomain:4570 web.mysql.com:auth TIME_WAIT Thanks- - Before posting, please check: http://www.mysql.com/

RE: Redhat 7.2 Linux Maximum Database/Table Size

2002-01-10 Thread Jerry Rehak
All right How do you set ext3 to minimum journaling?? > -Original Message- > From: Benjamin Arai [mailto:[EMAIL PROTECTED]] > Sent: Thursday, January 10, 2002 9:22 PM > To: [EMAIL PROTECTED] > Subject: Redhat 7.2 Linux Maximum Database/Table Size > > > I have been testing Redhat 7.2

Complicated Query?

2002-01-09 Thread Jerry Rehak
I have a table with the columns names and id. I want to be able to find all names with an id of '03' that do not have other records with id values of '10','20' or '37'. Is this even possible to do? name id a03 a11 a12 a13 I want 'a' because it has a 03 and

Subselect/set query..pardon my SQL

2002-01-07 Thread jerry
a 20, OR 37 I know this is childs play for some of you out there. Any help/ideas would be greatly appreciated. Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

to many connections, how to optimize them?

2001-11-30 Thread Jerry
code is generated or is it better to connect for every piece of information that is needed? What should I also be looking for in optimizing my pages? I don't have near 100 users simultaniously accessing database! Yours

Re: Re: Is converting string to integer possible?

2001-11-27 Thread Jerry
;although I own a copy of it I have hardly used it in a year or >>more)). >>On a side note to Jerry, I checked my uptime this morning, and >>my Amiga1200 has now been running for 59 days without a single >>reboot. I have yet to see windows do that. :-D >>And... o

Re: Is converting string to integer possible?

2001-11-27 Thread Jerry
n("date") Session("date") holds 20011126121222 Is 14 number digit to much to use < or what is wrong? Thank you for your help. Yours Jerry - Before posting, please check: http://www.mysql.com/manual

Is converting string to integer possible?

2001-11-27 Thread Jerry
but I need to to this in mySQL). Yours Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL P

RE: Need help with SELECT 2 tables from choice of 3

2001-11-22 Thread Jerry
when my database grows, all of the new messages will be from new members, not old, so the condition to open recordset in for...next loop would not be executed. Is my thinking valid? Yours Jerry - Before posting, please check:

Re: Need help with SELECT 2 tables from choice of 3

2001-11-21 Thread Jerry
). In SQL I can not do >the AND and compare both MEMBER_ID's because it would never return anything. >If I use or I do get data, but not one, but multiplied number od times (every >new member is then resulted or every old member, depending on in which table >SQL finds the data). >

Need help with SELECT 2 tables from choice of 3

2001-11-21 Thread Jerry
recordset from the members or oldmembers table. There must be another way directly from the SQL query. I looked everything on Internet about this problem and couldn't find any solution. Could you just point me to any directi

Grouping behavior question

2001-11-01 Thread Jerry van Leeuwen
of all my database tables to contain the latest statuses in the master table. For one thing this clutters up the database design by replicating information. Jerry van Leeuwen Business Analyst - Trans Data Tel: 02 - 9630 3533 Mobile: 0407 - 480 811

Re: Help me with SELECT - GROUP BY - IF

2001-10-02 Thread Jerry
there any if-like >function that checks ALL records for the ID=ocenjevalec, not just the first >(or the grouped by, seems to take 'ocenjevalec' as from the first data). If >this is not possible, how can I achieve that? Should

Re: FreeBSD and multiple daemons

2001-08-23 Thread Jerry Preeper
t know if this matters, but are there any general rules of thumb on the size of the mysql daemon on FreeBSD? Right now it shows 164MB according to this line from top 21366 mysql 58 0 164M 146M RUN1 32.5H 57.32% 57.32% mysqld Jerry >> I'm having a problem with my ser

Stability of Windows installation of MySQL 3.23.38

2001-08-20 Thread Jerry van Leeuwen
table corruption than other combinations? And if Windows 9x is a particularly bad option in this context, what benefit can be expected from migrating the MySQL installation to a Windows NT / 2000 machine? Jerry van Leeuwen Business Analyst - Trans Data Tel: 02 - 9630 3533 Mobile

MySQL data_seek performance

2001-06-21 Thread Jerry van Leeuwen
physical memory was not full yet, but the processor was running at 100%. Any enlightenment would be appreciated, Jerry van Leeuwen Business Analyst - Trans Data Tel: 02 - 9630 3533 Mobile: 0407 - 480 811 - Be

Compile failures on FreeBSD 3.5

2001-03-28 Thread Jerry Walsh
stname.o(.text+0x52b): undefined reference to `my_gethostbyname_r' Any help would be appreciated, Regards, Jerry. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

MySQL with transactions problem

2001-03-21 Thread Jerry van Leeuwen
seem to recognise the --dbd-home option, or allow me to create a BDB type table. Should I be looking in another area for binary Linux and Windows versions of MySQL that by default support BDB tables? Or am I doing something wrong? Jerry van Leeuwen Business Analyst - Trans Data Tel: 02

Q: MySQL 3.23.35 with Transactions?

2001-03-21 Thread Jerry van Leeuwen
another area for binary Linux and Windows versions of MySQL that by default support BDB tables? Or am I doing something wrong? Jerry van Leeuwen Business Analyst - Trans Data Tel: 02 - 9630 3533 Mobile: 0407 - 480 811

clustering

2001-03-21 Thread Jerry G. Wang
All, a.. does mysql support clustering multiple db servers? if so, on what platfrom. b.. how's stability of mysql on win2000 server ? c.. where can i get product support of mysql? pls reply to my email addr. thanks in advance. Jerry

replication or log-update

2001-03-19 Thread Jerry . Zhao
FYI Just noticed that statements like "LOAD DATA LOCAL INFILE 'testload.data' INTO TABLE testload ;" won't work via replication(3.23.33) or log-update(3.22.32) unless the data files are copied to remote slave servers in advance. Better implementation? Workar

log-update bug

2001-03-19 Thread Jerry . Zhao
Hi, Can you guys confirm that "create database" statements are not logged in the log-update log? The version I am using is 3.22.32. Regards, Jerry. - Before posting, please check: http://www.mysql.com/manual.

Access rights

2001-03-17 Thread Jerry Davis
mysql with user root. ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) Jerry -- Boycott the outlaw Microsoft - and use Linux - the Software that gives you Freedom to choose! - Before postin

got it installed, but can't run daemon

2001-03-08 Thread Jerry Davis
On system: SuSE 7.1 Professional MySql version: Ver 3.23.32 for pc-linux-gnu on i686 have also run the mysql_install_db, which says that all files have been installed. when running safe_mysql & 1) mysqld errors out 2) I get the following in linux.err J

<    4   5   6   7   8   9