Recent content by uncgis

Thanks again for the help... this code works out great and I will definitely use it again…but, it only searches the column name and not what is in the columns. Does anyone know how to search through all the text, in all the tables? thanks

Thanks for responding! I tried the code above but it does not return any value. what is the A.xtype='U'? Is that the user tables? Thanks again

Does anyone know how to use a find and replace in sql server 2000? I need to search all tables and columns.. Thanks for any suggestions!

Thanks for responding....the threads helped me out a lot. I think that I will use the session variables....do you know of any other way to handle logins (besides cookies and session variables)? Thanks again

What is the best way to handle user logins...Should I use cookies or session variables. I am looking for the best secure way. Currently, I am using this at the top of my pages 'Below checks to ensure that the user is logged in. if session ("username") = "" then response.redirect...

I ended up using two pages to get the program to work...but can XMLHTTPRequest be used in asp.net and asp pages? I would like to learn how to use it...but right now i am pushed for time

thanks for replying... where does the script go to update the database...on the yourpage.asp? thanks

I have a webpage with 3 command buttons... Read Contacted Print Whenever a command button is selected for "Read" or "Contacted" it needs to update the database. Is there anyway to update the database without being redirected to another page...I guess I am looking for how to add a function to...

Thanks for everyones respones...I have posted the SQL below that I am going to use...in case anyone is interested. Amrita418's having code worked out also...but some people had taken the same english class twice... Select distinct Shrtckn_Pidm From Shrtckn Where shrtckn_pidm In (Select...

Thanks for your response....your code worked out...Below is the actual SQL statement..in case you are intrested Select distinct Shrtckn_Pidm From Shrtckn Where shrtckn_pidm In (Select shrtckn_pidm From shrtckn Where shrtckn_crse_numb in ('1010', '1017','101') and shrtckn_subj_code in...

I need to create a SQL Statement that will display all students that have taken Eng 1010 AND 1020...I used crse_code In ("1010","1020")...but the works more like an OR than an AND. It returns all rows of students that have only taken one of the classes...for instance just 1010 and not 1020...

I need to create a query that will display all students that have taken Eng 1010 AND 1020...For the Course field I put In ("1010","1020")...but the works more like an OR than an AND. It returns all rows of students that have only taken one of the classes...for instance just 1010 and not 1020...

thank you for responding... That is exactly what the problem was...I did not change the file names. thanks again for your help

Does anyone know how to restore a backup file (BAK) to a SQL Server database that was created on another machine. I have right clicked on the database and went to restore database...I change the file path to my new BAK file and click ok...but SQL Server will not back up the file. THanks for...

What is the best way to handle user login? I currently use a session variable that expires after 20 minutes...but what if the user is not finished after 20 minutes? Can you reenable the session for each page? Does anyone handle logins different? Thanks for any input