Okay I hope my title is not confusing. I have two checkboxes names Delete[] and Update[] followed by a textbox named Name[]. When I tick checkbox Delete[] and click Submit, I ran a query to delete the data based on that Checkbox's value (which I have set to be the primary key of the record) and it worked fine. My problem started when I tried to do the same thing with my Update[] checkbox. After looking thru some forums I found the explanation I've been looking for: "Remember that in the POST data all of the textboxes will always be …

Member Avatar
Member Avatar
-1 forum 4

Hi, I have a data, employee attendance record with following format > 01-0002,I,4/21/2014,07:34:00 01-0002,O,4/21/2014,18:09:00 01-0002,I,4/22/2014,07:47:00 01-0002,O,4/22/2014,18:09:00 01-0002,I,4/23/2014,07:54:00 01-0002,O,4/23/2014,18:07:00 where I is in and O is out The table contains lots of records for this saves records from the start how can i search a record with no In or no Out from the date range specified? I need to create a report for those employees with no In but with Out, or with In but no Out. Another report needs to generate percentage of lates (individually or all) For now this is the query I used but no luck query …

Member Avatar
Member Avatar
+0 forum 6

Hello to everyone. I have this table: CREATE TABLE `documents_category` ( `id` int(11) NOT NULL AUTO_INCREMENT, `parent_id` int(11) NOT NULL, `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL, `description` text COLLATE utf8_unicode_ci NOT NULL, `active` varchar(255) COLLATE utf8_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci; I am trying to create a qyery that gives me: `(subcategory id, subcategory title, category title)` The categories has the `parent_id = 0`

Member Avatar
Member Avatar
+0 forum 2

I was wondering if there is any way to do a single mysql query to do a count of filled positions in a multi-level structure to an indefinite depth. That sounds a bit cryptic, but this is what I would like to do if it is at all possible. we are working within a 3 x ___ matrix meaning level 1 has 3 positions level 2 has 9 positions level 3 has 27 positions and so on... If a sponsor wants to know how many positions are filled within his downline I would like to be able to provide that …

Member Avatar
Member Avatar
+0 forum 5

hello :) i'm using MS access as a database of my Windows form application. i'm having problem with create table query, with variable table name. i have tried, but it din't work, as i tried. plz provide an example that can make me understand. suppose, string city = "newyork"; and city should be the name of table in example. Thanks :)

Member Avatar
Member Avatar
+0 forum 3

The End.