SitePoint Sponsor

User Tag List

Page 1 of 2 12 LastLast
Results 1 to 25 of 43
  1. #1
    SitePoint Zealot
    Join Date
    Jul 2001
    Location
    Grosse Pointe Farms, MI
    Posts
    129
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    ASP/Access Database

    I have a little site that I use to show my family/friends what I am doing while at college. I had been using FrontPage 2K to make it (www.udayton.edu/~riddell/index.asp), but wanted to learn how to make quality internet sites. So I learned some JavaS and a tiny bit of ASP [I mean almost none].

    I want to make the site DB driven so that I can change the format easy and make updating a breeze. The new site is home.earthlink.net/~maclake/. I want to have the following parts dynamically added to the page via the DB. The side menu, the main area and the top "title" bar (on the index this reads "Welcome to RYAN.com - RC3").

    The main area & title bar will be the easy parts. The part with the menu is that I want a seperate menu for each page, so that the page that I currently am on has a blue ("171A5E") bkground to identify the fact that the user is on that page. Then all the other links act normally. I can clear this up if it is unclear.

    My question is this . . . should I go w/ ASP & Access, ASP/mySQL, CF/(access or mySQL) ????

    like I said, this will not be an extremely giant site, just mainly for learning.

    Also, where can I learn this stuff??? On the net all I find are tutorials that are VERY basic or way over my head... If I must then I guess I will buy a book, but I would prefer an online tut.

    Enough of my rants, any help would be great!
    Ryan

  2. #2
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, it all depends on what Earthlink supports. If they support ASP, i'd definitely recommend it. I'll teach you whatever you need to know (a personal undertaking, even.) You can use ASP/MySQL, although I'm more familiar with ASP/Access.

    Of course, it's a matter of personal preference. Have you used any other languages? If so, you might want to consider the following: ASP is attributed to Visual Basic, Java (somewhat) and other "logic" programming language. PHP has been linked with C++, etc. You'll have to decide which environment you're more acclimated with, although I will say that in personal oppinion, if you take the time to learn an "ASP-Style" language, it will pay off amazingly well.

    As soon as you're ready to start learning, I'll recommend books, sites, etc. And then, just simply post here with your problems.

    Any questions? I hope this helped somewhat.

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

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

  3. #3
    SitePoint Zealot
    Join Date
    Jul 2001
    Location
    Grosse Pointe Farms, MI
    Posts
    129
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have programming EXP in Basic (plain, not visual) & vis C++.

    I would like to do ASP, since the site will only be on earthlink until I get back to school, at which point I will host it on my comp (IIS installed in win2K), so ASP and access will be no prob.

    All recommendations would be great . . . once again I prefer sites since they are free and books can cost a lotta $$$.

    Thanks for the timely reply,
    Ryan

  4. #4
    Yugo full of anvils bronze trophy hillsy's Avatar
    Join Date
    May 2001
    Location
    :noitacoL
    Posts
    1,859
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ColdFusion!!

    CF is the quickest, easiest language to develop web apps in, bar none.

    However if you have some BASIC programming experience then go with ASP. Chances are it'll be easier to host than a CF site as well.
    that's me!
    Now A Pom. And a Plone Nut
    Broccoli Martinez Airpark

  5. #5
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Okay, well, as for sites, check out:If you buy book for ASP, It should be Wrox's "Beginning Active Server Pages", either the 2.0 or 3.0 edition. It taught me most of the stuff I know, and it's the best reference I can have. For 40 bucks it'll teach you everything. Then, you can just come here for the rest.

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

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

  6. #6
    SitePoint Zealot
    Join Date
    Jul 2001
    Location
    Grosse Pointe Farms, MI
    Posts
    129
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    THANK YOU

    I have asked this question on other forums and only received replies such as RTFM and "did you check the internet?"

    I will definitly be hanging out around these forums now.

    THANK YOU.

    HILLSY: What do you need on a server to host CF pages? I know for ASP you need IIS (or PWS for 9x) and you need PHP xtensions 4 PHP, do you need CF xtends for CF?

    Once again the entire purpose of this is to learn (preferably one language at a time ), but I would like to eventually learn CF.

    Thanks again,
    Ryan Riddell
    :- :-

  7. #7
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Location
    Florida
    Posts
    29
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hey goober,

    Nice list of links . . . I thank you too. Since I'm trying to decide between the ASP or PHP route as well, I've been watching these threads. I appreciate the willingness to help others that is shown in this forum. Very refreshing.

  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)
    Mark,

    why, thanks for the compliment.

    You'll find sitepoint to be one of the most valuable resources for all languages, whichever one you may choose.
    Sean Killeen [LinkedIn] [Twitter] [Web]

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

  9. #9
    SitePoint Zealot
    Join Date
    Jul 2001
    Location
    Grosse Pointe Farms, MI
    Posts
    129
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Grrr....

    Ok, I went to a few of those sites (aspin.com mostly) and went through the BASIC database tutorials, but to no avail. . .

    I keep getting:
    Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
    [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'PRODUCTS'. Make sure it exists and that its name is spelled correctly.
    /learning_space/asp3.asp, line 17
    I have never used access, so maybe I screwed up there? I can send you the DB file if you want . . .

    Again, thanks for all the help, GOOBER: YHPM,
    Ryan

  10. #10
    SitePoint Zealot
    Join Date
    Jul 2001
    Location
    Grosse Pointe Farms, MI
    Posts
    129
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    HA HA HA!!! I GOT IT!!!

    He draws back, fakes to the left, to the right, BACK to the left! Puts it up . . . its going . . . going . . . going . . . NOTHING BUT NET!!!!

    Just sat arround playin' with it and all of a sudden that error go bye-bye and Ryan is a VERY happy person!

    Sorry about the third person there, couldn't help it!

    Now to just DB my site . . . . . . . . . . . . . . . . . . .

    Thanks to EVERYONE, esp GOOBER!

    Ryan Riddell

  11. #11
    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)
    k, this is my first post on the board, so be nice to me

    neway... im developing a site that is going to have free ASP stuff for people to download, http//e4ums.oreosnbeer.com .

    You have to keep in mind that the site is no where near complete, and its missing alot of content, i jus havent had time to work on it for the past mth, ive got 6 out-of-work projects, and 16 in-work-projects


  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 what does your post have to do with this thread? Sounds like spamming to me. tsk-tsk.

    Please explain yourself.
    Sean Killeen [LinkedIn] [Twitter] [Web]

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

  13. #13
    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)
    sorry if it came across as that , jus teh guy was talking about using usign premade asp apps, and i figured he might like something that ive got on the site

  14. #14
    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)
    goob, go easy on him

    He's new here and a good friend of mine
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  15. #15
    SitePoint Zealot
    Join Date
    Jul 2001
    Location
    Grosse Pointe Farms, MI
    Posts
    129
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    welcome dhtml....

    if I am "the guy" then what I want is a tutorial where I learn how to use ASP/Access. If it was just given to me (ie use this script and your site will be databased) then I would learn little to nothing . . .

    anyways, welcome to the board from one "newbie" to another.

    Ryan
    Michigan looks like your left hand . . . half way between your wrist and the base of your thumb is where I live.

  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)
    DBPath =Server.Mappath("sc.mdb")
    Set Con = Server.CreateObject( "ADODB.Connection" )
    Con.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & DBPath
    Set Rec=Con.Execute("SELECT * FROM navbuttons WHERE section='blank' ORDER BY id")

    The above is how to connect to an access database.

    Areas you need to be aware of are:

    Server.Mappath("sc.mdb") needs to be changed to your database name.

    Set Rec=Con.Execute("SELECT * FROM tablename WHERE condition") is an SQL command.

    The way it works is "Con" accesses resources on the server which allow a connection to a database. The Con.Open statement specifies the driver and database type as well as including the database path we specified up top (I do it on the top line so it's easy to find ).

    SQL is then used to find what you want in the database.

    As far as actually using the data, well, that's a whole other lesson, but suffice it to say that the SQL query will return a number of records (rows in the database) which you will need to cycle through or sort or whatnot.

    So, from the above example we could do:

    x=0
    WHILE NOT Rec.EOF
    x=x+1
    response.write Chr(9) & "hello, I am row " & x & Chr(10)
    WEND

    And that would cycle through the rows and simply count them. To access elements from that row do Rec("columnname").

    That's a quick rundown, hope it helps a bit.
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  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)
    Studiococo,

    my apologies. I was a little harsh, had a bad day this morning.

    I hope you forgive me, as I'm not usually like that.

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

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

  18. #18
    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)
    No worries mate

    What are the odds of "next time" being a reply to my pm?
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  19. #19
    code addict Abstraction's Avatar
    Join Date
    Apr 2001
    Location
    Des Moines, IA
    Posts
    346
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by goober

    Of course, it's a matter of personal preference. Have you used any other languages? If so, you might want to consider the following: ASP is attributed to Visual Basic, Java (somewhat) and other "logic" programming language. PHP has been linked with C++, etc. You'll have to decide which environment you're more acclimated with, although I will say that in personal oppinion, if you take the time to learn an "ASP-Style" language, it will pay off amazingly well.

    'Till next time..
    ASP is not a programming language. I think you mean VBScript.
    You can also write ASP's in Perl, Python, JScript, and maybe some others.
    VBScript is a subset of Visual Basic. It has hardly anything in common with Java.

  20. #20
    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)
    Someone is being incredibly nit-picky today.
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  21. #21
    code addict Abstraction's Avatar
    Join Date
    Apr 2001
    Location
    Des Moines, IA
    Posts
    346
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Nah, just factual. It's a good thing to start beginners out with correct information. I'm sure most people knew what you meant, but someone with no prior knowledge on the subject won't.

    Just trying to help him out.

  22. #22
    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)
    goober (the person you quoted) is hardly a beginner.

    However, thanx for being helpful. Maybe (something I try and do myself) you could frame it with "for beginners: " or something, but wahtever
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  23. #23
    code addict Abstraction's Avatar
    Join Date
    Apr 2001
    Location
    Des Moines, IA
    Posts
    346
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Originally posted by studiococo
    goober (the person you quoted) is hardly a beginner.

    However, thanx for being helpful. Maybe (something I try and do myself) you could frame it with "for beginners: " or something, but wahtever
    No, no, the person who was asking for information originally doesn't know much about ASP/VBScript/PHP/etc. I wan't trying to say goober is a beginner.

  24. #24
    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)
    Fair enough, I stand corrected... or whatever... I stand/sit somewhere... for something...
    SVP Marketing, SoCast SRM
    Personal blog: Strategerize
    Twitter: @jeremywright

  25. #25
    Say WHA?! goober's Avatar
    Join Date
    Sep 2000
    Location
    United States
    Posts
    1,921
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I believe you were talking about ASP's (Application Service Providers), which i was not.

    ASP uses VBScript as the base language, but added it's own modules, etc, and is highly changed from just VBScript. VBScript is a client-side language as well. ASP is not. Active Server pages is very different than you seem to have observed.

    Studiococo, thanks for sticking up for me in my absence.

    As far as being compared to Java, I haven't used java much, so i'm sure I could've made things a bit clearer. That may have been a false fact, and I'm sorry if i misled anyone. The logical object-oriented styles of the languages were what I was comparing.
    Sean Killeen [LinkedIn] [Twitter] [Web]

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


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
  •