Strange issue.
I have a sql statement that returns a set of rows for a datagrid (which works correctly).
I have the same criteria to get a count of rows in a stored procedure.
My problem is when I get the count from the stored procedure it always returns the number of records, but, the sql...
Thank in advance!
I have a query where I'm searching an inventory database. This database has items grouped by categories (headers). What I'm trying to do is search only the descriptions from the categories (no problem), but, what I need returned is the items also under the categories searched...
I've searched the last 3 nights (lucky me huh!) and I've tested and tested, but, can't get the results I need. Please HELP!!!
What I want to do is search a text field nvarchar(50) from left to right. So, if a user is searching for let's say Targets but only enteres tar this is the result I...
I'm working with a grid view that I would like to add a mouseover effect not for a tooltip but to show a picture on another place on the page. I started using a popupcontrolextender and got that to work, but, it only pops the panel near the mouse cursor, when I want to load a picture elsewhere...
Hi,
I have a asp.net form that I have a login form on. I have validator's on the 2 textboxes, I have added a div tag in the code with the "please wait box and image" that I want to display after the user clicks the button for logging in (I use the onclick event, that runs java, to display the...
I think my thinking is correct on this matter, but, let me run it by you experts.
I host multiple domains on my exchange 2000 server. My thinking is that I cannot have two of the same names on two differnt domains like: jack@xyz.com and jack@abc.com, unless the actual login (username for owa or...
I have found little info on this, so here's what I want to do; I want to setup a media server with all the audio/video connections on it. Then from another workstation I want to start and stop media (the media will be playing on the server not the workstation). I've read about remotly...
I'm using CR 7. and am trying to get totals per page, since there isnt a running total selection for reseting per page, I'm trying to use vars. Except that I'm not getting them to work right, so I need some help.
I created 4 formula fields, the first one I put on the report header with the...
I have a pretty straight forward query:
select * from MyTable where cancelled = 0
Not all the the data that matches the query is returned, it was fine and no changes have been made, it just stopped returning all the possible matches, any ideas?
If I use the query anylizer on the specific...
Ok, I have an ISA server that I've configured VPN access for (no problems) really like it. (now here's the ..but.. part) when I vpn in it's great, but I try to connect to the sql server, I can see from the log that the vpn connection is trying to connect to the ip address of the sql server, I...
I'm trying to search an address within a field. For example when I search '4500' I get results, but, if I search '4500 L' or '4500 Lamont' it comes back with no results. Here's my code:
SQL = "select * from customer where charindex('" & Trim(UCase(Sch)) & "', rtrim(upper(adr)) ) > 0 order by...
I've been trying to write a script that requires a page to use ssl, but, when I place the code at the top of each page (like the example microsoft has) when I try to navigate to the page it seems like it's stuck in a loop trying to redirect, then finally it will end up with a plain white screen...
Hi, I have an xp pro machine, and I am using the administrative local account, when I go to system, identification and try to join the computer to a domain, the domain option is grayed out. Any ideas on what is causing this, it once was on the domain and I put it to a workgroup (because the SIDs...
I'm using a aspx page to access an access 2003 database, it worked fine with a 97/2000 database, but, now I get an error "Cant find installable ISAM", I've searched around and cant find any help except short of trying to install access 2003 on the web server (which I really didnt want to do) the...
I have an NT 4 server as my PDC and it runs exchange 5.5 and DNS, I recently got hacked, the attacker got access to the registry and deleted keys that were obviously required, I found the system at the login prompt the next morning.
The system would startup and you could log in but DNS...
What is a good general rule to follow for servers, for example is it good practice to have the SQL Server and the Web Server on the same machine, or say, Domain Controller and Exchange Server, or is it Better to keep them all on seperate systems?
Domain Controller
Web Server
Exchange
SQl
ISA...
I'm trying to figure the best way to setup the ISA server, is my understanding correct, that is, that the ISA server sits with 2 nic's one connected to the router and the other connected to the switch that the lan and the other systems are on?
Also, I have 5 static IP address's that I've been...
What a great way to start a Monday...
I have an NT 4.0 server running exchange 5.5, and this morning it was at the login prompt. after login I got an error that a service could not be loaded. After some exploration I noticed that "Server" in control panel won't start, everytime I try to start...
Hi,
I was trying to install VPN on my windows 2000 server, I couldnt get it to work right and decided to remove it. Now the server won't connect to any other local servers on the network, It still can get out to the internet, but all local connectivity is lost. This all started when I was...
I have a T1 connection that connects to a router, the router has both a DMZ and virtual server configuration, at present the router is using the only static IP address, there is about 15 workstations all getting local DHCP address'. Our ISP has given us 5 static IP address which I would like to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.