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.

...does the same thing: select h.calldatetime, h.crc, h.projname, h.phonenum from dbo.history h WHERE ProjName IN ('sss' , 'mmm') AND (SELECT Count(*) FROM history WHERE CRC = 'ERROR' and phonenum = h.phonenum HAVING Count(*) > 2) > 2 AND (CallDateTime between dateadd(mi, -130, GetDate()) and...

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?

...where CRC = 'error') > 1)) OR ((CRC = 'NOCPA') OR (CRC NOT IN ('AMM' , 'OK'))) AND CallDateTime between dateadd(mi, -20, GetDate()) and Getdate() /*checks for any records within the last 30 minutes of the current server's time*/ AND PhoneNum LIKE...

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 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;"/> </appSettings> ERROR: Cannot open database "integration_services_en" requested by the...