close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

DA Search Wizard & Insert Multiple Records (ii)

Thread began 10/24/2012 4:49 am by salaroche | Last modified 10/26/2012 1:03 pm by salaroche | 1301 views | 11 replies |

salaroche

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.

Sign in to reply to this post

Jason ByrnesWebAssist

please send a copy of the search and results pages.

Sign in to reply to this post

salaroche

Jason:

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

Thank you for your attention

Attached Files
SalarocheAddAttRex(b).zip
Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

salaroche

Jason:

How does it feel to be a Cyber-Druid?

Many thanks for your help

Sign in to reply to this post

JamieEff

Originally Said By: salaroche
  Jason:
How does it feel to be a Cyber-Druid?  



So true! lol

Sign in to reply to this post

Jason ByrnesWebAssist

LOL, Cyber-Druid, I like that ;)

Off to find my cloak and staff now...

Sign in to reply to this post

salaroche

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.

Attached Files
SalarocheAddAttRex(3).zip
Sign in to reply to this post

Jason ByrnesWebAssist

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"])):"") ."";

Sign in to reply to this post

salaroche

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?

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...