Search results for query: *

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...

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.

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...

Here's what I need to do. Need to look in TableA and find out if a column is Yes or No. Then based on this look at TableB = Yes or TableC = No. Then in that table look at a date field. If it's null or not. Then go back to TableA and update fields to True or False bases on the results. I know I...

I have a datetime with user name string and I need to parse out the datetime. Sample: 2/7/2003 8:48:04 AM by BBROWN I deally I just want the date (2/7/2003) out of that string. My patience has been exusted with crystal for the day. Any help would be much appreciated. Thanks, David

(SELECT [Store #], [Datatec Posts BOM] FROM [Masterfile] WHERE [Datatec Posts BOM] >= '4/29/2003') (SELECT [Masterfile].[Store #], [Masterfile].[Datatec Posts BOM], [Inventory Tracking].[Store #], [Inventory Tracking].[BOM Build Date], [Inventory Tracking].[DatatecSupp] FROM [Masterfile]...

I'm running a dynamic select top x command where x can be more records then are in the recordset. x can be 600 and when you execute the select top 600 ..... it only returns say 200 records since that's all there is. Now I run the same select and only want 50 records. How can I store the actual...

How can I populate a field in TableA with a field in TableB in the formula for a field? Like in TableA I have a field called &quot;Test&quot; and in TableB I have a field called &quot;ID&quot;. I want &quot;Test&quot; in TableA to always be whatever &quot;ID&quot; in TableB is. They are the same...

I'm trying to get 2 selects to do simple math operations like add and subtract like: SELECT Sum([DatatecConcentrators]) FROM [Inventory Tracking] - SELECT Sum([Quantity]) FROM [Products] WHERE [Item Name] = 'Concentrators' Where the top select return say 100 and the bottom returns 75 then it...

Do anyone know if you can use asp or anything via the web to send a message to an instant message program like AOL AIM or ICQ? Would like to send events to instant message instead of emails. Thanks David

I have the following I'm trying to get 7 distinct counts from 7 different tables into this temporary table in a single record. CREATE PROCEDURE [dbo].[Test] AS CREATE TABLE #Temp ( UPS int, SW int, PCLAN1 int, PCLAN2 int, POS int, SCO1 int, SCO2 int ) insert into [#Temp] ([UPS]) select...

I have a report in which is based on a date range. If this date range does *not* contain today's date it uses the history table. If it contains today's date it then needs to combine the history table and the active table into 1 recordset to display them together. Both tables are identical in...

I have a report in which is based on a date range. If this date range does *not* contain today's date it uses the history table. If it contains today's date it then needs to combine the history table and the active table into 1 recordset to display them together. Both tables are identical in...

I have date in the following format I can't seem to change it to a useable format for my report. 1/1/2003 is how the date is now What I need to do it figure out if the day is single digit then if it is add a 0 so it displayes like: 1/01/2003 Thanks ahead of time for the help. David

We call a report via http://www/reports/report.rpt and it runs after yuo enter your IIS logon info. Prolblem is sometimes it stops working and goes to the crystal enterprise login page and says some error about web service not validating the user. After that the report never works again unless...

I'm looking to figure out a way to update a SQL record with existing data in a datetime field with null. When I blank the field I get 1/1/1900 not null. I'm using ADO to do the manipulation of the data. Any help could be great. David