I'm brand new...

[Greelmo]

I'm brand new to asp, and i wanted to know...
is there a way to actually make a database that can be accesed in an asp file?
is it global.asa?
I have absolutely no idea what i'm doing, so if any of you have a nice easy tutorial it would be greatly appreciated.
Oh, and i program in javascript, so i have a lot of experience with that. The tutorials i'm finding show me stuff in JScript, which i dont know.
THANKS!!!

[khaki]

hi Dex...

give www.asp101.com a try (go to the samples link).

then come on back when you have questions :)

it's a start...
;) k

[Greelmo]

but how do i do a data base in JavaScript? That site shows only JScript

[khaki]

okay...
let's try this again.
http://www.asp101.com/samples/db_simple.asp

(hint: it's not JScript) :)

;) k

[Greelmo]

could you actually go through and explain to me how it works? If not i understand.
thanks

[khaki]

hi Greelmo....

I really don't mind explaining the basics (although I already provided a good link that would probably explain it better than I ever could :rolleyes: )...

but...
let me ask a few questions:

you asked this question in the ASP forum (you know that... right?)

so you are expecting an ASP solution (right?)

and you are not expecting a javascript solution (right?)

and your server supports ASP (right?)

and so...

if you answered "right" to each of those questions...
we can move to the next step :)

so... do you have a database already set-up?
if so.... we can start there.
if not... you need one so that we can begin.

let me know when you are ready...
and we'll ride the next wave that crests...

waiting-out the sets...
;) k

[Greelmo]

My computer doesn't support asp, but my server does (brinkster.com)
I have no idea how to even set up a database.
could you help me with that?

[khaki]

okay Dex...

we'll take it in small steps then ;)

do you have MS Access on your computer?
(please say yes... unless of course you don't ;) )

if so...
we can use one of the sample db's to get you started.
...unless, of course, you are feeling adventurous and want to create a simple database of your own using the wizard (which would be a good idea to do... since it's important to have at least a basic understanding of databases if you are going to access them via ASP pages).

let me know when you are ready to continue...

;) k

[Greelmo]

i'm on an imac... all i know is that asp works on brinkster. I'm telling you, i know absolutely NOTHING about this stuff... i just know basic stuff like transfering form variables and stuff...

[khaki]

well Dex...

you may actually be too green for me to help you.

ASP and database integration generally requires at least some familiarity with ASP or databases.

but this makes me curious....
why are you looking to use ASP and connect it to a database in the first place?

normally it requires some sort of need...
but if you don't have either database or ASP knowledge...
I can't imagine why you would be looking to do it at all.

My suggestion:
Get a hold of Access and learn the basics.
Then see if it is anything that even interests you (databases are not for everybody - you gotta have the head for it).

After that... you should go to www.asp101.com (as suggested earlier).

hope that helps in some way...
;) k

[Greelmo]

a client wants a database that they can edit... I understand how databases work, i just don't know how to go about setting one up.. could you talk me through it step by step?

[khaki]

well...
ya gotta answer the questions y'know ;)

do you have Access?

if not... what db app do you have?

i'm not making any promises Dex...
if the scope of the project requires too much help...
you should just refer your client to me :)

let me know about the db situation...
;) k

[Greelmo]

been reading up on it, and i've got it all figured out... thanks though!

[khaki]

been reading up on it, and i've got it all figured out... thanks though! WOW!!!
I've been reading-up on this stuff for years... and I still haven't got it all figured-out ;)

okay... whatever :rolleyes:

(note to self: learn faster :) )
;) k

[Ribeyed]

Khaki,
i am totally amazed are your teaching skills, very well done top of the class:D

[khaki]

lol... thanks Dave! :)

my secret is "ASP by osmosis"

(although I must remember to allow myself time to stabalize... or I will drain the conditionals and queries right out of myself :) )

my work here is done :) ...
;) k