Recent content by JohnBeals

Thanks, Obviously I haven't done this before. A little assistance to set me in the right direction would help. Do I use MailSrv? John

Is it possible to set up an email server on a Home NT4 Server with IIS? Here's my sit. Registered Domain Name Server (let's say it's myserver.com) Full-time connection to server via Cable Modem. Router IIS Installed - web server working on a NT4 Server. Email addresses for the family using the...

I am still having this problem. I just posted the message below in the IIS forum. To answer the above question, I moved the Images directory under the main directory. See the new path below; I have a website running IIS. The pages use Cascading Style Sheets. Some users don't see the...

I have a website running IIS. The pages use Cascading Style Sheets. Some users don't see the background on the web pages unless they refresh their screen by resizing the browser or opening another window over the browser. You can literally "paint" the background with a smaller...

That's it! Thanks! The folks on this site have saved my bacon on multiple occasions. I spent 2 hours looking through my SQL 7 books without finding the answer to this question. I got it here in 5 minutes!!! Thanks again! John

I have two tables that are identical. One holds current data and one holds historical data. When we're finished with a record we move it to the historical table. This is a new process to speed up the application. I need to query both tables for reports. I'm drawing a blank on this. I...

I have a stored procedure that takes 10 - 15 seconds to run. I need to display a "Please wait" message until the records are returned. Then the "Please wait" message is replaced by the records returned. Any suggestions? Thanks, JB

Set NoCount On and Set NoCount Off seems to be required for @@IDENTITY to work. Without it I get the error stated in my original message. With it the code works. Thanks to everyone for this. It will help me bulletproof my code even better. John

Nope, using "Ident" instead of "ID" doesn't work either. Nice thought though... JB

I need to capture the Identity field after inserting a record. I was told to use the @@IDENTITY (http://msdn.microsoft.com/library/en-us/tsqlref/ts_globals_50u1.asp) function. So I have this: <cfquery name=&quot;InsertRequest&quot; datasource=&quot;#db#&quot;> INSERT INTO tbl_SchedJobs...

That's it! Thanks!!! JB

On SQL 7, using a Query Insert: I need to get the Column Identifier of the new record after an Insert. Does the Insert return any values? My concern is, that if I get the last ID and then assume the next ID is from the record I inserted, another user could possibly do an insert between my...

Thanks Vanc, I realize it would be easier, but not what I'm looking for. I need to physically move the directory structure (or backup, uninstall, reinstall and restore). I'm looking for pitfalls to this, or the BKM for doing this move. Thanks, JB

I need to move the entire installation of MS SQL 7 to another drive. It was installed on C:\MSSQL7, and now of course we're out of space on C: drive. Can I back up the databases, uninstall SQL 7, install SQL 7 on the other drive and then restore the databases? Thanks, JB

jemminger, Thanks for the script. This script has two effects. One, it solves my script problem, and two, it introduced me to a programming method I was previously unaware of: Regular Expressions in Javascript :-) Learn sumpin new ever'day! JB