Theunis
|
| Posted: 08/18/2005, 6:36 PM |
|
I was wondering if it is possible to display the results of a SQL statement (like in the grid display) but outside a table e.g. I need to extract X records to a marquee (horizontal scroll) - without playing with code directly - but inside the designer?
thanks in advance
Theunis
PS. a demo would be on the www.samusic.co.za site - the scrolling event guide just below the logo and menu
|
|
|
 |
smalloy
Posts: 107
|
| Posted: 08/23/2005, 12:07 PM |
|
I doubt its possible within the designer so you will have to bite the bullet and code!
Here is my suggestion, there are 2 parts, the ASP part that gets the marquee data:
Dim conn
Dim rs
Dim sSQL
Dim strMessage
-Instantiate database class
Set DBData = New clsDBData
-Open The DataBase
DBData.Open
-Your query
sSQL = "Select Message From Marquee_Data where ID = 1"
Set rs = DBData.Execute(sSQL)
If NOT rs.EOF Then
rs.MoveFirst
strMessage = rs("Message")
End IF
-Clean Up
rs.close
Set rs = Nothing
If DBData.State = adStateOpen Then _
DBData.Close
Set DBData = Nothing
And now (my weakness) the HTML code:
<html>
<body>
<marquee><%=strMessage%> packages shipped today!</marquee>
</body>
</html>
You may have to play with the HTML. Finally, thank you for your help with the loading JavaScript!
Good Luck, hope I’ve at leased pointed you in the right direction.
Steve
_________________
Anything can be done, just give me time and money. |
 |
|
DonB
|
| Posted: 08/24/2005, 7:59 AM |
|
As smalloy points out, you can rearrange the HTML to suit whatever you need.
Just understand that the 'comments' (like <!-- BEGIN yada yada --> and <!--
END yada yada --> are not merely comments, but markers that CCS uses. Keep
these markers intact and you can put any HTML you want into the template
(html) page. These must always be in the same relative order (some are
nested within others). If you keep that in mind, CCS will never complain
and you can make whatever layout you like.
--
DonB
http://www.gotodon.com/ccbth
"Theunis" <Theunis@forum.codecharge> wrote in message
news:6430537b2199c5@news.codecharge.com...
> I was wondering if it is possible to display the results of a SQL
statement
> (like in the grid display) but outside a table e.g. I need to extract X
records
> to a marquee (horizontal scroll) - without playing with code directly -
but
> inside the designer?
>
> thanks in advance
>
> Theunis
>
> PS. a demo would be on the www.samusic.co.za site - the scrolling event
guide
> just below the logo and menu
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
|
