Search results for query: *

Thanks all, I should be able to get on w/ this now. Cheers, Rich

Thanks to you both. Do you have an example of how to use the InStr function? Looked at the MS script repository, but couldn't find an example...

I need to extract a line from a text file and write that line to a new text file. I want to do this for each line that contains the string "AB". Does anyone know how to do this? Thanks, Rich

Works like a charm! Cheers, rich

I need to delete all files in a folder w/ 'qmtext' in the filename. Does anyone know how this can be done? Cheers, Rich

Cheers to you both.

I have 2 small tables (one column) that contain email addresses. I want to compare the tables to find out which email addresses match up between the 2 tables. Is there a simple way to query for this? Thanks, Rich

I need to delete 16,000 + bogus activities from the activity list. The activity list can only delete in chunks of 500. I'd like to axe all 16,000 at once. Any ideas?

Does anyone know how to script the addition of static ip address (as in the advanced tcp/ip settings tab of the tcp/ip properties)? I can only find examples for adding a single static ip, netmask, gateway... Thanks, Rich

Does anyone know how to set file permissions via asp.net? I have a page that allows me to upload files, but I want to be able to set the permissions on the file after I upload it. Any ideas? Thanks, Rich

Hi, the problem is that emails sent via this page are not being sent formatted in HTML, they are formatted as text messages. As far as I know, the only difference should be in one line: To send in HTML: objMail.BodyFormat = System.Web.Mail.MailFormat.Html To send in Text: objMail.BodyFormat =...

Thank you for your reply. "localhost" is a valid mail server. I have sent several test messages successfully, but the messages are sent in plain text. Rich

I cannot figure out how to send messages in HTML format. My code is below, do I need something else besides objMail.BodyFormat = System.Web.Mail.MailFormat.Html? Thanks, Rich <script language="vb" runat="server"> Sub sendmessage_Click(sender as Object, e as EventArgs) Dim objMail as New...

Who's better than you? Works wonderfully now!! Thanks so much. Rich

No luck, I still get tons of <Null>s for the fields I specfied to be not null. Any ideas? Here's my code: SELECT DISTINCT Company, Contact, Address1, Address2, City, State, Zip, Country FROM Contact1 WHERE (COMPANY IS NOT NULL)AND(CONTACT IS NOT NULL) AND (TITLE IS NOT NULL) AND (ADDRESS1 IS...

Hi All, I an a newbie to SQL queries and need to select rows from a contact DB where Address, City, State, Zip aren't null. I hope I am using the right lingo. Basically, if any of those fields are blank, I don't want it. I tried using city not is null, zip not is null, etc. but the query...

Thanks everyone. I was able to use the join to get this to work. We actually used one of those DMAs to get all of the zips in the Chicago metro area, but it was a matter of querying the database for the contacts w/ those 700 zips. Thanks again for the help! Cheers, Rich

Ok, thanks, I'll go that route.

I am a newebie that needs to query a database of addresses, using zip code as the criteria. Problem is that there are 700 zip codes in this case. Does anyone have any suggestions on how to do this? It would take for ever to do Select * from table1 where zip = 'xxxxx' or 'xxxxx"... Thanks! Rich

Hi Mark, Thanks for your response. This doesn't seem to work. Maybe the issue is that the file names are like LPT$VPN.100, LPT$VPN.101 and so on. Is there a way to specify a wildcard to get rid if files containing LPT$VPN? Thank again, Rich