please help me...

[liquid]

as'kum...salam aidilfitri to recom's people.

i've got a problem and i need an opinion. currently, i'm on my practical training for 3 months. i have to develop a survey system using ASP but i don't know much about ASP. i have to know from A-Z. i've a mental blocked for a couple of days. which the best software to develop my system-php,dreamweaver or vb? i need the simple ones. basically, i wanna develop the system on web-based. i've searched many tutorials but i still can't understand. even more worst, i don't know how i'm goin to develop my system...please help me...

[chenchow]

I am sure someone will reply to you very soon...i know how to use PHP, but at quite basic level, just know how to design a message board, and interact with mySQL, not sure that would help or not...

[littlebigone]

Unless you're talking about a different ASP, then I presume you're talking about the scripting language by Microsoft, "active server pages".

php is a scripting language, dreamweaver is a software and vb is a programming language.

So if they ask you to develop using ASP, i guess php and vb is out of the question.

I don't think dreamweaver supports ASP. You need to buy software that supports asp, which is to be expected since it is by M$. I think asp.net 1.1 is free now, but i think you still need to buy the software for the server. I may be wrong. So someone correct me if I am.

But if you're on practical training, wouldn't they provide you all these things already?

Anyway, I think the concepts used in asp is the same as any dynamic scripting languages (php, jsp, etc). So if you need help, just post your more details and requirements and we'll try to answer them best we can.

good luck (=

[liquid]

my friend told me i can use dreamweaver to develop my system. is it dreamweaver doesn't supports asp?? but i've checked inside dreamweaver, i can save my web page in ".asp". basically i've got the database and i have to use mysql to interact with my database because my database in mysql.

basically, this system will operates on client-server (*i do not really understand about this..sorry). i have to develop a survey questions page and it will automatically pop up on client side. then at the server side, there is a full system that admin use to produce a statistic of user that use a computer lab.

i think that's all...thanks for gave me some opinion...but i still need your help

[masterof_none]

DreamWeaver is just an editor to simplify your task .
Actually , you can use any text editor to code your ASP program.
For example, you can use Notepad. (just like you code HTML)
ASP usually work with VBScript. or JavaScript. ASP processed by
ActiveX component.(the scripting engine) .
ASP got objects to work with., etc etc,

I suggest you grab one of those many ASP books at the local bookstore. they usually have good explanation about ASP and its usage.

when you stuck, let us know. I know lot of ReCom members here knows about this. Just have to come frequently.

[jiinjoo]

Agree - grab da book. Alternatively if you want, go through online tutorials. It is redundant to reiterate everything in the book here - I garner from your post that you have not done anything with it before.

Client Server architecture is just a simple idea where the client initiates a connection with the server. Just like when you type www.recom.org into your web browser, your browser is the client and a little powerful box somewhere in usc is the server. That server, upon receiving the request, give you back a webpage, and your browser can then display it for you.

Your .asp scripts is just doing a bit more work on the server side, for example when the client sends a request, the request might contain other information, like your survey results. These survey results needs some processing (e.g. you want to save them to your database), before you response to the request with your thank you message. Get the idea?

Asp is typically served on Windows (dunno if there're open source implementations out there?). So typically, you need to have a Windows box, installed with IIS - microsoft's web server, and your MySQL as you mentioned. Simply search online for examples of how to connect from asp scripts to MySQL.

Good luck, hope all these post gives a good enough idea for you to take a plunge.

[littlebigone]

I have a question. Does asp work with opensource databases like mysql?

[liquid]

how u doin?..sorry...it's been long time i didn't join u all...i was quite busy...i need ur help to check this codes...currently i'm working on login page where admin need to key-in their username and password to get full access on my system. i'm using ms access as my database but i will switch to ms sql server 7.0 soon. could u check this codes for me?



<% if alogin <> "" then
if userrs.recordcount=0 then
session("error")="nologin"
else
if sesion("pwd") <> "" then
passw=session("pwd")
else
passw=request.form("pwd")
end if

if passw <> userrs("pwd") then
session("error")="wrong"
response.redirect("login.asp")
end if
end if
end if %>

if u got any codes, could u tell me...i've been working on this login page for several days....

[jiinjoo]

I have a question. Does asp work with opensource databases like mysql?

Yes certainly. http://www.quadrahosting.com.au/kb/c6_id22.html

The architecture that we have today is in 4 layers
1. Database
2. DB Driver
3. Connection Driver (think i got the name wrong)
4. Client code

The client code is what you write, can be anything, PHP, ASP, Perl etc any scripting language you use and your webserver will execute. The Connection layer is basically things like ODBC (the most general one), JDBC (for connecting Java programs to databases), DBI (connection Perl) etc. This piece is usually language specific.
On the DB side, each DB has a driver that is database specific. Each vendor will write code to talk to each different kind of connection driver. So oracle will have their DBD for jdbc, odbc, dbi, etc. and the same goes for mysql, db2, sqlserver, etc etc etc...

:)

[jiinjoo]

hi liquid,

i'm using ms access as my database but i will switch to ms sql server 7.0 soon. could u check this codes for me?

Firstly I don't know what userconn.asp is. That's ok. From what you said you're sort trying to grab as much ready made stuff online as possible, that's fine as long as you know what you're doing. It is hard to read what you post and made any conclusion whether it "works" whithout looking at everything else. userconn.asp probably went to the database and grabbed the recordset using some session variable, and it checks the password in the session object - session("pwd") - against the password in the database - userrs("pwd").

Hope you can post more specific problems that you have instead of just dumping the whole thing...

[Thirdshifter]

not that i'm doubting the abilities of regulars here. But you won't get as much help here as you could get on boards that specify on web developing. Thanks for the vote of confidence though :)