Re: some advice please
From: Bob (sdssd_at_no.az)
Date: 07/03/04
- Next message: Richard Marr: "RE: DERuntime not Installed in Win2003 Installation"
- Previous message: Bob: "Re: some advice please"
- In reply to: Jeff Cochran: "Re: some advice please"
- Next in thread: Jeff Cochran: "Re: some advice please"
- Reply: Jeff Cochran: "Re: some advice please"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 3 Jul 2004 10:38:15 +0200
I read something about RDS, where it's possible to access database from VB.
Is this a good idea?
Bob
"Jeff Cochran" <jeff.nospam@zina.com> wrote in message
news:40e5bd78.629952824@msnews.microsoft.com...
> On Fri, 2 Jul 2004 19:07:21 +0200, "Bob" <sdssd@no.az> wrote:
>
> You're putting the business logic on the client side of the app when
> you do this. There's nothing wrong with that, but as you've seen,
> you're doing multiple queries of the database, then posting back to
> the same form. Some of this could be encoded in the page logic, such
> as which hours the courts are open on which days, or you could do an
> initial select for all hours for the next 30 days and then display
> them as available/unavailable in a DHTML page where you unhide
> elements as others are selected (check a client side or DHTML group
> for sample code here).
>
> In essence though, you're doing a scheduling application. Take a look
> at scheduling apps available on the web and see if they will fit your
> needs, or what ideas they generate in your application. Aspin.com
> would make a decent starting place.
>
> Jeff
>
>
> >I have to make a web application in Javascript/ASP for tenniscourt
> >reservation (based on Access database). I would like to do everything
with
> >one page, because the user must be able to change his day, hour or
> >tenniscourt choice before really reserving it . I tried like this:
> >
> >The first SELECT contains the date (next 30 days) and is filled
dynamically.
> >No problem.
> >When the date is chosen (by clicking), the second SELECT must appears
with
> >the right opening hours (monday = 8 -18h, friday=8-16h etc ..). So i need
a
> >query like "select mondayhour, tuesdayhour ... from daytable". This is
no
> >problem because the code can be placed between <% %> just below the
> >first SELECT (set objdc = Server.CreateObject("ADODB.Connection" etc ..).
No
> >form needed because no variable to pass to ASP.
> >
> >My problem is when several tests must be done which require passing
> >variables to ASP.
> >Imagine that you can only reserve 2hours in a day. I need a query "select
> >count(hour) as tothour from reservation where day='" & dat & "' group by
> >logon having logon='" & login & "'" to check it. So i have to pass 'dat'
> >(chosen date) and 'login' (name of user) to ASP via a form that i submit
to
> >this ASP file. The value of tothour can be returned by <%=tothour%> to
the
> >client script.
> >Imagine you can maximum reserve 15 h in 30 days. Again a query "select
> >logon, count(hour) as tothour2 from reservation where cdate(day)> date()
> >group by logon having logon='" & login & "'" . Again a form to pass
'logon'
> >and submit it to itself
> >
> >If tothour <2, then the third SELECT must appear with the tenniscourt
> >numbers which are still available. I need another query like "select
> >tennisnr from reservation where cdate(day)='" & dat & "' and hour=" & hr
> >(hr=chosen hour). I need to pass "dat" and 'hr" to ASP. So i submit
another
> >form to ASP.
> >Etc ...
> >
> >Is this way the right way to work? Does this not become very complicated
and
> >confusing, also because when submitting the second form, the variable
> >passing through the first form are lost.
> >
> >Thanks for any advice.
> >Bob
> >
>
- Next message: Richard Marr: "RE: DERuntime not Installed in Win2003 Installation"
- Previous message: Bob: "Re: some advice please"
- In reply to: Jeff Cochran: "Re: some advice please"
- Next in thread: Jeff Cochran: "Re: some advice please"
- Reply: Jeff Cochran: "Re: some advice please"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
|
