Search results for query: *

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...

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...

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...

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...

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...

I'm retrieveing some records from a db - for each record I'm displaying in the web page, I want a preview rollover icon which when clicked will open up a popup. Using IE5.5. the preview icon is a magnifying glass that raises off the page on rolling over.. I've got this working fine for one...

I am retreiving a recordset into a web page from an access db and want to build a small jump menu to allow users to sort the recordset by category (one of the columns retreived from the db). The index_jump page runs the SQL that retreives the recordset from the db to display. Basically I want...

I have an access db with a column set up as hyperlink containing website URLs. This data is dynamically retrieved into a DW Ultradev page. I want users to be able to click on the this hyperlink within the web page. When retrieving this column data into DW Ultradev I notice that #'s have been...

I have some ASP code sitting on a web server that gets the current directory that the asp file sits in: pathStr = request.servervariables(&quot;PATH_TRANSLATED&quot;) scriptStr = Replace(request.servervariables(&quot;SCRIPT_NAME&quot;), &quot;/&quot;, &quot;\&quot;) Dim nameArr nameArr =...

Hello, My MS Access database driven website has got 39 concurrent users trying to query (read only) the db. I'm getting the error : Microsoft OLE DB Provider for ODBC Drivers error '8007000e' [Microsoft][ODBC Microsoft Access Driver] System resource exceeded. I've had 23 users querying the...

Hello again - I could'nt find an answer on this topic below which I posted a while ago - would anyone know of another HTML/ Cross broswers compatibility forum I might seek help from ? -------------------------------------------------------- I have got an issue with a dropdown control in a form...

Hello, I have got an issue with a dropdown control in a form. The dropdown list items are dynamically populated from a database. In IE and NS6.0 the control displays properly, eg. on clicking the dropdown the list expands to show several items at once. In NS 4.78 when you click the dropdown...

Hello all, Is there a simpe way of removing line break characters from an Excel cell I have a column of data that was exported from Lotus Approach db. When opened in Excel there are several line break characters throughout the text. I need to strip these out and have over 1500 rows. (I tried...

Hello, Can someone point me in the right direction for building the SQL to do the following (I've used generic names for the example - hopefully to make the concept clearer) : I've tried an insert/append query but am not sure how to insert multiple rows based on another field criteria. There...

Hello all, I have a frameset called index1.asp which consists of 2 frames a top frame and a mainframe. .... within index1.asp, after </head> .... <frameset rows=&quot;21,*&quot; border=&quot;0&quot; framespacing=&quot;0&quot;> <frame src=&quot;top.html&quot; marginwidth=&quot;0&quot...

Hello, I've been reading some of the posts to try and work out how to use UNC path mapping for the problem below. The problem is I have a linked Excel table in my db and the path of the linked table is absolute eg. pointing to my C:\directory1\directory\book1.xls. Because the db will sit on a...