krazigoddezz
-
Posts
43 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Downloads
Gallery
Store
Everything posted by krazigoddezz
-
I see what you mean. The blue boxes... Try setting your border to 0px for the div or table. If it's not that, you need to see if you have borders on the images themselves and remove those or set them to 0px. Hope that solves your problem.
-
ok i just finished fixing it after about 45 mins when i realized i forgot to set it to is not. thats why it wasnt working. and i fixed up the regExp <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <script type="text/javascript"> function validateFormOnSubmit(theForm) { var reason = ""; reason += validateFirst_Name(theForm.first_name); reason += validateLast_Name(theForm.last_name); reason += validateGuest_Count(theForm.guest_count); if (reason != "") { alert("Some fields need correction:\n" + reason); return false; } return true; } function validateEmpty(fld) { var error = ""; if (fld.value.length == 0) { fld.style.background = 'gray'; error = "The required field has not been filled in.\n" } else { fld.style.background = 'White'; } return error; } function validateFirst_Name(fld) { var error = ""; var illegalChars = /^([a-zA-Z ]+)$/; // allow letters and spaces if (fld.value == "") { fld.style.background = 'gray'; error = "You didn't enter a first name.\n"; } else if (!(illegalChars.test(fld.value))) { fld.style.background = 'gray'; error = "The first name must only have letters or spaces.\n"; } else { fld.style.background = 'White'; } return error; } function validateLast_Name(fld) { var error = ""; var illegalChars = /^([a-zA-Z -]+)$/; // allow letters, hyphens, and spaces if (fld.value == "") { fld.style.background = 'gray'; error = "You didn't enter a last name.\n"; } else if (!(illegalChars.test(fld.value))) { fld.style.background = 'gray'; error = "The last name must only have letters, hyphens, or spaces.\n"; } else { fld.style.background = 'White'; } return error; } function validateGuest_Count(fld) { var error = ""; if (fld.value == "") { error = "You didn't enter the number of guests attending.\n"; fld.style.background = 'gray'; } else if (isNaN(parseInt(fld.value))) { error = "The guest count can only be a number.\n"; fld.style.background = 'gray'; } return error; } </script> </head> <body> <form method="post" onsubmit="return validateFormOnSubmit(this)" action="#"> <p class="style1">First Name: <input name="first_name" type="text" id="first_name" maxlength="20" size="30"/> </p> <p class="style1">Last Name: <input type="text" name="last_name" id="last_name" maxlength="20" size="30"/> </p> <p class="style1">Number of guests: <input name="guest_count" type="text" id="guest_count" size="5" maxlength="1" /> </p> <p class="style1"> <input type="submit" value="Submit" /> <input type="reset" value = "Clear"> </p> </form> </body> </html> so now i just need to figure out how to validate with php and sql. which ill start on tomorrow.
-
figured out the problem to the syntax error. its supposed to be: var parsed = /^\d{1}/$; not var parsed = /^\d{1}$; it was just missing forward slash. was that the only error you were getting? when i input data correctly it still gives me the error message. are you getting that too?
-
oh ok... ill work on that some more then. thanks so much! i also have some questions about validating the user's input on the guest count. is it possible to call variables in the database an use php to validate it? So i figure it would be best to explaing my thought process on this since it probably changed from when i first started working on this almost a month ago even though you are fully aware but feel the need to update others reading this thread. im restricting the amount of guest that each person who receive an invitation can bring only a certain number of people. so in the database each tuple has 4 attributes: FirstName, LastName, GuestAllowed, and GuestCount and all are set at null values. so as of right now, with the form and database things ive been working on with the Falken's help, this page is just calling the first name and last name from the guest and allowing them to update if and only if the number they insert on the form is less than or equal to the GuestAllowed attribute. Right now, everyone's guestCount is at 0. So the javascript, which is currently being worked on is just to make sure there are no null fields and the user is typing in letters an numbers where they are supposed to go. now once the client side validation works works, the last part of this wedding rsvp project is that i want to be able to give the users error messages for when their information is not found in the database. I also want to give them another message if they try to rsvp with 5 guests when only 3 are allowed and remind them of the number of guests they are allowed to have. as of right now the database will not update if they type in more than 3 (which is what i want it to do). i started to work on it earlier to take a break from the javascript to realize that i have never done server side validation. so im shooting for something like: if (!($theGuestCount<=guestAllowed)){ print ("There was an error with your RSVP. You have " + guestAllowed + " reserved seats. Please check text field and try again."); } if (!($first_name=firstName) and !($last_name=lastName)){ print ("There was an error with your RSVP. You have entered an invalid first and last name combination. Please check the text field an try again.") } so.. is something like this possible? if it is.. how would i go about executing this? if not, would i need to create separate variables and set the values equal to the values in the database?
-
the javascript validation isn't working. i tried it in both firefox and ie and i get nothing. sigh... so this is what i have: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Untitled Document</title> <script type="text/javascript"> function validateFormOnSubmit(theForm) { var reason = ""; reason += validateFirst_Name(theForm.first_name); reason += validateLast_Name(theForm.last_name); reason += validateGuest_Count(theForm.guest_count); if (reason != "") { alert("Some fields need correction:\n" + reason); return false; } return true; } function validateEmpty(fld) { var error = ""; if (fld.value.length == 0) { fld.style.background = 'gray'; error = "The required field has not been filled in.\n" } else { fld.style.background = 'White'; } return error; } function validateFirst_Name(fld) { var error = ""; var illegalChars = /[ a-z]$/i; // allow letters and spaces if (fld.value == "") { fld.style.background = 'gray'; error = "You didn't enter a first name.\n"; } else if (illegalChars.test(fld.value)) { fld.style.background = 'gray'; error = "The first name must only have letters or spaces.\n"; } else { fld.style.background = 'White'; } return error; } function validateLast_Name(fld) { var error = ""; var illegalChars = /[- a-z]$/i; // allow letters, hyphens, and spaces if (fld.value == "") { fld.style.background = 'gray'; error = "You didn't enter a last name.\n"; } else if (illegalChars.test(fld.value)) { fld.style.background = 'gray'; error = "The last name must only have letters, hyphens, or spaces.\n"; } else { fld.style.background = 'White'; } return error; } function validateGuest_Count(fld) { var error = ""; var parsed = /^\d{1}$; if (fld.value == "") { error = "You didn't enter the number of guests attending.\n"; fld.style.background = 'gray'; } else if (isNaN(parseInt(parsed))) { error = "The guest count can only be a number.\n"; fld.style.background = 'gray'; } else { fld.style.background = 'White'; } return error; } </script> </head> <body> <form method="post" onsubmit="return validateFormOnSubmit(this)" action="#"> <p class="style1">First Name: <input name="first_name" type="text" id="first_name" maxlength="20" size="30"/> </p> <p class="style1">Last Name: <input type="text" name="last_name" id="last_name" maxlength="20" size="30"/> </p> <p class="style1">Number of guests: <input name="guest_count" type="text" id="guest_count" size="5" maxlength="1" /> </p> <p class="style1"> <input type="submit" value="Submit" /> <input type="reset" value = "Clear"> </p> </form> </body> </html> ive used this code in the past and it doesnt work for some strange reason. any ideas?
-
wow... i never heard of injection. i looked up on how to use it at the w3schools site because i didnt completely understand tizag. but after seeing it utilized two different ways, it makes sense. thank you. now i get what you are saying about the code not executing. so data now saves to the database (yay ). thank you so much! but now i have to create an if statement for people trying to enter in more guests than they are allowed to let them know it doesnt work and then add in some javascript to validate the textbox input to make sure there are no null fields and numbers and letters go where they are supposed to. hopefully i can remember how to since i haven't used it in years and learned the outdated codes from school. once again, thanks so much falken. if i could, i would ship you some yummy cookies or a cake (i work as a baker/cake decorator) as my thanks.
-
so since the first line in guestRSVP.php is if($Submit), it won't work? why exactly is that? you mentioned that it will not work because $Submit has yet to be executed. isnt it executed when the user click submit on RSVP.html through the form's submit button? like i said... im a php noob and learning as i go along. Well, I just thought of something... give me a few hours... i need to proofread, edit, and provide feedback on a paper for my mommy (shes going back to school after 13+ years) and ill let you know if i get what im thinking to work or not.
-
this is the page with the form: <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>RSVP</title> <style type="text/css"> <!-- .style1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #161616; } body { background-color: #161616; } a:link { color: #D70000; text-decoration: none; } a:visited { text-decoration: none; color: #D70000; } a:hover { text-decoration: underline; color: #666666; } a:active { text-decoration: none; color: #D70000; } --> </style></head> <body> <div align="center"> <table width="900" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="366"><img src="images/layout_01.png" alt="header" width="980" height="366" /></td> </tr> <tr> <td valign="top" background="images/layout_03.png"><table width="975" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="346" valign="top"><blockquote> <blockquote> <p class="style1">.:| <a href="index.htm">Home</a> </p> <p class="style1">.:| <a href="AboutUs.html">About Us</a></p> <p class="style1">.:| <a href="BridalParty.html">Bridal Party</a> </p> <p class="style1">.:| <a href="WeddingReception Details.html">Wedding/Reception Details</a></p> <p class="style1">.:| <a href="OutOfTowners.html">Out of Towners</a> </p> <p class="style1">.:| <a href="GiftRegistry.html">Gift Registry</a></p> <p class="style1">.:| <a href="ContactUs.html">Contact Us</a> </p> </blockquote> </blockquote></td> <td width="629" valign="top"><p> </p> <form method="post" action="guestRSVP.php"> <p class="style1">First Name: <input name="first_name" type="text" id="first_name" maxlength="20" size="30"/> </p> <p class="style1">Last Name: <input type="text" name="last_name" id="last_name" maxlength="20" size="30"/> </p> <p class="style1">Number of guests: <input name="guest_count" type="text" id="guest_count" size="5" maxlength="2" /> </p> <p class="style1"> <input type="submit" value="Submit" /> <input type="reset" value = "Clear"> </p> </form> <p class="style1"> </p></td> </tr> </table> </td> </tr> <tr> <td><img src="images/layout_05.png" width="980" height="57" alt="footer" /></td> </tr> </table> </div> </body> </html>
-
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Guest RSVP</title> <style type="text/css"> <!-- .style1 { font-family: Verdana, Arial, Helvetica, sans-serif; font-size: 11px; color: #161616; } body { background-color: #161616; } a:link { color: #D70000; text-decoration: none; } a:visited { text-decoration: none; color: #D70000; } a:hover { text-decoration: underline; color: #666666; } a:active { text-decoration: none; color: #D70000; } --> </style></head> <body> <div align="center"> <table width="900" border="0" cellspacing="0" cellpadding="0"> <tr> <td height="366"><img src="images/layout_01.png" alt="header" width="980" height="366" /></td> </tr> <tr> <td valign="top" background="images/layout_03.png"><table width="975" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="346" valign="top"><blockquote> <blockquote> <p class="style1">.:| <a href="index.htm">Home</a> </p> <p class="style1">.:| <a href="AboutUs.html">About Us</a></p> <p class="style1">.:| <a href="BridalParty.html">Bridal Party</a> </p> <p class="style1">.:| <a href="WeddingReception Details.html">Wedding/Reception Details</a></p> <p class="style1">.:| <a href="OutOfTowners.html">Out of Towners</a> </p> <p class="style1">.:| <a href="GiftRegistry.html">Gift Registry</a></p> <p class="style1">.:| <a href="ContactUs.html">Contact Us</a> </p> </blockquote> </blockquote></td> <td width="629" valign="top"> <p> <?php if($Submit) { //Connect to and use database $conn = mysql_connect("server", "user", "password") or die ("Logging was not succeeded"); mysql_select_db("database"); //Make variables $first_name = $_POST[first_name]; $last_name = $_POST[last_name]; $guest_count = $_POST[guest_count]; //Make guest_count string and integer $theGuestCount= (int)$guest_count; //Update guest first name, last name, and guest count to guest table $result= mysql_query("UPDATE guest SET guestCount='$theGuestCount' WHERE $first_name=firstName and $last_name=lastName and $theGuestCount<=guestAllowed"); //If update is possible or not possible if (!$result)// Was not updated { $error= mysql_error(); $errorno=mysql_errno(); print("There was an error with your RSVP. Please try again or visit the contact us page."); } else //Was updated { print("Your RSVP has been completed."); } //End database connection mysql_close($conn); } ?> </p> </td> </tr> </table> </td> </tr> <tr> <td><img src="images/layout_05.png" width="980" height="57" alt="footer" /></td> </tr> </table> </div> </body> </html>
-
<form method="post" action="guestRSVP.php"> <p class="style1">First Name: <input name="first_name" type="text" id="first_name" maxlength="20" size="30"/> </p> <p class="style1">Last Name: <input type="text" name="last_name" id="last_name" maxlength="20" size="30"/> </p> <p class="style1">Number of guests: <input name="guest_count" type="text" id="guest_count" size="5" maxlength="2" /> </p> <p class="style1"> <input type="submit" value="Submit" /> <input type="reset" value = "Clear"> </p> </form>
-
now with this code, it loads the php page but it doesn't print anything to the page when the info is submitted. so it doesnt tell me whether or not the code was submitted fine or if there was an error. so the only way it can be checked if i check the database, which is still leaving the guest count at 0.
-
if($Submit) { //Connect to and use database $conn = mysql_connect("server", "user", "password") or die ("Logging was not successful"); mysql_select_db("database"); //Make variables $first_name = $_POST[first_name]; $last_name = $_POST[last_name]; $guest_count = $_POST[guest_count]; //Make guest_count string and integer $theGuestCount= (int)$guest_count; //Update guest first name, last name, and guest count to guest table $result= mysql_query("UPDATE guest SET guestCount='$theGuestCount' WHERE $first_name=firstName and $last_name=lastName and $theGuestCount<=guestAllowed"); //If update is possible or not possible if (!$result)// Was not updated { $error= mysql_error(); $errorno=mysql_errno(); print("There was an error with your RSVP. Please try again or visit the contact us page."); } else //Was updated { print("Your RSVP has been completed."); } //End database connection mysql_close($conn); }
-
so i created theGuestCount variable just as above, i still receive the same error but now its on the line with the </html> tag. sigh..
-
ok.. so i found a solution to my problem... free webhost with free mysql database and can use myphpadmin. so i tested out the code and get this error after the first name, last name, and number of guests are submitted: Parse error: syntax error, unexpected $end in /home/krazigoddezz/public_html/guestRSVP.php on line 106. line 106 on the guestRSVP.php is the next line after the </html> tag. so i went back to make sure i did not miss any curly brackets and they are all there. so the only other thing i can think of is that when the user enters the number of attending guests (guest_count), that the number entered needs to be parsed from a string to an integer. so if this is the case, how exactly would i do that? //Update guest first name, last name, and guest count to guest table $result= mysql_query("update guest set (guestCount='$guest_count') where('$first_name'=first_name and '$last_name'=last_name and '$guest_count'<=guestAllowed)"); would i need to typecast and create another variable in php doing something like: $theGuestCount = (int)$guest_count; or is it possible to do so in the sql query? ill test out the typecast and respond back if it doesnt work. thanks once again.
-
Thanks Faulken but it was a no go. I'm going to try get the localhost problem taken care of. If not I guess I'll have to take another different approach. I originally tried using Visual Studio and for some strange reason, I could not create a database. I'm beginning to think there is actually something wrong with my computer. If individually installing mysql, php, and apache does not fix my little problem, do you have any suggestions on how I should go about doing this aside from using an RSVP page from a wedding website. I'm trying to avoid that since many of them have design restrictions and are pretty much missing the personal feel I would like. If not, its okay. I see the RSVP as an add on to the website, in addition to getting me back into the web design/development groove. Once again thanks.
-
it doesnt work. i keep getting this: and in addition to this.. i cant access the local host.. i reinstalled appserv and configured it and still it wont work.... so in the next few days ill just have to individually install apache, mysql and php....
-
so im getting married in oct (yay) and working on creating an rsvp and guest book for the website. we are reserving seats for our guest because there are tons of people we still want to invite and dont want a bunch of people we dont know coming. right now i find the rsvp a priority and ill worry about the guest book later. i dont know php very well and i know a little bit about sql so im doing the best i can looking through previous posts, college textbooks, and class notes but i feel like im missing something major (i have yet to test this out because i just found out that my access to my database through my university is blocked). what i want to do is create a database has one table called guest. guest will have 4 attributes: first_name, last_name, guest_count, and guest_allowed. The primary keys are of course first_name and last_name. what i plan to end up with is: create table guest ( first_name varchar(20) not null, last_name varchar(20) not null, guest_count integer not null, guest_allowed integer not null, primary key (first_name, last_name) ); i want to add in all the guests on my guest list so when they visit the website they can update the number of people coming since 0 will be the default. so the form is very simple and on rsvp.html: <form method="post" action="guestRSVP.php"> <p class="style1">First Name: <input name="first_name" type="text" id="first_name" maxlength="15" size="30"/> </p> <p class="style1">Last Name: <input type="text" name="last_name" id="last_name" maxlength="15" size="30"/> </p> <p class="style1">Number of guests: <input name="guest_count" type="text" id="guest_count" /> </p> <p class="style1"> <input type="submit" value="Submit" /> <input type="reset" value = "Clear"> </p> </form> so i worked on guestRSVP.php and this is what i have so far: <?php if($Submit) { //Connect to and use database $conn = mysql_connect("localhost", "user", "password") or die ("Logging was not succeeded"); mysql_select_db("database"); //Update guest first name, last name, and guest count to guest table $result= mysql_query("update guest set (guestCount='$guest_count') where('$first_name'=first_name and '$last_name'=last_name and '$guest_count'<=guestAllowed)"); //If update is possible or not possible if (!$result)// Was not updated { $error= mysql_error(); $errorno=mysql_errno(); print("<br/>"); if ($errorno== 1062) { print("<TR><TH> Sorry. Your RSVP was not completed. Please make sure you are entering the name written on the invitation and selecting the number of guests less than or equal to the number of your reserved seats.</TH> </TR>"); } else//Was updated { print("<br/>"); print("<TR><TH> Your RSVP has been completed.</TH> </TR> "); } //End database connection mysql_close($conn); } else { echo("problem with submit"); } ?> i have a strong gut feeling that something is wrong with: //Update guest first name, last name, and guest count to guest table $result= mysql_query("update guest set (guestCount='$guest_count') where('$first_name'=first_name and '$last_name'=last_name and '$guest_count'<=guestAllowed)"); i think it has to do with the '$guest_count'<=guestAllowed. I don't want the guests to be able to update their record if i specified that they can have only 3 guests and they are trying to put down 5. i have also thought that i might want to make a second table and name it theRSVP which has the foreign keys of fname and lname and gAllowed and have guestCount as a regular attribute. i know this is something simple, it just that im very skilled in doing this. thanks so much in advance for any replies.
-
i actually did not know about blender underground. most of the time i refer to the book and the tutorials on blender . org. most of the tutorials i have looked up were on lighting since that is my weak point. and i would agree with the videos are lengthy but im pretty sure they would be very helpful. and lynda . com helped me learn dreamweaver when i was not able to figure things out on my own. i wouldnt be surprised if there is a book for blender. and also thank you for sharing the computer arts site. i will have to look through the tutorials when i have the time.
-
New to CSS - how to put background color into style sheet?
krazigoddezz replied to mrhello's topic in CSS
i think all you have to do is add background-color to #body. #body{ margin: 0px; padding: 0px; font-family: Verdana, Geneva, Arial, Helvetica, sans-serif; font-size: 13px; color: black; background-color: silver } and to link a web page to the style sheet, you need to add: where style.css is the name of your css file. this line needs to go the head tags. for example: Your Page hope this helps. you should check out w3school's site. it is full of helpful tutorials. -
MacRankin, thanks for the titles. i will have to look them up when i get the chance. as for blender, i completely understand what you are saying about being overwhelmed. i freaked out when i first saw the interface, and i thought 3ds max had too much going on. if are really interested in learning blender, get a copy of The Essential Blender by Roland Hess, or even check out the blender wiki. blender is an amazing program, i made my avatar using blender.
-
i do have the new link from auntie in a saved email somewhere. i think python would work very well for me. i do 3d modeling in blender 3d and from what i understand, the programming is done in python. i tried doing some php about a week or two ago, it didn't look that difficult, but i was overwhelmed with it because of a project due, so i mostly copy and pasted without completely understanding it. when my semester is over, i plan o going back to read up on it. And thats pretty funny. i might actually look for that book. it would be great restroom reading material.
-
thanks tkg and lsw. most of the stuff i have learned has been self taught, which is much of the reason way i dont feel i have learned much in the past four years. i got into web design about the same time as you lsw, but the big difference is that i was only about 12 years old at the time haha.. through the years i taught myself basic html through msn groups and wed design, the lovely group we were from, helped me out a lot especially with understanding usability. but because of the limited things groups could do, i went on to myspace and taught myself css. but i eventually hit a road block. i didnt really understand the programming so my senior year of hs, i took a class on vb and realized then, i dont like programming.. haha.. so when i started college i took the simplest language offered which was qbasic so i could get a better grasp on the basics. i then tried java and i did horrible. i was ditching class so i could get help to pass the class. i was so happy i passed with a D.. i went to class everyday and did the homework, but the teacher was not very helpful when i asked questions and i failed almost every test. that was when i decided that i would never be a computer science major. i then took a class on html and xhtml because the instructor wouldnt let me challenge out of it because i didnt know how to use frames at all or tables very well. i told him i usually use css, but i was stuck in the class for the semester. the next year i took javascript and was actually happy i took that java class since the languages looks so similar. by that time i started using director (which was stupid since not very many people use it), but the lingo was helpful for me when i started to learn actionscript. i never really got into using actionscript because the flash class i took was an electronic art class. the actionscript class that was being offered was canceled because i was the only one interested in taking it... this year i think was the most productive year i had. im enrolled in two classes: one on asp.net and visual studio and the other is on databases. the database class which was specifically for web development was canceled because only 5 people were signed up for it, so we were put into a computer science majors only class on databases and file management. we only stayed for the database portion and stopped going for the file management so we could go on independent study to create a website which uses php and mysql. of course none of us learned php so this week has been interesting. im just happy the project is over with and due tomorrow. but getting back to something that you mentioned lsw, i would not want to teach web design in high school, but 3D modeling is what i would most likely want to teach. if i did teach web design, i wouldn't even know what aspect i would like to teach even if i did have the experience or the skills. as for marry the rich guy, i would agree with tkg that i wouldnt be happy. thats what i tell my father all the time, i dont want to marry someone who will never be around because they are always working or are going crazy because of the stress from their job. but i will check out the flex thread when my semester is over and when i have the most free time. thanks guys for your feedback!
-
so im graduating with a ba in communication studies with a multimedia concentration and i will earn my certification to be a web designer later this month... but personally i dont feel i learned enough to make my way into the real web design world, so im considering going for a masters.. i was looking at csu-east bay which is only about an hour or 2 away from me, but im curious if anyone has gone there and are willing to share their experiences? also if anyone knows of any accredited online grad programs that would be great... even a masters in digital media or web development would be awesome.. i do think that some schools dont do a very good of teaching multimedia. my uncle, who works in this field, keeps telling me to not worry about it because I will most likely get trained, but like i said, i dont feel confident that my skills will do me much help in even getting an entry level position. so i feel like i need to go back to school. i hate the scripting and coding of computer science because i have a hard time with it and i cant do the art, designs, and layouts on pages for hours straight... ive been told that im in the wrong field if i dont like to one or the other. i ditched my thoughts of becoming an animator in high school when i got tired of drawing and doing simple 2d animation. im even considering getting a teaching credential to teach multimedia in a high school if i am unable to find a masters program or going for a ba in interior design since i seem to be pretty good and enjoy 3d modeling. ive given this a lot of though over the past year and evaluated the pros and cons of each and they all come to the same conclusion: what i want to do is to create things that people can appreciate through interaction or by simply looking at it through any medium. i realized this about a year or so into working as a cake decorator. i know ive gone off on a tangent, but i need some serious counseling and guidance. the advisors at school arent much help and my friends and family tell me to not worry about it and do what will make you happy or tell me to go marry some rich guy who will support me. so do you guys think a masters might be a waste and i should just get an entry-level and learn that way or should i really reconsider my career plans or something differently? sorry for the long message, but i appreciate any advice.
-
I finally got it to work. Instead of the REVIEW_NUMBER in the WHERE clause, I had to use COUNT(REVIEWER_ROLE). They I got another error that I couldn't use the SSN and COUNT(REVIEWER_ROLE). I had to use GROUP BY because I didn't know that you can't have a column and a COUNT in the SELECT statement without GROUP BY. So it finally came down to: SELECT SSN, COUNT(REVIEWER_ROLE) AS "REVIEWED" FROM REVIEWS GROUP BY SSN HAVING COUNT(REVIEWER_ROLE) >2; I really appreciate the little hint you gave me LSW! I can finally move on to the website for this.
-
LSW, it did not work, but very helpful. I didn't know I could use COUNT like that but it makes sense. The error I get is: WHERE REVIEW_NUMBER > 2 * ERROR at line 3: ORA-00904: "REVIEW_NUMBER": invalid identifier and what used was: SELECT SSN, COUNT(REVIEWER_ROLE) "REVIEW_NUMBER" FROM REVIEWS WHERE REVIEW_NUMBER > 2; I looked up the 904 error and added the quotes to REVIEW_NUMBER and removed the AS... So I'll try to do a little more research tonight. Once again, thanks!