Search results for query: *

Ok I appreciate the help. I will give that a try and see what I can do. Thanks for your help.

Yes it is SQL running on server 03. That was a made up example. Actually it is too tables that I have joined. One has history of audits with WSID and the other is WSID with other fields like FileCapture that I do. I join the two tables and then am trying to do a listing of latest date of...

I'm trying to pull some information from a SQL database. I'll explain a bit what the table is comprised of to better explain my problem. I have data inputed into the table from an audit that runs on a PC. Each PC has an workstation number and it records the date it was audited. Because each...

I was trying to have it imported from the form but I set the default value in the SQL field to getdate(). I thought you could use that in the actual ASP page. I would still like to know how to pass a datetime format to a SQL database correctly with the SQL set as datetime or smalldatetime...

I've tried that but I get a type mismatch on that line.

I'm trying to insert the current date into an SQL database. I have tried the database field set to datetime and smalldatetime. I have tried using the commands date() and also building the date manually by grabbing month..etc. What is the easiest way to input a date into a datetime field...

Nope but I'll try it in the morning. Thanks!

The error is a error in the string. However if I do it where it calls the querystring in the insert, it says I can't do it because it can't convert to numberic. MY DB is set to numeric but it wants to do string.

Ok well I tried a different way and it works however I can't seem to write a value to my database as a numeric when called from a querystring. Sample code is this. If isnumeric (Request.Querystring("WONUM")) then WONUM= Request.Querystring("WONUM") sql_insert = "insert into MISSurvey (WO_NUM)...

Quick note, this was on my test page so the ', right after values is not actually there. it is & " TrainingExplain, Notified, Overallexperience, Comments) values (" _

I'm trying to replace all apostaphes and I can't get this to work. Here is my script. In what format do I need this in to be able to work? Right now putting the variable addtrain in there doesn't go in my database at all. Please assist :) <% Set Conn = Server.CreateObject("ADODB.Connection")...

Actually you did help in a way. By seeing the command you use to replace, I did a search on it and found a way to replace all the proxyaddresses fields. Well if I replace them with test.net, AD doesn't like it and it auto rebuilds. Cheap work around that works great.

Even more simple. Most software packages have a specific file they copy or version. What we do is check to see if a file exists. If not, it runs the program. if not exist "C:\Temp\path.txt" \\server\program.exe

I got it working now. I'm just going to touch up my script to loop.

Ok this script updates the email address on the general tab like you were saying. But I need to remove the ones that are referenced as proxyaddresses. I don't think it can be done unfortunately. Great script though.

I'll try that. Thanks.

Well I am looking at the email field on the main AD listing. It is just that each user has 3 emails. I just want to import directly into AD and remove one. I reread the original guys thread and I think he meant something else so I'll just back off but if you have any solution to this, let me...

sort of. We have 3 domains for our email but now we only have 2 so I need to get rid of the other 1. Well I know it is much easier to just remove them all and let AD rebuild the other 2 back. For example we have: joe@abc.com joe@abc.net joe@abc.gov Well we need to remove the .net email but...

I'm trying to remove all the proxyaddresses within user id's in active directory. We recently changed out domain extension, so I need to remove them all and then have AD rebuild the correct ones. I can display them all with ldifde command or a simple script. I just can't figure out how to...

I have tried this. I swear it soudns just like the question I asked. I have a way of exporting but not deleting. I'll be working on this next week probably so if you find anything out, let me know. The way I'm going to probably do it is by replacing all email addresses with nothing. I don't...