Hi We have a Hauppauge WinTV-Nova-t PCI card, and i'm based in the United kingdom (PAL) The card is both analog and digital. Peter --- Peter M

Hoping someone can advise me. I brought windows xp home. and a tv card (hauppauge). The hauppauge software to watch tv is awful, very unstable, and sluggish. So i looked out for a windows program to watch tv on. So i heard about windows media center 2005. Is there anyway that i can get hold of this (purchase that is). Just that from what i can see, you can only purchase this with a different version of windows, and its rather frustrating since i only brought windows xp home 2 weeks ago. Advice please! Peter M --- Peter M

Anyone seen this error message, and know what could be a cause. It’s for a forum. It works. Just maybe a couple of times a week this error message will appear, and disappear by itself! A friend of mine believes that the fault is with my Host (OneandOne). But after phoning my host they insist its not them but possibly there are open connections to the database not being closed. Which is quite possible I guess. But then again, the rest of the website works on a separate database. If there was too many connections open. This would effect both databases????? Would be interesting if there was a way to at any moment in time see how many connections are open ------------------- Server object error 'ASP 0177 : 8007000e' Server.CreateObject Failed /forum/mbbs2/includes/include-filesystem.asp, line 19 8007000e ---------- The line of code it refers to is Private Sub Class_Initialize ' Setup Initialize event. set fsoBBS = Server.CreateObject("Scripting.FileSystemObject") End Sub --- Peter M

Just to update this issue.... The error received is: ________________________________________ HTTP 500.100 - Internal Server Error - ASP error Internet Information Services Technical Information (for support personnel) • Error Type: Active Server Pages, ASP 0126 (0x80004005) The include file '/Includes/Admin/MetaTags.asp' was not found. /cullyonline/Default.asp, line 7 • Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1) • Page: GET /cullyonline/Default.asp • Time: 24 August 2004, 17:28:00 • More information: Microsoft Support ________________________________________ The line it’s referring to is Line 7: I’m using IIS Version 5.1 This site does work online, and has been so for the last couple of years. Its just now I wanted to see it working using IIS. Its basically the first include file in the html, and if I remove this line, it will have the same fault on the next virtual include --- Peter M

I wish to test out my website using IIS. Problem is, being that the website is normally hosted online, I use the following virtural include(s) quite a bit. Obviously this is generating an error when I try and run the website on my computer using IIS. Is there a simple way around this with out having to go through the whole website changing all the includes from virtual to file... I eagerly await any reply’s!! --- Peter M

I've found out you cannot do comparisons with memo fields. You need to put it into a string to compare. Thanks to david wulff. --- Peter M

I'm displaying details on my website, which is taken from my MS access database. Which is simple enough. The details are shown in a table, which you can most probably tell from the extract of code. The problem is the "Address" appear on the site, but the "Details" do not. The difference is that on the database, the Address data type is text, and the Details is data type memo. I believe the problem lie with this difference in data type, and the If RS("Details") <> "" then. Hopefully someone can show me the light! <% If RS("Address") <> "" then Response.Write("

") Response.Write RS("Address") 'This does appear Response.Write("

") End if %> <% If RS("Details") <> "" then Response.Write("

") Response.Write RS("Details") 'This does not appear Response.Write("

") End if %> --- Peter M

Ok, this is quite a simple question. I'm changing my website to use CSS. And i thought hey, how about allowing the CSS to control my tables as well. So if we have a table, which the code looks like:

and we want to apply the CSS style to it. Do i have to create a style for everything, hence Table, tr and td. Because that is what i am doing, and it seams a little tedious.. hence it becomes

Is there a simplier way, so I don't have to apply the class to literally everything seperately :confused: --- Peter M

Right, to set the scene, I am creating a website for my partner to sell Floral Arrangements. Now when certain events crops up, i.e. Mothers Day, Fathers Day, Easter, etc, we would like a reminder to appear. No problem. The problem is, the dates for the events change each year, and can't think of a logical way in code to determine the date automatically, as Easter for example falls on a different date each year. Do any of you know of a way to calculate when Special Occasion dates occur each year? Any suggestions? --- Peter M

