Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Showing results 1 to 25 of 30
Search took 0.01 seconds.
Search: Posts Made By: GailCG
Forum: Javascript How-To October 14th, 2009, 03:21 PM
Replies: 0
Views: 1,529
Posted By GailCG
Question Format input as Currency and Multiply

I have a javascript that multiplies two intergers, without the currency formatting including the commas. The users would now like to have commas with the data entry and result; but the script...
Forum: SQL Server 2005 June 29th, 2009, 10:45 AM
Replies: 0
Views: 3,339
Posted By GailCG
login failed for user Domain\User ID

My users are trying to connect to SQL Server 2005 from an Intranet application. All users are on Active Directory, if that makes a difference. Within SQL 2005 three Application Roles have been...
Forum: Classic ASP Basics April 1st, 2009, 12:52 PM
Replies: 2
Views: 1,941
Posted By GailCG
How to Change ASP.NET into Classic ASP?

I need to convert a asp.net page back into classic ASP and I am running into problems in getting this accomplished. It is blowing up all over the place.
Help needed now!
Thank you.

I have:
...
Forum: ASP.NET 2.0 Basics November 25th, 2008, 12:19 PM
Replies: 5
Views: 1,287
Posted By GailCG
I found the solution. ALTER PROCEDURE...

I found the solution.
ALTER PROCEDURE dbo.usp_InsertEmployeesTodaysLogin
(
@UserID char(8),
@Today datetime,
@SSNLogon char(15)
)
as
BEGIN
IF NOT EXISTS(select UserID, Today, SSNLogon FROM...
Forum: ASP.NET 2.0 Basics November 25th, 2008, 11:29 AM
Replies: 0
Views: 753
Posted By GailCG
Authentication and Authorization Using AD and SQL

I have an application that is being developed for our Intranet.
Which will require authentication of users that are members in an Active Directory group; TIRES Users, TIRES Super, TIRES Admin.
...
Forum: SQL Server 2005 November 17th, 2008, 02:13 PM
Replies: 1
Views: 1,056
Posted By GailCG
Capturing Output Parameter Value

When I execute my stored procedure, I get the following error message:
Procedure or function 'usp_InsertEmployeesTodaysLogin' expects parameter '@Cnt', which was not supplied.
No rows affected.
(0...
Forum: ASP.NET 2.0 Basics November 17th, 2008, 11:30 AM
Replies: 5
Views: 1,287
Posted By GailCG
I looked at the code and the problem is the code...

I looked at the code and the problem is the code is excuting each time the page is loaded. Howeverm, I need the Insert block of code to only excute once for each person that logs onto the page.
...
Forum: ASP.NET 2.0 Basics November 14th, 2008, 04:31 PM
Replies: 5
Views: 1,287
Posted By GailCG
Yes, I have: If Not Page.IsPostBack Then ...

Yes, I have:
If Not Page.IsPostBack Then
......
Forum: ASP.NET 2.0 Basics November 14th, 2008, 01:37 PM
Replies: 5
Views: 1,287
Posted By GailCG
How Not To Insert Duplicate Records

My stored procedure is inserting duplicate records, what I am working on is converting from classic ASP to ASP.NET.
The insertion occurs within the PageLoad Event Handler as the user logs onto the...
Forum: ASP.NET 2.0 Basics April 1st, 2008, 11:04 AM
Replies: 14
Views: 2,180
Posted By GailCG
HI, Getting closer to the end and getting...

HI,

Getting closer to the end and getting panicky, as I need to present in 1 1/2 hour.
The error was an extra "(" after the WHERE and before "ATTDivision").

Now that has been corrected, it...
Forum: ASP.NET 2.0 Basics April 1st, 2008, 10:47 AM
Replies: 14
Views: 2,180
Posted By GailCG
Great!. You understand completely, now I will...

Great!.
You understand completely, now I will test the first sql statement and hopefully 0 count will come back, at which time I again, hopefully, will be able to correctly delete the record.
Forum: ASP.NET 2.0 Basics April 1st, 2008, 10:01 AM
Replies: 14
Views: 2,180
Posted By GailCG
I removed the "Order By" from the SQL statement. ...

I removed the "Order By" from the SQL statement.
The error relates to any record value that is being passed to the first SQL statement. i.e. "Incorrect syntax near Division Code'. The Division...
Forum: ASP.NET 2.0 Basics April 1st, 2008, 09:42 AM
Replies: 14
Views: 2,180
Posted By GailCG
I copied the code, ran the page and received the...

I copied the code, ran the page and received the following error;
*ORDER BY items must appear in the select list if SELECT DISTINCT is specified.

This is the code that is being used:
If...
Forum: ASP.NET 2.0 Basics April 1st, 2008, 08:15 AM
Replies: 14
Views: 2,180
Posted By GailCG
This is my code in its entirety: If...

This is my code in its entirety:
If e.CommandName = "Delete" Then
Dim DivisionCode2 As Label = CType(dvNewDivision.FindControl("DivisionCode"), Label)
Dim Description2 As Label =...
Forum: ASP.NET 2.0 Basics April 1st, 2008, 07:58 AM
Replies: 14
Views: 2,180
Posted By GailCG
I used "Return" as you have it in your example,...

I used "Return" as you have it in your example, but it did not stop the execution of the code.
Forum: ASP.NET 2.0 Basics April 1st, 2008, 07:30 AM
Replies: 14
Views: 2,180
Posted By GailCG
Can you give me an example of the correct Return...

Can you give me an example of the correct Return statement to use?

Thank you.
Forum: ASP.NET 2.0 Basics March 31st, 2008, 03:37 PM
Replies: 14
Views: 2,180
Posted By GailCG
Opening a New Window

HI,
I need to inform users that they can't delete a record using a New Window or Message Box; which isn't working very well for me, yet.
I have tried two processes, a) redirect to the same page...
Forum: ASP.NET 2.0 Basics January 4th, 2008, 04:30 PM
Replies: 1
Views: 2,354
Posted By GailCG
Convert String To Time

