Web survey

[jocoutts]

My company are keen to have online questionnaires on several of their websites feeding into databases. Having no experience of SQL and .asp, I am unsure what to advise them.
I have been involved in developing websites for some years now, but surprisingly, never at this level. I understand there can be many complications if our server doesn't support these types of files.
Has any software been developed yet that could make this job easier for a novice like me? Is there such a thing as Access for web?
How difficult is SQL? Or should we look into paying a software engineering company to set up these surveys?

 

[rskuse]

Have you looked into PHP and MySQL? I do not claim to be a coding guru but I have implemented an online questionnaire for a customer website which feeds information into a MySQl database using PHP.

There are several beginners tutorials out on the web and I'm sure you would be able to pick it up in no time!

 

[onpnt]

How difficult is SQL?

my opinion SQL is the easiest language to learn. it is by far the most standardized language ever created thus you learn it you knwo it for any platform with minor syntax changes. of course if your on oracle that may very, as oracle likes to be different in pl.

a online questionair would be a good place to start as far as server/client scripting goes. Access DB's would be all you would need and the coding for the server (asp) side of things would be simple. Unless the forms become to complicated all you need as far as SQL goes is the update/insert/select statements from SQL. there should be hundreds of prewritten DB based examples on the net. even searching for guest book asp should turn up hundreds of examples to modify to a questionair type form

_____________________________________________________________________

[sub]
Hakuna matata!![/sub]

 

[cyclegeek]

Take this post with a grain of salt because the previous posts that suggest using ASP to feed data to MySql or Access databases are probably the best bet, even if you're a sql newbie.

If you're totally new to data access stuff and the amount and kinds of data are not exceedingly complex then you might consider an xml solution. You could get up to speed with it pretty quickly with just a few tutorials from w3schools.com PLUS, the XQuery specification which is a set of rules for querying an XML document like one would query a database, was recently adopted by the W3C consortium. CAN YOU FEEL THE EXCITEMENT?(glavin).

Cheers,
cyclegeek

 

[harrymossman]

I recently put up a questionnaire using ColdFusion (

http://sacramento.fws.gov/es/default.htm/).

Coldfusion has a fairly low learning curve, lower than asp. However not all hosts cover cfm so you should check with yours first.

Harry