SitePoint Sponsor

User Tag List

Results 1 to 18 of 18
  1. #1
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    oh no! I have to use ASP

    Hey guys.

    I'm screwed. I just signed a contract with a client who already had their own hosting plan. Upon signing I found out that their already purchased hosting plan is a 2000 server with ASP and SQL. Now I know nothing of ASP. I am still on the learning curve with PHP and MySQL and was looking forward to implementing some of the stuff in Kev's book to help me out. But now I find out that I have to use ASP and SQL. What do you suggest for a newbie to do to learn ASP real fast! I am assuming most of the syntax is the same for SQL and MySQL, and I know ASP and PHP are similar. I have no books on this so the internet and you guys are my only hope. Basic things I'm going to need to know are:

    [list=1][*]How to establish a connection to an ASP database[*]How to form a basic SELECT query (defining the function)[*]tips that are just your basic gotta knows (anything helps)[/list=1]

    I know this is going to be a learning experience and I'm hoping some veterans can give me a few tips. Fortunatley I learn fast and this is probably better in the end.

    Thanks.

    Sketch
    Aaron Brazell
    Technosailor



  2. #2
    SitePoint Guru Husain's Avatar
    Join Date
    Sep 2001
    Posts
    620
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Start with LearnASP. It is an excellent resource for beginners.

  3. #3
    Gone!
    Join Date
    Aug 2001
    Location
    Witty Location Parody
    Posts
    3,889
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The ASP toots I used too get started were Kevins ones on webmasterbase. I dont remember there being one on Connecting to a database!

    Wouldnt it be possible for the client to up/downgrade or change their plan to a PHP plan?

  4. #4
    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)
    Welcome to the wonderful work of ASP Sketch!

    Connecting to a db

    DSNless Connection
    Code:
    <%
    Set objDBCon = Server.CreateObject("ADODB.Connection")
    strConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("databseName.mdb")
    objDBCon.open strConnect
    %>
    DSN Connection
    Code:
    <%
    Set objDBCon = Server.CreateObject("ADODB.Connection")
    strConnect = "DSN_Name"
    objDBCon.open strConnect
    %>
    Getting Stuff From a database
    Now, you might have heard about a recordset, well unhear it. Their crap, and a waste of resoruces and a little over kill for what you generally need to do

    Selecting from a database:
    Code:
    Set getStuff = objDBCon.Execute("SELECT * FROM tblsBlah")
    SQL is your general standard SQL

    Now this is how you would send the stuff to the page:
    Code:
    Do Until getStuff.EOF ' EOF = End Of File
    	response.write(getStuff("Stuff") & "<br>")
    	getStuff.MoveNext
    Loop
    Insert:
    Code:
    objDBCon.Execute("INSERT INTO tblsBlah (stuff) VALUES ('" & stuff_Variable & "')")
    Update:
    Code:
    objDBCon.Execute("UPDATE tblsBlah SET stuff = '" & stuff_Variable & "' WHERE something = '" & something_Variable & "'")
    Thats all I got time to do, if you have any problems, just ask

  5. #5
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I was hoping you'd chime in, dhtml...Thatnks for all the great info. I found out late last night that not only is the plan they are on NOT a Linux/PHP one, unless they upgrade from the $17.95 to the $42.95 plan I don't even get a database!!!!! I shot a couple proposals their way that would migrate me to Linux and to the next up plan or just bumpe me up to the next plan. I must have a database and I prefer the Linux flavor. Anyways, I'll keep you posted. Dhtml, THANK YOU for all this...<printing>. Glenplake, seems Kevin is good for more than PHP/MySQL, eh? Thanks. <bookmarking webmasterbase>

    Sketch
    Aaron Brazell
    Technosailor



  6. #6
    Gone!
    Join Date
    Aug 2001
    Location
    Witty Location Parody
    Posts
    3,889
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Heh, yeah they were only basic ones to get started but the php ones are far more concise. really must get that book though, if I buy it then ill have to justify cost by making full use of it!

  7. #7
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    whew! Got him to move to a new company and server!

    Sketch
    Aaron Brazell
    Technosailor



  8. #8
    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)
    Glad I read all the way to the end, I was going to post a 2 page reply *L*
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  9. #9
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well thank God for that. All we need is another dissertation! DHTML's was enough!

    Sketch
    Aaron Brazell
    Technosailor



  10. #10
    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)
    Yeah well, at the end of mine you could have figured out most of ASP on your own
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  11. #11
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh yeah? bring it on, big boy....<getting the printer ready for another printout>...I can always "archive" until the need arises to use ASP...lol. Or I can just go to the bookstore and buy yet another book...

    Sketch
    Aaron Brazell
    Technosailor



  12. #12
    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)
    Nope, you're being ungrateful

    Actually, unless there's a need I don't feel like it, and you've got your solution. If another member needs it, I'll probably post it
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  13. #13
    Prolific Blogger silver trophy Technosailor's Avatar
    Join Date
    Jun 2001
    Location
    Before These Crowded Streets
    Posts
    9,446
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    hey I understand. Yeah, I really don't need it right now. Thanks anyways.

    Sketch
    Aaron Brazell
    Technosailor



  14. #14
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Two sites that may help (they're my favorite for anything ASP):

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

    Hope they help.
    Sean Killeen [LinkedIn] [Twitter] [Web]

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

  15. #15
    SitePoint Zealot
    Join Date
    Jul 2001
    Location
    Houston
    Posts
    130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    i've got a question

    I understand that ChiliSoft ASP isn't ideal, but ...

    If I use MySQL with ChiliSoft ASP, are all the commands for accessing the database the same. That is, once I've created a connection is everything back to normal or does MySQL require doing things differently?

  16. #16
    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)
    Once you've connected, everything is "normal", but using Chilisoft is not a valid solution, as everything is being simulated so it's slower and prone to... failure.
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  17. #17
    SitePoint Enthusiast
    Join Date
    Jun 2001
    Posts
    87
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    The Microsoft Developers Network site actually has some great resources for ASP. One decent reference article for quickly picking up on using ActiveX Data Objects for communicating to databases with ASP is at:

    http://www.microsoft.com/accessdev/articles/movs202.htm

    hope this helps.

  18. #18
    SitePoint Zealot
    Join Date
    Jul 2001
    Location
    Houston
    Posts
    130
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Jeremy-

    Thanks. I'm stuck on a Linux server right now but hope to switch to NT/2000 soon.


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
  •