Hi Everyone,
Our development web server is on windows 2000 and the test is on windows 2003.
We have created some web files which are stored in inetpub/wwwroot directory which seems to work perfectly fine in development but doesn't work in windows 2003. The QA team believes that it is because of windows web services being different but I am not sure about that. Can anyone help please.
Thanks a lot,
...
sreemati
Last Activity: Jul 1 '08, 02:19 PM
Joined: Jun 11 '07
Location: Dundee, Scotland (From Chennai, India)
-
How to change focus?
Hi
One of the web form has 3 dates fields: Date of form entry, date of diagnosis and date of death.
Date of form entry has future date validation done which I thought of extending to the other two date fields.
Code being used already:
...Code:function checkFutureDate(day, month, year, formName) { if (year > <%=zYear%>) { alert("Year -
Hi,
I am sure you will find MSDN online useful. I am adding a link where it explains with example. I hope this link helps:
http://www.mssqlcity.c om/Articles/General/using_constrain ts.htm
We will need to know what syntax you have created to be able to see where you are going wrong. Hence, your best bet is to add you syntax here.
Hope you figure it out soon.
Cheers
Sree -
Hi all,
The issue was with data, it was TEXT NULL and not a actual NULL as such and hence it was not getting eliminated through IS NULL or IS NOT NULL. Changed the data and its works beautifully.
Cheers,
Sree...Leave a comment:
-
Hi,
I do not think Trigger is the right thing to use for this but if you can post you SQL script for CHECK Constraint may be some one can help by seeing where you have gone wrong.
Cheers,
Sree...Leave a comment:
-
Are you using a store procedure to add new rows to the table? If yes than you can use a simple if statement to INSERT row to a table only if values are within the range.
Hope this helps,
Sree...Leave a comment:
-
Hi Chriskaza81,
Your question is not very clear. Do you wish to know some links where you can find useful resources to learn SQL server programming? SQL server data administration? Or Database Design.
I believe you need to read the forum guidelines and be very specific about your queries so that people can help you.
Cheers
Sree...Leave a comment:
-
How to Eliminate NULL values from the SQL queries
ssue:
------
I am working on a health care system and currently facing problem with NULL values being introduced as part of my SQL query.
What is the query trying to do?
The query is trying to retrieve ids from summary table for a practice where the patient are dead and find out if there are same patients in other systems like clinics or hospitals where this patient might still be showing as alive. This is basically... -
Thanks a lot for you help. Much appreciate.
Sree...Leave a comment:
-
Mutli dimensional Array in ASP
Hi Everyone,
I have a store procedure returning 7 rows for 3 columns, basically I am retrieving:
Descriptor Lower Range Upper Range
D1 1 10
D2 2 11
D3 3 12
D4 4 13
D5 5 14
D6 6 ... -
MSXML2.DOMDocument.4.0
Hi Everyone,
I would be glad if someone can elaborate on what is MSXML2.DOMDocum ent.4.0?? What exactly it does?
Thanks and regards,
Sree -
Hi
I did not mean the Number 1 by value1, I just meant it in reference to a field value1. Yes, I know that I am trying to re-create the error and get the error message, hopefully I get lucky soon and than I will post it.
Thanks,
Sree...Leave a comment:
-
Numeric to real type
Hi Everyone,
I hope this is not a silly one. Well, I have two tables - table 1 destination, table 2 source. Data is being imported from table 1 to table 2. For ages this has been working fine but now we get an error which just says can not insert value 1 (.i.e. user defined error message from error handling). I have been trying to run this whole thing bit by bit and detect the actual error but for some reason it doesn't show any error... -
Hi Debasis,
Your code worked, I mean the DROP Constraint Constraintname, thought its still giving me the error message, when I actually go back and check the table, the constraint is gone.
I more of Idiosyncrasies of SQL Server 2000, hail MS ;)
Anyways, thanks a lot, it works even though it gives error message though I will glad to know why it acts like this.
Cheers
SreeLeave a comment:
-
Hi debasisdas,
Thanks for your quick response but thats what I have tried in code 2) I have listed in my original post. I thought you meant me to try:
I got the following error message: Server: Msg 3728, Level 16, State 1, Line 1Code:ALTER TABLE tablename DROP Constraint [constraintname]
'DF_Population_ History_PPATIEN TS' is not a constraint.
Server: Msg 3727, Level 16, State 1, Line 1...Leave a comment:
-
Drop Default Constraints
Hi
I am working on SQL SERVER 200 and I am trying to drop the default constraints set in few tables. I tired to follow the instructions given in MSDN for dropping a default:
1) Unbind the code
When I try to run it, it gives me following this error message:Code:Exec sp_unbindefault 'tablename.columname'
Server: Msg 15049, Level 11, State 1, Procedure sp_unbindefault , Line 98
... -
Type REAL to return to a store procedure from an ASP array
Hi Everyone,
I had an ASP page which takes all the column values in array and then passes it to store procedure. Now one of the variable in the store procedure needs to be changed from int to real but the array doesn't seems to be able to return a real back to variable in the store procedure, it rounds it off as integer.
Can any one clarify why ASP array doesn't seem to be taking an real?
Thanks in advance,... -
Transaction Query - Not rolling back on step 1
Hi Everyone,
In brief, I am trying to get the whole block of code done in one go or not to do at all.
Here is a piece of code I am trying:
[sql]
BEGIN TRANSACTION
INSERT INTO authors (au_id, au_lname, au_fname, phone, contract)
VALUES ('172-32-1176', 'Mickey', 'Mouse', '222-33-4444', 1)
IF @@ERROR <>0
BEGIN
ROLLBACK TRAN
PRINT... -
MS-SQL store procedure to standard diagrams
Hi Everyone,
I would like to know if there is any free ware that coverts MS-SQL Server store procedures to standards visual diagrams, if not which would be the best language to make an editor interface where if I write a store procedure, it coverts it into diagrams.
I am using Visio to make it manually right now but I think would be really grand if I can use/ make one which can do all this, instead of having to make... -
Thanks that was helpful.
Sree...Leave a comment:
No activity results to display
Leave a comment: