ok, I got it -
in the cursor where it brings in those variables I told it to set the value to blank if it comes in as NULL and that worked:
[PHP]DECLARE Updated CURSOR FOR SELECT ID, ISNULL(Date,'') FROM Inserted[/PHP]
Being that this is of type smalldatetime, if it's blank it actually inserts "1900-1-1" into the table, which is fine for our purposes... but I guess that's the default in SQL 2005??
User Profile
Collapse
-
NULL <> @variable returns FALSE
This is very strange...
Using SQL Server 2005,
I've declared 2 variables, both of type smalldatetime and being populated using a CURSOR.
The first date is NULL and the second date has a valid value in it.
However, the following statement is returning a false when it should be true:
IF @firstdate <> @seconddate
and I am stumped as to why.
Any ideas??
Thanks! -
Thanks for the input!
That works, but only if not writing the output to excel.
I ended up just sticking with putting breaks in each of those cells...it must just be some issue with excel not recognizing/liking that formatting or something - I had a similar issue with ignoring cellpadding. I had to specify row height in pixels to get around that.
Not sure what else can be done about it.
Thanks anyways!Leave a comment:
-
-
Dreamweaver 8 - writing to excel
HI!
I am using Dreamweaver 8, creating a form that when run opens as excel table as follows:
<head>
<%
Response.Conten tType = "applicatio n/vnd.ms-excel"
%>
I have outer 1-celled container table set to width=100%,
Then inner table set to width=100% with table headers in top row.
Problem is the width is ignored and the headers are displayed without wrapping,...
No activity results to display
Show More
Leave a comment: