rheal.dugas@...

TechRepublic Resources

• sort by:
• Relevance
• Date
• Popularity

Using net Send

I have create a ASP page where you select the date and time and some customer info LogID and phone and the IP address of the person that entered the data. Now this info is entered into the Database. The date and time will be in the future. I...

Tags: Storage, Databases, rheal.dugas@..., database

Discussion threads 2007-06-27

ASP Page with a Form to be filled by Blackberry user

I have created a web form where a useer with a Blackberry has to fill in.One of the fields they have to enter a numeric value.How can I make it so that when they enter the number into that form field it will enter in a number value without them...

Tags: Microsoft ASP, RIM BlackBerry, rheal.dugas@...

Discussion threads 2007-03-05

Copy items from one table to another

I have 2 tables. Main Serial Number Solution_IDThey both have the following 2 fieldsLog_IDSoln_IDBoth tables contain the same information as far as LOG_ID goes.I want to that the information in the Solution ID table Field Soln_ID and replace the number that is in the Main Serial Number table Field Soln_IDSo...

Tags: rheal.dugas@..., Log_ID Soln_ID, Main Serial Number

Discussion threads 2007-01-11

BlackBerry Pin Number

I have a ASP page that BlackBerry users access.How can I display the BlackBerry Pin number of the person accesing that page?I know it has something to do with "getDeviceID"But I dont know how to use this in a ASP Page.Thank You

Tags: Scripting languages, Handhelds, RIM BlackBerry, ASP Page

Q&A 2006-07-24

Why does this Trigger go off?

I have created a SQL trigger that should only work if both fields are updated. Can someone tell me why when ony one field is uptated that this trigger goes off. Thank YouCREATE TRIGGER send_update_requeston dbo.ONSA_NSSFOR UPDATEAS--- Send a Update request to the owning ONSA/AGENTDeclare @ID NVARCHAR (4000)Declare @subject...

Tags: UPDATE, SELECT

Q&A 2006-06-28

Trouble creating a SQL SCRIPT

Trouble creating a SQL SCRIPT I am in desperate need of some help creating a way to send out a email if one of my dispatches is not picked up.I have created a database that dispatches calls to onsite analyst. When a request is entered it automaticly sends a email...

Tags: e-mail, SQL Script, Trouble, rheal.dugas@..., programming, interval, SQL, ACEPTEDDATE, DateCreated

Q&A 2006-05-16

Trouble creating a SQL SCRIPT

I am in desperate need of some help creating a way to send out a email if one of my dispatches is not picked up.I have created a database that dispatches calls to onsite analyst. When a request is entered it automaticly sends a email out to the analyst for...

Tags: e-mail, rheal.dugas@..., programming, SQL, ACEPTEDDATE, DateCreated, SENT field.I

Q&A 2006-05-15

Need a pop up window or application

I am in need of a application window or html window that when your computer is booted this window opens up in the top right corner of the screen. This window will contain 3 or 4 fields. One field will be a text input and the other 3 just check...

Tags: database, programming, rheal.dugas@..., window

Q&A 2006-01-24

Subtract 2 Time fields Formula

I have 3 fileds in my databaseMsSql.ArriveDepartTotalI would like to have the total field contain the Value of 'Depart-Arrive'11:40:44 AM - 1:49:44 PM = 2.9Could some show me how to create a formula to to this with in the table itself.Not sure if you can do this in mysql, but...

Tags: Cast, DATEDIFF, DateTime, programming, rheal.dugas@..., SELECT CAST

Q&A 2006-01-20

XML RPC Call

I need some help making a RPC call to a database grabing a value from the returned results and making another call with that value and take 3 or 4 values from that call and insert that into a table in my database.At the moment I have figured out how...

Tags: document.GetElementByID, methodName, XML-RPC Call, xml, sql, rpc, Value at Risk, rheal.dugas@..., software

Discussion threads 2006-01-11

Filling in a Form w/data from a XML

Filling in a Form w/data from a XML file I have a ASP page that contains a form which I want to populate with values from a XML file which I get from a MainFrame server.I have the code to get the xml file and place it into a Variable...

Tags: programming, rheal.dugas@..., XML, XML file

Q&A 2005-06-16

Filling in a Form w/data from a XML file

I have a ASP page that contains a form which I want to populate with values from a XML file which I get from a MainFrame server.I have the code to get the xml file and place it into a Variable that I named "GetStuff"My problem is extracting the

Tags: programming, rheal.dugas@..., XML, XML file

Discussion threads 2005-06-15

Create a Task in MSSql task Manager

I want to create a task in MSSql DTS Manage that will Empty/clear a temp table, check another table and look at one of the fields, if that field is NULL, put a entry into the temp table for each of the entries that contains a NULL and send a...

Tags: E-mail, NULL

Q&A 2005-05-30

Additional Resources

Sarbanes-Oxley Case Study: "3 Clicks to Compliance"

John Dugas, Audit Manager for Penn Virginia has the mission to manage Penn Virginia Corporation's compliance project with respect to the Sarbanes-Oxley legislation. Mr. Dugas reviewed several applications as well as provider companies that might fit his company's needs. After careful review, Mr. Dugas chose the Sarbanes-Oxley Compliance Playbook from...

Tags: Audit, Sarbanes-Oxley Act, Compliance, Mr., Sarbanes-Oxley, Regulatory Compliance, Regulations, Government, Financial Accounting, Finance, Human Resources, Policies And Procedures

Case studies