|
apswater
VP-CART Super User
444 Posts |
 Posted - July 24 2017 : 10:53:00
|
Here is another handy mod. I like to have the catalog number show up in the meta title since people search for the catalog number more than just the product name.
In shopheaders.asp around line 197 find :
response.write value
Change it to :
if request.servervariables("script_name")="/shopexd.asp" then
dim oconnts,mysqlts,rsts,ccode
Set oConnTs = Server.CreateObject("ADODB.Connection")
oConnTs.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=(your database path and name)" ''ie:d:\database\blah blah blah.mdb
mysqlTs = "S E L E C T ccode FROM products WHERE catalogid=" & catalogid
set rsTs=oConnTs.Execute(mysqlTs)
do until rsTs.eof
ccode=rsts("ccode")
rsTs.movenext
loop
set rsts=nothing
oconnts.close
response.write ccode & " " & value
else
response.write value
end if
------------------------
There is probably a better way to open the database and grab the ccode field but this works for me.
Now when people search a given catalog number on google or another search engine, you got a better shot at them finding your site.
*** Before where is says ccode FROM you have to add the word S E L E C T with no spaces because the pub auto erases that. Interesting
|
Edited by - apswater on July 24 2017 14:10:27 |
|
All Forums
Add catalog number to title on shopexd
New Topic
Printer Friendly
Topic 
TrustGuard - PCI Security Scanner
