Search results for query: *

Nutshell version. We've got an Exchange 2003 mail server behind our firewall. The IP is not externally routable. We do not have an ISA server. We have webmail working through a DMZ'd server that port-forwards through to the mail server. As is, does anyone know of a way to get the Exchange...

Scenario: Cell A1 contains whatever data Cell A2 contains formula : =A1 Any data changed in A1 obvoiusly changes A2. Is it possible to change the format of A2 based on the format of A1 as well? i.e. Set A1 to bold, and automatically have A2 changed to bold? Found ways to get close with...

The goal is to scp into another server and pull all files matching a format, say 20060408.gz, from all folders in a certain directory, say /home/tmp. scp -r user@server:/home/tmp/ del/ keeps the file structure intact, but obviously, pulls all files, not just 20060408.gz. scp -r...

I've got a php page that, under certain, rare circumstances, adds a row to a table. The goal is to receive an email notification whenever a row is inserted. xp_sendmail is not an option (have 'sa' access to mssql, but little access on the box itself). MSSQL Notifications are out for the...

I've got a number of tables containing data that comes from outside sources. I'd like to create a unifying view of the key information. The issue is session time. Most of the tables have this information stored in seconds. Some only contain the start & end dates. I can get the session time...

I've got a package set up to pull an excel file from an ftp datasource. The format is along the lines of filename20051115.xls and changes daily based on the date. I have a dynamic properties task that generates a filename for a date of 3 days prior. All runs fine as is. The issue is that the...

How does one go about viewing images stored in SQL? I've googled my little heart out, and can only find pages telling me not to store images, just pointers to their physical locations. I'm aware it's not optimal. But I'm a knowledge sponge fallen off the wagon. Though it's extremely rare...

Between a 'begin transaction' and 'commit transaction', will the database lock all tables involved until the commit transaction is executed? I've seen various posts about locking single tables, but the proc I'm using touches a few dozen tables. If the 'transaction' doesn't lock all of the...

I tried posting this in the Windows forum (can't find a DOS one anywhere). Here's the issue. I've got a number of web pages on an intranet at work. I can't access the server from home. Though I CAN get to it through our billing server by using xp_cmdshell and a linked server to the intranet...

Is it possible to append text to a text file from a command line in dos? (sorry, no dos forum I could find). Figure this is a quick and easy yes or no. Thanks, folks.

Not sure which forum to post this to, feel free to send me elsewhere if need be... Is it possible, on one page, to have two dropdown boxes... the first drop down to choose a database, then the second dropdown would query that particular database for the values to populate it? Ex. Dropdown 1...

Example: A report with drilldowns on these groups: level 1 STATE, level 2 CITY, level 3 RATE GROUP, level 4 contains the detail. Is there a way to set up the report to skip a level, say, drilldown CITY and receive the customer detail? I don't want to lose the RATE GROUP level data if I need...

When you have a page load, is it possible to have it check if it's loading in a frame, and if it is, to have it open in a new window instead? Forgive the ignorance. Not my area of expertise. Thanks all.

I receive this error when running this script (tablenames have been changed to protect the innocent) declare @dbname varchar(50) declare @id varchar(10) set @dbname = 'database1' set @id = '1001' declare @sql nvarchar(3000) set @sql = 'select top 5 table1.id, value from...

I began to post to the html forum, but they seem distracted with a post about toilets... As this is in a php page passing variables, maybe it should be posted here anyway... I've got a search page w/ a pull down list & a text box. The customer selects one of the options, and types in a...

I'm trying to create a page that will allow a user to change basic information...Example of table data: Value Existing Change ----- -------- ------ Name Bob ______ Login bobrocks ______ pass jimbob ______ --Submit-- The Change fields are textboxes. The...

This may be a stupid question. PHP is not my strong suit. I'm trying to put a total at the bottom of a query result w/ no success. It wasn't working so I added in a running total to see where it hung up. This example works fine but doesn't format properly: $grand = 0; while...

I've got a much larger text that I just about posted. If need be, I'll post that, but I think my issue would be solved by one little hurdle. How would one go about this... set @var = 'A' set @var2 = @var + 1 ...and have the result for @var2 be the letter B ? Assume everything is in context...

Didn't have much luck searching the site for this one, but I'll bet it's in here somewhere. I've got a very basic php search page that queries an MSSQL database. You throw in a name, it searches. The obvious problem is when you put in a name such as O'Connell, the query hits the apostrophe...

Essentially, what I'm going for is an automated mass emailing done daily. I've got the scripts that pull all of the customer information. I've created mail templates in Crystal & Excel to manually send these, but I've been told I need this to be completely automated... today. I typically try...