DA Search Wizard & Insert Multiple Records (ii)

Jason:

I inserted a second form in the DA Search page whose problem you solved in a previous ticket so that the Insert Multiple Records behavior could work well, and it does. But now the results table is once again keeping data from any previous search and it even shows data when the page initially loads.

I've placed the line of code you sent right after the </html> tag, but the page disregards it. All the behaviors included in the page are working fine (search, display, insert), except that the results table is again showing unwanted data.

If you wished to check out the problem live, please use the same information I placed in the recent ticket, except that this time please select Sal in the User Name field. All other info is the same (passwords, host name, etc.)

Thank you for your attention.

please send a copy of the search and results pages.

Jason:

Attached please find a copy of the Search/Results/Insert Page

Thank you for your attention

your page does not have the default where clause set.

this will cause it to show all records on initial load.

Set the default where clause in the Data Assist Search to 0 != 0

Jason:

How does it feel to be a Cyber-Druid?

Many thanks for your help

Originally Said By: salaroche

  Jason:
How does it feel to be a Cyber-Druid?  

So true! lol

LOL, Cyber-Druid, I like that ;)

Off to find my cloak and staff now...

Jason:

Glad you enjoyed the imagery. I think it's well deserved. But it so happens that after I moved around some elements in the search/results/insert page in question, the Insert Multiple Records behavior no longer wants to accept the input date format and it gives me the following error message:

- Incorrect date value: '26-10-2012' for column 'date' at row 1 -

I've inserted the following lines of code on line one, but the insert behavior still doesn't respond. Any suggestions?

<?php
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_POST['date2'] = "".((isset($_POST["date2"]))?date("d-m-y", strtotime($_POST["date2"])):"") ."";
}
?>

Just in case, attached please find a copy of the search/results/insert page in question.

Thank you for your attention.

you can use the m-d-Y format for dates. the format must be Y-m-d


change:
$_POST['date2'] = "".((isset($_POST["date2"]))?date("d-m-y", strtotime($_POST["date2"])):"") ."";


to:
$_POST['date2'] = "".((isset($_POST["date2"]))?date("Y-m-d", strtotime($_POST["date2"])):"") ."";

Jason:

The code I have is:

<?php
if($_SERVER["REQUEST_METHOD"] == "POST") {
$_POST['date2'] = "".((isset($_POST["date2"]))?date("Y-m-d", strtotime($_POST["date2"])):"") ."";
}
?>

But I still get the error message... What am I not doing right?