Re: FN-FORUM Problem with a search/response from Iain

date posted 7th December 2001 11:16

from what iains said i believe there just the one client updating.

as for direct connection to the live database(when using something like sql
server or mysql)... i wouldnt want anything
other than internal IP's (preferably just the webserver) being able to
connect to my database box for security reasons.

----- Original Message -----
From: "Alan Newman" [EMAIL REMOVED]
To: [EMAIL REMOVED]
Sent: Friday, December 07, 2001 8:38 AM
Subject: Re: FN-FORUM Problem with a search/response from Iain


> FTP the database to the server??....sounds a nightmare - I may have missed
> something here.
>
> If there are more than one client stations then the data will get
> overwritten - wouldn't it be better to have a mySQL database on the server
> and connect from the client end directly....
>
> Or may be link the client to the db on the server using ODBC allowing the
> data to be shared by mutliple clients...
>
>
>
> ----- Original Message -----
> From: "David Eckersall" [EMAIL REMOVED]
> To: [EMAIL REMOVED]
> Sent: Friday, December 07, 2001 12:53 AM
> Subject: Re: FN-FORUM Problem with a search/response from Iain
>
>
> > its always a problem making something client-proof! :)
> >
> > from what you've said id do the following:
> >
> > performer table (performer_id, fname, lname, etc.)
> > piece table (piece_id, piece_name, etc.)
> > performance table (performance_id, performance_date, performance_time)
> > LK_peformer_piece_performance lookup table (lk_id, performer_id,
piece_id,
> > performance_id)
> >
> > then i'd create a number of views to output what i required.
> >
> > for client admin, id create a either a desktop frontend(vb or access) or
a
> > web admin section.
> >
> > the client would select a performer (with the ability to
add/update/delete
> > them) which would then take them to the next page (performer id in a
> hidden
> > field) which asks for a date, time and a multiple select box to select
the
> > pieces that will be performed (alt. 15 select boxes if you want the
pieces
> > in a specific order).
> >
> > the advantage of a desktop frontend is that the client can update the
> > database, view the changes locally and then ftp the database (give them
an
> > 'FTP' button to automate rather than let them near your server!) saving
> you
> > lots of 'i cocked up!' phone calls from the client.
> >
> > ----- Original Message -----
> > From: [EMAIL REMOVED]
> > To: [EMAIL REMOVED]
> > Sent: Friday, December 07, 2001 12:00 AM
> > Subject: Re: FN-FORUM Problem with a search/response from Iain
> >
> >
> > > Cheers Guys - i'll try out the suggestions tomorrow.
> > >
> > >
> > > David - you are entirely right - the database table 'music1' is a
mess -
> > > basically the site is displaying the concerts at a venue and If
someone
> > > wants to search for a particular composer then they will be returned
all
> > the
> > > musicians and concerts at which the composer will be performed.
> > >
> > > My restrictions for the table are these:
> > > 1. the client wants to be able to fill in the concert details at his
> > leisure
> > > from his machine - I therefore need to create a page from which he can
> add
> > > records to the database table;
> > > 2. Each performer will do a maximum of 15 pieces of music at a
concert.
> I
> > > created 15 columns for the music pieces - some will be left blank, as
> well
> > > as the performers details and biography. What I WANTED to do was have
a
> > > table that would be linked by performer id and contain only 3
> > columns -'id',
> > > 'piece' and 'composer'. when the detail page is called i.e.
> > > music_detail.asp?id=2, I envisaged a repeat region calling to the
> music1
> > > database, getting the performers biog details from one table and the
> > > programme details, displayed as a repeating region on teh detail page,
> > from
> > > the other table.
> > >
> > > My problem with this is that i cant see a way in which the programme
> > details
> > > for all the performances can be stored in the same table - I would
have
> to
> > > trust the client to assign the correct id to each piece so that it
would
> > > link to the correct performer. I had thought of defining a 'pieces'
> table
> > > for each performance (by hand) but that would defeat the object of the
> > > client doing all the entering of data himself.
> > >
> > > any way the long and the short of it is that i have created a messy
> > database
> > > and am unhappy with the workaround that i must do to make the page
> present
> > > the detail data to the viewer.
> > >
> > > SO: should i trust the client?
> > >
> > > ANY thoughts would be welcome!
> > >
> > > Iain
> > > ---- Original Message -----
> > > From: "David Eckersall" [EMAIL REMOVED]
> > > To: [EMAIL REMOVED]
> > > Sent: Thursday, December 06, 2001 4:07 PM
> > > Subject: Re: FN-FORUM Problem with a search
> > >
> > >
> > > > for starters you seem to be missing string characters in the
> statement:
> > > > WHERE comp1 LIKE '" + Replace(rsCom__comSearch, "'", "''")+'"
> > > >
> > > > you also seem to be missing the LIKE parameters such as %, if you
want
> > > exact
> > > > then use = instead of LIKE.
> > > >
> > > > btw, why on earth do you have so many composer fields in your
> database?
> > > you
> > > > might want to have a look at shrinking it down to improve
performance.
> > > > ----- Original Message -----
> > > > From: [EMAIL REMOVED]
> > > > To: "Freelance forum" [EMAIL REMOVED]
> > > > Sent: Thursday, December 06, 2001 3:44 PM
> > > > Subject: FN-FORUM Problem with a search
> > > >
> > > >
> > > > > I am trying to code a database search using an access database. I
am
> > > > > creating it in Ultradev so there ore countless 'mm_colParam_mm'
> bits
> > in
> > > > the
> > > > > code. I have a text box called 'comSearch' and I want it to
search
> 15
> > > > > fields in the data base 'music1' .
> > > > >
> > > > > the code below does not work!
> > > > >
> > > > > > > > > Dim rsCom__comSearch
> > > > > rsCom__comSearch = "*"
> > > > > if (Request.QueryString("comSearch") "") then rsCom__comSearch
=
> > > > > Request.QueryString("comSearch")
> > > > > %>
> > > > > > > > > set rsCom = Server.CreateObject("ADODB.Recordset")
> > > > > rsCom.ActiveConnection = MM_conEvents_STRING
> > > > > rsCom.Source = "SELECT * FROM music1 WHERE comp1 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp2 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp3 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp4 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp5 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp6 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp7 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp8 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp9 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp10 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp11 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp12 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp13 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp14 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " OR comp15 LIKE " +
> > > > > Replace(rsCom__comSearch, "'", "''") + " ORDER BY when"
> > > > > rsCom.CursorType = 0
> > > > > rsCom.CursorLocation = 2
> > > > > rsCom.LockType = 3
> > > > > rsCom.Open()
> > > > > rsCom_numRows = 0
> > > > > %>
> > > > >
> > > > > the basic sql i have tried is this....
> > > > > SELECT *
> > > > > FROM music1
> > > > > WHERE comp1 LIKE comSearch OR comp2 LIKE comSearch OR comp3 LIKE
> > > > comSearch
> > > > > OR comp4 LIKE comSearch OR comp5 LIKE comSearch OR comp6 LIKE
> > comSearch
> > > > OR
> > > > > comp7 LIKE comSearch OR comp8 LIKE comSearch OR comp9 LIKE
comSearch
> > OR
> > > > > comp10 LIKE comSearch OR comp11 LIKE comSearch OR comp12 LIKE
> > comSearch
> > > OR
> > > > > comp13 LIKE comSearch OR comp14 LIKE comSearch OR comp15 LIKE
> > comSearch
> > > > > ORDER BY when
> > > > >
> > > > > I want to be able to type 'Wagner' into the text box and have the
> > > records
> > > > > that contain wagner in columns comp1-15 returned to the page.
> > > > >
> > > > > how should my WHERE statement be written?
> > > > >
> > > > > I am p*ssed iff - I can't locate anything that will help on the
> > internet
> > > > >
> > > > > I hope might be able to help!
> > > > >
> > > > > Iain
> > > > >
> > > > >
> > > > > ============================================================
> > > > >
> > > > > * Free listing for freelancers
> > > > > * Free to advertise jobs
> > > > > * Free jobs distribution service
> > > > > * Free database of 5000 freelancers
> > > > >
> > > > > Freelancers and Freelance Jobs:
> > > > > http://www.freelancers.net
> > > > >
> > > > > Forum FAQs:
> > > > > http://freelancers.netrickery.com
> > > > >
> > > > > To unsubscribe please email:
> > > > > [EMAIL REMOVED]
> > > > >
> > > > > If you have difficulties unsubscribing please email:
> > > > > [EMAIL REMOVED]
> > > >
> > > >
> > > > ============================================================
> > > >
> > > > * Free listing for freelancers
> > > > * Free to advertise jobs
> > > > * Free jobs distribution service
> > > > * Free database of 5000 freelancers
> > > >
> > > > Freelancers and Freelance Jobs:
> > > > http://www.freelancers.net
> > > >
> > > > Forum FAQs:
> > > > http://freelancers.netrickery.com
> > > >
> > > > To unsubscribe please email:
> > > > [EMAIL REMOVED]
> > > >
> > > > If you have difficulties unsubscribing please email:
> > > > [EMAIL REMOVED]
> > > >
> > >
> > >
> > > ============================================================
> > >
> > > * Free listing for freelancers
> > > * Free to advertise jobs
> > > * Free jobs distribution service
> > > * Free database of 5000 freelancers
> > >
> > > Freelancers and Freelance Jobs:
> > > http://www.freelancers.net
> > >
> > > Forum FAQs:
> > > http://freelancers.netrickery.com
> > >
> > > To unsubscribe please email:
> > > [EMAIL REMOVED]
> > >
> > > If you have difficulties unsubscribing please email:
> > > [EMAIL REMOVED]
> >
> >
> > ============================================================
> >
> > * Free listing for freelancers
> > * Free to advertise jobs
> > * Free jobs distribution service
> > * Free database of 5000 freelancers
> >
> > Freelancers and Freelance Jobs:
> > http://www.freelancers.net
> >
> > Forum FAQs:
> > http://freelancers.netrickery.com
> >
> > To unsubscribe please email:
> > [EMAIL REMOVED]
> >
> > If you have difficulties unsubscribing please email:
> > [EMAIL REMOVED]
>
>
> ============================================================
>
> * Free listing for freelancers
> * Free to advertise jobs
> * Free jobs distribution service
> * Free database of 5000 freelancers
>
> Freelancers and Freelance Jobs:
> http://www.freelancers.net
>
> Forum FAQs:
> http://freelancers.netrickery.com
>
> To unsubscribe please email:
> [EMAIL REMOVED]
>
> If you have difficulties unsubscribing please email:
> [EMAIL REMOVED]