I have tried a bunch of stuff on this one including putting the table names in with the field names most recently. I can do a select statement and get values from one table but when I try to join two I get nothing. Please let me know if you see something I don't, thanks in advance.
sql="SELECT...
This second login page works when the Username Password combination is correct but when it is incorrect, the response.redirect in the else part of the if statement fails. It goes to an error page Classic ASP Any ideas?
================================
<%
Response.Expires = -1
Dim strUserId...
I have a helpdesk asp form that invites our users to quickly point and click issues that they may be having and quickly exit the little app/utility. I would like to add an email component to this asp app so I can be informed when a user sends an issue. I tried to configure smtp on our IIS 6.0...
I have a STAFF table that has a pk called staff_id and I have another table EVENTS that has 3 staff fields because on any given transaction up to 3 people from the STAFF table could be involved. I can run this query in sql server but I can't get it right in Access. Here is my sql server query...
I have a main table(PC) with foreign keys from several tables such as Staff, OS, Devices. If I run an insert statement that adds a record to each of the tables, I know that the primary key/identity key for each table will be incremented. How do I get this new value to be reflected in the foreign...
Can I use Termainal Serivce to provide a different desktop for 6 users so that each user would have the Office Suite and some internally developed Visual Basic apps that use our sql server as a backend, or do I have to use Metaframe on top of Terminal Service like I did several years ago at a...
I am getting a message that says my temporary ts license is about to expire. I have a windows 2000 domain and this 2003 server is just a member server. I thought 2 license's came with the server for admin puposes. It does for w/2000 server. Or at least I have never bought any TS licenses for...
Using Windows Server 2000 native backup I would like to be able to restore a folder from a tape from another server that is unavailable right now, namely an NT Server 4.0. Is this even possible. When I open up the restore tab all I see are the prior backup jobs completed by that Server/tape...
For some reason when I try to save/update a form with a multi-line text box on it I get oledb errors. Then I simply change the text box back to NOT multi line and it saves/updates just fine. The backend database is sql 7 the field is varchar set for 500 characters.
aspvbwannab
I have a form that has text boxes that need to be updated. I am using this code. When I do a mouse over after toggling a breakpoint the rs!whatever seems to be holding the edited value but for some reason the rs.addnew or the rs.update isn't working. Here is my code. Thanks for any help...
I have an app going against a sql server with a form that has a combo box and five textboxes. I would like the textboxes populated with a recordset containing five selections from a table based on an id number. I am using the itemdata method of capturing and looping through but I am also...
I am trying to copy a folder with tons of subfolders and files from an nt 4 server to a w2k server in the same domain and I keep getting an error that says.
"cannot copy filename. Access is denied. Make sure the disk is not full or write-protected and that the file is not currently in use."
I...
I am running active directory. I have a mesh of mostly windows 98 pc's some windows2000. I have some windows 98 boxes that come up with the "bad username or password" screen and that no domain controller was able to authenticate them... but yet I am able to physically map a drive to...
Can anyone give me some code to reboot a server named HR1 that I can have the windows 2000 scheduler run so I can reboot our win2k servers on a routine schedule?
Thanks aspvbwannab
Does anyone have an idea of what the best approach to take to find out if users are logged in to a domain or not. Maybe a log could be generated giving logon times. Maybe a log somewhere. My users are w/95, w/98 and windows2000. Just looking for a push in the right direction. Thanks, aspvbwannab
Can someone give me the syntax to use a batch file to run a vbs file. I want to be able to add a line or two to batch files aleady in place to run a vbs file. aspvbwannab
I am using notepad for my editor for 8i. When I cut and paste the code to the sql prompt in sql plus the program runs fine. I want to be able to change the text file say,
test.txt to test.sql. so I can start it from the sql prompt by saying start c:\mydir\test.sql at the sql prompt. I have...
I am new and I have already submitted this posting once. I have acces to IIS 4 and IIS 5. At this point I am just trying to get it to work. I have made a folder in IIS 4 called Mydir and I gave IUSR permission to read and execute, list and read. I then made a virtual directory MyVdir in...
I set a simple directory in explorer ex. (vdir) I put in the simple time.asp that everyone has seen I give rights to the Iusr account, then I go into int. srvcs mgr and create a virtual directory (virsite)with the one I created earlier as the home directory. I enter in...
DOes anyone know how to put tabs on top of vb forms like you can do in Access or Does anyone know how to design anything different looking than a plain rectangular looking form. aspvbwannab
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.