mattyd 89 Posting Maven Featured Poster

Hi

>>> if I remove the "employeeNumber into(11) NOT NULL," line completely the same error message returns for the next line.


Be that as it may, "into(11)" isn't a datatype --> int(11) seems to be correct.

-- tesu

I make changes per your suggestion. Please see attached image of results. Thanks.

mattyd 89 Posting Maven Featured Poster

Hello,

I am brushing-up on SQL (using MySQL). It has been many years since I have worked with this and I'm having some trouble getting started.

I have looked at a tutorial and entered the code below:

CREATE TABLE employees (              
             employeeNumber into(11) NOT NULL,    
             lastName varchar(50) NOT NULL,      
             firstName varchar(50) NOT NULL,     
             extension varchar(10) NOT NULL,     
             email varchar(100) NOT NULL,        
             officeCode varchar(10) NOT NULL,    
             reportsTo int(11) default NULL,     
             jobTitle varchar(50) NOT NULL,      
             PRIMARY KEY  (employeeNumber)       
           );

I receive the error message in return:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 
'juggernaut
CREATE TABLE employees (
             employeeNumber in' at line 1

I am not quite sure what the message is referring to - I assumed it should run just fine.
If I remove the "employeeNumber into(11) NOT NULL," line completely the same error message returns for the next line.

I'm puzzled. :confused:

Thank-you in advance for any guidance in the right direction.

-Matty

mattyd 89 Posting Maven Featured Poster


Problem: User has made a "deposit" but when the User makes a "withdrawal", the "balance" is an incorrect and negative number always.

Bug Fixed. Solved.

mattyd 89 Posting Maven Featured Poster

I have one, reoccurring issue that arises each time I run this incomplete program I am working on; I have spent much time attempting to locate the bug. I am convinced it arises from a simple error.

Problem: User has made a "deposit" but when the User makes a "withdrawal", the "balance" is an incorrect and negative number always.

Any help in or push in the right direction would be greatly appreciated. Thank-you in advance.

import java.io.*;

final class readString {

   public static void main (String[] args) {

      //  Intro
      System.out.print("Welcome to World Bank. Please make a selection from the following and selct the Enter key:\n 1)Checking\n 2)Savings\n 3)Loans\n Choice:");

      //  Open Input
      BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

      String choice1 = "1";
      String choice2 = "2";
    

      String deposit1 = "1";
      String deposit2;
     


      String withdrawal1 ="1";
      String withdrawal2 = null;

      
      String response1 = "Checking";
      String response2 = "Savings";
      String response3 = "Loans";
   

      try {
         choice1 = br.readLine();
        

      if (choice1.equals("1"))
      {
         System.out.println("You chose " + response1);
         System.out.println("Please choose 1 for deposit or 2 for withdrawal:");
         deposit1 = br.readLine();
         System.out.println("Please make your deposit:");
         deposit2 = br.readLine();
         System.out.println("You deposited " + deposit2 + ".");
         System.out.println("Would you like to make a withdrawal? Here you may make a withdrawal and see your balance. Enter 1 to go to Withdrawal area.");
         deposit2 = br.readLine();
         System.out.println("You chose " + withdrawal1);
         System.out.println("Please enter the amount you would like to withdrawal: ");
         withdrawal2 = br.readLine();
         System.out.println("You have withdrawn: $" + withdrawal2 + ".00.");
         
        
         
         
         
         String convert1 = …
mattyd 89 Posting Maven Featured Poster

A strong cup of American coffee.

mattyd 89 Posting Maven Featured Poster

Languages: There are so many, and so many are just not right-- but does that matter? These and all coding languages amount to elitist, competitive shells easily brought down to a command-line yelling in binary. The aim is the same, the results the same, but the tongue speaking the output different. Python, C++, Lisp? I could care less-- please just tell me which one is deeper, faster, and the easiest to use for the job? Oh, and which one is the prettiest to look out for hours on end?

I build a castle of stone and realize too late that I used the worst rock available and when it rains it seeps, and these walls let in ghastly amounts of cold air. What do I do? Tear it down and start over using the right stone and perhaps preserve some of the adornments, gargoyles, and ramming stones (elements of the old code if it will mesh smartly) and reuse what I can. If not, drop the worthless slabs into the bay and mine somewhere else. Know when to cut losses and run into the arms of a better quarry.

We all have a library of biases towards or against particular languages, apps, hardware, etc-- it has always been that way, but please do not swear that my choice is incorrect just because less books exist on the subject or not enough servers yet serve their masters in this doctrine. That is just Draconian.

mattyd 89 Posting Maven Featured Poster

C-3PO, in the Star Wars movie The Empire Strikes Back, makes the statement: "Sir, I am fluent in six million forms of communication. This signal is not used by the Alliance. It could be an Imperial code." At times I think my compiler only communicates in "Imperial code".

I love my compiler, a Microsoft Visual C++ 2005 Express, but our relationship is tumultuous. Of course, it is not the compiler's fault but my own; I am sloppy at times or I fail to notice the small syntax flecks that will surely evolve into downhill, snowball landslides-- but will not my compiler become enlightened enough to go the extra step and explain these errors to me in simpler terms? Seemingly not. My compiler, ever the vanguard against deviant coding, springs forth with its verdict-- error, error, error! It is sometimes disheartening that my trusted machine can not speak to me in a language that I understand.

I enter C++, it replies with a shout in Symglish (symbolized English); the scattered English nouns and verbs amongst the hexadecimal blurbs and references to what is happening in\ on the stack can instantiate a cognitive overflow in my forehead. Its difficult enough sometimes to fix the error when discovered and pointed out, never-the-less wade through an error output that looks as if it
were downloaded from the mothership.

But I learn-- The compiler does now have to. Its education is left up to the programmers and designers that created this …

mattyd 89 Posting Maven Featured Poster

This is an excellent article for both new programmers as well as seasoned veterans. I program for a living but I also do it for my own pleasure. It can be enjoyable and should always be to one degree or another; I find it hard to visualize doing such tedious work as software design\programming if I was not empassioned and rather obessive about it.

It can be akin to a game: lighthearted, thrilling, rewarding. But, without a sound strategy it is easy to suffer defeat. Always plan your programs at least in your head if not on paper; even while I am building the actual program on the compiler I have a large sketchbook beside my mouse where I take notes, work out mathematics, draw diagrams-- whatever is needed to suceed in my task(s).

Thanks for the great article.

sharky_machine

mattyd 89 Posting Maven Featured Poster

Cool, I think this just what I am looking for for packaging future Python builds for release. The program to do this is this short? Nice. ;)

mattyd 89 Posting Maven Featured Poster

Designing fluid is actually really hard, because a lot of things come into play. A trick i like to use is, make sure it works in 1024 and chances are it will work on hi-res. Don't even try go as low as 800x600. Oh, i looked at your dummy site and it should be easy enough. Good luck and all the best

Thanks for your help :)

mattyd 89 Posting Maven Featured Poster

Thanks to all replies. I appreciate it very much.

mattyd 89 Posting Maven Featured Poster

I am redesigning my girlfriends website and this time hope to use fluid layout. I have been doing research for some time now but I am not making significant progress.

I am not new to web design, HTML or CSS but after my last frustrating attempt at a site (the site I am redesigning) I feel as if I am missing some key considerations:

- The top 3 Browsers to design for
- How various User-set resolutions affect the design

I need advice on this.

I have a dummied Home page on a server which can be viewed if anyone is interested (Note: This is a very rough version and non-functional. I have live it just to test browser/resolution issues on my home machines and varied machines at work.)

http://perola-nyc.com/fluid5.htm

Thank-you in advance for any help in regards to this (I really do need it)

mattyd

mattyd 89 Posting Maven Featured Poster

lets say you have the opportunity to choose between two women (men if you're a chick):

one of them is the hottest thing you've ever seen, but as long as she/he opens her/his mouth, it is full of crap and idiotness...

the other one is not too physically gifted... but has the best personality ever... very smart, a very good friend and listener, and all you can imagine...

which one would you choose?

Brains

mattyd 89 Posting Maven Featured Poster

I believe both -- God created everything, how he did it was through evolution.

Yes. God planned/built all initially (energy, physics, DNA... ); within this "design" was Evolution as well, a mechanism employed to allow the creation(s) to unfold over time and become stronger, faster, better, hence more able to subsist and survive on this planet. This ensured further reproduction of said species and ongoing evolution.

mattyd 89 Posting Maven Featured Poster

- Wave of Mutilation - The Pixies -

mattyd 89 Posting Maven Featured Poster

lol

mattyd 89 Posting Maven Featured Poster

Why do you say "G-d"?

I am a Catholic.

Some info on "G-d":

Judaism does not prohibit writing the Name of God per se; it prohibits only erasing or defacing a Name of God. However, observant Jews avoid writing any Name of God casually because of the risk that the written Name might later be defaced, obliterated or destroyed accidentally or by one who does not know better. Observant Jews avoid writing a Name of God on web sites because there is a risk that someone else will print it out and deface it. To avoid writing the Name, Orthodox Jews (and sometimes other denominations) substitute letters or syllables, for example, writing "G-d" instead of "God."

Regards,
Matty D.

mattyd 89 Posting Maven Featured Poster

> I believe G-d created the Universe
Which one?

The Christian G-d.

The other "gods" are just that, gods (lower g, generic). There can only be one G-d. Which One? You are asking me to compare G-d to human-created deities, ideas, apparitions.

Matty

mattyd 89 Posting Maven Featured Poster

No, ruby is mainly use for web applications.

Ruby is being used used mainly for web applications at this point (supposedly)but this is only half of the picture. Ruby is a scripting language by definition but it is powerful and can be exploited for non-Web development with fine results.

As to the Ruby section of DaniWeb being located in the Web Dev section-- well, thankfully we at least have a Ruby section (something I rallied for some years ago).

Interestingly enough, Python is located in the Software Dev section I believe; personally, I put Python and Ruby on the same level, although I prefer the beauty and speed of Ruby by far after using Python extensively.

mattyd 89 Posting Maven Featured Poster

um, VISTA?

mattyd 89 Posting Maven Featured Poster

I believe G-d created the Universe and has designed evolution as a method to advance biological species.

mattyd 89 Posting Maven Featured Poster

"Pleasure in the job puts perfection in the work."

mattyd 89 Posting Maven Featured Poster

I am a member of a QA/testing team for a software company in NYC. We
have decided recently to begin the development of scripting tools to
automate repetitive tasks used during our testing cycles. We have
decided to use Ruby. Although we have admired Ruby from afar for some
time now we have yet to actually make use of it.

So far we are coding simple scripts to create user accounts for testing;
this activity always absorbs incredible amounts of time and interrupts
our testing procedures, hence the need for automation.

What we have created in Ruby the last few days has been very exciting
and it convinces us of the power and beauty of this language.

Working remotely from home today on this project I have been attempting
to access the backend Admin controls for the company/site, that is, I'm
developing a script to automate this process in order for "users" to be
created for our upcoming testing cycle purposes.

This process is straight-foward: logging in via a two-step process to
ensure security. The script is simple and works up unto the point that
I must actually select a link to continue further (after log-in).

The following code is an anonymous version of the actual code I am using
(real links, passwords, etc altered:

1  require 'watir'
2  ie = Watir::IE.new
3  ie.maximize
4  ie.goto('https://main2.site.org/dev/code.asp)

#ie warning page …
mattyd 89 Posting Maven Featured Poster

- Cuban Coffee
- Marlboros
- CSS :-/

Sulley's Boo commented: Happy birthday .. "_" +5
mattyd 89 Posting Maven Featured Poster

None. Never had any.

mattyd 89 Posting Maven Featured Poster

Hi,

I am developing a simple site and have (after it being recommended) been using CSS to handle the homepage image display. The display consists of an array of 25 (95x95 px) images aligned to form one image. CSS has allowed me to display them just as I wanted (please see homepage link above). A minor problem exists now though. I have decided to add Javascript to the page so each image rolls over upon mouse contact-- simple. This works fine. (*NOTE: the website link is pre-Javascript, not the scripted version which contains the errors) But, ever since I've added JS, I am having an odd alignment problem. I have tried everything I can think of. The original non-JS works fine, and I do not see how adding JS would cause this problem.

Attached are two screenshots of the situation:

1) Before, without JS (lower-righthand image is placed correctly)
2) After JS (lower-righthand image is placed incorrectly)

Below is a relative code-snippet for each:

1)

<div class="thumbnail">
<a href="http://stormtrooper.webng.com/image.html"><img src="bombers.jpg" width="95" height="95" alt="" border=0></a><br>
</div>

<!-- layer 5-->
<div class="thumbnail">
<a href="http://stormtrooper.webng.com/image.html"><img src="bottomLeftCorner.jpg" width="95" height="95" alt="" border=0></a><br>
</div>

2)

<div class="thumbnail">  
<A href="#" onMouseOver="return changeImage18()" onMouseOut= "return changeImageBack18()" ><img name="shirtButton18" src="bombers.jpg" width="95" height="95" border="0" alt="javascript button"></A><br>
</div> 


<div class="thumbnail">
<a href="http://stormtrooper.webng.com/image.html"><img src="bottomLeftCorner.jpg" width="95" height="95" alt="" border=0></a><br>
</div>

** Both, full code versions upon request

I hope I explained this well to …

mattyd 89 Posting Maven Featured Poster

Vishesh:

Thank-you for your reply and for the further information.

I tried your suggestion and it worked great. I understand the problem much better now.

There still seems to be a pixel-width space between each image on the homepage image(s), though; I have read of this problem and need to solve that also. I will research it today.

Thank-you so much for your help, Vishesh.

Matty

GreenDay2001 commented: Anything for friend :) +4
mattyd 89 Posting Maven Featured Poster

Vishesh:

Thank-you for your advice. I've implemented both suggested changes. But, in regards to the table, the problem still exists. I am not sure why. Please see the homepage if you have the time.

Thanks again,
Matty

mattyd 89 Posting Maven Featured Poster

I am working on a fairly simple site. At this point I am wanting to assemble 25 images on the homepage which when assembled will form a whole image (where each separate image will be clickable).

I am only at the point of trying to getting the images arranged as described above. The problem is: When rendered on the screen (I am using Mozilla Firefox as my primary browser) each image is divided from the other with a section of background (in this case white) showing through.

I have tried to research this topic and have been coming up fairly empty with all suggested fixes. Can anyone offer any solutions for this issue?

Thank-you in advance (code below),
Matty

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<HTML>

<HEAD>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<meta name="AUTHOR" content="stormtrooper">
<meta name="DESCRIPTION" content="stormtrooper">
<title><> stormtrooper <></title>
</HEAD>

<BODY>

<body bgcolor="#ffffff">
<BODY link="pink" alink="yellow" vlink="grey">

<img src="5p5.jpg" width="725" height="142" alt="stormtrooper" >
<p>

<table border="0" align="center" width="60%">

<tr>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="redRobot.jpg" width="95" height="95" alt="" border=0></a></td>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="birdy.jpg" width="95" height="95" alt="" border=0></a></td>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="cosmosMan.jpg" width="95" height="95" alt="" border=0></a></td>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="uk.jpg" width="95" height="95" alt="" border=0></a></td>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="topRightCorner.jpg" width="95" height="95" alt="" border=0></a></td>
</tr>

<tr>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="japanAd.jpg"width="95"height="95"alt=""border=0></a></td>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="tulip.jpg" width="95" height="95" alt="" border=0></a></td>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="amoeba.jpg" width="95" height="95" alt="" border=0></a></td>
<td><a href="http://stormtrooper.webng.com/image.html"><img src="guilder.jpg" width="95" …
mattyd 89 Posting Maven Featured Poster

Brains, most definitely. Most fortunately, I live with my lovely, nerdy girlfriend and enjoy both. But, its all about the brains, really-- who truly cares about the rest? :yawn:

Sulley's Boo commented: welcome back!! .. +3
mattyd 89 Posting Maven Featured Poster

Cats == Yes! :)

