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: *

  1. TomasCrossroads

    use functions to separate some text from a string

    Are there always only 2 backslashes (\) ? In that case the solution from dbMark should work. Try adapting his code like this: Dim myText, pieces myText=".\sbp\B999999.CMI:Student Name: JOHN SMITH" pieces=split(myText,"\") response.write pieces(1)
  2. TomasCrossroads

    ASP & javascript

    i don't know the object you're using fro the menu but to redirect in javascript you have to use location.href='url' try this: mm_menu_0211140722_0.addMenuItem("Add Email...
  3. TomasCrossroads

    Error Handling not working, browser timing out

    try adding Response.End after the redirect to error.asp greets
  4. TomasCrossroads

    Submit form q

    If you post to the same page you'll need another form action to go further to the search page. So what you could do is check in your page wether a value in the first drop down list has been selected. If so, then populate your second dropdown with the desired values and make sure the action of...
  5. TomasCrossroads

    Problem displaying Excel data

    Ok it looks to me the missing fields from your excel sheet are either blank in the excel sheet or match the condition (for example when strMatchNum is "0" then it should display nothing) can you send the excel sheet? greetings Tomas
  6. TomasCrossroads

    Problem displaying Excel data

    The fact it displays some data means that your connection to the excel source is fine. If I understand correctly, cells 1,2 and 5 contain strMatchNum, strStartTime and objRS("Heading5")... right? From the code you supplied, we can't see what could be going wrong. Where and how do you...
  7. TomasCrossroads

    Best Practices Importing Data Files to SQL

    Hello, I'm into the exact same problem the last days. Here's what I have so far: - After uploading the source data file you can simply open it as a recordset (for txt, csv and mdb at least - i have problems with xls because you need a named range in the worksheet to act as table name). Once you...
  8. TomasCrossroads

    Something Fancy - ASP Page to pull up htm files and titles

    #1 For Each fileItem in curFiles fname = fileItem.Name fext = InStrRev( fname, &quot;.&quot; ) If fext < 1 Then fext = &quot;&quot; Else fext = Mid(fname,fext+1) ftype = fileItem.Type fsize = fileItem.Size fcreate = fileItem.DateCreated fmod =...
  9. TomasCrossroads

    Submitting a form with focus in combo box

    maybe this can help (i'm not sure): change the submit button in the form to a ordinary button and add an onClick event that changes the focus first and then submits the form... <input type=&quot;button&quot; value=&quot;submit&quot; onClick=&quot;this.focus();document.yourform.submit();&quot;>
  10. TomasCrossroads

    trouble with email formatting

    I'm not sure wether that is possible in cdonts but try sending the email in HTML format and put your recordset in a html table greetings
  11. TomasCrossroads

    Seeking ideas from multi-lingual programmers

    Ok, my idea: With javascript you could check which div's are shown and which are hidden. On the previous & next links add a javascript function (client-side, no reload of your page) that checks for the div tags that are currently open (loop through all existing divs and check the state) and...
  12. TomasCrossroads

    Something Fancy - ASP Page to pull up htm files and titles

    Hello, This is possible yes. At least when the folders you want to display are on the same server as the one your asp page is on. The FileSystemObject is indeed what you need. See the following url for examples on working with the filesystemobject...
  13. TomasCrossroads

    Excel.Application and adding named ranges in workbook

    Hello, Im' trying to open an excel workbook and give a named range to the contents of one worksheet. I need that named range to open a recordset afterwards... Anyone who can help me with some code. I know more or less how to accomplish it in VBA, but in not in ASP Code. In VBA it looks like...
  14. TomasCrossroads

    user need to import data in my database

    Hello, I'm writing an email application. I want one part of my site to control the client database. The idea is that we host the database and that a client can import data to it. I want to create some page that will invite the user to import data to our database. The client should have a couple...
  15. TomasCrossroads

    bit of basic asp code assistance

    Hello, your questions are more html-related then asp-related, but anyway here's some help :) - have the hyperlinks as clickable hyperlinks instead of text a hyperlink is formed as followed: <a href=&quot;http://url&quot;>click here</a> for your code this would make: Response.Write &quot;URL ...
  16. TomasCrossroads

    ASP &amp; Big Parameter Strings

    Depending on what is in the array you could try a few things. Easiest way is probably through a form or the url string. You could write out your array in one string, using a delimiter like : or --- or anything you think is appropiate. Dim sNewString, i For i = 0 To UBound(theArray) If i > 0...
  17. TomasCrossroads

    Request.Form question

    u suspect right try this: <SELECT ID=&quot;DisplayBy&quot; name=&quot;DisplayBy&quot; onChange=&quot;ChangeValues()&quot;>
  18. TomasCrossroads

    adding a dropdown list to allow selection of different directory

    Hello, I would work like this: make a page with the selectbox for the different directories. in the select tag add an onChange event: <select onChange=&quot;location.href='mypage.asp?folder='+this.value;&quot;> that way you reload the page giving you the right folder selection. Now you can use...
  19. TomasCrossroads

    Compare String and Totals

    sometimes it helps to use CStr() when comparing strings. while CStr(catname) = CStr(RS(&quot;Category&quot;)) but you'll have to be sure RS(&quot;Category&quot;) is never Null...
  20. TomasCrossroads

    Compare String and Totals

    a few things that might help if you intend to sum the hours in your asp code: - &quot;While CatName = CatName&quot; This will always be through and you'll stay in the loop forever. I guess you want to try this: While CatName = RS(&quot;Category&quot;) - add an extra RS.MoveNext outside the...

Part and Inventory Search

Back
Top