Author Topic: NHC Second Round Recipe Entry  (Read 2508 times)

Offline morticaixavier

  • I must live here
  • **********
  • Posts: 7782
  • Underhill VT
    • The Best Artist in the WORLD!!!!!
Re: NHC Second Round Recipe Entry
« Reply #15 on: May 20, 2014, 02:37:20 PM »
No I checked for special characters. The other recipe went in fine. The special ingredients field has the word 'with' in it  but I would be shocked... wait, this is SQL server... mildly astonished if the system couldn't handle 'with' inside text in a field.
"Creativity is the residue of wasted time"
-A Einstein

"errors are [...] the portals of discovery"
- J Joyce

Offline dkfick

  • Senior Brewmaster
  • ******
  • Posts: 1054
Re: NHC Second Round Recipe Entry
« Reply #16 on: May 20, 2014, 02:41:34 PM »
Hmm yeah I have no clue.  I used Chrome and entered a beer, a beer with specialty ingredients, and a mead without issue.
BJCP A0936 National Beer Judge and Mead Judge
Cicerone Certified Beer Server
AHA Member
CRAFT Homebrew Club
Sons of Liberty Homebrew Club
HBT "mors"

Offline james

  • Brewer
  • ****
  • Posts: 361
Re: NHC Second Round Recipe Entry
« Reply #17 on: May 20, 2014, 04:04:37 PM »
Just don't name your recipe super hoppy ipa'; drop table recipes;

:)

Offline morticaixavier

  • I must live here
  • **********
  • Posts: 7782
  • Underhill VT
    • The Best Artist in the WORLD!!!!!
Re: NHC Second Round Recipe Entry
« Reply #18 on: May 20, 2014, 06:00:40 PM »
I actually had a MS access query named 'Select ...' something that would hang the system everytime until I realized and renamed it 'Selct ...' something. Lazy coding grrr.
"Creativity is the residue of wasted time"
-A Einstein

"errors are [...] the portals of discovery"
- J Joyce

Offline morticaixavier

  • I must live here
  • **********
  • Posts: 7782
  • Underhill VT
    • The Best Artist in the WORLD!!!!!
Re: NHC Second Round Recipe Entry
« Reply #19 on: May 20, 2014, 06:34:58 PM »
Gah!

finally figured it out. 'California Select 2 row' is a problem phrase 'CA Slct 2row' on the other hand works like a charm.

Flash back to access
"Creativity is the residue of wasted time"
-A Einstein

"errors are [...] the portals of discovery"
- J Joyce

Offline dkfick

  • Senior Brewmaster
  • ******
  • Posts: 1054
Re: NHC Second Round Recipe Entry
« Reply #20 on: May 20, 2014, 06:52:26 PM »
smh
BJCP A0936 National Beer Judge and Mead Judge
Cicerone Certified Beer Server
AHA Member
CRAFT Homebrew Club
Sons of Liberty Homebrew Club
HBT "mors"

Offline jeffjm

  • Cellarman
  • **
  • Posts: 56
Re: NHC Second Round Recipe Entry
« Reply #21 on: May 24, 2014, 12:25:24 PM »
I have two different beers advancing, and when I enter the recipe for either of them, I get a slightly different error when I click 'submit':

SQLSTATE: 22001
code: 8152
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]String or binary data would be truncated.
SQLSTATE: 01000
code: 3621
message: [Microsoft][SQL Server Native Client 11.0][SQL Server]The statement has been terminated.

I had some notes in parenthesis the first time I tried, so I went back and removed them - same result.

Edit: This happened using firefox.
« Last Edit: May 24, 2014, 01:19:43 PM by jeffjm »
I set out running but I take my time.

Offline dkfick

  • Senior Brewmaster
  • ******
  • Posts: 1054
Re: NHC Second Round Recipe Entry
« Reply #22 on: May 24, 2014, 02:31:49 PM »
Are any of the fields seeming containing a lot of text?  (try making a description shorter etc...)
Are you using any apostrophes?
Do you have any SQL keywords in any of the fields? (Select, update, insert, delete, etc...)

It's a pretty poor form for sure as it should be cleaning these fields before dumping them into the database... A very good way to lose your database.
BJCP A0936 National Beer Judge and Mead Judge
Cicerone Certified Beer Server
AHA Member
CRAFT Homebrew Club
Sons of Liberty Homebrew Club
HBT "mors"

Offline morticaixavier

  • I must live here
  • **********
  • Posts: 7782
  • Underhill VT
    • The Best Artist in the WORLD!!!!!
Re: NHC Second Round Recipe Entry
« Reply #23 on: May 24, 2014, 02:46:49 PM »
I was having issues entering one of my recipes (see above). I finally started entering one field at a tinge and saving after each one. That was how I found the value that was causing the issue for me. Can you enter just the volume brewed and save it?

"Creativity is the residue of wasted time"
-A Einstein

"errors are [...] the portals of discovery"
- J Joyce

Offline jeffjm

  • Cellarman
  • **
  • Posts: 56
Re: NHC Second Round Recipe Entry
« Reply #24 on: May 24, 2014, 07:48:45 PM »
I'm not sure how many characters constitute a lot of text, but none of the fields seem excessively long to me. To the best of my memory, I have no SQL keywords, no apostrophes, and the second time through I removed the parentheses. The only non-alpha/non-numeric character I have is the decimal point in some of my quantities. I tried one recipe twice, and the other once, and the only things they have in common are yeast starters, carbonation, and dark Munich malt.

The idea about saving one field at a time is a good one - I'll have to try that.

Next year I'm going to name all my entries 'Bobby Tables'  :)

http://xkcd.com/327/
I set out running but I take my time.

Offline jeffjm

  • Cellarman
  • **
  • Posts: 56
Re: NHC Second Round Recipe Entry
« Reply #25 on: May 24, 2014, 08:08:42 PM »
I've identified the culprit after stepping through the fields one by one.

The "Amount" field thought my input of "404 billion cells estimated" was too long. Dropping the word "estimated" worked.
I set out running but I take my time.

Offline dkfick

  • Senior Brewmaster
  • ******
  • Posts: 1054
Re: NHC Second Round Recipe Entry
« Reply #26 on: May 25, 2014, 01:33:18 PM »
I've identified the culprit after stepping through the fields one by one.

The "Amount" field thought my input of "404 billion cells estimated" was too long. Dropping the word "estimated" worked.
Ah validation.  How we miss the.
BJCP A0936 National Beer Judge and Mead Judge
Cicerone Certified Beer Server
AHA Member
CRAFT Homebrew Club
Sons of Liberty Homebrew Club
HBT "mors"

Offline morticaixavier

  • I must live here
  • **********
  • Posts: 7782
  • Underhill VT
    • The Best Artist in the WORLD!!!!!
Re: NHC Second Round Recipe Entry
« Reply #27 on: May 26, 2014, 03:16:35 AM »
I'm kind of surprised it didn't freak out on '404' all by itself.  ;D
"Creativity is the residue of wasted time"
-A Einstein

"errors are [...] the portals of discovery"
- J Joyce