Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: WayneGretzky
  • Order by date
  1. WayneGretzky

    Query not returning correct results

    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...
  2. WayneGretzky

    Query not returning correct results

    >>>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
  3. WayneGretzky

    Query not returning correct results

    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.
  4. WayneGretzky

    Query not returning correct results

    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...
  5. WayneGretzky

    SQL Authentification Settings not sticking for SQL Job

    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?
  6. WayneGretzky

    No SQL Server Agent

    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...
  7. WayneGretzky

    Reader returning null values

    disregard, it was a problem with my stored procedure.
  8. WayneGretzky

    Reader returning null values

    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...
  9. WayneGretzky

    Share out a Stored Procedure output parameter with other subs

    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
  10. WayneGretzky

    The connection was not closed. The connection's current state is open.

    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.
  11. WayneGretzky

    The connection was not closed. The connection's current state is open.

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

    Share out a Stored Procedure output parameter with other subs

    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)...
  13. WayneGretzky

    Share out a Stored Procedure output parameter with other subs

    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...
  14. WayneGretzky

    Share out a Stored Procedure output parameter with other subs

    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 =...
  15. WayneGretzky

    Date Problem, not pulling correct dates

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

    Date Problem, not pulling correct dates

    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...
  17. WayneGretzky

    Subquery returned more than 1 value. This is not permitted when the su

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

    Subquery returned more than 1 value. This is not permitted when the su

    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...
  19. WayneGretzky

    Cannot connect to Database in Server Management Studio

    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...
  20. WayneGretzky

    Problem with connecting to login in SQL Server 2005

    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;"/>...

Part and Inventory Search

Back
Top