Linux/Coldfusion DIY Tap Display Project

[sandyeggoxj]

Are you going to have a beta program and offer discounted or free term subscriptions to beta testers?

 

[lextasy23]

Are you going to have a beta program and offer discounted or free term subscriptions to beta testers?

I need more suggestions than I need testers... If you do any coldfusion programming then you get an automatic lifetime membership lol

 

[sandyeggoxj]

I need more suggestions than I need testers... If you do any coldfusion programming then you get an automatic lifetime membership lol

Unfortunately only a background in SQL, php and CSS.

 

[swiggingpig]

Made major progress on the code last night - free trials should be starting soon!!! Stay tuned!

Any new updates ?

 

[lextasy23]

Any new updates ?

Not really - work picked back up and I've been swamped at night.

It's super close to being done though - just need a few minor bugs fixed.

 

[swiggingpig]

It's been a while, anything new ?

 

[lextasy23]

Sadly, nothing. Work picked up, I've been driving back and forth from MA to NJ every week, plus i have a couple other new web clients. I imagine after the holidays I'll have some more time to drop back into this.

The worst part is, it's at like 90%. Just need to polish it up and get it done.

Looking for ColdFusion volunteers...

 

[BigFloppy]

ColdFusion volunteer here, hope this isn't spaghetti code lol

 

[lextasy23]

Project is back on the front burner. I had a super busy October, spent the month out-of-state for work, then the holidays are our busy season, so that was crazy. I also just finished an (epic) brew panel. I should have started a thread on that. Maybe I'll do that now.

Anyways, I'm going to jump back in and see if I can figure out the bugs.

 

[wit2003]

Hurry it up....my piece of paper tap list isn't cutting it anymore

 

[Newsman]

Just FYI, you are aware that Adobe isn't supporting Flash on Linux any longer, right? If you want Flash, you pretty much have to go with the Chrome browser or Chromium browser (open source version of Chrome.)

 

[lextasy23]

Just FYI, you are aware that Adobe isn't supporting Flash on Linux any longer, right? If you want Flash, you pretty much have to go with the Chrome browser or Chromium browser (open source version of Chrome.)

I was not, but I'm not worried about supporting an open-source version of an OS or browser... Those Linux guys are pretty crafty and can probably figure it out.

 

[lextasy23]

ColdFusion volunteer here, hope this isn't spaghetti code lol

So... I need to get back "in the zone" so to speak, and figure out where I left off. I think I was having an issue with accounts, though I don't remember it as major.

I'm definitely still wondering how I can make ABV translate itself to the color in the flash video... Unless I just make all different color videos, but that doesn't allow me to make different variations for berry color, etc.

 

[lextasy23]

Ok, calling all CF/SQL guys here.

I'm stuck at one part in the code. When a new user signs up, they set up their preferences. Part of that is choosing how many taps your bar has (call it X). The code takes this and then passes you to another page where you enter X number of beer details. I have a CFOUTPUT repeating X times, but i need #tapnumber# variable to be inserted into each item. If that makes sense.

Here's some code:

<tr height="500">
     <td valign="top">
    	<center>
  		<cfform method="post" action="act_BeerOptions.cfm">

    	<cfoutput query="getBeers">
        <!---	
		THIS IS BROKEN BECAUSE #TAPNUMBER# BELOW IS NOT DEFINED.
		
		--->
        
			<br>
            <br>
		<font face="Arial Narrow" color="ffffff" size="3">Tap 

#tapnumber# - Full?</font>
			<cfinput type="checkbox" name="beer#tapnumber#isfull" 

value="IsFull" checked  onClick="Display('IsFull');"> 
			<div ID="IsFull" style="display:block">
		<font face="Arial Narrow" color="ffffff" size="3">Tap 

#tapnumber# Name</font>
            <br>
			<cfinput id="beer#tapnumber#name" 

name="beer#tapnumber#name" type="text" maxlength="255" value=""/> 
            <br>
            <br>
		<font face="Arial Narrow" color="ffffff" size="3">Tap 

#tapnumber# Style</font>
            <br>
			<cfinput id="beer#tapnumber#style" 

name="beer#tapnumber#style" type="text" maxlength="255" value=""/> 
            <br>
            <br>
		<font face="Arial Narrow" color="ffffff" size="3">Tap 

#tapnumber# ABV</font>
            <br>
			<cfinput id="beer#tapnumber#ABV" 

name="beer#tapnumber#ABV" type="text" maxlength="255" value=""/> 
            <br>
            <br>
		<font face="Arial Narrow" color="ffffff" size="3">Tap 

#tapnumber# SRM</font>
            <br>
			<cfinput id="beer#tapnumber#SRM" 

name="beer#tapnumber#SRM" type="text" maxlength="255" value=""/> 
            <br>
            <br>
		<font face="Arial Narrow" color="ffffff" size="3">Tap 

