Search found 5 matches

by sknelson
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...
by sknelson
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...
by sknelson
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 ...
by sknelson
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.
by sknelson
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...