Dogs == No :(

mattyd 89 Posting Maven Featured Poster

- Painting
- Metalsmithing
- Writing

mattyd 89 Posting Maven Featured Poster

Doesn't sound like a democracy to me.

Correct, yes.

mattyd 89 Posting Maven Featured Poster

from purely efficient point of view, dictatorship is obviously more efficient because only one person (ok maybe a small group of people) make all the decisions, eliminating all the problems and delays associated with allowing the citizens to cast ballots. And that is one of the reasons why we in USA do not have a democracy ("mob rule")

Dictatorship == more efficient, most definitely overall, yet not so pretty or nice to live under as history has noted.

"Democracy" == less efficient and strikingly so in general, but with patience a bit more comfortable if ones lives in Middle class\ borgeoius (like I do).

Socialist Democracy == Dare I utter this term within the borders of the United States? :sweat:
* Perhaps the best of two worlds: Democratic vote on the matters the people\ citizens should have a say in (leaders, etc), and Government mandate on matters the citizens are not versed enough to have an open say in: Military, education systems, etc. Hmm-- This sounds a bit like the United States, no? :-O


(* Canada, Holland, Germany, France, UK, Norway, Sweden, Switzerland, all Socialist Democratic nations in theory at least (no matter what their Constitution states.) And, please note their Math\ Science testing scores, Internationally-- all top of the list versus the U.S. that ranks, what No. 16 :icon_rolleyes:; Please explain this empirical fact, someone, with a touching heap of the typical, irrational justification so rampant within our borders, here. Pathetic. :S )

mattyd 89 Posting Maven Featured Poster

- Iron Maiden
- Ian Brown
- Coheed & Cambria
- Rush
- Pet Shop Boys
- The Cure
- 80's

mattyd 89 Posting Maven Featured Poster

1870, the year that nobody remembers.

mattyd 89 Posting Maven Featured Poster

Elitist hackers of Linux hate remembering their woes while pretending to destroy Windows.

mattyd 89 Posting Maven Featured Poster

You find a mistress.

I put in a gentleman.

mattyd 89 Posting Maven Featured Poster

tracking

mattyd 89 Posting Maven Featured Poster

Elitist hackers of Linux hate remembering their worries while commencing to destroy Windows.

mattyd 89 Posting Maven Featured Poster

baskets

mattyd 89 Posting Maven Featured Poster

Here is a place to rest your mind and proceed to alter character strings.

mattyd 89 Posting Maven Featured Poster

Elitist followers of Linux hate compiling their worries while commencing to destroy Windows.

mattyd 89 Posting Maven Featured Poster

mast

mattyd 89 Posting Maven Featured Poster

You get Mickey Mouse's skeleton.

I put in the skull of a horse.

mattyd 89 Posting Maven Featured Poster

Guys, I give up.

We all know that nobody's stance on anything will change a smudgeon, as shown by everybody's very last post. Everyone is using the same old ignorances, criticizing others who don't agree with their own beliefs, and simply bashing other religions needlessly.

WHY? Why does it matter what someone else believes? Why do we need to so vehemeously defend our own beliefs? Why does it matter what somebody else thinks of you?

This argument is going in circles, with nobody changing.

It was stupid of me to even partake in any of this, I'm sorry.

Again with your pronouncement of other's "ignorance"-- sounds very familiar. Why is someone ignorant who stands strongly by their beliefs and does not "change" just because you or someone wishes to encourage them through a post on a website? Please let it be known, and I speak for myself: I am not trying to change you nor convince or persuade-- I find that fruitless. Yes, I wish to spread the living Word with those open to hearing and learning about it, but I am not the kind of Christian that feels the need to convert through word or sword.

It is the norm in Western culture to bash Christianity as "ignorant", closed-minded, superstitious, and certainly some of that does exist in certain Christian sub-groups. The Christians I know, though, speak Hebrew and read Greek. They are programmers, artists, writers, doctors. These are not uneducated backwater folks hoping to pull you into …

mattyd 89 Posting Maven Featured Poster

You get to drink your fill of fennel beer.

I put in planet Dune.

mattyd 89 Posting Maven Featured Poster

boast

mattyd 89 Posting Maven Featured Poster

lobster

mattyd 89 Posting Maven Featured Poster


According to who? You? Christianity? Simply because you don't believe in the idea does not mean it isn't true. I myself have no affiliation to Buddhism of any kind, but I'm just trying to present another outlook on it all.

Again, ignorance.

Yes, according to myself and Christianity; although I have a general love for all individuals on this planet even if I disagree with their view, religious beliefs, etc, this does not mean I have to support their view and render myself inert to what I consider just another branch of Paganism (which in my religious beliefs is not to be supported, encouraged, or to be taken lightly.) I do believe Buddhism is a sidenote of a religion no matter the number of followers-- that means nothing to me.

As to ignorance: I have read and studied Buddhism, Islam, and Judaism actively and out of my own interest since I was 15-- I am 36 years-old now, so, I imagine I am better-versed and actually non-ignorant to these religions in actuality; it is my studies of these world religions that have allowed me to fully embrace Christianity by choice. And, please note, Stein, I have come to Jesus only two-years ago, hence, I was not raised and indoctrinated to follow something by rote. I am Jewish by birth.

I feel no need what-so-ever to stand by and grovel to these religions in a tone of global, political-correctness. As an American I believe in the right …