Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › SiteAssist and DataAssist: Solution Recipe Files (1,924 KB)

SiteAssist and DataAssist: Solution Recipe Files (1,924 KB)

Thread began 10/07/2012 2:04 pm by thehalpeen319342 | Last modified 10/11/2012 3:21 pm by Jason Byrnes | 3166 views | 13 replies |

10/07/2012 2:04 pm | #1 thehalpeen319342

SiteAssist and DataAssist: Solution Recipe Files (1,924 KB)

Dear Jason, I am having a look at this recipe I have unlocked the files, but when I try to add a product to the database, it adds it to the Database, but the item doesn't appear in the search. Also how could I change the display to show two columns instead of three in the file products.php ?

10/09/2012 10:44 am | #2 Jason ByrnesWebAssist

I dont follow, what do you mean by:
"but the item doesn't appear in the search"

what is the item that was added, and what are you searching on?

To change the layout of the products page, you use Dreamweaver's design view to modify the layout.

10/09/2012 11:25 am | #3 thehalpeen319342

Dear Jason, I added some products - CD's Gear and I created a category called DVD's. I added products via insert products. When I did a search, only one of the products appeared in the search results - any reasons?

10/09/2012 11:50 am | #4 Jason ByrnesWebAssist

what where the search criteria, based on the info you have provided, my only guess is that the other products did not match the criteria you where searching for.

10/10/2012 5:27 am | #5 thehalpeen319342

Jason, I have attached screenshots of the search and results pages (the search and results pages.pdf. I have also attached the tables (the mysql Tables Pages 1 and 2.pdf).

Attached Files

The mysql Tables Page 2.pdf

The mysql Tables page 1.pdf

the search and results pages.pdf

10/10/2012 8:13 am | #6 Jason ByrnesWebAssist

send a copy of the search and results pages please.

10/11/2012 6:11 am | #7 thehalpeen319342

Attached are files as requested

Attached Files

For_Jason.zip

10/11/2012 10:06 am | #8 Jason ByrnesWebAssist

to help troubleshoot, add the following code on the products page after the <body> tag:

php:

<?php echo("SAL: ".$query_limit_WADAitems."<br />"); ?>

this will write the search SQL to the screen, post that back please.

10/11/2012 1:46 pm | #9 thehalpeen319342

Is this where I insert it - under the grey (non-editable) area - see attached screenshot

10/11/2012 1:51 pm | #10 Jason ByrnesWebAssist

ok, so after adding the code, i need you to run a search and report back the SQL that is written to the page.

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.