#tapnumber# IBU</font>
            <br>
			<cfinput id="beer#tapnumber#IBU" 

name="beer#tapnumber#IBU" type="text" maxlength="255" value=""/> 
            <br>
            <br>
		<font face="Arial Narrow" color="ffffff" size="3">Tap 

#tapnumber# Tap Date</font>
            <br>
			<cfinput id="beer#tapnumber#tapdate" 

name="beer#tapnumber#tapdate" type="text" maxlength="255" value=""/> 
            <br>
            <br>
		</div>

    	</cfoutput>
		
			<cfinput name="submit" type="submit" value="Submit">
        	<cfinput name="custid" type="hidden" value="#url.custid#">
        	<cfinput name="tapqty" type="hidden" value="#url.tapqty#">
        	<cfinput name="title1" type="hidden" value="#url.title1#">
        	<cfinput name="title2" type="hidden" value="#url.title2#">
        </cfform>

For each beer, there's a number of database entries. I need those to repeat for X number of beers.

For example, if they have 2 beers on tap, then the form passes:

• beer#tapnumber#isfull
• beer#tapnumber#name
• beer#tapnumber#style
• beer#tapnumber#ABV
• beer#tapnumber#SRM
• beer#tapnumber#IBU
• beer#tapnumber#tapdate

So, it should actually pass:

• beer1isfull
• beer1name
• beer1style
• beer1ABV
• beer1SRM
• beer1IBU
• beer1tapdate
• beer2isfull
• beer2name
• beer2style
• beer2ABV
• beer2SRM
• beer2IBU
• beer2tapdate

...and so on, for up to 8 beers on tap (more with later page revisions or multiple screens i'm sure)

So I need to figure out a way to get #tapnumber# to return a number. I'm thinking MOD and RECORDCOUNT or something, but I can't figure it out

Any suggestions?

 

[RedRaiderDavid]

This is seriously cool, I have an old PC in my garage I can't bring myself to get rid of and this seems like a good use for it.
What would it take to have the keg levels live as well? There is a growler place close to me that does it, they even have it online. I'm guessing they have some kind of scale below each keg.

http://www.tapsandcaps.com/taps.html

 

[lextasy23]

This is seriously cool, I have an old PC in my garage I can't bring myself to get rid of and this seems like a good use for it.
What would it take to have the keg levels live as well? There is a growler place close to me that does it, they even have it online. I'm guessing they have some kind of scale below each keg.

http://www.tapsandcaps.com/taps.html

Ya, I could probably do it with USB scales - choose your options on the site for ball vs. pin, and let the code factor tare weight and gross weight, then calculate a percentage. Seems like a lot of extra work for something that most folks won't use, but I have definitely thought about it before. I had also thought about integrating a thermometer and displaying kegerator/keezer temp... Maybe even manifold pressure. Pretty straightforward getting the values into the page - much the same way Stamps.com gets the weight of your letter on your USB scale into its website.

 

[RedRaiderDavid]

Maybe v2.

 

[lextasy23]

Maybe v2.

I already have ideas for v30 lol. Gotta get through v1.

Making major progress today though.

 

[BigFloppy]

Ok, calling all CF/SQL guys here.

// SNIP //

So I need to figure out a way to get #tapnumber# to return a number. I'm thinking MOD and RECORDCOUNT or something, but I can't figure it out

Any suggestions?

instead of #tapnumber# use #getBeers.currentRow#

 

[lextasy23]

instead of #tapnumber# use #getBeers.currentRow#

Ugh. That's perfect... I forgot about that one.

You should see the bandaid workaround code i made to get this to work... Lots of repeated code and "is it bigger than this? than this? than this?" code lol.

Thanks man.

 

[wit2003]

Does this mean I'll know what's on tap soon?

 

[lextasy23]

Does this mean I'll know what's on tap soon?

http://mytapdisplay.com/addcustomer.cfm Try that on for size. It still bombs at the very last step, but I'm getting there...

 

[BigFloppy]

http://mytapdisplay.com/addcustomer.cfm Try that on for size. It still bombs at the very last step, but I'm getting there...

Just ran thru it...

You're using an INSERT where should be an UPDATE (assuming you already created rows for by brews in the "Beers" table) BUT that would likely be counter productive if I ever wanted to add another Tap to my list of available brews...


OH, also "Like" the inverted N in the title... makes my "Big Floppy Donkey B... " definitely standout

 

[lextasy23]

Just ran thru it...

You're using an INSERT where should be an UPDATE (assuming you already created rows for by brews in the "Beers" table) BUT that would likely be counter productive if I ever wanted to add another Tap to my list of available brews...


OH, also "Like" the inverted N in the title... makes my "Big Floppy Donkey B... " definitely standout

Ahhh... makes sense. I'm a little rusty.

 

[lextasy23]

Long time since I was at this project... But since we just bought a house and I'll be building out mantown soon... I'll need a tap display!

More to come soon.