Recent content by WayneGretzky

the kind of output I expect to see is like this for example: 2006-01-05 16:47:22.000 error mmm 8668762739 2006-01-05 16:53:23.000 error mmm 8668762739 2006-01-05 17:15:26.000 error sss 8668762739 there is a unique id for each of those by the way...such as: 10000...

>>>To add, nowhere do you eliminate AMM and OK But I shouldn't have to, the sub select speficially looks for crc = 'error' and nothign else

The purpose of seeking results where there are 2 records with the same phone number that have crc = error is to notify our network guys of an error. They don't want to be notified if there is only one error record for a specific phone number.

This query still produces results that are wrong. It should never return any crc unless it = 'error' and it does. Second, it should only return results where there are more than 2 records with the same phone number for those records where the crc = 'error' select calldatetime, crc, projname...

In any SQL Server 2005 job I create on my server, if I specify SQL Authentfication to run that job, put the information in, then click OK to close, it never sticks. I open back up the job and it resorts back to the Windows Authentification Setting again. Is this a bug? Bad install? What?

I just did a reinstall of SQL Server 2005 after backing up a database. I restored the database. I noticed I had to drop one of my users who still existed in sysusers because I needed to recreate that user in the new fresh install of SQL Server 2005. Ok, so I did that. If I logon to my...

disregard, it was a problem with my stored procedure.

I'm trying to figure out why the Variable CustomerName is null. I need to verify if my syntax for all in this Sub is formed well: Sub SendEmail_ElBalazo() Dim mailObj As New MailMessage Conn.Open() Dim myvalue As Integer = 1 Dim cmd As SqlCommand = New...

latest code is here: www.photopizzaz.biz/allcode.txt remember, I can't pull out NewCateringOrderID = New SqlParameter("@NewCateringOrderID", SqlDbType.BigInt) from my InsertOrder() or it throws an error saying I haven't declared NewCateringOrderID

thanks, I actually had 2 opens for Conn prior to posting this and I was updating the wrong file so I didn't see the changes I made which actually fixed it.

I'm not sure why I am still getting this connection error www.photopizzaz.biz/allcode.txt

Here's my latest code from my code-behind page: Public Class catering_form Inherits System.Web.UI.Page some code... Dim NewCateringOrderID As SqlParameter ...some more code Public Sub InsertOrder() Conn.Open() cmd = New SqlCommand("Add_NewOrder", Conn)...

ok, but now I get this error: Exception Details: System.FormatException: Index (zero based) must be greater than or equal to zero and less than the size of the argument list. Source Error: Line 292: Dim cmd As SqlCommand = New SqlCommand("sp_Get_OrderDetails", Conn) Line 293...

how can I make the value for the output parameter below available to all my subs in my code behind class? This is in one of my Subs but I want to share it out: Dim NewCateringOrderID As New SqlParameter("@NewCateringOrderID", SqlDbType.BigInt) NewCateringOrderID.Direction =...

I think I found it, I had 2 extra ) in an OR statement in my query. Thanks though for replying.