Web Development

Nino_124-Jul-03 16:49

Nino_1

24-Jul-03 16:49

Oops, deleted the first post. Dead | X|

Tony

User 1278224-Jul-03 16:05

User 12782

24-Jul-03 16:05

I'm using a loop to go through all the records and display them.

modified 12-Jul-20 21:01pm.

Nino_124-Jul-03 16:14

Nino_1

24-Jul-03 16:14

I just ran the following, and it ran succesfully.

Does this look simular to what you are running?

<%

Dim objConnectionString

Dim objRecordsetString

Set objConnectionString = Server.CreateObject("ADODB.Connection")

Set objRecordsetString = Server.CreateObject("ADODB.Recordset")

objConnectionString.Open "Provider=Microsoft.Jet.OLEDB.4.0;" &_

                         "Data Source=E:\stuff\grocertogo.mdb"

Set objRecordsetString = objConnectionString.Execute ("SELECT * FROM Products ORDER BY ProductID")
                         

%>

<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Interdev 6.0">
</HEAD>
<BODY bgcolor="">

<font face="Tahoma" size="1">
<table cellpadding="0" bgcolor="008080" width="683" height="400" cellspacing="1">
<%

Do While Not objRecordsetString.eof

%>
<tr>
<!--call out our table and corresponding rows-->
	<td bgcolor="#e6e6e6"><%=objRecordsetString("ProductID")%></td>
	
<!--</tr>-->

	<td bgcolor="#e6e6e6"><%=objRecordsetString("ProductName")%></td>
	
<!--</tr>-->
	
	<td bgcolor="#e6e6e6"><%=objRecordsetString("Manufacturer")%></td>
	
<!--</tr>-->

	<td bgcolor="#e6e6e6"><%=objRecordsetString("UnitPrice")%></td>
	
<!--</tr>-->

	<td bgcolor="#e6e6e6"><%=objRecordsetString("Servings")%></td>
	
</tr>

<%

objRecordsetString.MoveNext

Loop

objRecordsetString.Close

Set objRecordsetString = Nothing

objConnectionString.Close

Set objConnectionString = Nothing

%>

<table>

</BODY>
</HTML>

Tony

User 1278224-Jul-03 18:23

User 12782

24-Jul-03 18:23

I feel really stupid now. The problem I was reusing a recordset object from before, and it doesn't work to just do: r=Connect.Execute("SQL STRING"), it has to be set r= if I want to use it again. I spent a couple of hours trying to get that to work, and it was something simple as that. Thanks though for your help, I realized the problem when I was looking at your sample code.

-Aaron

modified 12-Jul-20 21:01pm.

Using CSS

andyg.10123-Jul-03 23:35

andyg.101

23-Jul-03 23:35

Hi there,

I am developing a website and I am quite new to using CSS. I already have a lot of HTML to change/update that I think someone generated using word or frontpage. I want to apply styles to the standard heading tags h1 etc..

Can I do this but leave all the old etc tags in the html file or do I have to remove them(There are hundreds). I was trying to work out if there is an order of precedence for the tags, but I can't seem to work it out.

sorry if this is a stupid question.

Nino_124-Jul-03 5:11

Nino_1

24-Jul-03 5:11

Andy,

It sounds like you should start by doing a copy and paste of the HTML tags into notepad.

Do this and save it as HTML, and see how your HTML behaves with your CSS Additions. Not knowing what your HTML code looks like I would try this and see how it turns out.

I'm sure you'll get more good suggestions from the other members here, there is a lot of good folks here that have loads of experience with HTML, and programming.

Tony

Roger Wright24-Jul-03 5:24

Roger Wright

24-Jul-03 5:24

I believe that if you have explicit styles coded into the HTML they will override to styles you specify in your css file - I don't know for sure because I try always to use one or the other method, but never both at the same time. If you have multiple css files linked into the page, the last one linked takes precedence over previous styles if there is any overlap in their contents. Probably the easiest way to learn it is to play with it.

Create a simple test page with several elements in it but no styles specified. Give each section or element a class name. Then create a couple of css files with the same classes defined, but different styles associated with each, and link them into your html page HEAD section. View the results before and after changing the order in which they are linked in the page, then add some explicit style attributes in the HTML itself and see what effect that has. An hour or two of playing with it will probably answer a bunch of questions.

"The Lion shall lie down with the Lamb;
but the Lamb will not get much sleep..."
Lazarus Long

andyg.10124-Jul-03 15:49

andyg.101

24-Jul-03 15:49