OK, now i have working code to count all the records thanks for all your suggestions, that’s all fine now. The other thing that I wanted to clear up was this, and i'll do my best at explaining! I wanted to select all the data in a table, then sort in descending order (the primary being a Autonumber called ID), and then select a range of records for paging. Now i can do the paging fine, the the first record is shown first, and wanted everything to be in reverse order. So my first bit of code works, in ascending order. (ignore the maths bit its used to select ie records 1-5 for page 1 and 6-10 for page 2 ...) SQLQuery = "SELECT * FROM Log WHERE Log.ID BETWEEN " & (((sCurrentpage-1)*5)+1) & " AND " & (sCurrentpage*5) This works fine, but I wanted it to have all the records in reverse order, so I thought ah ha, i'll just put in order by: SQLQuery = "SELECT * FROM Log ORDER BY ID DESC WHERE Log.ID BETWEEN " & (((sCurrentpage-1)*5)+1) & " AND " & (sCurrentpage*5) But this doesn't work. If I were to put ORDER BY ID DESC at the end of the SQL statement it will work, but it will only reverse order of the selected records. But i wanted to reverse order of everything and then select..understand the problem?? Suggestions on a post card.. Please note, I am not able to use anything to do with .NET, so i need .NETless code :-O ..cheers! --- Peter M

Could not get this to work with executeQuery, as mentioned with Dr X, this might be because the code is ADO.NET? Your all using space age technology compared to me, i'm not on the .NET train yet :eek: Thanks for your time otherwise --- Peter M

Tried again, but could not get it to work, I had a feeling that the code you submitted was in ASP.NET, which my friend David Wulff confirmed for me. My host (oneandone) does not allow me to use .NET, which explains things, i've managed to get things to work now with the following code, incase anyone else reads this in the future set rs = OBJdbConnection.execute("SELECT count(ID) as total from Log") sTotalpages = rs("total") Thanks for your time, its appeciated! --- Peter M

Well I tried your code but I get the error "ADODB.Connection error '800a0bb9' Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. /Includes/paging.asp, line 12 " I couldnt' get the tostring to work, so i took it out as well as the error checking, as they will not be blank fields (we are checking the primary after all) So the code ended up dim sTotalpages SQLQuery = "SELECT COUNT(ID) FROM Log" sTotalpages = OBJdbConnection.ExecuteScalar(SQLQuery) 'Line 12 - the error point Response.Write(sTotalpages) I'm rather confused to why I am having problems, i mean it looks easy enough, there is obviously something I am doing wrong. Well I'll go back to my old method for now, and have a break, and come back to it later --- Peter M

Yes it does have a primary index, which is just a auto number. Before I recieved your message, I managed to get things working by doing the following SQLQuery = "SELECT * FROM Log" Set RS = OBJdbConnection.Execute(SQLQuery) While (Not RS.EOF) sTotalpages = sTotalpages + 1 RS.MoveNext Wend Maybe its a crude way to count the pages. I'll give your code a try now --- Peter M

I wish to count the number of records in my table and then display the number on the screen So i done: SQLQuery = "SELECT COUNT(*) FROM Log" Set RS = OBJdbConnection.Execute(SQLQuery) Response.Write(RS.RecordCount) But i'm getting into a muddle on how to do it. Can someone please show me the light.!! --- Peter M

Nope.:) I get asked that so often though, I had to put the question in a FAQ on my own website!. Just dont make me angry on a full moon. Some say things get a little hairy. :-O --- Peter M

LOL :-D --- Peter M

thanks, i found out i needed to make the file executable, and now it runs fine. Thanks for your reply also Been advice to use ASP now, by a fellow CPian...humm...things to do...things to do... --- Peter M

Ok, this will be an easy question for you peal guys (or gals for that matter) I have a peal file, for a Form Mail in my website (FormMail.pl) I have been following instructions to use this file for my wesbite, making changes to the parameters, but what does this mean: ************** "Once uploaded you will need to change the file so that it can be executed, this can normally be done in any ftp programme" ************** Do I have to compile this file, or rename it? Either way, if i run the script as it is i get a Error 500. Hope this make some sence :~ Hope someone can let me know tonight, if you can spare a mo..cheers in advance --- Peter M

Not sure what connection we have at work, but the other day I was getting down load speeds in excess of 200K per second :omg:. I watched a 20Mb file download like a 20kb file would at home. I was gob smacked. --- Peter M