SitePoint Sponsor

User Tag List

Results 1 to 19 of 19
  1. #1
    SitePoint Enthusiast stephan_100's Avatar
    Join Date
    Nov 2001
    Location
    Toronto, Ontario, Canada
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Beginnier with asp

    Hey im a begiiner with asp, and dont really know anything!

    Im starting to learn some stuff like how to write some programming in asp and sql, and also how to mak databases. my question, where does all the coding go to make changes to a database. i tried just adding it into an asp script, but i heard that there is bunch of stuff i have to add to open the file, then i could make the changes.

    If you know how to do this, could you please give me some pointers
    Thank-you
    Stephan M.
    Computer Forums -- Supplies All The Help You Need
    http://www27.brinkster.com/cforums

  2. #2
    SitePoint Enthusiast stephan_100's Avatar
    Join Date
    Nov 2001
    Location
    Toronto, Ontario, Canada
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help!!!

    plzzzzzz....
    could anyone help me?

    i really need some help with exactly what i have to do to make m sql scripts to work.

    thank-you


    ps. this langauge is really confusing.....
    Stephan M.
    Computer Forums -- Supplies All The Help You Need
    http://www27.brinkster.com/cforums

  3. #3
    SitePoint Wizard silver trophy Jeremy W.'s Avatar
    Join Date
    Jun 2001
    Location
    Toronto, Canada
    Posts
    9,123
    Mentioned
    2 Post(s)
    Tagged
    0 Thread(s)
    Hmm... Have you ever done any server side development before? If not we'll have to teach you how client and server really interact (it's a bit confusing at first, but makes lots of sense later) then we can get into how to actually "do the stuff".
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  4. #4
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    precise what Jeremy said.

    Tell us your experience and what you've done before, and we can help you.

    Also, before you edit a database, you do have to open a connection to it, but we'll get to that later.
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  5. #5
    How Much Money?
    Join Date
    Aug 2001
    Location
    Liverpool, UK
    Posts
    172
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    you are qquite brave learning a new language i think it is a mix with me between cant be bothered and dont want to fail. i would rather not learn it than try and fail.

    that is a bit of a defeatest attitude i know but never mind i am happy

    Matthhew Taylor
    AutomatedLinks.com
    Boost your search engine ranking, by increasing your link Popularity,
    Dynamically.

  6. #6
    SitePoint Enthusiast stephan_100's Avatar
    Join Date
    Nov 2001
    Location
    Toronto, Ontario, Canada
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thankyou for helping me

    Well do far I have dont HTML, DHTML, and JAVASCRIPT. I would like to thank-you for helping me out. I'm just making a webpage right now, and I would like to make a user-log in, so that i could keep track of everything and have security on my site. I learned that the best way to do thid id with ASP, so that is what I am trying to do. As I had said above, I'm pretty good with those languages and know how to use them. I also know that server side scripting lets all the scripting be done on the server, so that none of the script can be viewed by the users unless it is downloaded. I also know a lot about STYLESHEETS. I dont know if tht will help me at all, but it's worth a try. Anywayz, if you have any pointers at all about learning ASP and SQL, i would really appreciate it.

    Thanks
    Stephan M.
    Computer Forums -- Supplies All The Help You Need
    http://www27.brinkster.com/cforums

  7. #7
    SitePoint Enthusiast RogueJedi's Avatar
    Join Date
    Oct 2001
    Location
    Texas
    Posts
    96
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    You can also look at the Database Connectivity article on the 4guysfromrolla.com website. They have a lot of good articles that I'm finding useful, and that will probably help you as well.
    Rob Nolan
    Do or do not, there is no try.

  8. #8
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Whoa, whoa, whoa. Dont' worry about Database connectivity yet as you don't have to learn that for some time.

    I would recommend buying "Beginning ASP 3.0" by Wrox Press. It is the best book you'll ever read for beginning ASP.

    Also, you have to make sure that your host supports ASP. If a host doesn't have ASP capabilities, then no matter how much you code for ASP, it won't work. So, save yourself some hassle and check first.

    Another thing: I find that, while ASP can be used with JavaScript, it is best used with VBScript. I was a JScripter for a while, but after using it with ASP a few times I decided that VBScript was much better and better suited for the purpose. So, I would also recommend picking up a VBScript reference book by Wrox (not now, but in the future when you become more advanced).

    In short, it's a lot of reading and a lot of experimenting/coding, but it's well worth it and you'll be able to do things with your web site that you never thought you could.

    'Till next time..
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  9. #9
    SitePoint Enthusiast stephan_100's Avatar
    Join Date
    Nov 2001
    Location
    Toronto, Ontario, Canada
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I've already started to lean some ASP using VBSCRIPT on www.w3schools.com. Thanks for the tips on differen ways that i can learn this. I hope i have some luck with this because i didn't have any with flash.

    thank you
    Stephan M.
    Computer Forums -- Supplies All The Help You Need
    http://www27.brinkster.com/cforums

  10. #10
    SitePoint Enthusiast stephan_100's Avatar
    Join Date
    Nov 2001
    Location
    Toronto, Ontario, Canada
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    help!

    So could anybody tell me how to connect to the database using SQL, so that i could start making my database, and setting everything up. I got pretty mush everything else under control.

    thanks
    Stephan M.
    Computer Forums -- Supplies All The Help You Need
    http://www27.brinkster.com/cforums

  11. #11
    SitePoint Enthusiast stephan_100's Avatar
    Join Date
    Nov 2001
    Location
    Toronto, Ontario, Canada
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    please help me!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

    Can you please help me!
    What I need help with, is knowing how I could make changes to a database using SQL. I already know most of the SQL commands, all I need is how to connect to the file. I am using brinkster.com as a host, and they support ASP and SQL queries. All I need to know is how to open up the my database file in my Brinkster database folder, and then ill put all my SQL queries, and then i need to know how to close the file again.

    I really need some help on this asap, so then i could get my site up and running.


    Thank-you
    Stephan M.
    Computer Forums -- Supplies All The Help You Need
    http://www27.brinkster.com/cforums

  12. #12
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    And you know all the basics of ASP?

    There's so many different ways to do this, that I'm going to recommend some good web sites and some books.

    "Beginning ASP Databases" By Wrox. Excellent book.

    Also, some web sites:

    http://www.4GuysFromRolla.com
    http://www.ASP101.com
    http://www.DevGuru.com
    http://www.ASPToday.com

    Check them out. Search for Databases and the like.

    Hope this helps somewhat.
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  13. #13
    SitePoint Enthusiast stephan_100's Avatar
    Join Date
    Nov 2001
    Location
    Toronto, Ontario, Canada
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thank-you, but.............

    Thank-you for recommending these sites, but all I really need to know is how to connect to my database and open up the file so I could make changes to it using SQL statements. Than all I need to know is how to close the file and disconnect to the database.

    If anyone knows how to do this, that would be great, and a big help.

    Thank-you
    Stephan M.
    Computer Forums -- Supplies All The Help You Need
    http://www27.brinkster.com/cforums

  14. #14
    SitePoint Wizard
    Join Date
    Jan 2001
    Location
    Milton Keynes, UK
    Posts
    1,011
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    stephan_100, try this article at asp101.

    You need to use the ADO Connection object. You specify the db, userid, password and any other connection details in the connection string property of the Connection object.

    You can assign this property either directly or when you call the Connection object's Open method (the asp101 article using the latter). Once you've set the connection string property and called the Open method you should have a connection to your db, assuming that no errors occurred.

    In the asp101 article the connection is closed and the Connection object destroyed in the last few lines.

    Code:
    ...
    cnnSimple.Close
    Set cnnSimple = Nothing
    ...
    ADO Connection string examples
    MS links
    Connection object
    Making a connection

  15. #15
    SitePoint Guru davedibiase's Avatar
    Join Date
    Aug 2001
    Location
    Toronto, Canada
    Posts
    829
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    rofl...

    This is simple steve, meet me at guidance computers on Monday and I will explain some stuff to you. You still need to learn some basic syntax and important factors before you can understand what the lines of code are actually doing.

    Also on another note, there are two basic ways of connecting to a DB...there is:

    System DSN and File DSN

    System DSN can be accessed universally on a computer system. In your control panel you should have a Data Source Managment console. (ODBC managment).

    This is the control panel to add/edit you System DSN connections. You choose the System DSN and click add database. Enter the information then you choose the location of the database (can be virtually anywhere).

    Now in your scripts you must connect to the DSN with special code *which I do not currently have on me, but will get you some at school*. Say your script was in a diff location then your databae it wouldn't matter.

    Now file DSN connects to the actual file rather then going through ODBC. Therefor you must add a location of the databae ever time. Here is some database connectivity code:
    Code:
    strConnect = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("./databaseName.mdb")
    SET conn = Server.CreateObject("ADODB.Connection")
    conn.open strConnect
    GetUser = request.cookies("vfuser")("Username")
    Now conn is the connection...when you say conn.open (its getting the database) to close the database you use
    conn.close
    conn = Nothing

    some basic lines for SQL are:
    the info in <> are information you must add!
    Code:
    'to retrieve information
    Set <VARIABLE> = conn.Execute("SELECT * FROM <DATABAES TABLE> WHERE <FIELD OF DATABASE> = '" & <CORRESPONDING INFO> & "'")
    'to insert a record
    conn.execute("INSERT INTO <TABLE>(<FIELD INFORMATION HERE>) VALUES ('" & <INFORMATION> & "')")
    'this insert code can be expanded to allow many more fields to be filled in *ask me at school*
    'update record
    conn.Execute("UPDATE <TABLE> SET <FIELD> ='" & <INFORMATION> & "' WHERE <FIELD> ='" & <CORRESPONDING INFORMATION & "'")
    'delete records
    conn.Execute("DELETE * FROM <TABLE> WHERE <FIELD> = " & <CORRESPONDING INFORMATION>)
    That retrieve database information line will only target which record in the database to take info from. To retrieve information from that record you must enter.
    <VARIABLE>("<FIELD YOU WANNA COLLECT>")
    here is an example:
    Account("Username")
    or
    Account("Password")
    etc.
    ||Dave Di Biase||
    ----------------------------------
    "There are 2 secrets in life. 1) Never say everything you know."
    GFXWARS - The ultimate graphics battle!

  16. #16
    SitePoint Enthusiast stephan_100's Avatar
    Join Date
    Nov 2001
    Location
    Toronto, Ontario, Canada
    Posts
    90
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    thank-you

    thank you so much!!!

    this helped me out a ton! now i think i have a really good basic idea on how everything works and how it all fits together.

    thanks
    Stephan M.
    Computer Forums -- Supplies All The Help You Need
    http://www27.brinkster.com/cforums

  17. #17
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No offense guys, but I strongly disagree with learning database access before more basic ASP programming. It will get you out of whack with the rest of the system in my oppinion. Also, coding basic things first engrains good practices in a web developer.

    You have to crawl before you can run.

    Just a thought -- not that big of a deal, but worth mentioning in my mind.
    Sean Killeen [LinkedIn] [Twitter] [Web]

    Warning: Reality.sys corrupted. Universe halted. Reboot? (Y/N)

  18. #18
    ALT.NET - because we need it silver trophybronze trophy dhtmlgod's Avatar
    Join Date
    Jul 2001
    Location
    Scotland
    Posts
    4,836
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'ld have to agree with goober, no point in learning how to take info out the db before you know how to work with it.


  19. #19
    SitePoint Addict drbones's Avatar
    Join Date
    Nov 2001
    Posts
    313
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    I agree too

    I agree with goober as well,
    However you can learn it this way, as I did.
    It probably took me a lot longer than it should have though just of not having a base to learn off of. I started learning ASP near the middle of september and within a week I had done a search engine. Now I have converted almost all my sites to data driven web sites and would never go back to plain static HTML stuff(even tho it is stressfull on the server)
    Definitely buy the big red book.. I bought it probably in may and never picked it up until september.. very good reference. DEfinitely learn a little vbscript unless you already know VB... Just makes life a lot easier
    Ryan
    *WRITERS* Create How To Guides and articles and get
    75% of the MONEY it makes via Adsense forever!

    Sign up Now! <- $100 Top Poster Contest


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •