Search results for query: *

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

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

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

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

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

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

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

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

Hello everyone, I am completely new to asp.net. I was trying to come up with a login page (web) using VS2005. I got some sample code online. I pretty much followed the walkthrough step by step but am getting the error: {"Object reference not set to an instance of an object."} for the line...

Hello, I am just starting to learn .net. Does anyone have a sample login page (the code behind) that they can send me? I need to create one but am struggling with the code behind in C#. I have the basic design set up with the username/password/validation, etc. I have a db table called...

Hello everyone, I am new to VBScript. I need some help w/wildcarding. I have the following piece of code: ******************************************************** sEmpTitle = formatForSQL( Request.Form("EmpTitle") ) If Not sManagerName = "" Then AppendAndClause m_sWhereClause =...

Hello, I am very new to javascript and vb. There is a piece of code that I need to change. It's basically a menu for an application called menu.asp. I need to check the condition so that when a certain user logs in, for example user1, it will display what i have below. But if it's user2 or...

Hello everyone, I'm using CR8.5 and when I try to view a report via a crystal report view over the web(IE 6.0), the report would sometimes come up and other times I would just get blank gray screen. Can someone please help? Thanks, Kathy

Hello, I need to create a role-based ER diagram for a new applicaiton we're developing. Basically the diagram should have roles, privileges, permissions, etc of what a user can and cannot see in the application. I am using SQL Server 2000. Can someone please point me to where I can see a...

Hello everyone, This is my first time calling a stored procedure in CR 8.5. I usually add the tables and select the columns from there. I have this stored procedure that references 2 different databases. I was able to pull up the stored procedure via an ODBC connection but it errored out...

Hello, I am new to .net and C#. I am following a walkthrough and got to the step where i am to create a membership user through the ASP.net Web Site Administration Tool. I click on the "security" tab and get the following error: There is a problem with your selected data store. This can be...

Hello, I have the following sql script: insert into table1 values ('1', 'testdata', '999') insert into table1 values ('2', 'testdata2', '998') I get the error below because the first column is an identity column. I know that I can leave the first column blank and it will insert it but is...

Hello, In SQL Server, can we "create or replace" a stored procedure like in Oracle? Or do we have to drop the existing sp first and then recreate it? Thanks in advance, Tracy

Hello, I am very new to sql server. I am getting some errors in an application that is pointing me to a constraint in sql server. Can you please tell me how to see or check the column/table constrainst in sql server? When I right click on a table and select properties, I only see Key, ID...

Hello, I'm using CR 8.5, CE 8 which comes w/5 licenses. When there are more than 5 users logging in and viewing the report via our web application, we get the following error: Crystal Report Viewing Log On The Web Component Server could not log you on to the APS. Is there anyway for me to...