Search results for query: *

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.

the portion of my query was working fine, nothing has changed except that I went from 30 to 20 for the dateadd function. Now when my query runs, I get CallDateTime that is not between the current time and 20 minutes prior, I get CallDateTime that is even from a month ago which is not right...

Thanks, worked great. Can you possibly explain to me why I had to do it that way instead of reference the single fieldname?

Not sure why I am not able to check whether > 1 for 'error': SELECT @RESULTS = ISNULL(@RESULTS + '', '') + CHAR(13) + 'Phone Number: ' + LEFT(PhoneNum, 3) + '-' + SUBSTRING(PhoneNum, 4, 3) + '-' + SUBSTRING(PhoneNum, 7, 4) + ' Call Date: ' + convert(varchar(20),CallDateTime,101) + ' HistoryID...

I currently can't connecto to my database in SQL Server 2005 (enterprise) but as soon as I try to use any functions, I get cryptic errors found below. I am about to pull my hair out. Everything was working fine for around 4 days and now everything just blows up. I've tried using both sql...

I keep getting this error below no matter how many times I tweak my SQL Server 2005 login. I am wondering if just VS can't handle it in debug mode or what the real problem is here: <appSettings> <add key="Econn" value="Server=****;uid=testit;pwd=***;database=integration_services_en;"/>...