BAND
INFO |
Chuy
has been the resident "opening act" for such headliners
as Tony Bennett, Gary Puckett, The Doors, Johnny Mathis, The
Byrds, Four Freshman, Peter Nero, Bobby Darin and Paul Anka. |
|
CHUY'S
CD |
- Music's
Got A Hold Of Me
- Just
Another Drink
- I'm
So Happy
- Natural
High
- You
Had Enough
- Europea
- On
My Way
- Growing
Older
- Never
Say Never
- Que
Sera
|
|
|
<%
' Create and establish data connection
Set DataConn = Server.CreateObject("ADODB.Connection")
DataConn.ConnectionTimeout = 15
DataConn.CommandTimeout = 30
DataConn.Open "Provider=SQLOLEDB;Data Source=207.182.248.137;Initial Catalog=unlimited;User Id=unlimited;Password=aleyda;"
Set cmdDC = Server.CreateObject("ADODB.Command")
cmdDC.ActiveConnection = DataConn
cmdDC.CommandText = "select * from chuysco_event where to_date > getDate();"
cmdDC.CommandType = 1
Set rsDC = Server.CreateObject("ADODB.Recordset")
' Opening record set with a forward-only cursor (the 0) and in read-only mode (the 1)
rsDC.Open cmdDC, , 0, 1
%>
<%
' Loop through recordset and display results
If Not rsDC.EOF Then rsDC.MoveFirst
' Get the number of fields and subtract one so our loops start at 0
iFieldCount = rsDC.Fields.Count - 1
' Continue till we get to the end, and while in each loop through fields
Do While Not rsDC.EOF
%>
Chuy's Company
Appearances |
<%
if Not IsNull(rsDC.Fields("image_loc")) then
%>
 " /> |
<%
end if
%>
| <%= rsDC.Fields("place") %> |
|
<%= rsDC.Fields("from_date") %> - <%= rsDC.Fields("to_date") %> |
| <%= rsDC.Fields("address") %> |
| <%= rsDC.Fields("city") %>, <%= rsDC.Fields("state") %>, <%= rsDC.Fields("zip") %> |
<%
rsDC.MoveNext
Loop
%>
<%
' Close Data Access Objects and free DB variables
rsDC.Close
Set rsDC = Nothing
' can't do a "cmdDC.Close" !
Set cmdDC = Nothing
DataConn.Close
Set DataConn = Nothing
%> |
MUSIC
|
- TopAD
- Latin
- Jazz
- Classic
Rock
- Standards
- Country
Western
- Impersonations
|
|
BAND
INFO |
Chuy
is also known internationally in Acapulco, Puerto Vallarta,
Cancun, Mazatlan and Belize. He has appeared on "Siempre
En Domingo", the western hemisphere's #1 television variety
show, seen by 250 million viewers weekly. |
|
|
