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!

Register Log in
  • Congratulations Chris Miller 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. prover

    Get the path to a file on a users machine

    Yup your right. No playing out of the sandbox! TY
  2. prover

    Get the path to a file on a users machine

    This may be simple but it eascapes me... What i'm doing is reading data from Excel to a datareader. I don't have a problem with doing that. My problem is trying to point to the Excel file on a user local machine. If i hard code the path i'm fine. I was playing around with the fileupload...
  3. prover

    dropdownlist values start at 6am and end at 9pm...

    I need to create a dropdownlist that has time values from 6am to 9pm (on the hour and half hour) as values. EX: 6:00AM 6:30AM 7:00AM 7:30AM etc... I've hard coded this but there has to be a way to do this via code. Maybe not? Ultimately i'd like to be able to reuse the code say for instance...
  4. prover

    Update a record based on checked/unchecked value in a checkboxlist

    After my post i realized (imediately) that my first idea was (lets face it) DUMB! I left the post anyway figuring someone could help with other ideas. I thought of deleting all records then adding the new values but that seemed to simple and heck simple things escape me :) Thank you!
  5. prover

    Update a record based on checked/unchecked value in a checkboxlist

    I have a form with preselected items in a checkboxlist control. What i'd like to do is either add a record if a checkbox was checked. Delete a record if the checkbox was unchecked. A user checked the following items and recorded them to a DB. Checkboxlist Items: car truck (checked) boat...
  6. prover

    Stored procedure Help Insert with a one to many relationship...

    Thank you both! 1. I was thinking the same thing two separate sp. one to add the person the other the languages (if any). Its nice to have confirmation. 2. The code to split the delimited string. Wow thats going save a lot of time! I just love Tek Tips and the experts helping us!!!
  7. prover

    Stored procedure Help Insert with a one to many relationship...

    I need some advise. I have a person table and a language table with a one to many relationship. I want to be able to add a new person and if they speak ohter languages then add then to the lang. table. The data is comming from an asp.net page. I'd rather not insert the person , return the...
  8. prover

    check box wont uncheck

    in the onclick event you could: me.checkbox.value = 0 if there are a bunch you could loop through comparing control types. suedo code: if control = "checkbox" then control.value = 0 something like that.
  9. prover

    Import MS Outlook Appointments Using a Date Criteria

    I can import all appointments from Outlook but what I'd like to do is only import appointments between a certain date period. The following code imports all appointments.. is there a way to refine my criteria? Dim ol As New Outlook.Application Dim olns As Outlook.NameSpace Dim cf As...
  10. prover

    Show multiple languages spoken for each person in a GridView

    I created a function that returned a (coma delimited) list of languages for each person. TY All! Never argue with an idiot. He'll just drag you to his level and beat you with experience!
  11. prover

    Return list of people with multiple languages spoken

    duh... a function!!! I knew it was simple Never argue with an idiot. He'll just drag you to his level and beat you with experience!
  12. prover

    Return list of people with multiple languages spoken

    My brain is mush. I know this has got to be simple but right now simple things escape me... I have "Person" table" and a "Language" table with a one to many relationship. I want to return a list of persons and any language spoken (if any) similar to below: Name Address...
  13. prover

    Show multiple languages spoken for each person in a GridView

    This may be simple but it escapes me. I have a gridview with the following columns: Name, address and position. I need to add another column listing all langaues spoken for each person (if any). My question is how to get the gridview to display each person and any language they speak...
  14. prover

    Calling Javascript from an asp button

    My first guess is that you are posting back the page and loosing state. Never argue with an idiot. He'll just drag you to his level and beat you with experience!
  15. prover

    Extract multiple values from one DB field and populate a checkbox list

    Ok here goes... I have a checkboxlist which stores its data in one field. how do i return that data back to the checkboxlist fro display. there are five options m - manager c - clerk a - assistant n - monitor and the values saved in the db: "mca" (if you checked manager...
  16. prover

    Where to put code when access to the <HEAD> tag isn't available!

    Thanks for the feed-back! So as long as my functions come before any calls to them I should be ok. I'm curious if there are any drawbacks (other than non-initialized variables) to not having my code between the head tags. Poor performance etc. ??? Just curious. I'm a newbee when it comes to...
  17. prover

    Where to put code when access to the <HEAD> tag isn't available!

    Hello, Our company has split our web pages into two include files. A header and footer include files. Because of this I no longer have "access" to the <HEAD> tags to place my javascript code. I was wondering if my js code should go above the ssi or below it? Or does it really matter...
  18. prover

    Adding a sequential number between a fiscal year help

    oh and thanks for the tip TJ! I'll test both.
  19. prover

    Adding a sequential number between a fiscal year help

    I came up with something similar myself: DECLARE @retVal int DECLARE @FYStart datetime DECLARE @FYEnd datetime DECLARE @NewNo int SET @FYEnd = cast('7/1/' + STR(YEAR(@Date) + MONTH(@Date) / 7) as datetime) SET @FYStart = cast('7/1/' + STR(YEAR(@FYEnd) - 1) as datetime) --if nothing...
  20. prover

    Adding a sequential number between a fiscal year help

    Hi all, I need a way to assign the next sequential (permit) number to an approved application. The trick is that every fiscal year the numbers restart at zero and the fiscal year is between 7/1/xx and 6/30/xx. for example if an application was approved on 8/4/03 i would need to get the next...

Part and Inventory Search

Back
Top