Who would have thought … Adobe Dreamweaver/Coldfusion has an insert form feature that allows you to insert checkboxes, radio buttons … you name it, just like the Visual Studio editor. Gooooo Dreamweaver!
Additionally, I have made an agreement with my bee sting allergenic co-worker that if his esophagus ever swells shut, or at the first sign of trouble such as a raised rash, I will stab him in the neck with a hollow pen in order to create an air passage, thus saving his life. I believe he is highly relieved.
Some code for those of you who like code:
This is a simple CF if, elseif statement that is highly important in writing in-line Cold Fusion code.
#sel_ac.addtocartinfo#
#sel_ac.addtocartinfo#
This ‘if’ statement is using a field (AddToCart) from a query (sel_ac), to set off an Add to Cart image button.
If the value is not equal to “Y”, then it displays addtocartinfo which generally says something like “Call to order, call 1-800 blah, blah, blah.”
End if
And here is the inline, CF query it is using:
SELECT a.Brand ,
a.Name ,
a.skuRoof ,
a.skuCeiling ,
a.Image ,
a.copy,
b.AddToCart,
b.AddToCartInfo,
(SELECT SUM(skuPCPrice) FROM dbo.PROD_SKU WHERE skuNum IN ('' + a.skuRoof + '' + '','' + '' + a.skuCeiling + '')) AS skuPCPrice,
(SELECT SUM(skuRegPrice) FROM dbo.PROD_SKU WHERE skuNum IN ('' + a.skuRoof + '' + '','' + '' + a.skuCeiling + '')) AS skuRegPrice
FROM dbo.wiz_airconditioners a LEFT OUTER JOIN dbo.wiz_dometic b
on a.skuRoof = b.skuRoof
where a.brand='Dometic'
The query is basically “Froming” from a sql server data table imported from an Excel sheet. The data source connection details are passed through the request.dsn variable.
A left outer join is used so we don’t throw the baby out with the bath water in the left table if no values are present in the right table on the join of skuRoof.
The main field we are concerned with pulling here is AddToCart which is used in our
