| Author |
Topic |
|
elisa
Starting Member
24 Posts |
 Posted - 2005-06-20 : 15:09:28
|
| Hello, It's my first time trying to build an application for work. I have the tools and some time, but not much knowledge.It should look something like this:After a login, you are directed to your personal page where you have 3 options: a- fill out a new form(quote) to submitb- continue filling out a previously started formc- review forms that you have already submittedThe form should have a SUBMIT and a SAVE button.Behind the form I have a SQL server database running on Windows 2003 server.After the form is filled two emails need to go out, one to me and one to the person that has filled the form, with the form attached and ready to be printed. That's it! Easy, right? Now, what I am asking here is for directions and some help while I learn all that is involved, I am a web developer but not a dba, but I am studying SQL server and SQL statements and I know html and some ASP...Anybody wants to help with maybe a summary of all that will be involved? At the end of it it can be posted for future reference to help the next newbie... Ok, I guess the first step is to figure out how to do this. In which order? Thank you,elise |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-06-20 : 15:19:07
|
Steps: - 1 - Define exactly what info you want to collect
- 2 - Determine the best design for your database to store the info
- 3 - Rough Draft your application (web pages and such) and determine if you forgot something in #1 & #2 (If so, Reevaluate #1 & #2)
- 4 - Build Stored Procedures to interface with your webpages
- 5 - Test said sproces in QA (Query Analyzer)
- 6 - Activate Db Connections in Webpages
- 7 - Test sproces in Your App
- 8 - Test your whole App
- 9 - Have someone else test it.
Repeat steps as necessary.PS For form population, you'll probably need adobe or something like it.Corey Co-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now."  |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-20 : 15:25:31
|
| Questions need to be a little more specific.Start with requirements and design. Have these checked off on with your stakeholdersThen do your database design based on what needs to be collected and dispersed. Avoid redundent and denormalized data.This sounds like a intranet app. Use a cookie on the login page and refer to that cookie to keep track of your user.Your options regarding email are various. CDOSYS. SQLMail, xp_smtpmail...Centralize your connection string in a include file, so if it changes you have to change it once. Write stored procedure and not inline sql and only give your users write on the procedures and not the table. Use windows authentication if at all possible. Use REPLACE(@variable,"'","''") on all of your input to avoid sql injection. Don't use cursors in your ADO or SQL. Properly index your tables... Validate your input with constraints and in the user interface.....There are hundreds of things I can say here. You need to be specificSean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
elisa
Starting Member
24 Posts |
Posted - 2005-06-20 : 15:47:59
|
| corey thank you, your list gives me an idea, what I am not sure how to do is step#3 and #4. How to make the webpage interact with the database in such a complicated way. Which statements or procedures do I need to learn? thank you, |
|
|
|
elisa
Starting Member
24 Posts |
Posted - 2005-06-20 : 16:01:27
|
| Thrasymachus, just like your name, your answers are a bit complicated and leave a newbie like me staring blankly at the screen...especially this part "Use REPLACE(@variable,"'","''") on all of your input to avoid sql injection. Don't use cursors in your ADO or SQL."Can we start with the basics first? I am just learning SQL, and if that's what I need to know before I move ahead, I will keep studying it some more, but in the meantime, could I get any of this going?Callicles |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-20 : 16:14:43
|
| vague questions get vague replies.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-20 : 16:27:44
|
| WARNING: Sarcasm imminentOK just give us your sites IP address, Administrator username and password and we will do it for you!!!!No really, There is no basic design, you need to try a little and we will help you through the snags as you run into them.You say appication, what type web, vb, .net, asp.net, http?you do not tell us what you are useing to create your forms.(front end) JimUsers <> Logic |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-20 : 16:34:24
|
| Username and password? Just setup a new install of sql server in mixed mode and leave the sa password blank and we will be right on over. Do not forget to load the credit card data before we come. I need a new laptop and maybe a new couch from IKEA I have been looking at.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-20 : 16:37:25
|
| By the way, the username is a Socratic reference. Too bad they do not make the kids read real books in school anymore.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-06-20 : 17:18:05
|
| elisa,you may want to start with a web-based tutorial on ASP and SQL... which there are many. As Corey and Sean already mentioned, an application begins with solid defined requirements. You wont get far without them :)Have a look here and elsewhere on the web:http://www.aspin.com/home/tutorial/databaseNathan |
|
|
|
elisa
Starting Member
24 Posts |
Posted - 2005-06-21 : 09:55:11
|
| great guys! sarcasm will definitely help me with this SQL thing...Jim, I will be creating the form with ASP and running in on the web with an SQL server database behind it. That's it, really. The question is, where do I write the stored procedures, how do I call them from ASP, and what will they look like (more or less)?Sean, IKEA is cr@p! Buy from Jennifer convertibles... Also, I got the socratic reference (hinted by the Callicles sig.) Nathans, thanks for the link. I'll be back with more questions. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-21 : 10:01:09
|
| You can Use Query Analyzer. but as a newbee you may find it easier to use Access its GUI can make it easyer when you start. Is the Table already on the SQL server and is the SQL server in your domain?JimUsers <> Logic |
|
|
|
elisa
Starting Member
24 Posts |
Posted - 2005-06-21 : 10:35:14
|
| Yes, the table is on the SQL (even if it's not finished) and the SQL server is on a virtual server on my computer right now (for testing purposes). |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-21 : 10:40:14
|
| All of the fun and games aside. Elisa what I wish I did earlier was to read SQL Server Books Online. It is the vast and exhaustive help file that is installed with SQL Server. For your task I would read the following sections.From the Contents Tab,Under Creating and Maintaining Databases you should read the following subjects.1.Stored Procedures2.Databases3.Tables4.Indexes5.Views6.Triggers7.User Defined FunctionsI would read every under Accessing and Changing relational Data and and under Optimizing Database Performance, I would read Database Design, Query Tuning, and Application Design.Then there is the Transact SQL reference section you should use constantly early on.At the same time I would go get a good book on ASP and make sure it is for the version you are working with.The thing about being a good nerd is that you have to read a lot.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
elisa
Starting Member
24 Posts |
Posted - 2005-06-21 : 13:00:07
|
| Thank you Sean, I am going to read some, it is a lot, and see if I can make any sense... elisa ps. I can't qualify as nerd, I am way too pretty! |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-21 : 13:22:28
|
| I have been told that I am rather good looking myself but vanity is one of the 7 deadly sins I lack so I would'nt know. Being a nerd is not on the outside, it is what is inside you and your willingness to expose that stuff to the world. I am a computer nerd, a music nerd, a chess nerd, a political nerd, a philososphy nerd.... but I also go out and party with my friends on a regular basis and they think I am pretty hip.Being a nerd really just means you are smart, knowledgeable about something and maybe a little obsessive.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-21 : 13:33:44
|
quote:
ps. I can't qualify as nerd, I am way too pretty!
Elisa You should not make comments Like that.Now we will hound you till you fill out your Bio and add your Picture. LOL The new MS Access 2003 .adp has an interactive tool for ASP page devopment, you may want to look at it.JimUsers <> Logic |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-06-21 : 13:37:51
|
| >>Being a nerd really just means you are smart, knowledgeable about something and maybe a little obsessive.Yeah, but a pocket protector and tape on the glasses is a dead givaway. I'm also a nerd but I'm drop dead gorgeous. That is if your idea of beauty is 5'2", 235 lbs, a comb-over, and loads of back hair. I know I'm great looking because all the women I pay to have sex with say so.just kiddin'...those women don't really say that.Be One with the OptimizerTG |
|
|
|
nathans
Aged Yak Warrior
938 Posts |
Posted - 2005-06-21 : 13:40:31
|
quote:
just kiddin'...those women don't really say that.
Thats extra. |
|
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-06-21 : 13:46:23
|
| I've come to the conclusion that everyone pays for sex... if you're married or dating its just a different type of currency...CoreyCo-worker on The Wizard of Oz "...those three midgets that came out and danced, the freaked me out when I was little. But they are ok now." |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-21 : 14:14:46
|
| I hear if you are married sometimes you pay and still do not get any.Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
Next Page
|
First Time Developer, maybe