Hi

A couple more questions please. I did a upgrade from 5.9.3 to 7.4.6. I get a error on the dynamic display below. Is this feature still valid or easily updated?

Microsoft JET Database Engine error '80040e10'
No value given for one or more required parameters.
/dynamicdisplay.asp, line 136

Next issue is since the upgrade the icons are messed up and you cant click either "add to cart" or checkout"

Thank you;
Praetorian

Hi Praetorian
I think for the unclickable buttons you need to look at this...
https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107040

And for the dynamic display, could you post from a couple of lines previous to that line?

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Tnx. I will checkout your link you sent me But the database error prevents any purchasing. I pasted text the the source code from that page. No other text is displayed on this main page except this error. If you needed something more please direct me.

<td colspan="2" bgcolor="#F0F0F0">
<img src="images/clearpixel.gif" width="1" height="1"></td>
</tr>
<tr>
<td bgcolor="#F0F0F0" colspan="2">
<p align="center"><!-- System9 dynamic front page V3.0 - display variables START -->


<!-- System9 dynamic products - display variables END -->
<font face="Arial" size=2>
<p>Microsoft JET Database Engine</font> <font face="Arial" size=2>error '80040e10'</font>
<p>
<font face="Arial" size=2>No value given for one or more required parameters.</font>
<p>
<font face="Arial" size=2>/dynamicdisplay.asp</font><font face="Arial" size=2>, line 136</font>


Scott

Hi, I'm pretty sure Vince was asking for the lines of code from that page, not the source of the error page.
Open dynamicdisplay.asp in your html editor and list the lines of code leading up to line 136.

It does appear to be some sort of mod and not part of the ect package, so you may need to remove the mod, or ask the provider for an update.

quote:

---

System9 dynamic front page V3.0

---

It's also possible that the function of that "dynamic front page" is also now a native feature.

Thanks,
David

Oh sorry I read his request too fast. I pasted that code below. This does have Vince as the creator of this mod.

Else
shuffle = true
s9SQL = "SELECT products.pId, products.pName, products.pDescription, products.pSection, products.pImage, products.pPrice, products.pListPrice, " & _
" products.pDisplay, products.pSell,pIsMap " & _
" FROM products where pSection = "&cat&" and pDisplay=1"
End If
End If


Scott

Hi Scott
The problem seems to be that the MOD is pulling the pImage column from the products table where about a decade ago changes were made to allow for unlimited product images and they were all put in a separate "productimages" table. The MOD would have to be updated to allow for the changes, but maybe it would be better to use for instance the "Cross Sell" feature which is pretty flexible and is always maintained?
https://www.ecommercetemplates.com/ectstore/cross-selling.asp
You can use the Cross Sell feature to show "recommended" products which will be ones you choose to mark in the product admin.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

OK I did get the cross selling working. I do want to as I assume its a CSS how to format the way it looks on the home like the dynamic display did. image uniform size with boxes in a grid?

The site is down now because after the update the format of my cart is wrong and when you click on add to cart when you click it nothing happens so transactions cant be done. Id greatly appreciate your help with this so I can back to business?


Thank you;
Praetorian

quote:

---

The site is down now because after the update the format of my cart is wrong and when you click on add to cart when you click it nothing happens so transactions cant be done. Id greatly appreciate your help with this so I can back to business?

---

Actually Vince addressed that in his first reply.
You must link your pages to the external js and css files, and be sure those are uploaded to the server.

quote:

---

I think for the unclickable buttons you need to look at this...
https://www.ecommercetemplates.com/support/topic.asp?TOPIC_ID=107040

---