Recent content by credo

Hello, I have a " Villa details" web-page that shows details of villas from a database using ASP (the results set is called rs_av). Some of the information being shown is on 'availability of the villa for a certain week'. If the villa is available for a certain week, I write a "book" link...

I have a web based search page (ASP) that allows users to search for villas within regions and also price. The user can choose the search results sort order (price, region or villa size) via radio buttons on the search page. If a user selects sort results by Region/Department for example, 2...

Thanks Cheerio and Tony - that's solved it.

Hello, I am doing a query using three joined tables Tbl_Villas, Tbl_Regions, Tbl_Countries.. I want to return the total number of villas per region, (including those regions that do not have any villas). SELECT Tbl_Regions.RegionID, Tbl_Regions.Region, Count(Tbl_Villas.VillaID) AS...

thanks very much - it now works.. !

Hello, I am having trouble with an ASP statement... I have an if statement that if is true, writes a an image and then a link to go to "book.asp" page. I want to make the link dynamic and pass a variable across when the URL is clicked by the user to the book.asp page (the variable...

Hi, Thanks for your quick response Chopstick - but I had'nt left out the first &quot;Then&quot;, it was a code pasting error ... so my code is : <td width=&quot;122&quot; valign=&quot;top&quot; class=&quot;gen2&quot;> <%= If (rs_av.Fields.Item(&quot;w1_Avail&quot;).Value = True) Then ' set the...

Hello, I'm trying to simply display Yes/No instead of True/Fasle from an Access db yes/no field in a table cell - having trouble with the ASP formatting with the following statement : <td width=&quot;122&quot; valign=&quot;top&quot; class=&quot;gen2&quot;> <%= If...

Hello, I have an excel spreadhseet with two columns that I want to import into Access 2000 (through the normal File>Get External Data). Problem is, one of the columns in the Excel spreadsheet has line breaks in the cell. When importing into Access these lines get put into separate...

Hello, I'm having a problem with capturing video in Premier 6.0 using RT2500 capture card. AMD Athlon processor.Windows XP.Soncy DCR-PC100.Latest video tools version 3.1b installed. When capturing video, the video ** does** apear in the movie capture window (and audio), but the video is...

Great - got it - thanks again for your help ... :)

thanks Russell - aaaaah - localhost works rather than 127.0.0.1. - and I see there's loads of documentation - good. I can view html sites locally fine. whereis Interent Services manager though to set the browse local directories option? I have several apps under Admin Tools (eg. Component...

ok I'm an IIS newbie- just got XP Pro installed and want to be able to view locally 10 websites that I've developed. On my old OS (Win ME) using PWS I viewed these locally through the browser from c:/inetpub/wwwroot/website1/index.html etc..... I didn't have to do much except point PWS to...

Since upgrading from Windows ME to Windows XP Pro - holding shift+2 prints @ to the screen and shift+@ keys produces &quot; ie. they are swapped round. Presumably I need an updated keyboard driver (?), but am unsure where to look to get this since the keyboard came with the PC. The manufacturer...

Derren, I figured it out and was just going to post - (you are right again!) - the browser pop-up will show blank if you do not have the latest Flash player plugin (6,0,23,0) in your browser. The reason for this is that the .swf URL's retreived from the db contain Flash components which are a...