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

    INSERT new values from a recent INSERT

    Thanks for the response! The initial INSERT may insert more than one record. So I would need all the user_id's at once to insert them into the other table.
  2. cossiboon

    INSERT new values from a recent INSERT

    I hope the subject was somewhat descriptive. I'm trying to INSERT records into a table, easy... My insert statement is as follows: INSERT INTO user_tbl SELECT * FROM user_tbl WHERE user_id IN (SELECT user_id FROM list_user_index_tbl WHERE list_id = 11) This is simple. I'm inserting the...
  3. cossiboon

    Multiple controls with the same ID

    Hello, Thanks for the prompt response. I understand your idea here, although I'm not posting to the server, only refreshing (F5). josh
  4. cossiboon

    Multiple controls with the same ID

    Hello, On a web form, I dynamically create some panels at run-time which all have unique ids. The first time the page is loaded, it works great. If I refresh or navigate out and come back I get the following error. Multiple controls with the same ID 'pnlQuestionHeader12968' were found...
  5. cossiboon

    ASP.NET & VSS project file is checked out!

    Hey, thanks again for the quick response. Your help is helping me keep my sanity. I have a couple developers that were commited to Dreamweaver's Check In/Out functions and they are struggling with this concept.
  6. cossiboon

    ASP.NET & VSS project file is checked out!

    Thanks! That is exactly what is happening. This process just seems a little cumbersome. Also, if I have any other files checked out, those files are checked in when the project file is checked in.
  7. cossiboon

    ASP.NET & VSS project file is checked out!

    Greetings! Recently, our company decided to migrate our website into ASP.NET. In addition to that, we are starting to use Visual SourceSafe 6.0. I have the database setup and all the users added and linked into the VSS database. A problem arises when someone makes a change to a project .aspx...
  8. cossiboon

    DataGrid/DataView missing first record

    '----------------------------- 'Setup the SELECT Command for email list '----------------------------- sSql = "SELECT user_tbl.user_id as uid, user_tbl.*, opt_out_tbl.email_address_vc as opt_out_address, psi_tbl.user_id as assignedtosurvey " & _...
  9. cossiboon

    DataGrid/DataView missing first record

    I'm fairly new to the .Net world, but have plenty of experience in ADO, VB 6, ASP and SQL. I'm creating a page that lists user in an email list. In asp.net using ADO.NET, I've created the SQL statement, SQLDataAdapter, dataset and created a dataview of the list. Then bound the columns...
  10. cossiboon

    Select/Join query execution time too long

    No indexes. user_tbl user_id primary key list_id is a primary key in the list_tbl not the list_user_index_tbl Could you give me an example of getting the user_id instead of the email_address_vc field? Because this doesn't work, email_address_vc needs to be in the select for the Group by to...
  11. cossiboon

    Simple/Not So Simple Select

    If you are asking how to query a table with special characters, it's easy. The only special character that will pose a problem is the single quote. Example: SELECT BarName, Address, City From BarTable WHERE BarName LIKE 'Joe''s%' If there is a single quote in the search criteria, add...
  12. cossiboon

    Select/Join query execution time too long

    Okay, I hope you guys can keep up with this... Here's my dilema: I have a user table, a list table and a list/user index table. Our interface allows people to create lists and I need to do a check to verify if there are duplicate email addresses in the same list. So I wrote the query below...
  13. cossiboon

    Insert multiple records w/o select subquery

    Hello. Hopefully somebody has an answer to this. My website imports a list of contacts from a tab delimited file and sets all the data into an array. I then loop through that array and insert each contact using a stored procedure. I'm curious if there is a way to insert the whole array with...
  14. cossiboon

    searching an ntext field in a table.

    It's one of those things I should have known. I can't believe that!!! Thanks for the help!
  15. cossiboon

    searching an ntext field in a table.

    I have a table that contains an ntext data type field. I need to do a search on that field to see if a record exists in that table. I'm running a stored procedure, but the data may have a single quote in it. I've tried two ways to try to run the query/stored procedure within vbscript/ASP. 1...
  16. cossiboon

    devldr end task on win 2000 after using CF

    Oh wow! I uuuhhh. Sorry to bother the CF panel. But, I could have sworn this started happening after CF was installed. I thought I would try and update my drivers first. I also looked on MS site. Thanks.
  17. cossiboon

    List delimiter problem.

    Yes I relize that I do not have the delimiter specified in the previous post. Gauranteed, it's in my code. But Thanks.
  18. cossiboon

    List delimiter problem.

    This is probably an easy question. I am populating a list from an array using the arraytolist function. Then I go ahead and display the list using the cfloop tag. My delimiter is ~N~. When the items are displayed, I lose the first character if the first character of the item is in the...
  19. cossiboon

    devldr end task on win 2000 after using CF

    Anyone? Have any ideas?
  20. cossiboon

    devldr end task on win 2000 after using CF

    At the end of the day when I need to shutdown, my system hangs then an end task dialog box appears for devldr. I click the end task button and my system does one of two things: -Hangs for about five+ minutes then shuts down. -Never shutsdown. Has anyone encountered this before. I am using...

Part and Inventory Search

Back
Top