Solved

How to create an  Updateable Gig Guide For Music Venue website?

Posted on 2004-09-23
6
264 Views
Last Modified: 2010-04-25
Hi

I am doing a website in dw for a friends music venue and have nearly completed the site. What I need to do is create a page that would list the gigs that are on at the venue (that could be updated through contribute or some other CMS).

Our webserver has access to both ASP and perl modules. We also have unlimited MySQL databases.

I normally learn by doing but am struggling to find a way to do it or any tutorials for similar.

 Bearing in mind the page formatting needs to look good regardless of how many gigs are listed. Ideally we would like to be able to search by artist and by date and be able to have the user sort the columns by date and artist also (ascending and descending). What they previously had is a 3 column table (artist, date, ticket price) (The artist details are also a link to artists websites) listing 10 gigs per page with next and previous links at the bottom to scroll through. Problem with this is that they currently pay someone to update the website every week with new gig dates. They want to be able to do it theirselves whenever new gigs are confirmed.

Can anyone give me some help as to the steps I need to take to get this working ( a step by step guide would be really appreciated or possibly some good links that describe the process in detail). Thanks in advance

0
Comment
Question by:cyjazzman
  • 3
  • 2
6 Comments
 
LVL 7

Assisted Solution

by:jay_eire
jay_eire earned 175 total points
ID: 12132616


this will help you to write the gig date venue  page, this guy did something similar.......................
http://www.webthang.co.uk/tuts/tuts_ud4/utrix1/utrix1_1.asp
0
 
LVL 19

Expert Comment

by:webwoman
ID: 12133497
Check out any of the ASP tutorial/resource sites. I like www.asp101.com and www.4guysfromrolla.com

What would be ideal is a database, with a form for them to enter/modify information. You could then display upcoming dates, and have the previous gigs displayed with some info about what they performed, how the crowds were, etc.
0
 

Author Comment

by:cyjazzman
ID: 12137740
www.qbic-it.com/gigs.rar

Thanks for the links jay and webwoman. I have had a go with some of the information I could find and have knowcked up an asp page linked to an access table. They are all here:

www.qbic-it.com/gigs.rar

One of the columns is a ticket price but only displays as the character before the decimal with no currency symbol. It is set as a currency datatype in the table with two decimals. how can I fix this

Also, is there any way to put a hyperlink on each of the artist names to link to their websites/ info pages?

How can I format the table so that long strings dont distort the column alignment?

I set it to display ten records per page, how do i create the rest of the pages for the remaining gigs? also can you automatically create next/ prev buttons at the bottom of the pages or maybe page number links to facilitate easy browsing through tthe list?

Sorry for all the questions but I have never looked at asp before tonight..
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 19

Accepted Solution

by:
webwoman earned 200 total points
ID: 12138690
Setting a format in the Access database doesn't have any effect on how it's shown. You can try an ASP formatCurrency(field) and see if it works... it should, but check the syntax, I might have it wrong.

How are you setting it to only display 10 records? You can set up paging, but it usually depends on how you're pulling the records.

Putting in the hyperlinks will be easier if you have that info in the database. If you don't, it would be a good idea to put it there. Then you can check that field, and if it's there you put the <a href="<%=hreffield%>"></a> tags around the name.

Long strings are going to be an issue. They are for everbody. You can check for a value in that field, and put another row of just that under the other info, then the width will be less of a problem. If you're using a table structure, set it for an absolute pixel size. The text should wrap -- but if you have really long words those will still mess it up.
0
 

Author Comment

by:cyjazzman
ID: 12151860
Where in the code below labelled A would i put the following statement  varLocale = SetLocale(2057)
FormatCurrency

<%=(get_gigs.Fields.Item("fldTicketPrice").Value)%>

I will have to figure out an alternative for displaying the url - can you use relative urls in asp?

TO display ten records is set a repeat region in dreamweaver. it gives you a choice of how many records to display

Thanks again webwoman
0
 

Author Comment

by:cyjazzman
ID: 12154166
Where in the code below labelled A would i put the following statement  varLocale = SetLocale(2057)
FormatCurrency

A:   <%=(get_gigs.Fields.Item("fldTicketPrice").Value)%>

I will have to figure out an alternative for displaying the url - can you use relative urls in asp?

TO display ten records is set a repeat region in dreamweaver. it gives you a choice of how many records to display

Thanks again webwoman
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now