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 Rhinorhino 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: stucker79
  • Order by date
  1. stucker79

    updating only a few pages

    let me add that the reason i ask is because my coworker and i are working on different pieces of the same project and just copying our pages up isn't working. we both named our projects the same but obviously i guess we can't include both of our dlls. should we name our projects different and...
  2. stucker79

    updating only a few pages

    if I make changes to a page and copy only the affected page up to the server, it doesn't use the new copy. do i have to copy the bin directory too?
  3. stucker79

    basic dataset question

    I feel crazy asking this, but I'm not exactly clear on how to run a "query" against a dataset. In other words, I have loaded a whole group table into a dataset and need to query for a specific groupid. I have queried the active directory for a list of groups that a specific user is in. I need...
  4. stucker79

    sending multiple inserts to sql

    at most it would be 6. thanks for reminding me about how they could fail. i'll use a transaction, thanks!!
  5. stucker79

    sending multiple inserts to sql

    I have queried Active Directory for a list of groups a particular user belongs to (comes back in an array). First, I need to loop through the array looking to see if any of 6 particular groups exist. Then, if any of them do exist, i need to update a table with this information. I am basically...
  6. stucker79

    easy string question

    hey I never knew about the split method, that's great!! thanks!!
  7. stucker79

    easy string question

    If I have a string value equal to "Firstname Lastname" and I want to separate the two into their own separate variables, how can i do that? i think i will need to use an instr to find the " " but I'm not sure what to do after that. I'm using the faq on access the active directory to get the...
  8. stucker79

    postback is confusing me

    I'm not sure if the control has built in caching, i looked in there help file and couldn't find anything. Here's my code: If Not IsPostBack Then SqlConn.ConnectionString = ConfigurationSettings.AppSettings("SqlConn") 'Populate Calendar Dim daGetTitle As...
  9. stucker79

    postback is confusing me

    I forgot to mention that when I debug this, it almost seems to be cached somehow. I say this because when I stop and restart the project, it will show up with duplicate entries on first page load.
  10. stucker79

    junction table

    thanks i wasn't sure if i needed another primary key for the usergroup table. how do i designate both of those fields as the primary key for the usergroup table?
  11. stucker79

    postback is confusing me

    I am using a control I purchased called calendar.net. I have some code in my page load event that populates that calendar with items. I currently have the code in an if not ispostback statement. I realize now that when a user navigates away from the page and then goes back to it, that code...
  12. stucker79

    junction table

    For instance, I have a table for users, and a table for groups. A user can belong to more than one group, and a group can have multiple users in it. So I made a UserGroup table that contains the following fields: UserGroupID (pkey), UserID (fkey), GroupID (fkey). Then I made a one to many...
  13. stucker79

    can I "reuse" a sqlcommand object?

    Thanks ThatRickGuy, that was it.
  14. stucker79

    junction table

    I have a many to many relationship which I have designed as two tables each with a one to many relationship to a junction table (with the id fields from each of the other two tables). When I do an insert to the two "regular" tables, what is the best way to get the id values into the junction...
  15. stucker79

    can I "reuse" a sqlcommand object?

    It seems to be cached or something, I change it's properties but it throws and error "too many arguments specified". if i change it to a different sqlcommand object it works fine...
  16. stucker79

    can I "reuse" a sqlcommand object?

    I would like to declare one sqlcommand object in a module that I can use across my project. Is there a way to "clear" a sqlcommand object so that I can use it again for a different stored procedure?
  17. stucker79

    sql grouping

    Ignore what I said about it repeating records, i was looking at it icorrectly. This is great! The only thing left is the ordering.
  18. stucker79

    sql grouping

    ok i tried putting sum(calc) in which is the field i need the sum on. It kind of worked. It didn't order them in order of most expensive and it repeats some of the records? sorry, advanced scripts are new to me!! thanks!!
  19. stucker79

    sql grouping

    is the sum(...) literal or am I supposed to put sum(project, maincategory, itemid) in there?
  20. stucker79

    sql grouping

    I'm working on a report for my boss. I am grabbing info from a table that has the following fields: ItemID Item ItemAmt Quantity Total (which is a calculated value of itemamt * quantity) MainCategoryID ProjectID Notes Deleted (a bit field indicating whether the record is "deleted")(users here...

Part and Inventory Search

Back
Top