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 Chriss Miller 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: CRuser89
  • Order by date
  1. CRuser89

    upper/lowercase?

    Thanks Alex....I used to work with oracle and we always had to use lower/upper for user parameters. I thought it would be the same for sql server. Thanks!!!
  2. CRuser89

    upper/lowercase?

    Hello, I have the following select statement: select a.name, a.address, a.telephone, b.jobtitle from person a, job b where a.jobtitleid = b.jobtitleid and b.name = "jack" How can I change it so that it looks for all cases of the name (i.e jack, Jack, JACK, etc...) Can I do the following or...
  3. CRuser89

    Incorrect syntax near '-'

    Thank you all very much for the in-depth explanation. I learned several new things today...Thanks again...
  4. CRuser89

    Incorrect syntax near '-'

    Thanks Denis....I was told by my manager that we need to prefix our procs with sp_. Can you please tell me why it shouldn't be prefixed this way?
  5. CRuser89

    Incorrect syntax near '-'

    Hello Denis, Thanks for your reply. I am calling this procedure by using the command below: exec sp_GetPerson Smith Smith is the parameter input required (last name of person). When I use Le-Ann it will give me the error.
  6. CRuser89

    Incorrect syntax near '-'

    Hello, I am using SQL Server 2005. I have a stored procedure that requires a parameter at execution - employee name. When I type in any name like donald, mike, john then it works fine. But when I use name like Sarah-Lee with a hypen, it gives me the error even though I've declared the...
  7. CRuser89

    selecting across different database

    Hi everyone, I added the database name dot owner dot table and it worked. Thanks, Kathy
  8. CRuser89

    selecting across different database

    Hello, I am using SQL Server 2005 and have the following select statement inside a stored procedure. The stored procedure has a bunch of other selects that select from tables in the test1 database and the sp is being run against test1 database. The table in the select statement below is in...
  9. CRuser89

    prompt user to enter parameters

    Thanks jbenson....
  10. CRuser89

    prompt user to enter parameters

    Hello everyone, I am new to SQL Server. We're currently using SQL Server 2005. Please see example below: create procedure proc4 (@p1 char(15), @p2 char(20), @p3 int) as insert into Workers values (@p1, @p2, @p3) go Is there a way to write the code so that it prompts the user to enter in...
  11. CRuser89

    rows.count property not working

    Thank you adamroof and ca8msn. It turns out that there was something wrong w/the query. It works fine now....thanks guys..
  12. CRuser89

    rows.count property not working

    Hello ca8msn. Everything was working as expected until I added the if condition today. It still works but instead it redirects the user to the Default.aspx page regardless of correct or incorrect login. Is that what you were asking ca8msn? If not...sorry...
  13. CRuser89

    rows.count property not working

    Hello everyone, Please see the line in bold below. I am trying to redirect the user to the Default.aspx page if the query from the typed data set (Criteria) returns at least a row. However, I am putting in usernames and passwords that do not exist in the 'People' table and it still goes true...
  14. CRuser89

    cannot convert to string

    Thank you both very much. It worked!!!
  15. CRuser89

    cannot convert to string

    Tipgiver - .GetDataBy is a method that was created through the TableAdapter Query Configuration Wizard. I created a query to pull all records of the people table based on the Username and Password parameters provided. When I plug in actual fields like "abc", "password" (these are actual...
  16. CRuser89

    cannot convert to string

    Thank you tipgiver for your tips. I tried passing the texts of the textboxes but that still didn't work. I'm getting the error - "Object reference not set to an instance of an object". I am very new to .net and didn't understand how to try out your second tip. Thanks again, Kathy
  17. CRuser89

    cannot convert to string

    Hello everyone, I am using VS2005 (C#) and have the following code behind for my login page. When I try to compile it, I get the following error on the line in bold below. Seems like I need to convert "UserName" and "Password" to strings. Can someone please help me with this? Thanks...
  18. CRuser89

    typed data set

    Hello, I am trying to learn typed data sets in VS2005. I have the following code behind. I am not sure if I'm calling the data sets correctly or not. I would also like to add a piece of code after the bold text below to check if the results return >1 then to redirect the user to a page...
  19. CRuser89

    inherits problem

    Hello Prashant, Thank you for your reply. I actually figured it out. I changed "CodeBehind" to "CodeFile" on the first line and it worked. However, when I compile it now, I get an error on the line below: Error: NullReferenceException was unhandled by user code Object reference not set to...
  20. CRuser89

    inherits problem

    Hello everyone, I'm very new to asp.net so please be patient w/me. I have a login page called login.aspx that has the following line below. When I try to compile it, I get the error - Could not load type 'LoginPage.WebForm1'. The namespace LoginPage and class WebForm1 exists on the code...

Part and Inventory Search

Back
Top