close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Data Search

Thread began 10/11/2019 11:39 am by vernon webb | Last modified 10/15/2019 11:31 am by Ray Borduin | 51 views | 8 replies |

vernon webb

Data Search

I have added one new field (metro_area) to a page for a data search and then inserted two new columns on a page that I want to do a search for:

metro_area, meatro_area2

The search field I called metro_area but when I open the DataAssist Search dialog box the columns added (metro_area or metro_area2) do not exist as an item to select as a field from the database. There is indeed on there as it is actually being displayed on the page.

Sign in to reply to this post

Ray BorduinWebAssist

Dreamweaver is connecting to your testing server database to show the list of columns... maybe the columns weren't added there?

I think you might have had some custom search code added.... it may not be safe to edit it in the Server Behavior anyway.

Have you looked at the search code on the page? It would probably be pretty easy to copy and paste code from another field to add the search values for the new fields.

Sign in to reply to this post

vernon webb

How can that be when the DB set to localhost?

Sign in to reply to this post

Ray BorduinWebAssist

It uses the URL listed in your Dreamweaver site definition. Localhost means different things depending on the server url it is browsing, which is determined by the testing server url listed in your Dreamweaver Site definition.

Sign in to reply to this post

vernon webb

I'm sorry but I'm not following. The test server is gone, the new server is the only one up now and it's pointed at rsavvy.com. New changes to pages are being displayed t he only thing not working right is the update part of the EXT. If I look at the table, by attempting to create a new recordset the table fields are there.

Sign in to reply to this post

vernon webb

Please don't forget me because I'm kind of dead in the water here

Sign in to reply to this post

Ray BorduinWebAssist

I may have to do screen sharing to debug. Dreamweaver could be caching the data. Have you tried going to the Database panel and clicking "test"? That should cause a refresh. Other than that, it should be using the testing server settings to connect to the database and show the data. If you post your site definition file and steps to reproduce, then I can add your site to my Dreamweaver and see the issue.

The key to getting my help is allowing me to reproduce the problem. Once I do that, then I can usually fix it provided I have access to the files I need.

Sign in to reply to this post

vernon webb

Ray, you've worked on the site many times, I'm sure you have access at this point. LOL

Sign in to reply to this post

Ray BorduinWebAssist

I added the search filter for that column. Did you scroll down on your list of columns in the screen shot? I found the new columns at the bottom of the list. I added them as includes filters so you can enter any part of the metro area. Please download the results page for your records.

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