User Profile

Collapse

Profile Sidebar

Collapse
tabbycat
tabbycat
Last Activity: May 3 '07, 06:58 PM
Joined: Nov 27 '06
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts

  • tabbycat
    replied to NULL <> @variable returns FALSE
    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??
    See more | Go to post

    Leave a comment:


  • tabbycat
    started a topic NULL <> @variable returns FALSE

    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!
    See more | Go to post

  • tabbycat
    replied to Dreamweaver 8 - writing to excel
    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!
    See more | Go to post

    Leave a comment:


  • tabbycat
    replied to Dreamweaver 8 - writing to excel
    MY BAD - it's DREAMWEAVER MX 2004
    See more | Go to post

    Leave a comment:


  • tabbycat
    started a topic Dreamweaver 8 - writing to excel

    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,...
    See more | Go to post
No activity results to display
Show More
Working...