Re: Path information into database

2007-05-11 Thread JamesDR
Brian E Boothe wrote: so how would i get the Actual file path to the folder into the database, i know ill have to use a file selector in asp / php but i wanna select the folder not the Files, it would be really great if u could help me with these issues, i'm not asking u to Code anything for

Re: NOT NULL = Not Working?

2007-05-09 Thread JamesDR
Scott Baker wrote: If I create the following table, and then try and insert the following data both inserts work. It looks like the second one works (it shouldn't because Last is NULL) because it assumes Last = ''. Is there a way I can make it NOT assume that? If Last is not specified it

Re: NOT NULL = Not Working?

2007-05-09 Thread JamesDR
JamesDR wrote: Scott Baker wrote: If I create the following table, and then try and insert the following data both inserts work. It looks like the second one works (it shouldn't because Last is NULL) because it assumes Last = ''. Is there a way I can make it NOT assume that? If Last

Re: Transaction/locking confusion

2007-03-13 Thread JamesDR
Marcus Bointon wrote: Hi, (repeat posting) I have a simple PHP function that initialises a process definition. To prevent it happening more than once, I'm wrapping it in a transaction, however, it doesn't seem to be working and I get multiple initialisations. In pseudocode: BEGIN;

Re: binary into blob

2007-03-07 Thread JamesDR
Ed wrote: On Wednesday 07 March 2007 19:28, Jay Pipes wrote: Is there a specific reason you want to store this in a database? Why not use the local (or networked) file system and simply store the metadata about the PDF in the database? Cheers, Jay Hi Jay, Could you explain what you

Re: Argh! Another Server Has Gone Away

2007-03-01 Thread JamesDR
Kévin Labécot wrote: Le 21 févr. 07 à 14:17, Kévin Labécot a écrit : Hi, I know this problem is already on forums and archives but I don't understand mine ! My MySQL Server works well, there are many scripts and website using it, without any problem. Since few days I'm working on a new

Re: MySQL Data Vanishing with FireFox

2006-12-28 Thread JamesDR
Matt Neimeyer wrote: I think it's your PHP application; how did you debug your application? All this is doing is letting our customer add their contacts to the database. This is on the quick add form and asks them to enter a first and last name and an email. I debugged by re-writing it

Re: Windows Server Configuration

2006-08-25 Thread JamesDR
David Lazo wrote: I'm sorry to bother you again with this. So we have the server but we have 4 Drives and now that I'm trying to set up the RAID10 I'm starting to think I needed 5 Drives one for the OS?. Please advise. David. snip We built one pretty close to this recently. You

Re: Windows Server Configuration

2006-08-22 Thread JamesDR
David Lazo wrote: We want to get: Windows Server 2003 R2, Standard x64 Edition 2- Dual Core Intel Xeon 5080, 2x2MB Cache, 3.73GHz, 1066MHz FSB 8GB 533MHz (8x1GB), Dual Ranked DIMMs 3- 146GB, SAS, 3.5-inch, 15K RPM Hard Drives What would be the recommended RAID configuration settings for a

Re: Multiple Entries

2006-06-26 Thread JamesDR
Nicholas Vettese wrote: If I have a multiple choice on a form and want to store that in my DB, then how should I set up my table? I have been reading up on these, but everyone seems to have a different opinion on how to accomplish this task. What I am looking to do give the user a few options

Re: DateTime limits

2006-06-06 Thread JamesDR
Duncan Hill wrote: On Tuesday 06 June 2006 15:38, [EMAIL PROTECTED] wrote: Quoting Barry [EMAIL PROTECTED]: Well my msql doesn't give me any errors using that query. neither a warning. Ditto. usemysql use test; Database changed mysql CREATE TABLE a ( t TIMESTAMP ); Query OK, 0 rows affected

Re: Moving from PowWeb to Rackspace

2006-02-06 Thread JamesDR
Brian Dunning wrote: I have a bunch of databases - some are really big, 2GB - on a number of different accounts at PowWeb. I am buying a Rackspace server and want to move everything over -- hopefully all in one night. Can anyone suggest the best way to do this? Would it be to use the Export

Re: Memory problems?

2006-02-01 Thread JamesDR
Rohit Peyyeti wrote: Thanks for your quick response. Another question: So, what you are saying is that sum of the memory (RES - 20m) of all the mysql processes shown with the 'top' command is not total memory occupied by mysql server? Like 22 threads*22m = 440MB? Also, any idea why this

Re: DB Tables on separate hardisks

2006-01-26 Thread JamesDR
Melvin Zamora wrote: Hi MySql, Would it be possible to have the PK tables on hardisk-A and FK tables on hardisk-B using only one database? to envision: CUSTOMER_MYSQL_DB CUSTOMER_TBL {PK} [HD-A], CUSTOMER_PURCHASES_TBL {FK} [HD-B] -Melvin

Re: Right platform for huge db with huge RAM

2006-01-20 Thread JamesDR
Martins wrote: Hi! I'm trying to figure out which platform to use on my new server. Server's primary and almost only role is mysql, huge databases (can grow up to terabyte or so), so I'm considering enough big ammount of RAM which probably allso will grow over 4GB, so at this point I think

Re: Cleaning illegal characters from varchar field

2005-12-21 Thread JamesDR
Nathan Gross wrote: snip I get two lists from different sources which I merge into the database via a Java program. Since these two lists themselves sometimes get their data from the same source, my program first does a SELECT on the varchar field (unique index) [to ensure that this data is

Re: Can foreign keys reference tables in another database?

2005-12-16 Thread JamesDR
Scott Plumlee wrote: sol beach wrote: Why in the world are you trying to keep multiple copies of the data? Why can't you just access the 'master database'? On 12/16/05, Scott Plumlee [EMAIL PROTECTED] wrote: I am trying to maintain one master list of countries and the states within those

Re: important! help plsss

2005-12-02 Thread JamesDR
Umit tas wrote: hello i'm umit Tas; i have a problem. i'm writing programme in visual basic 6.0 but i must use MySQL server. i'm installed MySQL server and executing my program (no problem) but my problem is : MySQL must be installed A computer and my programme must be installed B

Re: Trojan Horse in MySQL

2005-12-01 Thread JamesDR
Anthony Ettinger wrote: hmmm...google is null on that one too. I'd suspect that it's just a false positive, in other words, better to be safe than sorry from Norton's point of view. On 12/1/05, Gary [EMAIL PROTECTED] wrote: I have installed Apache PHP and MySQL over a year ago on a WINXP

Re: Problem of VB with MySQL

2005-11-16 Thread JamesDR
vishal wrote: i am sending the files. all details are in the source code what you have to do is to create a database name test2 and have to set the password of the server. the code will automatically create a table name test2 with two double fields and it will reture the error while adding the

Re: MSSQL-MySQL Compatibility Question

2005-10-27 Thread JamesDR
J.R. Bullington wrote: Hi All, Quick question -- I have a client who co-owns a server with me. I am a die-hard MySQL guy, they are MSSQL. They have some proprietary Access-frontend/MSSQL-backend financial system that they want to continue to use (i.e. pigheaded and won't convert). Can

Re: Full text search

2005-10-04 Thread JamesDR
Merlin wrote: Hi there, I am facing problems with fulltext search on MySQL 4.0.18 Problem is, that words which are not seperated by space are not found. Example: A search for dsl will not find DSL-Modem I looked it up on mysql.com help, but despite the fact that this is not seperated by space

Re: Populate values in an Excel sheet from MySQL

2005-09-01 Thread JamesDR
Nick Jones wrote: Does anyone know if it is possible to populate values into an Excel spreadsheet from a MySQL database? Can I do this directly in Excel or do I need to create an external program to do the work (i.e. in VB). Thanks -Nick __ Do

Re: Seeking Backup Strategy

2005-08-03 Thread JamesDR
Scott Purcell wrote: Hello, After many months of preparation, I am finally going to go live with a project I have created. It is your basic e-commerce site, where I need to make sure I have a current backup, specifically on the orders placed, etc. I am going to run the mysql server on a PC

Re: Complete server lock

2005-07-29 Thread JamesDR
Ben Clewett wrote: Jigal, Thanks. I can confirm that there were no domains used for our permissions. All IP based. Although this may have been the cause, I don't think it was in this case. I think as well that DNS timeouts are in the region of 20 seconds to 2 minutes. Would any person

Re: Network drive

2005-07-06 Thread JamesDR
Ruben Carvalho wrote: Well, thank you very much for your explanation. My problem is I would like to have the data files being saved in a machine behind a proxy but the server running in a machine outside the proxy (the clients don't have access to the machine behind the proxy). Any ideas?

Re: Help me for God!!

2005-06-29 Thread JamesDR
Carlos J Souza wrote: Dear Friends, Iam trying to install MySQL 4.1.x in Windows 2003 Server, and on error occurs when installation try a start de service. The service does not start and installation don't finish. I Try install and reinstall many times and all fail My WIndows is a 2003

Re: Help me for God!!

2005-06-29 Thread JamesDR
Carlos J Souza wrote: The error as follows: when installation is try to finish, the install try a start de new service MYSQL 4 and does not success I try the install and reinstall many times and nothing. Regards On Wed, 29 Jun 2005 08:39:51 -0400, JamesDR wrote: Carlos J Souza wrote