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 TouchToneTommy 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: rico14d
  • Content: Threads
  • Order by date
  1. rico14d

    count with a join and where clause

    Hi, im trying to report on 2 tables like the following tblMain MainId Name 1 a 2 b 3 c tblSub Id MainID Status 1 1 1 2 1 1 3 2 1 3 2 2 basically i want to show all the rows from the main table...
  2. rico14d

    SiteMapPath

    Hi, I am trying to use a SiteMapPath item in my page which works fine for most of my pages. However a number of URLs in the web.sitemap incorporate URL rewriting i.e. '/Products/ID=5/ipod.html' and the SiteMapPath wont seem to resolve it and display the correct node. Is there any way i can...
  3. rico14d

    asp:literal or asp:label

    Hi, What do people think of using the literal control instead of a label control? Im thinking of just using the literal control as i've had a lot of grief from a customer regarding SEO and the amount of redundant HTML code that is produced in ASP.Net. With the label control you might...
  4. rico14d

    Make SP return only 1 table

    Hi, Is there anyway i can clear what is returned from a stored procedure? Basically i only want to only return 1 table from the example below, instead of 1 empty table then a table of results. select * from Product where name = 'test' if @@RowCount = 0 begin -- I would want to 'clear'...
  5. rico14d

    NT Authentication without IIS

    Hi, I am trying to add NT authentication to a sub folder of my site but am struggling to do so. Is it possible to achieve this without making any IIS changes, the reason I ask is because when publishing a site, all sub-folders are deleted and therefore the IIS settings are lost. I thought I...
  6. rico14d

    Virtual Directory .Net 2.0

    Hi, How do i create a virtual directory in asp.Net 2.0? Im doing this so i can add an image folder to a project which isnt published to the live server. Thanks, Rich.
  7. rico14d

    Free hand Measure

    Hi, Does anybody know if there is a free-hand measure tool? Ive got a map and i wanted to trace my route and then work out the distance to scale. Thanks, Rich.
  8. rico14d

    Datatable Select - Using convert() ?

    Hi, I have a datatable which i need to order numerically. However, even though the column contains numeric data, it is a string datatype. Can i use a convert() in the order parameter? Ive tried the below code but it didnt work. drChildMenus = dtMenus.Select("Menu = 1"...
  9. rico14d

    Convert number to hex

    Hi, I'm trying to convert a number to its hex value which i can do with- System.Convert.ToInt32(12323) However, the number im trying to convert is much bigger (a MD5 hash result - 975415459309518814222848482335161230234) and the function errors. Any ideas anyone. Rich.
  10. rico14d

    Computer wont boot

    Hi, On a friends computer i recently installed office XP. On the next reboot the processor speed is shown at the top of the screen and at the bottom it shows Press DEL to enter setup and it just hangs there. Pressing DEL does not do anything and none of the 'lock' lights work. I tried...
  11. rico14d

    turn off validateRequest at runtime

    Hi , Is there anyway i can turn off the validateRequest at runtime? I want to allow only administrators to be able to submit HTML in a form. Thanks, Rich
  12. rico14d

    Regex help

    Hi, I could'nt find a regex forum so being as im using VB at the moment, ill post here. Im trying to test if a string contains 2 consecutive pairs e.g. 323535577091 true (5577) 312339565444 false The closest i've got is (\d)\1(\d)\1 but this only matches if the 2 pairs are the same -...
  13. rico14d

    conditional 'where COLUMN in'

    Hi, In my stored procedure i pass in a CSV list of IDs and use the IN statement to select from them. However, sometimes i will pass in a blank string and therefore dont want to use the IN clause. The below logic works correctly when the CSV list is blank - where ((CategoryID in...
  14. rico14d

    Self Referencing Table Query

    Hi, The Scenario: I am building a product database, each product belongs to a category. Each category will (usually) belong to a parent category. I need a query which can return each category and the number of items in it e.g. Computing(320) Laptops(100) PCs(100) Printers(120)...
  15. rico14d

    ASP URL question

    Hi, Can someone explain what exactly the following url is doing. Ive not seen this syntax before and am unsure of it. http://www.test.com/index.asp/page=test2/test3.htm Thanks, Rich
  16. rico14d

    isArray function

    Hi, I need a function to check for an array of form elements. At the moment I am using this - if (document.form1.text_box.length == undefined) //not array But i need a way to do this in IE 5.01 and it doesnt seem to work. Anyone have a different way of checking for this? Thanks, Rich
  17. rico14d

    Shortcut for 'Find'. Interdev 6

    Hi, Does anyone know of a keyboard shortcut to put the cursor into the 'find' box on the toolbar. I know Ctrl-f opens the find window but most of the time im searching the current file so i dont need any of the other options that are in the find window. Thanks, Rich
  18. rico14d

    Com+ dll

    Hi, Ok, Im not a PHP programmer, can you use Com+ dll written in VB for use in ASP, in PHP? If so, whats the best way to handle collections? Thanks, Richard.
  19. rico14d

    Duplicate Column Names

    Hi, Im using a recordset thats a join on 2 tables each with the same column name in them (not the foreign/primary keys). Is there any way when im referencing the recordset that I can specify which one to return? At the moment when I ask for rs("status") i just get the first one that is asked...
  20. rico14d

    Music slurred

    Hi, Im making an MP3 jukebox from my old PC (AMD 300mhz), when i playback MP3s they slur when the PC is doing other things, even when i move the mouse! The sound card is onboard the the motherboard, is this why it has such poor performance or is it just the spec of the PC. Also, it is running...

Part and Inventory Search

Back
Top