Search results for query: *

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!

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

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

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

I was wondering if anyone else has had the following problem, and if so, how they fixed it... First, I noticed that SQL Server Agent was not running..so, I tried to restart the service..but it would stop immediately after I clicked on Start. Next, I noticed that I could not create any new...

I am trying to push two sessions through one url...but I am having no luck. Below is my code response.write "<TD><a href=ATHLDetail.asp?Detail=" & rs("PIDM") & "CRN=" & rs("CRN") & ">" & "Select" & "</a></TD>" The code above simply concatenates the two together and does not make them two...

I am trying to create a ASP page that will count fields in a table and display the number...For instance Men's Soccor 10 Women's Soccor 5 Men's Basketball 0 I have wrote a SQL that will count all the records...but I don't know how to assign each one a value...It only rembers the last...

I have a combo box that pulls the value from the database. But, whenever the value is a string (eg. Bob Jones)..it will only capture Bob. <Select Name = "Name" value ="<%=session("Name")%>"> <Option Value = <%=rsAddComments("Name")%> selected> <%=rsAddComments("Name")%> </select> But...if I...

I can get the email to work whenever I am using my testbox, which is a XP Pro workstation...but whenever I try the code on the Server 2003...I get the 80040211 error. I have turned the firewall off on the Server and still get the message. Has anyone else had this problem and figured out what...

I need to update sql statement with multiple rows. For example, the primary keys are Major and Study. The second column is a Value. Primary Value Major 10 Major 20 Study 01 Study 02 I need to keep the Primary Keys the same but change the Study Value field to the same as the Major Value...

I need to pull only one record from access for each customer based on the last order date. I have tried to use a inner join in Select Query. I have the following as a where statement: (Select MAX (SPR_ACTIVITY_DATE) from dbo_SPR WHERE dbo_SPR.SPR_PIDM = SPR_PIDM) But it pulls no...

I have created a page called history.asp where users can add field values based on combo boxes...that page works great. Next I have created a page called EditHistory.asp, this page is used to edit the information. I want to be able to use combo boxes and preselect the same option that is already...

While trying to install a program it gave me the following error: Checking Swap Space: 1008MB Available, 1536MB Required...Failed Can I add temporarily Swap Space? or How do I add just permanent swap space? Thanks

I have two hard drives in a SunBlade. I need to name one of the drives to u01. I have vi the etc/vfstabs file and tried to rename the file there...but whenever I reboot the Sun the drives does not mount...it gives the error 'No mount point found for u01' Does anyone have any suggestions of how...

I have two 15.3gb drives in a Sunblade but only one drive is showing up. Whenever I installed Solaris 9 I do not remember any questions about the two hard drives but I selected the default settings. Would it be better to reinstall Solaris 9 and try to modify the settings to recognize the other...

I just updated to solaris 9 and I think I configured the time wrong during the installation. I have checked under the /etc/TIMEZONE and I have the right TZ setting...but my clock is two hours behind. Does anyone know how to adjust the time? Thanks

Instead of creating a new connection in a DTS package to add another table...i simply copied a connection and pasted it beside it...then i changed the name back to an existion connection under connection properties...needless to say, whenever i go uder disconnected edit >> Connections..i have...