Hi again,

I had a play around with it, and it looks like the style sheets get overridden by the html tags already present. i.e. if I do something like

<h1><u>this is a title</u></h1>

and the style sheet is set up for h1 without underline I still get underlined text. So I've taken to just commenting out the <font> tags for the moment. One thing I would like to know though, is how is it possible to make pages that use CSS compatible with older browsers, if it isn't possible to have a set of default HTML tags in the document when no CSS support is available or have I completely missed the point?
thanks andy

Roger Wright24-Jul-03 20:03

Roger Wright

24-Jul-03 20:03

andyg.101 wrote:
how is it possible to make pages that use CSS compatible with older browsers

You can't. Older browsers don't support modern CSS. For them you have to encode the styles in your HTML and pray that they will work.

"The Lion shall lie down with the Lamb;
but the Lamb will not get much sleep..."
Lazarus Long

Rocky Moore27-Jul-03 0:20

Rocky Moore

27-Jul-03 0:20

andyg.101 wrote:
how is it possible to make pages that use CSS compatible with older browsers

You may not want to bother. Most people use modern browsers, only a hand full in comparison use browsers that do not understand basic CSS. If you wish to support those few, then you have two choices, don't use CSS or keep two versions of your site.

Rocky Moore <><

theJazzyBrain25-Jul-03 1:15

theJazzyBrain

25-Jul-03 1:15

I had problems with HTML genereted by WORD or Front Page...
Therefore I have created a class that cleans all the unwanted tags...
I can send it to you if you want
...

theJazzyBrain
Wise is he who asks good questions, not he who gives good answers

andyg.10127-Jul-03 15:37

andyg.101

27-Jul-03 15:37

that would be cool, I'd like to see how you did it.

thanks
Andy

Loading text into a browser control

theJazzyBrain27-Jul-03 22:43

theJazzyBrain

27-Jul-03 22:43

if you give me an email address I can send it to you...

Just to let you know that it a C# class.

theJazzyBrain
Wise is he who asks good questions, not he who gives good answers

HP723-Jul-03 13:16

HP7

23-Jul-03 13:16

I am programming in VC++/MFC. I have a browser control in my application. How do I load text into a browser control witout using a file(or URL)?

WebBrowser1.Navigate() takes either filelocation or URL.

Thanks in advance.

H.

Re: Loading text into a browser control

Philip Patrick23-Jul-03 19:09

Philip Patrick

23-Jul-03 19:09

Look in my article for example:
http://www.codeproject.com/internet/parse_html.asp[^]

Note, this is not the only way, just one of them

Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer

ASP vs. ASP.NET and Web Tools

Popeye Doyle Murray23-Jul-03 10:36

Popeye Doyle Murray

23-Jul-03 10:36

I need to write a pro-quality database web application, using all MS technologies. I can't emphasize enough that The app must have COM controls that do not use .NET!

Well, I am thinking about ASP.NET. How difficult is that to use with COM objects in a web application? What is the development environment for ASP.NET? I assume VS 7.0? (I am a VC 6.0 guy).

Can Visual Studio 7.0 be used to develop for ASP and COM without using .NET?

Philip Patrick23-Jul-03 19:06

Philip Patrick

23-Jul-03 19:06

Popeye Doyle Murray wrote:
How difficult is that to use with COM objects in a web application

Easy, just add a reference to the project and whoala.

Popeye Doyle Murray wrote:
What is the development environment for ASP.NET? I assume VS 7.0?

Yes, also you can try a WebMatrix, wich is free (and yet from Microsoft)

Popeye Doyle Murray wrote:
Can Visual Studio 7.0 be used to develop for ASP and COM without using .NET?

Yes

Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer

Not Active24-Jul-03 6:16

Not Active

24-Jul-03 6:16

I'm curious as to the requirement for COM and no .NET?

If this is a web app what does it matter what you use on the backend?

Popeye Doyle Murray24-Jul-03 7:26

Popeye Doyle Murray

24-Jul-03 7:26

Mark Nischalke wrote:
I'm curious as to the requirement for COM and no .NET?

We have existing C++ classes that are required for some of the data processing, and these do not use .NET (and we use VC++ 6.0 only, to keep cost down and productivity up). So to leverage the existing code, they will be wrapped in COM objects.

Mark Nischalke wrote:
If this is a web app what does it matter what you use on the backend?

Mainly what I stated above, but it is also because the web app may actually be sold to customers on installed on their servers, so it affects the customers system requirements.

I am curious your perspective on those answers.