Re: personality test

From: Jim Carlock (anonymous_at_127.0.0.1)
Date: 05/01/04 

Date: Sat, 1 May 2004 10:04:45 -0400

Heh, I was thinking the VB meant Von Beuren or some such.

Does DreamWeaver have something that sets up the connections
to a database?

I'm curious about the self-generating code that it develops. MS
FrontPage will set up some code, which is good, but one has to
go through it to remove FrontPage specific stuff and do a mess
of recoding. It works but when you remove all the stuff to get it
down to something readable, you end up seeing it's no more than
10 or 12 statements.

As far as a vb Form goes, you'd use something such as:

Dim db As DAO.Database
Dim rs As DAO.RecordSet
Dim sConn As String
Dim sRS As String

sConn = "C:\apppath\mdbname.mdb"
sRS = "tTableName"
Set db = DAO.OpenDatabase(sConn)
'you can put a table name or SQL into sRS
Set rs = db.OpenRecordset(sRS)
rs.MoveLast: rs.MoveFirst 'used to populate the set
                                                'if needed

Text1(0).Text = rs.Fields(0).Value
'if the field might be empty, ie contain a null value
If IsNull(rs.Fields(1).Value) Then
  Text1(1).Text = ""
Else
  Text1(1).Text = rs.Fields(1).Value
End If
rs.Close
db.Close
Set rs = Nothing
Set db = Nothing

The above is DAO coding, and ADO coding will be very
similar.

Just giving something for you to compare against. 

-- 
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.
"Mike VB" <mike@perchoir.com> wrote:
Hi Jim,
I'll use a form in an asp document like we can see on website's magazine
(cosmopolitain,...)
I'm using dreamweaver to create my asp documents wiht vbscript.
the VB at the end of my name means ....   Another time!!!!
Mike
"Jim Carlock" <anonymous@127.0.0.1> a écrit dans le message de
news:OkF7%23iuLEHA.1388@TK2MSFTNGP09.phx.gbl...
> :-)
>
> If you feel more comfortable with the analysis as another table,
> that will work. It will provide a quicker manner in which to
> access the data if it was going up on the Internet. By the way,
> ASP (I'm assuming you are talking about about using vbScript)
> works in pretty much the same manner that VB does. The
> biggest differences are how the forms are designed. I'm using
> the word form, because an HTML form represents the concept
> of accepting data from an end user (ie, <form> tags in an HTML
> document). A form in VB is the window or dialog that is displayed
> and used to accept data from an end user.
>
> Anything written in vbScript can easily be put into a VB form as
> well. The differences are relatively minor.
>
> Are you using Visual InterDev to create the ASP documents?
>
> And one other question... were you using VBApp or VB ?
>
> And one more question... what's the VB mean at the end of your
> name? ;-)
>
> -- 
> Jim Carlock
> http://www.microcosmotalk.com/
> Post replies to the newsgroup.
>
>
> "Mike VB" wrote:
> Hi everybody,
>
> 1. what about using another table called
> Analysis(AnalysisID,QuizID,lowerBound,UpperBound,Analysis)?
> 2. I quit vb to use asp (more easy to do my application, i think)
> 3. the test is entirely anonymous, someone can play it more time
> 4. for argusy: the word "personality" is not a good terme (lol)
>
>
> Thanks,
> Mike
>  ps:excuse my english
>
>
> "Mike vb" <mike@perchoir.com> a écrit dans le message de
> news:eZdgxhjLEHA.1612@TK2MSFTNGP12.phx.gbl...
> > Jim,
> >
> > this is how i'd like to set it up:
> > i thinks i'm going to use an access database (access 2002 xp)
> > with 4 tables:
> > table1: QuizGroup(GroupID,Topic_Group)
> > table2: Subject(QuizID,GroupID,Topic_Quiz)
> > table3: Question(QuestionID,QuizID,Question)
> > table4:
> >
>
Answer(AnswerID,QuestionID,Answer_A,Answer_B,Answer_C,Answer_D,score_answerA
> > ,score_Answer_B,socre_Answer_C,score_Answer_D)
> >
> > but i don't see how to analyse my data.
> > perahps, i had to use an another table to store my analysis with a
> > lowerbound and a upper bound or a different way.
> >
> > i don't know.
> > Mike
> > ps:excuse my english
> > "Jim Carlock" <anonymous@127.0.0.1> a écrit dans le message de
> > news:O16nb3fLEHA.2576@TK2MSFTNGP12.phx.gbl...
> > > Now you need a plan on how you'd like to set it up.
> > >
> > > Do you want to present the information on one form,
> > > which has next and previous buttons, a label for the
> > > question and a text box for the answer.
> > >
> > > Or you could have one form which displays 100
> > > labels (for each question), with corresponding text
> > > boxes (for an answer to each question). In this case
> > > the form would have maybe two buttons, possibly
> > > labeled close and cancel (or restart or refresh or clear).
> > >
> > > Personally, I wouldn't save the information to the
> > > database until you had a complete data set to save. This
> > > will help keep the database clean and won't mean that it
> > > is kept open all the time.
> > >
> > > And then you need to know how many people are going
> > > to access this database at one time? Could there be 20
> > > people trying to save the data at the same time. Your
> > > answers to these will determine how you configure saving
> > > the information. Is it from a standalone app that will
> > > connect to a master DB at some later time to send the
> > > information to the master DB ?
> > >
> > > -- 
> > > Jim Carlock
> > > http://www.microcosmotalk.com/
> > > Post replies to the newsgroup.
> > >
> > >
> > > "Mike VB" <mike@perchoir.com> wrote in message
> > > news:%231CxJVcLEHA.644@tk2msftngp13.phx.gbl...
> > > Hi,
> > > In fact, Personality test is just an exemple.
> > > Thath i want to do is something like quizzes, as :
> > > ex1: How seductive are you?
> > > ex2 What star is in you?
> > > ex3: Is your Hair Healthy?
> > > ex3: Are You a Safe Cook?
> > > ex4: How Hot is Your Lover in Bed?
> > > and ...........
> > >
> > > with more  test groups, subjects, questions, answers and differents
> > > analysis.
> > > with an access  database
> > >
> > > Best regards,
> > > Mike
> > >
> > >
> > >
> >
> >
>
>
>