I need to substract break and lunch times based on the following
Sql statement

CREATE VIEW dbo.vwu_ExcelReport
AS
select, logout, login, AMBreakOut, AMBreakIn, LunchOut, LunchIn, PMBreakOut,...
Forum: ASP.NET 2.0 Basics February 22nd, 2007, 03:08 PM
Replies: 5
Views: 3,412
Posted By GailCG
Thank You. My error was that I made the...

Thank You.

My error was that I made the change in a stored procedure that I was not calling on the page.
Things are working now.

I appreciated you assistance.
Forum: ASP.NET 2.0 Basics February 22nd, 2007, 02:02 PM
Replies: 5
Views: 3,412
Posted By GailCG
I made the change in the sql statement and I get...

I made the change in the sql statement and I get the same error regarding "conversion from DBNULL to String..."

Public Sub New(ByVal EFName, ByVal ETitle)

m_EmpFName = EFName
m_Title = ETitle...
Forum: ASP.NET 2.0 Basics February 22nd, 2007, 01:46 PM
Replies: 5
Views: 3,412
Posted By GailCG
Conversion from type 'DBNull' to type 'String' is

My Business Logic Layer generates an error due to NULL values in the Title's column.

Public Property Title() As String
Get
Return m_Title
End Get
Set(ByVal value As String)
If (value Is...
Forum: ASP.NET 2.0 Basics November 20th, 2006, 10:23 AM
Replies: 1
Views: 5,095
Posted By GailCG
Convert DBNull to String

In SQL is have a column with data and Null values. The Null values need to be converted to string. Thus far nothing I have tried works.
The results are sent to a datagrid.
My code snipet:...
Forum: Classic ASP Professional March 3rd, 2006, 03:39 PM
Replies: 0
Views: 1,731
Posted By GailCG
One textbox, Two Parameters, with Stored Procedure

I have a stored procedure that need two parameters, last name and first name. The first web page has a text box which the user can enter either the first name or last name; then the second page...
Forum: Classic ASP Professional January 12th, 2006, 12:51 PM
Replies: 1
Views: 1,428
Posted By GailCG
Stored Procedure That Updates Table

I need to create a store procedure that will update a table. An Classic ASP page is calling and writing the info.
I am not sure how to begin. In Wrox' Professional Active Server Pages 3.0 pages...
Forum: ASP Pro Code Clinic May 14th, 2004, 02:00 PM
Replies: 2
Views: 1,557
Posted By GailCG
Checking/Unchecking while Disabling/Enabling Check

I am updating a page which has a table with four checkboxes that receives data from a db. The results are sent to a database, but

only two of the four checkbox values are stored into two fields...
Showing results 1 to 25 of 30

 




Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.