Search results for query: *

Also M-F and omit week-ends (Sat-Sun). Thanks again, David

I don't do a ton of javascript but we have to use javascript for this since the vendor uses javascript. Here's what we're trying to do: Add 6 or 12 hours to the current time. We'd like to have it calculate it based on 7am-5pm work hours. Example: User completes the form at 3pm and it's a 6 hour...

Guess it would be client-side. Executing it in a function in IE.

How could I do this in javascript? objForm.ADORecordset("RequestorEmail") = username I tried just <% objForm.ADORecordset("RequestorEmail") = username %> but it didn't like it.

We had some issues that lead to the need to restore from backup. The .bak file is 5megs. When I try to restore it's making a huge 35gig+ log file and basically hangs. It never restores the db. Is there anyway I can restore the db without the log file? Why would the .bak file be 5megs but the...

Looking to make an ASP page that queries a specific Ip and port just to see if it responds. (allows a connection) Just a basic server up check. Can't seem to find anything that gives me any direction on how to do this. Thanks.

Don't remeber any bit question but I know you'll see OSI layers order of data. So make sure you know what data is called at each layer.

Site I used for free prep material is http://www.net130.com

I've taken and passed the 642-891 about October last year. It's a pretty brutal test in length and content. I did it to get my CCNP and skip 1 test. Best advice I can give is get a testking from testking.com and go over it 3-5 times cover to cover then take the test few hours after you go thru...

I have this same issue. I'm in need of a fix as well.

When you have TS setup in Administrative mode you *must* be in the administrator group to have rights to log on.

Final select was: Select Count(*) FROM [Masterfile] LEFT JOIN [Inventory Tracking] ON [Masterfile].[Store #] = [Inventory Tracking].[Store #] WHERE [Masterfile].[PC/LAN1 Start] >= '4/29/2003' AND [Masterfile].[PC/LAN1 Start] <= GetDate() AND [Inventory Tracking].[BOM Ship Date] Is Null AND...

Thanks everyone. I modified Atomic's and think I got it working right. Thanks, David

Anything will work for record count. [Masterfile].[Store #] would be the logical choice. What I was trying to do is somethink like this: Select Count(*) from (SELECT [Masterfile].[Store #], [Masterfile].[PC/LAN1 Start] FROM [Masterfile] LEFT JOIN [Inventory Tracking] ON [Masterfile].[Store #] =...

I can't seem to get a record count of this select to work: SELECT [Masterfile].[Store #], [Masterfile].[PC/LAN1 Start] FROM [Masterfile] LEFT JOIN [Inventory Tracking] ON [Masterfile].[Store #] = [Inventory Tracking].[Store #] WHERE [Masterfile].[PC/LAN1 Start] >= '4/29/2003' AND...

We currently have a VB app the uses Outlook to email out stuff every 30 minutes. We need to make this app into a NT Service which isn't too hard. But then how can we interact with Outlook to send emails? Right now it only works if your logged into the machine. Is there a way to pass Outlook info...

I can't seem to get this record selection to evaluate both things. It only seems to evalutae the top line and not use the or. ({Store Wiring.Finished} = &quot;False&quot; and {Store Wiring.Current Status} <> &quot;Green&quot;) or ({Store Wiring.Finished} = &quot;False&quot; and {Store...

I'm looking over the results but it looks to be good as follows: UPDATE [Punchlist] SET [Display] = 'True' WHERE [Punchlist].[Store #] IN (SELECT [Punchlist].[Store #] FROM [Punchlist] JOIN (SELECT [Store #], [Finished],'b' AS TableID FROM [POS_SCO Cutover2] UNION SELECT [Store #], [Finished]...

Yup helps a ton. Don't want you to write it for me just needed that idea. I can get it from here I think. Thanks again. I'll post the working code incase you need it someday or to help others. =)

Thanks. Think I can make that work. Prolly won't be till tomorrow but I'll let you know how it goes.