Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: credo
  • Order by date
  1. credo

    Displaying a passed variable between ASP pages

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

    Order by - multiple key descending order

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

    Group by and count sql

    Thanks Cheerio and Tony - that's solved it.
  4. credo

    Group by and count sql

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

    Dynamic Response.Write passing URL vars

    thanks very much - it now works.. !
  6. credo

    Dynamic Response.Write passing URL vars

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

    ASP error displaying "True/False" db field as yes/no

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

    ASP error displaying &amp;quot;True/False&amp;quot; db field as yes/no

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

    Excel importing into Access

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

    Video capture problems w MatroxRT2500/Premier

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

    IIS set up and moving from PWS

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

    IIS set up and moving from PWS

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

    IIS set up and moving from PWS

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

    Keyboard problem

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

    Trouble with Rollovers

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

    Trouble with Rollovers

    Hi Derrin, Can you check again ? (my isp was down for a while). The link you put in your last post works for me - should be red triangle on a blue background. I just rechecked the following browsers again - using test component 14 - clicking on preview link : Ie 5.0., 5.5 and NN.4.7 - popup...
  17. credo

    Trouble with Rollovers

    no problem - have marked the thread and anytime you require Flash help I'll be glad to assist. Yes, I forgot to mention - only component 14 has a working URL - all the rest are dummy URLs'. In NN6.01 -the pop-up opens but it is completley blank with just the NS6.0 title bar - there's no 404...
  18. credo

    Trouble with Rollovers

    thanks Derren, - your solution works - that's twice you've helped me I really appreciate it. One final problem is that when clicking on a &quot;Preview&quot; link (as opposed to the magnifying glass) should open up a popup window (displaying a URL that is retrieved from the db). In NS4.7 and...
  19. credo

    Trouble with Rollovers

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

    Dynamic jump menu to sort recordset

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

Part and Inventory Search

Back
Top