Search found 5 matches
- Thu Jun 27, 2002 3:47 pm
- Forum: Databases
- Topic: Problems with NULL value in MySQL data when using PHP Form
- Replies: 5
- Views: 3348
I think I've figured it out
I decided to stick with the Access module that left all the values empty rather than the one that placed NULL in the fields. This allowed my query to work. I added the following to the end of the code in the Access module: Print #1, "UPDATE " & tname & " SET DELIVERY_D=NULL WH...
- Tue Jun 25, 2002 5:52 pm
- Forum: Databases
- Topic: Problems with NULL value in MySQL data when using PHP Form
- Replies: 5
- Views: 3348
Replacing the AND's with OR's just returns all the records, so that didn't work. I have tried splitting the query a couple different ways, but never got it to work. That is how I run a similar query in MS Access. The database is fairly small, only about 400 records at any one time. It is just the wo...
- Fri Jun 21, 2002 5:19 pm
- Forum: Databases
- Topic: Problems with NULL value in MySQL data when using PHP Form
- Replies: 5
- Views: 3348
Problems with NULL value in MySQL data when using PHP Form
I have a PHP form that users can enter a value in one or all of three fields to search for information. The problem is that the code I use to convert the data from MS Access to MySQL places "NULL" in the field. So, if one of the search fields has a "NULL" value, it won't pull up ...
- Mon May 20, 2002 9:57 am
- Forum: Databases
- Topic: Date returned as 00/00/0000 rather than blank
- Replies: 4
- Views: 7300
Different script solved the problem
I downloaded ExportSQL script from http://www.cynergi.net/exportsql/ and it worked great! It puts "Null" in as the value rather than leaving it blank and that took care of my problem. Thanks for the help.
- Thu May 16, 2002 2:56 pm
- Forum: Databases
- Topic: Date returned as 00/00/0000 rather than blank
- Replies: 4
- Views: 7300
Date returned as 00/00/0000 rather than blank
I run a macro in a Microsoft Access database to convert the data to MySQL. If a date field is empty in Access, it remains empty in the "Insert Record" code that is created by the macro, but when I insert the text file into MySQL, the date is changed to 00/00/0000. When I query the data and...