close ad
WARNING: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Search / results not working properly

Thread began 5/05/2010 2:08 pm by russell298997 | Last modified 5/07/2010 9:03 pm by Eric Mittman | 961 views | 3 replies |

russell298997

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

Attached Files
tblActors_Results.zip
Sign in to reply to this post

Eric Mittman

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.

Sign in to reply to this post

russell298997

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

Attached Files
tblActors.zip
Sign in to reply to this post

Eric Mittman

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.

Attached Files
switchMonthDay.zip
Sign in to reply to this post

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