Re: VB6 ODBC Memory problems
My first recommendation is to switch to ADO. It is much faster. Bruce Lewis - Original Message - From: Thomas Bein [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, March 16, 2003 12:55 PM Subject: VB6 ODBC Memory problems Hello, I have been developing an application in VB60 (SP5) which seems to eat up my memory after running some time. The programm is just doing a SELECT in a loop. When the programm is stopped, the memory is freed. Developement environment: WinNT40 SP6a VB60 SP5 DAO 3.6 MySql 2.23.54-nt MySql-ODBC 3.51.04 (using no transactions) Are there known problems ? Thomas - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: # of Business Days?
Where I work:
1) We created a table for holidays (projected data for the next few years).
2) Created a function for the day of the week.
3) If M-F and not Holiday, then perform routine.
We had to go this route because there are way too many bank and market
holidays to keep straight with just code. Plus, it is flexible in the event
of change (i.e. 9/11 - the markets were closed for several days, so they do
not count as business days).
Hope this helps.
Bruce
- Original Message -
From: Patrick Näf [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Cc: Joe Stump [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, February 24, 2003 2:21 PM
Subject: Re: # of Business Days?
Hello
This is not correct, see this at example:
From friday to mondey there are 4 days (or 3, depends on how you count
;-).
your calcs:
$day = 4
$weeks = 4 / 7 = 0
$weekend_day = 0 * 2 = 0
$business_days = 4 - 0 = 4
If you have 100 weeks, then it will be quite correct.
here is my solution:
$day = total_days_between_a_and_b;
$less = weekend_days_between_WeekDAY_a_and_WeekDAY_b (for example: from
friday to Mondey, then it will be 2)
$weeks = $day DIV 7;
$bussiness_days = $day - $weeks * 2 - $less;
my example again:
$day = 4;
$less = 2;
$weeks = 0;
$bussiness_days = 4 - 0 * 2 - 2 = 2
or use a function from a programming language, if available. You have to
deal also with some special days (12-24 / 12-25 and so on).
greetings from Switzerland
Patrick
Joe Stump wrote:
I'm not sure of an exact query, but if you can get the total number of
days
you can mathmatically get the biz days with the following math (in psuedo
code):
$days = total_days_between_a_and_b;
$weeks = ($days / 7);
$weekend_days = $weeks * 2;
$business_days = ($days - $weekend_days);
Hope this helps. There may be more elegant ways of getting such a value.
This doesn't take into account day A being wednesday. You might be able
to
do a SELECT COUNT(*) on evaluating your date to it's Day value in
('Mon','Tue','Wed','Thu','Fri')
Check the date commands.
--Joe
--
Joe Stump [EMAIL PROTECTED]
http://www.joestump.net
Label makers are proof God wants Sys Admins to be happy.
-Original Message-
From: Lucas Cowgar [mailto:[EMAIL PROTECTED]
Sent: Monday, February 24, 2003 9:59 AM
To: MySQL Mailing List
Subject: # of Business Days?
Can anyone out there help me with a SQL query? I need to find the number
of
business days between date a and b? Obviously finding simply the number
of
days is easy, but I have no clue how to find the number of business days.
TIA!
Lucas Cowgar
Information Technologies Department
Eldorado Services Group Inc.
http://www.eldoserv.com
[EMAIL PROTECTED]
(330) 861-3009
All your base are belong to us
-
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 PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: FAQ hosting site (was Re: An Idea)
Yes, you need to specify the IP address that you plan on using for this process instead of the computer name. If you use Windows, chances are your using MYODBC or some other similar driver. Case #1: You setup a DSN in the ODBC area of the OS Case #2 You setup a DSN-less connection to your db. Case #2 has actually worked much faster for me. You can just put the IP in your connection code and off you go. Either way, you need to do this because the OS cannot resolve how you want it done. Just to make sure it is two NIC's that is causing your problem, disable one in the IP configuration area and give it a try. If you still cannot connect to your db, then something else may also be wrong. Bruce - Original Message - From: Peter Lovatt [EMAIL PROTECTED] To: mnbv [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:25 PM Subject: RE: FAQ hosting site (was Re: An Idea) Hi Is '111' the IP it is trying to connect on? If so it is an invalid IP. If the IP is valid how are you trying to connect? Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: mnbv [mailto:[EMAIL PROTECTED]] Sent: 02 January 2003 00:23 To: Peter Lovatt; Stefan Hinz, iConnect (Berlin); David T-G; mysql users Subject: RE: FAQ hosting site (was Re: An Idea) I really need your help, I installed MySQL and I can connect to it through localhost but when trying to access it from outside I get: ERROR 2003: Can't connect to MySQL server on 'IP' (111) Any suggestions? Someone suggested that the problem is because the server has 2 nics (2 ips set up). Does anyone know a solution for this? --- Peter Lovatt [EMAIL PROTECTED] wrote: Hi Like the look of the way its taking shape. I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) we could use, or if someone can do a better job :) but I have a content management system written, together with a lot of the search functionality needed for the faq. It can mix database stored content with static content, so it would probably do the job with a little work. It also does the membership authorisation/management. I'd be happy to build the software, if that helps. Let me know Peter --- Excellence in internet and open source software --- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 --- -Original Message- From: Stefan Hinz, iConnect (Berlin) [mailto:[EMAIL PROTECTED]] Sent: 01 January 2003 21:26 To: David T-G; mysql users Subject: Re: FAQ hosting site (was Re: An Idea) David, Sure; it's the least I can do. Look for mysql.justpickone.org to be in the DNS tables by tomorrow. By then the [EMAIL PROTECTED] mailing list will be ready for subscriptions, too. Fine. http://mysql.justpickone.org/ works :) Now, what do we need to do to be able to update this FAQ? I can't create ssh accounts for everyone, but we might arrange ftp Let's set up a PHP thing with MySQL. That's quite fast and easy to do. I could contribute some code. My suggestions (database design): 1. We need an authors table, and everyone who wants to be an author (contributor) can mail you, and you will set up accounts for these persons. The authors table will, of course, be used for database authentification / to update the admin pages. 2. For the actual content, we will need only one table, with question (varchar), answer (text), timestamp and a couple of id's that refer to other tables. 3. For the beginning, I would suggest we only have two more tables: category (installation, privilege system, ..., generally speaking, the main chapters of the manual) and difficulty (beginner, advanced, expert). _Not_ to be edited by the authors, to keep the FAQ smooth and simple. - We can make this more complex when necessity comes, with ratings, automated checks for double entries etc. My suggestions (frontend): 1. For end users, a very simple search. As Jim (JamesD) pointed out, Alkaline could do the job. Then again, Alkaline will search (and before, index) documents, and not databases. For the beginning, I would prefer just a simple input box for the search. 2. Output preferably as html files, i.e. nothing like index.php?cat=installationdifficulty=beginnersearchterm=windows, but rather something like /installation/beginner/windows/1.html. IMHO, this is easier to refer to in a
Re: FAQ hosting site (was Re: An Idea)
Why not try Tek-Tips? Maybe they will sponsor something for free. They may have everything you need. Just a thought. [EMAIL PROTECTED] [EMAIL PROTECTED] Bruce - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Peter Lovatt [EMAIL PROTECTED] Cc: Stefan Hinz, iConnect (Berlin) [EMAIL PROTECTED]; David T-G [EMAIL PROTECTED]; mysql users [EMAIL PROTECTED] Sent: Wednesday, January 01, 2003 6:36 PM Subject: Re: FAQ hosting site (was Re: An Idea) On Wed, Jan 01, 2003 at 11:08:58PM -, Peter Lovatt wrote: I am not sure if there is existing faq software (I've checked sourceforge and freshmeat without much luck) Really? That's a wheel I've seen re-invented many times. I know there's stuff out there. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 3.23.51: up 17 days, processed 617,666,871 queries (401/sec. avg) - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Serwer Hardware p4 or pIII ?
Having the fastest memory that is available in your system is not as important as having enough memory in your system. Without sufficient memory, you can choke your whole system and bring your server to a crawl (or even crash). Bruce - Original Message - From: Nicolas MONNET (Tech) [EMAIL PROTECTED] To: Helmut Apfelholz [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 9:45 AM Subject: RE: Serwer Hardware p4 or pIII ? On Wed, 2002-12-04 at 15:23, Helmut Apfelholz wrote: --- Simon Green [EMAIL PROTECTED] wrote: MySQL uses memory and HDD the most and so processor speed is not so important. Well, processor speed is also important, on some of our servers processors are almost 100% occupied. If your bottleneck is memory speed, you will see 100% CPU usage even if the CPU actually spend 99% of its time idle, waiting for data to come in. I'm not too up to date on the latest RAM technology, but I hear there's several types of DDR, the most expensive one being significantly faster. Or is it? Anyone care to share some insight on this? - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql not working behind linksys router
You may want to check the advanced features of your Linksys router. There may be an IP imposed limit for the MYSQL server to the outside world. It is part of a configuration that you can alter. Check the IP filtering area. Bruce Lewis - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, December 02, 2002 11:04 AM Subject: re: mysql not working behind linksys router Mir, Sunday, December 01, 2002, 5:24:41 AM, you wrote: MSI Hi, apologies upfront since this is not directly a mysql question. I MSI have a mysql host sitting behind a linksys router/wireless ap. The mysql MSI host is configured as a DMZ host in the router. All web/ftp other MSI connections are working fine, however mysql connection from outside the MSI network is not working. Not only that if there is any inbound connection MSI mysql crashes hard and does not accept any connection or process anymore MSI queries. MSI Any idea what could be the possible cause? What OS? What is the MySQL version? Have you installed MySQL from binary or source distribution? MSI Does mysql need other ports ope besides 3306 ? Nope, if MySQL server is running on 3306. MSI Other DB (postgres) and services work fine. Although MSI I had to do some tricky stuff for the same host before I could get MSI proFTPD working for passive ftp. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my host IP changed
It is very possible. Your network may need an update as to what the new IP address is. Most networks take anywhere from 20-30 minutes to get the updates (depends upon your network administrators configuration). Another may be with your code. If you are using ODBC, you may need to change the code in that area as well if you are specifying an IP address. This is for a Windows environment though, but it should be similar to Unix as well. Bruce - Original Message - From: Chris Walcott [EMAIL PROTECTED] To: Mysql-L (E-mail) [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 1:22 PM Subject: my host IP changed I just got mysql up and running (I'm a new user). I'm using it with ColdFusionMX. Just as I was about to bind a database to coldfusion, my IT department decided to move my server to a new IP address. Now I can't get a database to bind to coldFusion and I'm wondering if it's because the IP address changed. Is this something that is stored in the mysql database? If so, how so I change that? I'd rather not have to rerun mysql_install_db. - chris - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: my host IP changed
One other simple task that you can try is to just perform a ping. If you can ping the server with the new IP address, then your network is not the problem. Bruce - Original Message - From: Gelu Gogancea [EMAIL PROTECTED] To: Chris Walcott [EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 2:05 PM Subject: Re: my host IP changed Yes.You can put the new IP address instead of the name (no localhost).When you make update, you must be sure that YOU DON'T REPLACE and the record where the Host field is 'localhost'.You must replace only the record where in Host field is the name of computer/server which must connect to the MySQL. You can use : update user SET Host='YOUR_IP_ADDRESS' where User='YOUR_USER_NAME' and Host='THE_NAME_OF_HOST'; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chris Walcott [EMAIL PROTECTED] To: 'Gelu Gogancea' [EMAIL PROTECTED]; Chris Walcott [EMAIL PROTECTED]; Mysql-L (E-mail) [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 9:52 PM Subject: RE: my host IP changed right now the host field has 2 entries: localhost and newpop (the name of the server). There are no IP numbers. Should I replace the host name entry with the new IP address? thanks! - chris -Original Message- From: Gelu Gogancea [mailto:ggelu;arctic.ro] Sent: Thursday, November 14, 2002 11:47 AM To: Chris Walcott; Mysql-L (E-mail) Subject: Re: my host IP changed Hi, It's possible that in mysql.user table to exist the old IP address of your machine.You should check the field Host using: use mysql; select Host,User from user where User='YOUR_USER_NAME'; If in the Host field you see the '%' character that means your problem is not from MySQL... else you should to update the new IP address in the mysql.user table using update or replace. Finally you must do: flush privileges; Regards, Gelu _ G.NET SOFTWARE COMPANY Permanent e-mail address : [EMAIL PROTECTED] [EMAIL PROTECTED] - Original Message - From: Chris Walcott [EMAIL PROTECTED] To: Mysql-L (E-mail) [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 9:22 PM Subject: my host IP changed I just got mysql up and running (I'm a new user). I'm using it with ColdFusionMX. Just as I was about to bind a database to coldfusion, my IT department decided to move my server to a new IP address. Now I can't get a database to bind to coldFusion and I'm wondering if it's because the IP address changed. Is this something that is stored in the mysql database? If so, how so I change that? I'd rather not have to rerun mysql_install_db. - chris - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with UPDATE table ... can u help plz?
You need an InnerJoin to perform the operation similar to: UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,... INNER JOIN Table1 ON Table2.ID = Table1.ID Bruce Lewis - Original Message - From: STIBS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 4:26 PM Subject: Problem with UPDATE table ... can u help plz? Hi from Dresden, Germany! I have a littlebig problem: I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this case a product number) is the same in both tables. OK, I did this: UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,... WHERE table1.id = table2.id; The answer from MySQL is: Unknown table 'table2' in WHERE clause . Heading to MySQL.com the docs tell me nothing than there is a INSERT ... SELECT. In my case this would be an UPDATE ... SELECT coz I don't want a new table, just updating records of an existing with data from another. I'm sure I just miss the right topic to look at. Point me please. Second try: I used UPDATE table1, table2 SET table1.field1 = table2.field1, table1.field2 = table2.field2,... WHERE table1.id = table2.id; It still gives me an error, now in the SQL Syntax when I set the table1.field2 value. It doesn't find the second tables name [You have an error... near ... table(2.field2 should be here)]. Could someone give me the right direction? TIA! Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with UPDATE table ... can u help plz?
You need to include the field names along with the table name. UPDATE table1 INNER JOIN Table1 ON Table2.FieldID = Table1.FieldID Set Table1.Field1=Table2.Field1, Table1.Field2=Table2.Field2, ... Bruce Lewis - Original Message - From: Greg Knaddison [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 5:15 PM Subject: RE: Problem with UPDATE table ... can u help plz? When I try that modified for my tables that fit this hypothetical, I get: CREATE TABLE `sales_table` ( `item_s` varchar(100) default '', `price_s` varchar(100) default '' ) TYPE=MyISAM CREATE TABLE `lookup_table` ( `item_l` varchar(100) default '', `price_l` varchar(100) default '' ) TYPE=MyISAM mysql UPDATE sales_table SET sales_table.price_s = lookup_table.price_l INNER JOIN sales_table ON lookup_table.item_l = sales_table.item_s; [localhost] ERROR 1064: You have an error in your SQL syntax near 'INNER JOIN sales_table ON lookup_table.item_l = sales_table.item_s' at line 1 The Update Syntax Manual page 6.4.5 http://www.mysql.com/doc/en/UPDATE.html doesn't mention INNER JOIN and the comments on that page seem to indicate that this is a functionality lacking in MySQL though the last comment on the page shows a kluge workaround. Greg -Original Message- From: Bruce Lewis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 16, 2002 4:03 PM To: STIBS; [EMAIL PROTECTED] Subject: Re: Problem with UPDATE table ... can u help plz? You need an InnerJoin to perform the operation similar to: UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,... INNER JOIN Table1 ON Table2.ID = Table1.ID Bruce Lewis - Original Message - From: STIBS [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, October 16, 2002 4:26 PM Subject: Problem with UPDATE table ... can u help plz? Hi from Dresden, Germany! I have a littlebig problem: I want to UPDATE table1.fields with data from table2.fields WHERE the id (in this case a product number) is the same in both tables. OK, I did this: UPDATE table1 SET table1.field1 = table2.field1, table1.field2 = table2.field2,... WHERE table1.id = table2.id; The answer from MySQL is: Unknown table 'table2' in WHERE clause . Heading to MySQL.com the docs tell me nothing than there is a INSERT ... SELECT. In my case this would be an UPDATE ... SELECT coz I don't want a new table, just updating records of an existing with data from another. I'm sure I just miss the right topic to look at. Point me please. Second try: I used UPDATE table1, table2 SET table1.field1 = table2.field1, table1.field2 = table2.field2,... WHERE table1.id = table2.id; It still gives me an error, now in the SQL Syntax when I set the table1.field2 value. It doesn't find the second tables name [You have an error... near ... table(2.field2 should be here)]. Could someone give me the right direction? TIA! Michael Stibane (STIBS) [EMAIL PROTECTED] Training, Linux, Admin, Programming, Web http://www.stibs.cc Escapade Server-Side Scripting Engine Development Team Pensacola - Dallas - Dresden - London http://www.escapade.org - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: startup on win2000 as service not working.
Check your ini file to make sure the path reflects the proper location of the database. Bruce - Original Message - From: Steve Bradwell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 8:14 AM Subject: startup on win2000 as service not working. Hi everyone, I have recently moved my mysql server from a win98 machine to a win2000 machine. After running the self extracting setup for mysql, I copied my existing my.ini file over from the win 98 box, made neccesary changes to start mysqld-max-nt from correct dir, I copied the my.ini file because of the Innodb settings I had setup on the win98 machine. I then copied over my Ibdata, and IbLogs directories and their contents to the win2000 box, and the replaced the data directory with the one from the 98 box. I then started mysql from the command prompt with mysqld-max-nt --console it said ...Innodb: Flushing modified pages from the buffer pool... Innodb: Started Ready for connections... And all works fine, however when I restarted the pc, and winmysqladmin.exe was started as a service, the server is not started, I get the red light and no server, or table information. If I then go and start it through the console and run winmysqladmin.exe All my information appears like normal. Can anyone suggest what I should do? Thanks alot, Steve. - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: access denied ????
I don't know how you have your system configured, but mine has the root only functional on the localhost. Bruce - Original Message - From: toby - [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, September 23, 2002 9:22 AM Subject: Re: access denied thnx gerald but i still dont know what to do to fix this thing up will someone pleez enlighten me on how to thnx a million ... toby . From: gerald_clark [EMAIL PROTECTED] To: toby - [EMAIL PROTECTED] CC: [EMAIL PROTECTED] Subject: Re: access denied Date: Mon, 23 Sep 2002 09:02:55 -0500 mysql does not own its files. toby - wrote: ok guyz im lost im creating my tables and after i ve created em i tried to change two of the fields to FULLTEXT and this is what i get : Database zabanDb running on localhost Error SQL-query : ALTER TABLE `ctnt_inf` ADD FULLTEXT(`summary`) MySQL said: Error on rename of '.\zabandb\ctnt_inf.MYI' to '.\zabandb\#sql2-5b0-7e.MYI' (Errcode: 13) ACCESS DENIED ! ! ! ! ! what the hell is rong with this thing ? cud anyone help me plz _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Filemaker database to MYSQL
I have not done this, but I know you can do it in a round-about way. You can download the MSDE from Microsoft and convert it to one of numerous db formats, and from there MYSQL will import it. Filemaker Pro 5.0 with their ODBC driver is needed though. FMP is not 100% ODBC compliant, but you should be able to export your data. Another catch to this is that when you perform the export with the ODBC connection, the FMP database will actually have to be open and shared for it to work properly. I just converted such a database into the M$ arena, and it was a pain in the you know where. Bruce - Original Message - From: Brian Leyland [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 4:46 AM Subject: Filemaker database to MYSQL Has anyone created a plugin or script that will allow me to convert my filemaker database to MYSQL Thanks Brian Leyland - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: stupid error, please kick me (and send me a solution)
Your missing your closing } at the end of the else statement.
- Original Message -
From: Jule Slootbeek [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]; php-general
[EMAIL PROTECTED]
Sent: Monday, June 03, 2002 5:09 PM
Subject: stupid error, please kick me (and send me a solution)
Hey guys,
i'm getting this error with the following sql script using php:
--error--
Warning: Supplied argument is not a valid MySQL-Link resource in
/var/www/phpquiz/register_user.php on line 12
--error--
--script--
$link_glob = mysql_connect('$host_glob', '$un_glob', '$pw_glob');
$query = INSERT INTO user values('0', '$fname', '$lname', '$email',
'$username', PASSWORD('$password');
$result = mysql_db_query('$db_glob', '$query', $link_glob');
if (!$result) {
echo font size=+1Your Information could not be entered into the
database,
Please contact the a
href=mailto:$webmasterwebmaster/a./fontbrbr . mysql_errno() .
: . mysql_error() . brbr;
} else {
echo font size=+1Your Information has successfully been entered into
the
database!/fontbr;
--
Jule Slootbeek
[EMAIL PROTECTED]
http://blindtheory.cjb.net
-
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 PROTECTED]
To unsubscribe, e-mail
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
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 PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: functions
Actually, W2K has a scheduler built in that works pretty well for basic scheduling needs. If you are using NT 4.0, try and upgrade to SP6a. That SP has the scheduler of W2K built in as well. Bruce - Original Message - From: Opus [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, April 22, 2002 3:17 PM Subject: Re: functions For NT and 2000 machines, use the AT command if you want a command line scheduler. The syntax is actually different between them though. I found that it is actually easier to schedule a process to schedule other processes instead of having the process schedule itself again. The FOR command in Batch files works REALLY well for that! On 22 Apr 2002 at 6:47, Rodney Broom wrote: Good morning Daniel, From: Daniel Jarrett [EMAIL PROTECTED] ...for mysql to perform daily operations.. You bet, it's called 'cron'. MySQL doesn't have anything like scheduling built in. And, arguably, it shouldn't. Since that type of functionality is the responsibility of the operating envoriment and not of the application. If you are using a UNIX like OS, type 'man cron'. If not UNIX, hollar and I'm sure that somebody can tell you how to work it out on your system. --- Rodney Broom sql --Opus-- Why program by hand in five days what you can spend five years of your life automating? - Terence Parr Get added to my Humor list: mailto:[EMAIL PROTECTED]?subject=ADD_HUMOR Get added to my Neat list: mailto:[EMAIL PROTECTED]?subject=ADD_NEAT Get my PGP public key: mailto:[EMAIL PROTECTED]?subject=PSENDbody=send%20PublicKEY.asc Visit My Home Page: http://value.net/~opus/ - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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 PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
