Search / results not working properly

Hi,

I get this issue sometimes with a DA results page with search function on it, where the results section wont display any results. if i move the recordset behaviour above the DA Search behaviour the results show ok, but the search just returns all records all the time.

Can you advise on what's wrong with the attached?

thanks

You should definitely leave the page the way it was after applying the DataAssist Search server behavior, like you noted you will just get all of the results if the Search server behavior is not applied to the recordset.

It looks like your search criteria is setup with all 'AND's and the separators, this means that you will have a very restrictive search, it will only return results when all of the search terms match for one or more record.

I think you should start with your Search server behavior criteria, you should try to remove all but one and test it out. When you get positive results with that then you can move onto the next criteria until it is built up the way that you would like it.

ok.

you'll see from previous documentation way back that there is a date issue with dd/mm/yyyy format that was never able to be resolved - when using DA if i put in dd/mm/yyyy it stores as mm/dd/yyyy, depsite every attempt to force/tell it to use uk date format.

webassist could never solve it so i have to use the DW insert record behaviour sadly. (presume no one ever came up with a solution to that one..?) which is ok until i add a Dig File Pro upload and then all Request.Form's have to be changed to WA_DFP_UploadObj.Form etc etc.



in doing so, the DW insert behaviour disappears from view in the server behaviour panel and i cannot edit it from there.

i'l suffer all that but i'm stuck with the fact that i cant get the file to upload and the record to insert. the upload behaviour sends the file ok, and the insert record behaviour adds the record but it doesnt add the image name to the image field - can you advise clearly on what to change in the insert page as i have this as a perennial problem.

also, i will have to do the same to the update page. pls advise on what to change there similarly.


thanks

file attached

On the insert page on line 57 you have this:

MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 255, WA_DFP_UploadObj.Form("actorimg")) ' adVarWChar

You should open this page and select the following part of this line:

WA_DFP_UploadObj.Form("actorimg")

Then go to the bindings and drag the binding for The Uploaded File - Server File Name into this highlighted part of the code.

On the update page highlight this line part of the code on line 34:

Request.Form("ActorImg")

Then do the same as you did on the insert page and drag the server file name binding to this highlighted code. This should replace the code with the code for the server file name on both of these pages. This should get the insert and update server behaviors to add and update the file's name.

As for using the DA insert and update server behaviors have you ever tried using the ASP function for SwitchMonthDay? I'm including the code for this attached to this post.