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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Blue Sky Search won't return results from database

Thread began 8/04/2015 4:14 pm by tmcbinc99963 | Last modified 8/11/2015 4:16 pm by Ray Borduin | 537 views | 9 replies |

tmcbinc99963

Multiple issues with DataAssist Pages Wizard, Search Wizard and Blue Sky sample files

Tried to use the Search Wizard on my own, with no success generating results data. Downloaded the Blue Sky sample site and followed the DataAssist Search and Result tutorial. Can't get any results to show up on the Results page there either. Files are attached.

Other issues:

+ button isn't clickable when adding columns to pages in Pages Wizard.

Mac DW CC crashes repeatedly when creating Search and Result pages using the DataAssist Pages Wizard.

The few times the Wizard has finished without crashing, the Results page is created but the Search page is blank.

Recordsets have continually disappeared. Read a post on how to fix with no success.

Thanks

Sign in to reply to this post

Ray BorduinWebAssist

What version of the extension are you using? What version of Dreamweaver? What OS?

Sign in to reply to this post

anonymous

OS 10.8, just bought latest Data Bridge, DW CC

Sign in to reply to this post

Ray BorduinWebAssist

It looks like you are using the catSearch select list and comparing the value to the ItemID column in the items table.

It seems like it should be the ItemCatID column? I don't know your database design but it may just be updating the proper column on line 16 of the Results page.

Sign in to reply to this post

anonymous

This uses the web assist search/result tutorial blue sky files and database. The search record set uses item category table and results record set uses items table. Should they both use the same table?

Sign in to reply to this post

Ray BorduinWebAssist

They can use different tables, but they have to refer to the correct associated (joined) field that represents the foreign key. The ItemID column is the unique ID for the items table, and the catSearch select is populated with the unique ID of the categories table. There has to be a joined column in the Items table that identifies the category the product is in that is used to compare against the category id passed from the search.

Sign in to reply to this post

tmcbinc99963

Blue Sky Tutorial and related files issues

The Results page shows no results when testing in browser. Doesn't even return 'No Files Found' statement. Files attached.

I've been following the tutorial on the website.

Thanks

Attached Files
bluesky.com.zip
Sign in to reply to this post

tmcbinc99963

PM

Sign in to reply to this post

Ray BorduinWebAssist

It looks like the entire results table is wrapped in a "Show if recordset is empty" server behavior. Which means if there are results, none will be displayed.

It should just have that applied around the "no records found" message and the table should have the opposite "show if recordset NOT empty"

Sign in to reply to this post

tmcbinc99963

That fixed the problem. Thanks.

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